\n Clicked\n setCount((c) => c + 1)}\n class=\"bg-blue-500 hover:bg-blue-600 text-white font-medium px-4 py-2 rounded-lg transition-colors cursor-pointer\"\n >\n {count}\n \n times\n

\n );\n}\n",[197,98,77],"db1e80ae-1d47-4f54-8979-56de49dcad1f",["D",1786551098514],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useEffect, useMemo, useState } from \"https://esm.sh/react@18.2.0\";\n\nconst STAGE_COLORS: Record = {\n \"New Lead\": \"bg-slate-100 text-slate-700\",\n \"Contacted\": \"bg-blue-100 text-blue-700\",\n \"Quoted\": \"bg-amber-100 text-amber-700\",\n \"Contract Signed\": \"bg-purple-100 text-purple-700\",\n \"Active Client\": \"bg-emerald-100 text-emerald-700\",\n \"Renewal Due\": \"bg-orange-100 text-orange-700\",\n \"Lost\": \"bg-red-100 text-red-700\",\n};\n\nconst BUSINESS_COLORS: Record = {\n \"We Staff Canada\": \"border-l-blue-500\",\n \"Can Clean Solutions\": \"border-l-emerald-500\",\n \"Zeus Security Services\": \"border-l-slate-700\",\n};\n\nconst emptyForm = {\n id: null as number | null,\n business: \"\",\n company_name: \"\",\n contact_name: \"\",\n email: \"\",\n phone: \"\",\n stage: \"New Lead\",\n source: \"\",\n notes: \"\",\n next_follow_up: \"\",\n contract_renewal_date: \"\",\n bill_rate: \"\",\n};\n\nfunction daysUntil(dateStr: string) {\n if (!dateStr) return null;\n const diff = (new Date(dateStr).getTime() - new Date().setHours(0, 0, 0, 0)) / 86400000;\n return Math.round(diff);\n}\n\nexport function App() {\n const [meta, setMeta] = useState<{ businesses: string[]; stages: string[] }>({ businesses: [], stages: [] });\n const [contacts, setContacts] = useState([]);\n const [activeBusiness, setActiveBusiness] = useState(\"all\");\n const [loading, setLoading] = useState(true);\n const [showForm, setShowForm] = useState(false);\n const [form, setForm] = useState(emptyForm);\n const [saving, setSaving] = useState(false);\n\n async function loadMeta() {\n const res = await fetch(\"/api/meta\");\n setMeta(await res.json());\n }\n\n async function loadContacts(business: string) {\n setLoading(true);\n const res = await fetch(`/api/contacts?business=${encodeURIComponent(business)}`);\n setContacts(await res.json());\n setLoading(false);\n }\n\n useEffect(() => {\n loadMeta();\n }, []);\n\n useEffect(() => {\n loadContacts(activeBusiness);\n }, [activeBusiness]);\n\n const dueSoon = useMemo(() => {\n return contacts.filter((c) => {\n const f = daysUntil(c.next_follow_up);\n const r = daysUntil(c.contract_renewal_date);\n return (f !== null && f <= 7) || (r !== null && r <= 30);\n });\n }, [contacts]);\n\n function openNew() {\n setForm({ ...emptyForm, business: activeBusiness !== \"all\" ? activeBusiness : meta.businesses[0] ?? \"\" });\n setShowForm(true);\n }\n\n function openEdit(c: any) {\n setForm({\n id: c.id,\n business: c.business ?? \"\",\n company_name: c.company_name ?? \"\",\n contact_name: c.contact_name ?? \"\",\n email: c.email ?? \"\",\n phone: c.phone ?? \"\",\n stage: c.stage ?? \"New Lead\",\n source: c.source ?? \"\",\n notes: c.notes ?? \"\",\n next_follow_up: c.next_follow_up ?? \"\",\n contract_renewal_date: c.contract_renewal_date ?? \"\",\n bill_rate: c.bill_rate ?? \"\",\n });\n setShowForm(true);\n }\n\n async function saveForm(e: React.FormEvent) {\n e.preventDefault();\n setSaving(true);\n const payload = { ...form };\n delete (payload as any).id;\n if (form.id == null) {\n await fetch(\"/api/contacts\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(payload),\n });\n } else {\n await fetch(`/api/contacts/${form.id}`, {\n method: \"PUT\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(payload),\n });\n }\n setSaving(false);\n setShowForm(false);\n loadContacts(activeBusiness);\n }\n\n async function quickStageChange(c: any, stage: string) {\n await fetch(`/api/contacts/${c.id}`, {\n method: \"PUT\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ stage }),\n });\n loadContacts(activeBusiness);\n }\n\n async function removeContact(id: number) {\n if (!confirm(\"Delete this lead/client record? This cannot be undone.\")) return;\n await fetch(`/api/contacts/${id}`, { method: \"DELETE\" });\n loadContacts(activeBusiness);\n }\n\n return (\n

