\n \n \n \n","019e46bb-f73a-762f-bb0e-9e54a584da61",["D",1779303184101],"branchVersion","label",[170,67],"frontend","pulls","branches","forks","envVars",{"_178":26,"_180":26},"connections",{"_178":26,"_179":26},"count","unfilledCount","emptyCount",{"_32":257,"_13":170,"_65":165,"_42":-5,"_34":35,"_167":39,"_194":86,"_36":258,"_38":26,"_68":254,"_163":-5,"_69":24,"_168":-5,"_198":259,"_17":260},{"_32":252,"_13":235,"_65":229,"_42":165,"_34":35,"_167":39,"_194":86,"_36":253,"_38":26,"_68":254,"_163":-5,"_69":24,"_168":-5,"_198":255,"_17":256},{"_32":244,"_13":245,"_65":246,"_42":229,"_34":35,"_167":247,"_194":86,"_36":248,"_38":39,"_68":212,"_163":249,"_69":24,"_168":-5,"_198":250,"_17":251},{"_32":236,"_13":237,"_65":238,"_42":229,"_34":35,"_167":239,"_194":86,"_36":240,"_38":26,"_68":212,"_163":241,"_69":24,"_168":-5,"_198":242,"_17":243},{"_32":226,"_13":227,"_65":228,"_42":229,"_34":35,"_167":230,"_194":86,"_36":231,"_38":26,"_68":212,"_163":232,"_69":24,"_168":-5,"_198":233,"_17":234},{"_32":219,"_13":220,"_65":221,"_42":165,"_34":35,"_167":39,"_194":86,"_36":222,"_38":26,"_68":21,"_163":223,"_69":24,"_168":-5,"_198":224,"_17":225},{"_32":162,"_13":67,"_65":66,"_42":165,"_34":35,"_167":39,"_194":86,"_36":216,"_38":26,"_68":21,"_163":164,"_69":24,"_168":-5,"_198":217,"_17":218},{"_32":208,"_13":209,"_65":210,"_42":165,"_34":35,"_167":39,"_194":86,"_36":211,"_38":26,"_68":212,"_163":213,"_69":24,"_168":-5,"_198":214,"_17":215},{"_32":201,"_13":202,"_65":203,"_42":-5,"_34":35,"_167":112,"_194":86,"_36":204,"_38":39,"_68":21,"_163":205,"_69":24,"_168":-5,"_198":206,"_17":207},{"_32":191,"_13":192,"_65":84,"_42":-5,"_34":35,"_167":193,"_194":86,"_36":195,"_38":39,"_68":196,"_163":197,"_69":24,"_168":-5,"_198":199,"_17":200},"26e25514-547d-11f1-9a83-ee650bb23af1","index.ts",2,"latest",["D",1779303192500],"http","import { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { Hono } from \"npm:hono\";\n\nconst app = new Hono();\n\n// Initialize database with demo data\nasync function initDatabase() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS deals (\n id INTEGER PRIMARY KEY,\n name TEXT NOT NULL,\n company TEXT NOT NULL,\n status TEXT NOT NULL,\n amount INTEGER NOT NULL,\n createdAt TEXT NOT NULL\n )\n `);\n\n // Check if demo data exists\n const result = await sqlite.execute(\"SELECT COUNT(*) as count FROM deals\");\n const count = (result.rows[0] as any)?.count || 0;\n\n if (count === 0) {\n // Insert demo data\n await sqlite.batch([\n {\n sql: \"INSERT INTO deals (name, company, status, amount, createdAt) VALUES (?, ?, ?, ?, ?)\",\n args: [\"Website Redesign\", \"Acme Corp\", \"lead\", 15000, new Date().toISOString()],\n },\n {\n sql: \"INSERT INTO deals (name, company, status, amount, createdAt) VALUES (?, ?, ?, ?, ?)\",\n args: [\"API Integration\", \"TechStart Inc\", \"lead\", 8000, new Date().toISOString()],\n },\n {\n sql: \"INSERT INTO deals (name, company, status, amount, createdAt) VALUES (?, ?, ?, ?, ?)\",\n args: [\"Analytics Dashboard\", \"DataFlow Ltd\", \"qualified\", 25000, new Date().toISOString()],\n },\n {\n sql: \"INSERT INTO deals (name, company, status, amount, createdAt) VALUES (?, ?, ?, ?, ?)\",\n args: [\"CRM Implementation\", \"Global Logistics\", \"qualified\", 45000, new Date().toISOString()],\n },\n {\n sql: \"INSERT INTO deals (name, company, status, amount, createdAt) VALUES (?, ?, ?, ?, ?)\",\n args: [\"Support Package\", \"FinServ Solutions\", \"proposal\", 12000, new Date().toISOString()],\n },\n {\n sql: \"INSERT INTO deals (name, company, status, amount, createdAt) VALUES (?, ?, ?, ?, ?)\",\n args: [\"Enterprise License\", \"BigBank Group\", \"proposal\", 75000, new Date().toISOString()],\n },\n {\n sql: \"INSERT INTO deals (name, company, status, amount, createdAt) VALUES (?, ?, ?, ?, ?)\",\n args: [\"Migration Services\", \"RetailCo\", \"negotiation\", 35000, new Date().toISOString()],\n },\n {\n sql: \"INSERT INTO deals (name, company, status, amount, createdAt) VALUES (?, ?, ?, ?, ?)\",\n args: [\"Annual Renewal\", \"TechStart Inc\", \"won\", 18000, new Date().toISOString()],\n },\n ]);\n }\n}\n\n// Initialize on startup\nawait initDatabase();\n\n// API Routes\napp.get(\"/api/deals\", async (c) => {\n const result = await sqlite.execute(\"SELECT * FROM deals ORDER BY createdAt DESC\");\n return c.json(result.rows);\n});\n\napp.post(\"/api/deals/:id/status\", async (c) => {\n const id = c.req.param(\"id\");\n const { status } = await c.req.json() as { status: string };\n await sqlite.execute(\"UPDATE deals SET status = ? WHERE id = ?\", [status, id]);\n return c.json({ ok: true });\n});\n\napp.post(\"/api/deals\", async (c) => {\n const { name, company, amount } = await c.req.json() as { name: string; company: string; amount: number };\n await sqlite.execute(\n \"INSERT INTO deals (name, company, status, amount, createdAt) VALUES (?, ?, ?, ?, ?)\",\n [name, company, \"lead\", amount, new Date().toISOString()]\n );\n return c.json({ ok: true });\n});\n\n// Serve index.html at the root /\napp.get(\"/\", () => serveFile(\"/frontend/index.html\"));\n\n// Serve all /frontend files\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\n\n// View source redirect\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","children",[],[192],"34f596fc-547d-11f1-9751-ee650bb23af1","README.md","019e46bb-f73a-762f-bb0e-a19784aad05b",["D",1779303216121],"# CRM Kanban Board\n\nA minimal sales pipeline kanban board built with React, Hono, and SQLite on Val Town.\n\n**Features:**\n- 5-stage sales pipeline (Lead → Qualified → Proposal → Negotiation → Won)\n- Drag-and-drop deals to update status\n- Real-time deal tracking with amounts\n- Pre-loaded with 8 demo deals\n- Dark theme with gradient styling\n\n## How it works\n\n1. **Backend** (`index.ts`): Hono server that initializes SQLite with demo data and provides API routes\n2. **Frontend** (`frontend/components/`): React components for the kanban board\n - `App.tsx`: Loads deals from `/api/deals` and handles status updates\n - `Kanban.tsx`: 5-column kanban with drag-and-drop\n - `DealCard.tsx`: Individual deal cards\n\n## API\n\n- `GET /api/deals` — Get all deals\n- `POST /api/deals/:id/status` — Update deal status\n- `POST /api/deals` — Create new deal\n\n## Database\n\nSQLite table:\n```sql\nCREATE TABLE deals (\n id INTEGER PRIMARY KEY,\n name TEXT NOT NULL,\n company TEXT NOT NULL,\n status TEXT NOT NULL,\n amount INTEGER NOT NULL,\n createdAt TEXT NOT NULL\n)\n```\n\n## Next steps\n\n- Add edit/delete functionality\n- Persist drag-drop reordering\n- Add filtering and search\n- Connect to a real CRM API\n",[],[202],"21ee06ac-547d-11f1-8572-ee650bb23af1","index.tsx","019e46bb-f73a-762f-bb0e-99416623d600",["D",1779303184101],"script","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst root = document.getElementById(\"root\");\nif (!root) {\n throw new Error(\"No root element found\");\n}\n\ncreateRoot(root).render();",[],[170,209],["D",1779303184101],[],[170,67],"21edfe3c-547d-11f1-8572-ee650bb23af1","favicon.svg","019e46bb-f73a-762f-bb0e-901d3f516ac9",["D",1779303184101],"\n",[],[170,220],"2da747a6-547d-11f1-ac51-ee650bb23af1","Kanban.tsx","2da74a12-547d-11f1-ac51-ee650bb23af1","019e46bb-f73a-762f-bb0e-8d34aea2a6b3",4,["D",1779303203863],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\nimport { DealCard } from \"./DealCard.tsx\";\n\ninterface Deal {\n id: number;\n name: string;\n company: string;\n status: string;\n amount: number;\n}\n\ninterface KanbanProps {\n deals: Deal[];\n onUpdateStatus: (dealId: number, newStatus: string) => void;\n}\n\nconst STAGES = [\n { id: \"lead\", label: \"Lead\", color: \"from-blue-500 to-blue-600\" },\n { id: \"qualified\", label: \"Qualified\", color: \"from-purple-500 to-purple-600\" },\n { id: \"proposal\", label: \"Proposal\", color: \"from-orange-500 to-orange-600\" },\n { id: \"negotiation\", label: \"Negotiation\", color: \"from-pink-500 to-pink-600\" },\n { id: \"won\", label: \"Won\", color: \"from-green-500 to-green-600\" },\n];\n\nexport function Kanban({ deals, onUpdateStatus }: KanbanProps) {\n const [draggedCard, setDraggedCard] = useState(null);\n\n const dealsByStatus = STAGES.reduce(\n (acc, stage) => ({\n ...acc,\n [stage.id]: deals.filter((d) => d.status === stage.id),\n }),\n {} as Record\n );\n\n const handleDragStart = (dealId: number) => {\n setDraggedCard(dealId);\n };\n\n const handleDrop = (status: string) => {\n if (draggedCard !== null) {\n onUpdateStatus(draggedCard, status);\n setDraggedCard(null);\n }\n };\n\n return (\n

\n {STAGES.map((stage) => (\n e.preventDefault()}\n onDrop={() => handleDrop(stage.id)}\n >\n

{stage.label}

\n \n {dealsByStatus[stage.id].length}\n \n

\n\n

\n {dealsByStatus[stage.id].length === 0 ? (\n

No deals

\n ) : (\n dealsByStatus[stage.id].map((deal) => (\n handleDragStart(deal.id)}\n class={`cursor-move transition-opacity ${\n draggedCard === deal.id ? \"opacity-50\" : \"\"\n }`}\n >\n \n

\n ))\n )}\n

\n\n

\n ${dealsByStatus[stage.id].reduce((sum, d) => sum + d.amount, 0).toLocaleString()}\n

\n ))}\n \n \n );\n}\n",[],[170,235,227],"components","2f2b42c6-547d-11f1-ac51-ee650bb23af1","DealCard.tsx","2f2b43b6-547d-11f1-ac51-ee650bb23af1",5,["D",1779303206409],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\ninterface Deal {\n id: number;\n name: string;\n company: string;\n status: string;\n amount: number;\n}\n\nexport function DealCard({ deal }: { deal: Deal }) {\n return (\n

