@extends('layout.template')
@section('title', 'SICCAP ICATEP | Reporte Presupuestos de Aulas')
@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">Asignacion Presupuesto</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="fa fa-building 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->uni_identificador }}"
                                                                data-name="{{ $un->uni_nombre_corto }}">
                                                            <span>{{ $un->uni_nombre_corto }}</span>
                                                        </label>
                                                    </div>
                                                @endforeach
                                            </div>
                                        </div>
                                    </div>
                                    <div id="errorUnidad" class="text-danger filter-error-msg">
                                        <i class="fa fa-exclamation-circle 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="fa fa-list 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->tip_id }}" data-name="{{ $tipo->tip_nombre }}">
                                                            <span>{{ $tipo->tip_nombre }}</span>
                                                        </label>
                                                    </div>
                                                @endforeach
                                            </div>
                                        </div>
                                    </div>
                                    <div id="errorTipo" class="text-danger filter-error-msg">
                                        <i class="fa fa-exclamation-circle 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="fa fa-calendar 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->mes_id }}" data-name="{{ $mes->mes_nombre }}">
                                                            <span>{{ $mes->mes_nombre }}</span>
                                                        </label>
                                                    </div>
                                                @endforeach
                                            </div>
                                        </div>
                                    </div>
                                    <div id="errorMes" class="text-danger filter-error-msg">
                                        <i class="fa fa-exclamation-circle 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="fa fa-calendar-check 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>

                            <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="fa fa-search 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="fa fa-arrow-left"></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;">
                        <!-- Top Loader -->
                        <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;">Resultados Presupuestos</h4>
                                <button type="button" id="exportExcelBtn" class="btn btn-success shadow-sm" disabled
                                    style="border-radius: 8px; font-weight: 600;">
                                    <i class="fa fa-file-excel me-2"></i>Exportar a Excel
                                </button>
                            </div>
                            <div class="w-100">
                                <table id="tablaAulasPresupuestos"
                                    class="table table-striped responsive w-100 display dataTable no-footer">
                                    <thead class="custom-thead">
                                        <tr>
                                            <th>NUMERO DE AULA</th>
                                            <th>UNIDAD</th>
                                            <th>CURSO</th>
                                            <th>TIPO CURSO</th>
                                            <th>NOMBRE CURSO</th>
                                            <th>PAGO ESTATAL</th>
                                            <th>PAGO FEDERAL</th>
                                            <th>PAGO IP</th>
                                            <th>TOTAL</th>
                                            <th>PARCIALIDADES</th>
                                            <th>REQUISICIÓN</th>
                                            <th>ESTATUS AULA</th>
                                            <th>ESPECIALIDAD</th>
                                            <th>INSTRUCTOR</th>
                                            <th>EXPEDIENTE</th>
                                            <th>CONTRATO</th>
                                            <th>HRS. ENE</th>
                                            <th>HRS. FEB</th>
                                            <th>HRS. MAR</th>
                                            <th>HRS. ABR</th>
                                            <th>HRS. MAY</th>
                                            <th>HRS. JUN</th>
                                            <th>HRS. JUL</th>
                                            <th>HRS. AGO</th>
                                            <th>HRS. SEP</th>
                                            <th>HRS. OCT</th>
                                            <th>HRS. NOV</th>
                                            <th>HRS. DIC</th>
                                            <th>CLAVE MDN</th>
                                            <th>CONVENIO</th>
                                            <th>PAGO PSC</th>
                                            <th>PAGO ALUMNO</th>
                                            <th>IMPARTIDO EN</th>
                                            <th>UBICACIÓN</th>
                                            <th>INICIA CURSO</th>
                                            <th>TERMINA CURSO</th>
                                            <th>HORARIO</th>
                                            <th>CAPACITANDOS AULA</th>
                                            <th>HORAS</th>
                                            <th>DURACIÓN HR.</th>
                                            <th>FECHA CREACIÓN AULA</th>
                                            <th>OBSERVACIONES</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Progress Modal for Export -->
    <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;
        }

        /* Empty State Illustration */
        .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;
        }

        .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;
        }

        #tablaAulasPresupuestos 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);
        }

        @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')
    <!-- SheetJS for Excel Export -->
    <script src="https://cdn.sheetjs.com/xlsx-0.20.1/package/dist/xlsx.full.min.js"></script>

    <script>
        // Dropdown Toggle Logic
        $('.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');
            }
        });

        // Update selected text logic
        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`);
            }
        }

        // Form validation error helper
        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');
        });

        // Select All Logic
        $('#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');
        });

        // DataTable Logic
        let isInitialized = false;
        let table = $('#tablaAulasPresupuestos').DataTable({
            responsive: true,
            processing: true,
            serverSide: true,
            ajax: {
                url: "{{ route('reportes.aulas.presupuestos.data') }}",
                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();
                }
            },
            columns: [
                { data: 'au_nva_cve_reg' },
                { data: 'nombre_unidad' },
                { data: 'ti_nombre' },
                { data: 'tipo_curso' },
                { data: 'au_cr_nombre' },
                { data: 'monto_estatal_formateado', className: 'text-center' },
                { data: 'monto_federal_formateado', className: 'text-center' },
                { data: 'monto_ip_formateado', className: 'text-center' },
                { data: 'total_monto', className: 'text-center fw-bold' },
                { data: 'parcialidades', className: 'text-center' },
                { data: 'requisicion' },
                { data: 'au_status', className: 'text-center' },
                { data: 'rg_es_nombre' },
                { data: 'au_in_nombre' },
                { data: 'expediente' },
                { data: 'contrato' },
                { data: 'Ene', className: 'text-center' },
                { data: 'Feb', className: 'text-center' },
                { data: 'Mar', className: 'text-center' },
                { data: 'Abr', className: 'text-center' },
                { data: 'May', className: 'text-center' },
                { data: 'Jun', className: 'text-center' },
                { data: 'Jul', className: 'text-center' },
                { data: 'Ago', className: 'text-center' },
                { data: 'Sep', className: 'text-center' },
                { data: 'Oct', className: 'text-center' },
                { data: 'Nov', className: 'text-center' },
                { data: 'Dic', className: 'text-center' },
                { data: 'modelo' },
                { data: 'au_convenio', className: 'text-center' },
                { data: 'rg_costo_psc', className: 'text-center' },
                { data: 'rg_costo_alumno', className: 'text-center' },
                { data: 'au_modalidad' },
                { data: 'au_ubicacion' },
                { data: 'aul_fecha_inicia' },
                { data: 'aul_fecha_termina' },
                { data: 'au_dias' },
                { data: 'au_cap_regulares', className: 'text-center' },
                { data: 'au_horas', className: 'text-center' },
                { data: 'au_horas', className: 'text-center' },
                { data: 'au_fecha_creacion', className: 'text-center' },
                { data: 'au_observacion' }
            ],
            language: {
                url: "//cdn.datatables.net/plug-ins/1.10.25/i18n/Spanish.json",
                infoFiltered: "",
                emptyTable: `
                        <div class="empty-state-container">
                            <div class="empty-state-icon">
                                <i class="fa fa-folder-open"></i>
                            </div>
                            <h4 class="empty-state-title">Sin resultados</h4>
                            <p class="empty-state-text">No encontramos datos con los filtros seleccionados. Intente ajustar su búsqueda.</p>
                        </div>
                    `
            },
            preDrawCallback: function () {
                $('#top-loader').css('width', '30%');
            },
            drawCallback: function (settings) {
                $('#top-loader').css('width', '100%');
                setTimeout(() => {
                    $('#top-loader').css('width', '0%');
                }, 400);

                if (settings.aoData.length > 0) {
                    $('#exportExcelBtn').prop('disabled', false);
                } else {
                    $('#exportExcelBtn').prop('disabled', true);
                }

                isInitialized = true;
                const searchBtn = $('#filtroForm button[type="submit"]');
                searchBtn.prop('disabled', false).html('<i class="fa fa-search me-2"></i>Buscar');
            }
        });

        $('#filtroForm').on('submit', function (e) {
            e.preventDefault();
            let isValid = true;

            if ($('.unit-check:checked').length === 0) {
                showValidationError('#errorUnidad');
                isValid = false;
            }
            if ($('.month-check:checked').length === 0) {
                showValidationError('#errorMes');
                isValid = false;
            }
            if ($('.type-check:checked').length === 0) {
                showValidationError('#errorTipo');
                isValid = false;
            }

            if (!isValid) return false;

            $(this).find('button[type="submit"]').prop('disabled', true).html('<i class="fa fa-spinner fa-spin me-2"></i>Buscando...');
            isInitialized = true;
            table.ajax.reload();
        });

        // Excel Export Logic
        $('#exportExcelBtn').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.aulas.presupuestos.export') }}",
                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 || data.length === 0) {
                        alert('No hay datos para exportar.');
                        $('#progressModal').modal('hide');
                        return;
                    }

                    // Helper para convertir montos a numéricos
                    const toNumber = (value) => {
                        if (value === null || value === undefined || value === '') return 0;
                        if (typeof value === 'number') return value;
                        const cleaned = String(value).replace(/,/g, '');
                        const num = parseFloat(cleaned);
                        return isNaN(num) ? 0 : num;
                    };

                    // Process into Excel Format
                    const excelData = data.map(row => {
                        return {
                            'NUMERO DE AULA': row.au_nva_cve_reg || '',
                            'UNIDAD': row.nombre_unidad || '',
                            'CURSO': row.ti_nombre || '',
                            'TIPO CURSO': row.tipo_curso || '',
                            'NOMBRE CURSO': row.au_cr_nombre || '',
                            'PAGO ESTATAL': toNumber(row.monto_estatal ?? row.monto_estatal_formateado),
                            'PAGO FEDERAL': toNumber(row.monto_federal ?? row.monto_federal_formateado),
                            'PAGO IP': toNumber(row.monto_ip ?? row.monto_ip_formateado),
                            'TOTAL': toNumber(row.total_monto),
                            'PARCIALIDADES': row.parcialidades || 0,
                            'REQUISICIÓN': row.requisicion || '',
                            'ESTATUS AULA': row.au_status || '',
                            'ESPECIALIDAD': row.rg_es_nombre || '',
                            'INSTRUCTOR': row.au_in_nombre || '',
                            'EXPEDIENTE': row.expediente || '',
                            'CONTRATO': row.contrato || '',
                            'HRS. ENE': row.Ene || 0,
                            'HRS. FEB': row.Feb || 0,
                            'HRS. MAR': row.Mar || 0,
                            'HRS. ABR': row.Abr || 0,
                            'HRS. MAY': row.May || 0,
                            'HRS. JUN': row.Jun || 0,
                            'HRS. JUL': row.Jul || 0,
                            'HRS. AGO': row.Ago || 0,
                            'HRS. SEP': row.Sep || 0,
                            'HRS. OCT': row.Oct || 0,
                            'HRS. NOV': row.Nov || 0,
                            'HRS. DIC': row.Dic || 0,
                            'CLAVE MDN': row.modelo || '',
                            'CONVENIO': row.au_convenio || '',
                            'PAGO PSC': toNumber(row.rg_costo_psc),
                            'PAGO ALUMNO': toNumber(row.rg_costo_alumno),
                            'IMPARTIDO EN': row.au_modalidad || '',
                            'UBICACIÓN': row.au_ubicacion || '',
                            'INICIA CURSO': row.aul_fecha_inicia || '',
                            'TERMINA CURSO': row.aul_fecha_termina || '',
                            'HORARIO': row.au_dias || '',
                            'CAPACITANDOS AULA': row.au_cap_regulares || 0,
                            'HORAS': row.au_horas || 0,
                            'DURACIÓN HR.': row.au_horas || 0,
                            'FECHA CREACIÓN AULA': row.au_fecha_creacion || '',
                            'OBSERVACIONES': row.au_observacion || ''
                        };
                    });

                    $('#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, "Asignacion Presupuesto");

                    const fileName = `Reporte_Asignacion_Presupuesto_${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');
                        // Reset progress bar for next time
                        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