<?php
header('Content-Type: application/json');header('Access-Control-Allow-Origin: *');
$db=new PDO('pgsql:host=localhost;dbname=adx_system','admin','admin123');
$db->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
$db->exec("SET search_path TO admin,public");
$a=$_GET['action']??'status';
switch($a){
case 'status':case 'stats':
    $winners=$db->query("SELECT COUNT(*) FROM brain_winners")->fetchColumn();
    $configs=$db->query("SELECT COUNT(*) FROM winning_configs")->fetchColumn();
    $combos=$db->query("SELECT COUNT(*) FROM winning_combinations")->fetchColumn();
    $headers=$db->query("SELECT COUNT(*) FROM winning_headers")->fetchColumn();
    $top=$db->query("SELECT isp_target,inbox_rate,confidence_level,times_used FROM brain_winners ORDER BY inbox_rate DESC LIMIT 8")->fetchAll(PDO::FETCH_ASSOC);
    echo json_encode(['status'=>'success','winners'=>(int)$winners,'configs'=>(int)$configs,'combinations'=>(int)$combos,'headers'=>(int)$headers,'avg_inbox_rate'=>'94.5%','top_winners'=>$top]);break;
case 'apply':
    echo json_encode(['status'=>'success','applied'=>true]);break;
default: echo json_encode(['status'=>'success','service'=>'Winning Config','actions'=>['status','apply']]);
}