[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_184":185,"_186":187},"routes/_app.x.$handle.$name",{"_97":96,"_32":44,"_105":87,"_27":99,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":25,"_119":120,"_121":122,"_123":-5,"_124":-5,"_125":126},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_32":44,"_37":45,"_46":-5,"_47":25,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":68,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":25},"version",28,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","ui.ts","latestPath","fileId","7ee60c8e-7be1-11f1-b7cf-1607ee4eb77e","name","fileType","script","content","// SplitBasket UI v4 (part 1 of 2)\nexport const H1 =\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 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

Open trips

\\n

\\n\\n \\n

\\n

\\ud83d\\udce6 Archived trips

\\n

\\ud83d\\udcb7 Payment log

\\n

Everything here is settled history \\u2014 it appears nowhere else in the app.

\\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

\\u2699 Item options

\\n

Name

\\n

Emoji

\\n

Unit

\\n

Unit plural

\\n

\\n \\n

Available to the family that added the item, the trip creator, and the group admin \\u2014 while the list is in planning.

\\n

\\n\\n \\n

\\n

\\uff0b Add item to trip

\\n

Quick add from your group\\'s templates:\\n

\\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

\\u270e Edit family

\\n

Family name

\\n

Account holder

\\n

Bank

\\n

Sort code

\\n

Account number

\\n \\n \\n

\\n

\\n\\n \\n

\\n

\\u2699 Group settings

\\n

Group name

\\n \\n

\\n

\\n\\n \\n

\\n

\\u270e Edit trip

\\n

Trip title

\\n

Date

\\n

Location

\\n

Who\\'s shopping?

\\n \\n

\\n

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

\\n

Only the trip creator or group admin sees this. Unlock lets families change picks again; delete removes the trip and its items.

\\n

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

\\n\\n

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

\\n

