<?php
declare(strict_types=1);
require_once __DIR__ . '/../../authentication/api/connect.php';
$user=require_auth();start_auth_session();if(!hash_equals($_SESSION['csrf_token']??'',$_SERVER['HTTP_X_CSRF_TOKEN']??''))reply(403,['status'=>'error','message'=>'Refresh and try again.']);
if(($_SERVER['REQUEST_METHOD']??'')!=='POST')reply(405,['status'=>'error','message'=>'Use POST.']);
if(($_POST['upload_kind']??'')==='department_file'){
 $file=$_FILES['department_file']??null;if(!$file||$file['error']!==UPLOAD_ERR_OK)reply(422,['status'=>'error','message'=>'Choose a file to upload.']);
 if((int)$file['size']<1||(int)$file['size']>20*1024*1024)reply(422,['status'=>'error','message'=>'Shared files must be smaller than 20 MB.']);
 $ext=strtolower(pathinfo((string)$file['name'],PATHINFO_EXTENSION));$allowedExt=['pdf','doc','docx','xls','xlsx','ppt','pptx','csv','txt','jpg','jpeg','png','zip'];if(!in_array($ext,$allowedExt,true))reply(422,['status'=>'error','message'=>'This file type is not supported.']);
 $mime=(new finfo(FILEINFO_MIME_TYPE))->file($file['tmp_name'])?:'application/octet-stream';$allowedMime=['application/pdf','application/msword','application/vnd.openxmlformats-officedocument.wordprocessingml.document','application/vnd.ms-excel','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet','application/vnd.ms-powerpoint','application/vnd.openxmlformats-officedocument.presentationml.presentation','text/csv','text/plain','image/jpeg','image/png','application/zip','application/x-zip-compressed','application/octet-stream'];if(!in_array($mime,$allowedMime,true))reply(422,['status'=>'error','message'=>'The uploaded file does not match an accepted document type.']);
 $departmentId=0;$campusId=null;$db=db();
 if($user['role']==='hod'){$q=$db->prepare('SELECT department_id,campus_id FROM hod_assignments WHERE user_id=?');$q->execute([(int)$user['id']]);$scope=$q->fetch();if(!$scope)reply(403,['status'=>'error','message'=>'Your HOD department assignment is unavailable.']);$departmentId=(int)$scope['department_id'];}
 elseif($user['role']==='student'){$q=$db->prepare('SELECT department_id,campus_id FROM students WHERE user_id=?');$q->execute([(int)$user['id']]);$scope=$q->fetch();if(!$scope)reply(403,['status'=>'error','message'=>'Your student department assignment is unavailable.']);$departmentId=(int)$scope['department_id'];}
 elseif(in_array($user['role'],['admin','staff'],true)){$departmentId=(int)($_POST['department_id']??0);if($departmentId<1)reply(422,['status'=>'error','message'=>'Choose a department for this shared file.']);$q=$db->prepare('SELECT 1 FROM departments WHERE id=? AND is_active=1');$q->execute([$departmentId]);if(!$q->fetch())reply(404,['status'=>'error','message'=>'Department not found or inactive.']);}
 else reply(403,['status'=>'error','message'=>'Your account cannot upload department files.']);
 $root=private_storage_root().'/department-files';if(!is_dir($root)&&!mkdir($root,0750,true)&&!is_dir($root))reply(503,['status'=>'error','message'=>'Secure file storage is unavailable.']);$key=bin2hex(random_bytes(20)).'.'.$ext;if(!move_uploaded_file($file['tmp_name'],$root.'/'.$key))reply(503,['status'=>'error','message'=>'Could not save the uploaded file.']);
 $name=trim((string)($_POST['display_name']??''));if($name==='')$name=basename((string)$file['name']);$db->prepare("INSERT INTO file_assets(file_name,storage_key,media_type,file_size_bytes,file_category,department_id,campus_id,uploaded_by) VALUES(?,?,?,?,'department_file',?,NULL,?)")->execute([substr($name,0,255),$key,$mime,(int)$file['size'],$departmentId,(int)$user['id']]);$fileId=$db->lastInsertId();audit_event((int)$user['id'],(string)$user['role'],'file_asset',$fileId,'upload','Uploaded a department file');reply(201,['status'=>'success','message'=>'File uploaded and shared with the department.','file_id'=>$fileId]);
}
if(($_POST['upload_kind']??'')==='past_paper'){
 if(!in_array($user['role'],['hod','staff'],true))reply(403,['message'=>'Only staff and HODs can upload papers.']);
 if($user['role']==='staff'){
  $scope=['department_id'=>(int)($_POST['department_id']??0),'campus_id'=>(int)($_POST['campus_id']??0)];
  foreach(['departments'=>'department_id','campuses'=>'campus_id'] as $table=>$field){$q=db()->prepare('SELECT id FROM '.$table.' WHERE id=? AND is_active=1');$q->execute([$scope[$field]]);if(!$q->fetch())reply(422,['message'=>'Choose an active department and campus.']);}
 }else{$q=db()->prepare('SELECT department_id,campus_id FROM hod_assignments WHERE user_id=?');$q->execute([(int)$user['id']]);$scope=$q->fetch();if(!$scope)reply(403,['message'=>'HOD assignment is unavailable.']);}

 $code=strtoupper(trim((string)($_POST['course_code']??'')));$year=(int)($_POST['exam_year']??0);$semester=trim((string)($_POST['semester']??''));$paper=$_FILES['paper_file']??null;$solution=$_FILES['solution_file']??null;if($code===''||$year<2000||$year>(int)date('Y')+1||$semester===''||!$paper||$paper['error']!==UPLOAD_ERR_OK)reply(422,['status'=>'error','message'=>'Enter course code, exam year, semester and choose the past paper file.']);
 if(!class_exists(ZipArchive::class)){}$root=private_storage_root().'/papers';if(!is_dir($root)&&!mkdir($root,0750,true)&&!is_dir($root))reply(503,['status'=>'error','message'=>'Secure file storage is unavailable.']);$mime=new finfo(FILEINFO_MIME_TYPE);
 $store=static function(array $f,string $category) use($root,$mime,$scope,$user):int {if($f['error']!==UPLOAD_ERR_OK||$f['size']>20*1024*1024)throw new RuntimeException('Paper files must be smaller than 20 MB.');$ext=strtolower(pathinfo((string)$f['name'],PATHINFO_EXTENSION));if(!in_array($ext,['pdf','doc','docx'],true))throw new RuntimeException('Paper files must use PDF, DOC or DOCX format.');$type=$mime->file($f['tmp_name'])?:'application/octet-stream';if(!in_array($type,['application/pdf','application/msword','application/vnd.openxmlformats-officedocument.wordprocessingml.document','application/zip','application/octet-stream'],true))throw new RuntimeException('Unsupported paper file type.');$key=bin2hex(random_bytes(20)).'.'.$ext;if(!move_uploaded_file($f['tmp_name'],$root.'/'.$key))throw new RuntimeException('Could not store paper file.');db()->prepare('INSERT INTO file_assets(file_name,storage_key,media_type,file_size_bytes,file_category,department_id,campus_id,uploaded_by) VALUES(?,?,?,?,?,?,?,?)')->execute([basename((string)$f['name']),$key,$type,(int)$f['size'],$category,(int)$scope['department_id'],(int)$scope['campus_id'],(int)$user['id']]);return db()->lastInsertId();};
 try{$paperId=$store($paper,'past_paper');$solutionId=$solution&&$solution['error']===UPLOAD_ERR_OK?$store($solution,'solution'):null;$db=db();$db->prepare('INSERT INTO courses(department_id,course_code,course_name) VALUES(?,?,?) ON DUPLICATE KEY UPDATE id=LAST_INSERT_ID(id)')->execute([(int)$scope['department_id'],$code,$code]);$courseId=$db->lastInsertId();$db->prepare('INSERT INTO past_papers(department_id,course_id,course_code,exam_year,semester,paper_file_id,solution_file_id,uploaded_by) VALUES(?,?,?,?,?,?,?,?)')->execute([(int)$scope['department_id'],$courseId,$code,$year,$semester,$paperId,$solutionId,(int)$user['id']]);audit_event((int)$user['id'],(string)$user['role'],'past_paper',$db->lastInsertId(),'upload','Uploaded a past paper',(int)$scope['campus_id']);reply(201,['status'=>'success','message'=>'Past paper uploaded.']);}catch(Throwable $e){reply(422,['status'=>'error','message'=>$e->getMessage()]);}
}
if($user['role']!=='student')reply(403,['status'=>'error','message'=>'This upload is unavailable for your role.']);
$sid=(int)$user['id'];$q=db()->prepare('SELECT id,department_id,campus_id FROM students WHERE user_id=?');$q->execute([$sid]);$student=$q->fetch();if(!$student)reply(403,['status'=>'error','message'=>'Student profile unavailable.']);
$assignment=(int)($_POST['assignment_id']??0);$q=db()->prepare('SELECT a.id FROM project_assignments a JOIN practical_projects p ON p.id=a.project_id WHERE a.id=? AND a.student_id=? AND p.department_id=? AND p.campus_id=?');$q->execute([$assignment,(int)$student['id'],(int)$student['department_id'],(int)$student['campus_id']]);if(!$q->fetch())reply(404,['status'=>'error','message'=>'Assignment not found for your account.']);
$file=$_FILES['project_zip']??null;if(!$file||$file['error']!==UPLOAD_ERR_OK)reply(422,['status'=>'error','message'=>'Choose a ZIP file smaller than 25 MB.']);if($file['size']<22||$file['size']>25*1024*1024||strtolower(pathinfo($file['name'],PATHINFO_EXTENSION))!=='zip')reply(422,['status'=>'error','message'=>'Only ZIP files up to 25 MB are accepted.']);if(!class_exists(ZipArchive::class))reply(503,['status'=>'error','message'=>'PHP ZipArchive must be enabled to validate project submissions.']);
$zip=new ZipArchive();if($zip->open($file['tmp_name'])!==true)reply(422,['status'=>'error','message'=>'The uploaded file is not a readable ZIP archive.']);$entries=[];$total=0;if($zip->numFiles>2000){$zip->close();reply(422,['status'=>'error','message'=>'ZIP contains too many files.']);}
for($i=0;$i<$zip->numFiles;$i++){ $st=$zip->statIndex($i);if(!$st)continue;$path=(string)$st['name'];$parts=preg_split('~[/\\\\]+~',$path);if(str_starts_with($path,'/')||preg_match('/^[A-Za-z]:/',$path)||in_array('..',$parts,true)||str_contains($path,"\0")){ $zip->close();reply(422,['status'=>'error','message'=>'ZIP contains an unsafe file path.']);}if(str_ends_with($path,'/'))continue;$total+=(int)$st['size'];if($total>60*1024*1024){$zip->close();reply(422,['status'=>'error','message'=>'ZIP expands beyond the allowed 60 MB.']);}$entries[]=[$path,$i,(int)$st['size']]; }
if(!$entries){$zip->close();reply(422,['status'=>'error','message'=>'ZIP contains no files.']);}
$root=private_storage_root().'/submissions';if(!is_dir($root)&&!mkdir($root,0750,true)&&!is_dir($root)){ $zip->close();reply(503,['status'=>'error','message'=>'Secure file storage is unavailable.']); }
$key=bin2hex(random_bytes(20)).'.zip';$dest=$root.'/'.$key;if(!move_uploaded_file($file['tmp_name'],$dest)){ $zip->close();reply(503,['status'=>'error','message'=>'Could not store your submission.']); }
$db=db();$db->beginTransaction();try{$db->prepare("INSERT INTO file_assets(file_name,storage_key,media_type,file_size_bytes,file_category,department_id,campus_id,uploaded_by) VALUES(?,?, 'application/zip',?,'submission',?,?,?)")->execute([basename((string)$file['name']),$key,(int)$file['size'],(int)$student['department_id'],(int)$student['campus_id'],$sid]);$fid=$db->lastInsertId();$db->prepare("INSERT INTO project_submissions(assignment_id,submitted_by,zip_file_id,validation_state,validation_message) VALUES(?,?,?,'valid','ZIP paths and size checked')")->execute([$assignment,(int)$student['id'],$fid]);$subId=$db->lastInsertId();$extract=$root.'/'.$subId;if(!mkdir($extract,0750)&&!is_dir($extract))throw new RuntimeException('Cannot prepare private extraction folder.');$stmt=$db->prepare('INSERT INTO extracted_submission_files(submission_id,relative_path,media_type,storage_key,file_size_bytes) VALUES(?,?,?,?,?)');$mime=new finfo(FILEINFO_MIME_TYPE);foreach($entries as [$path,$index,$size]){$normal=str_replace('\\','/',$path);$target=$extract.'/'.$normal;$parent=dirname($target);if(!is_dir($parent)&&!mkdir($parent,0750,true)&&!is_dir($parent))throw new RuntimeException('Cannot prepare extraction folder.');$stream=$zip->getStream($path);$out=fopen($target,'wb');if(!$stream||!$out)throw new RuntimeException('Could not extract a ZIP member.');stream_copy_to_stream($stream,$out);fclose($stream);fclose($out);$type=$mime->file($target)?:'application/octet-stream';$stmt->execute([$subId,$normal,$type,(string)$subId.'/'.$normal,$size]);}$db->commit();$zip->close();audit_event($sid,'student','submission',$subId,'upload','Submitted practical project ZIP');reply(201,['status'=>'success','message'=>'ZIP validated and submitted.']);}catch(Throwable $e){if($db->inTransaction())$db->rollBack();$zip->close();@unlink($dest);reply(503,['status'=>'error','message'=>'Submission could not be saved.']);}
