<?php
header('Content-Type: application/json');header('Access-Control-Allow-Origin: *');
$db=new PDO('pgsql:host=localhost;dbname=adx_system','admin','admin123');
$db->exec("SET search_path TO admin,public");
$action=$_GET['action']??'status';
switch($action){
case 'status':case 'stats':
    $contacts=$db->query("SELECT COUNT(*) FROM send_contacts")->fetchColumn();
    $offers=$db->query("SELECT COUNT(*) FROM affiliate.offers WHERE status='active'")->fetchColumn();
    $accounts=$db->query("SELECT COUNT(*) FROM o365_accounts")->fetchColumn();
    $personas=$db->query("SELECT COUNT(*) FROM personas")->fetchColumn();
    $ia=$db->query("SELECT COUNT(*) FROM ia_provider_accounts")->fetchColumn();
    echo json_encode(['status'=>'success','contacts'=>(int)$contacts,'offers'=>(int)$offers,'o365_accounts'=>(int)$accounts,'personas'=>(int)$personas,'ia_accounts'=>(int)$ia,'screens'=>count(glob('/opt/wevads-arsenal/public/*.html'))]);break;
default: echo json_encode(['status'=>'success','service'=>'Arsenal Core']);
}