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 === 'processing') {
return "Processing";
} elseif ($s === 'in progress') {
return "In Progress";
} else {
return "Pending";
}
}
function getDashboardStats(mysqli $conn): array {
$stats = [
'pending' => 0,
'in_progress' => 0,
'processing' => 0
];
$sql = "
SELECT
SUM(CASE WHEN LOWER(TRIM(status)) = 'pending' THEN 1 ELSE 0 END) AS pending_count,
SUM(CASE WHEN LOWER(TRIM(status)) = 'in progress' THEN 1 ELSE 0 END) AS in_progress_count,
SUM(CASE WHEN LOWER(TRIM(status)) = 'processing' THEN 1 ELSE 0 END) AS processing_count
FROM validation_requests
";
$res = $conn->query($sql);
if ($res instanceof mysqli_result) {
$row = $res->fetch_assoc();
if ($row) {
$stats['pending'] = (int)($row['pending_count'] ?? 0);
$stats['in_progress'] = (int)($row['in_progress_count'] ?? 0);
$stats['processing'] = (int)($row['processing_count'] ?? 0);
}
}
return $stats;
}
function renderStatsCards(array $stats): string {
ob_start();
?>
prepare($sql);
$stmt->bind_param("s", $like);
$stmt->execute();
$res = $stmt->get_result();
if ($res instanceof mysqli_result) {
while ($row = $res->fetch_assoc()) {
$rows[] = $row;
}
}
$stmt->close();
} else {
$sql = "SELECT * FROM validation_requests
WHERE $statusFilter
ORDER BY id DESC";
$res = $conn->query($sql);
if ($res instanceof mysqli_result) {
while ($row = $res->fetch_assoc()) {
$rows[] = $row;
}
}
}
return $rows;
}
function renderSearchInfo(string $searchNin, int $count): string {
if ($searchNin === '') {
return '';
}
return '
Showing ' . $count . ' result(s) for NIN:
' . h($searchNin) . '
';
}
function renderTableRows(array $rows, string $searchNin = ''): string {
ob_start();
if (!empty($rows)):
foreach ($rows as $r):
?>
|
|
|
₦ |
|
|
|
No pending, in progress, or processing requests found
|
prepare("UPDATE validation_requests SET status=?, reply=? WHERE id=?");
$stmt->bind_param("ssi", $status, $reply, $id);
$ok = $stmt->execute();
$stmt->close();
if (isAjaxRequest()) {
$stats = getDashboardStats($conn);
header('Content-Type: application/json');
echo json_encode([
'success' => $ok,
'message' => $ok ? 'Request updated successfully.' : 'Update failed.',
'status_badge' => getStatusBadgeHtml($status),
'stats_html' => renderStatsCards($stats)
]);
exit;
}
header("Location: " . $_SERVER['REQUEST_URI']);
exit;
}
/* SEARCH */
$searchNin = trim((string)($_GET['search_nin'] ?? ''));
/* AJAX SEARCH RESPONSE */
if ($_SERVER['REQUEST_METHOD'] === 'GET' && isAjaxRequest()) {
$rows = fetchValidationRows($conn, $searchNin);
header('Content-Type: application/json');
echo json_encode([
'success' => true,
'tbody_html' => renderTableRows($rows, $searchNin),
'search_info_html' => renderSearchInfo($searchNin, count($rows))
]);
exit;
}
/* FETCH */
$rows = fetchValidationRows($conn, $searchNin);
/* STATS */
$stats = getDashboardStats($conn);
?>
Pending / In Progress / Processing
📋 Pending / In Progress / Processing
| User |
NIN |
Type |
Price |
Status |
Action |