[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_239":240,"_241":242},"routes/_app.x.$handle.$name",{"_102":101,"_32":46,"_110":92,"_27":104,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_20":-5,"_121":-5,"_122":-5,"_123":25,"_124":125,"_126":61,"_127":-5,"_128":-5,"_129":130},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":56,"_18":57,"_58":59,"_60":61,"_62":-5,"_63":-5,"_64":65,"_66":67,"_68":69,"_70":71,"_72":73,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":85,"_86":87,"_88":89,"_90":25},"version",65,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","shared/meals.ts","latestPath","fileId","efff2222-61e0-11f1-9f49-1607ee4eb77e","name","meals.ts","fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\r\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\r\n\r\nconst TZ = \"Europe/Amsterdam\";\r\nconst NO_REPEAT_DAYS = 14;\r\n\r\ntype StandingMealDef = { dish: string; days: number; match: string[] };\r\n\r\nconst DEFAULT_STANDING_MEALS: StandingMealDef[] = [\r\n { dish: \"Burgers en friet\", days: 14, match: [\"burger\", \"friet\", \"fries\"] },\r\n { dish: \"Pizza\", days: 14, match: [\"pizza\"] },\r\n { dish: \"Lasagne\", days: 14, match: [\"lasagn\"] },\r\n];\r\n\r\nexport type Meal = {\r\n date: string;\r\n dish: string;\r\n source: \"manual\" | \"suggested\" | \"standing\";\r\n};\r\n\r\nexport function todayDate(): string {\r\n return new Date().toLocaleDateString(\"en-CA\", { timeZone: TZ });\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 async function ensureMealsSchema(): Promise {\r\n await sqlite.execute(\r\n \"CREATE TABLE IF NOT EXISTS meals (date TEXT PRIMARY KEY, dish TEXT NOT NULL, source TEXT DEFAULT 'manual')\",\r\n );\r\n try {\r\n await sqlite.execute(\"ALTER TABLE meals ADD COLUMN source TEXT DEFAULT 'manual'\");\r\n } catch {\r\n // column already exists\r\n }\r\n await sqlite.batch([\r\n \"CREATE TABLE IF NOT EXISTS config (key TEXT PRIMARY KEY, value TEXT)\",\r\n `INSERT OR IGNORE INTO config (key, value) VALUES ('standing_meal_dish', '${DEFAULT_STANDING_DISH}')`,\r\n `INSERT OR IGNORE INTO config (key, value) VALUES ('standing_meal_days', '${DEFAULT_STANDING_DAYS}')`,\r\n ]);\r\n}\r\n\r\nfunction daysBetween(earlier: string, later: string): number {\r\n const a = new Date(`${earlier}T12:00:00Z`).getTime();\r\n const b = new Date(`${later}T12:00:00Z`).getTime();\r\n return Math.floor((b - a) / 86_400_000);\r\n}\r\n\r\nfunction isStandingDish(dish: string): boolean {\r\n const d = dish.toLowerCase();\r\n return d.includes(\"burger\") || d.includes(\"friet\") || d.includes(\"fries\");\r\n}\r\n\r\nasync function getConfig(key: string): Promise {\r\n const row = await sqlite.execute({\r\n sql: \"SELECT value FROM config WHERE key = ?\",\r\n args: [key],\r\n });\r\n return (row.rows[0] as { value?: string } | undefined)?.value ?? null;\r\n}\r\n\r\nasync function getLastStandingMealDate(): Promise {\r\n await ensureMealsSchema();\r\n const result = await sqlite.execute(\r\n \"SELECT date, dish FROM meals ORDER BY date DESC\",\r\n );\r\n for (const row of result.rows as { date: string; dish: string }[]) {\r\n if (isStandingDish(row.dish)) return row.date;\r\n }\r\n return null;\r\n}\r\n\r\nasync function dueForStandingMeal(targetDate: string): Promise {\r\n const dish = (await getConfig(\"standing_meal_dish\")) ?? DEFAULT_STANDING_DISH;\r\n const interval = Number((await getConfig(\"standing_meal_days\")) ?? DEFAULT_STANDING_DAYS);\r\n const last = await getLastStandingMealDate();\r\n if (!last) return null;\r\n if (daysBetween(last, targetDate) >= interval) return dish;\r\n return null;\r\n}\r\n\r\nasync function maybeStandingMeal(date: string): Promise {\r\n const dish = await dueForStandingMeal(date);\r\n if (!dish) return null;\r\n await saveMeal(date, dish, \"standing\");\r\n return { date, dish, source: \"standing\" };\r\n}\r\n\r\nexport async function saveMeal(\r\n date: string,\r\n dish: string,\r\n source: Meal[\"source\"] = \"manual\",\r\n): Promise {\r\n await ensureMealsSchema();\r\n await sqlite.execute({\r\n sql: \"INSERT INTO meals (date, dish, source) VALUES (?, ?, ?) ON CONFLICT(date) DO UPDATE SET dish = excluded.dish, source = excluded.source\",\r\n args: [date, dish, source],\r\n });\r\n}\r\n\r\nexport async function getMealForDate(date: string): Promise {\r\n await ensureMealsSchema();\r\n const result = await sqlite.execute({\r\n sql: \"SELECT date, dish, source FROM meals WHERE date = ?\",\r\n args: [date],\r\n });\r\n const row = result.rows[0] as { date: string; dish: string; source?: string } | undefined;\r\n if (!row) return null;\r\n const source = row.source === \"suggested\" ? \"suggested\"\r\n : row.source === \"standing\" ? \"standing\"\r\n : \"manual\";\r\n return { date: row.date, dish: row.dish, source };\r\n}\r\n\r\nexport async function getRecentDishes(days = NO_REPEAT_DAYS): Promise {\r\n await ensureMealsSchema();\r\n const since = isoDate(addDays(new Date(), -days));\r\n const result = await sqlite.execute({\r\n sql: \"SELECT dish FROM meals WHERE date >= ? ORDER BY date DESC\",\r\n args: [since],\r\n });\r\n return (result.rows as { dish: string }[]).map((r) => r.dish);\r\n}\r\n\r\nexport async function listUpcomingMeals(limit = 7): Promise {\r\n await ensureMealsSchema();\r\n const today = todayDate();\r\n const result = await sqlite.execute({\r\n sql: \"SELECT date, dish, source FROM meals WHERE date >= ? ORDER BY date LIMIT ?\",\r\n args: [today, limit],\r\n });\r\n return (result.rows as { date: string; dish: string; source?: string }[]).map((row) => {\r\n const tag = row.source === \"suggested\" ? \" (voorstel)\"\r\n : row.source === \"standing\" ? \" (vaste routine)\"\r\n : \"\";\r\n return `${row.date} — ${row.dish}${tag}`;\r\n });\r\n}\r\n\r\nexport function parseMealDate(rest: string): { date: string; rest: string } {\r\n let date: string | null = null;\r\n let text = rest.trim();\r\n\r\n const isoMatch = text.match(/\\b(\\d{4}-\\d{2}-\\d{2})\\b/);\r\n if (isoMatch) {\r\n date = isoMatch[1];\r\n text = text.replace(isoMatch[0], \" \").trim();\r\n }\r\n\r\n if (/\\b(today|vandaag|vanavond)\\b/i.test(text)) {\r\n date = todayDate();\r\n text = text.replace(/\\b(today|vandaag|vanavond)\\b/gi, \" \").trim();\r\n }\r\n if (/\\b(tomorrow|morgen)\\b/i.test(text)) {\r\n date = isoDate(addDays(new Date(), 1));\r\n text = text.replace(/\\b(tomorrow|morgen)\\b/gi, \" \").trim();\r\n }\r\n\r\n if (!date) {\r\n const lower = text.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 text = text.replace(re, \" \").trim();\r\n break;\r\n }\r\n }\r\n }\r\n\r\n if (!date) date = todayDate();\r\n return { date, rest: text.replace(/\\s+/g, \" \").trim() };\r\n}\r\n\r\nexport function parseMealCommand(text: string): { date: string; dish: string } | \"list\" | \"anders\" | null {\r\n const match = text.trim().match(/^(?:meal|eten|diner):\\s*(.*)$/i);\r\n if (!match) return null;\r\n\r\n const body = match[1].trim();\r\n if (/^list$/i.test(body)) return \"list\";\r\n if (/^(anders|suggest|voorstel)$/i.test(body)) return \"anders\";\r\n\r\n if (!body) return null;\r\n\r\n const { date, rest } = parseMealDate(body);\r\n if (!rest) return null;\r\n return { date, dish: rest };\r\n}\r\n\r\nexport async function suggestMeal(recentDishes: string[]): Promise {\r\n const openai = new OpenAI();\r\n const avoid = recentDishes.length\r\n ? recentDishes.join(\", \")\r\n : \"none yet\";\r\n\r\n const completion = await openai.chat.completions.create({\r\n model: \"gpt-4o-mini\",\r\n messages: [{\r\n role: \"user\",\r\n content: `Suggest ONE dinner for a Dutch family (2 parents, teens Milan 14 and Eva 13).\r\n\r\nRecent meals — do NOT repeat these or close variants (same cuisine/style): ${avoid}\r\n\r\nRules:\r\n- Practical home dinner for a weekday\r\n- Kid-friendly, normal Dutch/European family food\r\n- Do NOT suggest burgers, fries, or fast-food (family already has burgers & friet every 2 weeks on a schedule)\r\n- One short dish name only (e.g. \"Pasta pesto\", \"Stamppot boerenkool\", \"Ovenschotel\")\r\n- No explanation, no quotes, no bullet points`,\r\n }],\r\n });\r\n\r\n const dish = completion.choices[0].message.content?.trim() ?? \"Pasta\";\r\n return dish.replace(/^[\"']|[\"']$/g, \"\");\r\n}\r\n\r\nexport async function planMealForDate(\r\n date: string,\r\n opts?: { forceAi?: boolean },\r\n): Promise {\r\n if (!opts?.forceAi) {\r\n const standing = await maybeStandingMeal(date);\r\n if (standing) return standing;\r\n }\r\n const recent = await getRecentDishes(NO_REPEAT_DAYS);\r\n const dish = await suggestMeal(recent);\r\n await saveMeal(date, dish, \"suggested\");\r\n return { date, dish, source: \"suggested\" };\r\n}\r\n\r\n/** AI-only suggestion (skips standing meal rotation). */\r\nexport async function suggestMealForDate(date: string): Promise {\r\n return await planMealForDate(date, { forceAi: true });\r\n}\r\n\r\n/** Fill today's meal if nothing is planned yet (standing rotation or AI). */\r\nexport async function ensureTodaysSuggestion(): Promise {\r\n const today = todayDate();\r\n const existing = await getMealForDate(today);\r\n if (existing) return existing;\r\n return await planMealForDate(today);\r\n}\r\n","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\r\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\r\n\r\nconst TZ = \"Europe/Amsterdam\";\r\nconst NO_REPEAT_DAYS = 14;\r\n\r\ntype StandingMealDef = { dish: string; days: number; match: string[] };\r\n\r\nconst DEFAULT_STANDING_MEALS: StandingMealDef[] = [\r\n { dish: \"Burgers en friet\", days: 14, match: [\"burger\", \"friet\", \"fries\"] },\r\n { dish: \"Pizza\", days: 14, match: [\"pizza\"] },\r\n { dish: \"Lasagne\", days: 14, match: [\"lasagn\"] },\r\n];\r\n\r\nexport type Meal = {\r\n date: string;\r\n dish: string;\r\n source: \"manual\" | \"suggested\" | \"standing\";\r\n};\r\n\r\nexport function todayDate(): string {\r\n return new Date().toLocaleDateString(\"en-CA\", { timeZone: TZ });\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 async function ensureMealsSchema(): Promise {\r\n await sqlite.execute(\r\n \"CREATE TABLE IF NOT EXISTS meals (date TEXT PRIMARY KEY, dish TEXT NOT NULL, source TEXT DEFAULT 'manual')\",\r\n );\r\n try {\r\n await sqlite.execute(\"ALTER TABLE meals ADD COLUMN source TEXT DEFAULT 'manual'\");\r\n } catch {\r\n // column already exists\r\n }\r\n await sqlite.batch([\r\n \"CREATE TABLE IF NOT EXISTS config (key TEXT PRIMARY KEY, value TEXT)\",\r\n `INSERT OR IGNORE INTO config (key, value) VALUES ('standing_meals', '${JSON.stringify(DEFAULT_STANDING_MEALS)}')`,\r\n ]);\r\n}\r\n\r\nfunction daysBetween(earlier: string, later: string): number {\r\n const a = new Date(`${earlier}T12:00:00Z`).getTime();\r\n const b = new Date(`${later}T12:00:00Z`).getTime();\r\n return Math.floor((b - a) / 86_400_000);\r\n}\r\n\r\nfunction isStandingDish(dish: string): boolean {\r\n const d = dish.toLowerCase();\r\n return d.includes(\"burger\") || d.includes(\"friet\") || d.includes(\"fries\");\r\n}\r\n\r\nasync function getConfig(key: string): Promise {\r\n const row = await sqlite.execute({\r\n sql: \"SELECT value FROM config WHERE key = ?\",\r\n args: [key],\r\n });\r\n return (row.rows[0] as { value?: string } | undefined)?.value ?? null;\r\n}\r\n\r\nasync function getLastStandingMealDate(): Promise {\r\n await ensureMealsSchema();\r\n const result = await sqlite.execute(\r\n \"SELECT date, dish FROM meals ORDER BY date DESC\",\r\n );\r\n for (const row of result.rows as { date: string; dish: string }[]) {\r\n if (isStandingDish(row.dish)) return row.date;\r\n }\r\n return null;\r\n}\r\n\r\nasync function dueForStandingMeal(targetDate: string): Promise {\r\n const dish = (await getConfig(\"standing_meal_dish\")) ?? DEFAULT_STANDING_DISH;\r\n const interval = Number((await getConfig(\"standing_meal_days\")) ?? DEFAULT_STANDING_DAYS);\r\n const last = await getLastStandingMealDate();\r\n if (!last) return null;\r\n if (daysBetween(last, targetDate) >= interval) return dish;\r\n return null;\r\n}\r\n\r\nasync function maybeStandingMeal(date: string): Promise {\r\n const dish = await dueForStandingMeal(date);\r\n if (!dish) return null;\r\n await saveMeal(date, dish, \"standing\");\r\n return { date, dish, source: \"standing\" };\r\n}\r\n\r\nexport async function saveMeal(\r\n date: string,\r\n dish: string,\r\n source: Meal[\"source\"] = \"manual\",\r\n): Promise {\r\n await ensureMealsSchema();\r\n await sqlite.execute({\r\n sql: \"INSERT INTO meals (date, dish, source) VALUES (?, ?, ?) ON CONFLICT(date) DO UPDATE SET dish = excluded.dish, source = excluded.source\",\r\n args: [date, dish, source],\r\n });\r\n}\r\n\r\nexport async function getMealForDate(date: string): Promise {\r\n await ensureMealsSchema();\r\n const result = await sqlite.execute({\r\n sql: \"SELECT date, dish, source FROM meals WHERE date = ?\",\r\n args: [date],\r\n });\r\n const row = result.rows[0] as { date: string; dish: string; source?: string } | undefined;\r\n if (!row) return null;\r\n const source = row.source === \"suggested\" ? \"suggested\"\r\n : row.source === \"standing\" ? \"standing\"\r\n : \"manual\";\r\n return { date: row.date, dish: row.dish, source };\r\n}\r\n\r\nexport async function getRecentDishes(days = NO_REPEAT_DAYS): Promise {\r\n await ensureMealsSchema();\r\n const since = isoDate(addDays(new Date(), -days));\r\n const result = await sqlite.execute({\r\n sql: \"SELECT dish FROM meals WHERE date >= ? ORDER BY date DESC\",\r\n args: [since],\r\n });\r\n return (result.rows as { dish: string }[]).map((r) => r.dish);\r\n}\r\n\r\nexport async function listUpcomingMeals(limit = 7): Promise {\r\n await ensureMealsSchema();\r\n const today = todayDate();\r\n const result = await sqlite.execute({\r\n sql: \"SELECT date, dish, source FROM meals WHERE date >= ? ORDER BY date LIMIT ?\",\r\n args: [today, limit],\r\n });\r\n return (result.rows as { date: string; dish: string; source?: string }[]).map((row) => {\r\n const tag = row.source === \"suggested\" ? \" (voorstel)\"\r\n : row.source === \"standing\" ? \" (vaste routine)\"\r\n : \"\";\r\n return `${row.date} — ${row.dish}${tag}`;\r\n });\r\n}\r\n\r\nexport function parseMealDate(rest: string): { date: string; rest: string } {\r\n let date: string | null = null;\r\n let text = rest.trim();\r\n\r\n const isoMatch = text.match(/\\b(\\d{4}-\\d{2}-\\d{2})\\b/);\r\n if (isoMatch) {\r\n date = isoMatch[1];\r\n text = text.replace(isoMatch[0], \" \").trim();\r\n }\r\n\r\n if (/\\b(today|vandaag|vanavond)\\b/i.test(text)) {\r\n date = todayDate();\r\n text = text.replace(/\\b(today|vandaag|vanavond)\\b/gi, \" \").trim();\r\n }\r\n if (/\\b(tomorrow|morgen)\\b/i.test(text)) {\r\n date = isoDate(addDays(new Date(), 1));\r\n text = text.replace(/\\b(tomorrow|morgen)\\b/gi, \" \").trim();\r\n }\r\n\r\n if (!date) {\r\n const lower = text.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 text = text.replace(re, \" \").trim();\r\n break;\r\n }\r\n }\r\n }\r\n\r\n if (!date) date = todayDate();\r\n return { date, rest: text.replace(/\\s+/g, \" \").trim() };\r\n}\r\n\r\nexport function parseMealCommand(text: string): { date: string; dish: string } | \"list\" | \"anders\" | null {\r\n const match = text.trim().match(/^(?:meal|eten|diner):\\s*(.*)$/i);\r\n if (!match) return null;\r\n\r\n const body = match[1].trim();\r\n if (/^list$/i.test(body)) return \"list\";\r\n if (/^(anders|suggest|voorstel)$/i.test(body)) return \"anders\";\r\n\r\n if (!body) return null;\r\n\r\n const { date, rest } = parseMealDate(body);\r\n if (!rest) return null;\r\n return { date, dish: rest };\r\n}\r\n\r\nexport async function suggestMeal(recentDishes: string[]): Promise {\r\n const openai = new OpenAI();\r\n const avoid = recentDishes.length\r\n ? recentDishes.join(\", \")\r\n : \"none yet\";\r\n\r\n const completion = await openai.chat.completions.create({\r\n model: \"gpt-4o-mini\",\r\n messages: [{\r\n role: \"user\",\r\n content: `Suggest ONE dinner for a Dutch family (2 parents, teens Milan 14 and Eva 13).\r\n\r\nRecent meals — do NOT repeat these or close variants (same cuisine/style): ${avoid}\r\n\r\nRules:\r\n- Practical home dinner for a weekday\r\n- Kid-friendly, normal Dutch/European family food\r\n- Do NOT suggest burgers, fries, or fast-food (family already has burgers & friet every 2 weeks on a schedule)\r\n- One short dish name only (e.g. \"Pasta pesto\", \"Stamppot boerenkool\", \"Ovenschotel\")\r\n- No explanation, no quotes, no bullet points`,\r\n }],\r\n });\r\n\r\n const dish = completion.choices[0].message.content?.trim() ?? \"Pasta\";\r\n return dish.replace(/^[\"']|[\"']$/g, \"\");\r\n}\r\n\r\nexport async function planMealForDate(\r\n date: string,\r\n opts?: { forceAi?: boolean },\r\n): Promise {\r\n if (!opts?.forceAi) {\r\n const standing = await maybeStandingMeal(date);\r\n if (standing) return standing;\r\n }\r\n const recent = await getRecentDishes(NO_REPEAT_DAYS);\r\n const dish = await suggestMeal(recent);\r\n await saveMeal(date, dish, \"suggested\");\r\n return { date, dish, source: \"suggested\" };\r\n}\r\n\r\n/** AI-only suggestion (skips standing meal rotation). */\r\nexport async function suggestMealForDate(date: string): Promise {\r\n return await planMealForDate(date, { forceAi: true });\r\n}\r\n\r\n/** Fill today's meal if nothing is planned yet (standing rotation or AI). */\r\nexport async function ensureTodaysSuggestion(): Promise {\r\n const today = todayDate();\r\n const existing = await getMealForDate(today);\r\n if (existing) return existing;\r\n return await planMealForDate(today);\r\n}\r\n","createdAt",["D",1780775618406],"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=1789534799&sig=26bfa1f4d2ddf7b226711212d3a79c436b5a278d75ca2748bccd2ac5fc0888f4","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",{"_102":101,"_109":104},"org",{"_102":101,"_103":104,"_105":104,"_18":57,"_106":107,"_108":25},"branch",{"_13":91,"_32":92,"_44":43,"_93":45,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":46,"_100":101},"isOwned",82,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Robbertd","handle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_44":45,"_32":46,"_39":234,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":56,"_18":57,"_58":59,"_60":61,"_62":-5,"_63":-5,"_64":65,"_66":67,"_68":69,"_70":71,"_72":235,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":236,"_86":237,"_88":238,"_90":25},"tree",[189,190,194,195,196],"files",[189,190,191,192,193,194,195,196],"counts",{"_177":65,"_178":179,"_180":65,"_181":182,"_183":184},"contents",[131,132,133,134,135],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":171,"_32":172,"_30":173,"_138":-5,"_42":43,"_41":174,"_140":61,"_39":175,"_13":65,"_34":169,"_36":-5,"_24":25,"_145":-5,"_27":176},{"_44":164,"_32":165,"_30":166,"_138":-5,"_42":43,"_41":167,"_140":61,"_39":168,"_13":65,"_34":169,"_36":-5,"_24":25,"_145":-5,"_27":170},{"_44":156,"_32":157,"_30":158,"_138":-5,"_42":43,"_41":159,"_140":61,"_39":160,"_13":161,"_34":153,"_36":162,"_24":25,"_145":-5,"_27":163},{"_44":147,"_32":148,"_30":149,"_138":-5,"_42":43,"_41":150,"_140":25,"_39":151,"_13":152,"_34":153,"_36":154,"_24":25,"_145":-5,"_27":155},{"_44":136,"_32":137,"_30":59,"_138":-5,"_42":43,"_41":139,"_140":25,"_39":141,"_13":142,"_34":143,"_36":144,"_24":25,"_145":-5,"_27":146},"fe0a5392-cf15-4540-b1e9-d88f531e9d1a","slack-bot.ts","parentId",57,"latest",["D",1780775442578],9,"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 =\n \"Family butler:\\n• `add: morgen 15:00 Eva riding` — appointment\\n• `list:` — appointments\\n• `meal: pizza` — log/plan dinner\\n• `meal: morgen stamppot`\\n• `meal: list`\\n• `meal: anders` — new AI suggestion for today\";\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 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.time ? `${appt.date} ${appt.time}` : 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","label",[137],"7f8566ff-b630-41cc-b8ef-0b0e6cc7116f","morningbriefing.ts","0a1e7f7a-61a7-11f1-9a9e-1607ee4eb77e",63,["D",1780775498001],14,"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 burgers & friet 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: burgers 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",[148],"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}",[157],"e4c0a743-f6ef-45a4-83eb-750083010cc3","shared","66f46181-8d05-4c65-bcca-cd48b2cabb6e",30,["D",1780769696406],"directory",[165],"02674820-082a-4a5a-8c34-33784c8578e3","scripts","b3ce88ed-427c-4cb5-8ae3-8ce7a75bdc3f",45,["D",1780774564186],[172],"pulls","branches",1,"forks","envVars",{"_185":187,"_188":65},"connections",{"_185":179,"_186":65},"count","unfilledCount",8,"emptyCount",{"_44":171,"_32":172,"_30":173,"_138":-5,"_42":43,"_41":174,"_140":61,"_39":231,"_13":65,"_34":169,"_36":-5,"_24":25,"_145":-5,"_198":232,"_27":233},{"_44":164,"_32":165,"_30":166,"_138":-5,"_42":43,"_41":167,"_140":61,"_39":228,"_13":65,"_34":169,"_36":-5,"_24":25,"_145":-5,"_198":229,"_27":230},{"_44":220,"_32":221,"_30":222,"_138":166,"_42":43,"_41":223,"_140":25,"_39":224,"_13":179,"_34":35,"_36":225,"_24":25,"_145":-5,"_198":226,"_27":227},{"_44":212,"_32":213,"_30":214,"_138":166,"_42":43,"_41":215,"_140":25,"_39":216,"_13":161,"_34":35,"_36":217,"_24":25,"_145":-5,"_198":218,"_27":219},{"_44":207,"_32":33,"_30":31,"_138":166,"_42":43,"_41":14,"_140":25,"_39":208,"_13":209,"_34":35,"_36":38,"_24":25,"_145":-5,"_198":210,"_27":211},{"_44":156,"_32":157,"_30":158,"_138":-5,"_42":43,"_41":159,"_140":61,"_39":204,"_13":161,"_34":153,"_36":162,"_24":25,"_145":-5,"_198":205,"_27":206},{"_44":147,"_32":148,"_30":149,"_138":-5,"_42":43,"_41":150,"_140":25,"_39":201,"_13":152,"_34":153,"_36":154,"_24":25,"_145":-5,"_198":202,"_27":203},{"_44":136,"_32":137,"_30":59,"_138":-5,"_42":43,"_41":139,"_140":25,"_39":197,"_13":142,"_34":143,"_36":144,"_24":25,"_145":-5,"_198":199,"_27":200},["D",1780775442578],"children",[],[137],["D",1780775498001],[],[148],["D",1780750420287],[],[157],"5fc5213f-3a41-4505-888f-9d05953b1eba",["D",1780775618406],3,[],[165,33],"c5838472-5ab6-4073-9812-bbaacae278e8","icloud-calendar.ts","a6236b76-61dc-11f1-94ba-1607ee4eb77e",53,["D",1780775080000],"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 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 startLine = `DTSTART;VALUE=DATE:${icalDate(appt.date)}`;\r\n endLine = `DTEND;VALUE=DATE:${icalDate(nextDayDate(appt.date))}`;\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",[],[165,213],"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",[],[165,221],["D",1780769696406],[191,192,193],[165],["D",1780774564186],[],[172],["D",1780688454116],["D",1789502486629],{"_102":101,"_109":104},{"_102":101,"_103":104,"_105":104,"_18":57,"_106":107,"_108":25},{"_13":91,"_32":92,"_44":43,"_93":45,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":46,"_100":101},"ctx",{"_84":-5,"_128":272,"_273":274,"_275":276,"_277":25,"_278":25,"_279":25,"_280":61,"_281":-5,"_282":-7,"_283":-7,"_284":65,"_285":25,"_286":25,"_287":-5,"_288":25,"_289":25,"_290":25,"_291":-5},"ENV",{"_243":244,"_245":246,"_247":92,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257,"_258":259,"_260":261,"_262":263,"_264":265,"_266":267,"_268":269,"_270":271},"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 · v65