@extends('layout.template')
@section('title', 'SICCAP ICATEP | Reporte Capacitandos')
@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 de Capacitandos</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="unidadcap[]" 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;">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-primary"
                                                    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="mes[]" 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ños:</label>
                                    <button type="button" id="btnSelectedYears"
                                        class="btn btn-dark d-flex align-items-center justify-content-between shadow-sm filter-toggle-btn"
                                        style="min-width: 180px; border-radius: 8px; padding: 0.6rem 1rem; border: 1px solid #dddddd; background: #eeeeee;">
                                        <span id="selectedYearsText" class="text-dark">Años</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: 180px;">
                                        <div class="filter-dropdown-header d-flex flex-wrap">
                                            <h5 class="text-dark">Seleccionar Años</h5>
                                            <button type="button" class="btn btn-xxs btn-primary"
                                                id="btnSelectAllYears" style="font-size: 0.7rem;">Seleccionar
                                                Todos</button>
                                        </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="checkbox" name="anio[]" class="year-check me-2"
                                                                value="{{ $anio }}" data-name="{{ $anio }}">
                                                            <span>{{ $anio }}</span>
                                                        </label>
                                                    </div>
                                                @endforeach
                                            </div>
                                        </div>
                                    </div>

                                    <div id="errorAnio" class="text-danger filter-error-msg">
                                        <i class="fa fa-exclamation-circle me-1"></i>Seleccionar año
                                    </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</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="tablaAulas"
                                    class="table table-striped responsive w-100 display dataTable no-footer">
                                    <thead class="custom-thead">
                                        <tr>
                                            <th>NUM. CONTROL</th>
                                            <th>UNIDAD</th>
                                            <th>APELLIDO PATERNO</th>
                                            <th>APELLIDO MATERNO</th>
                                            <th>NOMBRE(S)</th>
                                            <th>EMAIL</th>
                                            <th>ESTADO CIVIL</th>
                                            <th>POB. VULNERABLE</th>
                                            <th>DISCAPACIDAD</th>
                                            <th>POBLACIÓN INDÍGENA</th>
                                            <th>NIVEL ESTUDIOS</th>
                                            <th>FORMATO F2-2</th>
                                            <th>ESTATUS MIGRATORIO</th>
                                            <th>CURP</th>
                                            <th>RFC</th>
                                            <th>HOMOCLAVE</th>
                                            <th>PERSONAL ICATEP</th>
                                            <th>CELULAR</th>
                                            <th>FECHA INGRESO</th>

                                            <th>FECHA NACIMIENTO</th>
                                            <th>EDAD</th>
                                            <th>SEXO</th>
                                            <th>ENTIDAD FEDERATIVA DE NACIMIENTO</th>

                                            <th>CALLE</th>
                                            <th>NO. EXT.</th>
                                            <th>NO. INT.</th>
                                            <th>COLONIA</th>
                                            <th>C.P.</th>
                                            <th>ESTADO</th>
                                            <th>MUNICIPIO</th>
                                            <th>TELÉFONO</th>

                                            <th>EMPRESA NOMBRE</th>
                                            <th>EMPRESA DIRECCION</th>
                                            <th>EMPRESA PUESTO</th>
                                            <th>EMPRESA TELEFONO</th>

                                            <th>CARTA MENOR DE EDAD</th>
                                            <th>IDENTIFICACIÓN</th>
                                            <th>FOTOGRAFÍAS</th>
                                            <th>ACTA NAC.</th>
                                            <th>COMP. DOMICILIO</th>
                                            <th>COMP. ESTUDIOS</th>

                                            <th>ESTATUS</th>
                                            <th>FECHA ALTA</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;
        }

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

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

        #tablaReferencias tbody td:first-child {
            color: var(--primary) !important;
        }

        .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 Styles */
        .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;
        }


        /* Table Enhancements */
        #tablaReferencias tbody tr {
            transition: background 0.15s ease;
        }

        #tablaReferencias tbody tr:hover {
            background-color: #f8fafc !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;
        }

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

        .filter-section-title {
            font-weight: 700;
            color: #2C3E50;
            border-bottom: 2px solid #2C3E50;
            margin-bottom: 40px;
            padding-bottom: 5px;
            font-size: 0.95rem;
        }

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

        $('.year-check').on('change', function () {
            updateSelectedText('year-check', 'selectedYearsText', 'Años');
            if ($('.year-check:checked').length > 0) $('#errorAnio').fadeOut();
        });

        // 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');
        });

        $('#btnSelectAllYears').on('click', function () {
            let allChecked = $('.year-check:not(:checked)').length === 0;
            $('.year-check').prop('checked', !allChecked).trigger('change');
        });

        // DataTable Logic
        let isInitialized = false;
        let table = $('#tablaAulas').DataTable({
            responsive: true,
            processing: true,
            serverSide: true,
            ajax: {
                url: "{{ route('reportes.capacitandos.general.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: 'alu_num_control' },
                { data: 'uni_nombre' },
                { data: 'alu_ape_pat' },
                { data: 'alu_ape_mat' },
                { data: 'alu_nombre' },
                { data: 'alu_email' },
                { data: 'alu_edo_civ' },
                { data: 'alu_pob_vul' },
                { data: 'alu_discapacidad' },
                { data: 'alu_indigena' },
                { data: 'alu_grado_estudios' },
                { data: 'alu_f22' },
                { data: 'alu_extranjero' },
                { data: 'alu_curp' },
                { data: 'alu_rfc_base' },
                { data: 'alu_homoclave' },
                { data: 'alu_personal_icatep' },
                { data: 'alu_celular' },
                { data: 'alu_fecha_ingreso' },
                { data: 'alu_fechnac' },
                { data: 'alu_edad' },
                { data: 'alu_sexo' },
                { data: 'entidad_nac_nombre' },
                { data: 'alu_calle' },
                { data: 'alu_num_ext' },
                { data: 'alu_num_int' },
                { data: 'alu_colonia' },
                { data: 'alu_cp' },
                { data: 'estado_nombre' },
                { data: 'alu_municipio' },
                { data: 'alu_telefono' },
                { data: 'alu_empresa' },
                { data: 'alu_dir_emp' },
                { data: 'alu_puesto' },
                { data: 'alu_tel_emp' },
                { data: 'alu_menor' },
                { data: 'alu_identificacion' },
                { data: 'alu_foto' },
                { data: 'alu_acta_nac' },
                { data: 'alu_com_dom' },
                { data: 'alu_comp_est' },
                { data: 'alu_status' },
                { data: 'created_at' }
            ],
            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 () {
                // Start Top Loader
                $('#top-loader').css('width', '30%');
            },
            drawCallback: function (settings) {
                // Finish Top Loader
                $('#top-loader').css('width', '100%');
                setTimeout(() => {
                    $('#top-loader').css('width', '0%');
                }, 400);

                // Enable/Disable Excel button based on data
                if (settings.aoData.length > 0) {
                    $('#exportExcelBtn').prop('disabled', false);

                    // Update KPI Cards
                    const totalRecords = settings.json ? settings.json.recordsTotal : 0;
                    $('#stat-total-aulas').text(totalRecords);

                    // Use uniqueUnitsCount from backend
                    const uniqueUnits = settings.json ? settings.json.uniqueUnitsCount : 0;
                    $('#stat-total-unidades').text(uniqueUnits);

                    $('#kpi-row').fadeIn();
                    $('.kpi-card').addClass('kpi-pulse');
                    setTimeout(() => $('.kpi-card').removeClass('kpi-pulse'), 1500);
                } else {
                    $('#exportExcelBtn').prop('disabled', true);
                    if (isInitialized) $('#kpi-row').fadeOut();
                }

                isInitialized = true;

                // Reset search button state
                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 (!isValid) return false;

            // Loading state
            $(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.capacitandos.general.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;
                    }

                    const isJefe = {{ Auth::check() && Auth::user()->usu_nombre === 'admin' ? 'true' : 'false' }};
                    // Process into Excel Format
                    const excelData = data.map(row => {
                        let excelRow = {};
                        excelRow['NUM. CONTROL'] = row.alu_num_control || '';
                        excelRow['UNIDAD'] = row.uni_nombre || '';
                        excelRow['APELLIDO PATERNO'] = row.alu_ape_pat || '';
                        excelRow['APELLIDO MATERNO'] = row.alu_ape_mat || '';
                        excelRow['NOMBRE(S)'] = row.alu_nombre || '';
                        excelRow['EMAIL'] = row.alu_email || '';
                        excelRow['ESTADO CIVIL'] = row.alu_edo_civ || '';
                        excelRow['POB. VULNERABLE'] = row.alu_pob_vul || '';
                        excelRow['DISCAPACIDAD'] = row.alu_discapacidad || '';
                        excelRow['NIVEL ESTUDIOS'] = row.alu_grado_estudios || '';
                        excelRow['POBLACIÓN INDÍGENA'] = row.alu_indigena || '';
                        excelRow['FORMATO F2-2'] = row.alu_f22 || '';
                        excelRow['ESTATUS MIGRATORIO'] = row.alu_extranjero || '';
                        excelRow['CURP'] = row.alu_curp || '';
                        excelRow['RFC'] = row.alu_rfc_base || '';
                        excelRow['HOMOCLAVE'] = row.alu_homoclave || '';
                        excelRow['PERSONAL ICATEP'] = row.alu_personal_icatep || '';
                        excelRow['CELULAR'] = row.alu_celular || '';
                        excelRow['FECHA INGRESO'] = row.alu_fecha_ingreso || '';
                        excelRow['FECHA NACIMIENTO'] = row.alu_fechnac || '';
                        excelRow['EDAD'] = row.alu_edad || '';
                        excelRow['SEXO'] = row.alu_sexo || '';
                        excelRow['ENTIDAD FEDERATIVA DE NACIMIENTO'] = row.entidad_nac_nombre || '';
                        excelRow['CALLE'] = row.alu_calle || '';
                        excelRow['NO. EXT.'] = row.alu_num_ext || '';
                        excelRow['NO. INT.'] = row.alu_num_int || '';
                        excelRow['COLONIA'] = row.alu_colonia || '';
                        excelRow['C.P.'] = row.alu_cp || '';
                        excelRow['ESTADO'] = row.estado_nombre || '';
                        excelRow['MUNICIPIO'] = row.alu_municipio || '';
                        excelRow['TELÉFONO'] = row.alu_telefono || '';
                        excelRow['EMPRESA NOMBRE'] = row.alu_empresa || '';
                        excelRow['EMPRESA DIRECCION'] = row.alu_dir_emp || '';
                        excelRow['EMPRESA PUESTO'] = row.alu_puesto || '';
                        excelRow['EMPRESA TELEFONO'] = row.alu_tel_emp || '';
                        excelRow['CARTA MENOR DE EDAD'] = row.alu_menor || '';
                        excelRow['IDENTIFICACIÓN'] = row.alu_identificacion || '';
                        excelRow['FOTOGRAFÍAS'] = row.alu_foto || '';
                        excelRow['ACTA NAC.'] = row.alu_acta_nac || '';
                        excelRow['COMP. DOMICILIO'] = row.alu_com_dom || '';
                        excelRow['COMP. ESTUDIOS'] = row.alu_comp_est || '';
                        excelRow['ESTATUS'] = row.alu_status || '';
                        excelRow['FECHA ALTA'] = row.created_at || '';
                        return excelRow;
                    });

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

                    setTimeout(() => {
                        const ws = XLSX.utils.json_to_sheet(excelData);
                        const wb = XLSX.utils.book_new();
                        XLSX.utils.book_append_sheet(wb, ws, "Aulas");

                        const today = new Date();
                        const filename = 'Reporte_General_Capacitandos_' +
                            today.getFullYear() +
                            ('0' + (today.getMonth() + 1)).slice(-2) +
                            ('0' + today.getDate()).slice(-2) + '.xlsx';

                        XLSX.writeFile(wb, filename);

                        $('#progressBar').css('width', '100%').attr('aria-valuenow', 100);
                        $('#progressPercent').text('100%');
                        $('#progressStatus').text('¡Descarga completa!');

                        setTimeout(() => {
                            $('#progressModal').modal('hide');
                        }, 800);
                    }, 500);
                },
                error: function () {
                    alert('Error al exportar los datos.');
                    $('#progressModal').modal('hide');
                }
            });
        });
    </script>
@endpush