prepare( "INSERT INTO notifications (user_id, type, title, message, is_active) VALUES (NULL, ?, ?, ?, 1)" ); $stmt->bind_param('sss', $type, $title, $message); } else { $stmt = $conn->prepare( "INSERT INTO notifications (user_id, type, title, message, is_active) VALUES (?, ?, ?, ?, 1)" ); $stmt->bind_param('isss', $target_uid, $type, $title, $message); } $success = $stmt->execute() ? 'Notification sent successfully!' : 'Failed to send notification.'; } } if (isset($_POST['deactivate']) && is_numeric($_POST['notif_id'])) { $nid = (int)$_POST['notif_id']; $conn->query("UPDATE notifications SET is_active = 0 WHERE id = {$nid}"); $success = 'Notification deactivated.'; } if (isset($_POST['activate']) && is_numeric($_POST['notif_id'])) { $nid = (int)$_POST['notif_id']; $conn->query("UPDATE notifications SET is_active = 1 WHERE id = {$nid}"); $success = 'Notification activated.'; } if (isset($_POST['delete_notif']) && is_numeric($_POST['notif_id'])) { $nid = (int)$_POST['notif_id']; $conn->query("DELETE FROM notifications WHERE id = {$nid}"); $success = 'Notification deleted.'; } /* ══════════════════════════════════════════════════════════════ FETCH DATA ══════════════════════════════════════════════════════════════ */ $filter = isset($_GET['filter']) && $_GET['filter'] === 'inactive' ? 0 : 1; $filter_label = $filter ? 'Active' : 'Inactive'; $rows = $conn->query( "SELECT n.id, n.user_id, n.type, n.title, n.message, n.is_active, n.created_at, u.username, u.email FROM notifications n LEFT JOIN users u ON n.user_id = u.id WHERE n.is_active = {$filter} ORDER BY n.created_at DESC LIMIT 100" ); $stats = $conn->query( "SELECT COUNT(*) AS total, SUM(is_active = 1) AS active_count, SUM(is_active = 0) AS inactive_count, SUM(user_id IS NULL) AS broadcasts FROM notifications" )->fetch_assoc(); $user_list = $conn->query( "SELECT id, username, email FROM users ORDER BY username ASC LIMIT 200" ); /* ── SVG icon definitions ── */ $svg_bell = ''; $svg_send = ''; $svg_users = ''; $svg_user = ''; $svg_pause = ''; $svg_play = ''; $svg_trash = ''; $svg_check = ''; $svg_minus = ''; $type_svgs = [ 'info' => '', 'success' => '', 'warning' => '', 'failed' => '', 'pending' => '', 'deposit' => '', ]; $type_colors = [ 'info' => '#6366f1', 'success' => '#22c55e', 'warning' => '#f59e0b', 'failed' => '#ef4444', 'pending' => '#94a3b8', 'deposit' => '#f97316', ]; include '../includes/header.php'; ?>

Notifications

Create and manage system notifications for users

'Total', 'val' => number_format($stats['total']), 'color' => '#6366f1', 'icon' => '', ], [ 'label' => 'Active', 'val' => number_format($stats['active_count']), 'color' => '#22c55e', 'icon' => '', ], [ 'label' => 'Inactive', 'val' => number_format($stats['inactive_count']), 'color' => '#94a3b8', 'icon' => '', ], [ 'label' => 'Broadcasts', 'val' => number_format($stats['broadcasts']), 'color' => '#f97316', 'icon' => '', ], ]; foreach ($stat_cards as $sc): ?>

Send Notification

Max 500 characters
Preview title
Your message will appear here...
info

Notification Log

Active Inactive
num_rows > 0): while ($n = $rows->fetch_assoc()): $tc = $type_colors[$n['type']] ?? '#6366f1'; $ti = $type_svgs[$n['type']] ?? $type_svgs['info']; $is_broadcast = $n['user_id'] === null; ?>
Title / Message Type Target Sent Actions
60 ? '…' : '') ?>
All Users
#
No notifications found.