128 lines
5.4 KiB
PHP
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'; ?>
|