[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_171":172,"_173":174},"routes/_app.x.$handle.$name",{"_98":97,"_32":45,"_106":88,"_27":100,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":25,"_120":121,"_122":123,"_124":-5,"_125":-5,"_126":127},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":25},"version",18,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_34":35,"_36":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","ui.ts","latestPath","fileId","7ee60c8e-7be1-11f1-b7cf-1607ee4eb77e","name","UI.ts","fileType","script","content","// SplitBasket UI — served by main.ts\nexport const HTML =\n '\\n\\n\\n\\n\\nSplitBasket\\n\\ud83e\\uddfa\">\\n\\n\\n\\n\\n\\n\\n

\\n

\\n \\n

SplitBasket

loading\\u2026

\\n \\n

\\n\\n

\\n\\n \\n

\\n

\\ud83e\\uddfa

\\n

SplitBasket

\\n

Shop together \\u00b7 split fairly \\u00b7 settle on WhatsApp

\\n

Group share code\\n

\\n \\n

\\n

\\n \\n

\\n\\n \\n

\\n

Group name

\\n

Your family name

\\n

Your name

\\n

Your phone (identity only \\u2014 no SMS sent)

\\n

\\ud83c\\udfe6 Bank details (optional now \\u2014 used for settle-up requests)

\\n

Account holder

\\n

Bank

\\n

Sort code

\\n

Account number

\\n \\n

\\n

\\n\\n \\n

\\n

Your groups

\\n

\\n \\n \\n

Families join a group with a share code \\u2014 no typing emails.

\\n

\\n\\n \\n

Loading\\u2026

\\n\\n \\n

\\n

Trip title

\\n

Date

\\n

Location

\\n

Who\\'s shopping?

\\n \\n

Everyone gets notified to make their picks once the trip exists.

\\n

\\n\\n \\n

\\n

Loading\\u2026

\\n \\n

Cost of each item splits in proportion to the units each family takes. Locking freezes the list; the shopper then enters prices.

\\n

\\n\\n \\n

\\n

Loading\\u2026

\\n

Receipt extras & trip costs

\\n

Trip total

\\n

\\u00a30.00

\\n

\\n \\n

\\n\\n \\n

\\n

Swipe cards \\u2194 \\u00b7 every family\\'s total = their items + share of extras

\\n

Items \\u2014 tap a row to expand

\\n

Loading\\u2026

\\n

Families total

\\u00a30.00

\\n

Trip total (must match)

\\u00a30.00

\\n

\\ud83d\\udce4 Notify & share on WhatsApp

\\n

\\n \\n

Each button generates a snapshot card of that family\\'s split \\u2014 shared on WhatsApp for visual confirmation.

\\n

\\n \\n

Everyone can then settle from the Balances tab.

\\n

\\n\\n \\n

\\n

Settle-up (fewest transfers)

\\n

Loading\\u2026

\\n

Recent activity

\\n

\\n\\n

Done

\\n\\n \\n

\\n

Notifications

\\n

\\n\\n \\n

\\n

\\u270e Note for the shopper

\\n \\n \\n

\\n

\\n\\n \\n

\\n

\\uff0b Add item to trip

\\n

Quick add from your group\\'s templates:

\\n

Name

\\n

Emoji

\\n

Unit

\\n

Unit plural

\\n

\\n \\n Save as template for future trips\\n \\n \\n

\\n

\\n\\n \\n \\n\\n \\n \\n\\n

\\n\\n

\\n \\n \\n \\n

\\n

