<?php
declare(strict_types=1);
require_once __DIR__.'/../../authentication/api/connect.php';require_once __DIR__.'/../lib/practical_exams.php';
$user=require_auth();$editor=in_array($user['role'],['staff','admin','hod'],true);
try{
 $method=$_SERVER['REQUEST_METHOD']??'GET';$action=$_GET['action']??'list';
 if($method==='GET'&&$action==='list'){
  [$where,$args]=practical_exam_scope($user);$q=db()->prepare('SELECT e.*,c.course_name,c.course_code,ca.campus_name,(SELECT COUNT(*) FROM practical_exam_results r WHERE r.exam_id=e.id) candidates,(SELECT COUNT(*) FROM practical_exam_results r WHERE r.exam_id=e.id AND r.published_at IS NOT NULL) published FROM practical_exams e JOIN courses c ON c.id=e.course_id JOIN campuses ca ON ca.id=e.campus_id WHERE '.$where.' ORDER BY e.id DESC LIMIT 200');$q->execute($args);$exams=$q->fetchAll();$courses=[];$campuses=[];
  if($editor){$params=[];$filter='';if($user['role']==='hod'){$filter=' AND EXISTS(SELECT 1 FROM hod_assignments h WHERE h.user_id=? AND h.department_id=c.department_id)';$params=[$user['id']];}$q=db()->prepare('SELECT c.id,c.course_name,c.course_code,d.department_name FROM courses c JOIN departments d ON d.id=c.department_id WHERE c.is_active=1 AND d.is_active=1'.$filter.' ORDER BY c.course_code');$q->execute($params);$courses=$q->fetchAll();$sql='SELECT ca.id,ca.campus_name FROM campuses ca WHERE ca.is_active=1';$params=[];if($user['role']==='hod'){$sql.=' AND EXISTS(SELECT 1 FROM hod_assignments h WHERE h.user_id=? AND h.campus_id=ca.id)';$params=[$user['id']];}$q=db()->prepare($sql.' ORDER BY ca.campus_name');$q->execute($params);$campuses=$q->fetchAll();}
  reply(200,['exams'=>$exams,'can_edit'=>$editor,'editable_components'=>practical_exam_components($user),'can_publish'=>$user['role']==='staff','courses'=>$courses,'campuses'=>$campuses]);
 }
 if($method==='GET'&&$action==='sheet'){
  $exam=practical_exam_get($user,(int)($_GET['id']??0));$sql='SELECT r.*,COALESCE(NULLIF(u.full_name,\'\'),u.username) full_name,COALESCE(g.full_name,g.username) grader_name FROM practical_exam_results r JOIN users u ON u.id=r.student_user_id LEFT JOIN users g ON g.id=r.graded_by WHERE r.exam_id=?';$args=[$exam['id']];if(!$editor){$sql.=' AND r.student_user_id=? AND r.published_at IS NOT NULL';$args[]=$user['id'];}$q=db()->prepare($sql.' ORDER BY r.student_number');$q->execute($args);$rows=$q->fetchAll();foreach($rows as &$row)$row=array_merge($row,practical_exam_grade($row));unset($row);$q=db()->prepare('SELECT m.*,COALESCE(u.full_name,u.username) grader_name FROM practical_exam_components m JOIN users u ON u.id=m.graded_by WHERE m.exam_id=?');$q->execute([$exam['id']]);$meta=[];foreach($q->fetchAll() as $entry){if($editor||(int)$entry['student_user_id']===(int)$user['id'])$meta[$entry['student_user_id']][$entry['component']]=$entry;}foreach($rows as &$row)$row['components']=$meta[$row['student_user_id']]??[];unset($row);reply(200,['exam'=>$exam,'rows'=>$rows,'can_edit'=>$editor,'editable_components'=>practical_exam_components($user),'can_publish'=>$user['role']==='staff']);
 }
 if($method!=='POST')reply(405,['message'=>'Use GET or POST.']);$data=post_data(20000);if(!$editor)reply(403,['message'=>'Only staff, administrators and HODs may enter results.']);$db=db();
 if($action==='create'){
  $title=text_field($data,'title',160);$period=text_field($data,'academic_period',100);$course=(int)($data['course_id']??0);$campus=(int)($data['campus_id']??0);$year=(int)($data['year_of_study']??0);if(!$title||!$period||$year<0||$year>4)throw new InvalidArgumentException('Enter an examination title, period and a valid year of study.');
  $q=$db->prepare('SELECT c.department_id FROM courses c JOIN departments d ON d.id=c.department_id WHERE c.id=? AND c.is_active=1 AND d.is_active=1');$q->execute([$course]);$department=$q->fetchColumn();if(!$department)throw new InvalidArgumentException('Choose an active course.');$q=$db->prepare('SELECT id FROM campuses WHERE id=? AND is_active=1');$q->execute([$campus]);if(!$q->fetch())throw new InvalidArgumentException('Choose an active campus.');
  if($user['role']==='hod'){$q=$db->prepare('SELECT user_id FROM hod_assignments WHERE user_id=? AND department_id=? AND campus_id=?');$q->execute([$user['id'],$department,$campus]);if(!$q->fetch())reply(403,['message'=>'Choose your assigned department and campus.']);}
  $db->beginTransaction();try{$db->prepare('INSERT INTO practical_exams(title,academic_period,course_id,department_id,campus_id,year_of_study,created_by) VALUES(?,?,?,?,?,?,?)')->execute([$title,$period,$course,$department,$campus,$year?:null,$user['id']]);$id=$db->lastInsertId();$q=$db->prepare("INSERT INTO practical_exam_results(exam_id,student_user_id,student_number) SELECT ?,s.user_id,s.student_number FROM students s JOIN users u ON u.id=s.user_id WHERE s.department_id=? AND s.campus_id=? AND s.status='active' AND u.is_active=1".($year?' AND s.year_of_study=?':''));$args=[$id,$department,$campus];if($year)$args[]=$year;$q->execute($args);if(!$q->rowCount())throw new InvalidArgumentException('No active students match this department, campus and year.');audit_event((int)$user['id'],$user['role'],'practical_exam',$id,'create_exam',$title);$db->commit();}catch(Throwable $e){if($db->inTransaction())$db->rollBack();throw $e;}reply(201,['id'=>$id,'message'=>'Examination sheet created.']);
 }
 if(!in_array($action,['save_component','publish'],true))reply(400,['message'=>'Use the separate Level 1, Level 2 or Final entry sheet.']);
 $publish=$action==='publish';if($publish&&$user['role']!=='staff')reply(403,['message'=>'Only staff can publish the final combined result.']);
 if(!$publish&&!in_array((string)($data['component']??''),practical_exam_components($user),true))reply(403,['message'=>'You cannot enter this stage. Final examination entry is staff-only.']);
 $exam=practical_exam_get($user,(int)($data['id']??0));$student=(int)($data['student_user_id']??0);$feedback=text_field($data,'feedback',2000);
 $db->beginTransaction();try{$q=$db->prepare('SELECT * FROM practical_exam_results WHERE exam_id=? AND student_user_id=? FOR UPDATE');$q->execute([$exam['id'],$student]);$old=$q->fetch();if(!$old)throw new InvalidArgumentException('Student is not on this examination roster.');if((int)($data['revision']??-1)!==(int)$old['revision']){$db->rollBack();reply(409,['message'=>'This result changed elsewhere. Reload the sheet before saving.']);}
  if($publish){$marks=practical_exam_marks($old,true);$db->prepare('UPDATE practical_exam_results SET revision=revision+1,graded_by=?,published_at=UTC_TIMESTAMP() WHERE exam_id=? AND student_user_id=?')->execute([$user['id'],$exam['id'],$student]);}
  else{
   $marks=practical_exam_component_update($user,$old,$data);$component=(string)$data['component'];
   $db->prepare('UPDATE practical_exam_results SET '.$component.'=?,revision=revision+1,graded_by=?,published_at=NULL WHERE exam_id=? AND student_user_id=?')->execute([$marks[$component],$user['id'],$exam['id'],$student]);
   $db->prepare('INSERT INTO practical_exam_components(exam_id,student_user_id,component,feedback,graded_by) VALUES(?,?,?,?,?) ON DUPLICATE KEY UPDATE feedback=VALUES(feedback),graded_by=VALUES(graded_by),updated_at=CURRENT_TIMESTAMP')->execute([$exam['id'],$student,$component,$feedback?:null,$user['id']]);
  }
  if($publish){$grade=practical_exam_grade($marks);$link=app_path().'/shared/views/modules/practical-examinations.php?exam='.$exam['id'];$db->prepare("INSERT INTO notifications(recipient_user_id,kind,title,message,link,created_by) VALUES(?,'grade',?,?,?,?)")->execute([$student,'Practical examination results',$exam['title'].': '.$grade['total'].'% ('.$grade['band'].'). Open your examination result for the breakdown.',$link,$user['id']]);}
  audit_event((int)$user['id'],$user['role'],'practical_exam',(int)$exam['id'],$publish?'publish_result':'save_'.(string)$data['component'],'Student user '.$student.' '.($publish?'combined result published':(string)$data['component'].' updated'));$db->commit();
 }catch(Throwable $e){if($db->inTransaction())$db->rollBack();throw $e;}reply(200,['revision'=>(int)$old['revision']+1,'updated_at'=>gmdate('Y-m-d H:i:s'),'grader_name'=>$user['full_name']?:$user['username'],'message'=>$publish?'Result published. Student notified.':'Stage saved separately. Other stage marks were preserved. Staff can publish once all three marks are complete.']);
}catch(InvalidArgumentException $e){reply(422,['message'=>$e->getMessage()]);}catch(Throwable $e){error_log('Practical exams: '.$e->getMessage());reply(503,['message'=>'Examinations are unavailable. Check the practical examination migration and database connection.']);}
