@extends('layouts.user_type.auth')

@section('content')
<style>

.employee_col_sticky {
    position: sticky !important;
    inline-size: 70px;
    inset-inline-start: 0;
    z-index: 1 !important;
    background-color: #ffffff;
    inline-size: 300px;
    min-inline-size: 300px;
}

.employee_th_sticky {
    inline-size: 70px;
    inset-inline-start: 0;
    z-index: 2 !important;
    background-color: #ffffff;
    inline-size: 300px;
    min-inline-size: 300px;
}

tbody .employee_col_sticky {
    background-color: #ffffff; /* Background for body rows */
}

thead .employee_col_sticky {
    background-color: #ffffff; /* Background for body rows */
}
    /* Common styles for attendance letters */
.attendance-cell {
    block-size: 30px;
    display: block;
    border-block-end: 2px solid;
    text-align: center;
    line-height: 12px;
    font-size: var(--fontSz12);
    text-transform: capitalize;
    padding-block-start: 10px;
    border-block-start: none;
    border-inline-end: none;
    border-inline-start: none;
    border-radius: 0px;
    text-align: center;
    margin: 0px auto;
}

.P {
    border-color: #b2d7ad !important;
}

.A {
    border-color: #f0989a !important;
}

.W {
    border-color: #ffe5a3 !important;
}

.H {
    border-color: #80c7e0 !important;
}

.CL {
    border-color: #D98911 !important;
}

.PL {
    border-color: #D98911 !important;
}

.SL {
    border-color: #D98911 !important;
}

.HD {
    border-color: #D98911 !important;
}

/* Future Dates - Show "-" without underline */
.dash {
    color: gray;
    text-decoration: none;
}

.table-responsive {
    max-height: 70vh;
    overflow-y: auto;
}

.RRC {
    border-color: #9c6ade !important; /* Purple border */
}

.table_fixed > thead > tr > th {
    position: sticky !important;
    inset-block-start: 0;
    /* z-index: 1 !important; */
    /* background-color: #ffffff; */
    padding-inline-start: 10px;
}