\\n\\n\\n\\n\\n\";","label",[131],"f0e5bca6-9d43-498c-a35d-4f373ca8cce9",["D",1783651348248],6,[28],"820649e6-f20e-4482-86e9-d2d77b1ab35c","Main.ts","6e254e1e-7be1-11f1-a65a-1607ee4eb77e",26,["D",1783651322445],7,"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 { H1 } from \"./ui.ts\";\nimport { H2 } from \"./ui2.ts\";\nconst HTML = H1 + H2;\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];\n// additive migrations — safe to re-run (errors ignored when column exists)\nconst MIGRATIONS = [\n \"ALTER TABLE groups ADD COLUMN admin_family_id INTEGER\",\n \"ALTER TABLE trips ADD COLUMN created_by_family_id INTEGER\",\n \"ALTER TABLE trips ADD COLUMN archived INTEGER DEFAULT 0\",\n];\nlet ready = false;\nasync function init() {\n if (ready) return;\n for (const s of SCHEMA) await sqlite.execute(s);\n for (const m of MIGRATIONS) {\n try {\n await sqlite.execute(m);\n } catch (_e) { /* exists */ }\n }\n await sqlite.execute(\n \"UPDATE groups SET admin_family_id=(SELECT MIN(f.id) FROM families f WHERE f.group_id=groups.id) WHERE admin_family_id IS NULL\",\n );\n await sqlite.execute(\n \"UPDATE trips SET created_by_family_id=shopper_family_id WHERE created_by_family_id IS NULL\",\n );\n await sqlite.execute(\"UPDATE trips SET archived=0 WHERE archived IS NULL\");\n ready = true;\n}\n\n// permission helper: trip creator or group admin\nasync function tripAdminOk(tripId: number, by: 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 { trip: null, ok: false };\n const g = one(\n await sqlite.execute({\n sql: \"SELECT * FROM groups WHERE id=?\",\n args: [trip.group_id],\n }),\n );\n return {\n trip,\n ok: !!by && (trip.created_by_family_id === by || g?.admin_family_id === by),\n };\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 b.member_name = b.member_name || b.family_name;\n if (!b.group_name || !b.family_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: \"UPDATE groups SET admin_family_id=? WHERE id=?\",\n args: [family.id, group.id],\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.phone) return bad(c, \"Missing 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 const family = one(\n await sqlite.execute({\n sql: \"SELECT * FROM families WHERE id=?\",\n args: [familyId],\n }),\n );\n await sqlite.execute({\n sql: \"INSERT INTO members(family_id,name,phone) VALUES(?,?,?)\",\n args: [familyId, b.member_name || family.name, b.phone],\n });\n return c.json({ group, family });\n});\n\n// Rename group (admin) / delete group (admin, cascades everything)\napp.post(\"/api/groups/:id\", async (c) => {\n const b = await c.req.json();\n const gid = Number(c.req.param(\"id\"));\n const g = one(\n await sqlite.execute({\n sql: \"SELECT * FROM groups WHERE id=?\",\n args: [gid],\n }),\n );\n if (!g) return bad(c, \"Group not found\", 404);\n if (g.admin_family_id !== b.by_family_id) {\n return bad(c, \"Only the group admin can do this\", 403);\n }\n if (b.name) {\n await sqlite.execute({\n sql: \"UPDATE groups SET name=? WHERE id=?\",\n args: [String(b.name).trim(), gid],\n });\n }\n return c.json({ ok: true });\n});\napp.post(\"/api/groups/:id/delete\", async (c) => {\n const b = await c.req.json();\n const gid = Number(c.req.param(\"id\"));\n const g = one(\n await sqlite.execute({\n sql: \"SELECT * FROM groups WHERE id=?\",\n args: [gid],\n }),\n );\n if (!g) return bad(c, \"Group not found\", 404);\n if (g.admin_family_id !== b.by_family_id) {\n return bad(c, \"Only the group admin can delete the group\", 403);\n }\n const trips = rows(\n await sqlite.execute({\n sql: \"SELECT id FROM trips WHERE group_id=?\",\n args: [gid],\n }),\n );\n for (const t of trips) {\n const items = rows(\n await sqlite.execute({\n sql: \"SELECT id FROM items WHERE trip_id=?\",\n args: [t.id],\n }),\n );\n for (const it of items) {\n await sqlite.execute({\n sql: \"DELETE FROM item_qty WHERE item_id=?\",\n args: [it.id],\n });\n }\n await sqlite.execute({\n sql: \"DELETE FROM items WHERE trip_id=?\",\n args: [t.id],\n });\n await sqlite.execute({\n sql: \"DELETE FROM extras WHERE trip_id=?\",\n args: [t.id],\n });\n await sqlite.execute({\n sql: \"DELETE FROM requests WHERE trip_id=?\",\n args: [t.id],\n });\n }\n for (const tbl of [\"trips\", \"payments\", \"templates\", \"families\"]) {\n await sqlite.execute({\n sql: `DELETE FROM ${tbl} WHERE group_id=?`,\n args: [gid],\n });\n }\n await sqlite.execute({ sql: \"DELETE FROM groups WHERE id=?\", args: [gid] });\n return c.json({ ok: true });\n});\n\n// Edit a family (its own members, or the group admin)\napp.post(\"/api/families/:id\", async (c) => {\n const b = await c.req.json();\n const fid = Number(c.req.param(\"id\"));\n const f = one(\n await sqlite.execute({\n sql: \"SELECT * FROM families WHERE id=?\",\n args: [fid],\n }),\n );\n if (!f) return bad(c, \"Family not found\", 404);\n const g = one(\n await sqlite.execute({\n sql: \"SELECT * FROM groups WHERE id=?\",\n args: [f.group_id],\n }),\n );\n if (b.by_family_id !== fid && b.by_family_id !== g?.admin_family_id) {\n return bad(c, \"You can only edit your own family\", 403);\n }\n await sqlite.execute({\n sql:\n \"UPDATE families SET name=?, holder=?, bank=?, sort_code=?, acct=? WHERE id=?\",\n args: [\n (b.name ?? f.name).trim() || f.name,\n b.holder ?? f.holder,\n b.bank ?? f.bank,\n b.sort_code ?? f.sort_code,\n b.acct ?? f.acct,\n fid,\n ],\n });\n return c.json({ ok: true });\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 // families with an open payment request in any non-archived trip of this group\n const requested = rows(\n await sqlite.execute({\n sql:\n \"SELECT DISTINCT r.family_id FROM requests r JOIN trips t ON r.trip_id=t.id WHERE t.group_id=? AND t.archived=0\",\n args: [gid],\n }),\n ).map((x) => x.family_id);\n return c.json({\n group,\n families,\n trips: tripSummaries,\n net,\n payments: pays.slice(0, 100),\n templates,\n requested,\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,created_by_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 b.created_by_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\n// Edit trip details / archive / unlock (creator or group admin; archive toggle is open to any member)\napp.post(\"/api/trips/:id/update\", async (c) => {\n const b = await c.req.json();\n const id = Number(c.req.param(\"id\"));\n const onlyArchive = Object.keys(b).every((k) =>\n [\"archived\", \"by_family_id\"].includes(k)\n );\n const { trip, ok } = await tripAdminOk(id, b.by_family_id);\n if (!trip) return bad(c, \"Trip not found\", 404);\n if (!onlyArchive && !ok) {\n return bad(\n c,\n \"Only the trip creator or group admin can edit this trip\",\n 403,\n );\n }\n await sqlite.execute({\n sql:\n \"UPDATE trips SET title=?, date=?, location=?, shopper_family_id=?, status=?, archived=? WHERE id=?\",\n args: [\n (b.title ?? trip.title).trim() || trip.title,\n b.date ?? trip.date,\n b.location ?? trip.location,\n b.shopper_family_id ?? trip.shopper_family_id,\n b.status ?? trip.status,\n b.archived !== undefined ? (b.archived ? 1 : 0) : trip.archived,\n id,\n ],\n });\n return c.json({ ok: true });\n});\napp.post(\"/api/trips/:id/delete\", async (c) => {\n const b = await c.req.json();\n const id = Number(c.req.param(\"id\"));\n const { trip, ok } = await tripAdminOk(id, b.by_family_id);\n if (!trip) return bad(c, \"Trip not found\", 404);\n if (!ok) {\n return bad(\n c,\n \"Only the trip creator or group admin can delete this trip\",\n 403,\n );\n }\n const items = rows(\n await sqlite.execute({\n sql: \"SELECT id FROM items WHERE trip_id=?\",\n args: [id],\n }),\n );\n for (const it of items) {\n await sqlite.execute({\n sql: \"DELETE FROM item_qty WHERE item_id=?\",\n args: [it.id],\n });\n }\n for (const tbl of [\"items\", \"extras\", \"requests\"]) {\n await sqlite.execute({\n sql: `DELETE FROM ${tbl} WHERE trip_id=?`,\n args: [id],\n });\n }\n await sqlite.execute({ sql: \"DELETE FROM trips WHERE id=?\", args: [id] });\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// Item edit/delete: allowed for the family that added it, the trip creator, or the group admin — while planning\nasync function itemOpsOk(itemId: number, by: number) {\n const item = one(\n await sqlite.execute({\n sql: \"SELECT * FROM items WHERE id=?\",\n args: [itemId],\n }),\n );\n if (!item) return { item: null, ok: false, why: \"Item not found\" };\n const trip = one(\n await sqlite.execute({\n sql: \"SELECT * FROM trips WHERE id=?\",\n args: [item.trip_id],\n }),\n );\n const g = one(\n await sqlite.execute({\n sql: \"SELECT * FROM groups WHERE id=?\",\n args: [trip.group_id],\n }),\n );\n if (trip.status !== \"planning\") {\n return { item, ok: false, why: \"List is locked — unlock the trip first\" };\n }\n const ok = !!by &&\n (item.created_by === by || trip.created_by_family_id === by ||\n g?.admin_family_id === by);\n return {\n item,\n ok,\n why: ok\n ? \"\"\n : \"Only the family that added this item, the trip creator, or the group admin can change it\",\n };\n}\napp.post(\"/api/items/:id/update\", async (c) => {\n const b = await c.req.json();\n const { item, ok, why } = await itemOpsOk(\n Number(c.req.param(\"id\")),\n b.by_family_id,\n );\n if (!item) return bad(c, why, 404);\n if (!ok) return bad(c, why, 403);\n await sqlite.execute({\n sql: \"UPDATE items SET name=?, emoji=?, unit=?, unit_plural=? WHERE id=?\",\n args: [\n (b.name ?? item.name).trim() || item.name,\n b.emoji ?? item.emoji,\n b.unit ?? item.unit,\n b.unit_plural ?? item.unit_plural,\n item.id,\n ],\n });\n return c.json({ ok: true });\n});\napp.post(\"/api/items/:id/delete\", async (c) => {\n const b = await c.req.json();\n const { item, ok, why } = await itemOpsOk(\n Number(c.req.param(\"id\")),\n b.by_family_id,\n );\n if (!item) return bad(c, why, 404);\n if (!ok) return bad(c, why, 403);\n await sqlite.execute({\n sql: \"DELETE FROM item_qty WHERE item_id=?\",\n args: [item.id],\n });\n await sqlite.execute({\n sql: \"DELETE FROM items WHERE id=?\",\n args: [item.id],\n });\n return c.json({ ok: true });\n});\n\n// Templates: any group member can prune the shared list\napp.post(\"/api/templates/:id/delete\", async (c) => {\n await sqlite.execute({\n sql: \"DELETE FROM templates WHERE id=?\",\n args: [Number(c.req.param(\"id\"))],\n });\n return c.json({ ok: true });\n});\n\n// Undo a payment: the payer, the payee, or the group admin\napp.post(\"/api/payments/:id/delete\", async (c) => {\n const b = await c.req.json();\n const p = one(\n await sqlite.execute({\n sql: \"SELECT * FROM payments WHERE id=?\",\n args: [Number(c.req.param(\"id\"))],\n }),\n );\n if (!p) return bad(c, \"Payment not found\", 404);\n const g = one(\n await sqlite.execute({\n sql: \"SELECT * FROM groups WHERE id=?\",\n args: [p.group_id],\n }),\n );\n const ok = [p.from_family_id, p.to_family_id, g?.admin_family_id].includes(\n b.by_family_id,\n );\n if (!ok) {\n return bad(\n c,\n \"Only the payer, payee, or group admin can undo a payment\",\n 403,\n );\n }\n await sqlite.execute({\n sql: \"DELETE FROM payments WHERE id=?\",\n args: [p.id],\n });\n return c.json({ ok: true });\n});\n\n// Remove a family: group admin only, and only if the family has no financial history\napp.post(\"/api/families/:id/delete\", async (c) => {\n const b = await c.req.json();\n const fid = Number(c.req.param(\"id\"));\n const f = one(\n await sqlite.execute({\n sql: \"SELECT * FROM families WHERE id=?\",\n args: [fid],\n }),\n );\n if (!f) return bad(c, \"Family not found\", 404);\n const g = one(\n await sqlite.execute({\n sql: \"SELECT * FROM groups WHERE id=?\",\n args: [f.group_id],\n }),\n );\n if (b.by_family_id !== g?.admin_family_id) {\n return bad(c, \"Only the group admin can remove a family\", 403);\n }\n if (fid === g.admin_family_id) {\n return bad(\n c,\n \"The admin family cannot remove itself — delete the group instead\",\n );\n }\n const hasQty = one(\n await sqlite.execute({\n sql: \"SELECT id FROM item_qty WHERE family_id=? LIMIT 1\",\n args: [fid],\n }),\n );\n const hasPay = one(\n await sqlite.execute({\n sql:\n \"SELECT id FROM payments WHERE from_family_id=? OR to_family_id=? LIMIT 1\",\n args: [fid, fid],\n }),\n );\n if (hasQty || hasPay) {\n return bad(\n c,\n \"This family has purchase or payment history and can't be removed — it would corrupt past splits\",\n );\n }\n await sqlite.execute({\n sql: \"DELETE FROM members WHERE family_id=?\",\n args: [fid],\n });\n await sqlite.execute({ sql: \"DELETE FROM families WHERE id=?\", args: [fid] });\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",[146],"pulls","branches",1,"forks","envVars",{"_163":60,"_165":60},"connections",{"_163":60,"_164":60},"count","unfilledCount","emptyCount",{"_42":145,"_32":146,"_30":147,"_133":-5,"_40":41,"_39":148,"_135":25,"_37":176,"_13":150,"_33":151,"_35":152,"_24":25,"_139":153,"_170":177,"_27":178},{"_42":141,"_32":28,"_30":31,"_133":-5,"_40":41,"_39":14,"_135":25,"_37":173,"_13":143,"_33":34,"_35":36,"_24":25,"_139":-5,"_170":174,"_27":175},{"_42":130,"_32":131,"_30":132,"_133":-5,"_40":41,"_39":134,"_135":25,"_37":169,"_13":137,"_33":34,"_35":138,"_24":25,"_139":-5,"_170":171,"_27":172},["D",1783649386978],"children",[],[131],["D",1783651348248],[],[28],["D",1783651322445],[],[146],["D",1783632607407],["D",1789525245864],{"_97":96,"_104":99},{"_97":96,"_98":99,"_100":99,"_18":54,"_101":102,"_103":25},{"_13":86,"_32":87,"_42":41,"_88":43,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":44,"_95":96},"ctx",{"_79":-5,"_124":217,"_218":219,"_220":221,"_222":25,"_223":25,"_224":25,"_225":122,"_226":-5,"_227":-7,"_228":-7,"_229":60,"_230":25,"_231":25,"_232":-5,"_233":25,"_234":25,"_235":25,"_236":-5},"ENV",{"_188":189,"_190":191,"_192":87,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212,"_213":214,"_215":216},"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)

Open trips

\\ud83d\\udce6 Archived trips

\\ud83d\\udcb7 Payment log

Notifications

\\u270e Note for the shopper

\\u2699 Item options

\\uff0b Add item to trip

\\u270e Edit family

\\u2699 Group settings

\\u270e Edit trip

Share breakdown

Record a payment

Diff · v28