98 lines
3.4 KiB
PHP
98 lines
3.4 KiB
PHP
<?php
|
|
/**
|
|
* Instalación: crea la BD, catálogos y usuario admin.
|
|
* Solo disponible en entorno local (APP_ENV=local).
|
|
* En producción importe sql/backup_produccion.sql
|
|
*/
|
|
set_time_limit(300);
|
|
require_once __DIR__ . '/config/config.php';
|
|
|
|
if (APP_ENV === 'production') {
|
|
http_response_code(403);
|
|
header('Content-Type: text/plain; charset=utf-8');
|
|
echo "Instalación deshabilitada en producción.\n";
|
|
echo "Importe sql/backup_produccion.sql y acceda al panel admin.\n";
|
|
exit;
|
|
}
|
|
|
|
require_once __DIR__ . '/config/database.php';
|
|
require_once __DIR__ . '/includes/functions.php';
|
|
|
|
$messages = [];
|
|
$errors = [];
|
|
|
|
try {
|
|
$pdo = getDBWithoutName();
|
|
$schema = file_get_contents(__DIR__ . '/sql/schema.sql');
|
|
foreach (array_filter(array_map('trim', explode(';', $schema))) as $stmt) {
|
|
if ($stmt !== '') {
|
|
$pdo->exec($stmt);
|
|
}
|
|
}
|
|
$messages[] = 'Base de datos y tablas creadas.';
|
|
|
|
$db = getDB();
|
|
|
|
$countModulos = (int) $db->query('SELECT COUNT(*) FROM modulos')->fetchColumn();
|
|
if ($countModulos > 0) {
|
|
$countUb = (int) $db->query('SELECT COUNT(*) FROM ubicaciones')->fetchColumn();
|
|
$messages[] = "Datos existentes: {$countModulos} módulo(s), {$countUb} ubicación(es).";
|
|
} else {
|
|
$messages[] = 'Base vacía. Agregue módulos y ubicaciones desde el panel admin o restaure un respaldo SQL.';
|
|
}
|
|
|
|
seedEmpresasServicios($db, true);
|
|
|
|
require_once __DIR__ . '/includes/auth.php';
|
|
if (seedDefaultAdmin($db)) {
|
|
$messages[] = 'Usuario admin creado (usuario: admin, contraseña: admin123).';
|
|
}
|
|
|
|
regenerateQrCsv($db);
|
|
$messages[] = 'Archivo qr_data.csv generado desde la base de datos.';
|
|
|
|
} catch (Throwable $e) {
|
|
if (isset($db) && $db->inTransaction()) {
|
|
$db->rollBack();
|
|
}
|
|
$errors[] = $e->getMessage();
|
|
}
|
|
|
|
$pageTitle = 'Instalación';
|
|
?>
|
|
<!DOCTYPE html>
|
|
<html lang="es">
|
|
<head>
|
|
<meta charset="UTF-8">
|
|
<meta name="viewport" content="width=device-width, initial-scale=1.0">
|
|
<title>Instalación - <?= htmlspecialchars(APP_NAME) ?></title>
|
|
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/css/bootstrap.min.css" rel="stylesheet">
|
|
</head>
|
|
<body class="bg-light">
|
|
<div class="container py-5">
|
|
<div class="row justify-content-center">
|
|
<div class="col-md-8">
|
|
<div class="card">
|
|
<div class="card-header">Instalación del sistema</div>
|
|
<div class="card-body">
|
|
<?php foreach ($messages as $m): ?>
|
|
<div class="alert alert-success"><?= htmlspecialchars($m) ?></div>
|
|
<?php endforeach; ?>
|
|
<?php foreach ($errors as $e): ?>
|
|
<div class="alert alert-danger"><?= htmlspecialchars($e) ?></div>
|
|
<?php endforeach; ?>
|
|
<?php if (empty($errors)): ?>
|
|
<p class="mb-3">El sistema está listo. Los QR deben apuntar a:</p>
|
|
<code><?= htmlspecialchars(BASE_URL) ?>/formulario.php?u=UB-00001</code>
|
|
<div class="mt-4 d-flex gap-2">
|
|
<a href="admin/index.php" class="btn btn-primary">Ir al panel</a>
|
|
<a href="formulario.php?u=UB-00001" class="btn btn-outline-secondary">Probar formulario</a>
|
|
</div>
|
|
<?php endif; ?>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</body>
|
|
</html>
|