</style>
<div class="container-fluid">
    <div class="d-flex justify-content-between align-items-center mb-3">
        <h4>Employees Worked Hours - {{ \Carbon\Carbon::parse($month)->format('M Y') }}</h4>
        <div>
            <button class="btn btn-primary" id="prevMonth">←</button>
            <button class="btn btn-primary" id="nextMonth">→</button>
            <a href="{{ route('attendance.downloadWorkedHours', ['month' => $month]) }}" class="btn btn-success">Download XLS</a>
            <a href="{{ route('attendance.organization', ['month' => $month]) }}" class="btn btn-outline-primary">Attendance</a>
        </div>
    </div>

    <div class="table-responsive">
        <table class="table table-bordered text-center table_fixed">
            <thead class="thead-dark">
                <tr>
                    <th class="employee_th_sticky" style="max-width:300px;width:300px;">Employee</th>
                    @for ($i = 1; $i <= $daysInMonth; $i++)
                        @php
                            $date = \Carbon\Carbon::parse("$month-$i");
                        @endphp
                        <th>
                            {{ $date->format('M d') }} <br>
                            <span class="small">{{ $date->format('D') }}</span>
                        </th>
                    @endfor
                </tr>
            </thead>
            <tbody>
                @foreach ($employees as $employee)
                    <tr>
                        <td class="employee_col_sticky" style="max-width:300px;width:300px;height:57px;">
                            <!-- <img src="{{ asset('storage/' . $employee->passport_size_photo ?? 'assets/img/user.png') }}" class="rounded-circle me-2" width="30" height="30"> -->
                            {{ $employee->name ?? ($employee->first_name . ($employee->middle_name ? ' ' . $employee->middle_name : '') . ' ' . $employee->last_name) }}
                        </td>
                        @for ($i = 1; $i <= $daysInMonth; $i++)
                            @php
                                $date = \Carbon\Carbon::parse("$month-$i");
                                $formattedDate = $date->format('Y-m-d');
                                $isSunday = $date->isSunday();
                                $isFutureDate = $date->greaterThan(\Carbon\Carbon::today());
                                $isHoliday = in_array($formattedDate, $holidays);

                                // Check if employee is on leave
                                $leave = $employee->leaves->first(function ($leave) use ($formattedDate) {
                                    return $formattedDate >= $leave->start_date && $formattedDate <= $leave->end_date;
                                });

                                $attendancesForDay = $employee->attendances
                                    ->filter(function ($att) use ($formattedDate) {
                                        return \Carbon\Carbon::parse($att->check_in)->format('Y-m-d') === $formattedDate;
                                    });

                                $firstCheckIn = $attendancesForDay->min('check_in');
                                $lastCheckOut = $attendancesForDay->max('check_out');

                                $hasAttendance = $firstCheckIn !== null;

                                if ($isHoliday) {
                                    $status = 'H';
                                } elseif ($leave) {
                                    // Check if it is a half-day leave
                                    if ($leave->half_day) {
                                        $status = 'HD';
                                    } else {
                                        $status = $leave->leaveType->name ?? 'L';
                                    }
                                } elseif ($isSunday) {
                                    $status = 'W';
                                } elseif ($isFutureDate) {
                                    $status = '-';
                                } else {
                                    $status = $attendancesForDay->isNotEmpty() ? 'P' : 'A';
                                }
                            @endphp
                            <td style="max-width:300px;">
                                @if ($status === 'P' && $hasAttendance)
                                    @php
                                        $workedMinutes = 0;
                                        $absentFlag = false;

                                        foreach ($attendancesForDay as $att) {
                                            if ($att->check_in && $att->check_out) {
                                                $checkIn = \Carbon\Carbon::parse($att->check_in);
                                                $checkOut = \Carbon\Carbon::parse($att->check_out);

                                                // ✅ Handle cross-midnight checkout
                                                if ($checkOut->lessThan($checkIn)) {
                                                    $checkOut->addDay();
                                                }

                                                $workedMinutes += $checkIn->diffInMinutes($checkOut);
                                            } else {
                                                // 🚫 If any record has missing checkout, mark as absent
                                                $absentFlag = true;
                                                break;
                                            }
                                        }

                                        $workedHoursFormatted = (!$absentFlag && $workedMinutes > 0)
                                            ? sprintf('%02d:%02d', floor($workedMinutes / 60), $workedMinutes % 60)
                                            : 'Absent';
                                    @endphp

                                    @if ($workedHoursFormatted !== 'Absent')
                                        <span class="attendance-cell {{ $status }}">
                                            {{ $workedHoursFormatted }} <small>(H:M)</small>
                                        </span>
                                    @else
                                        <span class="attendance-cell {{ $status }}">{{ $workedHoursFormatted }}</span>
                                    @endif
                                @else
                                    @php
                                        // Check for Regularization (only if status was A)
                                        if ($status === 'A') {
                                            $regularized = $employee->regularizations->first(function ($reg) use ($formattedDate) {
                                                return $reg->date === $formattedDate && $reg->status === 'Pending';
                                            });

                                            if ($regularized) {
                                                $status = 'RRC';
                                            }
                                        }
                                    @endphp
                                    <span class="attendance-cell {{ $status }}">{{ $status }}</span>
                                @endif
                            </td>
                        @endfor
                    </tr>
                @endforeach
            </tbody>
        </table>
    </div>

    <div class="mt-3">
        <strong>Legend:</strong>
        <span class="text-success">P = Present</span> | 
        <span class="text-danger">A = Absent</span> | 
        <span class="text-warning">CL = Casual Leave</span> | 
        <span class="text-primary">SL = Sick Leave</span> | 
        <span class="text-info">PL = Paid Leave</span> |
        <span class="text-primary">W = Weekend</span> | 
        <span class="text-info">H = Holiday</span> |
        <span class="text-success">RRC = Regularization Request Created</span>
    </div>
</div>

<script>
document.getElementById('prevMonth').addEventListener('click', function() {
    let month = new Date('{{ $month }}-01');
    month.setMonth(month.getMonth() - 1);
    window.location.href = '?month=' + month.toISOString().slice(0,7);
});

document.getElementById('nextMonth').addEventListener('click', function() {
    let month = new Date('{{ $month }}-01');
    month.setMonth(month.getMonth() + 1);
    window.location.href = '?month=' + month.toISOString().slice(0,7);
});
</script>

@endsection