{deal.name}

{deal.company}

${deal.amount.toLocaleString()}

\n );\n}\n",[],[170,235,237],"29c1303e-547d-11f1-9a83-ee650bb23af1","App.tsx","019e46bb-f73a-762f-bb0e-8457ebbac640",3,["D",1779303197310],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport { Kanban } from \"./Kanban.tsx\";\n\ninterface Deal {\n id: number;\n name: string;\n company: string;\n status: string;\n amount: number;\n}\n\nexport function App() {\n const [deals, setDeals] = useState([]);\n const [loading, setLoading] = useState(true);\n\n useEffect(() => {\n const fetchDeals = async () => {\n try {\n const res = await fetch(\"/api/deals\");\n const data = await res.json();\n setDeals(data);\n } catch (err) {\n console.error(\"Failed to fetch deals\", err);\n } finally {\n setLoading(false);\n }\n };\n\n fetchDeals();\n }, []);\n\n const updateDealStatus = async (dealId: number, newStatus: string) => {\n try {\n await fetch(`/api/deals/${dealId}/status`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ status: newStatus }),\n });\n setDeals(deals.map((d) => (d.id === dealId ? { ...d, status: newStatus } : d)));\n } catch (err) {\n console.error(\"Failed to update deal\", err);\n }\n };\n\n return (\n

