<?php
// api/club_common.php
// Shared schema, authentication, campus-scoping and helpers for Rockview Clubs & Societies.

require_once __DIR__ . '/session_auth.php';

function rvu_club_json($payload, int $status = 200): void {
    http_response_code($status);
    header('Content-Type: application/json; charset=utf-8');
    echo json_encode($payload, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES | JSON_INVALID_UTF8_SUBSTITUTE);
    exit;
}

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

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

function rvu_club_role_is_admin(?string $role): bool {
    $value = strtolower(trim((string)$role));
    $value = str_replace(' ', '_', $value);
    return in_array($value, ['admin', 'administrator', 'superadmin', 'super_admin'], true);
}

function rvu_club_strlen(string $value): int {
    return function_exists('mb_strlen') ? mb_strlen($value, 'UTF-8') : strlen($value);
}

function rvu_club_clean_text($value, int $max = 5000): string {
    $text = trim((string)$value);
    if ($text === '') return '';
    if (rvu_club_strlen($text) > $max) {
        rvu_club_json(['detail' => "A field exceeds the maximum of {$max} characters."], 422);
    }
    return $text;
}

function rvu_ensure_club_tables(PDO $pdo): void {
    $pdo->exec("CREATE TABLE IF NOT EXISTS campus_clubs (
        id BIGSERIAL PRIMARY KEY,
        created_by BIGINT NOT NULL,
        name VARCHAR(180) NOT NULL,
        acronym VARCHAR(40) NULL,
        category VARCHAR(100) NOT NULL DEFAULT 'Other',
        purpose TEXT NOT NULL DEFAULT '',
        description TEXT NOT NULL DEFAULT '',
        campus VARCHAR(180) NOT NULL,
        patron_name VARCHAR(180) NULL,
        contact_email VARCHAR(180) NULL,
        contact_phone VARCHAR(80) NULL,
        meeting_schedule VARCHAR(220) NULL,
        meeting_venue VARCHAR(220) NULL,
        status VARCHAR(20) NOT NULL DEFAULT 'pending',
        rejection_reason TEXT NULL,
        approved_by BIGINT NULL,
        approved_at TIMESTAMPTZ NULL,
        created_at TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP,
        updated_at TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP,
        CONSTRAINT campus_clubs_status_check CHECK (status IN ('pending','active','rejected','inactive'))
    )");

    $pdo->exec("CREATE TABLE IF NOT EXISTS campus_club_members (
        id BIGSERIAL PRIMARY KEY,
        club_id BIGINT NOT NULL REFERENCES campus_clubs(id) ON DELETE CASCADE,
        added_by BIGINT NOT NULL,
        full_name VARCHAR(180) NOT NULL,
        member_number VARCHAR(100) NULL,
        member_type VARCHAR(80) NOT NULL DEFAULT 'Student',
        club_role VARCHAR(100) NOT NULL DEFAULT 'Member',
        email VARCHAR(180) NULL,
        phone VARCHAR(80) NULL,
        status VARCHAR(20) NOT NULL DEFAULT 'active',
        joined_at DATE NOT NULL DEFAULT CURRENT_DATE,
        created_at TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP,
        updated_at TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP,
        CONSTRAINT campus_club_members_status_check CHECK (status IN ('active','inactive'))
    )");

    $pdo->exec("CREATE TABLE IF NOT EXISTS campus_club_documents (
        id BIGSERIAL PRIMARY KEY,
        club_id BIGINT NOT NULL REFERENCES campus_clubs(id) ON DELETE CASCADE,
        uploaded_by BIGINT NOT NULL,
        document_type VARCHAR(100) NOT NULL DEFAULT 'Club Document',
        original_name VARCHAR(255) NOT NULL,
        stored_name VARCHAR(255) NOT NULL,
        file_path TEXT NOT NULL,
        mime_type VARCHAR(160) NOT NULL,
        file_size BIGINT NOT NULL DEFAULT 0,
        created_at TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP
    )");

    $pdo->exec("CREATE INDEX IF NOT EXISTS idx_campus_clubs_campus_status ON campus_clubs (campus, status, created_at DESC)");
    $pdo->exec("CREATE INDEX IF NOT EXISTS idx_campus_clubs_created_by ON campus_clubs (created_by, created_at DESC)");
    $pdo->exec("CREATE INDEX IF NOT EXISTS idx_campus_clubs_category ON campus_clubs (category)");
    $pdo->exec("CREATE INDEX IF NOT EXISTS idx_campus_club_members_club ON campus_club_members (club_id, status, full_name)");
    $pdo->exec("CREATE INDEX IF NOT EXISTS idx_campus_club_documents_club ON campus_club_documents (club_id, created_at DESC)");
}

function rvu_club_fetch(PDO $pdo, int $clubId): ?array {
    $stmt = $pdo->prepare("SELECT
        c.*,
        u.full_name AS creator_name,
        u.role AS creator_role,
        u.profile_picture AS creator_profile_picture,
        COALESCE((SELECT COUNT(*) FROM campus_club_members m WHERE m.club_id = c.id AND m.status = 'active'), 0) AS member_count,
        COALESCE((SELECT COUNT(*) FROM campus_club_documents d WHERE d.club_id = c.id), 0) AS document_count
      FROM campus_clubs c
      LEFT JOIN users u ON u.id = c.created_by
      WHERE c.id = ?
      LIMIT 1");
    $stmt->execute([$clubId]);
    $row = $stmt->fetch(PDO::FETCH_ASSOC);
    if (!$row) return null;
    $row['id'] = (int)$row['id'];
    $row['created_by'] = (int)$row['created_by'];
    $row['member_count'] = (int)$row['member_count'];
    $row['document_count'] = (int)$row['document_count'];
    return $row;
}

function rvu_club_can_view(array $user, array $club): bool {
    if (rvu_club_role_is_admin($user['role'] ?? '')) return true;
    $userCampus = trim((string)($user['campus'] ?? ''));
    $clubCampus = trim((string)($club['campus'] ?? ''));
    if ($userCampus === '' || strcasecmp($userCampus, $clubCampus) !== 0) return false;
    if (($club['status'] ?? '') === 'active') return true;
    return (int)($club['created_by'] ?? 0) === (int)($user['id'] ?? 0);
}

function rvu_club_can_manage(array $user, array $club): bool {
    return rvu_club_role_is_admin($user['role'] ?? '')
        || (int)($club['created_by'] ?? 0) === (int)($user['id'] ?? 0);
}

function rvu_club_require_view(array $user, ?array $club): array {
    if (!$club) rvu_club_json(['detail' => 'Club not found.'], 404);
    if (!rvu_club_can_view($user, $club)) {
        rvu_club_json(['detail' => 'You do not have access to this club.'], 403);
    }
    return $club;
}

function rvu_club_require_manage(array $user, ?array $club): array {
    if (!$club) rvu_club_json(['detail' => 'Club not found.'], 404);
    if (!rvu_club_can_manage($user, $club)) {
        rvu_club_json(['detail' => 'Only the club creator or an administrator can manage this club.'], 403);
    }
    return $club;
}

function rvu_club_remove_file(string $relativePath): void {
    $root = realpath(__DIR__ . '/..');
    if (!$root) return;
    $relative = str_replace(['\\', '..'], ['/', ''], $relativePath);
    $full = $root . DIRECTORY_SEPARATOR . str_replace('/', DIRECTORY_SEPARATOR, $relative);
    if (is_file($full)) @unlink($full);
}
