[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_350":351,"_352":353},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_262":-5,"_20":263,"_22":264,"_265":266,"_267":268,"_26":269,"_24":270,"_271":-5,"_272":-5,"_273":55,"_274":275,"_276":46,"_277":-5,"_278":-5,"_279":280},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","gflexmsme2lang","name","tridev-crm","branchName","main","version","path","shared","project",{"_34":205,"_13":14,"_47":206,"_207":-5,"_208":55,"_209":210,"_211":210,"_212":213,"_214":-5,"_215":216,"_217":70,"_218":46,"_219":-5,"_220":-5,"_221":49,"_222":223,"_224":225,"_226":227,"_228":229,"_230":-5,"_231":232,"_233":232,"_234":235,"_236":235,"_237":235,"_238":232,"_239":232,"_240":241,"_242":243,"_244":245,"_246":55},"tree",[63,64,65,66,67],"file",{"_34":58,"_41":42,"_37":40,"_13":19,"_52":-5,"_50":59,"_17":49,"_39":-5,"_47":60,"_43":61,"_56":-5,"_18":62},"contents",[33],"upstream","pull","ahead","behind","envVars",{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":57},"id","26758c8e-3ce7-11f1-929b-42b51c65c3df","types.ts","fileId","26758d42-3ce7-11f1-929b-42b51c65c3df","parentId","07e9e6ca-3ce7-11f1-b431-42b51c65c3df","branchId","0529eb56-3ce7-11f1-a75d-42b51c65c3df","branchVersion",7,"latest",true,"createdAt",["D",1776709890491],0,"fileType","script","content","export const LEAD_SOURCES = [\"Facebook\", \"Instagram\", \"Referral\", \"Cold Call\", \"Website\", \"Other\"] as const;\nexport const SERVICES = [\"Website\", \"App\", \"SEO\", \"Social Media\", \"Branding\", \"Other\"] as const;\nexport const LEAD_STATUSES = [\"New\", \"Contacted\", \"No Response\", \"Not Interested\", \"Converted\"] as const;\nexport const PIPELINE_STAGES = [\"Discussion\", \"Meeting\", \"Token Pending\", \"Token Done\", \"On Hold\", \"Lost\"] as const;\nexport const PROBABILITIES = [\"High\", \"Medium\", \"Low\"] as const;\nexport const PROJECT_STATUSES = [\"Planning\", \"In Progress\", \"Review\", \"Completed\"] as const;\n\nexport interface Lead {\n id: number;\n created_at: string;\n name: string;\n contact: string;\n email: string;\n source: string;\n service: string;\n budget: number;\n status: string;\n next_followup: string;\n assigned_to: string;\n notes: string;\n}\n\nexport interface PipelineItem {\n id: number;\n lead_id: number | null;\n client_name: string;\n service: string;\n stage: string;\n probability: string;\n expected_value: number;\n expected_close: string;\n last_activity: string;\n next_action: string;\n assigned_to: string;\n}\n\nexport interface Project {\n id: number;\n client_name: string;\n service: string;\n start_date: string;\n deadline: string;\n total_value: number;\n status: string;\n progress: number;\n team_assigned: string;\n client_feedback: string;\n delivery_date: string | null;\n}\n\nexport interface Payment {\n id: number;\n project_id: number | null;\n client_name: string;\n total_amount: number;\n token_amount: number;\n token_date: string;\n received_amount: number;\n next_payment_due: string;\n payment_history: string;\n}\n\nexport interface DashboardStats {\n totalLeads: number;\n totalMeetings: number;\n tokenReceived: number;\n activeClients: number;\n expectedRevenue: number;\n receivedRevenue: number;\n pendingRevenue: number;\n conversionRate: number;\n followupsDue: number;\n overdueProjects: number;\n pendingPayments: number;\n}\n","deleted",false,"label",[19,36],"07e9e60c-3ce7-11f1-b431-42b51c65c3df","directory",["D",1776709839295],3,[19],{"_34":180,"_13":181,"_37":182,"_39":-5,"_41":42,"_43":183,"_45":46,"_47":184,"_17":49,"_50":59,"_52":-5,"_54":55,"_56":-5,"_75":185,"_18":186},{"_34":93,"_13":94,"_37":95,"_39":-5,"_41":42,"_43":96,"_45":46,"_47":97,"_17":49,"_50":59,"_52":-5,"_54":55,"_56":-5,"_75":98,"_18":99},{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":61,"_45":46,"_47":86,"_17":49,"_50":59,"_52":-5,"_54":55,"_56":-5,"_75":87,"_18":88},{"_34":78,"_13":79,"_37":80,"_39":-5,"_41":42,"_43":81,"_45":46,"_47":82,"_17":49,"_50":24,"_52":83,"_54":55,"_56":-5,"_75":84,"_18":85},{"_34":68,"_13":69,"_37":70,"_39":-5,"_41":42,"_43":71,"_45":46,"_47":72,"_17":49,"_50":73,"_52":74,"_54":55,"_56":-5,"_75":76,"_18":77},"2fb1d37a-3ce7-11f1-929b-42b51c65c3df","index.ts","2fb1d4a6-3ce7-11f1-929b-42b51c65c3df",8,["D",1776709906029],"http","import { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport { runMigrations, seedSampleData } from \"./database/migrations.ts\";\nimport * as db from \"./database/queries.ts\";\n\nconst app = new Hono();\n\n// Run migrations on startup\nlet initialized = false;\napp.use(\"*\", async (c, next) => {\n if (!initialized) {\n await runMigrations();\n await seedSampleData();\n initialized = true;\n }\n await next();\n});\n\n// ===== STATIC FILES =====\napp.get(\"/\", () => serveFile(\"/frontend/index.html\"));\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path));\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// ===== API: DASHBOARD =====\napp.get(\"/api/dashboard\", async (c) => {\n const stats = await db.getDashboardStats();\n return c.json(stats);\n});\n\n// ===== API: LEADS =====\napp.get(\"/api/leads\", async (c) => {\n const leads = await db.getLeads();\n return c.json(leads);\n});\n\napp.post(\"/api/leads\", async (c) => {\n const body = await c.req.json();\n await db.addLead(body);\n return c.json({ ok: true });\n});\n\napp.put(\"/api/leads/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const body = await c.req.json();\n await db.updateLead(id, body);\n return c.json({ ok: true });\n});\n\napp.delete(\"/api/leads/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n await db.deleteLead(id);\n return c.json({ ok: true });\n});\n\n// ===== API: PIPELINE =====\napp.get(\"/api/pipeline\", async (c) => {\n const items = await db.getPipeline();\n return c.json(items);\n});\n\napp.post(\"/api/pipeline\", async (c) => {\n const body = await c.req.json();\n await db.addPipelineItem(body);\n return c.json({ ok: true });\n});\n\napp.put(\"/api/pipeline/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const body = await c.req.json();\n await db.updatePipelineItem(id, body);\n return c.json({ ok: true });\n});\n\napp.delete(\"/api/pipeline/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n await db.deletePipelineItem(id);\n return c.json({ ok: true });\n});\n\n// ===== API: PROJECTS =====\napp.get(\"/api/projects\", async (c) => {\n const projects = await db.getProjects();\n return c.json(projects);\n});\n\napp.post(\"/api/projects\", async (c) => {\n const body = await c.req.json();\n await db.addProject(body);\n return c.json({ ok: true });\n});\n\napp.put(\"/api/projects/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const body = await c.req.json();\n await db.updateProject(id, body);\n return c.json({ ok: true });\n});\n\napp.delete(\"/api/projects/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n await db.deleteProject(id);\n return c.json({ ok: true });\n});\n\n// ===== API: PAYMENTS =====\napp.get(\"/api/payments\", async (c) => {\n const payments = await db.getPayments();\n return c.json(payments);\n});\n\napp.post(\"/api/payments\", async (c) => {\n const body = await c.req.json();\n await db.addPayment(body);\n return c.json({ ok: true });\n});\n\napp.put(\"/api/payments/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const body = await c.req.json();\n await db.updatePayment(id, body);\n return c.json({ ok: true });\n});\n\napp.delete(\"/api/payments/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n await db.deletePayment(id);\n return c.json({ ok: true });\n});\n\napp.onError((err) => Promise.reject(err));\nexport default app.fetch;\n","children",[],[69],"972b7d08-3ce7-11f1-932b-42b51c65c3df","README.md","972b7dc6-3ce7-11f1-932b-42b51c65c3df",17,["D",1776710079625],"# 🔥 TRIDEV CRM\n\nComplete CRM system for managing leads, sales pipeline, projects, and payments.\n\n## Features\n\n- **📊 Dashboard** — Real-time KPIs: leads, meetings, tokens, revenue, conversion rate, and priority alerts\n- **👥 Leads Management** — Track leads with source, service, budget, status, and follow-up alerts (🔴 overdue / 🟢 OK)\n- **🔄 Sales Pipeline** — Kanban board + table view with stages: Discussion → Meeting → Token Pending → Token Done\n- **📁 Active Projects** — Card-based project tracker with progress bars, deadlines, and team assignments\n- **💰 Payments Tracker** — Track token amounts, received payments, pending balances with auto-calculations\n\n## Architecture\n\n```mermaid\ngraph TD\n A[index.ts - Hono HTTP] --> B[frontend/index.html]\n A --> C[API Routes /api/*]\n C --> D[database/queries.ts]\n D --> E[SQLite Database]\n B --> F[React SPA]\n F --> G[Dashboard]\n F --> H[Leads Table]\n F --> I[Pipeline Board]\n F --> J[Projects Cards]\n F --> K[Payments Table]\n```\n\n## Tech Stack\n\n- **Backend**: Hono + Val Town SQLite\n- **Frontend**: React 18 + Twind (Tailwind CSS)\n- **Database**: SQLite with 4 tables (leads, pipeline, projects, payments)\n\n## Data Model\n\n| Table | Key Fields |\n|-------|-----------|\n| `leads` | name, contact, email, source, service, budget, status, next_followup |\n| `pipeline` | client_name, stage, probability, expected_value, next_action |\n| `projects` | client_name, service, deadline, total_value, status, progress |\n| `payments` | client_name, total_amount, token_amount, received_amount |\n",[],[79],["D",1776709839295],[89],[19],{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":90,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_75":91,"_18":92},["D",1776709890491],[],[19,36],"07d260ae-3ce7-11f1-a75d-42b51c65c3df","frontend","07d26176-3ce7-11f1-a75d-42b51c65c3df",2,["D",1776709839135],[100,101,102],[94],{"_34":119,"_13":120,"_37":121,"_39":95,"_41":42,"_43":122,"_45":46,"_47":123,"_17":49,"_50":59,"_52":-5,"_54":55,"_56":-5,"_75":124,"_18":125},{"_34":111,"_13":112,"_37":113,"_39":95,"_41":42,"_43":114,"_45":46,"_47":115,"_17":49,"_50":24,"_52":116,"_54":55,"_56":-5,"_75":117,"_18":118},{"_34":103,"_13":104,"_37":105,"_39":95,"_41":42,"_43":106,"_45":46,"_47":107,"_17":49,"_50":51,"_52":108,"_54":55,"_56":-5,"_75":109,"_18":110},"3539c79e-3ce7-11f1-929b-42b51c65c3df","index.tsx","3539c866-3ce7-11f1-929b-42b51c65c3df",10,["D",1776709915314],"/** @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) throw new Error(\"No root element found\");\ncreateRoot(root).render();\n",[],[94,104],"31b3a144-3ce7-11f1-a414-42b51c65c3df","index.html","31b3a22a-3ce7-11f1-a414-42b51c65c3df",9,["D",1776709909405],"\n\n \n \n \n 🔥 TRIDEV CRM\n \n \n \n \n \n \n

\n \n \n \n\n",[],[94,112],"097f08e4-3ce7-11f1-a75d-42b51c65c3df","components","097f09b6-3ce7-11f1-a75d-42b51c65c3df",4,["D",1776709841951],[126,127,128,129,130,131],[94,120],{"_34":172,"_13":173,"_37":174,"_39":121,"_41":42,"_43":175,"_45":46,"_47":176,"_17":49,"_50":51,"_52":177,"_54":55,"_56":-5,"_75":178,"_18":179},{"_34":164,"_13":165,"_37":166,"_39":121,"_41":42,"_43":167,"_45":46,"_47":168,"_17":49,"_50":51,"_52":169,"_54":55,"_56":-5,"_75":170,"_18":171},{"_34":156,"_13":157,"_37":158,"_39":121,"_41":42,"_43":159,"_45":46,"_47":160,"_17":49,"_50":51,"_52":161,"_54":55,"_56":-5,"_75":162,"_18":163},{"_34":148,"_13":149,"_37":150,"_39":121,"_41":42,"_43":151,"_45":46,"_47":152,"_17":49,"_50":51,"_52":153,"_54":55,"_56":-5,"_75":154,"_18":155},{"_34":140,"_13":141,"_37":142,"_39":121,"_41":42,"_43":143,"_45":46,"_47":144,"_17":49,"_50":51,"_52":145,"_54":55,"_56":-5,"_75":146,"_18":147},{"_34":132,"_13":133,"_37":134,"_39":121,"_41":42,"_43":135,"_45":46,"_47":136,"_17":49,"_50":51,"_52":137,"_54":55,"_56":-5,"_75":138,"_18":139},"7a117ab0-3ce7-11f1-aa94-42b51c65c3df","ProjectsTable.tsx","7a117b5a-3ce7-11f1-aa94-42b51c65c3df",15,["D",1776710030817],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\n\nconst SERVICES = [\"Website\", \"App\", \"SEO\", \"Social Media\", \"Branding\", \"Other\"];\nconst STATUSES = [\"Planning\", \"In Progress\", \"Review\", \"Completed\"];\n\nconst STATUS_COLORS: Record = {\n \"Planning\": \"bg-blue-100 text-blue-800\",\n \"In Progress\": \"bg-yellow-100 text-yellow-800\",\n \"Review\": \"bg-purple-100 text-purple-800\",\n \"Completed\": \"bg-green-100 text-green-800\",\n};\n\nconst emptyProject = {\n client_name: \"\", service: \"Website\", deadline: \"\", total_value: 0,\n status: \"Planning\", progress: 0, team_assigned: \"You\", client_feedback: \"\",\n};\n\nexport function ProjectsTable() {\n const [projects, setProjects] = useState([]);\n const [loading, setLoading] = useState(true);\n const [showForm, setShowForm] = useState(false);\n const [form, setForm] = useState({ ...emptyProject });\n const [editId, setEditId] = useState(null);\n\n const load = () => { fetch(\"/api/projects\").then((r) => r.json()).then((d) => { setProjects(d); setLoading(false); }); };\n useEffect(load, []);\n\n const save = async () => {\n const method = editId ? \"PUT\" : \"POST\";\n const url = editId ? `/api/projects/${editId}` : \"/api/projects\";\n await fetch(url, { method, headers: { \"Content-Type\": \"application/json\" }, body: JSON.stringify(form) });\n setShowForm(false); setForm({ ...emptyProject }); setEditId(null); load();\n };\n\n const del = async (id: number) => { if (!confirm(\"Delete?\")) return; await fetch(`/api/projects/${id}`, { method: \"DELETE\" }); load(); };\n\n const startEdit = (p: any) => {\n setForm({\n client_name: p.client_name, service: p.service, deadline: p.deadline?.split(\"T\")[0] || \"\",\n total_value: p.total_value, status: p.status, progress: p.progress,\n team_assigned: p.team_assigned, client_feedback: p.client_feedback,\n });\n setEditId(p.id); setShowForm(true);\n };\n\n if (loading) return

Loading projects...

;\n\n return (\n

📁 Active Projects

\n \n

\n\n {/* Form Modal */}\n {showForm && (\n

{editId ? \"Edit Project\" : \"Add New Project\"}

\n Client Name *\n setForm({ ...form, client_name: e.target.value })} class=\"w-full border rounded-lg px-3 py-2 text-sm\" />\n

\n Service\n \n

\n Deadline\n setForm({ ...form, deadline: e.target.value })} class=\"w-full border rounded-lg px-3 py-2 text-sm\" />\n

\n Total Value (₹)\n setForm({ ...form, total_value: Number(e.target.value) })} class=\"w-full border rounded-lg px-3 py-2 text-sm\" />\n

\n Status\n \n

\n Progress % (0-100)\n setForm({ ...form, progress: Number(e.target.value) })} class=\"w-full border rounded-lg px-3 py-2 text-sm\" />\n

\n Team Assigned\n setForm({ ...form, team_assigned: e.target.value })} class=\"w-full border rounded-lg px-3 py-2 text-sm\" />\n

\n Client Feedback\n \n

\n \n \n

\n )}\n\n {/* Project Cards */}\n

