public function saveAction()
{
$clinic_doctor_id = $this->input->post('doctor_id');
$user_id = $this->input->post('patient_id');
$date = $this->input->post('date');
$time = $this->input->post('time');
$status = $this->input->post('status');
// $clinic_doctor_reservation_type_id = $this->input->post('clinic_doctor_reservation_type_id');
$model_res = new \modules\clinic\models\Clinic_reservations(FALSE);
$model_res->created = date("Y-m-d H:i:s");
$model_res->time = $time;
$model_res->date = $date;
$model_res->user_id = $user_id;
$model_res->clinic_doctor_id = $clinic_doctor_id;
// $model_res->clinic_doctor_reservation_type_id = $clinic_doctor_reservation_type_id;
$model_res->clinic_reservation_status = $status;
$model_res->status = '';
if ($model_res->save()) {
return true;
} else {
return false;
}
}
public function deleteAction($id = false)
{
$this->permission('delete');
if (!$id) {
return Brightery::error404();
}
$model_schedules = new \modules\clinic\models\Clinic_schedules();
$model_schedules->clinic_doctor_id = $id;
$model_exceptions = new modules\clinic\models\Clinic_schedule_exceptions();
$model_exceptions->clinic_doctor_id = $id;
$model = new \modules\clinic\models\Clinic_doctors();
$model->clinic_doctor_id = $id;
$model_resevration_type = new \modules\clinic\models\Clinic_doctor_reservation_types();
$model_resevration_type->clinic_doctor_id = $id;
$model_reservation = new \modules\clinic\models\Clinic_reservations();
$model_reservation->clinic_doctor_id = $id;
if ($model->delete() && $model_exceptions->delete() && $model_schedules->delete() && $model_resevration_type->delete() && $model_reservation->delete()) {
Uri_helper::redirect("management/clinic_doctors");
}
}
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 saveAction()
{
$email = $this->input->post('email');
$date = $this->input->post('date');
$time = $this->input->post('time');
$clinic_doctor_id = $this->input->post('clinic_doctor_id');
$clinic_doctor_reservation_type_id = $this->input->post('clinic_doctor_reservation_type_id');
$model = new \modules\users\models\Users();
$model->_select = "user_id";
$model->email = $email;
if ($model->get()) {
$user = $model->get();
$user_id = $user[0]->user_id;
$model_res = new \modules\clinic\models\Clinic_reservations(FALSE);
$model_res->created = date("Y-m-d H:i:s");
$model_res->time = $time;
$model_res->date = $date;
$model_res->user_id = $user_id;
$model_res->clinic_doctor_id = $clinic_doctor_id;
$model_res->clinic_doctor_reservation_type_id = $clinic_doctor_reservation_type_id;
$model_res->clinic_reservation_status = 'pending';
$model_res->status = '';
if ($model_res->save()) {
return true;
} else {
return false;
}
} else {
return false;
}
}
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;
}
