GET /api/creation-board — Community Creation Ideas

GET /api/creation-board

{
  "ideas": [
    {
      "id": "rec_abc123",
      "cardId": "card_01",
      "author": "晴天",
      "tags": "场景设计",
      "content": "在图书馆门口设计一个傍晚相遇场景，夕阳从西侧廊柱透进来。",
      "images": [
        "https://oss.himematsu.cn/creation/rec_abc123_ref.png"
      ],
      "createdAt": "2026-04-30T10:00:00.000Z",
      "sortOrder": 1
    },
    {
      "id": "rec_def456",
      "cardId": "card_01",
      "author": "匿名",
      "tags": "台词建议",
      "content": "可以加一句「你也喜欢在这个时间来？」",
      "images": [],
      "createdAt": "2026-04-30T11:30:00.000Z",
      "sortOrder": 2
    }
  ],
  "headers": [
    {
      "cardId": "card_01",
      "location": "图书馆",
      "character": "姬松",
      "sortOrder": 1
    }
  ]
}

interface CreationEntry {
  id: string;
  cardId: string;
  author: string;
  tags: string;
  content: string;
  images: string[];
  createdAt: string;
  sortOrder: number;
}

interface CreationCard {
  id: string;          // same as cardId
  cardId: string;
  addIdeaUrl: string;  // link rendered as the "新增创意" button in the card header
  entries: CreationEntry[];
  location?: string;   // campus location name, from the matching CardHeaderInfo
  character?: string;  // galgame character name, from the matching CardHeaderInfo
}

interface CreationIdea {
  id: string;
  cardId: string;
  author: string;
  tags: string;
  content: string;
  images: string[];
  createdAt: string;
  sortOrder: number;
}

interface CardHeaderInfo {
  cardId: string;
  location: string;
  character: string;
  sortOrder: number;
}

interface CreationBoardResponse {
  ideas: CreationIdea[];
  headers: CardHeaderInfo[];
}

async function fetchCreationBoard(): Promise<CreationBoardResponse> {
  const res = await fetch("/api/creation-board");
  if (!res.ok) {
    throw new Error(`Failed to fetch creation board: ${res.status}`);
  }
  return res.json() as Promise<CreationBoardResponse>;
}

// Group ideas by cardId
const { ideas, headers } = await fetchCreationBoard();

const cardMap = new Map<string, CreationIdea[]>();
for (const idea of ideas) {
  const group = cardMap.get(idea.cardId) ?? [];
  group.push(idea);
  cardMap.set(idea.cardId, group);
}

// Sort cards according to header sortOrder
const sortedHeaders = [...headers].sort((a, b) => a.sortOrder - b.sortOrder);
for (const header of sortedHeaders) {
  const entries = cardMap.get(header.cardId) ?? [];
  console.log(
    `${header.character} @ ${header.location}: ${entries.length} idea(s)`
  );
}