requireRole(['college']);
$db = DB();
$user = Auth()->getUser();
// Stats
$totalStudents = $db->fetchOne("SELECT COUNT(*) FROM students WHERE institution_id = ?", [$user['id']])['COUNT(*)'] ?? 0;
$wallet = $db->fetchOne("SELECT balance FROM wallets WHERE user_id = ?", [$user['id']]);
$walletBalance = $wallet['balance'] ?? 0;
$pendingResults = $db->fetchOne("SELECT COUNT(*) FROM students WHERE institution_id = ? AND status = 'pending'", [$user['id']])['COUNT(*)'] ?? 0;
// Recent Students
$recentStudents = $db->fetchAll("SELECT s.*, c.course_name FROM students s JOIN courses c ON s.course_id = c.id WHERE s.institution_id = ? ORDER BY s.created_at DESC LIMIT 5", [$user['id']]);
?>
College Dashboard - IBVTE
Admin Mode: You are viewing this college as an admin.