@php
if (!function_exists('formatNbJours')) {
function formatNbJours($nbJours) {
if (!is_numeric($nbJours)) return '0 jrs = 0.00 sem = 0.00 an';

$semaines = $nbJours / 7;
$annees = $nbJours / 365;

return sprintf('%d jrs = %.2f sem = %.2f an', $nbJours, $semaines, $annees);
}
}
if (!function_exists('formatNbJoursForItems')) {
    function formatNbJoursForItems($items, $filter_start_date = null, $filter_end_date = null) {
        if (is_string($items)) {
            $items = json_decode($items);
        }

        $totalNbJours = 0;

        if (is_array($items) || is_object($items)) {
            foreach ($items as $item) {
                // If no filter is applied, use original nbJours
                if ($filter_start_date === null || $filter_end_date === null) {
                    if (isset($item->nbJours) && is_numeric($item->nbJours)) {
                        $totalNbJours += $item->nbJours;
                    }
                } else {
                    // Calculate filtered days for items with from/to dates
                    if (isset($item->from) && isset($item->to)) {
                        $itemFrom = \Carbon\Carbon::parse($item->from);
                        $itemTo = \Carbon\Carbon::parse($item->to);
                        $filterStart = \Carbon\Carbon::parse($filter_start_date);
                        $filterEnd = \Carbon\Carbon::parse($filter_end_date);

                        // Get the overlap period
                        $overlapStart = $itemFrom->gt($filterStart) ? $itemFrom : $filterStart;
                        $overlapEnd = $itemTo->lt($filterEnd) ? $itemTo : $filterEnd;

                        // Calculate days only if there's an overlap
                        if ($overlapStart->lte($overlapEnd)) {
                            $totalNbJours += $overlapStart->diffInDays($overlapEnd) + 1;
                        }
                    } elseif (isset($item->from) && $item->to === null) {
                        // Handle ongoing events (no end date)
                        $itemFrom = \Carbon\Carbon::parse($item->from);
                        $filterStart = \Carbon\Carbon::parse($filter_start_date);
                        $filterEnd = \Carbon\Carbon::parse($filter_end_date);

                        $overlapStart = $itemFrom->gt($filterStart) ? $itemFrom : $filterStart;

                        // Calculate days from start to filter end
                        if ($overlapStart->lte($filterEnd)) {
                            $totalNbJours += $overlapStart->diffInDays($filterEnd) + 1;
                        }
                    } else {
                    // Fallback to original nbJours for items without proper date structure
                        if (isset($item->nbJours) && is_numeric($item->nbJours)) {
                            $totalNbJours += $item->nbJours;
                        }
                    }
                }
            }
        }

        return formatNbJours($totalNbJours);
    }
}

if (isset($employee->hiringDate)) {
$anciennete = $employee->seniority;
$anneeDeService = \Carbon\Carbon::parse($employee->hiringDate)->diffInYears(\Carbon\Carbon::now());
$anneeDeService = floor($anneeDeService);
}
if (isset($employee->birthdate)) {
$age = date('Y') - explode('-', $employee->birthdate)[0];
$birthdate = \Carbon\Carbon::parse($employee->birthdate)->format('Y-m-d');
}

if (!function_exists('getValueByKey')) {

function getValueByKey($parametres, $key)
{
foreach ($parametres as $parametre) {
if ($parametre->key === $key) {
$value = $parametre->value;
}
}
return $value;
}
}
$team = App\Models\Team::where('id', $employee->team_id)->first();

$derniereAffectation = App\Models\ParametresAffectation::where('id', $employee->derniereAffectation_affectation_id)->first();
$derniereAffectationLieu = App\Models\ParametresInstallation::where('id', $employee->derniereAffectation_installation_id)->first();

// Find the last section that will be displayed
$sectionsOrder = [
    'fiche',
    'affectation',
    'suivi',
    'invalidite',
    'absence',
    'accidentTravail',
    'dossierDisciplinaire',
    'formation',
    'soutien',
    'evaluation',
    'rappel'
];

$lastDisplayedSection = null;
foreach (array_reverse($sectionsOrder) as $section) {
    if (isset($listeTableau[$section])) {
        $lastDisplayedSection = $section;
        break;
    }
}
@endphp
<html>

