<?php
declare(strict_types=1);

require_once __DIR__ . '/../config/database.php';
require_once __DIR__ . '/announcement_common.php';

rvu_ensure_announcement_tables($pdo);
rvu_announcement_user($pdo);
if (strtoupper($_SERVER['REQUEST_METHOD'] ?? 'GET') !== 'GET') rvu_announcement_json(['detail' => 'Method not allowed.'], 405);
$announcementId = (int)($_GET['announcement_id'] ?? 0);
$q = trim((string)($_GET['q'] ?? ''));
if ($announcementId <= 0) rvu_announcement_json(['detail' => 'announcement_id is required.'], 422);
$stmt = $pdo->prepare('SELECT campus FROM campus_announcements WHERE id = ? LIMIT 1');
$stmt->execute([$announcementId]);
$campus = $stmt->fetchColumn();
if ($campus === false) rvu_announcement_json(['data' => []]);
$params = [];
$where = [];
if ($campus !== null && trim((string)$campus) !== '') {
    $where[] = 'campus = :campus';
    $params[':campus'] = (string)$campus;
}
if ($q !== '') {
    $where[] = '(full_name ILIKE :q OR role ILIKE :q OR 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 ($where) $sql .= ' WHERE ' . implode(' AND ', $where);
$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_announcement_json(['data' => $rows]);
