public function deleteAction($id = false) { $this->permission('delete'); if (!$id) { return Brightery::error404(); } $model = new \modules\clinic\models\Clinic_schedule_exceptions(); $model->clinic_schedule_exception_id = $id; if ($model->delete()) { Uri_helper::redirect("management/clinic_schedule_exceptions"); } }
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 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; }