@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>
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.11.3/font/bootstrap-icons.min.css">
<style>
    .btn-light {
        background-color: #ffffff;
        color: #333;
    }
    .btn-light:hover {
        background-color: #f1f1f1;
        transform: translateY(-2px);
        box-shadow: 0 6px 12px rgba(0, 0, 0, 0.15);
    }
    .btn-primary {
        background-color: rgb(220, 188, 140);
        border-color: rgb(220, 188, 140);
        color: #333;
    }
    .btn-primary:hover {
        background-color: rgb(200, 168, 120);
        border-color: rgb(200, 168, 120);
        transform: translateY(-2px);
        box-shadow: 0 6px 12px rgba(0, 0, 0, 0.15);
    }

    /* Spinner pour le téléchargement PDF et pagination */
    .pdf-spinner {
        position: fixed;
        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: 1000;
        opacity: 0;
        transition: opacity 0.3s ease-in-out;
    }

    .pdf-spinner.active {
        display: flex;
        opacity: 1;
    }

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

    .spinner-text {
        margin-left: 15px;
        font-size: 1.2rem;
        color: #28a745;
        font-weight: bold;
    }

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

    /* Message d'erreur personnalisé */
    .error-message {
        color: #dc3545;
        font-size: 0.9rem;
        margin-top: 5px;
        display: none;
    }

       .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>
@section('content')
<div class="pcoded-content">
    <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">Etats</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 par famille </a></li>
                    </ul>
                </div>
            </div>
        </div>
    </div>
    <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">
                        <div class="card shadow-sm border-0" >
                            <div class="card-header p-2 bg-dark text-white">
                                {{ Form::open(['route' => 'admin.etat.validerDepenseFamille', 'method' => 'GET', 'id' => 'form_statistique']) }}
                                <input id="version" name="version" type="hidden" value="{{$version ?? ''}}">
                                <div class="row align-items-center g-2">
                                    <div class="col-md-3">
                                        <div class="form-group mb-0">
                                            <label for="idSouscripteur" class="form-label fw-bold text-white mb-1">Adhérent</label>
                                            {{ Form::text('adherent', isset($adherent) ? $adherent: old('adherent'), ['class' => ' form-control', 'id' => 'adherent','placeholder'=>"Numéro Adhérent ou Nom Adhérent"]) }}
                                            <div id="idSouscripteur-error" class="error-message"></div>
                                        </div>
                                    </div>
                                    <div class="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' => 'js-select2 form-control', 'id' => 'idSouscripteur', 'required']) }}
                                            <div id="idSouscripteur-error" class="error-message"></div>
                                        </div>
                                    </div>
                                    <div class="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' => 'js-select2 form-control', 'id' => 'idPolice']) }}
                                            <div id="idPolice-error" class="error-message"></div>
                                        </div>
                                    </div>
                                    <div class="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-md-3">
                                        <div class="form-group mb-0">
                                            <label for="idDepense" class="form-label fw-bold text-white mb-1">Montant supérieur</label>
                                            {{ Form::text('idDepense', $idDepense ?? old('idDepense'), ['class' => 'form-control', 'id' => 'idDepense']) }}
                                        </div>
                                    </div>
                                    <div class="col-md-3">
                                        <div class="form-group mb-0">
                                            <label for="dateDebut" class="form-label fw-bold text-white mb-1">Période de *</label>
                                            {{ Form::date('dateDebut', $dateDebut ?? old('dateDebut'), ['class' => 'form-control datepicker', 'id' => 'dateDebut', 'required']) }}
                                            <div id="dateDebut-error" class="error-message"></div>
                                        </div>
                                    </div>
                                    <div class="col-md-3">
                                        <div class="form-group mb-0">
                                            <label for="dateFin" class="form-label fw-bold text-white mb-1">à *</label>
                                            {{ Form::date('dateFin', $dateFin ?? old('dateFin'), ['class' => 'form-control datepicker', 'id' => 'dateFin', 'required']) }}
                                            <div id="dateFin-error" class="error-message"></div>
                                        </div>
                                    </div>
                                    <div class="col-md-3 mt-3">
                                        <button onclick="showOverlay()" type="submit" 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>
                                </div>
                                {{ Form::close() }}
                            </div>  
                            <div id="modal-container"></div>
                            <div class="card-body p-2" style="background-color: #f8f9fa;">
                                <div id="preview" class="dt-responsive table-responsive">
                                   <!-- Tableau des souscripteurs -->
                                        @isset ($depenseFamilles)
                                            <div class="table-responsive" id="table-container">
                                                <table class="modern-table" id="souscripteurs-table">
                                                    <thead>
                                                        <tr>
                                                            <th class="text-center">Famille</th>
                                                            <th class="text-center">Pop. active</th>
                                                            <th class="text-center">Pop traitée</th>
                                                            <th class="text-center">Montant Réclamé</th>
                                                            <th class="text-center">Montant Remboursé</th>
                                                            <th class="text-center">Montant Non Remb.</th>
                                                            <th class="text-center">Coût moyen </th>
                                                        </tr>
                                                    </thead>
                                                    <tbody>
                                                         @php
                                                            $total_popActive = 0;
                                                            $total_popTraite = 0;
                                                            $total_montantReclame = 0;
                                                            $total_montantNonRembourse = 0;
                                                            $total_montantRembourse = 0;
                                                            $total_coutMoyen = 0;
                                                            $total_taux = 0;
                                                        @endphp

                                                        @foreach ( $depenseFamilles as $depenseFamille )
                                                        @php
                                                            (int)$total_popActive = (int)$total_popActive + ((int)$depenseFamille->popActive);
                                                            (int)$total_popTraite = (int)$total_popTraite + (int)($depenseFamille->popTraite);
                                                            (int)$total_montantReclame = (int)$total_montantReclame+ (int)$depenseFamille->montantReclame; 
                                                            (int)$total_montantNonRembourse = (int)$total_montantNonRembourse+ (int)$depenseFamille->NonRembourse; 
                                                            (int)$total_montantRembourse = (int)$total_montantRembourse+ (int)$depenseFamille->montantRembourse; 
                                                            (int)$total_coutMoyen = (int)$total_coutMoyen + (int)$depenseFamille->Coutmoyen; 
                                                        @endphp
                                                        <tr style=" font-weight: bold; font-size: 9px;">
                                                            <td>{{ $depenseFamille->numeroAdherent }} - {{ $depenseFamille->adherent }}</td>
                                                            <td class="text-center"> {{$depenseFamille->popActive}} </td>

                                                            <td class="text-center">{{ $depenseFamille->popTraite }} </td>
                                                            <td class="text-center"><div>{{ number_format($depenseFamille->montantReclame, 0, '', ' ') }}</div></td>
                                                            <td class="text-center">{{ number_format($depenseFamille->montantRembourse, 0, '', ' ') }}</td>
                                                            <td class="text-center" >{{ number_format($depenseFamille->NonRembourse, 0, '', ' ') }} </td>
                                                            <td class="text-center"  style="margin: 10px;">{{ number_format($depenseFamille->Coutmoyen, 0, '', ' ') }} </td>
                                                        </tr>
                                                        @endforeach
                                                    </tbody>
                                                </table>
                                            </div>
                                        @endif
                                  
                                </div>  
                                <div class="text-center mt-4">
                                    <a onclick="showOverlay()" href="{{ url()->previous() }}" 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>
