Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
ads.php	15.26 KB	-rw-r--r--	2025-10-18 22:42
dashboard.php	22.01 KB	-rw-r--r--	2025-10-18 22:49
deposit_history.php	4.14 KB	-rw-r--r--	2025-10-18 21:52
deposit_methods.php	11.74 KB	-rw-r--r--	2025-10-18 21:52
deposits.php	12.91 KB	-rw-r--r--	2025-10-18 21:52
dpin_details.php	4.52 KB	-rw-r--r--	2025-10-18 22:26
dpin_management.php	10.04 KB	-rw-r--r--	2025-10-18 21:52
dpin_send.php	6 KB	-rw-r--r--	2025-10-18 22:26
footer.php	148 B	-rw-r--r--	2025-10-18 21:50
header.php	8.2 KB	-rw-r--r--	2025-10-18 22:54
login.php	6.11 KB	-rw-r--r--	2025-10-18 21:41
logout.php	88 B	-rw-r--r--	2025-10-18 21:42
notifications.php	9.34 KB	-rw-r--r--	2025-10-18 21:54
plans.php	15.64 KB	-rw-r--r--	2025-10-18 22:42
referral.php	9.89 KB	-rw-r--r--	2025-10-18 21:52
sidebar.php	5.11 KB	-rw-r--r--	2025-10-18 21:50
transactions.php	4.47 KB	-rw-r--r--	2025-10-18 21:53
users.php	12.66 KB	-rw-r--r--	2025-10-18 22:42
withdraw_history.php	4.2 KB	-rw-r--r--	2025-10-18 21:53
withdraw_methods.php	11.89 KB	-rw-r--r--	2025-10-18 21:53
withdrawals.php	13.4 KB	-rw-r--r--	2025-10-18 21:53

Rename

<?php
require_once '../config.php';

// Check if admin is logged in
if (!isset($_SESSION['admin_id'])) {
    header("Location: login.php");
    exit();
}

// Handle notification sending
if (isset($_POST['send_notification'])) {
    $user_id = intval($_POST['user_id']);
    $message = sanitize_input($_POST['message']);
    $type = sanitize_input($_POST['type']);
    
    if ($user_id == 0) {
        // Send to all users
        $stmt = $conn->prepare("SELECT id FROM users");
        $stmt->execute();
        $users_result = $stmt->get_result();
        
        $conn->begin_transaction();
        try {
            while ($user = $users_result->fetch_assoc()) {
                $stmt = $conn->prepare("INSERT INTO notifications (user_id, message, type) VALUES (?, ?, ?)");
                $stmt->bind_param("iss", $user['id'], $message, $type);
                $stmt->execute();
            }
            $conn->commit();
            
            header("Location: notifications.php?success=sent_all");
            exit();
        } catch (Exception $e) {
            $conn->rollback();
            header("Location: notifications.php?error=send_failed");
            exit();
        }
    } else {
        // Send to specific user
        $stmt = $conn->prepare("INSERT INTO notifications (user_id, message, type) VALUES (?, ?, ?)");
        $stmt->bind_param("iss", $user_id, $message, $type);
        
        if ($stmt->execute()) {
            header("Location: notifications.php?success=sent");
            exit();
        } else {
            header("Location: notifications.php?error=send_failed");
            exit();
        }
    }
}

// Get all users for dropdown
$stmt = $conn->prepare("SELECT id, name, email FROM users ORDER BY name ASC");
$stmt->execute();
$users_result = $stmt->get_result();
$users = [];
while ($row = $users_result->fetch_assoc()) {
    $users[] = $row;
}

