requireRole(['super_admin', 'admin']); $db = DB(); $admin = Auth()->getUser(); $flash = getFlashMessage(); $action = $_GET['action'] ?? 'list'; $id = intval($_GET['id'] ?? 0); // ── APPROVE ────────────────────────────────────────────────────────────────── if ($action === 'approve' && $id) { // CSRF Protection if (!Auth()->verifyCSRFToken($_GET['csrf_token'] ?? '')) { redirectWithMessage('affiliations.php', 'Security session expired. Please try again.', 'danger'); } $app = $db->fetchOne("SELECT * FROM affiliation_applications WHERE id = ?", [$id]); if ($app && $app['application_status'] !== 'approved') { $name = preg_replace('/[^A-Z0-9]/i', '', strtoupper($app['institution_name'])); $username = 'CLG' . substr($name, 0, 5) . rand(100, 999); $password = 'Ibvte@' . rand(1000, 9999); $passHash = password_hash($password, PASSWORD_DEFAULT); $instCode = 'IBVTE' . date('Y') . str_pad($id, 4, '0', STR_PAD_LEFT); $userId = null; try { $userId = $db->insert('users', [ 'role_id' => ROLE_COLLEGE, 'username' => $username, 'email' => $app['director_email'], 'password' => $passHash, 'full_name' => $app['director_name'], 'mobile' => $app['director_mobile'], 'institution_name' => $app['institution_name'], 'institution_code' => $instCode, 'city' => $app['city'], 'state' => $app['state'], 'affiliation_status' => 'approved', 'is_active' => 1, 'created_at' => date('Y-m-d H:i:s'), ]); $db->insert('wallets', [ 'user_id' => $userId, 'wallet_type' => 'college', 'balance' => 0, 'created_at' => date('Y-m-d H:i:s'), ]); } catch (Exception $e) { error_log("Affiliation Approval Error: " . $e->getMessage()); } $db->update('affiliation_applications', [ 'application_status' => 'approved', 'approved_by' => $admin['id'], 'approved_at' => date('Y-m-d H:i:s'), 'approval_valid_from' => date('Y-m-d'), 'approval_valid_until'=> date('Y-m-d', strtotime('+3 years')), ], ['id' => $id]); $_SESSION['cred_modal'] = [ 'username' => $username, 'password' => $password, 'inst' => $app['institution_name'], 'code' => $instCode, ]; redirectWithMessage('affiliations.php', "✅ Approved! College account created: $username", 'success'); } } // ── REJECT ──────────────────────────────────────────────────────────────────── if ($action === 'reject' && $id) { // CSRF Protection if (!Auth()->verifyCSRFToken($_GET['csrf_token'] ?? '')) { redirectWithMessage('affiliations.php', 'Security session expired. Please try again.', 'danger'); } $db->update('affiliation_applications', [ 'application_status' => 'rejected', 'approved_by' => $admin['id'], 'approved_at' => date('Y-m-d H:i:s'), 'review_remarks' => trim($_GET['reason'] ?? 'Rejected by admin'), ], ['id' => $id]); redirectWithMessage('affiliations.php', '❌ Application rejected.', 'warning'); } // ── UNDER REVIEW ────────────────────────────────────────────────────────────── if ($action === 'review' && $id) { // CSRF Protection if (!Auth()->verifyCSRFToken($_GET['csrf_token'] ?? '')) { redirectWithMessage('affiliations.php', 'Security session expired. Please try again.', 'danger'); } $db->update('affiliation_applications', ['application_status' => 'under_review'], ['id' => $id]); redirectWithMessage('affiliations.php', '🔍 Marked as Under Review.', 'info'); } // ── SAVE EDIT ───────────────────────────────────────────────────────────────── if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['save_edit'])) { // CSRF Protection if (!Auth()->verifyCSRFToken($_POST['csrf_token'] ?? '')) { redirectWithMessage('affiliations.php', 'Security session expired. Please try again.', 'danger'); } $eid = intval($_POST['edit_id']); $db->update('affiliation_applications', [ 'institution_name' => trim($_POST['institution_name']), 'director_name' => trim($_POST['director_name']), 'director_mobile' => trim($_POST['director_mobile']), 'director_email' => trim($_POST['director_email']), 'address' => trim($_POST['address']), 'city' => trim($_POST['city']), 'state' => trim($_POST['state']), 'review_remarks' => trim($_POST['review_remarks']), ], ['id' => $eid]); redirectWithMessage('affiliations.php', '✏️ Application updated.', 'success'); } // ── FETCH DATA ──────────────────────────────────────────────────────────────── $statusFilter = $_GET['status'] ?? ''; $sql = "SELECT * FROM affiliation_applications"; $params = []; if ($statusFilter) { $sql .= " WHERE application_status = ?"; $params[] = $statusFilter; } $sql .= " ORDER BY created_at DESC"; $applications = $db->fetchAll($sql, $params); $counts = [ 'all' => $db->count('affiliation_applications'), 'submitted' => $db->count('affiliation_applications', ['application_status' => 'submitted']), 'under_review' => $db->count('affiliation_applications', ['application_status' => 'under_review']), 'approved' => $db->count('affiliation_applications', ['application_status' => 'approved']), 'rejected' => $db->count('affiliation_applications', ['application_status' => 'rejected']), ]; $viewApp = ($action === 'view' && $id) ? $db->fetchOne("SELECT * FROM affiliation_applications WHERE id = ?", [$id]) : null; $credModal = $_SESSION['cred_modal'] ?? null; unset($_SESSION['cred_modal']); ?> Affiliation Applications – <?= APP_SHORT_NAME ?>

Affiliation Applications

New Under Review
'bg-success', 'rejected' => 'bg-danger', 'under_review' => 'bg-info', 'submitted' => 'bg-warning text-dark', default => 'bg-secondary', }; $label = match($a['application_status']) { 'submitted' => 'New', 'under_review' => 'Under Review', 'approved' => 'Approved', 'rejected' => 'Rejected', default => ucfirst($a['application_status']), }; ?>
App No. Institution Contact Location Status Submitted Actions
No applications found.

 
✕ Close
Institution Info
Type
Est. Year
Total Staff
Classrooms
LibraryYes' : 'No' ?>
Computer LabYes' : 'No' ?>
InternetYes' : 'No' ?>
Courses
Contact & Address
Director
Mobile
Email
Address
City/State
Pincode
Txn Ref
Admin Remarks:
Approve Application Reject