</div>

<script>
    $(document).ready(function() {
        $(".js-select2").select2({
            closeOnSelect: false
        });

        /* const spinnerDiv = document.createElement('div');
        spinnerDiv.className = 'pdf-spinner';
        spinnerDiv.innerHTML = '<div class="spinner"></div><span class="spinner-text">Génération en cours...</span>';
        document.body.appendChild(spinnerDiv);
        */
        $('#form_statistique').on('submit', function(e) {
            const dateDebutVal = $('#dateDebut').val();
            const dateFinVal = $('#dateFin').val();
            const idSouscripteurVal = $('#idSouscripteur').val();

            $('#dateDebut-error').text('').hide();
            $('#dateFin-error').text('').hide();
            $('#idSouscripteur-error').text('').hide();

            let hasError = false;

            if (!idSouscripteurVal || idSouscripteurVal === '') {
                $('#idSouscripteur-error').text('Veuillez sélectionner un souscripteur.').show();
                hasError = true;
            }

            if (!dateDebutVal) {
                $('#dateDebut-error').text('Veuillez sélectionner une date de début.').show();
                hasError = true;
            }

            if (!dateFinVal) {
                $('#dateFin-error').text('Veuillez sélectionner une date de fin.').show();
                hasError = true;
            } else {
                const dateDebut = new Date(dateDebutVal);
                const dateFin = new Date(dateFinVal);
                if (isNaN(dateDebut.getTime()) || isNaN(dateFin.getTime())) {
                    $('#dateDebut-error').text('Les dates doivent être valides.').show();
                    $('#dateFin-error').text('Les dates doivent être valides.').show();
                    hasError = true;
                } else if (dateDebut > dateFin) {
                    $('#dateDebut-error').text('La date de début ne peut pas être postérieure à la date de fin.').show();
                    $('#dateFin-error').text('La date de fin doit être postérieure ou égale à la date de début.').show();
                    hasError = true;
                }
            }

            if (hasError) {
                e.preventDefault();
                return false;
            }

            spinnerDiv.classList.add('active');
        });

        $('#pdf_form').on('submit', function(e) {
            spinnerDiv.classList.add('active');
            setTimeout(() => {
                spinnerDiv.classList.remove('active');
            }, 10000);
        });

        const paginationLinks = document.querySelectorAll('.pagination .page-link');
        paginationLinks.forEach(link => {
            link.addEventListener('click', function(e) {
                if (this.parentElement.classList.contains('disabled')) {
                    return;
                }
                spinnerDiv.classList.add('active');
                if (typeof showOverlay === 'function') {
                    showOverlay();
                }
            });
        });

        window.addEventListener('load', function() {
            spinnerDiv.classList.remove('active');
        });
    });

    $("#idSouscripteur").on("change", function() {
        var idSouscripteur = $(this).val();
        $.ajax({
            method: "GET",
            data: { idSouscripteur: idSouscripteur },
            url: "{{ url('admin/sousPolice') }}",
        }).done(function(polices) {
            var result = '<option value="">Veuillez sélectionner une police</option>';
            for (var i = 0; i < polices.length; i++) {
                result += '<option value="' + polices[i].id + '">' + polices[i].libellePolice + '</option>';
            }
            $("#idPolice").find("option").remove().end().append(result).val("");
        });
    });

    $("#idPolice").on("change", function() {
        var idPolice = $(this).val();
        var idSouscripteur = $('#idSouscripteur').val();
        $.ajax({
            method: "GET",
            data: { idPolice: idPolice, idSouscripteur: idSouscripteur },
            url: "{{ url('admin/policeCollege') }}",
        }).done(function(colleges) {
            var result = '<option value="">Veuillez sélectionner un collège</option>';
            for (var i = 0; i < colleges.length; i++) {
                result += '<option value="' + colleges[i].id + '">' + colleges[i].libelleCollege + '</option>';
            }
            $("#idCollege").find("option").remove().end().append(result).val("");
        });
    });
</script>
@endsection