query($query); if($result->num_rows > 0){ $row = $result->fetch_assoc(); $employees_name = $row['employees_name']; if(isset($_GET['from']) OR isset($_GET['to'])){ $bulan = date ($_GET['from']); } else{ $bulan = date ("m"); } $hari = date("d"); $tahun = date("Y"); $jumlahhari = date("t",mktime(0,0,0,$bulan,$hari,$tahun)); $s = date ("w", mktime (0,0,0,$bulan,1,$tahun)); $mpdf = new \Mpdf\Mpdf(); ob_start(); $mpdf->SetHTMLFooter('
Simpanlah lembar Absensi ini. Dicetak tanggal '.tgl_indo($date).'
'); echo' Cetak Data Absensi '.$employees_name.' '; echo'
'; if(isset($_GET['from']) OR isset($_GET['to'])){ echo'

DATA ABSENSI BULAN '.tanggal_indo($_GET['from']).' - '.$_GET['to'].'

';} else{ echo'

DATA ABSENSI BULAN '.tanggal_indo($month).' - '.$year.'

'; } echo'

Nama : '.$row['employees_name'].'

Devisi : '.$row['position_name'].'


'; for ($d=1;$d<=$jumlahhari;$d++) { $warna = ''; $background = ''; $status = 'Tidak Hadir'; if (date("l",mktime (0,0,0,$bulan,$d,$tahun)) == "Sunday") { $warna='white'; $background ='#005CAA'; $status ='Libur Akhir Pekan'; } $date_month_year = ''.$year.'-'.$month.'-'.$d.''; if(isset($_GET['from']) OR isset($_GET['to'])){ $month = $_GET['from']; $year = $_GET['to']; $filter ="employees_id='$id' AND presence_date='$date_month_year' AND MONTH(presence_date)='$month' AND year(presence_date)='$year'"; } else{ $filter ="employees_id='$id' AND presence_date='$date_month_year' AND MONTH(presence_date) ='$month'"; } $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(); if($row_absen['time_in'] == NULL){ if (date("l",mktime (0,0,0,$bulan,$d,$tahun)) == "Sunday") { $status ='Libur Akhir Pekan'; }else{ $status ='Tidak Hadir'; } $time_in = $row_absen['time_in']; } else{ $status = $rowa['present_name']; $time_in = $row_absen['time_in']; } if($row_absen['status']=='Telat'){ $status_time_in =''; } elseif ($row_absen['status']=='Tepat Waktu') { $status_time_in =''; } else{ $status_time_in =''; } echo' '; 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 Waktu Masuk Waktu Pulang Status Keterangan
'.$d.' '.format_hari_tanggal($date_month_year).'Libur Akhir Pekan'.$row_absen['time_in'].''.$row_absen['time_in'].'Libur Akhir Pekan'.$row_absen['time_out'].''.$row_absen['time_out'].''.$status.' '.$status_time_in.' '.$row_absen['information'].'
'; if(isset($_GET['from']) OR isset($_GET['to'])){ $month = $_GET['from']; $year = $_GET['to']; $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.'

'; $html = ob_get_contents(); ob_end_clean(); $mpdf->WriteHTML(utf8_encode($html)); $mpdf->Output("Absensi-$employees_name-$date.pdf" ,'I'); }else{ echo'

Data Tidak Ditemukan

'; } }else{ echo'Data tidak boleh ada yang kosong!'; } //Explore to Excel ------------------------------------------------------- break; case 'excel': if (empty($_GET['id'])) { $error[] = 'ID tidak boleh kosong'; } else { $id = mysqli_real_escape_string($connection, $_GET['id']); } if (empty($error)) { $query ="SELECT employees.id,employees.employees_name,employees.shift_id,employees.position_id,position.position_name FROM employees,position WHERE employees.position_id=position.position_id AND employees.id='$id'"; $result = $connection->query($query); if($result->num_rows > 0){ $row = $result->fetch_assoc(); $employees_name = $row['employees_name']; if(isset($_GET['from']) OR isset($_GET['to'])){ $bulan = date ($_GET['from']); } else{ $bulan = date ("m"); } $hari = date("d"); $tahun = date("Y"); $jumlahhari = date("t",mktime(0,0,0,$bulan,$hari,$tahun)); $s = date ("w", mktime (0,0,0,$bulan,1,$tahun)); $mpdf = new \Mpdf\Mpdf(); ob_start(); if (empty($_GET['print'])) { header("Content-type: application/vnd-ms-excel"); header("Content-Disposition: attachment; filename=Data-Absensi-$employees_name-$date.xls"); } else { echo''; } echo' Cetak Data Absensi '.$employees_name.' '; echo'
'; if(isset($_GET['from']) OR isset($_GET['to'])){ echo'

DATA ABSENSI BULAN '.tanggal_indo($_GET['from']).' - '.$_GET['to'].'

';} else{ echo'

DATA ABSENSI BULAN '.tanggal_indo($month).' - '.$year.'

'; } echo'

Nama : '.$row['employees_name'].'

Devisi : '.$row['position_name'].'


'; for ($d=1;$d<=$jumlahhari;$d++) { $warna = ''; $background = ''; $status = 'Tidak Hadir'; if (date("l",mktime (0,0,0,$bulan,$d,$tahun)) == "Sunday") { $warna='white'; $background ='#005CAA'; $status ='Libur Akhir Pekan'; } $date_month_year = ''.$year.'-'.$month.'-'.$d.''; if(isset($_GET['from']) OR isset($_GET['to'])){ $month = $_GET['from']; $year = $_GET['to']; $filter ="employees_id='$id' AND presence_date='$date_month_year' AND MONTH(presence_date)='$month' AND year(presence_date)='$year'"; } else{ $filter ="employees_id='$id' AND presence_date='$date_month_year' AND MONTH(presence_date) ='$month'"; } $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(); if($row_absen['time_in'] == NULL){ if (date("l",mktime (0,0,0,$bulan,$d,$tahun)) == "Sunday") { $status ='Libur Akhir Pekan'; }else{ $status ='Tidak Hadir'; } $time_in = $row_absen['time_in']; } else{ $status = $rowa['present_name']; $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 =''; } echo' '; 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 Waktu Masuk Waktu Pulang Status Keterangan
'.$d.' '.format_hari_tanggal($date_month_year).'Libur Akhir Pekan'.$row_absen['time_in'].''.$row_absen['time_in'].'Libur Akhir Pekan'.$row_absen['time_out'].''.$row_absen['time_out'].''.$status.' '.$status_time_in.' '.$row_absen['information'].'
'; if(isset($_GET['from']) OR isset($_GET['to'])){ $month = $_GET['from']; $year = $_GET['to']; $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.'

'; }else{ echo'

Data Tidak Ditemukan

'; } }else{ echo'Data tidak boleh ada yang kosong!'; } break; /* ------- CETAK ALL Pengguna PDF-----------------------------------------------*/ case 'allpdf': $query ="SELECT employees.id,employees.employees_name,employees.position_id,position.position_name,shift.time_in,shift.time_out FROM employees,position,shift WHERE employees.position_id=position.position_id AND employees.shift_id=shift.shift_id ORDER BY employees.id DESC"; $result = $connection->query($query); if($result->num_rows > 0){ while ($row= $result->fetch_assoc()) { $employees_name = $row['employees_name']; $id = $row['id']; if(isset($_GET['from']) OR isset($_GET['to'])){ $bulan = date ($_GET['from']); } else{ $bulan = date ("m"); } $hari = date("d"); $tahun = date("Y"); $jumlahhari = date("t",mktime(0,0,0,$bulan,$hari,$tahun)); $s = date ("w", mktime (0,0,0,$bulan,1,$tahun)); $mpdf = new \Mpdf\Mpdf(); ob_start(); $shift_time_in = $row['time_in']; $newtimestamp = strtotime(''.$shift_time_in.' + 05 minute'); $newtimestamp = date('H:i:s', $newtimestamp); $mpdf->SetHTMLFooter('
Simpanlah lembar Absensi ini. Dicetak tanggal '.tgl_indo($date).'
'); echo' Cetak Data Absensi '.$employees_name.' '; echo'
'; if(isset($_GET['from']) OR isset($_GET['to'])){ echo'

DATA ABSENSI BULAN '.tanggal_indo($_GET['from']).' - '.$_GET['to'].'

';} else{ echo'

DATA ABSENSI BULAN '.tanggal_indo($month).' - '.$year.'

'; } echo'

Nama : '.$row['employees_name'].'

Devisi : '.$row['position_name'].'


'; for ($d=1;$d<=$jumlahhari;$d++) { $warna = ''; $background = ''; $status = 'Tidak Hadir'; if (date("l",mktime (0,0,0,$bulan,$d,$tahun)) == "Sunday") { $warna='white'; $background ='#005CAA'; $status ='Libur Akhir Pekan'; } $date_month_year = ''.$year.'-'.$month.'-'.$d.''; if(isset($_GET['from']) OR isset($_GET['to'])){ $month = $_GET['from']; $year = $_GET['to']; $filter ="employees_id='$id' AND presence_date='$date_month_year' AND MONTH(presence_date)='$month' AND year(presence_date)='$year'"; } else{ $filter ="employees_id='$id' AND presence_date='$date_month_year' AND MONTH(presence_date) ='$month'"; } $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"; $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(); if($row_absen['time_in'] == NULL){ if (date("l",mktime (0,0,0,$bulan,$d,$tahun)) == "Sunday") { $status ='Libur Akhir Pekan'; }else{ $status ='Tidak Hadir'; } $time_in = $row_absen['time_in']; } else{ $status = $rowa['present_name']; $time_in = $row_absen['time_in']; } if($row_absen['status']=='Telat'){ $status_time_in =''; } elseif ($row_absen['status']=='Tepat Waktu') { $status_time_in =''; } else{ $status_time_in =''; } echo' '; 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 Waktu Masuk Waktu Pulang Status Keterangan
'.$d.' '.format_hari_tanggal($date_month_year).'Libur Akhir Pekan'.$row_absen['time_in'].''.$row_absen['time_in'].'Libur Akhir Pekan'.$row_absen['time_out'].''.$row_absen['time_out'].''.$status.' '.$status_time_in.' '.$row_absen['information'].'
'; if(isset($_GET['from']) OR isset($_GET['to'])){ $month = $_GET['from']; $year = $_GET['to']; $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.'

';} $html = ob_get_contents(); ob_end_clean(); $mpdf->WriteHTML(utf8_encode($html)); $mpdf->Output("Absensi-$employees_name-$date.pdf" ,'I'); }else{ echo'

Data Tidak Ditemukan

'; } break; /* ------- CETAK ALL EXCEL-----------------------------------------------*/ case 'allexcel': $query ="SELECT employees.id,employees.employees_name,employees.position_id,position.position_name,shift.time_in,shift.time_out FROM employees,position,shift WHERE employees.position_id=position.position_id AND employees.shift_id=shift.shift_id ORDER BY employees.id DESC"; $result = $connection->query($query); if($result->num_rows > 0){ while ($row= $result->fetch_assoc()) { $employees_name = $row['employees_name']; $id = $row['id']; if(isset($_GET['from']) OR isset($_GET['to'])){ $bulan = date ($_GET['from']); } else{ $bulan = date ("m"); } $hari = date("d"); $tahun = date("Y"); $jumlahhari = date("t",mktime(0,0,0,$bulan,$hari,$tahun)); $s = date ("w", mktime (0,0,0,$bulan,1,$tahun)); $mpdf = new \Mpdf\Mpdf(); ob_start(); $shift_time_in = $row['time_in']; $newtimestamp = strtotime(''.$shift_time_in.' + 05 minute'); $newtimestamp = date('H:i:s', $newtimestamp); if (empty($_GET['print'])) { header("Content-type: application/vnd-ms-excel"); header("Content-Disposition: attachment; filename=Data-Absensi-$date.xls"); } else { echo''; } echo' Cetak Data Absensi '.$employees_name.' '; echo'
'; if(isset($_GET['from']) OR isset($_GET['to'])){ echo'

DATA ABSENSI BULAN '.tanggal_indo($_GET['from']).' - '.$_GET['to'].'

';} else{ echo'

DATA ABSENSI BULAN '.tanggal_indo($month).' - '.$year.'

'; } echo'

Nama : '.$row['employees_name'].'

Devisi : '.$row['position_name'].'


'; for ($d=1;$d<=$jumlahhari;$d++) { $warna = ''; $background = ''; $status = 'Tidak Hadir'; if (date("l",mktime (0,0,0,$bulan,$d,$tahun)) == "Sunday") { $warna='white'; $background ='#005CAA'; $status ='Libur Akhir Pekan'; } $date_month_year = ''.$year.'-'.$month.'-'.$d.''; if(isset($_GET['from']) OR isset($_GET['to'])){ $month = $_GET['from']; $year = $_GET['to']; $filter ="employees_id='$id' AND presence_date='$date_month_year' AND MONTH(presence_date)='$month' AND year(presence_date)='$year'"; } else{ $filter ="employees_id='$id' AND presence_date='$date_month_year' AND MONTH(presence_date) ='$month'"; } $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"; $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(); if($row_absen['time_in'] == NULL){ if (date("l",mktime (0,0,0,$bulan,$d,$tahun)) == "Sunday") { $status ='Libur Akhir Pekan'; }else{ $status ='Tidak Hadir'; } $time_in = $row_absen['time_in']; } else{ $status = $rowa['present_name']; $time_in = $row_absen['time_in']; } if($row_absen['status']=='Telat'){ $status_time_in =''; } elseif ($row_absen['status']=='Tepat Waktu') { $status_time_in =''; } else{ $status_time_in =''; } echo' '; 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 Waktu Masuk Waktu Pulang Status Keterangan
'.$d.' '.format_hari_tanggal($date_month_year).'Libur Akhir Pekan'.$row_absen['time_in'].''.$row_absen['time_in'].'Libur Akhir Pekan'.$row_absen['time_out'].''.$row_absen['time_out'].''.$status.' '.$status_time_in.' '.$row_absen['information'].'
'; if(isset($_GET['from']) OR isset($_GET['to'])){ $month = $_GET['from']; $year = $_GET['to']; $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.'

';} }else{ echo'

Data Tidak Ditemukan

'; } break; } }?>