\\n\\n\\n\\n\\n';","createdAt",["D",1783634779122],"branchVersion","branchId","97baba6c-1708-49ad-a6d2-d943d9c54d85","id","739d9c82-eb27-4d01-9a00-0fb7a9e7f427","Splitbasket",["D",1783632607407],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Splitbasket - An app to divide expenses ","imageUrl","7d446b08-6a12-44f6-a158-db08bb444617","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019f489f-9d50-7458-ae32-42b3e2a896fe","tursoName","739d9c82eb274d019a000fb7a9e7f427","tursoHostname","739d9c82eb274d019a000fb7a9e7f427-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789525245864],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_105":100},"org",{"_98":97,"_99":100,"_101":100,"_18":55,"_102":103,"_104":25},"branch",{"_13":87,"_32":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"isOwned",37,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","NMamidi","handle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":166,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":167,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":168,"_82":169,"_84":170,"_86":25},"tree",[157,158],"files",[157,158],"counts",{"_146":61,"_147":148,"_149":61,"_150":151,"_152":153},"contents",[128,129],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":137,"_32":138,"_30":139,"_131":-5,"_41":42,"_40":140,"_132":25,"_38":141,"_13":134,"_34":142,"_36":143,"_24":25,"_135":144,"_27":145},{"_43":130,"_32":28,"_30":31,"_131":-5,"_41":42,"_40":14,"_132":25,"_38":133,"_13":134,"_34":35,"_36":37,"_24":25,"_135":-5,"_27":136},"8233ecc8-079f-47b4-ac0a-a9919da29cc8","parentId","latest",["D",1783634779122],3,"label",[28],"9d0a85d8-df5c-4775-b48b-488783c62e04","Main.ts","6e254e1e-7be1-11f1-a65a-1607ee4eb77e",17,["D",1783634471806],"http","// SplitBasket — multi-family grocery trip splitting (pilot)\n// HTTP val: serves the app UI at / and a JSON API under /api/*\nimport { Hono } from \"npm:hono\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { HTML } from \"./ui.ts\";\n\nconst app = new Hono();\napp.onError((err) => Promise.reject(err));\n\n/* ============ schema ============ */\nconst SCHEMA = [\n `CREATE TABLE IF NOT EXISTS groups(\n id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, code TEXT UNIQUE NOT NULL,\n currency TEXT DEFAULT 'GBP', created_at TEXT DEFAULT (datetime('now')))`,\n `CREATE TABLE IF NOT EXISTS families(\n id INTEGER PRIMARY KEY AUTOINCREMENT, group_id INTEGER NOT NULL, name TEXT NOT NULL,\n color TEXT NOT NULL DEFAULT '#2f9e5f', holder TEXT DEFAULT '', bank TEXT DEFAULT '',\n sort_code TEXT DEFAULT '', acct TEXT DEFAULT '')`,\n `CREATE TABLE IF NOT EXISTS members(\n id INTEGER PRIMARY KEY AUTOINCREMENT, family_id INTEGER NOT NULL, name TEXT NOT NULL,\n phone TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')))`,\n `CREATE TABLE IF NOT EXISTS trips(\n id INTEGER PRIMARY KEY AUTOINCREMENT, group_id INTEGER NOT NULL, title TEXT NOT NULL,\n date TEXT DEFAULT '', location TEXT DEFAULT '', shopper_family_id INTEGER,\n status TEXT DEFAULT 'planning', created_at TEXT DEFAULT (datetime('now')))`,\n `CREATE TABLE IF NOT EXISTS items(\n id INTEGER PRIMARY KEY AUTOINCREMENT, trip_id INTEGER NOT NULL, emoji TEXT DEFAULT '🛒',\n name TEXT NOT NULL, unit TEXT DEFAULT '', unit_plural TEXT DEFAULT 'units',\n total_price REAL DEFAULT 0, shop_note TEXT DEFAULT '', created_by INTEGER)`,\n `CREATE TABLE IF NOT EXISTS item_qty(\n id INTEGER PRIMARY KEY AUTOINCREMENT, item_id INTEGER NOT NULL, family_id INTEGER NOT NULL,\n req REAL DEFAULT 0, act REAL DEFAULT 0, note TEXT DEFAULT '', UNIQUE(item_id, family_id))`,\n `CREATE TABLE IF NOT EXISTS extras(\n id INTEGER PRIMARY KEY AUTOINCREMENT, trip_id INTEGER NOT NULL, name TEXT NOT NULL,\n amount REAL DEFAULT 0, mode TEXT DEFAULT 'prop')`,\n `CREATE TABLE IF NOT EXISTS payments(\n id INTEGER PRIMARY KEY AUTOINCREMENT, trip_id INTEGER, group_id INTEGER NOT NULL,\n from_family_id INTEGER NOT NULL, to_family_id INTEGER NOT NULL, amount REAL NOT NULL,\n method TEXT DEFAULT 'Bank transfer', reference TEXT DEFAULT '',\n created_at TEXT DEFAULT (datetime('now')))`,\n `CREATE TABLE IF NOT EXISTS requests(\n id INTEGER PRIMARY KEY AUTOINCREMENT, trip_id INTEGER NOT NULL, family_id INTEGER NOT NULL,\n created_at TEXT DEFAULT (datetime('now')), UNIQUE(trip_id, family_id))`,\n `CREATE TABLE IF NOT EXISTS templates(\n id INTEGER PRIMARY KEY AUTOINCREMENT, group_id INTEGER NOT NULL, emoji TEXT DEFAULT '🛒',\n name TEXT NOT NULL, unit TEXT DEFAULT '', unit_plural TEXT DEFAULT 'units')`,\n];\nlet ready = false;\nasync function init() {\n if (ready) return;\n for (const s of SCHEMA) await sqlite.execute(s);\n ready = true;\n}\napp.use(\"*\", async (_c, next) => {\n await init();\n await next();\n});\n\n/* ============ helpers ============ */\nconst r2 = (v: number) => Math.round(v * 100) / 100;\nconst rows = (res: any) => res.rows as any[];\nconst one = (res: any) => (res.rows as any[])[0];\nconst bad = (c: any, msg: string, code = 400) =>\n c.json({ error: msg }, code as any);\nconst COLORS = [\n \"#2f9e5f\",\n \"#3566a8\",\n \"#b97a1c\",\n \"#7c5cb0\",\n \"#c04545\",\n \"#2a8f8f\",\n \"#8a6d3b\",\n \"#5b7a2f\",\n];\nfunction genCode(name: string) {\n const letters = (name.replace(/[^a-zA-Z]/g, \"\").toUpperCase() + \"XYZ\").slice(\n 0,\n 3,\n );\n return `${letters}-${Math.floor(100 + Math.random() * 900)}`;\n}\n\n/* ============ split math (mirrored on the client) ============ */\nfunction computeTrip(\n items: any[],\n qty: any[],\n extras: any[],\n famIds: number[],\n) {\n const byItem: Record = {};\n qty.forEach((q) => {\n (byItem[q.item_id] ||= []).push(q);\n });\n const fam: Record = {};\n famIds.forEach((f) =>\n fam[f] = { items: 0, units: 0, prop: 0, eq: 0, extra: 0, final: 0 }\n );\n const lines = items.map((it) => {\n const qs = (byItem[it.id] || []).filter((q) =>\n q.act > 0 && fam[q.family_id]\n );\n const total = r2(it.total_price || 0);\n const n = qs.reduce((s, q) => s + q.act, 0);\n const unit = n ? total / n : 0;\n const shares: Record = {};\n let acc = 0;\n qs.forEach((q, i) => {\n const s = i === qs.length - 1 ? r2(total - acc) : r2(q.act * unit);\n shares[q.family_id] = s;\n acc = r2(acc + s);\n fam[q.family_id].items = r2(fam[q.family_id].items + s);\n fam[q.family_id].units += q.act;\n });\n return { ...it, bought: n, unit, shares };\n });\n const itemsTotal = r2(items.reduce((s, i) => s + (i.total_price || 0), 0));\n const propTotal = r2(\n extras.filter((x) => x.mode === \"prop\").reduce((s, x) => s + x.amount, 0),\n );\n const eqTotal = r2(\n extras.filter((x) => x.mode === \"eq\").reduce((s, x) => s + x.amount, 0),\n );\n const receipt = r2(itemsTotal + propTotal + eqTotal);\n const active = famIds.filter((f) => fam[f].units > 0);\n let pAcc = 0, qAcc = 0;\n active.forEach((f, i) => {\n const last = i === active.length - 1;\n fam[f].prop = last\n ? r2(propTotal - pAcc)\n : (itemsTotal ? r2(propTotal * fam[f].items / itemsTotal) : 0);\n fam[f].eq = last\n ? r2(eqTotal - qAcc)\n : (active.length ? r2(eqTotal / active.length) : 0);\n pAcc = r2(pAcc + fam[f].prop);\n qAcc = r2(qAcc + fam[f].eq);\n fam[f].extra = r2(fam[f].prop + fam[f].eq);\n fam[f].final = r2(fam[f].items + fam[f].extra);\n });\n return { fam, lines, itemsTotal, propTotal, eqTotal, receipt, active };\n}\n\nasync function tripBundle(tripId: number) {\n const trip = one(\n await sqlite.execute({\n sql: \"SELECT * FROM trips WHERE id=?\",\n args: [tripId],\n }),\n );\n if (!trip) return null;\n const families = rows(\n await sqlite.execute({\n sql: \"SELECT * FROM families WHERE group_id=? ORDER BY id\",\n args: [trip.group_id],\n }),\n );\n const items = rows(\n await sqlite.execute({\n sql: \"SELECT * FROM items WHERE trip_id=? ORDER BY id\",\n args: [tripId],\n }),\n );\n const qty = items.length\n ? rows(\n await sqlite.execute({\n sql: `SELECT * FROM item_qty WHERE item_id IN (${\n items.map(() => \"?\").join(\",\")\n })`,\n args: items.map((i) => i.id),\n }),\n )\n : [];\n const extras = rows(\n await sqlite.execute({\n sql: \"SELECT * FROM extras WHERE trip_id=? ORDER BY id\",\n args: [tripId],\n }),\n );\n const payments = rows(\n await sqlite.execute({\n sql: \"SELECT * FROM payments WHERE trip_id=? ORDER BY id\",\n args: [tripId],\n }),\n );\n const requests = rows(\n await sqlite.execute({\n sql: \"SELECT * FROM requests WHERE trip_id=?\",\n args: [tripId],\n }),\n );\n return { trip, families, items, qty, extras, payments, requests };\n}\n\n/* ============ API ============ */\n\n// Look up a group by share code (join screen)\napp.get(\"/api/lookup\", async (c) => {\n const code = (c.req.query(\"code\") || \"\").trim().toUpperCase();\n const group = one(\n await sqlite.execute({\n sql: \"SELECT * FROM groups WHERE code=?\",\n args: [code],\n }),\n );\n if (!group) return bad(c, \"No group found for that code\");\n const families = rows(\n await sqlite.execute({\n sql: \"SELECT id,name,color FROM families WHERE group_id=? ORDER BY id\",\n args: [group.id],\n }),\n );\n return c.json({ group, families });\n});\n\n// Create a group (+ first family + first member)\napp.post(\"/api/groups\", async (c) => {\n const b = await c.req.json();\n if (!b.group_name || !b.family_name || !b.member_name || !b.phone) {\n return bad(c, \"Missing fields\");\n }\n let code = genCode(b.group_name);\n for (let i = 0; i < 5; i++) {\n const clash = one(\n await sqlite.execute({\n sql: \"SELECT id FROM groups WHERE code=?\",\n args: [code],\n }),\n );\n if (!clash) break;\n code = genCode(b.group_name + i);\n }\n await sqlite.execute({\n sql: \"INSERT INTO groups(name,code) VALUES(?,?)\",\n args: [b.group_name, code],\n });\n const group = one(\n await sqlite.execute({\n sql: \"SELECT * FROM groups WHERE code=?\",\n args: [code],\n }),\n );\n await sqlite.execute({\n sql:\n \"INSERT INTO families(group_id,name,color,holder,bank,sort_code,acct) VALUES(?,?,?,?,?,?,?)\",\n args: [\n group.id,\n b.family_name,\n COLORS[0],\n b.holder || \"\",\n b.bank || \"\",\n b.sort_code || \"\",\n b.acct || \"\",\n ],\n });\n const family = one(\n await sqlite.execute({\n sql: \"SELECT * FROM families WHERE group_id=? ORDER BY id DESC LIMIT 1\",\n args: [group.id],\n }),\n );\n await sqlite.execute({\n sql: \"INSERT INTO members(family_id,name,phone) VALUES(?,?,?)\",\n args: [family.id, b.member_name, b.phone],\n });\n // starter templates\n for (\n const t of [\n [\"🍓\", \"Strawberries\", \"box\", \"boxes\"],\n [\"🥔\", \"Potatoes\", \"5 kg bag\", \"bags\"],\n [\"🥛\", \"Milk\", \"4-pint\", \"bottles\"],\n [\"🥚\", \"Eggs\", \"dozen\", \"dozens\"],\n [\"🍚\", \"Rice\", \"10 kg bag\", \"bags\"],\n [\"🫒\", \"Olive oil\", \"1 L bottle\", \"bottles\"],\n ]\n ) {\n await sqlite.execute({\n sql:\n \"INSERT INTO templates(group_id,emoji,name,unit,unit_plural) VALUES(?,?,?,?,?)\",\n args: [group.id, ...t],\n });\n }\n return c.json({ group, family });\n});\n\n// Join a group: pick an existing family or create a new one\napp.post(\"/api/join\", async (c) => {\n const b = await c.req.json();\n const code = (b.code || \"\").trim().toUpperCase();\n const group = one(\n await sqlite.execute({\n sql: \"SELECT * FROM groups WHERE code=?\",\n args: [code],\n }),\n );\n if (!group) return bad(c, \"No group found for that code\");\n if (!b.member_name || !b.phone) return bad(c, \"Missing name or phone\");\n let familyId = b.family_id;\n if (!familyId) {\n if (!b.family_name) {\n return bad(c, \"Pick a family or enter a new family name\");\n }\n const count =\n rows(\n await sqlite.execute({\n sql: \"SELECT id FROM families WHERE group_id=?\",\n args: [group.id],\n }),\n ).length;\n await sqlite.execute({\n sql:\n \"INSERT INTO families(group_id,name,color,holder,bank,sort_code,acct) VALUES(?,?,?,?,?,?,?)\",\n args: [\n group.id,\n b.family_name,\n COLORS[count % COLORS.length],\n b.holder || \"\",\n b.bank || \"\",\n b.sort_code || \"\",\n b.acct || \"\",\n ],\n });\n familyId =\n one(\n await sqlite.execute({\n sql:\n \"SELECT id FROM families WHERE group_id=? ORDER BY id DESC LIMIT 1\",\n args: [group.id],\n }),\n ).id;\n }\n await sqlite.execute({\n sql: \"INSERT INTO members(family_id,name,phone) VALUES(?,?,?)\",\n args: [familyId, b.member_name, b.phone],\n });\n const family = one(\n await sqlite.execute({\n sql: \"SELECT * FROM families WHERE id=?\",\n args: [familyId],\n }),\n );\n return c.json({ group, family });\n});\n\n// Whole-group state: families, trips (with totals), running balances, templates\napp.get(\"/api/state\", async (c) => {\n const gid = Number(c.req.query(\"group_id\"));\n const group = one(\n await sqlite.execute({\n sql: \"SELECT * FROM groups WHERE id=?\",\n args: [gid],\n }),\n );\n if (!group) return bad(c, \"Group not found\", 404);\n const families = rows(\n await sqlite.execute({\n sql: \"SELECT * FROM families WHERE group_id=? ORDER BY id\",\n args: [gid],\n }),\n );\n const famIds = families.map((f) => f.id);\n const trips = rows(\n await sqlite.execute({\n sql: \"SELECT * FROM trips WHERE group_id=? ORDER BY id DESC\",\n args: [gid],\n }),\n );\n const net: Record = {};\n famIds.forEach((f) => net[f] = 0);\n const tripSummaries = [];\n for (const t of trips) {\n const b = await tripBundle(t.id);\n const comp = computeTrip(b!.items, b!.qty, b!.extras, famIds);\n if (![\"planning\", \"cancelled\"].includes(t.status) && t.shopper_family_id) {\n famIds.forEach((f) => {\n net[f] = r2(net[f] - comp.fam[f].final);\n });\n net[t.shopper_family_id] = r2(net[t.shopper_family_id] + comp.receipt);\n }\n tripSummaries.push({\n ...t,\n receipt: comp.receipt,\n item_count: b!.items.length,\n });\n }\n const pays = rows(\n await sqlite.execute({\n sql: \"SELECT * FROM payments WHERE group_id=? ORDER BY id DESC\",\n args: [gid],\n }),\n );\n for (const p of pays) {\n if (net[p.from_family_id] !== undefined) {\n net[p.from_family_id] = r2(net[p.from_family_id] + p.amount);\n }\n if (net[p.to_family_id] !== undefined) {\n net[p.to_family_id] = r2(net[p.to_family_id] - p.amount);\n }\n }\n const templates = rows(\n await sqlite.execute({\n sql: \"SELECT * FROM templates WHERE group_id=? ORDER BY name\",\n args: [gid],\n }),\n );\n return c.json({\n group,\n families,\n trips: tripSummaries,\n net,\n payments: pays.slice(0, 20),\n templates,\n });\n});\n\n// Full trip detail + computed split\napp.get(\"/api/trips/:id\", async (c) => {\n const b = await tripBundle(Number(c.req.param(\"id\")));\n if (!b) return bad(c, \"Trip not found\", 404);\n const comp = computeTrip(\n b.items,\n b.qty,\n b.extras,\n b.families.map((f: any) => f.id),\n );\n return c.json({ ...b, comp });\n});\n\napp.post(\"/api/trips\", async (c) => {\n const b = await c.req.json();\n if (!b.group_id || !b.title) return bad(c, \"Missing fields\");\n await sqlite.execute({\n sql:\n \"INSERT INTO trips(group_id,title,date,location,shopper_family_id) VALUES(?,?,?,?,?)\",\n args: [\n b.group_id,\n b.title,\n b.date || \"\",\n b.location || \"\",\n b.shopper_family_id || null,\n ],\n });\n const trip = one(\n await sqlite.execute({\n sql: \"SELECT * FROM trips WHERE group_id=? ORDER BY id DESC LIMIT 1\",\n args: [b.group_id],\n }),\n );\n for (\n const [name, mode] of [[\"Bag fee\", \"prop\"], [\"Loyalty discount\", \"prop\"], [\n \"Fuel expense\",\n \"eq\",\n ], [\"Parking fee\", \"eq\"]]\n ) {\n await sqlite.execute({\n sql: \"INSERT INTO extras(trip_id,name,mode) VALUES(?,?,?)\",\n args: [trip.id, name, mode],\n });\n }\n return c.json({ trip });\n});\n\napp.post(\"/api/trips/:id/status\", async (c) => {\n const b = await c.req.json();\n const ok = [\"planning\", \"locked\", \"settling\", \"settled\", \"cancelled\"];\n if (!ok.includes(b.status)) return bad(c, \"Bad status\");\n await sqlite.execute({\n sql: \"UPDATE trips SET status=? WHERE id=?\",\n args: [b.status, Number(c.req.param(\"id\"))],\n });\n return c.json({ ok: true });\n});\n\napp.post(\"/api/items\", async (c) => {\n const b = await c.req.json();\n if (!b.trip_id || !b.name) return bad(c, \"Missing fields\");\n await sqlite.execute({\n sql:\n \"INSERT INTO items(trip_id,emoji,name,unit,unit_plural,created_by) VALUES(?,?,?,?,?,?)\",\n args: [\n b.trip_id,\n b.emoji || \"🛒\",\n b.name,\n b.unit || \"\",\n b.unit_plural || \"units\",\n b.family_id || null,\n ],\n });\n return c.json({ ok: true });\n});\n\n// Upsert quantity/note for (item, family). During planning, setting req also sets act.\napp.post(\"/api/qty\", async (c) => {\n const b = await c.req.json();\n if (!b.item_id || !b.family_id) return bad(c, \"Missing fields\");\n const cur = one(\n await sqlite.execute({\n sql: \"SELECT * FROM item_qty WHERE item_id=? AND family_id=?\",\n args: [b.item_id, b.family_id],\n }),\n );\n const req = b.req !== undefined\n ? Math.max(0, Number(b.req))\n : (cur?.req ?? 0);\n const act = b.act !== undefined\n ? Math.max(0, Number(b.act))\n : (b.req !== undefined ? req : (cur?.act ?? 0));\n const note = b.note !== undefined ? String(b.note) : (cur?.note ?? \"\");\n if (cur) {\n await sqlite.execute({\n sql: \"UPDATE item_qty SET req=?,act=?,note=? WHERE id=?\",\n args: [req, act, note, cur.id],\n });\n } else {\n await sqlite.execute({\n sql:\n \"INSERT INTO item_qty(item_id,family_id,req,act,note) VALUES(?,?,?,?,?)\",\n args: [b.item_id, b.family_id, req, act, note],\n });\n }\n return c.json({ ok: true });\n});\n\napp.post(\"/api/items/:id/price\", async (c) => {\n const b = await c.req.json();\n await sqlite.execute({\n sql: \"UPDATE items SET total_price=? WHERE id=?\",\n args: [r2(Number(b.total) || 0), Number(c.req.param(\"id\"))],\n });\n return c.json({ ok: true });\n});\n\napp.post(\"/api/extras/:id\", async (c) => {\n const b = await c.req.json();\n await sqlite.execute({\n sql: \"UPDATE extras SET amount=? WHERE id=?\",\n args: [r2(Number(b.amount) || 0), Number(c.req.param(\"id\"))],\n });\n return c.json({ ok: true });\n});\n\napp.post(\"/api/payments\", async (c) => {\n const b = await c.req.json();\n if (!b.group_id || !b.from_family_id || !b.to_family_id || !b.amount) {\n return bad(c, \"Missing fields\");\n }\n await sqlite.execute({\n sql:\n \"INSERT INTO payments(trip_id,group_id,from_family_id,to_family_id,amount,method,reference) VALUES(?,?,?,?,?,?,?)\",\n args: [\n b.trip_id || null,\n b.group_id,\n b.from_family_id,\n b.to_family_id,\n r2(Number(b.amount)),\n b.method || \"Bank transfer\",\n b.reference || \"\",\n ],\n });\n return c.json({ ok: true });\n});\n\napp.post(\"/api/requests\", async (c) => {\n const b = await c.req.json();\n try {\n await sqlite.execute({\n sql: \"INSERT INTO requests(trip_id,family_id) VALUES(?,?)\",\n args: [b.trip_id, b.family_id],\n });\n } catch (_e) { /* already requested */ }\n return c.json({ ok: true });\n});\n\napp.post(\"/api/templates\", async (c) => {\n const b = await c.req.json();\n if (!b.group_id || !b.name) return bad(c, \"Missing fields\");\n await sqlite.execute({\n sql:\n \"INSERT INTO templates(group_id,emoji,name,unit,unit_plural) VALUES(?,?,?,?,?)\",\n args: [\n b.group_id,\n b.emoji || \"🛒\",\n b.name,\n b.unit || \"\",\n b.unit_plural || \"units\",\n ],\n });\n return c.json({ ok: true });\n});\n\n// One-time seed: only runs when the database has no groups yet.\napp.get(\"/api/seed\", async (c) => {\n const existing = rows(await sqlite.execute(\"SELECT id FROM groups LIMIT 1\"));\n if (existing.length) {\n return c.json({ seeded: false, note: \"Already has data\" });\n }\n await sqlite.execute({\n sql: \"INSERT INTO groups(name,code) VALUES(?,?)\",\n args: [\"Veggie Club\", \"VEG-742\"],\n });\n const g = one(\n await sqlite.execute(\"SELECT * FROM groups ORDER BY id DESC LIMIT 1\"),\n );\n const fams = [\n [\"Chatterjee\", \"#2f9e5f\", \"U Chatterjee\", \"Monzo\", \"04-00-04\", \"12345678\"],\n [\"Patel\", \"#3566a8\", \"R Patel\", \"Starling\", \"60-83-71\", \"87654321\"],\n [\"Smith\", \"#b97a1c\", \"J Smith\", \"Barclays\", \"20-00-00\", \"11223344\"],\n ];\n for (const f of fams) {\n await sqlite.execute({\n sql:\n \"INSERT INTO families(group_id,name,color,holder,bank,sort_code,acct) VALUES(?,?,?,?,?,?,?)\",\n args: [g.id, ...f],\n });\n }\n for (\n const t of [\n [\"🍓\", \"Strawberries\", \"box (10 lb)\", \"boxes\"],\n [\"🥔\", \"Potatoes\", \"5 kg bag\", \"bags\"],\n [\"🥛\", \"Milk\", \"4-pint\", \"bottles\"],\n [\"🥚\", \"Eggs\", \"dozen, free range\", \"dozens\"],\n [\"🫐\", \"Blueberries\", \"punnet\", \"punnets\"],\n [\"🍚\", \"Basmati rice\", \"10 kg bag\", \"bags\"],\n [\"🫒\", \"Olive oil\", \"1 L bottle\", \"bottles\"],\n ]\n ) {\n await sqlite.execute({\n sql:\n \"INSERT INTO templates(group_id,emoji,name,unit,unit_plural) VALUES(?,?,?,?,?)\",\n args: [g.id, ...t],\n });\n }\n return c.json({ seeded: true, group: g });\n});\n\n/* ============ UI ============ */\napp.get(\"/\", (c) => c.html(HTML));\n\nexport default app.fetch;","splitbasket",[138],"pulls","branches",1,"forks","envVars",{"_154":61,"_156":61},"connections",{"_154":61,"_155":61},"count","unfilledCount","emptyCount",{"_43":137,"_32":138,"_30":139,"_131":-5,"_41":42,"_40":140,"_132":25,"_38":163,"_13":134,"_34":142,"_36":143,"_24":25,"_135":144,"_160":164,"_27":165},{"_43":130,"_32":28,"_30":31,"_131":-5,"_41":42,"_40":14,"_132":25,"_38":159,"_13":134,"_34":35,"_36":37,"_24":25,"_135":-5,"_160":161,"_27":162},["D",1783634779122],"children",[],[28],["D",1783634471806],[],[138],["D",1783632607407],["D",1789525245864],{"_98":97,"_105":100},{"_98":97,"_99":100,"_101":100,"_18":55,"_102":103,"_104":25},{"_13":87,"_32":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"ctx",{"_80":-5,"_125":204,"_205":206,"_207":208,"_209":25,"_210":25,"_211":25,"_212":123,"_213":-5,"_214":-7,"_215":-7,"_216":61,"_217":25,"_218":25,"_219":-5,"_220":25,"_221":25,"_222":25,"_223":-5},"ENV",{"_175":176,"_177":178,"_179":88,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201,"_202":203},"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"]

SplitBasket

Your groups

Receipt extras & trip costs

Items \\u2014 tap a row to expand

\\ud83d\\udce4 Notify & share on WhatsApp

Settle-up (fewest transfers)

Recent activity

Notifications

\\u270e Note for the shopper

\\uff0b Add item to trip

Share breakdown

Record a payment

Diff · v18