@extends('layouts.app', ['title' => 'Urlaubskonten'])
@section('content')

@php
function secondsToTime($totalSeconds) {
    $sign = $totalSeconds < 0 ? '-' : '';
    $totalSeconds = abs($totalSeconds);
    $hours = floor($totalSeconds / 3600);
    $minutes = floor(($totalSeconds % 3600) / 60);
    return $sign . sprintf('%02d:%02d', $hours, $minutes);
}
function hoursToSeconds($hours) { return $hours * 3600; }
function convertDecimalToHHMM($decimalHours) {
    $decimalHours = str_replace(',', '.', $decimalHours);
    $isNegative = $decimalHours < 0;
    $decimalHours = abs($decimalHours);
    $hours = floor($decimalHours);
    $minutes = ($decimalHours - $hours) * 60;
    $result = sprintf('%02d:%02d', $hours, $minutes);
    return $isNegative ? '-' . $result : $result;
}
function convertHMToHours($time) {
    [$hours, $minutes] = explode(':', $time);
    return str_replace('.', ',', number_format($hours + $minutes / 60, 2));
}
function convertSecondsToHours($seconds) {
    return str_replace('.', ',', number_format($seconds / 3600, 2));
}
@endphp

<div class="container-fluid py-4" style="max-width:1200px;">

    {{-- Header --}}
    <div class="d-flex align-items-center justify-content-between mb-4">
        <h4 class="fw-bold mb-0">
            <i class="bi bi-calendar-check me-2 text-primary"></i>Urlaubskonten
        </h4>
    </div>

    {{-- Tabelle --}}
    <div class="card border-0 shadow-sm">
        <div class="card-body p-0">
            <table class="table table-hover align-middle mb-0" style="font-size:0.82rem;">
                <thead class="table-light">
                    <tr>
                        <th class="ps-3">Mitarbeiter</th>
                        <th class="text-center">Vorjahr</th>
                        <th class="text-center">Anspruch</th>
                        <th class="text-center">Genommen</th>
                        <th class="text-center pe-3">Rest</th>
                    </tr>
                </thead>
                <tbody>
                    @php $groupedEmployees = $employees->pluck('fk_employee_id')->unique(); @endphp
                    @foreach($department as $item)
                        <tr class="table-secondary">
                            <td colspan="5" class="ps-3 fw-semibold small text-uppercase text-muted py-2">
                                <i class="bi bi-building me-1"></i>{{ $item->name }}
                            </td>
                        </tr>
                        @php
                            $startDate = Carbon\Carbon::parse($ddate)->startOfMonth();
                            $endDate   = Carbon\Carbon::parse($ddate)->endOfMonth();
                        @endphp
                        @foreach($item->get_employee->where('has_time_recording', '1') as $iteme)
                            @if($iteme->contract && $iteme->contract->get_days)
                                @php
                                    $got_vacations = 0;
                                    for (
                                        $start = Carbon\Carbon::parse('2025-01')->startOfMonth();
                                        $start <= Carbon\Carbon::parse($ddate)->endOfMonth();
                                        $start->addDay()
                                    ) {
                                        $isVacationDay = $Vacations
                                            ->where('is_accepted', '1')
                                            ->where('fk_employee_id', $iteme->employee_id)
                                            ->where('date_from', '<=', $start->toDateString())
                                            ->where('date_to', '>=', $start->toDateString())
                                            ->count();
                                        $isWorkDay = $iteme->contract->get_days[strtolower($start->format('l'))] > 0;
                                        $isHoliday = in_array($start->toDateString(), $holidays->pluck('date')->toArray());
                                        if ($isVacationDay && $isWorkDay && !$isHoliday) { $got_vacations += 1; }
                                    }
                                    $vorjahr   = $iteme->contract->get_days->last_year_vacation_rest;
                                    $anspruch  = $iteme->contract->get_days->vacation_entitlement;
                                    $rest      = $vorjahr + $anspruch - $got_vacations;
                                @endphp
                                <tr>
                                    <td class="ps-3">
                                        <a href="{{ route('hrm.employee.timerecords', ['id' => $iteme->employee_id]) }}"
                                            target="_blank" class="text-decoration-none fw-semibold">
                                            {{ $iteme->first_name }} {{ $iteme->last_name }}
                                        </a>
                                    </td>
                                    <td class="text-center text-muted">{{ $vorjahr }} T</td>
                                    <td class="text-center text-muted">{{ $anspruch }} T</td>
                                    <td class="text-center">{{ $got_vacations }} T</td>
                                    <td class="text-center pe-3">
                                        @if($rest > 5)
                                            <span class="badge bg-success rounded-pill">{{ $rest }} T</span>
                                        @elseif($rest > 0)
                                            <span class="badge bg-warning text-dark rounded-pill">{{ $rest }} T</span>
                                        @else
                                            <span class="badge bg-danger rounded-pill">{{ $rest }} T</span>
                                        @endif
                                    </td>
                                </tr>
                            @else
                                <tr>
                                    <td class="ps-3 fw-semibold">{{ $iteme->first_name }} {{ $iteme->last_name }}</td>
                                    <td colspan="4" class="text-muted" style="font-size:.78rem;">Kein Vertrag angelegt</td>
                                </tr>
                            @endif
                        @endforeach
                    @endforeach
                </tbody>
            </table>
        </div>
    </div>

</div>

@endsection