<?php
declare(strict_types=1);

// Keep API responses JSON-only. XAMPP can otherwise render PHP warnings as
// HTML (<br />...), which breaks Flutter's jsonDecode().
if (ob_get_level() === 0) {
    ob_start();
}
ini_set('display_errors', '0');
ini_set('html_errors', '0');
error_reporting(E_ALL);

require_once __DIR__ . '/session_auth.php';

// The announcement module must not depend on the optional mbstring PHP
// extension. These helpers use UTF-8 aware functions when available and safe
// core-PHP fallbacks when mbstring is disabled in XAMPP.
function rvu_announcement_strlen(string $value): int {
    return function_exists('mb_strlen')
        ? mb_strlen($value, 'UTF-8')
        : strlen($value);
}

function rvu_announcement_substr(string $value, int $start, int $length): string {
    return function_exists('mb_substr')
        ? mb_substr($value, $start, $length, 'UTF-8')
        : substr($value, $start, $length);
}

function rvu_announcement_json($payload, int $status = 200): void {
    // Discard any accidental warning/notice output before sending JSON.
    while (ob_get_level() > 0) {
        ob_end_clean();
    }
    http_response_code($status);
    header('Content-Type: application/json; charset=utf-8');
    header('Cache-Control: no-store, no-cache, must-revalidate, max-age=0');
    header('Pragma: no-cache');
    echo json_encode($payload, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES | JSON_INVALID_UTF8_SUBSTITUTE);
    exit;
}

set_exception_handler(static function (Throwable $error): void {
    rvu_announcement_json([
        'detail' => 'Announcement server error: ' . $error->getMessage(),
    ], 500);
});

function rvu_announcement_input(): array {
    $raw = file_get_contents('php://input');
    if ($raw === false || trim($raw) === '') return [];
    $decoded = json_decode($raw, true);
    if (!is_array($decoded)) rvu_announcement_json(['detail' => 'Invalid JSON request body.'], 400);
    return $decoded;
}

function rvu_announcement_user(PDO $pdo): array {
    $user = rvu_current_user($pdo);
    if (!$user) rvu_announcement_json(['detail' => 'Your session is invalid. Please sign in again.'], 401);
    return $user;
}

function rvu_announcement_is_admin(?string $role): bool {
    $r = strtolower(trim((string)$role));
    return in_array($r, ['admin', 'administrator', 'superadmin', 'super_admin', 'super admin'], true);
}

function rvu_announcement_can_manage(array $user, int $authorId): bool {
    return (int)($user['id'] ?? 0) === $authorId || rvu_announcement_is_admin($user['role'] ?? '');
}

function rvu_ensure_announcement_tables(PDO $pdo): void {
    $pdo->exec("CREATE TABLE IF NOT EXISTS campus_announcements (
        id BIGSERIAL PRIMARY KEY,
        author_id BIGINT NOT NULL,
        title VARCHAR(180) NOT NULL,
        body TEXT NOT NULL,
        category VARCHAR(80) NOT NULL DEFAULT 'General',
        priority VARCHAR(20) NOT NULL DEFAULT 'Normal',
        audience VARCHAR(50) NOT NULL DEFAULT 'All Staff',
        campus VARCHAR(180) NULL,
        status VARCHAR(20) NOT NULL DEFAULT 'published',
        is_pinned BOOLEAN NOT NULL DEFAULT FALSE,
        scheduled_at TIMESTAMPTZ NULL,
        published_at TIMESTAMPTZ NULL,
        expires_at TIMESTAMPTZ NULL,
        created_at TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP,
        updated_at TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP,
        CONSTRAINT campus_announcements_status_check CHECK (status IN ('draft','scheduled','published','expired')),
        CONSTRAINT campus_announcements_priority_check CHECK (priority IN ('Normal','Important','Urgent'))
    )");

    $pdo->exec("CREATE TABLE IF NOT EXISTS campus_announcement_media (
        id BIGSERIAL PRIMARY KEY,
        announcement_id BIGINT NOT NULL REFERENCES campus_announcements(id) ON DELETE CASCADE,
        media_type VARCHAR(20) NOT NULL DEFAULT 'image',
        media_path TEXT NOT NULL,
        thumbnail_path TEXT NULL,
        size_bytes BIGINT NOT NULL DEFAULT 0,
        position INTEGER NOT NULL DEFAULT 0,
        created_at TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP,
        CONSTRAINT campus_announcement_media_type_check CHECK (media_type IN ('image','video'))
    )");

    $pdo->exec("CREATE TABLE IF NOT EXISTS campus_announcement_comments (
        id BIGSERIAL PRIMARY KEY,
        announcement_id BIGINT NOT NULL REFERENCES campus_announcements(id) ON DELETE CASCADE,
        user_id BIGINT NOT NULL,
        parent_comment_id BIGINT NULL REFERENCES campus_announcement_comments(id) ON DELETE CASCADE,
        comment TEXT NOT NULL,
        created_at TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP
    )");

    $pdo->exec("CREATE TABLE IF NOT EXISTS campus_announcement_likes (
        id BIGSERIAL PRIMARY KEY,
        announcement_id BIGINT NOT NULL REFERENCES campus_announcements(id) ON DELETE CASCADE,
        user_id BIGINT NOT NULL,
        created_at TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP,
        CONSTRAINT campus_announcement_likes_unique UNIQUE (announcement_id, user_id)
    )");

    $pdo->exec("CREATE TABLE IF NOT EXISTS campus_announcement_mentions (
        id BIGSERIAL PRIMARY KEY,
        comment_id BIGINT NOT NULL REFERENCES campus_announcement_comments(id) ON DELETE CASCADE,
        mentioned_user_id BIGINT NOT NULL,
        created_at TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP,
        CONSTRAINT campus_announcement_mentions_unique UNIQUE (comment_id, mentioned_user_id)
    )");

    $pdo->exec("CREATE TABLE IF NOT EXISTS campus_announcement_notifications (
        id BIGSERIAL PRIMARY KEY,
        recipient_user_id BIGINT NOT NULL,
        actor_user_id BIGINT NULL,
        announcement_id BIGINT NULL REFERENCES campus_announcements(id) ON DELETE CASCADE,
        comment_id BIGINT NULL REFERENCES campus_announcement_comments(id) ON DELETE CASCADE,
        type VARCHAR(40) NOT NULL DEFAULT 'general',
        title VARCHAR(180) NOT NULL,
        message VARCHAR(255) NOT NULL,
        is_read BOOLEAN NOT NULL DEFAULT FALSE,
        created_at TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP
    )");

    $pdo->exec("CREATE INDEX IF NOT EXISTS idx_announcements_feed ON campus_announcements (status, is_pinned DESC, published_at DESC, id DESC)");
    $pdo->exec("CREATE INDEX IF NOT EXISTS idx_announcements_author ON campus_announcements (author_id, status)");
    $pdo->exec("CREATE INDEX IF NOT EXISTS idx_announcement_comments_parent ON campus_announcement_comments (announcement_id, parent_comment_id, created_at)");
    $pdo->exec("CREATE INDEX IF NOT EXISTS idx_announcement_notifications_recipient ON campus_announcement_notifications (recipient_user_id, is_read, created_at DESC)");
}

