Home Upgrade Assessment

/** @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"; export default async function server(request: Request): Promise { // Dynamic import of SQLite const { sqlite } = await import("https://esm.town/v/stevekrouse/sqlite"); // Use the val's URL as a unique key for the database table const KEY = new URL(import.meta.url).pathname.split("/").at(-1); const TABLE_NAME = `${KEY}_assessments`; // CSS definition moved inside the server function const css = ` body { font-family: 'Inter', sans-serif; line-height: 1.6; margin: 0; padding: 20px; background-color: #f4f4f4; } .final-summary { max-width: 800px; margin: 0 auto; background-color: white; padding: 30px; border-radius: 8px; box-shadow: 0 4px 6px rgba(0,0,0,0.1); } h1, h2 { color: #333; font-family: 'Roboto Slab', serif; } `; // Create table if it doesn't exist await sqlite.execute(` CREATE TABLE IF NOT EXISTS ${TABLE_NAME} ( id INTEGER PRIMARY KEY AUTOINCREMENT, timestamp DATETIME DEFAULT CURRENT_TIMESTAMP, selected_categories TEXT, category_scores TEXT, total_score INTEGER ) `); // Handle form submission for saving assessment if (request.method === 'POST') { try { const body = await request.json(); // Save assessment data await sqlite.execute(` INSERT INTO ${TABLE_NAME} (selected_categories, category_scores, total_score) VALUES (?, ?, ?) `, [ JSON.stringify(body.selectedCategories), JSON.stringify(body.categoryScores), Object.values(body.categoryScores).reduce((a, b) => a + b, 0) ]); return new Response(JSON.stringify({ success: true }), { headers: { 'Content-Type': 'application/json' } }); } catch (error) { return new Response(JSON.stringify({ error: error.message }), { status: 500, headers: { 'Content-Type': 'application/json' } }); } } return new Response( ` Home Upgrade Assessment

`, { headers: { "content-type": "text/html" }, }, ); } function App() { const [selectedCategories, setSelectedCategories] = useState([]); const [categoryScores, setCategoryScores] = useState({}); const [currentPage, setCurrentPage] = useState('categories'); const saveAssessmentToDatabase = async () => { try { const response = await fetch(import.meta.url, { method: 'POST', headers: { 'Content-Type': 'application/json', }, body: JSON.stringify({ selectedCategories, categoryScores, }), }); const result = await response.json(); if (!result.success) { console.error('Failed to save assessment'); } } catch (error) { console.error('Error saving assessment:', error); } }; const renderFinalSummaryPage = () => { useEffect(() => { saveAssessmentToDatabase(); }, []); return (

Final Assessment Summary

Here are your scores and recommendations for each category you chose:

{/* Placeholder for existing summary content */}

); }; // Placeholder for the rest of the App component logic return (

{currentPage === 'categories' &&

Categories Page

} {currentPage === 'summary' && renderFinalSummaryPage()}

); } function client() { createRoot(document.getElementById("root")).render(); } if (typeof document !== "undefined") { client(); }

aanand700