@if (!isset($listeTableau['affectation']))
    <p></p>
@elseif (count($affectation) === 0)
<div class="section {{ $lastDisplayedSection !== 'affectation' ? 'page-break' : '' }}">
    <h3>
        {{ getValueByKey($parametres, 'affectation_titre_section') }}
        @if (isset($filter_start_date) && isset($filter_end_date))
            du {{ date_format($filter_start_date, 'Y-m-d') }} au {{ date_format($filter_end_date, 'Y-m-d') }}
        @endif
    </h3>
    <p>Aucune donnée</p>
</div>
@else
<div class="section {{ $lastDisplayedSection !== 'affectation' ? 'page-break' : '' }}">
    <h3>
        {{ getValueByKey($parametres, 'affectation_titre_section') }}
        @if (isset($filter_start_date) && isset($filter_end_date))
            du {{ date_format($filter_start_date, 'Y-m-d') }} au {{ date_format($filter_end_date, 'Y-m-d') }}
        @endif
    </h3>
    <table id="affectation" style="width:100%; margin-bottom: 10px;">
        <tr>
            <th class="date">{{ getValueByKey($parametres, 'affectation_nom_col_du') }}</th>
            <th class="date">{{ getValueByKey($parametres, 'affectation_nom_col_au') }}</th>
            <th class="halfsize">{{ getValueByKey($parametres, 'affectation_nom_col_affectation') }}</th>
            <th class="halfsize">{{ getValueByKey($parametres, 'affectation_nom_col_Installation') }}</th>
            <th class="date">{{ getValueByKey($parametres, 'affectation_nom_col_nbjours') }}</th>
        </tr>
        @foreach ($affectation as $item)
        <tr>
            @php
                $displayFrom = $item->from;
                $displayTo = $item->to;
                $displayNbJours = $item->nbJours;

                // Adjust dates to filter period if filters are applied
                if (isset($filter_start_date) && isset($filter_end_date)) {
                    if ($item->from < $filter_start_date) {
                        $displayFrom = $filter_start_date;
                    }
                    if ($item->to !== null && $item->to > $filter_end_date) {
                        $displayTo = $filter_end_date;
                    }
                    if ($item->to === null && $displayFrom <= $filter_end_date) {
                        $displayTo = $filter_end_date;
                    }

                    // Recalculate nbJours for the filtered period
                    if ($displayFrom && $displayTo) {
                        $filterFromCarbon = \Carbon\Carbon::parse($displayFrom);
                        $filterToCarbon = \Carbon\Carbon::parse($displayTo);
                        $displayNbJours = $filterFromCarbon->diffInDays($filterToCarbon) + 1;
                    }
                }
            @endphp
            <td>{{ date_format($displayFrom, 'Y-m-d') }}</td>
            @if ($displayTo !== null)
            <td>{{ date_format($displayTo, 'Y-m-d') }}</td>
            @else
            <td></td>
            @endif
            @if (App\Models\ParametresAffectation::where('id', $item->parametre_affectation_id)->first() !== null)
            <td>{{ App\Models\ParametresAffectation::where('id', $item->parametre_affectation_id)->first()->nom }}</td>
            @else
            <td></td>
            @endif
            @if (App\Models\ParametresInstallation::where('id', $item->parametre_installation_id)->first() !== null)
            <td>{{ App\Models\ParametresInstallation::where('id', $item->parametre_installation_id)->first()->nom }}</td>
            @else
            <td></td>
            @endif
            <td>{{ formatNbJours($displayNbJours) }}</td>
        </tr>
        @endforeach
    </table>
</div>
@endif