Level progress tracker: a Summer App for game teams

{
  "name": "Levels",
  "purpose": "Every level from blockout to done, with owners, blockers and playtest scores.",
  "permissions": ["data", "team:read"],
  "collections": {
    "levels": {
      "description": "One level of the game",
      "fields": {
        "name": { "type": "string", "required": true },
        "order": { "type": "integer", "description": "Position in the game, from 1" },
        "stage": { "type": "string", "required": true, "description": "blockout, art, lighting, playtest or done" },
        "owner": { "type": "string", "description": "Name of the team member who owns it" },
        "blocker": { "type": "string", "description": "What blocks it. Leave it out when nothing does." },
        "playtestScore": { "type": "number", "description": "Average fun score from 1 to 5 at the last playtest" },
        "scene": { "type": "string", "description": "res:// path of the level scene" }
      }
    }
  },
  "agentEvents": ["level.moved"],
  "agentTools": [
    {
      "name": "status_report",
      "description": "Levels per stage, blocked levels with their blockers, and the average playtest score, for a stand-up.",
      "input": { "type": "object", "properties": {} }
    }
  ]
}

{
  "appId": "<app id>",
  "as": "seed",
  "ops": [
    { "op": "put", "collection": "levels", "recordId": "ashfall-gate", "data": { "name": "Ashfall Gate", "order": 1, "stage": "done", "owner": "Mia", "playtestScore": 4.2, "scene": "res://levels/ashfall_gate.tscn" } },
    { "op": "put", "collection": "levels", "recordId": "cinder-mines", "data": { "name": "Cinder Mines", "order": 2, "stage": "playtest", "owner": "Tom", "playtestScore": 3.1, "scene": "res://levels/cinder_mines.tscn" } },
    { "op": "put", "collection": "levels", "recordId": "lantern-bridge", "data": { "name": "Lantern Bridge", "order": 3, "stage": "lighting", "owner": "Rae", "blocker": "Players fall through the bridge collision", "scene": "res://levels/lantern_bridge.tscn" } },
    { "op": "put", "collection": "levels", "recordId": "clocktower", "data": { "name": "Clocktower", "order": 4, "stage": "art", "owner": "Mia", "scene": "res://levels/clocktower.tscn" } },
    { "op": "put", "collection": "levels", "recordId": "drowned-chapel", "data": { "name": "Drowned Chapel", "order": 5, "stage": "blockout", "owner": "Tom", "scene": "res://levels/drowned_chapel.tscn" } }
  ]
}

{ "appId": "<app id>", "collection": "levels" }

{
  "appId": "<app id>",
  "ops": [
    { "op": "patch", "collection": "levels", "recordId": "lantern-bridge", "patch": { "stage": "playtest", "blocker": null }, "ifRevision": 1 }
  ]
}

const levels = summer.data.collection("levels");
const board = document.getElementById("board");
await summer.ready;

// summer-move fires before the card moves. Save it; on failure, load the board again.
board.addEventListener("summer-move", (event) => {
  const { cardId, toLane } = event.detail;
  levels.patch(cardId, { stage: toLane })
    .then(() => summer.agent.send("level.moved", { id: cardId, stage: toLane }))
    .catch((error) => { summerUI.toast(error.message, { tone: "error" }); load(); });
});

summer.agent.tool("status_report", async () => {
  const all = (await levels.list({ limit: 500 })).records.map((r) => ({ id: r.recordId, ...r.data }));
  const scored = all.filter((l) => typeof l.playtestScore === "number");
  const perStage = {};
  for (const l of all) perStage[l.stage] = (perStage[l.stage] ?? 0) + 1;
  return {
    perStage,
    blocked: all.filter((l) => l.blocker).map((l) => ({ id: l.id, name: l.name, blocker: l.blocker, owner: l.owner })),
    averageScore: scored.length ? scored.reduce((sum, l) => sum + l.playtestScore, 0) / scored.length : null,
  };
});