public function getHosTimeSlot($hospitalId)
{
$this->db->select('hospitalTimeSlot_id id,hospitalTimeSlot_startTime start,hospitalTimeSlot_endTime end, hospitalTimeSlot_sessionType session')->from('qyura_hospitalTimeSlot')->where(array('hospitalTimeSlot_deleted' => 0, 'hospitalTimeSlot_hospitalId' => $hospitalId));
$response = $this->db->get()->result();
// echo $this->db->last_query(); die();
$finalResult = array();
if (!empty($response)) {
foreach ($response as $row) {
$finalTemp = array();
$finalTemp['id'] = isset($row->id) && $row->id ? $row->id : '';
$finalTemp['start'] = isset($row->start) ? $row->start : "";
$finalTemp['end'] = isset($row->end) ? $row->end : "";
$finalTemp['session'] = isset($row->session) ? getDoctorAvailibilitySession($row->session) : "";
$finalResult[] = $finalTemp;
}
return $finalResult;
} else {
return $finalResult;
}
}
public function getDoctorSessionForDoctor($id, $miId, $slotId = NULL)
{
$where = array('doctorAvailability_doctorAvailabilityId' => $id, 'doctors_userId' => $miId);
if ($slotId != NULL) {
$where["doctorAvailabilitySession_id"] = $slotId;
}
$this->db->select('doctorAvailabilitySession_id, doctors_fName as dName, doctors_id dId, doctorAvailabilitySession_start as start, doctorAvailabilitySession_end as end, doctorAvailabilitySession_type as session')->from('qyura_doctorAvailabilitySession')->join('qyura_doctors', 'qyura_doctors.doctors_userId=qyura_doctorAvailabilitySession.doctorAvailability_refferalId', 'left')->where($where);
$response = $this->db->get()->result();
// echo $this->db->last_query(); die();
if ($slotId != NULL) {
return count($response);
}
$finalResult = array();
if (!empty($response)) {
foreach ($response as $row) {
$finalTemp = array();
$finalTemp['sessionid'] = isset($row->doctorAvailabilitySession_id) ? $row->doctorAvailabilitySession_id : "";
$finalTemp['id'] = isset($row->dId) && $row->dId ? $row->dId : '';
$finalTemp['name'] = isset($row->dName) && $row->dName != '' ? $row->dName : '';
$finalTemp['start'] = isset($row->start) ? $row->start : "";
$finalTemp['end'] = isset($row->end) ? $row->end : "";
$finalTemp['session'] = isset($row->session) ? getDoctorAvailibilitySession($row->session) : "";
$finalResult[] = $finalTemp;
}
return $finalResult;
} else {
return $finalResult;
}
}
