<?php
declare(strict_types=1);
require_once __DIR__ . '/../config/database.php';
require_once __DIR__ . '/market_common.php';

try {
    rvu_ensure_market_tables($pdo);
    rvu_market_require_user($pdo);
    if (strtoupper($_SERVER['REQUEST_METHOD'] ?? 'GET') !== 'GET') rvu_market_json(['detail'=>'Method not allowed.'],405);
    $itemId=(int)($_GET['item_id']??0);
    $q=trim((string)($_GET['q']??''));
    if($itemId<=0) rvu_market_json(['detail'=>'item_id is required.'],422);
    $itemStmt=$pdo->prepare('SELECT campus FROM campus_market_items WHERE id=? LIMIT 1');
    $itemStmt->execute([$itemId]);
    $campus=$itemStmt->fetchColumn();
    if($campus===false) rvu_market_json(['data'=>[]]);

    $conditions=[];$params=[];
    if($campus!==null && trim((string)$campus)!==''){$conditions[]='campus=:campus';$params[':campus']=(string)$campus;}
    if($q!==''){$conditions[]='(full_name ILIKE :q OR role ILIKE :q OR COALESCE(campus,\'\') ILIKE :q)';$params[':q']='%'.$q.'%';}
    $sql="SELECT id,full_name,role,COALESCE(campus,'') AS campus,COALESCE(profile_picture,'') AS profile_picture FROM users";
    if($conditions)$sql.=' WHERE '.implode(' AND ',$conditions);
    $sql.=' ORDER BY full_name ASC LIMIT 50';
    $stmt=$pdo->prepare($sql);$stmt->execute($params);$rows=$stmt->fetchAll(PDO::FETCH_ASSOC)?:[];
    foreach($rows as &$row){$row['id']=(int)$row['id'];}unset($row);
    rvu_market_json(['data'=>$rows]);
} catch(Throwable $e){rvu_market_json(['detail'=>'Marketplace mentions server error: '.$e->getMessage()],500);}