<head>
    <title>Sommaire employé(e) - {{ $employee->firstName }} {{ $employee->lastName }}</title>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <style>
        table {
            margin-right: 2px;
            font-size: 14px;
        }

        table,
        th,
        td {
            border: 1px solid black;
            border-collapse: collapse;
            font-family: Arial, Helvetica, sans-serif;
        }

        th,
        td {
            padding: 5px;
            text-align: left;
        }

        th {
            padding-top: 12px;
            padding-bottom: 12px;
            text-align: left;
            background-color: #626890;
            color: white;
        }

        h1,
        h3 {
            font-family: Arial, Helvetica, sans-serif;
        }

        .logo {
            position: fixed;
            bottom: 0px;
            text-align: center;
            width: 100%;
            display: none;
        }

        .link {
            position: fixed;
            bottom: 0;
            text-align: right;
            width: 100%;
        }

        .link a {
            color: #000000;
            text-decoration: none;
            font-weight: 400 !important;
            font-size: 16px !important;
        }

        #titre {
            text-align: left;
        }

        .section {
            margin-bottom: 100px;
        }

        /* Si la fiche n'est pas affichée, la première section visible n'aura pas de page break */
        .no-fiche .section:first-of-type {
            page-break-before: auto !important;
        }

        .note {
            word-wrap: break-word;
            font-size: 14px;
            max-width: 20cm;
            /* Set your desired max-width */
        }

        .date {
            width: 75px;
            min-width: 75px;
        }

        .halfsize {
            width: 50%;
            word-break: break-all;
            word-wrap: break-word;
        }

        .tiersize {
            width: 33%;
            word-break: break-all;
            word-wrap: break-word;
        }

        .twoTiersize {
            width: 66%;
            word-break: break-all;
            word-wrap: break-word;
        }

        .page-break {
            page-break-after: always;
        }

        .info-header {
            width: 35%;
            padding-left: 15px;
        }

        .info-header-table td {
              .page-break {
            page-break-after: always;
        }
    </style>
</head>

<body>
    <div class="{{ !isset($listeTableau['fiche']) ? 'no-fiche' : '' }}">
        <div id="titre">
            <h1>{{ $team->name }}</h1>
        </div>
        @if (!isset($listeTableau['fiche']))
        <!--Fiche de l'employé non selectionné-->
        <p></p>
        @else
        <div class="{{ $lastDisplayedSection !== 'fiche' ? 'page-break' : '' }}">
            <table class="info-header-table" style="width:100%">
                <tr>
                    <th class="info-header">Nom complet</th>
                    <td>{{ $employee->firstName . ' ' . $employee->lastName }}</td>
                </tr>
                <tr>
                    <th class="info-header">Poste</th>
                    <td>{{ isset($employee->job) ? $employee->job : 'N/A' }}</td>
                </tr>
                <tr>
                    <th class="info-header">Affectation</th>
                    <td>{{ isset($derniereAffectation) ? $derniereAffectation->nom : 'N/A' }}</td>
                </tr>
                <tr>
                    <th class="info-header">Lieu</th>
                    <td>{{ isset($derniereAffectationLieu) ? $derniereAffectationLieu->nom : 'N/A' }}</td>
                </tr>
                <tr>
                    <th class="info-header">Statut</th>
                    <td>{{ isset($employeeArray["status"]) ? $employeeArray["status"]["nom"] : 'N/A' }}</td>
                </tr>
                <tr>
                    <th class="info-header">Qualification</th>
                    <td>{{ isset($employeeArray["qualification"]) ? $employeeArray["qualification"]["nom"] : 'N/A' }}</td>
                </tr>
                <tr>
                    <th class="info-header">Date d'embauche</th>
                    <td>{{ isset($employee->hiringDate) ? $employee->hiringDate : 'N/A' }}</td>
                </tr>
                <tr>
                    <th class="info-header">Date de départ</th>
                    <td>{{ isset($employee->departure_date) ? $employee->departure_date : 'N/A' }}</td>
                </tr>
                <tr>
                    <th class="info-header">Années de service</th>
                    <td>{{ isset($anneeDeService) ? $anneeDeService : 'N/A' }}</td>
                </tr>
                <tr>
                    <th class="info-header">Ancienneté (Années et décimales)</th>
                    <td>{{ isset($anciennete) ? $anciennete : 'N/A' }}</td>
                </tr>
                <tr>
                    <th class="info-header">Date de naissance</th>
                    <td>{{ isset($employee->birthdate) ? $birthdate : 'N/A' }}</td>
                </tr>
                <tr>
                    <th class="info-header">Âge</th>
                    <td>{{ isset($age) ? $age : 'N/A' }}</td>
                </tr>
            </table>
        </div>
        @endif


        @include('pdf.sommaireEmploye.includes.affectation')
        @include('pdf.sommaireEmploye.includes.suiviEvenementIncident')
        @include('pdf.sommaireEmploye.includes.invalidite')
        @include('pdf.sommaireEmploye.includes.absence')
        @include('pdf.sommaireEmploye.includes.accidentTravail')
        @include('pdf.sommaireEmploye.includes.dossierDisciplinaire')
        @include('pdf.sommaireEmploye.includes.formation')
        @include('pdf.sommaireEmploye.includes.soutien')
        @include('pdf.sommaireEmploye.includes.evaluationAnnuelle')
        @include('pdf.sommaireEmploye.includes.rappels')
    </div>
</body>

</html>