setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// Stats
$stats = [
'total_accounts' => $pdo->query("SELECT COUNT(*) FROM admin.office_accounts")->fetchColumn(),
'warmup_active' => $pdo->query("SELECT COUNT(*) FROM admin.email_warmup WHERE status IS NOT NULL")->fetchColumn(),
'warmup_total' => $pdo->query("SELECT COUNT(*) FROM admin.email_warmup")->fetchColumn(),
];
// Ajouter compte au warmup
$msg = '';
if ($_POST && isset($_POST['add_warmup'])) {
$email = $_POST['email'] ?? '';
$daily = intval($_POST['daily_target'] ?? 50);
if ($email) {
$stmt = $pdo->prepare("INSERT INTO admin.email_warmup (email, account_type, daily_target, current_day, emails_sent_today, total_sent, status, created_at) VALUES (?, 'office365', ?, 1, 0, 0, 'active', NOW()) ON CONFLICT DO NOTHING");
$stmt->execute([$email, $daily]);
$msg = "✅ Compte ajouté au warmup!";
}
}
// Liste warmup
$warmupList = $pdo->query("SELECT * FROM admin.email_warmup ORDER BY id DESC LIMIT 20")->fetchAll(PDO::FETCH_ASSOC);
// Liste comptes Office disponibles
$officeAccounts = $pdo->query("SELECT id, admin_email, tenant_domain, status FROM admin.office_accounts WHERE status IS NOT NULL ORDER BY id DESC LIMIT 50")->fetchAll(PDO::FETCH_ASSOC);
?>
Warmup Dashboard - WEVAL