<?php
declare(strict_types=1);

require_once __DIR__ . '/app.php';

header('Content-Type: application/json');

try {
    ensure_request_table();
    $totalRequests = (int) db()->query('SELECT COUNT(*) FROM department_requests')->fetchColumn();

    echo json_encode([
        'status' => 'ok',
        'app' => app_name(),
        'time_utc' => gmdate('c'),
        'database' => 'connected',
        'requests' => $totalRequests,
    ], JSON_PRETTY_PRINT | JSON_UNESCAPED_SLASHES);
} catch (Throwable $exception) {
    http_response_code(500);
    echo json_encode([
        'status' => 'error',
        'app' => app_name(),
        'time_utc' => gmdate('c'),
        'database' => 'unavailable',
    ], JSON_PRETTY_PRINT | JSON_UNESCAPED_SLASHES);
}