requireRole(['super_admin', 'admin']); $db = DB(); $user = Auth()->getUser(); // Get dashboard statistics $stats = [ 'total_colleges' => $db->count('users', ['role_id' => ROLE_COLLEGE, 'is_active' => 1]), 'total_arc_centers' => $db->count('users', ['role_id' => ROLE_ARC_CENTER, 'is_active' => 1]), 'total_students' => $db->count('students', ['is_active' => 1]), 'pending_fund_requests' => $db->count('fund_requests', ['status' => 'pending']), 'pending_affiliations' => $db->count('affiliation_applications', ['application_status' => 'under_review']), 'results_pending' => $db->count('students', ['result_declared' => 0, 'status' => 'active']), ]; // Get admin wallet balance $adminWallet = $db->fetchOne("SELECT balance FROM wallets WHERE wallet_type = 'admin'"); $adminBalance = $adminWallet ? $adminWallet['balance'] : 0; // Recent activities $recentActivities = $db->fetchAll( "SELECT al.*, u.full_name, u.institution_name FROM audit_logs al LEFT JOIN users u ON al.user_id = u.id ORDER BY al.created_at DESC LIMIT 10" ); // Recent fund requests $recentFundRequests = $db->fetchAll( "SELECT fr.*, u.institution_name, u.institution_code FROM fund_requests fr JOIN users u ON fr.requester_id = u.id ORDER BY fr.created_at DESC LIMIT 5" ); // Recent admissions $recentAdmissions = $db->fetchAll( "SELECT s.*, c.course_name, u.institution_name FROM students s JOIN courses c ON s.course_id = c.id JOIN users u ON s.institution_id = u.id ORDER BY s.created_at DESC LIMIT 5" ); $flash = getFlashMessage(); ?> Admin Dashboard - <?= APP_SHORT_NAME ?>

Dashboard

Admin Wallet Balance

Total funds available for college approvals

View Wallet Details
Colleges

Students

Fund Requests

0): ?> View Pending
Affiliations

0): ?> Review Applications
Results Pending

Declare Results
Recent Fund Requests
$request['status'], 'class' => 'secondary']; ?>

...
View All Requests
Recent Admissions

View All Students
Recent Activity
View All Logs