@php
    use Carbon\Carbon;
@endphp
@if ($attendanceSummary->isEmpty())
    <table>
        <thead class="table-light">
            <tr>
                <th colspan="35" style="text-align: center;">
                    No data available for {{ Carbon::createFromDate($year, $month)->format('F Y') }}
                </th>
            </tr>
        </thead>
    </table>
@else
    <table>
        <thead class="table-light">
            <tr>
                <th></th>
                <th></th>
                <th colspan="31" style="text-align: center">
                    Month of {{ \Carbon\Carbon::createFromDate($year, $month)->format('F Y') }}
                </th>
                <th></th>
                <th></th>
                <th></th>
                <th></th>
            </tr>
            <tr>
                <th>Employee Name</th>
                <th>Designation</th>
                <th>Location</th>
                @php
                    // Safely fetch the days in the month
                    $firstEmployeeAttendance = $attendanceSummary->first();
                    $daysInMonth =
                        $firstEmployeeAttendance && $firstEmployeeAttendance->first()
                            ? $firstEmployeeAttendance->first()->daysInMonth
                            : 0;
                @endphp

                @for ($day = 1; $day <= $daysInMonth; $day++)
                    <th>{{ $day }}</th>
                @endfor
                <th>Present Days</th>
                <th>Absent Days</th>
                <th>Week Offs</th>
                <th>Paid Days</th>
            </tr>
        </thead>
        <tbody>
            @foreach ($attendanceSummary as $employeeAttendances)
                @php
                    $employee = $employeeAttendances->first()->employee;
                @endphp
                <tr>
                    <td>{{ $employee->name ?? '-' }}</td>
                    <td>{{ $employee->designation->name ?? '-' }}</td>
                    <td>{{ $employee->locations->first()->name ?? '-' }}</td>

                    @php $statuses = []; @endphp

                    @for ($day = 1; $day <= $daysInMonth; $day++)
                        @php
                            $date = \Carbon\Carbon::createFromDate($year, $month, $day)->toDateString();
                            $attendance = $employeeAttendances->where('attendance_date', $date)->first();
                        @endphp
                        <td>
                            @php
                                if ($attendance) {
                                    if (
                                        !empty($attendance->in_time) ||
                                        !empty($attendance->out_time)
                                    ) {
                                        $status = 'P'; // Present
                                    } elseif ($attendance->attendance_type === 'week-off') {
                                        $status = 'W'; // Week-off
                                    } elseif ($attendance->attendance_type === 'holiday') {
                                        $status = 'H'; // Holiday
                                    } else {
                                        $status = 'A'; // Absent
                                    }
                                } else {
                                    $status = '-'; // No data
                                }

                                $statuses[] = $status;
                            @endphp

                            {{ $status }}
                        </td>
                    @endfor

                    @php
                        // Calculate present and absent days
                        $presentDays = collect($statuses)->filter(fn($status) => $status === 'P')->count();
                        $absentDays = collect($statuses)->filter(fn($status) => $status === 'A')->count();
                        $weekOffs = collect($statuses)->filter(fn($status) => $status === 'W')->count();
                        $paidDays = $presentDays + $weekOffs;
                    @endphp

                    <td>{{ $presentDays }}</td>
                    <td>{{ $absentDays }}</td>
                    <td>{{ $weekOffs }}</td>
                    <td>{{ $paidDays }}</td>
                </tr>
            @endforeach
        </tbody>
    </table>
@endif