\n \n \n \n\n",[18,89],"469493ba-5296-11f1-b0ce-ee650bb23af1",["D",1779094080713],"\n",[18,95],"46949234-5296-11f1-b0ce-ee650bb23af1",["D",1779094080713],[18,100],"pulls","branches","forks","envVars",{"_96":26,"_235":26},"connections",{"_96":26,"_234":26},"unfilledCount","emptyCount",{"_34":201,"_13":18,"_75":111,"_44":-5,"_36":37,"_204":41,"_212":24,"_38":306,"_40":26,"_78":101,"_202":-5,"_80":30,"_205":-5,"_254":307,"_17":308},{"_34":224,"_13":100,"_75":99,"_44":111,"_36":37,"_204":41,"_212":24,"_38":303,"_40":26,"_78":101,"_202":-5,"_80":30,"_205":-5,"_254":304,"_17":305},{"_34":296,"_13":297,"_75":298,"_44":99,"_36":37,"_204":251,"_212":24,"_38":299,"_40":41,"_78":79,"_202":300,"_80":30,"_205":-5,"_254":301,"_17":302},{"_34":288,"_13":289,"_75":290,"_44":99,"_36":37,"_204":291,"_212":24,"_38":292,"_40":26,"_78":79,"_202":293,"_80":30,"_205":-5,"_254":294,"_17":295},{"_34":281,"_13":282,"_75":283,"_44":99,"_36":37,"_204":97,"_212":24,"_38":284,"_40":26,"_78":79,"_202":285,"_80":30,"_205":-5,"_254":286,"_17":287},{"_34":273,"_13":274,"_75":275,"_44":99,"_36":37,"_204":276,"_212":24,"_38":277,"_40":26,"_78":79,"_202":278,"_80":30,"_205":-5,"_254":279,"_17":280},{"_34":220,"_13":95,"_75":94,"_44":111,"_36":37,"_204":41,"_212":24,"_38":270,"_40":26,"_78":21,"_202":222,"_80":30,"_205":-5,"_254":271,"_17":272},{"_34":216,"_13":89,"_75":88,"_44":111,"_36":37,"_204":104,"_212":24,"_38":267,"_40":41,"_78":21,"_202":218,"_80":30,"_205":-5,"_254":268,"_17":269},{"_34":211,"_13":77,"_75":76,"_44":111,"_36":37,"_204":41,"_212":24,"_38":264,"_40":26,"_78":79,"_202":214,"_80":30,"_205":-5,"_254":265,"_17":266},{"_34":257,"_13":258,"_75":259,"_44":-5,"_36":37,"_204":150,"_212":24,"_38":260,"_40":41,"_78":21,"_202":261,"_80":30,"_205":-5,"_254":262,"_17":263},{"_34":247,"_13":248,"_75":123,"_44":-5,"_36":37,"_204":249,"_212":24,"_38":250,"_40":251,"_78":252,"_202":253,"_80":30,"_205":-5,"_254":255,"_17":256},"7917d482-5296-11f1-9647-ee650bb23af1","index.ts",10,["D",1779094165527],3,"http","import { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// Create table if not exists\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS assistance_requests (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n request TEXT NOT NULL,\n status TEXT DEFAULT 'pending',\n created_at TEXT DEFAULT (datetime('now'))\n)`);\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS chat_messages (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n request_id INTEGER NOT NULL,\n sender TEXT NOT NULL,\n message TEXT NOT NULL,\n created_at TEXT DEFAULT (datetime('now')),\n FOREIGN KEY (request_id) REFERENCES assistance_requests(id)\n)`);\n\nconst app = new Hono();\n\n// Serve index.html at the root /\napp.get(\"/\", () => serveFile(\"/frontend/index.html\"));\n\n// Serve all /frontend files\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\n\n// View source redirect\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// ===== API Routes =====\n\n// GET all requests\napp.get(\"/api/requests\", async (c) => {\n const result = await sqlite.execute(\"SELECT * FROM assistance_requests ORDER BY created_at DESC\");\n return c.json(result.rows);\n});\n\n// POST new request\napp.post(\"/api/requests\", async (c) => {\n const { name, request } = await c.req.json();\n if (!name || !request) {\n return c.json({ error: \"Name and request are required\" }, 400);\n }\n const result = await sqlite.execute({\n sql: \"INSERT INTO assistance_requests (name, request) VALUES (?, ?)\",\n args: [name, request],\n });\n return c.json({ id: Number(result.lastInsertRowid), name, request, status: \"pending\" }, 201);\n});\n\n// UPDATE request status\napp.patch(\"/api/requests/:id\", async (c) => {\n const id = c.req.param(\"id\");\n const { status } = await c.req.json();\n await sqlite.execute({\n sql: \"UPDATE assistance_requests SET status = ? WHERE id = ?\",\n args: [status, id],\n });\n return c.json({ success: true });\n});\n\n// DELETE request\napp.delete(\"/api/requests/:id\", async (c) => {\n const id = c.req.param(\"id\");\n await sqlite.execute({ sql: \"DELETE FROM chat_messages WHERE request_id = ?\", args: [id] });\n await sqlite.execute({ sql: \"DELETE FROM assistance_requests WHERE id = ?\", args: [id] });\n return c.json({ success: true });\n});\n\n// GET chat messages for a request\napp.get(\"/api/requests/:id/messages\", async (c) => {\n const id = c.req.param(\"id\");\n const result = await sqlite.execute({\n sql: \"SELECT * FROM chat_messages WHERE request_id = ? ORDER BY created_at ASC\",\n args: [id],\n });\n return c.json(result.rows);\n});\n\n// POST chat message\napp.post(\"/api/requests/:id/messages\", async (c) => {\n const id = c.req.param(\"id\");\n const { sender, message } = await c.req.json();\n if (!sender || !message) {\n return c.json({ error: \"Sender and message are required\" }, 400);\n }\n const result = await sqlite.execute({\n sql: \"INSERT INTO chat_messages (request_id, sender, message) VALUES (?, ?, ?)\",\n args: [id, sender, message],\n });\n return c.json({ id: Number(result.lastInsertRowid), request_id: id, sender, message }, 201);\n});\n\n// Unwrap and rethrow Hono errors\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","children",[],[248],"84406f40-5296-11f1-9647-ee650bb23af1","README.md","019e3a45-4d09-7019-8fa6-3a71023c8ee6",["D",1779094184249],"# 🆘 Assistance Request App\n\nA full-stack assistance request application built with React + Hono on Val Town.\n\nUsers can submit assistance requests, track their status, and communicate through a real-time support chat.\n\n## Features\n\n- **Submit requests** — input field for name and description\n- **Display area** — view all submitted requests with status badges\n- **Data persistence** — SQLite database stores requests and chat messages\n- **Real-time chat** — support chat panel with 3-second polling\n- **Status management** — pending → in-progress → resolved workflow\n- **Delete requests** — remove requests and associated messages\n\n## Architecture\n\n```mermaid\ngraph LR\n Browser -->|\"GET /\"| Hono[\"index.ts (Hono)\"]\n Hono -->|serves| HTML[\"index.html\"]\n HTML -->|loads| React[\"App.tsx\"]\n React -->|fetch| API[\"/api/requests\"]\n API -->|read/write| DB[\"SQLite DB\"]\n```\n\n## API Endpoints\n\n| Method | Path | Description |\n|--------|------|-------------|\n| GET | /api/requests | List all requests |\n| POST | /api/requests | Create new request |\n| PATCH | /api/requests/:id | Update request status |\n| DELETE | /api/requests/:id | Delete a request |\n| GET | /api/requests/:id/messages | Get chat messages |\n| POST | /api/requests/:id/messages | Send chat message |\n\n## File Structure\n\n```\nindex.ts ← Hono backend + API routes + SQLite\nfrontend/\n index.html ← HTML shell\n index.tsx ← React entrypoint\n components/\n App.tsx ← Root layout\n RequestForm.tsx ← Submit request form\n RequestList.tsx ← Display requests list\n ChatPanel.tsx ← Real-time chat panel\n```\n",[],[258],["D",1779094080713],[],[18,77],["D",1779094145062],[],[18,89],["D",1779094080713],[],[18,95],"5fcfb24c-5296-11f1-8be2-ee650bb23af1","RequestList.tsx","5fcfb2e2-5296-11f1-8be2-ee650bb23af1",5,["D",1779094123114],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\n\ninterface Request {\n id: number;\n name: string;\n request: string;\n status: string;\n created_at: string;\n}\n\ninterface Props {\n refreshKey: number;\n onSelect: (id: number | null) => void;\n selectedId: number | null;\n onRefresh: () => void;\n}\n\nexport function RequestList({ refreshKey, onSelect, selectedId, onRefresh }: Props) {\n const [requests, setRequests] = useState([]);\n const [loading, setLoading] = useState(true);\n\n useEffect(() => {\n fetchRequests();\n }, [refreshKey]);\n\n const fetchRequests = async () => {\n setLoading(true);\n try {\n const res = await fetch(\"/api/requests\");\n const data = await res.json();\n setRequests(data);\n } catch {\n console.error(\"Failed to fetch requests\");\n }\n setLoading(false);\n };\n\n const updateStatus = async (id: number, status: string) => {\n await fetch(`/api/requests/${id}`, {\n method: \"PATCH\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ status }),\n });\n onRefresh();\n };\n\n const deleteRequest = async (id: number) => {\n await fetch(`/api/requests/${id}`, { method: \"DELETE\" });\n if (selectedId === id) onSelect(null);\n onRefresh();\n };\n\n const statusColors: Record = {\n pending: \"bg-yellow-100 text-yellow-800\",\n \"in-progress\": \"bg-blue-100 text-blue-800\",\n resolved: \"bg-green-100 text-green-800\",\n };\n\n if (loading) return

Loading requests...

;\n\n return (\n

📋 Requests ({requests.length})

\n {requests.length === 0 ? (\n

No requests yet. Submit one above!

\n ) : (\n

\n {requests.map((r) => (\n onSelect(r.id)}\n class={`border rounded-xl p-4 cursor-pointer transition-all ${\n selectedId === r.id\n ? \"border-blue-500 bg-blue-50 shadow-md\"\n : \"border-gray-200 bg-white hover:border-gray-300 hover:shadow-sm\"\n }`}\n >\n

\n {r.name}\n \n {r.status}\n \n

{r.request}

\n {new Date(r.created_at + \"Z\").toLocaleString()}\n

\n {r.status === \"pending\" && (\n { e.stopPropagation(); updateStatus(r.id, \"in-progress\"); }}\n class=\"text-blue-600 hover:underline cursor-pointer\"\n >\n Start\n \n )}\n {r.status === \"in-progress\" && (\n { e.stopPropagation(); updateStatus(r.id, \"resolved\"); }}\n class=\"text-green-600 hover:underline cursor-pointer\"\n >\n Resolve\n \n )}\n { e.stopPropagation(); deleteRequest(r.id); }}\n class=\"text-red-500 hover:underline cursor-pointer\"\n >\n Delete\n \n

\n ))}\n

\n )}\n \n );\n}\n",[],[18,100,274],"5914ae30-5296-11f1-9647-ee650bb23af1","RequestForm.tsx","5914aee4-5296-11f1-9647-ee650bb23af1",["D",1779094111818],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\n\nexport function RequestForm({ onSubmit }: { onSubmit: () => void }) {\n const [name, setName] = useState(\"\");\n const [request, setRequest] = useState(\"\");\n const [loading, setLoading] = useState(false);\n const [message, setMessage] = useState(\"\");\n\n const handleSubmit = async (e: Event) => {\n e.preventDefault();\n if (!name.trim() || !request.trim()) return;\n setLoading(true);\n setMessage(\"\");\n try {\n const res = await fetch(\"/api/requests\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ name: name.trim(), request: request.trim() }),\n });\n if (res.ok) {\n setName(\"\");\n setRequest(\"\");\n setMessage(\"✅ Request submitted successfully!\");\n onSubmit();\n } else {\n setMessage(\"❌ Failed to submit request.\");\n }\n } catch {\n setMessage(\"❌ Network error.\");\n }\n setLoading(false);\n };\n\n return (\n

📝 Submit a Request

\n setName(e.target.value)}\n class=\"w-full border border-gray-300 rounded-lg px-3 py-2 mb-3 focus:outline-none focus:ring-2 focus:ring-blue-400\"\n />\n setRequest(e.target.value)}\n rows={3}\n class=\"w-full border border-gray-300 rounded-lg px-3 py-2 mb-3 focus:outline-none focus:ring-2 focus:ring-blue-400 resize-none\"\n />\n \n {loading ? \"Submitting...\" : \"Submit Request\"}\n \n {message &&

{message}

}\n \n );\n}\n",[],[18,100,282],"6841898c-5296-11f1-9647-ee650bb23af1","ChatPanel.tsx","68418a22-5296-11f1-9647-ee650bb23af1",6,["D",1779094137283],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect, useRef } from \"https://esm.sh/react@18.2.0\";\n\ninterface Message {\n id: number;\n sender: string;\n message: string;\n created_at: string;\n}\n\nexport function ChatPanel({ requestId }: { requestId: number | null }) {\n const [messages, setMessages] = useState([]);\n const [sender, setSender] = useState(\"\");\n const [text, setText] = useState(\"\");\n const [loading, setLoading] = useState(false);\n const bottomRef = useRef(null);\n const intervalRef = useRef(null);\n\n useEffect(() => {\n if (requestId) {\n fetchMessages();\n // Poll for new messages every 3 seconds (real-time simulation)\n intervalRef.current = setInterval(fetchMessages, 3000) as unknown as number;\n } else {\n setMessages([]);\n }\n return () => {\n if (intervalRef.current) clearInterval(intervalRef.current);\n };\n }, [requestId]);\n\n useEffect(() => {\n bottomRef.current?.scrollIntoView({ behavior: \"smooth\" });\n }, [messages]);\n\n const fetchMessages = async () => {\n if (!requestId) return;\n try {\n const res = await fetch(`/api/requests/${requestId}/messages`);\n const data = await res.json();\n setMessages(data);\n } catch {\n console.error(\"Failed to fetch messages\");\n }\n };\n\n const sendMessage = async (e: Event) => {\n e.preventDefault();\n if (!sender.trim() || !text.trim() || !requestId) return;\n setLoading(true);\n try {\n await fetch(`/api/requests/${requestId}/messages`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ sender: sender.trim(), message: text.trim() }),\n });\n setText(\"\");\n await fetchMessages();\n } catch {\n console.error(\"Failed to send message\");\n }\n setLoading(false);\n };\n\n if (!requestId) {\n return (\n

