@extends('layout.template')
@section('title', 'ICAT | Reporte Estatus Pagos')
@section('content')
    <div class="content-body">
        <div class="container-fluid">
            <div class="row page-titles mx-0 mt-4 shadow-sm" style="border-radius: 12px; border: none; background: white;">
                <div class="col-sm-12 p-md-0 card-body">
                    <h3 class="mb-2">Reporte Pago PSC</h3>
                    <form id="filtroForm">
                        @csrf
                        <div class="d-flex flex-wrap gap-4 mb-2 mt-3 justify-content-between">
                            <div class="d-flex flex-wrap gap-4">

                                <div class="filter-dropdown-container">
                                    <label class="text-dark mb-1 d-block"
                                        style="font-size: 0.9rem; margin-bottom: 2px !important;">Seleccionar
                                        unidades:</label>
                                    <button type="button" id="btnSelectedUnits"
                                        class="btn btn-dark d-flex align-items-center justify-content-between shadow-sm filter-toggle-btn"
                                        style="min-width: 200px; border-radius: 8px; padding: 0.6rem 1rem; border: 1px solid #dddddd; background: #eeeeee;">
                                        <span id="selectedUnitsText" class="text-dark">Unidades</span>
                                        <i class=" ri-building-line ms-2 text-dark"></i>
                                    </button>

                                    <div class="filter-dropdown-menu shadow-lg" id="dropdownUnidades">
                                        <div class="filter-dropdown-header">
                                            <h5 class="text-dark mb-0">Seleccionar Unidades</h5>
                                            <div class="d-flex">
                                                <button type="button" class="btn btn-xxs btn-primary"
                                                    id="btnSelectAllUnits" style="font-size: 0.7rem;">Seleccionar
                                                    Todas</button>
                                            </div>
                                        </div>
                                        <div class="filter-dropdown-body">
                                            <div class="row compact-row" id="unidadesList">
                                                @foreach ($unidades as $un)
                                                    <div class="col-md-6 col-12">
                                                        <label class="unit-checkbox-label">
                                                            <input type="checkbox" name="unidades[]" class="unit-check me-2"
                                                                value="{{ $un->identificador }}"
                                                                data-name="{{ $un->nombre_corto }}">
                                                            <span>{{ $un->nombre_corto }}</span>
                                                        </label>
                                                    </div>
                                                @endforeach
                                            </div>
                                        </div>
                                    </div>
                                    <div id="errorUnidad" class="text-danger filter-error-msg">
                                        <i class=" ri-error-warning-line me-1"></i>Seleccionar unidad
                                    </div>
                                </div>

                                <div class="filter-dropdown-container">
                                    <label class="text-dark mb-1 d-block"
                                        style="font-size: 0.9rem; margin-bottom: 2px !important;">Tipo de curso:</label>
                                    <button type="button" id="btnSelectedTypes"
                                        class="btn btn-dark d-flex align-items-center justify-content-between shadow-sm filter-toggle-btn"
                                        style="min-width: 200px; border-radius: 8px; padding: 0.6rem 1rem; border: 1px solid #dddddd; background: #eeeeee;">
                                        <span id="selectedTypesText" class="text-dark">Tipo de curso</span>
                                        <i class=" ri-list-check ms-2 text-dark"></i>
                                    </button>

                                    <div class="filter-dropdown-menu shadow-lg" id="dropdownTipos">
                                        <div class="filter-dropdown-header">
                                            <h5 class="text-dark mb-0">Seleccionar tipo de curso</h5>
                                            <div class="d-flex justify-content-end ">
                                                <button type="button" class="btn btn-xxs btn-outline-light"
                                                    style="background: #fefefe;" id="btnSelectAllTypes"
                                                    style="font-size: 0.7rem;">Seleccionar Todos</button>
                                            </div>
                                        </div>
                                        <div class="filter-dropdown-body">
                                            <div class="row compact-row">
                                                @foreach ($tiposCursos as $tipo)
                                                    <div class="col-md-6 col-12">
                                                        <label class="unit-checkbox-label">
                                                            <input type="checkbox" name="tipos[]" class="type-check me-2"
                                                                value="{{ $tipo->id }}"
                                                                data-name="{{ $tipo->nombre }}">
                                                            <span>{{ $tipo->nombre }}</span>
                                                        </label>
                                                    </div>
                                                @endforeach
                                            </div>
                                        </div>
                                    </div>
                                    <div id="errorTipo" class="text-danger filter-error-msg">
                                        <i class=" ri-error-warning-line me-1"></i>Seleccionar tipo
                                    </div>
                                </div>

                                <div class="filter-dropdown-container">
                                    <label class="text-dark mb-1 d-block"
                                        style="font-size: 0.9rem; margin-bottom: 2px !important;">Seleccionar meses:</label>
                                    <button type="button" id="btnSelectedMonths"
                                        class="btn btn-dark d-flex align-items-center justify-content-between shadow-sm filter-toggle-btn"
                                        style="min-width: 200px; border-radius: 8px; padding: 0.6rem 1rem; border: 1px solid #dddddd; background: #eeeeee;">
                                        <span id="selectedMonthsText" class="text-dark">Meses</span>
                                        <i class=" ri-calendar-line ms-2 text-dark"></i>
                                    </button>

                                    <div class="filter-dropdown-menu shadow-lg" id="dropdownMeses">
                                        <div class="filter-dropdown-header">
                                            <h5 class="text-dark mb-0">Seleccionar Meses</h5>
                                            <div class="d-flex justify-content-end ">
                                                <button type="button" class="btn btn-xxs btn-outline-light"
                                                    style="background: #fefefe;" id="btnSelectAllMonths"
                                                    style="font-size: 0.7rem;">Seleccionar Todos</button>
                                            </div>
                                        </div>
                                        <div class="filter-dropdown-body">
                                            <div class="row compact-row">
                                                @foreach ($meses as $mes)
                                                    <div class="col-md-6 col-12">
                                                        <label class="unit-checkbox-label">
                                                            <input type="checkbox" name="meses[]" class="month-check me-2"
                                                                value="{{ $mes->numero }}"
                                                                data-name="{{ $mes->nombre }}">
                                                            <span>{{ $mes->nombre }}</span>
                                                        </label>
                                                    </div>
                                                @endforeach
                                            </div>
                                        </div>
                                    </div>
                                    <div id="errorMes" class="text-danger filter-error-msg">
                                        <i class=" ri-error-warning-line me-1"></i>Seleccionar mes
                                    </div>
                                </div>

                                <div class="filter-dropdown-container">
                                    <label class="text-dark mb-1 d-block"
                                        style="font-size: 0.9rem; margin-bottom: 2px !important;">Seleccionar año:</label>
                                    <button type="button" id="btnSelectedYear"
                                        class="btn btn-dark d-flex align-items-center justify-content-between shadow-sm filter-toggle-btn"
                                        style="min-width: 150px; border-radius: 8px; padding: 0.6rem 1rem; border: 1px solid #dddddd; background: #eeeeee;">
                                        <span id="selectedYearText" class="text-dark">{{ date('Y') }}</span>
                                        <i class=" ri-calendar-check-line ms-2 text-dark"></i>
                                    </button>

                                    <div class="filter-dropdown-menu shadow-lg" id="dropdownYear"
                                        style="min-width: 150px;">
                                        <div class="filter-dropdown-header">
                                            <h5 class="text-dark mb-0">Año</h5>
                                        </div>
                                        <div class="filter-dropdown-body">
                                            <div class="row compact-row">
                                                @foreach ($anios as $anio)
                                                    <div class="col-12">
                                                        <label class="unit-checkbox-label">
                                                            <input type="radio" name="anio" class="year-radio me-2"
                                                                value="{{ $anio }}"
                                                                {{ $anio == date('Y') ? 'checked' : '' }}>
                                                            <span>{{ $anio }}</span>
                                                        </label>
                                                    </div>
                                                @endforeach
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                <div class="filter-dropdown-container">
                                    <label class="text-dark mb-1 d-block"
                                        style="font-size: 0.9rem; margin-bottom: 2px !important;">&nbsp;</label>
                                    <button type="submit" class="btn btn-primary shadow-sm"
                                        style="border-radius: 8px; padding: 0.6rem 1.5rem; font-weight: 600;">
                                        <i class=" ri-search-line me-2"></i>Buscar
                                    </button>
                                </div>
                            </div>

                            <!--<div class="filter-dropdown-container">
                                                        <label class="text-dark mb-1 d-block"
                                                            style="font-size: 0.9rem; margin-bottom: 2px !important;">&nbsp;</label>
                                                        <button type="submit" class="btn btn-primary shadow-sm"
                                                            style="border-radius: 8px; padding: 0.6rem 1.5rem; font-weight: 600;">
                                                            <i class=" ri-search-line me-2"></i>Buscar
                                                        </button>
                                                    </div>-->
                        </div>

                    </form>
                </div>
                <div class="col-sm-6 p-md-0 justify-content-sm-end mt-2 mt-sm-0 d-flex"
                    style="position: absolute; right: 30px; top: 20px;">
                    <ol class="breadcrumb">
                        <a href="{{ url('reportes') }}" class="btn btn-rounded btn-dark back-fixed"
                            aria-label="Regresar">
                            <span class="btn-icon-start text-dark"><i class=" ri-arrow-left-line"></i></span>
                            Regresar
                        </a>
                    </ol>
                </div>
            </div>

            <div class="row">
                <div class="col-12">
                    <div class="card shadow-sm"
                        style="border-radius: 12px; border: none; position: relative; overflow: hidden;">
                        <div class="top-loader-container">
                            <div class="top-loader-bar" id="top-loader"></div>
                        </div>

                        <div class="card-body">
                            <div class="d-flex justify-content-between align-items-center mb-4">
                                <h4 class="card-title mb-0" style="font-weight: 700; color: #2C3E50;"></h4>
                                <button type="button" id="exportExcelBtn" class="btn btn-success shadow-sm" disabled
                                    style="border-radius: 8px; font-weight: 600;">
                                    <i class=" ri-file-excel-2-line me-2"></i>Exportar a Excel
                                </button>
                            </div>
                            <div class="w-100 table-responsive">
                                <table id="tablaEstatusPagos"
                                    class="table table-striped responsive w-100 display dataTable no-footer">
                                    <thead class="custom-thead">
                                        <tr>
                                            <th>Clave Aula</th>
                                            <th>Nombre</th>
                                            <th>Apellido Paterno</th>
                                            <th>Apellido Materno</th>
                                            <th>CURP PSC</th>
                                            <th>RFC PSC</th>
                                            <th>HRS. PAGAR</th>
                                            <th>Fuente</th>
                                            <th>E PAGO</th>
                                            <th>ESTATUS AULA</th>
                                            <th>UNIDAD</th>
                                            <th>FOLIO FACTURA</th>
                                            <th>NOMBRE CURSO</th>
                                            <th>MES</th>
                                            <th>HRS. FACTURA</th>
                                            <th>CAPACITANDOS</th>
                                            <th>Subtotal</th>
                                            <th>IVA</th>
                                            <th>ISR</th>
                                            <th>TOTAL</th>
                                            <th># PARCIALIDAD</th>
                                            <th>FECHA PAGO</th>
                                            <th>MES PAGO</th>
                                            <th>FECH. REGISTRO FACTURA</th>
                                            <th>NOMBRE PSC</th>
                                            <th>FALTAS PSC</th>
                                            <th>INICIA</th>
                                            <th>TERMINA</th>
                                            <th>DURACIÓN HRS.</th>
                                            <th>CONTRATO</th>
                                            <th>FECHA REPORTE HORAS</th>
                                            <th>OBSERVACIONES FINANCIEROS</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <div class="modal fade" id="progressModal" tabindex="-1" role="dialog" aria-labelledby="progressModalLabel"
        aria-hidden="true" data-bs-backdrop="static" data-bs-keyboard="false">
        <div class="modal-dialog modal-dialog-centered" role="document">
            <div class="modal-content"
                style="border-radius: 15px; border: none; box-shadow: 0 10px 30px rgba(0,0,0,0.1);">
                <div class="modal-header border-0 pb-0">
                    <h5 class="modal-title" id="progressModalLabel" style="font-weight: 700; color: #333;">Exportando a
                        Excel</h5>
                </div>
                <div class="modal-body text-center pb-4 pt-3">
                    <p id="progressStatus" class="mb-3" style="font-weight: 600; color: #444;">Preparando descarga...
                    </p>
                    <div class="progress" style="height: 12px; border-radius: 10px; background: #e9ecef; margin: 0 20px;">
                        <div id="progressBar" class="progress-bar progress-bar-striped progress-bar-animated bg-success"
                            role="progressbar" aria-valuenow="0" aria-valuemin="0" aria-valuemax="100"
                            style="width: 0%; border-radius: 10px;"></div>
                    </div>
                    <p id="progressPercent" class="mt-2 mb-0"
                        style="font-size: 0.85rem; color: #6c757d; font-weight: 600;">0%</p>
                </div>
            </div>
        </div>
    </div>
    <style>
        .custom-thead {
            background: #E7EBEF !important;
        }

        .custom-thead th {
            color: #444 !important;
            border-bottom: 1px solid #dee2e6 !important;
            padding: 12px 15px !important;
            font-weight: 600 !important;
            text-transform: uppercase;
            font-size: 0.85rem;
        }

        #tablaEstatusPagos tbody td {
            font-weight: 600;
            color: #4a4a4a;
            vertical-align: middle;
            font-size: 0.85rem;
        }

        .filter-dropdown-container {
            position: relative;
            display: inline-block;
            padding-bottom: 5px;
        }

        .filter-error-msg {
            position: absolute;
            bottom: -18px;
            left: 5px;
            font-size: 0.8rem;
            font-weight: 600;
            display: none;
            white-space: nowrap;
        }

        .top-loader-container {
            position: absolute;
            top: 0;
            left: 0;
            width: 100%;
            height: 3px;
            background: transparent;
            overflow: hidden;
            z-index: 10;
        }

        .top-loader-bar {
            width: 0%;
            height: 100%;
            background: #556ee6;
            transition: width 0.3s ease;
        }

        .filter-dropdown-menu {
            display: none;
            position: absolute;
            border: 1px solid #2C3E5050;
            top: 100%;
            left: 0;
            z-index: 1000;
            min-width: 400px;
            background-color: #fff;
            border-radius: 12px;
            overflow: hidden;
            margin-top: 5px;
            transform-origin: top left;
            animation: growAnimation 0.2s ease-out forwards;
        }

        @keyframes growAnimation {
            from {
                transform: scale(0.8);
                opacity: 0;
            }

            to {
                transform: scale(1);
                opacity: 1;
            }
        }

        .filter-dropdown-menu.show {
            display: block;
        }

        .filter-dropdown-header {
            padding: 0.8rem;
            color: white;
            display: flex;
            justify-content: space-between;
            align-items: center;
        }

        .filter-dropdown-body {
            padding: 0 1.2rem 1.2rem 1.2rem;
            max-height: 400px;
            overflow-y: auto;
        }

        .unit-checkbox-label {
            cursor: pointer;
            padding: 5px 8px;
            border-radius: 6px;
            transition: background 0.2s;
            display: flex;
            align-items: center;
            width: 100%;
            margin-bottom: 2px;
            font-size: 0.85rem;
        }

        .unit-checkbox-label:hover {
            background-color: #f1f1f1;
        }

        .compact-row {
            margin-right: -5px;
            margin-left: -5px;
        }

        .compact-row>[class*="col-"] {
            padding-right: 5px;
            padding-left: 5px;
        }

        .transform-0.9 {
            transform: scale(0.9);
        }

        .empty-state-container {
            padding: 4rem 1rem;
            text-align: center;
        }

        .empty-state-icon {
            font-size: 4rem;
            color: #e2e8f0;
            margin-bottom: 1.5rem;
        }

        .empty-state-title {
            font-size: 1.25rem;
            font-weight: 700;
            color: #475569;
            margin-bottom: 0.5rem;
        }

        .empty-state-text {
            color: #94a3b8;
            max-width: 300px;
            margin: 0 auto;
        }

        @media screen and (max-width: 576px) {
            .filter-dropdown-menu {
                min-width: 300px;
                position: fixed;
                top: 50%;
                left: 50%;
                transform: translate(-50%, -50%) !important;
                margin-top: 0;
                width: 90%;
            }
        }
    </style>


