Charmaine loves OGTS

/** @jsxImportSource https://esm.sh/react */ import React, { useEffect, useState, useRef } from "https://esm.sh/react"; import { createRoot } from "https://esm.sh/react-dom/client"; function App() { const [coworkers, setCoworkers] = useState([]); const [newCoworker, setNewCoworker] = useState(""); const [peopleBrought, setPeopleBrought] = useState(1); const AVERAGE_SPEND = 22.50; useEffect(() => { fetchCoworkers(); fetchPeopleBrought(); }, []); const fetchCoworkers = async () => { const response = await fetch("?action=list"); const data = await response.json(); setCoworkers(data); }; const fetchPeopleBrought = async () => { const response = await fetch("?action=getPeopleBrought"); const data = await response.json(); setPeopleBrought(data.peopleBrought); }; const addCoworker = async (e) => { e.preventDefault(); if (!newCoworker.trim()) return; await fetch("?action=add", { method: "POST", body: JSON.stringify({ name: newCoworker }), }); setNewCoworker(""); fetchCoworkers(); }; const updatePeopleBrought = async (e) => { const value = parseInt(e.target.value) || 1; setPeopleBrought(value); await fetch("?action=updatePeopleBrought", { method: "POST", body: JSON.stringify({ peopleBrought: value }), }); }; const deleteCoworker = async (id) => { await fetch("?action=delete", { method: "POST", body: JSON.stringify({ id }), }); fetchCoworkers(); }; const calculateRevenue = () => { return ((coworkers.length + peopleBrought) * AVERAGE_SPEND).toFixed(2); }; return (

Olive Garden Revenue Generated by Charmaine

${calculateRevenue()}

Victim List

deleteCoworker(coworker.id)}>

{coworker.name}

View source

); } function SwipeToDelete({ children, onDelete }) { const [startX, setStartX] = useState(null); const [offset, setOffset] = useState(0); const elementRef = useRef(null); const handleTouchStart = (e) => { setStartX(e.touches[0].clientX); }; const handleTouchMove = (e) => { if (startX === null) return; const currentX = e.touches[0].clientX; const diff = startX - currentX; if (diff > 0) { setOffset(Math.min(diff, 100)); } else { setOffset(0); } }; const handleTouchEnd = () => { if (offset > 50) { onDelete(); } setStartX(null); setOffset(0); }; return (

{children}

); } 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 SCHEMA_VERSION = 2; const KEY = new URL(import.meta.url).pathname.split("/").at(-1); await sqlite.execute(` CREATE TABLE IF NOT EXISTS ${KEY}_coworkers_${SCHEMA_VERSION} ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, timestamp DATETIME DEFAULT CURRENT_TIMESTAMP ) `); await sqlite.execute(` CREATE TABLE IF NOT EXISTS ${KEY}_stats_${SCHEMA_VERSION} ( id INTEGER PRIMARY KEY CHECK (id = 1), people_brought INTEGER NOT NULL DEFAULT 1 ) `); // Initialize stats if not exists await sqlite.execute(` INSERT OR IGNORE INTO ${KEY}_stats_${SCHEMA_VERSION} (id, people_brought) VALUES (1, 1) `); const url = new URL(request.url); const action = url.searchParams.get("action"); if (action === "list") { const result = await sqlite.execute(`SELECT * FROM ${KEY}_coworkers_${SCHEMA_VERSION} ORDER BY timestamp DESC`); return new Response(JSON.stringify(result.rows), { headers: { "Content-Type": "application/json" }, }); } else if (action === "add" && request.method === "POST") { const { name } = await request.json(); await sqlite.execute(`INSERT INTO ${KEY}_coworkers_${SCHEMA_VERSION} (name) VALUES (?)`, [name]); return new Response("Added successfully", { status: 200 }); } else if (action === "delete" && request.method === "POST") { const { id } = await request.json(); await sqlite.execute(`DELETE FROM ${KEY}_coworkers_${SCHEMA_VERSION} WHERE id = ?`, [id]); return new Response("Deleted successfully", { status: 200 }); } else if (action === "getPeopleBrought") { const result = await sqlite.execute(`SELECT people_brought FROM ${KEY}_stats_${SCHEMA_VERSION} WHERE id = 1`); return new Response(JSON.stringify({ peopleBrought: result.rows[0].people_brought }), { headers: { "Content-Type": "application/json" }, }); } else if (action === "updatePeopleBrought" && request.method === "POST") { const { peopleBrought } = await request.json(); await sqlite.execute(`UPDATE ${KEY}_stats_${SCHEMA_VERSION} SET people_brought = ? WHERE id = 1`, [peopleBrought]); return new Response("Updated successfully", { status: 200 }); } return new Response( ` Charmaine loves OGTS

`, { headers: { "content-type": "text/html", }, }, ); }

oliveGardenChar