[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_152":153,"_154":155},"routes/_app.x.$handle.$name",{"_94":93,"_32":45,"_102":84,"_27":97,"_13":14,"_103":-5,"_11":104,"_105":106,"_107":108,"_109":110,"_111":112,"_20":-5,"_113":-5,"_114":-5,"_115":25,"_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",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":77,"_78":79,"_80":81,"_82":25},"version",7,"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","main.ts","latestPath","fileId","80c83266-3bef-11f1-ae0f-42b51c65c3df","name","fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nconst SOURCE_URL =\n \"https://ical-2d0le9.findmyshift.com/ical.ics?IuAM9008B3C4NAXH5B9H2B6O3FKZGUbKC4ApJ00400Q0fI2A7C6CsuE4Is40OB68KiuB907706U9A9i9K5BYC9A70QG4ABDA2BK7K69A7K4M8009C9O8KU39I00PE7M90PD0C5M4C2KU05HB84G40380Z07000A0B40B7A3F5J8C9N80eP2I6C4E5AKSO8\";\n\nconst SHIFTS = [\n { key: \"planning editor\", times: [9, 0, 18, 45] },\n { key: \"digital editor\", times: [9, 0, 18, 45] },\n { key: \"programme editor\", times: [8, 30, 18, 45] },\n { key: \"news editor\", times: [8, 30, 18, 45] },\n { key: \"late digital pj\", times: [11, 30, 20, 0] },\n { key: \"late pj\", times: [14, 30, 23, 30] },\n { key: \"assistant programme editor\", times: [10, 15, 18, 45] },\n { key: \"assistant programme editor\", times: [10, 15, 18, 45] },\n { key: \"day pj\", times: [10, 15, 18, 45] },\n { key: \"digital pj\", times: [9, 15, 17, 45] },\n { key: \"weekend pj\", times: [10, 30, 18, 30] },\n { key: \"planning\", times: [9, 15, 17, 45] },\n];\n\nconst SHARP_END_DEFAULT = [9, 15, 17, 45];\nconst SHARP_END_TUESDAY = [14, 0, 23, 30];\nconst SHARP_END_WEDNESDAY = [10, 15, 17, 45];\n\nconst SKIP = [\"w/e\", \"r/o\", \"leave\", \"bank holiday\", \"what matters day\"];\n\nasync function loadOverrides(): Promise<\n Map\n> {\n const map = new Map();\n try {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS shift_overrides (\n date TEXT PRIMARY KEY,\n title TEXT NOT NULL,\n start_time TEXT NOT NULL,\n end_time TEXT NOT NULL,\n created_at TEXT DEFAULT (datetime('now'))\n )\n `);\n const result = await sqlite.execute(\n \"SELECT date, title, start_time, end_time FROM shift_overrides\",\n );\n for (const row of result.rows) {\n const [date, title, start_time, end_time] = row as string[];\n const [sh, sm] = start_time.split(\":\").map(Number);\n const [eh, em] = end_time.split(\":\").map(Number);\n map.set(date, { title, times: [sh, sm, eh, em] });\n }\n } catch (e) {}\n return map;\n}\n\nfunction getShiftTimes(\n title: string,\n dateStr: string,\n overrides: Map,\n): { times: number[] | null | undefined; title: string } {\n const isoDate = dateStr.slice(0, 4) + \"-\" + dateStr.slice(4, 6) + \"-\" +\n dateStr.slice(6, 8);\n\n if (overrides.has(isoDate)) {\n const o = overrides.get(isoDate)!;\n return { times: o.times, title: o.title };\n }\n\n const t = title.toLowerCase().trim();\n\n if (SKIP.includes(t)) return { times: null, title };\n\n if (t.includes(\"sharp end\") || t.includes(\"sharpend\")) {\n const d = new Date(isoDate);\n if (d.getDay() === 2) return { times: SHARP_END_TUESDAY, title };\n if (d.getDay() === 3) return { times: SHARP_END_WEDNESDAY, title };\n return { times: SHARP_END_DEFAULT, title };\n }\n\n for (const shift of SHIFTS) {\n if (t.includes(shift.key)) return { times: shift.times, title };\n }\n\n return { times: undefined, title };\n}\n\nfunction pad(n: number): string {\n return String(n).padStart(2, \"0\");\n}\n\nfunction formatDateTime(dateStr: string, h: number, m: number): string {\n return dateStr + \"T\" + pad(h) + pad(m) + \"00\";\n}\n\n// Parse raw event lines into a structured object\nfunction parseEvent(\n lines: string[],\n): { summary: string; dtstart: string; other: string[] } {\n let summary = \"\";\n let dtstart = \"\";\n const other: string[] = [];\n for (const line of lines) {\n if (line.startsWith(\"SUMMARY:\")) {\n summary = line.slice(8);\n } else if (line.startsWith(\"DTSTART\")) {\n const match = line.match(/(\\d{8})$/);\n if (match) dtstart = match[1];\n } else if (\n !line.startsWith(\"DTEND\") &&\n !line.startsWith(\"DESCRIPTION\") &&\n line !== \"BEGIN:VEVENT\" &&\n line !== \"END:VEVENT\"\n ) {\n other.push(line);\n }\n }\n return { summary, dtstart, other };\n}\n\nfunction buildEvent(\n summary: string,\n dtstart: string,\n times: number[],\n other: string[],\n description: string,\n): string[] {\n const [sh, sm, eh, em] = times;\n return [\n \"BEGIN:VEVENT\",\n \"DTSTART;TZID=Europe/London:\" + formatDateTime(dtstart, sh, sm),\n \"DTEND;TZID=Europe/London:\" + formatDateTime(dtstart, eh, em),\n \"SUMMARY:\" + summary,\n \"DESCRIPTION:\" + description,\n ...other,\n \"END:VEVENT\",\n ];\n}\n\nfunction transformIcal(\n ical: string,\n overrides: Map,\n): string {\n const lines = ical.replace(/\\r\\n/g, \"\\n\").replace(/\\r/g, \"\\n\").split(\"\\n\");\n\n // First pass: collect all raw events grouped by date\n const eventsByDate = new Map();\n const headerLines: string[] = [];\n const footerLines: string[] = [];\n let inEvent = false;\n let eventLines: string[] = [];\n let headerDone = false;\n\n for (const line of lines) {\n if (line === \"BEGIN:VEVENT\") {\n inEvent = true;\n headerDone = true;\n eventLines = [line];\n } else if (line === \"END:VEVENT\") {\n eventLines.push(line);\n const parsed = parseEvent(eventLines);\n if (parsed.dtstart) {\n const existing = eventsByDate.get(parsed.dtstart) || [];\n existing.push(eventLines);\n eventsByDate.set(parsed.dtstart, existing);\n }\n inEvent = false;\n eventLines = [];\n } else if (inEvent) {\n eventLines.push(line);\n } else if (!headerDone) {\n headerLines.push(line);\n } else {\n footerLines.push(line);\n }\n }\n\n // Second pass: process each date's events\n const outputEvents: string[][] = [];\n\n for (const [dtstart, eventsOnDay] of eventsByDate) {\n // Separate debrief from regular events\n const debriefEvents = eventsOnDay.filter((ev) => {\n const p = parseEvent(ev);\n return p.summary.toLowerCase().trim() === \"debrief\";\n });\n const regularEvents = eventsOnDay.filter((ev) => {\n const p = parseEvent(ev);\n return p.summary.toLowerCase().trim() !== \"debrief\";\n });\n\n const hasDebrief = debriefEvents.length > 0;\n\n if (regularEvents.length === 0 && hasDebrief) {\n // Debrief with no regular shift — skip entirely\n continue;\n }\n\n for (const rawLines of regularEvents) {\n const { summary, dtstart: ds, other } = parseEvent(rawLines);\n const { times, title: outTitle } = getShiftTimes(summary, ds, overrides);\n\n if (times === null || times === undefined) {\n // Keep as-is (skip/unrecognised)\n outputEvents.push(rawLines);\n continue;\n }\n\n const finalTitle = hasDebrief ? outTitle + \" (Debrief)\" : outTitle;\n const description = hasDebrief\n ? \"Generated via Shift Time Tool | Includes debrief meeting\"\n : \"Generated via Shift Time Tool\";\n\n outputEvents.push(buildEvent(finalTitle, ds, times, other, description));\n }\n }\n\n const output: string[] = [\n ...headerLines,\n ...outputEvents.flat(),\n ...footerLines,\n ];\n\n return output.join(\"\\r\\n\");\n}\n\nexport default async function (req: Request): Promise {\n try {\n const [sourceResponse, overrides] = await Promise.all([\n fetch(SOURCE_URL),\n loadOverrides(),\n ]);\n\n if (!sourceResponse.ok) {\n return new Response(\"Failed to fetch source calendar\", { status: 502 });\n }\n\n const ical = await sourceResponse.text();\n const transformed = transformIcal(ical, overrides);\n\n return new Response(transformed, {\n headers: {\n \"Content-Type\": \"text/calendar; charset=utf-8\",\n \"Cache-Control\": \"no-cache\",\n },\n });\n } catch (err) {\n return new Response(\"Error: \" + (err as Error).message, { status: 500 });\n }\n}","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nconst SOURCE_URL =\n \"https://ical-2d0le9.findmyshift.com/ical.ics?IuAM9008B3C4NAXH5B9H2B6O3FKZGUbKC4ApJ00400Q0fI2A7C6CsuE4Is40OB68KiuB907706U9A9i9K5BYC9A70QG4ABDA2BK7K69A7K4M8009C9O8KU39I00PE7M90PD0C5M4C2KU05HB84G40380Z07000A0B40B7A3F5J8C9N80eP2I6C4E5AKSO8\";\n\nconst SHIFTS = [\n { key: \"planning editor\", times: [9, 0, 18, 45] },\n { key: \"digital editor\", times: [9, 0, 18, 45] },\n { key: \"programme editor\", times: [8, 30, 18, 45] },\n { key: \"news editor\", times: [8, 30, 18, 45] },\n { key: \"late digital pj\", times: [11, 30, 20, 0] },\n { key: \"late pj\", times: [14, 30, 23, 30] },\n { key: \"assistant programme editor\", times: [10, 15, 18, 45] },\n { key: \"assistant programme editor\", times: [10, 15, 18, 45] },\n { key: \"day pj\", times: [10, 15, 18, 45] },\n { key: \"digital pj\", times: [9, 15, 17, 45] },\n { key: \"weekend pj\", times: [10, 30, 18, 30] },\n { key: \"planning\", times: [9, 15, 17, 45] },\n];\n\nconst SHARP_END_DEFAULT = [9, 15, 17, 45];\nconst SHARP_END_TUESDAY = [14, 0, 23, 30];\nconst SHARP_END_WEDNESDAY = [10, 15, 17, 45];\n\nconst SKIP = [\"w/e\", \"r/o\", \"leave\", \"bank holiday\", \"what matters day\"];\n\nasync function loadOverrides(): Promise<\n Map\n> {\n const map = new Map();\n try {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS shift_overrides (\n date TEXT PRIMARY KEY,\n title TEXT NOT NULL,\n start_time TEXT NOT NULL,\n end_time TEXT NOT NULL,\n created_at TEXT DEFAULT (datetime('now'))\n )\n `);\n const result = await sqlite.execute(\n \"SELECT date, title, start_time, end_time FROM shift_overrides\",\n );\n for (const row of result.rows) {\n const [date, title, start_time, end_time] = row as string[];\n const [sh, sm] = start_time.split(\":\").map(Number);\n const [eh, em] = end_time.split(\":\").map(Number);\n map.set(date, { title, times: [sh, sm, eh, em] });\n }\n } catch (e) {}\n return map;\n}\n\nfunction getShiftTimes(\n title: string,\n dateStr: string,\n overrides: Map,\n): { times: number[] | null | undefined; title: string } {\n const isoDate = dateStr.slice(0, 4) + \"-\" + dateStr.slice(4, 6) + \"-\" +\n dateStr.slice(6, 8);\n\n if (overrides.has(isoDate)) {\n const o = overrides.get(isoDate)!;\n return { times: o.times, title: o.title };\n }\n\n const t = title.toLowerCase().trim();\n\n if (SKIP.includes(t)) return { times: null, title };\n\n if (t.includes(\"sharp end\") || t.includes(\"sharpend\")) {\n const d = new Date(isoDate);\n if (d.getDay() === 2) return { times: SHARP_END_TUESDAY, title };\n if (d.getDay() === 3) return { times: SHARP_END_WEDNESDAY, title };\n return { times: SHARP_END_DEFAULT, title };\n }\n\n for (const shift of SHIFTS) {\n if (t.includes(shift.key)) return { times: shift.times, title };\n }\n\n return { times: undefined, title };\n}\n\nfunction pad(n: number): string {\n return String(n).padStart(2, \"0\");\n}\n\nfunction formatDateTime(dateStr: string, h: number, m: number): string {\n return dateStr + \"T\" + pad(h) + pad(m) + \"00\";\n}\n\nfunction parseEvent(\n lines: string[],\n): { summary: string; dtstart: string; other: string[] } {\n let summary = \"\";\n let dtstart = \"\";\n const other: string[] = [];\n for (const line of lines) {\n if (line.startsWith(\"SUMMARY:\")) {\n summary = line.slice(8);\n } else if (line.startsWith(\"DTSTART\")) {\n const match = line.match(/(\\d{8})$/);\n if (match) dtstart = match[1];\n } else if (\n !line.startsWith(\"DTEND\") &&\n !line.startsWith(\"DESCRIPTION\") &&\n line !== \"BEGIN:VEVENT\" &&\n line !== \"END:VEVENT\"\n ) {\n other.push(line);\n }\n }\n return { summary, dtstart, other };\n}\n\nfunction buildEvent(\n summary: string,\n dtstart: string,\n times: number[],\n other: string[],\n description: string,\n): string[] {\n const [sh, sm, eh, em] = times;\n return [\n \"BEGIN:VEVENT\",\n \"DTSTART;TZID=Europe/London:\" + formatDateTime(dtstart, sh, sm),\n \"DTEND;TZID=Europe/London:\" + formatDateTime(dtstart, eh, em),\n \"SUMMARY:\" + summary,\n \"DESCRIPTION:\" + description,\n ...other,\n \"END:VEVENT\",\n ];\n}\n\nfunction transformIcal(\n ical: string,\n overrides: Map,\n): string {\n const lines = ical.replace(/\\r\\n/g, \"\\n\").replace(/\\r/g, \"\\n\").split(\"\\n\");\n\n const eventsByDate = new Map();\n const headerLines: string[] = [];\n const footerLines: string[] = [];\n let inEvent = false;\n let eventLines: string[] = [];\n let headerDone = false;\n\n for (const line of lines) {\n if (line === \"BEGIN:VEVENT\") {\n inEvent = true;\n headerDone = true;\n eventLines = [line];\n } else if (line === \"END:VEVENT\") {\n eventLines.push(line);\n const parsed = parseEvent(eventLines);\n if (parsed.dtstart) {\n const existing = eventsByDate.get(parsed.dtstart) || [];\n existing.push(eventLines);\n eventsByDate.set(parsed.dtstart, existing);\n }\n inEvent = false;\n eventLines = [];\n } else if (inEvent) {\n eventLines.push(line);\n } else if (!headerDone) {\n headerLines.push(line);\n } else {\n footerLines.push(line);\n }\n }\n\n const outputEvents: string[][] = [];\n\n for (const [dtstart, eventsOnDay] of eventsByDate) {\n // Separate debrief from regular events\n const debriefEvents = eventsOnDay.filter((ev) => {\n const p = parseEvent(ev);\n return p.summary.toLowerCase().trim() === \"debrief\";\n });\n const regularEvents = eventsOnDay.filter((ev) => {\n const p = parseEvent(ev);\n return p.summary.toLowerCase().trim() !== \"debrief\";\n });\n\n const hasDebrief = debriefEvents.length > 0;\n\n if (regularEvents.length === 0 && hasDebrief) {\n // Debrief alone — drop entirely\n continue;\n }\n\n for (const rawLines of regularEvents) {\n const { summary, dtstart: ds, other } = parseEvent(rawLines);\n const { times, title: outTitle } = getShiftTimes(summary, ds, overrides);\n\n if (times === null) {\n // Known skip (r/o, w/e, leave etc.) — drop entirely\n continue;\n }\n\n if (times === undefined) {\n // Unrecognised — keep as all-day\n outputEvents.push(rawLines);\n continue;\n }\n\n const finalTitle = hasDebrief ? outTitle + \" (Debrief)\" : outTitle;\n const description = hasDebrief\n ? \"Generated via Shift Time Tool | Includes debrief meeting\"\n : \"Generated via Shift Time Tool\";\n\n outputEvents.push(buildEvent(finalTitle, ds, times, other, description));\n }\n }\n\n const output: string[] = [\n ...headerLines,\n ...outputEvents.flat(),\n ...footerLines,\n ];\n\n return output.join(\"\\r\\n\");\n}\n\nexport default async function (req: Request): Promise {\n try {\n const [sourceResponse, overrides] = await Promise.all([\n fetch(SOURCE_URL),\n loadOverrides(),\n ]);\n\n if (!sourceResponse.ok) {\n return new Response(\"Failed to fetch source calendar\", { status: 502 });\n }\n\n const ical = await sourceResponse.text();\n const transformed = transformIcal(ical, overrides);\n\n return new Response(transformed, {\n headers: {\n \"Content-Type\": \"text/calendar; charset=utf-8\",\n \"Cache-Control\": \"no-cache\",\n },\n });\n } catch (err) {\n return new Response(\"Error: \" + (err as Error).message, { status: 500 });\n }\n}","createdAt",["D",1777924777514],"branchVersion","branchId","80b135ac-3bef-11f1-ae0f-42b51c65c3df","id","80ae3320-3bef-11f1-ae0f-42b51c65c3df","shifttimes",["D",1776603526730],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","0d00c63a-1d57-4b17-a5b9-fb0e81675f07","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019da5cf-9768-730f-b60f-e7e062c5d543","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_94":93,"_101":97},"org",{"_94":93,"_95":-5,"_96":97,"_18":54,"_98":99,"_100":25},"branch",{"_13":83,"_32":84,"_43":42,"_85":44,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":45,"_92":93},"isOwned",9,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","atkinstom","handle","displayName","avatar","","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":148,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":149,"_78":150,"_80":151,"_82":25},"tree",[143],"files",[143],"counts",{"_132":60,"_133":134,"_135":60,"_136":137,"_138":139},"contents",[124],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":125,"_32":28,"_30":31,"_126":-5,"_41":42,"_40":14,"_127":25,"_38":128,"_13":129,"_33":34,"_35":37,"_24":25,"_130":-5,"_27":131},"c7869cb4-47f3-11f1-a80d-42b51c65c3df","parentId","latest",["D",1777924777514],6,"label",[28],"pulls","branches",1,"forks","envVars",{"_140":60,"_142":60},"connections",{"_140":60,"_141":60},"count","unfilledCount","emptyCount",{"_43":125,"_32":28,"_30":31,"_126":-5,"_41":42,"_40":14,"_127":25,"_38":144,"_13":129,"_33":34,"_35":37,"_24":25,"_130":-5,"_145":146,"_27":147},["D",1777924777514],"children",[],[28],["D",1776603526730],{"_94":93,"_101":97},{"_94":93,"_95":-5,"_96":97,"_18":54,"_98":99,"_100":25},{"_13":83,"_32":84,"_43":42,"_85":44,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":45,"_92":93},"ctx",{"_76":-5,"_121":185,"_186":187,"_188":189,"_190":25,"_191":25,"_192":25,"_193":119,"_194":-5,"_195":-7,"_196":-7,"_197":60,"_198":25,"_199":25,"_200":-5,"_201":25,"_202":25,"_203":25,"_204":-5},"ENV",{"_156":157,"_158":159,"_160":84,"_161":162,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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 · v7