Ascend — Class Calendar

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_244":245,"_246":247},"routes/_app.x.$handle.$name",{"_95":94,"_32":43,"_104":85,"_27":105,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":47,"_119":120,"_121":25,"_122":-5,"_123":-5,"_124":125},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_32":43,"_36":44,"_45":-5,"_46":47,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":47},"version",42,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":20,"_34":35,"_36":37,"_38":14,"_39":40,"_24":25},"previous",{"_30":31,"_32":28,"_33":20,"_34":35},"deleted",true,"deletedHere","path","Builder-copy.html","latestPath","fileId","3c437024-8a19-11f1-98c5-1607ee4eb77e","name","fileType","content","\n\n\n\n\nAscend — Class Calendar\n\n\n\n\n\n\n\n\n

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

\n\n

\nNew class\n\n

\n\n\n\n\n\n\n\n","createdAt",["D",1785197646076],"branchVersion","branchId","dd297312-a0e0-46c0-8fd4-ae063ca9c96e","id","6896f76d-f9a5-4e0d-9971-1bf89f3e6319","Schedule_Builder",["D",1784924009269],"deletedAt","legacyEnvVars",false,"privacy","public","httpPrivacy","description","front end schedule builder/editter","imageUrl","44ce8aa9-1ed9-4504-91ee-c68325632994","pinnedFileId","d9a211c8-879d-11f1-bd7d-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019f56a8-ec15-7479-9c4c-4a6e2eb98c2f","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_103":99},"org",{"_95":94,"_96":97,"_98":99,"_18":-5,"_100":101,"_102":47},"branch",{"_13":84,"_32":85,"_41":40,"_86":42,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":43,"_93":94},"isOwned",80,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","ascendfitnesslakemary","handle","displayName","Ascendfitness","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/cb3dc115-6116-4059-3e38-e7f87c778300/square512?exp=1789574399&sig=d75b53406c9337f7ebf3f974cffd118a127025d56f8f2ab376c2d518c5521aa6","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_41":42,"_32":43,"_36":240,"_45":-5,"_46":47,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":241,"_79":242,"_81":243,"_83":47},"tree",[215,216,217,218,219,220],"files",[215,216,217,218,219,220],"counts",{"_204":61,"_205":170,"_206":61,"_207":208,"_209":210},"contents",[149,150,151,152,153,154],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[126,127,128,129,130,131,132,133,134,135,136],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":148,"_138":-5},{"_41":147,"_138":-5},{"_41":146,"_138":-5},{"_41":145,"_138":-5},{"_41":144,"_138":-5},{"_41":143,"_138":-5},{"_41":142,"_138":-5},{"_41":141,"_138":-5},{"_41":140,"_138":-5},{"_41":139,"_138":-5},{"_41":137,"_138":-5},"3c619b5e-7239-4ab2-ac99-e70e4eb71179","reporterId","45dc40f3-452d-44f1-a3ab-2d8ced3bce36","dc08f899-7fc0-43f5-8f34-cd19919d5b9c","5b50fc21-16c9-4a3e-a2f0-8d0ae6cefe06","aafc8ad6-80f8-4318-b82f-6fcd3a96d074","654e6e0b-82d7-4dd8-8245-dff30ce6461a","f494887a-621f-46e9-a7bc-92891e30a2af","49c9129e-5e9c-410f-9c49-a3be8916dc90","fecdfc39-ce90-439c-a827-cb5f7a4e69f7","408de5f9-208f-470f-942c-2115e5ff2880","19d5d311-ab8e-4321-9b83-ddd3c3533afa",{"_41":197,"_32":198,"_30":199,"_158":-5,"_39":40,"_38":200,"_160":47,"_36":201,"_13":202,"_33":20,"_34":35,"_24":47,"_164":-5,"_27":203},{"_41":189,"_32":190,"_30":191,"_158":-5,"_39":40,"_38":192,"_160":47,"_36":193,"_13":194,"_33":162,"_34":195,"_24":47,"_164":-5,"_27":196},{"_41":182,"_32":183,"_30":184,"_158":-5,"_39":40,"_38":185,"_160":47,"_36":186,"_13":61,"_33":162,"_34":187,"_24":47,"_164":-5,"_27":188},{"_41":174,"_32":175,"_30":176,"_158":-5,"_39":40,"_38":177,"_160":47,"_36":178,"_13":179,"_33":162,"_34":180,"_24":47,"_164":-5,"_27":181},{"_41":166,"_32":167,"_30":56,"_158":-5,"_39":40,"_38":168,"_160":25,"_36":169,"_13":170,"_33":171,"_34":172,"_24":47,"_164":-5,"_27":173},{"_41":155,"_32":156,"_30":157,"_158":-5,"_39":40,"_38":159,"_160":25,"_36":161,"_13":61,"_33":162,"_34":163,"_24":47,"_164":-5,"_27":165},"fd63dcd5-9906-45dd-9efa-b836c6d0d86f","logo_data.ts","8c87d192-8834-11f1-87c6-1607ee4eb77e","parentId",21,"latest",["D",1784989470246],"script","/**\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","label",[156],"1a8b5a60-7f1f-4803-bca2-b304cbeb692a","index.ts",20,["D",1784982122663],1,"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",[167],"dc937596-8dda-4ab6-9fef-70d3bf65b05a","Builder_val_main.ts","22c16f4a-879c-11f1-ab32-1607ee4eb77e",30,["D",1785192055014],10,"/**\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\";\n\nconst DOW = [\"Sun\", \"Mon\", \"Tues\", \"Wed\", \"Thur\", \"Fri\", \"Sat\"];\nconst PROGRAM_MAP: Record = {\n team: \"Team\",\n youth: \"Youth\",\n opengym: null,\n internal: null,\n};\nconst TYPE_LABEL: Record = {\n team: \"Team\",\n youth: \"Youth\",\n opengym: \"Open Gym\",\n internal: \"Internal\",\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\"])\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 if (blockId && day && program) {\n workoutMap.set(`${blockId}|${day}|${program}`, r.id);\n }\n }\n return { blocks, workoutMap };\n}\nfunction findWorkout(\n date: string,\n programKey: string,\n idx: { blocks: any[]; workoutMap: Map },\n): string | null {\n const atProgram = PROGRAM_MAP[programKey];\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 return idx.workoutMap.get(`${block.id}|${dow}|${atProgram}`) || 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(\"/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\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 \"Link to Workouts\",\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[\"Link to Workouts\"] || [])[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 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 workoutId = findWorkout(date, it.program || \"team\", idx);\n const fields: any = {\n Date: date,\n Time: time,\n \"Push to Trainerize\": pushToTrainerize,\n };\n fields[\"Type\"] = TYPE_LABEL[it.program || \"team\"] || \"Team\";\n if (it.coachRecId) fields[\"Coach\"] = [it.coachRecId];\n if (it.capacity != null) fields[\"Capacity\"] = Number(it.capacity);\n if (it.duration != null) fields[\"Duration\"] = Number(it.duration);\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[\"Link to Workouts\"] = [workoutId];\n toCreate.push({ fields });\n results.push({\n date,\n time,\n program: it.program || \"team\",\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 if (body.program) fields[\"Type\"] = TYPE_LABEL[body.program] || \"Team\";\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 if (body.date && body.program) {\n const idx = await loadWorkoutIndex();\n const wid = findWorkout(body.date, body.program, idx);\n fields[\"Link to Workouts\"] = wid ? [wid] : [];\n }\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) ──\nconst ATT_FIELDS = [\"Class\", \"Client\", \"Attendance Type\", \"Source\"];\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 (!classId) return json({ success: false, error: \"classId required\" }, 400);\n const safe = classId.replace(/'/g, \"\\\\'\");\n const recs = await fetchAllRecords(\n ATTENDANCE_TABLE,\n ATT_FIELDS,\n `FIND('${safe}', ARRAYJOIN({Class}))`,\n );\n const names = await rosterNameMap();\n const participants = recs.map((r: any) => {\n const clientId = (r.fields[\"Client\"] || [])[0] || null;\n return {\n id: r.id,\n clientId,\n name: (clientId && names.get(clientId)) || \"Unknown\",\n status: r.fields[\"Attendance Type\"] || \"\",\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",[175],"78121f00-eca5-4d85-ab9c-493d6f9fb26b","Builder_participants.js","367e9f9a-8a0c-11f1-bbc0-1607ee4eb77e",29,["D",1785192048360],"/**\n * Ascend Schedule Builder — participants / reservations module.\n *\n * Loaded by Builder.html as a SECOND classic

Diff · v42