🚀 Selar: Sales Lead Management

\n\n

\n setNewLead({ ...newLead, name: e.target.value })}\n required\n />\n setNewLead({ ...newLead, email: e.target.value })}\n required\n />\n setNewLead({ ...newLead, phone: e.target.value })}\n />\n setNewLead({ ...newLead, company: e.target.value })}\n />\n \n \n\n

\n {leads.map((lead) => (\n

{lead.name}

📧 {lead.email}

📱 {lead.phone}

🏢 {lead.company}

\n updateLeadStatus(lead.id, e.target.value)}\n style={styles.statusSelect}\n >\n \n \n \n \n \n \n

\n ))}\n

\n \n View Source\n \n

\n );\n}\n\nconst styles = {\n container: {\n maxWidth: \"800px\",\n margin: \"0 auto\",\n padding: \"20px\",\n fontFamily: \"system-ui, sans-serif\",\n },\n form: {\n display: \"flex\",\n flexDirection: \"column\",\n gap: \"10px\",\n marginBottom: \"20px\",\n },\n leadList: {\n display: \"grid\",\n gridTemplateColumns: \"repeat(auto-fill, minmax(250px, 1fr))\",\n gap: \"15px\",\n },\n leadCard: {\n border: \"1px solid #ddd\",\n borderRadius: \"8px\",\n padding: \"15px\",\n backgroundColor: \"#f9f9f9\",\n },\n statusSelect: {\n width: \"100%\",\n padding: \"5px\",\n marginTop: \"10px\",\n },\n sourceLink: {\n display: \"block\",\n marginTop: \"20px\",\n textAlign: \"center\",\n color: \"#666\",\n },\n};\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const KEY = new URL(import.meta.url).pathname.split(\"/\").at(-1);\n const SCHEMA_VERSION = 1;\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_leads_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n email TEXT NOT NULL,\n phone TEXT,\n company TEXT,\n status TEXT DEFAULT 'New Lead',\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n if (request.method === \"GET\" && new URL(request.url).pathname === \"/leads\") {\n const result = await sqlite.execute(`\n SELECT * FROM ${KEY}_leads_${SCHEMA_VERSION} \n ORDER BY created_at DESC\n `);\n return new Response(JSON.stringify(result.rows), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n if (request.method === \"POST\" && new URL(request.url).pathname === \"/leads\") {\n const lead = await request.json();\n await sqlite.execute(\n `\n INSERT INTO ${KEY}_leads_${SCHEMA_VERSION} \n (name, email, phone, company, status) \n VALUES (?, ?, ?, ?, ?)\n `,\n [lead.name, lead.email, lead.phone, lead.company, lead.status],\n );\n\n return new Response(\"Lead added\", { status: 201 });\n }\n\n if (request.method === \"PATCH\" && /^\\/leads\\/\\d+$/.test(new URL(request.url).pathname)) {\n const id = new URL(request.url).pathname.split(\"/\").pop();\n const { status } = await request.json();\n\n await sqlite.execute(\n `\n UPDATE ${KEY}_leads_${SCHEMA_VERSION} \n SET status = ? \n WHERE id = ?\n `,\n [status, id],\n );\n\n return new Response(\"Lead updated\", { status: 200 });\n }\n\n return new Response(\n `\n \n \n Selar: Sales Lead Management\n \n \n \n

\n \n \n \n \n `,\n {\n headers: { \"Content-Type\": \"text/html\" },\n },\n );\n}g","createdAt",["D",1739308207116],"version","currentUserHasLiked","likeCount","forkCount",1,"referenceCount","dependencyCount","commentCount","prCount","mergedPr",{"_128":129,"_130":131},"handle","selarcom","profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJzdWFHVkhqTmc1b01pV1ZhR0gzSHY5UVRRQSJ9","forkedVal","interval","slug","selarcom/selarApp","description","@jsxImportSource https://esm.sh/react@18.2.0","versions",[140,143,146],{"_117":90,"_141":-5,"_115":142,"_112":110},"prId",["D",1739308207116],{"_117":121,"_141":-5,"_115":144,"_112":145},["D",1739308184941],"84b2046a-e8bc-11ef-97d3-e6cdfca9ef9f",{"_117":31,"_141":-5,"_115":147,"_112":148},["D",1739308014307],"1effc49a-e8bc-11ef-a615-e6cdfca9ef9f","recentThread","breadcrumbs","comments",[153],{"_112":154,"_155":66,"_115":156,"_157":-5,"_158":26,"_159":26,"_20":160},"fa1f3bdc-e8bc-11ef-96d8-e6cdfca9ef9f","body",["D",1739308381961],"updatedAt","canDelete","canEdit",{"_128":129,"_130":131},"isOwner","routes/_app.v.$handle.$name.forks",{"_164":165,"_189":121,"_190":135,"_191":31,"_94":192},"forksList",[166],{"_100":167,"_168":169},"4e4c4128-e944-11ef-b0fe-e6cdfca9ef9f","initialData",{"_98":99,"_95":170,"_100":167,"_102":-5,"_103":-5,"_104":105,"_106":66,"_107":108,"_109":171,"_111":26,"_112":171,"_113":172,"_115":173,"_117":121,"_118":26,"_119":31,"_122":31,"_123":121,"_124":31,"_120":31,"_125":121,"_126":-5,"_20":174,"_132":177,"_133":-7,"_136":137,"_179":-5,"_134":180,"_138":181},"a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","50d4cd34-e944-11ef-a50a-e6cdfca9ef9f","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport React, { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\n\nfunction App() {\n const [leads, setLeads] = useState([]);\n const [newLead, setNewLead] = useState({\n name: \"\",\n email: \"\",\n phone: \"\",\n company: \"\",\n status: \"New Lead\",\n });\n\n useEffect(() => {\n fetchLeads();\n }, []);\n\n const fetchLeads = async () => {\n const response = await fetch(\"/leads\");\n const data = await response.json();\n setLeads(data);\n };\n\n const handleSubmit = async (e) => {\n e.preventDefault();\n const response = await fetch(\"/leads\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(newLead),\n });\n\n if (response.ok) {\n fetchLeads();\n setNewLead({\n name: \"\",\n email: \"\",\n phone: \"\",\n company: \"\",\n status: \"New Lead\",\n });\n }\n };\n\n const updateLeadStatus = async (id, newStatus) => {\n const response = await fetch(`/leads/${id}`, {\n method: \"PATCH\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ status: newStatus }),\n });\n\n if (response.ok) {\n fetchLeads();\n }\n };\n\n return (\n

🚀 Selar: Sales Lead Management

\n\n

\n {leads.map((lead) => (\n

{lead.name}

📧 {lead.email}

📱 {lead.phone}

🏢 {lead.company}

\n updateLeadStatus(lead.id, e.target.value)}\n style={styles.statusSelect}\n >\n \n \n \n \n \n \n

\n ))}\n

\n \n View Source\n \n

\n \n \n \n \n `,\n {\n headers: { \"Content-Type\": \"text/html\" },\n },\n );\n}",["D",1739366509478],{"_128":175,"_130":176},"stevekrouse","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg",{"_112":110,"_128":129,"_98":99,"_117":90,"_178":-5},"prDisabledHint","latestEvaluation","stevekrouse/selarApp",[182,186],{"_115":183,"_117":121,"_184":185},["D",1739366509478],"n","1",{"_115":187,"_117":31,"_184":188},["D",1739366505229],"2","forksCount","valname","page",{"_112":110,"_98":99,"_128":129,"_11":96,"_117":90,"_100":101,"_113":114,"_104":105,"_111":26,"_134":135},"routes/_app","actionData","errors"]