SplitTab

\n \n

\n );\n }\n\n if (view === \"auth\") {\n if (aMode === \"forgot\") {\n return (\n
\n
\n
\n \n
\n
Reset password
\n
We'll email you a reset link
\n
\n
\n setAForm((p) => ({ ...p, email: e.target.value }))}\n onKeyDown={(e) => e.key === \"Enter\" && doForgotPassword()} className={inputBase} autoFocus />\n {aErr &&
{aErr}
}\n {aMsg &&
{aMsg}
}\n \n \n
\n
\n );\n }\n\n if (aMode === \"reset\") {\n return (\n
\n
\n
\n \n
\n
Set new password
\n
Choose a new password for your account
\n
\n
\n setNewPassword(e.target.value)}\n onKeyDown={(e) => e.key === \"Enter\" && doResetPassword()} className={inputBase} autoFocus />\n {aErr &&
{aErr}
}\n {aMsg &&
{aMsg}
}\n \n
\n
\n );\n }\n\n return (\n
\n
\n
\n \n
\n
SplitTab
\n
Split bills smarter, settle trips faster
\n
\n
\n
\n {[\"login\", \"signup\"].map((m) => (\n \n ))}\n
\n
\n setAForm((p) => ({ ...p, username: e.target.value }))}\n onKeyDown={(e) => e.key === \"Enter\" && doAuth()} className={inputBase} autoFocus />\n {aMode === \"signup\" && (\n setAForm((p) => ({ ...p, email: e.target.value }))}\n onKeyDown={(e) => e.key === \"Enter\" && doAuth()} className={inputBase} />\n )}\n setAForm((p) => ({ ...p, password: e.target.value }))}\n onKeyDown={(e) => e.key === \"Enter\" && doAuth()} className={inputBase} />\n
\n {aErr &&
{aErr}
}\n \n {aMode === \"login\" && (\n \n )}\n {aMode === \"signup\" && (\n
\n By creating an account you agree to our Terms and Privacy Policy.\n
\n )}\n
\n
\n view source\n
\n
\n );\n }\n\n if (view === \"home\") {\n return (\n
\n
\n
\n
Your groups
\n
Hi, {sess.username}
\n
\n \n
\n\n {usage && usage.maxGroups !== null && (\n
\n {usage.groups}/{usage.maxGroups} groups · {usage.scansThisMonth}/{usage.maxScansPerMonth} scans this month\n \n
\n )}\n {usage && usage.maxGroups === null && (\n
\n SplitTab Pro — unlimited groups & scans\n \n
\n )}\n\n {groups.length === 0 && !showCreate && !showJoin && (\n
\n \n
No groups yet
\n
Create one for your trip, or join with an invite code
\n
\n )}\n\n {groups.map((g, i) => {\n const spent = (g.expenses || []).reduce((s: number, e: any) => s + e.totalAmount, 0);\n const c = clr(i);\n return (\n
openGroup(g)}\n className={`${cardBase} px-4 py-3.5 mb-2 cursor-pointer flex items-center gap-3 hover:border-gray-300`}>\n
\n \n
\n
\n
{g.name}
\n
\n {g.members?.length || 1} member{(g.members?.length || 1) !== 1 ? \"s\" : \"\"} · {g.expenses?.length || 0} expense{(g.expenses?.length || 0) !== 1 ? \"s\" : \"\"}\n
\n
\n
\n
{g.currency}{spent.toFixed(2)}
\n
total spent
\n
\n
\n );\n })}\n\n {showCreate && (\n
\n
New group
\n setNewGrp((p) => ({ ...p, name: e.target.value }))}\n onKeyDown={(e) => e.key === \"Enter\" && doCreateGroup()} className={`${inputBase} mb-2`} autoFocus />\n
\n {[\"€\", \"$\", \"£\", \"¥\", \"kr\"].map((c) => (\n \n ))}\n
\n
\n \n \n
\n
\n )}\n\n {showJoin && (\n
\n
Join with invite code
\n
\n setJoinCode(e.target.value.toUpperCase())}\n onKeyDown={(e) => e.key === \"Enter\" && doJoinGroup()}\n maxLength={6} className={`flex-1 font-mono tracking-widest uppercase ${inputBase}`} autoFocus />\n \n \n
\n
\n )}\n\n {!showCreate && !showJoin && (\n
0 ? \"mt-4\" : \"\"}`}>\n \n \n
\n )}\n
\n );\n }\n\n if (view === \"group\" && grp) {\n const { txs, bal } = computeSettlement(grp.expenses || [], grp.members || []);\n const myBal = Math.round((bal[sess.id] || 0) * 100) / 100;\n\n return (\n
\n
\n \n
{grp.name}
\n \n
\n\n {(grp.expenses || []).length > 0 && (\n
0 ? \"bg-emerald-50 border-emerald-400\" : myBal < 0 ? \"bg-orange-50 border-orange-400\" : \"bg-gray-50 border-gray-200\"}`}>\n Your balance\n 0 ? \"text-emerald-700\" : myBal < 0 ? \"text-orange-800\" : \"text-gray-400\"}`}>\n {myBal > 0 ? `+${fmtC(myBal)} — you are owed` : myBal < 0 ? `-${fmtC(myBal)} — you owe` : \"All even ✓\"}\n \n
\n )}\n\n
\n {[\n { key: \"expenses\", icon: \"ti-list\", label: `Expenses${(grp.expenses?.length || 0) > 0 ? ` (${grp.expenses.length})` : \"\"}` },\n { key: \"settle\", icon: \"ti-arrows-exchange\", label: `Settle up${txs.length > 0 ? ` (${txs.length})` : \"\"}` },\n { key: \"members\", icon: \"ti-users\", label: `Members (${grp.members?.length || 1})` },\n ].map((t) => (\n \n ))}\n
\n\n {tab === \"expenses\" && (\n <>\n \n {(grp.expenses || []).length === 0 ? (\n
\n \n
No expenses yet — add the first one!
\n
\n ) : (\n
\n {[...(grp.expenses || [])].reverse().map((exp: any) => {\n const payer = getMember(exp.paidBy);\n const c = clr(getMemberIdx(exp.paidBy));\n return (\n
\n
\n
{exp.title}
\n
\n \n {payer?.username || \"?\"}\n \n paid · {dateFmt(exp.date)}\n
\n
\n
\n
{fmtC(exp.totalAmount)}
\n
{exp.items?.length || 0} item{(exp.items?.length || 0) !== 1 ? \"s\" : \"\"}
\n
\n {exp.createdBy === sess.id && (\n \n )}\n
\n );\n })}\n
\n )}\n \n )}\n\n {tab === \"settle\" && (\n <>\n {(grp.expenses || []).length === 0 ? (\n
Add some expenses first to see the settlement.
\n ) : (\n <>\n
\n
Net balances
\n {(grp.members || []).map((m: any, i: number) => {\n const b = Math.round((bal[m.id] || 0) * 100) / 100;\n const c = clr(i);\n return (\n
\n
\n {ini(m.username)}\n
\n \n {m.username}{m.id === sess.id ? \" (you)\" : \"\"}\n \n 0 ? \"text-emerald-700\" : b < 0 ? \"text-orange-800\" : \"text-gray-400\"}`}>\n {b > 0 ? \"+\" : b < 0 ? \"-\" : \"\"}{ccy}{Math.abs(b).toFixed(2)}\n \n
\n );\n })}\n
\n\n {txs.length === 0 ? (\n
\n \n
All settled up! 🎉
\n
Everyone is even
\n
\n ) : (\n <>\n
\n Minimum {txs.length} payment{txs.length !== 1 ? \"s\" : \"\"} to settle everything\n
\n
\n {txs.map((tx, i) => {\n const fromM = getMember(tx.from);\n const toM = getMember(tx.to);\n const fromC = clr(getMemberIdx(tx.from));\n const toC = clr(getMemberIdx(tx.to));\n const isMyDebt = tx.from === sess.id;\n const isMyCred = tx.to === sess.id;\n return (\n
\n
\n {ini(fromM?.username)}\n
\n
\n {fromM?.username || \"?\"}{isMyDebt ? \" (you)\" : \"\"} pays {toM?.username || \"?\"}{isMyCred ? \" (you)\" : \"\"}\n
\n
\n {ini(toM?.username)}\n
\n \n {fmtC(tx.amount)}\n \n
\n );\n })}\n
\n
Debts are automatically simplified — cross-payments cancel each other out
\n \n )}\n \n )}\n \n )}\n\n {tab === \"members\" && (\n
\n {(grp.members || []).map((m: any, i: number) => {\n const c = clr(i);\n return (\n
\n
\n {ini(m.username)}\n
\n \n {m.username}{m.id === sess.id ? \" (you)\" : \"\"}\n \n {i === 0 && Creator}\n
\n );\n })}\n
\n
Invite others
\n
Share this code — others can join from the home screen
\n
\n \n {grp.inviteCode}\n \n \n
\n
\n
\n )}\n
\n );\n }\n\n if (view === \"add-expense\" && grp) {\n if (eStep === 1) return (\n
\n
\n \n
New expense
\n
\n What was this for?\n setEInfo((p: any) => ({ ...p, title: e.target.value }))}\n className={`${inputBase} mb-5`} autoFocus />\n Who paid?\n
\n {grp.members.map((m: any, i: number) => {\n const c = clr(i);\n const sel = eInfo.paidBy === m.id;\n return (\n \n );\n })}\n
\n \n
\n );\n\n if (eStep === 2) return (\n
\n
\n \n
Add items
\n
\n\n { e.preventDefault(); setDragOver(true); }}\n onDragLeave={() => setDragOver(false)}\n onDrop={(e) => { e.preventDefault(); setDragOver(false); const f = e.dataTransfer.files[0]; if (f) scanReceipt(f); }}\n onClick={() => !eScan && fileRef.current?.click()}\n className={`border-2 border-dashed rounded-xl p-6 text-center mb-4 transition-colors ${\n eScan ? \"cursor-wait\" : \"cursor-pointer\"} ${dragOver ? \"border-orange-500 bg-orange-50\" : \"border-gray-300 bg-gray-50\"}`}>\n {eScan ? (\n <>\n \n
Scanning & translating…
\n
Extracting items from the receipt
\n \n ) : (\n <>\n \n
Upload receipt photo
\n
Auto-extracts items · translates to English if needed
\n \n )}\n
\n { const f = e.target.files?.[0]; if (f) scanReceipt(f); }} />\n\n {eErr && (\n
\n {eErr}\n
\n )}\n\n
\n
\n Items {eItems.length > 0 && ({eItems.length})}\n
\n {eItems.length > 0 && {ccy}{eTotal.toFixed(2)}}\n
\n\n {eItems.length > 0 && (\n
\n {eItems.map((item, i) => (\n
\n setEItems((p) => p.map((it) => (it.id === item.id ? { ...it, name: e.target.value } : it)))}\n className=\"flex-1 border-none px-1 py-0.5 text-sm bg-transparent outline-none\" />\n {ccy}\n setEItems((p) => p.map((it) => (it.id === item.id ? { ...it, price: Math.round(parseFloat(e.target.value) * 100) / 100 || 0 } : it)))}\n className=\"w-14 border-none text-right px-0.5 py-0.5 text-sm font-mono bg-transparent outline-none\" min=\"0\" step=\"0.01\" />\n \n
\n ))}\n
\n )}\n\n
\n setMItem((p) => ({ ...p, name: e.target.value }))}\n onKeyDown={(e) => e.key === \"Enter\" && addManualItem()} className={`flex-1 ${inputBase}`} />\n
\n {ccy}\n setMItem((p) => ({ ...p, price: e.target.value }))}\n onKeyDown={(e) => e.key === \"Enter\" && addManualItem()}\n className=\"w-14 border-none outline-none px-0.5 py-1 text-sm font-mono bg-transparent\" min=\"0\" step=\"0.01\" />\n
\n \n
\n\n \n \n );\n\n if (eStep === 3) return (\n
\n
\n \n
Who had what?
\n
\n
Tap names to toggle. Multiple people can share one item.
\n\n
\n {eItems.map((item) => {\n const assigned = eAssign[item.id] || [];\n const perPerson = assigned.length > 0 ? item.price / assigned.length : 0;\n const allSel = assigned.length === grp.members.length;\n return (\n
\n
\n {item.name}\n
\n {fmtC(item.price)}\n {assigned.length > 1 &&
{fmtC(perPerson)} each
}\n
\n
\n
\n {grp.members.map((m: any, i: number) => {\n const c = clr(i);\n const isOn = assigned.includes(m.id);\n return (\n \n );\n })}\n \n
\n {assigned.length === 0 &&
No one assigned
}\n
\n );\n })}\n
\n\n
\n
This expense: {fmtC(eTotal)} total
\n
\n {grp.members.map((m: any, i: number) => {\n const c = clr(i);\n let share = 0;\n eItems.forEach((it) => { const as = eAssign[it.id] || []; if (as.includes(m.id)) share += it.price / as.length; });\n return (\n
\n
\n {ini(m.username)}\n
\n {m.username}\n {fmtC(share)}\n
\n );\n })}\n
\n
\n\n \n
\n );\n }\n\n return null;\n}\n",[19,69],"2b8d6bc0-9601-4c41-8a24-ab432de5c747",4,["D",1787221202545],"directory",[19],{"_36":110,"_13":111,"_39":112,"_41":-5,"_43":44,"_45":64,"_47":48,"_49":113,"_17":51,"_52":79,"_53":-5,"_55":56,"_57":-5,"_92":114,"_18":115},{"_36":76,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":77,"_47":48,"_49":95,"_17":51,"_52":79,"_53":-5,"_55":56,"_57":-5,"_92":96,"_18":97},{"_36":84,"_13":85,"_39":86,"_41":-5,"_43":44,"_45":87,"_47":48,"_49":88,"_17":89,"_52":90,"_53":91,"_55":56,"_57":-5,"_92":93,"_18":94},"c4f397f5-cf96-4a30-9d3e-56543ba2d0b8","main.tsx","b19384da-9c80-11f1-9efb-1607ee4eb77e",53,["D",1787487023261],5,"http","import { Hono } from \"npm:hono\";\nimport { parseVal, serveFile, serveImmutableFile, immutableFileUrl } from \"https://esm.town/v/std/utils/index.ts\";\nimport { initDb } from \"./backend/db.ts\";\nimport api from \"./backend/routes.ts\";\n\nawait initDb();\n\nconst app = new Hono();\n\napp.route(\"/api\", api);\n\napp.get(\"/\", (c) => c.html(`\n\n\n \n \n SplitTab\n \n \n \n \n \n \n \n \n \n \n \n \n\n\n
\n \n \n\n`));\n\napp.get(\"/manifest.json\", (c) => {\n c.header(\"Content-Type\", \"application/manifest+json\");\n return c.body(JSON.stringify({\n name: \"SplitTab\",\n short_name: \"SplitTab\",\n description: \"Split bills smarter, settle trips faster\",\n start_url: \"/\",\n scope: \"/\",\n display: \"standalone\",\n background_color: \"#FFFFFF\",\n theme_color: \"#D85A30\",\n orientation: \"portrait\",\n icons: [\n { src: \"/icon.svg\", sizes: \"any\", type: \"image/svg+xml\", purpose: \"any\" },\n { src: \"/icon-maskable.svg\", sizes: \"any\", type: \"image/svg+xml\", purpose: \"maskable\" },\n ],\n }));\n});\n\nconst ICON_SVG = ``;\n\nconst ICON_MASKABLE_SVG = ``;\n\napp.get(\"/icon.svg\", (c) => { c.header(\"Content-Type\", \"image/svg+xml\"); return c.body(ICON_SVG); });\napp.get(\"/icon-maskable.svg\", (c) => { c.header(\"Content-Type\", \"image/svg+xml\"); return c.body(ICON_MASKABLE_SVG); });\n\napp.get(\"/sw.js\", (c) => {\n c.header(\"Content-Type\", \"application/javascript\");\n return c.body(`\n const CACHE = \"splittab-v1\";\n self.addEventListener(\"install\", (e) => { self.skipWaiting(); });\n self.addEventListener(\"activate\", (e) => { self.clients.claim(); });\n // Network-first: always try the network (this is a live app), fall back to cache only if offline.\n self.addEventListener(\"fetch\", (e) => {\n if (e.request.method !== \"GET\") return;\n e.respondWith(\n fetch(e.request).then((res) => {\n const copy = res.clone();\n caches.open(CACHE).then((c) => c.put(e.request, copy));\n return res;\n }).catch(() => caches.match(e.request))\n );\n });\n `);\n});\n\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\nconst legalPage = (title: string, bodyHtml: string) => `\n\n${title} — SplitTab\n\n\n← Back to SplitTab\n
${bodyHtml}
\n`;\n\napp.get(\"/privacy\", (c) => c.html(legalPage(\"Privacy Policy\", `\n
Privacy Policy — SplitTab
\n
Last updated: [DATE]
\n
1. Who is responsible for your data
\n
SplitTab is operated by [Your name or legal entity], based in [City, Netherlands]. Contact: [your-email@example.com].
\n
2. What we collect
\n
Username, email, password (hashed); group names, invite codes, and membership; expense titles, amounts, item names, who paid and who's assigned; receipt photos are sent to Google's Gemini API for scanning and are not stored afterward; session tokens; IP address is used only in-memory to rate-limit login attempts.
\n
3. Legal basis
\n
Processing is necessary to provide the service you signed up for (performance of a contract), and session/rate-limit data relies on our legitimate interest in keeping the service secure.
\n
4. Who else sees your data
\n
Google (Gemini API) for receipt scanning, and Val Town for hosting and database infrastructure. We do not sell your data or share it with advertisers.
\n
5. Your rights
\n
Under GDPR you can access, correct, delete, or export your data, object to processing, and complain to the Autoriteit Persoonsgegevens. Contact [your-email@example.com] to exercise these rights.
\n
6. Cookies
\n
We store a session token in your browser's local storage to keep you logged in. No tracking cookies or third-party analytics are used.
\n
This is a draft. Full text with all sections is available in your project files — replace the [bracketed] placeholders before relying on this publicly.
\n`)));\n\napp.get(\"/terms\", (c) => c.html(legalPage(\"Terms of Service\", `\n
Terms of Service — SplitTab
\n
Last updated: [DATE]
\n
1. What SplitTab is
\n
SplitTab helps groups track shared expenses and calculates who owes whom. SplitTab does not process payments or move money between users — settling up happens outside the app, by whatever method you agree on.
\n
2. Your account
\n
You're responsible for your password and account activity. You must provide a valid email and be at least 16 years old. One account per person.
\n
3. Receipt scanning
\n
Photos you upload are sent to a third-party AI service (Google Gemini) for extraction. We don't guarantee accuracy — review scanned items before saving.
\n
4. No liability for financial disputes
\n
We are not responsible for incorrect entries, disputes between users about who owes what, or financial loss from reliance on the app's calculations.
\n
5. Governing law
\n
These terms are governed by the laws of the Netherlands. Disputes are handled by the competent court in [your city].
\n
This is a draft. Full text with all sections is available in your project files — replace the [bracketed] placeholders before relying on this publicly.
\n`)));\n\napp.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path));\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\n\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","children",[],[85],["D",1787221202545],[98,99,100],[19],{"_36":68,"_13":69,"_39":70,"_41":42,"_43":44,"_45":71,"_47":48,"_49":107,"_17":73,"_52":65,"_53":74,"_55":56,"_57":-5,"_92":108,"_18":109},{"_36":59,"_13":60,"_39":61,"_41":42,"_43":44,"_45":62,"_47":48,"_49":104,"_17":64,"_52":65,"_53":66,"_55":56,"_57":-5,"_92":105,"_18":106},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":101,"_17":51,"_52":24,"_53":54,"_55":56,"_57":-5,"_92":102,"_18":103},["D",1787486993748],[],[19,38],["D",1787221487625],[],[19,60],["D",1787404315466],[],[19,69],"6e8cc8d4-4f31-4636-aaf7-92b99311ade0","backend","a9a6b58a-2656-4264-815f-80df2ed2f808",["D",1787221159123],[116,117],[111],{"_36":127,"_13":128,"_39":129,"_41":112,"_43":44,"_45":130,"_47":48,"_49":131,"_17":62,"_52":65,"_53":132,"_55":56,"_57":-5,"_92":133,"_18":134},{"_36":118,"_13":119,"_39":120,"_41":112,"_43":44,"_45":121,"_47":48,"_49":122,"_17":123,"_52":65,"_53":124,"_55":56,"_57":-5,"_92":125,"_18":126},"98f42bae-35a2-4278-b0fe-d5ecad778882","routes.ts","ad907758-9c80-11f1-a9f0-1607ee4eb77e",46,["D",1787404289620],16,"import { Hono } from \"npm:hono\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { email as sendEmail } from \"https://esm.town/v/std/email\";\n// @ts-ignore\nimport Stripe from \"npm:stripe\";\nimport {\n uid, hashPassword, verifyPassword, createSession, getValidSession,\n isValidEmail, createPasswordReset, consumePasswordReset,\n getUserPlan, countUserGroups, countScansThisMonth, recordScan, PLAN_LIMITS,\n} from \"./db.ts\";\n\nconst stripe = Deno.env.get(\"STRIPE_SECRET_KEY\") ? new Stripe(Deno.env.get(\"STRIPE_SECRET_KEY\")!) : null;\n\nconst api = new Hono();\n\n// ---- auth helpers ----\nasync function getSession(c: any) {\n const token = c.req.header(\"Authorization\")?.replace(\"Bearer \", \"\");\n if (!token) return null;\n const userId = await getValidSession(token);\n if (!userId) return null;\n const u = await sqlite.execute({ sql: \"SELECT id, username FROM users WHERE id = ?\", args: [userId] });\n return u.rows[0] || null;\n}\n\nasync function requireAuth(c: any, next: any) {\n const user = await getSession(c);\n if (!user) return c.json({ error: \"Not authenticated\" }, 401);\n c.set(\"user\", user);\n await next();\n}\n\n// ---- simple in-memory rate limiting ----\n// Note: resets on redeploy/restart; fine as a first line of defense against bots and brute force.\nconst rateBuckets = new Map();\nfunction rateLimit(bucket: string, key: string, max: number, windowMs: number) {\n const k = `${bucket}:${key}`;\n const now = Date.now();\n const entry = rateBuckets.get(k);\n if (!entry || entry.resetAt < now) {\n rateBuckets.set(k, { count: 1, resetAt: now + windowMs });\n return true;\n }\n if (entry.count >= max) return false;\n entry.count++;\n return true;\n}\nfunction clientIp(c: any) {\n return c.req.header(\"x-forwarded-for\")?.split(\",\")[0].trim() || c.req.header(\"cf-connecting-ip\") || \"unknown\";\n}\nasync function rateLimited(c: any, next: any) {\n const bucket = c.req.path;\n if (!rateLimit(bucket, clientIp(c), 10, 60_000)) {\n return c.json({ error: \"Too many attempts, try again shortly.\" }, 429);\n }\n await next();\n}\n\n// ---- auth ----\napi.post(\"/signup\", rateLimited, async (c) => {\n const { username, email, password } = await c.req.json();\n if (!username?.trim() || !email?.trim() || !password?.trim()) return c.json({ error: \"Fill in all fields.\" }, 400);\n if (!isValidEmail(email.trim())) return c.json({ error: \"Enter a valid email address.\" }, 400);\n if (password.length < 8) return c.json({ error: \"Password must be at least 8 characters.\" }, 400);\n const existingUsername = await sqlite.execute({\n sql: \"SELECT id FROM users WHERE LOWER(username) = LOWER(?)\",\n args: [username.trim()],\n });\n if (existingUsername.rows.length > 0) return c.json({ error: \"Username already taken.\" }, 400);\n const existingEmail = await sqlite.execute({\n sql: \"SELECT id FROM users WHERE LOWER(email) = LOWER(?)\",\n args: [email.trim()],\n });\n if (existingEmail.rows.length > 0) return c.json({ error: \"An account with this email already exists.\" }, 400);\n const id = uid();\n const hash = await hashPassword(password);\n await sqlite.execute({\n sql: \"INSERT INTO users (id, username, email, password_hash, created_at) VALUES (?, ?, ?, ?, ?)\",\n args: [id, username.trim(), email.trim().toLowerCase(), hash, Date.now()],\n });\n const token = await createSession(id);\n return c.json({ token, user: { id, username: username.trim() } });\n});\n\napi.post(\"/login\", rateLimited, async (c) => {\n const { username, password } = await c.req.json();\n if (!username?.trim() || !password?.trim()) return c.json({ error: \"Fill in all fields.\" }, 400);\n const res = await sqlite.execute({\n sql: \"SELECT id, username, password_hash FROM users WHERE LOWER(username) = LOWER(?)\",\n args: [username.trim()],\n });\n if (res.rows.length === 0) return c.json({ error: \"Wrong username or password.\" }, 401);\n const row = res.rows[0] as any;\n const ok = await verifyPassword(password, row.password_hash);\n if (!ok) return c.json({ error: \"Wrong username or password.\" }, 401);\n // transparently upgrade any legacy SHA-256 hash to bcrypt now that we have the plaintext\n if (/^[a-f0-9]{64}$/i.test(row.password_hash)) {\n const upgraded = await hashPassword(password);\n await sqlite.execute({ sql: \"UPDATE users SET password_hash = ? WHERE id = ?\", args: [upgraded, row.id] });\n }\n const token = await createSession(row.id);\n return c.json({ token, user: { id: row.id, username: row.username } });\n});\n\napi.post(\"/forgot-password\", rateLimited, async (c) => {\n const { email } = await c.req.json();\n if (!email?.trim()) return c.json({ error: \"Enter your email.\" }, 400);\n const res = await sqlite.execute({\n sql: \"SELECT id, username FROM users WHERE LOWER(email) = LOWER(?)\",\n args: [email.trim()],\n });\n // Always return success, whether or not the email exists — avoids leaking which emails are registered.\n if (res.rows.length > 0) {\n const row = res.rows[0] as any;\n const token = await createPasswordReset(row.id);\n const resetUrl = `${new URL(c.req.url).origin}/?reset=${token}`;\n try {\n await sendEmail({\n to: email.trim(),\n subject: \"Reset your SplitTab password\",\n text: `Hi ${row.username},\\n\\nSomeone requested a password reset for your SplitTab account. If this was you, click the link below within the next hour:\\n\\n${resetUrl}\\n\\nIf you didn't request this, you can ignore this email.`,\n });\n } catch { /* don't leak email delivery failures to the client */ }\n }\n return c.json({ ok: true });\n});\n\napi.post(\"/reset-password\", rateLimited, async (c) => {\n const { token, password } = await c.req.json();\n if (!token || !password?.trim()) return c.json({ error: \"Missing token or password.\" }, 400);\n if (password.length < 8) return c.json({ error: \"Password must be at least 8 characters.\" }, 400);\n const userId = await consumePasswordReset(token);\n if (!userId) return c.json({ error: \"This reset link is invalid or has expired.\" }, 400);\n const hash = await hashPassword(password);\n await sqlite.execute({ sql: \"UPDATE users SET password_hash = ? WHERE id = ?\", args: [hash, userId] });\n // invalidate all existing sessions for this user as a safety measure\n await sqlite.execute({ sql: \"DELETE FROM sessions WHERE user_id = ?\", args: [userId] });\n return c.json({ ok: true });\n});\n\napi.post(\"/logout\", requireAuth, async (c) => {\n const token = c.req.header(\"Authorization\")?.replace(\"Bearer \", \"\");\n await sqlite.execute({ sql: \"DELETE FROM sessions WHERE token = ?\", args: [token] });\n return c.json({ ok: true });\n});\n\napi.get(\"/me\", requireAuth, async (c) => {\n const user = c.get(\"user\") as any;\n const plan = await getUserPlan(user.id);\n const groupCount = await countUserGroups(user.id);\n const scansThisMonth = await countScansThisMonth(user.id);\n const limits = PLAN_LIMITS[plan];\n return c.json({\n user, plan,\n usage: {\n groups: groupCount, maxGroups: limits.maxGroups === Infinity ? null : limits.maxGroups,\n scansThisMonth, maxScansPerMonth: limits.maxScansPerMonth === Infinity ? null : limits.maxScansPerMonth,\n },\n });\n});\n\n// ---- groups ----\nasync function fullGroup(groupId: string) {\n const g = await sqlite.execute({ sql: \"SELECT * FROM groups WHERE id = ?\", args: [groupId] });\n if (g.rows.length === 0) return null;\n const group = g.rows[0] as any;\n const members = await sqlite.execute({\n sql: `SELECT u.id, u.username FROM group_members gm\n JOIN users u ON u.id = gm.user_id WHERE gm.group_id = ? ORDER BY gm.joined_at ASC`,\n args: [groupId],\n });\n const expenses = await sqlite.execute({\n sql: \"SELECT * FROM expenses WHERE group_id = ? ORDER BY created_at ASC\",\n args: [groupId],\n });\n const expensesFull = await Promise.all(expenses.rows.map(async (e: any) => {\n const items = await sqlite.execute({ sql: \"SELECT * FROM expense_items WHERE expense_id = ?\", args: [e.id] });\n return {\n id: e.id, title: e.title, paidBy: e.paid_by, totalAmount: e.total_amount,\n createdBy: e.created_by, date: e.created_at,\n items: items.rows.map((it: any) => ({\n id: it.id, name: it.name, price: it.price, assigned: JSON.parse(it.assigned_to || \"[]\"),\n })),\n };\n }));\n return {\n id: group.id, name: group.name, currency: group.currency, inviteCode: group.invite_code,\n memberIds: members.rows.map((m: any) => m.id),\n members: members.rows.map((m: any) => ({ id: m.id, username: m.username })),\n expenses: expensesFull, createdAt: group.created_at,\n };\n}\n\napi.get(\"/groups\", requireAuth, async (c) => {\n const user = c.get(\"user\") as any;\n const res = await sqlite.execute({\n sql: `SELECT g.id FROM groups g JOIN group_members gm ON gm.group_id = g.id WHERE gm.user_id = ?`,\n args: [user.id],\n });\n const groups = await Promise.all(res.rows.map((r: any) => fullGroup(r.id)));\n return c.json({ groups: groups.filter(Boolean) });\n});\n\napi.post(\"/groups\", requireAuth, async (c) => {\n const user = c.get(\"user\") as any;\n const plan = await getUserPlan(user.id);\n const limits = PLAN_LIMITS[plan];\n const groupCount = await countUserGroups(user.id);\n if (groupCount >= limits.maxGroups) {\n return c.json({ error: `Free plan is limited to ${limits.maxGroups} active groups. Upgrade to Pro for unlimited groups.`, code: \"LIMIT_REACHED\" }, 402);\n }\n const { name, currency } = await c.req.json();\n if (!name?.trim()) return c.json({ error: \"Name required.\" }, 400);\n const id = uid();\n const inviteCode = Math.random().toString(36).slice(2, 8).toUpperCase();\n const now = Date.now();\n await sqlite.batch([\n {\n sql: \"INSERT INTO groups (id, name, currency, invite_code, created_by, created_at) VALUES (?, ?, ?, ?, ?, ?)\",\n args: [id, name.trim(), currency || \"€\", inviteCode, user.id, now],\n },\n { sql: \"INSERT INTO group_members (group_id, user_id, joined_at) VALUES (?, ?, ?)\", args: [id, user.id, now] },\n ]);\n return c.json({ group: await fullGroup(id) });\n});\n\napi.post(\"/groups/join\", requireAuth, rateLimited, async (c) => {\n const user = c.get(\"user\") as any;\n const plan = await getUserPlan(user.id);\n const limits = PLAN_LIMITS[plan];\n const groupCount = await countUserGroups(user.id);\n if (groupCount >= limits.maxGroups) {\n return c.json({ error: `Free plan is limited to ${limits.maxGroups} active groups. Upgrade to Pro for unlimited groups.`, code: \"LIMIT_REACHED\" }, 402);\n }\n const { code } = await c.req.json();\n const res = await sqlite.execute({ sql: \"SELECT id FROM groups WHERE invite_code = ?\", args: [(code || \"\").trim().toUpperCase()] });\n if (res.rows.length === 0) return c.json({ error: \"Group not found. Check the code.\" }, 404);\n const groupId = (res.rows[0] as any).id;\n const existing = await sqlite.execute({\n sql: \"SELECT 1 FROM group_members WHERE group_id = ? AND user_id = ?\",\n args: [groupId, user.id],\n });\n if (existing.rows.length > 0) return c.json({ error: \"You're already in this group!\" }, 400);\n await sqlite.execute({\n sql: \"INSERT INTO group_members (group_id, user_id, joined_at) VALUES (?, ?, ?)\",\n args: [groupId, user.id, Date.now()],\n });\n return c.json({ group: await fullGroup(groupId) });\n});\n\napi.get(\"/groups/:id\", requireAuth, async (c) => {\n const user = c.get(\"user\") as any;\n const groupId = c.req.param(\"id\");\n const member = await sqlite.execute({\n sql: \"SELECT 1 FROM group_members WHERE group_id = ? AND user_id = ?\",\n args: [groupId, user.id],\n });\n if (member.rows.length === 0) return c.json({ error: \"Not a member of this group.\" }, 403);\n const group = await fullGroup(groupId);\n if (!group) return c.json({ error: \"Group not found.\" }, 404);\n return c.json({ group });\n});\n\n// ---- expenses ----\napi.post(\"/groups/:id/expenses\", requireAuth, async (c) => {\n const user = c.get(\"user\") as any;\n const groupId = c.req.param(\"id\");\n const member = await sqlite.execute({\n sql: \"SELECT 1 FROM group_members WHERE group_id = ? AND user_id = ?\",\n args: [groupId, user.id],\n });\n if (member.rows.length === 0) return c.json({ error: \"Not a member of this group.\" }, 403);\n const { title, paidBy, items } = await c.req.json();\n if (!Array.isArray(items) || items.length === 0) return c.json({ error: \"At least one item required.\" }, 400);\n const total = Math.round(items.reduce((s: number, i: any) => s + (Number(i.price) || 0), 0) * 100) / 100;\n const expenseId = uid();\n const now = Date.now();\n const statements = [\n {\n sql: \"INSERT INTO expenses (id, group_id, title, paid_by, total_amount, created_by, created_at) VALUES (?, ?, ?, ?, ?, ?, ?)\",\n args: [expenseId, groupId, (title || \"Expense\").trim(), paidBy, total, user.id, now],\n },\n ...items.map((it: any) => ({\n sql: \"INSERT INTO expense_items (id, expense_id, name, price, assigned_to) VALUES (?, ?, ?, ?, ?)\",\n args: [uid(), expenseId, it.name, Math.round((Number(it.price) || 0) * 100) / 100, JSON.stringify(it.assigned || [])],\n })),\n ];\n await sqlite.batch(statements);\n return c.json({ group: await fullGroup(groupId) });\n});\n\napi.delete(\"/groups/:id/expenses/:expId\", requireAuth, async (c) => {\n const user = c.get(\"user\") as any;\n const groupId = c.req.param(\"id\");\n const expId = c.req.param(\"expId\");\n const exp = await sqlite.execute({ sql: \"SELECT created_by FROM expenses WHERE id = ? AND group_id = ?\", args: [expId, groupId] });\n if (exp.rows.length === 0) return c.json({ error: \"Expense not found.\" }, 404);\n if ((exp.rows[0] as any).created_by !== user.id) return c.json({ error: \"Only the creator can delete this.\" }, 403);\n await sqlite.batch([\n { sql: \"DELETE FROM expense_items WHERE expense_id = ?\", args: [expId] },\n { sql: \"DELETE FROM expenses WHERE id = ?\", args: [expId] },\n ]);\n return c.json({ group: await fullGroup(groupId) });\n});\n\n// ---- receipt scanning (server-side, key never reaches the client) ----\napi.post(\"/scan-receipt\", requireAuth, async (c) => {\n const user = c.get(\"user\") as any;\n const plan = await getUserPlan(user.id);\n const limits = PLAN_LIMITS[plan];\n const scansThisMonth = await countScansThisMonth(user.id);\n if (scansThisMonth >= limits.maxScansPerMonth) {\n return c.json({ error: `Free plan is limited to ${limits.maxScansPerMonth} receipt scans per month. Upgrade to Pro for unlimited scans.`, code: \"LIMIT_REACHED\" }, 402);\n }\n const { imageBase64, mediaType } = await c.req.json();\n if (!imageBase64) return c.json({ error: \"No image provided.\" }, 400);\n const apiKey = Deno.env.get(\"GEMINI_API_KEY\");\n if (!apiKey) return c.json({ error: \"Server not configured for receipt scanning.\" }, 500);\n try {\n const res = await fetch(\n `https://generativelanguage.googleapis.com/v1beta/models/gemini-2.5-flash:generateContent`,\n {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"x-goog-api-key\": apiKey,\n },\n body: JSON.stringify({\n contents: [{\n parts: [\n { inline_data: { mime_type: mediaType || \"image/jpeg\", data: imageBase64 } },\n {\n text: \"Extract all ordered items from this receipt. If any item names are not in English, translate them to English. Return ONLY a raw JSON array with no markdown, no backticks, no preamble. Format: [{\\\"name\\\":\\\"Item name in English\\\",\\\"price\\\":0.00}]. List each item individually. Skip totals, subtotals, taxes, tips, service charges, and discounts.\",\n },\n ],\n }],\n generationConfig: { responseMimeType: \"application/json\" },\n }),\n },\n );\n const data = await res.json();\n if (data.error) throw new Error(data.error.message || \"Gemini API error\");\n const text = data.candidates?.[0]?.content?.parts?.[0]?.text?.trim() || \"\";\n const cleaned = text.replace(/```json\\n?|```\\n?/g, \"\").trim();\n const parsed = JSON.parse(cleaned);\n const items = parsed.map((it: any) => ({\n name: String(it.name || \"\").slice(0, 200),\n price: Math.round((parseFloat(it.price) || 0) * 100) / 100,\n }));\n await recordScan(user.id);\n return c.json({ items });\n } catch (e) {\n return c.json({ error: \"Could not read the receipt. Add items manually.\" }, 502);\n }\n});\n\n// ---- billing (Stripe) ----\napi.post(\"/billing/checkout\", requireAuth, async (c) => {\n const user = c.get(\"user\") as any;\n if (!stripe) return c.json({ error: \"Billing is not configured yet.\" }, 500);\n const priceId = Deno.env.get(\"STRIPE_PRICE_ID\");\n if (!priceId) return c.json({ error: \"Billing is not configured yet.\" }, 500);\n\n const row = (await sqlite.execute({ sql: \"SELECT email, stripe_customer_id FROM users WHERE id = ?\", args: [user.id] })).rows[0] as any;\n let customerId = row?.stripe_customer_id;\n if (!customerId) {\n const customer = await stripe.customers.create({ email: row?.email || undefined, metadata: { userId: user.id } });\n customerId = customer.id;\n await sqlite.execute({ sql: \"UPDATE users SET stripe_customer_id = ? WHERE id = ?\", args: [customerId, user.id] });\n }\n\n const origin = new URL(c.req.url).origin;\n const session = await stripe.checkout.sessions.create({\n customer: customerId,\n mode: \"subscription\",\n line_items: [{ price: priceId, quantity: 1 }],\n client_reference_id: user.id,\n metadata: { userId: user.id },\n success_url: `${origin}/?upgraded=1`,\n cancel_url: `${origin}/`,\n allow_promotion_codes: true,\n });\n return c.json({ url: session.url });\n});\n\napi.post(\"/billing/portal\", requireAuth, async (c) => {\n const user = c.get(\"user\") as any;\n if (!stripe) return c.json({ error: \"Billing is not configured yet.\" }, 500);\n const row = (await sqlite.execute({ sql: \"SELECT stripe_customer_id FROM users WHERE id = ?\", args: [user.id] })).rows[0] as any;\n if (!row?.stripe_customer_id) return c.json({ error: \"No billing account found.\" }, 400);\n const origin = new URL(c.req.url).origin;\n const session = await stripe.billingPortal.sessions.create({\n customer: row.stripe_customer_id,\n return_url: `${origin}/`,\n });\n return c.json({ url: session.url });\n});\n\n// Stripe webhook — no auth, verified via signature instead. Keep this route's\n// body untouched (no JSON-parsing middleware) since signature checking needs the raw text.\napi.post(\"/webhooks/stripe\", async (c) => {\n if (!stripe) return c.json({ error: \"Billing is not configured.\" }, 500);\n const webhookSecret = Deno.env.get(\"STRIPE_WEBHOOK_SECRET\");\n const signature = c.req.header(\"Stripe-Signature\");\n const body = await c.req.text();\n let event: any;\n try {\n event = await stripe.webhooks.constructEventAsync(body, signature!, webhookSecret!);\n } catch (err: any) {\n return c.json({ error: `Webhook signature verification failed: ${err.message}` }, 400);\n }\n\n try {\n switch (event.type) {\n case \"checkout.session.completed\": {\n const session = event.data.object;\n const userId = session.client_reference_id || session.metadata?.userId;\n if (userId) {\n await sqlite.execute({\n sql: \"UPDATE users SET plan = 'pro', stripe_subscription_id = ? WHERE id = ?\",\n args: [session.subscription, userId],\n });\n }\n break;\n }\n case \"customer.subscription.updated\":\n case \"customer.subscription.deleted\": {\n const sub = event.data.object;\n const isActive = sub.status === \"active\" || sub.status === \"trialing\";\n await sqlite.execute({\n sql: \"UPDATE users SET plan = ? WHERE stripe_customer_id = ?\",\n args: [isActive ? \"pro\" : \"free\", sub.customer],\n });\n break;\n }\n }\n } catch (err) {\n // Don't fail the webhook (Stripe will retry pointlessly) — log and move on.\n console.error(\"Stripe webhook handling error\", err);\n }\n\n return c.json({ received: true });\n});\n\nexport default api;\n",[],[111,119],"41f64663-09fd-4c41-9de5-b41c46d04e41","db.ts","9ac2f920-9c80-11f1-9834-1607ee4eb77e",44,["D",1787404269741],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport bcrypt from \"npm:bcryptjs\";\n\nexport async function initDb() {\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS users (\n id TEXT PRIMARY KEY,\n username TEXT UNIQUE NOT NULL,\n email TEXT UNIQUE,\n password_hash TEXT NOT NULL,\n plan TEXT NOT NULL DEFAULT 'free',\n stripe_customer_id TEXT,\n stripe_subscription_id TEXT,\n created_at INTEGER NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS groups (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n currency TEXT NOT NULL DEFAULT '€',\n invite_code TEXT UNIQUE NOT NULL,\n created_by TEXT NOT NULL,\n created_at INTEGER NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS group_members (\n group_id TEXT NOT NULL,\n user_id TEXT NOT NULL,\n joined_at INTEGER NOT NULL,\n PRIMARY KEY (group_id, user_id)\n )`,\n `CREATE TABLE IF NOT EXISTS expenses (\n id TEXT PRIMARY KEY,\n group_id TEXT NOT NULL,\n title TEXT NOT NULL,\n paid_by TEXT NOT NULL,\n total_amount REAL NOT NULL,\n created_by TEXT NOT NULL,\n created_at INTEGER NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS expense_items (\n id TEXT PRIMARY KEY,\n expense_id TEXT NOT NULL,\n name TEXT NOT NULL,\n price REAL NOT NULL,\n assigned_to TEXT NOT NULL DEFAULT '[]'\n )`,\n `CREATE TABLE IF NOT EXISTS sessions (\n token TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n created_at INTEGER NOT NULL,\n expires_at INTEGER NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS password_resets (\n token TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n created_at INTEGER NOT NULL,\n expires_at INTEGER NOT NULL,\n used INTEGER NOT NULL DEFAULT 0\n )`,\n `CREATE TABLE IF NOT EXISTS receipt_scans (\n id TEXT PRIMARY KEY,\n user_id TEXT NOT NULL,\n created_at INTEGER NOT NULL\n )`,\n ]);\n // migrate older tables that predate these columns\n try {\n await sqlite.execute(\"ALTER TABLE sessions ADD COLUMN expires_at INTEGER NOT NULL DEFAULT 0\");\n } catch { /* column already exists */ }\n try {\n await sqlite.execute(\"ALTER TABLE users ADD COLUMN email TEXT\");\n } catch { /* column already exists */ }\n try {\n await sqlite.execute(\"ALTER TABLE users ADD COLUMN plan TEXT NOT NULL DEFAULT 'free'\");\n } catch { /* column already exists */ }\n try {\n await sqlite.execute(\"ALTER TABLE users ADD COLUMN stripe_customer_id TEXT\");\n } catch { /* column already exists */ }\n try {\n await sqlite.execute(\"ALTER TABLE users ADD COLUMN stripe_subscription_id TEXT\");\n } catch { /* column already exists */ }\n}\n\n// ---- plan limits ----\nexport const PLAN_LIMITS = {\n free: { maxGroups: 2, maxScansPerMonth: 10 },\n pro: { maxGroups: Infinity, maxScansPerMonth: Infinity },\n} as const;\n\nexport async function getUserPlan(userId: string): Promise<\"free\" | \"pro\"> {\n const res = await sqlite.execute({ sql: \"SELECT plan FROM users WHERE id = ?\", args: [userId] });\n return (res.rows[0] as any)?.plan === \"pro\" ? \"pro\" : \"free\";\n}\n\nexport async function countUserGroups(userId: string): Promise {\n const res = await sqlite.execute({\n sql: \"SELECT COUNT(*) as n FROM group_members WHERE user_id = ?\",\n args: [userId],\n });\n return Number((res.rows[0] as any)?.n || 0);\n}\n\nexport async function countScansThisMonth(userId: string): Promise {\n const now = new Date();\n const monthStart = Date.UTC(now.getUTCFullYear(), now.getUTCMonth(), 1);\n const res = await sqlite.execute({\n sql: \"SELECT COUNT(*) as n FROM receipt_scans WHERE user_id = ? AND created_at >= ?\",\n args: [userId, monthStart],\n });\n return Number((res.rows[0] as any)?.n || 0);\n}\n\nexport async function recordScan(userId: string): Promise {\n await sqlite.execute({\n sql: \"INSERT INTO receipt_scans (id, user_id, created_at) VALUES (?, ?, ?)\",\n args: [uid(), userId, Date.now()],\n });\n}\n\nexport const uid = () => crypto.randomUUID();\n\nconst SESSION_TTL_MS = 30 * 24 * 60 * 60 * 1000; // 30 days\n\nexport async function hashPassword(password: string): Promise {\n return await bcrypt.hash(password, 10);\n}\n\nexport async function verifyPassword(password: string, hash: string): Promise {\n // Support old unsalted SHA-256 hashes (64 hex chars) from before the bcrypt migration,\n // so existing accounts aren't locked out; they get upgraded to bcrypt on next login.\n if (/^[a-f0-9]{64}$/i.test(hash)) {\n const data = new TextEncoder().encode(password);\n const digest = await crypto.subtle.digest(\"SHA-256\", data);\n const legacyHash = Array.from(new Uint8Array(digest)).map(b => b.toString(16).padStart(2, \"0\")).join(\"\");\n return legacyHash === hash;\n }\n return await bcrypt.compare(password, hash);\n}\n\nexport async function createSession(userId: string): Promise {\n const token = uid();\n const now = Date.now();\n await sqlite.execute({\n sql: \"INSERT INTO sessions (token, user_id, created_at, expires_at) VALUES (?, ?, ?, ?)\",\n args: [token, userId, now, now + SESSION_TTL_MS],\n });\n return token;\n}\n\nexport async function getValidSession(token: string) {\n const res = await sqlite.execute({\n sql: \"SELECT user_id, expires_at FROM sessions WHERE token = ?\",\n args: [token],\n });\n if (res.rows.length === 0) return null;\n const row = res.rows[0] as any;\n if (row.expires_at && row.expires_at < Date.now()) {\n await sqlite.execute({ sql: \"DELETE FROM sessions WHERE token = ?\", args: [token] });\n return null;\n }\n return row.user_id as string;\n}\n\nconst RESET_TTL_MS = 60 * 60 * 1000; // 1 hour\n\nexport function isValidEmail(email: string): boolean {\n return /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/.test(email);\n}\n\nexport async function createPasswordReset(userId: string): Promise {\n const token = uid();\n const now = Date.now();\n await sqlite.execute({\n sql: \"INSERT INTO password_resets (token, user_id, created_at, expires_at, used) VALUES (?, ?, ?, ?, 0)\",\n args: [token, userId, now, now + RESET_TTL_MS],\n });\n return token;\n}\n\nexport async function consumePasswordReset(token: string): Promise {\n const res = await sqlite.execute({\n sql: \"SELECT user_id, expires_at, used FROM password_resets WHERE token = ?\",\n args: [token],\n });\n if (res.rows.length === 0) return null;\n const row = res.rows[0] as any;\n if (row.used || row.expires_at < Date.now()) return null;\n await sqlite.execute({ sql: \"UPDATE password_resets SET used = 1 WHERE token = ?\", args: [token] });\n return row.user_id as string;\n}\n",[],[111,128],"cbe729ca-86bd-485c-9de3-dc5e67c71f71",["D",1787221101901],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Split bills and expenses with groups, receipt scanning","imageUrl","userId","9de9736c-cf5d-4d8f-8c52-9805e5a8bc38","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","01a01eac-cdd8-7258-a69b-0a59a72e22ba","tursoName","cbe729ca86bd485c9de3dc5e67c71f71","tursoHostname","cbe729ca86bd485c9de3dc5e67c71f71-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789479081816],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_192":188},"org",{"_11":12,"_185":186,"_187":188,"_145":146,"_189":190,"_191":56},"branch",{"_17":87,"_13":16,"_36":44,"_177":135,"_178":-5,"_179":-5,"_180":-5,"_181":-5,"_182":-5,"_183":14,"_184":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","F Haddad","avatar","https://lh3.googleusercontent.com/a/ACg8ocKWAFvWR5vFVvudBriPaQTEAgSOR2liRWlZCdoiZvdih_zDzE8z=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":135,"_13":14,"_49":253,"_137":-5,"_138":56,"_139":140,"_141":140,"_142":143,"_144":-5,"_145":146,"_147":86,"_148":48,"_149":-5,"_150":-5,"_151":51,"_152":153,"_154":155,"_156":157,"_158":254,"_160":-5,"_161":162,"_163":162,"_164":165,"_166":165,"_167":165,"_168":162,"_169":162,"_170":255,"_172":256,"_174":257,"_176":56},[229,232,236],"files",[229,230,231,232,233,234,235,236],"counts",{"_220":51,"_221":64,"_222":51,"_32":223,"_224":225},[214,215,216],{"_36":76,"_43":44,"_39":42,"_13":19,"_53":-5,"_52":79,"_17":51,"_41":-5,"_49":212,"_45":77,"_57":-5,"_18":213},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1787221202545],[19],{"_36":68,"_13":69,"_39":70,"_41":42,"_43":44,"_45":71,"_47":48,"_49":72,"_17":73,"_52":65,"_53":74,"_55":56,"_57":-5,"_18":219},{"_36":59,"_13":60,"_39":61,"_41":42,"_43":44,"_45":62,"_47":48,"_49":63,"_17":64,"_52":65,"_53":66,"_55":56,"_57":-5,"_18":218},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_17":51,"_52":24,"_53":54,"_55":56,"_57":-5,"_18":217},[19,38],[19,60],[19,69],"pulls","branches","forks",{"_226":51,"_228":51},"connections",{"_226":51,"_227":51},"count","unfilledCount","emptyCount",{"_36":110,"_13":111,"_39":112,"_41":-5,"_43":44,"_45":64,"_47":48,"_49":113,"_17":51,"_52":79,"_53":-5,"_55":56,"_57":-5,"_92":251,"_18":252},{"_36":127,"_13":128,"_39":129,"_41":112,"_43":44,"_45":130,"_47":48,"_49":131,"_17":62,"_52":65,"_53":132,"_55":56,"_57":-5,"_92":249,"_18":250},{"_36":118,"_13":119,"_39":120,"_41":112,"_43":44,"_45":121,"_47":48,"_49":122,"_17":123,"_52":65,"_53":124,"_55":56,"_57":-5,"_92":247,"_18":248},{"_36":76,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":77,"_47":48,"_49":95,"_17":51,"_52":79,"_53":-5,"_55":56,"_57":-5,"_92":245,"_18":246},{"_36":68,"_13":69,"_39":70,"_41":42,"_43":44,"_45":71,"_47":48,"_49":107,"_17":73,"_52":65,"_53":74,"_55":56,"_57":-5,"_92":243,"_18":244},{"_36":59,"_13":60,"_39":61,"_41":42,"_43":44,"_45":62,"_47":48,"_49":104,"_17":64,"_52":65,"_53":66,"_55":56,"_57":-5,"_92":241,"_18":242},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":101,"_17":51,"_52":24,"_53":54,"_55":56,"_57":-5,"_92":239,"_18":240},{"_36":84,"_13":85,"_39":86,"_41":-5,"_43":44,"_45":87,"_47":48,"_49":88,"_17":89,"_52":90,"_53":91,"_55":56,"_57":-5,"_92":237,"_18":238},[],[85],[],[19,38],[],[19,60],[],[19,69],[233,234,235],[19],[],[111,119],[],[111,128],[230,231],[111],["D",1787221101901],["D",1789479081816],{"_11":12,"_192":188},{"_11":12,"_185":186,"_187":188,"_145":146,"_189":190,"_191":56},{"_17":87,"_13":16,"_36":44,"_177":135,"_178":-5,"_179":-5,"_180":-5,"_181":-5,"_182":-5,"_183":14,"_184":12},"ctx",{"_170":-5,"_209":291,"_292":293,"_294":295,"_296":56,"_297":56,"_298":56,"_299":48,"_300":-5,"_301":-7,"_302":-7,"_303":51,"_304":56,"_305":56,"_306":-5,"_307":56,"_308":56,"_309":56,"_310":-5},"ENV",{"_262":263,"_264":265,"_266":16,"_267":268,"_269":270,"_271":272,"_273":274,"_275":276,"_277":278,"_279":280,"_281":282,"_283":284,"_285":286,"_287":288,"_289":290},"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"]