<?php
declare(strict_types=1);
require_once __DIR__.'/../../authentication/api/connect.php';require_once __DIR__.'/../lib/graduation.php';require_once __DIR__.'/../lib/guidelines.php';
$GLOBALS['graduation_mode']=true;$user=require_auth();$manager=in_array($user['role'],['staff','admin','hod'],true);$method=$_SERVER['REQUEST_METHOD']??'GET';$action=$_GET['action']??'list';
try{
 if(!graduation_installed())reply(503,['message'=>'Graduation tables are missing in the database connected to SLPS. Import database/migrations/20261017_graduation_complete_repair.sql into that database.']);
 if(in_array($action,['create_requirement','workflow','upload'],true)){$issues=graduation_check_schema();if($issues)reply(503,['message'=>'The graduation database update is incomplete. Import database/migrations/20261017_graduation_complete_repair.sql into the database used by SLPS. Missing changes: '.implode(', ',$issues)]);}
 if($method==='GET'&&$action==='requirement'){$r=graduation_requirement($user,(int)($_GET['id']??0));$r['can_delete']=graduation_deletion_installed()&&graduation_can_delete($user,(int)$r['created_by']);reply(200,['requirement'=>$r]);}
 if($method==='GET'&&$action==='list'){
  [$where,$args]=graduation_scope($user);$q=db()->prepare('SELECT r.*,c.course_name,d.department_name,(SELECT GROUP_CONCAT(y.year_of_study ORDER BY y.year_of_study) FROM graduation_requirement_years y WHERE y.requirement_id=r.id) years FROM graduation_requirements r LEFT JOIN courses c ON c.id=r.course_id JOIN departments d ON d.id=r.department_id WHERE '.graduation_visible().' AND '.$where.' ORDER BY r.academic_period DESC,r.stage,r.id DESC LIMIT 200');$q->execute($args);$requirements=$q->fetchAll();foreach($requirements as &$r){$r['blocked']=graduation_block($user,$r);$r['can_delete']=graduation_deletion_installed()&&graduation_can_delete($user,(int)$r['created_by']);}unset($r);
  [$where,$args]=project_filter($user);$q=db()->prepare("SELECT p.id,p.title,p.description,p.technologies,p.archive_name,p.archive_type,p.created_at,COALESCE(NULLIF(u.full_name,''),u.username) full_name,c.course_name,d.department_name,g.status,g.attempt,r.stage FROM student_projects p JOIN graduation_submissions g ON g.project_id=p.id JOIN graduation_requirements r ON r.id=g.requirement_id JOIN users u ON u.id=p.student_user_id LEFT JOIN courses c ON c.id=p.course_id JOIN departments d ON d.id=p.department_id WHERE ".$where.' ORDER BY p.id DESC LIMIT 200');$q->execute($args);$projects=$q->fetchAll();$courses=[];
  $departments=[];if($manager){$where=$user['role']==='hod'?' AND EXISTS(SELECT 1 FROM hod_assignments h WHERE h.user_id=? AND h.department_id=d.id)':'';$q=db()->prepare('SELECT d.id,d.department_name FROM departments d WHERE d.is_active=1'.$where.' ORDER BY d.department_name');$q->execute($user['role']==='hod'?[$user['id']]:[]);$departments=$q->fetchAll();}
  reply(200,['projects'=>$projects,'courses'=>[],'departments'=>$departments,'requirements'=>$requirements,'can_manage'=>$manager,'can_submit'=>$user['role']==='student','capabilities'=>['zip'=>class_exists('ZipArchive'),'rar'=>class_exists('RarArchive')]]);
 }
 if($method==='POST'&&in_array($action,['delete_requirement','delete_submission'],true)){
  $data=post_data();if(!graduation_deletion_installed())reply(503,['message'=>'Import the graduation project deletion migration first.']);
  $id=(int)($data['id']??0);$reason=text_field($data,'reason',1000);if(strlen(trim($reason))<10)throw new InvalidArgumentException('Enter a deletion reason of at least 10 characters.');
  $db=db();$db->beginTransaction();try{
   if($action==='delete_requirement'){$r=graduation_requirement($user,$id);$type='requirement';}
   else{$p=project_get($user,$id);$q=$db->prepare('SELECT requirement_id FROM graduation_submissions WHERE project_id=?');$q->execute([$id]);$r=graduation_requirement($user,(int)$q->fetchColumn());$type='submission';}
   if(!graduation_can_delete($user,(int)$r['created_by']))throw new InvalidArgumentException('Only staff, admins or the instructor who created this project may delete it.');
   // Serialize with archive submission, which locks this same requirement row.
   $q=$db->prepare('SELECT id FROM graduation_requirements WHERE id=? FOR UPDATE');$q->execute([$r['id']]);$q->fetch();
   $db->prepare('INSERT INTO graduation_deleted_items(entity_type,entity_id,deleted_by,reason) VALUES(?,?,?,?)')->execute([$type,$id,$user['id'],$reason]);
   audit_event((int)$user['id'],$user['role'],'graduation_'.$type,$id,'delete',$reason);$db->commit();
  }catch(Throwable $e){if($db->inTransaction())$db->rollBack();throw $e;}
  reply(200,['message'=>$type==='requirement'?'Project removed together with its linked submissions.':'Student submission removed.']);
 }
 if($method==='POST'&&$action==='upload'){
  if(!hash_equals($_SESSION['csrf_token']??'',$_SERVER['HTTP_X_CSRF_TOKEN']??''))reply(403,['message'=>'Refresh the form and try again.']);if($user['role']!=='student')reply(403,['message'=>'Only students submit graduation projects.']);$r=graduation_requirement($user,(int)($_POST['requirement_id']??0));$blocked=graduation_block($user,$r);if($blocked)throw new InvalidArgumentException($blocked);$_POST['course_id']='';require __DIR__.'/student_projects.php';exit;
 }
 if($action==='create_requirement'||$action==='extend_deadline'){
  if($method!=='POST'||!$manager)reply(403,['message'=>'Only instructors manage requirements.']);$data=post_data(250000);$deadline=graduation_datetime($data['deadline']??null,true);
  if($action==='extend_deadline'){$r=graduation_requirement($user,(int)($data['requirement_id']??0));db()->prepare('UPDATE graduation_requirements SET deadline=? WHERE id=?')->execute([$deadline->format('Y-m-d H:i:s'),$r['id']]);audit_event((int)$user['id'],$user['role'],'graduation_requirement',(int)$r['id'],'change_deadline','Graduation project deadline updated');reply(200,['message'=>'Deadline updated.']);}
  $title=text_field($data,'title',160);$period=text_field($data,'academic_period',100);$description=text_field($data,'requirements',12000);$stage=(int)($data['stage']??0);$dept=(int)($data['department_id']??0);$delta=guideline_delta($data['requirements_delta']??null,0)['delta'];foreach($delta['ops'] as $op)if(!is_string($op['insert']))throw new InvalidArgumentException('Only text and document formatting are supported in graduation requirements.');$description=trim(implode('',array_column($delta['ops'],'insert')));if(strlen($description)>12000)throw new InvalidArgumentException('Requirements must be at most 12000 characters.');$years=array_values(array_unique(array_map('intval',is_array($data['years']??null)?$data['years']:[])));if(!$title||!$period||strlen($description)<20||$stage<1||$stage>3||!$years||array_diff($years,[1,2,3,4]))throw new InvalidArgumentException('Enter title, period, detailed requirements (20+ characters), stage and study years.');
  $q=db()->prepare('SELECT id FROM departments WHERE id=? AND is_active=1');$q->execute([$dept]);if(!$q->fetchColumn())throw new InvalidArgumentException('Choose an active department.');if($user['role']==='hod'){$q=db()->prepare('SELECT user_id FROM hod_assignments WHERE user_id=? AND department_id=?');$q->execute([$user['id'],$dept]);if(!$q->fetch())reply(403,['message'=>'Choose your assigned department.']);}
  $db=db();$db->beginTransaction();try{$db->prepare('INSERT INTO graduation_requirements(stage,title,academic_period,course_id,department_id,requirements,requirements_delta,deadline,created_by) VALUES(?,?,?,?,?,?,?,?,?)')->execute([$stage,$title,$period,null,$dept,$description,json_encode($delta,JSON_THROW_ON_ERROR),$deadline->format('Y-m-d H:i:s'),$user['id']]);$id=$db->lastInsertId();foreach($years as $year)$db->prepare('INSERT INTO graduation_requirement_years(requirement_id,year_of_study) VALUES(?,?)')->execute([$id,$year]);$db->prepare("INSERT INTO notifications(recipient_user_id,kind,title,message,link,created_by) SELECT s.user_id,'graduation',?,?,?,? FROM students s JOIN users u ON u.id=s.user_id WHERE s.department_id=? AND s.year_of_study IN (".implode(',',array_fill(0,count($years),'?')).") AND u.is_active=1")->execute(array_merge(['New graduation project: '.$title,$description,app_path().'/shared/views/modules/way-to-graduate.php',$user['id'],$dept],$years));audit_event((int)$user['id'],$user['role'],'graduation_requirement',$id,'publish_requirement',$title);$db->commit();}catch(Throwable $e){if($db->inTransaction())$db->rollBack();throw $e;}reply(201,['message'=>'Requirements published to the selected years across all campuses in the department.']);
 }
 if($action==='workflow'){
  $data=$method==='POST'?post_data(15000):$_GET;$p=project_get($user,(int)($data['id']??0));$q=db()->prepare('SELECT g.*,r.title requirement_title,r.stage,r.requirements,r.requirements_delta,r.deadline,r.academic_period FROM graduation_submissions g JOIN graduation_requirements r ON r.id=g.requirement_id WHERE g.project_id=?');$q->execute([$p['id']]);$workflow=$q->fetch();$root=project_root($p);
  if($method==='POST'){
   if(!$manager)reply(403,['message'=>'Only instructors can verify, record defence or decide projects.']);$lock=project_lock($root);try{$m=project_manifest($root);if(!$m['revision'])throw new InvalidArgumentException('Extract and inspect the project files before verification.');$db=db();$db->beginTransaction();try{$q=$db->prepare('SELECT * FROM graduation_submissions WHERE project_id=? FOR UPDATE');$q->execute([$p['id']]);$old=$q->fetch();if((int)($data['version']??-1)!==(int)$old['version']||(int)($data['revision']??-1)!==(int)$m['revision']){$db->rollBack();reply(409,['message'=>'The project or review changed. Reload and review it before deciding.']);}$decision=(string)($data['decision']??'');$reason=text_field($data,'reason',5000);$next=graduation_transition($old['status'],$decision,$reason);if($decision!=='verify'&&$decision!=='reject'&&(int)$old['reviewed_revision']!==(int)$m['revision'])throw new InvalidArgumentException('Project files changed after verification.');$defence=null;if(str_starts_with($decision,'defence_')){$defence=graduation_datetime($data['defence_at']??null,false)->format('Y-m-d H:i:s');}
    $db->prepare('UPDATE graduation_submissions SET status=?,reviewed_revision=?,version=version+1 WHERE project_id=?')->execute([$next,$m['revision'],$p['id']]);$db->prepare('INSERT INTO graduation_reviews(project_id,action,reason,defence_at,reviewed_by,reviewed_revision) VALUES(?,?,?,?,?,?)')->execute([$p['id'],$decision,$reason,$defence,$user['id'],$m['revision']]);$db->prepare("INSERT INTO notifications(recipient_user_id,kind,title,message,link,created_by) VALUES(?,'graduation',?,?,?,?)")->execute([$p['student_user_id'],'Graduation project: '.str_replace('_',' ',$next),$reason,app_path().'/shared/views/modules/way-to-graduate.php?project='.$p['id'],$user['id']]);audit_event((int)$user['id'],$user['role'],'graduation_project',(int)$p['id'],$decision,$reason);$db->commit();}catch(Throwable $e){if($db->inTransaction())$db->rollBack();throw $e;}}finally{flock($lock,LOCK_UN);fclose($lock);}reply(200,['message'=>'Review recorded and student notified.']);
  }
  $q=db()->prepare('SELECT r.*,COALESCE(u.full_name,u.username) reviewer_name FROM graduation_reviews r JOIN users u ON u.id=r.reviewed_by WHERE r.project_id=? ORDER BY r.id DESC');$q->execute([$p['id']]);reply(200,['workflow'=>$workflow,'history'=>$q->fetchAll(),'can_review'=>$manager,'can_delete'=>graduation_deletion_installed()&&graduation_can_delete($user,(int)graduation_requirement($user,(int)$workflow['requirement_id'])['created_by']),'revision'=>project_manifest($root)['revision']]);
 }
 if($action==='grade'){if($method==='GET')reply(200,['grade'=>null,'can_grade'=>false]);reply(403,['message'=>'Use the graduation verification and defence workflow.']);}
 if(!in_array($action,['project','tree','extract','file','download','original','export','save'],true))reply(400,['message'=>'Unknown graduation project action.']);
 require __DIR__.'/student_projects.php';
}catch(InvalidArgumentException $e){reply(422,['message'=>$e->getMessage()]);}catch(Throwable $e){$reference='GRAD-'.bin2hex(random_bytes(4));error_log('Way to graduate ['.$reference.'] action='.$action.' code='.$e->getCode().' '.$e->getMessage());reply(503,['message'=>graduation_error_message($e,$reference)]);}
