set_charset('utf8mb4'); function h(string $value): string { return htmlspecialchars($value, ENT_QUOTES, 'UTF-8'); } function aso_is_admin(): bool { if (!empty($_SESSION['admin'])) { return true; } $role = strtolower(trim((string)($_SESSION['role'] ?? ''))); return in_array( $role, ['admin', 'superadmin', 'administrator'], true ); } if (!aso_is_admin()) { http_response_code(403); ?> Access Denied

Access Denied

You must be an ASOVERIFY administrator to access this page.

query( "SELECT id FROM aso_agent_settings WHERE id = 1 LIMIT 1" ); if (!$check) { throw new RuntimeException( 'ASOVERIFY Agent tables are missing. Import the supplied Agent SQL first.' ); } $check->free(); } catch (Throwable $e) { http_response_code(500); exit( 'Agent database error: ' . h($e->getMessage()) ); } /* |-------------------------------------------------------------------------- | ACTIONS |-------------------------------------------------------------------------- */ $action = strtolower( trim((string)($_GET['action'] ?? $_POST['action'] ?? '')) ); if ($_SERVER['REQUEST_METHOD'] === 'POST' && $action !== '') { header('Content-Type: application/json; charset=utf-8'); try { /* * SAVE GENERAL SETTINGS */ if ($action === 'save_settings') { $registrationPrice = max( 0, (float)($_POST['registration_price'] ?? 5000) ); $defaultCommission = max( 0, min( 100, (float)($_POST['default_commission_percent'] ?? 5) ) ); $stmt = $conn->prepare( "UPDATE aso_agent_settings SET registration_price = ?, default_commission_percent = ? WHERE id = 1" ); $stmt->bind_param( 'dd', $registrationPrice, $defaultCommission ); $stmt->execute(); $stmt->close(); echo json_encode([ 'success' => true, 'message' => 'Agent settings updated successfully.' ]); exit; } /* * UPDATE ONE AGENT */ if ($action === 'update_agent') { $agentId = (int)($_POST['agent_id'] ?? 0); $commission = max( 0, min( 100, (float)($_POST['commission_percent'] ?? 0) ) ); $rank = strtolower( trim((string)($_POST['agent_rank'] ?? 'default_agent')) ); $status = strtolower( trim((string)($_POST['status'] ?? 'active')) ); if ($agentId <= 0) { throw new RuntimeException('Invalid agent ID.'); } if (!in_array( $rank, ['default_agent', 'super_agent', 'md'], true )) { throw new RuntimeException('Invalid agent rank.'); } if (!in_array( $status, ['active', 'suspended'], true )) { throw new RuntimeException('Invalid agent status.'); } $stmt = $conn->prepare( "UPDATE aso_agents SET agent_rank = ?, commission_percent = ?, status = ? WHERE id = ? LIMIT 1" ); $stmt->bind_param( 'sdsi', $rank, $commission, $status, $agentId ); $stmt->execute(); $stmt->close(); echo json_encode([ 'success' => true, 'message' => 'Agent updated successfully.' ]); exit; } /* * ADD / REMOVE COMMISSION WALLET BALANCE */ if ($action === 'adjust_wallet') { $agentId = (int)($_POST['agent_id'] ?? 0); $amount = (float)($_POST['amount'] ?? 0); $type = strtolower(trim((string)($_POST['type'] ?? 'adjustment'))); $description = trim((string)($_POST['description'] ?? '')); if ($agentId <= 0) { throw new RuntimeException('Invalid agent.'); } if (!in_array($type, ['credit', 'debit'], true)) { throw new RuntimeException('Invalid wallet action.'); } if ($amount <= 0) { throw new RuntimeException('Enter a valid amount.'); } $amount = round($amount, 2); $conn->begin_transaction(); try { $stmt = $conn->prepare( "SELECT amount FROM aso_agent_wallet WHERE agent_id = ? LIMIT 1 FOR UPDATE" ); $stmt->bind_param('i', $agentId); $stmt->execute(); $wallet = $stmt->get_result()->fetch_assoc(); $stmt->close(); if (!$wallet) { $stmt = $conn->prepare( "INSERT INTO aso_agent_wallet (agent_id, amount) VALUES (?, 0)" ); $stmt->bind_param('i', $agentId); $stmt->execute(); $stmt->close(); $balance = 0; } else { $balance = (float)$wallet['amount']; } if ($type === 'debit') { if ($balance < $amount) { throw new RuntimeException( 'Agent commission wallet does not have enough balance.' ); } $stmt = $conn->prepare( "UPDATE aso_agent_wallet SET amount = amount - ? WHERE agent_id = ? LIMIT 1" ); $stmt->bind_param( 'di', $amount, $agentId ); } else { $stmt = $conn->prepare( "UPDATE aso_agent_wallet SET amount = amount + ? WHERE agent_id = ? LIMIT 1" ); $stmt->bind_param( 'di', $amount, $agentId ); } $stmt->execute(); $stmt->close(); $logAmount = $amount; $logDescription = $description !== '' ? $description : ( $type === 'credit' ? 'Admin wallet credit' : 'Admin wallet debit' ); $reference = 'ADMIN-' . strtoupper( bin2hex(random_bytes(5)) ); $stmt = $conn->prepare( "INSERT INTO aso_agent_wallet_logs ( agent_id, type, amount, description, reference ) VALUES ( ?, 'adjustment', ?, ?, ? )" ); $stmt->bind_param( 'idss', $agentId, $logAmount, $logDescription, $reference ); $stmt->execute(); $stmt->close(); $conn->commit(); echo json_encode([ 'success' => true, 'message' => 'Agent commission wallet updated.' ]); exit; } catch (Throwable $e) { $conn->rollback(); throw $e; } } /* * APPROVE / REJECT WITHDRAWAL */ if ($action === 'withdrawal') { $withdrawalId = (int)($_POST['withdrawal_id'] ?? 0); $decision = strtolower( trim((string)($_POST['decision'] ?? '')) ); $adminNote = trim( (string)($_POST['admin_note'] ?? '') ); if ($withdrawalId <= 0) { throw new RuntimeException( 'Invalid withdrawal request.' ); } if (!in_array( $decision, ['approve', 'reject'], true )) { throw new RuntimeException( 'Invalid withdrawal decision.' ); } $conn->begin_transaction(); try { $stmt = $conn->prepare( "SELECT * FROM aso_agent_withdrawals WHERE id = ? LIMIT 1 FOR UPDATE" ); $stmt->bind_param( 'i', $withdrawalId ); $stmt->execute(); $withdrawal = $stmt->get_result()->fetch_assoc(); $stmt->close(); if (!$withdrawal) { throw new RuntimeException( 'Withdrawal request not found.' ); } if ($withdrawal['status'] !== 'pending') { throw new RuntimeException( 'This withdrawal has already been processed.' ); } $agentId = (int)$withdrawal['agent_id']; $amount = round( (float)$withdrawal['amount'], 2 ); if ($decision === 'reject') { $stmt = $conn->prepare( "UPDATE aso_agent_withdrawals SET status = 'rejected', admin_note = ?, processed_at = NOW() WHERE id = ? LIMIT 1" ); $stmt->bind_param( 'si', $adminNote, $withdrawalId ); $stmt->execute(); $stmt->close(); $conn->commit(); echo json_encode([ 'success' => true, 'message' => 'Withdrawal rejected.' ]); exit; } /* * APPROVAL: * Lock wallet and deduct commission. */ $stmt = $conn->prepare( "SELECT amount FROM aso_agent_wallet WHERE agent_id = ? LIMIT 1 FOR UPDATE" ); $stmt->bind_param( 'i', $agentId ); $stmt->execute(); $wallet = $stmt->get_result()->fetch_assoc(); $stmt->close(); $balance = (float)($wallet['amount'] ?? 0); if ($balance < $amount) { throw new RuntimeException( 'Agent commission wallet does not have enough balance.' ); } $stmt = $conn->prepare( "UPDATE aso_agent_wallet SET amount = amount - ? WHERE agent_id = ? AND amount >= ? LIMIT 1" ); $stmt->bind_param( 'did', $amount, $agentId, $amount ); $stmt->execute(); if ($stmt->affected_rows !== 1) { $stmt->close(); throw new RuntimeException( 'Unable to deduct agent commission wallet.' ); } $stmt->close(); $reference = 'AGENT-WD-' . $withdrawalId; $description = 'Approved agent commission withdrawal'; $stmt = $conn->prepare( "INSERT INTO aso_agent_wallet_logs ( agent_id, type, amount, description, reference ) VALUES ( ?, 'withdrawal', ?, ?, ? )" ); $stmt->bind_param( 'idss', $agentId, $amount, $description, $reference ); $stmt->execute(); $stmt->close(); $stmt = $conn->prepare( "UPDATE aso_agent_withdrawals SET status = 'approved', admin_note = ?, processed_at = NOW() WHERE id = ? LIMIT 1" ); $stmt->bind_param( 'si', $adminNote, $withdrawalId ); $stmt->execute(); $stmt->close(); $conn->commit(); echo json_encode([ 'success' => true, 'message' => 'Withdrawal approved and commission deducted.' ]); exit; } catch (Throwable $e) { $conn->rollback(); throw $e; } } /* * DELETE AGENT * * This removes the agent's own records only if there are no * transaction/withdrawal records. This prevents accidental * destruction of financial history. */ if ($action === 'delete_agent') { $agentId = (int)($_POST['agent_id'] ?? 0); if ($agentId <= 0) { throw new RuntimeException( 'Invalid agent.' ); } $stmt = $conn->prepare( "SELECT (SELECT COUNT(*) FROM aso_agent_transactions WHERE agent_id = ?) AS transactions_count, (SELECT COUNT(*) FROM aso_agent_withdrawals WHERE agent_id = ?) AS withdrawals_count, (SELECT COUNT(*) FROM aso_agent_customers WHERE agent_id = ?) AS customers_count" ); $stmt->bind_param( 'iii', $agentId, $agentId, $agentId ); $stmt->execute(); $counts = $stmt->get_result()->fetch_assoc(); $stmt->close(); if ( (int)$counts['transactions_count'] > 0 || (int)$counts['withdrawals_count'] > 0 || (int)$counts['customers_count'] > 0 ) { throw new RuntimeException( 'This agent has financial/customer history. Suspend the agent instead of deleting it.' ); } $conn->begin_transaction(); try { $stmt = $conn->prepare( "DELETE FROM aso_agent_wallet WHERE agent_id = ? LIMIT 1" ); $stmt->bind_param( 'i', $agentId ); $stmt->execute(); $stmt->close(); $stmt = $conn->prepare( "DELETE FROM aso_agents WHERE id = ? LIMIT 1" ); $stmt->bind_param( 'i', $agentId ); $stmt->execute(); if ($stmt->affected_rows !== 1) { throw new RuntimeException( 'Agent not found.' ); } $stmt->close(); $conn->commit(); echo json_encode([ 'success' => true, 'message' => 'Agent deleted.' ]); exit; } catch (Throwable $e) { $conn->rollback(); throw $e; } } throw new RuntimeException( 'Unknown admin action.' ); } catch (Throwable $e) { http_response_code(400); echo json_encode([ 'success' => false, 'message' => $e->getMessage() ]); exit; } } /* |-------------------------------------------------------------------------- | SETTINGS |-------------------------------------------------------------------------- */ $settings = [ 'registration_price' => 5000, 'default_commission_percent' => 5 ]; $result = $conn->query( "SELECT registration_price, default_commission_percent FROM aso_agent_settings WHERE id = 1 LIMIT 1" ); if ($result) { $row = $result->fetch_assoc(); if ($row) { $settings = $row; } $result->free(); } /* |-------------------------------------------------------------------------- | STATISTICS |-------------------------------------------------------------------------- */ $stats = [ 'agents' => 0, 'active_agents' => 0, 'customers' => 0, 'transaction_value' => 0, 'commission' => 0, 'wallet_balance' => 0, 'pending_withdrawals' => 0, 'pending_withdrawal_amount' => 0 ]; $result = $conn->query( "SELECT COUNT(*) AS agents, SUM(status = 'active') AS active_agents, COALESCE(SUM(total_customers),0) AS customers, COALESCE(SUM(total_transaction_amount),0) AS transaction_value, COALESCE(SUM(total_commission),0) AS commission FROM aso_agents" ); if ($result) { $row = $result->fetch_assoc(); if ($row) { $stats['agents'] = (int)$row['agents']; $stats['active_agents'] = (int)$row['active_agents']; $stats['customers'] = (int)$row['customers']; $stats['transaction_value'] = (float)$row['transaction_value']; $stats['commission'] = (float)$row['commission']; } $result->free(); } $result = $conn->query( "SELECT COALESCE(SUM(amount),0) AS wallet_balance FROM aso_agent_wallet" ); if ($result) { $row = $result->fetch_assoc(); $stats['wallet_balance'] = (float)($row['wallet_balance'] ?? 0); $result->free(); } $result = $conn->query( "SELECT COUNT(*) AS pending_withdrawals, COALESCE(SUM(amount),0) AS pending_amount FROM aso_agent_withdrawals WHERE status = 'pending'" ); if ($result) { $row = $result->fetch_assoc(); $stats['pending_withdrawals'] = (int)($row['pending_withdrawals'] ?? 0); $stats['pending_withdrawal_amount'] = (float)($row['pending_amount'] ?? 0); $result->free(); } /* |-------------------------------------------------------------------------- | AGENTS |-------------------------------------------------------------------------- */ $agents = []; $result = $conn->query( "SELECT a.id, a.user_email, a.referral_code, a.agent_rank, a.commission_percent, a.status, a.total_customers, a.total_transaction_amount, a.total_commission, a.created_at, COALESCE(w.amount,0) AS wallet_balance FROM aso_agents a LEFT JOIN aso_agent_wallet w ON w.agent_id = a.id ORDER BY a.total_transaction_amount DESC, a.total_customers DESC, a.total_commission DESC, a.id ASC" ); if ($result) { while ($row = $result->fetch_assoc()) { $agents[] = $row; } $result->free(); } /* |-------------------------------------------------------------------------- | WITHDRAWALS |-------------------------------------------------------------------------- */ $withdrawals = []; $result = $conn->query( "SELECT w.id, w.agent_id, w.amount, w.bank_name, w.account_number, w.status, w.admin_note, w.created_at, w.processed_at, a.user_email, a.referral_code, COALESCE(aw.amount,0) AS wallet_balance FROM aso_agent_withdrawals w INNER JOIN aso_agents a ON a.id = w.agent_id LEFT JOIN aso_agent_wallet aw ON aw.agent_id = w.agent_id ORDER BY CASE WHEN w.status = 'pending' THEN 0 WHEN w.status = 'approved' THEN 1 ELSE 2 END, w.id DESC LIMIT 500" ); if ($result) { while ($row = $result->fetch_assoc()) { $withdrawals[] = $row; } $result->free(); } /* |-------------------------------------------------------------------------- | RECENT TRANSACTIONS |-------------------------------------------------------------------------- */ $transactions = []; $result = $conn->query( "SELECT t.id, t.customer_email, t.external_transaction_id, t.service_name, t.transaction_amount, t.commission_percent, t.commission_amount, t.status, t.created_at, a.user_email AS agent_email FROM aso_agent_transactions t INNER JOIN aso_agents a ON a.id = t.agent_id ORDER BY t.id DESC LIMIT 200" ); if ($result) { while ($row = $result->fetch_assoc()) { $transactions[] = $row; } $result->free(); } /* |-------------------------------------------------------------------------- | CUSTOMER LEADERBOARD |-------------------------------------------------------------------------- */ $customers = []; $result = $conn->query( "SELECT c.customer_email, c.total_transactions, c.total_spend, c.total_commission, c.first_referred_at, c.last_transaction_at, a.user_email AS agent_email, a.agent_rank FROM aso_agent_customers c INNER JOIN aso_agents a ON a.id = c.agent_id ORDER BY c.total_spend DESC, c.total_transactions DESC LIMIT 200" ); if ($result) { while ($row = $result->fetch_assoc()) { $customers[] = $row; } $result->free(); } function rankLabel(string $rank): string { return match ($rank) { 'super_agent' => 'SUPER AGENT', 'md' => 'MD', default => 'DEFAULT AGENT' }; } function statusClass(string $status): string { return match (strtolower($status)) { 'approved', 'active' => 'success', 'rejected', 'suspended' => 'danger', default => 'warning' }; } ?> ASOVERIFY Agent Admin
ASOVERIFY AGENT ADMIN
ADMIN CONTROL PANEL
TOTAL AGENTS
active
INVITED CUSTOMERS
CUSTOMER TRANSACTIONS
₦
TOTAL COMMISSION
₦
AGENT WALLET BALANCE
₦
PENDING WITHDRAWALS
PENDING WITHDRAWAL VALUE
₦
REGISTRATION PRICE
₦

Agent Ranking

Agents are ranked by the total transaction value generated by customers they invited. Customer count is the secondary ranking factor.

$agent): ?>
# Agent Rank Customers Transaction Value Commission Wallet
₦ ₦ ₦

Manage Agents

Agent Referral Code Rank Commission % Customers Transactions Commission Wallet Status Action
₦ ₦ ₦

Agent Withdrawal Requests

Approving a withdrawal automatically deducts the approved amount from the agent's commission wallet.

Date Agent Amount Bank Account Wallet Status Action
No withdrawal requests.
₦ ₦
Processed

Customer Transactions

Date Agent Customer Service Transaction ID Amount Commission % Commission Status
No agent transactions.
₦ % ₦

Invited Customers

Customer Agent Agent Rank Transactions Total Spend Commission First Referred Last Transaction
No invited customers.
₦ ₦

Agent System Settings

Changes here affect new agent registrations and the default commission percentage assigned to newly registered agents.

Wallet Adjustment

Admin can manually credit or debit an agent commission wallet. Every adjustment is recorded in the wallet log.