@once @endonce @php $detailRows = is_array($detailRows ?? null) ? $detailRows : []; $detailOtColumns = is_array($detailOtColumns ?? null) ? $detailOtColumns : []; $detailProfil = $detailProfil ?? $profil ?? null; $publicView = (bool) ($publicView ?? false); $paymentView = !$publicView && request()->query('view') === 'payment'; $hidePaymentModeButton = (bool) ($hidePaymentModeButton ?? false); $paymentHourlyRate = (float) ($paymentHourlyRate ?? 0); $paymentOvertimeRate = (float) ($paymentOvertimeRate ?? 0); $segmentView = request()->query('view', 'segment') !== 'legacy'; $segmentAutoOtEnabled = collect($detailRows)->contains(fn ($row) => (bool) ($row['auto_ot_without_spl'] ?? false)); $dayTypeLabelResolver = static fn (string $dayType): string => match ($dayType) { 'holiday_special' => 'Holiday Special', 'holiday' => 'Holiday', 'weekend' => 'Weekend', default => 'Workday', }; $specialPaymentModeLabelResolver = static fn (?string $mode): string => match (strtolower(trim((string) $mode))) { 'payroll' => 'Gabung Payroll', 'separate' => 'Bayar Terpisah', default => '-', }; $emergencyBaselineLabelResolver = static fn (?string $mode): string => match (strtolower(trim((string) $mode))) { 'after_normal_shift' => 'Setelah jam normal selesai', 'after_normal_or_existing_ot' => 'Setelah jam normal / OT existing selesai', default => trim((string) $mode) !== '' ? trim((string) $mode) : '-', }; $emergencyMultiplierLabelResolver = static fn (?string $profile): string => match (strtolower(trim((string) $profile))) { 'default' => 'Default Emergency x2', default => trim((string) $profile) !== '' ? trim((string) $profile) : '-', }; $workTargetBonusSourceLabelResolver = static fn (?string $source): string => match (strtolower(trim((string) $source))) { 'manual_override' => 'Override manual', 'remaining_target' => 'Sisa target aktual', default => trim((string) $source) !== '' ? trim((string) $source) : '-', }; $dayTypeRowClassResolver = static fn (string $dayType): string => match ($dayType) { 'holiday_special' => 'row-holiday-special', 'holiday' => 'row-holiday', 'weekend' => 'row-weekend', default => '', }; $isHolidayLikeDayType = static fn (string $dayType): bool => in_array($dayType, ['holiday', 'holiday_special'], true); $sumPlannedHours = 0.0; $sumActualEffectiveDisplay = 0.0; $sumNormalHours = 0.0; $sumHk = 0.0; $prorataPeriodWorkdayHk = 0; $prorataAbsentWorkdayHk = 0; $prorataHolidayWeekday = 0; $prorataCuti = 0; $prorataSakit = 0; $payableLeaveDays = 0; $payableLeaveHours = 0.0; $prorataIzin = 0; $prorataAlpha = 0; $realizedRecognizedHours = 0.0; $realizedTargetHours = 0.0; $jamTdkMasuk = 0.0; $sumOvertime = 0.0; $sumWeightedOvertime = 0.0; $otTotals = []; $sumOvertimeBefore = 0.0; $sumOvertimeBeforeWeighted = 0.0; $sumOvertimeAfter = 0.0; $sumNoRest1Hours = 0.0; $sumNoRest2Hours = 0.0; $detailPayrollBasis = is_array($payrollBasis ?? null) ? $payrollBasis : []; $isDailySalaryOverride = (bool) ($isDailySalaryOverride ?? false); $detailPayrollSettings = is_array($detailProfil?->payroll_settings ?? null) ? (array) $detailProfil->payroll_settings : []; $isProrataSalary = (bool) ($detailPayrollSettings['prorata_salary'] ?? false); $hkHoursPerDay = (float) ($detailPayrollBasis['hours_per_day'] ?? ($detailProfil->jam_per_hari ?? 8)); $hkBaseHours = (float) ($detailPayrollBasis['monthly_hour_base'] ?? (((float) ($detailProfil->hk_basis ?? 21)) * $hkHoursPerDay)); $hkBasis = $hkHoursPerDay > 0 ? ($hkBaseHours / $hkHoursPerDay) : (float) ($detailProfil->hk_basis ?? 21); $basisProfileLabel = trim((string) ($detailPayrollBasis['profil_gaji_code'] ?? '') . ' - ' . (string) ($detailPayrollBasis['profil_gaji_name'] ?? ''), ' -'); $fmt = function ($v) { return number_format((float) $v, 2, ',', '.'); }; $prorateSummaryLabel = $isProrataSalary ? 'HK Efektif Payroll Periode' : ($isDailySalaryOverride ? 'Prorate Hari' : 'Proyeksi Jam Masuk Normal Periode (' . $fmt($hkBaseHours) . ' - Total Jam Kurang Periode)'); $prorateSmallLabel = $isProrataSalary ? 'HK periode prorata' : ($isDailySalaryOverride ? 'Prorate hari' : 'Jam normal'); $resolveAttendanceDayCredit = static fn (array $detailRow, float $hkHoursPerDay, $profil): array => \App\Modules\AttendanceReview\Services\AttendanceDayCreditResolver::resolve($detailRow, $profil, $hkHoursPerDay); $realizedCutoffDate = \Carbon\Carbon::today(config('app.timezone'))->subDay()->toDateString(); $isRosterDetail = collect($detailRows)->contains(fn ($row) => in_array(strtolower(trim((string) ($row['schedule_badge_label'] ?? ''))), ['shift', 'off', 'belum ada shift'], true)); // Use the same payable gate as payroll: approved SPL or the matching auto-OT rule. $isOvertimeAuthorized = static function (array $row, string $segment): bool { return (bool) ($row['spl_approved'] ?? false) || (bool) ($row['auto_overtime_' . $segment] ?? $row['auto_ot_without_spl'] ?? false); }; $isNoRestAuthorized = static function (array $row, string $segment): bool { return (bool) ($row['spl_approved'] ?? false) || (bool) ($row['auto_no_rest_' . $segment] ?? false); }; $payrollEligibleDetailRows = $paymentView ? collect($detailRows)->filter(fn ($row) => (bool) ($row['is_approved'] ?? false) || (bool) ($row['leave_is_payable'] ?? false))->values()->all() : $detailRows; foreach ($payrollEligibleDetailRows as $row) { $sumPlannedHours += (float) ($row['planned_hours'] ?? 0); $summaryDayType = (string) ($row['day_type'] ?? 'workday'); $summaryIn = trim((string) ($row['in_time'] ?? '-')); $summaryOut = trim((string) ($row['out_time'] ?? '-')); $summaryHasActual = $summaryIn !== '' && $summaryIn !== '-' && $summaryOut !== '' && $summaryOut !== '-'; $summaryPlannedSpan = 0.0; if (in_array($summaryDayType, ['holiday', 'holiday_special', 'weekend'], true) && ($row['planned_in_time'] ?? '-') !== '-' && ($row['planned_out_time'] ?? '-') !== '-') { $summaryPlannedSpan = (float) (strtotime((string) $row['planned_out_time']) - strtotime((string) $row['planned_in_time'])) / 3600; if ($summaryPlannedSpan < 0) $summaryPlannedSpan += 24; } $summarySourceHours = $summaryDayType === 'weekend' && $summaryPlannedSpan > 0 ? $summaryPlannedSpan : (in_array($summaryDayType, ['holiday', 'holiday_special', 'weekend'], true) && (float) ($row['overtime_hours_gross'] ?? 0) > 0 ? (float) $row['overtime_hours_gross'] : (float) ($row['actual_hours'] ?? 0)); $sumActualEffectiveDisplay += max(0.0, $summarySourceHours - (($summaryHasActual && $summarySourceHours > 0) ? (float) ($row['break_hours'] ?? 0) : 0.0)); $sumNormalHours += (float) ($row['normal_hours'] ?? 0); $rowSpecialCode = strtolower((string) ($row['special_overtime_code'] ?? '')); $rowSpecialMode = strtolower((string) ($row['special_overtime_mode'] ?? '')); $isCarryBonusRow = $rowSpecialCode === 'continues_work_day' && str_contains($rowSpecialMode, 'carry'); if (!$isCarryBonusRow) { $beforeHoursRow = $isOvertimeAuthorized((array) $row, 'before') ? max(0.0, (float) ($row['overtime_before_hours'] ?? 0)) : 0.0; $beforeWeightedRow = $isOvertimeAuthorized((array) $row, 'before') ? max(0.0, (float) ($row['overtime_before_weighted_hours'] ?? 0)) : 0.0; $afterHoursRow = $isOvertimeAuthorized((array) $row, 'after') ? max(0.0, (float) ($row['overtime_after_hours'] ?? 0)) : 0.0; $afterWeightedRow = $isOvertimeAuthorized((array) $row, 'after') ? max(0.0, (float) ($row['overtime_after_weighted_hours'] ?? 0)) : 0.0; $noRest1Row = $isNoRestAuthorized((array) $row, '1') ? max(0.0, (float) ($row['no_rest_normal_included_minutes'] ?? 0) / 60) : 0.0; $noRest2Row = $isNoRestAuthorized((array) $row, '2') ? max(0.0, (float) ($row['no_rest_skip_break_minutes'] ?? 0) / 60) : 0.0; $sumOvertime += $beforeHoursRow + $afterHoursRow + $noRest1Row + $noRest2Row; $sumWeightedOvertime += $beforeWeightedRow + $afterWeightedRow + $noRest1Row + $noRest2Row; $sumOvertimeAfter += $afterHoursRow; $sumOvertimeBefore += $beforeHoursRow; $sumOvertimeBeforeWeighted += $beforeWeightedRow; $sumNoRest1Hours += $noRest1Row; $sumNoRest2Hours += $noRest2Row; } if (!empty($row['ot_dynamic']) && is_array($row['ot_dynamic'])) { foreach ($row['ot_dynamic'] as $k => $v) { if (!isset($otTotals[$k])) { $otTotals[$k] = 0.0; } $otTotals[$k] += (float) $v; } } $dayCredit = $resolveAttendanceDayCredit((array) $row, $hkHoursPerDay, $detailProfil); $rowSpecialCode = strtolower((string) ($row['special_overtime_code'] ?? '')); $rowSpecialMode = strtolower((string) ($row['special_overtime_mode'] ?? '')); $isCarryBonusRow = $rowSpecialCode === 'continues_work_day' && str_contains($rowSpecialMode, 'carry'); $rowHkFlag = $isCarryBonusRow ? 1 : (int) ($dayCredit['hk_flag'] ?? 0); $rowHkValue = $isCarryBonusRow ? 1.0 : (float) ($dayCredit['hk_value'] ?? $rowHkFlag); $sumHk += $isProrataSalary ? $rowHkValue : $rowHkFlag; if ($isProrataSalary && (string) ($row['day_type'] ?? 'workday') === 'workday') { $prorataPeriodWorkdayHk++; if ($rowHkFlag !== 1) { $prorataAbsentWorkdayHk++; } } $rowText = strtolower((string) ($row['leave_tag_label'] ?? '') . ' ' . (string) ($row['reason'] ?? '')); if ((bool) ($row['leave_is_payable'] ?? false)) { $payableLeaveDays++; $payableLeaveHours += max(0.0, (float) ($row['planned_hours'] ?? 0)); } if ($isProrataSalary && in_array((string) ($row['day_type'] ?? ''), ['holiday', 'holiday_special'], true) && !in_array(strtolower((string) ($row['day_name'] ?? '')), ['sabtu', 'minggu', 'saturday', 'sunday'], true)) { $prorataHolidayWeekday++; } if ($isProrataSalary && str_contains($rowText, 'cuti')) $prorataCuti++; if ($isProrataSalary && str_contains($rowText, 'sakit')) $prorataSakit++; if ($isProrataSalary && str_contains($rowText, 'izin')) $prorataIzin++; if ($isProrataSalary && (string) ($row['day_type'] ?? '') === 'workday' && (int) ($dayCredit['hk_flag'] ?? 0) !== 1 && !str_contains($rowText, 'cuti') && !str_contains($rowText, 'sakit') && !str_contains($rowText, 'izin')) $prorataAlpha++; if ((string) ($row['work_date'] ?? '') <= $realizedCutoffDate && (int) ($dayCredit['hk_flag'] ?? 0) === 1) { $realizedTargetHours += $hkHoursPerDay; $realizedRecognizedHours += min($hkHoursPerDay, max(0.0, (float) ($dayCredit['recognized_hours'] ?? 0))); } } $totalJamHk = $hkBaseHours; $deficitRows = []; foreach ($detailRows as $row) { $dayCredit = $resolveAttendanceDayCredit((array) $row, $hkHoursPerDay, $detailProfil); if ((int) ($dayCredit['hk_flag'] ?? 0) !== 1 && (float) ($dayCredit['deficit_hours'] ?? 0) <= 0) { continue; } $normalHours = max(0.0, (float) ($dayCredit['recognized_hours'] ?? 0)); $deficitHours = max(0.0, (float) ($dayCredit['deficit_hours'] ?? 0)); if ($deficitHours <= 0) { continue; } $deficitRows[] = [ 'work_date' => (string) ($row['work_date'] ?? '-'), 'day_name' => (string) ($row['day_name'] ?? '-'), 'day_type' => (string) ($row['day_type'] ?? 'workday'), 'leave_tag_label' => (string) ($row['leave_tag_label'] ?? ''), 'normal_hours' => $normalHours, 'deficit_hours' => $deficitHours, 'reason' => (string) ($row['reason'] ?? '-') . (!empty($dayCredit['special_bonus']) ? ' | Bonus HK ContinuesNextDay' : ''), ]; } if ($isProrataSalary && $isRosterDetail) { $rosterOnRows = collect($detailRows)->filter(function ($row): bool { $badge = strtolower(trim((string) ($row['schedule_badge_label'] ?? ''))); return $badge === 'shift' && (float) ($row['planned_hours'] ?? 0) > 0; }); $prorataPeriodWorkdayHk = $rosterOnRows->count(); $hkBasis = (float) $prorataPeriodWorkdayHk; $hkBaseHours = (float) $rosterOnRows->sum(fn ($row) => (float) ($row['planned_hours'] ?? 0)); $hkHoursPerDay = $hkBasis > 0 ? $hkBaseHours / $hkBasis : $hkHoursPerDay; } elseif ($isProrataSalary && $prorataPeriodWorkdayHk > 0) { // Regular employees use calendar workdays; roster employees use scheduled ON days above. $hkBasis = (float) $prorataPeriodWorkdayHk; $hkBaseHours = $hkBasis * $hkHoursPerDay; } $prorataEffectiveBasis = $hkBasis; if ($isProrataSalary) { // Keep the period basis intact; effective HK is shown separately after absence deductions. $prorataEffectiveBasis = $hkBasis; $hkBaseHours = $hkBasis * $hkHoursPerDay; } $totalDeficitHours = collect($deficitRows)->sum('deficit_hours'); $jamTdkMasuk = max(0.0, $totalDeficitHours); $jamMasukNormal = max(0.0, $hkBaseHours - $jamTdkMasuk); $hkMasuk = $isProrataSalary ? max(0.0, (float) $sumHk) : ($hkHoursPerDay > 0 ? $jamMasukNormal / $hkHoursPerDay : 0); if ($isProrataSalary) { $jamMasukNormal = $hkMasuk * $hkHoursPerDay; } $realizedHk = $hkHoursPerDay > 0 ? $realizedRecognizedHours / $hkHoursPerDay : 0; $realizedTargetHk = $hkHoursPerDay > 0 ? $realizedTargetHours / $hkHoursPerDay : 0; $scheduleCounts = collect($detailRows)->countBy(function ($row) { $badge = strtolower(trim((string) ($row['schedule_badge_label'] ?? ''))); return $badge === 'belum ada shift' ? 'waiting' : ($badge === 'off' ? 'off' : 'scheduled'); }); $usesRosterShift = collect($detailRows)->contains(function ($row) { return strtolower(trim((string) ($row['schedule_badge_label'] ?? ''))) === 'shift'; }); $rosterComplete = $usesRosterShift && (int) ($scheduleCounts['waiting'] ?? 0) === 0 && ((int) ($scheduleCounts['scheduled'] ?? 0) + (int) ($scheduleCounts['off'] ?? 0)) === count($detailRows); // NoRest hanya jam break yang benar-benar diberi rule NoRest, bukan sisa OT segment. $noRest1Hours = round($sumNoRest1Hours, 2); $noRest2Hours = round($sumNoRest2Hours, 2); $noRestHours = $noRest1Hours + $noRest2Hours; $afterRawHours = max(0.0, $sumOvertime - $sumOvertimeBefore - $noRestHours); $beforeMultiplier = $sumOvertimeBefore > 0 ? $sumOvertimeBeforeWeighted / $sumOvertimeBefore : 0.0; $afterWeighted = max(0.0, $sumWeightedOvertime - $sumOvertimeBeforeWeighted - $noRestHours); $afterMultiplier = $afterRawHours > 0 ? $afterWeighted / $afterRawHours : 0.0; $totalMultiplier = $sumOvertime > 0 ? $sumWeightedOvertime / $sumOvertime : 0.0; $multiplierLabel = static fn (float $value): string => $value > 0 ? 'x' . number_format($value, 2, ',', '.') : 'x0'; $segmentOtColumns = collect($detailOtColumns)->map(function (array $column) use ($multiplierLabel) { $multiplier = (float) ($column['multiplier'] ?? 0); $key = (string) ($column['key'] ?? $multiplier); $label = trim((string) ($column['label'] ?? '')); if ($label === '') { $label = 'x' . rtrim(rtrim(number_format($multiplier, 2, ',', ''), '0'), ','); } return ['key' => $key, 'multiplier' => $multiplier, 'label' => $multiplierLabel($multiplier)]; })->values()->all(); $segmentTotalBuckets = []; foreach ($segmentOtColumns as $column) { $segmentTotalBuckets[$column['key']] = (float) ($otTotals[$column['key']] ?? 0); } // Daily rounded buckets can differ a few minutes from raw OT total; reconcile on the closest active rule. $bucketDelta = $sumOvertime - array_sum($segmentTotalBuckets); if ($segmentOtColumns !== [] && abs($bucketDelta) > 0.0001) { usort($segmentOtColumns, fn ($left, $right) => abs($left['multiplier'] - $totalMultiplier) <=> abs($right['multiplier'] - $totalMultiplier)); $segmentTotalBuckets[$segmentOtColumns[0]['key']] = max(0.0, ($segmentTotalBuckets[$segmentOtColumns[0]['key']] ?? 0) + $bucketDelta); usort($segmentOtColumns, fn ($left, $right) => $left['multiplier'] <=> $right['multiplier']); } $segmentBeforeBuckets = array_fill_keys(array_column($segmentOtColumns, 'key'), 0.0); $segmentNoRestBuckets = array_fill_keys(array_column($segmentOtColumns, 'key'), 0.0); if ($sumOvertimeBefore > 0 && $segmentOtColumns !== []) { $beforeColumn = collect($segmentOtColumns)->sortBy(fn ($column) => abs($column['multiplier'] - $beforeMultiplier))->first(); $segmentBeforeBuckets[$beforeColumn['key']] = $sumOvertimeBefore; } // NoRest dibayar 1:1 sebagai jam lembur; tidak masuk bucket multiplier OVT Before/After. if ($noRestHours > 0 && $segmentOtColumns !== []) { $noRestColumn = collect($segmentOtColumns)->sortBy(fn ($column) => abs($column['multiplier']))->first(); $segmentTotalBuckets[$noRestColumn['key']] = max(0.0, ($segmentTotalBuckets[$noRestColumn['key']] ?? 0) - $noRestHours); } $segmentAfterBuckets = []; foreach ($segmentOtColumns as $column) { $key = $column['key']; $segmentAfterBuckets[$key] = max(0.0, ($segmentTotalBuckets[$key] ?? 0) - ($segmentBeforeBuckets[$key] ?? 0)); } // Buckets are display-only; total must use the engine's authorized weighted hours. $afterWeighted = round(max(0.0, $sumWeightedOvertime - $sumOvertimeBeforeWeighted - $noRestHours), 2); $ovtTotalWeighted = round($sumOvertimeBeforeWeighted + $afterWeighted, 2); $otCount = count($detailOtColumns); $remainingCols = 4 + $otCount; $totalDetailColumns = 11 + $otCount + ($segmentView ? 2 : 0); $summaryTailCols = max(1, $totalDetailColumns - 8); @endphp @if ($usesRosterShift)
| Tanggal | Jenis | Jam Diakui | Kurang | Penanda |
|---|---|---|---|---|
| {{ $auditRow['work_date'] }} ({{ $auditRow['day_name'] }}) |
{{ ucfirst($auditRow['day_type']) }}
@if ($auditRow['leave_tag_label'] !== '')
{{ $auditRow['leave_tag_label'] }} @endif |
{{ number_format($auditRow['normal_hours'], 2, ',', '.') }} jam | {{ number_format($auditRow['deficit_hours'], 2, ',', '.') }} jam | {!! nl2br(e($auditRow['reason'])) !!} |
| Total Jam Kurang Periode | {{ number_format($totalDeficitHours, 2, ',', '.') }} jam | |||