public function attendAction() { $this->language->load("clinic_doctors"); $user_id = $this->input->post('user_id'); $date = $this->input->post('date'); $time = $this->input->post('time'); $model = new \modules\clinic\models\Clinic_reservations(FALSE); $model->_select = "clinic_reservation_id"; $model->user_id = $user_id; $model->date = $date; $model->time = $time; $model->clinic_reservation_status = 'confirmed'; $result = $model->get(); if ($model->get()) { $clinic_reservation_id = $result[0]->clinic_reservation_id; $model->clinic_reservation_id = $clinic_reservation_id; $model->status = 'attend'; if ($model->save(TRUE)) { return true; } else { return false; } } else { return false; } }
public function manageAction($id = false) { $this->permission('manage'); $this->language->load("clinic_reservations"); $model = new \modules\clinic\models\Clinic_reservations(); $model->language_id = $this->language->getDefaultLanguage(); $doctor = Form_helper::queryToDropdown('users', 'clinic_doctor_id', 'fullname', null, 'join clinic_doctors on clinic_doctors.user_id = users.user_id'); $model->attributes = $this->Input->input['post']; $clinic_reservation_status = ['confirmed' => $this->Language->phrase('confirmed'), 'canceled' => $this->Language->phrase('canceled'), 'pending' => $this->Language->phrase('pending')]; $schedules = Form_helper::queryToDropdown('clinic_schedules', 'clinic_schedule_id', 'clinic_schedule_id'); $patients = Form_helper::queryToDropdown('users', 'user_id', 'fullname'); // $patients = Form_helper::fullqueryToDropdown('SELECT clinic_patients.clinic_patient_id, users.fullname FROM clinic_patients INNER JOIN users ON users.user_id = clinic_patients.user_id', 'clinic_patient_id', 'fullname'); if ($id) { $model->clinic_reservation_id = $id; } $model->language_id = $this->language->getDefaultLanguage(); if (!$id) { $model->created = date("Y-m-d H:i:s"); } if ($model->save()) { Uri_helper::redirect("management/clinic_reservations"); } $final = null; if ($_POST) { $final = $this->getSearch(); } return $this->render('clinic_reservations/manage', ['item' => $id ? $model->get() : null, 'patient' => $patients, 'schedule' => $schedules, 'clinic_reservation_status' => $clinic_reservation_status, 'doctors' => $doctor]); }
public function get_searchResult($date, $time, $doctor_id) { $i = 0; $x = 0; // $final_result = []; // $newtime[]->time = (object) array('time', 'user_id', 'date'); foreach ($time as $key => $value) { $newtime[$key]->time = $value; } foreach ($newtime as $key => $value) { $model_rev = new \modules\clinic\models\Clinic_reservations(); $model_rev->_select = 'user_id , date , time'; $model_rev->time = $value->time; $model_rev->date = $date; $model_rev->clinic_doctor_id = $doctor_id; $model_rev->where = 'clinic_reservation_status = "confirmed" of clinic_reservation_status = "pending"'; $result_f = $model_rev->get(); $user_id = $result_f[0]->user_id; if ($result_f) { foreach ($result_f as $key => $value) { $tim = $result_f[$key]->time; foreach ($newtime as $k => $val) { if ($newtime[$k]->time == $tim) { $user_id = $result_f[$key]->user_id; $newtime[$k]->user_id = $user_id; $newtime[$k]->date = $date; $newtime[$k]->time = $tim; $newtime[$k]->status = 'reserved'; } } } } } $model_ex = new \modules\clinic\models\Clinic_schedule_exceptions(); $model_ex->select = ''; $model_ex->clinic_doctor_id = $doctor_id; $model_ex->date = $date; $exception = $model_ex->get(); foreach ($exception as $key => $v) { $ffff = strtotime("1970-01-01 {$v->from_time} UTC"); $tttt = strtotime("1970-01-01 {$v->to_time} UTC"); foreach ($newtime as $k => $value) { $newwww = $newtime[$k]->time; $convert = strtotime("1970-01-01 {$newwww} UTC"); if ($convert == $ffff) { $newtime[$k]->status = 'except'; $newtime[$k]->time = $newwww; } elseif ($convert == $tttt) { $newtime[$k]->status = 'except'; } elseif ($convert > $ffff && $convert < $tttt) { $newtime[$k]->status = 'except'; } } } return $newtime; }