[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_157":158,"_159":160},"routes/_app.x.$handle.$name",{"_16":17,"_20":21,"_82":65,"_83":84,"_63":-7,"_85":-5,"_13":86,"_87":88,"_11":89,"_90":91,"_92":93,"_94":-5,"_95":-5,"_96":-5,"_97":26,"_98":99,"_100":101,"_102":-5,"_103":-5,"_104":105},"routes/_app.x.$handle.$name.search.$(branch)",{"_11":12,"_13":14,"_15":-5,"_16":17},"files",[],"project",{"_18":19,"_20":21,"_22":23,"_24":-5,"_25":26,"_27":28,"_29":28,"_30":31,"_32":-5,"_33":34,"_35":-5,"_36":26,"_37":-5,"_38":-5,"_39":40,"_41":42,"_43":-5,"_44":-5,"_45":-5,"_46":-5,"_47":48,"_49":48,"_50":51,"_52":51,"_53":51,"_54":48,"_55":48,"_56":57,"_58":59,"_60":61,"_62":26},"query","handle","director","id","7669cd9e-2967-47af-bd14-c02188d7e6aa","name","formsmasterics","createdAt",["D",1780600307583],"deletedAt","legacyEnvVars",false,"privacy","public","httpPrivacy","description","Forms Academy ICS live feed","imageUrl","userId","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",{"_16":17,"_81":77},"org",{"_16":17,"_75":-5,"_76":77,"_33":34,"_78":79,"_80":26},"branch",{"_63":64,"_20":65,"_18":66,"_67":19,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":21,"_74":17},"isOwned","version",7,"main","073a3b77-7273-4ff7-8504-1738497804b4","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/1977df9e-bb24-475d-ff22-184507695c00/square512?exp=1789585199&sig=e8d132c93b8cc7924466cf97eba231cfb56834a25278e996e7dcb9dfe382dd8c","tier","pro","canRestrictVals","profileImageUrl","branchName","path","","adoptOrgId",{"_18":19,"_20":21,"_22":153,"_24":-5,"_25":26,"_27":28,"_29":28,"_30":31,"_32":-5,"_33":34,"_35":-5,"_36":26,"_37":-5,"_38":-5,"_39":40,"_41":42,"_43":-5,"_44":-5,"_45":-5,"_46":-5,"_47":48,"_49":48,"_50":51,"_52":51,"_53":51,"_54":48,"_55":48,"_56":154,"_58":155,"_60":156,"_62":26},"tree",[144,145],[144,145],"counts",{"_133":40,"_134":135,"_136":40,"_137":138,"_139":140},"contents",[106,107],"file","upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_18":125,"_20":126,"_110":127,"_112":-5,"_113":66,"_114":128,"_115":101,"_22":129,"_63":130,"_118":119,"_120":131,"_122":26,"_123":-5,"_83":132},{"_18":108,"_20":109,"_110":111,"_112":-5,"_113":66,"_114":64,"_115":101,"_22":116,"_63":117,"_118":119,"_120":121,"_122":26,"_123":-5,"_83":124},"dd37670f-fd50-4e98-8cae-a903e53bf879","index.ts","fileId","3e0e68c2-6049-11f1-ad78-1607ee4eb77e","parentId","branchId","branchVersion","latest",["D",1781105450291],3,"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.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6ImxtZ3BseXRueWNtdnVlbWh2bWZjIiwicm9sZSI6InNlcnZpY2Vfcm9sZSIsImlhdCI6MTc3MzA3NDk4MywiZXhwIjoyMDg4NjUwOTgzfQ.nK4Z3vXyc0pecf2vnNKHy4jVUfkrbgNgENQlo-2r3bs\";\nconst SUPABASE_ANON_FALLBACK_KEY = Deno.env.get(\"SUPABASE_ANON_FALLBACK_KEY\") || \"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6ImxtZ3BseXRueWNtdnVlbWh2bWZjIiwicm9sZSI6ImFub24iLCJpYXQiOjE3NzMwNzQ5ODMsImV4cCI6MjA4ODY1MDk4M30.aLfnSeqMyvyxqwAzM9LQcT2RTMDujc3H3jnFylVmRI8\";\nconst TEAM_HOME_TZ = \"America/Chicago\";\nconst UTC_TZ = \"UTC\";\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};\ntype EventRegistration = {\n id: string;\n event_id: string | null;\n squad_id: string | null;\n player_id?: string | null;\n guest_player_id?: string | null;\n status: string | null;\n};\ntype TravelEvent = {\n id: string;\n name: string | null;\n city?: string | null;\n state?: string | null;\n country?: string | null;\n venue_name?: string | null;\n timezone: string | null;\n status?: string | null;\n};\ntype Venue = {\n id: string;\n name: string | null;\n address_line1?: string | null;\n address_line2?: string | null;\n city?: string | null;\n state?: string | null;\n postal_code?: string | null;\n country?: string | null;\n timezone: string | null;\n};\ntype EventActivity = {\n id: string;\n event_id: string | null;\n squad_id: string | null;\n kind: string | null;\n title: string | null;\n starts_at: string | null;\n ends_at: string | null;\n venue_id: string | null;\n field_label: string | null;\n opponent: string | null;\n status: string | null;\n result: string | null;\n notes: string | null;\n home_away: string | null;\n};\ntype CalendarItem = {\n uid: string;\n sortKey: string;\n timezone: string;\n usesUtc: boolean;\n dtStart: string;\n dtEnd: string | null;\n summary: string;\n location: string;\n description: string;\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 csvIn(items: string[]): string {\n return `in.(${items.join(\",\")})`;\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 datePartsInZone(tz: string, date = new Date()): Record {\n const parts = new Intl.DateTimeFormat(\"en-CA\", {\n timeZone: tz,\n year: \"numeric\",\n month: \"2-digit\",\n day: \"2-digit\",\n hour: \"2-digit\",\n minute: \"2-digit\",\n second: \"2-digit\",\n hourCycle: \"h23\",\n }).formatToParts(date);\n const out: Record = {};\n for (const p of parts) if (p.type !== \"literal\") out[p.type] = p.value;\n return out;\n}\n\nfunction todayInTeamHomeZone(): string {\n const parts = datePartsInZone(TEAM_HOME_TZ, new Date());\n return `${parts.year}-${parts.month}-${parts.day}`;\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 addMinutesLocalIcs(dtStart: string, minutes = 120): 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 date = new Date(Date.UTC(Number(m[1]), Number(m[2]) - 1, Number(m[3]), Number(m[4]), Number(m[5]), Number(m[6])));\n date.setUTCMinutes(date.getUTCMinutes() + minutes);\n const y = String(date.getUTCFullYear()).padStart(4, \"0\");\n const mo = String(date.getUTCMonth() + 1).padStart(2, \"0\");\n const d = String(date.getUTCDate()).padStart(2, \"0\");\n const h = String(date.getUTCHours()).padStart(2, \"0\");\n const mi = String(date.getUTCMinutes()).padStart(2, \"0\");\n const s = String(date.getUTCSeconds()).padStart(2, \"0\");\n return `${y}${mo}${d}T${h}${mi}${s}`;\n}\n\nfunction isEndAfterStart(start: string, end: string): boolean {\n const s = start.replace(/[^0-9]/g, \"\");\n const e = end.replace(/[^0-9]/g, \"\");\n return Boolean(s && e && e > s);\n}\n\nfunction validTimeZone(tz: string | null | undefined): string | null {\n const value = String(tz || \"\").trim();\n if (!value) return null;\n try {\n new Intl.DateTimeFormat(\"en-US\", { timeZone: value }).format(new Date());\n return value;\n } catch {\n return null;\n }\n}\n\nfunction resolveActivityTimeZone(activity: EventActivity, event: TravelEvent | undefined, venue: Venue | undefined): string {\n return validTimeZone(venue?.timezone) || validTimeZone(event?.timezone) || validTimeZone(TEAM_HOME_TZ) || UTC_TZ;\n}\n\nfunction formatInstantInZone(iso: string | null | undefined, tz: string): string {\n const date = new Date(String(iso || \"\"));\n if (!Number.isFinite(date.getTime())) return \"\";\n if (tz === UTC_TZ || !validTimeZone(tz)) return formatUtcStamp(date);\n const parts = datePartsInZone(tz, date);\n return `${parts.year}${parts.month}${parts.day}T${parts.hour}${parts.minute}${parts.second}`;\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 icsDateLine(name: \"DTSTART\" | \"DTEND\", item: CalendarItem, value: string): string {\n if (item.usesUtc) return `${name}:${value}`;\n return `${name};TZID=${item.timezone}:${value}`;\n}\n\nfunction buildGameDescription(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 buildActivityDescription(activity: EventActivity, event: TravelEvent | undefined): string {\n const parts: string[] = [];\n if (event?.name) parts.push(String(event.name));\n if (activity.kind) parts.push(`Type: ${activity.kind}`);\n if (activity.opponent) parts.push(`Opponent: ${activity.opponent}`);\n if (activity.home_away) parts.push(`Home or away: ${activity.home_away}`);\n if (activity.result) parts.push(`Result: ${activity.result}`);\n if (activity.notes) parts.push(String(activity.notes));\n return parts.join(\"\\n\");\n}\n\nfunction activityDefaultMinutes(activity: EventActivity): number {\n const kind = String(activity.kind || \"\").toLowerCase();\n if ([\"game\", \"fixture\", \"match\"].some((x) => kind.includes(x))) return 90;\n if (kind.includes(\"training\")) return 90;\n return 60;\n}\n\nfunction eventLocation(activity: EventActivity, event: TravelEvent | undefined, venue: Venue | undefined): string {\n const parts = [venue?.name, activity.field_label, venue?.address_line1, venue?.city || event?.city, venue?.state || event?.state, venue?.country || event?.country]\n .map((x) => String(x || \"\").trim())\n .filter(Boolean);\n return unique(parts).join(\" - \");\n}\n\nfunction activitySummary(activity: EventActivity, event: TravelEvent | undefined): string {\n const base = [event?.name, activity.title].map((x) => String(x || \"\").trim()).filter(Boolean).join(\": \") || \"Forms Academy Event\";\n if (activity.opponent) return `${base} vs ${activity.opponent}`;\n return base;\n}\n\nfunction gameToItem(game: Game): CalendarItem | null {\n if (!game.date) return null;\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 return {\n uid: `cs-game-${game.id}@formsacademy.com`,\n sortKey: `${String(game.date)}T${parseTimeToHHMMSS(game.time)}`,\n timezone: TEAM_HOME_TZ,\n usesUtc: false,\n dtStart,\n dtEnd: addMinutesLocalIcs(dtStart, 120),\n summary,\n location,\n description: buildGameDescription(game),\n };\n}\n\nfunction activityToItem(activity: EventActivity, eventMap: Map, venueMap: Map): CalendarItem | null {\n if (!activity.starts_at || !activity.event_id) return null;\n const event = eventMap.get(activity.event_id);\n const venue = activity.venue_id ? venueMap.get(activity.venue_id) : undefined;\n const timezone = resolveActivityTimeZone(activity, event, venue);\n const usesUtc = timezone === UTC_TZ || !validTimeZone(timezone);\n const start = formatInstantInZone(activity.starts_at, usesUtc ? UTC_TZ : timezone);\n if (!start) return null;\n let end = activity.ends_at ? formatInstantInZone(activity.ends_at, usesUtc ? UTC_TZ : timezone) : \"\";\n if (!end || !isEndAfterStart(start, end)) {\n if (usesUtc) {\n const startDate = new Date(activity.starts_at);\n startDate.setUTCMinutes(startDate.getUTCMinutes() + activityDefaultMinutes(activity));\n end = formatUtcStamp(startDate);\n } else {\n end = addMinutesLocalIcs(start, activityDefaultMinutes(activity));\n }\n }\n return {\n uid: `event-activity-${activity.id}@formsacademy.com`,\n sortKey: activity.starts_at,\n timezone: usesUtc ? UTC_TZ : timezone,\n usesUtc,\n dtStart: start,\n dtEnd: end,\n summary: activitySummary(activity, event),\n location: eventLocation(activity, event, venue),\n description: buildActivityDescription(activity, event),\n };\n}\n\nfunction timezoneOffset(tz: string, date: Date): string {\n try {\n const parts = datePartsInZone(tz, date);\n const asUtc = Date.UTC(Number(parts.year), Number(parts.month) - 1, Number(parts.day), Number(parts.hour), Number(parts.minute), Number(parts.second));\n const offsetMinutes = Math.round((asUtc - date.getTime()) / 60000);\n const sign = offsetMinutes >= 0 ? \"+\" : \"-\";\n const abs = Math.abs(offsetMinutes);\n return `${sign}${String(Math.floor(abs / 60)).padStart(2, \"0\")}${String(abs % 60).padStart(2, \"0\")}`;\n } catch {\n return \"+0000\";\n }\n}\n\nfunction timezoneBlock(tz: string): string[] {\n if (tz === \"America/Chicago\") {\n return [\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 }\n if (tz === \"Europe/Madrid\") {\n return [\n \"BEGIN:VTIMEZONE\",\n \"TZID:Europe/Madrid\",\n \"BEGIN:DAYLIGHT\",\n \"TZOFFSETFROM:+0100\",\n \"TZOFFSETTO:+0200\",\n \"TZNAME:CEST\",\n \"DTSTART:19700329T020000\",\n \"RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU\",\n \"END:DAYLIGHT\",\n \"BEGIN:STANDARD\",\n \"TZOFFSETFROM:+0200\",\n \"TZOFFSETTO:+0100\",\n \"TZNAME:CET\",\n \"DTSTART:19701025T030000\",\n \"RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU\",\n \"END:STANDARD\",\n \"END:VTIMEZONE\",\n ];\n }\n if (tz === \"America/New_York\") {\n return [\n \"BEGIN:VTIMEZONE\",\n \"TZID:America/New_York\",\n \"BEGIN:DAYLIGHT\",\n \"TZOFFSETFROM:-0500\",\n \"TZOFFSETTO:-0400\",\n \"TZNAME:EDT\",\n \"DTSTART:19700308T020000\",\n \"RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=2SU\",\n \"END:DAYLIGHT\",\n \"BEGIN:STANDARD\",\n \"TZOFFSETFROM:-0400\",\n \"TZOFFSETTO:-0500\",\n \"TZNAME:EST\",\n \"DTSTART:19701101T020000\",\n \"RRULE:FREQ=YEARLY;BYMONTH=11;BYDAY=1SU\",\n \"END:STANDARD\",\n \"END:VTIMEZONE\",\n ];\n }\n const offset = timezoneOffset(tz, new Date());\n return [\n \"BEGIN:VTIMEZONE\",\n `TZID:${tz}`,\n \"BEGIN:STANDARD\",\n `TZOFFSETFROM:${offset}`,\n `TZOFFSETTO:${offset}`,\n `TZNAME:${tz}`,\n \"DTSTART:19700101T000000\",\n \"END:STANDARD\",\n \"END:VTIMEZONE\",\n ];\n}\n\nfunction buildIcs(familyName: string, items: CalendarItem[]): string {\n const now = formatUtcStamp();\n const calName = `Forms Academy - ${familyName || \"Family\"}`;\n const sorted = [...items].sort((a, b) => a.sortKey.localeCompare(b.sortKey));\n const uniqueTimezones = unique(sorted.filter((item) => !item.usesUtc).map((item) => item.timezone));\n const primaryTimezone = uniqueTimezones[0] || TEAM_HOME_TZ;\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:${primaryTimezone}`,\n ];\n for (const tz of uniqueTimezones) lines.push(...timezoneBlock(tz));\n for (const item of sorted) {\n lines.push(\n \"BEGIN:VEVENT\",\n icsLine(\"UID\", item.uid),\n `DTSTAMP:${now}`,\n icsDateLine(\"DTSTART\", item, item.dtStart),\n );\n if (item.dtEnd) lines.push(icsDateLine(\"DTEND\", item, item.dtEnd));\n lines.push(\n icsLine(\"SUMMARY\", item.summary),\n icsLine(\"LOCATION\", item.location),\n icsLine(\"DESCRIPTION\", item.description),\n \"END:VEVENT\",\n );\n }\n lines.push(\"END:VCALENDAR\");\n return lines.join(\"\\r\\n\") + \"\\r\\n\";\n}\n\nfunction isCancelled(status: string | null | undefined): boolean {\n return [\"cancelled\", \"canceled\", \"withdrawn\", \"removed\", \"declined\"].includes(String(status || \"\").toLowerCase());\n}\n\nasync function loadTournamentItems(familyId: string): Promise {\n const registrations = await sbGet(\"event_registrations\", {\n family_id: `eq.${familyId}`,\n select: \"id,event_id,squad_id,player_id,guest_player_id,status\",\n limit: \"2000\",\n });\n const activeRegistrations = registrations.filter((r) => r.event_id && !isCancelled(r.status));\n const eventIds = unique(activeRegistrations.map((r) => String(r.event_id))).filter(Boolean);\n if (!eventIds.length) return [];\n\n const squadIds = unique(activeRegistrations.map((r) => r.squad_id ? String(r.squad_id) : \"\")).filter(Boolean);\n const [events, eventWideActivities, squadActivities] = await Promise.all([\n sbGet(\"events\", {\n id: csvIn(eventIds),\n select: \"id,name,city,state,country,venue_name,timezone,status\",\n limit: \"2000\",\n }),\n sbGet(\"event_activities\", {\n event_id: csvIn(eventIds),\n squad_id: \"is.null\",\n select: \"id,event_id,squad_id,kind,title,starts_at,ends_at,venue_id,field_label,opponent,status,result,notes,home_away\",\n order: \"starts_at.asc\",\n limit: \"2000\",\n }),\n squadIds.length ? sbGet(\"event_activities\", {\n event_id: csvIn(eventIds),\n squad_id: csvIn(squadIds),\n select: \"id,event_id,squad_id,kind,title,starts_at,ends_at,venue_id,field_label,opponent,status,result,notes,home_away\",\n order: \"starts_at.asc\",\n limit: \"2000\",\n }) : Promise.resolve([] as EventActivity[]),\n ]);\n\n const eventMap = new Map(events.map((event) => [String(event.id), event]));\n const activityMap = new Map();\n for (const activity of [...eventWideActivities, ...squadActivities]) {\n if (activity.id && activity.starts_at && !isCancelled(activity.status)) activityMap.set(String(activity.id), activity);\n }\n const activities = Array.from(activityMap.values());\n const venueIds = unique(activities.map((a) => a.venue_id ? String(a.venue_id) : \"\")).filter(Boolean);\n const venues = venueIds.length ? await sbGet(\"venues\", {\n id: csvIn(venueIds),\n select: \"id,name,address_line1,address_line2,city,state,postal_code,country,timezone\",\n limit: \"2000\",\n }) : [];\n const venueMap = new Map(venues.map((venue) => [String(venue.id), venue]));\n return activities.map((activity) => activityToItem(activity, eventMap, venueMap)).filter(Boolean) as CalendarItem[];\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: csvIn(playerIds), 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: csvIn(teamIds), select: \"id,name\" });\n teamNames = unique(teams.map((t) => String(t.name || \"\").trim())).filter(Boolean);\n }\n }\n\n const today = todayInTeamHomeZone();\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 gameItems = games.filter((g) => gameMatchesTeams(g.roster, teamNames)).map(gameToItem).filter(Boolean) as CalendarItem[];\n const tournamentItems = await loadTournamentItems(String(family.id));\n const allItems = [...gameItems, ...tournamentItems];\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\", allItems);\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","deleted","label",[109],"b9d53f1a-9710-43e6-ad09-d79d6c15f94c","formsmasterics.ts","5efa1fe0-6049-11f1-a493-1607ee4eb77e",6,["D",1780600706076],2,"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",[126],"pulls","branches",1,"forks","envVars",{"_141":117,"_143":40},"connections",{"_141":40,"_142":40},"count","unfilledCount","emptyCount",{"_18":125,"_20":126,"_110":127,"_112":-5,"_113":66,"_114":128,"_115":101,"_22":150,"_63":130,"_118":119,"_120":131,"_122":26,"_123":-5,"_147":151,"_83":152},{"_18":108,"_20":109,"_110":111,"_112":-5,"_113":66,"_114":64,"_115":101,"_22":146,"_63":117,"_118":119,"_120":121,"_122":26,"_123":-5,"_147":148,"_83":149},["D",1781105450291],"children",[],[109],["D",1780600706076],[],[126],["D",1780600307583],{"_16":17,"_81":77},{"_16":17,"_75":-5,"_76":77,"_33":34,"_78":79,"_80":26},{"_63":64,"_20":65,"_18":66,"_67":19,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":21,"_74":17},"ctx",{"_56":-5,"_103":190,"_191":192,"_193":194,"_195":26,"_196":26,"_197":26,"_198":101,"_199":-5,"_200":-7,"_201":-7,"_202":40,"_203":26,"_204":26,"_205":-5,"_206":26,"_207":26,"_208":26,"_209":-5},"ENV",{"_161":162,"_163":164,"_165":65,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189},"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"]

Search