Files

1338 lines
73 KiB
HTML

{% extends "base.html" %}
{% block title %}Sincronización Google Sheets y Purga Académica - Edu-Space Admin{% endblock %}
{% block content %}
<div class="container-fluid pt-5 mt-4">
<!-- Header -->
<div class="d-flex flex-wrap justify-content-between align-items-center mb-4 gap-2">
<div>
<h1 class="h3 mb-1">
<i class="bi bi-file-earmark-spreadsheet text-success me-2"></i>Google Sheets Academic Sync & Gestión de
Datos
</h1>
<p class="text-muted small mb-0">Extrae, normaliza y sincroniza carreras, aulas, comisiones y cronogramas de
cursada desde Google Sheets con soporte de configuración dinámica y reinicio de entorno.</p>
</div>
<div class="d-flex gap-2">
<a href="/schedule/calendar_view" class="btn btn-outline-primary btn-sm">
<i class="bi bi-calendar3 me-1"></i>Ver Calendario
</a>
<a href="/main/dashboard" class="btn btn-outline-secondary btn-sm">
<i class="bi bi-arrow-left me-1"></i>Dashboard
</a>
</div>
</div>
<!-- Feedback Alerts -->
{% if flash_msg %}
<div class="alert alert-{{ flash_type }} alert-dismissible fade show border-0 shadow-sm mb-4" role="alert">
<div class="d-flex align-items-center">
{% if flash_type == 'success' %}
<i class="bi bi-check-circle-fill fs-5 me-2 text-success"></i>
{% elif flash_type == 'danger' %}
<i class="bi bi-exclamation-triangle-fill fs-5 me-2 text-danger"></i>
{% elif flash_type == 'warning' %}
<i class="bi bi-exclamation-circle-fill fs-5 me-2 text-warning"></i>
{% else %}
<i class="bi bi-info-circle-fill fs-5 me-2 text-info"></i>
{% endif %}
<div>{{ flash_msg }}</div>
</div>
<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
</div>
{% endif %}
{% if sync_error %}
<div class="alert alert-danger border-0 shadow-sm mb-4" role="alert">
<div class="d-flex align-items-start">
<i class="bi bi-x-octagon-fill fs-4 me-3 text-danger flex-shrink-0"></i>
<div>
<h6 class="alert-heading fw-bold mb-1">Error durante la sincronización:</h6>
<p class="small mb-0">{{ sync_error }}</p>
</div>
</div>
</div>
{% endif %}
<!-- Metrics Cards -->
<div class="row g-3 mb-4">
<div class="col-sm-6 col-xl-2">
<div class="card border-0 shadow-sm text-center p-3 h-100 bg-body">
<div class="text-primary mb-1"><i class="bi bi-mortarboard fs-3"></i></div>
<div class="h4 mb-0 fw-bold" id="metric-careers">{{ metrics.total_careers }}</div>
<small class="text-muted">Carreras</small>
</div>
</div>
<div class="col-sm-6 col-xl-2">
<div class="card border-0 shadow-sm text-center p-3 h-100 bg-body">
<div class="text-info mb-1"><i class="bi bi-book fs-3"></i></div>
<div class="h4 mb-0 fw-bold" id="metric-subjects">{{ metrics.total_subjects }}</div>
<small class="text-muted">Asignaturas</small>
</div>
</div>
<div class="col-sm-6 col-xl-2">
<div class="card border-0 shadow-sm text-center p-3 h-100 bg-body">
<div class="text-success mb-1"><i class="bi bi-door-open fs-3"></i></div>
<div class="h4 mb-0 fw-bold" id="metric-classrooms">{{ metrics.total_classrooms }}</div>
<small class="text-muted">Aulas (Físicas/Virt.)</small>
</div>
</div>
<div class="col-sm-6 col-xl-3">
<div class="card border-0 shadow-sm text-center p-3 h-100 bg-body">
<div class="text-warning mb-1"><i class="bi bi-diagram-3 fs-3"></i></div>
<div class="h4 mb-0 fw-bold" id="metric-commissions">{{ metrics.total_commissions }}</div>
<small class="text-muted">Comisiones</small>
</div>
</div>
<div class="col-sm-6 col-xl-3">
<div class="card border-0 shadow-sm text-center p-3 h-100 bg-body">
<div class="text-danger mb-1"><i class="bi bi-calendar-check fs-3"></i></div>
<div class="h4 mb-0 fw-bold" id="metric-reservations">{{ metrics.total_reservations }}</div>
<small class="text-muted">Asignaciones en Calendario</small>
</div>
</div>
</div>
<!-- Google Sheets URL Configuration Card -->
<div class="card border-0 shadow-sm mb-4">
<div class="card-header bg-body-tertiary d-flex justify-content-between align-items-center py-3">
<h5 class="card-title h6 mb-0 fw-bold">
<i class="bi bi-gear-wide-connected text-primary me-2"></i>Configuración Global del Google Sheet
</h5>
<span
class="badge {% if sheets_config.source == 'database' %}bg-success-subtle text-success border border-success-subtle{% else %}bg-secondary-subtle text-secondary border{% endif %}">
Origen: {{ 'Base de Datos (Personalizado)' if sheets_config.source == 'database' else ('Variables de
Entorno' if sheets_config.source == 'environment' else 'Predeterminado') }}
</span>
</div>
<div class="card-body p-4">
<form method="POST" action="/admin/google_sheets_config" id="configForm">
<div class="mb-3">
<label for="google_sheets_url" class="form-label fw-semibold">
URL o Enlace Público de la Hoja de Cálculo (Google Sheets):
</label>
<div class="input-group">
<span class="input-group-text bg-body-secondary"><i class="bi bi-link-45deg"></i></span>
<input type="text" class="form-control font-monospace small" id="google_sheets_url"
name="google_sheets_url" value="{{ sheets_config.active_url }}" required
placeholder="https://docs.google.com/spreadsheets/d/.../pub?output=csv o enlace compartido">
<button type="submit" class="btn btn-primary px-3">
<i class="bi bi-floppy me-1"></i>Guardar Enlace
</button>
</div>
<div class="form-text mt-2">
<i class="bi bi-info-circle me-1"></i>
Acepta enlaces web publicados (<code>/pub?output=csv</code>) o enlaces estándar de Google Sheets
(<code>/spreadsheets/d/ID/edit</code>). El sistema los normaliza automáticamente para consultar
cada pestaña de día (Lunes a Sábado).
</div>
</div>
<div class="d-flex justify-content-between align-items-center">
<button type="button" class="btn btn-sm btn-outline-secondary" onclick="restoreDefaultUrl()">
<i class="bi bi-arrow-counterclockwise me-1"></i>Restaurar URL Oficial UniCABA
</button>
<a href="{{ sheets_config.active_url }}" target="_blank" rel="noopener noreferrer"
class="small text-decoration-none">
<i class="bi bi-box-arrow-up-right me-1"></i>Abrir Enlace Actual en Google Docs
</a>
</div>
</form>
</div>
</div>
<!-- Sync Action Banner & Advanced Filters -->
<div class="card border-0 shadow-sm mb-4">
<div class="card-header bg-body-tertiary d-flex flex-wrap justify-content-between align-items-center py-3">
<div>
<h5 class="card-title h6 mb-0 fw-bold">
<i class="bi bi-sliders text-success me-2"></i>Sincronización Académica con Filtros Avanzados y Control de Fecha
</h5>
<small class="text-muted">Importe el cronograma completo o filtre por Carrera, Materia, Día de cursada y fecha puntual manual.</small>
</div>
<div class="d-flex gap-2 mt-2 mt-sm-0">
<button type="button" class="btn btn-sm btn-outline-primary" id="btnInspectSheet" onclick="inspectOnlineSheets()">
<i class="bi bi-search me-1"></i><span id="inspectBtnText">Inspeccionar Sheet Online</span>
</button>
<button type="button" class="btn btn-sm btn-outline-secondary" onclick="clearFilters()">
<i class="bi bi-x-circle me-1"></i>Limpiar Filtros
</button>
</div>
</div>
<div class="card-body p-4">
<!-- Alert de inspección online (se muestra vía JS) -->
<div id="inspectAlert" class="alert alert-info border-0 shadow-sm mb-4 d-none">
<div class="d-flex align-items-center">
<i class="bi bi-info-circle-fill fs-5 me-2 text-info"></i>
<div id="inspectAlertMsg"></div>
</div>
</div>
<form method="POST" id="syncForm" action="/admin/google_sheets_import">
<input type="hidden" name="sheets_url" id="syncSheetsUrl" value="{{ sheets_config.active_url }}">
<input type="hidden" name="selected_rows_json" id="selected_rows_json" value="">
<!-- 1. Selección Granular de Entidades a Sincronizar (Estilo Tarjetas Checkbox) -->
<div class="mb-4">
<div class="d-flex flex-wrap justify-content-between align-items-center mb-2 gap-2">
<label class="form-label fw-bold small text-uppercase text-secondary mb-0">
<i class="bi bi-check2-square text-success me-1"></i>1. Entidades a Importar / Sincronizar:
</label>
<div class="btn-group btn-group-sm" role="group">
<button type="button" class="btn btn-outline-secondary py-0 px-2" onclick="toggleImportEntities(true)">
<i class="bi bi-check-all me-1"></i>Marcar Todo
</button>
<button type="button" class="btn btn-outline-secondary py-0 px-2" onclick="toggleImportEntities(false)">
<i class="bi bi-dash-square me-1"></i>Desmarcar Todo
</button>
</div>
</div>
<div class="row g-2">
<div class="col-sm-6 col-lg">
<div class="form-check p-2 border rounded bg-body-tertiary h-100 shadow-sm-sm">
<input class="form-check-input ms-1 me-2 import-entity-chk" type="checkbox" name="import_reservations" id="chk_import_reservations" value="true" checked>
<label class="form-check-label fw-semibold small" for="chk_import_reservations">
<i class="bi bi-calendar-check text-danger me-1"></i>Asignaciones (Reservas)
<small class="d-block text-muted fw-normal">Clases y horarios en calendario.</small>
</label>
</div>
</div>
<div class="col-sm-6 col-lg">
<div class="form-check p-2 border rounded bg-body-tertiary h-100 shadow-sm-sm">
<input class="form-check-input ms-1 me-2 import-entity-chk" type="checkbox" name="import_classrooms" id="chk_import_classrooms" value="true" checked>
<label class="form-check-label fw-semibold small" for="chk_import_classrooms">
<i class="bi bi-door-open text-success me-1"></i>Aulas Físicas y Virtuales
<small class="d-block text-muted fw-normal">Aulas presenciales y Zoom/PB.</small>
</label>
</div>
</div>
<div class="col-sm-6 col-lg">
<div class="form-check p-2 border rounded bg-body-tertiary h-100 shadow-sm-sm">
<input class="form-check-input ms-1 me-2 import-entity-chk" type="checkbox" name="import_commissions" id="chk_import_commissions" value="true" checked>
<label class="form-check-label fw-semibold small" for="chk_import_commissions">
<i class="bi bi-diagram-3 text-warning me-1"></i>Comisiones de Cursada
<small class="d-block text-muted fw-normal">Turnos y comisiones académicas.</small>
</label>
</div>
</div>
<div class="col-sm-6 col-lg">
<div class="form-check p-2 border rounded bg-body-tertiary h-100 shadow-sm-sm">
<input class="form-check-input ms-1 me-2 import-entity-chk" type="checkbox" name="import_subjects" id="chk_import_subjects" value="true" checked>
<label class="form-check-label fw-semibold small" for="chk_import_subjects">
<i class="bi bi-book text-info me-1"></i>Asignaturas / Materias
<small class="d-block text-muted fw-normal">Catálogo de materias curriculares.</small>
</label>
</div>
</div>
<div class="col-sm-6 col-lg">
<div class="form-check p-2 border rounded bg-body-tertiary h-100 shadow-sm-sm">
<input class="form-check-input ms-1 me-2 import-entity-chk" type="checkbox" name="import_careers" id="chk_import_careers" value="true" checked>
<label class="form-check-label fw-semibold small" for="chk_import_careers">
<i class="bi bi-mortarboard text-primary me-1"></i>Carreras Académicas
<small class="d-block text-muted fw-normal">Planes de estudio y carreras.</small>
</label>
</div>
</div>
</div>
</div>
<!-- 2. Selección de Días de la Semana (Checkboxes Múltiples) -->
<div class="mb-4">
<div class="p-3 border rounded bg-body-tertiary">
<div class="d-flex flex-wrap justify-content-between align-items-center mb-2 gap-2">
<label class="form-label fw-bold small text-uppercase text-secondary mb-0">
<i class="bi bi-calendar3 text-primary me-1"></i>2. Días de la Semana a Procesar:
</label>
<div class="btn-group btn-group-sm" role="group">
<button type="button" class="btn btn-outline-primary py-0 px-2" onclick="setDaysSelection('all')">Todos</button>
<button type="button" class="btn btn-outline-secondary py-0 px-2" onclick="setDaysSelection('workdays')">Lun a Vie</button>
<button type="button" class="btn btn-outline-secondary py-0 px-2" onclick="setDaysSelection('none')">Limpiar</button>
</div>
</div>
<div class="d-flex flex-wrap gap-2" id="daysCheckboxesContainer">
{% set all_days = ['Lunes', 'Martes', 'Miércoles', 'Jueves', 'Viernes', 'Sábado'] %}
{% for d in all_days %}
<div class="form-check form-check-inline border rounded px-3 py-1 bg-white shadow-sm mb-0">
<input class="form-check-input filter-day-chk" type="checkbox" name="filter_days" id="day_chk_{{ loop.index }}" value="{{ d }}"
{% if not filter_days or (d in filter_days) or (filter_day and (filter_day == d or filter_day == 'ALL')) %}checked{% endif %}>
<label class="form-check-label small fw-semibold cursor-pointer" for="day_chk_{{ loop.index }}">{{ d }}</label>
</div>
{% endfor %}
</div>
<div class="form-text small mt-1">
<i class="bi bi-info-circle me-1"></i>Tilde uno o varios días específicos. Al inspeccionar o sincronizar se consultarán exclusivamente las pestañas seleccionadas.
</div>
</div>
</div>
<!-- 3. Filtros Específicos y Control de Fecha -->
<div class="row g-3 mb-4">
<!-- Filtro por Carrera -->
<div class="col-md-4">
<label for="filter_career" class="form-label fw-semibold small">
<i class="bi bi-mortarboard me-1 text-primary"></i>Carrera Académica:
</label>
<input type="text" name="filter_career" id="filter_career" class="form-control form-control-sm"
list="careersDataList" value="{{ filter_career }}"
placeholder="Ej: DATOS (CCC) o todas...">
<datalist id="careersDataList">
{% for c in available_careers %}
<option value="{{ c.name if c.name else c }}"></option>
{% endfor %}
</datalist>
<div class="form-text small">Coincidencia en materia principal o compartida.</div>
</div>
<!-- Filtro por Materia -->
<div class="col-md-4">
<label for="filter_subject" class="form-label fw-semibold small">
<i class="bi bi-book me-1 text-primary"></i>Materia / Asignatura:
</label>
<input type="text" name="filter_subject" id="filter_subject" class="form-control form-control-sm"
list="subjectsDataList" value="{{ filter_subject }}"
placeholder="Ej: ASIG00113 o por nombre...">
<datalist id="subjectsDataList">
{% for s in available_subjects %}
<option value="{{ s.code }} - {{ s.name }}"></option>
{% endfor %}
</datalist>
<div class="form-text small">Busca por código o nombre curricular.</div>
</div>
<!-- Fecha Manual y Control Puntual -->
<div class="col-md-4">
<label for="manual_date" class="form-label fw-semibold small">
<i class="bi bi-calendar-event me-1 text-danger"></i>Fecha Manual Sugerida:
</label>
<input type="date" name="manual_date" id="manual_date" class="form-control form-control-sm"
value="{{ manual_date }}">
<div class="form-text small">Fecha por defecto para registros sin fecha inferida.</div>
</div>
</div>
<!-- Opciones de Cursada y Acciones Principales -->
<div class="p-3 bg-body-tertiary rounded border mb-4">
<div class="d-flex flex-wrap justify-content-between align-items-center gap-3">
<div class="form-check form-switch mb-0">
<input class="form-check-input" type="checkbox" role="switch" id="single_date_only" name="single_date_only" value="true" {% if single_date_only %}checked{% endif %}>
<label class="form-check-label fw-semibold small" for="single_date_only">
<i class="bi bi-pin-angle-fill text-warning me-1"></i>Importar ÚNICAMENTE para fecha puntual
</label>
<span class="d-block text-muted small">Crea 1 sola asignación por fila en lugar del cuatrimestre regular (16 semanas).</span>
</div>
<div class="d-flex gap-2">
<button type="button" class="btn btn-outline-primary px-3 shadow-sm fw-semibold" id="btnInspectSheet" onclick="inspectOnlineSheets()">
<i class="bi bi-search me-1"></i><span id="inspectBtnText">Inspeccionar Sheet Online</span>
</button>
<button type="button" id="syncBtn" class="btn btn-success px-4 shadow-sm fw-semibold" onclick="openSyncConfirmModal()">
<i class="bi bi-arrow-repeat me-1"></i>Iniciar Sincronización
</button>
</div>
</div>
</div>
</form>
<div id="syncSpinner" class="d-none text-center py-3 text-muted">
<div class="spinner-border spinner-border-sm text-success me-2" role="status"></div>
<strong>Conectando a Google Sheets y sincronizando registros según filtros seleccionados...</strong>
</div>
<!-- 4. Grilla de Inspección Previa (Pre-visualización Interactiva) -->
<div id="previewSection" class="card border border-primary border-opacity-25 shadow-sm mb-4 d-none">
<div class="card-header bg-primary bg-opacity-10 py-3 d-flex flex-wrap justify-content-between align-items-center gap-2">
<div>
<h6 class="mb-0 fw-bold text-primary">
<i class="bi bi-table me-2"></i>Grilla de Inspección Previa (Previsualización Interactiva)
</h6>
<small class="text-muted">Revise, deseleccione filas individuales y ajuste las fechas de cursada antes de confirmar la subida.</small>
</div>
<div class="d-flex align-items-center gap-2">
<span class="badge bg-white text-dark border">
Total detectado: <strong id="previewTotalCount">0</strong>
</span>
<span class="badge bg-success text-white">
Seleccionados: <strong id="previewSelectedCount">0</strong>
</span>
</div>
</div>
<div class="card-body p-3">
<!-- Barra de Controles de la Grilla -->
<div class="row g-2 align-items-center mb-3">
<div class="col-md-5">
<div class="input-group input-group-sm">
<span class="input-group-text bg-white"><i class="bi bi-search"></i></span>
<input type="text" id="previewSearchInput" class="form-control" placeholder="Buscar por código, materia, carrera o aula..." oninput="onPreviewSearch()">
</div>
</div>
<div class="col-md-4">
<div class="input-group input-group-sm">
<span class="input-group-text bg-white small"><i class="bi bi-calendar-event me-1"></i>Fecha masiva:</span>
<input type="date" id="bulkDateInput" class="form-control">
<button type="button" class="btn btn-outline-secondary" onclick="applyBulkDate()" title="Aplica esta fecha a todos los registros seleccionados">
Aplicar
</button>
</div>
</div>
<div class="col-md-3 text-end">
<div class="btn-group btn-group-sm" role="group">
<button type="button" class="btn btn-outline-secondary" onclick="toggleSelectAllFiltered(true)">Marcar Todos</button>
<button type="button" class="btn btn-outline-secondary" onclick="toggleSelectAllFiltered(false)">Desmarcar</button>
</div>
</div>
</div>
<!-- Tabla de Previsualización -->
<div class="table-responsive border rounded mb-3" style="max-height: 520px; overflow-y: auto;">
<table class="table table-hover table-striped align-middle mb-0 small" id="previewTable">
<thead class="table-light sticky-top shadow-sm">
<tr>
<th class="text-center" style="width: 40px;">
<input class="form-check-input" type="checkbox" id="chkSelectAllPreview" onchange="toggleMasterPreviewCheckbox(this.checked)" checked title="Seleccionar/Deseleccionar todos">
</th>
<th style="width: 50px;">#</th>
<th style="width: 100px;">Día</th>
<th style="width: 110px;">Turno / Horario</th>
<th>Código & Asignatura</th>
<th>Carrera(s)</th>
<th style="width: 150px;">Aula Detectada</th>
<th style="width: 175px;">Fecha Cursada (Editable)</th>
<th style="width: 130px;">Estado</th>
</tr>
</thead>
<tbody id="previewTableBody">
<!-- Poblado dinámicamente con JavaScript -->
</tbody>
</table>
</div>
<!-- Paginación y Resumen -->
<div class="d-flex flex-wrap justify-content-between align-items-center gap-2">
<div class="small text-muted" id="previewPaginationInfo">
Mostrando registros 1-25
</div>
<nav aria-label="Navegación de previsualización">
<ul class="pagination pagination-sm mb-0" id="previewPaginationNav">
<!-- Botones de paginación generados por JS -->
</ul>
</nav>
<div>
<button type="button" class="btn btn-sm btn-success px-3 shadow-sm fw-semibold" onclick="openSyncConfirmModal()">
<i class="bi bi-arrow-repeat me-1"></i>Confirmar Sincronización (<span id="previewSelectedCountBtn">0</span>)
</button>
</div>
</div>
</div>
</div>
<!-- Etiquetas de Días cubiertos en cartelera -->
<div class="d-flex flex-wrap align-items-center gap-1 pt-2 border-top">
<span class="small text-muted me-2">Hojas de cursada configuradas:</span>
{% for s in metrics.sheets %}
<span class="badge bg-body-tertiary text-secondary border small">
<i class="bi bi-calendar-check me-1 text-primary"></i>{{ s.name }}
</span>
{% endfor %}
</div>
</div>
</div>
<!-- Sync Results (if just completed) -->
{% if stats %}
<div class="card border-0 shadow-sm mb-4 border-start border-success border-4">
<div class="card-header bg-success bg-opacity-10 text-success py-3 d-flex flex-wrap justify-content-between align-items-center gap-2">
<h5 class="card-title h6 mb-0 fw-bold">
<i class="bi bi-check-circle-fill me-2"></i>Informe Detallado de Sincronización
</h5>
<div class="d-flex gap-2 align-items-center">
{% if stats.filters_applied %}
<span class="badge bg-light text-dark border">
<i class="bi bi-funnel-fill text-primary me-1"></i>Filtros Activos
</span>
{% endif %}
<span class="badge bg-success text-white">Completado</span>
</div>
</div>
<div class="card-body">
<!-- Resumen de Filtros Aplicados si hubo alguno -->
{% if stats.filters_applied %}
<div class="p-3 mb-3 rounded bg-light border">
<div class="d-flex flex-wrap gap-3 align-items-center small">
<div>
<strong class="text-secondary"><i class="bi bi-calendar3 me-1"></i>Día:</strong>
<span class="badge bg-primary-subtle text-primary border border-primary-subtle">{{ stats.filters_applied.day or 'Todos los Días' }}</span>
</div>
<div>
<strong class="text-secondary"><i class="bi bi-mortarboard me-1"></i>Carrera:</strong>
<span class="badge bg-info-subtle text-info border border-info-subtle">{{ stats.filters_applied.career or 'Todas las Carreras' }}</span>
</div>
<div>
<strong class="text-secondary"><i class="bi bi-book me-1"></i>Materia:</strong>
<span class="badge bg-secondary-subtle text-secondary border">{{ stats.filters_applied.subject or 'Todas las Materias' }}</span>
</div>
<div>
<strong class="text-secondary"><i class="bi bi-calendar-event me-1"></i>Fecha Manual:</strong>
<span class="badge {% if stats.filters_applied.manual_date %}bg-warning-subtle text-dark border border-warning-subtle{% else %}bg-light text-muted border{% endif %}">
{{ stats.filters_applied.manual_date or 'No requerida' }}
</span>
</div>
<div>
<strong class="text-secondary"><i class="bi bi-clock-history me-1"></i>Generación:</strong>
<span class="badge {% if stats.filters_applied.single_date_only %}bg-warning-subtle text-warning border border-warning-subtle{% else %}bg-success-subtle text-success border border-success-subtle{% endif %}">
{{ 'Fecha puntual única (1 asignación)' if stats.filters_applied.single_date_only else 'Cuatrimestre regular (16 semanas)' }}
</span>
</div>
<div>
<strong class="text-secondary"><i class="bi bi-check-all me-1"></i>Filas Coincidentes:</strong>
<span class="fw-bold text-success">{{ stats.matching_rows if stats.matching_rows is defined else stats.total_rows_processed }}</span>
<span class="text-muted">/ {{ stats.total_rows_processed }} totales</span>
</div>
</div>
</div>
{% endif %}
<div class="row g-3 text-center mb-3">
<div class="col-md-2">
<div class="p-3 border rounded bg-body-tertiary">
<div class="fw-bold fs-4 text-secondary">{{ stats.matching_rows if stats.matching_rows is defined else stats.total_rows_processed }}</div>
<small class="text-muted fw-semibold">Filas Coincidentes</small>
</div>
</div>
<div class="col-md-2">
<div class="p-3 border rounded bg-body-tertiary">
<div class="fw-bold fs-4 text-primary">+{{ stats.careers_created }}</div>
<small class="text-muted fw-semibold">Carreras Creadas</small>
</div>
</div>
<div class="col-md-2">
<div class="p-3 border rounded bg-body-tertiary">
<div class="fw-bold fs-4 text-success">+{{ stats.classrooms_created }}</div>
<small class="text-muted fw-semibold">Aulas Creadas</small>
</div>
</div>
<div class="col-md-2">
<div class="p-3 border rounded bg-body-tertiary">
<div class="fw-bold fs-4 text-info">+{{ stats.subjects_created }}</div>
<small class="text-muted fw-semibold">Materias Creadas</small>
</div>
</div>
<div class="col-md-2">
<div class="p-3 border rounded bg-body-tertiary">
<div class="fw-bold fs-4 text-warning">+{{ stats.commissions_created }}</div>
<small class="text-muted fw-semibold">Comisiones Creadas</small>
</div>
</div>
<div class="col-md-2">
<div class="p-3 border rounded bg-body-tertiary">
<div class="fw-bold fs-4 text-danger">+{{ stats.reservations_created }}</div>
<small class="text-muted fw-semibold">Clases / Reservas</small>
</div>
</div>
</div>
{% if stats.by_day %}
<div class="card bg-body-tertiary border mb-3">
<div class="card-header bg-transparent py-2 border-bottom">
<h6 class="mb-0 small fw-bold text-dark"><i class="bi bi-calendar3 me-2 text-primary"></i>Desglose Semanal por Día de Cursada:</h6>
</div>
<div class="card-body p-2">
<div class="row g-2 text-center">
{% for day_name, d_info in stats.by_day %}
<div class="col-md-2 col-4">
<div class="p-2 border rounded bg-white shadow-sm">
<span class="fw-bold d-block text-secondary small">{{ day_name }}</span>
<span class="badge {% if d_info.status == 'OK' %}bg-success-subtle text-success border border-success-subtle{% else %}bg-danger-subtle text-danger border border-danger-subtle{% endif %}">
{{ d_info.rows_count }} filas
</span>
</div>
</div>
{% endfor %}
</div>
</div>
</div>
{% endif %}
{% if stats.errors and (stats.errors|length > 0) %}
<div class="alert alert-warning mb-0 small">
<h6 class="alert-heading fw-bold mb-1"><i class="bi bi-exclamation-triangle me-1"></i>Advertencias o incidencias detectadas:</h6>
<ul class="mb-0 ps-3">
{% for err in stats.errors %}
<li>{{ err }}</li>
{% endfor %}
</ul>
</div>
{% endif %}
</div>
</div>
{% endif %}
<!-- Academic Data Purge / Reset Tool (Zona de Mantenimiento) -->
<div class="card border-0 shadow-sm mb-4 border-start border-danger border-4">
<div
class="card-header bg-danger bg-opacity-10 text-danger py-3 d-flex justify-content-between align-items-center">
<div>
<h5 class="card-title h6 mb-0 fw-bold">
<i class="bi bi-trash3 text-danger me-2"></i>Herramienta de Reinicio y Purga Académica (Testing &
Reset)
</h5>
<small class="text-muted">Permite eliminar de forma limpia carreras, aulas y asignaciones para realizar
pruebas completas del importador desde cero.</small>
</div>
<span class="badge bg-danger text-white">Zona de Peligro</span>
</div>
<div class="card-body p-4">
<p class="small text-muted mb-3">
Seleccione las entidades que desea eliminar de la base de datos antes de re-importar. Las restricciones
de clave foránea se limpian automáticamente en el orden estricto.
<strong class="text-body">Nota de seguridad:</strong> Los usuarios del sistema, credenciales de acceso,
roles RBAC y registros de auditoría <u>NUNCA</u> se eliminan.
</p>
<form id="purgeForm" method="POST" action="/admin/reset_academic_data">
<div class="row g-3 mb-3">
<div class="col-md-6 col-lg-4">
<div class="form-check p-2 border rounded bg-body-tertiary">
<input class="form-check-input ms-1 me-2" type="checkbox" name="reset_reservations"
id="chk_reservations" value="true" checked>
<label class="form-check-label fw-semibold" for="chk_reservations">
Asignaciones de Aulas (Reservas)
<small class="d-block text-muted fw-normal">Elimina las clases cargadas en el
calendario.</small>
</label>
</div>
</div>
<div class="col-md-6 col-lg-4">
<div class="form-check p-2 border rounded bg-body-tertiary">
<input class="form-check-input ms-1 me-2" type="checkbox" name="reset_classrooms"
id="chk_classrooms" value="true">
<label class="form-check-label fw-semibold" for="chk_classrooms">
Aulas Físicas y Virtuales
<small class="d-block text-muted fw-normal">Elimina aulas y espacios áulicos
creados.</small>
</label>
</div>
</div>
<div class="col-md-6 col-lg-4">
<div class="form-check p-2 border rounded bg-body-tertiary">
<input class="form-check-input ms-1 me-2" type="checkbox" name="reset_commissions"
id="chk_commissions" value="true">
<label class="form-check-label fw-semibold" for="chk_commissions">
Comisiones de Cursada
<small class="d-block text-muted fw-normal">Elimina turnos y comisiones de
asignaturas.</small>
</label>
</div>
</div>
<div class="col-md-6 col-lg-4">
<div class="form-check p-2 border rounded bg-body-tertiary">
<input class="form-check-input ms-1 me-2" type="checkbox" name="reset_subjects"
id="chk_subjects" value="true">
<label class="form-check-label fw-semibold" for="chk_subjects">
Asignaturas / Materias
<small class="d-block text-muted fw-normal">Elimina el catálogo de materias
importadas.</small>
</label>
</div>
</div>
<div class="col-md-6 col-lg-4">
<div class="form-check p-2 border rounded bg-body-tertiary">
<input class="form-check-input ms-1 me-2" type="checkbox" name="reset_careers"
id="chk_careers" value="true">
<label class="form-check-label fw-semibold" for="chk_careers">
Carreras Académicas
<small class="d-block text-muted fw-normal">Elimina las carreras (Tecnicaturas,
Licenciaturas, etc).</small>
</label>
</div>
</div>
<div class="col-md-6 col-lg-4">
<div class="form-check p-2 border rounded border-danger bg-danger bg-opacity-10">
<input class="form-check-input ms-1 me-2" type="checkbox" name="reset_all" id="chk_all"
value="true" onchange="toggleSelectAll(this.checked)">
<label class="form-check-label fw-bold text-danger" for="chk_all">
Reiniciar Todo el Esquema
<small class="d-block text-danger fw-normal">Marca automáticamente todas las
entidades.</small>
</label>
</div>
</div>
</div>
<div class="d-flex justify-content-end">
<button type="button" class="btn btn-outline-danger px-4" onclick="openPurgeModal()">
<i class="bi bi-exclamation-triangle me-2"></i>Ejecutar Purga de Datos Seleccionados
</button>
</div>
</form>
</div>
</div>
<!-- Database Preview Table -->
<div class="card border-0 shadow-sm mb-5">
<div class="card-header bg-body-tertiary d-flex justify-content-between align-items-center py-3">
<h5 class="card-title h6 mb-0 fw-bold">
<i class="bi bi-table text-primary me-2"></i>Muestra de Asignaturas en Base de Datos (Primeras 15)
</h5>
<span class="badge bg-secondary-subtle text-secondary">
Total: {{ metrics.total_subjects }} asignaturas
</span>
</div>
<div class="table-responsive">
<table class="table table-hover align-middle mb-0">
<thead class="bg-body-tertiary">
<tr>
<th class="ps-4">Código</th>
<th>Nombre de la Asignatura</th>
<th>Carrera / Departamento</th>
<th>Comisiones</th>
<th>Estado</th>
</tr>
</thead>
<tbody>
{% for s in recent_subjects %}
<tr>
<td class="ps-4">
<span class="badge bg-secondary-subtle text-secondary font-monospace border">
{{ s.code }}
</span>
</td>
<td>
<div class="fw-semibold">{{ s.name }}</div>
</td>
<td>
<span class="badge bg-primary-subtle text-primary border border-primary-subtle small">
{{ s.career_obj.name if s.career_obj else (s.career_name or s.department or 'General')
}}
</span>
</td>
<td>
<span class="small text-muted">
{{ s.commissions_count if s.commissions_count is defined else (s.commissions|length if
s.commissions else 0) }} comisión(es)
</span>
</td>
<td>
{% if s.is_active %}
<span class="badge bg-success-subtle text-success border border-success-subtle small">
<i class="bi bi-check-circle me-1"></i>Activa
</span>
{% else %}
<span class="badge bg-secondary small">Inactiva</span>
{% endif %}
</td>
</tr>
{% else %}
<tr>
<td colspan="5" class="text-center py-5 text-muted">
<i class="bi bi-cloud-arrow-down fs-1 d-block mb-2 text-secondary"></i>
No hay materias en la base de datos actualmente. Haga clic en "Sincronizar Datos Ahora" para
importar.
</td>
</tr>
{% endfor %}
</tbody>
</table>
</div>
</div>
</div>
<!-- Modal: Confirmación de Purga de Datos Académicos -->
<div class="modal fade" id="purgeConfirmModal" tabindex="-1" aria-labelledby="purgeConfirmModalLabel" aria-hidden="true">
<div class="modal-dialog modal-dialog-centered">
<div class="modal-content border-0 shadow-lg">
<div class="modal-header bg-danger text-white py-3">
<h5 class="modal-title h6 fw-bold" id="purgeConfirmModalLabel">
<i class="bi bi-exclamation-triangle-fill me-2"></i>Confirmar Purga de Datos Académicos
</h5>
<button type="button" class="btn-close btn-close-white" data-bs-dismiss="modal" aria-label="Close"></button>
</div>
<div class="modal-body p-4">
<p class="mb-3 text-body">
Se procederá a <strong>eliminar de forma permanente</strong> los siguientes registros de la base de datos:
</p>
<ul class="list-group list-group-flush border rounded mb-3 small" id="purgeEntitiesList">
<!-- Poblado dinámicamente -->
</ul>
<div class="alert alert-warning small mb-0 d-flex gap-2 align-items-start">
<i class="bi bi-shield-lock-fill fs-5 text-warning flex-shrink-0"></i>
<div>
<strong>Seguridad del Sistema:</strong> Los usuarios del sistema (administradores, bedeles, docentes, alumnos), sus contraseñas, roles RBAC y registros de auditoría <u>permanecerán intactos</u>.
</div>
</div>
</div>
<div class="modal-footer bg-body-tertiary border-top py-2">
<button type="button" class="btn btn-outline-secondary btn-sm" data-bs-dismiss="modal">Cancelar</button>
<button type="button" class="btn btn-danger btn-sm px-3" id="btnDoPurge" onclick="confirmPurge()">
<i class="bi bi-trash-fill me-1"></i>Sí, Confirmar Purga
</button>
</div>
</div>
</div>
</div>
<!-- Modal: Confirmación de Sincronización Académica -->
<div class="modal fade" id="syncConfirmModal" tabindex="-1" aria-labelledby="syncConfirmModalLabel" aria-hidden="true">
<div class="modal-dialog modal-dialog-centered">
<div class="modal-content border-0 shadow-lg">
<div class="modal-header bg-success text-white py-3">
<h5 class="modal-title h6 fw-bold" id="syncConfirmModalLabel">
<i class="bi bi-cloud-arrow-up-fill me-2"></i>Confirmar Sincronización Académica
</h5>
<button type="button" class="btn-close btn-close-white" data-bs-dismiss="modal" aria-label="Close"></button>
</div>
<div class="modal-body p-4">
<p class="mb-2 text-body">
¿Desea iniciar el procesamiento y sincronización de datos con el siguiente alcance?
</p>
<div class="p-3 bg-body-tertiary border rounded mb-3 small" id="syncConfirmDetails">
<!-- Poblado dinámicamente -->
</div>
<div class="alert alert-info small mb-0 d-flex gap-2 align-items-start">
<i class="bi bi-info-circle-fill fs-5 text-info flex-shrink-0"></i>
<div>
<strong>Nota:</strong> Los registros se validarán contra la matriz de disponibilidad. Las fechas editadas en la grilla se aplicarán a cada asignación individual.
</div>
</div>
</div>
<div class="modal-footer bg-body-tertiary border-top py-2">
<button type="button" class="btn btn-outline-secondary btn-sm" data-bs-dismiss="modal">Cancelar</button>
<button type="button" class="btn btn-success btn-sm px-4 fw-semibold" id="btnDoSyncConfirm" onclick="confirmSyncSubmission()">
<i class="bi bi-check2-circle me-1"></i>Sí, Iniciar Sincronización
</button>
</div>
</div>
</div>
</div>
{% endblock %}
{% block extra_js %}
<script>
// Variables globales para el manejo de la previsualización interactiva
window.inspectedRows = [];
window.previewCurrentPage = 1;
window.previewPageSize = 25;
window.previewSearchTerm = '';
// Gestión de Entidades
function toggleImportEntities(checked) {
document.querySelectorAll('.import-entity-chk').forEach(el => el.checked = checked);
}
// Gestión de Días de la Semana
function setDaysSelection(mode) {
const chks = document.querySelectorAll('.filter-day-chk');
chks.forEach(el => {
if (mode === 'all') {
el.checked = true;
} else if (mode === 'none') {
el.checked = false;
} else if (mode === 'workdays') {
el.checked = (el.value !== 'Sábado' && el.value !== 'Sabado');
}
});
}
function getSelectedDays() {
const selected = [];
document.querySelectorAll('.filter-day-chk:checked').forEach(el => {
selected.push(el.value);
});
return selected;
}
// Limpieza de Filtros
function clearFilters() {
const c = document.getElementById('filter_career');
if (c) c.value = '';
const s = document.getElementById('filter_subject');
if (s) s.value = '';
const m = document.getElementById('manual_date');
if (m) m.value = '';
const single = document.getElementById('single_date_only');
if (single) single.checked = false;
setDaysSelection('all');
}
// Restaurar URL oficial
function restoreDefaultUrl() {
const defaultUrl = "{{ sheets_config.default_url }}";
const input = document.getElementById('google_sheets_url');
if (input && defaultUrl) {
input.value = defaultUrl;
}
}
// Inspección Online del Sheet
async function inspectOnlineSheets() {
const btn = document.getElementById('btnInspectSheet');
const btnText = document.getElementById('inspectBtnText');
const alertBox = document.getElementById('inspectAlert');
const alertMsg = document.getElementById('inspectAlertMsg');
const urlInput = document.getElementById('google_sheets_url');
const previewSec = document.getElementById('previewSection');
if (btn) btn.disabled = true;
if (btnText) btnText.innerText = 'Inspeccionando...';
try {
const selectedDays = getSelectedDays();
const payload = {
sheets_url: urlInput ? urlInput.value.trim() : '',
filter_career: (document.getElementById('filter_career')?.value || '').trim(),
filter_subject: (document.getElementById('filter_subject')?.value || '').trim(),
filter_days: selectedDays,
manual_date: (document.getElementById('manual_date')?.value || '').trim()
};
const resp = await fetch('/admin/sheets_inspect', {
method: 'POST',
headers: { 'Content-Type': 'application/json' },
body: JSON.stringify(payload)
});
const data = await resp.json();
if (data.status === 'success' && data.metadata) {
const meta = data.metadata;
// Actualizar datalist de Carreras
const careersList = document.getElementById('careersDataList');
if (careersList && meta.careers) {
careersList.innerHTML = '';
meta.careers.forEach(function(c) {
const opt = document.createElement('option');
opt.value = c;
careersList.appendChild(opt);
});
}
// Actualizar datalist de Materias
const subjectsList = document.getElementById('subjectsDataList');
if (subjectsList && meta.subjects) {
subjectsList.innerHTML = '';
meta.subjects.forEach(function(s) {
const opt = document.createElement('option');
opt.value = s.code + ' - ' + s.name;
subjectsList.appendChild(opt);
});
}
// Cargar filas en memoria para la grilla interactiva
const rawRows = meta.preview_rows || [];
window.inspectedRows = rawRows.map(function(r) {
return Object.assign({}, r, {
selected: r.is_valid !== false,
date: r.inferred_date || document.getElementById('manual_date')?.value || ''
});
});
// Mostrar Alert resumen
if (alertBox && alertMsg) {
alertBox.className = 'alert alert-success border-0 shadow-sm mb-4';
alertMsg.innerHTML = '<strong>Inspección completada con éxito:</strong> Se detectaron <strong>' +
(meta.total_rows || 0) + ' filas procesables</strong>, <strong>' +
(meta.careers ? meta.careers.length : 0) + ' carreras</strong> y <strong>' +
(meta.subjects ? meta.subjects.length : 0) + ' materias</strong> en los días seleccionados (' +
(selectedDays.join(', ') || 'Todos') + '). Revise los registros en la grilla inferior.';
alertBox.classList.remove('d-none');
}
// Desplegar y renderizar la grilla
if (previewSec) {
previewSec.classList.remove('d-none');
window.previewCurrentPage = 1;
renderPreview();
previewSec.scrollIntoView({ behavior: 'smooth', block: 'start' });
}
} else {
throw new Error(data.message || 'No se pudieron extraer datos del Sheet online.');
}
} catch (err) {
if (alertBox && alertMsg) {
alertBox.className = 'alert alert-danger border-0 shadow-sm mb-4';
alertMsg.innerHTML = '<strong>Error al inspeccionar Sheet online:</strong> ' + err.message;
alertBox.classList.remove('d-none');
}
} finally {
if (btn) btn.disabled = false;
if (btnText) btnText.innerText = 'Inspeccionar Sheet Online';
}
}
// Filtro de búsqueda en la grilla
function onPreviewSearch() {
const inp = document.getElementById('previewSearchInput');
window.previewSearchTerm = (inp ? inp.value : '').toLowerCase().trim();
window.previewCurrentPage = 1;
renderPreview();
}
function getFilteredRows() {
if (!window.previewSearchTerm) {
return window.inspectedRows;
}
const term = window.previewSearchTerm;
return window.inspectedRows.filter(function(r) {
const str = [
r.dia || '',
r.codigo || '',
r.asignatura || '',
r.carrera || '',
(r.carreras_list || []).join(' '),
r.aula || '',
r.horario || '',
r.turno || ''
].join(' ').toLowerCase();
return str.indexOf(term) !== -1;
});
}
// Renderizado dinámico de la Grilla Interactiva
function renderPreview() {
const tbody = document.getElementById('previewTableBody');
if (!tbody) return;
const filtered = getFilteredRows();
const totalFiltered = filtered.length;
const totalAll = window.inspectedRows.length;
const selectedCount = window.inspectedRows.filter(r => r.selected).length;
// Actualizar contadores
const totalCountEl = document.getElementById('previewTotalCount');
const selCountEl = document.getElementById('previewSelectedCount');
const selCountBtnEl = document.getElementById('previewSelectedCountBtn');
if (totalCountEl) totalCountEl.innerText = totalAll;
if (selCountEl) selCountEl.innerText = selectedCount;
if (selCountBtnEl) selCountBtnEl.innerText = selectedCount;
// Paginación
const totalPages = Math.max(1, Math.ceil(totalFiltered / window.previewPageSize));
if (window.previewCurrentPage > totalPages) window.previewCurrentPage = totalPages;
const startIdx = (window.previewCurrentPage - 1) * window.previewPageSize;
const pageRows = filtered.slice(startIdx, startIdx + window.previewPageSize);
if (pageRows.length === 0) {
tbody.innerHTML = '<tr><td colspan="9" class="text-center py-4 text-muted">' +
'<i class="bi bi-search fs-3 d-block mb-1 text-secondary"></i>' +
'No se encontraron registros que coincidan con la búsqueda.</td></tr>';
renderPreviewPagination(totalFiltered, totalPages);
return;
}
let html = '';
pageRows.forEach(function(row, idx) {
const globalIdx = startIdx + idx + 1;
const isInvalid = (row.is_valid === false);
const hasWarning = (row.has_warning === true);
const rowClass = isInvalid ? 'table-danger' : (hasWarning ? 'table-warning' : '');
// Badge de Aula
let aulaBadge = '';
if (row.is_virtual) {
aulaBadge = '<span class="badge bg-info-subtle text-info border border-info-subtle"><i class="bi bi-camera-video me-1"></i>' + (row.aula || 'Virtual') + '</span>';
} else if (row.aula) {
aulaBadge = '<span class="badge bg-secondary-subtle text-secondary border"><i class="bi bi-door-open me-1"></i>' + row.aula + '</span>';
} else {
aulaBadge = '<span class="badge bg-warning-subtle text-warning border border-warning-subtle"><i class="bi bi-question-circle me-1"></i>Sin Aula</span>';
}
// Badge de Estado
let estadoBadge = '';
if (isInvalid) {
estadoBadge = '<span class="badge bg-danger text-white"><i class="bi bi-x-circle me-1"></i>Inválido</span>';
} else if (hasWarning) {
estadoBadge = '<span class="badge bg-warning-subtle text-dark border border-warning-subtle" title="' + (row.warning_msg || 'Advertencia') + '"><i class="bi bi-exclamation-triangle me-1"></i>' + (row.warning_msg || 'Alerta') + '</span>';
} else {
estadoBadge = '<span class="badge bg-success-subtle text-success border border-success-subtle"><i class="bi bi-check-circle me-1"></i>Listo</span>';
}
// Carrera format
const carText = (row.carreras_list && row.carreras_list.length > 0) ? row.carreras_list.join(', ') : (row.carrera || 'General');
html += '<tr class="' + rowClass + '">' +
'<td class="text-center">' +
'<input class="form-check-input preview-row-chk" type="checkbox" ' +
(row.selected ? 'checked' : '') + ' ' +
(isInvalid ? 'disabled' : '') + ' ' +
'onchange="toggleRowSelection(\'' + row.id + '\', this.checked)">' +
'</td>' +
'<td class="text-muted font-monospace">' + globalIdx + '</td>' +
'<td><span class="badge bg-primary-subtle text-primary border border-primary-subtle">' + (row.dia || '-') + '</span></td>' +
'<td><div class="fw-semibold">' + (row.turno || '') + '</div><small class="text-muted">' + (row.horario || '') + '</small></td>' +
'<td>' +
'<div class="fw-bold text-dark">' + (row.codigo || '') + '</div>' +
'<div class="small text-secondary text-truncate" style="max-width: 220px;" title="' + (row.asignatura || '') + '">' + (row.asignatura || '') + '</div>' +
'</td>' +
'<td><small class="text-muted d-block text-truncate" style="max-width: 160px;" title="' + carText + '">' + carText + '</small></td>' +
'<td>' + aulaBadge + '</td>' +
'<td>' +
'<input type="date" class="form-control form-control-sm font-monospace" ' +
'value="' + (row.date || row.inferred_date || '') + '" ' +
'onchange="updateRowDate(\'' + row.id + '\', this.value)">' +
'</td>' +
'<td>' + estadoBadge + '</td>' +
'</tr>';
});
tbody.innerHTML = html;
renderPreviewPagination(totalFiltered, totalPages);
// Actualizar checkbox maestro
const masterChk = document.getElementById('chkSelectAllPreview');
if (masterChk) {
const visibleSelectable = pageRows.filter(r => r.is_valid !== false);
masterChk.checked = visibleSelectable.length > 0 && visibleSelectable.every(r => r.selected);
}
}
// Paginación visual
function renderPreviewPagination(totalFiltered, totalPages) {
const infoEl = document.getElementById('previewPaginationInfo');
const navEl = document.getElementById('previewPaginationNav');
if (!infoEl || !navEl) return;
const startIdx = totalFiltered === 0 ? 0 : (window.previewCurrentPage - 1) * window.previewPageSize + 1;
const endIdx = Math.min(window.previewCurrentPage * window.previewPageSize, totalFiltered);
infoEl.innerHTML = 'Mostrando registros <strong>' + startIdx + '</strong> - <strong>' + endIdx + '</strong> de <strong>' + totalFiltered + '</strong>';
let navHtml = '';
navHtml += '<li class="page-item ' + (window.previewCurrentPage === 1 ? 'disabled' : '') + '">' +
'<button class="page-link py-1 px-2" onclick="goToPreviewPage(' + (window.previewCurrentPage - 1) + ')">&laquo;</button>' +
'</li>';
let startP = Math.max(1, window.previewCurrentPage - 2);
let endP = Math.min(totalPages, startP + 4);
if (endP - startP < 4) startP = Math.max(1, endP - 4);
for (let p = startP; p <= endP; p++) {
navHtml += '<li class="page-item ' + (p === window.previewCurrentPage ? 'active' : '') + '">' +
'<button class="page-link py-1 px-2" onclick="goToPreviewPage(' + p + ')">' + p + '</button>' +
'</li>';
}
navHtml += '<li class="page-item ' + (window.previewCurrentPage === totalPages ? 'disabled' : '') + '">' +
'<button class="page-link py-1 px-2" onclick="goToPreviewPage(' + (window.previewCurrentPage + 1) + ')">&raquo;</button>' +
'</li>';
navEl.innerHTML = navHtml;
}
function goToPreviewPage(page) {
const filtered = getFilteredRows();
const totalPages = Math.max(1, Math.ceil(filtered.length / window.previewPageSize));
if (page < 1 || page > totalPages) return;
window.previewCurrentPage = page;
renderPreview();
}
// Edición Inline de Fechas en la Grilla
function updateRowDate(rowId, newDate) {
const row = window.inspectedRows.find(r => r.id === rowId);
if (row) {
row.date = newDate;
row.inferred_date = newDate;
}
}
// Toggle individual de selección de fila
function toggleRowSelection(rowId, checked) {
const row = window.inspectedRows.find(r => r.id === rowId);
if (row) {
row.selected = checked;
}
const selCount = window.inspectedRows.filter(r => r.selected).length;
const selCountEl = document.getElementById('previewSelectedCount');
const selCountBtnEl = document.getElementById('previewSelectedCountBtn');
if (selCountEl) selCountEl.innerText = selCount;
if (selCountBtnEl) selCountBtnEl.innerText = selCount;
}
// Checkbox Maestro de la Grilla
function toggleMasterPreviewCheckbox(checked) {
const filtered = getFilteredRows();
filtered.forEach(function(r) {
if (r.is_valid !== false) {
r.selected = checked;
}
});
renderPreview();
}
function toggleSelectAllFiltered(checked) {
const filtered = getFilteredRows();
filtered.forEach(function(r) {
if (r.is_valid !== false) {
r.selected = checked;
}
});
renderPreview();
}
// Aplicar Fecha Masiva a todas las filas seleccionadas
function applyBulkDate() {
const bulkInput = document.getElementById('bulkDateInput');
const val = bulkInput ? bulkInput.value : '';
if (!val) {
alert('Por favor ingrese una fecha válida en el campo de Fecha masiva.');
return;
}
let updatedCount = 0;
window.inspectedRows.forEach(function(r) {
if (r.selected) {
r.date = val;
r.inferred_date = val;
updatedCount++;
}
});
renderPreview();
alert('Se aplicó la fecha ' + val + ' a ' + updatedCount + ' fila(s) seleccionada(s).');
}
// Modal de Confirmación de Sincronización
function openSyncConfirmModal() {
const hasInspected = (window.inspectedRows && window.inspectedRows.length > 0);
const selCount = hasInspected ? window.inspectedRows.filter(r => r.selected).length : null;
if (hasInspected && selCount === 0) {
alert('Atención: Tiene 0 filas seleccionadas en la grilla de previsualización. Seleccione al menos una fila para sincronizar.');
return;
}
// Resumen de entidades marcadas
const chkRes = document.getElementById('chk_import_reservations')?.checked;
const chkCls = document.getElementById('chk_import_classrooms')?.checked;
const chkCom = document.getElementById('chk_import_commissions')?.checked;
const chkSub = document.getElementById('chk_import_subjects')?.checked;
const chkCar = document.getElementById('chk_import_careers')?.checked;
const detailsEl = document.getElementById('syncConfirmDetails');
if (detailsEl) {
let html = '<ul class="list-unstyled mb-0">';
if (hasInspected) {
html += '<li class="mb-1"><i class="bi bi-check2-circle text-success me-2"></i><strong>' + selCount + ' registros específicos seleccionados</strong> desde la grilla interactiva.</li>';
} else {
html += '<li class="mb-1"><i class="bi bi-layers text-primary me-2"></i>Sincronización completa de las pestañas de días seleccionadas.</li>';
}
html += '<li class="mt-2 text-muted fw-semibold">Entidades a crear / sincronizar:</li>';
if (chkRes) html += '<li class="ms-3"><i class="bi bi-calendar-check text-danger me-2"></i>Asignaciones de aulas (Reservas en Calendario)</li>';
if (chkCls) html += '<li class="ms-3"><i class="bi bi-door-open text-success me-2"></i>Aulas físicas y virtuales</li>';
if (chkCom) html += '<li class="ms-3"><i class="bi bi-diagram-3 text-warning me-2"></i>Comisiones de cursada</li>';
if (chkSub) html += '<li class="ms-3"><i class="bi bi-book text-info me-2"></i>Asignaturas / Materias</li>';
if (chkCar) html += '<li class="ms-3"><i class="bi bi-mortarboard text-primary me-2"></i>Carreras Académicas</li>';
const days = getSelectedDays();
html += '<li class="mt-2 text-muted fw-semibold">Días de cursada: ' + (days.length > 0 ? days.join(', ') : 'Ninguno seleccionado') + '</li>';
html += '</ul>';
detailsEl.innerHTML = html;
}
const modalEl = document.getElementById('syncConfirmModal');
if (modalEl && typeof bootstrap !== 'undefined' && bootstrap.Modal) {
try {
const modal = new bootstrap.Modal(modalEl);
modal.show();
return;
} catch (e) {
console.warn('Bootstrap modal error, fallback:', e);
}
}
if (confirm("¿Confirma iniciar la sincronización de las entidades seleccionadas?")) {
confirmSyncSubmission();
}
}
function confirmSyncSubmission() {
const btnConfirm = document.getElementById('btnDoSyncConfirm');
if (btnConfirm) {
btnConfirm.disabled = true;
btnConfirm.innerHTML = '<span class="spinner-border spinner-border-sm me-2"></span>Iniciando...';
}
// Si se inspeccionó previamente, serializar las filas seleccionadas
const hiddenSelectedRows = document.getElementById('selected_rows_json');
if (hiddenSelectedRows && window.inspectedRows && window.inspectedRows.length > 0) {
const selectedOnly = window.inspectedRows.filter(r => r.selected);
hiddenSelectedRows.value = JSON.stringify(selectedOnly);
}
const urlInput = document.getElementById('google_sheets_url');
const syncUrlInput = document.getElementById('syncSheetsUrl');
if (urlInput && syncUrlInput) {
syncUrlInput.value = urlInput.value.trim();
}
const spinner = document.getElementById('syncSpinner');
if (spinner) spinner.classList.remove('d-none');
const form = document.getElementById('syncForm');
if (form) {
form.submit();
}
}
// Modal de Purga
function toggleSelectAll(checked) {
document.getElementById('chk_reservations').checked = checked;
document.getElementById('chk_classrooms').checked = checked;
document.getElementById('chk_commissions').checked = checked;
document.getElementById('chk_subjects').checked = checked;
document.getElementById('chk_careers').checked = checked;
}
function openPurgeModal() {
const isAll = document.getElementById('chk_all').checked;
const isRes = isAll || document.getElementById('chk_reservations').checked;
const isCls = isAll || document.getElementById('chk_classrooms').checked;
const isCom = isAll || document.getElementById('chk_commissions').checked;
const isSub = isAll || document.getElementById('chk_subjects').checked;
const isCar = isAll || document.getElementById('chk_careers').checked;
const anyChecked = isRes || isCls || isCom || isSub || isCar;
if (!anyChecked) {
alert('Por favor seleccione al menos una entidad para purgar.');
return;
}
const listEl = document.getElementById('purgeEntitiesList');
if (listEl) {
listEl.innerHTML = '';
if (isAll) {
listEl.innerHTML += '<li class="list-group-item list-group-item-danger fw-bold"><i class="bi bi-trash-fill me-2"></i>REINICIO TOTAL DEL ESQUEMA (Carreras, Asignaturas, Comisiones, Aulas y Reservas)</li>';
} else {
if (isCar) listEl.innerHTML += '<li class="list-group-item text-danger fw-semibold"><i class="bi bi-mortarboard me-2"></i>Carreras Académicas y sus Asignaturas asociadas</li>';
if (isSub && !isCar) listEl.innerHTML += '<li class="list-group-item text-danger fw-semibold"><i class="bi bi-book me-2"></i>Asignaturas / Materias y sus Comisiones</li>';
if (isCom && !isSub && !isCar) listEl.innerHTML += '<li class="list-group-item text-danger fw-semibold"><i class="bi bi-diagram-3 me-2"></i>Comisiones de Cursada e Inscripciones</li>';
if (isRes) listEl.innerHTML += '<li class="list-group-item text-danger"><i class="bi bi-calendar-event me-2"></i>Asignaciones de Aulas (Reservas del Calendario)</li>';
if (isCls) listEl.innerHTML += '<li class="list-group-item text-danger"><i class="bi bi-door-open me-2"></i>Aulas Físicas y Virtuales</li>';
}
}
const modalEl = document.getElementById('purgeConfirmModal');
if (modalEl && typeof bootstrap !== 'undefined' && bootstrap.Modal) {
try {
const modal = new bootstrap.Modal(modalEl);
modal.show();
return;
} catch (e) {
console.warn('Bootstrap modal error, falling back to window.confirm:', e);
}
}
if (confirm("ATENCIÓN: ¿Confirma la purga y eliminación permanente de los datos académicos seleccionados?\nEsta acción es irreversible.")) {
confirmPurge();
}
}
function confirmPurge() {
const btn = document.getElementById('btnDoPurge');
if (btn) {
btn.disabled = true;
btn.innerHTML = '<span class="spinner-border spinner-border-sm me-2"></span>Purgando base de datos...';
}
const form = document.getElementById('purgeForm');
if (form) {
form.submit();
}
}
</script>
{% endblock %}