\n {projects.map((p: any) => (\n

{p.client_name}

{p.service} • #{p.id}

\n {p.status}\n

\n Progress\n {p.progress}%\n

💰 Value: ₹{Number(p.total_value).toLocaleString(\"en-IN\")}

📅 Deadline: {p.deadline?.split(\"T\")[0] || \"—\"}

👤 Team: {p.team_assigned}

\n {p.client_feedback &&

\"{p.client_feedback}\"

}\n

\n \n \n

\n ))}\n {projects.length === 0 && (\n

No active projects yet.

\n )}\n

\n );\n}\n",[],[94,120,133],"6c8d30be-3ce7-11f1-9566-42b51c65c3df","PipelineBoard.tsx","6c8d3172-3ce7-11f1-9566-42b51c65c3df",14,["D",1776710008128],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\n\nconst STAGES = [\"Discussion\", \"Meeting\", \"Token Pending\", \"Token Done\", \"On Hold\", \"Lost\"];\nconst SERVICES = [\"Website\", \"App\", \"SEO\", \"Social Media\", \"Branding\", \"Other\"];\nconst PROBABILITIES = [\"High\", \"Medium\", \"Low\"];\n\nconst STAGE_COLORS: Record = {\n \"Discussion\": { bg: \"bg-gray-50\", border: \"border-gray-300\", text: \"text-gray-700\" },\n \"Meeting\": { bg: \"bg-blue-50\", border: \"border-blue-300\", text: \"text-blue-700\" },\n \"Token Pending\": { bg: \"bg-orange-50\", border: \"border-orange-300\", text: \"text-orange-700\" },\n \"Token Done\": { bg: \"bg-green-50\", border: \"border-green-300\", text: \"text-green-700\" },\n \"On Hold\": { bg: \"bg-pink-50\", border: \"border-pink-300\", text: \"text-pink-700\" },\n \"Lost\": { bg: \"bg-red-50\", border: \"border-red-300\", text: \"text-red-700\" },\n};\n\nconst emptyItem = {\n lead_id: null, client_name: \"\", service: \"Website\", stage: \"Discussion\",\n probability: \"Medium\", expected_value: 0, expected_close: \"\", next_action: \"\", assigned_to: \"You\",\n};\n\nexport function PipelineBoard() {\n const [items, setItems] = useState([]);\n const [loading, setLoading] = useState(true);\n const [showForm, setShowForm] = useState(false);\n const [form, setForm] = useState({ ...emptyItem });\n const [editId, setEditId] = useState(null);\n const [view, setView] = useState<\"board\" | \"table\">(\"board\");\n\n const load = () => { fetch(\"/api/pipeline\").then((r) => r.json()).then((d) => { setItems(d); setLoading(false); }); };\n useEffect(load, []);\n\n const save = async () => {\n const method = editId ? \"PUT\" : \"POST\";\n const url = editId ? `/api/pipeline/${editId}` : \"/api/pipeline\";\n await fetch(url, { method, headers: { \"Content-Type\": \"application/json\" }, body: JSON.stringify(form) });\n setShowForm(false); setForm({ ...emptyItem }); setEditId(null); load();\n };\n\n const del = async (id: number) => { if (!confirm(\"Delete?\")) return; await fetch(`/api/pipeline/${id}`, { method: \"DELETE\" }); load(); };\n\n const moveStage = async (id: number, stage: string) => {\n await fetch(`/api/pipeline/${id}`, {\n method: \"PUT\", headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ stage, last_activity: new Date().toISOString().split(\"T\")[0] }),\n });\n load();\n };\n\n const startEdit = (item: any) => {\n setForm({\n lead_id: item.lead_id, client_name: item.client_name, service: item.service,\n stage: item.stage, probability: item.probability, expected_value: item.expected_value,\n expected_close: item.expected_close?.split(\"T\")[0] || \"\", next_action: item.next_action, assigned_to: item.assigned_to,\n });\n setEditId(item.id); setShowForm(true);\n };\n\n if (loading) return

Loading pipeline...

;\n\n return (\n

🔄 Sales Pipeline

\n \n \n

\n\n {/* Form Modal */}\n {showForm && (\n

{editId ? \"Edit Deal\" : \"Add New Deal\"}

\n Client Name *\n setForm({ ...form, client_name: e.target.value })} class=\"w-full border rounded-lg px-3 py-2 text-sm\" />\n

\n Service\n \n

\n Stage\n \n

\n Probability\n \n

\n Expected Value (₹)\n setForm({ ...form, expected_value: Number(e.target.value) })} class=\"w-full border rounded-lg px-3 py-2 text-sm\" />\n

\n Expected Close\n setForm({ ...form, expected_close: e.target.value })} class=\"w-full border rounded-lg px-3 py-2 text-sm\" />\n

\n Assigned To\n setForm({ ...form, assigned_to: e.target.value })} class=\"w-full border rounded-lg px-3 py-2 text-sm\" />\n

\n Next Action\n setForm({ ...form, next_action: e.target.value })} class=\"w-full border rounded-lg px-3 py-2 text-sm\" />\n

\n \n \n

\n )}\n\n {/* Board View */}\n {view === \"board\" ? (\n

\n {STAGES.map((stage) => {\n const stageItems = items.filter((i: any) => i.stage === stage);\n const colors = STAGE_COLORS[stage] || STAGE_COLORS[\"Discussion\"];\n return (\n

{stage} ({stageItems.length})

\n {stageItems.map((item: any) => (\n

{item.client_name}

{item.service}

₹{Number(item.expected_value).toLocaleString(\"en-IN\")}

{item.next_action}

\n \n \n {stage !== \"Token Done\" && stage !== \"Lost\" && (\n { if (e.target.value) moveStage(item.id, e.target.value); }}\n >\n \n {STAGES.filter((s) => s !== stage).map((s) => )}\n \n )}\n

\n ))}\n

\n );\n })}\n

\n ) : (\n /* Table View */\n

\n \n \n \n \n \n \n \n \n \n \n \n \n \n {items.map((item: any) => {\n const colors = STAGE_COLORS[item.stage] || STAGE_COLORS[\"Discussion\"];\n return (\n \n \n \n \n \n \n \n \n \n );\n })}\n \n

Client	Service	Stage	Probability	Value	Next Action	Actions
{item.client_name}	{item.service}	{item.stage}	{item.probability}	₹{Number(item.expected_value).toLocaleString(\"en-IN\")}	{item.next_action}	\n \n \n

\n )}\n

\n );\n}\n",[],[94,120,141],"8a3c784a-3ce7-11f1-8da9-42b51c65c3df","PaymentsTable.tsx","8a3c78ea-3ce7-11f1-8da9-42b51c65c3df",16,["D",1776710057937],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\n\nconst emptyPayment = {\n project_id: null, client_name: \"\", total_amount: 0, token_amount: 0,\n token_date: \"\", received_amount: 0, next_payment_due: \"\", payment_history: \"\",\n};\n\nfunction formatCurrency(n: number) {\n return \"₹\" + Number(n).toLocaleString(\"en-IN\");\n}\n\nexport function PaymentsTable() {\n const [payments, setPayments] = useState([]);\n const [loading, setLoading] = useState(true);\n const [showForm, setShowForm] = useState(false);\n const [form, setForm] = useState({ ...emptyPayment });\n const [editId, setEditId] = useState(null);\n\n const load = () => { fetch(\"/api/payments\").then((r) => r.json()).then((d) => { setPayments(d); setLoading(false); }); };\n useEffect(load, []);\n\n const save = async () => {\n const method = editId ? \"PUT\" : \"POST\";\n const url = editId ? `/api/payments/${editId}` : \"/api/payments\";\n await fetch(url, { method, headers: { \"Content-Type\": \"application/json\" }, body: JSON.stringify(form) });\n setShowForm(false); setForm({ ...emptyPayment }); setEditId(null); load();\n };\n\n const del = async (id: number) => { if (!confirm(\"Delete?\")) return; await fetch(`/api/payments/${id}`, { method: \"DELETE\" }); load(); };\n\n const startEdit = (p: any) => {\n setForm({\n project_id: p.project_id, client_name: p.client_name, total_amount: p.total_amount,\n token_amount: p.token_amount, token_date: p.token_date?.split(\"T\")[0] || \"\",\n received_amount: p.received_amount, next_payment_due: p.next_payment_due?.split(\"T\")[0] || \"\",\n payment_history: p.payment_history,\n });\n setEditId(p.id); setShowForm(true);\n };\n\n // Summary calculations\n const totalAmount = payments.reduce((s: number, p: any) => s + Number(p.total_amount), 0);\n const totalReceived = payments.reduce((s: number, p: any) => s + Number(p.received_amount), 0);\n const totalPending = totalAmount - totalReceived;\n\n if (loading) return

Loading payments...

;\n\n return (\n

💰 Payments Tracker

\n \n

\n\n {/* Summary Cards */}\n

Total Contract Value

{formatCurrency(totalAmount)}

Total Received

{formatCurrency(totalReceived)}

0 ? \"bg-red-50 border-red-200\" : \"bg-green-50 border-green-200\"}`}>\n

0 ? \"text-red-600\" : \"text-green-600\"}`}>Total Pending

0 ? \"text-red-700\" : \"text-green-700\"}`}>{formatCurrency(totalPending)}

\n\n {/* Form Modal */}\n {showForm && (\n

{editId ? \"Edit Payment\" : \"Add New Payment\"}

\n Client Name *\n setForm({ ...form, client_name: e.target.value })} class=\"w-full border rounded-lg px-3 py-2 text-sm\" />\n

\n Project ID\n setForm({ ...form, project_id: e.target.value ? Number(e.target.value) : null })} class=\"w-full border rounded-lg px-3 py-2 text-sm\" />\n

\n Total Amount (₹)\n setForm({ ...form, total_amount: Number(e.target.value) })} class=\"w-full border rounded-lg px-3 py-2 text-sm\" />\n

\n Token Amount (₹)\n setForm({ ...form, token_amount: Number(e.target.value) })} class=\"w-full border rounded-lg px-3 py-2 text-sm\" />\n

\n Token Date\n setForm({ ...form, token_date: e.target.value })} class=\"w-full border rounded-lg px-3 py-2 text-sm\" />\n

\n Received Amount (₹)\n setForm({ ...form, received_amount: Number(e.target.value) })} class=\"w-full border rounded-lg px-3 py-2 text-sm\" />\n

\n Next Payment Due\n setForm({ ...form, next_payment_due: e.target.value })} class=\"w-full border rounded-lg px-3 py-2 text-sm\" />\n

\n Payment History / Notes\n \n

\n \n \n

\n )}\n\n {/* Table */}\n

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n {payments.map((p: any) => {\n const balance = Number(p.total_amount) - Number(p.received_amount);\n const isPaid = balance <= 0;\n return (\n \n \n \n \n \n \n \n \n \n \n \n );\n })}\n {payments.length === 0 && (\n \n )}\n \n

ID	Client	Total	Token	Received	Balance	Status	Next Due	Actions
{p.id}	{p.client_name}	{formatCurrency(p.total_amount)}	{formatCurrency(p.token_amount)}	{formatCurrency(p.received_amount)}	{formatCurrency(balance)}	\n \n {isPaid ? \"✅ Paid\" : `⏳ Pending`}\n \n	{p.next_payment_due?.split(\"T\")[0] \|\| \"—\"}	\n \n \n
No payments recorded yet.

\n );\n}\n",[],[94,120,149],"577e785e-3ce7-11f1-929b-42b51c65c3df","LeadsTable.tsx","577e7912-3ce7-11f1-929b-42b51c65c3df",13,["D",1776709972809],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\n\nconst SOURCES = [\"Facebook\", \"Instagram\", \"Referral\", \"Cold Call\", \"Website\", \"Other\"];\nconst SERVICES = [\"Website\", \"App\", \"SEO\", \"Social Media\", \"Branding\", \"Other\"];\nconst STATUSES = [\"New\", \"Contacted\", \"No Response\", \"Not Interested\", \"Converted\"];\n\nconst STATUS_COLORS: Record = {\n \"New\": \"bg-blue-100 text-blue-800\",\n \"Contacted\": \"bg-yellow-100 text-yellow-800\",\n \"No Response\": \"bg-gray-100 text-gray-800\",\n \"Not Interested\": \"bg-red-100 text-red-800\",\n \"Converted\": \"bg-green-100 text-green-800\",\n};\n\nfunction isOverdue(dateStr: string) {\n if (!dateStr) return false;\n return new Date(dateStr) < new Date(new Date().toISOString().split(\"T\")[0]);\n}\n\nconst emptyLead = {\n name: \"\", contact: \"\", email: \"\", source: \"Facebook\", service: \"Website\",\n budget: 0, status: \"New\", next_followup: \"\", assigned_to: \"You\", notes: \"\",\n};\n\nexport function LeadsTable() {\n const [leads, setLeads] = useState([]);\n const [loading, setLoading] = useState(true);\n const [showForm, setShowForm] = useState(false);\n const [form, setForm] = useState({ ...emptyLead });\n const [editId, setEditId] = useState(null);\n\n const load = () => {\n fetch(\"/api/leads\").then((r) => r.json()).then((data) => { setLeads(data); setLoading(false); });\n };\n useEffect(load, []);\n\n const save = async () => {\n const method = editId ? \"PUT\" : \"POST\";\n const url = editId ? `/api/leads/${editId}` : \"/api/leads\";\n await fetch(url, { method, headers: { \"Content-Type\": \"application/json\" }, body: JSON.stringify(form) });\n setShowForm(false); setForm({ ...emptyLead }); setEditId(null); load();\n };\n\n const del = async (id: number) => {\n if (!confirm(\"Delete this lead?\")) return;\n await fetch(`/api/leads/${id}`, { method: \"DELETE\" });\n load();\n };\n\n const startEdit = (lead: any) => {\n setForm({\n name: lead.name, contact: lead.contact, email: lead.email, source: lead.source,\n service: lead.service, budget: lead.budget, status: lead.status,\n next_followup: lead.next_followup?.split(\"T\")[0] || \"\", assigned_to: lead.assigned_to, notes: lead.notes,\n });\n setEditId(lead.id); setShowForm(true);\n };\n\n if (loading) return

