real_escape_string(trim($_POST['ct_remarks']));
$pr=$conn->real_escape_string(trim($_POST['principal_remarks']));
$rs=$conn->real_escape_string($_POST['result_status']);
$pub=isset($_POST['is_published'])?1:0;
$conn->query("INSERT INTO result_remarks (student_id,term_id,class_teacher_remarks,principal_remarks,result_status,is_published) VALUES ($sid,$tid,'$ctr','$pr','$rs',$pub) ON DUPLICATE KEY UPDATE class_teacher_remarks='$ctr',principal_remarks='$pr',result_status='$rs',is_published=$pub");
$msg="Remarks saved!";
}
// Bulk publish
if ($_POST['action']??''=='bulk_publish') {
$cid=intval($_POST['class_id']); $tid=intval($_POST['term_id']);
$sids=$conn->query("SELECT id FROM result_students WHERE class_id=$cid AND is_active=1");
while($s=$sids->fetch_assoc()){
$sid=$s['id'];
$conn->query("INSERT INTO result_remarks (student_id,term_id,is_published) VALUES ($sid,$tid,1) ON DUPLICATE KEY UPDATE is_published=1");
}
$msg="All results published!";
}
$sel_class=intval($_GET['class_id']??0); $sel_term=intval($_GET['term_id']??0);
$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");
$students=[]; $remarks_map=[];
if($sel_class&&$sel_term){
$sr=$conn->query("SELECT id,first_name,last_name,roll_no FROM result_students WHERE class_id=$sel_class AND is_active=1 ORDER BY roll_no,first_name");
while($s=$sr->fetch_assoc()) $students[]=$s;
if(!empty($students)){
$sids=implode(',',array_column($students,'id'));
$rr=$conn->query("SELECT * FROM result_remarks WHERE student_id IN($sids) AND term_id=$sel_term");
while($r=$rr->fetch_assoc()) $remarks_map[$r['student_id']]=$r;
}
}
?>
Remarks & Publish | Result