[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_250":251,"_252":253},"routes/_app.x.$handle.$name",{"_99":98,"_31":44,"_107":89,"_26":108,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":24,"_122":123,"_124":58,"_125":-5,"_126":-5,"_127":128},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":24},"version",13,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","frontend/components/Finances.tsx","latestPath","fileId","1bc4dafa-a151-11f1-8c59-1607ee4eb77e","name","Finances.tsx","fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useEffect,useState } from \"https://esm.sh/react@18.2.0\";\nconst money=(c:number)=>new Intl.NumberFormat(\"en-US\",{style:\"currency\",currency:\"USD\"}).format(Number(c||0)/100);\nexport function Finances(){\n const [d,setD]=useState(null);useEffect(()=>{fetch(\"/api/finance\").then(r=>r.json()).then(setD)},[]);\n if(!d)return

Opening the books…

;\n const s=d.summary,q=d.settings;\n return

The books are open

Public financial ledger

No mystery fees and no hidden margin. Every posted dollar, assumption, and dues calculation is visible—even while every number is still zero.

{q.period_label} dues

{money(s.quarterly_dues_cents)}

per member, per quarter

Show your work

How dues are calculated

Updated {q.updated_at} UTC

{[[money(s.planned_costs_cents),\"Planned costs\"],[money(q.reserve_target_cents),\"Reserve target\"],[\"− \"+money(s.cash_balance_cents),\"Cash available\"],[String(s.projected_members),\"Projected members\"],[money(s.quarterly_dues_cents),\"Dues each\"]].map(([v,l],i)=>

{v}

{l}

)}

{q.methodology}

Quarterly operating budget

Planned costs explain what the collective expects to fund before the quarter begins.

{d.budget.map((b:any)=>

{b.category}

{b.explanation}

{money(b.planned_cents)}

)}

Posted transactions

Entries are never deleted. Corrections remain visible as voided records.

{d.transactions.length} entries

{[\"Date\",\"Type\",\"Category / explanation\",\"Payee\",\"Amount\",\"Evidence\"].map(x=>)}{d.transactions.length?d.transactions.map((t:any)=>):}

{x}
{t.transaction_date}	{t.type}	{t.category} {t.description} {t.voided_at&& VOID: {t.void_reason} }	{t.payee\|\|\"—\"}	{t.type===\"income\"?\"+\":\"−\"}{money(t.amount_cents)}	{t.receipt_url?Receipt ↗:\"—\"}
🧾 No transactions yet The ledger is functional and begins at exactly zero.

What this ledger does—and does not—prove

It shows the records entered by the collective, evidence attached to them, and the formula used for dues. It is not an independent audit. Members should reconcile it against the club bank account and vote on material budget changes.

}\nfunction Card({label,value,blue,red,yellow}:any){return

{label}

{value}

}","createdAt",["D",1787750515541],"branchVersion","branchId","deb63916-95c3-4389-b9d3-b76b7f2e6f65","id","39ce0c14-ff21-409b-88eb-7823ab8d5d9d","miata-life-crisis",["D",1787708091556],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Socially owned motorsport experiences","imageUrl","40e69d1a-3254-4858-920b-7b1449761575","pinnedFileId","01a03bb4-ad04-7558-b577-f8ab6dcd8446","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","54bae3d1-8223-41e5-b22d-81eb28a263c7","tursoName","39ce0c14ff21409b88eb7823ab8d5d9d","tursoHostname","39ce0c14ff21409b88eb7823ab8d5d9d-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789533091345],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_106":102},"org",{"_99":98,"_100":-5,"_101":102,"_18":54,"_103":104,"_105":24},"branch",{"_13":88,"_31":89,"_42":41,"_90":43,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":44,"_97":98},"isOwned",18,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","pchinjr","handle","displayName","avatar","https://images.clerk.dev/oauth_github/img_2OaSpooJk6yZ5KFqyjtIVA4z3SH.jpeg","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":245,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":246,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":247,"_83":248,"_85":249,"_87":24},"tree",[173,181,182,183],"files",[173,174,175,176,177,178,179,180,181,182,183],"counts",{"_163":62,"_164":147,"_165":62,"_166":167,"_168":169},"contents",[129,130,131,132],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":157,"_31":158,"_29":159,"_135":-5,"_40":41,"_39":147,"_137":58,"_37":160,"_13":62,"_33":161,"_35":-5,"_23":24,"_142":-5,"_26":162},{"_42":151,"_31":152,"_29":153,"_135":-5,"_40":41,"_39":147,"_137":58,"_37":154,"_13":62,"_33":20,"_35":155,"_23":24,"_142":-5,"_26":156},{"_42":144,"_31":145,"_29":146,"_135":-5,"_40":41,"_39":147,"_137":58,"_37":148,"_13":62,"_33":20,"_35":149,"_23":24,"_142":-5,"_26":150},{"_42":133,"_31":134,"_29":56,"_135":-5,"_40":41,"_39":136,"_137":58,"_37":138,"_13":139,"_33":140,"_35":141,"_23":24,"_142":44,"_26":143},"22e31ed7-e684-4f30-a0b2-93f40cc63fbb","index.ts","parentId",12,"latest",["D",1787750343639],7,"http","import { parseVal, serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { getOAuthUserData, oauthMiddleware } from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport { Hono } from \"npm:hono\";\nimport { Root } from \"./frontend/root.tsx\";\n\nconst app = new Hono();\n\nasync function setup() {\n await sqlite.batch([\n { sql: `CREATE TABLE IF NOT EXISTS members (id INTEGER PRIMARY KEY AUTOINCREMENT,name TEXT NOT NULL,email TEXT NOT NULL UNIQUE,interests TEXT NOT NULL,experience TEXT NOT NULL,status TEXT NOT NULL DEFAULT 'pending',joined_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP)` },\n { sql: `CREATE TABLE IF NOT EXISTS cars (id INTEGER PRIMARY KEY,name TEXT NOT NULL,year TEXT NOT NULL,discipline TEXT NOT NULL,status TEXT NOT NULL,detail TEXT NOT NULL,next_ready TEXT,accent TEXT NOT NULL)` },\n { sql: `CREATE TABLE IF NOT EXISTS events (id INTEGER PRIMARY KEY,title TEXT NOT NULL,event_date TEXT NOT NULL,location TEXT NOT NULL,discipline TEXT NOT NULL,car_id INTEGER,capacity INTEGER NOT NULL,status TEXT NOT NULL,description TEXT NOT NULL)` },\n { sql: `CREATE TABLE IF NOT EXISTS bookings (id INTEGER PRIMARY KEY AUTOINCREMENT,member_id INTEGER NOT NULL,event_id INTEGER NOT NULL,status TEXT NOT NULL DEFAULT 'confirmed',created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,UNIQUE(member_id,event_id))` },\n { sql: \"INSERT OR IGNORE INTO cars VALUES (1,?,?,?,?,?,?,?)\", args: [\"Red Five\",\"1999 Mazda MX-5\",\"Drift\",\"Ready\",\"Fresh fluids · 80% tires · aligned\",\"Now\",\"red\"] },\n { sql: \"INSERT OR IGNORE INTO cars VALUES (2,?,?,?,?,?,?,?)\", args: [\"Blue Monday\",\"2001 Mazda MX-5\",\"Track\",\"Ready\",\"Track inspection passed · new pads\",\"Now\",\"blue\"] },\n { sql: \"INSERT OR IGNORE INTO cars VALUES (3,?,?,?,?,?,?,?)\", args: [\"Dad Bod\",\"1994 Mazda MX-5\",\"Autocross\",\"Service\",\"Cooling refresh in progress\",\"Sep 8\",\"amber\"] },\n { sql: \"INSERT OR IGNORE INTO cars VALUES (4,?,?,?,?,?,?,?)\", args: [\"Long Way Round\",\"2006 Mazda MX-5\",\"Off-road pilot\",\"Planning\",\"Rallycross setup under evaluation\",\"2027\",\"green\"] },\n { sql: \"INSERT OR IGNORE INTO events VALUES (1,?,?,?,?,?,?,?,?)\", args: [\"Drift School: First Slide\",\"2026-09-19\",\"Virginia International Raceway\",\"Drift\",1,8,\"Open\",\"A low-pressure day for learning weight transfer, initiating a slide, and laughing at your first spin.\"] },\n { sql: \"INSERT OR IGNORE INTO events VALUES (2,?,?,?,?,?,?,?,?)\", args: [\"GT Pace: Full Course\",\"2026-10-17\",\"Dominion Raceway\",\"Track\",2,6,\"Open\",\"Lead-follow laps, coaching, and a properly prepared car without owning a trailer or a torque wrench collection.\"] },\n { sql: \"INSERT OR IGNORE INTO events VALUES (3,?,?,?,?,?,?,?,?)\", args: [\"Parking Lot Hero\",\"2026-11-08\",\"Hampton Roads Autocross\",\"Autocross\",3,10,\"Waitlist\",\"Cones, timing lights, and friendly competition. The purest dollar-to-grin ratio in motorsport.\"] },\n { sql: \"INSERT OR IGNORE INTO events VALUES (4,?,?,?,?,?,?,?,?)\", args: [\"Quarterly Garage Social\",\"2026-12-05\",\"The Shared Garage · Norfolk\",\"Social\",null,30,\"Open\",\"Meet the members, see the fleet, vote on next quarter, and help set maintenance priorities.\"] },\n { sql: `CREATE TABLE IF NOT EXISTS finance_settings (id INTEGER PRIMARY KEY CHECK(id=1),period_label TEXT NOT NULL,projected_members INTEGER NOT NULL DEFAULT 1,reserve_target_cents INTEGER NOT NULL DEFAULT 0,opening_balance_cents INTEGER NOT NULL DEFAULT 0,methodology TEXT NOT NULL,updated_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP)` },\n { sql: `CREATE TABLE IF NOT EXISTS finance_budget (id INTEGER PRIMARY KEY AUTOINCREMENT,period_label TEXT NOT NULL,category TEXT NOT NULL,planned_cents INTEGER NOT NULL DEFAULT 0,explanation TEXT NOT NULL,sort_order INTEGER NOT NULL DEFAULT 0)` },\n { sql: `CREATE TABLE IF NOT EXISTS finance_transactions (id INTEGER PRIMARY KEY AUTOINCREMENT,transaction_date TEXT NOT NULL,type TEXT NOT NULL CHECK(type IN ('income','expense')),category TEXT NOT NULL,payee TEXT NOT NULL,description TEXT NOT NULL,amount_cents INTEGER NOT NULL CHECK(amount_cents>=0),receipt_url TEXT,posted_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,voided_at TEXT,void_reason TEXT)` },\n { sql: \"INSERT OR IGNORE INTO finance_settings(id,period_label,projected_members,reserve_target_cents,opening_balance_cents,methodology) VALUES(1,?,?,?,?,?)\", args: [\"2026 Q4\",1,0,0,\"Quarterly dues = max(0, planned operating costs + reserve target − current cash balance) ÷ projected participating members. The result is rounded up to the next cent.\"] },\n { sql: \"INSERT OR IGNORE INTO finance_budget(id,period_label,category,planned_cents,explanation,sort_order) VALUES(1,?,?,?,?,?)\", args: [\"2026 Q4\",\"Track and venue fees\",0,\"Facility rental, event entry, and track access.\",1] },\n { sql: \"INSERT OR IGNORE INTO finance_budget(id,period_label,category,planned_cents,explanation,sort_order) VALUES(2,?,?,?,?,?)\", args: [\"2026 Q4\",\"Fleet maintenance\",0,\"Parts, fluids, tires, inspections, and specialist labor.\",2] },\n { sql: \"INSERT OR IGNORE INTO finance_budget(id,period_label,category,planned_cents,explanation,sort_order) VALUES(3,?,?,?,?,?)\", args: [\"2026 Q4\",\"Insurance and compliance\",0,\"Coverage, registrations, waivers, and administrative requirements.\",3] },\n { sql: \"INSERT OR IGNORE INTO finance_budget(id,period_label,category,planned_cents,explanation,sort_order) VALUES(4,?,?,?,?,?)\", args: [\"2026 Q4\",\"Transport and storage\",0,\"Trailer, fuel, towing, garage, and storage costs.\",4] },\n { sql: \"INSERT OR IGNORE INTO finance_budget(id,period_label,category,planned_cents,explanation,sort_order) VALUES(5,?,?,?,?,?)\", args: [\"2026 Q4\",\"Instruction and safety\",0,\"Coaches, helmets, extinguishers, and other safety equipment.\",5] }\n ]);\n}\napp.get(\"/\", async c => { await setup(); return c.html(Root()); });\napp.get(\"/__immutable/*\", c => serveImmutableFile(c.req.path));\napp.get(\"/source\", c => c.redirect(parseVal().links.self.val));\napp.get(\"/api/dashboard\", async c => {\n await setup();\n const [cars,events,counts] = await Promise.all([\n sqlite.execute(\"SELECT * FROM cars ORDER BY id\"),\n sqlite.execute(`SELECT e.*,c.name car_name,COUNT(b.id) booked FROM events e LEFT JOIN cars c ON c.id=e.car_id LEFT JOIN bookings b ON b.event_id=e.id AND b.status='confirmed' GROUP BY e.id ORDER BY e.event_date`),\n sqlite.execute(`SELECT (SELECT COUNT(*) FROM members) members,(SELECT COUNT(*) FROM bookings) reservations,(SELECT COUNT(*) FROM cars WHERE status='Ready') ready_cars`)\n ]);\n return c.json({cars:cars.rows,events:events.rows,stats:counts.rows[0]});\n});\n\napp.get(\"/api/finance\", async c => {\n await setup();\n const [settings,budget,transactions] = await Promise.all([\n sqlite.execute(\"SELECT * FROM finance_settings WHERE id=1\"),\n sqlite.execute(\"SELECT * FROM finance_budget ORDER BY sort_order,id\"),\n sqlite.execute(\"SELECT * FROM finance_transactions ORDER BY transaction_date DESC,id DESC\")\n ]);\n const s:any=settings.rows[0];\n const active=(transactions.rows as any[]).filter(t=>!t.voided_at);\n const income=active.filter(t=>t.type===\"income\").reduce((n,t)=>n+Number(t.amount_cents),0);\n const expenses=active.filter(t=>t.type===\"expense\").reduce((n,t)=>n+Number(t.amount_cents),0);\n const cash=Number(s.opening_balance_cents)+income-expenses;\n const planned=(budget.rows as any[]).reduce((n,b)=>n+Number(b.planned_cents),0);\n const needed=Math.max(0,planned+Number(s.reserve_target_cents)-cash);\n const members=Math.max(1,Number(s.projected_members));\n const dues=Math.ceil(needed/members);\n return c.json({settings:s,budget:budget.rows,transactions:transactions.rows,summary:{income_cents:income,expense_cents:expenses,cash_balance_cents:cash,planned_costs_cents:planned,funding_needed_cents:needed,quarterly_dues_cents:dues,projected_members:members}});\n});\n\napp.post(\"/api/members\", async c => {\n await setup(); const b=await c.req.json();\n const name=String(b.name||\"\").trim(), email=String(b.email||\"\").trim().toLowerCase();\n const interests=Array.isArray(b.interests)?b.interests.join(\", \"):\"\", experience=String(b.experience||\"\");\n if(!name||!email.includes(\"@\")||!interests||!experience)return c.json({error:\"Please complete every field.\"},400);\n try { await sqlite.execute({sql:\"INSERT INTO members(name,email,interests,experience) VALUES(?,?,?,?)\",args:[name,email,interests,experience]}); return c.json({ok:true,message:\"You're on the founding member list.\"},201); }\n catch(err){ if(String(err).includes(\"UNIQUE\"))return c.json({error:\"That email is already on the member list.\"},409); throw err; }\n});\napp.post(\"/api/events/:id/join\", async c => {\n await setup(); const eventId=Number(c.req.param(\"id\")); const b=await c.req.json(); const email=String(b.email||\"\").trim().toLowerCase();\n const member=await sqlite.execute({sql:\"SELECT id FROM members WHERE email=?\",args:[email]});\n if(!member.rows.length)return c.json({error:\"Apply for membership first, then reserve your event.\"},404);\n const event=await sqlite.execute({sql:`SELECT e.capacity,e.status,COUNT(b.id) booked FROM events e LEFT JOIN bookings b ON b.event_id=e.id AND b.status='confirmed' WHERE e.id=? GROUP BY e.id`,args:[eventId]});\n if(!event.rows.length)return c.json({error:\"Event not found.\"},404);\n const row:any=event.rows[0]; const status=row.status===\"Waitlist\"||Number(row.booked)>=Number(row.capacity)?\"waitlist\":\"confirmed\";\n try { await sqlite.execute({sql:\"INSERT INTO bookings(member_id,event_id,status) VALUES(?,?,?)\",args:[Number((member.rows[0] as any).id),eventId,status]}); return c.json({ok:true,message:status===\"confirmed\"?\"Your spot is reserved.\":\"You're on the waitlist.\"},201); }\n catch(err){ if(String(err).includes(\"UNIQUE\"))return c.json({error:\"You're already registered for this event.\"},409); throw err; }\n});\n\nasync function requireAdmin(c:any) {\n const session = await getOAuthUserData(c.req.raw);\n if (!session?.user) return { response: c.json({ error: \"Sign in required\", login: \"/auth/login\" }, 401) };\n if (session.user.username !== \"pchinjr\") return { response: c.json({ error: \"This dashboard is restricted to the club owner.\" }, 403) };\n return { session };\n}\napp.get(\"/admin\", async c => {\n const auth = await requireAdmin(c);\n if (auth.response) return c.redirect(\"/auth/login\");\n return c.redirect(\"/#desk\");\n});\napp.get(\"/api/admin/dashboard\", async c => {\n const auth = await requireAdmin(c); if (auth.response) return auth.response;\n await setup();\n const [members,bookings,cars,events] = await Promise.all([\n sqlite.execute(\"SELECT * FROM members ORDER BY joined_at DESC\"),\n sqlite.execute(`SELECT b.*,m.name member_name,m.email member_email,e.title event_title FROM bookings b JOIN members m ON m.id=b.member_id JOIN events e ON e.id=b.event_id ORDER BY b.created_at DESC`),\n sqlite.execute(\"SELECT * FROM cars ORDER BY id\"),\n sqlite.execute(\"SELECT * FROM events ORDER BY event_date\")\n ]);\n return c.json({ user: auth.session?.user.username, members: members.rows, bookings: bookings.rows, cars: cars.rows, events: events.rows });\n});\napp.patch(\"/api/admin/members/:id\", async c => {\n const auth=await requireAdmin(c); if(auth.response)return auth.response;\n const b=await c.req.json(); if(![\"pending\",\"active\",\"paused\"].includes(b.status))return c.json({error:\"Invalid status\"},400);\n await sqlite.execute({sql:\"UPDATE members SET status=? WHERE id=?\",args:[b.status,Number(c.req.param(\"id\"))]}); return c.json({ok:true});\n});\napp.patch(\"/api/admin/cars/:id\", async c => {\n const auth=await requireAdmin(c); if(auth.response)return auth.response;\n const b=await c.req.json(); if(![\"Ready\",\"Service\",\"Planning\"].includes(b.status))return c.json({error:\"Invalid status\"},400);\n await sqlite.execute({sql:\"UPDATE cars SET status=?,detail=?,next_ready=? WHERE id=?\",args:[b.status,String(b.detail||\"\"),String(b.next_ready||\"\"),Number(c.req.param(\"id\"))]}); return c.json({ok:true});\n});\napp.patch(\"/api/admin/events/:id\", async c => {\n const auth=await requireAdmin(c); if(auth.response)return auth.response;\n const b=await c.req.json(); if(![\"Open\",\"Waitlist\",\"Closed\",\"Complete\"].includes(b.status)||Number(b.capacity)<1)return c.json({error:\"Invalid event update\"},400);\n await sqlite.execute({sql:\"UPDATE events SET status=?,capacity=? WHERE id=?\",args:[b.status,Number(b.capacity),Number(c.req.param(\"id\"))]}); return c.json({ok:true});\n});\napp.patch(\"/api/admin/bookings/:id\", async c => {\n const auth=await requireAdmin(c); if(auth.response)return auth.response;\n const b=await c.req.json(); if(![\"confirmed\",\"waitlist\",\"cancelled\",\"attended\"].includes(b.status))return c.json({error:\"Invalid status\"},400);\n await sqlite.execute({sql:\"UPDATE bookings SET status=? WHERE id=?\",args:[b.status,Number(c.req.param(\"id\"))]}); return c.json({ok:true});\n});\n\n\napp.post(\"/api/admin/finance/transactions\", async c => {\n const auth=await requireAdmin(c); if(auth.response)return auth.response;\n const b=await c.req.json(); const type=String(b.type),amount=Math.round(Number(b.amount)*100);\n if(![\"income\",\"expense\"].includes(type)||!Number.isFinite(amount)||amount<0||!b.transaction_date||!b.category||!b.description)return c.json({error:\"Complete all required transaction fields.\"},400);\n const url=String(b.receipt_url||\"\").trim(); if(url&&!/^https?:\\/\\//i.test(url))return c.json({error:\"Receipt link must begin with http:// or https://\"},400);\n await sqlite.execute({sql:\"INSERT INTO finance_transactions(transaction_date,type,category,payee,description,amount_cents,receipt_url) VALUES(?,?,?,?,?,?,?)\",args:[String(b.transaction_date),type,String(b.category),String(b.payee||\"\"),String(b.description),amount,url||null]});\n return c.json({ok:true},201);\n});\napp.patch(\"/api/admin/finance/transactions/:id/void\", async c => {\n const auth=await requireAdmin(c); if(auth.response)return auth.response;\n const b=await c.req.json(); const reason=String(b.reason||\"\").trim(); if(!reason)return c.json({error:\"A public correction reason is required.\"},400);\n await sqlite.execute({sql:\"UPDATE finance_transactions SET voided_at=CURRENT_TIMESTAMP,void_reason=? WHERE id=? AND voided_at IS NULL\",args:[reason,Number(c.req.param(\"id\"))]}); return c.json({ok:true});\n});\napp.patch(\"/api/admin/finance/settings\", async c => {\n const auth=await requireAdmin(c); if(auth.response)return auth.response;\n const b=await c.req.json(); const members=Math.max(1,Math.floor(Number(b.projected_members))); const reserve=Math.max(0,Math.round(Number(b.reserve_target)*100)); const opening=Math.round(Number(b.opening_balance)*100);\n if(!b.period_label||!Number.isFinite(members)||!Number.isFinite(reserve)||!Number.isFinite(opening))return c.json({error:\"Invalid planning assumptions.\"},400);\n await sqlite.execute({sql:\"UPDATE finance_settings SET period_label=?,projected_members=?,reserve_target_cents=?,opening_balance_cents=?,updated_at=CURRENT_TIMESTAMP WHERE id=1\",args:[String(b.period_label),members,reserve,opening]});\n await sqlite.execute({sql:\"UPDATE finance_budget SET period_label=?\",args:[String(b.period_label)]}); return c.json({ok:true});\n});\napp.patch(\"/api/admin/finance/budget/:id\", async c => {\n const auth=await requireAdmin(c); if(auth.response)return auth.response;\n const b=await c.req.json(); const amount=Math.max(0,Math.round(Number(b.planned_amount)*100)); if(!Number.isFinite(amount)||!b.explanation)return c.json({error:\"Invalid budget line.\"},400);\n await sqlite.execute({sql:\"UPDATE finance_budget SET planned_cents=?,explanation=? WHERE id=?\",args:[amount,String(b.explanation),Number(c.req.param(\"id\"))]}); return c.json({ok:true});\n});\n\napp.onError(err=>Promise.reject(err));\nexport default oauthMiddleware(app.fetch);","label",[134],"e93ca4d6-3d1b-4f47-be68-a915258e0c74","README.md","01a03bb4-ad04-7558-b577-f661a8929c18",1,["D",1787708091556],"# React + Hono Starter\n\nA minimal starter template for building client-side React apps with a Hono\nbackend on Val Town. Click **Remix** to get your own copy.\n\n## Picking a starter\n\n| Starter | When to pick it |\n| --- | --- |\n| [`basic-html-starter`](https://www.val.town/x/templates/basic-html-starter) | Static HTML pages. Sprinkle of vanilla JS. No server-side rendering. |\n| [`hono-jsx-starter`](https://www.val.town/x/templates/hono-jsx-starter) | Dynamic server-rendered HTML with JSX. API routes. No React, no SPA. |\n| **[`react-hono-starter`](https://www.val.town/x/templates/react-hono-starter)** *(you're here)* | Client-side React SPA with a Hono API backend. |\n\n**Want to build UI?** Start writing React components in\n[`frontend/components/`](/frontend/components/). Import them into `App.tsx` and\nyou're good to go. Styling is [Twind](https://twind.style/) — just use Tailwind\nutility classes, zero config.\n\n**Want to add an API?** Add routes in [`index.ts`](/index.ts) (there's a\ncommented-out example). Fetch them from your React components.\n\n## Architecture\n\n```mermaid\ngraph LR\n Browser -->|\"GET /\"| Hono[\"index.ts
(Hono server)\"]\n Hono -->|serves| HTML[\"root.tsx\"]\n HTML -->|loads| Entry[\"index.tsx\"]\n Entry -->|renders| App[\"App.tsx\"]\n App -->|renders| Counter[\"Counter.tsx\"]\n```\n\n## File structure\n\n```\nindex.ts ← Hono backend (serves frontend + API routes)\nfrontend/\n root.tsx ← HTML shell (stamps immutable asset URLs)\n index.tsx ← React entrypoint (mounts )\n favicon.svg ← App icon\n components/\n App.tsx ← Root component (layout + view source link)\n Counter.tsx ← Example component with state\n```\n\n## How it works\n\n1. **`index.ts`** is the HTTP entrypoint — a Hono server that serves the\n frontend and any API routes you add.\n2. **`frontend/root.tsx`** is the HTML shell — it loads Twind and stamps\n immutable asset URLs for the favicon and React entrypoint.\n3. **`frontend/index.tsx`** mounts the React app.\n4. **`frontend/components/App.tsx`** is the root layout — add new components\n alongside it.\n5. **`frontend/components/Counter.tsx`** is an example stateful component —\n replace it with your own!\n\n## Next steps\n\n- Add API routes in `index.ts`\n- Add new components in `frontend/components/`\n- Add a SQLite database — see the\n [React Hono Example](https://www.val.town/x/stevekrouse/reactHonoExample) for\n a full-stack example with database, queries, and shared types\n\nTemplate updates and upgrade paths for existing remixes: [CHANGELOG.md](/CHANGELOG.md)\n",[145],"866b0aaf-14cc-4ced-bf06-af0ebb6336e2","CHANGELOG.md","01a03bb4-ad04-7558-b577-f25405a25147",["D",1787708091556],"# Changelog\n\n## 2026-07-30 — Immutable asset caching\n\nFrontend files are now served at version-addressed URLs\n(`/__immutable/45/frontend/index.tsx`) with\n`Cache-Control: public, max-age=31536000, immutable`, so repeat visits load the\nwhole client graph from the browser cache — roughly 3× faster (~665ms → ~157ms\nmeasured). Publishing your val bumps its version, which changes every URL, so\ncaches invalidate automatically. Old-version URLs return 404 after a publish\n(like Next.js build assets); a reload picks up the new version.\n\nWhat changed in the template:\n\n- `frontend/index.html` → [`frontend/root.tsx`](/frontend/root.tsx): the HTML\n shell is now JSX and stamps asset URLs with `immutableFileUrl()`\n- [`index.ts`](/index.ts): serves `Root()` at `/`, and one\n `app.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path))` route\n serves all frontend files\n\n### Upgrading an existing remix\n\nYour copy of this template doesn't update automatically. Two options:\n\n**Minimal (most of the benefit):** point both routes at `serveImmutableFile` —\nyour existing bare URLs redirect into versioned space, the new route serves\nthem, and the whole module graph gets cached (costs one redirect per page view):\n\n```ts\nimport { serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\n\napp.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path));\napp.get(\"/frontend/**/*\", (c) => serveImmutableFile(c.req.path)); // was serveFile\n```\n\n**Full upgrade (also removes the redirect):** three self-contained steps —\nno other files needed. Adjust the ``, favicon, and body of `Root()` to\nmatch your app's existing `index.html`, and stamp anything else your shell\nreferences directly (images, css) with `immutableFileUrl()`.\n\n1. Create `frontend/root.tsx`:\n\n```tsx\n/** @jsxImportSource npm:hono@4/jsx */\nimport { raw } from \"npm:hono@4/html\";\nimport { immutableFileUrl } from \"https://esm.town/v/std/utils/index.ts\";\n\n// The HTML shell for the app. It is never cached, so immutableFileUrl can stamp\n// the current val version into each asset URL — the browser caches those\n// immutably, and publishing the val changes the URLs, refetching exactly once.\nexport function Root() {\n return (\n <>\n {raw(\"<!DOCTYPE html>\")}\n <html lang=\"en\">\n <head>\n <meta charSet=\"UTF-8\" />\n <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\" />\n <title>React Hono Val Town Starter\n

Diff · v13