query("SELECT rc.*,rs.session_name FROM result_classes rc JOIN result_sessions rs ON rc.session_id=rs.id ORDER BY rs.is_active DESC,rc.numeric_level,rc.section"); $terms=$conn->query("SELECT rt.*,rs.session_name FROM result_terms rt JOIN result_sessions rs ON rt.session_id=rs.id ORDER BY rs.is_active DESC,rt.display_order"); // Analytics data $class_stats=[]; if($sel_class&&$sel_term){ $students=$conn->query("SELECT id,first_name,last_name,roll_no FROM result_students WHERE class_id=$sel_class AND is_active=1"); $stu_ids=[]; while($s=$students->fetch_assoc()) $stu_ids[$s['id']]=$s; if(!empty($stu_ids)){ $sids=implode(',',array_keys($stu_ids)); $marks=$conn->query("SELECT m.student_id,SUM(m.marks_obtained) as tot_obt,SUM(es.max_marks) as tot_max FROM result_marks m JOIN result_exam_structure es ON m.exam_structure_id=es.id JOIN result_subjects sub ON es.subject_id=sub.id WHERE m.student_id IN($sids) AND es.term_id=$sel_term AND m.status='present' AND sub.is_scholastic=1 AND sub.grading_type='NUMERIC' GROUP BY m.student_id ORDER BY tot_obt DESC"); $rank=1; $gradeCount=[]; $passCount=0; while($m=$marks->fetch_assoc()){ $sid=$m['student_id']; $pct=$m['tot_max']>0?round($m['tot_obt']/$m['tot_max']*100,1):0; $g=getGrade($conn,$pct,'PRIMARY'); $gradeCount[$g['grade_letter']]=($gradeCount[$g['grade_letter']]??0)+1; if($pct>=33) $passCount++; $class_stats[]=['rank'=>$rank,'name'=>$stu_ids[$sid]['first_name'].' '.$stu_ids[$sid]['last_name'],'roll'=>$stu_ids[$sid]['roll_no'],'total'=>$m['tot_obt'],'max'=>$m['tot_max'],'pct'=>$pct,'grade'=>$g['grade_letter'],'desc'=>$g['description']]; $rank++; } $totalStu=count($stu_ids); $failCount=$totalStu-$passCount; } } ?> Analytics | Result

Analytics & Reports

Total Students
Passed
Failed
0)?round($passCount/$totalStu*100,1):0?>%
Pass Rate
Grade Distribution
Pass vs Fail
Class Performance — Ranked
RankStudentRollTotal%GradeDescriptionReport Card
/ % View
📊
Select class & term to view analytics