AutoFiller_QR_Campamento/admin/registros.php
2026-06-11 16:40:36 -06:00

128 lines
5.4 KiB
PHP

<?php
$adminSection = 'registros';
$pageTitle = 'Registros';
$pageHeading = 'Registros de mantenimiento';
require_once __DIR__ . '/../includes/admin_header.php';
require_once __DIR__ . '/../config/database.php';
$db = getDB();
$moduloId = (int) ($_GET['modulo_id'] ?? 0);
$empresaId = (int) ($_GET['empresa_id'] ?? 0);
$fechaDesde = trim($_GET['desde'] ?? '');
$fechaHasta = trim($_GET['hasta'] ?? '');
$buscar = trim($_GET['q'] ?? '');
$modulos = $db->query('SELECT id, nombre FROM modulos WHERE activo = 1 ORDER BY nombre')->fetchAll();
$empresas = $db->query('SELECT id, nombre FROM empresas WHERE activo = 1 ORDER BY nombre')->fetchAll();
$sql = '
SELECT r.id, r.created_at, r.registrado_por, r.observaciones,
m.nombre AS modulo, u.nombre AS ubicacion, u.codigo AS ubicacion_codigo,
e.nombre AS empresa, s.nombre AS servicio
FROM registros r
JOIN ubicaciones u ON u.id = r.ubicacion_id
JOIN modulos m ON m.id = u.modulo_id
JOIN empresas e ON e.id = r.empresa_id
JOIN servicios s ON s.id = r.servicio_id
WHERE 1=1
';
$params = [];
if ($moduloId > 0) { $sql .= ' AND m.id = ?'; $params[] = $moduloId; }
if ($empresaId > 0) { $sql .= ' AND e.id = ?'; $params[] = $empresaId; }
if ($fechaDesde !== '') { $sql .= ' AND DATE(r.created_at) >= ?'; $params[] = $fechaDesde; }
if ($fechaHasta !== '') { $sql .= ' AND DATE(r.created_at) <= ?'; $params[] = $fechaHasta; }
if ($buscar !== '') {
$sql .= ' AND (u.nombre LIKE ? OR m.nombre LIKE ? OR e.nombre LIKE ? OR s.nombre LIKE ? OR r.registrado_por LIKE ?)';
$like = '%' . $buscar . '%';
array_push($params, $like, $like, $like, $like, $like);
}
$sql .= ' ORDER BY r.created_at DESC LIMIT 500';
$stmt = $db->prepare($sql);
$stmt->execute($params);
$registros = $stmt->fetchAll();
?>
<div class="card mb-4">
<div class="card-body">
<form method="get" class="row g-3 align-items-end">
<div class="col-md-3">
<label class="form-label">Módulo</label>
<select name="modulo_id" class="form-select">
<option value="">Todos</option>
<?php foreach ($modulos as $m): ?>
<option value="<?= (int) $m['id'] ?>" <?= $moduloId === (int) $m['id'] ? 'selected' : '' ?>><?= h($m['nombre']) ?></option>
<?php endforeach; ?>
</select>
</div>
<div class="col-md-2">
<label class="form-label">Empresa</label>
<select name="empresa_id" class="form-select">
<option value="">Todas</option>
<?php foreach ($empresas as $e): ?>
<option value="<?= (int) $e['id'] ?>" <?= $empresaId === (int) $e['id'] ? 'selected' : '' ?>><?= h($e['nombre']) ?></option>
<?php endforeach; ?>
</select>
</div>
<div class="col-md-2">
<label class="form-label">Desde</label>
<input type="date" name="desde" class="form-control" value="<?= h($fechaDesde) ?>">
</div>
<div class="col-md-2">
<label class="form-label">Hasta</label>
<input type="date" name="hasta" class="form-control" value="<?= h($fechaHasta) ?>">
</div>
<div class="col-md-2">
<label class="form-label">Buscar</label>
<input type="text" name="q" class="form-control" value="<?= h($buscar) ?>">
</div>
<div class="col-md-1">
<button type="submit" class="btn btn-primary w-100">Filtrar</button>
</div>
</form>
</div>
</div>
<div class="card">
<div class="card-header"><?= count($registros) ?> registro(s)</div>
<div class="table-responsive">
<table class="table table-hover table-sm mb-0">
<thead class="table-light">
<tr>
<th>#</th>
<th>Fecha</th>
<th>Módulo</th>
<th>Habitación</th>
<th>ID QR</th>
<th>Empresa</th>
<th>Servicio</th>
<th>Por</th>
<th>Obs.</th>
</tr>
</thead>
<tbody>
<?php if (empty($registros)): ?>
<tr><td colspan="9" class="text-center text-muted py-4">No hay registros.</td></tr>
<?php else: ?>
<?php foreach ($registros as $r): ?>
<tr>
<td><?= (int) $r['id'] ?></td>
<td class="text-nowrap small"><?= h(formatFecha($r['created_at'])) ?></td>
<td><?= h($r['modulo']) ?></td>
<td><?= h($r['ubicacion']) ?></td>
<td><code class="table-codigo"><?= h($r['ubicacion_codigo']) ?></code></td>
<td><?= h($r['empresa']) ?></td>
<td><span class="badge bg-secondary"><?= h($r['servicio']) ?></span></td>
<td><?= h($r['registrado_por'] ?? '—') ?></td>
<td class="small"><?= h($r['observaciones'] ?? '') ?></td>
</tr>
<?php endforeach; ?>
<?php endif; ?>
</tbody>
</table>
</div>
</div>
<?php require_once __DIR__ . '/../includes/admin_footer.php'; ?>