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","label",[184,185,70],"frontend","components","pulls","branches","forks","envVars",{"_193":26,"_195":26},"connections",{"_193":26,"_194":26},"count","unfilledCount","emptyCount",{"_33":266,"_13":184,"_68":232,"_43":-5,"_35":36,"_177":40,"_178":99,"_37":267,"_39":26,"_71":263,"_180":-5,"_73":24,"_182":-5,"_212":268,"_17":269},{"_33":261,"_13":185,"_68":176,"_43":232,"_35":36,"_177":40,"_178":99,"_37":262,"_39":26,"_71":263,"_180":-5,"_73":24,"_182":-5,"_212":264,"_17":265},{"_33":175,"_13":70,"_68":69,"_43":176,"_35":36,"_177":79,"_178":99,"_37":258,"_39":40,"_71":72,"_180":181,"_73":24,"_182":-5,"_212":259,"_17":260},{"_33":251,"_13":252,"_68":253,"_43":176,"_35":36,"_177":40,"_178":99,"_37":254,"_39":26,"_71":72,"_180":255,"_73":24,"_182":-5,"_212":256,"_17":257},{"_33":244,"_13":245,"_68":246,"_43":232,"_35":36,"_177":40,"_178":99,"_37":247,"_39":26,"_71":21,"_180":248,"_73":24,"_182":-5,"_212":249,"_17":250},{"_33":237,"_13":238,"_68":239,"_43":232,"_35":36,"_177":40,"_178":99,"_37":240,"_39":26,"_71":72,"_180":241,"_73":24,"_182":-5,"_212":242,"_17":243},{"_33":229,"_13":230,"_68":231,"_43":232,"_35":36,"_177":125,"_178":99,"_37":233,"_39":40,"_71":72,"_180":234,"_73":24,"_182":-5,"_212":235,"_17":236},{"_33":222,"_13":223,"_68":224,"_43":-5,"_35":36,"_177":40,"_178":99,"_37":225,"_39":26,"_71":21,"_180":226,"_73":24,"_182":-5,"_212":227,"_17":228},{"_33":215,"_13":216,"_68":217,"_43":-5,"_35":36,"_177":40,"_178":99,"_37":218,"_39":26,"_71":21,"_180":219,"_73":24,"_182":-5,"_212":220,"_17":221},{"_33":206,"_13":207,"_68":97,"_43":-5,"_35":36,"_177":208,"_178":99,"_37":209,"_39":40,"_71":210,"_180":211,"_73":24,"_182":-5,"_212":213,"_17":214},"d9e8ecb4-6ee9-4364-a5b9-e1d311073eef","index.ts",2,["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",[],[207],"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",[],[216],"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 · App.tsx