[{"_1":2,"_181":-5,"_182":-5},"loaderData",{"_3":4,"_93":94},"root",{"_5":6,"_36":37,"_66":67},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":-5,"_32":33,"_34":20,"_35":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesChatPanelState","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61,"_62":63,"_64":65},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","e9e636d7b466d0cb012ac9b89f74068c1d9c5525","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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","API_URL","https://api.val.town","clerkState",{"_68":69},"__internal_clerk_state",{"_70":71,"_72":47,"_73":74,"_75":74,"_76":20,"_77":74,"_78":74,"_79":74,"_80":74,"_81":82,"_91":20,"_92":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_83":20,"_19":20,"_84":74,"_85":86,"_87":74,"_88":47,"_89":20,"_90":74},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_95":96,"_97":98,"_99":100,"_101":102,"_155":156,"_178":179,"_180":-5},"handle","pchinjr","name","notion_weekly_report","path","shared/blood_sugar_logic.ts","project",{"_103":104,"_97":98,"_105":106,"_107":-5,"_108":20,"_109":110,"_111":74,"_112":-5,"_12":113,"_114":-5,"_115":20,"_116":-5,"_117":-5,"_118":33,"_14":119,"_120":121,"_122":123,"_124":125,"_126":125,"_127":128,"_129":128,"_130":128,"_131":125,"_132":125,"_23":133,"_136":137,"_141":142,"_154":20},"id","ec7452dc-f0b4-11f0-a3b9-42dde27851f2","createdAt",["D",1768332030028],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","40e69d1a-3254-4858-920b-7b1449761575","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","54bae3d1-8223-41e5-b22d-81eb28a263c7","tursoName","ec7452dcf0b411f0a3b942dde27851f2","tursoHostname","ec7452dcf0b411f0a3b942dde27851f2-val-town.aws-us-east-2.turso.io","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_95":96,"_134":135},"profileImageUrl","https://images.clerk.dev/oauth_github/img_2OaSpooJk6yZ5KFqyjtIVA4z3SH.jpeg","org",{"_95":96,"_138":135,"_12":113,"_139":140},"avatar","tier","free","branch",{"_143":144,"_97":45,"_103":145,"_146":104,"_147":-5,"_148":-5,"_149":-5,"_150":-5,"_151":-5,"_152":98,"_153":96},"version",648,"ec74b2b8-f0b4-11f0-a3b9-42dde27851f2","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_103":157,"_97":158,"_159":160,"_161":162,"_163":145,"_164":165,"_166":167,"_105":168,"_143":169,"_170":171,"_172":173,"_174":20,"_175":-5,"_99":176},"8f10723e-f7ac-11f0-98e3-42dde27851f2","blood_sugar_logic.ts","fileId","e6a27e5e-f309-11f0-8d21-42dde27851f2","parentId","25688b9e-f23b-11f0-a33f-42dde27851f2","branchId","branchVersion",418,"latest",true,["D",1769098095502],12,"fileType","script","content","import { calculateCurrentStreak, countEntriesByDate, listDateRange } from \"./date.ts\";\nimport { type NotionCreatedTimeProperty, type NotionNumberProperty, type NotionTextProperty } from \"./notion.ts\";\n\nconst REPORT_TIMEZONE = \"America/New_York\";\n\n// Scoring constants for XP and bonuses.\nconst XP_PER_ENTRY = 12;\nconst STREAK_BONUS_MULTIPLIER = 1.2;\nconst HEALTHY_AVG_BONUS_MULTIPLIER = 1.2;\nconst HEALTHY_AVG_THRESHOLD = 100;\n\n// Notion page shape and normalized entry types.\nexport type BloodSugarNotionPage = {\n id: string;\n properties: {\n \"Blood Sugar Level\"?: NotionNumberProperty;\n \"Created time\"?: NotionCreatedTimeProperty | NotionTextProperty;\n };\n};\n\nexport type Entry = {\n date: string;\n createdTime: string | null;\n value: number;\n};\n\nexport type BloodSugarRollup = {\n category: string;\n periodStart: string;\n periodEnd: string;\n streak: number;\n completionRate: number;\n xp: number;\n badges: string[];\n stats: {\n totalEntries: number;\n avg: number;\n min: number;\n max: number;\n entriesByDate: Record;\n expected: number;\n missing: number;\n };\n runId: string;\n};\n\nexport type GroupedEntries = {\n date: string;\n am: Entry[];\n pm: Entry[];\n};\n\n// Parse a Notion page into a normalized entry.\nexport function parseEntry(page: BloodSugarNotionPage): Entry | null {\n // Normalize a Notion page into the minimal shape used by the report.\n const props = page.properties ?? {};\n const value = props[\"Blood Sugar Level\"]?.number ?? null;\n const createdProp = props[\"Created time\"];\n const createdTimeRaw = isCreatedTimeProperty(createdProp)\n ? createdProp.created_time\n : isTextProperty(createdProp)\n ? createdProp.rich_text?.[0]?.plain_text ?? null\n : null;\n if (!createdTimeRaw || typeof value !== \"number\") return null;\n const date = extractDate(createdTimeRaw);\n if (!date) return null;\n const createdTime = formatCreatedTime(createdTimeRaw);\n return { date, createdTime, value };\n}\n\nfunction extractDate(value: string): string | null {\n const trimmed = value.trim();\n const textMatch = trimmed.match(\n /^(January|February|March|April|May|June|July|August|September|October|November|December)\\s+(\\d{1,2}),\\s*(\\d{4})\\s+(\\d{1,2}):(\\d{2})\\s*([AP]M)$/i,\n );\n if (textMatch) {\n const monthMap: Record = {\n january: 1,\n february: 2,\n march: 3,\n april: 4,\n may: 5,\n june: 6,\n july: 7,\n august: 8,\n september: 9,\n october: 10,\n november: 11,\n december: 12,\n };\n const month = monthMap[textMatch[1].toLowerCase()];\n const day = Number(textMatch[2]);\n const year = Number(textMatch[3]);\n if (!month || Number.isNaN(day) || Number.isNaN(year)) return null;\n return `${year}-${String(month).padStart(2, \"0\")}-${String(day).padStart(2, \"0\")}`;\n }\n\n const parsed = new Date(trimmed);\n if (Number.isNaN(parsed.getTime())) return null;\n return formatDateInTimeZone(parsed, REPORT_TIMEZONE);\n}\n\n// Normalize various Notion \"created time\" formats into readable time strings.\nexport function formatCreatedTime(value: string | null): string | null {\n if (!value) return null;\n const trimmed = value.trim();\n const timeMatch = trimmed.match(/(\\d{1,2}:\\d{2}\\s*[AP]M)/i);\n if (timeMatch) {\n return timeMatch[1].toUpperCase().replace(/\\s+/, \" \");\n }\n const parsed = new Date(trimmed);\n if (Number.isNaN(parsed.getTime())) return trimmed;\n return parsed.toLocaleTimeString(\"en-US\", {\n hour: \"numeric\",\n minute: \"2-digit\",\n hour12: true,\n timeZone: REPORT_TIMEZONE,\n });\n}\n\nfunction formatDateInTimeZone(date: Date, timeZone: string): string {\n const parts = new Intl.DateTimeFormat(\"en-US\", {\n timeZone,\n year: \"numeric\",\n month: \"2-digit\",\n day: \"2-digit\",\n }).formatToParts(date);\n const lookup = parts.reduce>((acc, part) => {\n acc[part.type] = part.value;\n return acc;\n }, {});\n return `${lookup.year}-${lookup.month}-${lookup.day}`;\n}\n\n// Perfect streak means 2+ readings per day for a full week.\nexport function hasPerfectWeekStreak(dateRange: string[], dateCounts: Record): boolean {\n return dateRange.length >= 7 && dateRange.every((date) => (dateCounts[date] ?? 0) >= 2);\n}\n\n// XP is weighted by streak and healthy average bonuses.\nexport function calculateXp(totalCount: number, avg: number, perfectWeekStreak: boolean): number {\n const baseXp = totalCount * XP_PER_ENTRY;\n if (baseXp === 0) return 0;\n const streakBonus = perfectWeekStreak ? STREAK_BONUS_MULTIPLIER : 1;\n const healthyAvgBonus = avg > 0 && avg < HEALTHY_AVG_THRESHOLD ? HEALTHY_AVG_BONUS_MULTIPLIER : 1;\n return Math.round(baseXp * streakBonus * healthyAvgBonus);\n}\n\n// Build the weekly rollup stored in SQLite.\nexport function buildBloodSugarRollup(entries: Entry[], start: string, end: string): BloodSugarRollup {\n const values = entries.map((entry) => entry.value);\n const count = values.length;\n const avg = count ? Math.round((values.reduce((a, b) => a + b, 0) / count) * 10) / 10 : 0;\n const min = count ? Math.min(...values) : 0;\n const max = count ? Math.max(...values) : 0;\n\n const dateCounts = countEntriesByDate(entries);\n const dateRange = listDateRange(start, end);\n const expected = dateRange.length * 2;\n const missing = Math.max(0, expected - count);\n const completionRate = expected ? Math.round((count / expected) * 100) : 0;\n const currentStreak = calculateCurrentStreak(dateRange, dateCounts);\n const perfectWeekStreak = hasPerfectWeekStreak(dateRange, dateCounts);\n const badges = buildBadges(dateRange, dateCounts, count, avg, perfectWeekStreak);\n const xp = calculateXp(count, avg, perfectWeekStreak);\n\n return {\n category: \"blood_sugar\",\n periodStart: start,\n periodEnd: end,\n streak: currentStreak,\n completionRate,\n xp,\n badges,\n stats: {\n totalEntries: count,\n avg,\n min,\n max,\n entriesByDate: dateCounts,\n expected,\n missing,\n },\n runId: `blood_sugar-${start}-${end}`,\n };\n}\n\n// Decide which badges to award for the week.\nexport function buildBadges(\n _dateRange: string[],\n _dateCounts: Record,\n totalCount: number,\n avg: number,\n perfectWeekStreak: boolean,\n): string[] {\n const badges: string[] = [];\n if (totalCount >= 7) badges.push(\"Mandy-Mode Consistency\");\n if (totalCount >= 14) badges.push(\"Cage Match: Full Week\");\n if (perfectWeekStreak) badges.push(\"Cage Match: Double-Check Champion\");\n if (avg > 0 && avg < HEALTHY_AVG_THRESHOLD) badges.push(\"National Treasure: Healthy Average\");\n return badges;\n}\n\n// Short motivational copy for emails.\nexport function buildEncouragement(completionRate: number, streak: number): string {\n if (completionRate >= 90) return \"Amazing work — you kept a near-perfect log this week.\";\n if (completionRate >= 70) return \"Great consistency — you’re building a strong habit.\";\n if (completionRate >= 40) return \"Nice progress — a few more check-ins will make this even stronger.\";\n if (streak >= 3) return \"You’re on a streak — keep it going!\";\n return \"Every entry helps — you’ve got this.\";\n}\n\n// Group entries into a per-day AM/PM structure for reports.\nexport function groupEntriesByDate(entries: Entry[], dateRange: string[]): GroupedEntries[] {\n // Bucket entries by date and AM/PM for consistent report formatting.\n const buckets: Record = {};\n for (const date of dateRange) {\n buckets[date] = { am: [], pm: [] };\n }\n for (const entry of entries) {\n if (!buckets[entry.date]) {\n buckets[entry.date] = { am: [], pm: [] };\n }\n const meridiem = getMeridiem(entry.createdTime);\n if (meridiem === \"AM\") {\n buckets[entry.date].am.push(entry);\n } else if (meridiem === \"PM\") {\n buckets[entry.date].pm.push(entry);\n } else {\n buckets[entry.date].pm.push(entry);\n }\n }\n return dateRange.map((date) => ({\n date,\n am: buckets[date]?.am ?? [],\n pm: buckets[date]?.pm ?? [],\n }));\n}\n\n// Format a single line of the daily summary table.\nexport function formatGroupedEntryLine(group: GroupedEntries): string {\n const [first, second] = formatFirstSecondText(group);\n return `${group.date} | 1st: ${first} | 2nd: ${second}`;\n}\n\n// Type guard for Notion created_time fields.\nexport function isCreatedTimeProperty(value: unknown): value is NotionCreatedTimeProperty {\n return (\n !!value &&\n typeof value === \"object\" &&\n \"created_time\" in value &&\n typeof (value as { created_time?: unknown }).created_time === \"string\"\n );\n}\n\n// Type guard for Notion rich_text fields.\nexport function isTextProperty(value: unknown): value is NotionTextProperty {\n return (\n !!value &&\n typeof value === \"object\" &&\n \"rich_text\" in value &&\n Array.isArray((value as { rich_text?: unknown }).rich_text)\n );\n}\n\n// Extract AM/PM from a time string if possible.\nfunction getMeridiem(value: string | null): \"AM\" | \"PM\" | null {\n if (!value) return null;\n const match = value.match(/\\b(AM|PM)\\b/i);\n if (!match) return null;\n return match[1].toUpperCase() as \"AM\" | \"PM\";\n}\n\n// Pick the first two readings (with an overflow indicator).\nfunction formatFirstSecondText(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\n// Order entries by time when present (unknown times go last).\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\n// Convert \"h:mm AM/PM\" into minutes since midnight.\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","deleted","label",[177,158],"shared","permalink","https://www.val.town/x/pchinjr/notion_weekly_report/code/shared/blood_sugar_logic.ts","extension","actionData","errors"]