[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_232":233,"_234":235},"routes/_app.x.$handle.$name",{"_101":100,"_32":45,"_109":91,"_27":103,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_20":-5,"_120":-5,"_121":-5,"_122":49,"_123":124,"_125":25,"_126":-5,"_127":-5,"_128":129},"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":49,"_50":51,"_52":51,"_53":54,"_55":56,"_18":57,"_58":59,"_60":25,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":84,"_85":86,"_87":88,"_89":49},"version",51,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",true,"deletedHere","path","scripts/test-icloud-sync.ts","latestPath","fileId","f4bf85d8-61de-11f1-aba4-1607ee4eb77e","name","test-icloud-sync.ts","fileType","script","content","const email = Deno.env.get(\"ICLOUD_EMAIL\");\r\nconst password = Deno.env.get(\"ICLOUD_APP_PASSWORD\");\r\nconsole.log(\"email set:\", !!email, \"password set:\", !!password, \"email domain:\", email?.split(\"@\")[1] ?? \"none\");\r\n\r\nconst body = \"

\";\r\nconst auth = `Basic ${btoa(`${email}:${password}`)}`;\r\n\r\nfor (const url of [\"https://caldav.icloud.com/co\", \"https://caldav.icloud.com/\"]) {\r\n const res = await fetch(url, {\r\n method: \"PROPFIND\",\r\n headers: {\r\n Authorization: auth,\r\n Depth: \"0\",\r\n \"Content-Type\": \"application/xml; charset=utf-8\",\r\n Accept: \"*/*\",\r\n },\r\n body,\r\n });\r\n const text = await res.text();\r\n console.log(url, \"->\", res.status, text.slice(0, 300));\r\n}\r\n\r\nimport { syncAppointmentToICloud } from \"../shared/icloud-calendar.ts\";\r\nconst appt = { date: \"2026-06-07\", time: \"15:00\", title: \"verjaardag klaas\" };\r\nconst result = await syncAppointmentToICloud(appt);\r\nconsole.log(\"sync:\", JSON.stringify(result));\r\n\r\nexport default async function (): Promise {\r\n return Response.json(result);\r\n}\r\n","createdAt",["D",1780774642709],"branchVersion","branchId","67b31c9f-abdc-460c-820d-3545aa45f61f","id","4bfef0de-e74e-47c0-ba37-39d09b0a8ffe","family-butler",["D",1780688454116],"deletedAt","legacyEnvVars",false,"privacy","public","httpPrivacy","description","Daily tasks, calendar, and dinner planning for the family","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/baeef583-a661-47c1-518c-640c7e092a00/square512?exp=1789545599&sig=64f51b4480e2e0273ca7671696efa6242a6507e63f1939bc10b52851c0b65b3b","08b6ee43-68da-4bf2-918a-58fd79608932","pinnedFileId","a19b903c-61d3-11f1-af58-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019e994b-5e8f-775e-8465-668beecf3303","tursoName","4bfef0dee74e47c0ba3739d09b0a8ffe","tursoHostname","4bfef0dee74e47c0ba3739d09b0a8ffe-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789502486629],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_101":100,"_108":103},"org",{"_101":100,"_102":103,"_104":103,"_18":57,"_105":106,"_107":49},"branch",{"_13":90,"_32":91,"_43":42,"_92":44,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":45,"_99":100},"isOwned",82,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Robbertd","handle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":227,"_47":-5,"_48":49,"_50":51,"_52":51,"_53":54,"_55":56,"_18":57,"_58":59,"_60":25,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":228,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":229,"_85":230,"_87":231,"_89":49},"tree",[187,188,191,192,193],"files",[187,188,189,190,191,192,193],"counts",{"_176":64,"_177":178,"_179":64,"_180":181,"_182":183},"contents",[130,131,132,133,134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":170,"_32":171,"_30":172,"_137":-5,"_41":42,"_40":173,"_139":25,"_38":174,"_13":64,"_34":168,"_36":-5,"_24":49,"_144":-5,"_27":175},{"_43":163,"_32":164,"_30":165,"_137":-5,"_41":42,"_40":166,"_139":25,"_38":167,"_13":64,"_34":168,"_36":-5,"_24":49,"_144":-5,"_27":169},{"_43":155,"_32":156,"_30":157,"_137":-5,"_41":42,"_40":158,"_139":25,"_38":159,"_13":160,"_34":152,"_36":161,"_24":49,"_144":-5,"_27":162},{"_43":146,"_32":147,"_30":148,"_137":-5,"_41":42,"_40":149,"_139":49,"_38":150,"_13":151,"_34":152,"_36":153,"_24":49,"_144":-5,"_27":154},{"_43":135,"_32":136,"_30":59,"_137":-5,"_41":42,"_40":138,"_139":49,"_38":140,"_13":141,"_34":142,"_36":143,"_24":49,"_144":-5,"_27":145},"48bb794f-1842-4228-83fe-1986e9b2ec31","slack-bot.ts","parentId",44,"latest",["D",1780773582142],8,"http","// Slack Events API — add:/list: → SQLite + Apple Calendar\r\n// Env: SLACK_SIGNING_SECRET, SLACK_BOT_TOKEN, SLACK_WEBHOOK_DAILY (reply fallback)\r\n// ICLOUD_EMAIL, ICLOUD_APP_PASSWORD, optional ICLOUD_CALENDAR_NAME\r\n\r\nimport { createHmac, timingSafeEqual } from \"node:crypto\";\r\nimport { IncomingWebhook } from \"npm:@slack/webhook\";\r\nimport {\r\n ensureAppointmentSchema,\r\n saveAppointment,\r\n listUpcomingAppointments,\r\n parseAddCommand,\r\n} from \"./shared/appointments.ts\";\r\n\r\nconst HELP =\r\n \"Family butler:\\n• `add: morgen 15:00 Eva riding`\\n• `list:`\\n\\nSaves to morning briefing + Apple Calendar.\";\r\n\r\nasync function verifySlack(\r\n rawBody: string,\r\n timestamp: string | null,\r\n signature: string | null,\r\n signingSecret: string,\r\n): Promise {\r\n if (!timestamp || !signature) return false;\r\n const base = `v0:${timestamp}:${rawBody}`;\r\n const hmac = createHmac(\"sha256\", signingSecret).update(base).digest(\"hex\");\r\n const computed = `v0=${hmac}`;\r\n try {\r\n return timingSafeEqual(\r\n new TextEncoder().encode(computed),\r\n new TextEncoder().encode(signature),\r\n );\r\n } catch {\r\n return false;\r\n }\r\n}\r\n\r\nasync function slackReply(text: string): Promise {\r\n const token = Deno.env.get(\"SLACK_BOT_TOKEN\");\r\n if (token) {\r\n const res = await fetch(\"https://slack.com/api/chat.postMessage\", {\r\n method: \"POST\",\r\n headers: {\r\n Authorization: `Bearer ${token}`,\r\n \"Content-Type\": \"application/json\",\r\n },\r\n body: JSON.stringify({ channel: \"#daily\", text }),\r\n });\r\n const data = await res.json();\r\n if (data.ok) return;\r\n console.error(\"Slack reply failed:\", data.error);\r\n }\r\n\r\n const webhookUrl = Deno.env.get(\"SLACK_WEBHOOK_DAILY\") ??\r\n Deno.env.get(\"SLACK_WEBHOOK_URL\");\r\n if (webhookUrl) {\r\n const slack = new IncomingWebhook(webhookUrl);\r\n await slack.send(text);\r\n }\r\n}\r\n\r\nexport default async function (req: Request): Promise {\r\n const signingSecret = Deno.env.get(\"SLACK_SIGNING_SECRET\");\r\n const rawBody = await req.text();\r\n\r\n if (req.method !== \"POST\") {\r\n return new Response(\"Family butler Slack bot is running.\", { status: 200 });\r\n }\r\n\r\n if (signingSecret) {\r\n const ok = await verifySlack(\r\n rawBody,\r\n req.headers.get(\"x-slack-request-timestamp\"),\r\n req.headers.get(\"x-slack-signature\"),\r\n signingSecret,\r\n );\r\n if (!ok) return new Response(\"Invalid signature\", { status: 401 });\r\n }\r\n\r\n const payload = JSON.parse(rawBody);\r\n\r\n if (payload.type === \"url_verification\") {\r\n return new Response(payload.challenge, {\r\n headers: { \"Content-Type\": \"text/plain\" },\r\n });\r\n }\r\n\r\n if (payload.type !== \"event_callback\") {\r\n return Response.json({ ok: true });\r\n }\r\n\r\n const event = payload.event;\r\n if (!event || event.bot_id) {\r\n return Response.json({ ok: true });\r\n }\r\n\r\n if (event.type !== \"message\" && event.type !== \"app_mention\") {\r\n return Response.json({ ok: true });\r\n }\r\n if (event.type === \"message\" && event.subtype) {\r\n return Response.json({ ok: true });\r\n }\r\n\r\n const text = (event.text ?? \"\").replace(/<@[^>]+>\\s*/g, \"\").trim();\r\n console.log(\"Slack event:\", event.type, text);\r\n\r\n if (!text) return Response.json({ ok: true });\r\n\r\n await ensureAppointmentSchema();\r\n\r\n if (/^list:/i.test(text)) {\r\n const items = await listUpcomingAppointments();\r\n const reply = items.length\r\n ? `Upcoming:\\n${items.map((i) => `• ${i}`).join(\"\\n\")}`\r\n : \"No upcoming appointments. Try: `add: morgen 15:00 Eva riding`\";\r\n await slackReply(reply);\r\n return Response.json({ ok: true });\r\n }\r\n\r\n const appt = parseAddCommand(text);\r\n if (appt) {\r\n const { apple, appleError } = await saveAppointment(appt);\r\n const when = appt.time ? `${appt.date} ${appt.time}` : appt.date;\r\n const appleLine = apple\r\n ? \"Also added to Apple Calendar.\"\r\n : appleError?.includes(\"ICLOUD_EMAIL\")\r\n ? \"Apple Calendar skipped — add ICLOUD_EMAIL on Val Town.\"\r\n : `Apple Calendar: ${appleError ?? \"failed\"}`;\r\n await slackReply(`Saved: *${appt.title}* on ${when}\\n${appleLine}`);\r\n return Response.json({ ok: true });\r\n }\r\n\r\n if (event.type === \"app_mention\") {\r\n await slackReply(HELP);\r\n }\r\n\r\n return Response.json({ ok: true });\r\n}\r\n","label",[136],"8d96510c-dadb-420c-b38b-0c06fddf5e35","morningbriefing.ts","0a1e7f7a-61a7-11f1-9a9e-1607ee4eb77e",34,["D",1780769702820],11,"interval","// Morning cron — family briefing to #daily\n// Env: SLACK_WEBHOOK_DAILY or SLACK_WEBHOOK_URL, optional FAMILY_ICAL_URL\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { email } from \"https://esm.town/v/std/email\";\nimport { IncomingWebhook } from \"npm:@slack/webhook\";\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nimport { getAppointmentsForDate } from \"./shared/appointments.ts\";\n\nasync function todaysCalendarEvents(icalUrl: string): Promise {\n const url = icalUrl.replace(/^webcal:\\/\\//i, \"https://\");\n try {\n const ical = (await import(\"npm:node-ical\")).default;\n const data = await ical.async.fromURL(url);\n const today = new Date().toISOString().slice(0, 10);\n const events: string[] = [];\n\n for (const item of Object.values(data)) {\n if (item.type !== \"VEVENT\" || !item.start) continue;\n if (item.start.toISOString().slice(0, 10) !== today) continue;\n\n const time = item.start.toLocaleTimeString(\"nl-NL\", {\n hour: \"2-digit\",\n minute: \"2-digit\",\n timeZone: \"Europe/Amsterdam\",\n });\n const label = item.summary ?? \"Event\";\n events.push(time === \"00:00\" ? label : `${time} ${label}`);\n }\n\n return events.sort();\n } catch (error) {\n console.error(\"Calendar fetch failed:\", error);\n return [];\n }\n}\n\nexport default async function (_interval: Interval) {\n const today = new Date().toISOString().slice(0, 10);\n const dow = new Date().getDay();\n\n await sqlite.batch([\n \"CREATE TABLE IF NOT EXISTS config (key TEXT PRIMARY KEY, value TEXT)\",\n \"CREATE TABLE IF NOT EXISTS meals (date TEXT PRIMARY KEY, dish TEXT NOT NULL)\",\n \"CREATE TABLE IF NOT EXISTS rotation (task TEXT, day_of_week INTEGER, assignee TEXT, assist TEXT)\",\n ]);\n\n const meals = await sqlite.execute(\n \"SELECT date, dish FROM meals ORDER BY date DESC LIMIT 7\",\n );\n const chores = await sqlite.execute({\n sql: \"SELECT task, assignee FROM rotation WHERE day_of_week = ?\",\n args: [dow],\n });\n\n const icalUrl = Deno.env.get(\"FAMILY_ICAL_URL\");\n const appleCalendar = icalUrl ? await todaysCalendarEvents(icalUrl) : [];\n const butlerCalendar = await getAppointmentsForDate(today);\n const calendarEvents = [...appleCalendar, ...butlerCalendar.map((e) => `[butler] ${e}`)];\n\n const openai = new OpenAI();\n const completion = await openai.chat.completions.create({\n model: \"gpt-4o-mini\",\n messages: [{\n role: \"user\",\n content: `Family butler morning brief for ${today}.\n\nHOUSEHOLD FACTS (only these are true):\n- Parents: me + Anna. Kids: Milan (14), Eva (13).\n- Milan: walks Mylo (dog) daily 16:00-17:00.\n- Eva: Pepsi (cat) feed + litter. Owns pony Rosa. Eva does NOT play piano — never mention piano for Eva.\n- Anna: rides horse Kyana. Eva: rides/owns pony Rosa.\n- Kyana + Rosa are BOARDED — no stable feeding/cleaning reminders.\n\nDATA FOR TODAY (only mention activities from here):\n- Calendar (Apple + butler DB): ${JSON.stringify(calendarEvents)}\n- Chores rotation: ${JSON.stringify(chores.rows)}\n- Recent meals: ${JSON.stringify(meals.rows)}\n\nRULES:\n- Do NOT invent lessons, hobbies, instruments, or reminders not in the data above.\n- Do NOT guess activities for kids or parents.\n- If calendar is empty for someone, do not fill in with assumptions.\n- Mention Milan's Mylo walk. Suggest dinner. Keep it short and Slack-friendly.`,\n }],\n });\n\n const text = completion.choices[0].message.content ?? \"\";\n\n const webhookUrl = Deno.env.get(\"SLACK_WEBHOOK_DAILY\") ??\n Deno.env.get(\"SLACK_WEBHOOK_URL\");\n if (webhookUrl) {\n const slack = new IncomingWebhook(webhookUrl);\n await slack.send(text);\n } else {\n await email({ subject: `Family brief ${today}`, text });\n }\n}\n",[147],"0c5f0c09-e6f9-4c55-8b30-bfa1b55f794e","cron.ts","59986620-61a6-11f1-9e9a-1607ee4eb77e",20,["D",1780750420287],6,"// Val Town cron val — paste into a file with Cron trigger (see HANDOFF or chat)\n// Env: SLACK_WEBHOOK_URL (same one that worked in slack-test)\n\nimport { IncomingWebhook } from \"npm:@slack/webhook\";\n\nexport default async function (_interval: Interval) {\n const url = Deno.env.get(\"SLACK_WEBHOOK_DAILY\");\n if (!url) throw new Error(\"Missing SLACK_WEBHOOK_URL\");\n\n const day = new Date().getDay(); // 0=Sun, 6=Sat\n const dishwasher = day % 2 === 0 ? \"Milan\" : \"Eva\";\n\n const lines = [\n \"☀️ Good morning!\",\n `• Dishwasher today: ${dishwasher}`,\n \"• Milan: walk Mylo 16:00–17:00\",\n \"• Eva: Pepsi feed + litter\",\n ];\n if (day === 6) lines.push(\"• Saturday: clean your rooms\");\n\n const slack = new IncomingWebhook(url);\n await slack.send(lines.join(\"\\n\"));\n}",[156],"e4c0a743-f6ef-45a4-83eb-750083010cc3","shared","66f46181-8d05-4c65-bcca-cd48b2cabb6e",30,["D",1780769696406],"directory",[164],"02674820-082a-4a5a-8c34-33784c8578e3","scripts","b3ce88ed-427c-4cb5-8ae3-8ce7a75bdc3f",45,["D",1780774564186],[171],"pulls","branches",1,"forks","envVars",{"_184":141,"_186":64},"connections",{"_184":178,"_185":64},"count","unfilledCount","emptyCount",{"_43":170,"_32":171,"_30":172,"_137":-5,"_41":42,"_40":173,"_139":25,"_38":224,"_13":64,"_34":168,"_36":-5,"_24":49,"_144":-5,"_195":225,"_27":226},{"_43":163,"_32":164,"_30":165,"_137":-5,"_41":42,"_40":166,"_139":25,"_38":221,"_13":64,"_34":168,"_36":-5,"_24":49,"_144":-5,"_195":222,"_27":223},{"_43":213,"_32":214,"_30":215,"_137":165,"_41":42,"_40":216,"_139":49,"_38":217,"_13":178,"_34":35,"_36":218,"_24":49,"_144":-5,"_195":219,"_27":220},{"_43":204,"_32":205,"_30":206,"_137":165,"_41":42,"_40":207,"_139":49,"_38":208,"_13":209,"_34":35,"_36":210,"_24":49,"_144":-5,"_195":211,"_27":212},{"_43":155,"_32":156,"_30":157,"_137":-5,"_41":42,"_40":158,"_139":25,"_38":201,"_13":160,"_34":152,"_36":161,"_24":49,"_144":-5,"_195":202,"_27":203},{"_43":146,"_32":147,"_30":148,"_137":-5,"_41":42,"_40":149,"_139":49,"_38":198,"_13":151,"_34":152,"_36":153,"_24":49,"_144":-5,"_195":199,"_27":200},{"_43":135,"_32":136,"_30":59,"_137":-5,"_41":42,"_40":138,"_139":49,"_38":194,"_13":141,"_34":142,"_36":143,"_24":49,"_144":-5,"_195":196,"_27":197},["D",1780773582142],"children",[],[136],["D",1780769702820],[],[147],["D",1780750420287],[],[156],"9ce44d03-bc2b-4099-95b1-87be01be6acd","icloud-calendar.ts","a6236b76-61dc-11f1-94ba-1607ee4eb77e",50,["D",1780774634793],4,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\r\nimport type { Appointment } from \"./appointments.ts\";\r\n\r\nconst TZ = \"Europe/Amsterdam\";\r\nconst DISCOVERY_URLS = [\r\n \"https://caldav.icloud.com/\",\r\n \"https://caldav.icloud.com/co\",\r\n];\r\n\r\nfunction authHeader(): string | null {\r\n const email = Deno.env.get(\"ICLOUD_EMAIL\");\r\n const password = Deno.env.get(\"ICLOUD_APP_PASSWORD\");\r\n if (!email || !password) return null;\r\n return `Basic ${btoa(`${email}:${password}`)}`;\r\n}\r\n\r\nasync function davRequest(\r\n url: string,\r\n method: string,\r\n body?: string,\r\n depth = \"0\",\r\n): Promise {\r\n const auth = authHeader();\r\n if (!auth) throw new Error(\"Missing ICLOUD_EMAIL or ICLOUD_APP_PASSWORD\");\r\n\r\n const res = await fetch(url, {\r\n method,\r\n headers: {\r\n Authorization: auth,\r\n Depth: depth,\r\n \"Content-Type\": \"application/xml; charset=utf-8\",\r\n },\r\n body,\r\n });\r\n const text = await res.text();\r\n if (!res.ok) {\r\n throw new Error(`CalDAV ${method} ${url} failed: ${res.status} ${text.slice(0, 200)}`);\r\n }\r\n return text;\r\n}\r\n\r\nfunction firstHref(xml: string): string | null {\r\n const m = xml.match(/<[^>]*href[^>]*>([^<]+)<\\/[^>]*href>/i);\r\n return m?.[1] ?? null;\r\n}\r\n\r\nfunction principalHref(xml: string): string | null {\r\n const m = xml.match(/current-user-principal[\\s\\S]*?<[^>]*href[^>]*>([^<]+)]*href[^>]*>([^<]+) {\r\n const row = await sqlite.execute(\r\n \"SELECT value FROM config WHERE key = 'icloud_write_calendar_url'\",\r\n );\r\n const v = (row.rows[0] as { value?: string } | undefined)?.value;\r\n return v ?? null;\r\n}\r\n\r\nasync function cacheCalendarUrl(url: string): Promise {\r\n await sqlite.execute({\r\n sql: \"INSERT INTO config (key, value) VALUES ('icloud_write_calendar_url', ?) ON CONFLICT(key) DO UPDATE SET value = excluded.value\",\r\n args: [url],\r\n });\r\n}\r\n\r\nfunction parseCalendars(xml: string, homeUrl: string): { name: string; url: string }[] {\r\n const results: { name: string; url: string }[] = [];\r\n const blocks = xml.split(/<(?:[A-Za-z0-9]+:)?response\\b/i).slice(1);\r\n for (const block of blocks) {\r\n const href = firstHref(block);\r\n const nameM = block.match(/<[^>]*displayname[^>]*>([^<]*) {\r\n const body =\r\n \"

\";\r\n let lastErr = \"Could not find iCloud principal\";\r\n\r\n for (const base of DISCOVERY_URLS) {\r\n try {\r\n const xml = await davRequest(base, \"PROPFIND\", body);\r\n const href = principalHref(xml) ?? firstHref(xml);\r\n if (href && href !== \"/\") return absUrl(base, href);\r\n } catch (e) {\r\n lastErr = e instanceof Error ? e.message : String(e);\r\n }\r\n }\r\n\r\n throw new Error(lastErr);\r\n}\r\n\r\nasync function discoverWriteCalendarUrl(): Promise {\r\n const override = Deno.env.get(\"ICLOUD_CALDAV_CALENDAR_URL\");\r\n if (override) return override.endsWith(\"/\") ? override : `${override}/`;\r\n\r\n const cached = await getCachedCalendarUrl();\r\n if (cached) return cached;\r\n\r\n const principalUrl = await discoverPrincipalUrl();\r\n const homeXml = await davRequest(\r\n principalUrl,\r\n \"PROPFIND\",\r\n \"

\",\r\n );\r\n const homeHref = calendarHomeHref(homeXml) ?? firstHref(homeXml);\r\n if (!homeHref) throw new Error(\"Could not find calendar-home-set\");\r\n\r\n const homeUrl = absUrl(principalUrl, homeHref);\r\n const listXml = await davRequest(\r\n homeUrl.endsWith(\"/\") ? homeUrl : `${homeUrl}/`,\r\n \"PROPFIND\",\r\n \"\",\r\n \"1\",\r\n );\r\n\r\n const calendars = parseCalendars(listXml, homeUrl);\r\n if (!calendars.length) throw new Error(\"No writable iCloud calendars found\");\r\n\r\n const preferred = Deno.env.get(\"ICLOUD_CALENDAR_NAME\");\r\n const pick = preferred\r\n ? calendars.find((c) => c.name.toLowerCase() === preferred.toLowerCase())\r\n : calendars.find((c) => /^(home|thuis|familie|family|kalender)$/i.test(c.name));\r\n const url = (pick ?? calendars[0]).url;\r\n await cacheCalendarUrl(url);\r\n return url;\r\n}\r\n\r\nfunction icalLocal(date: string, time: string | null, allDay: boolean): string {\r\n const [y, m, d] = date.split(\"-\");\r\n if (allDay || !time) return `${y}${m}${d}`;\r\n const [hh, mm] = time.split(\":\");\r\n return `${y}${m}${d}T${hh}${mm}00`;\r\n}\r\n\r\nfunction escapeIcal(text: string): string {\r\n return text.replace(/\\\\/g, \"\\\\\\\\\").replace(/;/g, \"\\\\;\").replace(/,/g, \"\\\\,\")\r\n .replace(/\\n/g, \"\\\\n\");\r\n}\r\n\r\nfunction buildIcs(appt: Appointment, uid: string): string {\r\n const allDay = !appt.time;\r\n const start = icalLocal(appt.date, appt.time, allDay);\r\n let end = start;\r\n if (allDay) {\r\n const next = new Date(`${appt.date}T12:00:00`);\r\n next.setDate(next.getDate() + 1);\r\n end = icalLocal(next.toISOString().slice(0, 10), null, true);\r\n } else {\r\n const [hh, mm] = appt.time!.split(\":\").map(Number);\r\n const endH = String(hh + 1).padStart(2, \"0\");\r\n end = icalLocal(appt.date, `${endH}:${String(mm).padStart(2, \"0\")}`, false);\r\n }\r\n\r\n const startLine = allDay\r\n ? `DTSTART;VALUE=DATE:${start}`\r\n : `DTSTART;TZID=${TZ}:${start}`;\r\n const endLine = allDay\r\n ? `DTEND;VALUE=DATE:${end}`\r\n : `DTEND;TZID=${TZ}:${end}`;\r\n\r\n return [\r\n \"BEGIN:VCALENDAR\",\r\n \"VERSION:2.0\",\r\n \"PRODID:-//Family Butler//EN\",\r\n \"CALSCALE:GREGORIAN\",\r\n \"BEGIN:VEVENT\",\r\n `UID:${uid}`,\r\n `DTSTAMP:${new Date().toISOString().replace(/[-:]/g, \"\").slice(0, 15)}Z`,\r\n startLine,\r\n endLine,\r\n `SUMMARY:${escapeIcal(appt.title)}`,\r\n \"END:VEVENT\",\r\n \"END:VCALENDAR\",\r\n ].join(\"\\r\\n\");\r\n}\r\n\r\nexport async function syncAppointmentToICloud(\r\n appt: Appointment,\r\n): Promise<{ ok: boolean; error?: string }> {\r\n if (!authHeader()) {\r\n return { ok: false, error: \"Missing ICLOUD_EMAIL or ICLOUD_APP_PASSWORD\" };\r\n }\r\n\r\n try {\r\n const calendarUrl = await discoverWriteCalendarUrl();\r\n const uid = crypto.randomUUID();\r\n const eventUrl = `${calendarUrl}${uid}.ics`;\r\n const ics = buildIcs(appt, `${uid}@family-butler`);\r\n\r\n const auth = authHeader()!;\r\n const res = await fetch(eventUrl, {\r\n method: \"PUT\",\r\n headers: {\r\n Authorization: auth,\r\n \"Content-Type\": \"text/calendar; charset=utf-8\",\r\n \"If-None-Match\": \"*\",\r\n },\r\n body: ics,\r\n });\r\n\r\n if (!res.ok && res.status !== 201 && res.status !== 204) {\r\n const err = await res.text();\r\n throw new Error(`${res.status} ${err.slice(0, 200)}`);\r\n }\r\n\r\n return { ok: true };\r\n } catch (e) {\r\n const msg = e instanceof Error ? e.message : String(e);\r\n console.error(\"iCloud sync failed:\", msg);\r\n return { ok: false, error: msg };\r\n }\r\n}\r\n",[],[164,205],"e10c9ce6-35e8-4fad-9f3f-176614aa4a60","appointments.ts","9f540c50-61d3-11f1-b57f-1607ee4eb77e",43,["D",1780773578951],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\r\n\r\nconst TZ = \"Europe/Amsterdam\";\r\n\r\nexport type Appointment = {\r\n date: string;\r\n time: string | null;\r\n title: string;\r\n};\r\n\r\nexport async function ensureAppointmentSchema(): Promise {\r\n await sqlite.batch([\r\n \"CREATE TABLE IF NOT EXISTS config (key TEXT PRIMARY KEY, value TEXT)\",\r\n \"CREATE TABLE IF NOT EXISTS appointments (id INTEGER PRIMARY KEY AUTOINCREMENT, date TEXT NOT NULL, time TEXT, title TEXT NOT NULL, ical_uid TEXT, created_at TEXT DEFAULT CURRENT_TIMESTAMP)\",\r\n ]);\r\n try {\r\n await sqlite.execute(\"ALTER TABLE appointments ADD COLUMN ical_uid TEXT\");\r\n } catch {\r\n // column already exists\r\n }\r\n}\r\n\r\nfunction isoDate(d: Date): string {\r\n return d.toLocaleDateString(\"en-CA\", { timeZone: TZ });\r\n}\r\n\r\nfunction addDays(base: Date, days: number): Date {\r\n const d = new Date(base);\r\n d.setDate(d.getDate() + days);\r\n return d;\r\n}\r\n\r\nfunction nextWeekday(targetDow: number, from = new Date()): string {\r\n const d = new Date(from);\r\n const current = d.getDay();\r\n let delta = (targetDow - current + 7) % 7;\r\n if (delta === 0) delta = 7;\r\n return isoDate(addDays(d, delta));\r\n}\r\n\r\nconst DAY_MAP: Record = {\r\n sun: 0, sunday: 0, zo: 0, zondag: 0,\r\n mon: 1, monday: 1, ma: 1, maandag: 1,\r\n tue: 2, tuesday: 2, di: 2, dinsdag: 2,\r\n wed: 3, wednesday: 3, wo: 3, woensdag: 3,\r\n thu: 4, thursday: 4, do: 4, donderdag: 4,\r\n fri: 5, friday: 5, vr: 5, vrijdag: 5,\r\n sat: 6, saturday: 6, za: 6, zaterdag: 6,\r\n};\r\n\r\nexport function parseAddCommand(text: string): Appointment | null {\r\n const match = text.trim().match(/^add:\\s*(.+)$/i);\r\n if (!match) return null;\r\n\r\n let rest = match[1].trim();\r\n if (!rest) return null;\r\n\r\n let time: string | null = null;\r\n const timeMatch = rest.match(/\\b(\\d{1,2}):(\\d{2})\\b/);\r\n if (timeMatch) {\r\n time = `${timeMatch[1].padStart(2, \"0\")}:${timeMatch[2]}`;\r\n rest = rest.replace(timeMatch[0], \" \").trim();\r\n }\r\n\r\n let date: string | null = null;\r\n const isoMatch = rest.match(/\\b(\\d{4}-\\d{2}-\\d{2})\\b/);\r\n if (isoMatch) {\r\n date = isoMatch[1];\r\n rest = rest.replace(isoMatch[0], \" \").trim();\r\n }\r\n\r\n if (/\\b(today|vandaag)\\b/i.test(rest)) {\r\n date = isoDate(new Date());\r\n rest = rest.replace(/\\b(today|vandaag)\\b/gi, \" \").trim();\r\n }\r\n if (/\\b(tomorrow|morgen)\\b/i.test(rest)) {\r\n date = isoDate(addDays(new Date(), 1));\r\n rest = rest.replace(/\\b(tomorrow|morgen)\\b/gi, \" \").trim();\r\n }\r\n\r\n if (!date) {\r\n const lower = rest.toLowerCase();\r\n for (const [key, dow] of Object.entries(DAY_MAP)) {\r\n const re = new RegExp(`\\\\b${key}\\\\b`, \"i\");\r\n if (re.test(lower)) {\r\n date = nextWeekday(dow);\r\n rest = rest.replace(re, \" \").trim();\r\n break;\r\n }\r\n }\r\n }\r\n\r\n if (!date) date = isoDate(new Date());\r\n\r\n const title = rest.replace(/\\s+/g, \" \").trim();\r\n if (!title) return null;\r\n\r\n return { date, time, title };\r\n}\r\n\r\nexport async function insertAppointment(appt: Appointment): Promise {\r\n await ensureAppointmentSchema();\r\n await sqlite.execute({\r\n sql: \"INSERT INTO appointments (date, time, title) VALUES (?, ?, ?)\",\r\n args: [appt.date, appt.time, appt.title],\r\n });\r\n}\r\n\r\nexport async function saveAppointment(\r\n appt: Appointment,\r\n): Promise<{ apple: boolean; appleError?: string }> {\r\n await insertAppointment(appt);\r\n const { syncAppointmentToICloud } = await import(\"./icloud-calendar.ts\");\r\n const result = await syncAppointmentToICloud(appt);\r\n return { apple: result.ok, appleError: result.error };\r\n}\r\n\r\nexport async function getAppointmentsForDate(date: string): Promise {\r\n await ensureAppointmentSchema();\r\n const result = await sqlite.execute({\r\n sql: \"SELECT time, title FROM appointments WHERE date = ? ORDER BY time, title\",\r\n args: [date],\r\n });\r\n return (result.rows as { time: string | null; title: string }[]).map((row) => {\r\n if (row.time) return `${row.time} ${row.title}`;\r\n return row.title;\r\n });\r\n}\r\n\r\nexport async function listUpcomingAppointments(limit = 10): Promise {\r\n await ensureAppointmentSchema();\r\n const today = isoDate(new Date());\r\n const result = await sqlite.execute({\r\n sql: \"SELECT date, time, title FROM appointments WHERE date >= ? ORDER BY date, time LIMIT ?\",\r\n args: [today, limit],\r\n });\r\n return (result.rows as { date: string; time: string | null; title: string }[])\r\n .map((row) => {\r\n const when = row.time ? `${row.date} ${row.time}` : row.date;\r\n return `${when} — ${row.title}`;\r\n });\r\n}\r\n",[],[164,214],["D",1780769696406],[189,190],[164],["D",1780774564186],[],[171],["D",1780688454116],["D",1789502486629],{"_101":100,"_108":103},{"_101":100,"_102":103,"_104":103,"_18":57,"_105":106,"_107":49},{"_13":90,"_32":91,"_43":42,"_92":44,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":45,"_99":100},"ctx",{"_83":-5,"_127":265,"_266":267,"_268":269,"_270":49,"_271":49,"_272":49,"_273":25,"_274":-5,"_275":-7,"_276":-7,"_277":64,"_278":49,"_279":49,"_280":-5,"_281":49,"_282":49,"_283":49,"_284":-5},"ENV",{"_236":237,"_238":239,"_240":91,"_241":242,"_243":244,"_245":246,"_247":248,"_249":250,"_251":252,"_253":254,"_255":256,"_257":258,"_259":260,"_261":262,"_263":264},"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 · v51