@extends('admin.layout.master')
<link rel="stylesheet" type="text/css" href="{{asset('plugins/files/assets/css/select-responsive-fraza.css')}}" >
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/js/bootstrap.bundle.min.js"></script>
<style type="text/css">
    .table-responsive {
        position: relative;
        overflow-x: auto;
        -webkit-overflow-scrolling: touch;
    }

    .modern-table {
        width: 100%;
        border-collapse: collapse;
        background: #fff;
        border-radius: 6px;
        box-shadow: 0 1px 8px rgba(0, 0, 0, 0.05);
        margin-bottom: 15px;
    }

    .modern-table thead {
        background: #f1f3f5;
        color: #333;
    }

    .modern-table th {
        padding: 8px 10px;
        font-size: 0.85rem;
        font-weight: 600;
        text-transform: uppercase;
        text-align: left;
        border-bottom: 1px solid #dee2e6;
        white-space: nowrap;
    }

    .modern-table tbody tr {
        transition: background-color 0.3s ease;
    }

    .modern-table tbody tr:hover {
        background-color: #f9f9f9;
    }

    .modern-table td {
        padding: 6px 10px;
        font-size: 0.85rem;
        color: #444;
        border-bottom: 1px solid #e6e6e6;
        text-align: left;
        vertical-align: middle;
        white-space: normal;
        word-wrap: break-word;
    }

    .action-btn {
        display: inline-flex;
        align-items: center;
        padding: 5px 10px;
        border-radius: 15px;
        font-size: 0.8rem;
        font-weight: 500;
        text-decoration: none;
        transition: background-color 0.3s ease, transform 0.2s ease;
        margin-right: 5px;
        margin-bottom: 3px;
    }

    .action-btn i {
        margin-right: 4px;
    }

    .action-btn.view-policies {
        background-color: #ff4d4f;
        color: #fff;
    }

    .action-btn.view-policies:hover {
        background-color: #e63946;
        transform: scale(1.05);
    }

    .action-btn.view-details {
        background-color: #007bff;
        color: #fff;
    }

    .action-btn.view-details:hover {
        background-color: #0056b3;
        transform: scale(1.05);
    }

    .table-spinner {
        position: absolute;
        top: 0;
        left: 0;
        width: 100%;
        height: 100%;
        background: rgba(255, 255, 255, 0.8);
        display: none;
        align-items: center;
        justify-content: center;
        z-index: 10;
    }

    .spinner {
        border: 3px solid #f3f3f3;
        border-top: 3px solid #28a745;
        border-radius: 50%;
        width: 30px;
        height: 30px;
        animation: spin 1s linear infinite;
    }

    @keyframes spin {
        0% { transform: rotate(0deg); }
        100% { transform: rotate(360deg); }
    }

    .pagination {
        justify-content: center;
    }

    .pagination .page-link {
        border-radius: 20px;
        margin: 0 4px;
        padding: 6px 12px;
        font-size: 0.85rem;
        color: #007bff;
        font-weight: 500;
        border: 1px solid #dee2e6;
        transition: background-color 0.3s ease, color 0.3s ease;
    }

    .pagination .page-link:hover {
        background-color: #007bff;
        color: #fff;
        border-color: #007bff;
    }

    .pagination .page-item.active .page-link {
        background-color: #28a745;
        border-color: #28a745;
        color: #fff;
    }

    .pagination .page-item.disabled .page-link {
        color: #6c757d;
        cursor: not-allowed;
    }

    @media (max-width: 768px) {
        .modern-table {
            display: block;
            overflow-x: auto;
            white-space: nowrap;
        }

        .modern-table th,
        .modern-table td {
            min-width: 100px;
            padding: 5px 8px;
            font-size: 0.8rem;
        }

        .action-btn {
            padding: 4px 8px;
            font-size: 0.75rem;
        }
    }

    @media (max-width: 576px) {
        .modern-table th,
        .modern-table td {
            min-width: 80px;
            font-size: 0.75rem;
            padding: 4px 6px;
        }

        .action-btn {
            padding: 3px 6px;
            font-size: 0.7rem;
        }
    }
   
    /* Style des messages d'erreur */
    .alert-danger {
        padding: 10px;
        margin-bottom: 15px;
        border-radius: 4px;
        font-size: 0.9rem;
    }

    .alert-danger ul {
        margin: 0;
        padding-left: 20px;
    }

    .alert-danger .close {
        position: absolute;
        top: 5px;
        right: 10px;
        color: #fff;
        opacity: 0.8;
    }

    .alert-danger .close:hover {
        opacity: 1;
    }

