Dashboard - Master Admin | Cricket Exchange

query("SELECT * FROM master_admin WHERE id = " . (int)$_SESSION['user_id'])->fetch_assoc(); // Stats $total_subadmins = $conn->query("SELECT COUNT(*) as c FROM sub_admins")->fetch_assoc()['c']; $active_subadmins = $conn->query("SELECT COUNT(*) as c FROM sub_admins WHERE status='active'")->fetch_assoc()['c']; $total_users = $conn->query("SELECT COUNT(*) as c FROM users")->fetch_assoc()['c']; $active_users = $conn->query("SELECT COUNT(*) as c FROM users WHERE status='active'")->fetch_assoc()['c']; $pending_deposits = $conn->query("SELECT COUNT(*) as c FROM subadmin_deposit_requests WHERE status='pending'")->fetch_assoc()['c']; $pending_withdrawals = $conn->query("SELECT COUNT(*) as c FROM subadmin_withdrawal_requests WHERE status='pending'")->fetch_assoc()['c']; $total_subadmin_wallets = $conn->query("SELECT SUM(wallet_balance) as t FROM sub_admins")->fetch_assoc()['t'] ?? 0; $total_user_wallets = $conn->query("SELECT SUM(wallet_balance) as t FROM users")->fetch_assoc()['t'] ?? 0; // Recent transactions $recent_txns = $conn->query("SELECT t.*, IFNULL(sa.full_name, 'Admin') as to_name FROM admin_wallet_transactions t LEFT JOIN sub_admins sa ON t.recipient_id = sa.id AND t.recipient_type='sub_admin' WHERE t.admin_id = " . (int)$_SESSION['user_id'] . " ORDER BY t.created_at DESC LIMIT 8")->fetch_all(MYSQLI_ASSOC); // Recent sub admins $recent_subadmins = $conn->query("SELECT * FROM sub_admins ORDER BY created_at DESC LIMIT 5")->fetch_all(MYSQLI_ASSOC); // Handle wallet load (admin loads own wallet) $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 = "₹" . number_format($amount, 2) . " added to your wallet successfully!"; $admin['wallet_balance'] = $new_balance; } else { $error = "Invalid amount."; } } } ?> Dashboard - Master Admin | Cricket Exchange

My Wallet Balance

💰

Loaded times

Sub Admins

👥

Active

Total Users

🙋

Active

Pending Requests

⏳

Deposits · Withdrawals

Sub Admin Wallets

🏦

Combined balance of all sub admins

User Wallets

👛

Combined balance of all users

0 || $pending_withdrawals > 0): ?>

Action Required: 0): ?> deposit request(s) pending approval. 0): ?> withdrawal request(s) pending approval. Review Now →

Recent Sub Admins

View All

Name	Code	Wallet	Status

No sub admins yet

Wallet History

View All

💳

No transactions yet

Dashboard Overview

Recent Sub Admins

Wallet History

💰 Load Admin Wallet