query(" SELECT COUNT(*) as total, SUM(CASE WHEN current_status = 'pending' THEN 1 ELSE 0 END) as pending, SUM(CASE WHEN current_status = 'in_progress' THEN 1 ELSE 0 END) as processing, SUM(CASE WHEN current_status = 'completed' THEN 1 ELSE 0 END) as completed FROM replacement_requests ")->fetch(); require_once 'includes/header.php'; ?>

Admin Dashboard

Pending
In Progress
Completed
Total Requests

Recent Requests

query(" SELECT r.*, u.business_name as reseller_name FROM replacement_requests r JOIN users u ON r.user_id = u.id ORDER BY r.created_at DESC LIMIT 5 "); while ($row = $stmt->fetch()) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } ?>
ID Reseller Customer Plan Status Date
#{$row['id']}" . htmlspecialchars($row['reseller_name']) . "" . htmlspecialchars($row['customer_name']) . "" . htmlspecialchars($row['adobe_plan']) . "{$row['current_status']}" . date('d M', strtotime($row['created_at'])) . "