\n \n

{title}

\n Range: {monthStart} → {monthEnd} {includePartialWeeks ? \"(partial weeks included)\" : \"(full weeks only)\"}\n

\n {/* Month navigation is query-string driven for shareable URLs. */}\n \n

\n\n {/* Main content: two summary cards */}\n

Blood Sugar

\n \n \n \n \n \n \n \n

\n {(bloodSugar.badges.length ? bloodSugar.badges : [\"No badges yet\"]).map((badge) => (\n \n {badge}\n \n ))}\n

\n\n

Food Log

\n \n \n \n \n \n \n \n

\n Macro averages (per entry)\n {Object.keys(food.macroSummary).length === 0 &&

No macro data yet.

}\n {Object.entries(food.macroSummary).map(([key, value]) => (\n

\n {key}\n {value.avg}\n

\n ))}\n

\n\n

\n Praise Cage mode: keep logging, keep winning. Data from weekly rollups stored in Val Town SQLite.\n

\n \n \n \n );\n}\n\nfunction Stat(props: { label: string; value: string | number }) {\n return (\n

\n {props.label}\n {props.value}\n

\n );\n}\n\n// Build the month dropdown from the first data year through the current month.\nfunction buildMonthOptions(startYear: number, now: Date): string[] {\n const options: string[] = [];\n const start = new Date(Date.UTC(startYear, 0, 1));\n const end = new Date(Date.UTC(now.getUTCFullYear(), now.getUTCMonth(), 1));\n if (end < start) {\n return [formatMonth(start)];\n }\n for (let cursor = start; cursor <= end; cursor = addMonths(cursor, 1)) {\n options.push(formatMonth(cursor));\n }\n return options;\n}\n\n// Use the query string if valid, otherwise default to last month.\nfunction resolveSelectedMonth(monthParam: string | null, now: Date, startYear: number): string {\n const minMonth = `${startYear}-01`;\n if (monthParam && /^\\d{4}-\\d{2}$/.test(monthParam)) {\n return monthParam < minMonth ? minMonth : monthParam;\n }\n const year = now.getUTCFullYear();\n const month = now.getUTCMonth();\n const previous = new Date(Date.UTC(year, month - 1, 1));\n const fallback = formatMonth(previous);\n return fallback < minMonth ? minMonth : fallback;\n}\n\n// Format a Date as YYYY-MM for query params and dropdown values.\nfunction formatMonth(date: Date): string {\n const year = date.getUTCFullYear();\n const month = String(date.getUTCMonth() + 1).padStart(2, \"0\");\n return `${year}-${month}`;\n}\n\n// Date helper for iterating month-by-month.\nfunction addMonths(date: Date, amount: number): Date {\n return new Date(Date.UTC(date.getUTCFullYear(), date.getUTCMonth() + amount, 1));\n}\n",[],[199,389],["D",1768499628695],[235,236],[199],"8f078c0a-f7ac-11f0-9c14-42dde27851f2","food_report.cron.tsx","f851115a-f233-11f0-a807-42dde27851f2",417,["D",1769098095429],38,"interval","import { getWeeklyRange } from \"../shared/date.ts\";\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nimport { fetchNotionPages, type NotionPage, updateNotionPage } from \"../shared/notion.ts\";\nimport { fetchFoodMacros, getFatSecretConfig, requestAccessToken, sumIfComplete } from \"../shared/fatsecret.ts\";\nimport {\n buildNutritionProperties,\n buildFoodRollup,\n type Entry,\n type MacroKey,\n parseEntry,\n PROPERTY_NAMES,\n roundNumber,\n safeParseJson,\n shouldEnrich,\n} from \"../shared/food_enrich.ts\";\nimport { initRollupSchema, upsertWeeklyRollup } from \"../storage/rollups.ts\";\n\ntype NotionConfig = {\n token: string;\n databaseId: string;\n};\n\nexport default async function () {\n // Resolve configs and hydrate external clients first to fail fast.\n const notionConfig = getNotionConfig();\n if (!notionConfig) {\n return new Response(\"Missing Notion secrets.\", { status: 500 });\n }\n const openai = new OpenAI();\n const fatSecretConfig = getFatSecretConfig();\n const fatSecretToken = fatSecretConfig ? await requestAccessToken(fatSecretConfig) : null;\n\n const { start, end } = getWeeklyRange();\n const entries = await fetchEntries(start, end, notionConfig);\n console.log(`Food entries ${start} to ${end}:`, entries);\n\n let enriched = 0;\n for (const entry of entries) {\n // Only enrich entries missing core macros to avoid overwriting manual edits.\n if (!shouldEnrich(entry)) continue;\n if (!entry.food || entry.food === \"Unknown\") continue;\n const enrichment = await fetchNutrition(entry.food, openai, fatSecretConfig, fatSecretToken);\n if (!enrichment) continue;\n const properties = buildNutritionProperties(enrichment.macros);\n if (!Object.keys(properties).length) continue;\n console.log(\"Enriching entry\", {\n pageId: entry.pageId,\n food: entry.food,\n loggedAt: entry.loggedAt,\n macros: enrichment.macros,\n });\n console.log(\"Notion update properties\", {\n pageId: entry.pageId,\n properties,\n });\n await updateNotionPage(entry.pageId, notionConfig.token, properties);\n entry.macros = { ...entry.macros, ...enrichment.macros };\n enriched += 1;\n }\n\n await initRollupSchema();\n const rollup = buildFoodRollup(entries, start, end);\n await upsertWeeklyRollup(rollup);\n\n return new Response(`Weekly food entries logged. Enriched ${enriched}.`, { status: 200 });\n}\n\nfunction getNotionConfig(): NotionConfig | null {\n const token = Deno.env.get(\"NOTION_TOKEN\");\n const databaseId = Deno.env.get(\"NOTION_FOOD_DB_ID\");\n if (!token || !databaseId) return null;\n return { token, databaseId };\n}\n\nasync function fetchEntries(start: string, end: string, config: NotionConfig): Promise {\n // Pull just the last-week window to keep the Notion query fast.\n const pages = await fetchNotionPages(config.databaseId, config.token, (cursor) => ({\n filter: {\n and: [\n { property: PROPERTY_NAMES.loggedAt, date: { on_or_after: start } },\n { property: PROPERTY_NAMES.loggedAt, date: { on_or_before: end } },\n ],\n },\n sorts: [{ property: PROPERTY_NAMES.loggedAt, direction: \"ascending\" }],\n ...(cursor ? { start_cursor: cursor } : {}),\n }));\n\n const entries: Entry[] = [];\n for (const page of pages) {\n const entry = parseEntry(page);\n if (entry) entries.push(entry);\n }\n\n return entries;\n}\n\nasync function fetchNutrition(\n foodName: string,\n openai: OpenAI,\n config: ReturnType,\n token: string | null,\n): Promise<{\n macros: Partial>;\n} | null> {\n if (!config || !token) return null;\n const items = await parseFoodItems(foodName, openai);\n const macros = await fetchFatSecretTotals(items, foodName, token, config);\n if (!macros || !Object.keys(macros).length) return null;\n return { macros };\n}\n\ntype FoodItem = {\n name: string;\n servings: number;\n};\n\nasync function parseFoodItems(foodName: string, openai: OpenAI): Promise {\n // Keep the OpenAI request compact to control costs.\n const completion = await openai.chat.completions.create({\n model: \"gpt-5-nano\",\n messages: [\n {\n role: \"system\",\n content:\n \"You normalize food log entries. \" +\n \"Return a single JSON object: {\\\"items\\\":[{\\\"name\\\":\\\"...\\\",\\\"servings\\\":1}]}. \" +\n \"Correct spelling, keep names short, and split sides when phrased as \\\"with\\\" or \\\"and\\\". \" +\n \"Infer servings for a regular meal: default to 1 per item; if explicit quantities are given, \" +\n \"convert to a servings multiplier. Keep brands and key ingredients. No extra text.\",\n },\n {\n role: \"user\",\n content: `Food entry: \"${foodName}\".`,\n },\n ],\n max_tokens: 160,\n });\n\n const text = completion.choices[0]?.message?.content?.trim();\n if (!text) return [{ name: foodName, servings: 1 }];\n const parsed = safeParseJson(text);\n if (!parsed || typeof parsed !== \"object\") return [{ name: foodName, servings: 1 }];\n const items = (parsed as Record).items;\n if (!Array.isArray(items)) return [{ name: foodName, servings: 1 }];\n const cleaned = items\n .map((item) => coerceFoodItem(item))\n .filter((item): item is FoodItem => !!item)\n .map((item) => ({\n name: item.name.trim(),\n servings: sanitizeServings(item.servings),\n }))\n .filter((item) => item.name.length > 0);\n return cleaned.length ? cleaned : [{ name: foodName, servings: 1 }];\n}\n\nasync function fetchFatSecretTotals(\n items: FoodItem[],\n original: string,\n token: string,\n config: ReturnType,\n): Promise> | null> {\n if (!config) return null;\n const components: Array> | null> = [];\n for (const item of items) {\n const macros = await fetchFoodMacros(item.name, token);\n components.push(macros ? scaleMacros(macros, item.servings) : null);\n }\n\n if (components.length === 1 && components[0]) return components[0];\n const totals = sumComponentMacros(components);\n if (totals && hasCoreMacros(totals)) return totals;\n const fallback = await fetchFoodMacros(original, token);\n return fallback ?? null;\n}\n\nconst CORE_MACROS: MacroKey[] = [\"calories\", \"protein\", \"carbs\", \"fat\"];\nconst SUM_MACROS: MacroKey[] = [\"calories\", \"protein\", \"carbs\", \"fat\", \"fiber\", \"sugar\", \"sodium\"];\n\nfunction hasCoreMacros(macros: Partial>): boolean {\n return CORE_MACROS.every((key) => typeof macros[key] === \"number\");\n}\n\nfunction sumComponentMacros(\n components: Array> | null>,\n): Partial> | null {\n if (!components.length) return null;\n if (components.some((component) => !component)) return null;\n const entries = components as Array>>;\n const totals: Partial> = {};\n for (const key of SUM_MACROS) {\n const value = sumIfComplete(entries.map((entry) => entry[key]));\n if (value !== undefined) totals[key] = value;\n }\n return totals;\n}\n\nfunction coerceFoodItem(item: unknown): FoodItem | null {\n if (typeof item === \"string\") {\n return { name: item, servings: 1 };\n }\n if (!item || typeof item !== \"object\") return null;\n const record = item as Record;\n const name = record.name;\n if (typeof name !== \"string\") return null;\n const servings = record.servings;\n if (typeof servings === \"number\" && Number.isFinite(servings)) {\n return { name, servings };\n }\n if (typeof servings === \"string\") {\n const parsed = Number(servings.trim());\n if (Number.isFinite(parsed)) return { name, servings: parsed };\n }\n return { name, servings: 1 };\n}\n\nfunction sanitizeServings(value: number): number {\n if (!Number.isFinite(value) || value <= 0) return 1;\n return roundNumber(value);\n}\n\nfunction scaleMacros(\n macros: Partial>,\n servings: number,\n): Partial> {\n const scaled: Partial> = {};\n for (const [key, value] of Object.entries(macros) as Array<[MacroKey, number]>) {\n if (typeof value !== \"number\") continue;\n scaled[key] = roundNumber(value * servings);\n }\n return scaled;\n}\n",[],[205,401],"8f02a5d2-f7ac-11f0-a96e-42dde27851f2","blood_sugar_report.cron.tsx","905c839c-f0bf-11f0-b356-42dde27851f2",416,["D",1769098095417],58,"import { email } from \"https://esm.town/v/std/email\";\nimport { getWeeklyRange, listDateRange } from \"../shared/date.ts\";\nimport { fetchNotionPages } from \"../shared/notion.ts\";\nimport { initRollupSchema, upsertWeeklyRollup } from \"../storage/rollups.ts\";\nimport {\n buildEncouragement,\n buildBloodSugarRollup,\n formatGroupedEntryLine,\n groupEntriesByDate,\n parseEntry,\n type GroupedEntries,\n type BloodSugarNotionPage,\n type Entry,\n hasPerfectWeekStreak,\n} from \"../shared/blood_sugar_logic.ts\";\n\nexport default async function handler(): Promise {\n const notionConfig = getNotionConfig();\n const emailConfig = getEmailConfig();\n\n if (!notionConfig) {\n return new Response(\"Missing required secrets.\", { status: 500 });\n }\n\n // Use a fixed 7-day range ending today (UTC) for weekly rollups.\n const { start, end } = getWeeklyRange();\n console.log(`Weekly range: ${start} to ${end}`);\n const entries = await fetchEntries(start, end, notionConfig);\n console.log(`Fetched ${entries.length} entries from Notion`);\n const report = buildReport(entries, start, end);\n console.log(\"Report subject:\", report.subject);\n console.log(\"Sending email to Val Town account owner (free tier default).\");\n\n // Build the payload to match Val Town's std/email expectations.\n const emailPayload = {\n subject: report.subject,\n text: report.text,\n html: report.html,\n ...(buildFrom(emailConfig?.fromEmail, emailConfig?.fromName) ?? {}),\n ...(emailConfig?.replyTo ? { replyTo: emailConfig.replyTo } : {}),\n };\n\n await email(emailPayload);\n console.log(\"Email sent.\");\n\n await initRollupSchema();\n await upsertWeeklyRollup(report.rollup);\n\n return new Response(\"Weekly report sent.\", { status: 200 });\n}\n\nfunction buildFrom(email?: string | null, name?: string | null) {\n if (!email) return null;\n return {\n from: name ? { email, name } : { email },\n };\n}\n\ntype NotionConfig = {\n token: string;\n databaseId: string;\n};\n\ntype EmailConfig = {\n fromEmail?: string;\n fromName?: string;\n replyTo?: string;\n};\n\nfunction getNotionConfig(): NotionConfig | null {\n const token = Deno.env.get(\"NOTION_TOKEN\");\n const databaseId = Deno.env.get(\"NOTION_BLOOD_SUGAR_DB_ID\");\n if (!token || !databaseId) return null;\n return { token, databaseId };\n}\n\nfunction getEmailConfig(): EmailConfig | null {\n const fromEmail = Deno.env.get(\"REPORT_FROM_EMAIL\") ?? undefined;\n const fromName = Deno.env.get(\"REPORT_FROM_NAME\") ?? undefined;\n const replyTo = Deno.env.get(\"REPORT_REPLY_TO\") ?? undefined;\n if (!fromEmail && !fromName && !replyTo) return null;\n return { fromEmail, fromName, replyTo };\n}\n\nexport async function fetchEntries(\n start: string,\n end: string,\n notionConfig: NotionConfig,\n): Promise {\n const pages = await fetchNotionPages(notionConfig.databaseId, notionConfig.token, (cursor) => ({\n filter: {\n and: [\n { property: \"Created time\", created_time: { on_or_after: start } },\n { property: \"Created time\", created_time: { on_or_before: end } },\n ],\n },\n sorts: [{ property: \"Created time\", direction: \"ascending\" }],\n ...(cursor ? { start_cursor: cursor } : {}),\n }));\n\n const entries: Entry[] = [];\n for (const page of pages) {\n const entry = parseEntry(page);\n if (entry) entries.push(entry);\n }\n\n return entries;\n}\n\nexport function buildReport(entries: Entry[], start: string, end: string) {\n // Compute summary stats and derive copy for email-friendly output.\n // Summary stats for the weekly rollup.\n const rollup = buildBloodSugarRollup(entries, start, end);\n const subject = `Blood Sugar Weekly Rollup (${start} → ${end})`;\n const dateRange = listDateRange(start, end);\n const groupedEntries = groupEntriesByDate(entries, dateRange);\n const encouragement = buildEncouragement(rollup.completionRate, rollup.streak);\n const disclaimer =\n \"Not medical advice. Educational info only. Source: https://www.ynhhs.org/articles/what-is-healthy-blood-sugar\";\n\n const lines = [\n `Range: ${start} to ${end}`,\n `Entries: ${rollup.stats.totalEntries} (expected ${rollup.stats.expected}, missing ${rollup.stats.missing})`,\n `Average: ${rollup.stats.avg}`,\n `Min: ${rollup.stats.min}`,\n `Max: ${rollup.stats.max}`,\n `Completion: ${rollup.completionRate}%`,\n `Current streak: ${rollup.streak} day${rollup.streak === 1 ? \"\" : \"s\"}`,\n `Perfect week streak: ${hasPerfectWeekStreak(dateRange, rollup.stats.entriesByDate) ? \"Yes\" : \"No\"}`,\n `XP earned: ${rollup.xp}`,\n `Badges: ${rollup.badges.length ? rollup.badges.join(\", \") : \"No badges yet\"}`,\n `Encouragement: ${encouragement}`,\n `Disclaimer: ${disclaimer}`,\n \"\",\n \"Entries:\",\n ...groupedEntries.map(formatGroupedEntryLine),\n ];\n\n const text = lines.join(\"\\n\");\n const html = renderHtmlReport(groupedEntries, {\n start,\n end,\n count: rollup.stats.totalEntries,\n expected: rollup.stats.expected,\n missing: rollup.stats.missing,\n avg: rollup.stats.avg,\n min: rollup.stats.min,\n max: rollup.stats.max,\n completionRate: rollup.completionRate,\n currentStreak: rollup.streak,\n badges: rollup.badges,\n encouragement,\n disclaimer,\n xp: rollup.xp,\n perfectWeekStreak: hasPerfectWeekStreak(dateRange, rollup.stats.entriesByDate),\n });\n\n return { subject, text, html, rollup };\n}\n\nfunction formatFirstSecondHtml(group: GroupedEntries): [string, string] {\n const ordered = orderEntries(group);\n if (!ordered.length) return [\"—\", \"—\"];\n const first = String(ordered[0].value);\n if (ordered.length === 1) return [first, \"—\"];\n const secondValue = String(ordered[1].value);\n const overflow = ordered.length > 2 ? ` (+${ordered.length - 2})` : \"\";\n return [first, `${secondValue}${overflow}`];\n}\n\nfunction orderEntries(group: GroupedEntries): Entry[] {\n const combined = [...group.am, ...group.pm];\n return combined.sort((a, b) => {\n const aMinutes = parseTimeToMinutes(a.createdTime);\n const bMinutes = parseTimeToMinutes(b.createdTime);\n if (aMinutes === null && bMinutes === null) return 0;\n if (aMinutes === null) return 1;\n if (bMinutes === null) return -1;\n return aMinutes - bMinutes;\n });\n}\n\nfunction parseTimeToMinutes(value: string | null): number | null {\n if (!value) return null;\n const match = value.match(/(\\d{1,2}):(\\d{2})\\s*([AP]M)/i);\n if (!match) return null;\n let hours = Number(match[1]);\n const minutes = Number(match[2]);\n const meridiem = match[3].toUpperCase();\n if (meridiem === \"PM\" && hours < 12) hours += 12;\n if (meridiem === \"AM\" && hours === 12) hours = 0;\n return hours * 60 + minutes;\n}\n\nexport function renderHtmlReport(\n groupedEntries: GroupedEntries[],\n stats: {\n start: string;\n end: string;\n count: number;\n expected: number;\n missing: number;\n avg: number;\n min: number;\n max: number;\n completionRate: number;\n currentStreak: number;\n badges: string[];\n encouragement: string;\n disclaimer: string;\n xp: number;\n perfectWeekStreak: boolean;\n },\n): string {\n // Simple HTML table for quick scanning in email clients.\n const rows = groupedEntries\n .map((group) => {\n const [first, second] = formatFirstSecondHtml(group);\n return `\n ${group.date}\n ${escapeHtml(first)}\n ${escapeHtml(second)}\n `;\n })\n .join(\"\");\n\n return `\n

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

Blood Sugar Weekly Rollup

${stats.start} to ${stats.end}

\n 🔺 🔷 〰️ 🟢 〰️ 🔶 〰️ 🟡 〰️ 🟣 🔺 🔵 〰️\n

\n \n \n \n \n \n \n

Avg

${stats.avg}

Min

${stats.min}

Max

${stats.max}

\n \n \n \n \n \n \n \n \n \n

\n \n Entries \n ${stats.count}/${stats.expected} \n \n	\n \n Completion \n ${stats.completionRate}% \n \n
\n \n Streak \n ${stats.currentStreak} day${stats.currentStreak === 1 ? \"\" : \"s\"} \n \n	\n \n XP \n ${stats.xp} \n \n

\n Perfect Week Streak: ${stats.perfectWeekStreak ? \"Yes\" : \"No\"}\n

\n Badges:\n

\n ${\n stats.badges.length\n ? stats.badges\n .map(\n (badge) =>\n `${escapeHtml(badge)}`,\n )\n .join(\"\")\n : `No badges yet`\n }\n

\n ${escapeHtml(stats.encouragement)}\n

\n ${escapeHtml(stats.disclaimer)}\n

\n Entries\n

\n \n \n \n \n \n \n \n \n \n ${rows || ``}\n \n

Date	1st	2nd
No entries

\n `;\n}\n\nexport function escapeHtml(value: string): string {\n return value\n .replaceAll(\"&\", \"&\")\n .replaceAll(\"<\", \"<\")\n .replaceAll(\">\", \">\")\n .replaceAll('\"', \""\")\n .replaceAll(\"'\", \"'\");\n}\n",[],[205,411],["D",1768499629095],[232,233],[205],"2de47576-f23b-11f0-a135-42dde27851f2","settings.json","2de4762a-f23b-11f0-a135-42dde27851f2",228,["D",1768499643522],"{\n \"deno.enable\": true,\n \"deno.enablePaths\": [\"./\"]\n }",[],[211,423],"2de68492-f23b-11f0-93cf-42dde27851f2","extensions.json","2de68528-f23b-11f0-93cf-42dde27851f2",229,["D",1768499643540],"{\n \"recommendations\": [\n \"denoland.vscode-deno\"\n ]\n}",[],[211,431],["D",1768499629401],[229,230],[211],["D",1768332030028],["D",1789516910456],{"_97":96,"_104":100},{"_97":96,"_98":-5,"_99":100,"_18":54,"_101":102,"_103":24},{"_13":86,"_31":87,"_42":41,"_88":43,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":44,"_95":96},"ctx",{"_79":-5,"_124":479,"_480":481,"_482":483,"_484":24,"_485":24,"_486":24,"_487":122,"_488":-5,"_489":-7,"_490":-7,"_491":60,"_492":24,"_493":24,"_494":-5,"_495":24,"_496":24,"_497":24,"_498":-5},"ENV",{"_450":451,"_452":453,"_454":87,"_455":456,"_457":458,"_459":460,"_461":462,"_463":464,"_465":466,"_467":468,"_469":470,"_471":472,"_473":474,"_475":476,"_477":478},"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 · v423