Hari/Tanggal :
| No |
Kode |
Keterangan |
Masuk |
Pulang |
'1';");
while($dcb = mysqli_fetch_assoc($subcb)) {
echo "
";
echo "| ".$dcb['deptid']." | ";
echo "".$dcb['deptname']." | ";
echo "
";
$tampil = " SELECT a.userid,b.name,(day(checktime)) as mtgl,date_format(checktime,'%H:%m:%s') as nil,date_format(checktime,'%d-%m-%Y') as tgl from checkinout a
left join userinfo b on a.userid=b.userid
where date(a.checktime)='$dtgl' and b.DEFAULTDEPTID='$dcb[deptid]' group by a.userid order by a.userid ;";
$no=1;
$sql0 = mysqli_query($con,$tampil);
while($data = mysqli_fetch_assoc($sql0)) {
$hr=$data['mtgl'];
echo "";
echo "| ".$no." | ";
echo "".$data['userid']." | ";
echo "".$data['name']." | ";
$dt = " SELECT TIME_FORMAT(checktime,'%H:%i') AS a from checkinout
where checktime>='$dtgl' and userid='$data[userid]' and hour(checktime)<12 group by userid order by checktime limit 1;";
$sql2 = mysqli_query($con,$dt);
$dt1 = mysqli_fetch_assoc($sql2);
$dtp = " SELECT TIME_FORMAT(checktime,'%H:%i') AS b from checkinout
where checktime>='$dtgl' and userid='$data[userid]' and hour(checktime)>15 group by userid order by checktime desc limit 1;";
$sql21 = mysqli_query($con,$dtp);
$dt11 = mysqli_fetch_assoc($sql21);
echo " ".($dt1['a'])." | ";
echo " ".($dt11['b'])." | ";
echo "
";
$no++;
}
}
?>