💬

Select a request to start chatting

\n );\n }\n\n return (\n

💬 Support Chat — Request #{requestId}

Messages refresh every 3 seconds

\n\n

\n {messages.length === 0 ? (\n

No messages yet. Start the conversation!

\n ) : (\n messages.map((m) => (\n

\n {m.sender}\n {new Date(m.created_at + \"Z\").toLocaleTimeString()}\n

{m.message}

\n ))\n )}\n

\n\n

\n );\n}\n",[],[18,100,289],"5485a98c-5296-11f1-a6b5-ee650bb23af1","App.tsx","019e3a45-4d09-7019-8fa6-1c7e59d9923f",["D",1779094104170],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\nimport { RequestForm } from \"./RequestForm.tsx\";\nimport { RequestList } from \"./RequestList.tsx\";\nimport { ChatPanel } from \"./ChatPanel.tsx\";\n\nexport function App() {\n const [refreshKey, setRefreshKey] = useState(0);\n const [selectedRequestId, setSelectedRequestId] = useState(null);\n\n const triggerRefresh = () => setRefreshKey((k) => k + 1);\n\n return (\n

🆘 Assistance Request App

Submit your assistance request and chat with support in real-time.

\n\n

\n \n \n

\n \n

\n\n

\n View source\n

\n );\n}\n",[],[18,100,297],["D",1779094080713],[238,239,240,241],[18,100],["D",1779094080713],[237,242,243,244],[18],["D",1779094080713],["D",1789468254172],{"_11":12,"_167":83},{"_11":12,"_162":163,"_82":83,"_31":81,"_164":165,"_166":30},{"_40":150,"_13":16,"_34":37,"_151":113,"_152":72,"_153":154,"_155":117,"_156":157,"_158":159,"_160":14,"_161":12},"ctx",{"_53":-5,"_188":347,"_348":349,"_350":351,"_352":30,"_353":30,"_354":30,"_355":24,"_356":-5,"_357":-7,"_358":-7,"_359":26,"_360":30,"_361":30,"_362":-5,"_363":30,"_364":30,"_365":30,"_366":-5},"ENV",{"_318":319,"_320":321,"_322":16,"_323":324,"_325":326,"_327":328,"_329":330,"_331":332,"_333":334,"_335":336,"_337":338,"_339":340,"_341":342,"_343":344,"_345":346},"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"]

History · frontend