[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_166":167,"_168":169},"routes/_app.x.$handle.$name",{"_95":94,"_32":45,"_103":85,"_27":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":25,"_118":119,"_120":121,"_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",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_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":25},"version",5,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","index.ts","latestPath","fileId","3e0e68c2-6049-11f1-ad78-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 SUPABASE_ANON_FALLBACK_KEY = Deno.env.get(\"SUPABASE_ANON_FALLBACK_KEY\") || \"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6ImxtZ3BseXRueWNtdnVlbWh2bWZjIiwicm9sZSI6ImFub24iLCJpYXQiOjE3NzMwNzQ5ODMsImV4cCI6MjA4ODY1MDk4M30.aLfnSeqMyvyxqwAzM9LQcT2RTMDujc3H3jnFylVmRI8\";\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 supabaseKeys(): string[] {\n return Array.from(new Set([SUPABASE_SERVICE_ROLE_KEY, SUPABASE_ANON_FALLBACK_KEY].filter(Boolean)));\n}\n\nfunction supabaseHeaders(key: string) {\n return {\n \"apikey\": key,\n \"Authorization\": `Bearer ${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 let lastError = \"\";\n for (const key of supabaseKeys()) {\n const res = await fetch(url.toString(), { headers: supabaseHeaders(key) });\n if (res.ok) return await res.json();\n const body = await res.text().catch(() => \"\");\n lastError = `${res.status} ${body.slice(0, 300)}`;\n if (res.status !== 401 && res.status !== 403) break;\n }\n throw new Error(`Supabase ${table} GET failed: ${lastError}`);\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 for (const key of supabaseKeys()) {\n const res = await fetch(url.toString(), {\n method: \"PATCH\",\n headers: { ...supabaseHeaders(key), \"Prefer\": \"return=minimal\" },\n body: JSON.stringify(body),\n });\n if (res.ok) return;\n const txt = await res.text().catch(() => \"\");\n console.warn(`Supabase ${table} PATCH failed: ${res.status} ${txt.slice(0, 300)}`);\n if (res.status !== 401 && res.status !== 403) return;\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","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.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6ImxtZ3BseXRueWNtdnVlbWh2bWZjIiwicm9sZSI6InNlcnZpY2Vfcm9sZSIsImlhdCI6MTc3MzA3NDk4MywiZXhwIjoyMDg4NjUwOTgzfQ.nK4Z3vXyc0pecf2vnNKHy4jVUfkrbgNgENQlo-2r3bs\";\nconst SUPABASE_ANON_FALLBACK_KEY = Deno.env.get(\"SUPABASE_ANON_FALLBACK_KEY\") || \"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6ImxtZ3BseXRueWNtdnVlbWh2bWZjIiwicm9sZSI6ImFub24iLCJpYXQiOjE3NzMwNzQ5ODMsImV4cCI6MjA4ODY1MDk4M30.aLfnSeqMyvyxqwAzM9LQcT2RTMDujc3H3jnFylVmRI8\";\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 supabaseKeys(): string[] {\n return Array.from(new Set([SUPABASE_SERVICE_ROLE_KEY, SUPABASE_ANON_FALLBACK_KEY].filter(Boolean)));\n}\n\nfunction supabaseHeaders(key: string) {\n return {\n \"apikey\": key,\n \"Authorization\": `Bearer ${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 let lastError = \"\";\n for (const key of supabaseKeys()) {\n const res = await fetch(url.toString(), { headers: supabaseHeaders(key) });\n if (res.ok) return await res.json();\n const body = await res.text().catch(() => \"\");\n lastError = `${res.status} ${body.slice(0, 300)}`;\n if (res.status !== 401 && res.status !== 403) break;\n }\n throw new Error(`Supabase ${table} GET failed: ${lastError}`);\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 for (const key of supabaseKeys()) {\n const res = await fetch(url.toString(), {\n method: \"PATCH\",\n headers: { ...supabaseHeaders(key), \"Prefer\": \"return=minimal\" },\n body: JSON.stringify(body),\n });\n if (res.ok) return;\n const txt = await res.text().catch(() => \"\");\n console.warn(`Supabase ${table} PATCH failed: ${res.status} ${txt.slice(0, 300)}`);\n if (res.status !== 401 && res.status !== 403) return;\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",1780600702292],"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",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":55,"_99":100,"_101":25},"branch",{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"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=1789592399&sig=5815b6c6d6df8718d05a70ff5325479a20996cb795747b5d1cd8e51804708c12","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":162,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_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":163,"_79":164,"_81":165,"_83":25},"tree",[153,154],"files",[153,154],"counts",{"_142":61,"_143":140,"_144":61,"_145":146,"_147":148},"contents",[126,127],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":135,"_32":136,"_30":137,"_129":-5,"_41":42,"_40":138,"_130":25,"_38":139,"_13":140,"_33":34,"_35":36,"_24":25,"_133":-5,"_27":141},{"_43":128,"_32":28,"_30":31,"_129":-5,"_41":42,"_40":14,"_130":25,"_38":131,"_13":132,"_33":34,"_35":37,"_24":25,"_133":-5,"_27":134},"6d98ab89-cc72-43a2-b75d-99981754b9f7","parentId","latest",["D",1780600702292],2,"label",[28],"ac97ab90-aa7c-4f0f-abf3-c5021383f3bf","formsmasterics.ts","5efa1fe0-6049-11f1-a493-1607ee4eb77e",4,["D",1780600600827],1,[136],"pulls","branches","forks","envVars",{"_149":151,"_152":61},"connections",{"_149":61,"_150":61},"count","unfilledCount",3,"emptyCount",{"_43":135,"_32":136,"_30":137,"_129":-5,"_41":42,"_40":138,"_130":25,"_38":159,"_13":140,"_33":34,"_35":36,"_24":25,"_133":-5,"_156":160,"_27":161},{"_43":128,"_32":28,"_30":31,"_129":-5,"_41":42,"_40":14,"_130":25,"_38":155,"_13":132,"_33":34,"_35":37,"_24":25,"_133":-5,"_156":157,"_27":158},["D",1780600702292],"children",[],[28],["D",1780600600827],[],[136],["D",1780600307583],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":55,"_99":100,"_101":25},{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"ctx",{"_77":-5,"_123":199,"_200":201,"_202":203,"_204":25,"_205":25,"_206":25,"_207":121,"_208":-5,"_209":-7,"_210":-7,"_211":61,"_212":25,"_213":25,"_214":-5,"_215":25,"_216":25,"_217":25,"_218":-5},"ENV",{"_170":171,"_172":173,"_174":85,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5015b8df46402d8bba4f485ecc37aec202b0e06b","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 · v5