[{"_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/monthly_report.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},"0459b77c-f329-11f0-9209-42dde27851f2","monthly_report.ts","fileId","045b9332-f31d-11f0-9776-42dde27851f2","parentId","25688b9e-f23b-11f0-a33f-42dde27851f2","branchId","branchVersion",356,"latest",true,["D",1768601794059],1,"fileType","script","content","import { calculateCurrentStreak, listDateRange } from \"./date.ts\";\n\n// Types shared by the monthly rollup page.\nexport type Rollup = {\n category: string;\n periodStart: string;\n periodEnd: string;\n streak: number;\n completionRate: number;\n xp: number;\n badges: string[];\n stats: Record;\n runId: string;\n};\n\nexport type MonthlySummary = {\n monthStart: string;\n monthEnd: string;\n rollupsIncluded: number;\n};\n\nexport type BloodSugarMonthlySummary = MonthlySummary & {\n totalEntries: number;\n average: number;\n min: number;\n max: number;\n completionRate: number;\n streak: number;\n xp: number;\n badges: string[];\n entriesByDate: Record;\n};\n\nexport type FoodMacroStats = {\n count: number;\n total: number;\n avg: number;\n};\n\nexport type FoodMonthlySummary = MonthlySummary & {\n totalEntries: number;\n uniqueDays: number;\n avgEntriesPerDay: number;\n minEntriesPerDay: number;\n maxEntriesPerDay: number;\n completionRate: number;\n streak: number;\n macroSummary: Record;\n entriesByDate: Record;\n};\n\ntype FoodStatsShape = {\n entriesByDate?: Record;\n macroSummary?: Record;\n totalEntries?: number;\n};\n\ntype BloodSugarStatsShape = {\n entriesByDate?: Record;\n avg?: number;\n min?: number;\n max?: number;\n totalEntries?: number;\n};\n\n// Aggregate blood sugar rollups into a single monthly summary.\nexport function aggregateBloodSugarMonth(\n rollups: Rollup[],\n monthStart: string,\n monthEnd: string,\n options: { includePartialWeeks?: boolean } = {},\n): BloodSugarMonthlySummary {\n // Default to full-week rollups to avoid double counting across overlaps.\n const dateRange = listDateRange(monthStart, monthEnd);\n const filtered = filterRollups(rollups, monthStart, monthEnd, options.includePartialWeeks ?? false);\n const entriesByDate = mergeEntriesByDate(filtered, monthStart, monthEnd);\n const totalEntries = sumValues(entriesByDate);\n\n // Use weighted average and min/max across weeks that are fully included.\n let weightedSum = 0;\n let weightedCount = 0;\n let min = Number.POSITIVE_INFINITY;\n let max = Number.NEGATIVE_INFINITY;\n let xp = 0;\n const badgeSet = new Set();\n\n for (const rollup of filtered) {\n const stats = (rollup.stats ?? {}) as BloodSugarStatsShape;\n const count = stats.totalEntries ?? 0;\n if (typeof stats.avg === \"number\" && count > 0) {\n weightedSum += stats.avg * count;\n weightedCount += count;\n }\n if (typeof stats.min === \"number\") min = Math.min(min, stats.min);\n if (typeof stats.max === \"number\") max = Math.max(max, stats.max);\n xp += rollup.xp;\n for (const badge of rollup.badges ?? []) badgeSet.add(badge);\n }\n\n const average = weightedCount ? Number((weightedSum / weightedCount).toFixed(1)) : 0;\n const resolvedMin = Number.isFinite(min) ? min : 0;\n const resolvedMax = Number.isFinite(max) ? max : 0;\n const expected = dateRange.length * 2;\n const completionRate = expected ? Math.round((totalEntries / expected) * 100) : 0;\n const streak = calculateCurrentStreak(dateRange, entriesByDate);\n\n return {\n monthStart,\n monthEnd,\n rollupsIncluded: filtered.length,\n totalEntries,\n average,\n min: resolvedMin,\n max: resolvedMax,\n completionRate,\n streak,\n xp,\n badges: Array.from(badgeSet),\n entriesByDate,\n };\n}\n\n// Aggregate food rollups into a single monthly summary.\nexport function aggregateFoodMonth(\n rollups: Rollup[],\n monthStart: string,\n monthEnd: string,\n options: { includePartialWeeks?: boolean } = {},\n): FoodMonthlySummary {\n const dateRange = listDateRange(monthStart, monthEnd);\n const filtered = filterRollups(rollups, monthStart, monthEnd, options.includePartialWeeks ?? false);\n const entriesByDate = mergeEntriesByDate(filtered, monthStart, monthEnd);\n const totalEntries = sumValues(entriesByDate);\n const uniqueDays = Object.values(entriesByDate).filter((count) => count > 0).length;\n const avgEntriesPerDay = dateRange.length ? Number((totalEntries / dateRange.length).toFixed(2)) : 0;\n const minEntriesPerDay = dateRange.length\n ? Math.min(...dateRange.map((date) => entriesByDate[date] ?? 0))\n : 0;\n const maxEntriesPerDay = dateRange.length\n ? Math.max(...dateRange.map((date) => entriesByDate[date] ?? 0))\n : 0;\n const completionRate = dateRange.length ? Math.round((uniqueDays / dateRange.length) * 100) : 0;\n const streak = calculateCurrentStreak(dateRange, entriesByDate);\n const macroSummary = aggregateMacroSummary(filtered);\n\n return {\n monthStart,\n monthEnd,\n rollupsIncluded: filtered.length,\n totalEntries,\n uniqueDays,\n avgEntriesPerDay,\n minEntriesPerDay,\n maxEntriesPerDay,\n completionRate,\n streak,\n macroSummary,\n entriesByDate,\n };\n}\n\n// Resolve the month range from a YYYY-MM string (or default to last month).\nexport function resolveMonthRange(monthParam?: string | null, now = new Date()) {\n if (monthParam) {\n const match = monthParam.match(/^(\\d{4})-(\\d{2})$/);\n if (match) {\n const year = Number(match[1]);\n const month = Number(match[2]) - 1;\n const start = new Date(Date.UTC(year, month, 1));\n const end = new Date(Date.UTC(year, month + 1, 0));\n return { start: formatDate(start), end: formatDate(end) };\n }\n }\n const year = now.getUTCFullYear();\n const month = now.getUTCMonth();\n const start = new Date(Date.UTC(year, month - 1, 1));\n const end = new Date(Date.UTC(year, month, 0));\n return { start: formatDate(start), end: formatDate(end) };\n}\n\n// Filter rollups to the desired month window.\nfunction filterRollups(\n rollups: Rollup[],\n monthStart: string,\n monthEnd: string,\n includePartialWeeks: boolean,\n) {\n return rollups.filter((rollup) => {\n if (includePartialWeeks) {\n return rollup.periodStart <= monthEnd && rollup.periodEnd >= monthStart;\n }\n return rollup.periodStart >= monthStart && rollup.periodEnd <= monthEnd;\n });\n}\n\n// Merge per-day counts across rollups (handling overlap safely).\nfunction mergeEntriesByDate(rollups: Rollup[], monthStart: string, monthEnd: string) {\n const entriesByDate: Record = {};\n for (const rollup of rollups) {\n const stats = rollup.stats as FoodStatsShape | BloodSugarStatsShape;\n const entries = stats.entriesByDate ?? {};\n for (const [date, count] of Object.entries(entries)) {\n if (date < monthStart || date > monthEnd) continue;\n const current = entriesByDate[date];\n // When rollups overlap, prefer the larger count for a given day.\n entriesByDate[date] = current === undefined ? count : Math.max(current, count);\n }\n }\n return entriesByDate;\n}\n\n// Roll up macro stats across all matching rollups.\nfunction aggregateMacroSummary(rollups: Rollup[]) {\n const summary: Record = {};\n for (const rollup of rollups) {\n const stats = rollup.stats as FoodStatsShape;\n const macroSummary = stats.macroSummary ?? {};\n for (const [key, value] of Object.entries(macroSummary)) {\n const existing = summary[key] ?? { count: 0, total: 0, avg: 0 };\n existing.count += value.count ?? 0;\n existing.total += value.total ?? 0;\n existing.avg = existing.count ? Number((existing.total / existing.count).toFixed(2)) : 0;\n summary[key] = existing;\n }\n }\n return summary;\n}\n\n// Sum values of a date->count map.\nfunction sumValues(record: Record) {\n return Object.values(record).reduce((sum, value) => sum + value, 0);\n}\n\n// Format a Date as YYYY-MM-DD (UTC).\nfunction formatDate(value: Date) {\n return value.toISOString().slice(0, 10);\n}\n","deleted","label",[177,158],"shared","permalink","https://www.val.town/x/pchinjr/notion_weekly_report/code/shared/monthly_report.ts","extension","actionData","errors"]