<?php
declare(strict_types=1);

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

rvu_ensure_announcement_tables($pdo);
rvu_announcement_apply_schedule($pdo);
$user = rvu_announcement_user($pdo);
$viewerId = (int)$user['id'];
$method = strtoupper($_SERVER['REQUEST_METHOD'] ?? 'GET');
$announcementId = isset($_GET['id']) ? (int)$_GET['id'] : 0;

if ($method === 'GET' && $announcementId > 0) {
    $item = rvu_announcement_fetch($pdo, $announcementId, $viewerId);
    if (!$item) rvu_announcement_json(['detail' => 'Announcement not found.'], 404);
    if ($item['status'] !== 'published' && !rvu_announcement_can_manage($user, (int)$item['author_id'])) {
        rvu_announcement_json(['detail' => 'You cannot access this announcement.'], 403);
    }
    rvu_announcement_json(['data' => $item]);
}

if ($method === 'GET') {
    $scope = strtolower(trim((string)($_GET['scope'] ?? 'active')));
    $page = max(1, (int)($_GET['page'] ?? 1));
    $limit = max(1, min(50, (int)($_GET['limit'] ?? 8)));
    $offset = ($page - 1) * $limit;
    $campus = trim((string)($_GET['campus'] ?? ''));
    $category = trim((string)($_GET['category'] ?? ''));
    $q = trim((string)($_GET['q'] ?? ''));

    $where = [];
    $params = [':viewer_id' => $viewerId];

    if ($scope === 'all' && !rvu_announcement_is_admin($user['role'] ?? '')) {
        rvu_announcement_json(['detail' => 'Administrator access is required to view all announcements.'], 403);
    }

    if ($scope === 'mine') {
        $where[] = 'a.author_id = :author_id';
        $params[':author_id'] = $viewerId;
        $where[] = "a.status IN ('draft','scheduled')";
    } elseif ($scope === 'all') {
        // Administrator delete-centre view intentionally includes every status.
    } else {
        $where[] = "a.status = 'published'";
        $where[] = '(a.expires_at IS NULL OR a.expires_at > CURRENT_TIMESTAMP)';
    }

    if ($campus !== '') {
        $where[] = 'a.campus = :campus';
        $params[':campus'] = $campus;
    }
    if ($category !== '') {
        $where[] = 'a.category = :category';
        $params[':category'] = $category;
    }
    if ($q !== '') {
        $where[] = '(a.title ILIKE :q OR a.body ILIKE :q OR u.full_name ILIKE :q)';
        $params[':q'] = '%' . $q . '%';
    }

    $whereSql = $where ? 'WHERE ' . implode(' AND ', $where) : '';

    $countSql = "SELECT COUNT(*) FROM campus_announcements a INNER JOIN users u ON u.id = a.author_id {$whereSql}";
    $countStmt = $pdo->prepare($countSql);
    $countParams = $params;
    unset($countParams[':viewer_id']);
    $countStmt->execute($countParams);
    $total = (int)$countStmt->fetchColumn();

    $sql = "SELECT a.*,
                   u.full_name AS author_name,
                   u.role AS author_role,
                   COALESCE(u.profile_picture, '') AS author_profile_picture,
                   (SELECT COUNT(*) FROM campus_announcement_likes l WHERE l.announcement_id = a.id) AS like_count,
                   (SELECT COUNT(*) FROM campus_announcement_comments c WHERE c.announcement_id = a.id) AS comment_count,
                   EXISTS(SELECT 1 FROM campus_announcement_likes x WHERE x.announcement_id = a.id AND x.user_id = :viewer_id) AS liked_by_me,
                   COALESCE((
                     SELECT json_agg(json_build_object(
                       'id', m.id,
                       'announcement_id', m.announcement_id,
                       'type', m.media_type,
                       'path', m.media_path,
                       'thumbnail_path', COALESCE(m.thumbnail_path, ''),
                       'size_bytes', m.size_bytes
                     ) ORDER BY m.position, m.id)
                     FROM campus_announcement_media m WHERE m.announcement_id = a.id
                   ), '[]'::json) AS media
            FROM campus_announcements a
            INNER JOIN users u ON u.id = a.author_id
            {$whereSql}
            ORDER BY
              CASE WHEN a.status = 'published' THEN a.is_pinned ELSE FALSE END DESC,
              COALESCE(a.published_at, a.scheduled_at, a.updated_at, a.created_at) DESC,
              a.id DESC
            LIMIT {$limit} OFFSET {$offset}";

    $stmt = $pdo->prepare($sql);
    $stmt->execute($params);
    $rows = $stmt->fetchAll(PDO::FETCH_ASSOC) ?: [];
    $rows = array_map('rvu_announcement_normalize', $rows);

    rvu_announcement_json([
        'data' => $rows,
        'pagination' => [
            'page' => $page,
            'limit' => $limit,
            'total' => $total,
            'has_more' => ($offset + count($rows)) < $total,
        ],
    ]);
}

