<?php
require_once __DIR__ . '/connect_common.php';
if (($_SERVER['REQUEST_METHOD'] ?? 'GET') === 'OPTIONS') connect_json(204);
$user = connect_user($pdo);
$method = $_SERVER['REQUEST_METHOD'] ?? 'GET';
$userId = (int)($user['id'] ?? 0);

try {
    if ($method === 'GET') {
        $q = connect_text($_GET['q'] ?? '', 120);
        $where = 'WHERE c.is_active = TRUE';
        $params = [];
        if ($q !== '') {
            $where .= ' AND (c.name ILIKE :q1 OR c.description ILIKE :q2 OR COALESCE(c.campus, \'\') ILIKE :q3)';
            $needle = '%' . $q . '%';
            $params[':q1'] = $needle;
            $params[':q2'] = $needle;
            $params[':q3'] = $needle;
        }

        $sql = "SELECT
                    c.*,
                    COALESCE((SELECT COUNT(*) FROM connect_community_members m WHERE m.community_id = c.id), 0)::int AS members_count,
                    EXISTS(SELECT 1 FROM connect_community_members mm WHERE mm.community_id = c.id AND mm.user_id = :viewer_id) AS is_member,
                    COALESCE((SELECT role FROM connect_community_members mr WHERE mr.community_id = c.id AND mr.user_id = :viewer_role_id LIMIT 1), '') AS my_role
                FROM connect_communities c
                $where
                ORDER BY c.created_at DESC";
        $stmt = $pdo->prepare($sql);
        $stmt->bindValue(':viewer_id', $userId, PDO::PARAM_INT);
        $stmt->bindValue(':viewer_role_id', $userId, PDO::PARAM_INT);
        foreach ($params as $key => $value) $stmt->bindValue($key, $value, PDO::PARAM_STR);
        $stmt->execute();
        connect_json(200, ['data' => $stmt->fetchAll(PDO::FETCH_ASSOC)]);
    }

    if ($method !== 'POST') connect_json(405, ['detail' => 'Only GET and POST are supported for communities.']);
    $body = connect_body();
    $name = connect_text($body['name'] ?? '', 160);
    $description = connect_text($body['description'] ?? '', 1200);
    if ($name === '') connect_json(400, ['detail' => 'Community name is required.']);
    if ($userId <= 0) connect_json(401, ['detail' => 'Your account could not be verified.']);

    $dup = $pdo->prepare('SELECT id FROM connect_communities WHERE LOWER(name) = LOWER(?) AND is_active = TRUE LIMIT 1');
    $dup->execute([$name]);
    if ($dup->fetchColumn()) connect_json(409, ['detail' => 'A community with this name already exists.']);

    $pdo->beginTransaction();
    $stmt = $pdo->prepare("INSERT INTO connect_communities
        (name, description, creator_id, creator_name, creator_email, campus)
        VALUES (?, ?, ?, ?, ?, ?) RETURNING id");
    $stmt->execute([
        $name,
        $description,
        $userId,
        connect_text($user['full_name'] ?? $user['name'] ?? 'Rockview User', 255),
        connect_text($user['email'] ?? '', 255),
        connect_text($user['campus'] ?? '', 255) ?: null,
    ]);
    $communityId = (int)$stmt->fetchColumn();

    $member = $pdo->prepare("INSERT INTO connect_community_members
        (community_id, user_id, user_name, user_email, role)
        VALUES (?, ?, ?, ?, 'admin')");
    $member->execute([
        $communityId,
        $userId,
        connect_text($user['full_name'] ?? $user['name'] ?? 'Rockview User', 255),
        connect_text($user['email'] ?? '', 255),
    ]);
    $pdo->commit();

    connect_json(201, [
        'message' => 'Community created successfully.',
        'data' => ['id' => $communityId, 'name' => $name, 'is_member' => true, 'members_count' => 1, 'my_role' => 'admin'],
    ]);
} catch (Throwable $e) {
    if ($pdo->inTransaction()) $pdo->rollBack();
    connect_json(500, ['detail' => 'Community service error: ' . $e->getMessage()]);
}
