public static function updateSchedule($diagDate, $diagTime, $mode, $doctorId)
{
$schedule = schedule::join('scheduleLog', 'schedule.scheduleLogId', '=', 'scheduleLog.scheduleLogId')->where('scheduleLog.doctorId', '=', $doctorId)->where('schedule.diagDate', '=', $diagDate)->where('schedule.diagTime', '=', $diagTime)->first();
// add new schedule
if ($schedule == null && $mode == 'true') {
$slog = scheduleLog::newInstantScheduleLog($diagDate, $doctorId);
$newSchedule = new schedule();
$newSchedule->scheduleLogId = $slog->scheduleLogId;
$newSchedule->diagDate = $diagDate;
$newSchedule->diagTime = $diagTime;
$newSchedule->save();
} else {
if ($schedule != null && $mode == 'false') {
$appointments = $schedule->appointments()->get();
foreach ($appointments as $app) {
$app->delete();
}
$schedule->delete();
}
}
}
