@extends('layouts.base')

@section('title', 'Ensemble - ' . (Auth::check() ? Auth::user()->t_structure->libelle : 'Invité'))

@push('styles')
    <style>
        /* Style pour l'overlay qui couvre toute la page */
    .loader-overlay {
        position: fixed;
        top: 0;
        left: 0;
        width: 100%;
        height: 100%;
        background: rgba(0, 0, 0, 0.3); /* Opacité grisâtre */
        display: none; /* Initialement caché */
        z-index: 9999; /* Assurez-vous que c'est au-dessus du contenu */
        justify-content: center;
        align-items: center;
    }

    /* Style du spinner centré */
    .spinner {
        border: 4px solid rgba(255, 255, 255, 0.3); /* Couleur claire */
        border-top: 4px solid white; /* Couleur du spinner */
        border-radius: 50%;
        width: 50px;
        height: 50px;
        animation: spin 1s linear infinite;
    }

    /* Animation du spinner */
    @keyframes spin {
        0% { transform: rotate(0deg); }
        100% { transform: rotate(360deg); }
    }

    </style>
@endpush

@section('breadcrumb')
    <div class="subheader-block d-lg-flex align-items-center">
        <ol class="breadcrumb page-breadcrumb m-0 mr-4">
            <li class="breadcrumb-item"><a href="{{ route('accueil') }}">Tableau de bord</a></li>
            <li class="breadcrumb-item">@yield('title')</li>
        </ol>
    </div>
@endsection

@push('filtre')
    <!-- 📌 Filtre par date stylisé avec icônes -->
    <div class="ml-4 d-flex align-items-center">
        <i class="fal fa-filter text-white mr-2"></i> <!-- Icône de filtre -->

        <!-- 📌 Filtre par date de début et de fin -->
        <label for="startDate" class="text-white mr-1">Date:</label>
        <input type="date" id="startDate" class="form-control ml-2" placeholder="Date de début">

        <label for="endDate" class="text-white mr-1 ml-2">Fin:</label>
        <input type="date" id="endDate" class="form-control ml-2" placeholder="Date de fin">

        <select id="yearFilter" class="form-control custom-select ml-2">
            <option value="all">📊 Tous</option>
            @php
                $currentYear = date('Y');
                for ($i = 0; $i < 3; $i++) {
                    $year = $currentYear - $i;
                    echo "<option value='$year'>📅 $year</option>";
                }
            @endphp
        </select>
    </div>
    <!-- Overlay de chargement -->
    <div id="loader-overlay" class="loader-overlay" style="display: none;">
        <div class="spinner"></div>
    </div>
@endpush

