\";\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 icalDate(date: string): string {\r\n return date.replace(/-/g, \"\");\r\n}\r\n\r\nfunction localInZoneToUtc(date: string, time: string, timeZone: string): Date {\r\n const target = `${date} ${time}:00`;\r\n const [y, mo, d] = date.split(\"-\").map(Number);\r\n const dayStart = Date.UTC(y, mo - 1, d, 0, 0, 0);\r\n const dayEnd = Date.UTC(y, mo - 1, d + 1, 0, 0, 0);\r\n for (let t = dayStart; t < dayEnd; t += 60_000) {\r\n const formatted = new Date(t).toLocaleString(\"sv-SE\", { timeZone });\r\n if (formatted === target) return new Date(t);\r\n }\r\n throw new Error(`Could not convert ${target} (${timeZone})`);\r\n}\r\n\r\nfunction utcToIcal(dt: Date): string {\r\n return `${dt.toISOString().replace(/[-:]/g, \"\").slice(0, 15)}Z`;\r\n}\r\n\r\nfunction nextDayDate(date: string): string {\r\n const [y, mo, d] = date.split(\"-\").map(Number);\r\n return new Date(Date.UTC(y, mo - 1, d + 1)).toISOString().slice(0, 10);\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 let startLine: string;\r\n let endLine: string;\r\n\r\n if (allDay) {\r\n const end = appt.endDate ?? appt.date;\r\n startLine = `DTSTART;VALUE=DATE:${icalDate(appt.date)}`;\r\n endLine = `DTEND;VALUE=DATE:${icalDate(nextDayDate(end))}`;\r\n } else {\r\n const startUtc = localInZoneToUtc(appt.date, appt.time!, TZ);\r\n const endUtc = new Date(startUtc.getTime() + 60 * 60 * 1000);\r\n startLine = `DTSTART:${utcToIcal(startUtc)}`;\r\n endLine = `DTEND:${utcToIcal(endUtc)}`;\r\n }\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",[19,61],"a08ef9c0-a3b8-4d12-b023-49e127e74bee","appointments.ts","9f540c50-61d3-11f1-b57f-1607ee4eb77e",74,["D",1780777510355],2,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst TZ = \"Europe/Amsterdam\";\n\nexport type Appointment = {\n date: string;\n endDate?: string;\n time: string | null;\n title: string;\n};\n\nconst MONTH_MAP: Record = {\n jan: 1, january: 1, januari: 1,\n feb: 2, february: 2, februari: 2,\n mrt: 3, mar: 3, march: 3, maart: 3,\n apr: 4, april: 4,\n may: 5, mei: 5,\n jun: 6, june: 6, juni: 6,\n jul: 7, july: 7, juli: 7,\n aug: 8, august: 8, augustus: 8,\n sep: 9, sept: 9, september: 9,\n okt: 10, oct: 10, october: 10, oktober: 10,\n nov: 11, november: 11,\n dec: 12, december: 12,\n};\n\nexport async function ensureAppointmentSchema(): Promise {\n await sqlite.batch([\n \"CREATE TABLE IF NOT EXISTS config (key TEXT PRIMARY KEY, value TEXT)\",\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)\",\n ]);\n try {\n await sqlite.execute(\"ALTER TABLE appointments ADD COLUMN ical_uid TEXT\");\n } catch {\n // column already exists\n }\n try {\n await sqlite.execute(\"ALTER TABLE appointments ADD COLUMN end_date TEXT\");\n } catch {\n // column already exists\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\nfunction defaultYear(month: number, day: number): number {\n const today = isoDate(new Date());\n const y = parseInt(today.slice(0, 4), 10);\n const candidate = `${y}-${String(month).padStart(2, \"0\")}-${String(day).padStart(2, \"0\")}`;\n return candidate < today ? y + 1 : y;\n}\n\nfunction monthDayToIso(month: number, day: number, year?: number): string {\n const y = year ?? defaultYear(month, day);\n return `${y}-${String(month).padStart(2, \"0\")}-${String(day).padStart(2, \"0\")}`;\n}\n\nfunction parsePartialDate(token: string, yearHint?: number): string | null {\n const t = token.trim().toLowerCase();\n const iso = t.match(/^(\\d{4})-(\\d{2})-(\\d{2})$/);\n if (iso) return `${iso[1]}-${iso[2]}-${iso[3]}`;\n\n let m = t.match(/^(\\d{1,2})\\s+([a-z]+)$/);\n if (m) {\n const month = MONTH_MAP[m[2]];\n if (month) return monthDayToIso(month, parseInt(m[1], 10), yearHint);\n }\n m = t.match(/^([a-z]+)\\s+(\\d{1,2})$/);\n if (m) {\n const month = MONTH_MAP[m[1]];\n if (month) return monthDayToIso(month, parseInt(m[2], 10), yearHint);\n }\n return null;\n}\n\nfunction parseEndDate(startIso: string, endToken: string): string | null {\n const startYear = parseInt(startIso.slice(0, 4), 10);\n let end = parsePartialDate(endToken, startYear);\n if (!end) return null;\n if (end < startIso) {\n end = parsePartialDate(endToken, startYear + 1);\n }\n return end;\n}\n\nfunction tryParseRange(rest: string): { start: string; end: string; matched: string } | null {\n const isoRange = rest.match(\n /\\b(\\d{4}-\\d{2}-\\d{2})\\s+(?:to|tot|t\\/m|-)\\s+(\\d{4}-\\d{2}-\\d{2})\\b/i,\n );\n if (isoRange) {\n const start = isoRange[1];\n const end = isoRange[2];\n if (start <= end) return { start, end, matched: isoRange[0] };\n }\n\n const natural = rest.match(\n /\\b(\\d{1,2}\\s+[a-z]+|[a-z]+\\s+\\d{1,2})\\s+(?:to|tot|t\\/m|-)\\s+(\\d{1,2}\\s+[a-z]+|[a-z]+\\s+\\d{1,2})\\b/i,\n );\n if (natural) {\n const start = parsePartialDate(natural[1]);\n if (!start) return null;\n const end = parseEndDate(start, natural[2]);\n if (end && start <= end) {\n return { start, end, matched: natural[0] };\n }\n }\n\n return null;\n}\n\nfunction hasUnparsedDateHints(text: string): boolean {\n return /\\b(?:to|tot|t\\/m)\\b/i.test(text) ||\n /\\b\\d{1,2}\\s+(?:jan|feb|mrt|mar|apr|may|mei|jun|jul|aug|sep|okt|oct|nov|dec|januari|februari|maart|april|juni|juli|augustus|september|oktober|november|december)\\b/i\n .test(text) ||\n /\\b(?:januari|februari|maart|april|mei|juni|juli|augustus|september|oktober|november|december|january|february|march|april|may|june|july|august|september|october|november|december)\\s+\\d{1,2}\\b/i\n .test(text);\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 let endDate: string | undefined;\n\n const range = tryParseRange(rest);\n if (range) {\n date = range.start;\n endDate = range.end;\n rest = rest.replace(range.matched, \" \").trim();\n }\n\n if (!date) {\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\n if (!date && /\\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 (!date && /\\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 && hasUnparsedDateHints(rest)) return null;\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, endDate, time, title };\n}\n\nexport async function insertAppointment(appt: Appointment): Promise {\n await ensureAppointmentSchema();\n await sqlite.execute({\n sql: \"INSERT INTO appointments (date, end_date, time, title) VALUES (?, ?, ?, ?)\",\n args: [appt.date, appt.endDate ?? null, appt.time, appt.title],\n });\n}\n\nexport async function saveAppointment(\n appt: Appointment,\n): Promise<{ apple: boolean; appleError?: string }> {\n await insertAppointment(appt);\n const { syncAppointmentToICloud } = await import(\"./icloud-calendar.ts\");\n const result = await syncAppointmentToICloud(appt);\n return { apple: result.ok, appleError: result.error };\n}\n\nexport async function getAppointmentsForDate(date: string): Promise {\n await ensureAppointmentSchema();\n const result = await sqlite.execute({\n sql: `SELECT time, title, date, end_date FROM appointments\n WHERE date <= ? AND COALESCE(end_date, date) >= ?\n ORDER BY time, title`,\n args: [date, date],\n });\n return (result.rows as { time: string | null; title: string; date: string; end_date: string | null }[])\n .map((row) => {\n const range = row.end_date && row.end_date !== row.date\n ? ` (${row.date} - ${row.end_date})`\n : \"\";\n if (row.time) return `${row.time} ${row.title}${range}`;\n return `${row.title}${range}`;\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, end_date, time, title FROM appointments\n WHERE COALESCE(end_date, date) >= ?\n ORDER BY date, time LIMIT ?`,\n args: [today, limit],\n });\n return (result.rows as { date: string; end_date: string | null; time: string | null; title: string }[])\n .map((row) => {\n const when = row.end_date && row.end_date !== row.date\n ? `${row.date} - ${row.end_date}`\n : row.time\n ? `${row.date} ${row.time}`\n : row.date;\n return `${when} - ${row.title}`;\n });\n}\n",[19,68],"e4c0a743-f6ef-45a4-83eb-750083010cc3",30,["D",1780769696406],0,"directory",[19],{"_36":131,"_13":132,"_39":133,"_41":-5,"_43":44,"_45":134,"_47":48,"_49":135,"_17":78,"_52":79,"_54":-5,"_56":57,"_58":-5,"_94":136,"_18":137},{"_36":75,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":76,"_47":48,"_49":116,"_17":78,"_52":79,"_54":-5,"_56":57,"_58":-5,"_94":117,"_18":118},{"_36":107,"_13":108,"_39":109,"_41":-5,"_43":44,"_45":110,"_47":48,"_49":111,"_17":112,"_52":103,"_54":113,"_56":57,"_58":-5,"_94":114,"_18":115},{"_36":97,"_13":98,"_39":99,"_41":-5,"_43":44,"_45":100,"_47":48,"_49":101,"_17":102,"_52":103,"_54":104,"_56":57,"_58":-5,"_94":105,"_18":106},{"_36":86,"_13":87,"_39":88,"_41":-5,"_43":44,"_45":89,"_47":48,"_49":90,"_17":91,"_52":92,"_54":93,"_56":57,"_58":-5,"_94":95,"_18":96},"ffff31fc-0281-4d2a-8a71-60dd7de0cb5e","slack-bot.ts","a19b903c-61d3-11f1-af58-1607ee4eb77e",82,["D",1780777879564],12,"http","// Slack Events API — appointments + meals\n// Env: SLACK_SIGNING_SECRET, SLACK_BOT_TOKEN, SLACK_WEBHOOK_DAILY, SLACK_WEBHOOK_MEALS\n\nimport { createHmac, timingSafeEqual } from \"node:crypto\";\nimport { IncomingWebhook } from \"npm:@slack/webhook\";\nimport {\n ensureAppointmentSchema,\n saveAppointment,\n listUpcomingAppointments,\n parseAddCommand,\n} from \"./shared/appointments.ts\";\nimport {\n ensureMealsSchema,\n saveMeal,\n listUpcomingMeals,\n parseMealCommand,\n suggestMealForDate,\n todayDate,\n} from \"./shared/meals.ts\";\n\nconst HELP = `*Family Butler — help*\n\n*Afspraken*\n• \\`add: morgen 15:00 Eva riding\\` — afspraak met tijd\n• \\`add: 29 augustus tot 3 september Anna vakantie\\` — datumbereik\n• \\`add: 2026-08-29 tot 2026-09-03 Anna vakantie\\` — datumbereik (ISO)\n• \\`list:\\` — komende afspraken\n\nDatums: vandaag, morgen, weekdag, \\`2026-06-07\\`, \\`29 augustus\\`\nBereik: \\`tot\\`, \\`to\\`, of \\`t/m\\` tussen twee datums\n\n*Maaltijden* (#meals)\n• \\`meal: pasta\\` — vanavond\n• \\`meal: morgen stamppot\\` — andere dag\n• \\`meal: list\\` — geplande maaltijden\n• \\`meal: anders\\` — nieuw AI-voorstel voor vanavond\n(ook: \\`eten:\\` of \\`diner:\\`)\n\n*Help*\n• \\`help\\` of \\`help:\\` — dit bericht\n• @Family Butler — ook help`;\n\nfunction isHelpCommand(text: string): boolean {\n const t = text.trim();\n if (/^(?:help|hulp)(?::|\\s*|$)/i.test(t)) return true;\n if (t === \"?\") return true;\n if (/^(?:commands?|wat kan|what can)/i.test(t)) return true;\n return false;\n}\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(\n text: string,\n opts?: { channel?: string; meals?: boolean },\n): Promise {\n const channel = opts?.channel ?? \"#daily\";\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, 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 = opts?.meals\n ? Deno.env.get(\"SLACK_WEBHOOK_MEALS\")\n : Deno.env.get(\"SLACK_WEBHOOK_DAILY\") ?? 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 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 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 const channel = event.channel as string | undefined;\n console.log(\"Slack event:\", event.type, text);\n\n if (!text) return Response.json({ ok: true });\n\n if (isHelpCommand(text)) {\n const meals = /^(?:meal|eten|diner):/i.test(text);\n await slackReply(HELP, { channel, meals });\n return Response.json({ ok: true });\n }\n\n const mealCmd = parseMealCommand(text);\n if (mealCmd) {\n await ensureMealsSchema();\n const replyOpts = { channel, meals: true };\n\n if (mealCmd === \"list\") {\n const items = await listUpcomingMeals();\n const reply = items.length\n ? `Meals:\\n${items.map((i) => `• ${i}`).join(\"\\n\")}`\n : \"No meals planned. Try: `meal: pasta` or `meal: anders`\";\n await slackReply(reply, replyOpts);\n return Response.json({ ok: true });\n }\n\n if (mealCmd === \"anders\") {\n const meal = await suggestMealForDate(todayDate());\n await slackReply(`Nieuw voorstel voor vanavond: *${meal.dish}*`, replyOpts);\n return Response.json({ ok: true });\n }\n\n await saveMeal(mealCmd.date, mealCmd.dish, \"manual\");\n const when = mealCmd.date === todayDate() ? \"vanavond\" : mealCmd.date;\n await slackReply(`Opgeslagen voor ${when}: *${mealCmd.dish}*`, replyOpts);\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:\\n${items.map((i) => `• ${i}`).join(\"\\n\")}`\n : \"No upcoming appointments. Try: `add: morgen 15:00 Eva riding`\";\n await slackReply(reply, { channel });\n return Response.json({ ok: true });\n }\n\n const appt = parseAddCommand(text);\n if (appt) {\n const { apple, appleError } = await saveAppointment(appt);\n const when = appt.endDate && appt.endDate !== appt.date\n ? `${appt.date} – ${appt.endDate}`\n : appt.time\n ? `${appt.date} ${appt.time}`\n : appt.date;\n const appleLine = apple\n ? \"Also added to Apple Calendar.\"\n : appleError?.includes(\"ICLOUD_EMAIL\")\n ? \"Apple Calendar skipped — add ICLOUD_EMAIL on Val Town.\"\n : `Apple Calendar: ${appleError ?? \"failed\"}`;\n await slackReply(`Saved: *${appt.title}* on ${when}\\n${appleLine}`, { channel });\n return Response.json({ ok: true });\n }\n\n if (event.type === \"app_mention\") {\n await slackReply(HELP, { channel });\n }\n\n return Response.json({ ok: true });\n}\n","children",[],[87],"e5496f7b-0c3f-490c-a39a-549e7ad0dde3","morningbriefing.ts","0a1e7f7a-61a7-11f1-9a9e-1607ee4eb77e",73,["D",1780775710665],18,"interval","// Val Town cron file: morningbriefing.ts\n// Env: SLACK_WEBHOOK_DAILY, SLACK_WEBHOOK_MEALS, 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\";\nimport {\n ensureTodaysSuggestion,\n getRecentDishes,\n todayDate,\n} from \"./shared/meals.ts\";\n\nconst TZ = \"Europe/Amsterdam\";\n\nasync function todaysCalendarEvents(icalUrl: string, today: 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 events: string[] = [];\n\n for (const item of Object.values(data)) {\n if (item.type !== \"VEVENT\" || !item.start) continue;\n const eventDate = item.start.toLocaleDateString(\"en-CA\", { timeZone: TZ });\n if (eventDate !== today) continue;\n\n const time = item.start.toLocaleTimeString(\"nl-NL\", {\n hour: \"2-digit\",\n minute: \"2-digit\",\n timeZone: TZ,\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 = todayDate();\n const dow = new Date(new Date().toLocaleString(\"en-US\", { timeZone: TZ })).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, source TEXT DEFAULT 'manual')\",\n \"CREATE TABLE IF NOT EXISTS rotation (task TEXT, day_of_week INTEGER, assignee TEXT, assist TEXT)\",\n ]);\n\n const tonight = await ensureTodaysSuggestion();\n const recentDishes = await getRecentDishes();\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, today) : [];\n const butlerCalendar = await getAppointmentsForDate(today);\n const calendarEvents = [...appleCalendar, ...butlerCalendar.map((e) => `[butler] ${e}`)];\n\n const dinnerLine = tonight.source === \"standing\"\n ? `Tonight's dinner (2-week family routine): ${tonight.dish}`\n : tonight.source === \"suggested\"\n ? `Tonight's dinner (AI suggestion, override in #meals with meal: …): ${tonight.dish}`\n : `Tonight's dinner (planned): ${tonight.dish}`;\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- ${dinnerLine}\n- Recent meals (for context only, do not invent new ones): ${JSON.stringify(recentDishes)}\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 tonight's dinner exactly as given above — do NOT suggest a different meal.\n- Mention Milan's Mylo walk. Keep it short and Slack-friendly.`,\n }],\n });\n\n const text = completion.choices[0].message.content ?? \"\";\n\n const dailyWebhook =\n Deno.env.get(\"SLACK_WEBHOOK_DAILY\") ?? Deno.env.get(\"SLACK_WEBHOOK_URL\");\n if (dailyWebhook) {\n const slack = new IncomingWebhook(dailyWebhook);\n await slack.send(text);\n } else {\n await email({ subject: `Family brief ${today}`, text });\n }\n\n const mealsWebhook = Deno.env.get(\"SLACK_WEBHOOK_MEALS\");\n if (mealsWebhook) {\n const tag = tonight.source === \"standing\"\n ? \" _(vaste routine — elke 2 weken)_\"\n : tonight.source === \"suggested\"\n ? \" _(voorstel — `meal: anders` voor ander idee)_\"\n : \"\";\n const slack = new IncomingWebhook(mealsWebhook);\n await slack.send(`🍽 *Vanavond:* ${tonight.dish}${tag}`);\n }\n}\n",[],[98],"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}",[],[108],["D",1780769696406],[119,120,121],[19],{"_36":67,"_13":68,"_39":69,"_41":42,"_43":44,"_45":70,"_47":48,"_49":128,"_17":72,"_52":53,"_54":73,"_56":57,"_58":-5,"_94":129,"_18":130},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":63,"_47":48,"_49":125,"_17":51,"_52":53,"_54":65,"_56":57,"_58":-5,"_94":126,"_18":127},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":122,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_94":123,"_18":124},["D",1780775710344],[],[19,38],["D",1780777515619],[],[19,61],["D",1780777510355],[],[19,68],"02674820-082a-4a5a-8c34-33784c8578e3","scripts","b3ce88ed-427c-4cb5-8ae3-8ce7a75bdc3f",45,["D",1780774564186],[],[132],"4bfef0de-e74e-47c0-ba37-39d09b0a8ffe",["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=1789538399&sig=97d2792c231a9412b9b9646df2dc2845f366fbcb53f39181dff1c2fc8f4891ae","userId","08b6ee43-68da-4bf2-918a-58fd79608932","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","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",{"_11":12,"_195":190},"org",{"_11":12,"_189":190,"_191":190,"_149":150,"_192":193,"_194":57},"branch",{"_17":89,"_13":16,"_36":44,"_181":138,"_182":-5,"_183":-5,"_184":-5,"_185":-5,"_186":-5,"_187":14,"_188":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":138,"_13":14,"_49":257,"_140":-5,"_141":57,"_142":143,"_144":143,"_145":146,"_147":148,"_149":150,"_151":88,"_152":48,"_153":-5,"_154":-5,"_155":78,"_156":157,"_158":159,"_160":161,"_162":258,"_164":-5,"_165":166,"_167":166,"_168":169,"_170":169,"_171":169,"_172":166,"_173":166,"_174":259,"_176":260,"_178":261,"_180":57},[233,234,238,239,240],"files",[233,234,235,236,237,238,239,240],"counts",{"_222":78,"_223":224,"_225":78,"_32":226,"_227":228},[216,217,218],{"_36":75,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":76,"_47":48,"_49":77,"_17":78,"_52":79,"_54":-5,"_56":57,"_58":-5,"_18":215},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],{"_36":67,"_13":68,"_39":69,"_41":42,"_43":44,"_45":70,"_47":48,"_49":71,"_17":72,"_52":53,"_54":73,"_56":57,"_58":-5,"_18":221},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":63,"_47":48,"_49":64,"_17":51,"_52":53,"_54":65,"_56":57,"_58":-5,"_18":220},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_18":219},[19,38],[19,61],[19,68],"pulls","branches",1,"forks",{"_229":231,"_232":78},"connections",{"_229":224,"_230":78},"count","unfilledCount",8,"emptyCount",{"_36":131,"_13":132,"_39":133,"_41":-5,"_43":44,"_45":134,"_47":48,"_49":135,"_17":78,"_52":79,"_54":-5,"_56":57,"_58":-5,"_94":255,"_18":256},{"_36":75,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":76,"_47":48,"_49":116,"_17":78,"_52":79,"_54":-5,"_56":57,"_58":-5,"_94":253,"_18":254},{"_36":67,"_13":68,"_39":69,"_41":42,"_43":44,"_45":70,"_47":48,"_49":128,"_17":72,"_52":53,"_54":73,"_56":57,"_58":-5,"_94":251,"_18":252},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":63,"_47":48,"_49":125,"_17":51,"_52":53,"_54":65,"_56":57,"_58":-5,"_94":249,"_18":250},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":122,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_94":247,"_18":248},{"_36":107,"_13":108,"_39":109,"_41":-5,"_43":44,"_45":110,"_47":48,"_49":111,"_17":112,"_52":103,"_54":113,"_56":57,"_58":-5,"_94":245,"_18":246},{"_36":97,"_13":98,"_39":99,"_41":-5,"_43":44,"_45":100,"_47":48,"_49":101,"_17":102,"_52":103,"_54":104,"_56":57,"_58":-5,"_94":243,"_18":244},{"_36":86,"_13":87,"_39":88,"_41":-5,"_43":44,"_45":89,"_47":48,"_49":90,"_17":91,"_52":92,"_54":93,"_56":57,"_58":-5,"_94":241,"_18":242},[],[87],[],[98],[],[108],[],[19,38],[],[19,61],[],[19,68],[235,236,237],[19],[],[132],["D",1780688454116],["D",1789502486629],{"_11":12,"_195":190},{"_11":12,"_189":190,"_191":190,"_149":150,"_192":193,"_194":57},{"_17":89,"_13":16,"_36":44,"_181":138,"_182":-5,"_183":-5,"_184":-5,"_185":-5,"_186":-5,"_187":14,"_188":12},"ctx",{"_174":-5,"_212":295,"_296":297,"_298":299,"_300":57,"_301":57,"_302":57,"_303":48,"_304":-5,"_305":-7,"_306":-7,"_307":78,"_308":57,"_309":57,"_310":-5,"_311":57,"_312":57,"_313":57,"_314":-5},"ENV",{"_266":267,"_268":269,"_270":16,"_271":272,"_273":274,"_275":276,"_277":278,"_279":280,"_281":282,"_283":284,"_285":286,"_287":288,"_289":290,"_291":292,"_293":294},"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"]