connect_error) { die("DB Error"); } $conn->set_charset("utf8mb4"); /* HELPERS */ function h($v){ return htmlspecialchars((string)($v ?? ''), ENT_QUOTES, 'UTF-8'); } function naira($v){ return number_format((float)($v ?? 0), 2); } function isAjaxRequest(): bool { return isset($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) === 'xmlhttprequest'; } function getStatusBadgeHtml(string $status): string { $s = strtolower(trim($status)); if ($s === 'successful') { return "Successful"; } elseif ($s === 'failed') { return "Failed"; } elseif ($s === 'processing') { return "Processing"; } elseif ($s === 'in progress') { return "In Progress"; } else { return "Pending"; } } function getRefundHtml(array $row): string { $id = (int)($row['id'] ?? 0); $status = strtolower((string)($row['status'] ?? '')); $refunded = (int)($row['refunded'] ?? 0); if ($refunded === 1) { return 'Refunded 80%'; } if ($status === 'failed') { return '
'; } return '-'; } /* STATUS LIST */ $allowedStatuses = [ 'Pending', 'In Progress', 'Processing', 'Successful', 'Failed' ]; /* UPDATE */ if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['update'])) { $id = (int)($_POST['id'] ?? 0); $status = trim((string)($_POST['status'] ?? 'Pending')); $reply = trim((string)($_POST['reply'] ?? '')); if (!in_array($status, $allowedStatuses, true)) { $status = 'Pending'; } $stmt = $conn->prepare("UPDATE validation_requests SET status=?, reply=? WHERE id=?"); $stmt->bind_param("ssi", $status, $reply, $id); $ok = $stmt->execute(); $stmt->close(); if (isAjaxRequest()) { $row = null; $q = $conn->prepare("SELECT id, status, refunded FROM validation_requests WHERE id=? LIMIT 1"); $q->bind_param("i", $id); $q->execute(); $row = $q->get_result()->fetch_assoc(); $q->close(); header('Content-Type: application/json'); echo json_encode([ 'success' => $ok, 'message' => $ok ? 'Request updated successfully.' : 'Update failed.', 'status' => $status, 'status_badge' => getStatusBadgeHtml($status), 'refund_html' => $row ? getRefundHtml($row) : '-', 'reply' => $reply ]); exit; } header("Location: " . $_SERVER['PHP_SELF']); exit; } /* REFUND - 80% */ if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['refund'])) { $id = (int)($_POST['id'] ?? 0); $q = $conn->prepare("SELECT id, user, price, status, refunded FROM validation_requests WHERE id=? LIMIT 1"); $q->bind_param("i", $id); $q->execute(); $row = $q->get_result()->fetch_assoc(); $q->close(); $success = false; $message = 'Refund could not be processed.'; if ($row && strtolower((string)$row['status']) === 'failed' && (int)$row['refunded'] === 0) { $user = (string)$row['user']; $price = (float)$row['price']; $statusBeforeRefund = (string)$row['status']; $refundPercent = 80.00; $refundAmount = round($price * 0.80, 2); $note = '80% refund for failed validation request'; $conn->begin_transaction(); try { $bal = $conn->prepare("UPDATE balance SET amount = amount + ? WHERE user = ?"); $bal->bind_param("ds", $refundAmount, $user); $bal->execute(); $bal->close(); $upd = $conn->prepare("UPDATE validation_requests SET refunded = 1 WHERE id = ?"); $upd->bind_param("i", $id); $upd->execute(); $upd->close(); $ins = $conn->prepare(" INSERT INTO refund_transactions (validation_request_id, user, original_amount, refund_percent, refund_amount, request_status, note) VALUES (?, ?, ?, ?, ?, ?, ?) "); $ins->bind_param( "isdddss", $id, $user, $price, $refundPercent, $refundAmount, $statusBeforeRefund, $note ); $ins->execute(); $ins->close(); $conn->commit(); $success = true; $message = 'Refund processed successfully.'; } catch (Throwable $e) { $conn->rollback(); $success = false; $message = 'Refund failed.'; } } if (isAjaxRequest()) { header('Content-Type: application/json'); echo json_encode([ 'success' => $success, 'message' => $message, 'refund_html' => $success ? 'Refunded 80%' : (isset($row) && $row ? getRefundHtml($row) : '-') ]); exit; } header("Location: " . $_SERVER['PHP_SELF']); exit; } /* FETCH */ $res = $conn->query("SELECT * FROM validation_requests ORDER BY id DESC"); /* STATS */ $stats = [ 'today' => ['count' => 0, 'spent' => 0], 'week' => ['count' => 0, 'spent' => 0], 'month' => ['count' => 0, 'spent' => 0], 'total' => ['count' => 0, 'spent' => 0], ]; $statsSql = " SELECT SUM(CASE WHEN DATE(created_at) = CURDATE() THEN 1 ELSE 0 END) AS today_count, SUM(CASE WHEN DATE(created_at) = CURDATE() THEN price ELSE 0 END) AS today_spent, SUM(CASE WHEN YEARWEEK(created_at, 1) = YEARWEEK(CURDATE(), 1) THEN 1 ELSE 0 END) AS week_count, SUM(CASE WHEN YEARWEEK(created_at, 1) = YEARWEEK(CURDATE(), 1) THEN price ELSE 0 END) AS week_spent, SUM(CASE WHEN YEAR(created_at) = YEAR(CURDATE()) AND MONTH(created_at) = MONTH(CURDATE()) THEN 1 ELSE 0 END) AS month_count, SUM(CASE WHEN YEAR(created_at) = YEAR(CURDATE()) AND MONTH(created_at) = MONTH(CURDATE()) THEN price ELSE 0 END) AS month_spent, COUNT(*) AS total_count, SUM(price) AS total_spent FROM validation_requests "; $statsRes = $conn->query($statsSql); if ($statsRes instanceof mysqli_result) { $s = $statsRes->fetch_assoc(); if ($s) { $stats['today']['count'] = (int)($s['today_count'] ?? 0); $stats['today']['spent'] = (float)($s['today_spent'] ?? 0); $stats['week']['count'] = (int)($s['week_count'] ?? 0); $stats['week']['spent'] = (float)($s['week_spent'] ?? 0); $stats['month']['count'] = (int)($s['month_count'] ?? 0); $stats['month']['spent'] = (float)($s['month_spent'] ?? 0); $stats['total']['count'] = (int)($s['total_count'] ?? 0); $stats['total']['spent'] = (float)($s['total_spent'] ?? 0); } } ?> Validation Admin

📋 Validation Dashboard

Today
Today Count:
Today Spent: ₦
Weekly
Weekly Count:
Weekly Spent: ₦
Monthly
Monthly Count:
Monthly Spent: ₦
Total
Total Count:
Total Spent: ₦
fetch_assoc()): ?>
User NIN Price Status Refund Action
₦