Business CRM & Pipeline

We Staff Canada · Can Clean Solutions · Zeus Security Services

\n \n + New Lead / Client\n \n

\n\n

\n setActiveBusiness(\"all\")}\n className={`px-3 py-1.5 rounded-full text-sm font-medium ${\n activeBusiness === \"all\" ? \"bg-gray-900 text-white\" : \"bg-gray-100 text-gray-700 hover:bg-gray-200\"\n }`}\n >\n All Businesses\n \n {meta.businesses.map((b) => (\n setActiveBusiness(b)}\n className={`px-3 py-1.5 rounded-full text-sm font-medium ${\n activeBusiness === b ? \"bg-gray-900 text-white\" : \"bg-gray-100 text-gray-700 hover:bg-gray-200\"\n }`}\n >\n {b}\n \n ))}\n

\n\n {dueSoon.length > 0 && (\n

\n {dueSoon.length} lead{dueSoon.length === 1 ? \"\" : \"s\"}/client{dueSoon.length === 1 ? \"\" : \"s\"} need\n {\" \"}attention soon — a follow-up due within 7 days or a contract renewal within 30 days.\n

\n )}\n\n {loading ? (\n

Loading…

\n ) : contacts.length === 0 ? (\n

No leads or clients yet for this view.

\n \n

\n ) : (\n

\n \n \n \n \n {activeBusiness === \"all\" && }\n \n \n \n \n \n \n \n \n {contacts.map((c) => (\n \n \n {activeBusiness === \"all\" && }\n \n \n \n \n \n \n ))}\n \n

Company	Business	Contact	Stage	Next follow-up	Renewal
openEdit(c)}>\n {c.company_name}\n	{c.business}	\n {c.contact_name}\n {c.email && {c.email} }\n	\n quickStageChange(c, e.target.value)}\n className={`text-xs font-medium rounded-full px-2 py-1 border-0 ${STAGE_COLORS[c.stage] ?? \"bg-gray-100\"}`}\n >\n {meta.stages.map((s) => (\n \n ))}\n \n	\n {c.next_follow_up \|\| \"—\"}\n	\n {c.contract_renewal_date \|\| \"—\"}\n	\n \n \n

\n )}\n\n {showForm && (\n

{form.id == null ? \"New Lead / Client\" : \"Edit\"}

\n Business\n setForm({ ...form, business: e.target.value })}\n className=\"w-full border border-gray-300 rounded-lg px-3 py-2 text-sm\"\n >\n \n {meta.businesses.map((b) => (\n \n ))}\n \n

\n Company name\n setForm({ ...form, company_name: e.target.value })}\n className=\"w-full border border-gray-300 rounded-lg px-3 py-2 text-sm\"\n />\n

\n Contact name\n setForm({ ...form, contact_name: e.target.value })}\n className=\"w-full border border-gray-300 rounded-lg px-3 py-2 text-sm\"\n />\n

\n Stage\n setForm({ ...form, stage: e.target.value })}\n className=\"w-full border border-gray-300 rounded-lg px-3 py-2 text-sm\"\n >\n {meta.stages.map((s) => (\n \n ))}\n \n

\n Email\n setForm({ ...form, email: e.target.value })}\n className=\"w-full border border-gray-300 rounded-lg px-3 py-2 text-sm\"\n />\n

\n Phone\n setForm({ ...form, phone: e.target.value })}\n className=\"w-full border border-gray-300 rounded-lg px-3 py-2 text-sm\"\n />\n

