| # |
created |
idrfid |
nama |
division |
mail |
alamat |
tgl |
jam masuk |
jam keluar |
Action |
'09:00:00' AND a.rekap_keluar < '16:00:00' THEN 'Terlambat dan Pulang Dulu'
WHEN a.rekap_masuk > '09:00:00' THEN 'Terlambat'
WHEN a.rekap_keluar < '16:00:00' THEN 'Pulang Dulu'
ELSE 'Tidak Terlambat'
END AS action
FROM data_karyawan k
INNER JOIN data_absen a ON k.idrfid = a.idrfid
ORDER BY k.nama";
$rows = mysqli_query($conn, $query);
foreach($rows as $row) :
?>
| |
|
|
|
|
|
|
|
|
|
|