<?php
require_once __DIR__ . '/../auth.php';
$user = requireRole('curator');

$stats = [
    'total_tickets' => db()->query("SELECT COUNT(*) FROM tickets")->fetchColumn(),
    'active_tickets' => db()->query("SELECT COUNT(*) FROM tickets WHERE status != 'closed'")->fetchColumn(),
    'users_count' => db()->query("SELECT COUNT(*) FROM users")->fetchColumn(),
    'helpers_count' => db()->query("SELECT COUNT(*) FROM users WHERE role = 'helper'")->fetchColumn()
];

echo json_encode($stats);