<?php
declare(strict_types=1);
require_once __DIR__.'/../../authentication/api/connect.php';
function notice_user_scope(array $u): array {
 $scope=['student_id'=>null,'department_id'=>null,'campus_id'=>null];
 if($u['role']==='student'){$q=db()->prepare('SELECT id AS student_id,department_id,campus_id FROM students WHERE user_id=?');$q->execute([$u['id']]);return array_merge($scope,$q->fetch()?:[]);}
 if($u['role']==='hod'){$q=db()->prepare('SELECT department_id,campus_id FROM hod_assignments WHERE user_id=?');$q->execute([$u['id']]);return array_merge($scope,$q->fetch()?:[]);}
 if(in_array($u['role'],['admin','staff'],true)){$table=$u['role']==='admin'?'admins':'staff';$q=db()->prepare('SELECT campus_id FROM '.$table.' WHERE user_id=?');$q->execute([$u['id']]);$scope=array_merge($scope,$q->fetch()?:[]);}
 return $scope;
}
function notice_visibility(array $u,array $s): array {
 if($u['role']==='staff')return ["(p.notification_id IS NOT NULL OR (p.notification_id IS NULL AND (n.recipient_user_id=? OR (n.recipient_user_id IS NULL AND n.student_id IS NULL))))",[$u['id']]];
 // Explicit personal recipients take precedence; they never become broadcast records.
 return ["((p.notification_id IS NOT NULL AND (n.created_by=? OR p.audience='global' OR (p.audience='campuses' AND EXISTS (SELECT 1 FROM notice_campuses nc WHERE nc.notification_id=n.id AND nc.campus_id=?)))) OR (p.notification_id IS NULL AND (n.recipient_user_id=? OR n.student_id=? OR (n.recipient_user_id IS NULL AND n.student_id IS NULL AND (n.department_id IS NULL OR n.department_id=?) AND (n.campus_id IS NULL OR n.campus_id=?)))))",[$u['id'],$s['campus_id'],$u['id'],$s['student_id'],$s['department_id'],$s['campus_id']]];
}
function notice_unread(array $u,array $s): int {
 [$where,$args]=notice_visibility($u,$s);$q=db()->prepare('SELECT COUNT(*) FROM notifications n LEFT JOIN notice_publications p ON p.notification_id=n.id LEFT JOIN notification_reads r ON r.notification_id=n.id AND r.user_id=? WHERE r.notification_id IS NULL AND '.$where);$q->execute(array_merge([$u['id']],$args));return (int)$q->fetchColumn();
}
function notice_link(string $url): ?string {
 $url=trim($url);if($url==='')return null;
 if(str_starts_with($url,'/')&&!str_starts_with($url,'//')&&!str_contains($url,'\\')&&!preg_match('/[\x00-\x20\x7f]/',$url))return $url;
 if(filter_var($url,FILTER_VALIDATE_URL)&&in_array(strtolower(parse_url($url,PHP_URL_SCHEME)??''),['http','https'],true)&&!parse_url($url,PHP_URL_USER)&&!parse_url($url,PHP_URL_PASS))return $url;
 throw new InvalidArgumentException('Use an http/https link or a system path starting with /.');
}
