requireRole(['college']); $db = DB(); $flash = getFlashMessage(); $user = Auth()->getUser(); // Get college wallet $wallet = $db->fetchOne("SELECT * FROM wallets WHERE user_id = ?", [$user['id']]); // Check affiliation status $collegeData = $db->fetchOne("SELECT affiliation_status FROM users WHERE id = ?", [$user['id']]); $isApproved = ($collegeData['affiliation_status'] === 'approved'); // Handle fund request submission if ($_SERVER['REQUEST_METHOD'] === 'POST') { if (!$isApproved) { redirectWithMessage('fund-requests.php', 'You must be an approved college to request funds. Your current status is ' . ucfirst($collegeData['affiliation_status']), 'danger'); } $amount = floatval($_POST['amount'] ?? 0); $transactionId = cleanInput($_POST['transaction_id'] ?? ''); $date = $_POST['transaction_date'] ?? date('Y-m-d'); $purpose = cleanInput($_POST['purpose'] ?? 'Wallet Topup'); // Handle snapshot upload $snapshotPath = ''; if (isset($_FILES['snapshot']) && $_FILES['snapshot']['error'] === 0) { $targetDir = "../uploads/fund_requests/"; if (!is_dir($targetDir)) mkdir($targetDir, 0777, true); $fileName = time() . '_' . basename($_FILES['snapshot']['name']); $targetPath = $targetDir . $fileName; if (move_uploaded_file($_FILES['snapshot']['tmp_name'], $targetPath)) { $snapshotPath = "uploads/fund_requests/" . $fileName; } } if ($amount > 0 && !empty($transactionId)) { $db->insert('fund_requests', [ 'requester_id' => $user['id'], 'amount' => $amount, 'purpose' => $purpose, 'supporting_document' => $snapshotPath, 'remarks' => "Trans ID: $transactionId | Date: $date", 'status' => 'pending', 'created_at' => date('Y-m-d H:i:s') ]); redirectWithMessage('fund-requests.php', 'Fund request submitted successfully. Admin will review and approve soon.', 'success'); } else { $error = 'Please enter a valid amount and transaction ID.'; } } // Get request history $requests = $db->fetchAll("SELECT * FROM fund_requests WHERE requester_id = ? ORDER BY created_at DESC", [$user['id']]); ?> Wallet & Fund Requests - College Panel

Wallet & Fund Requests

Current Balance

₹

Virtual wallet for student admissions & fees

Request Fund Addition
Only approved colleges can request funds. Your current status is: .
Request History
Date Amount Status Remarks Details
No requests found
₹ Pending Approved Rejected View