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

switch($action) {
    case 'daily_stats':
        $o365 = $pdo->query("SELECT status, COUNT(*) as cnt FROM admin.office_accounts GROUP BY status")->fetchAll(PDO::FETCH_KEY_PAIR);
        $campaigns = $pdo->query("SELECT COUNT(*) as total, SUM(total_sent) as sent, SUM(total_opens) as opens, SUM(total_clicks) as clicks FROM admin.campaigns")->fetch(PDO::FETCH_ASSOC);
        $seeds = $pdo->query("SELECT COUNT(*) FROM admin.brain_seeds WHERE is_active=true")->fetchColumn();
        echo json_encode([
            'success'=>true,
            'date'=>date('Y-m-d'),
            'o365'=>$o365,
            'campaigns'=>$campaigns,
            'active_seeds'=>$seeds
        ]);
        break;
    default:
        echo json_encode(['success'=>false, 'error'=>'Unknown action']);
}