Sub Admin Dashboard

query("SELECT * FROM sub_admins WHERE id=" . (int)$_SESSION['user_id'])->fetch_assoc(); $total_users = $conn->query("SELECT COUNT(*) as c FROM users WHERE sub_admin_id=" . (int)$_SESSION['user_id'])->fetch_assoc()['c']; $active_users = $conn->query("SELECT COUNT(*) as c FROM users WHERE sub_admin_id=" . (int)$_SESSION['user_id'] . " AND status='active'")->fetch_assoc()['c']; $pending_deposits = $conn->query("SELECT COUNT(*) as c FROM user_deposit_requests WHERE sub_admin_id=" . (int)$_SESSION['user_id'] . " AND status='pending'")->fetch_assoc()['c']; $pending_withdrawals = $conn->query("SELECT COUNT(*) as c FROM user_withdrawal_requests WHERE sub_admin_id=" . (int)$_SESSION['user_id'] . " AND status='pending'")->fetch_assoc()['c']; $my_pending_deposit = $conn->query("SELECT COUNT(*) as c FROM subadmin_deposit_requests WHERE sub_admin_id=" . (int)$_SESSION['user_id'] . " AND status='pending'")->fetch_assoc()['c']; // Recent transactions $recent_txns = $conn->query("SELECT * FROM subadmin_wallet_transactions WHERE sub_admin_id=" . (int)$_SESSION['user_id'] . " ORDER BY created_at DESC LIMIT 6")->fetch_all(MYSQLI_ASSOC); $recent_users = $conn->query("SELECT * FROM users WHERE sub_admin_id=" . (int)$_SESSION['user_id'] . " ORDER BY created_at DESC LIMIT 5")->fetch_all(MYSQLI_ASSOC); ?> Sub Admin Dashboard - Cricket Exchange

0 || $pending_withdrawals > 0): ?>

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

0): ?>

Your deposit request is pending approval from Master Admin.

My Wallet Balance

💰

Total received:

My Users

🙋

Active

Pending Requests

⏳

Deposits · Withdrawals

query("SELECT SUM(wallet_balance) as t FROM users WHERE sub_admin_id=" . (int)$_SESSION['user_id'])->fetch_assoc()['t'] ?? 0; ?>

Users Total Wallet

👛

Combined of all my users

My Users

View All

User	Wallet	Status
@
No users yet

My Users

Wallet History

🔗 My Login Link