real_escape_string(trim($_POST['component_name']));
$mm=floatval($_POST['max_marks']); $pm=floatval($_POST['pass_marks']); $wt=floatval($_POST['weightage']);
$conn->query("INSERT INTO result_exam_structure (term_id,class_id,subject_id,component_name,max_marks,pass_marks,weightage) VALUES ($tid,$cid,$sid,'$comp',$mm,$pm,$wt)");
if($conn->affected_rows>0) $msg="Structure added!"; else $err=$conn->error;
}
if ($_POST['action']??''=='bulk_setup') {
// Auto-create structure for all mapped subjects in a class-term
$tid=intval($_POST['term_id']); $cid=intval($_POST['class_id']);
$comp=$conn->real_escape_string($_POST['component_name']??'Theory');
$mm=floatval($_POST['max_marks']??100); $pm=floatval($_POST['pass_marks']??33);
$subs=$conn->query("SELECT subject_id FROM result_class_subject WHERE class_id=$cid");
$added=0;
while($s=$subs->fetch_assoc()) {
$conn->query("INSERT IGNORE INTO result_exam_structure (term_id,class_id,subject_id,component_name,max_marks,pass_marks,weightage) VALUES ($tid,$cid,{$s['subject_id']},'$comp',$mm,$pm,100)");
if($conn->affected_rows>0) $added++;
}
$msg="$added exam structures created!";
}
if (isset($_GET['del'])) { $conn->query("DELETE FROM result_exam_structure WHERE id=".intval($_GET['del'])); $msg="Deleted."; }
$filter_class=intval($_GET['class_id']??0); $filter_term=intval($_GET['term_id']??0);
$where=[]; if($filter_class) $where[]="es.class_id=$filter_class"; if($filter_term) $where[]="es.term_id=$filter_term";
$wstr=count($where)?"WHERE ".implode(' AND ',$where):"";
$structures=$conn->query("SELECT es.*,c.class_name,c.section,s.subject_name,s.grading_type,t.term_name FROM result_exam_structure es JOIN result_classes c ON es.class_id=c.id JOIN result_subjects s ON es.subject_id=s.id JOIN result_terms t ON es.term_id=t.id $wstr ORDER BY c.numeric_level,t.display_order,s.subject_name");
$classes=$conn->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");
$subjects=$conn->query("SELECT * FROM result_subjects WHERE is_active=1 ORDER BY subject_name");
$components=['Theory','Practical','Oral','Notebook','Subject Enrichment','Assignment','FA1','FA2','SA1','SA2','Unit Test','Half Yearly','Annual'];
?>
Exam Structure | Result