query("SELECT isp, COUNT(*) as c FROM send_contacts WHERE status='active' GROUP BY isp ORDER BY COUNT(*) DESC")->fetchAll(PDO::FETCH_ASSOC); // Brain par ISP $_brain_isp = $_mdb->query("SELECT isp_target as isp, COUNT(*) as configs, SUM(CASE WHEN is_winner THEN 1 ELSE 0 END) as winners, ROUND(AVG(inbox_rate),1) as avg_inbox, SUM(total_sent) as sent FROM brain_configs WHERE is_active=true GROUP BY isp_target ORDER BY COUNT(*) DESC")->fetchAll(PDO::FETCH_ASSOC); $_brain_map = []; foreach($_brain_isp as $b) $_brain_map[strtolower($b['isp'])] = $b; // Filters $_filters = $_mdb->query("SELECT isp_name, filter_name, filter_type, severity, bypass_method FROM isp_filters ORDER BY isp_name, severity DESC")->fetchAll(PDO::FETCH_ASSOC); $_filter_map = []; foreach($_filters as $f) $_filter_map[strtolower($f['isp_name'])][] = $f; // Methods $_methods = $_mdb->query("SELECT isp_name, country, domains, method, uses_office, uses_gsuite, uses_smtp_direct, max_daily_ip, delay_seconds, notes FROM isp_methods ORDER BY isp_name")->fetchAll(PDO::FETCH_ASSOC); $_method_map = []; foreach($_methods as $m) $_method_map[strtolower($m['isp_name'])] = $m; // Sends par ISP $_sends_isp = $_mdb->query("SELECT recipient_isp as isp, COUNT(*) as sent, SUM(CASE WHEN status='sent' THEN 1 ELSE 0 END) as ok FROM graph_send_log GROUP BY recipient_isp ORDER BY COUNT(*) DESC")->fetchAll(PDO::FETCH_ASSOC); $_sends_map = []; foreach($_sends_isp as $s) $_sends_map[strtolower($s['isp'])] = $s; $_total_contacts = array_sum(array_column($_isps, 'c')); ?>
| Pays | =$method['country']?> | Méthode | =$method['method']?> |
| Domaines | =str_replace(['{','}'],'',$method['domains'])?> | ||
| Max/jour/IP | =number_format($method['max_daily_ip'])?> | Délai | =$method['delay_seconds']?>s |
| O365 | =$method['uses_office']=='t'?'✅':'❌'?> | GSuite | =$method['uses_gsuite']=='t'?'✅':'❌'?> |