[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_215":216,"_217":218},"routes/_app.x.$handle.$name",{"_100":99,"_31":44,"_108":90,"_26":102,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":24,"_122":123,"_124":59,"_125":-5,"_126":-5,"_127":128},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":54,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":24},"version",42,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","shared/icloud-calendar.ts","latestPath","fileId","a6236b76-61dc-11f1-94ba-1607ee4eb77e","name","icloud-calendar.ts","fileType","script","content","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_URL = \"https://caldav.icloud.com/\";\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 absUrl(base: string, href: string): string {\r\n if (href.startsWith(\"http\")) return href.replace(/:443\\//, \"/\");\r\n return new URL(href, base).toString().replace(/:443\\//, \"/\");\r\n}\r\n\r\nasync function getCachedCalendarUrl(): Promise {\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 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 principalXml = await davRequest(\r\n DISCOVERY_URL,\r\n \"PROPFIND\",\r\n \"

\",\r\n );\r\n const principalHref = firstHref(principalXml);\r\n if (!principalHref) throw new Error(\"Could not find iCloud principal\");\r\n\r\n const principalUrl = absUrl(DISCOVERY_URL, principalHref);\r\n const homeXml = await davRequest(\r\n principalUrl,\r\n \"PROPFIND\",\r\n \"

\",\r\n );\r\n const homeHref = 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","createdAt",["D",1780773573305],"branchVersion","branchId","67b31c9f-abdc-460c-820d-3545aa45f61f","id","4bfef0de-e74e-47c0-ba37-39d09b0a8ffe","family-butler",["D",1780688454116],"deletedAt","legacyEnvVars","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=1789588799&sig=e9bb9e6c9a698d7a8e3d15c8af46fe052e307c4146d2bb834109cad406604d12","08b6ee43-68da-4bf2-918a-58fd79608932","pinnedFileId","a19b903c-61d3-11f1-af58-1607ee4eb77e","pinPreview",true,"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",{"_100":99,"_107":102},"org",{"_100":99,"_101":102,"_103":102,"_18":55,"_104":105,"_106":24},"branch",{"_13":89,"_31":90,"_42":41,"_91":43,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":44,"_98":99},"isOwned",82,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Robbertd","handle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_42":43,"_31":44,"_37":210,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":54,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":211,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":212,"_84":213,"_86":214,"_88":24},"tree",[180,183,184,185],"files",[180,181,182,183,184,185],"counts",{"_168":63,"_169":170,"_171":63,"_172":173,"_174":175},"contents",[129,130,131,132],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":161,"_31":162,"_29":163,"_135":-5,"_40":41,"_39":164,"_137":59,"_37":165,"_13":63,"_33":166,"_35":-5,"_23":24,"_142":-5,"_26":167},{"_42":153,"_31":154,"_29":155,"_135":-5,"_40":41,"_39":156,"_137":59,"_37":157,"_13":158,"_33":150,"_35":159,"_23":24,"_142":-5,"_26":160},{"_42":144,"_31":145,"_29":146,"_135":-5,"_40":41,"_39":147,"_137":24,"_37":148,"_13":149,"_33":150,"_35":151,"_23":24,"_142":-5,"_26":152},{"_42":133,"_31":134,"_29":57,"_135":-5,"_40":41,"_39":136,"_137":24,"_37":138,"_13":139,"_33":140,"_35":141,"_23":24,"_142":-5,"_26":143},"647b418d-de20-44ee-a74a-5c8fb9a56996","slack-bot.ts","parentId",41,"latest",["D",1780773268757],7,"http","// Slack Events API — add:/list: via @mention or channel message\n// Env: SLACK_SIGNING_SECRET, SLACK_BOT_TOKEN, SLACK_WEBHOOK_DAILY (reply fallback)\n\nimport { createHmac, timingSafeEqual } from \"node:crypto\";\nimport { IncomingWebhook } from \"npm:@slack/webhook\";\nimport {\n ensureAppointmentSchema,\n insertAppointment,\n listUpcomingAppointments,\n parseAddCommand,\n} from \"./shared/appointments.ts\";\n\nconst HELP =\n \"Family butler commands:\\n• `add: vrijdag 15:00 Eva riding Rosa`\\n• `list:` — upcoming butler appointments\\n\\nSaved items show in the *morning briefing*, not Apple Calendar.\";\n\nasync function verifySlack(\n rawBody: string,\n timestamp: string | null,\n signature: string | null,\n signingSecret: string,\n): Promise {\n if (!timestamp || !signature) return false;\n const base = `v0:${timestamp}:${rawBody}`;\n const hmac = createHmac(\"sha256\", signingSecret).update(base).digest(\"hex\");\n const computed = `v0=${hmac}`;\n try {\n return timingSafeEqual(\n new TextEncoder().encode(computed),\n new TextEncoder().encode(signature),\n );\n } catch {\n return false;\n }\n}\n\nasync function slackReply(text: string): Promise {\n const token = Deno.env.get(\"SLACK_BOT_TOKEN\");\n if (token) {\n const res = await fetch(\"https://slack.com/api/chat.postMessage\", {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${token}`,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ channel: \"#daily\", text }),\n });\n const data = await res.json();\n if (data.ok) return;\n console.error(\"Slack reply failed:\", data.error);\n }\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 }\n}\n\nexport default async function (req: Request): Promise {\n const signingSecret = Deno.env.get(\"SLACK_SIGNING_SECRET\");\n const botToken = Deno.env.get(\"SLACK_BOT_TOKEN\");\n const rawBody = await req.text();\n\n if (req.method !== \"POST\") {\n return new Response(\"Family butler Slack bot is running.\", { status: 200 });\n }\n\n if (signingSecret) {\n const ok = await verifySlack(\n rawBody,\n req.headers.get(\"x-slack-request-timestamp\"),\n req.headers.get(\"x-slack-signature\"),\n signingSecret,\n );\n if (!ok) return new Response(\"Invalid signature\", { status: 401 });\n }\n\n const payload = JSON.parse(rawBody);\n\n if (payload.type === \"url_verification\") {\n return new Response(payload.challenge, {\n headers: { \"Content-Type\": \"text/plain\" },\n });\n }\n\n if (payload.type !== \"event_callback\") {\n return Response.json({ ok: true });\n }\n\n const event = payload.event;\n if (!event || event.bot_id) {\n return Response.json({ ok: true });\n }\n\n // message.channels or app_mention\n if (event.type !== \"message\" && event.type !== \"app_mention\") {\n return Response.json({ ok: true });\n }\n if (event.type === \"message\" && event.subtype) {\n return Response.json({ ok: true });\n }\n\n const text = (event.text ?? \"\").replace(/<@[^>]+>\\s*/g, \"\").trim();\n\n console.log(\"Slack event:\", event.type, text);\n\n if (!text) {\n return Response.json({ ok: true });\n }\n\n await ensureAppointmentSchema();\n\n if (/^list:/i.test(text)) {\n const items = await listUpcomingAppointments();\n const reply = items.length\n ? `Upcoming (butler DB):\\n${items.map((i) => `• ${i}`).join(\"\\n\")}`\n : \"No upcoming appointments yet. Try: `add: morgen 15:00 Eva riding Rosa`\";\n await slackReply(reply);\n return Response.json({ ok: true });\n }\n\n const appt = parseAddCommand(text);\n if (appt) {\n await insertAppointment(appt);\n const when = appt.time ? `${appt.date} ${appt.time}` : appt.date;\n await slackReply(\n `Saved: *${appt.title}* on ${when}\\nShows in tomorrow's morning briefing — not Apple Calendar.`,\n );\n return Response.json({ ok: true });\n }\n\n if (event.type === \"app_mention\") {\n await slackReply(HELP);\n }\n\n return Response.json({ ok: true });\n}\n","label",[134],"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",[145],"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}",[154],"e4c0a743-f6ef-45a4-83eb-750083010cc3","shared","66f46181-8d05-4c65-bcca-cd48b2cabb6e",30,["D",1780769696406],"directory",[162],"pulls","branches",1,"forks","envVars",{"_176":178,"_179":63},"connections",{"_176":170,"_177":63},"count","unfilledCount",8,"emptyCount",{"_42":161,"_31":162,"_29":163,"_135":-5,"_40":41,"_39":164,"_137":59,"_37":207,"_13":63,"_33":166,"_35":-5,"_23":24,"_142":-5,"_187":208,"_26":209},{"_42":200,"_31":201,"_29":202,"_135":163,"_40":41,"_39":164,"_137":24,"_37":203,"_13":63,"_33":34,"_35":204,"_23":24,"_142":-5,"_187":205,"_26":206},{"_42":196,"_31":32,"_29":30,"_135":163,"_40":41,"_39":14,"_137":24,"_37":197,"_13":63,"_33":34,"_35":36,"_23":24,"_142":-5,"_187":198,"_26":199},{"_42":153,"_31":154,"_29":155,"_135":-5,"_40":41,"_39":156,"_137":59,"_37":193,"_13":158,"_33":150,"_35":159,"_23":24,"_142":-5,"_187":194,"_26":195},{"_42":144,"_31":145,"_29":146,"_135":-5,"_40":41,"_39":147,"_137":24,"_37":190,"_13":149,"_33":150,"_35":151,"_23":24,"_142":-5,"_187":191,"_26":192},{"_42":133,"_31":134,"_29":57,"_135":-5,"_40":41,"_39":136,"_137":24,"_37":186,"_13":139,"_33":140,"_35":141,"_23":24,"_142":-5,"_187":188,"_26":189},["D",1780773268757],"children",[],[134],["D",1780769702820],[],[145],["D",1780750420287],[],[154],"c3b35be1-12ed-4827-a6f9-4890880e214e",["D",1780773573305],[],[162,32],"7402b900-2a9b-4350-bf57-2dc31286553c","appointments.ts","9f540c50-61d3-11f1-b57f-1607ee4eb77e",["D",1780769696406],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst TZ = \"Europe/Amsterdam\";\n\nexport type Appointment = {\n date: string;\n time: string | null;\n title: string;\n};\n\nexport async function ensureAppointmentSchema(): Promise {\n await sqlite.batch([\n \"CREATE TABLE IF NOT EXISTS appointments (id INTEGER PRIMARY KEY AUTOINCREMENT, date TEXT NOT NULL, time TEXT, title TEXT NOT NULL, created_at TEXT DEFAULT CURRENT_TIMESTAMP)\",\n ]);\n}\n\nfunction isoDate(d: Date): string {\n return d.toLocaleDateString(\"en-CA\", { timeZone: TZ });\n}\n\nfunction addDays(base: Date, days: number): Date {\n const d = new Date(base);\n d.setDate(d.getDate() + days);\n return d;\n}\n\nfunction nextWeekday(targetDow: number, from = new Date()): string {\n const d = new Date(from);\n const current = d.getDay();\n let delta = (targetDow - current + 7) % 7;\n if (delta === 0) delta = 7;\n return isoDate(addDays(d, delta));\n}\n\nconst DAY_MAP: Record = {\n sun: 0, sunday: 0, zo: 0, zondag: 0,\n mon: 1, monday: 1, ma: 1, maandag: 1,\n tue: 2, tuesday: 2, di: 2, dinsdag: 2,\n wed: 3, wednesday: 3, wo: 3, woensdag: 3,\n thu: 4, thursday: 4, do: 4, donderdag: 4,\n fri: 5, friday: 5, vr: 5, vrijdag: 5,\n sat: 6, saturday: 6, za: 6, zaterdag: 6,\n};\n\nexport function parseAddCommand(text: string): Appointment | null {\n const match = text.trim().match(/^add:\\s*(.+)$/i);\n if (!match) return null;\n\n let rest = match[1].trim();\n if (!rest) return null;\n\n let time: string | null = null;\n const timeMatch = rest.match(/\\b(\\d{1,2}):(\\d{2})\\b/);\n if (timeMatch) {\n time = `${timeMatch[1].padStart(2, \"0\")}:${timeMatch[2]}`;\n rest = rest.replace(timeMatch[0], \" \").trim();\n }\n\n let date: string | null = null;\n const isoMatch = rest.match(/\\b(\\d{4}-\\d{2}-\\d{2})\\b/);\n if (isoMatch) {\n date = isoMatch[1];\n rest = rest.replace(isoMatch[0], \" \").trim();\n }\n\n if (/\\b(today|vandaag)\\b/i.test(rest)) {\n date = isoDate(new Date());\n rest = rest.replace(/\\b(today|vandaag)\\b/gi, \" \").trim();\n }\n if (/\\b(tomorrow|morgen)\\b/i.test(rest)) {\n date = isoDate(addDays(new Date(), 1));\n rest = rest.replace(/\\b(tomorrow|morgen)\\b/gi, \" \").trim();\n }\n\n if (!date) {\n const lower = rest.toLowerCase();\n for (const [key, dow] of Object.entries(DAY_MAP)) {\n const re = new RegExp(`\\\\b${key}\\\\b`, \"i\");\n if (re.test(lower)) {\n date = nextWeekday(dow);\n rest = rest.replace(re, \" \").trim();\n break;\n }\n }\n }\n\n if (!date) date = isoDate(new Date());\n\n const title = rest.replace(/\\s+/g, \" \").trim();\n if (!title) return null;\n\n return { date, time, title };\n}\n\nexport async function insertAppointment(appt: Appointment): Promise {\n await ensureAppointmentSchema();\n await sqlite.execute({\n sql: \"INSERT INTO appointments (date, time, title) VALUES (?, ?, ?)\",\n args: [appt.date, appt.time, appt.title],\n });\n}\n\nexport async function getAppointmentsForDate(date: string): Promise {\n await ensureAppointmentSchema();\n const result = await sqlite.execute({\n sql: \"SELECT time, title FROM appointments WHERE date = ? ORDER BY time, title\",\n args: [date],\n });\n return (result.rows as { time: string | null; title: string }[]).map((row) => {\n if (row.time) return `${row.time} ${row.title}`;\n return row.title;\n });\n}\n\nexport async function listUpcomingAppointments(limit = 10): Promise {\n await ensureAppointmentSchema();\n const today = isoDate(new Date());\n const result = await sqlite.execute({\n sql: \"SELECT date, time, title FROM appointments WHERE date >= ? ORDER BY date, time LIMIT ?\",\n args: [today, limit],\n });\n return (result.rows as { date: string; time: string | null; title: string }[])\n .map((row) => {\n const when = row.time ? `${row.date} ${row.time}` : row.date;\n return `${when} — ${row.title}`;\n });\n}\n",[],[162,201],["D",1780769696406],[181,182],[162],["D",1780688454116],["D",1789502486629],{"_100":99,"_107":102},{"_100":99,"_101":102,"_103":102,"_18":55,"_104":105,"_106":24},{"_13":89,"_31":90,"_42":41,"_91":43,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":44,"_98":99},"ctx",{"_82":-5,"_126":248,"_249":250,"_251":252,"_253":24,"_254":24,"_255":24,"_256":59,"_257":-5,"_258":-7,"_259":-7,"_260":63,"_261":24,"_262":24,"_263":-5,"_264":24,"_265":24,"_266":24,"_267":-5},"ENV",{"_219":220,"_221":222,"_223":90,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v42