<?php
declare(strict_types=1);

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

rvu_ensure_announcement_tables($pdo);
$user = rvu_announcement_user($pdo);
$userId = (int)$user['id'];
$method = strtoupper($_SERVER['REQUEST_METHOD'] ?? 'GET');

if ($method === 'GET') {
    $limit = max(1, min(100, (int)($_GET['limit'] ?? 50)));
    $stmt = $pdo->prepare("SELECT n.id, n.announcement_id, n.comment_id, n.type, n.title, n.message, n.is_read, n.created_at,
                                  COALESCE(u.full_name, '') AS actor_name,
                                  COALESCE(u.profile_picture, '') AS actor_profile_picture
                           FROM campus_announcement_notifications n
                           LEFT JOIN users u ON u.id = n.actor_user_id
                           WHERE n.recipient_user_id = ?
                           ORDER BY n.created_at DESC, n.id DESC
                           LIMIT {$limit}");
    $stmt->execute([$userId]);
    $rows = $stmt->fetchAll(PDO::FETCH_ASSOC) ?: [];
    foreach ($rows as &$row) {
        $row['id'] = (int)$row['id'];
        $row['announcement_id'] = $row['announcement_id'] !== null ? (int)$row['announcement_id'] : null;
        $row['comment_id'] = $row['comment_id'] !== null ? (int)$row['comment_id'] : null;
        $row['is_read'] = in_array($row['is_read'], [true,1,'1','t','true'], true);
    }
    unset($row);
    $count = $pdo->prepare('SELECT COUNT(*) FROM campus_announcement_notifications WHERE recipient_user_id = ? AND is_read = FALSE');
    $count->execute([$userId]);
    rvu_announcement_json(['data' => $rows, 'unread_count' => (int)$count->fetchColumn()]);
}

if ($method === 'POST') {
    $input = rvu_announcement_input();
    if (($input['action'] ?? '') !== 'mark_all_read') rvu_announcement_json(['detail' => 'Unsupported action.'], 422);
    $pdo->prepare('UPDATE campus_announcement_notifications SET is_read = TRUE WHERE recipient_user_id = ?')->execute([$userId]);
    rvu_announcement_json(['success' => true]);
}

if ($method === 'PUT') {
    $id = (int)($_GET['id'] ?? 0);
    if ($id <= 0) rvu_announcement_json(['detail' => 'Notification id is required.'], 422);
    $pdo->prepare('UPDATE campus_announcement_notifications SET is_read = TRUE WHERE id = ? AND recipient_user_id = ?')->execute([$id, $userId]);
    rvu_announcement_json(['success' => true]);
}

rvu_announcement_json(['detail' => 'Method not allowed.'], 405);