@endsection


@push('scripts')


    <script src="https://cdn.datatables.net/buttons/2.4.2/js/dataTables.buttons.min.js"></script>

    <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.10.1/jszip.min.js"></script>

    <script src="https://cdn.datatables.net/buttons/2.4.2/js/buttons.html5.min.js"></script>

    <script src="https://cdn.datatables.net/buttons/2.4.2/js/buttons.print.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/xlsx/dist/xlsx.full.min.js"></script>

    <script>
        $('#tablaEstatusPagos').on('draw.dt', function() {
            $('#tablaEstatusPagos').DataTable().columns.adjust();
        });


        $('.filter-toggle-btn').on('click', function(e) {
            e.stopPropagation();
            let $target = $(this).siblings('.filter-dropdown-menu');
            $('.filter-dropdown-menu').not($target).removeClass('show');
            $('.filter-toggle-btn').not(this).removeClass('transform-0.9');
            $(this).toggleClass('transform-0.9');
            $target.toggleClass('show');
        });
        $(document).on('click', function(e) {
            if (!$(e.target).closest('.filter-dropdown-container').length) {
                $('.filter-dropdown-menu').removeClass('show');
                $('.filter-toggle-btn').removeClass('transform-0.9');
            }
        });

        function updateSelectedText(checkboxClass, textId, defaultText) {
            let selected = [];
            $(`.${checkboxClass}:checked`).each(function() {
                selected.push($(this).data('name'));
            });
            if (selected.length === 0) $(`#${textId}`).text(defaultText);
            else if (selected.length === 1) $(`#${textId}`).text(selected[0]);
            else $(`#${textId}`).text(`${selected.length} seleccionados`);
        }

        function showValidationError(selector) {
            $(selector).fadeIn();
            setTimeout(() => $(selector).fadeOut(), 3000);
        }

        $('.unit-check').on('change', function() {
            updateSelectedText('unit-check', 'selectedUnitsText', 'Unidades');
            if ($('.unit-check:checked').length > 0) $('#errorUnidad').fadeOut();
        });
        $('.month-check').on('change', function() {
            updateSelectedText('month-check', 'selectedMonthsText', 'Meses');
            if ($('.month-check:checked').length > 0) $('#errorMes').fadeOut();
        });
        $('.type-check').on('change', function() {
            updateSelectedText('type-check', 'selectedTypesText', 'Tipo de curso');
            if ($('.type-check:checked').length > 0) $('#errorTipo').fadeOut();
        });
        $('.year-radio').on('change', function() {
            $('#selectedYearText').text($(this).val());
            $('#dropdownYear').removeClass('show');
            $('.filter-toggle-btn').removeClass('transform-0.9');
        });

        $('#btnSelectAllUnits').on('click', function() {
            let allChecked = $('.unit-check:not(:checked)').length === 0;
            $('.unit-check').prop('checked', !allChecked).trigger('change');
        });
        $('#btnSelectAllMonths').on('click', function() {
            let allChecked = $('.month-check:not(:checked)').length === 0;
            $('.month-check').prop('checked', !allChecked).trigger('change');
        });
        $('#btnSelectAllTypes').on('click', function() {
            let allChecked = $('.type-check:not(:checked)').length === 0;
            $('.type-check').prop('checked', !allChecked).trigger('change');
        });

        let isInitialized = false;
        let table = $('#tablaEstatusPagos').DataTable({
            /* responsive: true,
             processing: true,
             serverSide: true,*/
            //scrollX: true, // activa scroll horizontal
            responsive: false, //  quita el "+"
            autoWidth: false,
            //processing: true,
            //serverSide: true,
            ajax: {
                url: "{{ route('reportes.estatus.pagos.data2') }}",
                type: "POST",
                data: function(d) {
                    if (!isInitialized) d.initial = 'true';
                    var formData = $('#filtroForm').serializeArray();
                    $.each(formData, function(i, field) {
                        if (field.name.includes('[]')) {
                            let cleanName = field.name.replace('[]', '');
                            if (!d[cleanName]) d[cleanName] = [];
                            d[cleanName].push(field.value);
                        } else {
                            d[field.name] = field.value;
                        }
                    });
                    d._token = $('input[name="_token"]').val();
                }
            },
            buttons: [{
                extend: 'excelHtml5',
                text: 'Exportar Excel'
            }],
            columns: [{
                    data: 'clave_aula'
                },
                {
                    data: 'nombre'
                },
                {
                    data: 'apellido_paterno'
                },
                {
                    data: 'apellido_materno'
                },
                {
                    data: 'curp'
                },
                {
                    data: 'rfc_psc'
                },
                {
                    data: 'hrs_pagar',
                    className: 'text-center'
                },
                {
                    data: 'fuente'
                },
                {
                    //data: 'estatus_pago'
                    data: 'estatus_pago',
                    render: function(data, type, row) {
                        let clase = '';
                        let texto = row.estatus_pago ?? data;

                        switch (row.estatus_pago) {
                            case 'Por pagar':
                                clase = 'text-danger';
                                break;
                            case 'Pagada':
                                clase = 'text-success';
                                break;
                            default:
                                clase = 'text-secondary';
                        }

                        return `<span class="${clase} fw-bold">${texto}</span>`;
                    }
                },
                {
                    data: 'estatus_aula',
                    className: 'text-center'
                },
                {
                    data: 'unidad'
                },
                {
                    data: 'folio_factura',
                    className: 'text-nowrap'
                },
                {
                    data: 'nombre_curso'
                },
                {
                    data: 'mes_corresponde',
                    className: 'text-center'
                },
                {
                    data: 'hrs_factura',
                    className: 'text-center'
                },
                {
                    data: 'capacitandos',
                    className: 'text-center'
                },
                {
                    data: 'subtotal',
                    className: 'text-center'
                },
                {
                    data: 'iva',
                    className: 'text-center'
                },
                {
                    data: 'isr',
                    className: 'text-center'
                },
                {
                    data: 'total',
                    className: 'text-center'
                },
                {
                    data: 'parcialidad',
                    className: 'text-center'
                },
                {
                    data: 'fecha_pago'
                },
                {
                    data: 'mes_pago'
                },
                {
                    data: 'fecha_registro_factura'
                },
                {
                    data: 'nombre_psc'
                },
                {
                    data: 'faltas_psc',
                    className: 'text-center'
                },
                {
                    data: 'inicia'
                },
                {
                    data: 'termina'
                },
                {
                    data: 'duracion_hrs',
                    className: 'text-center'
                },
                {
                    data: 'contrato'
                },
                {
                    data: 'fecha_reporte_horas'
                },
                {
                    data: 'observaciones'
                }
            ],
            initComplete: function() {
                this.api().columns.adjust();
            },
            preDrawCallback: function() {
                $('#top-loader').css('width', '30%');
            },
            drawCallback: function(settings) {
                $('#top-loader').css('width', '100%');
                setTimeout(() => $('#top-loader').css('width', '0%'), 400);
                $('#exportExcelBtn').prop('disabled', settings.aoData.length === 0);
                isInitialized = true;
                $('#filtroForm button[type="submit"]').prop('disabled', false).html(
                    '<i class=" ri-search-line me-2"></i>Buscar');
            }
        });



        $('#filtroForm').on('submit', function(e) {
            e.preventDefault();
            if ($('.unit-check:checked').length === 0) {
                showValidationError('#errorUnidad');
                return false;
            }
            if ($('.month-check:checked').length === 0) {
                showValidationError('#errorMes');
                return false;
            }
            if ($('.type-check:checked').length === 0) {
                showValidationError('#errorTipo');
                return false;
            }
            $(this).find('button[type="submit"]').prop('disabled', true).html(
                '<i class=" ri-loader-4-line ri-spin me-2"></i>Buscando...');
            isInitialized = true;
            table.ajax.reload();
        });

        $('#exportExcelBtn').on('click', function() {

            let datos = table.rows({
                search: 'applied'
            }).data().toArray();

            const excelData = datos.map(row => ({
                'CLAVE AULA': row.clave_aula || '',
                'NOMBRE': row.nombre || '',
                'AP PATERNO': row.apellido_paterno || '',
                'AP MATERNO': row.apellido_materno || '',
                'CURP': row.curp || '',
                'RFC': row.rfc_psc || '',
                'HRS PAGO': row.hrs_pagar || '',
                'FUENTE': row.fuente || '',
                'ESTATUS PAGO': row.estatus_pago || '',
                'ESTATUS AULA': row.estatus_aula || '',
                'UNIDAD': row.unidad || '',
                'FOLIO FACTURA': row.folio_factura || '',
                'CURSO': row.nombre_curso || '',
                'MES CORRESPONDE': row.mes_corresponde || '',
                'HRS FACTURA': row.hrs_factura || '',
                'CAPACITANDOS': row.capacitandos || '',
                'SUBTOTAL': row.subtotal || '',
                'IVA': row.iva || '',  
                'ISR': row.isr || '',
                'TOTAL': row.total || '',
                'PARCIALIDAD': row.parcialidad || '',
                'FECHA PAGO': row.fecha_pago || '',
                'MES PAGO': row.mes_pago || '',
                'FECHA REGISTRO': row.fecha_registro_factura || '',
                'NOMBRE PSC': row.nombre_psc || '',
                'FALTAS PSC': row.faltas_psc || '',
                'INICIA': row.inicia || '',
                'TERMINA': row.termina || '',
                'DURACION HRS': row.duracion_hrs || '',
                'CONTRATO': row.contrato || '',
                'FECHA REPORTE': row.fecha_reporte_horas || '',
                'OBSERVACIONES': row.observaciones || ''
            }));

            let ws = XLSX.utils.json_to_sheet(excelData);
            let wb = XLSX.utils.book_new();

            XLSX.utils.book_append_sheet(wb, ws, "Reporte");

            XLSX.writeFile(wb, "estatus_pagos.xlsx");
        });

        $('#exportExcelBtn22222').on('click', function() {
            const formData = $('#filtroForm').serializeArray();
            let dataParams = {};
            $.each(formData, function(i, field) {
                if (field.name.includes('[]')) {
                    let cleanName = field.name.replace('[]', '');
                    if (!dataParams[cleanName]) dataParams[cleanName] = [];
                    dataParams[cleanName].push(field.value);
                } else {
                    dataParams[field.name] = field.value;
                }
            });
            dataParams._token = $('input[name="_token"]').val();

            $('#progressModal').modal('show');
            $('#progressBar').css('width', '10%').attr('aria-valuenow', 10);
            $('#progressPercent').text('10%');
            $('#progressStatus').text('Solicitando datos...');

            $.ajax({
                url: "{{ route('reportes.estatus.pagos.export2') }}",
                type: "POST",
                data: dataParams,
                success: function(response) {
                    $('#progressBar').css('width', '40%').attr('aria-valuenow', 40);
                    $('#progressPercent').text('40%');
                    $('#progressStatus').text('Procesando datos...');

                    const data = response.data || [];
                    if (data.length === 0) {
                        alert('No hay datos para exportar.');
                        $('#progressModal').modal('hide');
                        return;
                    }

                    const excelData = data.map(row => ({
                        'NUMERO DE AULA': row.clave_aula || '',
                        'TIPO CURSO': row.tipo_curso || '',
                        'F ESTATUS': row.estatus_factura || '',
                        'E PAGO': row.estatus_pago || '',
                        'ESTATUS AULA': row.estatus_aula || '',
                        'UNIDAD': row.unidad || '',
                        'FOLIO FACTURA': row.folio_factura || '',
                        'NOMBRE CURSO': row.nombre_curso || '',
                        'MES': row.mes_corresponde || '',
                        'HRS. FACTURA': row.hrs_factura || '',
                        'CAPACITANDOS': row.capacitandos || '',
                        'HRS. PAGAR': row.hrs_pagar || '',
                        'FUENTE': row.fuente || '',
                        'SUBTOTAL': row.subtotal || '',
                        'IVA': row.iva || '',
                        'ISR': row.isr || '',
                        'TOTAL': row.total || '',
                        'PAGO POR HORA': row.pago_por_hora || '',
                        '# PARCIALIDAD': row.parcialidad || '',
                        'FECHA PAGO': row.fecha_pago || '',
                        'MES PAGO': row.mes_pago || '',
                        'FECH. EMISIÓN FACTURA': row.fecha_emision || '',
                        'FECH. REGISTRO FACTURA': row.fecha_registro_factura || '',
                        'NOMBRE PSC': row.nombre_psc || '',
                        'RFC PSC': row.rfc_psc || '',
                        'FALTAS PSC': row.faltas_psc || '',
                        'INICIA': row.inicia || '',
                        'TERMINA': row.termina || '',
                        'DURACIÓN HRS.': row.duracion_hrs || '',
                        'CONTRATO': row.contrato || '',
                        'FECHA REPORTE HORAS': row.fecha_reporte_horas || '',
                        'OBSERVACIONES FINANCIEROS': row.observaciones || ''
                    }));

                    $('#progressBar').css('width', '70%').attr('aria-valuenow', 70);
                    $('#progressPercent').text('70%');
                    $('#progressStatus').text('Generando archivo...');

                    const worksheet = XLSX.utils.json_to_sheet(excelData);
                    const workbook = XLSX.utils.book_new();
                    XLSX.utils.book_append_sheet(workbook, worksheet, "Reporte_de_Pagos");
                    const fileName =
                        `Reporte_de_Pagos_${new Date().toISOString().slice(0,10)}.xlsx`;
                    XLSX.writeFile(workbook, fileName);

                    $('#progressBar').css('width', '100%').attr('aria-valuenow', 100);
                    $('#progressPercent').text('100%');
                    $('#progressStatus').text('¡Completado!');
                    setTimeout(() => {
                        $('#progressModal').modal('hide');
                        setTimeout(() => {
                            $('#progressBar').css('width', '0%').attr(
                                'aria-valuenow',
                                0);
                            $('#progressPercent').text('0%');
                        }, 500);
                    }, 1000);
                },
                error: function(xhr) {
                    console.error(xhr);
                    alert('Error al exportar datos. Por favor intente de nuevo.');
                    $('#progressModal').modal('hide');
                }
            });
        });
    </script>
@endpush