prepare("
UPDATE smod_requests
SET
status=?,
reply=?
WHERE id=?
");
$stmt->bind_param("ssi", $status, $reply, $id);
if ($stmt->execute()) {
$msg = "
Request Updated Successfully
";
} else {
$msg = "
Failed To Update Request
";
}
}
/* ================= TODAY STATS ================= */
$today = date('Y-m-d');
$todayQuery = $conn->query("
SELECT
COUNT(*) as total_count,
SUM(amount) as total_spent
FROM smod_requests
WHERE DATE(created_at) = '$today'
");
$todayData = $todayQuery->fetch_assoc();
$todayCount = $todayData['total_count'] ?? 0;
$todaySpent = $todayData['total_spent'] ?? 0;
/* ================= WEEKLY STATS ================= */
$weekQuery = $conn->query("
SELECT
COUNT(*) as total_count,
SUM(amount) as total_spent
FROM smod_requests
WHERE YEARWEEK(created_at, 1) = YEARWEEK(CURDATE(), 1)
");
$weekData = $weekQuery->fetch_assoc();
$weekCount = $weekData['total_count'] ?? 0;
$weekSpent = $weekData['total_spent'] ?? 0;
/* ================= MONTHLY STATS ================= */
$monthQuery = $conn->query("
SELECT
COUNT(*) as total_count,
SUM(amount) as total_spent
FROM smod_requests
WHERE MONTH(created_at)=MONTH(CURDATE())
AND YEAR(created_at)=YEAR(CURDATE())
");
$monthData = $monthQuery->fetch_assoc();
$monthCount = $monthData['total_count'] ?? 0;
$monthSpent = $monthData['total_spent'] ?? 0;
/* ================= FETCH REQUESTS ================= */
$get = $conn->query("
SELECT *
FROM smod_requests
ORDER BY id DESC
");
?>
ASO VERIFY - Admin Panel
ASO VERIFY
Second Time Modification Admin Panel
Today Statistics
Today Count
Today Spent
₦
Weekly Statistics
Weekly Count
Weekly Spent
₦
Monthly Statistics
Monthly Count
Monthly Spent
₦
num_rows > 0): ?>
| ID |
User |
NIN |
Type |
Price |
Status |
Reply |
Date |
Update |
fetch_assoc()): ?>
|
#
|
|
|
|
₦
|
|
|
|
|
No Requests Found