/**
* Get the time element from datetime parameter, then get kode_waktu from fetched time, based on Noreg and Kode Seksi
* @param $date
* @return mixed|null
*/
public static function getKodeWaktuByDate($date, $kode_seksi, $noreg)
{
$instance = DB::select('SELECT time(tanggal) as time FROM presences WHERE date(tanggal)=? and kode_seksi=? and Noreg=? order by time desc', [$date, $kode_seksi, $noreg]);
if (count($instance) == 0) {
return null;
}
$time = $instance[0]->time;
//next query timeslot, guaranteed to be not null by condition
$timeslot = WaktuKuliah::getKodeWaktuByTime($time);
return $timeslot;
}
public function editMatkul($id_course)
{
$course = Course::where('seksi', $id_course)->first();
//get all prodi information
$prodis = Prodi::all();
//transform prodi to associative array
$prodi_arr = array();
foreach ($prodis as $prodi) {
$prodi_arr[$prodi->id] = $prodi->prodi;
}
$kode_dosen = $course->Kode_Dosen;
//need to pass filled data to this view (extra parameter)
$room = Room::room_name();
$room_arr = Helpers::toAssociativeArrays($room);
$waktu_kuliah = WaktuKuliah::waktuMap();
$waktu_opts = Helpers::toAssociativeArrays($waktu_kuliah);
return view('lecturers.editcourse')->with('prodi_options', $prodi_arr)->with('Kode_Dosen', $kode_dosen)->with('room_options', $room_arr)->with('course', $course)->with('waktu_options', $waktu_opts);
}
/**
* @param $day string of course day
* @param $time_start string of course start time
* @param $time_end string of course end time
*/
public static function isAbsentFillable($day, $time_start, $time_end, $kode_seksi, $noreg)
{
//get current time in Indonesia
$current_day = trans('messages.' . date('l'));
//get current time
$current_time = date('H:i');
//first condition current time must be in interval course time
$stat = (bool) DB::select('select ? between ? and ? as result', [$current_time, $time_start, $time_end])[0]->result;
//second condition current day must be within course day
$stat2 = strcmp($current_day, $day) == 0;
//third condition, check in presences table whether current slot already exist
$current_slot = WaktuKuliah::getKodeWaktuByTime($current_time);
if (is_null($current_slot)) {
return 0;
}
$current_date = date('Y-m-d');
$recorded_slot = Presence::getKodeWaktuByDate($current_date, $kode_seksi, $noreg);
//if(is_null($recorded_slot))
// return 0;
//insertable if current slot different from recorded slot
$stat3 = strcmp($current_slot, $recorded_slot) != 0;
$final_stat = $stat && $stat2 && $stat3;
return $final_stat;
}
