/** @jsxImportSource https://esm.sh/react@18.2.0 */ import { createRoot } from "https://esm.sh/react-dom@18.2.0/client"; import React, { useEffect, useState } from "https://esm.sh/react@18.2.0"; function BusinessDashboard() { const [businesses, setBusinesses] = useState([]); const [newBusiness, setNewBusiness] = useState({ name: "", revenue: "", employees: "", }); useEffect(() => { fetchBusinesses(); }, []); const fetchBusinesses = async () => { try { const response = await fetch("/businesses"); const data = await response.json(); setBusinesses(data); } catch (error) { console.error("Error fetching businesses:", error); } }; const handleSubmit = async (e) => { e.preventDefault(); try { const response = await fetch("/businesses", { method: "POST", headers: { "Content-Type": "application/json" }, body: JSON.stringify(newBusiness), }); if (response.ok) { fetchBusinesses(); setNewBusiness({ name: "", revenue: "", employees: "" }); } } catch (error) { console.error("Error adding business:", error); } }; return (

💼 nicotine pest service

Current Businesses

{businesses.map((business, index) => ( ))}

Name	Revenue	Employees
{business.name}	${business.revenue}	{business.employees}

Add New Business

); } function App() { return ; } function client() { createRoot(document.getElementById("root")).render(); } if (typeof document !== "undefined") { client(); } export default async function server(request: Request): Promise { const { sqlite } = await import("https://esm.town/v/stevekrouse/sqlite"); const KEY = new URL(import.meta.url).pathname.split("/").at(-1); await sqlite.execute(` CREATE TABLE IF NOT EXISTS ${KEY}_businesses ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, revenue REAL NOT NULL, employees INTEGER NOT NULL ) `); if (request.method === "GET" && new URL(request.url).pathname === "/businesses") { const result = await sqlite.execute(`SELECT * FROM ${KEY}_businesses`); return new Response(JSON.stringify(result.rows), { headers: { "Content-Type": "application/json" }, }); } if (request.method === "POST" && new URL(request.url).pathname === "/businesses") { const business = await request.json(); await sqlite.execute( ` INSERT INTO ${KEY}_businesses (name, revenue, employees) VALUES (?, ?, ?) `, [business.name, business.revenue, business.employees], ); return new Response(JSON.stringify({ success: true }), { headers: { "Content-Type": "application/json" }, }); } return new Response( ` Business Tracker

`, { headers: { "Content-Type": "text/html" }, }, ); } const css = ` body { font-family: 'Arial', sans-serif; max-width: 800px; margin: 0 auto; padding: 20px; background-color: #f4f4f4; } .business-app { background: white; border-radius: 8px; padding: 20px; box-shadow: 0 2px 5px rgba(0,0,0,0.1); } .dashboard { display: flex; gap: 20px; } .business-list, .add-business-form { flex: 1; } table { width: 100%; border-collapse: collapse; } table th, table td { border: 1px solid #ddd; padding: 8px; text-align: left; } form { display: flex; flex-direction: column; gap: 10px; } input, button { padding: 10px; margin: 5px 0; } button { background-color: #007bff; color: white; border: none; cursor: pointer; } footer { margin-top: 20px; text-align: center; font-size: 0.8em; } `;

Ankit285001