if ($method === 'POST') {
    $input = rvu_announcement_input();
    $title = trim((string)($input['title'] ?? ''));
    $body = trim((string)($input['body'] ?? ''));
    $category = trim((string)($input['category'] ?? 'General')) ?: 'General';
    $priority = trim((string)($input['priority'] ?? 'Normal')) ?: 'Normal';
    $audience = trim((string)($input['audience'] ?? 'All Staff')) ?: 'All Staff';
    $status = strtolower(trim((string)($input['status'] ?? 'draft')));
    $isPinned = !empty($input['is_pinned']);
    $scheduledAt = $input['scheduled_at'] ?? null;
    $expiresAt = $input['expires_at'] ?? null;

    if (rvu_announcement_strlen($title) < 4 || rvu_announcement_strlen($title) > 180) rvu_announcement_json(['detail' => 'Title must be between 4 and 180 characters.'], 422);
    if (rvu_announcement_strlen($body) < 10 || rvu_announcement_strlen($body) > 20000) rvu_announcement_json(['detail' => 'Announcement message must be between 10 and 20,000 characters.'], 422);
    if (!in_array($status, ['draft','scheduled','published'], true)) rvu_announcement_json(['detail' => 'Invalid announcement status.'], 422);
    if (!in_array($priority, ['Normal','Important','Urgent'], true)) $priority = 'Normal';
    if ($status === 'scheduled' && !$scheduledAt) rvu_announcement_json(['detail' => 'scheduled_at is required for scheduled announcements.'], 422);

    $campus = trim((string)($user['campus'] ?? ''));
    $publishedAt = $status === 'published' ? date('c') : null;

    $stmt = $pdo->prepare("INSERT INTO campus_announcements
        (author_id, title, body, category, priority, audience, campus, status, is_pinned, scheduled_at, published_at, expires_at)
        VALUES (:author_id, :title, :body, :category, :priority, :audience, :campus, :status, :is_pinned, :scheduled_at, :published_at, :expires_at)
        RETURNING id");
    $stmt->execute([
        ':author_id' => $viewerId,
        ':title' => $title,
        ':body' => $body,
        ':category' => $category,
        ':priority' => $priority,
        ':audience' => $audience,
        ':campus' => $campus !== '' ? $campus : null,
        ':status' => $status,
        ':is_pinned' => $isPinned,
        ':scheduled_at' => $scheduledAt,
        ':published_at' => $publishedAt,
        ':expires_at' => $expiresAt,
    ]);
    rvu_announcement_json(['id' => (int)$stmt->fetchColumn(), 'message' => 'Announcement saved.'], 201);
}

if ($method === 'PUT' && $announcementId > 0) {
    $existing = rvu_announcement_fetch($pdo, $announcementId, $viewerId);
    if (!$existing) rvu_announcement_json(['detail' => 'Announcement not found.'], 404);
    if (!rvu_announcement_can_manage($user, (int)$existing['author_id'])) rvu_announcement_json(['detail' => 'You cannot edit this announcement.'], 403);

    $input = rvu_announcement_input();
    $allowed = ['title','body','category','priority','audience','status','is_pinned','scheduled_at','expires_at'];
    $sets = [];
    $params = [':id' => $announcementId];

    foreach ($allowed as $field) {
        if (!array_key_exists($field, $input)) continue;
        $value = $input[$field];
        if ($field === 'status') {
            $value = strtolower(trim((string)$value));
            if (!in_array($value, ['draft','scheduled','published','expired'], true)) continue;
        }
        if ($field === 'priority' && !in_array((string)$value, ['Normal','Important','Urgent'], true)) $value = 'Normal';
        if ($field === 'is_pinned') $value = !empty($value);
        $sets[] = "{$field} = :{$field}";
        $params[":{$field}"] = $value;
    }

    if (isset($input['status']) && strtolower((string)$input['status']) === 'published') {
        $sets[] = 'published_at = COALESCE(published_at, CURRENT_TIMESTAMP)';
    }
    $sets[] = 'updated_at = CURRENT_TIMESTAMP';
    if (count($sets) === 1) rvu_announcement_json(['detail' => 'No valid changes supplied.'], 422);

    $stmt = $pdo->prepare('UPDATE campus_announcements SET ' . implode(', ', $sets) . ' WHERE id = :id');
    $stmt->execute($params);
    rvu_announcement_json(['message' => 'Announcement updated.']);
}

if ($method === 'DELETE' && $announcementId > 0) {
    // Permanent announcement deletion is an administrator-only operation.
    // Authors can still edit/publish their own drafts, but cannot delete them.
    if (!rvu_announcement_is_admin($user['role'] ?? '')) {
        rvu_announcement_json(['detail' => 'Only an administrator can delete announcements.'], 403);
    }

    $existing = rvu_announcement_fetch($pdo, $announcementId, $viewerId);
    if (!$existing) rvu_announcement_json(['detail' => 'Announcement not found.'], 404);

    $mediaStmt = $pdo->prepare('SELECT media_path, thumbnail_path FROM campus_announcement_media WHERE announcement_id = ?');
    $mediaStmt->execute([$announcementId]);
    $media = $mediaStmt->fetchAll(PDO::FETCH_ASSOC) ?: [];
    $pdo->prepare('DELETE FROM campus_announcements WHERE id = ?')->execute([$announcementId]);
    $root = realpath(__DIR__ . '/..');
    if ($root) {
        foreach ($media as $row) {
            foreach (['media_path','thumbnail_path'] as $key) {
                $rel = trim((string)($row[$key] ?? ''));
                if ($rel === '' || strpos($rel, '..') !== false) continue;
                $path = $root . DIRECTORY_SEPARATOR . str_replace(['/', '\\'], DIRECTORY_SEPARATOR, $rel);
                if (is_file($path)) @unlink($path);
            }
        }
    }
    rvu_announcement_json(['message' => 'Announcement deleted.']);
}

rvu_announcement_json(['detail' => 'Unsupported request.'], 405);
