@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 ($students as $attendance)
<tr>
    @php

    if (!isset($attendance['user']['id'])) {
    $total_present = $total_late = $total_absent = 0;
    } else {
    $user_id = $attendance['user']['id'];

    $total_present = count(
    $user_attandances->filter(function ($item) use ($user_id) {
    return $item['user_id'] == $user_id && $item->attendance_type_id == '1';
    })
    );

    $total_late = count(
    $user_attandances->filter(function ($item) use ($user_id) {
    return $item['user_id'] == $user_id && $item->attendance_type_id == '4';
    })
    );

    $total_absent = count(
    $user_attandances->filter(function ($item) use ($user_id) {
    return $item['user_id'] == $user_id && $item->attendance_type_id == '2';
    })
    );
    }

    @endphp
    <!-- Username -->
    <td>{{ $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>

    </td>

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

    <!-- Total Working Days for the Selected Month -->
    <td>{{ $daysSinceStartOfYear." days" ?? 'N/A' }}</td>
    <!-- Show N/A if working days summary is missing -->

    <!-- 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="{{ $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 -->
            <!-- Attendance report button -->
            @if (isset($attendance['user']['id']))
            <a href="{{ route('hrm.report.user_attendance_report.monthly',["student_user_id"=>$attendance['user']['id']]) }}">
                <i class="fa fa-edit text-primary"></i> <!-- Adjust the size using fa-2x for a larger icon -->
            </a>

            @endif

        </div>
    </td>
</tr>
@endforeach