query(
"SELECT COUNT(*) FROM ocorrencias"
)->fetchColumn();
$totalBombeiros = $pdo->query(
"SELECT COUNT(*) FROM bombeiros"
)->fetchColumn();
$totalViaturas = $pdo->query(
"SELECT COUNT(*) FROM viaturas"
)->fetchColumn();
$ocorrenciasAbertas = $pdo->query(
"SELECT COUNT(*) FROM ocorrencias
WHERE status='Aberta'"
)->fetchColumn();
$ocorrenciasAtendimento = $pdo->query(
"SELECT COUNT(*) FROM ocorrencias
WHERE status='Em Atendimento'"
)->fetchColumn();
$ocorrenciasFinalizadas = $pdo->query(
"SELECT COUNT(*) FROM ocorrencias
WHERE status='Finalizada'"
)->fetchColumn();
?>
SIGOB 2.0