$id]); header('Location: email-queue.php?msg=requeued'); exit; } if ($do === 'cancel' && $id) { db_exec("UPDATE email_queue SET status='cancelled' WHERE id=:id AND status IN ('pending','failed')", ['id'=>$id]); header('Location: email-queue.php?msg=cancelled'); exit; } if ($do === 'process_now') { $r = email_process_queue(20); header('Location: email-queue.php?msg=processed&sent='.$r['sent'].'&failed='.$r['failed']); exit; } } $status_filter = $_GET['status'] ?? ''; $where = ''; $params = []; if (in_array($status_filter, ['pending','sending','sent','failed','cancelled'], true)) { $where = 'WHERE status=:s'; $params['s'] = $status_filter; } $jobs = db_all("SELECT * FROM email_queue $where ORDER BY scheduled_at DESC, id DESC LIMIT 200", $params); $counts = []; foreach (db_all("SELECT status, COUNT(*) AS c FROM email_queue GROUP BY status") as $r) { $counts[$r['status']] = (int)$r['c']; } $page_title = 'Email Queue'; require __DIR__ . '/_guard.php'; ?>

Email Queue

Pending and recent send jobs. Cron processes 20 every minute.

Templates Log

'Job re-queued — will be picked up on next cron run.', 'cancelled'=> 'Job cancelled.', 'processed'=> 'Processed: '.((int)($_GET['sent']??0)).' sent, '.((int)($_GET['failed']??0)).' failed.', ]; $m = $msgs[$_GET['msg']] ?? ''; if ($m): ?>

All

No queued jobs.

When	Template	To	Status	Attempts	Last error
				/