ikan Uploader :
Directory : /var/www/html/shardahospital_old.org/application/controllers/
Upload File : |
| Current File : /var/www/html/shardahospital_old.org/application/controllers/MeetOurDoctors.php |
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
error_reporting(0);
class MeetOurDoctors extends CI_Controller {
function __construct() {
parent::__construct();
$this->load->model('doctor_model', 'doctor');
$this->load->model('department_model', 'department');
}
public function index($id=0)
{
if(isset($_GET['Search']) && isset($_GET['department'])){
$this->find_a_doctor1($_GET);
}
else if(isset($_GET['department'])||isset($_GET['doctor_name']) || isset($_GET['designation']) || isset($_GET['gender']) ){
$this->find_a_doctor($_GET);
}
else if(!$id){
$this->view_doctors();
}
else{
$this->view_doctor($id);
}
}
public function view_doctors(){
$data['doctors'] = $this->doctor->get_doctors('',array(),'','','','','A');
/*foreach($data['doctors'] as $doctor){
echo '<script>console.log("'.$doctor['DoctorName'].' '.$doctor['DoctorProfilePic'].'")</script>';
}*/
$seoArray = getdynamicseo($this->uri->segment(1));
$data['page_title'] = $seoArray->SEOTitle!='' ? $seoArray->SEOTitle : 'Meet Our Doctors|Sharda Hospital';
$data['page_description'] = $seoArray->SEODescription!='' ? $seoArray->SEODescription : 'Meet Our Doctors|Sharda Hospital';
$data['page_keyword'] = $seoArray->SEOKeywords!='' ? $seoArray->SEOKeywords : 'Meet Our Doctors|Sharda Hospital';
//$data['page_title']='Meet Our Doctors|Sharda Hospital';
//To be used in header forms
$data['departments_list']=$this->department->get_department_list( 'DepartmentType ASC', 'A');
$data['coes'] = $this->department->get_departments_summary('',array('COE'));
$this->load->view('meet_our_doctors',$data);
}
public function view_doctor($id){
$data = array();
$doctor_id = $id;
if(is_numeric($id)){
$data['doctor'] = $this->doctor->get_doctor_details($id);
}
else{
$doctor_id = $this->doctor->get_doctor_id($id)['DoctorID'];
if($doctor_id){
$data['doctor'] = $this->doctor->get_doctor_details($doctor_id);
/*echo '<script>console.log("COE ID: '.$doctor_id.'")</script>';*/
}
}
if(!isset($data['doctor'])){
$this->load->view('error_404');
exit;
}
$departments = $this->doctor->get_doctor_departments_id($doctor_id)['DoctorDepartment'];
$data['related_doctors'] = $this->doctor->get_doctors('',array(),'',$departments,'','','A',array($doctor_id));
$seoArray = getdynamicseo($this->uri->segment(2));
$data['page_title'] = $seoArray->SEOTitle!='' ? $seoArray->SEOTitle : $data['doctor']['DoctorName'].'|Sharda Hospital';
$data['page_description'] = $seoArray->SEODescription!='' ? $seoArray->SEODescription : $data['doctor']['DoctorName'].'|Sharda Hospital';
$data['page_keyword'] = $seoArray->SEOKeywords!='' ? $seoArray->SEOKeywords : $data['doctor']['DoctorName'].'|Sharda Hospital';
// $data['page_title'] = $data['doctor']['DoctorName'].'|Sharda Hospital';
$data['OPD_schedule'] = $this->doctor->get_OPD_schedule($doctor_id);
$ratings = $this->doctor->review_show($doctor_id);
$data['ratinnew'] = $ratings[0]['averageRating'];
if(!empty($data['ratinnew'])){
$data['ratinnew'] = $ratings[0]['averageRating'];
} else {
$data['ratinnew'] = 4.5;
}
//To be used in header forms
$data['departments_list']=$this->department->get_department_list( 'DepartmentType ASC', 'A');
$data['coes'] = $this->department->get_departments_summary('',array('COE'));
$data['js'] = '<!--rateyo--><script src="'.base_url().'assets/js/jquery.rateyo.js"></script><!--rateyo-->';
$data['js'] .= '<!--star-rating-js-->
<script type="text/javascript" src="<?php echo base_url();?>assets/js/jquery.rateyo.js"></script>
<script type="text/javascript">
$(function () {
$("#rateYo").rateYo({
rating : '.$data['ratinnew'].',
spacing : "5px",
multiColor: {
"startColor": "#f47436", //RED
"endColor" : "#f47436" //GREEN
}
});
});
</script>
<!--star-rating-js-->';
$this->load->view('doctor_profile',$data,$OPD_schedule);
}
public function find_a_doctor($post){
$data = array();
$department_id = '';
$doctor_name = '';
$designation_id ='';
$gender = '';
if($post){
/*echo '<script>console.log("post:find a doctor")</script>';*/
// if((!empty($post['department'])) && (empty($post['doctor'])) && (empty($post['gender']))){
// $id = $post['department'];
// $coe_id = $id;
// if(is_numeric($id)){
// $data['coe'] = $this->department->get_department($id);
// }
// else{
// $data['coe'] = $this->department->get_department_by_slug($id);
// $coe_id = $this->department->get_department_id($id)['DepartmentID'];
// /*echo '<script>console.log("COE ID: '.$coe_id.'")</script>';*/
// }
// $sub_departments = $this->department->get_sub_departments($coe_id);
// $data['doctors'] = $this->doctor->get_doctors_by_department('',$sub_departments,'',array(),'','','A');
// // print_r($data['doctors']);
// }
// else{
if((!empty($post['department']))){
$department_id = $post['department'];
$conditon .= "SH_Departments.DepartmentID = '".$department_id."' and ";
}
if((!empty($post['designation']))){
$designation_id = $post['designation'];
$conditon .= "SH_DoctorProfile.DoctorDesignation = '".$designation_id."' and ";
}
if(!empty($post['gender'])) {
$gender = $post['gender'];
$conditon .= "SH_DoctorProfile.DoctorGender = '$gender' and ";
}
if((isset($post['doctor']))&&($post['doctor']!='')){
$doctor_name = $post['doctor'];
$conditon .= "SH_DoctorProfile.DoctorName LIKE '%$doctor_name%' and ";
}
$data['doctors'] = $this->db->query('Select SH_DoctorProfile.DoctorID,SH_DoctorProfile.DoctorTitle,
SH_DoctorProfile.DoctorName,SH_DoctorProfile.DoctorDesignation,SH_DoctorProfile.DoctorProfilePic,SH_DoctorProfile.DoctorPageURL,
SH_Designations.DesignationID,SH_Designations.DesignationTitle,SH_Designations.DesignationRank,SH_Designations.DesignationPriority,
SH_Departments.DepartmentID,SH_Departments.DepartmentName,SH_Departments.DepartmentType
from SH_DoctorProfile left join
SH_Designations on SH_DoctorProfile.DoctorDesignation =
SH_Designations.DesignationID
left join SH_Departments on SH_DoctorProfile.DoctorDepartment = SH_Departments.DepartmentID
where '.$conditon.' DoctorID >=1 and SH_DoctorProfile.status="A" order by DesignationRank ASC')->result_array();
}
// }
elseif($doctor_name){
$designation_id = $post['designation'];
$department_id = $post['department'];
$data['doctors'] = $this->doctor->get_doctors('',array(),'',$department_id,$designation_id,'','A');
}
//To be used in header forms
$data['departments_list']=$this->department->get_department_list( 'DepartmentType ASC', 'A');
$data['coes'] = $this->department->get_departments_summary('',array('COE'));
$data['page_title']='Meet Our Doctors|Sharda Hospital';
// print_r($data['doctors']);
$this->load->view('meet_our_doctors',$data);
}
public function patient_review(){
$data = array();
$emails = $_POST['email'];
$DoctorPageURL = $_POST['DoctorPageURL'];
if((!empty($_POST['username'])) and (!empty($_POST['email'])) and (!empty($_POST['star_review'])) and (!empty($_POST['phone']))) {
$querys = $this->db->query("select `review_email` from `SH_Doctor_review` where review_email='".$emails."'");
$numbb = $querys->num_rows();
$regex = '/^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$/';
if(preg_match($regex,$emails)) {
$insert_data1 = array(
'doc_id' => $_POST['DoctorID'],
'patient_id' => '',
'username' => $_POST['username'],
'review_email' => $_POST['email'],
'phone' => $_POST['phone'],
'review_rating' => $_POST['star_review'],
'status' => '1'
);
if($numbb=='0'){
$success = $this->doctor->insert_patient_review($insert_data1);
echo "<font color='#006600'>Thanks for review.</font>";
$currentURL = current_url();
if($success){
?>
<script> setTimeout(function() {
window.location = "<?php echo base_url().'meetourdoctors/'.$DoctorPageURL?>";
}, 1000 );
</script>
<?php
}} else {
echo "<font color='#990000'>You have already reviewed.</font>";
}
} else { echo "<font color='#990000'>Invalid Email Id.</font>"; }
}
else {
echo "<font color='#990000'>Please Fill all Information.</font>";
}
}
public function find_a_doctor1($post){
$data = array();
$department_id = '';
$doctor_name = '';
$designation_id ='';
$gender = '';
if($post){
/*echo '<script>console.log("post:find a doctor")</script>';*/
if((!empty($post['department'])) && (empty($post['doctor'])) && (empty($post['gender']))){
$id = $post['department'];
$coe_id = $id;
if(is_numeric($id)){
$data['coe'] = $this->department->get_department($id);
}
else{
$data['coe'] = $this->department->get_department_by_slug($id);
$coe_id = $this->department->get_department_id($id)['DepartmentID'];
/*echo '<script>console.log("COE ID: '.$coe_id.'")</script>';*/
}
$sub_departments = $this->department->get_sub_departments($coe_id);
$data['doctors'] = $this->doctor->get_doctors_by_department('DoctorID,DoctorTitle,DoctorName,DoctorDesignation,DesignationTitle,DoctorGender,DoctorProfilePic,DoctorDepartment,GROUP_CONCAT(DepartmentName SEPARATOR ", ") as DepartmentNames,DoctorPageURL',$sub_departments,'',array(),'','','A');
// print_r($data['doctors']);
}
else{
// if((!empty($post['department']))){
// $department_id = $post['department'];
// $conditon .= "SH_Departments.DepartmentID = '".$department_id."' and ";
// }
if((!empty($post['designation']))){
$designation_id = $post['designation'];
$conditon .= "SH_DoctorProfile.DoctorDesignation = '".$designation_id."' and ";
}
if(!empty($post['gender'])) {
$gender = $post['gender'];
$conditon .= "SH_DoctorProfile.DoctorGender = '$gender' and ";
}
if((isset($post['doctor']))&&($post['doctor']!='')){
$doctor_name = $post['doctor'];
$conditon .= "SH_DoctorProfile.DoctorName LIKE '%$doctor_name%' and ";
}
$data['doctors'] = $this->db->query('Select SH_DoctorProfile.DoctorID,SH_DoctorProfile.DoctorTitle,
SH_DoctorProfile.DoctorName,SH_DoctorProfile.DoctorDesignation,SH_DoctorProfile.DoctorProfilePic,SH_DoctorProfile.DoctorPageURL,
SH_Designations.DesignationID,SH_Designations.DesignationTitle,SH_Designations.DesignationRank,SH_Designations.DesignationPriority,
SH_Departments.DepartmentID,SH_Departments.DepartmentName,SH_Departments.DepartmentType
from SH_DoctorProfile left join
SH_Designations on SH_DoctorProfile.DoctorDesignation =
SH_Designations.DesignationID
left join SH_Departments on SH_DoctorProfile.DoctorDepartment = SH_Departments.DepartmentID
where '.$conditon.' DoctorID >=1 and SH_DoctorProfile.status="A" order by DesignationRank ASC')->result_array();
}
}
elseif($doctor_name){
$designation_id = $post['designation'];
$department_id = $post['department'];
$data['doctors'] = $this->doctor->get_doctors('',array(),'',$department_id,$designation_id,'','A');
}
//To be used in header forms
$data['departments_list']=$this->department->get_department_list( 'DepartmentType ASC', 'A');
$data['coes'] = $this->department->get_departments_summary('',array('COE'));
$data['page_title']='Meet Our Doctors|Sharda Hospital';
// print_r($data['doctors']);
$this->load->view('meet_our_doctors',$data);
}
}
Kontol Shell Bypass