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");
$selected_class = intval($_GET['class_id'] ?? 0);
$students_list = [];
if ($selected_class) {
$sr = $conn->query("SELECT id,first_name,last_name,admission_no,roll_no FROM result_students WHERE class_id=$selected_class AND is_active=1 ORDER BY roll_no");
while($s=$sr->fetch_assoc()) $students_list[] = $s;
}
// Show selector UI
include_once('_report_selector.php');
exit;
}
// ---- FETCH STUDENT DATA ----
$student = $conn->query("SELECT rs.*, rc.class_name, rc.section, rc.numeric_level, sess.session_name
FROM result_students rs
JOIN result_classes rc ON rs.class_id=rc.id
JOIN result_sessions sess ON rc.session_id=sess.id
WHERE rs.id=$student_id")->fetch_assoc();
if (!$student) { echo "
Student not found.
"; exit; }
$term = $conn->query("SELECT * FROM result_terms WHERE id=$term_id")->fetch_assoc();
// Marks
$marks_res = $conn->query("
SELECT m.marks_obtained, m.status, es.max_marks, es.pass_marks, es.component_name, es.weightage,
s.subject_name, s.subject_code, s.grading_type, s.is_scholastic
FROM result_marks m
JOIN result_exam_structure es ON m.exam_structure_id=es.id
JOIN result_subjects s ON es.subject_id=s.id
WHERE m.student_id=$student_id AND es.term_id=$term_id AND s.is_scholastic=1
ORDER BY s.subject_name, es.component_name
");
$subjects_data = [];
$totalObt = 0; $totalMax = 0; $failSubjects = 0;
while($m=$marks_res->fetch_assoc()) {
$sname = $m['subject_name'];
if (!isset($subjects_data[$sname])) $subjects_data[$sname] = ['components'=>[],'grading_type'=>$m['grading_type'],'total_obt'=>0,'total_max'=>0,'status'=>'pass'];
$subjects_data[$sname]['components'][] = $m;
if ($m['grading_type']=='NUMERIC' && $m['status']=='present' && $m['marks_obtained']!==null) {
$subjects_data[$sname]['total_obt'] += floatval($m['marks_obtained']);
$subjects_data[$sname]['total_max'] += floatval($m['max_marks']);
$totalObt += floatval($m['marks_obtained']);
$totalMax += floatval($m['max_marks']);
} elseif (!isset($subjects_data[$sname]['total_max_counted'])) {
$subjects_data[$sname]['total_max'] += floatval($m['max_marks']);
$totalMax += floatval($m['max_marks']);
$subjects_data[$sname]['total_max_counted'] = true;
}
}
// Calculate per-subject grade
foreach($subjects_data as $sn=>&$sd) {
if ($sd['grading_type']=='NUMERIC' && $sd['total_max']>0) {
$pct = ($sd['total_obt']/$sd['total_max'])*100;
$g = getGrade($conn, $pct, $student['numeric_level']<=2?'PREPRIMARY':'PRIMARY');
$sd['percentage'] = round($pct,1);
$sd['grade'] = $g['grade_letter'];
$sd['grade_point'] = $g['grade_point'];
$sd['description'] = $g['description'];
if ($sd['total_obt'] < ($sd['total_max'] * 0.33)) { $sd['status']='fail'; $failSubjects++; }
}
}
$overallPct = $totalMax>0 ? round(($totalObt/$totalMax)*100,2) : 0;
$overallGrade = getGrade($conn, $overallPct, $student['numeric_level']<=2?'PREPRIMARY':'PRIMARY');
$result_status = ($failSubjects==0 && count($subjects_data)>0) ? 'PASS' : 'FAIL';
// Attendance
$att = $conn->query("SELECT * FROM result_attendance WHERE student_id=$student_id AND term_id=$term_id")->fetch_assoc();
// Co-scholastic
$coscho = $conn->query("SELECT * FROM result_coscholastic WHERE student_id=$student_id AND term_id=$term_id");
// Remarks
$remarks = $conn->query("SELECT * FROM result_remarks WHERE student_id=$student_id AND term_id=$term_id")->fetch_assoc();
// Rank in class
$rank_res = $conn->query("
SELECT s2.student_id, SUM(m2.marks_obtained) as total
FROM result_marks m2
JOIN result_exam_structure es2 ON m2.exam_structure_id=es2.id
JOIN result_students s2 ON m2.student_id=s2.id
WHERE s2.class_id={$student['class_id']} AND es2.term_id=$term_id AND m2.status='present' AND m2.marks_obtained IS NOT NULL
GROUP BY s2.student_id ORDER BY total DESC
");
$rank = 1; $rankFound = false;
while($r=$rank_res->fetch_assoc()) {
if ($r['student_id']==$student_id) { $rankFound=true; break; }
$rank++;
}
if (!$rankFound) $rank = '--';
$is_preprimary = $student['numeric_level'] <= 2;
?>
Report Card - <?= htmlspecialchars($student['first_name'].' '.$student['last_name']) ?>
📄 PDF View
query("SELECT id,first_name,last_name FROM result_students WHERE class_id={$student['class_id']} AND is_active=1 ORDER BY roll_no,first_name");
$allStu=[]; while($x=$prev_next->fetch_assoc()) $allStu[]=$x;
$myIdx = array_search($student_id, array_column($allStu,'id'));
if ($myIdx!==false && $myIdx>0): $prev=$allStu[$myIdx-1]; ?>
← →
BS
B.S. Public School
Affiliated to CBSE | Nursery to Class 8
bspspublicschool.in | Excellence in Education Since 2005
 ?>)