<?php
declare(strict_types=1);
require_once __DIR__.'/../lib/guidelines.php';
$user=require_auth();$scope=guideline_scope($user);$db=db();
try {
 if(($_SERVER['REQUEST_METHOD']??'GET')==='POST'){
  $data=post_data(1200000);if(!$scope['can_edit'])reply(403,['status'=>'error','message'=>'Your account has read-only access to published guidelines.']);
  $action=(string)($data['action']??'');
  if($action==='create_course'){
   $department=$scope['department_id']??(int)($data['department_id']??0);
   $q=$db->prepare('SELECT id FROM departments WHERE id=? AND is_active=1');$q->execute([$department]);if(!$q->fetch())reply(422,['status'=>'error','message'=>'Choose an active department.']);
   $code=strtoupper(text_field($data,'course_code',40));$name=text_field($data,'course_name',180);$year=(int)($data['year_of_study']??0);
   if($code===''||$name===''||$year<0||$year>4)reply(422,['status'=>'error','message'=>'Enter a course code and name, and a valid year.']);
   $db->prepare('INSERT INTO courses(department_id,course_code,course_name,year_of_study) VALUES(?,?,?,?)')->execute([$department,$code,$name,$year?:null]);
   reply(201,['status'=>'success','message'=>'Course created. Open it to write practical guidelines.','course_id'=>$db->lastInsertId()]);
  }
  if(!in_array($action,['save_draft','publish'],true))reply(400,['status'=>'error','message'=>'Unknown guidelines action.']);
  $course=guideline_course($scope,(int)($data['course_id']??0));$courseId=(int)$course['id'];
  $document=guideline_delta($data['delta']??null,$courseId);$ids=guideline_ids($data['attachment_ids']??[]);
  $assets=guideline_assets($courseId,$ids);if(count($assets)!==count($ids))reply(422,['status'=>'error','message'=>'An attachment does not belong to this course.']);
  foreach($assets as $asset)if($asset['asset_kind']!=='attachment')reply(422,['status'=>'error','message'=>'Choose document attachments from this course.']);
  if(!array_key_exists('revision',$data)||!is_numeric($data['revision']))reply(422,['status'=>'error','message'=>'Reload the course before saving.']);
  $encoded=json_encode($document['delta'],JSON_THROW_ON_ERROR|JSON_UNESCAPED_SLASHES);$attachmentJson=json_encode($ids,JSON_THROW_ON_ERROR);
  $db->beginTransaction();
  $q=$db->prepare('SELECT id FROM courses WHERE id=? FOR UPDATE');$q->execute([$courseId]);
  $q=$db->prepare('SELECT revision FROM course_guidelines WHERE course_id=? FOR UPDATE');$q->execute([$courseId]);$current=$q->fetch();
  if((int)($current['revision']??0)!==(int)$data['revision']){$db->rollBack();reply(409,['status'=>'error','message'=>'Another editor saved changes. Copy your work, reload this course, and review before saving.']);}
  $revision=(int)($current['revision']??0)+1;
  if($current)$db->prepare('UPDATE course_guidelines SET draft_delta=?,draft_attachment_ids=?,revision=?,updated_by=?,updated_at=UTC_TIMESTAMP() WHERE course_id=?')->execute([$encoded,$attachmentJson,$revision,(int)$user['id'],$courseId]);
  else $db->prepare('INSERT INTO course_guidelines(course_id,draft_delta,draft_attachment_ids,revision,updated_by) VALUES(?,?,?,?,?)')->execute([$courseId,$encoded,$attachmentJson,$revision,(int)$user['id']]);
  if($action==='publish'){
   $db->prepare('UPDATE course_guidelines SET published_delta=?,published_attachment_ids=?,published_revision=?,published_at=UTC_TIMESTAMP() WHERE course_id=?')->execute([$encoded,$attachmentJson,$revision,$courseId]);
   $db->prepare('UPDATE guideline_assets SET is_published=0 WHERE course_id=?')->execute([$courseId]);
   $public=array_values(array_unique(array_merge($ids,$document['image_ids'])));
   if($public)$db->prepare('UPDATE guideline_assets SET is_published=1 WHERE course_id=? AND id IN ('.implode(',',array_fill(0,count($public),'?')).')')->execute(array_merge([$courseId],$public));
  }
  $db->commit();reply(200,['status'=>'success','message'=>$action==='publish'?'Guidelines published to students in this department.':'Draft saved. Students continue to see the last published version.','revision'=>$revision,'published'=>$action==='publish']);
 }
 if(($_SERVER['REQUEST_METHOD']??'GET')!=='GET')reply(405,['status'=>'error','message'=>'Use GET or POST.']);
 if(isset($_GET['course_id'])){
  $course=guideline_course($scope,(int)$_GET['course_id']);$q=$db->prepare('SELECT * FROM course_guidelines WHERE course_id=?');$q->execute([(int)$course['id']]);$guide=$q->fetch();$editor=$scope['can_edit'];
  $publishedView=!$editor||($_GET['version']??'draft')==='published';
  $raw=$guide?($publishedView?$guide['published_delta']:$guide['draft_delta']):null;
  $ids=$guide?json_decode((string)($publishedView?($guide['published_attachment_ids']??'[]'):$guide['draft_attachment_ids']),true):[];
  reply(200,['status'=>'success','course'=>$course,'can_edit'=>$editor,'delta'=>$raw?json_decode($raw,true):['ops'=>[['insert'=>"\n"]]],'attachments'=>guideline_assets((int)$course['id'],$ids??[]),'revision'=>$editor?(int)($guide['revision']??0):0,'published_revision'=>$guide['published_revision']??null,'published_at'=>$guide['published_at']??null,'updated_at'=>$editor?($guide['updated_at']??null):null,'has_content'=>(bool)$raw]);
 }
 $department=$scope['department_id']??(int)($_GET['department_id']??0);
 $q=$db->prepare('SELECT id,department_name FROM departments WHERE is_active=1'.($scope['department_id']!==null?' AND id=?':'').' ORDER BY department_name');$q->execute($scope['department_id']!==null?[$scope['department_id']]:[]);$departments=$q->fetchAll();
 $sql='SELECT c.*,d.department_name,g.revision,g.published_revision,g.published_at,g.updated_at FROM courses c JOIN departments d ON d.id=c.department_id LEFT JOIN course_guidelines g ON g.course_id=c.id WHERE c.is_active=1 AND d.is_active=1';$params=[];
 if($department){$sql.=' AND c.department_id=?';$params[]=$department;}$q=$db->prepare($sql.' ORDER BY c.course_code');$q->execute($params);$courses=$q->fetchAll();
 if(!$scope['can_edit'])foreach($courses as &$row){unset($row['revision'],$row['updated_at']);}
 reply(200,['status'=>'success','can_edit'=>$scope['can_edit'],'department_id'=>$department?:null,'departments'=>$departments,'courses'=>$courses]);
}catch(InvalidArgumentException $error){if($db->inTransaction())$db->rollBack();reply(422,['status'=>'error','message'=>$error->getMessage()]);}
catch(Throwable $error){if($db->inTransaction())$db->rollBack();error_log('Guidelines: '.$error->getMessage());$code=(int)$error->getCode();reply($code===1062?409:503,['status'=>'error','message'=>$code===1146?'Practical Guidelines needs its database update. Run database/migrations/20261015_practical_guidelines.sql.':($code===1062?'That course code already exists in this department.':'Guidelines could not be saved or loaded. Please try again.')]);}
