'; for ($d=1;$d<=$jumlahhari;$d++) { $warna = ''; $background = ''; $status_hadir = 'Tidak Hadir'; if (date("l",mktime (0,0,0,$bulan,$d,$tahun)) == "Sunday") { $warna='#ffffff'; $background ='#005CAA'; $status_hadir ='Libur Akhir Pekan'; } $date_month_year = ''.$year.'-'.$month.'-'.$d.''; if(isset($_POST['month']) OR isset($_POST['year'])){ $month = $_POST['month']; $year = $_POST['year']; $filter ="employees_id='$id' AND presence_date='$date_month_year' AND MONTH(presence_date)='$month' AND year(presence_date)='$year' AND employees_id='$id'"; } else{ $filter ="employees_id='$id' AND presence_date='$date_month_year' AND MONTH(presence_date) ='$month' AND employees_id='$id'"; } $query ="SELECT employees.id,shift.shift_id,shift.time_in,shift.time_out FROM employees,shift WHERE employees.shift_id=shift.shift_id AND employees.id='$id'"; $result = $connection->query($query); $row = $result->fetch_assoc(); $query_shift ="SELECT time_in,time_out FROM shift WHERE shift_id='$row[shift_id]'"; $result_shift = $connection->query($query_shift); $row_shift = $result_shift->fetch_assoc(); $shift_time_in = $row_shift['time_in']; $newtimestamp = strtotime(''.$shift_time_in.' + 05 minute'); $newtimestamp = date('H:i:s', $newtimestamp); $query_absen ="SELECT presence_id,presence_date,time_in,time_out,picture_in,picture_out,present_id,presence_address,information,TIMEDIFF(TIME(time_in),'$shift_time_in') AS selisih,if (time_in>'$shift_time_in','Telat',if(time_in='00:00:00','Tidak Masuk','Tepat Waktu')) AS status FROM presence WHERE $filter ORDER BY presence_id DESC"; $result_absen = $connection->query($query_absen); $row_absen = $result_absen->fetch_assoc(); $querya ="SELECT present_id,present_name FROM present_status WHERE present_id='$row_absen[present_id]'"; $resulta= $connection->query($querya); $rowa = $resulta->fetch_assoc(); // Status Kehadiran if($row_absen['time_in'] == NULL){ if (date("l",mktime (0,0,0,$bulan,$d,$tahun)) == "Sunday") { $status_hadir ='Libur Akhir Pekan'; }else{ $status_hadir ='Tidak Hadir'; } $time_in = $row_absen['time_in']; } else{ $status_hadir =''; $time_in = $row_absen['time_in']; } // Status Absensi Jam Masuk if($row_absen['status']=='Telat'){ $status_time_in =''; } elseif ($row_absen['status']=='Tepat Waktu') { $status_time_in =''; } else{ $status_time_in =''; } list($latitude, $longitude) = explode(',', $row_absen['presence_address']); echo''.$geo_location.' '; if (date("l",mktime (0,0,0,$bulan,$d,$tahun)) == "Sunday"){ if($row_absen['time_in'] ==''){ echo' '; } else{ echo' '; } } else{ echo' '; } if (date("l",mktime (0,0,0,$bulan,$d,$tahun)) == "Sunday"){ if($row_absen['time_out'] ==''){ echo' '; } else{ echo' '; } } else{ echo' '; } echo' '; } echo'
No Tanggal Jam Masuk Jam Pulang Lokasi Status Aksi
'.$d.' '.format_hari_tanggal($date_month_year).'Libur Akhir Pekan Libur Akhir Pekan'; if($row_absen['picture_in'] ==NULL){ echo'';} else{ echo' ';} echo' '.$row_absen['time_in'].''; if($row_absen['picture_in'] ==NULL){ echo'';} else{ echo' ';} echo' '.$row_absen['time_in'].'Libur Akhir Pekan Libur Akhir Pekan'; if($row_absen['picture_out'] ==NULL){ echo'';} else{ echo' ';} echo' '.$row_absen['time_out'].''; if($row_absen['picture_out'] ==NULL){ echo'';} else{ echo' ';} echo' '.$row_absen['time_out'].'

Lat: '.$latitude.'
Long: '.$longitude.'

 '.$status_hadir.' '.$status_time_in.'
'.$row_absen['information'].'
'; if(isset($_POST['month']) OR isset($_POST['year'])){ $month = $_POST['month']; $year = $_POST['year']; $filter ="employees_id='$id' AND MONTH(presence_date)='$month' AND year(presence_date)='$year' AND employees_id='$id'"; } else{ $filter ="employees_id='$id' AND MONTH(presence_date) ='$month' and employees_id='$id'"; } $query_hadir="SELECT presence_id FROM presence WHERE $filter AND present_id='1' ORDER BY presence_id DESC"; $hadir= $connection->query($query_hadir); $query_sakit="SELECT presence_id FROM presence WHERE $filter AND present_id='2' ORDER BY presence_id"; $sakit = $connection->query($query_sakit); $query_izin="SELECT presence_id FROM presence WHERE $filter AND present_id='3' ORDER BY presence_id"; $izin = $connection->query($query_izin); $query_telat ="SELECT presence_id FROM presence WHERE $filter AND time_in>'$shift_time_in'"; $telat = $connection->query($query_telat); echo'

Hadir : '.$hadir->num_rows.'

Telat : '.$telat->num_rows.'

Sakit : '.$sakit->num_rows.'

Izin : '.$izin->num_rows.'

'; echo' ';?>