</style>
@section('content')
    <div class="pcoded-content">
        <!-- Breadcrumb -->
        <div class="page-header mb-2">
            <div class="page-block">
                <div class="row align-items-center">
                    <div class="col-md-12">
                        <div class="page-header-title">
                            <h4 class="m-b-5">Evolution</h4>
                        </div>
                        <ul class="breadcrumb shadow-sm p-2 bg-light rounded">
                            <li class="breadcrumb-item"><a href="{{ route('home_path') }}"><i class="feather icon-home"></i></a></li>
                            <li class="breadcrumb-item"><a href="{{ route('home_path') }}">Accueil</a></li>
                            <li class="breadcrumb-item"><a href="#" style="font-weight: bold;">Dépenses validées</a></li>
                        </ul>
                    </div>
                </div>
            </div>
        </div>
    
        <!-- [ breadcrumb ] end -->
        <div class="pcoded-inner-content" style="margin-top:5px">
            <div class="page-wrapper">
                <div class="page-body">
                    <div class="row">
                        <div class="col-sm-12">
                            <!-- Statistiques -->
                            <div class="row mb-3 g-2">
                               
                            </div>
                            <!-- Zone de recherche -->
                            <div class="card shadow-sm border-0" style="margin-top:-30px">
                                <div class="card-header p-2 bg-dark text-white">
                                    <div class="row align-items-center g-2" id="form_search">
                                        @if ($errors->any())
                                            <div class="col-12">
                                                <div class="alert alert-danger alert-dismissible">
                                                    <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                                                        <i class="far fa-times-circle"></i>
                                                    </button>
                                                    <strong>Erreur(s) :</strong>
                                                    <ul>
                                                        @if ($errors->has('idPolice'))
                                                            <li>{{ $errors->first('idPolice') }}</li>
                                                        @endif
                                                        @if ($errors->has('dateDebut'))
                                                            <li>{{ $errors->first('dateDebut') }}</li>
                                                        @endif
                                                        @if ($errors->has('dateFin'))
                                                            <li>{{ $errors->first('dateFin') }}</li>
                                                        @endif
                                                    </ul>
                                                </div>
                                            </div>
                                        @endif
                                        <!-- Champs cachés (suppression des doublons) -->
                                        @if (isset($garant_defaut))
                                            <input id="codeGcAssureur" name="codeGcAssureur" type="hidden" 
                                                value="{{ is_array($garant_defaut) ? implode(',', $garant_defaut) : $garant_defaut }}">
                                        @endif
                                        @if (isset($idPolice))
                                            <input id="idPolice" name="idPolice" type="hidden" value="{{ $idPolice }}">
                                        @endif
                                        @if (isset($idCollege))
                                            <input id="idCollege" name="idCollege" type="hidden" value="{{ $idCollege }}">
                                        @endif
                                         <!-- Section conditionnelle pour role_id == 4 -->
                                        @if ($role_id == 4)
                                            <div class="col-12 col-md-3">
                                                <div class="form-group mb-0">
                                                    <label for="Garant" class="form-label fw-bold text-white mb-1">Garant</label>
                                                    {{ Form::select('codeGcAssureur', $garants, old('codeGcAssureur'), ['class' => 'js-select2 form-control', 'id' => 'codeGcAssureur']) }}
                                                </div>
                                            </div>
                                            <div class="col-12 col-md-3">
                                                <div class="form-group mb-0">
                                                    <label for="idSouscripteur" class="form-label fw-bold text-white mb-1">Souscripteur</label>
                                                    {{ Form::select('idSouscripteur', $souscripteurs, old('idSouscripteur'), ['class' => 'form-control js-select2', 'id' => 'idSouscripteur']) }}
                                                </div>
                                            </div>
                                            <div class="col-12 col-md-3">
                                                <div class="form-group mb-0">
                                                    <label for="idPolice" class="form-label fw-bold text-white mb-1">Police</label>
                                                    {{ Form::select('idPolice', $polices, old('idPolice'), ['class' => 'form-control js-select2', 'id' => 'idPolice']) }}
                                                </div>
                                            </div>
                                            <div class="col-12 col-md-3">
                                                <div class="form-group mb-0">
                                                    <label for="idCollege" class="form-label fw-bold text-white mb-1">Collège</label>
                                                    {{ Form::select('idCollege', $colleges, old('idCollege'), ['class' => 'form-control js-select2', 'id' => 'idCollege']) }}
                                                </div>
                                            </div>
                                            <div class="col-12 col-md-3">
                                                <div class="form-group mb-0">
                                                    <label for="idCollege" class="form-label fw-bold text-white mb-1">Famille d'acte</label>
                                                    {{ Form::select('codeGarantie', $garanties, $idGarantie ?? old('codeGarantie'), ['class' => 'form-control js-select2', 'id' => 'codeGarantie']) }}
                                                </div>
                                            </div>
                                            <div class="col-12 col-md-3">
                                                <div class="form-group mb-0">
                                                    <label for="idCollege" class="form-label fw-bold text-white mb-1">Prestataire</label>
                                                    {{ Form::select('codePrestataire', $prestataires, $idPrestataire ?? old('codePrestataire'), ['class' => 'form-control js-select2', 'id' => 'codePrestataire']) }}
                                                </div>
                                            </div>
                                            <div class="col-12 col-md-3">
                                                <div class="form-group mb-0">
                                                    <label for="dateDebut" class="form-label fw-bold text-white mb-1">Période du</label>
                                                    {{ Form::date('dateDebut', old('dateDebut'), ['class' => 'form-control datepicker', 'id' => 'dateDebut', 'placeholder' => '< Date d\'enregistrement']) }}
                                                </div>
                                            </div>
                                            <div class="col-12 col-md-3">
                                                <div class="form-group mb-0">
                                                    <label for="dateFin" class="form-label fw-bold text-white mb-1">Au</label>
                                                    {{ Form::date('dateFin', old('dateFin'), ['class' => 'form-control datepicker', 'id' => 'dateFin', 'placeholder' => '> Date d\'enregistrement']) }}
                                                </div>
                                            </div>
                                            <div class="col-12 col-md-3 mt-3">
                                                <button type="button" id="btnEffectifsearch" class="btn btn-success btn-sm btn-round w-100 uniform-btn fw-bold" style="color: black;">
                                                    <i class="fas fa-check me-1"></i> Valider
                                                </button>
                                            </div>
                                        @else
                                            <div class="col-12 col-md-4">
                                                <div class="form-group mb-0">
                                                    <label for="idSouscripteur" class="form-label fw-bold text-white mb-1">Souscripteur</label>
                                                    {{ Form::select('idSouscripteur', $souscripteurs, old('idSouscripteur'), ['class' => 'form-control js-select2', 'id' => 'idSouscripteur']) }}
                                                </div>
                                            </div>
                                            <div class="col-12 col-md-4">
                                                <div class="form-group mb-0">
                                                    <label for="idPolice" class="form-label fw-bold text-white mb-1">Police</label>
                                                    {{ Form::select('idPolice', $polices, old('idPolice'), ['class' => 'form-control js-select2', 'id' => 'idPolice']) }}
                                                </div>
                                            </div>
                                            <div class="col-12 col-md-4">
                                                <div class="form-group mb-0">
                                                    <label for="idCollege" class="form-label fw-bold text-white mb-1">Collège</label>
                                                    {{ Form::select('idCollege', $colleges, old('idCollege'), ['class' => 'form-control js-select2', 'id' => 'idCollege']) }}
                                                </div>
                                            </div>
                                            <div class="col-12 col-md-6">
                                                <div class="form-group mb-0">
                                                    <label for="idCollege" class="form-label fw-bold text-white mb-1">Famille d'acte</label>
                                                    {{ Form::select('codeGarantie', $garanties, $idGarantie ?? old('codeGarantie'), ['class' => 'form-control js-select2', 'id' => 'codeGarantie']) }}
                                                </div>
                                            </div>
                                            <div class="col-12 col-md-6">
                                                <div class="form-group mb-0">
                                                    <label for="idCollege" class="form-label fw-bold text-white mb-1">Prestataire</label>
                                                    {{ Form::select('codePrestataire', $prestataires, $idPrestataire ?? old('codePrestataire'), ['class' => 'form-control js-select2', 'id' => 'codePrestataire']) }}
                                                </div>
                                            </div>
                                            <div class="col-12 col-md-4">
                                                <div class="form-group mb-0">
                                                    <label for="dateDebut" class="form-label fw-bold text-white mb-1">Période du</label>
                                                    {{ Form::date('dateDebut', old('dateDebut'), ['class' => 'form-control datepicker', 'id' => 'dateDebut', 'placeholder' => '< Date d\'enregistrement']) }}
                                                </div>
                                            </div>
                                            <div class="col-12 col-md-4">
                                                <div class="form-group mb-0">
                                                    <label for="dateFin" class="form-label fw-bold text-white mb-1">Au</label>
                                                    {{ Form::date('dateFin', old('dateFin'), ['class' => 'form-control datepicker', 'id' => 'dateFin', 'placeholder' => '> Date d\'enregistrement']) }}
                                                </div>
                                            </div>
                                            <div class="col-12 col-md-4 mt-3">
                                                <button type="button" id="btnDepensesearch" class="btn btn-success btn-sm btn-round w-100 uniform-btn fw-bold" style="color: black;">
                                                    <i class="fas fa-check me-1"></i> Valider
                                                </button>
                                            </div>
                                        @endif
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="card-body p-2" style="background-color: #f8f9fa;">
                                <div id="preview" class="dt-responsive table-responsive">
                                    @include('admin.evolution.depense.items', ['depenses' => $depenses])
                                </div>
                            
                                <!-- Bouton Retour -->
                                <div class="text-center mt-4">
                                    <a  href="{{ url()->previous() }}" onclick="showOverlay()"  class="btn btn-outline-dark rounded-pill" style="font-weight: bold;">
                                        <i class="fas fa-arrow-circle-left me-2"></i> Retour
                                    </a>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</section>

