@php $total_denda = 0; $total_potongan_jam = 0; $total_jam_lembur = 0; $jml_hadir = 0; $jml_sakit = 0; $jml_izin = 0; $jml_cuti = 0; $jml_libur = 0; $jml_alfa = 0; $jml_terlambat = 0; $jml_pulangcepat = 0; $jml_tidakscanmasuk = 0; $jml_tidakscanpulang = 0; // Mapping data presensi agar mudah diakses $presensiByDate = []; foreach ($presensi as $row) { $presensiByDate[$row->tanggal] = $row; } $mapJadwalByDate = $jadwal_bydate[$karyawan->nik] ?? []; $mapJadwalGrupByDate = $jadwal_grup_bydate[$karyawan->nik] ?? []; $mapJadwalByDay = $jadwal_byday[$karyawan->nik] ?? []; $tanggal_presensi = $periode_dari; $no = 1; @endphp @while (strtotime($tanggal_presensi) <= strtotime($periode_sampai)) @php $denda = 0; $potongan_jam = 0; $search = [ 'nik' => $karyawan->nik, 'tanggal' => $tanggal_presensi, ]; $ceklibur = ceklibur($datalibur, $search); // Cek snapshot lembur (data terkunci) $d_row = $presensiByDate[$tanggal_presensi] ?? null; if ($d_row && $d_row->jam_lembur_aktual !== null) { $jml_jam_lembur = $d_row->jam_lembur_aktual; } else { $ceklembur = ceklembur($datalembur, $search); $lembur_jam = hitungLembur($ceklembur); $jml_jam_lembur = !empty($ceklembur) ? $lembur_jam : 0; } $nama_hari = getHari($tanggal_presensi); $d = $presensiByDate[$tanggal_presensi] ?? null; $bgcolor = ''; $textcolor = ''; $ket_status = ''; $ket_jam_kerja = '-'; $ket_jam_in = '-'; $ket_jam_out = '-'; $ket_istirahat = '-'; $ket_terlambat = ''; @endphp @if ($d) @php $ket_jam_kerja = $d->nama_jam_kerja . ' (' . date('H:i', strtotime($d->jam_masuk)) . ' - ' . date('H:i', strtotime($d->jam_pulang)) . ')'; if ($d->status == 'h') { $jml_hadir++; $ket_jam_in = !empty($d->jam_in) ? date('H:i', strtotime($d->jam_in)) : 'X'; $ket_jam_out = !empty($d->jam_out) ? date('H:i', strtotime($d->jam_out)) : 'X'; $jam_masuk_reg = $tanggal_presensi . ' ' . $d->jam_masuk; $terlambat_info = hitungjamterlambat($d->jam_in, $jam_masuk_reg); if ($terlambat_info != null) { $ket_terlambat = $terlambat_info['show_laporan']; if ($terlambat_info['menitterlambat'] > 0) { $jml_terlambat++; } } // Denda Logic (matching presensi_cetak) $denda_dari_db = isset($d->denda) && $d->denda !== null ? $d->denda : null; if ($denda_dari_db !== null) { $denda = $denda_dari_db; if ($terlambat_info != null) { $potongan_jam_terlambat = $terlambat_info['desimal_terlambat'] < 1 ? 0 : ($terlambat_info['desimal_terlambat'] > $d->total_jam ? $d->total_jam : $terlambat_info['desimal_terlambat']); } else { $potongan_jam_terlambat = 0; } } else { if ($terlambat_info != null) { if ($terlambat_info['desimal_terlambat'] < 1) { $potongan_jam_terlambat = 0; $denda = hitungdenda($denda_list, $terlambat_info['menitterlambat']); } else { $potongan_jam_terlambat = $terlambat_info['desimal_terlambat'] > $d->total_jam ? $d->total_jam : $terlambat_info['desimal_terlambat']; $denda = 0; } } else { $potongan_jam_terlambat = 0; $denda = 0; } } $pulangcepat = hitungpulangcepat($tanggal_presensi, $d->jam_out, $d->jam_pulang, $d->istirahat, $d->jam_awal_istirahat, $d->jam_akhir_istirahat, $d->lintashari); $pulangcepat = $pulangcepat > $d->total_jam ? $d->total_jam : $pulangcepat; if ($pulangcepat != null) $jml_pulangcepat++; $potongan_istirahat = hitungPotonganIstirahat($d->istirahat_out, $d->istirahat_in, $d->jam_awal_istirahat, $d->jam_akhir_istirahat); $potongan_tidak_absen = (empty($d->jam_out) || empty($d->jam_in)) ? $d->total_jam : 0; $status_potongan_istirahat = $d->status_potongan_istirahat ?? $generalsetting->potongan_istirahat; $potongan_jam = $potongan_tidak_absen == 0 ? ($pulangcepat + $potongan_jam_terlambat + ($status_potongan_istirahat == 1 ? $potongan_istirahat : 0)) : $potongan_tidak_absen; $status_potongan_harian = $d->status_potongan ?? $generalsetting->status_potongan_jam; if ($status_potongan_harian == 0) $potongan_jam = 0; if (empty($d->jam_in)) $jml_tidakscanmasuk++; if (empty($d->jam_out)) $jml_tidakscanpulang++; if ($generalsetting->absen_istirahat == 1) { $istirahat_in_val = (!empty($d->istirahat_in)) ? date('H:i', strtotime($d->istirahat_in)) : null; $istirahat_out_val = (!empty($d->istirahat_out)) ? date('H:i', strtotime($d->istirahat_out)) : null; if ($istirahat_out_val && $istirahat_in_val) { $ket_istirahat = '' . $istirahat_out_val . ' - ' . $istirahat_in_val . ''; } else { $ket_istirahat = 'Belum Absen'; } } else { $ket_istirahat = '-'; } $ket_status = 'HADIR'; } elseif ($d->status == 'i') { $jml_izin++; $bgcolor = '#dea51f'; $textcolor = 'white'; $ket_status = 'IZIN'; $potongan_jam = $generalsetting->status_potongan_jam == 1 ? $d->total_jam : 0; $denda = $d->denda ?? 0; } elseif ($d->status == 's') { $jml_sakit++; $bgcolor = '#c8075b'; $textcolor = 'white'; $ket_status = 'SAKIT'; $denda = $d->denda ?? 0; } elseif ($d->status == 'c') { $jml_cuti++; $bgcolor = '#0164b5'; $textcolor = 'white'; $ket_status = 'CUTI'; $denda = $d->denda ?? 0; } elseif ($d->status == 'a') { $jml_alfa++; $bgcolor = 'red'; $textcolor = 'white'; $ket_status = 'ALPA'; $status_pot_alpa = $d->status_potongan ?? $generalsetting->status_potongan_jam; $potongan_jam = $status_pot_alpa == 1 ? $d->total_jam : 0; $denda = $d->denda ?? 0; } @endphp @else @php $is_future = strtotime($tanggal_presensi) > strtotime(date('Y-m-d')); if (!empty($ceklibur)) { $bgcolor = 'green'; $textcolor = 'white'; $jml_libur++; $ket_status = 'LIBUR (' . $ceklibur[0]['keterangan'] . ')'; } else { $totalJamJadwal = $mapJadwalByDate[$tanggal_presensi] ?? null; if ($totalJamJadwal === null) $totalJamJadwal = $mapJadwalGrupByDate[$tanggal_presensi] ?? null; if ($totalJamJadwal === null) $totalJamJadwal = $mapJadwalByDay[$nama_hari] ?? null; if ($totalJamJadwal === null) { $keyDeptCabang = $karyawan->kode_dept . '|' . $karyawan->kode_cabang; $mapDept = $jadwal_bydept[$keyDeptCabang] ?? []; $totalJamJadwal = $mapDept[$nama_hari] ?? null; } if ($totalJamJadwal === null) { $totalJamJadwal = $jadwal_global[$nama_hari] ?? null; } if ($totalJamJadwal !== null && !$is_future) { $jml_alfa++; $bgcolor = 'red'; $textcolor = 'white'; $ket_status = 'ALPA'; $potongan_jam = $generalsetting->status_potongan_jam == 1 ? (is_array($totalJamJadwal) ? $totalJamJadwal['total_jam'] : $totalJamJadwal) : 0; } else { $ket_status = '-'; } } @endphp @endif @php $total_denda += $denda; $total_potongan_jam += $potongan_jam; $total_jam_lembur += $jml_jam_lembur; if ($nama_hari == 'Minggu') $bgcolor = 'orange'; @endphp @php $tanggal_presensi = date('Y-m-d', strtotime('+1 day', strtotime($tanggal_presensi))); @endphp @endwhile

No	Tanggal	Hari	Jadwal Kerja	Jam Masuk	Jam Pulang	Jam Istirahat	Status	Terlambat	Denda	Pot. Jam	Lembur
{{ $no++ }}	{{ date('d-m-Y', strtotime($tanggal_presensi)) }}	{{ $nama_hari }}	{{ $ket_jam_kerja }}	{{ $ket_jam_in }}	{{ $ket_jam_out }}	{!! $ket_istirahat !!}	@if(isset($d) && (isset($d->status_potongan) || isset($d->denda))) @endif {{ $ket_status }}	{!! $ket_terlambat !!}	{{ $denda != 0 ? formatAngka($denda) : '' }}	{{ $potongan_jam != 0 ? formatAngkaDesimal($potongan_jam) : '' }}	{{ $jml_jam_lembur != 0 ? formatAngkaDesimal($jml_jam_lembur) : '' }}