@extends('layouts.app', ['title' => 'Monatlich Übersicht'])
@section('content')
    @php
        // if (!isset($ddate)) {
        // # code...

        // $today = \Carbon\Carbon::now();
        // }
        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)
        {
            $seconds = $hours * 3600;
            return $seconds;
        }
        function convertDecimalToHHMM($decimalHours)
        {
            // Replace comma with dot to handle European decimal format
            $decimalHours = str_replace(',', '.', $decimalHours);

            // Determine if the value is negative
            $isNegative = $decimalHours < 0;

            // Take absolute value for calculation
            $decimalHours = abs($decimalHours);

            // Separate hours and minutes
            $hours = floor($decimalHours);
            $minutes = ($decimalHours - $hours) * 60;

            // Format the result as HH:MM
            $formattedTime = sprintf('%02d:%02d', $hours, $minutes);

            // Add negative sign back if the original value was negative
            if ($isNegative) {
                $formattedTime = '-' . $formattedTime;
            }

            return $formattedTime;
        }
        function convertHMToHours($time)
        {
            // Split the input string by the colon
            [$hours, $minutes] = explode(':', $time);

            // Convert hours and minutes to integers and calculate the total hours as a decimal
            $totalHours = $hours + $minutes / 60;

            // Replace the decimal point with a comma
            $formattedTotalHours = str_replace('.', ',', number_format($totalHours, 2));

            return $formattedTotalHours;
        }
        function convertSecondsToHours($seconds)
        {
            // Convert seconds to hours as a decimal
            $hours = $seconds / 3600;

            // Format the result to have two decimal places and replace the decimal point with a comma
            $formattedHours = str_replace('.', ',', number_format($hours, 2));

            return $formattedHours;
        }

    @endphp
    <div class="row">

        <div class="col">
            <h4 class="bg-white border border-2 p-2 rounded shadow-sm ">HRM - monatliche Übersicht</h4>
        </div>




    </div>
    <br>
    <div class="container-fluid bg-white px-3   border rounded p-1">
        <div class="row">

            <div class="col-2 ">

                <h6 class=" "> Zeiterfassung aus:</h6>
            </div>
            <div class="col ">

                @foreach ($months as $item)
                    @if ($item->year > 2024)
                        <a name="" id="" class="btn btn-secondary btn-sm"
                            href="{{ route('hrm.monthlyoverview.department', ['date' => $item->year . '-' . $item->month]) }}"
                            role="button">{{ Carbon\Carbon::create()->day(1)->month($item->month)->format('m.') }}{{ $item->year }}
                        </a>
                    @endif
                @endforeach
            </div>




        </div>
    </div>



    <br>

    <div class="container-fluid bg-white px-3   border rounded p-1">
        @php

            $startDate = Carbon\Carbon::parse($ddate)->startOfMonth();
            $endDate = Carbon\Carbon::parse($ddate)->endOfMonth();

            // Prüfen ob Vormonat AZK hat
            $hasPrevAzK = isset($hr_workTimeAccounts) && $hr_workTimeAccounts->count() > 0;

        @endphp
        <h4 class="text-center"> Zeitraum: {{ $startDate->format('d.m.Y') }} -
            {{ $endDate->format('d.m.Y') }}</h4>


        {{-- ⚠️ Hinweis, wenn der Vormonat kein AZK hat --}}
        @if (!$hasPrevAzK)
            <div class="alert alert-warning text-center">
                Für den Vormonat ({{ $ddate->copy()->subMonth()->format('m.Y') }})
                existiert <b>kein AZK-Konto</b>.<br>
                Es wird automatisch mit einem <b>Startsaldo von 0 Stunden</b> gerechnet.
            </div>
        @endif

        {{-- 🟢 Monat wurde bereits festgeschrieben --}}
        @if ($isFixed)
            <div class="alert alert-success text-center">
                Für diesen Monat wurde die AZK <b>bereits festgeschrieben</b>.<br>

            </div>

            {{-- 🔵 Monat wurde NOCH NICHT festgeschrieben --}}
        @else
            <div class="alert alert-info text-center">
                Für diesen Monat wurde die AZK <b>noch nicht festgeschrieben</b>.

            </div>
        @endif


        <div class="row mt-1">

            <div class="col ">
                @php
                    $work_days = 0;

                    for (
                        $start = Carbon\Carbon::parse($ddate)->startOfMonth();
                        $start <= Carbon\Carbon::parse($ddate)->endOfMonth();
                        $start->addDay()
                    ) {
                        if (!in_array($start->isoFormat('dd'), ['Sa', 'So'])) {
                            if ($holidays->where('date', $start->toDateString())->count() <= 0) {
                                # code...
                                $work_days += 1;
                            }
                        }
                    }
                @endphp

                Arbeitstage: {{ $work_days }} | Feirtage:
                {{ $holidays->whereBetween('date', [$ddate->startOfMonth()->format('Y-m-d'), $ddate->endOfMonth()->format('Y-m-d')])->count() }}
            </div>




        </div>

        <hr>
        <table class="table table-bordered table-hover ">
            <thead>
                <tr class="small">
                    <th class="col-2 text-center">Mitarbeiter</th>

                    <th class="col-1  text-center">
                        <div class="row justify-content-center align-items-center ">
                            <div class="col-12">Arbeitstage</div>
                            <div class="col-12"><small class="text-muted">soll / ist</small></div>

                        </div>

                    </th>
                    <th class="col-1  text-center">Krank</th>
                    <th class="col-3  text-center ">
                        <div class="row justify-content-center align-items-center p-0">
                            <div class="col-12">Urlaub</div>


                        </div>
                        <div class="row  justify-content-center align-items-center">
                            <div class="col text-muted border-end small">
                                VJ Url. üb.
                            </div>
                            <div class="col  text-muted  border-end small">
                                Url. Anspr.
                            </div>
                            <div class="col  border-end small">

                                Url.Tg.gen.
                            </div>

                            <div class="col small">Rest</div>
                        </div>
                        <div class="row justify-content-center align-items-center ">
                            <div class="col  border-top mx-2"><small>Urlaubstage diesen Monat</small>

                            </div>

                        </div>

                    </th>
                    <th class="col  text-center">soll</th>
                    <th class="col  text-center">ist</th>
                    <th class="col  text-center">AZK Vormonat</th>
                    <th class="col  text-center">AZK aktuell</th>


                    {{-- <th class="col-1">Beginn</th>
                    <th class="col-1">Ende</th>
                    <th class="col-1">Arbeitsschichten</th>
                    <th class="col-1">Pausen</th>
                    <th class="col-1">Pause</th>
                    <th class="col-1">Soll</th>
                    <th class="col-1">Ist</th>
                    <th class="col-2">Notiz</th> --}}

                </tr>
            </thead>


            <tbody>
                @php
                    // Group employees by 'fk_emp_id' and get unique items
                    $groupedEmployees = $employees->pluck('fk_employee_id')->unique();
                @endphp

                @foreach ($department as $item)
                    <tr class="bg-opacity-25 bg-secondary">
                        <td colspan="100%" class="small text-center"><b>{{ $item->name }}
                                {{-- {{ $groupedEmployees->whereIn('fk_employee_id', $item->get_employee->pluck('employee_id'))->count() }} --}}
                                {{-- {{ $HrTimeRecordingToday->pluck('fk_employee_id')->unique()->whereIn('fk_employee_id', $item->get_employee->pluck('employee_id'))->count() }} --}}

                                {{-- /
                                {{ $item->get_employee->count() }}</b> --}}
                            </b>
                        </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) --}}
                    @foreach ($item->get_employee as $iteme)
                        @if ($hrtimerecords->where('fk_employee_id', $iteme->employee_id)->where('work', '1')->count())
                            {{-- @if (1) --}}
                            @php

                                $total_work_days = 0;
                                $total_sicks = 0;

                                $contractStart = $iteme->contract->start_day
                                    ? Carbon\Carbon::parse($iteme->contract->start_day)
                                    : null;
                                $total_vacations = 0;
                                $total_soll = 0;
                                $startDate = Carbon\Carbon::parse($ddate)->startOfMonth();
                                $endDate = Carbon\Carbon::parse($ddate)->endOfMonth();
                                for ($start = $startDate; $start <= $endDate; $start->addDay()) {
                                    $isSick = 0;
                                    $isVacation = 0;
                                    $isHoliday = 0;
                                    if (
                                        $hrtimerecords
                                            ->where('fk_employee_id', $iteme->employee_id)
                                            ->where('start_date', $start->toDateString())
                                            ->where('work', '1')
                                            ->where('status_open', '0')
                                            ->count()
                                    ) {
                                        $total_work_days += 1;
                                    }

                                    if (
                                        $HrSickRequest

                                            ->where('fk_employee_id', $iteme->employee_id)

                                            ->where('date_from', '<=', $start->toDateString())
                                            ->where('date_to', '>=', $start->toDateString())
                                            ->count() &
                                        ($iteme->contract->get_days[strtolower($start->format('l'))] > 0)
                                    ) {
                                        $total_sicks += 1;
                                        $isSick = 1;
                                    }

                                    $isHoliday = $holidays->contains(function ($holiday) use ($start) {
                                        return $holiday->date == $start->toDateString();
                                    });
                                    if (
                                        !$isHoliday &&
                                        $Vacations
                                            ->where('is_accepted', '1')
                                            ->where('fk_employee_id', $iteme->employee_id)

                                            ->where('date_from', '<=', $start->toDateString())
                                            ->where('date_to', '>=', $start->toDateString())
                                            ->count() &
                                            ($iteme->contract->get_days[strtolower($start->format('l'))] > 0)
                                    ) {
                                        $total_vacations += 1;
                                        $isVacation = 1;
                                    }
                                    // $isSick = $HrSickRequest->contains(function ($HrSickRequest) use ($start) {
                                    //     return $HrSickRequest->date_from <= $start->toDateString() &&
                                    //         $HrSickRequest->date_to >= $start->toDateString();
                                    // });

                                    // $isVacation = $Vacations
                                    //     ->where('is_accepted', '1')
                                    //     ->where('date_from', '<=', $start->toDateString())
                                    //     ->where('date_to', '>=', $start->toDateString())
                                    //     ->count();

                                    if (
                                        !$isHoliday &&
                                        !$isSick &&
                                        !$isVacation &&
                                        (!$contractStart || $start->greaterThanOrEqualTo($contractStart))
                                    ) {
                                        $dayOfWeek = strtolower($start->format('l'));
                                        $total_soll += $iteme->contract->get_days[$dayOfWeek] ?? 0;
                                    }
                                }
                                // for (
                                //     $start = Carbon\Carbon::parse($ddate)->startOfMonth();
                                //     $start <= Carbon\Carbon::parse($ddate)->endOfMonth();
                                //     $start->addDay()
                                // ) {
                                //     if (
                                //         $hrtimerecords
                                //             ->where('fk_employee_id', $iteme->employee_id)
                                //             ->where('start_date', $start->toDateString())
                                //             ->where('work', '1')
                                //             ->where('status_open', '0')
                                //             ->count()
                                //     ) {
                                //         $total_work_days += 1;
                                //     }

                                //     if (
                                //         $HrSickRequest

                                //             ->where('fk_employee_id', $iteme->employee_id)

                                //             ->where('date_from', '<=', $start->toDateString())
                                //             ->where('date_to', '>=', $start->toDateString())
                                //             ->count() &
                                //         ($iteme->contract->get_days[strtolower($start->format('l'))] > 0)
                                //     ) {
                                //         $total_sicks += 1;
                                //     }
                                //     if (
                                //         $Vacations
                                //             ->where('is_accepted', '1')
                                //             ->where('fk_employee_id', $iteme->employee_id)

                                //             ->where('date_from', '<=', $start->toDateString())
                                //             ->where('date_to', '>=', $start->toDateString())
                                //             ->count() &
                                //         ($iteme->contract->get_days[strtolower($start->format('l'))] > 0)
                                //     ) {
                                //         $total_vacations += 1;
                                //     }
                                //     if (
                                //         !$Vacations
                                //             ->where('is_accepted', '1')
                                //             ->where('fk_employee_id', $iteme->employee_id)

                                //             ->where('date_from', '<=', $start->toDateString())
                                //             ->where('date_to', '>=', $start->toDateString())
                                //             ->count()
                                //     ) {
                                //         $total_soll += $iteme->contract->get_days[strtolower($start->format('l'))];
                                //     }
                                // }
                            @endphp
                            <tr>

                                <td class=" text-center">
                                    <div class="row ">
                                        <div class="col  ">
                                            <a class="btn btn-outline-secondary" role="button"
                                                href="{{ route('hrm.employee.timerecords.department', ['id' => $iteme->employee_id]) }}"
                                                target="_blank"
                                                title="  {{ $iteme->contract->id }}- {{ $iteme->first_name }}
                                                {{ $iteme->last_name }}">

                                                {{ $iteme->first_name }}
                                                {{ $iteme->last_name }}</a>


                                            {{-- {{ $iteme->first_name }} {{ $iteme->last_name }} --}}
                                        </div>
                                    </div>
                                </td>
                                <td class=" text-center">

                                    {{ $work_days - $total_sicks - $total_vacations }} / {{ $total_work_days }}
                                </td>


                                <td class=" text-center">
                                    {{ $total_sicks }}
                                </td>



                                <td class=" text-center">
                                    @php
                                        $got_vacations = 0;
                                        $Vacations_manual_days_sum = 0;
                                        $Vacations_manual_days_sum_all = $Vacations_manual_days
                                            ->where('is_accepted', '1')
                                            ->where('fk_employee_id', $iteme->employee_id)
                                            ->where('date_from', '>=', Carbon\Carbon::parse('2025-01')->startOfMonth())
                                            ->where('date_to', '<=', Carbon\Carbon::parse($ddate)->endOfMonth())
                                            ->sum('manual_days');
                                        $Vacations_manual_days_sum = $Vacations_manual_days
                                            ->where('is_accepted', '1')
                                            ->where('fk_employee_id', $iteme->employee_id)
                                            ->where('date_from', '>=', Carbon\Carbon::parse($ddate)->startOfMonth())
                                            ->where('date_to', '<=', Carbon\Carbon::parse($ddate)->endOfMonth())
                                            ->sum('manual_days');
                                        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;
                                            }
                                            // if ($isVacationDay && $isWorkDay && !$isHoliday) {
                                            //     $got_vacations += 1;
                                            // }
                                        }

                                    @endphp
                                    <div class="row justify-content-center align-items-center mx-2">
                                        <div class="col text-muted border-end">
                                            {{ $iteme->contract->get_days->last_year_vacation_rest }}
                                        </div>
                                        <div class="col  text-muted  border-end">
                                            {{ $iteme->contract->get_days->vacation_entitlement }}
                                        </div>
                                        <div class="col  border-end">

                                            {{ $got_vacations + $Vacations_manual_days_sum_all }}
                                        </div>

                                        <div class="col">
                                            {{ $iteme->contract->get_days->last_year_vacation_rest + $iteme->contract->get_days->vacation_entitlement - $got_vacations - $Vacations_manual_days_sum_all }}
                                        </div>
                                    </div>
                                    <div class="row justify-content-center align-items-center ">
                                        <div class="col  border-top mx-2">
                                            <b>{{ $total_vacations + $Vacations_manual_days_sum }}</b>
                                        </div>

                                    </div>

                                </td>

                                <td class=" text-center">


                                    {{ convertDecimalToHHMM($total_soll) }}

                                    ({{ $total_soll }} Std.)
                                </td>
                                <td class=" text-center">

                                    @if ($hrtimerecords->where('fk_employee_id', $iteme->employee_id)->where('work', '1')->where('status_open', '0')->count())
                                        {{ secondsToTime(
                                            $hrtimerecords->where('fk_employee_id', $iteme->employee_id)->where('work', '1')->where('status_open', '0')->sum('total_second') -
                                                $hrtimerecords->where('fk_employee_id', $iteme->employee_id)->where('break', '1')->where('status_open', '0')->sum('total_second'),
                                        ) }}

                                        ({{ convertHMToHours(
                                            secondsToTime(
                                                $hrtimerecords->where('fk_employee_id', $iteme->employee_id)->where('work', '1')->where('status_open', '0')->sum('total_second') -
                                                    $hrtimerecords->where('fk_employee_id', $iteme->employee_id)->where('break', '1')->where('status_open', '0')->sum('total_second'),
                                            ),
                                        ) }}
                                        Std.)
                                    @else
                                        0
                                    @endif

                                </td>
                                <td class=" text-center">
                                    @php
                                        // Hole den WorkTimeAccount für den letzten Monat
                                        $workTimeAccount = $hr_workTimeAccounts
                                            ->where('fk_employee_id', $iteme->employee_id)

                                            ->last();

                                        // Falls kein Eintrag für den letzten Monat vorhanden ist, setze new_balance auf 0
                                        $oldBalance = $workTimeAccount ? $workTimeAccount->previous_balance : 0;
                                    @endphp
                                    @if ($oldBalance < 0)
                                        <b class="border-bottom text-danger">
                                            {{ convertDecimalToHHMM($oldBalance) }}
                                            ({{ number_format($oldBalance, 2, ',', '.') }}
                                            Stunde)</b>
                                    @else
                                        <label class="border-bottom ">
                                            {{ convertDecimalToHHMM($oldBalance) }}
                                            ({{ number_format($oldBalance, 2, ',', '.') }}
                                            Stunde)</label>
                                    @endif

                                    {{-- @if ($iteme->contract->get_days->old_work_time_account < 0)
                                    <div class=" text-danger">

                                        {{ convertDecimalToHHMM($iteme->contract->get_days->old_work_time_account) }}
                                        ({{ number_format($iteme->contract->get_days->old_work_time_account, 2, ',', '.') }}
                                        Std.)
                                    </div>
                                @else
                                    {{ convertDecimalToHHMM($iteme->contract->get_days->old_work_time_account) }}
                                    ({{ number_format($iteme->contract->get_days->old_work_time_account, 2, ',', '.') }}
                                    Std.)
                                @endif --}}
                                </td>
                                <td class=" text-center">
                                    {{-- <b> {{ secondsToTime(
                                    $hrtimerecords->where('fk_employee_id', $iteme->employee_id)->where('work', '1')->where('status_open', '0')->sum('total_second') -
                                        $hrtimerecords->where('fk_employee_id', $iteme->employee_id)->where('break', '1')->where('status_open', '0')->sum('total_second') +
                                        hoursToSeconds($iteme->contract->get_days->old_work_time_account) -
                                        hoursToSeconds($total_soll),
                                ) }}
                                </b>

                                ({{ convertSecondsToHours(
                                    $hrtimerecords->where('fk_employee_id', $iteme->employee_id)->where('work', '1')->where('status_open', '0')->sum('total_second') -
                                        $hrtimerecords->where('fk_employee_id', $iteme->employee_id)->where('break', '1')->where('status_open', '0')->sum('total_second') +
                                        hoursToSeconds($iteme->contract->get_days->old_work_time_account) -
                                        hoursToSeconds($total_soll),
                                ) }}
                                Std.) --}}
                                    @php
                                        // Hole den WorkTimeAccount für den letzten Monat
                                        $workTimeAccount = $hr_workTimeAccounts
                                            ->where('fk_employee_id', $iteme->employee_id)

                                            ->last();

                                        // Falls kein Eintrag für den letzten Monat vorhanden ist, setze new_balance auf 0
                                        $newBalance = $workTimeAccount ? $workTimeAccount->new_balance : 0;
                                    @endphp
                                    @if ($newBalance < 0)
                                        <b class="border-bottom text-danger">
                                            {{ convertDecimalToHHMM($newBalance) }}
                                            ({{ number_format($newBalance, 2, ',', '.') }}
                                            Stunde)</b>
                                    @else
                                        <label class="border-bottom ">
                                            {{ convertDecimalToHHMM($newBalance) }}
                                            ({{ number_format($newBalance, 2, ',', '.') }}
                                            Stunde)</label>
                                    @endif
                                </td>
                            </tr>
                        @endif
                    @endforeach
                @endforeach

            </tbody>


        </table>
    </div>{{-- für container --}}
@endsection