<?php
declare(strict_types=1);
// Explicit audiences, not a guessed numeric rank. Add confirmed higher offices here.
function sfm_policies(): array {
    $executives = ['dvc1','dvc2','cfo','ceo','coo','cao'];
    return [
        'staff' => ['campus'=>['registrar'], 'global'=>[]],
        'hod' => ['campus'=>['registrar'], 'global'=>[]],
        'junior_hr' => ['campus'=>['registrar'], 'global'=>array_merge(['senior_hr'], $executives)],
        'registrar' => ['campus'=>[], 'global'=>array_merge(['senior_hr'], $executives)],
        'senior_hr' => ['campus'=>[], 'global'=>$executives],
        'senior_lecturer' => ['campus'=>[], 'global'=>$executives],
        'cfo' => ['campus'=>[], 'global'=>['coo','cfo','cao','ceo']],
        'dvc1' => ['campus'=>[], 'global'=>[]],
        'dvc2' => ['campus'=>[], 'global'=>[]],
        'coo' => ['campus'=>[], 'global'=>[]],
        'cao' => ['campus'=>[], 'global'=>[]],
        'ceo' => ['campus'=>[], 'global'=>[]],
    ];
}
function sfm_role(string $value): string {
    $value = strtolower(trim(preg_replace('/[^a-z0-9]+/i', '_', $value), '_'));
    $aliases = [
        'junior_hr'=>'junior_hr','junior_human_resource'=>'junior_hr','junior_human_resources'=>'junior_hr',
        'senior_hr'=>'senior_hr','senior_human_resource'=>'senior_hr','senior_human_resources'=>'senior_hr',
        'junior_hr_officer'=>'junior_hr','senior_hr_officer'=>'senior_hr',
        'hr_officer'=>'junior_hr','human_resource_officer'=>'junior_hr',
        'junior_human_resources_officer'=>'junior_hr','senior_human_resources_officer'=>'senior_hr',
        'senior_lecturer'=>'senior_lecturer', 'registrar'=>'registrar', 'campus_registrar'=>'registrar',
        'hod'=>'hod','head_of_department'=>'hod', 'staff'=>'staff', 'lecturer'=>'staff',
        'dvc1'=>'dvc1','dvc_1'=>'dvc1','deputy_vice_chancellor_1'=>'dvc1',
        'deputy_vice_chancellor_i'=>'dvc1','deputy_vice_chancellor_ii'=>'dvc2',
        'dvc2'=>'dvc2','dvc_2'=>'dvc2','deputy_vice_chancellor_2'=>'dvc2',
        'cfo'=>'cfo','chief_financial_officer'=>'cfo','chief_finance_officer'=>'cfo',
        'coo'=>'coo','chief_operating_officer'=>'coo','chief_operations_officer'=>'coo',
        'cao'=>'cao','chief_administrative_officer'=>'cao','chief_academic_officer'=>'cao',
        'ceo'=>'ceo','chief_executive_officer'=>'ceo',
    ];
    // Unmapped job titles have ordinary-staff access, never executive privileges.
    return $aliases[$value] ?? 'staff';
}
function sfm_campus(string $value): string {
    return strtolower(trim(preg_replace('/\s+/', ' ', preg_replace('/\s+campus\s*$/i', '', trim($value)))));
}
// Executive oversight is independent of the uploader's job title.
function sfm_executives(): array { return ['dvc1','dvc2','ceo','cfo','coo','cao']; }
function sfm_is_executive(array $actor): bool {
    return in_array($actor['role'], sfm_executives(), true);
}
// Folder access is independent of uploader roles and invitation state.
function sfm_folder_reason(array $actor, array $folder, bool $accepted=false): ?string {
    if (!empty($folder['deleted_at'])) return null;
    if ((int)$actor['id']===(int)$folder['owner_id']) return 'Owner';
    if (sfm_is_executive($actor)) return 'Executive oversight';
    if ($actor['role']==='registrar' && $actor['campus_key']!=='' && $actor['campus_key']===$folder['campus_key']) return 'Campus registrar';
    if (($folder['visibility']??'restricted')==='public') return 'Public access';
    return $accepted ? 'Accepted invitation' : null;
}
// Alias is internal, never supplied by the request.
function sfm_folder_acl_sql(array $actor, array &$args, string $alias='g'): string {
    if (sfm_is_executive($actor)) return "$alias.deleted_at IS NULL";
    $args[]=(int)$actor['id'];
    $parts=["$alias.owner_id = ?", "$alias.visibility = 'public'"];
    if ($actor['role']==='registrar' && $actor['campus_key']!=='') {
        $parts[]="$alias.campus_key = ?"; $args[]=$actor['campus_key'];
    }
    $parts[]="EXISTS (SELECT 1 FROM managed_folder_members m WHERE m.folder_id=$alias.id AND m.user_id=? AND m.state='accepted')";
    $args[]=(int)$actor['id'];
    return "$alias.deleted_at IS NULL AND (".implode(' OR ',$parts).')';
}
function sfm_acl_sql(array $actor, array &$args): string {
    $args=[];
    // The same parent-folder predicate governs listing, metadata and downloads.
    $folderAcl=sfm_folder_acl_sql($actor,$args);
    $folder="(f.folder_id IS NOT NULL AND EXISTS (SELECT 1 FROM managed_folders g WHERE g.id=f.folder_id AND $folderAcl))";
    if (sfm_is_executive($actor)) return "(f.folder_id IS NULL OR $folder)";
    $clauses=['f.owner_id = ?']; $args[]=(int)$actor['id'];
    if ($actor['role']==='registrar' && $actor['campus_key']!=='') {
        $clauses[]='f.campus_key = ?'; $args[]=$actor['campus_key'];
    }
    foreach (sfm_policies() as $ownerRole=>$policy) {
        if (in_array($actor['role'],$policy['global'],true)) {
            $clauses[]='f.owner_role = ?'; $args[]=$ownerRole;
        } elseif ($actor['campus_key']!=='' && in_array($actor['role'],$policy['campus'],true)) {
            $clauses[]='(f.owner_role = ? AND f.campus_key = ?)';
            $args[]=$ownerRole; $args[]=$actor['campus_key'];
        }
    }
    return "($folder OR (f.folder_id IS NULL AND (".implode(' OR ',$clauses).')))';
}
function sfm_audience(array $file): array {
    if (!empty($file['folder_id'])) return ['campus'=>['registrar'], 'global'=>array_merge(sfm_executives(),['folder_members'])];
    $policy=sfm_policies()[$file['owner_role']]??['campus'=>[],'global'=>[]];
    $policy['global']=array_values(array_unique(array_merge($policy['global'],sfm_executives())));
    $policy['campus']=array_values(array_unique(array_merge($policy['campus'],['registrar'])));
    return $policy;
}
