[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_112":113,"_114":115},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","xdv","name","subscriptions-feedback","path","backend/fx.ts","project",{"_22":48,"_11":12,"_35":49,"_50":-5,"_51":44,"_52":53,"_54":53,"_55":56,"_57":-5,"_58":59,"_60":61,"_62":34,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_75":-5,"_76":77,"_78":77,"_79":80,"_81":80,"_82":80,"_83":77,"_84":77,"_85":86,"_87":88,"_89":90,"_91":44},"file",{"_22":23,"_11":24,"_25":26,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":-5,"_13":46},"permalink","https://www.val.town/x/xdv/subscriptions-feedback/code/backend/fx.ts","extension","id","3f85b9c2-7001-4ece-9d9e-fa992e5de0a1","fx.ts","fileId","01a05e91-3c61-747c-96e4-541ad5aed82c","parentId","01a05e91-3c61-747c-96e4-6bafb8891850","branchId","3cb18c55-e6c7-42be-b35f-89b94db8140e","branchVersion",19,"latest",true,"createdAt",["D",1788302892448],"version",1,"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","deleted",false,"label",[47,24],"backend","9bc728ac-50f9-4071-a163-6ccfe685ce52",["D",1788292971385],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Subscription tracker — separate instance for colleague feedback","imageUrl","userId","5f1525c6-51a0-4c57-858d-f94f1e686d46","pinnedFileId","01a05e91-3c61-747c-96e4-e7f8845199ec","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a05e29-777a-77c1-a910-e4a1d8102a40","tursoName","9bc728ac50f94071a1636ccfe685ce52","tursoHostname","9bc728ac50f94071a1636ccfe685ce52-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789514495229],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_111":-5},"org",{"_9":10,"_105":106,"_107":-5,"_58":-5,"_108":109,"_110":44},"branch",{"_37":92,"_11":93,"_22":30,"_94":48,"_95":96,"_97":98,"_99":53,"_100":101,"_102":68,"_103":12,"_104":10},"isOwned",20,"main","projectId","forkedBranchId","723ee93a-6b67-428c-b3cc-6f9491011d78","forkedBranchVersion",60,"forkedProjectPrivacy","forkedProjectId","5588f200-1c41-400f-bf66-81f9f6ac0211","forkedProjectOrgId","projectName","userHandle","displayName","xd.ventures","avatar","tier","free","canRestrictVals","profileImageUrl","ctx",{"_85":-5,"_145":146,"_147":148,"_149":150,"_151":44,"_152":44,"_153":44,"_154":34,"_155":-5,"_156":-7,"_157":-7,"_158":66,"_159":44,"_160":44,"_161":-5,"_162":44,"_163":44,"_164":44,"_165":-5},"ENV",{"_116":117,"_118":119,"_120":93,"_121":122,"_123":124,"_125":126,"_127":128,"_129":130,"_131":132,"_133":134,"_135":136,"_137":138,"_139":140,"_141":142,"_143":144},"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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]