<?php
declare(strict_types=1);
$originalRoot = 'C:/zyt/server';
try {
    $environment = parse_ini_file($originalRoot . '/.env', true, INI_SCANNER_RAW);
    if (!is_array($environment)) { throw new RuntimeException('Unable to load project configuration'); }
    $database = array_change_key_case($environment['database'] ?? [], CASE_LOWER);
    $prefix = (string) ($database['prefix'] ?? '');
    if (!preg_match('/^[a-zA-Z0-9_]*$/D', $prefix)) { throw new RuntimeException('Invalid prefix'); }
    $pdo = new PDO('mysql:host=' . $database['hostname'] . ';port=' . ($database['hostport'] ?? '3306') . ';dbname=' . $database['database'] . ';charset=utf8mb4', $database['username'], $database['password'], [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_TIMEOUT => 5]);
    $result = ['connected' => true, 'read_only_probe' => true];
    foreach (['admin', 'system_role', 'system_menu', 'dept', 'admin_role', 'admin_dept', 'admin_jobs', 'admin_session'] as $table) {
        $columns = $pdo->query('SHOW COLUMNS FROM `' . $prefix . $table . '`')->fetchAll(PDO::FETCH_COLUMN);
        $where = in_array('delete_time', $columns, true) ? ' WHERE delete_time IS NULL' : '';
        $result['tables'][$table] = ['count' => (int) $pdo->query('SELECT COUNT(*) FROM `' . $prefix . $table . '`' . $where)->fetchColumn(), 'columns' => $columns];
    }
    $result['navigation_candidates'] = $pdo->query("SELECT id,type,name,perms,paths,component,is_disable FROM `{$prefix}system_menu` WHERE component IN ('permission/admin/index','permission/role/index','permission/menu/index','organization/department/index') OR perms IN ('auth.admin/lists','auth.role/lists','auth.menu/lists','dept.dept/lists')")->fetchAll(PDO::FETCH_ASSOC);
    echo json_encode($result, JSON_UNESCAPED_UNICODE | JSON_PRETTY_PRINT) . PHP_EOL;
} catch (Throwable $error) {
    echo json_encode(['connected' => false, 'error_code' => (string) $error->getCode(), 'message' => 'Project database probe failed; credentials were not printed.']) . PHP_EOL;
    exit(1);
}