<?php
// api/club_members.php
require_once __DIR__ . '/../config/database.php';
require_once __DIR__ . '/club_common.php';

try {
    rvu_ensure_club_tables($pdo);
    $user = rvu_club_require_user($pdo);
    $method = strtoupper($_SERVER['REQUEST_METHOD'] ?? 'GET');
    $path = trim((string)($_SERVER['PATH_INFO'] ?? ''), '/');
    $memberId = ctype_digit($path) ? (int)$path : null;

    if ($method === 'GET') {
        $clubId = (int)($_GET['club_id'] ?? 0);
        if ($clubId <= 0) rvu_club_json(['detail' => 'A valid club_id is required.'], 422);
        $club = rvu_club_require_view($user, rvu_club_fetch($pdo, $clubId));

        $stmt = $pdo->prepare("SELECT * FROM campus_club_members WHERE club_id = ? ORDER BY
            CASE club_role
              WHEN 'President' THEN 1
              WHEN 'Vice President' THEN 2
              WHEN 'Secretary' THEN 3
              WHEN 'Treasurer' THEN 4
              WHEN 'Patron' THEN 5
              WHEN 'Adviser' THEN 6
              WHEN 'Committee Member' THEN 7
              ELSE 8
            END,
            full_name ASC");
        $stmt->execute([$clubId]);
        $rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
        foreach ($rows as &$row) {
            $row['id'] = (int)$row['id'];
            $row['club_id'] = (int)$row['club_id'];
        }
        rvu_club_json(['data' => $rows, 'club' => $club]);
    }

    if ($method === 'POST') {
        $input = rvu_club_input();
        $clubId = (int)($input['club_id'] ?? 0);
        if ($clubId <= 0) rvu_club_json(['detail' => 'A valid club is required.'], 422);
        $club = rvu_club_require_manage($user, rvu_club_fetch($pdo, $clubId));

        $name = rvu_club_clean_text($input['full_name'] ?? '', 180);
        $memberNumber = rvu_club_clean_text($input['member_number'] ?? '', 100);
        $memberType = rvu_club_clean_text($input['member_type'] ?? 'Student', 80);
        $clubRole = rvu_club_clean_text($input['club_role'] ?? 'Member', 100);
        $email = rvu_club_clean_text($input['email'] ?? '', 180);
        $phone = rvu_club_clean_text($input['phone'] ?? '', 80);
        $joinedAt = trim((string)($input['joined_at'] ?? ''));
        if ($name === '') rvu_club_json(['detail' => 'Member full name is required.'], 422);
        if ($joinedAt === '') $joinedAt = date('Y-m-d');

        if ($memberNumber !== '') {
            $dup = $pdo->prepare("SELECT id FROM campus_club_members WHERE club_id = ? AND LOWER(member_number) = LOWER(?) AND status = 'active' LIMIT 1");
            $dup->execute([$clubId, $memberNumber]);
            if ($dup->fetchColumn()) {
                rvu_club_json(['detail' => 'This member number is already registered in the club.'], 409);
            }
        }

        $stmt = $pdo->prepare("INSERT INTO campus_club_members (
            club_id, added_by, full_name, member_number, member_type, club_role, email, phone, joined_at
          ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) RETURNING id");
        $stmt->execute([
            $clubId, (int)$user['id'], $name, $memberNumber, $memberType, $clubRole, $email, $phone, $joinedAt
        ]);
        $id = (int)$stmt->fetchColumn();
        $fetch = $pdo->prepare('SELECT * FROM campus_club_members WHERE id = ?');
        $fetch->execute([$id]);
        $row = $fetch->fetch(PDO::FETCH_ASSOC);
        $row['id'] = (int)$row['id'];
        $row['club_id'] = (int)$row['club_id'];
        rvu_club_json(['message' => 'Club member added.', 'data' => $row], 201);
    }

    if ($method === 'PUT' && $memberId !== null) {
        $stmt = $pdo->prepare("SELECT m.*, c.created_by, c.campus, c.status AS club_status FROM campus_club_members m INNER JOIN campus_clubs c ON c.id = m.club_id WHERE m.id = ?");
        $stmt->execute([$memberId]);
        $member = $stmt->fetch(PDO::FETCH_ASSOC);
        if (!$member) rvu_club_json(['detail' => 'Club member not found.'], 404);
        $club = [
            'id' => (int)$member['club_id'],
            'created_by' => (int)$member['created_by'],
            'campus' => $member['campus'],
            'status' => $member['club_status'],
        ];
        rvu_club_require_manage($user, $club);
        $input = rvu_club_input();

        $allowed = [
            'full_name' => 180,
            'member_number' => 100,
            'member_type' => 80,
            'club_role' => 100,
            'email' => 180,
            'phone' => 80,
            'status' => 20,
        ];
        $fields = [];
        $params = [];
        foreach ($allowed as $field => $max) {
            if (array_key_exists($field, $input)) {
                $value = rvu_club_clean_text($input[$field], $max);
                if ($field === 'full_name' && $value === '') rvu_club_json(['detail' => 'Member name cannot be empty.'], 422);
                if ($field === 'status' && !in_array($value, ['active','inactive'], true)) {
                    rvu_club_json(['detail' => 'Invalid member status.'], 422);
                }
                $fields[] = "$field = ?";
                $params[] = $value;
            }
        }
        if (array_key_exists('joined_at', $input)) {
            $fields[] = 'joined_at = ?';
            $params[] = trim((string)$input['joined_at']);
        }
        if (!$fields) rvu_club_json(['detail' => 'No editable member fields were provided.'], 422);
        $fields[] = 'updated_at = CURRENT_TIMESTAMP';
        $params[] = $memberId;
        $pdo->prepare('UPDATE campus_club_members SET ' . implode(', ', $fields) . ' WHERE id = ?')->execute($params);
        $fetch = $pdo->prepare('SELECT * FROM campus_club_members WHERE id = ?');
        $fetch->execute([$memberId]);
        $row = $fetch->fetch(PDO::FETCH_ASSOC);
        $row['id'] = (int)$row['id'];
        $row['club_id'] = (int)$row['club_id'];
        rvu_club_json(['message' => 'Club member updated.', 'data' => $row]);
    }

    if ($method === 'DELETE' && $memberId !== null) {
        $stmt = $pdo->prepare("SELECT m.id, m.club_id, c.created_by, c.campus, c.status FROM campus_club_members m INNER JOIN campus_clubs c ON c.id = m.club_id WHERE m.id = ?");
        $stmt->execute([$memberId]);
        $row = $stmt->fetch(PDO::FETCH_ASSOC);
        if (!$row) rvu_club_json(['detail' => 'Club member not found.'], 404);
        rvu_club_require_manage($user, $row);
        $pdo->prepare('DELETE FROM campus_club_members WHERE id = ?')->execute([$memberId]);
        rvu_club_json(['message' => 'Club member removed.']);
    }

    rvu_club_json(['detail' => 'Unsupported request.'], 405);
} catch (Throwable $e) {
    rvu_club_json(['detail' => 'Club members server error: ' . $e->getMessage()], 500);
}
