query($query); if($result->num_rows > 0){ $row= $result->fetch_assoc(); $shift_time_in = $row['time_in']; if(isset($_GET['from']) OR isset($_GET['to'])){ $from = date('Y-m-d', strtotime($_GET['from'])); $to = date('Y-m-d', strtotime($_GET['to'])); $filter ="presence_date BETWEEN '$from' AND '$to'"; } else{ $filter ="MONTH(presence_date) ='$month'"; } $mpdf = new \Mpdf\Mpdf(); ob_start(); $mpdf->SetHTMLFooter('
Simpanlah lembar Absensi ini. Dicetak tanggal '.tgl_indo($date).'
'); echo' Cetak Data Absensi '; echo'
'; if(isset($_GET['from']) OR isset($_GET['to'])){ echo'

DATA ABSENSI "'.$employees_name.'" PER TANGGAl '.tanggal_ind($from).' S/D '.tanggal_ind($to).'

';} else{ echo'

DATA ABSENSI "'.$employees_name.'" BULAN '.tanggal_indo($month_en).' '.$year.'

'; } echo'
'; $query_absen ="SELECT presence_id,presence_date,picture_in,time_in,picture_out,time_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 employees_id='$row_user[id]' AND $filter ORDER BY presence_id ASC"; $result_absen = $connection->query($query_absen); if($result_absen->num_rows > 0){ while ($row_absen= $result_absen->fetch_assoc()) { $query_status ="SELECT present_name FROM present_status WHERE present_id='$row_absen[present_id]'"; $result_status = $connection->query($query_status); $row_aa= $result_status->fetch_assoc(); $no++; if($row_absen['information']==''){ $information = ''; }else{ $information = '
'.$row_absen['information'].''; } if($row_absen['status']=='Telat'){ $status_time_in =' '.$row_absen['status'].''; } elseif ($row_absen['status']=='Tepat Waktu') { $status_time_in =' '.$row_absen['status'].''; } else{ $status_time_in =''; } echo''; } }else{ echo'

Data tidak ditemukan..!

'; } echo'
No. Tanggal Waktu Masuk Waktu Pulang Status Keterangan
'.$no.' '.tanggal_indo($row_absen['presence_date'], true).' '.$row_absen['time_in'].' '.$row_absen['time_out'].' '.$row_aa['present_name'].' '.$status_time_in.' '.$row_absen['information'].'
'; $query_hadir="SELECT presence_id FROM presence WHERE employees_id='$row_user[id]' AND $filter AND present_id='1' ORDER BY presence_id DESC"; $hadir= $connection->query($query_hadir); $query_sakit="SELECT presence_id FROM presence WHERE employees_id='$row_user[id]' AND $filter AND present_id='2' ORDER BY presence_id"; $sakit = $connection->query($query_sakit); $query_izin="SELECT presence_id FROM presence WHERE employees_id='$row_user[id]' AND $filter AND present_id='3' ORDER BY presence_id"; $izin = $connection->query($query_izin); $query_telat ="SELECT presence_id FROM presence WHERE employees_id='$row_user[id]' AND $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{ } break; case 'excel': $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 AND employees.id='$row_user[id]'"; $result = $connection->query($query); if($result->num_rows > 0){ $row= $result->fetch_assoc(); $shift_time_in = $row['time_in']; if(isset($_GET['from']) OR isset($_GET['to'])){ $from = date('Y-m-d', strtotime($_GET['from'])); $to = date('Y-m-d', strtotime($_GET['to'])); $filter ="presence_date BETWEEN '$from' AND '$to'"; } else{ $filter ="MONTH(presence_date) ='$month'"; } header("Content-type: application/vnd-ms-excel"); header("Content-Disposition: attachment; filename=Data-Absensi-$employees_name-$date.xls"); echo' Cetak Data Absensi '; echo'
'; if(isset($_GET['from']) OR isset($_GET['to'])){ echo'

DATA ABSENSI "'.$employees_name.'" PER TANGGAl '.tanggal_ind($from).' S/D '.tanggal_ind($to).'

';} else{ echo'

DATA ABSENSI "'.$employees_name.'" BULAN '.tanggal_indo($month_en).' '.$year.'

'; } echo'
'; $query_absen ="SELECT presence_id,presence_date,picture_in,time_in,picture_out,time_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 employees_id='$row_user[id]' AND $filter ORDER BY presence_id ASC"; $result_absen = $connection->query($query_absen); if($result_absen->num_rows > 0){ while ($row_absen= $result_absen->fetch_assoc()) { $query_status ="SELECT present_name FROM present_status WHERE present_id='$row_absen[present_id]'"; $result_status = $connection->query($query_status); $row_aa= $result_status->fetch_assoc(); $no++; if($row_absen['information']==''){ $information = ''; }else{ $information = '
'.$row_absen['information'].''; } if($row_absen['status']=='Telat'){ $status_time_in =' '.$row_absen['status'].''; } elseif ($row_absen['status']=='Tepat Waktu') { $status_time_in =' '.$row_absen['status'].''; } else{ $status_time_in =''; } echo''; } }else{ echo'

Data tidak ditemukan..!

'; } echo'
No. Tanggal Waktu Masuk Waktu Pulang Status Keterangan
'.$no.' '.tanggal_indo($row_absen['presence_date'], true).' '.$row_absen['time_in'].' '.$row_absen['time_out'].' '.$row_aa['present_name'].' '.$status_time_in.' '.$information.'
'; $query_hadir="SELECT presence_id FROM presence WHERE employees_id='$row_user[id]' AND $filter AND present_id='1' ORDER BY presence_id DESC"; $hadir= $connection->query($query_hadir); $query_sakit="SELECT presence_id FROM presence WHERE employees_id='$row_user[id]' AND $filter AND present_id='2' ORDER BY presence_id"; $sakit = $connection->query($query_sakit); $query_izin="SELECT presence_id FROM presence WHERE employees_id='$row_user[id]' AND $filter AND present_id='3' ORDER BY presence_id"; $izin = $connection->query($query_izin); $query_telat ="SELECT presence_id FROM presence WHERE employees_id='$row_user[id]' AND $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; } }?>