[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_162":163,"_164":165},"routes/_app.x.$handle.$name",{"_93":92,"_31":43,"_101":83,"_26":102,"_13":14,"_103":-5,"_11":104,"_105":106,"_107":108,"_109":110,"_111":112,"_20":-5,"_113":-5,"_114":-5,"_115":24,"_116":117,"_118":119,"_120":-5,"_121":-5,"_122":123},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_31":43,"_36":44,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":-5,"_55":24,"_56":-5,"_57":-5,"_58":59,"_60":61,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":67,"_68":67,"_69":70,"_71":70,"_72":70,"_73":67,"_74":67,"_75":76,"_77":78,"_79":80,"_81":24},"version",2,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":27,"_32":33,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","deleted",false,"deletedHere","path","formsmasterics.ts","latestPath","fileId","5efa1fe0-6049-11f1-a493-1607ee4eb77e","name","fileType","http","content","const SUPABASE_URL = Deno.env.get(\"SUPABASE_URL\") || \"https://lmgplytnycmvuemhvmfc.supabase.co\";\nconst SUPABASE_SERVICE_ROLE_KEY = Deno.env.get(\"SUPABASE_SERVICE_ROLE_KEY\") || \"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6ImxtZ3BseXRueWNtdnVlbWh2bWZjIiwicm9sZSI6InNlcnZpY2Vfcm9sZSIsImlhdCI6MTc0NTk1NTg2MCwiZXhwIjoyMDYxNTMxODYwfQ.4lDkH1Tu1JNVqv0YqzCNjrLlpfBaGDcGnfIxJFSsOEo\";\nconst TZ = \"America/Chicago\";\n\ntype Family = { id: string; family_name: string | null };\ntype Player = { id: string; first_name?: string | null; last_name?: string | null };\ntype TeamRoster = { team_id: string | number | null; player_id?: string | number | null; status?: string | null };\ntype Team = { id: string | number; name: string | null };\ntype Game = {\n id: string | number;\n roster: string | null;\n date: string | null;\n time: string | null;\n opponent: string | null;\n location: string | null;\n city: string | null;\n field: string | null;\n game_type: string | null;\n display_type: string | null;\n notes: string | null;\n};\n\nfunction text(body: string, status = 200, headers: Record = {}) {\n return new Response(body, {\n status,\n headers: {\n \"Cache-Control\": \"no-store\",\n ...headers,\n },\n });\n}\n\nfunction supabaseHeaders() {\n return {\n \"apikey\": SUPABASE_SERVICE_ROLE_KEY,\n \"Authorization\": `Bearer ${SUPABASE_SERVICE_ROLE_KEY}`,\n \"Accept\": \"application/json\",\n \"Content-Type\": \"application/json\",\n };\n}\n\nasync function sbGet(table: string, params: Record): Promise {\n const url = new URL(`${SUPABASE_URL}/rest/v1/${table}`);\n for (const [key, value] of Object.entries(params)) url.searchParams.set(key, value);\n const res = await fetch(url.toString(), { headers: supabaseHeaders() });\n if (!res.ok) {\n const body = await res.text().catch(() => \"\");\n throw new Error(`Supabase ${table} GET failed: ${res.status} ${body.slice(0, 300)}`);\n }\n return await res.json();\n}\n\nasync function sbPatch(table: string, params: Record, body: unknown): Promise {\n const url = new URL(`${SUPABASE_URL}/rest/v1/${table}`);\n for (const [key, value] of Object.entries(params)) url.searchParams.set(key, value);\n const res = await fetch(url.toString(), {\n method: \"PATCH\",\n headers: { ...supabaseHeaders(), \"Prefer\": \"return=minimal\" },\n body: JSON.stringify(body),\n });\n if (!res.ok) {\n const txt = await res.text().catch(() => \"\");\n console.warn(`Supabase ${table} PATCH failed: ${res.status} ${txt.slice(0, 300)}`);\n }\n}\n\nfunction unique(items: T[]): T[] {\n return Array.from(new Set(items.filter((x) => x !== null && x !== undefined))) as T[];\n}\n\nfunction normalizeForMatch(value: string | null | undefined): string {\n return String(value || \"\").toLowerCase().replace(/alphaforms/g, \"formsacademy\").replace(/[^a-z0-9]/g, \"\");\n}\n\nfunction teamNameVariants(name: string): string[] {\n const raw = String(name || \"\").trim();\n const compact = normalizeForMatch(raw);\n const variants = new Set();\n if (compact) variants.add(compact);\n const yearMatch = raw.match(/'(\\d{2})\\s*([A-Za-z])?/);\n if (yearMatch) {\n const yy = yearMatch[1];\n const gender = (yearMatch[2] || \"\").toLowerCase();\n variants.add(`formsacademy${yy}${gender}`);\n variants.add(`alphaforms${yy}${gender}`.toLowerCase());\n variants.add(`formsacademy${yy}`);\n variants.add(`alphaforms${yy}`);\n variants.add(yy);\n }\n return Array.from(variants).map(normalizeForMatch).filter(Boolean);\n}\n\nfunction gameMatchesTeams(gameRoster: string | null | undefined, teamNames: string[]): boolean {\n const rosterNorm = normalizeForMatch(gameRoster);\n if (!rosterNorm) return false;\n for (const team of teamNames) {\n for (const variant of teamNameVariants(team)) {\n if (variant.length >= 2 && (rosterNorm.includes(variant) || variant.includes(rosterNorm))) return true;\n if (/^\\d{2}$/.test(variant) && rosterNorm.includes(variant)) return true;\n }\n }\n return false;\n}\n\nfunction chicagoDateParts(): string {\n const parts = new Intl.DateTimeFormat(\"en-CA\", { timeZone: TZ, year: \"numeric\", month: \"2-digit\", day: \"2-digit\" }).formatToParts(new Date());\n const y = parts.find((p) => p.type === \"year\")?.value;\n const m = parts.find((p) => p.type === \"month\")?.value;\n const d = parts.find((p) => p.type === \"day\")?.value;\n return `${y}-${m}-${d}`;\n}\n\nfunction formatUtcStamp(date = new Date()): string {\n return date.toISOString().replace(/[-:]/g, \"\").replace(/\\.\\d{3}Z$/, \"Z\");\n}\n\nfunction parseTimeToHHMMSS(time: string | null | undefined): string {\n const value = String(time || \"\").trim();\n if (!value) return \"000000\";\n const lower = value.toLowerCase();\n const ampm = lower.match(/\\b(am|pm)\\b/);\n const nums = lower.match(/(\\d{1,2})(?::(\\d{2}))?(?::(\\d{2}))?/);\n if (!nums) return \"000000\";\n let hour = Number(nums[1]);\n const minute = Number(nums[2] || \"0\");\n const second = Number(nums[3] || \"0\");\n if (ampm) {\n if (ampm[1] === \"pm\" && hour < 12) hour += 12;\n if (ampm[1] === \"am\" && hour === 12) hour = 0;\n }\n return `${String(hour).padStart(2, \"0\")}${String(minute).padStart(2, \"0\")}${String(second).padStart(2, \"0\")}`;\n}\n\nfunction toLocalIcsDateTime(date: string | null | undefined, time: string | null | undefined): string {\n const safeDate = String(date || \"\").slice(0, 10).replace(/-/g, \"\");\n return `${safeDate}T${parseTimeToHHMMSS(time)}`;\n}\n\nfunction addHoursLocalIcs(dtStart: string, hours = 2): string {\n const m = dtStart.match(/^(\\d{4})(\\d{2})(\\d{2})T(\\d{2})(\\d{2})(\\d{2})$/);\n if (!m) return dtStart;\n const hour = Number(m[4]) + hours;\n if (hour < 24) return `${m[1]}${m[2]}${m[3]}T${String(hour).padStart(2, \"0\")}${m[5]}${m[6]}`;\n return dtStart;\n}\n\nfunction escapeIcs(value: string | null | undefined): string {\n return String(value || \"\")\n .replace(/\\\\/g, \"\\\\\\\\\")\n .replace(/\\r?\\n/g, \"\\\\n\")\n .replace(/,/g, \"\\\\,\")\n .replace(/;/g, \"\\\\;\");\n}\n\nfunction foldLine(line: string): string {\n const max = 74;\n if (line.length <= max) return line;\n const chunks: string[] = [];\n let rest = line;\n chunks.push(rest.slice(0, max));\n rest = rest.slice(max);\n while (rest.length) {\n chunks.push(\" \" + rest.slice(0, max - 1));\n rest = rest.slice(max - 1);\n }\n return chunks.join(\"\\r\\n\");\n}\n\nfunction icsLine(name: string, value: string | null | undefined): string {\n return foldLine(`${name}:${escapeIcs(value)}`);\n}\n\nfunction buildDescription(game: Game): string {\n const parts: string[] = [];\n const type = [game.game_type, game.display_type].filter(Boolean).join(\" / \");\n if (type) parts.push(type);\n if (game.city) parts.push(`City: ${game.city}`);\n if (game.notes) parts.push(String(game.notes));\n return parts.join(\"\\n\");\n}\n\nfunction buildIcs(familyName: string, games: Game[]): string {\n const now = formatUtcStamp();\n const calName = `Forms Academy - ${familyName || \"Family\"}`;\n const lines: string[] = [\n \"BEGIN:VCALENDAR\",\n \"VERSION:2.0\",\n \"PRODID:-//Forms Academy//Forms Master Live Feed//EN\",\n \"CALSCALE:GREGORIAN\",\n \"METHOD:PUBLISH\",\n icsLine(\"X-WR-CALNAME\", calName),\n \"X-WR-TIMEZONE:America/Chicago\",\n \"BEGIN:VTIMEZONE\",\n \"TZID:America/Chicago\",\n \"BEGIN:DAYLIGHT\",\n \"TZOFFSETFROM:-0600\",\n \"TZOFFSETTO:-0500\",\n \"TZNAME:CDT\",\n \"DTSTART:19700308T020000\",\n \"RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=2SU\",\n \"END:DAYLIGHT\",\n \"BEGIN:STANDARD\",\n \"TZOFFSETFROM:-0500\",\n \"TZOFFSETTO:-0600\",\n \"TZNAME:CST\",\n \"DTSTART:19701101T020000\",\n \"RRULE:FREQ=YEARLY;BYMONTH=11;BYDAY=1SU\",\n \"END:STANDARD\",\n \"END:VTIMEZONE\",\n ];\n for (const game of games) {\n if (!game.date) continue;\n const dtStart = toLocalIcsDateTime(game.date, game.time);\n const location = [game.location, game.field].filter(Boolean).join(\" - \");\n const summary = `${game.roster || \"Forms Academy\"} vs ${game.opponent || \"TBD\"}`;\n lines.push(\n \"BEGIN:VEVENT\",\n icsLine(\"UID\", `${game.id}@formsacademy.com`),\n `DTSTAMP:${now}`,\n `DTSTART;TZID=America/Chicago:${dtStart}`,\n `DTEND;TZID=America/Chicago:${addHoursLocalIcs(dtStart, 2)}`,\n icsLine(\"SUMMARY\", summary),\n icsLine(\"LOCATION\", location),\n icsLine(\"DESCRIPTION\", buildDescription(game)),\n \"END:VEVENT\",\n );\n }\n lines.push(\"END:VCALENDAR\");\n return lines.join(\"\\r\\n\") + \"\\r\\n\";\n}\n\nexport default async function handler(req: Request): Promise {\n try {\n if (req.method !== \"GET\") return text(\"Method not allowed\", 405, { \"Allow\": \"GET\" });\n const url = new URL(req.url);\n const token = (url.searchParams.get(\"token\") || \"\").trim();\n if (!/^[a-fA-F0-9]{16,}$/.test(token)) return text(\"Missing or invalid token\", 401, { \"Content-Type\": \"text/plain; charset=utf-8\" });\n\n const families = await sbGet(\"p_families\", { ics_token: `eq.${token}`, select: \"id,family_name\", limit: \"1\" });\n const family = families[0];\n if (!family) return text(\"Missing or invalid token\", 401, { \"Content-Type\": \"text/plain; charset=utf-8\" });\n\n const players = await sbGet(\"players\", { family_id: `eq.${family.id}`, select: \"id,first_name,last_name\" });\n const playerIds = unique(players.map((p) => String(p.id))).filter(Boolean);\n let teamNames: string[] = [];\n if (playerIds.length) {\n const rosterRows = await sbGet(\"team_rosters\", { player_id: `in.(${playerIds.join(\",\")})`, select: \"team_id,player_id,status\" });\n const teamIds = unique(rosterRows.map((r) => r.team_id == null ? \"\" : String(r.team_id))).filter(Boolean);\n if (teamIds.length) {\n const teams = await sbGet(\"teams\", { id: `in.(${teamIds.join(\",\")})`, select: \"id,name\" });\n teamNames = unique(teams.map((t) => String(t.name || \"\").trim())).filter(Boolean);\n }\n }\n\n const today = chicagoDateParts();\n const games = await sbGet(\"cs_games\", {\n date: `gte.${today}`,\n select: \"id,roster,date,time,opponent,location,city,field,game_type,display_type,notes\",\n order: \"date.asc,time.asc\",\n limit: \"2000\",\n });\n const matchedGames = games.filter((g) => gameMatchesTeams(g.roster, teamNames));\n\n await sbPatch(\"p_families\", { id: `eq.${family.id}` }, { ics_token_last_used_at: new Date().toISOString() });\n\n const ics = buildIcs(family.family_name || \"Family\", matchedGames);\n return text(ics, 200, {\n \"Content-Type\": \"text/calendar; charset=utf-8\",\n \"Content-Disposition\": `inline; filename=\"forms-academy-${String(family.family_name || \"family\").toLowerCase().replace(/[^a-z0-9]+/g, \"-\")}.ics\"`,\n });\n } catch (err) {\n console.error(err);\n return text(\"Calendar feed temporarily unavailable\", 500, { \"Content-Type\": \"text/plain; charset=utf-8\" });\n }\n}\n","createdAt",["D",1780600366735],"branchVersion","branchId","073a3b77-7273-4ff7-8504-1738497804b4","id","7669cd9e-2967-47af-bd14-c02188d7e6aa","formsmasterics",["D",1780600307583],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Forms Academy ICS live feed","imageUrl","019cdfb8-beb5-7562-b6a2-fa005c0ee90f","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019cdfb8-beb5-7562-b6a2-fe2ba5beed97","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_93":92,"_100":96},"org",{"_93":92,"_94":-5,"_95":96,"_18":53,"_97":98,"_99":24},"branch",{"_13":82,"_31":83,"_41":40,"_84":42,"_85":-5,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":43,"_91":92},"isOwned",7,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","director","handle","displayName","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/1977df9e-bb24-475d-ff22-184507695c00/square512?exp=1789588799&sig=ea85957a4a4e9fb3a51d18b00e0dcdfc29bd39568e38ae8060124288bbec7280","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_41":42,"_31":43,"_36":158,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":-5,"_55":24,"_56":-5,"_57":-5,"_58":59,"_60":61,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":67,"_68":67,"_69":70,"_71":70,"_72":70,"_73":67,"_74":67,"_75":159,"_77":160,"_79":161,"_81":24},"tree",[149,150],"files",[149,150],"counts",{"_138":59,"_139":130,"_140":59,"_141":142,"_143":144},"contents",[124,125],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_41":135,"_31":27,"_29":30,"_129":-5,"_39":40,"_38":14,"_131":24,"_36":136,"_13":59,"_32":33,"_34":35,"_23":24,"_133":-5,"_26":137},{"_41":126,"_31":127,"_29":128,"_129":-5,"_39":40,"_38":130,"_131":24,"_36":132,"_13":59,"_32":33,"_34":35,"_23":24,"_133":-5,"_26":134},"8fd04551-10c6-41d6-9994-9ba5dd75b4c5","index.ts","3e0e68c2-6049-11f1-ad78-1607ee4eb77e","parentId",1,"latest",["D",1780600311511],"label",[127],"cc492e72-5af5-4831-bfdc-1238bba1e0aa",["D",1780600366735],[27],"pulls","branches","forks","envVars",{"_145":147,"_148":59},"connections",{"_145":59,"_146":59},"count","unfilledCount",3,"emptyCount",{"_41":135,"_31":27,"_29":30,"_129":-5,"_39":40,"_38":14,"_131":24,"_36":155,"_13":59,"_32":33,"_34":35,"_23":24,"_133":-5,"_152":156,"_26":157},{"_41":126,"_31":127,"_29":128,"_129":-5,"_39":40,"_38":130,"_131":24,"_36":151,"_13":59,"_32":33,"_34":35,"_23":24,"_133":-5,"_152":153,"_26":154},["D",1780600311511],"children",[],[127],["D",1780600366735],[],[27],["D",1780600307583],{"_93":92,"_100":96},{"_93":92,"_94":-5,"_95":96,"_18":53,"_97":98,"_99":24},{"_13":82,"_31":83,"_41":40,"_84":42,"_85":-5,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":43,"_91":92},"ctx",{"_75":-5,"_121":195,"_196":197,"_198":199,"_200":24,"_201":24,"_202":24,"_203":119,"_204":-5,"_205":-7,"_206":-7,"_207":59,"_208":24,"_209":24,"_210":-5,"_211":24,"_212":24,"_213":24,"_214":-5},"ENV",{"_166":167,"_168":169,"_170":83,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v2