function rvu_announcement_apply_schedule(PDO $pdo): void {
    $pdo->exec("UPDATE campus_announcements
               SET status = 'published', published_at = COALESCE(published_at, CURRENT_TIMESTAMP), updated_at = CURRENT_TIMESTAMP
               WHERE status = 'scheduled' AND scheduled_at IS NOT NULL AND scheduled_at <= CURRENT_TIMESTAMP");
    $pdo->exec("UPDATE campus_announcements
               SET status = 'expired', updated_at = CURRENT_TIMESTAMP
               WHERE status = 'published' AND expires_at IS NOT NULL AND expires_at <= CURRENT_TIMESTAMP");
}

function rvu_announcement_normalize(array $row): array {
    foreach (['id','author_id','like_count','comment_count'] as $key) {
        if (isset($row[$key])) $row[$key] = (int)$row[$key];
    }
    $row['is_pinned'] = in_array($row['is_pinned'] ?? false, [true, 1, '1', 't', 'true'], true);
    $row['liked_by_me'] = in_array($row['liked_by_me'] ?? false, [true, 1, '1', 't', 'true'], true);
    if (isset($row['media']) && is_string($row['media'])) {
        $decoded = json_decode($row['media'], true);
        $row['media'] = is_array($decoded) ? $decoded : [];
    } elseif (!isset($row['media']) || !is_array($row['media'])) {
        $row['media'] = [];
    }
    return $row;
}

function rvu_announcement_fetch(PDO $pdo, int $announcementId, int $viewerId): ?array {
    $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 = ?) 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
            WHERE a.id = ? LIMIT 1";
    $stmt = $pdo->prepare($sql);
    $stmt->execute([$viewerId, $announcementId]);
    $row = $stmt->fetch(PDO::FETCH_ASSOC);
    return $row ? rvu_announcement_normalize($row) : null;
}

function rvu_announcement_fetch_comment(PDO $pdo, int $commentId): ?array {
    $stmt = $pdo->prepare("SELECT c.id, c.announcement_id, c.user_id, c.parent_comment_id, c.comment, c.created_at,
                                  u.full_name AS author_name, u.role AS author_role,
                                  COALESCE(u.profile_picture, '') AS author_profile_picture
                           FROM campus_announcement_comments c
                           INNER JOIN users u ON u.id = c.user_id
                           WHERE c.id = ? LIMIT 1");
    $stmt->execute([$commentId]);
    $row = $stmt->fetch(PDO::FETCH_ASSOC);
    if (!$row) return null;
    $row['id'] = (int)$row['id'];
    $row['announcement_id'] = (int)$row['announcement_id'];
    $row['user_id'] = (int)$row['user_id'];
    $row['parent_comment_id'] = $row['parent_comment_id'] !== null ? (int)$row['parent_comment_id'] : null;
    return $row;
}

function rvu_announcement_create_notification(PDO $pdo, int $recipient, ?int $actor, ?int $announcementId, ?int $commentId, string $type, string $title, string $message): void {
    if ($recipient <= 0 || ($actor !== null && $recipient === $actor)) return;
    $stmt = $pdo->prepare("INSERT INTO campus_announcement_notifications
        (recipient_user_id, actor_user_id, announcement_id, comment_id, type, title, message)
        VALUES (?, ?, ?, ?, ?, ?, ?)");
    $stmt->execute([$recipient, $actor, $announcementId, $commentId, substr($type, 0, 40), rvu_announcement_substr($title, 0, 180), rvu_announcement_substr($message, 0, 255)]);
}
