<?php
declare(strict_types=1);

function fm_is_staff(array $user): bool {
    $role=(string)($user['role']??'');
    if (preg_match('/student|learner/i',$role)) return false;
    return leave_is_employee_role($role) || fm_role($role)!=='staff';
}
function fm_folder_public(array $folder, array $actor): array {
    $folder['id']=(int)$folder['id'];$folder['owner_id']=(int)$folder['owner_id'];
    $folder['can_upload']=$folder['owner_id']===(int)$actor['id'];
    $folder['can_invite']=$folder['can_upload'];$folder['can_delete']=$folder['can_upload'];
    return $folder;
}
function fm_folder(PDO $pdo, array $actor, int $id, bool $owner=false): array {
    $args=[];$acl=fm_folder_acl_sql($actor,$args);$args[]=$id;
    $q=$pdo->prepare("SELECT g.* FROM managed_folders g WHERE $acl AND g.id=?");$q->execute($args);
    $folder=$q->fetch(PDO::FETCH_ASSOC);
    if (!$folder) fm_fail('Folder is unavailable or access was removed.',404);
    if ($owner && (int)$folder['owner_id']!==(int)$actor['id']) fm_fail('Only the folder owner may perform this action.',403);
    return $folder;
}
function fm_folder_for_upload(PDO $pdo,array $actor,int $id): array {
    // A shared lock lasts through finalization; deletion cannot race a commit.
    $q=$pdo->prepare('SELECT * FROM managed_folders WHERE id=? AND owner_id=? AND deleted_at IS NULL FOR SHARE');
    $q->execute([$id,$actor['id']]);$folder=$q->fetch(PDO::FETCH_ASSOC);
    if (!$folder) fm_fail('Only the owner can upload into an active folder.',403);
    return $folder;
}
function fm_lock_folder(PDO $pdo,int $id): array {
    $q=$pdo->prepare('SELECT * FROM managed_folders WHERE id=? AND deleted_at IS NULL FOR UPDATE');$q->execute([$id]);
    $folder=$q->fetch(PDO::FETCH_ASSOC);
    if (!$folder) fm_fail('Folder is unavailable.',404);
    return $folder;
}
function fm_folder_audit(PDO $pdo,array $actor,int $id,string $action,?int $target=null): void {
    $pdo->prepare('INSERT INTO managed_folder_audit(folder_id,actor_id,action,target_user_id) VALUES(?,?,?,?)')->execute([$id,$actor['id'],$action,$target]);
}
// Use the same official position/campus precedence as leave_official_profile.
// Load once per request, with no per-employee database round trips.
function fm_staff_directory(PDO $pdo): array {
    static $directory=null;
    if ($directory!==null) return $directory;
    $columns=leave_columns($pdo,'users');
    $fields=['id','full_name','email','role','campus'];
    foreach(['position','account_status'] as $key) if(in_array($key,$columns,true))$fields[]=$key;
    $users=$pdo->query('SELECT '.implode(',',$fields).' FROM users ORDER BY full_name,id')->fetchAll(PDO::FETCH_ASSOC);
    $admins=[];
    if(leave_table_exists($pdo,'admins')) {
        $cols=leave_columns($pdo,'admins');
        if(in_array('email',$cols,true)) {
            $select=['id','email'];foreach(['position','campus'] as $key)if(in_array($key,$cols,true))$select[]=$key;
            foreach($pdo->query('SELECT '.implode(',',$select).' FROM admins ORDER BY id')->fetchAll(PDO::FETCH_ASSOC) as $admin) {
                $email=strtolower(trim((string)$admin['email']));if(!isset($admins[$email]))$admins[$email]=$admin;
            }
        }
    }
    $directory=[];
    foreach($users as $user) {
        if(!fm_is_staff($user)||strtolower((string)($user['account_status']??'active'))==='suspended')continue;
        $admin=$admins[strtolower(trim((string)$user['email']))]??[];
        $position=trim((string)($admin['position']??''));
        if($position==='')$position=trim((string)($user['position']??''));
        if($position==='')$position=(string)$user['role'];
        $campus=trim((string)($admin['campus']??''));if($campus==='')$campus=(string)$user['campus'];
        $directory[(int)$user['id']]=['id'=>(int)$user['id'],'name'=>(string)$user['full_name'],
          'email'=>(string)$user['email'],'role'=>fm_role($position),'campus'=>$campus,'campus_key'=>fm_campus($campus)];
    }
    return $directory;
}
function fm_handle_folder_operation(PDO $pdo,array $actor,string $op,string $method): void {
    if($op==='create_folder'&&$method==='POST') {
        $in=fm_input();$name=trim((string)($in['name']??''));$description=trim((string)($in['description']??''));
        if($name===''||mb_strlen($name)>150||preg_match('/[\x00-\x1f\x7f]/',$name))fm_fail('Folder name must be 1–150 characters without control characters.',422);
        if(mb_strlen($description)>500)fm_fail('Description must be at most 500 characters.',422);
        $visibility=(string)($in['visibility']??'restricted');
        if(!in_array($visibility,['restricted','public'],true))fm_fail('Invalid visibility.',422);
        if($visibility==='public'&&!fm_is_executive($actor))fm_fail('Only executives may create folders public to all staff.',403);
        $pdo->beginTransaction();
        $q=$pdo->prepare('INSERT INTO managed_folders(owner_id,owner_name,owner_role,campus,campus_key,name,description,visibility) VALUES(?,?,?,?,?,?,?,?) ON CONFLICT(owner_id,name) WHERE deleted_at IS NULL DO NOTHING RETURNING id');
        $q->execute([$actor['id'],$actor['name'],$actor['role'],$actor['campus'],$actor['campus_key'],$name,$description,$visibility]);$id=$q->fetchColumn();
        if(!$id)fm_fail('You already have a folder with this name.',409);
        fm_folder_audit($pdo,$actor,(int)$id,'create');$pdo->commit();fm_json(['folder_id'=>(int)$id],201);
    }
    if($op==='folder_details'&&$method==='GET') {
        $id=(int)($_GET['folder_id']??0);$folder=fm_folder($pdo,$actor,$id);
        $q=$pdo->prepare('SELECT user_id,state,invited_at,responded_at FROM managed_folder_members WHERE folder_id=?');$q->execute([$id]);
        $states=[];foreach($q->fetchAll(PDO::FETCH_ASSOC) as $row)$states[(int)$row['user_id']]=$row;
        $members=[];$pending=[];$directory=fm_staff_directory($pdo);
        foreach($directory as $person) {
            $state=$states[$person['id']]??[];
            $reason=fm_folder_reason($person,$folder,($state['state']??'')==='accepted');
            if($reason!==null)$members[]=array_merge($person,['access_reason'=>$reason]);
            if((int)$folder['owner_id']===(int)$actor['id']&&($state['state']??'')==='pending')$pending[]=array_merge($person,['state'=>'pending']);
        }
        fm_json(['folder'=>fm_folder_public($folder,$actor),'members'=>$members,'pending'=>$pending]);
    }
    if($op==='folder_candidates'&&$method==='GET') {
        $id=(int)($_GET['folder_id']??0);$folder=fm_folder($pdo,$actor,$id,true);
        $query=trim((string)($_GET['q']??''));if(mb_strlen($query)<2)fm_json(['people'=>[]]);
        if(mb_strlen($query)>150)fm_fail('Search text is too long.',422);
        $q=$pdo->prepare("SELECT user_id FROM managed_folder_members WHERE folder_id=? AND state IN ('pending','accepted')");$q->execute([$id]);
        $existing=array_map('intval',$q->fetchAll(PDO::FETCH_COLUMN));$matches=[];
        foreach(fm_staff_directory($pdo) as $person) {
            if(in_array($person['id'],$existing,true)||$person['id']===(int)$actor['id'])continue;
            if(mb_stripos($person['name'].' '.$person['email'],$query)===false)continue;
            $matches[]=$person;if(count($matches)>=50)break;
        }
        fm_json(['people'=>$matches]);
    }
    if($op==='invite_folder'&&$method==='POST') {
        $in=fm_input();$id=(int)($in['folder_id']??0);$target=(int)($in['user_id']??0);
        $pdo->beginTransaction();$folder=fm_lock_folder($pdo,$id);
        if((int)$folder['owner_id']!==(int)$actor['id'])fm_fail('Only the folder owner can invite members.',403);
        if($target===(int)$actor['id']||!isset(fm_staff_directory($pdo)[$target]))fm_fail('Select an active staff member.',422);
        $q=$pdo->prepare("INSERT INTO managed_folder_members(folder_id,user_id,invited_by) VALUES(?,?,?) ON CONFLICT(folder_id,user_id) DO UPDATE SET state='pending',invited_by=EXCLUDED.invited_by,invited_at=CURRENT_TIMESTAMP,responded_at=NULL WHERE managed_folder_members.state='declined' RETURNING user_id");
        $q->execute([$id,$target,$actor['id']]);
        if(!$q->fetchColumn())fm_fail('This member already has a pending or accepted invitation.',409);
        fm_folder_audit($pdo,$actor,$id,'invite',$target);$pdo->commit();fm_json(['invited'=>true],201);
    }
    if($op==='respond_folder_invite'&&$method==='POST') {
        $in=fm_input();$id=(int)($in['folder_id']??0);$decision=(string)($in['decision']??'');
        if(!in_array($decision,['accepted','declined'],true))fm_fail('Choose accept or decline.',422);
        $pdo->beginTransaction();fm_lock_folder($pdo,$id);
        // The recipient comes only from authentication; no client user_id is used.
        $q=$pdo->prepare("UPDATE managed_folder_members SET state=?,responded_at=CURRENT_TIMESTAMP WHERE folder_id=? AND user_id=? AND state='pending'");
        $q->execute([$decision,$id,$actor['id']]);if(!$q->rowCount())fm_fail('Invitation is no longer pending.',409);
        fm_folder_audit($pdo,$actor,$id,$decision,(int)$actor['id']);$pdo->commit();fm_json(['state'=>$decision]);
    }
    if($op==='delete_folder'&&$method==='POST') {
        $in=fm_input();$id=(int)($in['folder_id']??0);$pdo->beginTransaction();$folder=fm_lock_folder($pdo,$id);
        if((int)$folder['owner_id']!==(int)$actor['id'])fm_fail('Only the folder owner may delete it.',403);
        $pdo->prepare('UPDATE managed_folders SET deleted_at=CURRENT_TIMESTAMP WHERE id=?')->execute([$id]);
        fm_folder_audit($pdo,$actor,$id,'delete');$pdo->commit();
        // Keep stored content/audit for retention, but ACLs hide folder and files.
        fm_json(['deleted'=>true]);
    }
}
