requireRole(['super_admin', 'admin']);
$db = DB();
$flash = getFlashMessage();
// Handle Manual Top-up
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action']) && $_POST['action'] === 'topup') {
$wallet_id = intval($_POST['wallet_id']);
$amount = floatval($_POST['amount']);
$remarks = cleanInput($_POST['remarks']);
if ($amount > 0) {
$wallet = $db->fetchOne("SELECT * FROM wallets WHERE id = ?", [$wallet_id]);
if ($wallet) {
$db->query("UPDATE wallets SET balance = balance + ?, total_credited = total_credited + ? WHERE id = ?", [$amount, $amount, $wallet_id]);
// Log transaction
$db->insert('transactions', [
'transaction_id' => 'MANUAL_' . time(),
'to_user_id' => $wallet['user_id'],
'from_user_id' => $_SESSION['user_id'],
'transaction_type' => 'manual_topup',
'amount' => $amount,
'status' => 'completed',
'description' => "Manual topup: $remarks"
]);
redirectWithMessage('wallet.php', 'Wallet balance updated successfully.', 'success');
}
}
}
// Fetch Wallets
$wallets = $db->fetchAll("
SELECT w.*, u.institution_name, u.institution_code, u.email
FROM wallets w
LEFT JOIN users u ON w.user_id = u.id
WHERE w.wallet_type = 'college'
ORDER BY w.balance DESC
");
?>
Manage Wallets - <?= APP_SHORT_NAME ?>
College Wallets
| Institution Name |
Code |
Current Balance |
Total Credited |
Actions |
| No wallets found. |
|
|
₹ |
₹ |
|