$type, 'message' => $message]; } function getFlash(): ?array { if (!isset($_SESSION['flash'])) { return null; } $flash = $_SESSION['flash']; unset($_SESSION['flash']); return $flash; } function getUbicacionByCodigo(PDO $db, string $codigo): ?array { $stmt = $db->prepare(' SELECT u.id, u.codigo AS ubicacion_codigo, u.nombre AS ubicacion_nombre, m.id AS modulo_id, m.codigo AS modulo_codigo, m.nombre AS modulo_nombre FROM ubicaciones u JOIN modulos m ON m.id = u.modulo_id WHERE u.codigo = ? AND u.activo = 1 AND m.activo = 1 '); $stmt->execute([$codigo]); $row = $stmt->fetch(); return $row ?: null; } function formatFecha(?string $datetime): string { if (!$datetime) { return ''; } $dt = new DateTime($datetime); return $dt->format('d/m/Y H:i'); } function nextModuloCodigo(PDO $db): string { $row = $db->query("SELECT codigo FROM modulos WHERE codigo REGEXP '^MOD-[0-9]+$' ORDER BY CAST(SUBSTRING(codigo, 5) AS UNSIGNED) DESC LIMIT 1")->fetch(); $num = $row ? (int) substr($row['codigo'], 4) : 0; return sprintf('MOD-%03d', $num + 1); } function nextUbicacionCodigo(PDO $db): string { $row = $db->query("SELECT codigo FROM ubicaciones WHERE codigo REGEXP '^UB-[0-9]+$' ORDER BY CAST(SUBSTRING(codigo, 4) AS UNSIGNED) DESC LIMIT 1")->fetch(); $num = $row ? (int) substr($row['codigo'], 4) : 0; return sprintf('UB-%05d', $num + 1); } function seedEmpresasServicios(PDO $db, bool $onlyIfEmpty = false): void { $count = (int) $db->query('SELECT COUNT(*) FROM empresas')->fetchColumn(); if ($count > 0 && $onlyIfEmpty) { return; } if ($count > 0 && !$onlyIfEmpty) { return; } $db->exec('DELETE FROM servicios'); $db->exec('DELETE FROM empresas'); $empresas = ['SODEXO', 'REYSAP', 'MTTO CAMP', 'SmartService']; $stmt = $db->prepare('INSERT INTO empresas (nombre) VALUES (?)'); foreach ($empresas as $e) { $stmt->execute([$e]); } $servicios = [ 'SODEXO' => ['Limpieza / Supervisión', 'Fumigación'], 'REYSAP' => ['Servicio de Mantenimiento'], 'MTTO CAMP' => ['Mtto Preventivo', 'Mtto Correctivo'], 'SmartService' => ['Mtto Cocina'], ]; $stmtSrv = $db->prepare(' INSERT INTO servicios (empresa_id, nombre) SELECT id, ? FROM empresas WHERE nombre = ? '); foreach ($servicios as $empresa => $lista) { foreach ($lista as $srv) { $stmtSrv->execute([$srv, $empresa]); } } } function safeQrFilename(string $text): string { return preg_replace('/[\\\\\/:*?"<>|]/', '-', $text); } /** @return array codigo => filename.png */ function buildQrFilenameMap(array $ubicaciones): array { $used = []; $map = []; foreach ($ubicaciones as $u) { $base = safeQrFilename($u['modulo']) . '_' . safeQrFilename($u['ubicacion']); $filename = $base . '.png'; if (isset($used[$filename])) { $filename = $base . '_' . safeQrFilename($u['codigo']) . '.png'; } $used[$filename] = true; $map[$u['codigo']] = $filename; } return $map; } function regenerateQrCsv(PDO $db): void { $path = dirname(__DIR__) . '/qr_data.csv'; $rows = $db->query(' SELECT u.codigo, m.nombre AS modulo, u.nombre AS ubicacion FROM ubicaciones u JOIN modulos m ON m.id = u.modulo_id WHERE u.activo = 1 ORDER BY u.codigo ')->fetchAll(); $fh = fopen($path, 'w'); fputcsv($fh, ['codigo', 'modulo', 'ubicacion', 'url'], ',', '"', '\\'); foreach ($rows as $r) { fputcsv($fh, [ $r['codigo'], $r['modulo'], $r['ubicacion'], BASE_URL . '/formulario.php?u=' . $r['codigo'], ], ',', '"', '\\'); } fclose($fh); } function qrOutputDir(): string { return dirname(__DIR__) . '/output'; } function qrFilePathForUbicacion(string $modulo, string $ubicacion, string $codigo, array $filenameMap): ?string { $filename = $filenameMap[$codigo] ?? null; if (!$filename) { return null; } $path = qrOutputDir() . '/' . $filename; return is_file($path) ? $path : null; } function deleteQrFileForUbicacion(string $modulo, string $ubicacion, string $codigo, array $filenameMap): void { $path = qrFilePathForUbicacion($modulo, $ubicacion, $codigo, $filenameMap); if ($path) { @unlink($path); } } function countRegistrosForUbicacion(PDO $db, int $id): int { $stmt = $db->prepare('SELECT COUNT(*) FROM registros WHERE ubicacion_id = ?'); $stmt->execute([$id]); return (int) $stmt->fetchColumn(); } function countRegistrosForEmpresa(PDO $db, int $id): int { $stmt = $db->prepare('SELECT COUNT(*) FROM registros WHERE empresa_id = ?'); $stmt->execute([$id]); return (int) $stmt->fetchColumn(); } function countRegistrosForServicio(PDO $db, int $id): int { $stmt = $db->prepare('SELECT COUNT(*) FROM registros WHERE servicio_id = ?'); $stmt->execute([$id]); return (int) $stmt->fetchColumn(); }