<script>
    document.addEventListener('DOMContentLoaded', function () {
        // Initialisation de Select2
        $(".js-select2").select2({
            closeOnSelect: false
        });
        $(".js-select2-multi").select2({
            closeOnSelect: false
        });

        const tableContainer = document.getElementById('table-container');
        const spinnerDiv = document.createElement('div');
        spinnerDiv.className = 'table-spinner';
        spinnerDiv.innerHTML = '<div class="spinner"></div>';
        tableContainer.appendChild(spinnerDiv);

        // Cacher le spinner une fois la page chargée
        window.addEventListener('load', function() {
            spinnerDiv.style.display = 'none';
        });

        // Fonction pour formater les nombres
        function formatNumber(value) {
            if (value == null || isNaN(value)) return '0';
            return Number(value).toLocaleString('fr-FR', { minimumFractionDigits: 0 });
        }

        // Fonction pour formater les dates
        function formatDate(dateStr) {
            if (!dateStr) return '';
            const date = new Date(dateStr);
            return date.toLocaleDateString('fr-FR', { day: '2-digit', month: '2-digit', year: 'numeric' });
        }

        // Gestion des changements pour charger les souscripteurs, polices, collèges
        $("#codeGcAssureur").on("change", function() {
            const codeGcAssureur = $(this).val();
            if (!codeGcAssureur) return;

            spinnerDiv.style.display = 'flex';
            $.ajax({
                method: "GET",
                url: "{{ url('admin/garantSouscripteur') }}",
                data: { codeGcAssureur: codeGcAssureur },
                success: function(souscripteurs) {
                    const $idSouscripteur = $("#idSouscripteur");
                    $idSouscripteur.empty().append('<option value="">Veuillez sélectionner un souscripteur</option>');
                    if (souscripteurs && souscripteurs.length > 0) {
                        souscripteurs.forEach(function(item) {
                            const souscripteur = item.souscripteur;
                            $idSouscripteur.append(`<option value="${souscripteur.id}">${souscripteur.nom} ${souscripteur.prenoms}</option>`);
                        });
                    }
                    $idSouscripteur.val("").trigger('change');
                },
                error: function(xhr) {
                    console.error('Erreur lors du chargement des souscripteurs:', xhr.responseText);
                    alert('Une erreur est survenue lors du chargement des souscripteurs.');
                },
                complete: function() {
                    spinnerDiv.style.display = 'none';
                }
            });
        });

        $("#idSouscripteur").on("change", function() {
            const idSouscripteur = $(this).val();
            if (!idSouscripteur) return;

            spinnerDiv.style.display = 'flex';
            $.ajax({
                method: "GET",
                url: "{{ url('admin/sousPolice') }}",
                data: { idSouscripteur: idSouscripteur },
                success: function(polices) {
                    const $idPolice = $("#idPolice");
                    $idPolice.empty().append('<option value="">Veuillez sélectionner une police</option>');
                    if (polices && polices.length > 0) {
                        polices.forEach(function(police) {
                            $idPolice.append(`<option value="${police.id}">${police.libellePolice}</option>`);
                        });
                    }
                    $idPolice.val("").trigger('change');
                },
                error: function(xhr) {
                    console.error('Erreur lors du chargement des polices:', xhr.responseText);
                    alert('Une erreur est survenue lors du chargement des polices.');
                },
                complete: function() {
                    spinnerDiv.style.display = 'none';
                }
            });
        });

        $("#idPolice").on("change", function() {
            const idPolice = $(this).val();
            const idSouscripteur = $('#idSouscripteur').val();
            if (!idPolice || !idSouscripteur) return;

            spinnerDiv.style.display = 'flex';
            $.ajax({
                method: "GET",
                url: "{{ url('admin/policeCollege') }}",
                data: { idPolice: idPolice, idSouscripteur: idSouscripteur },
                success: function(colleges) {
                    const $idCollege = $("#idCollege");
                    $idCollege.empty().append('<option value="">Veuillez sélectionner un collège</option>');
                    if (colleges && colleges.length > 0) {
                        colleges.forEach(function(college) {
                            $idCollege.append(`<option value="${college.id}">${college.libelleCollege}</option>`);
                        });
                    }
                    $idCollege.val("");
                },
                error: function(xhr) {
                    console.error('Erreur lors du chargement des collèges:', xhr.responseText);
                    alert('Une erreur est survenue lors du chargement des collèges.');
                },
                complete: function() {
                    spinnerDiv.style.display = 'none';
                }
            });
        });

        // Gestion de la recherche AJAX
        $('#btnDepensesearch').on('click', function() {
            spinnerDiv.style.display = 'flex';

            const formData = {
                codeGcAssureur: $('#codeGcAssureur').val() || null,
                idPolice: $('#idPolice').val() || null,
                idCollege: $('#idCollege').val() || null,
                idSouscripteur: $('#idSouscripteur').val() || null,
                codeGarantie: $('#codeGarantie').val() || null,
                codePrestataire: $('#codePrestataire').val() || null,
                dateDebut: $('#dateDebut').val() || null,
                dateFin: $('#dateFin').val() || null,
                valider: 'valider',
                _token: '{{ csrf_token() }}'
            };

            $.ajax({
                url: '{{ route("admin.depense.indexAll") }}',
                type: 'GET',
                data: formData,
                success: function(response) {
                    if (response.status === 'success') {
                        // Mettre à jour les informations affichées
                        const depenseTitle = $('#depense-title');
                        if (depenseTitle.length) depenseTitle.show();

                        const garantInfo = $('#garant-info');
                        if (garantInfo.length && response.codeGcAssureur) {
                            garantInfo.html(`du Garant <span style="text-align: center; color: blue; font-style: italic; font-weight: bold;">${response.codeGcAssureur}</span>`);
                        } else if (garantInfo.length) {
                            garantInfo.empty();
                        }

                        const policeInfo = $('#police-info');
                        if (policeInfo.length && response.police?.libellePolice) {
                            policeInfo.html(`de la police <span style="text-align: center; color: blue; font-style: italic; font-weight: bold;">${response.police.libellePolice}</span>`);
                        } else if (policeInfo.length) {
                            policeInfo.empty();
                        }

                        const garantieInfo = $('#garantie-info');
                        if (garantieInfo.length && response.garantie?.libelle) {
                            garantieInfo.html(`pour la garantie <span style="text-align: center; color: blue; font-style: italic; font-weight: bold;">${response.garantie.libelle}</span>`);
                        } else if (garantieInfo.length) {
                            garantieInfo.empty();
                        }

                        const prestataireInfo = $('#prestataire-info');
                        if (prestataireInfo.length && response.prestataire?.libellePrestataire) {
                            prestataireInfo.html(`du <span style="text-align: center; color: blue; font-style: italic; font-weight: bold;">${response.prestataire.libellePrestataire}</span>`);
                        } else if (prestataireInfo.length) {
                            prestataireInfo.empty();
                        }

                        $('#date-debut').text(formatDate(response.dateDebut));
                        $('#date-fin').text(formatDate(response.dateFin));

                        // Mettre à jour le tableau
                        const depenseBody = $('#depense-body');
                        if (depenseBody.length) {
                            depenseBody.empty();
                            const depenses = response.depenses?.data || [];
                            if (depenses.length > 0) {
                                depenses.forEach(function(depense) {
                                    const row = `
                                        <tr>
                                            <td>${depense.codeGarant || ''}</td>
                                            <td class="text-left">${depense.libellePolice || ''}</td>
                                            <td class="text-right">${formatNumber(depense.JANVIER)}</td>
                                            <td class="text-right">${formatNumber(depense.FEVRIER)}</td>
                                            <td class="text-right">${formatNumber(depense.MARS)}</td>
                                            <td class="text-right">${formatNumber(depense.AVRIL)}</td>
                                            <td class="text-right">${formatNumber(depense.MAI)}</td>
                                            <td class="text-right">${formatNumber(depense.JUIN)}</td>
                                            <td class="text-right">${formatNumber(depense.JUILLET)}</td>
                                            <td class="text-right">${formatNumber(depense.AOUT)}</td>
                                            <td class="text-right">${formatNumber(depense.SEPTEMBRE)}</td>
                                            <td class="text-right">${formatNumber(depense.OCTOBRE)}</td>
                                            <td class="text-right">${formatNumber(depense.NOVEMBRE)}</td>
                                            <td class="text-right">${formatNumber(depense.DECEMBRE)}</td>
                                            <td class="text-right">${formatNumber(depense.TOTAUX)}</td>
                                        </tr>`;
                                    depenseBody.append(row);
                                });
                                $('#depense-count').show();
                            } else {
                                depenseBody.append('<tr><td colspan="15" class="text-center">Aucune dépense trouvée.</td></tr>');
                                $('#depense-count').hide();
                            }
                        } else {
                            console.error('Element #depense-body introuvable.');
                            alert('Erreur : Impossible de mettre à jour le tableau des dépenses.');
                        }

                        // Mettre à jour la pagination
                        const paginationContainer = $('#table-container .pagination');
                        if (paginationContainer.length && response.depenses?.links) {
                            paginationContainer.replaceWith(response.depenses.links);
                        }
                    } else {
                        console.error('Réponse inattendue:', response);
                        alert('Erreur : Réponse inattendue du serveur.');
                    }
                },
                error: function(xhr) {
                    console.error('Erreur AJAX:', xhr.responseText);
                    let errorMessage = xhr.responseJSON?.message || 'Une erreur est survenue.';
                    if (xhr.status === 422) {
                        errorMessage = Object.values(xhr.responseJSON.errors).flat().join('<br>');
                    }
                    $('#errorContainer').html(`<div class="alert alert-danger">${errorMessage}</div>`);
                },
                complete: function() {
                    spinnerDiv.style.display = 'none';
                }
            });
        });
    });
</script>

@endsection