<?php
declare(strict_types=1);
require_once __DIR__ . '/../../authentication/api/connect.php';
$u=require_auth();$id=(int)($_GET['id']??0);if($id<1)reply(400,['status'=>'error','message'=>'Invalid file.']);$q=db()->prepare('SELECT id,file_name,storage_key,media_type,file_category,department_id,campus_id,uploaded_by FROM file_assets WHERE id=?');$q->execute([$id]);$f=$q->fetch();if(!$f)reply(404,['status'=>'error','message'=>'File not found.']);
$allowed=in_array($u['role'],['admin','staff'],true);if($u['role']==='hod'){$s=db()->prepare('SELECT 1 FROM hod_assignments WHERE user_id=? AND department_id=? AND (? IS NULL OR campus_id=?)');$s->execute([(int)$u['id'],(int)$f['department_id'],$f['campus_id'],(int)$f['campus_id']]);$allowed=(bool)$s->fetch();}elseif($u['role']==='student'){if($f['file_category']==='department_file'){$s=db()->prepare('SELECT 1 FROM students WHERE user_id=? AND department_id=? AND (? IS NULL OR campus_id=?)');$s->execute([(int)$u['id'],(int)$f['department_id'],$f['campus_id'],(int)$f['campus_id']]);$allowed=(bool)$s->fetch();}elseif(in_array($f['file_category'],['past_paper','solution'],true)){$s=db()->prepare('SELECT 1 FROM students s JOIN past_papers p ON p.department_id=s.department_id WHERE s.user_id=? AND s.department_id=? AND (p.paper_file_id=? OR p.solution_file_id=?)');$s->execute([(int)$u['id'],(int)$f['department_id'],$id,$id]);$allowed=(bool)$s->fetch();}else $allowed=(int)$f['uploaded_by']===(int)$u['id'];}if(!$allowed)reply(403,['status'=>'error','message'=>'You do not have access to this file.']);
$folder=match($f['file_category']){'submission'=>'submissions','past_paper','solution'=>'papers','department_file'=>'department-files',default=>''};if($folder===''||!preg_match('/^[a-f0-9]{40}\.(zip|pdf|doc|docx|xls|xlsx|ppt|pptx|csv|txt|jpg|jpeg|png)$/',$f['storage_key']))reply(404,['status'=>'error','message'=>'File unavailable.']);$path=private_storage_root().'/'.$folder.'/'.$f['storage_key'];if(!is_file($path))reply(404,['status'=>'error','message'=>'File unavailable.']);header('Content-Type: '.(preg_match('/^[\w.+-]+\/[\w.+-]+$/',(string)$f['media_type'])?$f['media_type']:'application/octet-stream'));header('Content-Length: '.filesize($path));header('Content-Disposition: attachment; filename="'.str_replace(['"',"\r","\n"],'_',basename((string)$f['file_name'])).'"');header('X-Content-Type-Options: nosniff');header('Cache-Control: private, no-store');readfile($path);
