[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_271":272,"_273":274},"routes/_app.x.$handle.$name",{"_99":98,"_31":44,"_107":89,"_26":108,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":24,"_122":123,"_124":24,"_125":-5,"_126":-5,"_127":128},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":24},"version",13,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","backend/fx.ts","latestPath","fileId","2d738448-a63a-11f1-b6f5-1607ee4eb77e","name","fx.ts","fileType","script","content","/**\n * Currency conversion.\n *\n * Everything is stored in the currency it is actually billed in; conversion is a\n * presentation concern, applied when we roll costs up into one number. Rates come\n * from Frankfurter (ECB reference rates, no API key), are cached in `fx_rates` for\n * the day, and fall back to the last cached value if the fetch fails — a stale\n * rate is a far better answer than a broken dashboard.\n *\n * Historical charges store the rate that applied on the day they were recorded,\n * so past spending is never silently re-priced when the zloty moves.\n */\nimport type { Currency } from \"../shared/types.ts\";\nimport { CURRENCIES } from \"../shared/types.ts\";\nimport { today } from \"../shared/money.ts\";\nimport { exec, getSetting, num, query, str } from \"./db.ts\";\n\nconst API = \"https://api.frankfurter.app/latest\";\n\n/** Last-resort rates so a first run with no network still renders something sane. */\nconst FALLBACK: Record> = {\n PLN: { PLN: 1, USD: 4.0, EUR: 4.3 },\n USD: { PLN: 0.25, USD: 1, EUR: 1.08 },\n EUR: { PLN: 0.23, USD: 0.93, EUR: 1 },\n};\n\nexport async function baseCurrency(): Promise {\n const fromEnv = Deno.env.get(\"BASE_CURRENCY\");\n const stored = fromEnv ?? (await getSetting(\"base_currency\"));\n const candidate = (stored ?? \"PLN\").toUpperCase() as Currency;\n return CURRENCIES.includes(candidate) ? candidate : \"PLN\";\n}\n\n/** How many units of `base` one unit of each currency is worth. */\nexport type RateTable = Record;\n\nlet memo: { base: Currency; day: string; table: RateTable } | null = null;\n\nexport async function getRates(base?: Currency): Promise {\n const target = base ?? (await baseCurrency());\n const day = today();\n if (memo && memo.base === target && memo.day === day) return memo.table;\n\n const cached = await readCache(target);\n if (cached && cached.asOf === day) {\n memo = { base: target, day, table: cached.table };\n return cached.table;\n }\n\n let table: RateTable;\n try {\n table = await fetchRates(target);\n await writeCache(target, table, day);\n } catch (err) {\n console.error(\"fx: falling back to cached/static rates:\", err);\n table = cached?.table ?? { ...FALLBACK[target] };\n }\n\n memo = { base: target, day, table };\n return table;\n}\n\nasync function fetchRates(base: Currency): Promise {\n const others = CURRENCIES.filter((c) => c !== base);\n // Frankfurter answers \"1 base = N quote\"; we want the inverse, \"1 quote = N base\".\n const res = await fetch(`${API}?base=${base}&symbols=${others.join(\",\")}`);\n if (!res.ok) throw new Error(`frankfurter ${res.status}`);\n const body = await res.json() as { rates?: Record };\n const table = { [base]: 1 } as RateTable;\n for (const c of others) {\n const perBase = body.rates?.[c];\n if (!perBase || perBase <= 0) throw new Error(`missing rate for ${c}`);\n table[c] = 1 / perBase;\n }\n return table;\n}\n\nasync function readCache(base: Currency): Promise<{ table: RateTable; asOf: string } | null> {\n const rows = await query(\"SELECT quote, rate, as_of FROM fx_rates WHERE base = ?\", [base]);\n if (rows.length === 0) return null;\n const table = { [base]: 1 } as RateTable;\n let asOf = \"\";\n for (const r of rows) {\n table[str(r.quote) as Currency] = num(r.rate);\n const rowDate = str(r.as_of) ?? \"\";\n if (!asOf || rowDate < asOf) asOf = rowDate; // oldest row decides freshness\n }\n for (const c of CURRENCIES) if (table[c] === undefined) return null;\n return { table, asOf };\n}\n\nasync function writeCache(base: Currency, table: RateTable, asOf: string): Promise {\n for (const quote of CURRENCIES) {\n await exec(\n `INSERT INTO fx_rates (quote, base, rate, as_of) VALUES (?, ?, ?, ?)\n ON CONFLICT(quote, base) DO UPDATE SET rate = excluded.rate, as_of = excluded.as_of`,\n [quote, base, table[quote], asOf],\n );\n }\n}\n\n/** Convert minor units between currencies using a table keyed to the base. */\nexport function convertMinor(amountMinor: number, from: Currency, table: RateTable): number {\n return Math.round(amountMinor * (table[from] ?? 1));\n}\n\nexport function rateFor(from: Currency, table: RateTable): number {\n return table[from] ?? 1;\n}\n\n/** Called by the daily cron so the dashboard's first hit of the day is already warm. */\nexport async function refreshRates(): Promise {\n memo = null;\n const base = await baseCurrency();\n const table = await fetchRates(base);\n await writeCache(base, table, today());\n memo = { base, day: today(), table };\n return table;\n}\n","createdAt",["D",1788290422584],"branchVersion","branchId","723ee93a-6b67-428c-b3cc-6f9491011d78","id","5588f200-1c41-400f-bf66-81f9f6ac0211","subscriptions",["D",1788290256185],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Track subscriptions, forecast spend, decide what to cancel","imageUrl","5f1525c6-51a0-4c57-858d-f94f1e686d46","pinnedFileId","c177e026-a63a-11f1-bee9-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a05e29-777a-77c1-a910-e4a1d8102a40","tursoName","5588f2001c41400fbf6681f9f6ac0211","tursoHostname","5588f2001c41400fbf6681f9f6ac0211-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789509043237],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_106":-5},"org",{"_99":98,"_100":101,"_102":-5,"_18":-5,"_103":104,"_105":24},"branch",{"_13":88,"_31":89,"_42":41,"_90":43,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":44,"_97":98},"isOwned",92,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","xdv","handle","displayName","xd.ventures","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":266,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":267,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":268,"_83":269,"_85":270,"_87":24},"tree",[180,184,186,191,192],"files",[180,181,182,183,184,185,186,187,188,189,190,191,192],"counts",{"_169":62,"_170":138,"_171":138,"_172":173,"_174":175},"contents",[129,130,131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":163,"_31":164,"_29":165,"_137":-5,"_40":41,"_39":166,"_139":58,"_37":167,"_13":62,"_33":149,"_35":-5,"_23":24,"_142":-5,"_26":168},{"_42":157,"_31":158,"_29":159,"_137":-5,"_40":41,"_39":160,"_139":58,"_37":161,"_13":62,"_33":149,"_35":-5,"_23":24,"_142":-5,"_26":162},{"_42":151,"_31":152,"_29":153,"_137":-5,"_40":41,"_39":154,"_139":58,"_37":155,"_13":62,"_33":149,"_35":-5,"_23":24,"_142":-5,"_26":156},{"_42":144,"_31":145,"_29":146,"_137":-5,"_40":41,"_39":147,"_139":58,"_37":148,"_13":62,"_33":149,"_35":-5,"_23":24,"_142":-5,"_26":150},{"_42":134,"_31":135,"_29":136,"_137":-5,"_40":41,"_39":138,"_139":24,"_37":140,"_13":62,"_33":20,"_35":141,"_23":24,"_142":-5,"_26":143},"67d40d33-d63e-42a4-848c-c79f3182920a","PLACEHOLDER.md","ca49b9d2-a639-11f1-bb59-1607ee4eb77e","parentId",1,"latest",["D",1788290256221],"Bootstrapping.","label",[135],"44ac6418-79af-44cf-ad45-03919cf85518","tests","daa22ada-a639-11f1-a090-1607ee4eb77e",7,["D",1788290283645],"directory",[145],"3b062db2-506c-4dab-8eea-bbf72b699f28","shared","cd4c23cc-a639-11f1-9263-1607ee4eb77e",2,["D",1788290261270],[152],"7a1a8cc2-5f5e-41d8-b0dc-6a886fbbfd83","frontend","d62582e0-a639-11f1-8486-1607ee4eb77e",5,["D",1788290276120],[158],"8e3a3793-994f-4922-93a3-91669c779f58","backend","cfb9f800-a639-11f1-ae2f-1607ee4eb77e",3,["D",1788290265322],[164],"pulls","branches","forks","envVars",{"_176":178,"_179":62},"connections",{"_176":62,"_177":62},"count","unfilledCount",6,"emptyCount",{"_42":163,"_31":164,"_29":165,"_137":-5,"_40":41,"_39":166,"_139":58,"_37":263,"_13":62,"_33":149,"_35":-5,"_23":24,"_142":-5,"_194":264,"_26":265},{"_42":256,"_31":257,"_29":258,"_137":165,"_40":41,"_39":259,"_139":58,"_37":260,"_13":62,"_33":149,"_35":-5,"_23":24,"_142":-5,"_194":261,"_26":262},{"_42":248,"_31":249,"_29":250,"_137":165,"_40":41,"_39":251,"_139":24,"_37":252,"_13":62,"_33":34,"_35":253,"_23":24,"_142":-5,"_194":254,"_26":255},{"_42":244,"_31":32,"_29":30,"_137":165,"_40":41,"_39":14,"_139":58,"_37":245,"_13":62,"_33":34,"_35":36,"_23":24,"_142":-5,"_194":246,"_26":247},{"_42":157,"_31":158,"_29":159,"_137":-5,"_40":41,"_39":160,"_139":58,"_37":241,"_13":62,"_33":149,"_35":-5,"_23":24,"_142":-5,"_194":242,"_26":243},{"_42":235,"_31":236,"_29":237,"_137":159,"_40":41,"_39":178,"_139":58,"_37":238,"_13":62,"_33":149,"_35":-5,"_23":24,"_142":-5,"_194":239,"_26":240},{"_42":151,"_31":152,"_29":153,"_137":-5,"_40":41,"_39":154,"_139":58,"_37":232,"_13":62,"_33":149,"_35":-5,"_23":24,"_142":-5,"_194":233,"_26":234},{"_42":224,"_31":225,"_29":226,"_137":153,"_40":41,"_39":227,"_139":58,"_37":228,"_13":62,"_33":34,"_35":229,"_23":24,"_142":-5,"_194":230,"_26":231},{"_42":216,"_31":217,"_29":218,"_137":153,"_40":41,"_39":219,"_139":58,"_37":220,"_13":62,"_33":34,"_35":221,"_23":24,"_142":-5,"_194":222,"_26":223},{"_42":208,"_31":209,"_29":210,"_137":153,"_40":41,"_39":211,"_139":58,"_37":212,"_13":62,"_33":34,"_35":213,"_23":24,"_142":-5,"_194":214,"_26":215},{"_42":200,"_31":201,"_29":202,"_137":153,"_40":41,"_39":203,"_139":24,"_37":204,"_13":62,"_33":34,"_35":205,"_23":24,"_142":-5,"_194":206,"_26":207},{"_42":144,"_31":145,"_29":146,"_137":-5,"_40":41,"_39":147,"_139":58,"_37":197,"_13":62,"_33":149,"_35":-5,"_23":24,"_142":-5,"_194":198,"_26":199},{"_42":134,"_31":135,"_29":136,"_137":-5,"_40":41,"_39":138,"_139":24,"_37":193,"_13":62,"_33":20,"_35":141,"_23":24,"_142":-5,"_194":195,"_26":196},["D",1788290256221],"children",[],[135],["D",1788290283645],[],[145],"e4d4dca2-b850-4197-9596-43f83839fc12","types.ts","fad95512-a639-11f1-8af0-1607ee4eb77e",8,["D",1788290337678],"/** Shared types used by both the backend and the browser bundle. */\n\nexport type Currency = \"PLN\" | \"USD\" | \"EUR\";\nexport const CURRENCIES: Currency[] = [\"PLN\", \"USD\", \"EUR\"];\n\nexport type BillingCycle = \"monthly\" | \"yearly\";\nexport const BILLING_CYCLES: BillingCycle[] = [\"monthly\", \"yearly\"];\n\nexport type SubscriptionStatus = \"active\" | \"trial\" | \"paused\" | \"cancelled\";\n\n/** Statuses that still cost money and still get forecast, rated and reminded about. */\nexport const LIVE_STATUSES: SubscriptionStatus[] = [\"active\", \"trial\"];\n\nexport function isLive(status: SubscriptionStatus): boolean {\n return status === \"active\" || status === \"trial\";\n}\n\nexport interface Service {\n id: number;\n name: string;\n /** Sender domain of confirmation mail, used to match forwarded email to a service. */\n vendorDomain: string | null;\n category: string | null;\n notes: string | null;\n createdAt: string;\n}\n\nexport interface Subscription {\n id: number;\n serviceId: number;\n serviceName: string;\n category: string | null;\n planName: string | null;\n /** Native amount in minor units (grosze / cents). Never a float. */\n amountMinor: number;\n currency: Currency;\n billingCycle: BillingCycle;\n startedOn: string | null;\n /** ISO date of the next expected charge. Drives forecasts and reminders. */\n nextChargeOn: string | null;\n status: SubscriptionStatus;\n cancelledOn: string | null;\n cancelReason: string | null;\n paymentMethod: string | null;\n autoRenew: boolean;\n /** Where the row came from: typed in by hand, or extracted from a forwarded email. */\n source: \"manual\" | \"email\";\n notes: string | null;\n createdAt: string;\n updatedAt: string;\n}\n\n/** A real payment that happened, as opposed to a projected one. */\nexport interface Charge {\n id: number;\n subscriptionId: number;\n chargedOn: string;\n amountMinor: number;\n currency: Currency;\n /** Value in base currency at the time of the charge, so history is not re-rated by later FX moves. */\n baseMinor: number;\n fxRate: number;\n source: \"manual\" | \"email\" | \"projected\";\n inboundEmailId: number | null;\n createdAt: string;\n}\n\n/** One month's worth of \"how good is this, really\". */\nexport interface Rating {\n id: number;\n subscriptionId: number;\n /** YYYY-MM */\n period: string;\n /** 1..5 — how happy am I with the quality of the service. */\n quality: number;\n /** 1..5 — how often do I actually use it. */\n usage: number;\n note: string | null;\n createdAt: string;\n}\n\nexport type ReviewKind =\n | \"confirm_new\"\n | \"renewal_soon\"\n | \"yearly_upcoming\"\n | \"rating_due\"\n | \"cancel_candidate\";\n\nexport type ReviewStatus = \"open\" | \"done\" | \"dismissed\";\n\n/** The actionable inbox: the thing that stops a \"I meant to cancel that\" from evaporating. */\nexport interface ReviewItem {\n id: number;\n subscriptionId: number | null;\n kind: ReviewKind;\n status: ReviewStatus;\n title: string;\n detail: string | null;\n dueOn: string | null;\n createdAt: string;\n resolvedAt: string | null;\n}\n\nexport type EmailIntent = \"ingest\" | \"question\" | \"command\" | \"unknown\";\n\nexport interface InboundEmail {\n id: number;\n messageId: string | null;\n fromAddr: string;\n subject: string | null;\n intent: EmailIntent;\n handled: boolean;\n result: string | null;\n createdAt: string;\n}\n\n/** Verdict for a single subscription, computed from its recent ratings and its cost. */\nexport interface Verdict {\n /** Recency-weighted quality, 1..5, or null when never rated. */\n quality: number | null;\n usage: number | null;\n /** Harmonic mean of quality and usage — punishes \"great but unused\" and \"used but bad\". */\n score: number | null;\n ratedMonths: number;\n band: \"keep\" | \"watch\" | \"cancel_candidate\" | \"unrated\";\n reason: string;\n}\n\n/** A subscription plus everything the dashboard needs to render a row. */\nexport interface SubscriptionView extends Subscription {\n /** Native cost normalised to a month, in minor units of the native currency. */\n monthlyMinor: number;\n yearlyMinor: number;\n /** Same, converted to the base currency. */\n monthlyBaseMinor: number;\n yearlyBaseMinor: number;\n /** Units of base currency per unit of this subscription's currency, at render time. */\n fxRate: number;\n verdict: Verdict;\n latestRating: Rating | null;\n /** True when this month has no rating yet and the subscription is live. */\n ratingDue: boolean;\n}\n\n/** One projected (not yet charged) payment. */\nexport interface ProjectedCharge {\n subscriptionId: number;\n serviceName: string;\n date: string;\n amountMinor: number;\n currency: Currency;\n baseMinor: number;\n billingCycle: BillingCycle;\n}\n\nexport interface MonthBucket {\n /** YYYY-MM */\n period: string;\n baseMinor: number;\n charges: ProjectedCharge[];\n}\n\nexport interface Summary {\n baseCurrency: Currency;\n /** Sum of monthly-equivalents of everything live — the steady-state burn. */\n monthlyRunRateBaseMinor: number;\n yearlyRunRateBaseMinor: number;\n /** What the next 30 days will actually cost, on the calendar. */\n next30DaysBaseMinor: number;\n /** Calendar-accurate 12-month projection, so yearly renewals land in their real month. */\n next12MonthsBaseMinor: number;\n activeCount: number;\n monthlyCount: number;\n yearlyCount: number;\n /** Cumulative monthly-equivalent not spent since each cancellation. */\n savedToDateBaseMinor: number;\n /** Monthly-equivalent of everything cancelled — the ongoing saving. */\n savedPerMonthBaseMinor: number;\n openReviewCount: number;\n ratingDueCount: number;\n}\n",[],[152,201],"7e542ab3-108c-44d6-8108-02d6e5e4f01f","money.ts","09979014-a63a-11f1-83e6-1607ee4eb77e",9,["D",1788290362431],"/**\n * Money and billing-cycle maths. Pure — no imports, runs on both sides.\n *\n * Amounts are integer minor units (grosze / cents) everywhere. PLN, USD and EUR\n * all have two decimal places, so one constant covers every supported currency.\n */\nimport type { BillingCycle, Currency } from \"./types.ts\";\n\nexport const MINOR = 100;\n\nexport function toMinor(amount: number): number {\n return Math.round(amount * MINOR);\n}\n\nexport function fromMinor(minor: number): number {\n return minor / MINOR;\n}\n\nconst SYMBOLS: Record = { PLN: \"zł\", USD: \"$\", EUR: \"€\" };\n\n/** \"1 234,56 zł\" for PLN, \"$1,234.56\" for USD/EUR — matches where each symbol normally sits. */\nexport function formatMoney(minor: number, currency: Currency, opts?: { compact?: boolean }): string {\n const value = fromMinor(minor);\n const locale = currency === \"PLN\" ? \"pl-PL\" : \"en-US\";\n const body = value.toLocaleString(locale, {\n minimumFractionDigits: opts?.compact ? 0 : 2,\n maximumFractionDigits: opts?.compact ? 0 : 2,\n });\n return currency === \"PLN\" ? `${body} ${SYMBOLS.PLN}` : `${SYMBOLS[currency]}${body}`;\n}\n\n/**\n * Cost of one cycle expressed as a month.\n *\n * A yearly subscription is divided by twelve — this is the \"average monthly cost\"\n * that makes a 600 zł/year plan comparable to a 49 zł/month one. It is a run-rate,\n * not a cash-flow figure; the calendar projection below is what tells you when the\n * money actually leaves.\n */\nexport function monthlyEquivalentMinor(amountMinor: number, cycle: BillingCycle): number {\n return cycle === \"yearly\" ? Math.round(amountMinor / 12) : amountMinor;\n}\n\nexport function yearlyEquivalentMinor(amountMinor: number, cycle: BillingCycle): number {\n return cycle === \"yearly\" ? amountMinor : amountMinor * 12;\n}\n\n// ---------------------------------------------------------------------------\n// Dates. Stored as YYYY-MM-DD strings and manipulated in UTC so that a server in\n// one timezone and a browser in another agree on which day a charge lands.\n// ---------------------------------------------------------------------------\n\nexport function today(now: Date = new Date()): string {\n return toISODate(now);\n}\n\nexport function toISODate(d: Date): string {\n return d.toISOString().slice(0, 10);\n}\n\nexport function parseISODate(s: string): Date {\n const [y, m, d] = s.split(\"-\").map(Number);\n return new Date(Date.UTC(y, m - 1, d));\n}\n\n/** YYYY-MM for a date string. */\nexport function periodOf(isoDate: string): string {\n return isoDate.slice(0, 7);\n}\n\nexport function currentPeriod(now: Date = new Date()): string {\n return toISODate(now).slice(0, 7);\n}\n\n/** Previous period, e.g. \"2026-01\" -> \"2025-12\". */\nexport function shiftPeriod(period: string, months: number): string {\n const [y, m] = period.split(\"-\").map(Number);\n const d = new Date(Date.UTC(y, m - 1 + months, 1));\n return toISODate(d).slice(0, 7);\n}\n\n/**\n * Add months, clamping the day to the end of the target month.\n * 31 Jan + 1 month is 28/29 Feb, which is how card renewals actually behave.\n */\nexport function addMonths(isoDate: string, months: number): string {\n const d = parseISODate(isoDate);\n const day = d.getUTCDate();\n const target = new Date(Date.UTC(d.getUTCFullYear(), d.getUTCMonth() + months, 1));\n const lastDay = new Date(Date.UTC(target.getUTCFullYear(), target.getUTCMonth() + 1, 0)).getUTCDate();\n target.setUTCDate(Math.min(day, lastDay));\n return toISODate(target);\n}\n\nexport function addDays(isoDate: string, days: number): string {\n const d = parseISODate(isoDate);\n d.setUTCDate(d.getUTCDate() + days);\n return toISODate(d);\n}\n\nexport function advanceByCycle(isoDate: string, cycle: BillingCycle): string {\n return addMonths(isoDate, cycle === \"yearly\" ? 12 : 1);\n}\n\nexport function daysBetween(from: string, to: string): number {\n return Math.round((parseISODate(to).getTime() - parseISODate(from).getTime()) / 86_400_000);\n}\n\n/**\n * Roll a stale next-charge date forward until it is in the future.\n * Cheaper than a backfill job: a subscription whose date was never updated still\n * forecasts correctly, and the loop is bounded so bad data cannot hang a request.\n */\nexport function normaliseNextCharge(nextChargeOn: string, cycle: BillingCycle, from: string): string {\n let next = nextChargeOn;\n for (let i = 0; i < 240 && next < from; i++) {\n next = advanceByCycle(next, cycle);\n }\n return next;\n}\n",[],[152,209],"9353e38a-fea3-4c76-a556-ccfc0c7b0461","grade.ts","24db9dfc-a63a-11f1-9b8b-1607ee4eb77e",10,["D",1788290408143],"/**\n * Turning two monthly grades into a keep/cancel verdict.\n *\n * Each month you give a subscription two scores out of five: how good it is\n * (quality) and how much you actually reach for it (usage). Neither alone is a\n * decision — a brilliant tool you opened twice is still money leaving, and a\n * mediocre one you live in is worth keeping. So the two are combined with a\n * harmonic mean, which collapses toward whichever score is *worse*: 5 and 1 give\n * 1.7, not 3. Lopsided pairs are exactly the ones worth surfacing.\n */\nimport type { Rating, Verdict } from \"./types.ts\";\nimport { shiftPeriod } from \"./money.ts\";\n\n/** How many months of history feed a verdict. */\nexport const WINDOW_MONTHS = 6;\n/** Each month back counts for three quarters of the one after it. */\nconst DECAY = 0.75;\n\nexport const KEEP_THRESHOLD = 3.5;\nexport const WATCH_THRESHOLD = 2.5;\n\nexport function harmonicMean(a: number, b: number): number {\n if (a <= 0 || b <= 0) return 0;\n return (2 * a * b) / (a + b);\n}\n\nexport interface VerdictInput {\n ratings: Rating[];\n currentPeriod: string;\n /** Monthly cost in base currency, used to escalate an expensive middling service. */\n monthlyBaseMinor?: number;\n /** Cost above which \"watch\" becomes \"cancel candidate\". Typically the portfolio median. */\n expensiveThresholdMinor?: number;\n}\n\nexport function computeVerdict(input: VerdictInput): Verdict {\n const { ratings, currentPeriod, monthlyBaseMinor, expensiveThresholdMinor } = input;\n\n // Index the window by period so gaps (months you skipped) simply carry no weight.\n const windowPeriods = new Map();\n for (let i = 0; i < WINDOW_MONTHS; i++) {\n windowPeriods.set(shiftPeriod(currentPeriod, -i), Math.pow(DECAY, i));\n }\n\n let qSum = 0, uSum = 0, wSum = 0, months = 0;\n for (const r of ratings) {\n const w = windowPeriods.get(r.period);\n if (w === undefined) continue;\n qSum += r.quality * w;\n uSum += r.usage * w;\n wSum += w;\n months++;\n }\n\n if (wSum === 0) {\n return {\n quality: null,\n usage: null,\n score: null,\n ratedMonths: 0,\n band: \"unrated\",\n reason: \"No ratings yet — rate it once to get a verdict.\",\n };\n }\n\n const quality = round1(qSum / wSum);\n const usage = round1(uSum / wSum);\n const score = round1(harmonicMean(quality, usage));\n\n let band: Verdict[\"band\"] = score >= KEEP_THRESHOLD ? \"keep\" : score >= WATCH_THRESHOLD ? \"watch\" : \"cancel_candidate\";\n\n const expensive = monthlyBaseMinor !== undefined\n && expensiveThresholdMinor !== undefined\n && monthlyBaseMinor > expensiveThresholdMinor;\n\n // An above-median cost only has to be middling, not bad, to deserve a decision.\n if (band === \"watch\" && expensive) band = \"cancel_candidate\";\n\n return { quality, usage, score, ratedMonths: months, band, reason: explain(quality, usage, score, band, expensive) };\n}\n\nfunction explain(quality: number, usage: number, score: number, band: Verdict[\"band\"], expensive: boolean): string {\n const gap = quality - usage;\n if (gap >= 1.5) {\n return `Good service (${quality}) you barely use (${usage}) — the usual cancel candidate.`;\n }\n if (gap <= -1.5) {\n return `You use it (${usage}) despite rating it ${quality} — look for a better alternative.`;\n }\n if (band === \"keep\") return `Solid on both axes (${quality} quality, ${usage} usage).`;\n if (band === \"cancel_candidate\" && expensive) {\n return `Middling (${score}) and above your median cost — decide on it.`;\n }\n if (band === \"cancel_candidate\") return `Low on both axes (${quality} quality, ${usage} usage).`;\n return `Neither good nor bad (${score}) — worth a conscious decision.`;\n}\n\nfunction round1(n: number): number {\n return Math.round(n * 10) / 10;\n}\n\nexport function bandLabel(band: Verdict[\"band\"]): string {\n return { keep: \"Keep\", watch: \"Watch\", cancel_candidate: \"Cancel?\", unrated: \"Unrated\" }[band];\n}\n\n/** Median of the live monthly costs — the reference point for \"expensive\". */\nexport function medianMinor(values: number[]): number | undefined {\n if (values.length === 0) return undefined;\n const sorted = [...values].sort((a, b) => a - b);\n const mid = Math.floor(sorted.length / 2);\n return sorted.length % 2 ? sorted[mid] : Math.round((sorted[mid - 1] + sorted[mid]) / 2);\n}\n",[],[152,217],"1b189923-25e4-4258-a3c4-af249248f555","forecast.ts","27a1da2e-a63a-11f1-9ce3-1607ee4eb77e",11,["D",1788290412822],"/**\n * Projecting charges forward. Pure — the calendar maths that turns a set of\n * subscriptions into \"what leaves the account, and when\".\n *\n * Kept out of the backend so it can be tested without a database, and so the\n * browser could run the same projection if it ever needed to.\n */\nimport type { MonthBucket, ProjectedCharge, SubscriptionView } from \"./types.ts\";\nimport { isLive } from \"./types.ts\";\nimport { advanceByCycle, normaliseNextCharge, periodOf, shiftPeriod, today } from \"./money.ts\";\n\n/** Bound on how many charges one subscription can contribute — 20 years of monthly. */\nconst MAX_ITERATIONS = 240;\n\nexport function projectCharges(\n subs: SubscriptionView[],\n opts: { from?: string; until: string },\n): ProjectedCharge[] {\n const from = opts.from ?? today();\n const out: ProjectedCharge[] = [];\n\n for (const s of subs) {\n if (!isLive(s.status) || !s.nextChargeOn) continue;\n // A stale next-charge date rolls forward to the first one still ahead of us,\n // so a row nobody has touched in months still forecasts correctly.\n let date = normaliseNextCharge(s.nextChargeOn, s.billingCycle, from);\n for (let i = 0; i < MAX_ITERATIONS && date <= opts.until; i++) {\n out.push({\n subscriptionId: s.id,\n serviceName: s.serviceName,\n date,\n amountMinor: s.amountMinor,\n currency: s.currency,\n baseMinor: Math.round(s.amountMinor * s.fxRate),\n billingCycle: s.billingCycle,\n });\n // Auto-renew off means the charge already scheduled happens and nothing after it.\n if (!s.autoRenew) break;\n date = advanceByCycle(date, s.billingCycle);\n }\n }\n return out.sort((a, b) => a.date.localeCompare(b.date) || a.serviceName.localeCompare(b.serviceName));\n}\n\n/** Group into calendar months, keeping empty months so the chart has a continuous axis. */\nexport function bucketByMonth(charges: ProjectedCharge[], startPeriod: string, months: number): MonthBucket[] {\n const buckets: MonthBucket[] = [];\n const index = new Map();\n for (let i = 0; i < months; i++) {\n const period = shiftPeriod(startPeriod, i);\n const bucket: MonthBucket = { period, baseMinor: 0, charges: [] };\n buckets.push(bucket);\n index.set(period, bucket);\n }\n for (const c of charges) {\n const bucket = index.get(periodOf(c.date));\n if (!bucket) continue;\n bucket.baseMinor += c.baseMinor;\n bucket.charges.push(c);\n }\n return buckets;\n}\n",[],[152,225],["D",1788290261270],[187,188,189,190],[152],"a1f202f4-c83f-4267-8b6a-bd8cd99fe46f","components","d850bc88-a639-11f1-af8b-1607ee4eb77e",["D",1788290279752],[],[158,236],["D",1788290276120],[185],[158],"9581af13-d37b-4ddf-9fdd-16951baa2f9d",["D",1788290422584],[],[164,32],"a39cdcec-6a39-4209-8d1c-252792a079bf","db.ts","2a7cf6de-a63a-11f1-a04e-1607ee4eb77e",12,["D",1788290417591],"/**\n * Schema and connection for the subscription tracker.\n *\n * Shape of the model, in one paragraph: a `service` is the thing you buy from\n * (Netflix, Figma). A `subscription` is one billing arrangement for that service\n * — its price, currency, cycle and status. Prices change and plans get switched,\n * so a service can own several subscriptions over time while only one is live.\n * `charges` are payments that really happened; everything in the future is\n * projected on the fly from `next_charge_on` rather than stored, so a price\n * change never leaves stale rows behind. `ratings` hold the two monthly grades,\n * `review_items` is the actionable inbox, and `inbound_emails` is the audit log\n * that also gives us idempotency against a mail server delivering twice.\n */\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport { sqlite };\n\nexport type Row = Record;\n\nconst SCHEMA = [\n `CREATE TABLE IF NOT EXISTS services (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n name_key TEXT NOT NULL UNIQUE,\n vendor_domain TEXT,\n category TEXT,\n notes TEXT,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n\n `CREATE TABLE IF NOT EXISTS subscriptions (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n service_id INTEGER NOT NULL REFERENCES services(id) ON DELETE CASCADE,\n plan_name TEXT,\n amount_minor INTEGER NOT NULL CHECK (amount_minor >= 0),\n currency TEXT NOT NULL CHECK (currency IN ('PLN','USD','EUR')),\n billing_cycle TEXT NOT NULL CHECK (billing_cycle IN ('monthly','yearly')),\n started_on TEXT,\n next_charge_on TEXT,\n status TEXT NOT NULL DEFAULT 'active'\n CHECK (status IN ('active','trial','paused','cancelled')),\n cancelled_on TEXT,\n cancel_reason TEXT,\n payment_method TEXT,\n auto_renew INTEGER NOT NULL DEFAULT 1,\n source TEXT NOT NULL DEFAULT 'manual' CHECK (source IN ('manual','email')),\n notes TEXT,\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n updated_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n\n `CREATE TABLE IF NOT EXISTS ratings (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n subscription_id INTEGER NOT NULL REFERENCES subscriptions(id) ON DELETE CASCADE,\n period TEXT NOT NULL,\n quality INTEGER NOT NULL CHECK (quality BETWEEN 1 AND 5),\n usage INTEGER NOT NULL CHECK (usage BETWEEN 1 AND 5),\n note TEXT,\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n UNIQUE (subscription_id, period)\n )`,\n\n `CREATE TABLE IF NOT EXISTS review_items (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n subscription_id INTEGER REFERENCES subscriptions(id) ON DELETE CASCADE,\n kind TEXT NOT NULL,\n status TEXT NOT NULL DEFAULT 'open' CHECK (status IN ('open','done','dismissed')),\n title TEXT NOT NULL,\n detail TEXT,\n due_on TEXT,\n dedupe_key TEXT UNIQUE,\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n resolved_at TEXT\n )`,\n\n `CREATE TABLE IF NOT EXISTS inbound_emails (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n message_id TEXT UNIQUE,\n from_addr TEXT NOT NULL,\n subject TEXT,\n body TEXT,\n intent TEXT NOT NULL DEFAULT 'unknown',\n handled INTEGER NOT NULL DEFAULT 0,\n result TEXT,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n\n `CREATE TABLE IF NOT EXISTS charges (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n subscription_id INTEGER NOT NULL REFERENCES subscriptions(id) ON DELETE CASCADE,\n charged_on TEXT NOT NULL,\n amount_minor INTEGER NOT NULL,\n currency TEXT NOT NULL,\n base_minor INTEGER NOT NULL,\n fx_rate REAL NOT NULL DEFAULT 1,\n source TEXT NOT NULL DEFAULT 'manual',\n inbound_email_id INTEGER REFERENCES inbound_emails(id),\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n UNIQUE (subscription_id, charged_on, amount_minor)\n )`,\n\n `CREATE TABLE IF NOT EXISTS fx_rates (\n quote TEXT NOT NULL,\n base TEXT NOT NULL,\n rate REAL NOT NULL,\n as_of TEXT NOT NULL,\n PRIMARY KEY (quote, base)\n )`,\n\n `CREATE TABLE IF NOT EXISTS settings (\n key TEXT PRIMARY KEY,\n value TEXT NOT NULL\n )`,\n\n `CREATE INDEX IF NOT EXISTS idx_sub_status ON subscriptions(status)`,\n `CREATE INDEX IF NOT EXISTS idx_sub_service ON subscriptions(service_id)`,\n `CREATE INDEX IF NOT EXISTS idx_sub_next ON subscriptions(next_charge_on)`,\n `CREATE INDEX IF NOT EXISTS idx_charge_sub ON charges(subscription_id, charged_on)`,\n `CREATE INDEX IF NOT EXISTS idx_charge_date ON charges(charged_on)`,\n `CREATE INDEX IF NOT EXISTS idx_rating_sub ON ratings(subscription_id, period)`,\n `CREATE INDEX IF NOT EXISTS idx_review_status ON review_items(status, due_on)`,\n];\n\n/**\n * Columns added after the first release. Each runs on its own and swallows the\n * \"duplicate column\" error, so a fresh database (which already has them from\n * SCHEMA) and an existing one both end up in the same shape.\n */\nconst MIGRATIONS: string[] = [];\n\nlet schemaReady: Promise | null = null;\n\n/** Idempotent, and memoised per isolate so a burst of requests sets up once. */\nexport function ensureSchema(): Promise {\n schemaReady ??= (async () => {\n for (const stmt of SCHEMA) await sqlite.execute(stmt);\n for (const stmt of MIGRATIONS) {\n try {\n await sqlite.execute(stmt);\n } catch (err) {\n const msg = String(err);\n if (!msg.includes(\"duplicate column\") && !msg.includes(\"already exists\")) throw err;\n }\n }\n })().catch((err) => {\n schemaReady = null; // let the next caller retry rather than caching a failure\n throw err;\n });\n return schemaReady;\n}\n\n/** Run a query, making sure the schema exists first. */\nexport async function query(sql: string, args: unknown[] = []): Promise {\n await ensureSchema();\n const res = await sqlite.execute({ sql, args: args as never });\n return res.rows as unknown as Row[];\n}\n\nexport async function exec(sql: string, args: unknown[] = []): Promise<{ rowsAffected: number; lastInsertRowid: number | null }> {\n await ensureSchema();\n const res = await sqlite.execute({ sql, args: args as never });\n return {\n rowsAffected: Number(res.rowsAffected ?? 0),\n lastInsertRowid: res.lastInsertRowid == null ? null : Number(res.lastInsertRowid),\n };\n}\n\nexport async function queryOne(sql: string, args: unknown[] = []): Promise {\n const rows = await query(sql, args);\n return rows[0] ?? null;\n}\n\n// --- small coercions, because libsql hands back `unknown` -------------------\n\nexport function str(v: unknown): string | null {\n return v == null ? null : String(v);\n}\n\nexport function num(v: unknown): number {\n return Number(v ?? 0);\n}\n\nexport function bool(v: unknown): boolean {\n return Number(v ?? 0) !== 0;\n}\n\n/** Normalised key used to match \"Netflix \", \"netflix\" and \"NETFLIX\" to one service. */\nexport function nameKey(name: string): string {\n return name.trim().toLowerCase().replace(/\\s+/g, \" \");\n}\n\n// --- settings ---------------------------------------------------------------\n\nexport async function getSetting(key: string): Promise {\n const row = await queryOne(\"SELECT value FROM settings WHERE key = ?\", [key]);\n return row ? str(row.value) : null;\n}\n\nexport async function setSetting(key: string, value: string): Promise {\n await exec(\n \"INSERT INTO settings (key, value) VALUES (?, ?) ON CONFLICT(key) DO UPDATE SET value = excluded.value\",\n [key, value],\n );\n}\n",[],[164,249],"fa5b6689-ec81-4372-b6f9-215fd851817c","email","d1f39aa4-a639-11f1-b6a1-1607ee4eb77e",4,["D",1788290269074],[],[164,257],["D",1788290265322],[181,182,183],[164],["D",1788290256185],["D",1789509043237],{"_99":98,"_106":-5},{"_99":98,"_100":101,"_102":-5,"_18":-5,"_103":104,"_105":24},{"_13":88,"_31":89,"_42":41,"_90":43,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":44,"_97":98},"ctx",{"_81":-5,"_126":304,"_305":306,"_307":308,"_309":24,"_310":24,"_311":24,"_312":58,"_313":-5,"_314":-7,"_315":-7,"_316":62,"_317":24,"_318":24,"_319":-5,"_320":24,"_321":24,"_322":24,"_323":-5},"ENV",{"_275":276,"_277":278,"_279":89,"_280":281,"_282":283,"_284":285,"_286":287,"_288":289,"_290":291,"_292":293,"_294":295,"_296":297,"_298":299,"_300":301,"_302":303},"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 · v13