@php
use Carbon\Carbon;

$startOfYear = Carbon::createFromDate(null, 1, 1); // January 1 of the current year
$today = Carbon::today(); // Current date
$daysSinceStartOfYear = (int) $startOfYear->diffInDays($today) + 1; // Add 1 to include today
@endphp

@foreach ($employees as $attendance)
<tr>
    @php

    $total_present = count(
    $user_attandances->filter(function ($item) use ($attendance) {
    return $item['user_id'] == $attendance['user']['id'] && $item->attendance_type_id == '1';
    }),
    );
    $total_late = count(
    $user_attandances->filter(function ($item) use ($attendance) {
    return $item['user_id'] == $attendance['user']['id'] && $item->attendance_type_id == '4';
    }),
    );
    $total_absent = count(
    $user_attandances->filter(function ($item) use ($attendance) {
    return $item['user_id'] == $attendance['user']['id'] && $item->attendance_type_id == '2';
    }),
    );
    @endphp
    <!-- Username -->
    <td>
        {{ optional($attendance->user)->username ?? 'N/A' }}
    </td>

    <!-- Attendance Status -->
    <td>
        @if ($attendance->attendances->isNotEmpty())
        <!-- Show today's attendance status -->
        @php
        $todayAttendance = $attendance->attendances->first(); // Get the first attendance for today
        @endphp

        @if ($todayAttendance->attendance_status == 1)
        Pending
        @elseif($todayAttendance->attendance_status == 2)
        Approved
        @elseif($todayAttendance->attendance_status == 3)
        Cancelled
        @else
        N/A
        @endif
        @else
        N/A
        <!-- Show N/A if no attendance for today -->
        @endif
    </td>


    <!-- Attendance Date, In time, and Out time -->
    <td>
        <!-- Attendance Date -->
        <span class="d-block mb-1">
            <strong>Date:</strong>
            {{ $attendance['attendance_date'] ? date('Y-m-d', strtotime($attendance['attendance_date'])) : date('Y-m-d') }}
            <!-- Format the date to Y-m-d and show today's date by default if attendance_date is null -->
        </span>

        <!-- In Time -->
        <span class="d-block mb-1">
            <strong>In:</strong>
            @if ($attendance->attendances->isNotEmpty())
            @php
            $todayAttendance = $attendance->attendances->first();
            @endphp
            <!-- Show In Time -->
            @if ($todayAttendance->intime)
            {{ date('g:i A', strtotime($todayAttendance->intime)) }}
            @else
            N/A
            @endif
            @else
            N/A
            <!-- Show N/A if no attendance for today -->
            @endif
        </span>

        <!-- Out Time -->
        <span class="d-block">
            <strong>Out:</strong>
            @if ($attendance->attendances->isNotEmpty())
            @php
            $todayAttendance = $attendance->attendances->first();
            @endphp
            @if ($todayAttendance->outime)
            {{ date('g:i A', strtotime($todayAttendance->outime)) }}
            @else
            N/A
            <!-- Show N/A if outime is not set -->
            @endif
            @else
            N/A
            <!-- Show N/A if no attendance for today -->
            @endif
        </span>
    </td>

    <td>
        Present: {{ $total_present ?? 'N/A' }}<br>
        Absent: {{ $total_absent ?? 'N/A' }} <br> <!-- Show N/A if summary is missing -->
        Late: {{ $total_late ?? 'N/A' }} <!-- Show N/A if summary is missing -->
    </td>

    <td>{{ $daysSinceStartOfYear ?? 'N/A' }}</td>

    <!-- Actions -->
    <td>
        <div class="d-flex align-items-center">
            <!-- Add attendance button -->
            {{-- <a href="{{ route('user_attendances.create') }}" class="nav-link me-2" id="add" data-userid="{{ optional($attendance->user)->id }}" data-bs-toggle="modal" data-bs-target="#addModal">
            <i class="fa fa-lg fa-edit text-primary"></i>
            </a> --}}

            <!-- Attendance report button -->
            @if (optional($attendance->user)->id)
            <a href="{{ route('hrm.report.user_attendance_report.monthly',['employee_user_id'=>$attendance['user']['id']]) }}">
                <i class="fa fa-edit text-primary"></i>
            </a>
            @else
            <span>No User ID</span> <!-- Show message or avoid rendering the link if there's no user -->
            @endif
        </div>
    </td>
</tr>
@endforeach