<?php
header('Content-Type: application/json');
require_once 'auth.php';
require_login();

$pdo = db();

function getVisitsByStatus($pdo) {
    $stmt = $pdo->prepare('SELECT status, COUNT(*) as count FROM visits GROUP BY status');
    $stmt->execute();
    $results = $stmt->fetchAll(PDO::FETCH_KEY_PAIR);

    $labels = array_keys($results);
    $data = array_values($results);

    return [
        'labels' => $labels,
        'data' => $data,
    ];
}

$response = [
    'visitsByStatus' => getVisitsByStatus($pdo),
];

echo json_encode($response);