Attendance Sheet - {{ \Carbon\Carbon::create($year, $month)->format('F Y') }}

@foreach ($grouped as $employeeId => $data) @foreach ($dates as $date) @php $record = $data['records'][$date] ?? null; $dayOfWeek = \Carbon\Carbon::parse($date)->format('l'); $isWeekend = in_array($dayOfWeek, ['Saturday', 'Sunday']); $isHoliday = isset($holidays[$date]); $holidayName = $isHoliday ? $holidays[$date] : null; $status = strtolower($record['status'] ?? ''); @endphp @endforeach @endforeach

Employee	Date	Status	Check-In	Check-Out
{{ $data['name'] }}	@if ($isWeekend) Weekend ({{ $dayOfWeek }}) @elseif($isHoliday) Holiday {{ $holidayName }} @else {{ \Carbon\Carbon::parse($date)->format('d M Y (D)') }} @endif	{{ $isWeekend ? 'Weekend' : ($isHoliday ? $holidayName : ($status ?: 'Absent')) }}	{{ $record['check_in'] ?? '' }}	{{ $record['check_out'] ?? '' }}