\n \n \n \n\n",[],[151,216],"7a117ab0-3ce7-11f1-aa94-42b51c65c3df","ProjectsTable.tsx","7a117b5a-3ce7-11f1-aa94-42b51c65c3df","097f09b6-3ce7-11f1-a75d-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",[],[151,232,224],"components","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",[],[151,232,234],"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",[],[151,232,242],"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",[],[151,232,250],"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",[],[151,232,258],"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",[],[151,232,266],"097f08e4-3ce7-11f1-a75d-42b51c65c3df",4,["D",1776709841951],[176,177,178,179,180,181],[151,232],["D",1776709839135],[175,182,183],[151],"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",[],[157,282],"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",[],[157,290],["D",1776709838302],[172,173],[157],["D",1776709834679],["D",1789511441255],{"_11":12,"_91":87},{"_11":12,"_85":-5,"_86":87,"_45":46,"_88":89,"_90":38},{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_80":-5,"_81":-5,"_82":-5,"_83":14,"_84":12},"ctx",{"_73":-5,"_113":338,"_339":340,"_341":342,"_343":38,"_344":38,"_345":38,"_346":50,"_347":-5,"_348":-7,"_349":-7,"_350":54,"_351":38,"_352":38,"_353":-5,"_354":38,"_355":38,"_356":38,"_357":-5},"ENV",{"_309":310,"_311":312,"_313":26,"_314":315,"_316":317,"_318":319,"_320":321,"_322":323,"_324":325,"_326":327,"_328":329,"_330":331,"_332":333,"_334":335,"_336":337},"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"]

Branches1

Branches
1