Withdraw Funds - Sub Admin | Cricket Exchange

query("SELECT * FROM sub_admins WHERE id=" . (int)$_SESSION['user_id'])->fetch_assoc(); $success = $error = ''; if ($_SERVER['REQUEST_METHOD'] === 'POST') { $sa_id = (int)$_SESSION['user_id']; $amount = floatval($_POST['amount']); $holder_name = sanitize($_POST['holder_name']); $mobile = sanitize($_POST['mobile']); $payment_method = in_array($_POST['payment_method'], ['upi','bank']) ? $_POST['payment_method'] : 'upi'; $upi_id = sanitize($_POST['upi_id'] ?? ''); $bank_account = sanitize($_POST['bank_account'] ?? ''); $ifsc_code = sanitize($_POST['ifsc_code'] ?? ''); $bank_name = sanitize($_POST['bank_name'] ?? ''); if ($amount <= 0) { $error = "Invalid amount."; } elseif ($amount > $sa['wallet_balance']) { $error = "Amount exceeds your wallet balance: " . formatINR($sa['wallet_balance']); } elseif (empty($holder_name) || empty($mobile)) { $error = "Name and mobile are required."; } elseif ($payment_method === 'upi' && empty($upi_id)) { $error = "UPI ID is required."; } elseif ($payment_method === 'bank' && (empty($bank_account) || empty($ifsc_code))) { $error = "Bank account and IFSC are required."; } else { $stmt = $conn->prepare("INSERT INTO subadmin_withdrawal_requests (sub_admin_id, amount, holder_name, mobile, payment_method, upi_id, bank_account, ifsc_code, bank_name) VALUES (?,?,?,?,?,?,?,?,?)"); $stmt->bind_param('idssssss', $sa_id, $amount, $holder_name, $mobile, $payment_method, $upi_id, $bank_account, $ifsc_code, $bank_name); // Fix binding - need 9 parameters $stmt = $conn->prepare("INSERT INTO subadmin_withdrawal_requests (sub_admin_id, amount, holder_name, mobile, payment_method, upi_id, bank_account, ifsc_code, bank_name) VALUES (?,?,?,?,?,?,?,?,?)"); $stmt->bind_param('idssssss', $sa_id, $amount, $holder_name, $mobile, $payment_method, $upi_id, $bank_account, $ifsc_code, $bank_name); if ($stmt->execute()) { $success = "Withdrawal request of " . formatINR($amount) . " submitted! Pending admin approval."; } else { $error = "Failed to submit. Please try again."; } } } $history = $conn->query("SELECT * FROM subadmin_withdrawal_requests WHERE sub_admin_id=" . (int)$_SESSION['user_id'] . " ORDER BY created_at DESC")->fetch_all(MYSQLI_ASSOC); ?> Withdraw Funds - Sub Admin | Cricket Exchange

📤 New Withdrawal Request

Amount (₹) * — Max:

Account Holder Name *

Mobile Number *

Payment Method *

📱 UPI 🏦 Bank Account

UPI ID *

📋 Withdrawal History

Note:

📤

No withdrawal requests yet