Ascend — Class Calendar

\n\n\n\n\n\n

\n\n

\nNew class\n\n

\n\n\n\n\n\n\n\n\n","label",[18],"pulls","branches",1,"forks","envVars",{"_296":298,"_299":26},"connections",{"_296":26,"_297":26},"count","unfilledCount",4,"emptyCount",{"_45":279,"_13":18,"_74":75,"_55":-5,"_47":48,"_280":176,"_281":195,"_49":349,"_51":283,"_77":21,"_284":285,"_79":24,"_286":-5,"_312":350,"_17":351},{"_45":340,"_13":341,"_74":342,"_55":-5,"_47":48,"_280":343,"_281":195,"_49":344,"_51":345,"_77":78,"_284":346,"_79":24,"_286":-5,"_312":347,"_17":348},{"_45":332,"_13":333,"_74":334,"_55":-5,"_47":48,"_280":335,"_281":195,"_49":336,"_51":290,"_77":78,"_284":337,"_79":24,"_286":-5,"_312":338,"_17":339},{"_45":323,"_13":324,"_74":325,"_55":-5,"_47":48,"_280":326,"_281":195,"_49":327,"_51":328,"_77":78,"_284":329,"_79":24,"_286":-5,"_312":330,"_17":331},{"_45":315,"_13":316,"_74":193,"_55":-5,"_47":48,"_280":317,"_281":195,"_49":318,"_51":290,"_77":319,"_284":320,"_79":24,"_286":-5,"_312":321,"_17":322},{"_45":306,"_13":307,"_74":308,"_55":-5,"_47":48,"_280":309,"_281":195,"_49":310,"_51":26,"_77":78,"_284":311,"_79":24,"_286":-5,"_312":313,"_17":314},"fd63dcd5-9906-45dd-9efa-b836c6d0d86f","logo_data.ts","8c87d192-8834-11f1-87c6-1607ee4eb77e",21,["D",1784989470246],"/**\n * Ascend wordmark, inlined as base64 PNG.\n *\n * Why inline instead of a binary file in the val: binary uploads to this val\n * were failing, so the logo lives here as text and is decoded and served by\n * Builder_val_main.ts at /Ascend_logo.png.\n *\n * Source: Ascend_logo.png (341x96 RGBA). Re-rendered at 277x78 (3x the 26px\n * CSS display height, so it stays crisp on retina), flattened to the single\n * brand colour #5FACF7 with a 16-level alpha ramp — ~2.8KB instead of 25KB.\n *\n * To replace: re-encode a PNG to base64 and paste it below.\n */\nexport const LOGO_B64 = `\niVBORw0KGgoAAAANSUhEUgAAARUAAABOBAMAAAD8/p9RAAAAMFBMVEVfrPdfrPdfrPdfrPdfrPdfrPdfrPdfrPcAAAAAAAAAAAAA\nAAAAAAAAAAAAAAAAAABiS6fnAAAAEHRSTlMA/UvVKm2yjwAAAAAAAAAASht2lQAACmVJREFUeNrNmf1zVNUZxz979u6GRgN7siGx\ninBDCLZidJcdxIrAhqwwtZRuBLVWhchLptPpKBlo/wfHTqd2ajvTsU5kaDtTKKyM2EF8WahgR4XGYrU1GC4p0ClI2IIGyN7c7Q/3\ndZd7l3WmEzi/7N17zp773ef5Ps/zfc6FKkNZxUQOUW1SP37dYHmwOtIJxdIEIn2dYBlXhpTYdYFlCTA+rl4XWI4zEBIGysRhCQfO\nxD4vjrZ/o1AcuQ7sku0MLUpoTCB5g11QCBmJVz6T+evAR0qpeXigTv/4kZh2zX1kaFpreEVp+oGJi+pQ0ERdPQij9UTDrflrbpf7\nAINQKJ6/DmL6EsC50sjFax/TViwbK659HCnHLKx12jXnbuRGa37i0m6gjwzrcwJdFIhlOhM/RHXqUqixbiieuqVkMhWTmfJvGYBM\nuka+iCnW59y9lVP3J/cOrzq7vXz55r1a+30/tb61jQDMBEDryENrwUu7rsMszplPmAkQtn8YgCU82fyM3n6sIo5WvglA94uee8tO\nawCz/2OubfUac4oGrQXR4abMzgEW55zgAGg9XM1HT9kyM1FhyTYTCjvXeqC8a2L4ZDRQBRpV9eGxtVWwiH5bxPTvKq9Sjq13Zp3w\nP21fFUcD1c6frhDT3i87NwZjCblCs9yJP3Av37Evfuh6sXg+CMtYdeH8u3SgllpheTfy5mRD9RCmrh+YPX0gOagxls2ZlOoH2qcN\nzKvPwTFrdZdDmdftBufK/K00AKRCe6H4eSDMpDRHY6eUPZ77rVLKzQDLpJRN5r0npZRrAZRNUspGc1W5FVqllM0ud6XMgnA2YJmU\nMp4O8JHQPNnHS5gYtP0EYM9c+6d1OWh9EUB/LgulIMYUs4G5fc88k9y+WCLO1YEyLwoNYYXiPpWiCvAARKwEoG8NSI4A7A9my2s9\nsDsAS8nt7rEeaSfcksUkXYUsoGjwgJ07iukqYj5UhbrPg572x7LAvlhuZCHmjUOnTuVMEwjN9Si8wqz3A1NMTzCWMRUS/lhirk/y\nMOwtUmmPHz8EbnFNBRTXvxfUbcHuKoYpwNbqWMJ5hiuM69DBkPIzE95qz/SzQQ97G/Qqbd9JCPliETnXJwIMJwLy8IrDpKEhDZQc\nYqAWPVBUq9Aa9CAskYo9NA93Kw5kQiBqaxRi8O/gWSNLMe2HZcwbTwU46eFuRZYPwYzahNLbMJatShhN+PPMHIuAYTcnofc4NdU2\nG9xRG5ZiFt4Onh6ArB8WzUvUkpcwPwd2zvMsDWKBTyXc4s1bV4xhKPhgiWiVysO5EVKBoy3ukxLgS10t7ZfrjI3VeqMBJbgFoDUP\noGouYfSP6oExfdV29/+rfg1U/ELKesa7zm/TebZU6438+LKivBfY5UHH5UYA4w0PaXzDaMgen7r3dlepnEG6zinSBXuFSxg+XWIK\nsXlfvuUwVF8eVcPi0MVKHGUZBv44FYCjXx6MXvCRmtWx3Gdf3OJWoZOe+U/uVgGOzrVsWPuB3omrSM0ruavagXG+1yGE4V2wR/S9\nCBzL5mCgzGbuWG/fHd/hTTE5P6nppFUvFmXT4Ei+zi5GyoxtnhSd8zr+uQf3WuJbHSDht/t7+YAkMhxsFtXjI/HEr9868qPv2V8f\nK/ilP9Pzf7gbM6XvD6Cj/79/y1dqArAQEh4sa3JgvGAbQPxKK6/pZWPP3aZqDAfEtBoopwKk5hDEXCzi72UblO71zX8OmEaIQKmq\n1f20ZCgdpLVyLhajXnrsJxoLFTW9su8EHUp8qRcGRlA3q+QRquJNoJ5+W2ibYEiocA62wYkr7d1vpPN6NldUaz9F02MFdvsV9pCG\nki/7V8W043yhP4PSOeUZAPr6OQ4oa9Hd44WcHfDpfs//06uDOVWPHvM3WLE813neXI3Nytz2xPtvOuLCSAPbtnn0s6nbT5bn0jXV\n22Yuq/5kfwqml2P5tieLnDt7OmfPHgQjAajo3rAN50Evk2vRHaPqVaVmwLmGWoZlqRexoQHWa7VxYCvoCY8CqdMoWWF6wPnRY4FN\nuupKTZ8xAyI5LxZxJpByPeZBcB5+7zn9mGFJPd02TFvOLmcatbfVIGJgeGuj8vSVG0Q1hzBjZokcs5RLWz9Ms1vTg+a/XjYC0VyV\nXGdJzSsC+mkNbvRi+U6/T0ew0bVswswNOzfMgiUPj0AkZ4YpFEcfTJN55DTw6NXCuuQDpd/sy52mcKlv9znDLNpKh0b4M+g6DIi2\njsOaC17cpQEzTYIpZ8yzw5nuFg15Wgvc5XCxO491jilUl5mLc27WjPiSxe4JdVUjDOzr0MAYHASIWHY0pmpmPQG44YxTXpyDzIo9\nd9/ghIe7KpRztZS4w5dtTtjsMgmjf+TOOfXqtSXugWsNKdivCETudHWdWBOwSd4j/xLA5anOY91c9LKtxLtfuApxbalZCaU+b/Ul\nEFntlUo8/FXDWh+91cJofL3Ah6PA2YX3fAy0J7d6/ul7y40CRNb80jL4Je9ukwrIS1xyEVyMoP6D0CTnRvuYZvclSlu95q1vXdvp\nzlce3d52JyWzKVIWxfnrtIpEnjmeODTdvnd/WXI9k+f+GNs8dx7iTB6l2xKhA8LeLPRj9mqRzk8cLKJzu3OKLhpqL8H/hyE+KMx7\ncuRm55nt3dtdj69Umegh+qR5oBu/rdlUXZE+KaVMpicWRxhl8xf7u0YKQNNNR775qsnGQ1EgPFmbWJvAsbb/GtpssqHB99nulLBV\nM1NHq584Kenq3682zPUVr7TEpviGZXNby8gRsZZsmg/r5tG2UUmpRBOsk/H55pRIWvq4KynlPFgm5WZESsY3oKRUoo0A0aSUMh1N\niGQ8KbN1LdCWFSkpZQ+zpZyfZqV1gG/nl9BNk3coTTPfoVK+AF87cM+Joc+/iN30t9GxixRHWXpv/YlTAGJ88b6LAOrQutTgpPNn\nV92yY/7xyxuSW79/cFLTqdXz/wKgr5wz56z6cXF5+6GVBy6EvzuQ5p+XV82Z0/BuaV3TtHOnTi+ZNXiyRkM+2bcx2txCa48Sl2pX\njCREzNcM0ca2RgA6E9CnRqdC30bRAksbicTrrEVNAOGYeRWNN9OdFS0AkRaAzqbqZx7lY9fWBctNCybO54E0RavpL12w3gMcl/K3\n2sIiDOQBXo9QXH37zdb+vb1r3fa/tKBnAMakjFO6Wcr5HByXcn1wb1+pGo4kXjY7tT83ZPe5P1E60lvaEzmAaDb2+u3uTmHg+YYO\nK60e8ioW8eqUBSVEZjrP6h88pL6WzS2aW/pNrWTvS6fiYiqtPUozXbKJZCYzuwWgbqqSNN8tdSZQ+tS65rRIZkVzJtPdBEoLPj6q\na6RPmj5Kswq6s4qKkkrX6KOCNl3Yi/apwLlzZx4FKBprNKuM/yvVsEUd/9aRu07lKB46tP9GMErOiTDuEU0JfoHKWCqVLChvpFL7\nC+JCqmM4XyOWg+roAvEYswv6GvTmx5mdyXT9DMCIH1nXnACIrs/0dub1l7KRryB6e3sXaiAet7bvAdjfA6XHQV9LcWlO9GYyS9N6\nM+HOvNFF1NFW/wPrFDoZRZteNwAAAABJRU5ErkJggg==\n`.replace(/\\s+/g, \"\");\n","children",[],[307],"1a8b5a60-7f1f-4803-bca2-b304cbeb692a","index.ts",20,["D",1784982122663],"http","/**\n * Ascend Schedule Builder — HTTP entrypoint.\n *\n * The gateway (ascendfitness/ascend-gateway) routes\n * https://ascend.val.run/lakemaryfl/builder to THIS file's endpoint, so this\n * file must stay the val's HTTP-type file. All server logic lives in\n * Builder_val_main.ts — edit that file, not this one.\n */\nexport { default } from \"./Builder_val_main.ts\";\n",[],[316],"0cfb7cac-98cd-4967-a0bf-e2fc4bf76b6d","Builder_val_main.ts","22c16f4a-879c-11f1-ab32-1607ee4eb77e",67,["D",1786229719207],24,"/**\n * Ascend Schedule Builder — server (Val Town HTTP val)\n * Serves the builder UI behind HTTP Basic Auth and reads/writes the Airtable base\n * (the PAT never reaches the browser). \"Push to Trainerize\" is set here; the actual\n * Trainerize push still runs from the trainerize sync val's /pushClass.\n *\n * Files in this val:\n * - this file (HTTP) → server\n * - builder.html (static) → UI shell (HTML+CSS)\n * - builder.js (static) → UI logic\n * - Ascend_logo.png (static) → header logo\n *\n * Env vars to set on THIS val:\n * AT_PAT, AT_BASE_ID (=appAUyXe4LgupwX0f), BASIC_USER, BASIC_PASS\n *\n * URL: /lakemaryfl/builder (any path ending in /builder works)\n */\n\nimport { serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { LOGO_B64 } from \"./logo_data.ts\";\n\nconst AT_PAT = Deno.env.get(\"AT_PAT\")!;\nconst AT_BASE_ID = Deno.env.get(\"AT_BASE_ID\")!;\nconst BASIC_USER = Deno.env.get(\"BASIC_USER\") || \"\";\nconst BASIC_PASS = Deno.env.get(\"BASIC_PASS\") || \"\";\nasync function servePage(name: string) {\n return await serveFile(`/${name}`, import.meta.url);\n}\nfunction serveLogo() {\n const bin = Uint8Array.from(atob(LOGO_B64), (c) => c.charCodeAt(0));\n return new Response(bin, {\n headers: {\n \"Content-Type\": \"image/png\",\n \"Cache-Control\": \"public, max-age=86400\",\n },\n });\n}\n\n// Airtable table IDs (Team Training base)\nconst STAFF_TABLE = \"tblBfxQjKCie5ch5U\";\nconst CLASSES_TABLE = \"tblmj5ezsqdd6bm4S\";\nconst ROSTER_TABLE = \"tbl9fSFXxA6NXGCZ8\";\nconst ATTENDANCE_TABLE = \"tblEGksWB6sBy5bAB\";\nconst BLOCKS_TABLE = \"tblSnFCbPQFpLI15a\";\nconst WORKOUTS_TABLE = \"tblejHe7t8gOEeuCO\";\nconst CLASS_TYPES_TABLE = \"tblgB5KsbYEMfGv13\";\n\nconst DOW = [\"Sun\", \"Mon\", \"Tues\", \"Wed\", \"Thur\", \"Fri\", \"Sat\"];\n\n// ── Class types ───────────────────────────────────────────────────────────────\n// These used to be the hardcoded PROGRAM_MAP / TYPE_LABEL pair here, PROG_LABELS /\n// PROG_ORDER / PROG_COLORS in Builder.js, and regex name-matching in the Trainerize\n// sync — four places to edit for one new type. The Class Types table now owns all of\n// it: add a row there and the type appears in the builder.\n//\n// \"Show in Trainerize\" is the switch that matters. When it is off the class is created\n// with Push to Trainerize unticked AND the push job skips the type outright, so a class\n// can never leak into Trainerize even if someone ticks the box by hand.\ntype ClassType = {\n key: string;\n name: string;\n showInTrainerize: boolean;\n trainerizeTypeId: string | null;\n autoWorkout: boolean;\n workoutProgram: string | null;\n duration: number | null;\n capacity: number | null;\n color: string;\n order: number;\n};\n\n// Used only when the table can't be read, so an Airtable blip degrades the builder\n// rather than leaving it with no types to pick from. Mirrors the original constants.\nconst FALLBACK_CLASS_TYPES: ClassType[] = [\n { key: \"team\", name: \"Team\", showInTrainerize: true, trainerizeTypeId: \"11197128\", autoWorkout: true, workoutProgram: \"Team\", duration: 50, capacity: 8, color: \"#11676a\", order: 1 },\n { key: \"youth\", name: \"Youth\", showInTrainerize: false, trainerizeTypeId: null, autoWorkout: true, workoutProgram: \"Youth\", duration: 50, capacity: 8, color: \"#1cabb0\", order: 2 },\n { key: \"opengym\", name: \"Open Gym\", showInTrainerize: true, trainerizeTypeId: \"11261469\", autoWorkout: false, workoutProgram: null, duration: 60, capacity: 8, color: \"#3ddbe1\", order: 3 },\n { key: \"internal\", name: \"Internal\", showInTrainerize: false, trainerizeTypeId: null, autoWorkout: false, workoutProgram: null, duration: 60, capacity: 8, color: \"#69f2c4\", order: 4 },\n];\n\nconst slug = (s: unknown) => String(s ?? \"\").toLowerCase().replace(/[^a-z0-9]/g, \"\");\n\nlet CLASS_TYPE_CACHE: { at: number; types: ClassType[] } | null = null;\nasync function loadClassTypes(): Promise {\n if (CLASS_TYPE_CACHE && Date.now() - CLASS_TYPE_CACHE.at < 60_000) {\n return CLASS_TYPE_CACHE.types;\n }\n try {\n const recs = await fetchAllRecords(CLASS_TYPES_TABLE, [\n \"Name\",\n \"Key\",\n \"Show in Trainerize\",\n \"Trainerize Class Type ID\",\n \"Auto-assign Workout\",\n \"Workout Program\",\n \"Default Duration\",\n \"Default Capacity\",\n \"Color\",\n \"Sort Order\",\n \"Active\",\n ]);\n const types: ClassType[] = recs\n .filter((r: any) => r.fields[\"Active\"] !== false && r.fields[\"Name\"])\n .map((r: any) => ({\n key: slug(r.fields[\"Key\"] || r.fields[\"Name\"]),\n name: String(r.fields[\"Name\"]),\n showInTrainerize: r.fields[\"Show in Trainerize\"] === true,\n trainerizeTypeId: r.fields[\"Trainerize Class Type ID\"]\n ? String(r.fields[\"Trainerize Class Type ID\"])\n : null,\n autoWorkout: r.fields[\"Auto-assign Workout\"] === true,\n workoutProgram: r.fields[\"Workout Program\"] || null,\n duration: r.fields[\"Default Duration\"] ?? null,\n capacity: r.fields[\"Default Capacity\"] ?? null,\n color: String(r.fields[\"Color\"] || \"#11676a\"),\n order: r.fields[\"Sort Order\"] ?? 999,\n }))\n .sort((a, b) => a.order - b.order || a.name.localeCompare(b.name));\n if (types.length) {\n CLASS_TYPE_CACHE = { at: Date.now(), types };\n return types;\n }\n console.warn(\"Class Types returned no active rows — using built-in fallback\");\n } catch (e) {\n console.error(\n \"Class Types unreadable, using built-in fallback:\",\n e instanceof Error ? e.message : e,\n );\n }\n return FALLBACK_CLASS_TYPES;\n}\n\n// The client may send the slug (\"opengym\") or the display name (\"Open Gym\"), and a saved\n// event may carry a name that has since been renamed. Fall back to the first type rather\n// than throwing, so a stale value can never block a save.\nfunction resolveClassType(types: ClassType[], v: unknown): ClassType {\n const want = slug(v);\n return types.find((t) => t.key === want) ||\n types.find((t) => slug(t.name) === want) ||\n types[0];\n}\n\nconst CORS = {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"GET, POST, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type, Authorization\",\n};\nfunction json(data: unknown, status = 200) {\n return new Response(JSON.stringify(data), {\n status,\n headers: { \"Content-Type\": \"application/json\", ...CORS },\n });\n}\n\n// ── HTTP Basic Auth ──\nfunction checkBasicAuth(req: Request): boolean {\n const h = req.headers.get(\"Authorization\") || \"\";\n if (!h.startsWith(\"Basic \")) return false;\n try {\n const dec = atob(h.slice(6));\n const i = dec.indexOf(\":\");\n return !!BASIC_USER && dec.slice(0, i) === BASIC_USER &&\n dec.slice(i + 1) === BASIC_PASS;\n } catch {\n return false;\n }\n}\nfunction authChallenge(): Response {\n return new Response(\"Authentication required\", {\n status: 401,\n headers: { \"WWW-Authenticate\": 'Basic realm=\"Ascend\", charset=\"UTF-8\"' },\n });\n}\n\n// ── Generic authenticated Airtable proxy ──\nasync function handleAt(req: Request) {\n const body = await req.json().catch(() => ({}));\n const op = body.op;\n const auth = { \"Authorization\": `Bearer ${AT_PAT}` };\n const pass = async (r: Response) =>\n new Response(await r.text(), {\n status: r.status,\n headers: { \"Content-Type\": \"application/json\", ...CORS },\n });\n try {\n if (op === \"schema\") {\n return pass(\n await fetch(\n `https://api.airtable.com/v0/meta/bases/${AT_BASE_ID}/tables`,\n { headers: auth },\n ),\n );\n }\n const table = body.table;\n if (!table) return json({ success: false, error: \"table required\" }, 400);\n const enc = encodeURIComponent(table);\n if (op === \"list\") {\n let url = `https://api.airtable.com/v0/${AT_BASE_ID}/${enc}?pageSize=100`;\n if (body.formula) {\n url += `&filterByFormula=${encodeURIComponent(body.formula)}`;\n }\n if (body.sort) {\n url += `&sort[0][field]=${\n encodeURIComponent(body.sort)\n }&sort[0][direction]=asc`;\n }\n let all: any[] = [], offset: string | undefined;\n do {\n const r = await fetch(url + (offset ? `&offset=${offset}` : \"\"), {\n headers: auth,\n });\n if (!r.ok) {\n return json(\n { success: false, error: `Airtable ${r.status}` },\n r.status,\n );\n }\n const d = await r.json();\n all = all.concat(d.records);\n offset = d.offset;\n if (body.max && all.length >= body.max) break;\n } while (offset);\n return json({ records: all });\n }\n if (op === \"update\") {\n return pass(\n await fetch(\n `https://api.airtable.com/v0/${AT_BASE_ID}/${enc}/${body.id}`,\n {\n method: \"PATCH\",\n headers: { ...auth, \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ fields: body.fields, typecast: true }),\n },\n ),\n );\n }\n if (op === \"create\") {\n return pass(\n await fetch(`https://api.airtable.com/v0/${AT_BASE_ID}/${enc}`, {\n method: \"POST\",\n headers: { ...auth, \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n records: [{ fields: body.fields }],\n typecast: true,\n }),\n }),\n );\n }\n if (op === \"delete\") {\n return pass(\n await fetch(\n `https://api.airtable.com/v0/${AT_BASE_ID}/${enc}/${body.id}`,\n { method: \"DELETE\", headers: auth },\n ),\n );\n }\n return json({ success: false, error: \"unknown op\" }, 400);\n } catch (e) {\n return json({\n success: false,\n error: e instanceof Error ? e.message : String(e),\n }, 500);\n }\n}\n\n// ── Airtable helpers ──\nasync function callAirtableAPI(path: string, method = \"GET\", body?: object) {\n const resp = await fetch(`https://api.airtable.com/v0/${path}`, {\n method,\n headers: {\n \"Authorization\": `Bearer ${AT_PAT}`,\n \"Content-Type\": \"application/json\",\n },\n body: body ? JSON.stringify(body) : undefined,\n });\n if (!resp.ok) {\n throw new Error(`Airtable ${resp.status} on ${path}: ${await resp.text()}`);\n }\n return resp.json();\n}\nfunction fieldsParam(fields: string[], extra?: Record): string {\n const p = new URLSearchParams();\n for (const f of fields) p.append(\"fields[]\", f);\n if (extra) { for (const [k, v] of Object.entries(extra)) p.append(k, v); }\n return p.toString();\n}\nasync function fetchAllRecords(\n tableId: string,\n fields: string[],\n filterFormula?: string,\n) {\n let records: any[] = [];\n let offset: string | undefined;\n do {\n const extra: Record = { pageSize: \"100\" };\n if (offset) extra.offset = offset;\n if (filterFormula) extra.filterByFormula = filterFormula;\n const resp = await callAirtableAPI(\n `${AT_BASE_ID}/${tableId}?${fieldsParam(fields, extra)}`,\n );\n records = records.concat(resp.records);\n offset = resp.offset;\n } while (offset);\n return records;\n}\nfunction blockNum(name: string): number | null {\n const m = (name || \"\").match(/block\\s*(\\d+)/i);\n return m ? parseInt(m[1]) : null;\n}\nfunction minToTimeSlot(min: number): string {\n const h = Math.floor(min / 60), m = min % 60;\n const ap = h >= 12 ? \"PM\" : \"AM\", hr = (h % 12) || 12;\n return `${hr}:${String(m).padStart(2, \"0\")} ${ap}`;\n}\nasync function loadWorkoutIndex() {\n const blocksResp = await callAirtableAPI(\n `${AT_BASE_ID}/${BLOCKS_TABLE}?${\n fieldsParam([\"Name\", \"Start Date\", \"End Date\"])\n }`,\n );\n const blocks = blocksResp.records.map((r: any) => ({\n id: r.id,\n start: r.fields[\"Start Date\"],\n end: r.fields[\"End Date\"],\n })).filter((b: any) => b.start && b.end);\n const woResp = await callAirtableAPI(\n `${AT_BASE_ID}/${WORKOUTS_TABLE}?${\n fieldsParam([\"Block\", \"Day\", \"Program\", \"Week\"])\n }`,\n );\n const workoutMap = new Map();\n for (const r of woResp.records) {\n const blockId = (r.fields[\"Block\"] || [])[0];\n const day = r.fields[\"Day\"];\n const program = r.fields[\"Program\"];\n // Week is a number field. Rows with a blank Week are intentionally NOT indexed —\n // a class in that block will come back workoutLinked:false rather than silently\n // grabbing some other week's workout.\n const week = r.fields[\"Week\"];\n if (blockId && day && program && week != null && week !== \"\") {\n workoutMap.set(`${blockId}|${day}|${program}|${Number(week)}`, r.id);\n }\n }\n return { blocks, workoutMap };\n}\n// atProgram is the Workouts.Program value to match (\"Team\" / \"Youth\"), taken from the\n// class type's Workout Program. Null means this type never carries a workout.\nfunction findWorkout(\n date: string,\n atProgram: string | null,\n idx: { blocks: any[]; workoutMap: Map },\n): string | null {\n if (!atProgram) return null;\n const dow = DOW[new Date(date + \"T00:00:00Z\").getUTCDay()];\n const block = idx.blocks.find((b) => b.start <= date && date <= b.end);\n if (!block) return null;\n // Mirrors the Classes \"Week #\" formula: FLOOR(DATETIME_DIFF(Date, Block Start,'days')/7)+1.\n // Computed from the Blocks table, NOT from that formula — the formula rolls Block Start up\n // through the Workout link, so relying on it here would be circular.\n const days = Math.floor(\n (Date.parse(date + \"T00:00:00Z\") - Date.parse(block.start + \"T00:00:00Z\")) / 86400000,\n );\n const week = Math.floor(days / 7) + 1;\n return idx.workoutMap.get(`${block.id}|${dow}|${atProgram}|${week}`) || null;\n}\n\n// ── Routes ──\nexport default async function (req: Request) {\n if (req.method === \"OPTIONS\") {\n return new Response(null, { status: 204, headers: CORS });\n }\n if (!checkBasicAuth(req)) return authChallenge();\n const url = new URL(req.url);\n const p = url.pathname;\n try {\n // Served UI (endsWith → location paths work, e.g. /lakemaryfl/builder)\n if (p === \"/\" || p === \"\" || p.endsWith(\"/builder\")) {\n return await servePage(\"Builder.html\");\n }\n if (p.endsWith(\"/builder_participants.js\")) {\n return await servePage(\"Builder_participants.js\");\n }\n if (p.endsWith(\"/builder.js\")) return await servePage(\"Builder.js\");\n if (p.endsWith(\"/Ascend_logo.png\")) return serveLogo();\n // Data API\n if (p.endsWith(\"/at\")) return await handleAt(req);\n if (p.endsWith(\"/classTypes\")) return await getClassTypes();\n if (p.endsWith(\"/blocks\")) return await getBlocks();\n if (p.endsWith(\"/staff\")) return await getStaff();\n if (p.endsWith(\"/clients\")) return await getClients(url);\n if (p.endsWith(\"/classes\")) return await getClasses(url);\n if (p.endsWith(\"/series\")) return await getSeries(url);\n if (p.endsWith(\"/createClass\")) return await createClass(req);\n if (p.endsWith(\"/updateClass\")) return await updateClass(req);\n if (p.endsWith(\"/deleteClass\")) return await deleteClass(req);\n if (p.endsWith(\"/addParticipants\")) return await addParticipants(req);\n if (p.endsWith(\"/participants\")) return await getParticipants(url);\n if (p.endsWith(\"/removeParticipant\")) return await removeParticipant(req);\n return json({ ok: true, service: \"ascend-builder\" });\n } catch (e) {\n return json({\n success: false,\n error: e instanceof Error ? e.message : String(e),\n }, 500);\n }\n}\n\n// Drives the builder's type chips, their colours, order and per-type defaults.\nasync function getClassTypes() {\n const types = await loadClassTypes();\n return json({ success: true, classTypes: types });\n}\nasync function getBlocks() {\n const recs = await fetchAllRecords(BLOCKS_TABLE, [\n \"Name\",\n \"Theme\",\n \"Start Date\",\n \"End Date\",\n ]);\n const blocks = recs.filter((r: any) =>\n r.fields[\"Start Date\"] && r.fields[\"End Date\"]\n )\n .map((r: any) => ({\n id: r.id,\n num: blockNum(r.fields[\"Name\"]),\n name: r.fields[\"Name\"],\n theme: r.fields[\"Theme\"] || \"\",\n start: r.fields[\"Start Date\"],\n end: r.fields[\"End Date\"],\n }))\n .sort((a: any, b: any) => (a.start < b.start ? -1 : 1));\n return json({ success: true, blocks });\n}\nasync function getStaff() {\n const recs = await fetchAllRecords(STAFF_TABLE, [\"Name\", \"Active\", \"Role\"]);\n const staff = recs.filter((r: any) =>\n r.fields[\"Active\"] === true && r.fields[\"Name\"]\n ).map((r: any) => ({\n id: r.id,\n name: r.fields[\"Name\"],\n role: r.fields[\"Role\"] || \"\",\n }));\n return json({ success: true, staff });\n}\nasync function getClients(url: URL) {\n const q = (url.searchParams.get(\"q\") || \"\").trim();\n const recs = await fetchAllRecords(ROSTER_TABLE, [\n \"Name\",\n \"Member Status\",\n \"First Name\",\n \"Last Name\",\n ]);\n let clients = recs.filter((r: any) => r.fields[\"Name\"]).map((r: any) => ({\n id: r.id,\n name: r.fields[\"Name\"],\n status: r.fields[\"Member Status\"] || \"\",\n }));\n if (q) {\n const ql = q.toLowerCase();\n clients = clients.filter((c: any) => c.name.toLowerCase().includes(ql));\n }\n clients.sort((a: any, b: any) => a.name.localeCompare(b.name));\n return json({\n success: true,\n count: clients.length,\n clients: clients.slice(0, 30),\n });\n}\nconst CLASS_FIELDS = [\n \"Date\",\n \"Time\",\n \"Coach\",\n \"Capacity\",\n \"Duration\",\n \"Type\",\n \"Program (from Link to Workouts)\",\n \"Workout\",\n \"Session Notes\",\n \"Announcement\",\n \"Series ID\",\n \"Push to Trainerize\",\n \"Trainerize Appointment ID\",\n];\nfunction mapClass(r: any) {\n return {\n id: r.id,\n date: r.fields[\"Date\"],\n time: r.fields[\"Time\"] || \"\",\n coachId: (r.fields[\"Coach\"] || [])[0] || null,\n capacity: r.fields[\"Capacity\"] ?? null,\n duration: r.fields[\"Duration\"] ?? null,\n type: r.fields[\"Type\"] ||\n (r.fields[\"Program (from Link to Workouts)\"] || [])[0] || null,\n program: (r.fields[\"Program (from Link to Workouts)\"] || [])[0] || null,\n workoutId: (r.fields[\"Workout\"] || [])[0] || null,\n notes: r.fields[\"Session Notes\"] || \"\",\n announcement: r.fields[\"Announcement\"] || \"\",\n seriesId: r.fields[\"Series ID\"] || null,\n pushed: !!r.fields[\"Trainerize Appointment ID\"],\n queued: r.fields[\"Push to Trainerize\"] === true,\n };\n}\nasync function getClasses(url: URL) {\n const from = url.searchParams.get(\"from\");\n const to = url.searchParams.get(\"to\");\n let filter: string | undefined;\n if (from && to) {\n filter = `AND(IS_AFTER({Date}, '${from}'), IS_BEFORE({Date}, '${to}'))`;\n }\n const recs = await fetchAllRecords(CLASSES_TABLE, CLASS_FIELDS, filter);\n const classes = recs.filter((r: any) => r.fields[\"Date\"]).map(mapClass);\n return json({ success: true, count: classes.length, classes });\n}\nasync function getSeries(url: URL) {\n const sid = (url.searchParams.get(\"seriesId\") || \"\").trim();\n if (!sid) return json({ success: false, error: \"seriesId required\" }, 400);\n const safe = sid.replace(/'/g, \"\\\\'\");\n const recs = await fetchAllRecords(\n CLASSES_TABLE,\n CLASS_FIELDS,\n `{Series ID} = '${safe}'`,\n );\n const classes = recs.filter((r: any) => r.fields[\"Date\"]).map(mapClass).sort((\n a: any,\n b: any,\n ) => (a.date < b.date ? -1 : a.date > b.date ? 1 : 0));\n return json({ success: true, count: classes.length, seriesId: sid, classes });\n}\nasync function createClass(req: Request) {\n const body = await req.json().catch(() => ({}));\n const items: any[] = body.classes || [];\n const dryRun = body.dryRun === true;\n const pushToTrainerize = body.pushToTrainerize !== false;\n if (!items.length) {\n return json({ success: false, error: \"No classes provided\" }, 400);\n }\n const idx = await loadWorkoutIndex();\n const types = await loadClassTypes();\n const results: any[] = [];\n const toCreate: any[] = [];\n for (const it of items) {\n const date = it.date;\n const time = it.time ||\n (typeof it.startMin === \"number\" ? minToTimeSlot(it.startMin) : null);\n if (!date || !time) {\n results.push({ date, error: \"missing date or time\" });\n continue;\n }\n const ct = resolveClassType(types, it.program);\n // Two gates on the workout: the type must carry one at all, and autoWorkout\n // defaults to true so only an explicit false opts out.\n const workoutId = it.autoWorkout === false || !ct.autoWorkout\n ? null\n : findWorkout(date, ct.workoutProgram, idx);\n const fields: any = {\n Date: date,\n Time: time,\n // A type that doesn't show in Trainerize is never queued, whatever the caller asked.\n \"Push to Trainerize\": ct.showInTrainerize && pushToTrainerize,\n // Written with typecast (see the create call below), so a brand new class type\n // materialises its Classes.Type option automatically — the Class Types row is the\n // only thing anyone has to add.\n Type: ct.name,\n };\n if (ct.trainerizeTypeId) fields[\"Trainerize Class Type ID\"] = ct.trainerizeTypeId;\n if (it.coachRecId) fields[\"Coach\"] = [it.coachRecId];\n // Fall back to the type's defaults when the panel didn't specify.\n const cap = it.capacity != null ? it.capacity : ct.capacity;\n const dur = it.duration != null ? it.duration : ct.duration;\n if (cap != null) fields[\"Capacity\"] = Number(cap);\n if (dur != null) fields[\"Duration\"] = Number(dur);\n if (it.notes) fields[\"Session Notes\"] = it.notes;\n if (it.announcement) fields[\"Announcement\"] = it.announcement;\n if (it.seriesId) fields[\"Series ID\"] = it.seriesId;\n if (workoutId) fields[\"Workout\"] = [workoutId];\n toCreate.push({ fields });\n results.push({\n date,\n time,\n program: ct.key,\n type: ct.name,\n queuedForTrainerize: ct.showInTrainerize && pushToTrainerize,\n workoutLinked: !!workoutId,\n });\n }\n if (dryRun) {\n return json({\n success: true,\n dryRun: true,\n wouldCreate: toCreate.length,\n results,\n });\n }\n const created: string[] = [];\n for (let i = 0; i < toCreate.length; i += 10) {\n const batch = toCreate.slice(i, i + 10);\n const resp = await callAirtableAPI(\n `${AT_BASE_ID}/${CLASSES_TABLE}`,\n \"POST\",\n { typecast: true, records: batch },\n );\n for (const r of resp.records) created.push(r.id);\n }\n return json({ success: true, created, count: created.length, results });\n}\nasync function updateClass(req: Request) {\n const body = await req.json().catch(() => ({}));\n const id = body.id;\n if (!id) return json({ success: false, error: \"id required\" }, 400);\n const fields: any = {};\n if (body.date) fields[\"Date\"] = body.date;\n if (body.time) fields[\"Time\"] = body.time;\n let ct: ClassType | null = null;\n if (body.program) {\n ct = resolveClassType(await loadClassTypes(), body.program);\n fields[\"Type\"] = ct.name;\n if (ct.trainerizeTypeId) fields[\"Trainerize Class Type ID\"] = ct.trainerizeTypeId;\n }\n if (body.coachRecId) fields[\"Coach\"] = [body.coachRecId];\n if (body.capacity != null) fields[\"Capacity\"] = Number(body.capacity);\n if (body.duration != null) fields[\"Duration\"] = Number(body.duration);\n if (body.announcement != null) fields[\"Announcement\"] = body.announcement;\n if (body.notes != null) fields[\"Session Notes\"] = body.notes;\n if (body.pushToTrainerize != null) {\n fields[\"Push to Trainerize\"] = !!body.pushToTrainerize;\n }\n // Changing a class TO a type that doesn't show in Trainerize must un-queue it, even\n // if the caller didn't mention pushToTrainerize — otherwise switching an existing\n // class to Foundations would leave it queued and it would publish anyway.\n if (ct && !ct.showInTrainerize) fields[\"Push to Trainerize\"] = false;\n // The Workout link is deliberately NOT touched on update. It is set once at creation\n // (see createClass / autoWorkout). A reschedule therefore KEEPS the workout it was given,\n // which is what a holiday/weather move actually wants — and it means a workout assigned by\n // hand in Airtable is never silently overwritten by an unrelated edit (coach, capacity, drag).\n // To re-point one, clear or change the Workout link in Airtable.\n // Note: a class moved across a block boundary keeps its old block's workout, which shows up\n // as a Week # above 5 — a useful tell that it needs re-pointing.\n const resp = await callAirtableAPI(\n `${AT_BASE_ID}/${CLASSES_TABLE}`,\n \"PATCH\",\n { typecast: true, records: [{ id, fields }] },\n );\n return json({ success: true, id: resp.records[0].id });\n}\nasync function deleteClass(req: Request) {\n const body = await req.json().catch(() => ({}));\n const ids: string[] = body.ids || (body.id ? [body.id] : []);\n if (!ids.length) return json({ success: false, error: \"ids required\" }, 400);\n let deleted = 0;\n for (let i = 0; i < ids.length; i += 10) {\n const batch = ids.slice(i, i + 10);\n const qs = batch.map((x) => `records[]=${encodeURIComponent(x)}`).join(\"&\");\n const resp = await fetch(\n `https://api.airtable.com/v0/${AT_BASE_ID}/${CLASSES_TABLE}?${qs}`,\n { method: \"DELETE\", headers: { \"Authorization\": `Bearer ${AT_PAT}` } },\n );\n if (!resp.ok) {\n throw new Error(`Airtable delete ${resp.status}: ${await resp.text()}`);\n }\n const j = await resp.json();\n deleted += (j.records || []).length;\n }\n return json({ success: true, deleted });\n}\nasync function addParticipants(req: Request) {\n const body = await req.json().catch(() => ({}));\n const classIds: string[] = body.classRecordIds || [];\n const clientIds: string[] = body.clientRecordIds || [];\n const dryRun = body.dryRun === true;\n if (!classIds.length || !clientIds.length) {\n return json({\n success: false,\n error: \"classRecordIds and clientRecordIds are required\",\n }, 400);\n }\n const records: any[] = [];\n for (const classId of classIds) {\n for (const clientId of clientIds) {\n records.push({\n fields: {\n Class: [classId],\n Client: [clientId],\n \"Attendance Type\": \"Reserved\",\n \"Source\": \"Schedule Builder\",\n },\n });\n }\n }\n if (dryRun) {\n return json({ success: true, dryRun: true, wouldCreate: records.length });\n }\n const created: string[] = [];\n for (let i = 0; i < records.length; i += 10) {\n const batch = records.slice(i, i + 10);\n const resp = await callAirtableAPI(\n `${AT_BASE_ID}/${ATTENDANCE_TABLE}`,\n \"POST\",\n { typecast: true, records: batch },\n );\n for (const r of resp.records) created.push(r.id);\n }\n return json({ success: true, created, count: created.length });\n}\n\n// ── Participants (Attendance records for one class) ──\n// \"Attendance Type\" is Reserved | Walk In. \"Attendance\" is Attended | No Show.\n// A walk-in who trained has Type=\"Walk In\", Attendance=\"Attended\" — attended but not reserved.\nconst ATT_FIELDS = [\"Class\", \"Client\", \"Attendance Type\", \"Attendance\", \"Source\"];\nconst CLASS_ATT_LINK = \"Attendance\"; // link field on Classes → Attendance records\nlet ROSTER_CACHE: { at: number; map: Map } | null = null;\nasync function rosterNameMap(): Promise> {\n if (ROSTER_CACHE && Date.now() - ROSTER_CACHE.at < 60_000) {\n return ROSTER_CACHE.map;\n }\n const recs = await fetchAllRecords(ROSTER_TABLE, [\"Name\"]);\n const map = new Map();\n for (const r of recs) if (r.fields[\"Name\"]) map.set(r.id, r.fields[\"Name\"]);\n ROSTER_CACHE = { at: Date.now(), map };\n return map;\n}\nasync function getParticipants(url: URL) {\n const classId = (url.searchParams.get(\"classId\") || \"\").trim();\n if (!/^rec[A-Za-z0-9]{14}$/.test(classId)) {\n return json({ success: false, error: \"valid classId required\" }, 400);\n }\n // Resolve via the Class record's Attendance link, NOT by filtering the Attendance table with\n // FIND(classId, ARRAYJOIN({Class})). In an Airtable formula a linked-record field renders as\n // the linked records' PRIMARY field — here Classes' \"Label\" (a date/time formula) — never a\n // record ID, so that filter silently matches nothing. This is the same reliable path the\n // kiosk uses; its own code labels the FIND version \"legacy ... may miss records\".\n const clsRecs = await fetchAllRecords(\n CLASSES_TABLE,\n [CLASS_ATT_LINK],\n `RECORD_ID()=\"${classId}\"`,\n );\n const attIds: string[] = clsRecs.length\n ? (clsRecs[0].fields[CLASS_ATT_LINK] || [])\n : [];\n if (!attIds.length) {\n return json({ success: true, count: 0, classId, participants: [] });\n }\n let recs: any[] = [];\n for (let i = 0; i < attIds.length; i += 40) {\n const formula = `OR(${\n attIds.slice(i, i + 40).map((x) => `RECORD_ID()=\"${x}\"`).join(\",\")\n })`;\n recs = recs.concat(await fetchAllRecords(ATTENDANCE_TABLE, ATT_FIELDS, formula));\n }\n const names = await rosterNameMap();\n const participants = recs.map((r: any) => {\n const clientId = (r.fields[\"Client\"] || [])[0] || null;\n const type = r.fields[\"Attendance Type\"] || \"\";\n const attendance = r.fields[\"Attendance\"] || \"\";\n return {\n id: r.id,\n clientId,\n name: (clientId && names.get(clientId)) || \"Unknown\",\n type,\n attendance,\n reserved: type === \"Reserved\",\n attended: attendance === \"Attended\",\n source: r.fields[\"Source\"] || \"\",\n };\n }).sort((a: any, b: any) => a.name.localeCompare(b.name));\n return json({ success: true, count: participants.length, classId, participants });\n}\nasync function removeParticipant(req: Request) {\n const body = await req.json().catch(() => ({}));\n const ids: string[] = body.attendanceIds || (body.id ? [body.id] : []);\n if (!ids.length) {\n return json({ success: false, error: \"attendanceIds required\" }, 400);\n }\n let deleted = 0;\n for (let i = 0; i < ids.length; i += 10) {\n const qs = ids.slice(i, i + 10).map((x) =>\n `records[]=${encodeURIComponent(x)}`\n ).join(\"&\");\n const resp = await fetch(\n `https://api.airtable.com/v0/${AT_BASE_ID}/${ATTENDANCE_TABLE}?${qs}`,\n { method: \"DELETE\", headers: { \"Authorization\": `Bearer ${AT_PAT}` } },\n );\n if (!resp.ok) {\n throw new Error(`Airtable delete ${resp.status}: ${await resp.text()}`);\n }\n const j = await resp.json();\n deleted += (j.records || []).length;\n }\n return json({ success: true, deleted });\n}\n",[],[324],"f0d8ef52-da76-49c9-a64d-8c46064c50c5","Builder_participants.js","367e9f9a-8a0c-11f1-bbc0-1607ee4eb77e",56,["D",1785371289424],"/**\n * Ascend Schedule Builder — participants / reservations module.\n *\n * Loaded by Builder.html as a SECOND classic

History · Builder.html