@section('content')
    <main id="js-page-content" role="main" class="page-content">
        <div class="row">
            <div class="card border-0 mb-3 col-xl-12 col-md-12">
                <div class="card-body">
                    <div class="row pl-3 pr-3 pb-3">
                        <h3 class="d-flex flex-row mr-auto align-items-center"><i class="fal fa-chart-area demande t-ico color-primary-200 fa-2x mr-2"></i>Vue d'ensemble</h3>

                    </div>
                    <div class="row mr-2 ml-2 mt-3">
                        <div class="col-md-12">
                            <!-- datatable start -->
                            <table id="dt-ensemble" class="table table-bordered table-hover table-striped w-100">
                                <thead class="bg-primary-100">
                                    <tr>
                                        <th>Lieux Intervention</th>
                                        <th style="width: 100px;">Référent</th>
                                        <th>N° Demande + (Date)</th>
                                        <th>N° Devis + (Date)</th>
                                        <th>Montant</th>
                                        <th>Date de commande</th>
                                        <th>Votre Réf.Commande</th>
                                        <th>Date début intervention</th>
                                        <th>Rapport(s) validé(s)</th>
                                        <th>Notation du rapport</th>
                                        @if(config('app.display_facture'))
                                        <th>N° Facture + Date</th>
                                        <th>Montant TTC</th>
                                        <th>Date écheance</th>
                                        @endif
                                    </tr>
                                </thead>
                                <tbody>
                                    @forelse ( $ensembles as $ensemble)
                                    <tr>
                                        <td>{{ $ensemble->t_planning->t_location->libelle }}</td>
                                        <td>{{ $ensemble->t_planning->t_location->t_user->nom }} {{ $ensemble->t_planning->t_location->t_user->prenom }}</td>
                                        <td>{{ $ensemble->t_planning->t_devi->t_demande ? $ensemble->t_planning->t_devi->t_demande->id : '-' }}</td>
                                        <td>{{ $ensemble->t_planning->t_devi->id_libelle }}</td>
                                        <td>
                                            @if($ensemble->t_planning->t_devi->id_contrat_entretien && $ensemble->t_planning->t_devi->validation_client == 1)
                                                @if($ensemble->t_planning->t_devi->t_devis_sites->isNotEmpty())
                                                    @php
                                                        // Récupérer le devis_site correspondant à l'ID de location de l'ensemble actuel
                                                        $devisSite = $ensemble->t_planning->t_devi->t_devis_sites->firstWhere('id_location', $ensemble->t_planning->id_location);
                                                        $total = $devisSite ? $devisSite->total_sum : 0;
                                                    @endphp
                                                    @if($total > 0)
                                                        {{ number_format($total, 2, ',', ' ') }} €
                                                    @else
                                                        -
                                                    @endif
                                                @else
                                                    -
                                                @endif
                                            @else
                                                @if ($ensemble->t_planning->t_devi->total_ht > 0)
                                                    {{ number_format($ensemble->t_planning->t_devi->total_ht, 2, ',', ' ') }} €
                                                @else
                                                    -
                                                @endif
                                            @endif
                                        </td>
                                        <td data-order="{{ $ensemble->t_planning->t_devi->date_validate ? $ensemble->t_planning->t_devi->date_validate->format('Y-m-d') : '' }}">{{ $ensemble->t_planning->t_devi->date_validate ? $ensemble->t_planning->t_devi->date_validate->format('d/m/Y') : '-' }}</td>
                                        <td>{{ $ensemble->t_planning->t_devi->bon_commande ? $ensemble->t_planning->t_devi->bon_commande : '-'   }}</td>
                                        <td data-order="{{ $ensemble->date_starting ? $ensemble->date_starting->format('Y-m-d') : '' }}">{{ $ensemble->date_starting ? $ensemble->date_starting->format('d/m/Y') : '-' }}</td>
                                        <td class="text-center">
                                            @if($ensemble->fichier() !== '#')
                                                <a class="btn btn-primary waves-effect waves-themed"
                                                    href="{{ $ensemble->fichier() }}?t={{ $tokenFile }}" target="_blank"
                                                    title="Voir le devis complémentaire" class="text-danger"><i
                                                class="fal fa-file-pdf"></i>
                                                </a>
                                            @else
                                                <span class="text-muted">Fichier non disponible</span>
                                            @endif
                                        </td>
                                        <td class="text-center">
                                            {{-- État général --}}
                                           <span data-toggle="tooltip" title="État général">
                                                @if ($ensemble->etat_general == -1 || $ensemble->etat_general == -2)
                                                    <span class="text-muted"><i class="fas fa-question-circle"></i></span>
                                                @elseif ($ensemble->etat_general == 0)
                                                    <span style="color: #238c3e;"><i class="fas fa-smile"></i></span>
                                                @elseif ($ensemble->etat_general == 1)
                                                    <span style="color:#FAFA33;"><i class="fas fa-smile"></i></span>
                                                @elseif ($ensemble->etat_general == 1.5)
                                                    <span style="color:#FFBF00;"><i class="fas fa-smile"></i></span>
                                                @elseif ($ensemble->etat_general == 2)
                                                    <span style="color: #d20616;"><i class="fas fa-smile"></i></span>
                                                @endif
                                           </span>

                                            {{-- Sécurité existante --}}
                                            <span data-toggle="tooltip" title="Sécurité existante">
                                                @if ($ensemble->securite_exist == -1)
                                                    <span class="text-muted"><i class="fas fa-question-circle"></i></span>
                                                @elseif ($ensemble->securite_exist == 0)
                                                <span style="color: #238c3e;"><i class="fas fa-check-circle"></i></span>
                                                @elseif ($ensemble->securite_exist == 2)
                                                <span style="color: #d20616;"><i class="fas fa-times-circle"></i></span>
                                                @endif
                                            </span>

                                            {{-- Conformité sécurité --}}
                                            <span data-toggle="tooltip" title="Conformité sécurité">
                                                @if ($ensemble->securite_conforme == -1)
                                                    <span class="text-muted"><i class="fas fa-question-circle"></i></span>
                                                @elseif ($ensemble->securite_conforme == 0)
                                                    <span style="color: #238c3e;"><i class="fas fa-shield-alt"></i></span>
                                                @elseif ($ensemble->securite_conforme == 1.5)
                                                    <span style="color: #d20616;"><i class="fas fa-shield-alt"></i></span>
                                                @endif
                                            </span>
                                        </td>
                                        @if(config('app.display_facture'))
                                        <td>
                                            @php
                                                $facture = null;

                                                if ($ensemble->t_planning->t_devi->id_contrat_entretien) {
                                                    // Cas CTE : Récupérer la première facture associée au lieu (t_facture_location)
                                                    $factures = $ensemble->t_planning->t_devi->t_factures;
                                                    $factureLocation = null;

                                                    // Recherche dans chaque facture de la collection
                                                    foreach ($factures as $factureItem) {
                                                        // Assure-toi que la facture a la relation 't_facture_location' et vérifie l'id_location
                                                        $factureLocation = $factureItem->t_facture_location->firstWhere('id_location', $ensemble->t_planning->id_location);
                                                        if ($factureLocation) {
                                                            $facture = $factureLocation->t_facture;
                                                            break;
                                                        }
                                                    }
                                                } else {
                                                    // Cas DV/FT : Récupérer la première facture depuis t_devis->t_factures
                                                    $facture = $ensemble->t_planning->t_devi->t_factures->first();
                                                }
                                            @endphp

                                            @if ($facture)
                                                {{ $facture->id_libelle }} - {{ $facture->date_facture->format('d/m/Y') }}
                                            @else
                                                -
                                            @endif
                                        </td>
                                        <td>
                                            @php
                                                $facture = null;

                                                if ($ensemble->t_planning->t_devi->id_contrat_entretien) {
                                                    // Cas CTE : Récupérer la première facture associée au lieu (t_facture_location)
                                                    $factures = $ensemble->t_planning->t_devi->t_factures;
                                                    $factureLocation = null;

                                                    // Recherche dans chaque facture de la collection
                                                    foreach ($factures as $factureItem) {
                                                        // Assure-toi que la facture a la relation 't_facture_location' et vérifie l'id_location
                                                        $factureLocation = $factureItem->t_facture_location->firstWhere('id_location', $ensemble->t_planning->id_location);
                                                        if ($factureLocation) {
                                                            $facture = $factureLocation->t_facture;
                                                            break;
                                                        }
                                                    }
                                                } else {
                                                    // Cas DV/FT : Récupérer la première facture depuis t_devis->t_factures
                                                    $facture = $ensemble->t_planning->t_devi->t_factures->first();
                                                }
                                            @endphp

                                            @if ($facture)
                                                {{ number_format($facture->total_ht, 2, ',', ' ') }} €
                                            @else
                                                -
                                            @endif
                                        </td>
                                        <td>
                                            @php
                                                $facture = null;

                                                if ($ensemble->t_planning->t_devi->id_contrat_entretien) {
                                                    // Cas CTE : Récupérer la première facture associée au lieu (t_facture_location)
                                                    $factures = $ensemble->t_planning->t_devi->t_factures;
                                                    $factureLocation = null;

                                                    // Recherche dans chaque facture de la collection
                                                    foreach ($factures as $factureItem) {
                                                        // Assure-toi que la facture a la relation 't_facture_location' et vérifie l'id_location
                                                        $factureLocation = $factureItem->t_facture_location->firstWhere('id_location', $ensemble->t_planning->id_location);
                                                        if ($factureLocation) {
                                                            $facture = $factureLocation->t_facture;
                                                            break;
                                                        }
                                                    }
                                                } else {
                                                    // Cas DV/FT : Récupérer la première facture depuis t_devis->t_factures
                                                    $facture = $ensemble->t_planning->t_devi->t_factures->first();
                                                }
                                            @endphp

                                            @if ($facture)
                                                {{ $facture->date_echeance->format('d/m/Y') }}
                                            @else
                                                -
                                            @endif
                                        </td>
                                        @endif
                                    </tr>
                                    @empty
                                    <tr>
                                        <td colspan="7" class="text-center">Aucun enregistrement trouvé</td>
                                    </tr>
                                    @endforelse
                                </tbody>
                                <tfoot>
                                    <tr>
                                        <th>Lieux Intervention</th>
                                        <th style="width: 500px;">Référent</th>
                                        <th>N° Demande + (Date)</th>
                                        <th>N° Devis + (Date)</th>
                                        <th>Montant</th>
                                        <th>Date de commande</th>
                                        <th>Votre Réf.Commande</th>
                                        <th>Date début intervention</th>
                                        <th>Rapport(s) validé(s)</th>
                                        <th>Notation du rapport</th>
                                        @if(config('app.display_facture'))
                                        <th>N° Facture + Date</th>
                                        <th>Montant TTC</th>
                                        <th>Date écheance</th>
                                        @endif
                                    </tr>
                                </tfoot>
                            </table>
                            <!-- datatable end -->
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </main>
@endsection

