PDO::ERRMODE_EXCEPTION,PDO::ATTR_DEFAULT_FETCH_MODE=>PDO::FETCH_ASSOC]);$_db->exec("SET search_path TO admin,public");
$_total=(int)$_db->query("SELECT COUNT(*) FROM send_capacity")->fetchColumn();
$_cols=$_db->query("SELECT column_name FROM information_schema.columns WHERE table_schema='admin' AND table_name='send_capacity' ORDER BY ordinal_position")->fetchAll(PDO::FETCH_COLUMN);
$_warmup=(int)$_db->query("SELECT COUNT(*) FROM warmup_accounts WHERE status='warming'")->fetchColumn();
$_cap=$_warmup*50;
$_sent_today=(int)$_db->query("SELECT COUNT(*) FROM unified_send_log WHERE created_at > CURRENT_DATE")->fetchColumn();
$_sent_week=(int)$_db->query("SELECT COUNT(*) FROM unified_send_log WHERE created_at > CURRENT_DATE - INTERVAL '7 days'")->fetchColumn();
$_bc=(int)$_db->query("SELECT COUNT(*) FROM brain_send_configs WHERE status='active'")->fetchColumn();
$_bw=(int)$_db->query("SELECT COUNT(*) FROM brain_send_configs WHERE is_winner=true")->fetchColumn();
// Try to get ISP breakdown from send_capacity
$_by_isp=[];
try{
if(in_array('isp',$_cols)&&in_array('capacity',$_cols)){
$_by_isp=$_db->query("SELECT isp,SUM(capacity) as cap,COUNT(*) as cnt FROM send_capacity GROUP BY isp ORDER BY cap DESC LIMIT 15")->fetchAll();
}elseif(in_array('isp_target',$_cols)){
$_by_isp=$_db->query("SELECT isp_target as isp,COUNT(*) as cnt,0 as cap FROM send_capacity GROUP BY isp_target ORDER BY cnt DESC LIMIT 15")->fetchAll();
}else{
$_by_isp=$_db->query("SELECT * FROM send_capacity ORDER BY id DESC LIMIT 20")->fetchAll();
}
}catch(Exception $e){$_by_isp=[];}
// Also get brain_send_configs by ISP
$_cfg_isp=$_db->query("SELECT isp_target,COUNT(*) as cnt,SUM(CASE WHEN is_winner THEN 1 ELSE 0 END) as winners,COALESCE(AVG(inbox_rate),0) as avg_inbox FROM brain_send_configs WHERE status='active' GROUP BY isp_target ORDER BY cnt DESC LIMIT 15")->fetchAll();
?>
WEVADS - Send Capacity Dashboard