query("SELECT * FROM master_admin WHERE id = " . (int)$_SESSION['user_id'])->fetch_assoc();
$success = $error = '';
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action'])) {
if ($_POST['action'] === 'load_admin_wallet') {
$amount = floatval($_POST['amount']);
$desc = sanitize($_POST['description'] ?? 'Manual credit');
if ($amount > 0) {
$new_balance = $admin['wallet_balance'] + $amount;
$conn->query("UPDATE master_admin SET wallet_balance=$new_balance, total_loaded=total_loaded+$amount, load_count=load_count+1 WHERE id=" . (int)$_SESSION['user_id']);
$conn->query("INSERT INTO admin_wallet_transactions (admin_id, transaction_type, amount, description, recipient_type, balance_after) VALUES (" . (int)$_SESSION['user_id'] . ", 'credit', $amount, '$desc', 'admin', $new_balance)");
$success = formatINR($amount) . " added to your wallet!";
$admin['wallet_balance'] = $new_balance;
}
}
}
// Fetch all transactions with pagination
$page = max(1, (int)($_GET['page'] ?? 1));
$limit = 20;
$offset = ($page - 1) * $limit;
$total = $conn->query("SELECT COUNT(*) as c FROM admin_wallet_transactions WHERE admin_id=" . (int)$_SESSION['user_id'])->fetch_assoc()['c'];
$pages = ceil($total / $limit);
$transactions = $conn->query("SELECT * FROM admin_wallet_transactions WHERE admin_id=" . (int)$_SESSION['user_id'] . " ORDER BY created_at DESC LIMIT $limit OFFSET $offset")->fetch_all(MYSQLI_ASSOC);
?>
My Wallet - Cricket Exchange Admin
My Wallet
Manage and track your wallet balance
💰 Current Balance
Total Loaded Ever
📊
load operations
query("SELECT SUM(amount) as t FROM admin_wallet_transactions WHERE admin_id=" . (int)$_SESSION['user_id'] . " AND transaction_type='debit'")->fetch_assoc()['t'] ?? 0;
?>