109 lines
3.2 KiB
PHP
109 lines
3.2 KiB
PHP
<?php
|
|
require_once __DIR__ . '/../includes/admin_bootstrap.php';
|
|
require_once __DIR__ . '/../config/database.php';
|
|
|
|
$db = getDB();
|
|
$outputDir = qrOutputDir();
|
|
|
|
$rows = $db->query('
|
|
SELECT u.codigo, m.nombre AS modulo, u.nombre AS ubicacion, u.modulo_id
|
|
FROM ubicaciones u
|
|
JOIN modulos m ON m.id = u.modulo_id
|
|
WHERE u.activo = 1
|
|
ORDER BY u.codigo
|
|
')->fetchAll();
|
|
|
|
$filenameMap = buildQrFilenameMap($rows);
|
|
|
|
$codigo = trim($_GET['codigo'] ?? '');
|
|
$bulk = isset($_GET['bulk']);
|
|
$moduloFiltro = (int) ($_GET['modulo_id'] ?? 0);
|
|
$selected = array_filter(array_map('trim', (array) ($_GET['codes'] ?? [])));
|
|
|
|
if ($codigo !== '') {
|
|
$match = null;
|
|
foreach ($rows as $r) {
|
|
if ($r['codigo'] === $codigo) {
|
|
$match = $r;
|
|
break;
|
|
}
|
|
}
|
|
if (!$match) {
|
|
flash('danger', 'Ubicación no encontrada.');
|
|
redirect(BASE_URL . '/admin/qrs.php');
|
|
}
|
|
|
|
$path = qrFilePathForUbicacion($match['modulo'], $match['ubicacion'], $match['codigo'], $filenameMap);
|
|
if (!$path) {
|
|
flash('warning', 'El QR aún no está generado. Use «Generar QR» primero.');
|
|
redirect(BASE_URL . '/admin/qrs.php');
|
|
}
|
|
|
|
$downloadName = $filenameMap[$codigo] ?? basename($path);
|
|
header('Content-Type: image/png');
|
|
header('Content-Disposition: attachment; filename="' . $downloadName . '"');
|
|
header('Content-Length: ' . filesize($path));
|
|
readfile($path);
|
|
exit;
|
|
}
|
|
|
|
if (!$bulk && empty($selected)) {
|
|
redirect(BASE_URL . '/admin/qrs.php');
|
|
}
|
|
|
|
if (!class_exists('ZipArchive')) {
|
|
flash('danger', 'ZipArchive no está disponible en el servidor.');
|
|
redirect(BASE_URL . '/admin/qrs.php');
|
|
}
|
|
|
|
$toZip = [];
|
|
foreach ($rows as $r) {
|
|
if ($moduloFiltro > 0 && (int) $r['modulo_id'] !== $moduloFiltro) {
|
|
continue;
|
|
}
|
|
if (!empty($selected) && !in_array($r['codigo'], $selected, true)) {
|
|
continue;
|
|
}
|
|
$path = qrFilePathForUbicacion($r['modulo'], $r['ubicacion'], $r['codigo'], $filenameMap);
|
|
if ($path) {
|
|
$toZip[] = ['path' => $path, 'name' => $filenameMap[$r['codigo']] ?? basename($path)];
|
|
}
|
|
}
|
|
|
|
if (empty($toZip)) {
|
|
flash('warning', 'No hay QR generados para descargar con los filtros seleccionados.');
|
|
redirect(BASE_URL . '/admin/qrs.php' . ($moduloFiltro ? '?modulo_id=' . $moduloFiltro : ''));
|
|
}
|
|
|
|
$zip = new ZipArchive();
|
|
$tmpFile = tempnam(sys_get_temp_dir(), 'qrs_');
|
|
if ($zip->open($tmpFile, ZipArchive::OVERWRITE) !== true) {
|
|
flash('danger', 'No se pudo crear el archivo ZIP.');
|
|
redirect(BASE_URL . '/admin/qrs.php');
|
|
}
|
|
|
|
foreach ($toZip as $item) {
|
|
$zip->addFile($item['path'], $item['name']);
|
|
}
|
|
$zip->close();
|
|
|
|
$zipName = 'qrs_campamento';
|
|
if ($moduloFiltro > 0) {
|
|
$stmt = $db->prepare('SELECT nombre FROM modulos WHERE id = ?');
|
|
$stmt->execute([$moduloFiltro]);
|
|
$modName = $stmt->fetchColumn();
|
|
if ($modName) {
|
|
$zipName .= '_' . safeQrFilename($modName);
|
|
}
|
|
}
|
|
if (!empty($selected)) {
|
|
$zipName .= '_seleccion';
|
|
}
|
|
$zipName .= '_' . date('Y-m-d') . '.zip';
|
|
|
|
header('Content-Type: application/zip');
|
|
header('Content-Disposition: attachment; filename="' . $zipName . '"');
|
|
header('Content-Length: ' . filesize($tmpFile));
|
|
readfile($tmpFile);
|
|
@unlink($tmpFile);
|
|
exit;
|