<?php
declare(strict_types=1);
require_once __DIR__.'/../lib/papers.php';$user=require_auth();
try{
 $action=$_GET['action']??'list';$method=$_SERVER['REQUEST_METHOD']??'GET';
 if($method==='GET'&&$action==='list'){
  [$where,$args]=paper_scope($user);$q=db()->prepare('SELECT p.id,p.course_code,p.exam_year,p.semester,p.uploaded_at,p.paper_file_id,p.solution_file_id,c.course_name,d.department_name,f.file_name,f.storage_key,f.file_size_bytes,s.file_name AS solution_name,s.storage_key AS solution_key FROM past_papers p JOIN courses c ON c.id=p.course_id JOIN departments d ON d.id=p.department_id JOIN file_assets f ON f.id=p.paper_file_id LEFT JOIN file_assets s ON s.id=p.solution_file_id WHERE '.$where.' ORDER BY p.exam_year DESC,p.id DESC LIMIT 300');$q->execute($args);$papers=$q->fetchAll();foreach($papers as &$p){$p['extension']=strtolower(pathinfo($p['storage_key'],PATHINFO_EXTENSION));$p['solution_extension']=$p['solution_key']?strtolower(pathinfo($p['solution_key'],PATHINFO_EXTENSION)):null;unset($p['storage_key'],$p['solution_key']);}unset($p);reply(200,['papers'=>$papers,'can_upload'=>in_array($user['role'],['staff','hod'],true),'can_solution'=>in_array($user['role'],['admin','staff','hod'],true),'departments'=>$user['role']==='staff'?db()->query('SELECT id,department_name FROM departments WHERE is_active=1 ORDER BY department_name')->fetchAll():[],'campuses'=>$user['role']==='staff'?db()->query('SELECT id,campus_name FROM campuses WHERE is_active=1 ORDER BY campus_name')->fetchAll():[],'limit'=>300]);
 }
 if($method==='GET'&&$action==='document'){
  $kind=($_GET['kind']??'paper')==='solution'?'solution':'paper';$p=paper_get($user,(int)($_GET['id']??0));$f=paper_asset($user,(int)$p['id'],$kind);reply(200,['paper'=>$p,'filename'=>$f['file_name'],'extension'=>pathinfo($f['storage_key'],PATHINFO_EXTENSION)]);
 }
 if($method==='POST'&&$action==='solution'){
  if(!in_array($user['role'],['admin','staff','hod'],true))reply(403,['message'=>'Only administrators and assigned HODs can publish solutions.']);if(!hash_equals($_SESSION['csrf_token']??'',$_SERVER['HTTP_X_CSRF_TOKEN']??''))reply(403,['message'=>'Refresh and try again.']);$p=paper_get($user,(int)($_POST['paper_id']??0));$file=$_FILES['solution_file']??null;
  if(!$file||$file['error']!==UPLOAD_ERR_OK||$file['size']<1||$file['size']>20971520)throw new InvalidArgumentException('Select a solution document up to 20 MB.');$ext=strtolower(pathinfo($file['name'],PATHINFO_EXTENSION));if(!in_array($ext,['pdf','doc','docx'],true))throw new InvalidArgumentException('Use PDF, DOC or DOCX.');$sig=file_get_contents($file['tmp_name'],false,null,0,8);if(($ext==='pdf'&&!str_starts_with($sig,'%PDF-'))||($ext==='doc'&&!str_starts_with($sig,"\xd0\xcf\x11\xe0"))||($ext==='docx'&&!str_starts_with($sig,"PK\x03\x04")))throw new InvalidArgumentException('The document does not match its file type.');
  $q=db()->prepare('SELECT campus_id FROM file_assets WHERE id=?');$q->execute([$p['paper_file_id']]);$campus=$q->fetchColumn();$root=private_storage_root().'/papers';if(!is_dir($root)&&!mkdir($root,0750,true))throw new RuntimeException('Storage unavailable.');$key=bin2hex(random_bytes(20)).'.'.$ext;if(!move_uploaded_file($file['tmp_name'],$root.'/'.$key))throw new RuntimeException('Upload failed.');
  try{db()->beginTransaction();$q=db()->prepare('SELECT solution_file_id FROM past_papers WHERE id=? FOR UPDATE');$q->execute([$p['id']]);$current=$q->fetchColumn();if((int)$current!==(int)($_POST['expected_solution']??0)){db()->rollBack();@unlink($root.'/'.$key);reply(409,['message'=>'Another solution was published. Refresh the library before replacing it.']);}
   $mime=['pdf'=>'application/pdf','doc'=>'application/msword','docx'=>'application/vnd.openxmlformats-officedocument.wordprocessingml.document'][$ext];$q=db()->prepare("INSERT INTO file_assets(file_name,storage_key,media_type,file_size_bytes,file_category,department_id,campus_id,uploaded_by) VALUES (?,?,?,?,'solution',?,?,?)");$q->execute([basename(str_replace('\\','/',$file['name'])),$key,$mime,$file['size'],$p['department_id'],$campus,$user['id']]);$id=db()->lastInsertId();$q=db()->prepare('UPDATE past_papers SET solution_file_id=? WHERE id=?');$q->execute([$id,$p['id']]);db()->commit();
  }catch(Throwable $e){if(db()->inTransaction())db()->rollBack();@unlink($root.'/'.$key);throw $e;}reply(201,['message'=>'Solution published.']);
 }
 reply(405,['message'=>'Unsupported action.']);
}catch(InvalidArgumentException $e){reply(422,['message'=>$e->getMessage()]);}catch(Throwable $e){error_log('SLPS papers: '.$e->getMessage());reply(503,['message'=>'The paper library is unavailable. Check the database and document storage.']);}
