User Requests

query("SELECT * FROM sub_admins WHERE id=" . (int)$_SESSION['user_id'])->fetch_assoc(); $success = $error = ''; $sa_id = (int)$_SESSION['user_id']; if ($_SERVER['REQUEST_METHOD'] === 'POST') { $action = $_POST['action'] ?? ''; // Approve user deposit if ($action === 'approve_deposit') { $req_id = (int)$_POST['req_id']; $req = $conn->query("SELECT * FROM user_deposit_requests WHERE id=$req_id AND sub_admin_id=$sa_id AND status='pending'")->fetch_assoc(); if ($req) { $amount = $req['amount']; $user_id = $req['user_id']; $user = $conn->query("SELECT * FROM users WHERE id=$user_id")->fetch_assoc(); $new_user_bal = $user['wallet_balance'] + $amount; $conn->query("UPDATE users SET wallet_balance=$new_user_bal, total_received=total_received+$amount WHERE id=$user_id"); $conn->query("UPDATE user_deposit_requests SET status='approved', approved_at=NOW() WHERE id=$req_id"); $conn->query("INSERT INTO user_wallet_transactions (user_id, transaction_type, amount, description, balance_after, reference_id) VALUES ($user_id, 'credit', $amount, 'Deposit approved by Sub Admin', $new_user_bal, $req_id)"); $success = "Deposit of " . formatINR($amount) . " approved for " . htmlspecialchars($user['full_name']) . "!"; } } if ($action === 'reject_deposit') { $req_id = (int)$_POST['req_id']; $note = sanitize($_POST['subadmin_note'] ?? 'Rejected'); $conn->query("UPDATE user_deposit_requests SET status='rejected', subadmin_note='$note', approved_at=NOW() WHERE id=$req_id AND sub_admin_id=$sa_id"); $success = "Deposit request rejected."; } // Approve user withdrawal if ($action === 'approve_withdrawal') { $req_id = (int)$_POST['req_id']; $req = $conn->query("SELECT * FROM user_withdrawal_requests WHERE id=$req_id AND sub_admin_id=$sa_id AND status='pending'")->fetch_assoc(); if ($req) { $amount = $req['amount']; $user_id = $req['user_id']; $user = $conn->query("SELECT * FROM users WHERE id=$user_id")->fetch_assoc(); if ($user['wallet_balance'] < $amount) { $error = "User's wallet balance is insufficient."; } else { $new_user_bal = $user['wallet_balance'] - $amount; $conn->query("UPDATE users SET wallet_balance=$new_user_bal WHERE id=$user_id"); $conn->query("UPDATE user_withdrawal_requests SET status='approved', approved_at=NOW() WHERE id=$req_id"); $conn->query("INSERT INTO user_wallet_transactions (user_id, transaction_type, amount, description, balance_after, reference_id) VALUES ($user_id, 'debit', $amount, 'Withdrawal approved', $new_user_bal, $req_id)"); $success = "Withdrawal of " . formatINR($amount) . " approved!"; } } } if ($action === 'reject_withdrawal') { $req_id = (int)$_POST['req_id']; $note = sanitize($_POST['subadmin_note'] ?? 'Rejected'); $conn->query("UPDATE user_withdrawal_requests SET status='rejected', subadmin_note='$note', approved_at=NOW() WHERE id=$req_id AND sub_admin_id=$sa_id"); $success = "Withdrawal rejected."; } } $tab = $_GET['tab'] ?? 'deposits'; $deposits = $conn->query("SELECT dr.*, u.full_name as user_name, u.username FROM user_deposit_requests dr JOIN users u ON u.id=dr.user_id WHERE dr.sub_admin_id=$sa_id ORDER BY dr.created_at DESC")->fetch_all(MYSQLI_ASSOC); $withdrawals = $conn->query("SELECT wr.*, u.full_name as user_name FROM user_withdrawal_requests wr JOIN users u ON u.id=wr.user_id WHERE wr.sub_admin_id=$sa_id ORDER BY wr.created_at DESC")->fetch_all(MYSQLI_ASSOC); ?> User Requests - Sub Admin | Cricket Exchange

$d['status']==='pending')); $pending_wit = count(array_filter($withdrawals, fn($w) => $w['status']==='pending')); ?>

📥 User Deposit Requests

$dep): ?>

#	User	Amount	Transaction ID	Screenshot	Status	Date	Actions
	@			📷 View No image			✅ Approved ❌ Rejected
📥 No deposit requests

📤 User Withdrawal Requests

$wr): ?>

#	User	Amount	Payment Details	Status	Date	Actions
			📱			✅ Approved ❌ Rejected
📤 No withdrawal requests

📥 User Deposit Requests

📤 User Withdrawal Requests

❌ Reject Request