Loading leads...

;\n\n return (\n

👥 Leads Management

\n \n

\n\n {/* Form Modal */}\n {showForm && (\n

{editId ? \"Edit Lead\" : \"Add New Lead\"}

\n Name *\n setForm({ ...form, name: e.target.value })} class=\"w-full border rounded-lg px-3 py-2 text-sm\" />\n

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

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

\n Source\n \n

\n Service\n \n

\n Budget (₹)\n setForm({ ...form, budget: Number(e.target.value) })} class=\"w-full border rounded-lg px-3 py-2 text-sm\" />\n

\n Status\n \n

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

\n Assigned To\n setForm({ ...form, assigned_to: e.target.value })} class=\"w-full border rounded-lg px-3 py-2 text-sm\" />\n

\n Notes\n \n

\n \n \n

\n )}\n\n {/* Table */}\n

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n {leads.map((l: any) => (\n \n \n \n \n \n \n \n \n \n \n \n ))}\n {leads.length === 0 && (\n \n )}\n \n

ID	Name	Contact	Source	Service	Budget	Status	Follow-up	Actions
{l.id}	{l.name}	{l.contact}	{l.source}	{l.service}	₹{Number(l.budget).toLocaleString(\"en-IN\")}	\n {l.status}\n	\n {l.next_followup && (\n \n {isOverdue(l.next_followup) ? \"🔴 \" : \"🟢 \"}{l.next_followup?.split(\"T\")[0]}\n \n )}\n	\n \n \n
No leads yet. Add your first lead!

\n );\n}\n",[],[94,120,157],"467088d6-3ce7-11f1-9566-42b51c65c3df","Dashboard.tsx","4670898a-3ce7-11f1-9566-42b51c65c3df",12,["D",1776709944195],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\n\ninterface Stats {\n totalLeads: number;\n totalMeetings: number;\n tokenReceived: number;\n activeClients: number;\n expectedRevenue: number;\n receivedRevenue: number;\n pendingRevenue: number;\n conversionRate: number;\n followupsDue: number;\n overdueProjects: number;\n pendingPayments: number;\n}\n\nfunction formatCurrency(n: number) {\n return \"₹\" + n.toLocaleString(\"en-IN\");\n}\n\nfunction KPICard({ label, value, icon, color }: { label: string; value: string | number; icon: string; color: string }) {\n return (\n

