query('SELECT COUNT(*) FROM assessments WHERE deleted_at IS NULL')->fetchColumn();
$aCompleted = (int)$pdo->query("SELECT COUNT(*) FROM assessments WHERE status = 'completed' AND deleted_at IS NULL")->fetchColumn();
$aOpen = (int)$pdo->query("SELECT COUNT(*) FROM assessments WHERE status IN ('draft','in_progress') AND deleted_at IS NULL")->fetchColumn();
$rTotal = (int)$pdo->query('SELECT COUNT(*) FROM checklist_runs WHERE deleted_at IS NULL')->fetchColumn();
$rCompleted = (int)$pdo->query("SELECT COUNT(*) FROM checklist_runs WHERE status = 'completed' AND deleted_at IS NULL")->fetchColumn();
$rOpen = (int)$pdo->query("SELECT COUNT(*) FROM checklist_runs WHERE status = 'draft' AND deleted_at IS NULL")->fetchColumn();
$stats = [
'plants' => (int)$pdo->query('SELECT COUNT(*) FROM plants WHERE is_active = 1')->fetchColumn(),
'assessments' => $aTotal + $rTotal,
'completed' => $aCompleted + $rCompleted,
'in_progress' => $aOpen + $rOpen,
];
// ---- Estado de flota (tiering) ----------------------------------------------
$tiers = ['1' => 0, '2' => 0, '3' => 0, 'none' => 0];
foreach ($pdo->query(
"SELECT COALESCE(CAST(current_tier AS CHAR), 'none') AS t, COUNT(*) AS c
FROM plants WHERE is_active = 1 GROUP BY t"
)->fetchAll() as $row) {
$tiers[$row['t']] = (int)$row['c'];
}
$pendingMap = Tier::evaluationPendingMap();
$evalPending = count(array_filter($pendingMap, static fn(array $v): bool => $v['pending']));
$tierReviews = count(Tier::pendingReviews());
// ---- Evaluaciones recientes (ambos instrumentos, mezcladas) ------------------
$recent = [];
foreach ($pdo->query(
"SELECT a.id, a.title, a.status, a.assessment_date AS d, a.updated_at AS ts,
p.code AS plant_code, p.name AS plant_name,
1 AS tier_class, 'c2m2' AS kind, NULL AS result
FROM assessments a JOIN plants p ON p.id = a.plant_id
WHERE a.deleted_at IS NULL
ORDER BY a.updated_at DESC LIMIT 10"
)->fetchAll() as $r) { $recent[] = $r; }
foreach ($pdo->query(
"SELECT r.id, t.name AS title, r.status, COALESCE(r.completed_at, r.started_at) AS d,
COALESCE(r.completed_at, r.started_at) AS ts,
p.code AS plant_code, p.name AS plant_name,
t.tier AS tier_class, 'run' AS kind, r.result
FROM checklist_runs r
JOIN plants p ON p.id = r.plant_id
JOIN checklist_templates t ON t.id = r.template_id
WHERE r.deleted_at IS NULL
ORDER BY ts DESC LIMIT 10"
)->fetchAll() as $r) { $recent[] = $r; }
usort($recent, static fn(array $x, array $y): int => strtotime($y['ts']) <=> strtotime($x['ts']));
$recent = array_slice($recent, 0, 10);
$statusLabels = [
'draft' => ['Borrador', 'badge-none'],
'in_progress' => ['En curso', 'badge-pi'],
'completed' => ['Completada', 'badge-fi'],
'archived' => ['Archivada', 'badge-na'],
];
$pageTitle = 'Dashboard';
$crumbs = [['label' => 'Dashboard']];
include __DIR__ . '/../views/_header.php';
?>
Dashboard
Visión global del programa de ciberseguridad OT de la flota