\n Next follow-up\n setForm({ ...form, next_follow_up: e.target.value })}\n className=\"w-full border border-gray-300 rounded-lg px-3 py-2 text-sm\"\n />\n

\n Contract renewal date\n setForm({ ...form, contract_renewal_date: e.target.value })}\n className=\"w-full border border-gray-300 rounded-lg px-3 py-2 text-sm\"\n />\n

\n Lead source\n setForm({ ...form, source: e.target.value })}\n placeholder=\"Referral, website, cold call…\"\n className=\"w-full border border-gray-300 rounded-lg px-3 py-2 text-sm\"\n />\n

\n Bill rate / deal size\n setForm({ ...form, bill_rate: e.target.value })}\n className=\"w-full border border-gray-300 rounded-lg px-3 py-2 text-sm\"\n />\n

\n Notes\n setForm({ ...form, notes: e.target.value })}\n rows={3}\n className=\"w-full border border-gray-300 rounded-lg px-3 py-2 text-sm\"\n />\n

\n setShowForm(false)}\n className=\"px-4 py-2 text-sm text-gray-600 hover:text-gray-900\"\n >\n Cancel\n \n \n {saving ? \"Saving…\" : \"Save\"}\n \n

\n )}\n\n

\n View source\n

\n );\n}\n",[197,98,88],"pulls","branches","forks","envVars",{"_84":26,"_216":26},"connections",{"_84":26,"_215":26},"unfilledCount","emptyCount",{"_34":279,"_13":197,"_75":190,"_44":-5,"_36":37,"_191":41,"_192":24,"_38":280,"_40":26,"_78":99,"_194":-5,"_80":30,"_195":-5,"_232":281,"_17":282},{"_34":189,"_13":98,"_75":97,"_44":190,"_36":37,"_191":41,"_192":24,"_38":276,"_40":26,"_78":99,"_194":-5,"_80":30,"_195":-5,"_232":277,"_17":278},{"_34":204,"_13":88,"_75":87,"_44":97,"_36":37,"_191":91,"_192":24,"_38":273,"_40":41,"_78":79,"_194":206,"_80":30,"_195":-5,"_232":274,"_17":275},{"_34":200,"_13":77,"_75":76,"_44":97,"_36":37,"_191":41,"_192":24,"_38":270,"_40":26,"_78":79,"_194":202,"_80":30,"_195":-5,"_232":271,"_17":272},{"_34":263,"_13":264,"_75":265,"_44":190,"_36":37,"_191":41,"_192":24,"_38":266,"_40":26,"_78":21,"_194":267,"_80":30,"_195":-5,"_232":268,"_17":269},{"_34":256,"_13":257,"_75":258,"_44":190,"_36":37,"_191":41,"_192":24,"_38":259,"_40":26,"_78":79,"_194":260,"_80":30,"_195":-5,"_232":261,"_17":262},{"_34":249,"_13":250,"_75":251,"_44":190,"_36":37,"_191":139,"_192":24,"_38":252,"_40":41,"_78":79,"_194":253,"_80":30,"_195":-5,"_232":254,"_17":255},{"_34":242,"_13":243,"_75":244,"_44":-5,"_36":37,"_191":41,"_192":24,"_38":245,"_40":26,"_78":21,"_194":246,"_80":30,"_195":-5,"_232":247,"_17":248},{"_34":235,"_13":236,"_75":237,"_44":-5,"_36":37,"_191":41,"_192":24,"_38":238,"_40":26,"_78":21,"_194":239,"_80":30,"_195":-5,"_232":240,"_17":241},{"_34":227,"_13":228,"_75":112,"_44":-5,"_36":37,"_191":85,"_192":24,"_38":229,"_40":41,"_78":230,"_194":231,"_80":30,"_195":-5,"_232":233,"_17":234},"d9e8ecb4-6ee9-4364-a5b9-e1d311073eef","index.ts",["D",1786551052632],"http","import { parseVal, serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { Root } from \"./frontend/root.tsx\";\n\nconst app = new Hono();\n\nconst BUSINESSES = [\"We Staff Canada\", \"Can Clean Solutions\", \"Zeus Security Services\"];\nconst STAGES = [\"New Lead\", \"Contacted\", \"Quoted\", \"Contract Signed\", \"Active Client\", \"Renewal Due\", \"Lost\"];\n\nasync function ensureSchema() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS contacts (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n business TEXT NOT NULL,\n company_name TEXT NOT NULL,\n contact_name TEXT,\n email TEXT,\n phone TEXT,\n stage TEXT NOT NULL DEFAULT 'New Lead',\n source TEXT,\n notes TEXT,\n next_follow_up TEXT,\n contract_renewal_date TEXT,\n bill_rate TEXT,\n created_at TEXT DEFAULT (datetime('now')),\n updated_at TEXT DEFAULT (datetime('now'))\n )`);\n}\n\n// Serve the (never-cached) HTML shell at the root /\napp.get(\"/\", async (c) => {\n await ensureSchema();\n return c.html(Root());\n});\n\n// Serve frontend files at the version-addressed URLs Root() stamps, cached immutably\napp.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path));\n\n// View source redirect\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// ---- API ----\n\napp.get(\"/api/meta\", async (c) => {\n await ensureSchema();\n return c.json({ businesses: BUSINESSES, stages: STAGES });\n});\n\napp.get(\"/api/contacts\", async (c) => {\n await ensureSchema();\n const business = c.req.query(\"business\");\n let sql = \"SELECT * FROM contacts\";\n const args: unknown[] = [];\n if (business && business !== \"all\") {\n sql += \" WHERE business = ?\";\n args.push(business);\n }\n sql += \" ORDER BY created_at DESC\";\n const result = await sqlite.execute({ sql, args });\n return c.json(result.rows);\n});\n\napp.post(\"/api/contacts\", async (c) => {\n await ensureSchema();\n const body = await c.req.json();\n if (!body.business || !body.company_name) {\n return c.json({ error: \"business and company_name are required\" }, 400);\n }\n const result = await sqlite.execute({\n sql: `INSERT INTO contacts\n (business, company_name, contact_name, email, phone, stage, source, notes, next_follow_up, contract_renewal_date, bill_rate)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n body.business,\n body.company_name,\n body.contact_name ?? null,\n body.email ?? null,\n body.phone ?? null,\n body.stage ?? \"New Lead\",\n body.source ?? null,\n body.notes ?? null,\n body.next_follow_up ?? null,\n body.contract_renewal_date ?? null,\n body.bill_rate ?? null,\n ],\n });\n return c.json({ id: Number(result.lastInsertRowid) }, 201);\n});\n\napp.put(\"/api/contacts/:id\", async (c) => {\n await ensureSchema();\n const id = c.req.param(\"id\");\n const body = await c.req.json();\n const fields = [\n \"business\",\n \"company_name\",\n \"contact_name\",\n \"email\",\n \"phone\",\n \"stage\",\n \"source\",\n \"notes\",\n \"next_follow_up\",\n \"contract_renewal_date\",\n \"bill_rate\",\n ];\n const sets: string[] = [];\n const args: unknown[] = [];\n for (const f of fields) {\n if (f in body) {\n sets.push(`${f} = ?`);\n args.push(body[f]);\n }\n }\n if (sets.length === 0) return c.json({ error: \"no fields to update\" }, 400);\n sets.push(\"updated_at = datetime('now')\");\n args.push(id);\n await sqlite.execute({\n sql: `UPDATE contacts SET ${sets.join(\", \")} WHERE id = ?`,\n args,\n });\n return c.json({ ok: true });\n});\n\napp.delete(\"/api/contacts/:id\", async (c) => {\n await ensureSchema();\n const id = c.req.param(\"id\");\n await sqlite.execute({ sql: \"DELETE FROM contacts WHERE id = ?\", args: [id] });\n return c.json({ ok: true });\n});\n\n// Unwrap and rethrow Hono errors as the original error\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","children",[],[228],"a7a5e233-c76f-4cf5-9b1f-0d9011fc6935","README.md","019ff6bd-25c1-7561-b0e2-127ec5d3e11b",["D",1786551016582],"# 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",[],[236],"4012e7d2-61a9-40e0-bcab-6c4dbd07698b","CHANGELOG.md","019ff6bd-25c1-7561-b0e2-0dc1b3b69359",["D",1786551016582],"# 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

History · components