Bridge & Vault Simulator

\n \n

Load Saved Scenario

\n \n \n

\n\n

\n \n

\n\n

\n \n \n \n \n \n \n \n \n \n

Age	Annual ISA In	Annual Pension In	Bridge Balance	Vault Balance	Net Worth
Enter your numbers and click Run Simulation

\n \n \n `;\n return new Response(html, { headers: { \"Content-Type\": \"text/html\" } });\n }\n\n // ROUTE 2: GET /scenarios -> Populates the dropdown menu\n if (req.method === \"GET\" && url.pathname === \"/scenarios\") {\n try {\n const rs = await sqlite.execute(\n \"SELECT id, scenario_name FROM fire_scenarios ORDER BY created_at DESC\",\n );\n let optionsHtml =\n ``;\n\n // Val Town std/sqlite returns rows as arrays: [id, scenario_name]\n for (const row of rs.rows) {\n optionsHtml += ``;\n }\n return new Response(optionsHtml, {\n headers: { \"Content-Type\": \"text/html\" },\n });\n } catch (e) {\n return new Response(``, {\n headers: { \"Content-Type\": \"text/html\" },\n });\n }\n }\n\n // ROUTE 3: GET /load -> Fetches a specific scenario and rebuilds the input HTML\n if (req.method === \"GET\" && url.pathname === \"/load\") {\n const id = url.searchParams.get(\"scenarioId\");\n if (!id) return new Response(\"\", { status: 200 });\n\n try {\n const rs = await sqlite.execute({\n sql:\n \"SELECT current_age, current_isa, current_pension, monthly_isa, extra_sacrifice FROM fire_scenarios WHERE id = ?\",\n args: [id],\n });\n\n if (rs.rows.length === 0) return new Response(\"\", { status: 404 });\n\n // Map the array returned by SQLite back to variables\n const [\n currentAge,\n currentIsa,\n currentPension,\n monthlyIsa,\n extraSacrifice,\n ] = rs.rows[0];\n\n // Rebuild the #form-inputs div with the values from the database pre-filled\n const updatedFormHtml = `\n

\n Current Age\n \n Current ISA Balance (£)\n \n Current Pension Balance (£)\n \n

\n Monthly into S&S ISA (£)\n \n Monthly Extra Sacrifice (£ Take-Home)\n \n Base Pension (£ You + Employer)\n \n

\n `;\n\n // Also trigger a recalculation immediately via HTMX triggering\n return new Response(updatedFormHtml, {\n headers: {\n \"Content-Type\": \"text/html\",\n \"HX-Trigger\": \"loadFormComplete\", // Optional: You could use this to auto-click the run button later\n },\n });\n } catch (e) {\n return new Response(\"\", { status: 500 });\n }\n }\n\n // ROUTE 4: POST /calculate -> Run the math and return HTML rows\n if (req.method === \"POST\" && url.pathname === \"/calculate\") {\n const formData = await req.formData();\n\n let age = parseInt(formData.get(\"currentAge\")) || 35;\n let isaBal = parseFloat(formData.get(\"currentIsa\")) || 0;\n let pensionBal = parseFloat(formData.get(\"currentPension\")) || 0;\n\n const monthlyIsa = parseFloat(formData.get(\"monthlyIsa\")) || 0;\n const extraSacrifice = parseFloat(formData.get(\"extraSacrifice\")) || 0;\n const monthlyBasePension = parseFloat(formData.get(\"monthlyBasePension\")) ||\n 0;\n\n const growthRate = 0.07;\n const grossUp = 1.724;\n\n const annualIsaIn = monthlyIsa * 12;\n const annualPensionIn = (monthlyBasePension + (extraSacrifice * grossUp)) *\n 12;\n\n let htmlResponse = \"\";\n const formatMoney = (num) =>\n new Intl.NumberFormat(\"en-GB\", {\n style: \"currency\",\n currency: \"GBP\",\n maximumFractionDigits: 0,\n }).format(num);\n\n for (let i = 0; i <= 30; i++) {\n let currentYearAge = age + i;\n isaBal = (isaBal + annualIsaIn) * (1 + growthRate);\n pensionBal = (pensionBal + annualPensionIn) * (1 + growthRate);\n let netWorth = isaBal + pensionBal;\n\n htmlResponse += `\n \n ${currentYearAge}\n ${formatMoney(annualIsaIn)}\n ${formatMoney(annualPensionIn)}\n ${formatMoney(isaBal)}\n ${formatMoney(pensionBal)}\n ${formatMoney(netWorth)}\n \n `;\n }\n return new Response(htmlResponse, {\n headers: { \"Content-Type\": \"text/html\" },\n });\n }\n\n // ROUTE 5: POST /save -> Save data to SQLite\n if (req.method === \"POST\" && url.pathname === \"/save\") {\n try {\n const formData = await req.formData();\n const currentAge = parseInt(formData.get(\"currentAge\")) || 35;\n const currentIsa = parseFloat(formData.get(\"currentIsa\")) || 0;\n const currentPension = parseFloat(formData.get(\"currentPension\")) || 0;\n const monthlyIsa = parseFloat(formData.get(\"monthlyIsa\")) || 0;\n const extraSacrifice = parseFloat(formData.get(\"extraSacrifice\")) || 0;\n\n const scenarioName = `Scenario: ${new Date().toLocaleString(\"en-GB\")}`;\n const userId = \"xavier_123\";\n\n await sqlite.execute({\n sql:\n `INSERT INTO fire_scenarios (user_id, scenario_name, current_age, current_isa, current_pension, monthly_isa, extra_sacrifice) \n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n args: [\n userId,\n scenarioName,\n currentAge,\n currentIsa,\n currentPension,\n monthlyIsa,\n extraSacrifice,\n ],\n });\n\n const successHtml = `\n

\n ✅ Success! Saved as \"${scenarioName}\".\n

\n `;\n return new Response(successHtml, {\n headers: { \"Content-Type\": \"text/html\" },\n });\n } catch (error) {\n return new Response(\n `

❌ Error: Database save failed.

`,\n { headers: { \"Content-Type\": \"text/html\" } },\n );\n }\n }\n\n return new Response(\"Not Found\", { status: 404 });\n}","deleted","label",[102],"permalink","https://www.val.town/x/kailhus/untitled-3676/code/main.ts","extension","actionData","errors"]