All Transactions - Master Admin

query("SELECT SUM(amount) as t FROM admin_wallet_transactions WHERE transaction_type='credit' AND recipient_type='admin'")->fetch_assoc()['t'] ?? 0; $total_subadmin_disbursed = $conn->query("SELECT SUM(amount) as t FROM admin_wallet_transactions WHERE transaction_type='debit' AND recipient_type='sub_admin'")->fetch_assoc()['t'] ?? 0; $total_user_deposits = $conn->query("SELECT SUM(amount) as t FROM user_deposit_requests WHERE status='approved'")->fetch_assoc()['t'] ?? 0; $total_user_withdrawals = $conn->query("SELECT SUM(amount) as t FROM user_withdrawal_requests WHERE status='approved'")->fetch_assoc()['t'] ?? 0; // Admin Wallet Txns $admin_txns = $conn->query("SELECT * FROM admin_wallet_transactions ORDER BY created_at DESC LIMIT 50")->fetch_all(MYSQLI_ASSOC); // Sub Admin Txns $sa_txns = $conn->query(" SELECT t.*, sa.full_name as sa_name, sa.unique_code FROM subadmin_wallet_transactions t JOIN sub_admins sa ON t.sub_admin_id = sa.id ORDER BY t.created_at DESC LIMIT 50 ")->fetch_all(MYSQLI_ASSOC); // User Txns $user_txns = $conn->query(" SELECT t.*, u.full_name as user_name, u.username as u_username, sa.full_name as sa_name FROM user_wallet_transactions t JOIN users u ON t.user_id = u.id LEFT JOIN sub_admins sa ON u.sub_admin_id = sa.id ORDER BY t.created_at DESC LIMIT 50 ")->fetch_all(MYSQLI_ASSOC); ?> All Transactions - Master Admin | Cricket Exchange

Total Admin Loaded

Direct wallet additions

Sent to Sub Admins

Allocated to Sub Admins

User Deposits Approved

Loaded to User accounts

User Withdrawals Paid

Successfully paid out

Master Admin Logs () Sub Admin Wallets () User Wallets ()

👑 Master Admin Wallet Activity Log

No Master Admin transactions yet.

Date & Time	Type	Amount	Recipient / Purpose	Balance After	Notes
			Admin Self Load

👥 Sub Admin Transactions Log

No Sub Admin transactions yet.

Date	Sub Admin	Type	Amount	To / From	Balance After	Description

🙋 User Account Transactions Log

No User transactions yet.

Date	User	Sub Admin	Type	Amount	Balance After	Description
	@

Global Transactions Audit

Total Admin Loaded

Sent to Sub Admins

User Deposits Approved

User Withdrawals Paid