
<?php
header('Content-Type: application/json');
$pdo = new PDO("pgsql:host=localhost;dbname=adx_system", "admin", "admin123", [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);

$action = $_GET['action'] ?? $_POST['action'] ?? '';

switch ($action) {
    case 'overview':
    case 'full':
        $data = [
            'cloud' => [
                'huawei' => $pdo->query("SELECT COUNT(*) FROM admin.huawei_accounts")->fetchColumn(),
                'regions_active' => $pdo->query("SELECT COUNT(*) FROM admin.huawei_regions WHERE is_active = true")->fetchColumn()
            ],
            'email' => [
                'o365' => $pdo->query("SELECT COUNT(*) FROM admin.office365_accounts")->fetchColumn(),
                'gsuite' => $pdo->query("SELECT COUNT(*) FROM admin.gsuite_accounts")->fetchColumn()
            ],
            'infrastructure' => [
                'mta_servers' => $pdo->query("SELECT COUNT(*) FROM admin.mta_servers")->fetchColumn(),
                'domains' => $pdo->query("SELECT COUNT(*) FROM admin.domains")->fetchColumn()
            ],
            'data' => [
                'leads' => $pdo->query("SELECT COUNT(*) FROM admin.leads")->fetchColumn(),
                'campaigns' => $pdo->query("SELECT COUNT(*) FROM admin.campaigns")->fetchColumn()
            ],
            'intelligence' => [
                'knowledge_base' => $pdo->query("SELECT COUNT(*) FROM admin.knowledge_base")->fetchColumn(),
                'brain_winners' => $pdo->query("SELECT COUNT(*) FROM admin.brain_winners")->fetchColumn()
            ],
            'performance' => [
                'top_isps' => $pdo->query("SELECT isp_target, inbox_rate FROM admin.brain_winners ORDER BY inbox_rate DESC LIMIT 5")->fetchAll(PDO::FETCH_ASSOC),
                'campaigns_completed' => $pdo->query("SELECT COUNT(*) FROM admin.campaigns WHERE status = 'completed'")->fetchColumn()
            ]
        ];
        echo json_encode($data);
        break;
    case 'campaigns':
        $campaigns = $pdo->query("SELECT id, name, status, created_at FROM admin.campaigns ORDER BY id DESC LIMIT 20")->fetchAll(PDO::FETCH_ASSOC);
        echo json_encode(['campaigns' => $campaigns]);
        break;
    case 'winners':
        $winners = $pdo->query("SELECT * FROM admin.brain_winners ORDER BY inbox_rate DESC")->fetchAll(PDO::FETCH_ASSOC);
        echo json_encode(['winners' => $winners]);
        break;
    default:
        echo json_encode(['name' => 'Unified Dashboard API', 'actions' => ['overview', 'full', 'campaigns', 'winners']]);
}