requireRole(['super_admin', 'admin']); $db = DB(); $flash = getFlashMessage(); // Handle status updates if (isset($_GET['action']) && isset($_GET['id'])) { $action = $_GET['action']; $id = intval($_GET['id']); if ($action === 'approve') { $db->update('noc_applications', ['status' => 'approved'], ['id' => $id]); redirectWithMessage('noc-applications.php', 'Application approved successfully', 'success'); } elseif ($action === 'reject') { $db->update('noc_applications', ['status' => 'rejected'], ['id' => $id]); redirectWithMessage('noc-applications.php', 'Application rejected', 'success'); } elseif ($action === 'delete') { $db->delete('noc_applications', ['id' => $id]); redirectWithMessage('noc-applications.php', 'Application deleted', 'success'); } } // Filters $statusFilter = $_GET['status'] ?? ''; $typeFilter = $_GET['type'] ?? ''; $search = $_GET['search'] ?? ''; $sql = "SELECT * FROM noc_applications WHERE 1=1"; $params = []; if ($statusFilter) { $sql .= " AND status = ?"; $params[] = $statusFilter; } if ($typeFilter) { $sql .= " AND application_type = ?"; $params[] = $typeFilter; } if ($search) { $sql .= " AND (applicant_name LIKE ? OR application_no LIKE ? OR email LIKE ? OR mobile LIKE ?)"; $params[] = "%$search%"; $params[] = "%$search%"; $params[] = "%$search%"; $params[] = "%$search%"; } $sql .= " ORDER BY created_at DESC"; $applications = $db->fetchAll($sql, $params); // Stats $stats = [ 'total' => $db->count('noc_applications'), 'pending' => $db->count('noc_applications', ['status' => 'pending']), 'approved' => $db->count('noc_applications', ['status' => 'approved']), 'rejected' => $db->count('noc_applications', ['status' => 'rejected']) ]; ?> NOC/ID Card Applications - <?= APP_SHORT_NAME ?>

NOC & ID Card Applications

Total Received

Pending Review

Approved

Rejected
App No. Applicant Details Application Type Document Fee Mode Status Applied Date Actions
No applications found matching your filters.

 Online View Already Paid