window.location.href='../center_login.php';"; exit(); } $center_id = intval($_SESSION['center']['id']); // Fetch basic center details $get = $con->query("SELECT * FROM centers WHERE id = '$center_id'")->fetch_assoc(); // Fetch dashboard counters safely $studentResultApproved = $con->query("SELECT id FROM `students` WHERE center_id = '$center_id' AND status = 1"); $studentResultPending = $con->query("SELECT id FROM `students` WHERE center_id = '$center_id' AND status = 0"); $certificateCount = $con->query("SELECT certificates.id FROM `certificates` JOIN `students` ON students.enrollment_no = certificates.enrollment_no WHERE certificates.status = 1 AND students.center_id = '$center_id'")->num_rows; $resultCount = $con->query("SELECT id FROM results WHERE center_id = '$center_id' AND status = 1"); $admitCardCount = $con->query("SELECT admit_card.id FROM admit_card JOIN `students` ON students.enrollment_no = admit_card.enrollment_no WHERE students.center_id = '$center_id'"); // Recent 5 admissions $recentStudents = $con->query("SELECT * FROM students WHERE center_id = '$center_id' ORDER BY id DESC LIMIT 5"); // Chart Data - Monthly Admissions (Last 6 months) $chartLabels = []; $chartData = []; $dateColumn = 'timestamp'; $columnCheck = $con->query("SHOW COLUMNS FROM students LIKE 'created_at'"); if ($columnCheck && $columnCheck->num_rows > 0) { $dateColumn = 'created_at'; } else { $columnCheck = $con->query("SHOW COLUMNS FROM students LIKE 'timestamp'"); if ($columnCheck && $columnCheck->num_rows > 0) { $dateColumn = 'timestamp'; } else { $columnCheck = $con->query("SHOW COLUMNS FROM students LIKE 'date'"); if ($columnCheck && $columnCheck->num_rows > 0) { $dateColumn = 'date'; } } } for ($i = 5; $i >= 0; $i--) { $month = date('M Y', strtotime("-$i months")); $monthStart = date('Y-m-01', strtotime("-$i months")); $monthEnd = date('Y-m-t', strtotime("-$i months")); $chartLabels[] = $month; if ($dateColumn != 'id') { $countQuery = $con->query("SELECT COUNT(*) as total FROM students WHERE center_id = '$center_id' AND DATE($dateColumn) BETWEEN '$monthStart' AND '$monthEnd'"); $chartData[] = $countQuery ? ($countQuery->fetch_assoc()['total'] ?? 0) : 0; } else { $chartData[] = 0; } } ?>

Institute Management Dashboard

Welcome back, • Gujarat State Open School

Authorized Center

query("SELECT * FROM notification"); if ($data && $data->num_rows > 0) { while ($res = $data->fetch_assoc()) { echo '

'; echo '' . htmlspecialchars($res['title'] ?? '') . ' | '; } } else { echo 'No new notifications at this time.'; } ?>

num_rows?>

Approved

num_rows?>

Pending

Certificates

num_rows?>

Results

num_rows?>

Admit Cards

Monthly Admissions (Last 6 Months)

Recent Admissions

num_rows > 0): while ($student = $recentStudents->fetch_assoc()): ?>

Enrollment No	Name	Course	Status
			Approved Pending
No students found