// Get recent notifications
$stmt = $conn->prepare("SELECT n.*, u.name as user_name FROM notifications n LEFT JOIN users u ON n.user_id = u.id ORDER BY n.created_at DESC LIMIT 50");
$stmt->execute();
$notifications_result = $stmt->get_result();
$notifications = [];
while ($row = $notifications_result->fetch_assoc()) {
    $notifications[] = $row;
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Notifications - Admin Panel</title>
    <?php include 'header.php'; ?>
</head>
<body>
    <div class="container-fluid">
        <div class="row">
            <?php include 'sidebar.php'; ?>
            
            <main class="col-md-9 ms-sm-auto col-lg-10 main-content">
                <div class="d-flex justify-content-between flex-wrap flex-md-nowrap align-items-center pt-3 pb-2 mb-3 border-bottom">
                    <h1 class="h2">Notifications</h1>
                </div>
                
                <?php if (isset($_GET['success']) && $_GET['success'] == 'sent'): ?>
                    <div class="alert alert-success">Notification sent successfully.</div>
                <?php endif; ?>
                
                <?php if (isset($_GET['success']) && $_GET['success'] == 'sent_all'): ?>
                    <div class="alert alert-success">Notification sent to all users successfully.</div>
                <?php endif; ?>
                
                <?php if (isset($_GET['error']) && $_GET['error'] == 'send_failed'): ?>
                    <div class="alert alert-danger">Failed to send notification.</div>
                <?php endif; ?>
                
                <div class="row">
                    <div class="col-md-6">
                        <div class="card">
                            <div class="card-header">
                                <h5 class="mb-0">Send Notification</h5>
                            </div>
                            <div class="card-body">
                                <form method="POST">
                                    <div class="mb-3">
                                        <label class="form-label">Recipient</label>
                                        <select class="form-select" name="user_id" required>
                                            <option value="0">All Users</option>
                                            <?php foreach ($users as $user): ?>
                                                <option value="<?php echo $user['id']; ?>">
                                                    <?php echo htmlspecialchars($user['name']); ?> (<?php echo htmlspecialchars($user['email']); ?>)
                                                </option>
                                            <?php endforeach; ?>
                                        </select>
                                    </div>
                                    
                                    <div class="mb-3">
                                        <label class="form-label">Type</label>
                                        <select class="form-select" name="type" required>
                                            <option value="info">Info</option>
                                            <option value="success">Success</option>
                                            <option value="warning">Warning</option>
                                            <option value="error">Error</option>
                                        </select>
                                    </div>
                                    
                                    <div class="mb-3">
                                        <label class="form-label">Message</label>
                                        <textarea class="form-control" name="message" rows="4" required></textarea>
                                    </div>
                                    
                                    <button type="submit" name="send_notification" class="btn btn-primary">Send Notification</button>
                                </form>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-md-6">
                        <div class="card">
                            <div class="card-header">
                                <h5 class="mb-0">Recent Notifications</h5>
                            </div>
                            <div class="card-body">
                                <?php if (empty($notifications)): ?>
                                    <div class="text-center py-3">
                                        <p class="mb-0">No notifications sent yet.</p>
                                    </div>
                                <?php else: ?>
                                    <div class="list-group">
                                        <?php foreach ($notifications as $notification): ?>
                                            <div class="list-group-item">
                                                <div class="d-flex justify-content-between">
                                                    <h6 class="mb-1">
                                                        <?php 
                                                        $icon = 'info-circle';
                                                        if ($notification['type'] == 'success') $icon = 'check-circle';
                                                        if ($notification['type'] == 'warning') $icon = 'exclamation-triangle';
                                                        if ($notification['type'] == 'error') $icon = 'exclamation-circle';
                                                        ?>
                                                        <i class="fas fa-<?php echo $icon; ?> me-2 text-<?php echo $notification['type']; ?>"></i>
                                                        <?php echo htmlspecialchars($notification['message']); ?>
                                                    </h6>
                                                    <small class="text-muted">
                                                        <?php echo date('M d, Y H:i', strtotime($notification['created_at'])); ?>
                                                    </small>
                                                </div>
                                                <small class="text-muted">
                                                    <?php if ($notification['user_name']): ?>
                                                        To: <?php echo htmlspecialchars($notification['user_name']); ?>
                                                    <?php else: ?>
                                                        To: All Users
                                                    <?php endif; ?>
                                                </small>
                                            </div>
                                        <?php endforeach; ?>
                                    </div>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>
                </div>
            </main>
        </div>
    </div>
    
    <?php include 'footer.php'; ?>
</body>
</html>