@push('script')
<script>
    //Ensemble
    $(document).ready(function()
        {
            $('#dt-ensemble').dataTable(
            {
                responsive: true,
                order: [5, 'desc'],
                language: {
                    url: "{{ asset('assets/js/core/fr-FR.json') }}",
                },
                lengthChange: true,
                dom:
                    "<'row mb-3'<'col-sm-12 col-md-6 d-flex align-items-center justify-content-start'f><'col-sm-12 col-md-6 d-flex align-items-center justify-content-end'lB>>" +
                    "<'row'<'col-sm-12'tr>>" +
                    "<'row'<'col-sm-12 col-md-5'i><'col-sm-12 col-md-7'p>>",
                buttons: [
                    {
                        extend: 'csvHtml5',
                        text: 'CSV',
                        titleAttr: 'Generate CSV',
                        className: 'btn-outline-primary btn-sm mr-1'
                    },
                ],
                "initComplete": function (settings, json) { // show new container for data
                    $('#cd-rapport').insertBefore('#dt-rapport');

                    // Ajouter des filtres de recherche par colonne
                    this.api().columns().every(function () {
                        var column = this;
                        var header = $(column.header());
                        var input = document.createElement("input");

                        // Ajouter le champ de recherche avec le placeholder
                        $(input).appendTo(header)
                            .attr("placeholder", "Rechercher ")
                            .css('width', '100%') // Ajouter cette ligne pour ajuster la largeur du champ de recherche
                            .addClass('form-control')
                            .on('keyup', function () {
                                column.search($(this).val()).draw();
                            });
                    });
                },
            });
        });
