exec("SET search_path TO admin");
$_total=(int)$_db->query("SELECT COUNT(*) FROM brain_send_configs")->fetchColumn();
$_tested=(int)$_db->query("SELECT COUNT(*) FROM brain_send_configs WHERE total_sent>0")->fetchColumn();
$_avgInbox=$_db->query("SELECT ROUND(AVG(NULLIF(inbox_rate,0))::numeric,1) FROM brain_send_configs WHERE total_sent>0")->fetchColumn() ?: 0;
$_totalSent=(int)$_db->query("SELECT COALESCE(SUM(total_sent),0) FROM brain_send_configs")->fetchColumn();
$_totalInbox=(int)$_db->query("SELECT COALESCE(SUM(total_inbox),0) FROM brain_send_configs")->fetchColumn();
// Get unique methods and ISPs
$_methodList=$_db->query("SELECT DISTINCT send_method FROM brain_send_configs WHERE send_method IS NOT NULL ORDER BY send_method")->fetchAll(PDO::FETCH_COLUMN);
$_ispList=$_db->query("SELECT DISTINCT isp_target FROM brain_send_configs WHERE isp_target IS NOT NULL AND isp_target!='' ORDER BY isp_target")->fetchAll(PDO::FETCH_COLUMN);
// Matrix data: method x isp -> avg inbox rate
$_matrix=$_db->query("SELECT send_method, isp_target, ROUND(AVG(NULLIF(inbox_rate,0))::numeric,1) as avg_inbox, COUNT(*) as cnt, SUM(total_sent) as total_sent FROM brain_send_configs WHERE isp_target IS NOT NULL AND isp_target!='' GROUP BY send_method, isp_target ORDER BY send_method, isp_target")->fetchAll(PDO::FETCH_ASSOC);
// Build matrix lookup
$_matrixMap=[];
foreach($_matrix as $m) $_matrixMap[$m['send_method']][$m['isp_target']]=['inbox'=>$m['avg_inbox'],'cnt'=>$m['cnt'],'sent'=>$m['total_sent']];
// Best combos
$_bestCombos=$_db->query("SELECT send_method, isp_target, inbox_rate, total_sent, from_domain, status FROM brain_send_configs WHERE total_sent>0 AND inbox_rate>0 ORDER BY inbox_rate DESC LIMIT 10")->fetchAll(PDO::FETCH_ASSOC);
// Worst combos
$_worstCombos=$_db->query("SELECT send_method, isp_target, inbox_rate, total_sent, from_domain FROM brain_send_configs WHERE total_sent>0 AND inbox_rate>0 ORDER BY inbox_rate ASC LIMIT 5")->fetchAll(PDO::FETCH_ASSOC);
?>