[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_226":227,"_228":229},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_170":-5,"_20":171,"_22":172,"_173":174,"_175":176,"_26":177,"_24":178,"_179":-5,"_180":-5,"_181":56,"_182":183,"_184":47,"_185":-5,"_186":-5,"_187":188},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","Tribeca_Rep","name","tribeca-lead-relay","branchName","main","version","path","components","project",{"_35":112,"_13":14,"_48":113,"_114":-5,"_115":56,"_116":117,"_118":117,"_119":120,"_121":-5,"_122":123,"_124":77,"_125":47,"_126":-5,"_127":-5,"_128":50,"_129":130,"_131":132,"_133":134,"_135":136,"_137":-5,"_138":139,"_140":139,"_141":142,"_143":142,"_144":142,"_145":139,"_146":139,"_147":148,"_149":150,"_151":152,"_153":56},"tree",[71,72,73,74],"file",{"_35":67,"_13":19,"_38":41,"_40":-5,"_42":43,"_44":64,"_46":47,"_48":68,"_17":50,"_51":69,"_53":-5,"_55":56,"_57":-5,"_18":70},"contents",[33,34],"upstream","pull","ahead","behind","envVars",{"_35":59,"_13":60,"_38":61,"_40":41,"_42":43,"_44":62,"_46":47,"_48":63,"_17":64,"_51":52,"_53":65,"_55":56,"_57":-5,"_18":66},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_17":50,"_51":52,"_53":54,"_55":56,"_57":-5,"_18":58},"id","60cf02c9-6e37-4193-a53d-c40b623fea9d","LeadsPage.tsx","fileId","28d08204-a7bd-11f1-ba65-1607ee4eb77e","parentId","01a06851-302f-749c-af36-35a6166f97ac","branchId","a3185ec6-ba1c-4b36-b86e-d84880f41daf","branchVersion",4,"latest",true,"createdAt",["D",1788456630046],0,"fileType","script","content","/** @jsxImportSource npm:hono/jsx */\nimport Layout from \"./Layout.tsx\";\nimport type { Lead } from \"../db.ts\";\n\nexport default function LeadsPage({ leads }: { leads: Lead[] }) {\n return (\n \n

Leads

