1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
<?php
class Doctor_model extends CI_Model {
public function _consruct(){
parent::_construct();
}
function get_all_doctor(){
$doctor_data = $this->db->get("tbl_doctors");
return $doctor_data->result_array();
}
function get_bookinglist($doctorid){
$this->db->select("tbl_booking.*,tbl_doctors.name,tbl_doctors.profile_pic,tbl_clinic.name as clinicName");
$this->db->from('tbl_booking');
$this->db->join('tbl_doctors','tbl_doctors.id = tbl_booking.doctor_id','INNER');
$this->db->join('tbl_clinic','tbl_clinic.id = tbl_booking.clinic_id','left');
if($doctorid != 0){
$this->db->where('tbl_booking.doctor_id',$doctorid);
}
$result = $this->db->get();
return $result->result_array();
}
function get_specializations(){
return $this->db->get('tbl_specialization')->result_array();
}
public function update_status($id){
$data = array('account_status'=>'1');
$this->db->where('id',$id);
$this->db->update('tbl_doctors',$data);
return "success";
}
public function enable_status($id){
$data = array('account_status'=>'0');
$this->db->where('id',$id);
$result = $this->db->update('tbl_doctors',$data);
//echo $this->db->last_query();
return "success";
}
}