[{"_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",{"_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",35,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","Main.ts","latestPath","fileId","6e254e1e-7be1-11f1-a65a-1607ee4eb77e","name","fileType","http","content","// 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 — 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(\n items.reduce((s, it) =>\n s + ((byItem[it.id] || []).some((q) =>\n q.act > 0 && fam[q.family_id]\n )\n ? (it.total_price || 0)\n : 0), 0),\n );\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 // Regenerate until the code is unique; only ever INSERT a confirmed-free code.\n for (\n let i = 0;\n one(\n await sqlite.execute({\n sql: \"SELECT id FROM groups WHERE code=?\",\n args: [code],\n }),\n );\n i++\n ) {\n if (i >= 50) {\n return bad(\n c,\n \"Could not generate a unique group code — please try again\",\n );\n }\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 String(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 String(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 if (!trip) return { item, ok: false, why: \"Trip not found\" };\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 String(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;","createdAt",["D",1783998815264],"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":179,"_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":180,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":181,"_82":182,"_84":183,"_86":25},"tree",[166,167,168],"files",[166,167,168],"counts",{"_155":61,"_156":157,"_158":61,"_159":160,"_161":162},"contents",[128,129,130],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":151,"_32":28,"_30":31,"_134":-5,"_41":42,"_40":14,"_136":123,"_38":152,"_13":148,"_33":34,"_35":37,"_24":25,"_141":153,"_27":154},{"_43":143,"_32":144,"_30":145,"_134":-5,"_41":42,"_40":146,"_136":25,"_38":147,"_13":148,"_33":139,"_35":149,"_24":25,"_141":-5,"_27":150},{"_43":131,"_32":132,"_30":133,"_134":-5,"_41":42,"_40":135,"_136":25,"_38":137,"_13":138,"_33":139,"_35":140,"_24":25,"_141":-5,"_27":142},"d1aae46e-aa13-4b18-a867-e5c0c61a0df6","ui2.ts","60ec0b3e-7c04-11f1-8ab9-1607ee4eb77e","parentId",34,"latest",["D",1783675966605],4,"script","// SplitBasket UI v5 (part 2 of 2)\nexport const H2 =\n \"erLookup()\\\">\\uff0b We're a new family\\n \\n ${pickFam===-1?`

Family name

`:''}\\n

Your phone (identity only)

\\n `;\\n}\\nasync function joinGroup(){\\n if(!pickFam)return toast('Pick your family first');\\n try{\\n const res=await api('/api/join',{code:LOOKUP.group.code,family_id:pickFam>0?pickFam:null,\\n family_name:pickFam===-1?$('jFam').value.trim():null,phone:$('jPhone').value.trim()});\\n SB.phone=$('jPhone').value.trim();\\n if(!SB.groups.find(g=>g.id===res.group.id))SB.groups.push({id:res.group.id,name:res.group.name,familyId:res.family.id,familyName:res.family.name});\\n saveSB();CUR=res.group.id;await loadState(CUR);\\n toast('Welcome to '+res.group.name+' \\ud83c\\udf89');goHome();\\n }catch(e){oops(e);}\\n}\\nasync function createGroup(){\\n try{\\n const res=await api('/api/groups',{group_name:$('gName').value.trim(),family_name:$('gFam').value.trim(),\\n phone:$('gPhone').value.trim(),holder:$('gHolder').value.trim(),\\n bank:$('gBank').value.trim(),sort_code:$('gSort').value.trim(),acct:$('gAcct').value.trim()});\\n SB.phone=$('gPhone').value.trim();\\n SB.groups.push({id:res.group.id,name:res.group.name,familyId:res.family.id,familyName:res.family.name});\\n saveSB();CUR=res.group.id;await loadState(CUR);\\n toast('Group created \\u2014 share code '+res.group.code+' \\ud83c\\udf89');goHome();\\n }catch(e){oops(e);}\\n}\\n\\n/* ================= home / groups ================= */\\nasync function renderGroups(){\\n await loadAll();\\n let mine=0,owedTo='';\\n SB.groups.forEach(g=>{const st=STATES[g.id];if(!st)return;const n=st.net[g.familyId]||0;mine=r2(mine+n);});\\n $('homeHero').innerHTML=`\\n

\\n

Your overall position

\\n

${mine<0?('\\u2212'+gbp(Math.abs(mine))):mine>0?('+'+gbp(mine)):'\\u00a30.00'}

\\n

${mine<0?'You owe across your groups':mine>0?'You are owed across your groups':'All settled across your groups \\ud83c\\udf89'}

\\n

`;\\n $('groupList').innerHTML=SB.groups.map(g=>{\\n const st=STATES[g.id];if(!st)return'';\\n const open=st.trips.find(t=>!['settled','cancelled'].includes(t.status));\\n const n=st.net[g.familyId]||0;\\n return `

\\n

\\ud83e\\udd6c

\\n

${esc(st.group.name)}

\\n

${st.families.map(f=>esc(f.name)).join(' \\u00b7 ')}

\\n

\\n ${open?`Trip ${esc(open.date||'open')}`:'No open trip'}\\n

${n<0?`You owe ${gbp(Math.abs(n))}`:n>0?`Owed ${gbp(n)}`:'Settled \\u2713'}

\\n

`;\\n }).join('')||'

No groups yet

';\\n}\\nasync function openGroup(gid){CUR=gid;await loadState(gid);go('s-group',STATES[gid].group.name,STATES[gid].families.length+' families \\u00b7 code '+STATES[gid].group.code);}\\n\\n/* ================= group detail ================= */\\nfunction statusChip(s){return {planning:'Planning',locked:'Locked',\\n settling:'Settling',settled:'Settled \\u2713',\\n cancelled:'Cancelled'}[s]||'';}\\nlet showArchived=false;\\nfunction tripCard(t){\\n return `

\\n

\\ud83e\\uddfa

\\n

${esc(t.title)}

\\n

${esc(t.date||'')}${t.location?' \\u00b7 '+esc(t.location):''} \\u00b7 ${esc(FAM(t.shopper_family_id).name)} shopping${t.receipt?' \\u00b7 '+gbp(t.receipt):''}

\\n ${t.archived?'\\ud83d\\udce6 Archived':statusChip(t.status)}\\n

`;\\n}\\nfunction renderGroup(){\\n const st=STATES[CUR];if(!st)return;\\n const activeTrips=st.trips.filter(t=>!t.archived);\\n const archTrips=st.trips.filter(t=>!!t.archived);\\n $('groupDetail').innerHTML=`\\n

\\n

\\ud83e\\udd6c

\\n

${esc(st.group.name)}

\\n

GBP \\u00a3 \\u00b7 admin: ${esc(FAM(st.group.admin_family_id).name)}${isAdmin()?' (you)':''}

\\n \\n

\\n

${st.families.map(f=>`${ini(f.name)}`).join('')}

\\n ${esc(st.group.code)}\\n

\\n

Anyone with this code can join as a family. Tap the code to share it on WhatsApp.

\\n

\\n\\n

\\ud83c\\udfe6 Payment details \\u2014 members only

\\n

\\n ${st.families.map(f=>{const canEdit=f.id===myFam()||isAdmin();return `

\\n \\n

${esc(f.name)}${f.id===st.group.admin_family_id?' admin':''}${f.holder?` \\u00b7 ${esc(f.holder)} \\u00b7 ${esc(f.bank)}
Sort ${esc(f.sort_code)} \\u00b7 Acct ${esc(f.acct)}`:'
No details added yet'}

\\n

\\n ${f.holder?``:''}\\n ${canEdit?``:''}\\n

\\n

`;}).join('')}\\n

Each family can edit its own details any time (the admin can too). Account info only, attached to payment requests.

\\n

\\n\\n

Trips

\\n ${activeTrips.map(tripCard).join('')||'

No open trips \\u2014 plan one!

'}\\n ${archTrips.length?`

\\ud83d\\udce6 ${archTrips.length} archived trip${archTrips.length>1?'s':''} moved to the History tab.

`:''}\\n\\n

Group balance (all trips)

\\n

\\n ${st.families.map(f=>{const n=st.net[f.id]||0;return `

\\n

${esc(f.name)}${f.id===myFam()?' (you)':''}

\\n 0?'pos':''}\\\">${n<0?'\\u2212':n>0?'+':''}${gbp(Math.abs(n))}

`;}).join('')}\\n

\\n \\n

\\n\\n `;\\n}\\nfunction shareCode(){\\n const st=STATES[CUR];\\n const t=`\\ud83e\\uddfa Join our grocery group *${st.group.name}* on SplitBasket!\\\\nOpen ${location.origin} and enter code *${st.group.code}*`;\\n window.open('https://wa.me/?text='+encodeURIComponent(t),'_blank');\\n}\\nfunction copyBank(fid){\\n const f=(STATES[CUR]?.families||[]).find(x=>x.id===fid);if(!f)return;\\n const txt=`${f.holder} \\u00b7 ${f.bank} \\u00b7 Sort ${f.sort_code} \\u00b7 Acct ${f.acct}`;\\n try{navigator.clipboard.writeText(txt);toast('\\ud83d\\udccb Copied: '+f.bank+' details');}catch(e){toast('\\ud83d\\udccb '+txt);}\\n}\\n\\n/* ================= edit family / group / trip ================= */\\nlet editFamId=null;\\nfunction openFamEdit(fid){\\n const f=(STATES[CUR]?.families||[]).find(x=>x.id===fid);if(!f)return;\\n editFamId=fid;\\n $('famSheetTitle').textContent='\\u270e '+famLabel(f.name);\\n $('fName').value=f.name;$('fHolder').value=f.holder||'';$('fBank').value=f.bank||'';\\n $('fSort').value=f.sort_code||'';$('fAcct').value=f.acct||'';\\n $('famRemoveWrap').style.display=(isAdmin()&&fid!==myFam())?'block':'none';\\n $('famSheet').classList.add('show');\\n}\\nasync function removeFam(){\\n const f=(STATES[CUR]?.families||[]).find(x=>x.id===editFamId);\\n if(!confirm('Remove '+famLabel(f.name)+' from the group? Only possible if they have no purchase/payment history.'))return;\\n try{\\n await api('/api/families/'+editFamId+'/delete',{by_family_id:myFam()});\\n $('famSheet').classList.remove('show');\\n await loadState(CUR);renderGroup();\\n toast(famLabel(f.name)+' removed from group \\ud83d\\uddd1');\\n }catch(e){oops(e);}\\n}\\nasync function saveFam(){\\n try{\\n await api('/api/families/'+editFamId,{by_family_id:myFam(),name:$('fName').value,holder:$('fHolder').value.trim(),\\n bank:$('fBank').value.trim(),sort_code:$('fSort').value.trim(),acct:$('fAcct').value.trim()});\\n $('famSheet').classList.remove('show');\\n const mine=SB.groups.find(g=>g.id===CUR);\\n if(mine&&editFamId===mine.familyId){mine.familyName=$('fName').value.trim()||mine.familyName;saveSB();}\\n await loadState(CUR);renderGroup();toast('Family details saved \\u2713');\\n }catch(e){oops(e);}\\n}\\nfunction openGroupEdit(){\\n const st=STATES[CUR];\\n $('gEditName').value=st.group.name;\\n const admin=isAdmin();\\n $('gEditName').disabled=!admin;$('gRenameBtn').style.display=admin?'block':'none';\\n $('gDeleteBtn').style.display=admin?'block':'none';\\n $('gSheetHint').textContent=admin\\n ?'Deleting wipes the group, its trips and history for everyone \\u2014 there is no undo.'\\n :'Only the group admin ('+FAM(st.group.admin_family_id).name+') can rename or delete this group.';\\n $('groupSheet').classList.add('show');\\n}\\nasync function saveGroupName(){\\n try{\\n await api('/api/groups/'+CUR,{by_family_id:myFam(),name:$('gEditName').value});\\n $('groupSheet').classList.remove('show');\\n const mine=SB.groups.find(g=>g.id===CUR);if(mine)mine.name=$('gEditName').value.trim();saveSB();\\n await loadState(CUR);\\n go('s-group',STATES[CUR].group.name,STATES[CUR].families.length+' families \\u00b7 code '+STATES[CUR].group.code);\\n toast('Group renamed \\u2713');\\n }catch(e){oops(e);}\\n}\\nfunction leaveGroup(){\\n if(!confirm('Leave this group? It disappears from this device \\u2014 data stays on the server and you can rejoin with the share code.'))return;\\n SB.groups=SB.groups.filter(g=>g.id!==CUR);saveSB();\\n delete STATES[CUR];CUR=SB.groups[0]?.id||null;\\n $('groupSheet').classList.remove('show');\\n toast('Left the group');\\n SB.groups.length?goHome():show('s-join','SplitBasket','Join your group');\\n}\\nasync function deleteGroup(){\\n if(!confirm('Delete this group PERMANENTLY for everyone? All trips, items and history will be wiped. This cannot be undone.'))return;\\n if(!confirm('Really sure? Last chance.'))return;\\n try{\\n await api('/api/groups/'+CUR+'/delete',{by_family_id:myFam()});\\n SB.groups=SB.groups.filter(g=>g.id!==CUR);saveSB();\\n delete STATES[CUR];CUR=SB.groups[0]?.id||null;\\n $('groupSheet').classList.remove('show');\\n toast('Group deleted');\\n SB.groups.length?goHome():show('s-join','SplitBasket','Join your group');\\n }catch(e){oops(e);}\\n}\\nfunction openTripEdit(){\\n const t=TRIP.trip;const st=STATES[CUR];\\n $('eTitle').value=t.title;$('eDate').value=t.date||'';$('eLoc').value=t.location||'';\\n $('eShopper').innerHTML=st.families.map(f=>``).join('');\\n $('eUnlock').style.display=['locked','settling'].includes(t.status)?'inline-block':'none';\\n $('eArchive').textContent=t.archived?'\\ud83d\\udce4 Unarchive':'\\ud83d\\udce6 Archive';\\n $('eArchive').style.display=(t.status==='settled'||t.archived)?'inline-block':'none';\\n $('tripSheet').classList.add('show');\\n}\\nasync function saveTripEdit(){\\n try{\\n await api('/api/trips/'+curTripId+'/update',{by_family_id:myFam(),title:$('eTitle').value,\\n date:$('eDate').value,location:$('eLoc').value,shopper_family_id:Number($('eShopper').value)});\\n $('tripSheet').classList.remove('show');\\n await loadTrip(curTripId);await loadState(CUR);\\n refreshScreen(document.querySelector('.screen.active')?.id);\\n toast('Trip updated \\u2713');\\n }catch(e){oops(e);}\\n}\\nasync function unlockTrip(){\\n try{\\n await api('/api/trips/'+curTripId+'/update',{by_family_id:myFam(),status:'planning'});\\n $('tripSheet').classList.remove('show');\\n await loadTrip(curTripId);await loadState(CUR);\\n go('s-trip',TRIP.trip.title,TRIP.trip.date||'');\\n toast('Unlocked \\u2014 families can change picks again \\ud83d\\udd13');\\n }catch(e){oops(e);}\\n}\\nasync function toggleArchive(){\\n try{\\n const to=TRIP.trip.archived?0:1;\\n await api('/api/trips/'+curTripId+'/update',{by_family_id:myFam(),archived:to});\\n $('tripSheet').classList.remove('show');\\n await loadTrip(curTripId);await loadState(CUR);\\n toast(to?'Trip archived \\u2014 find it in History \\ud83d\\udce6':'Trip unarchived \\ud83d\\udce4');\\n to?navHist():go('s-group',STATES[CUR].group.name,STATES[CUR].families.length+' families \\u00b7 code '+STATES[CUR].group.code);\\n }catch(e){oops(e);}\\n}\\nasync function deleteTrip(){\\n if(!confirm('Delete this trip and all its items? This cannot be undone.'))return;\\n try{\\n await api('/api/trips/'+curTripId+'/delete',{by_family_id:myFam()});\\n $('tripSheet').classList.remove('show');\\n curTripId=null;TRIP=null;\\n await loadState(CUR);\\n go('s-group',STATES[CUR].group.name,STATES[CUR].families.length+' families \\u00b7 code '+STATES[CUR].group.code);\\n toast('Trip deleted \\ud83d\\uddd1');\\n }catch(e){oops(e);}\\n}\\n\\n/* ================= new trip ================= */\\nfunction renderNewTrip(){\\n const st=STATES[CUR];if(!st)return;\\n $('tShopper').innerHTML=st.families.map(f=>``).join('');\\n}\\nasync function createTrip(){\\n try{\\n const res=await api('/api/trips',{group_id:CUR,title:$('tTitle').value.trim()||'Grocery run',\\n date:$('tDate').value,location:$('tLoc').value.trim(),shopper_family_id:Number($('tShopper').value),\\n created_by_family_id:myFam()});\\n await loadState(CUR);toast('Trip created \\u2014 time to make picks \\ud83e\\uddfa');\\n openTrip(res.trip.id);\\n }catch(e){oops(e);}\\n}\\nasync function openTrip(id){\\n await loadTrip(id);if(!TRIP)return;\\n const t=TRIP.trip;\\n const sub=`${t.date||''}${t.location?' \\u00b7 '+t.location:''}`;\\n if(t.status==='planning')go('s-trip',t.title,sub);\\n else if(t.status==='locked')go('s-shop',canShopNow(t)?'Shopping mode':'Watching live \\ud83d\\udc40',\\n famLabel(FAM(t.shopper_family_id).name)+(canShopNow(t)?' \\u00b7 enter receipt totals':' is shopping'));\\n else go('s-split','Breakdown',t.title+' \\u00b7 '+gbp(compute(TRIP).receipt));\\n}\\n\\n/* ================= trip planning ================= */\\nfunction qbadges(itemId){\\n const qs=(TRIP.qty||[]).filter(q=>q.item_id===itemId&&q.req>0);\\n return '

'+qs.map(q=>{const f=FAM(q.family_id);\\n return `${esc(f.name)} \\u00b7 ${q.req}`;}).join('')+'

';\\n}\\nfunction myQty(itemId){return (TRIP.qty||[]).find(q=>q.item_id===itemId&&q.family_id===myFam())||{req:0,act:0,note:''};}\\nfunction renderItems(){\\n if(!TRIP)return;\\n const t=TRIP.trip;\\n $('tripHead').innerHTML=`

\\n

How many does your family want? \\ud83e\\udd55

\\n

${esc(famLabel(FAM(t.shopper_family_id).name))} shops ${esc(t.date||'soon')} \\u00b7 created by ${esc(FAM(t.created_by_family_id).name)}

\\n ${canManageTrip(t)?``:''}\\n ${statusChip(t.status)}

`;\\n const canOps=it=>t.status==='planning'&&(it.created_by===myFam()||canManageTrip(t));\\n $('itemList').innerHTML=TRIP.items.map(it=>{\\n const q=myQty(it.id);\\n return `

\\n

${esc(it.emoji)} ${esc(it.name)}

\\n

${esc(it.unit)}${it.created_by?' \\u00b7 added by '+esc(FAM(it.created_by).name):''}

\\n ${canOps(it)?``:''}\\n \\n

\\n \\n

${q.req||'\\u2013'}

\\n \\n

\\n

\\n ${qbadges(it.id)}\\n ${q.note?`

\\u270e \\u201c${esc(q.note)}\\u201d

`:''}\\n

`;\\n }).join('')||'

No items yet \\u2014 add the first one below.

';\\n // Lock is only for the trip creator, group admin, or the shopper\\n $('lockBtn').style.display=(TRIP.items.length&&canShopNow(TRIP.trip))?'block':'none';\\n}\\nasync function step(itemId,d){\\n const q=myQty(itemId);const req=Math.max(0,(q.req||0)+d);\\n try{await api('/api/qty',{item_id:itemId,family_id:myFam(),req});await loadTrip(curTripId);renderItems();\\n const it=TRIP.items.find(i=>i.id===itemId);\\n toast(req?`${it.name}: ${req} ${it.unit_plural} for your family`:`${it.name}: removed for your family`);\\n }catch(e){oops(e);}\\n}\\nlet noteItem=0;\\nfunction openNote(itemId){\\n noteItem=itemId;const it=TRIP.items.find(i=>i.id===itemId);\\n $('noteTitle').textContent=`\\u270e ${it.emoji} ${it.name} \\u2014 note for the shopper`;\\n $('noteInput').value=myQty(itemId).note||'';\\n $('noteSheet').classList.add('show');\\n setTimeout(()=>$('noteInput').focus(),150);\\n}\\nasync function saveNote(){\\n try{await api('/api/qty',{item_id:noteItem,family_id:myFam(),note:$('noteInput').value.trim()});\\n $('noteSheet').classList.remove('show');await loadTrip(curTripId);renderItems();\\n toast($('noteInput').value.trim()?'Note saved \\u2014 the shopper will see it \\u270e':'Note cleared');\\n }catch(e){oops(e);}\\n}\\nlet tplManage=false;\\nfunction openAdd(keep){\\n if(!keep)tplManage=false;\\n const tpl=STATES[CUR]?.templates||[];\\n $('tplManageBtn').textContent=tplManage?'\\u2713 done':'\\ud83d\\uddd1 manage';\\n $('tplChips').innerHTML=tpl.map(t=>tplManage\\n ?``\\n :``).join('')||'No templates yet';\\n $('addSheet').classList.add('show');\\n}\\nasync function delTpl(tid){\\n const t=(STATES[CUR].templates||[]).find(x=>x.id===tid);\\n if(!confirm('Delete template \\\"'+t.name+'\\\"? (Existing trip items are not affected)'))return;\\n try{await api('/api/templates/'+tid+'/delete',{});await loadState(CUR);openAdd(true);toast('Template deleted \\ud83d\\uddd1');}catch(e){oops(e);}\\n}\\nlet itemId2=0;\\nfunction openItem(id){\\n const it=TRIP.items.find(x=>x.id===id);if(!it)return;\\n itemId2=id;\\n $('itemSheetTitle').textContent='\\u2699 '+it.emoji+' '+it.name;\\n $('iName').value=it.name;$('iEmoji').value=it.emoji;$('iUnit').value=it.unit||'';$('iUnitP').value=it.unit_plural||'';\\n $('itemSheet').classList.add('show');\\n}\\nasync function saveItem(){\\n try{\\n await api('/api/items/'+itemId2+'/update',{by_family_id:myFam(),name:$('iName').value,emoji:$('iEmoji').value.trim()||'\\ud83d\\uded2',\\n unit:$('iUnit').value.trim(),unit_plural:$('iUnitP').value.trim()||'units'});\\n $('itemSheet').classList.remove('show');\\n await loadTrip(curTripId);renderItems();toast('Item updated \\u2713');\\n }catch(e){oops(e);}\\n}\\nasync function deleteItem(){\\n const it=TRIP.items.find(x=>x.id===itemId2);\\n if(!confirm('Delete \\\"'+(it?.name||'this item')+'\\\" from the trip? All families\\\\' picks for it are removed too.'))return;\\n try{\\n await api('/api/items/'+itemId2+'/delete',{by_family_id:myFam()});\\n $('itemSheet').classList.remove('show');\\n await loadTrip(curTripId);renderItems();toast('Item deleted \\ud83d\\uddd1');\\n }catch(e){oops(e);}\\n}\\nasync function useTpl(tid){\\n const t=(STATES[CUR].templates||[]).find(x=>x.id===tid);\\n $('addSheet').classList.remove('show');\\n try{await api('/api/items',{trip_id:curTripId,emoji:t.emoji,name:t.name,unit:t.unit,unit_plural:t.unit_plural,family_id:myFam()});\\n await loadTrip(curTripId);renderItems();toast(t.emoji+' '+t.name+' added \\u2014 set your quantity');\\n }catch(e){oops(e);}\\n}\\nasync function addItem(){\\n const name=$('aName').value.trim();if(!name)return toast('Give the item a name');\\n $('addSheet').classList.remove('show');\\n try{\\n await api('/api/items',{trip_id:curTripId,emoji:$('aEmoji').value.trim()||'\\ud83d\\uded2',name,\\n unit:$('aUnit').value.trim(),unit_plural:$('aUnitP').value.trim()||'units',family_id:myFam()});\\n if($('aSave').checked)await api('/api/templates',{group_id:CUR,emoji:$('aEmoji').value.trim()||'\\ud83d\\uded2',name,unit:$('aUnit').value.trim(),unit_plural:$('aUnitP').value.trim()||'units'});\\n ['aName','aEmoji','aUnit','aUnitP'].forEach(i=>$(i).value='');\\n await Promise.all([loadTrip(curTripId),loadState(CUR)]);\\n renderItems();toast(name+' added \\u2014 set your quantity');\\n }catch(e){oops(e);}\\n}\\nasync function lockTrip(){\\n try{await api('/api/trips/'+curTripId+'/status',{status:'locked'});await loadTrip(curTripId);await loadState(CUR);\\n toast('List locked \\ud83d\\udd12 \\u2014 families can no longer change picks');\\n setTimeout(()=>go('s-shop','Shopping mode',FAM(TRIP.trip.shopper_family_id).name+' Family \\u00b7 enter receipt totals'),400);\\n }catch(e){oops(e);}\\n}\\n\\n/* ================= shopping ================= */\\nfunction renderShop(){\\n if(!TRIP)return;\\n const c=compute(TRIP);\\n const editable=canShopNow(TRIP.trip);\\n $('shopBanner').innerHTML=editable\\n ?`

\\ud83d\\udd12 List locked \\u00b7 Shopping as ${esc(famLabel(FAM(TRIP.trip.shopper_family_id).name))}

`\\n :`

\\ud83d\\udc40 ${esc(famLabel(FAM(TRIP.trip.shopper_family_id).name))} is shopping \\u2014 you're watching prices arrive live. Nothing to do yet.

`;\\n $('shopList').innerHTML=c.lines.filter(l=>l.qs.length||((TRIP.qty||[]).some(q=>q.item_id===l.id&&q.req>0))).map(l=>{\\n const rqs=(TRIP.qty||[]).filter(q=>q.item_id===l.id&&(q.req>0||q.act>0));\\n const adjusted=rqs.some(q=>q.act!==q.req);\\n const notes=rqs.filter(q=>q.note).map(q=>`${FAM(q.family_id).name}: \\u201c${esc(q.note)}\\u201d`).join(' \\u00b7 ');\\n return `

\\n

${esc(l.emoji)} ${esc(l.name)}

\\n

${esc(l.unit)} \\u00b7 bought ${l.bought} ${esc(l.unit_plural)}${l.bought?' \\u00b7 '+gbp(l.unit)+'/each':''}

\\n ${editable\\n ?`

Line total \\u00a3\\n

`\\n :`

Line total\\n

${gbp(l.total_price||0)}

`}\\n

\\n

\\n ${rqs.map(q=>{const f=FAM(q.family_id);return editable\\n ?`

${esc(f.name)}\\n \\n

${q.act}

\\n

`\\n :`${esc(f.name)} \\u00b7 ${q.act}`;}).join('')}\\n

\\n ${adjusted?`\\u270f\\ufe0f Adjusted: ${rqs.filter(q=>q.act!==q.req).map(q=>`${esc(FAM(q.family_id).name)} requested ${q.req} \\u2192 got ${q.act}`).join(' \\u00b7 ')}`:''}\\n ${notes?`

\\u270e ${notes}

`:''}\\n

`;\\n }).join('')||'

No items with picks yet.

';\\n $('extrasCard').innerHTML=TRIP.extras.map(x=>`\\n

\\n

${x.name==='Fuel expense'?'\\u26fd ':x.name==='Parking fee'?'\\ud83c\\udd7f\\ufe0f ':''}${esc(x.name)}\\n ${x.mode==='eq'?'equal':'\\u221d items'}

\\n ${editable\\n ?`

${x.amount<0?'\\u2212\\u00a3':'\\u00a3'}

`\\n :`${sgn(x.amount)}`}\\n

`).join('')+\\n (editable?`

Bag fee & discounts split \\u221d item totals \\u00b7 fuel & parking split equally per family. Enter discounts as positive \\u2014 stored negative automatically.

`:'');\\n $('shopTotal').textContent=gbp(c.receipt);\\n $('shopTotalSub').textContent=`Items ${gbp(c.itemsTotal)} \\u00b7 extras ${sgn(c.propTotal)} \\u00b7 fuel+parking ${gbp(c.eqTotal)}`;\\n $('doneBtn').style.display=editable?'block':'none';\\n}\\nasync function setPrice(itemId,el){\\n const v=Math.abs(parseFloat(el.value)||0);el.value=v.toFixed(2);\\n try{await api('/api/items/'+itemId+'/price',{total:v});await loadTrip(curTripId);renderShop();toast('Line total updated \\u2014 split recalculated');}catch(e){oops(e);}\\n}\\nasync function setExtra(id,name,el){\\n let v=Math.abs(parseFloat(el.value)||0);el.value=v.toFixed(2);\\n if(/discount/i.test(name))v=-v;\\n try{await api('/api/extras/'+id,{amount:v});await loadTrip(curTripId);renderShop();toast(name+' updated \\u2014 split recalculated');}catch(e){oops(e);}\\n}\\nasync function adjAct(itemId,famId,d){\\n const q=(TRIP.qty||[]).find(x=>x.item_id===itemId&&x.family_id===famId);\\n const act=Math.max(0,(q?.act||0)+d);\\n try{await api('/api/qty',{item_id:itemId,family_id:famId,act});await loadTrip(curTripId);renderShop();\\n toast(`${FAM(famId).name} now gets ${act} \\u2014 split recalculated`);}catch(e){oops(e);}\\n}\\nasync function toSplit(){\\n try{await api('/api/trips/'+curTripId+'/status',{status:'settling'});await loadTrip(curTripId);await loadState(CUR);\\n go('s-split','Breakdown',TRIP.trip.title+' \\u00b7 '+gbp(compute(TRIP).receipt));}catch(e){oops(e);}\\n}\\n\\n/* ================= breakdown ================= */\\nfunction renderSplit(){\\n if(!TRIP)return;\\n const c=compute(TRIP);const t=TRIP.trip;const buyer=t.shopper_family_id;\\n const pct=f=>c.receipt?(c.fam[f].final/c.receipt*100).toFixed(1):'0.0';\\n $('pfolio').innerHTML=TRIP.families.map(f=>`\\n

\\n

${esc(f.name)}${f.id===myFam()?' (you)':''}

\\n

${gbp(c.fam[f.id].final)}

\\n

${c.fam[f.id].units} units \\u00b7 ${pct(f.id)}% of trip
\\n ${f.id===buyer?`paid ${gbp(c.receipt)} \\u00b7 gets back ${gbp(r2(c.receipt-c.fam[f.id].final))}`\\n :`items ${gbp(c.fam[f.id].items)} ${c.fam[f.id].extra<0?'\\u2212':'+'} extras ${gbp(Math.abs(c.fam[f.id].extra))}`}

\\n

`).join('');\\n const rows=c.lines.filter(l=>l.bought>0).map((l,i)=>{\\n const fams=l.qs.map(q=>q.family_id);\\n return `

\\n

${esc(l.emoji)}

\\n

${esc(l.name)}

\\n

${l.bought} ${esc(l.unit_plural)} \\u00d7 ${gbp(l.unit)} \\u00b7 ${fams.length} famil${fams.length>1?'ies':'y'}

\\n

${gbp(l.total_price)}

\\n

your share ${gbp(l.shares[myFam()]||0)}

\\n \\u25be\\n

\\n

${l.qs.map(q=>``).join('')}

\\n ${l.qs.map(q=>`

\\n \\n ${esc(FAM(q.family_id).name)}\\n ${q.act} ${esc(l.unit_plural)}${q.act!==q.req?` \\u270f\\ufe0f req ${q.req} \\u2192 got ${q.act}`:''}\\n ${gbp(l.shares[q.family_id])}

`).join('')}\\n ${l.qs.filter(q=>q.note).map(q=>`

\\u270e ${esc(FAM(q.family_id).name)}: ${esc(q.note)}

`).join('')}\\n

\\n

`;\\n }).join('');\\n const ex=`

\\n

\\ud83e\\uddfe

\\n

Extras, fuel & parking

\\n

fees \\u221d items \\u00b7 fuel/parking equal

\\n

${sgn(r2(c.propTotal+c.eqTotal))}

\\n

your share ${sgn(c.fam[myFam()]?.extra||0)}

\\n \\u25be\\n

\\n

\\n ${TRIP.extras.map(x=>`

${esc(x.name)}${x.mode==='prop'?'\\u221d items':'equal'}${sgn(x.amount)}

`).join('')}\\n

\\n ${c.active.map(f=>`

\\n ${esc(FAM(f).name)}\\n ${sgn(c.fam[f].prop)} \\u221d \\u00b7 ${sgn(c.fam[f].eq)} eq\\n ${sgn(c.fam[f].extra)}

`).join('')}\\n

\\n

`;\\n $('tickerList').innerHTML=rows+ex;\\n const famSum=r2(TRIP.families.reduce((s,f)=>s+c.fam[f.id].final,0));\\n $('famTotal').textContent=gbp(famSum);\\n $('receiptTotal').textContent=gbp(c.receipt)+(Math.abs(famSum-c.receipt)<0.005?' \\u2713':' \\u2717');\\n $('shareBtns').innerHTML=TRIP.families.map(f=>\\n ``).join('');\\n $('finaliseBtn').style.display=(t.status!=='settled'&&canShopNow(t))?'block':'none';\\n}\\nlet shareText='';\\nfunction snapCard(fid){\\n const c=compute(TRIP);const t=TRIP.trip;const buyer=FAM(t.shopper_family_id);\\n if(fid==='ALL'){\\n const debt=TRIP.families.filter(f=>f.id!==t.shopper_family_id&&c.fam[f.id].final>0);\\n return `

\\n

\\ud83e\\uddfa ${esc(STATES[CUR].group.name)} \\u00b7 ${esc(t.title)}

${esc(t.date||'')} \\u00b7 ${esc(buyer.name)} shopped \\u00b7 trip total ${gbp(c.receipt)}

\\n

\\n ${TRIP.families.map(f=>`

\\u25a0 ${esc(f.name)}${f.id===t.shopper_family_id?' (paid)':''}${gbp(c.fam[f.id].final)}

`).join('')}\\n

Trip total${gbp(c.receipt)} \\u2713

\\n

\\ud83d\\udcb8 ${debt.map(f=>`${esc(f.name)} \\u2192 ${esc(buyer.name)} ${gbp(c.fam[f.id].final)}`).join(' \\u00b7 ')||'Nothing owed'}

\\n

`;\\n }\\n const f=FAM(fid);const mine=c.lines.filter(l=>l.shares[fid]!==undefined);\\n return `

\\n

\\ud83e\\uddfa ${esc(STATES[CUR].group.name)} \\u00b7 ${esc(t.title)}

${esc(t.date||'')} \\u00b7 ${esc(f.name)} Family's share

\\n

\\n ${mine.map(l=>{const q=l.qs.find(q=>q.family_id===fid);return `

${esc(l.emoji)} ${q.act} \\u00d7 ${esc(l.name)} @ ${gbp(l.unit)}${gbp(l.shares[fid])}

`;}).join('')}\\n

Fees & discounts (\\u221d items)${sgn(c.fam[fid].prop)}

\\n

Fuel & parking (equal)${sgn(c.fam[fid].eq)}

\\n

${esc(f.name)} Family total${gbp(c.fam[fid].final)}

\\n

${fid===t.shopper_family_id?`\\u2705 Paid ${gbp(c.receipt)} \\u2014 gets back ${gbp(r2(c.receipt-c.fam[fid].final))}`:`\\ud83d\\udcb8 Pay ${esc(buyer.name)} Family ${gbp(c.fam[fid].final)}`}

\\n

`;\\n}\\nfunction snapText(fid){\\n const c=compute(TRIP);const t=TRIP.trip;const buyer=FAM(t.shopper_family_id);\\n let s=`\\ud83e\\uddfa *${STATES[CUR].group.name} \\u2014 ${t.title}* (${t.date||''})\\\\n`;\\n if(fid==='ALL'){\\n TRIP.families.forEach(f=>{s+=`${f.name}${f.id===t.shopper_family_id?' (paid)':''}: ${gbp(c.fam[f.id].final)}\\\\n`;});\\n s+=`Trip total: ${gbp(c.receipt)}\\\\n`;\\n s+=TRIP.families.filter(f=>f.id!==t.shopper_family_id&&c.fam[f.id].final>0).map(f=>`\\ud83d\\udcb8 ${f.name} \\u2192 ${buyer.name} ${gbp(c.fam[f.id].final)}`).join('\\\\n');\\n }else{\\n const f=FAM(fid);s+=`*${f.name} Family's share*\\\\n`;\\n c.lines.filter(l=>l.shares[fid]!==undefined).forEach(l=>{const q=l.qs.find(q=>q.family_id===fid);s+=`${q.act} \\u00d7 ${l.name} @ ${gbp(l.unit)} = ${gbp(l.shares[fid])}\\\\n`;});\\n s+=`Fees/discounts: ${sgn(c.fam[fid].prop)} \\u00b7 Fuel/parking: ${sgn(c.fam[fid].eq)}\\\\n*Total: ${gbp(c.fam[fid].final)}*\\\\n`;\\n s+=fid===t.shopper_family_id?`\\u2705 Paid ${gbp(c.receipt)}`:`\\ud83d\\udcb8 Pay ${buyer.name} Family ${gbp(c.fam[fid].final)}`;\\n if(buyer.holder)s+=`\\\\n\\ud83c\\udfe6 ${buyer.holder} \\u00b7 ${buyer.bank} \\u00b7 Sort ${buyer.sort_code} \\u00b7 Acct ${buyer.acct}`;\\n }\\n return s;\\n}\\nfunction openShare(fid){\\n $('shareTitle').textContent=fid==='ALL'?'Share with all families':'Share with '+FAM(fid).name+' Family';\\n $('shareCard').innerHTML=snapCard(fid);\\n shareText=snapText(fid);\\n $('shareModal').classList.add('show');\\n}\\nfunction shareWA(){\\n $('shareModal').classList.remove('show');\\n toast('Opening WhatsApp\\u2026 \\ud83d\\udfe2');\\n window.open('https://wa.me/?text='+encodeURIComponent(shareText),'_blank');\\n}\\nasync function finishTrip(){\\n try{await api('/api/trips/'+curTripId+'/status',{status:'settled'});await loadTrip(curTripId);await loadState(CUR);\\n toast('Split finalised \\ud83d\\udcb7 \\u2014 settle from the Balances tab');\\n setTimeout(()=>navBal(),450);}catch(e){oops(e);}\\n}\\n\\n/* ================= balances / settlement ================= */\\nfunction suggestions(){\\n const st=STATES[CUR];if(!st)return[];\\n const debt=st.families.filter(f=>(st.net[f.id]||0)<-0.004).map(f=>({f,amt:-st.net[f.id]})).sort((a,b)=>b.amt-a.amt);\\n const cred=st.families.filter(f=>(st.net[f.id]||0)>0.004).map(f=>({f,amt:st.net[f.id]})).sort((a,b)=>b.amt-a.amt);\\n const out=[];let i=0,j=0;\\n const d=debt.map(x=>({...x})),c=cred.map(x=>({...x}));\\n while(i0.004)out.push({from:d[i].f,to:c[j].f,amount:pay});\\n d[i].amt=r2(d[i].amt-pay);c[j].amt=r2(c[j].amt-pay);\\n if(d[i].amt<0.005)i++;if(c[j].amt<0.005)j++;\\n }\\n return out;\\n}\\nfunction renderBalances(){\\n const st=STATES[CUR];if(!st)return;\\n const me=st.net[myFam()]||0;\\n const openTripId=st.trips.find(t=>!['settled','cancelled'].includes(t.status))?.id||st.trips[0]?.id;\\n $('balHero').innerHTML=`\\n

\\n

${esc(st.group.name)} \\u00b7 running balance (all trips)

\\n

${me<-0.004?('You owe '+gbp(Math.abs(me))):me>0.004?('You are owed '+gbp(me)):'All settled \\ud83c\\udf89'}

\\n

${me<-0.004||me>0.004?'across all trips in this group':(esc(FAMSelf())+' owes nothing')}

\\n ${openTripId?``:''}\\n

`;\\n const sugg=suggestions();\\n $('settleList').innerHTML=(sugg.map((s,i)=>`\\n

\\n

\\ud83d\\udcb8

\\n

${esc(s.from.name)} \\u2192 ${esc(s.to.name)} ${gbp(s.amount)}

\\n ${(st.requested||[]).includes(s.from.id)?'\\ud83d\\udcac Requested':'Pending'}\\n

\\n

\\n \\n \\n

\\n

`).join('')||`

\\ud83c\\udf89

\\n

Everything is settled

Settled \\u2713

`)+\\n (sugg.length?`

\\n `:'')+\\n `

Requests open WhatsApp pre-filled with the amount + the payee's bank details. Money moves by bank transfer; the app is the ledger.

`;\\n const openTrips=st.trips.filter(t=>!t.archived);\\n $('activityList').innerHTML=openTrips.map(t=>`\\n

\\ud83e\\uddfe

${esc(t.title)} \\u2014 ${statusChip(t.status)} ${t.receipt?gbp(t.receipt):''}\\n

${esc(t.date||'')}

`).join('')\\n ||'

No open trips \\u2014 settled history lives in the History tab \\ud83d\\udce6

';\\n}\\nfunction payReqText(s){\\n const to=s.to;\\n let t=`Hi ${s.from.name} Family! \\ud83e\\uddfa Your ${STATES[CUR].group.name} balance is *${gbp(s.amount)}* owed to ${to.name} Family.\\\\n`;\\n if(to.holder)t+=`Please pay:\\\\n\\ud83c\\udfe6 ${to.holder} \\u00b7 ${to.bank}\\\\nSort ${to.sort_code} \\u00b7 Account ${to.acct}\\\\n`;\\n t+=`Sent from SplitBasket \\u2705 ${location.origin}`;\\n return t;\\n}\\nlet SUGG=[];\\nasync function requestPay(i){\\n const s=suggestions()[i];if(!s)return;\\n const tid=STATES[CUR].trips.find(t=>!t.archived&&(t.status==='settling'||t.status==='settled'))?.id\\n ||STATES[CUR].trips.find(t=>!t.archived)?.id;\\n toast('Opening WhatsApp with the payment request\\u2026 \\ud83d\\udfe2');\\n window.open('https://wa.me/?text='+encodeURIComponent(payReqText(s)),'_blank');\\n if(tid){try{await api('/api/requests',{trip_id:tid,family_id:s.from.id});await loadState(CUR);renderBalances();}catch(_e){}}\\n}\\nasync function remindAll(){\\n const sugg=suggestions();if(!sugg.length)return;\\n let t=`\\ud83e\\uddfa *${STATES[CUR].group.name} \\u2014 settle up!*\\\\n`+sugg.map(s=>`${s.from.name} \\u2192 ${s.to.name}: *${gbp(s.amount)}*`).join('\\\\n');\\n const banks=[...new Set(sugg.map(s=>s.to.id))].map(id=>FAM(id)).filter(f=>f.holder)\\n .map(f=>`\\ud83c\\udfe6 ${f.name}: ${f.holder} \\u00b7 ${f.bank} \\u00b7 Sort ${f.sort_code} \\u00b7 Acct ${f.acct}`).join('\\\\n');\\n if(banks)t+='\\\\n'+banks;\\n toast('Opening WhatsApp \\u2014 pick the group chat \\ud83d\\udfe2');\\n window.open('https://wa.me/?text='+encodeURIComponent(t),'_blank');\\n const tid=STATES[CUR].trips.find(x=>!x.archived&&(x.status==='settling'||x.status==='settled'))?.id\\n ||STATES[CUR].trips.find(x=>!x.archived)?.id;\\n if(tid){try{\\n for(const s of sugg)await api('/api/requests',{trip_id:tid,family_id:s.from.id});\\n await loadState(CUR);renderBalances();\\n }catch(_e){}}\\n}\\nlet paySugg=null;\\nfunction openModal(i){\\n paySugg=suggestions()[i];if(!paySugg)return;\\n $('mFrom').value=paySugg.from.name+' Family';\\n $('mTo').value=paySugg.to.name+' Family';\\n $('mAmt').value=paySugg.amount.toFixed(2);\\n $('mBank').innerHTML=paySugg.to.holder?\\n `${esc(paySugg.to.holder)} \\u00b7 ${esc(paySugg.to.bank)}
Sort ${esc(paySugg.to.sort_code)} \\u00b7 Acct ${esc(paySugg.to.acct)}\\n `\\n :'No bank details saved for this family yet';\\n $('modal').classList.add('show');\\n}\\nasync function recordPayment(){\\n if(!paySugg)return;\\n $('modal').classList.remove('show');\\n try{\\n const tid=STATES[CUR].trips.find(t=>t.status==='settling'||t.status==='settled')?.id||null;\\n await api('/api/payments',{trip_id:tid,group_id:CUR,from_family_id:paySugg.from.id,to_family_id:paySugg.to.id,\\n amount:parseFloat($('mAmt').value)||paySugg.amount,method:$('mMethod').value,reference:$('mRef').value.trim()});\\n await loadState(CUR);\\n // auto-archive: when the whole group is square, settled trips tidy themselves away\\n const st=STATES[CUR];\\n if(st.families.every(f=>Math.abs(st.net[f.id]||0)<0.005)){\\n const done=st.trips.filter(t=>t.status==='settled'&&!t.archived);\\n for(const t of done)await api('/api/trips/'+t.id+'/update',{by_family_id:myFam(),archived:1}).catch(()=>{});\\n if(done.length){await loadState(CUR);toast('All square \\ud83c\\udf89 \\u2014 settled trips auto-archived \\ud83d\\udce6');}\\n }\\n renderBalances();\\n toast(paySugg.from.name+' \\u2192 '+paySugg.to.name+' recorded \\u2014 Settled \\u2713');\\n }catch(e){oops(e);}\\n}\\n\\n/* ================= notifications ================= */\\nfunction openSheet(){\\n const st=STATES[CUR];const items=[];\\n if(st){\\n st.trips.filter(t=>t.status==='planning').forEach(t=>items.push(['\\u23f0',`Make your picks! ${esc(t.title)} is in planning.`]));\\n st.trips.filter(t=>t.status==='locked').forEach(t=>items.push(['\\ud83d\\udd12',`List locked. ${esc(FAM(t.shopper_family_id).name)} Family is shopping for ${esc(t.title)}.`]));\\n const me=st.net[myFam()]||0;\\n if(me<-0.004)items.push(['\\ud83d\\udcb7',`You owe ${gbp(Math.abs(me))} in ${esc(st.group.name)}. Settle from the Balances tab.`]);\\n }\\n $('notifList').innerHTML=items.map(x=>`

${x[0]}

${x[1]}

`).join('')\\n ||'

Nothing needs your attention \\ud83c\\udf89

';\\n $('sheet').classList.add('show');\\n}\\nlet tmr;\\nfunction toast(msg){const t=$('toast');t.textContent=msg;t.classList.add('show');clearTimeout(tmr);tmr=setTimeout(()=>t.classList.remove('show'),2200);}\\n\\n/* ================= polling & boot ================= */\\nsetInterval(async()=>{\\n if(document.hidden)return;\\n const cur=document.querySelector('.screen.active')?.id;\\n try{\\n if(['s-trip','s-shop','s-split'].includes(cur)&&curTripId){\\n const before=JSON.stringify(TRIP);await loadTrip(curTripId);\\n if(JSON.stringify(TRIP)!==before)refreshScreen(cur);\\n }else if(['s-groups','s-group','s-balances'].includes(cur)&&CUR){\\n const before=JSON.stringify(STATES[CUR]);await loadState(CUR);\\n if(JSON.stringify(STATES[CUR])!==before)refreshScreen(cur);\\n }\\n }catch(_e){}\\n},6000);\\n\\n(async function boot(){\\n if(!SB.groups.length){show('s-join','SplitBasket','Join your group');return;}\\n CUR=SB.groups[0].id;\\n await loadAll();\\n // prune groups that no longer exist\\n SB.groups=SB.groups.filter(g=>STATES[g.id]);saveSB();\\n if(!SB.groups.length){show('s-join','SplitBasket','Join your group');return;}\\n CUR=SB.groups[0].id;\\n const me=Object.values(STATES).some(st=>((st.net[myFam(st.group.id)]||0)<-0.004));\\n $('bellDot').style.display=me?'block':'none';\\n goHome();\\n})();\\n\\n\\n\\n\";","label",[132],"ffd31844-b1d8-4e4a-b551-712b6153474f","ui.ts","7ee60c8e-7be1-11f1-b7cf-1607ee4eb77e",33,["D",1783675940958],9,"// SplitBasket UI v5 (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

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

\\ud83c\\udfe6 Payment details \\u2014 members only

Trips

Group balance (all trips)

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 · v35