\n Most recent {leads.length} submission{leads.length === 1 ? \"\" : \"s\"} across all sites.\n

\n {leads.map((lead) => {\n const fields = JSON.parse(lead.fields_json) as Record;\n return (\n

\n \n {lead.site} · {lead.form_name}\n \n {lead.created_at}\n

{k}: {v}

\n );\n })}\n {leads.length === 0 &&

No leads yet.

}\n

\n \n );\n}\n","deleted",false,"label",[19,37],"d6919c16-f63f-40b9-994b-a4936bfdb82a","Layout.tsx","01a06851-302f-749c-af36-2d631c7d892c",5,["D",1788456640220],1,"/** @jsxImportSource npm:hono/jsx */\n\nexport default function Layout({ title, children }: { title: string; children?: unknown }) {\n return (\n \n \n \n \n {title}\n \n \n \n \n

{children}

\n \n \n );\n}\n",[19,60],"a1138fe6-5441-4a00-9ea7-7ddf58060e0b",["D",1788456546221],"directory",[19],{"_35":67,"_13":19,"_38":41,"_40":-5,"_42":43,"_44":64,"_46":47,"_48":101,"_17":50,"_51":69,"_53":-5,"_55":56,"_57":-5,"_83":102,"_18":103},{"_35":94,"_13":95,"_38":96,"_40":-5,"_42":43,"_44":64,"_46":47,"_48":97,"_17":50,"_51":24,"_53":98,"_55":56,"_57":-5,"_83":99,"_18":100},{"_35":86,"_13":87,"_38":88,"_40":-5,"_42":43,"_44":89,"_46":47,"_48":90,"_17":64,"_51":52,"_53":91,"_55":56,"_57":-5,"_83":92,"_18":93},{"_35":75,"_13":76,"_38":77,"_40":-5,"_42":43,"_44":78,"_46":47,"_48":79,"_17":80,"_51":81,"_53":82,"_55":56,"_57":-5,"_83":84,"_18":85},"b49d403e-0aa5-4883-b831-e5d6a87296eb","main.tsx","01a06851-302f-749c-af36-42279acb0805",13,["D",1789154459169],7,"http","/** @jsxImportSource npm:hono/jsx */\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\nimport { email } from \"https://esm.town/v/std/email\";\nimport { Hono } from \"npm:hono\";\nimport LeadsPage from \"./components/LeadsPage.tsx\";\nimport { addLead, listLeads } from \"./db.ts\";\n\nconst app = new Hono();\n\n// Only these sites may post here. Keeps this from being usable as an open\n// mail relay by anyone who finds the URL, and pins the /thank-you/ redirect\n// target to a known-good domain.\nconst ALLOWED_SITES = new Set([\n \"jerseywaterdeliverypros.com\",\n \"manhattanwaterdeliverypros.com\",\n \"miamiwaterdeliverypros.com\",\n]);\n\n// std/email on a free-tier Val Town account can only deliver to the\n// account owner's own address — sending to info@tribecabeverage.com\n// directly fails silently unless this account is on Pro. Omitting `to`\n// makes std/email default to the owner's address, which free tier allows.\n\n// Forward each lead into Salesforce as a Lead, via the WordPress snippet\n// #131 (\"Tribeca - Water Delivery Pros lead receiver\") on tribecabeverage.com.\n// That snippet borrows the CF7-Salesforce plugin's own connection — the\n// license-blocked tribeca-salesforce-agent integration user was never\n// involved, and this never touches CF7's Turnstile-gated form either, since\n// it's a dedicated signed REST route with no CAPTCHA on it at all.\n//\n// WRITTEN WITHOUT A JWT LIBRARY on purpose, same reasoning as the WordPress\n// side: this is four lines of HMAC, not worth a dependency. Deno's Web\n// Crypto (crypto.subtle) does the signing natively, no npm import needed.\n//\n// Best-effort, same rule as the notification email just above: a lead that's\n// already durably stored via addLead() must not be lost or delayed by a\n// problem on this side. Every failure here is caught and logged, never\n// thrown, so it can't affect the visitor's redirect or the email that also\n// fires alongside it.\nfunction b64url(bytes: Uint8Array): string {\n let str = \"\";\n for (const b of bytes) str += String.fromCharCode(b);\n return btoa(str).replace(/\\+/g, \"-\").replace(/\\//g, \"_\").replace(/=+$/, \"\");\n}\n\nasync function sha256Hex(text: string): Promise {\n const digest = await crypto.subtle.digest(\"SHA-256\", new TextEncoder().encode(text));\n return Array.from(new Uint8Array(digest)).map((b) => b.toString(16).padStart(2, \"0\")).join(\"\");\n}\n\nasync function signWdpJws(body: string, secret: string): Promise {\n const header = b64url(new TextEncoder().encode(JSON.stringify({ alg: \"HS256\", typ: \"JWT\" })));\n const payload = b64url(new TextEncoder().encode(JSON.stringify({ sha256: await sha256Hex(body) })));\n const signingInput = `${header}.${payload}`;\n\n const key = await crypto.subtle.importKey(\n \"raw\",\n new TextEncoder().encode(secret),\n { name: \"HMAC\", hash: \"SHA-256\" },\n false,\n [\"sign\"],\n );\n const sig = new Uint8Array(\n await crypto.subtle.sign(\"HMAC\", key, new TextEncoder().encode(signingInput)),\n );\n\n return `${signingInput}.${b64url(sig)}`;\n}\n\n// `fields` is whatever the calling form actually submitted — shape varies\n// by site/form (quote form vs. lead form vs. chat widget). name/email/phone\n// are lifted out for Salesforce's own columns; everything else left over\n// becomes Description, the same \"dump every remaining k: v\" approach the\n// notification email above already uses, so nothing submitted is silently\n// dropped even if a field name here was never anticipated.\nasync function forwardToSalesforce(site: string, form: string, fields: Record) {\n const secret = Deno.env.get(\"WDP_WEBHOOK_SECRET\");\n if (!secret) {\n console.error(\"Salesforce forward skipped: WDP_WEBHOOK_SECRET not set on this val.\");\n return;\n }\n\n const details = Object.entries(fields)\n .filter(([k]) => k !== \"name\" && k !== \"email\" && k !== \"phone\")\n .map(([k, v]) => `${k}: ${v}`)\n .join(\"\\n\");\n\n const body = JSON.stringify({\n name: fields.name ?? \"\",\n email: fields.email ?? \"\",\n phone: fields.phone ?? \"\",\n site,\n form,\n details,\n });\n\n try {\n const token = await signWdpJws(body, secret);\n const res = await fetch(\"https://tribecabeverage.com/wp-json/tribeca/v1/water-delivery-lead\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\", \"X-Webhook-Signature\": token },\n body,\n });\n if (!res.ok) {\n console.error(\"Salesforce forward rejected:\", res.status, await res.text().catch(() => \"\"));\n }\n } catch (err) {\n console.error(\"Salesforce forward errored:\", err);\n }\n}\n\napp.get(\"/\", (c) => c.redirect(\"/leads\"));\n\napp.post(\"/submit\", async (c) => {\n const form = await c.req.formData();\n\n const site = String(form.get(\"site\") ?? \"\").trim().toLowerCase();\n const formName = String(form.get(\"form-name\") ?? \"unknown\").trim();\n\n if (!ALLOWED_SITES.has(site)) {\n return c.text(\"Unrecognized site.\", 400);\n }\n\n // Honeypot: real visitors never fill this in. Bots that blindly fill every\n // field will. Redirect to the real thank-you page either way so a bot\n // gets no signal that it was caught, but skip storage and the email.\n if (String(form.get(\"bot-field\") ?? \"\").trim()) {\n return new Response(null, {\n status: 302,\n headers: { Location: `https://${site}/thank-you/` },\n });\n }\n\n const fields: Record = {};\n for (const [key, value] of form.entries()) {\n if (key === \"site\" || key === \"form-name\" || key === \"bot-field\") continue;\n fields[key] = String(value);\n }\n\n // Require at least one way to reach the person who submitted this.\n if (!fields.email && !fields.phone) {\n return c.text(\"An email or phone number is required.\", 400);\n }\n\n await addLead(site, formName, fields);\n await forwardToSalesforce(site, formName, fields);\n\n const lines = Object.entries(fields)\n .map(([k, v]) => `${k}: ${v}`)\n .join(\"\\n\");\n\n try {\n await email({\n subject: `New ${formName} lead — ${site}`,\n text: `New submission from ${site} (${formName} form)\\n\\n${lines}`,\n });\n } catch (err) {\n // Don't fail the user's submission just because the notification email\n // had a problem — it's already durably stored above.\n console.error(\"notification email failed:\", err);\n }\n\n return new Response(null, {\n status: 302,\n headers: { Location: `https://${site}/thank-you/` },\n });\n});\n\n// The chat widget's own lead capture, on the sites with no online ordering\n// at all behind them. Same storage and same email notification as /submit\n// above — same \"netlify forms replacement\" this val already is — just JSON\n// in, JSON out, and keyed rather than public+honeypot, since this is called\n// server-to-server from tribeca-chat rather than submitted by a browser.\napp.post(\"/api/chat-lead\", async (c) => {\n const expected = Deno.env.get(\"CHAT_LEAD_KEY\");\n if (!expected) return c.json({ error: \"CHAT_LEAD_KEY not set on this val\" }, 500);\n const supplied = c.req.header(\"x-api-key\");\n if (supplied !== expected) {\n console.warn(supplied === null ? \"chat-lead REJECTED: no x-api-key header\" : \"chat-lead REJECTED: wrong key\");\n return c.json({ error: \"Unauthorized\" }, 401);\n }\n\n const body = await c.req.json().catch(() => ({}));\n const site = String(body.site ?? \"\").trim().toLowerCase();\n const name = String(body.name ?? \"\").trim();\n const phone = String(body.phone ?? \"\").trim();\n\n if (!ALLOWED_SITES.has(site)) return c.json({ ok: false, reason: \"bad_site\" }, 400);\n if (!name || !phone) return c.json({ ok: false, reason: \"missing_fields\" }, 400);\n\n await addLead(site, \"chat\", { name, phone });\n await forwardToSalesforce(site, \"chat\", { name, phone });\n\n try {\n await email({\n subject: `New chat lead — ${site}`,\n text: `New lead from the chat widget on ${site}\\n\\nName: ${name}\\nPhone: ${phone}`,\n });\n } catch (err) {\n // Same rule as /submit: a notification hiccup must not look like the\n // lead itself failed — it is already durably stored above.\n console.error(\"chat-lead notification email failed:\", err);\n }\n\n return c.json({ ok: true });\n});\n\napp.get(\"/leads\", async (c) => {\n const leads = await listLeads();\n return c.html();\n});\n\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","children",[],[76],"3fa66a25-0714-4a5e-b0ed-ce482d46a5d6","db.ts","01a06851-302f-749c-af36-3c2a9b50d72f",2,["D",1788456602836],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport interface Lead {\n id: number;\n site: string;\n form_name: string;\n fields_json: string;\n created_at: string;\n}\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS leads (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n site TEXT NOT NULL,\n form_name TEXT NOT NULL,\n fields_json TEXT NOT NULL,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n)`);\n\nexport async function addLead(site: string, formName: string, fields: Record) {\n await sqlite.execute({\n sql: \"INSERT INTO leads (site, form_name, fields_json) VALUES (?, ?, ?)\",\n args: [site, formName, JSON.stringify(fields)],\n });\n}\n\nexport async function listLeads(): Promise {\n const result = await sqlite.execute(\n \"SELECT id, site, form_name, fields_json, created_at FROM leads ORDER BY id DESC LIMIT 200\",\n );\n return result.rows as unknown as Lead[];\n}\n",[],[87],"8cb63f41-8a7e-420a-bdd4-597ac50cb0cb","README.md","01a06851-302f-749c-af36-3b812047b4b4",["D",1788456546221],"# What's the easiest way to put a form online and save submissions?\n\nRemix this val. It serves a contact form (name, email, message) at `/`, saves every submission to the val's own SQLite database, and lists everything received at `/submissions`. No external services, no API keys, no env vars.\n\n## Setup\n\n1. Remix this val.\n2. Open the HTTP endpoint of `main.tsx` — that is your live form. Share the URL.\n3. Visit `/submissions` on the same URL to see what people sent.\n\nEach remix gets its own private SQLite database, so your submissions stay with your copy.\n\n## Files\n\n- `main.tsx` — Hono routes: GET `/` (form), POST `/submit` (save), GET `/submissions` (list)\n- `db.ts` — creates the `submissions` table and holds the two queries\n- `components/Layout.tsx` — shared page shell with Tailwind (via Twind)\n- `components/FormPage.tsx` — the form\n- `components/SubmissionsPage.tsx` — the list\n\n## Notes\n\n- `/submissions` is public by default. If your form collects anything sensitive, protect that route before sharing the form URL.\n- No client-side JavaScript: the form is a plain HTML POST.\n",[],[95],["D",1788456546221],[104,105],[19],{"_35":59,"_13":60,"_38":61,"_40":41,"_42":43,"_44":62,"_46":47,"_48":109,"_17":64,"_51":52,"_53":65,"_55":56,"_57":-5,"_83":110,"_18":111},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":106,"_17":50,"_51":52,"_53":54,"_55":56,"_57":-5,"_83":107,"_18":108},["D",1788456630046],[],[19,37],["D",1788456640220],[],[19,60],"9f69e07f-cfcb-4caa-9929-255d912e2d33",["D",1788456546221],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Netlify Forms replacement: emails + stores quote-form leads","imageUrl","userId","c5acd3b3-60a7-4deb-bc6d-528f83012ea9","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","019f8fe2-cdfc-775d-a845-a69af13d39cb","tursoName","9f69e07fcfcb4caa9929255d912e2d33","tursoHostname","9f69e07fcfcb4caa9929255d912e2d33-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789501263826],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_169":165},"org",{"_11":12,"_162":163,"_164":165,"_122":123,"_166":167,"_168":56},"branch",{"_17":78,"_13":16,"_35":43,"_154":112,"_155":-5,"_156":-5,"_157":-5,"_158":-5,"_159":-5,"_160":14,"_161":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","M A","avatar","https://lh3.googleusercontent.com/a/ACg8ocI9znhXn2hWp1wjjyWzeuOyoO_JrDgJo8aD0umFraR7bAG3UAmc=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_35":112,"_13":14,"_48":221,"_114":-5,"_115":56,"_116":117,"_118":117,"_119":120,"_121":-5,"_122":123,"_124":77,"_125":47,"_126":-5,"_127":-5,"_128":50,"_129":130,"_131":132,"_133":134,"_135":222,"_137":-5,"_138":139,"_140":139,"_141":142,"_143":142,"_144":142,"_145":139,"_146":139,"_147":223,"_149":224,"_151":225,"_153":56},[203,206,207,208],"files",[203,204,205,206,207,208],"counts",{"_194":50,"_195":64,"_196":50,"_32":197,"_198":199},[190,191],{"_35":67,"_13":19,"_38":41,"_40":-5,"_42":43,"_44":64,"_46":47,"_48":68,"_17":50,"_51":69,"_53":-5,"_55":56,"_57":-5,"_18":189},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],{"_35":59,"_13":60,"_38":61,"_40":41,"_42":43,"_44":62,"_46":47,"_48":63,"_17":64,"_51":52,"_53":65,"_55":56,"_57":-5,"_18":193},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_17":50,"_51":52,"_53":54,"_55":56,"_57":-5,"_18":192},[19,37],[19,60],"pulls","branches","forks",{"_200":89,"_202":50},"connections",{"_200":50,"_201":50},"count","unfilledCount","emptyCount",{"_35":67,"_13":19,"_38":41,"_40":-5,"_42":43,"_44":64,"_46":47,"_48":101,"_17":50,"_51":69,"_53":-5,"_55":56,"_57":-5,"_83":219,"_18":220},{"_35":59,"_13":60,"_38":61,"_40":41,"_42":43,"_44":62,"_46":47,"_48":109,"_17":64,"_51":52,"_53":65,"_55":56,"_57":-5,"_83":217,"_18":218},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":106,"_17":50,"_51":52,"_53":54,"_55":56,"_57":-5,"_83":215,"_18":216},{"_35":94,"_13":95,"_38":96,"_40":-5,"_42":43,"_44":64,"_46":47,"_48":97,"_17":50,"_51":24,"_53":98,"_55":56,"_57":-5,"_83":213,"_18":214},{"_35":86,"_13":87,"_38":88,"_40":-5,"_42":43,"_44":89,"_46":47,"_48":90,"_17":64,"_51":52,"_53":91,"_55":56,"_57":-5,"_83":211,"_18":212},{"_35":75,"_13":76,"_38":77,"_40":-5,"_42":43,"_44":78,"_46":47,"_48":79,"_17":80,"_51":81,"_53":82,"_55":56,"_57":-5,"_83":209,"_18":210},[],[76],[],[87],[],[95],[],[19,37],[],[19,60],[204,205],[19],["D",1788456546221],["D",1789501263826],{"_11":12,"_169":165},{"_11":12,"_162":163,"_164":165,"_122":123,"_166":167,"_168":56},{"_17":78,"_13":16,"_35":43,"_154":112,"_155":-5,"_156":-5,"_157":-5,"_158":-5,"_159":-5,"_160":14,"_161":12},"ctx",{"_147":-5,"_186":259,"_260":261,"_262":263,"_264":56,"_265":56,"_266":56,"_267":47,"_268":-5,"_269":-7,"_270":-7,"_271":50,"_272":56,"_273":56,"_274":-5,"_275":56,"_276":56,"_277":56,"_278":-5},"ENV",{"_230":231,"_232":233,"_234":16,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248,"_249":250,"_251":252,"_253":254,"_255":256,"_257":258},"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"]