</script>
@endpush
@push('script_02')
<script>
    let table;
    let displayFacture = @json(config('app.display_facture'));

    // Initialisation de la table au démarrage
    function initDataTable() {
        table = $('#dt-ensemble').DataTable({
            order: [5, 'desc'],
            destroy: true,
            language: {

                url: "{{ asset('assets/js/core/fr-FR.json') }}",
            },
            dom: `<'row mb-3'<'col-md-6 d-flex align-items-center'f><'col-md-6 d-flex justify-content-end'lB>>
            <'row'<'col-12'tr>>
            <'row'<'col-md-5'i><'col-md-7'p>>`,
            buttons: [
                {
                    extend: 'csvHtml5',
                    text: 'CSV',
                    className: 'btn-outline-primary btn-sm mr-1'
                },
            ],
            "initComplete": function (settings, json) { // show new container for data
                $('#cd-rapport').insertBefore('#dt-rapport');
                // Ajouter des filtres de recherche par colonne
                this.api().columns().every(function () {
                    var column = this;
                    var header = $(column.header());
                    var input = document.createElement("input");

                    // Ajouter le champ de recherche avec le placeholder
                    $(input).appendTo(header)
                        .attr("placeholder", "Rechercher ")
                        .css('width', '100%')
                        .addClass('form-control')
                        .on('keyup', function () {
                            column.search($(this).val()).draw();
                        });
                });
            },

        });
    }

    // Assure-toi que ta table est bien initialisée DataTable
    document.getElementById('startDate').addEventListener('change', updateData);
    document.getElementById('endDate').addEventListener('change', updateData);
    document.getElementById('yearFilter').addEventListener('change', updateData);

    function updateData() {

        // Afficher le loader
        showLoader();

        let startDate = document.getElementById('startDate').value;
        let endDate = document.getElementById('endDate').value;
        let selectedYear = document.getElementById('yearFilter').value;

        let url = `/ensemble/data`;

        // Ajouter les paramètres selon les sélections
        let queryParams = [];

        if (startDate && endDate) {
            queryParams.push(`start_date=${startDate}`);
            queryParams.push(`end_date=${endDate}`);
        } else if (selectedYear !== 'all') {
            queryParams.push(`year=${selectedYear}`);
        }

        // Si des paramètres sont présents, les ajouter à l'URL
        if (queryParams.length > 0) {
            url += `?${queryParams.join('&')}`;
        }

        // Effectuer la requête AJAX
        fetch(url)
            .then(response => response.json())
            .then(data => {
                updateEnsembleTable(data.ensembles ?? [], data.tokenFile ?? '');

                // Masquer le loader après avoir mis à jour les données
                hideLoader();

            })
            .catch(error => {
                console.error('Erreur de mise à jour des données :', error);

                // Masquer le loader en cas d'erreur
                hideLoader();
            });
    }

    // Fonction pour afficher le loader
    function showLoader() {
        document.getElementById('loader-overlay').style.display = 'flex';
    }

    // Fonction pour masquer le loader
    function hideLoader() {
        document.getElementById('loader-overlay').style.display = 'none';
    }

    function updateEnsembleTable(ensembles, tokenFile) {
        // Détruire la table existante avant de la réinitialiser
        if ($.fn.DataTable.isDataTable('#dt-ensemble')) {
            $('#dt-ensemble').DataTable().clear().destroy();
        }

        $('#dt-ensemble thead th select, #dt-ensemble thead th input').remove();

        // Effacer le contenu existant dans le tableau
        $("#dt-ensemble tbody").empty();

        // Si 'demandes' est vide ou non défini, on affiche un message d'erreur
        if (!ensembles || ensembles.length === 0) {
            $("#dt-ensemble tbody").html("<tr><td colspan='6' class='text-center'>Aucune données trouvée pour cette année.</td></tr>");
        } else {

        // Fonction pour formater un nombre en format français
        function number_format(number, decimals, dec_point, thousands_sep) {
            if (number == null) return "-";
            number = parseFloat(number).toFixed(decimals);
            let parts = number.split(".");
            parts[0] = parts[0].replace(/\B(?=(\d{3})+(?!\d))/g, thousands_sep);
            return parts.join(dec_point);
        }

        function formatDate(dateString) {
            if (!dateString) return "-";
            let date = new Date(dateString);
            return date.toLocaleDateString('fr-FR');
        }

        // Ajouter les nouvelles lignes de ensemble à la table
        ensembles.forEach(ensemble => {

            let facture = null;

            if (ensemble.t_planning && ensemble.t_planning.t_devi) {
                if (ensemble.t_planning.t_devi.id_contrat_entretien) {
                    // Cas CTE : Récupérer la première facture associée au lieu (t_facture_location)
                    let factures = ensemble.t_planning.t_devi.t_factures || [];
                    let factureLocation = null;

                    for (let i = 0; i < factures.length; i++) {
                        let factureItem = factures[i];
                        if (factureItem.t_facture_location) {
                            factureLocation = factureItem.t_facture_location.find(
                                loc => loc.id_location === ensemble.t_planning.id_location
                            );
                            if (factureLocation) {
                                facture = factureLocation.t_facture;
                                break;
                            }
                        }
                    }
                } else {
                    // Cas DV/FT : Récupérer la première facture depuis t_devis->t_factures
                    if (ensemble.t_planning.t_devi.t_factures && ensemble.t_planning.t_devi.t_factures.length > 0) {
                        facture = ensemble.t_planning.t_devi.t_factures[0];
                    }
                }
            }

            const row = [
                `<td>${ensemble.t_planning.t_location.libelle}</td>`,
                `<td>${ensemble.t_planning.t_location.t_user.nom} ${ensemble.t_planning.t_location.t_user.prenom}</td>`,
                `<td>${ensemble.t_planning.t_devi.t_demande ? ensemble.t_planning.t_devi.t_demande.id : '-'}</td>`,
                `<td>${ensemble.t_planning.t_devi.id_libelle ?? '-'}</td>`,
                `<td>
                    ${ensemble.t_planning && ensemble.t_planning.t_devi && ensemble.t_planning.t_devi.id_contrat_entretien && ensemble.t_planning.t_devi.validation_client == 1
                        ? (ensemble.t_planning.t_devi.t_devis_sites && ensemble.t_planning.t_devi.t_devis_sites.length > 0
                            ? (ensemble.t_planning.t_devi.t_devis_sites.find(site => site.id_location === ensemble.t_planning.id_location)?.total_sum > 0
                                ? number_format(ensemble.t_planning.t_devi.t_devis_sites.find(site => site.id_location === ensemble.t_planning.id_location)?.total_sum, 2, ',', ' ')
                                : '-')
                            : '-')
                        : (ensemble.t_planning && ensemble.t_planning.t_devi.total_ht > 0
                            ? number_format(ensemble.t_planning.t_devi.total_ht, 2, ',', ' ')
                            : '-')
                    }
                </td>`,
                `<td data-order="${ensemble.t_planning.t_location.t_devi ? ensemble.t_planning.t_location.t_devi.date_validate : ''}">
                    ${ensemble.t_planning.t_devi && ensemble.t_planning.t_devi.date_validate
                        ? new Date(ensemble.t_planning.t_devi.date_validate).toLocaleDateString('fr-FR')
                        : '-'}
                </td>`,
                `<td>${ensemble.t_planning.t_devi ? ensemble.t_planning.t_devi.bon_commande || '-' : '-'}</td>`,
                `<td data-order="${ensemble.date_starting ? ensemble.date_starting : ''}">
                    ${ensemble.date_starting ? new Date(ensemble.date_starting).toLocaleDateString('fr-FR') : '-'}
                </td>`,
                `<td class="text-center">
                    ${ensemble.fichier !== '#'
                        ? `<a class="btn btn-primary waves-effect waves-themed" href="${ensemble.fichier}?t=${tokenFile}" target="_blank" title="Voir le devis complémentaire"><i class="fal fa-file-pdf"></i></a>`
                        : `<span class="text-muted">Fichier non disponible</span>`
                    }
                </td>`,
                `<td class="text-center">
                    <span data-toggle="tooltip" title="État général">
                        ${ensemble.etat_general == -1 || ensemble.etat_general == -2
                            ? `<span class="text-muted"><i class="fas fa-question-circle"></i></span>`
                            : ensemble.etat_general == 0
                            ? `<span style="color: #238c3e"><i class="fas fa-smile"></i></span>`
                            : ensemble.etat_general == 1
                            ? `<span style="color:#FAFA33;"><i class="fas fa-smile"></i></span>`
                            : ensemble.etat_general == 1.5
                            ? `<span style="color:#FFBF00;"><i class="fas fa-smile"></i></span>`
                            : ensemble.etat_general == 2
                            ? `<span style="color: #d20616;"><i class="fas fa-smile"></i></span>`
                            : ''
                        }
                    </span>
                    <span data-toggle="tooltip" title="Sécurité existante">
                        ${ensemble.securite_exist == -1
                            ? `<span class="text-muted"><i class="fas fa-question-circle"></i></span>`
                            : ensemble.securite_exist == 0
                            ? `<span style="color: #238c3e"><i class="fas fa-check-circle"></i></span>`
                            : ensemble.securite_exist == 2
                            ? `<span style="color: #d20616"><i class="fas fa-times-circle"></i></span>`
                            : ''
                        }
                    </span>
                    <span data-toggle="tooltip" title="Conformité sécurité">
                        ${ensemble.securite_conforme == -1
                            ? `<span class="text-muted"><i class="fas fa-question-circle"></i></span>`
                            : ensemble.securite_conforme == 0
                            ? `<span style="color: #238c3e"><i class="fas fa-shield-alt"></i></span>`
                            : ensemble.securite_conforme == 1.5
                            ? `<span style="color: #d20616"><i class="fas fa-shield-alt"></i></span>`
                            : ''
                        }
                    </span>
                </td>`,
            ];

            // ✅ Ajouter dynamiquement les colonnes Facture
            if (displayFacture) {
                row.push(`<td>${facture ? facture.id_libelle + ' - ' + formatDate(facture.date_facture) : '-'}</td>`);
                row.push(`<td>${facture ? number_format(facture.total_ht, 2, ',', ' ') + ' €' : '-'}</td>`);
                row.push(`<td>${facture ? formatDate(facture.date_echeance) : '-'}</td>`);
            }

            // Ajouter la ligne au tableau
            $("#dt-ensemble tbody").append("<tr>" + row.join("") + "</tr>");
        });

        // Réinitialiser le DataTable après avoir ajouté les données
        initDataTable();
        }
    }
</script>
@endpush