{icon}

{label}

{value}

\n );\n}\n\nfunction AlertCard({ label, value, icon }: { label: string; value: number; icon: string }) {\n const isAlert = value > 0;\n return (\n

\n {icon}\n {label}\n

\n {value}\n

\n );\n}\n\nexport function Dashboard() {\n const [stats, setStats] = useState(null);\n const [loading, setLoading] = useState(true);\n\n useEffect(() => {\n fetch(\"/api/dashboard\")\n .then((r) => r.json())\n .then((data) => { setStats(data); setLoading(false); })\n .catch(() => setLoading(false));\n }, []);\n\n if (loading) return

Loading dashboard...

;\n if (!stats) return

Failed to load stats

;\n\n return (\n

\n {/* Title */}\n

🔥 TRIDEV CRM Dashboard

Real-time business metrics at a glance

\n\n {/* KPI Grid */}\n

\n \n \n \n \n

\n\n {/* Revenue Section */}\n

💰 Revenue Overview

Expected Revenue

{formatCurrency(stats.expectedRevenue)}

Received Revenue

{formatCurrency(stats.receivedRevenue)}

Pending Revenue

{formatCurrency(stats.pendingRevenue)}

\n\n {/* Conversion Rate */}\n

Conversion Rate (Leads → Token Done)

\n {(stats.conversionRate * 100).toFixed(1)}%\n

\n\n {/* Priority Actions */}\n

🚨 Priority Actions

\n \n \n \n

\n \n );\n}\n",[],[94,120,165],"3a2b1bfe-3ce7-11f1-929b-42b51c65c3df","App.tsx","3a2b1d02-3ce7-11f1-929b-42b51c65c3df",11,["D",1776709923609],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\nimport { Dashboard } from \"./Dashboard.tsx\";\nimport { LeadsTable } from \"./LeadsTable.tsx\";\nimport { PipelineBoard } from \"./PipelineBoard.tsx\";\nimport { ProjectsTable } from \"./ProjectsTable.tsx\";\nimport { PaymentsTable } from \"./PaymentsTable.tsx\";\n\nconst TABS = [\n { id: \"dashboard\", label: \"📊 Dashboard\", icon: \"📊\" },\n { id: \"leads\", label: \"👥 Leads\", icon: \"👥\" },\n { id: \"pipeline\", label: \"🔄 Pipeline\", icon: \"🔄\" },\n { id: \"projects\", label: \"📁 Projects\", icon: \"📁\" },\n { id: \"payments\", label: \"💰 Payments\", icon: \"💰\" },\n] as const;\n\ntype Tab = typeof TABS[number][\"id\"];\n\nexport function App() {\n const [tab, setTab] = useState(\"dashboard\");\n\n return (\n

\n {/* Header */}\n

\n 🔥\n

TRIDEV CRM

Complete Business Management System

\n view source\n

\n\n {/* Tabs */}\n \n\n {/* Content */}\n

\n {tab === \"dashboard\" && }\n {tab === \"leads\" && }\n {tab === \"pipeline\" && }\n {tab === \"projects\" && }\n {tab === \"payments\" && }\n

\n );\n}\n",[],[94,120,173],"07528226-3ce7-11f1-b431-42b51c65c3df","database","075282e4-3ce7-11f1-b431-42b51c65c3df",1,["D",1776709838302],[187,188],[181],{"_34":197,"_13":198,"_37":199,"_39":182,"_41":42,"_43":200,"_45":46,"_47":201,"_17":49,"_50":51,"_52":202,"_54":55,"_56":-5,"_75":203,"_18":204},{"_34":189,"_13":190,"_37":191,"_39":182,"_41":42,"_43":192,"_45":46,"_47":193,"_17":49,"_50":51,"_52":194,"_54":55,"_56":-5,"_75":195,"_18":196},"22a4598c-3ce7-11f1-a156-42b51c65c3df","queries.ts","22a45a90-3ce7-11f1-a156-42b51c65c3df",6,["D",1776709884138],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// ===== LEADS =====\nexport async function getLeads() {\n const result = await sqlite.execute(\"SELECT * FROM leads ORDER BY id DESC\");\n return result.rows;\n}\n\nexport async function addLead(lead: {\n name: string;\n contact: string;\n email: string;\n source: string;\n service: string;\n budget: number;\n status: string;\n next_followup: string;\n assigned_to: string;\n notes: string;\n}) {\n return sqlite.execute({\n sql: `INSERT INTO leads (name, contact, email, source, service, budget, status, next_followup, assigned_to, notes)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [lead.name, lead.contact, lead.email, lead.source, lead.service, lead.budget, lead.status, lead.next_followup, lead.assigned_to, lead.notes],\n });\n}\n\nexport async function updateLead(id: number, lead: Record) {\n const fields = Object.keys(lead).map((k) => `${k} = ?`).join(\", \");\n const values = Object.values(lead);\n return sqlite.execute({ sql: `UPDATE leads SET ${fields} WHERE id = ?`, args: [...values, id] });\n}\n\nexport async function deleteLead(id: number) {\n return sqlite.execute({ sql: \"DELETE FROM leads WHERE id = ?\", args: [id] });\n}\n\n// ===== PIPELINE =====\nexport async function getPipeline() {\n const result = await sqlite.execute(\"SELECT * FROM pipeline ORDER BY id DESC\");\n return result.rows;\n}\n\nexport async function addPipelineItem(item: {\n lead_id: number | null;\n client_name: string;\n service: string;\n stage: string;\n probability: string;\n expected_value: number;\n expected_close: string;\n next_action: string;\n assigned_to: string;\n}) {\n return sqlite.execute({\n sql: `INSERT INTO pipeline (lead_id, client_name, service, stage, probability, expected_value, expected_close, next_action, assigned_to)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [item.lead_id, item.client_name, item.service, item.stage, item.probability, item.expected_value, item.expected_close, item.next_action, item.assigned_to],\n });\n}\n\nexport async function updatePipelineItem(id: number, item: Record) {\n const fields = Object.keys(item).map((k) => `${k} = ?`).join(\", \");\n const values = Object.values(item);\n return sqlite.execute({ sql: `UPDATE pipeline SET ${fields} WHERE id = ?`, args: [...values, id] });\n}\n\nexport async function deletePipelineItem(id: number) {\n return sqlite.execute({ sql: \"DELETE FROM pipeline WHERE id = ?\", args: [id] });\n}\n\n// ===== PROJECTS =====\nexport async function getProjects() {\n const result = await sqlite.execute(\"SELECT * FROM projects ORDER BY id DESC\");\n return result.rows;\n}\n\nexport async function addProject(p: {\n client_name: string;\n service: string;\n deadline: string;\n total_value: number;\n status: string;\n progress: number;\n team_assigned: string;\n client_feedback: string;\n}) {\n return sqlite.execute({\n sql: `INSERT INTO projects (client_name, service, deadline, total_value, status, progress, team_assigned, client_feedback)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [p.client_name, p.service, p.deadline, p.total_value, p.status, p.progress, p.team_assigned, p.client_feedback],\n });\n}\n\nexport async function updateProject(id: number, p: Record) {\n const fields = Object.keys(p).map((k) => `${k} = ?`).join(\", \");\n const values = Object.values(p);\n return sqlite.execute({ sql: `UPDATE projects SET ${fields} WHERE id = ?`, args: [...values, id] });\n}\n\nexport async function deleteProject(id: number) {\n return sqlite.execute({ sql: \"DELETE FROM projects WHERE id = ?\", args: [id] });\n}\n\n// ===== PAYMENTS =====\nexport async function getPayments() {\n const result = await sqlite.execute(\"SELECT * FROM payments ORDER BY id DESC\");\n return result.rows;\n}\n\nexport async function addPayment(p: {\n project_id: number | null;\n client_name: string;\n total_amount: number;\n token_amount: number;\n token_date: string;\n received_amount: number;\n next_payment_due: string;\n payment_history: string;\n}) {\n return sqlite.execute({\n sql: `INSERT INTO payments (project_id, client_name, total_amount, token_amount, token_date, received_amount, next_payment_due, payment_history)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [p.project_id, p.client_name, p.total_amount, p.token_amount, p.token_date, p.received_amount, p.next_payment_due, p.payment_history],\n });\n}\n\nexport async function updatePayment(id: number, p: Record) {\n const fields = Object.keys(p).map((k) => `${k} = ?`).join(\", \");\n const values = Object.values(p);\n return sqlite.execute({ sql: `UPDATE payments SET ${fields} WHERE id = ?`, args: [...values, id] });\n}\n\nexport async function deletePayment(id: number) {\n return sqlite.execute({ sql: \"DELETE FROM payments WHERE id = ?\", args: [id] });\n}\n\n// ===== DASHBOARD STATS =====\nexport async function getDashboardStats() {\n const [leads, meetings, tokens, active, revenue, received, followups, overdue, pendingPayments] = await Promise.all([\n sqlite.execute(\"SELECT COUNT(*) as cnt FROM leads\"),\n sqlite.execute(\"SELECT COUNT(*) as cnt FROM pipeline WHERE stage = 'Meeting'\"),\n sqlite.execute(\"SELECT COUNT(*) as cnt FROM pipeline WHERE stage = 'Token Done'\"),\n sqlite.execute(\"SELECT COUNT(*) as cnt FROM projects\"),\n sqlite.execute(\"SELECT COALESCE(SUM(total_value),0) as total FROM projects\"),\n sqlite.execute(\"SELECT COALESCE(SUM(received_amount),0) as total FROM payments\"),\n sqlite.execute(\"SELECT COUNT(*) as cnt FROM leads WHERE next_followup < date('now') AND status NOT IN ('Converted','Not Interested')\"),\n sqlite.execute(\"SELECT COUNT(*) as cnt FROM projects WHERE deadline < date('now') AND status != 'Completed'\"),\n sqlite.execute(\"SELECT COUNT(*) as cnt FROM payments WHERE (total_amount - received_amount) > 0\"),\n ]);\n\n const totalLeads = (leads.rows[0] as any).cnt;\n const tokenCount = (tokens.rows[0] as any).cnt;\n\n return {\n totalLeads,\n totalMeetings: (meetings.rows[0] as any).cnt,\n tokenReceived: tokenCount,\n activeClients: (active.rows[0] as any).cnt,\n expectedRevenue: (revenue.rows[0] as any).total,\n receivedRevenue: (received.rows[0] as any).total,\n pendingRevenue: (revenue.rows[0] as any).total - (received.rows[0] as any).total,\n conversionRate: totalLeads > 0 ? tokenCount / totalLeads : 0,\n followupsDue: (followups.rows[0] as any).cnt,\n overdueProjects: (overdue.rows[0] as any).cnt,\n pendingPayments: (pendingPayments.rows[0] as any).cnt,\n };\n}\n",[],[181,190],"1717d0e4-3ce7-11f1-a156-42b51c65c3df","migrations.ts","1717d1a2-3ce7-11f1-a156-42b51c65c3df",5,["D",1776709864762],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function runMigrations() {\n await sqlite.batch([\n {\n sql: `CREATE TABLE IF NOT EXISTS leads (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n created_at TEXT DEFAULT (datetime('now')),\n name TEXT NOT NULL,\n contact TEXT,\n email TEXT,\n source TEXT DEFAULT 'Other',\n service TEXT DEFAULT 'Other',\n budget REAL DEFAULT 0,\n status TEXT DEFAULT 'New',\n next_followup TEXT,\n assigned_to TEXT DEFAULT 'You',\n notes TEXT DEFAULT ''\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS pipeline (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n lead_id INTEGER,\n client_name TEXT NOT NULL,\n service TEXT,\n stage TEXT DEFAULT 'Discussion',\n probability TEXT DEFAULT 'Medium',\n expected_value REAL DEFAULT 0,\n expected_close TEXT,\n last_activity TEXT DEFAULT (datetime('now')),\n next_action TEXT DEFAULT '',\n assigned_to TEXT DEFAULT 'You',\n FOREIGN KEY (lead_id) REFERENCES leads(id)\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS projects (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n client_name TEXT NOT NULL,\n service TEXT,\n start_date TEXT DEFAULT (date('now')),\n deadline TEXT,\n total_value REAL DEFAULT 0,\n status TEXT DEFAULT 'Planning',\n progress INTEGER DEFAULT 0,\n team_assigned TEXT DEFAULT 'You',\n client_feedback TEXT DEFAULT '',\n delivery_date TEXT\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS payments (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n project_id INTEGER,\n client_name TEXT NOT NULL,\n total_amount REAL DEFAULT 0,\n token_amount REAL DEFAULT 0,\n token_date TEXT,\n received_amount REAL DEFAULT 0,\n next_payment_due TEXT,\n payment_history TEXT DEFAULT '',\n FOREIGN KEY (project_id) REFERENCES projects(id)\n )`,\n },\n ]);\n}\n\nexport async function seedSampleData() {\n // Check if data already exists\n const check = await sqlite.execute(\"SELECT COUNT(*) as cnt FROM leads\");\n if ((check.rows[0] as any).cnt > 0) return;\n\n await sqlite.batch([\n {\n sql: `INSERT INTO leads (name, contact, email, source, service, budget, status, next_followup, notes) VALUES\n ('Rahul Sharma', '9876543210', 'rahul@email.com', 'Facebook', 'Website', 50000, 'New', date('now','+5 days'), 'Interested in e-commerce site'),\n ('Priya Patel', '8765432109', 'priya@email.com', 'Referral', 'App', 120000, 'Contacted', date('now','+2 days'), 'Wants Android app'),\n ('Amit Kumar', '7654321098', 'amit@email.com', 'Instagram', 'SEO', 30000, 'New', date('now','-1 days'), 'Local business SEO'),\n ('Sneha Gupta', '6543210987', 'sneha@email.com', 'Cold Call', 'Branding', 80000, 'Contacted', date('now','-3 days'), 'Complete branding package'),\n ('Vikram Rao', '5432109876', 'vikram@email.com', 'Website', 'Website', 65000, 'No Response', date('now','-5 days'), 'Corporate website')`,\n },\n {\n sql: `INSERT INTO pipeline (lead_id, client_name, service, stage, probability, expected_value, expected_close, next_action) VALUES\n (1, 'Rahul Sharma', 'Website', 'Discussion', 'Medium', 50000, date('now','+25 days'), 'Send proposal'),\n (2, 'Priya Patel', 'App', 'Meeting', 'High', 120000, date('now','+30 days'), 'Prepare demo'),\n (3, 'Amit Kumar', 'SEO', 'Token Pending', 'High', 30000, date('now','+20 days'), 'Follow for token'),\n (4, 'Sneha Gupta', 'Branding', 'Token Done', 'High', 80000, date('now','+15 days'), 'Start project'),\n (5, 'Vikram Rao', 'Website', 'Discussion', 'Low', 65000, date('now','+35 days'), 'Send portfolio')`,\n },\n {\n sql: `INSERT INTO projects (client_name, service, deadline, total_value, status, progress, client_feedback) VALUES\n ('Sneha Gupta', 'Branding', date('now','+56 days'), 80000, 'In Progress', 25, 'Initial concepts approved'),\n ('Priya Patel', 'App', date('now','+100 days'), 120000, 'Planning', 10, 'Requirements gathered'),\n ('Amit Kumar', 'SEO', date('now','+70 days'), 30000, 'In Progress', 50, 'Keywords finalized')`,\n },\n {\n sql: `INSERT INTO payments (project_id, client_name, total_amount, token_amount, token_date, received_amount, next_payment_due, payment_history) VALUES\n (1, 'Sneha Gupta', 80000, 20000, date('now'), 20000, date('now','+25 days'), 'Token received on start'),\n (2, 'Priya Patel', 120000, 30000, date('now'), 30000, date('now','+40 days'), 'Token received'),\n (3, 'Amit Kumar', 30000, 10000, date('now'), 10000, date('now','+30 days'), 'Token received')`,\n },\n ]);\n}\n",[],[181,198],"05296762-3ce7-11f1-a75d-42b51c65c3df",["D",1776709834679],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","TRIDEV CRM - Leads, Pipeline, Projects & Payments","imageUrl","userId","9f2161b7-6614-4b5a-9255-d076e0b602b8","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","019dac25-3ef8-733f-b8d9-1bd3c74611ed","tursoName","052967623ce711f1a75d42b51c65c3df","tursoHostname","052967623ce711f1a75d42b51c65c3df-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789511441255],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_261":257},"org",{"_11":12,"_255":-5,"_256":257,"_215":216,"_258":259,"_260":55},"branch",{"_17":81,"_13":16,"_34":42,"_247":205,"_248":-5,"_249":-5,"_250":-5,"_251":-5,"_252":-5,"_253":14,"_254":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://avatars.githubusercontent.com/u/277851378?v=4","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_34":205,"_13":14,"_47":345,"_207":-5,"_208":55,"_209":210,"_211":210,"_212":213,"_214":-5,"_215":216,"_217":70,"_218":46,"_219":-5,"_220":-5,"_221":49,"_222":223,"_224":225,"_226":227,"_228":346,"_230":-5,"_231":232,"_233":232,"_234":235,"_236":235,"_237":235,"_238":232,"_239":232,"_240":347,"_242":348,"_244":349,"_246":55},[294,297,307,309,310],"files",[294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310],"counts",{"_285":49,"_286":183,"_287":49,"_32":288,"_289":290},[283],{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":61,"_45":46,"_47":281,"_17":49,"_50":59,"_52":-5,"_54":55,"_56":-5,"_18":282},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1776709839295],[19],{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":284},[19,36],"pulls","branches","forks",{"_291":49,"_293":49},"connections",{"_291":49,"_292":49},"count","unfilledCount","emptyCount",{"_34":180,"_13":181,"_37":182,"_39":-5,"_41":42,"_43":183,"_45":46,"_47":184,"_17":49,"_50":59,"_52":-5,"_54":55,"_56":-5,"_75":343,"_18":344},{"_34":197,"_13":198,"_37":199,"_39":182,"_41":42,"_43":200,"_45":46,"_47":201,"_17":49,"_50":51,"_52":202,"_54":55,"_56":-5,"_75":341,"_18":342},{"_34":189,"_13":190,"_37":191,"_39":182,"_41":42,"_43":192,"_45":46,"_47":193,"_17":49,"_50":51,"_52":194,"_54":55,"_56":-5,"_75":339,"_18":340},{"_34":93,"_13":94,"_37":95,"_39":-5,"_41":42,"_43":96,"_45":46,"_47":97,"_17":49,"_50":59,"_52":-5,"_54":55,"_56":-5,"_75":337,"_18":338},{"_34":119,"_13":120,"_37":121,"_39":95,"_41":42,"_43":122,"_45":46,"_47":123,"_17":49,"_50":59,"_52":-5,"_54":55,"_56":-5,"_75":335,"_18":336},{"_34":172,"_13":173,"_37":174,"_39":121,"_41":42,"_43":175,"_45":46,"_47":176,"_17":49,"_50":51,"_52":177,"_54":55,"_56":-5,"_75":333,"_18":334},{"_34":164,"_13":165,"_37":166,"_39":121,"_41":42,"_43":167,"_45":46,"_47":168,"_17":49,"_50":51,"_52":169,"_54":55,"_56":-5,"_75":331,"_18":332},{"_34":156,"_13":157,"_37":158,"_39":121,"_41":42,"_43":159,"_45":46,"_47":160,"_17":49,"_50":51,"_52":161,"_54":55,"_56":-5,"_75":329,"_18":330},{"_34":148,"_13":149,"_37":150,"_39":121,"_41":42,"_43":151,"_45":46,"_47":152,"_17":49,"_50":51,"_52":153,"_54":55,"_56":-5,"_75":327,"_18":328},{"_34":140,"_13":141,"_37":142,"_39":121,"_41":42,"_43":143,"_45":46,"_47":144,"_17":49,"_50":51,"_52":145,"_54":55,"_56":-5,"_75":325,"_18":326},{"_34":132,"_13":133,"_37":134,"_39":121,"_41":42,"_43":135,"_45":46,"_47":136,"_17":49,"_50":51,"_52":137,"_54":55,"_56":-5,"_75":323,"_18":324},{"_34":111,"_13":112,"_37":113,"_39":95,"_41":42,"_43":114,"_45":46,"_47":115,"_17":49,"_50":24,"_52":116,"_54":55,"_56":-5,"_75":321,"_18":322},{"_34":103,"_13":104,"_37":105,"_39":95,"_41":42,"_43":106,"_45":46,"_47":107,"_17":49,"_50":51,"_52":108,"_54":55,"_56":-5,"_75":319,"_18":320},{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":61,"_45":46,"_47":86,"_17":49,"_50":59,"_52":-5,"_54":55,"_56":-5,"_75":317,"_18":318},{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":90,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_75":315,"_18":316},{"_34":78,"_13":79,"_37":80,"_39":-5,"_41":42,"_43":81,"_45":46,"_47":82,"_17":49,"_50":24,"_52":83,"_54":55,"_56":-5,"_75":313,"_18":314},{"_34":68,"_13":69,"_37":70,"_39":-5,"_41":42,"_43":71,"_45":46,"_47":72,"_17":49,"_50":73,"_52":74,"_54":55,"_56":-5,"_75":311,"_18":312},[],[69],[],[79],[],[19,36],[308],[19],[],[94,104],[],[94,112],[],[94,120,133],[],[94,120,141],[],[94,120,149],[],[94,120,157],[],[94,120,165],[],[94,120,173],[299,300,301,302,303,304],[94,120],[298,305,306],[94],[],[181,190],[],[181,198],[295,296],[181],["D",1776709834679],["D",1789511441255],{"_11":12,"_261":257},{"_11":12,"_255":-5,"_256":257,"_215":216,"_258":259,"_260":55},{"_17":81,"_13":16,"_34":42,"_247":205,"_248":-5,"_249":-5,"_250":-5,"_251":-5,"_252":-5,"_253":14,"_254":12},"ctx",{"_240":-5,"_278":383,"_384":385,"_386":387,"_388":55,"_389":55,"_390":55,"_391":46,"_392":-5,"_393":-7,"_394":-7,"_395":49,"_396":55,"_397":55,"_398":-5,"_399":55,"_400":55,"_401":55,"_402":-5},"ENV",{"_354":355,"_356":357,"_358":16,"_359":360,"_361":362,"_363":364,"_365":366,"_367":368,"_369":370,"_371":372,"_373":374,"_375":376,"_377":378,"_379":380,"_381":382},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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"]