Sales Pipeline

Drag deals across stages to update their status

\n\n {loading ? (\n

Loading deals...

\n ) : (\n \n )}\n\n

\n View source\n

\n );\n}\n",[],[170,235,245],"21edfcc0-547d-11f1-8572-ee650bb23af1",["D",1779303184101],"directory",[183,184,185],[170,235],"21ee0b02-547d-11f1-8572-ee650bb23af1",["D",1779303184101],[182,186,187,188],[170],["D",1779303184101],["D",1789676511826],{"_11":12,"_128":72},{"_11":12,"_124":-5,"_71":72,"_30":70,"_125":126,"_127":24},{"_38":112,"_13":16,"_32":35,"_113":74,"_114":62,"_115":116,"_117":78,"_118":119,"_120":121,"_122":14,"_123":12},"ctx",{"_51":-5,"_149":299,"_300":301,"_302":303,"_304":24,"_305":24,"_306":24,"_307":86,"_308":-5,"_309":-7,"_310":-7,"_311":26,"_312":24,"_313":24,"_314":-5,"_315":24,"_316":24,"_317":24,"_318":-5},"ENV",{"_270":271,"_272":273,"_274":16,"_275":276,"_277":278,"_279":280,"_281":282,"_283":284,"_285":286,"_287":288,"_289":290,"_291":292,"_293":294,"_295":296,"_297":298},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

History · index.html