requireRole(['super_admin', 'admin']); $db = DB(); $flash = getFlashMessage(); // Handle result declaration if ($_SERVER['REQUEST_METHOD'] === 'POST') { // CSRF Protection if (!Auth()->verifyCSRFToken($_POST['csrf_token'] ?? '')) { redirectWithMessage('results.php', 'Security session expired. Please try again.', 'danger'); } $action = $_POST['action'] ?? ''; if ($action === 'declare') { $studentId = intval($_POST['student_id'] ?? 0); $marksObtained = intval($_POST['marks_obtained'] ?? 0); $totalMarks = intval($_POST['total_marks'] ?? 100); $percentage = ($marksObtained / $totalMarks) * 100; // Calculate division $division = getDivision($percentage); // Calculate remark $remark = ''; if ($percentage >= 75) $remark = 'D'; else if ($percentage >= 60) $remark = 'I'; else if ($percentage >= 50) $remark = 'II'; else if ($percentage >= 40) $remark = 'III'; else $remark = 'Fail'; $db->update('students', [ 'marks_obtained' => $marksObtained, 'total_marks' => $totalMarks, 'percentage' => round($percentage, 2), 'division' => $division, 'remark' => $remark, 'result_declared' => 1, 'result_declared_at' => date('Y-m-d H:i:s') ], ['id' => $studentId]); // Add detailed subject results if provided if (!empty($_POST['subjects'])) { foreach ($_POST['subjects'] as $subject) { if (!empty($subject['name'])) { $subMarks = intval($subject['marks'] ?? 0); $subMax = intval($subject['max_marks'] ?? 100); $subPercent = ($subMarks / $subMax) * 100; // Grade calculation $grade = 'F'; $isPass = 0; if ($subPercent >= 90) $grade = 'A+'; else if ($subPercent >= 80) $grade = 'A'; else if ($subPercent >= 70) $grade = 'B+'; else if ($subPercent >= 60) $grade = 'B'; else if ($subPercent >= 50) $grade = 'C'; else if ($subPercent >= 40) $grade = 'D'; if ($subPercent >= 40) $isPass = 1; $db->insert('student_results', [ 'student_id' => $studentId, 'exam_type' => 'final', 'exam_session' => $_POST['session_year'] ?? date('Y'), 'semester' => intval($_POST['semester'] ?? 1), 'subject_code' => strtoupper(substr($subject['name'], 0, 3)) . rand(100, 999), 'subject_name' => $subject['name'], 'max_marks' => $subMax, 'obtained_marks' => $subMarks, 'grade' => $grade, 'is_pass' => $isPass, 'is_published' => 1, 'published_at' => date('Y-m-d H:i:s'), 'created_by' => $_SESSION['user_id'] ]); } } } redirectWithMessage('results.php', 'Result declared successfully', 'success'); } if ($action === 'bulk_declare') { $studentIds = $_POST['student_ids'] ?? []; foreach ($studentIds as $id) { $db->update('students', [ 'result_declared' => 1, 'result_declared_at' => date('Y-m-d H:i:s') ], ['id' => $id]); } redirectWithMessage('results.php', count($studentIds) . ' results published', 'success'); } } // Get students without declared results $pendingStudents = $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 WHERE s.result_declared = 0 AND s.status = 'active' ORDER BY s.created_at DESC" ); // Get declared results $declaredResults = $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 WHERE s.result_declared = 1 ORDER BY s.result_declared_at DESC" ); // Add dummy data $dummyPending = [ ['id' => 1, 'full_name' => 'Rahul Kumar', 'roll_number' => 'IBVTE24001', 'course_name' => 'Diploma in Computer', 'institution_name' => 'XYZ College', 'session_year' => '2023-24'], ['id' => 2, 'full_name' => 'Priya Sharma', 'roll_number' => 'IBVTE24002', 'course_name' => 'Diploma in Aviation', 'institution_name' => 'ABC Institute', 'session_year' => '2023-24'], ['id' => 3, 'full_name' => 'Amit Singh', 'roll_number' => 'IBVTE24003', 'course_name' => 'Diploma in Ayurveda', 'institution_name' => 'Medical College', 'session_year' => '2023-24'], ]; $dummyDeclared = [ ['id' => 4, 'full_name' => 'Sunita Devi', 'roll_number' => 'IBVTE23001', 'course_name' => 'Diploma in Computer', 'institution_name' => 'XYZ College', 'marks_obtained' => 78, 'total_marks' => 100, 'percentage' => 78.00, 'division' => 'first', 'remark' => 'I', 'session_year' => '2022-23'], ['id' => 5, 'full_name' => 'Rajesh Patel', 'roll_number' => 'IBVTE23002', 'course_name' => 'Diploma in Civil', 'institution_name' => 'Engineering College', 'marks_obtained' => 82, 'total_marks' => 100, 'percentage' => 82.00, 'division' => 'first', 'remark' => 'I', 'session_year' => '2022-23'], ['id' => 6, 'full_name' => 'Anita Gupta', 'roll_number' => 'IBVTE23003', 'course_name' => 'Diploma in Automobile', 'institution_name' => 'Tech Institute', 'marks_obtained' => 76, 'total_marks' => 100, 'percentage' => 76.00, 'division' => 'distinction', 'remark' => 'D', 'session_year' => '2022-23'], ['id' => 7, 'full_name' => 'Vikram Rao', 'roll_number' => 'IBVTE23004', 'course_name' => 'Diploma in Computer', 'institution_name' => 'XYZ College', 'marks_obtained' => 35, 'total_marks' => 100, 'percentage' => 35.00, 'division' => 'fail', 'remark' => '*', 'session_year' => '2022-23'], ]; if (empty($pendingStudents)) { $pendingStudents = $dummyPending; } if (empty($declaredResults)) { $declaredResults = $dummyDeclared; } // Stats $totalPending = count($pendingStudents); $totalDeclared = count($declaredResults); $totalPass = count(array_filter($declaredResults, fn($s) => $s['percentage'] >= 40)); $totalFail = count(array_filter($declaredResults, fn($s) => $s['percentage'] < 40)); ?> Result Management - <?= APP_SHORT_NAME ?>

Result Management

Pending Results

Total Declared

Passed

Failed
Pending Results ()
Student Roll Number Course Institution Session Action
Roll:
Declared Results
Student Roll Number Course & Sem Marks Percentage Division Remark Actions
Roll:

fetchOne("SELECT semester FROM student_results WHERE student_id = ? ORDER BY semester DESC LIMIT 1", [$result['id']]); $semNum = $sem ? $sem['semester'] : 1; ?> Semester 		/ %