13 lines
492 B
PHP
13 lines
492 B
PHP
<?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);
|