| {{ $index + 1 }} |
{{ $employee->employee_code }} |
{{ $employee->name }} |
{{ optional($employee->subDepartment)->name }} |
@foreach($dateList as $date)
@php
$day = $attendanceSummary[$date] ?? null;
$status = '-';
if ($day) {
$first = strtoupper(trim($day->first_half_status));
$second = strtoupper(trim($day->second_half_status));
if ($first === 'A' && $second === 'A') {
$status = 'A';
} elseif (in_array($day->on_duty, [2, 3, 4])) {
$status = $day->status ?? '-';
} elseif (
($first === 'P' || $first === 'HD') ||
($second === 'P' || $second === 'HD')
) {
$status = 'P';
} else {
$status = $day->status ?? '-';
}
if ($status === 'POH') {
$status = 'HP';
}
// Totals
$totals['present'] += $day->total_present ?? 0;
$totals['absent'] += $day->total_absent ?? 0;
$totals['leave'] += $day->total_leave ?? 0;
$totals['week_off'] += $day->total_week_off ?? 0;
$totals['holiday'] += $day->total_national_holiday ?? 0;
$totals['night'] += $day->total_night_shift ?? 0;
$totals['total_holiday'] += $day->total_holiday ?? 0;
}
$totalDays = \Carbon\Carbon::parse($startDate)
->diffInDays(\Carbon\Carbon::parse($endDate)) + 1;
@endphp
{{ $status }} |
@endforeach
{{ $totals['present'] }} |
{{ $totals['absent'] }} |
{{ $totals['leave'] }} |
{{ $totals['week_off'] }} |
{{ $totals['holiday'] }} |
{{ $totals['total_holiday'] }} |
{{ $totals['present']
+ $totals['leave']
+ $totals['week_off']
+ $totals['total_holiday']
}}
|
{{ $totalDays }} |
{{ $totals['night'] }} |
{{ $employee->od_count?? 0 }} |
@endforeach