[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_202":203,"_204":205},"routes/_app.x.$handle.$name",{"_99":98,"_32":44,"_108":89,"_27":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_20":-5,"_120":-5,"_121":-5,"_122":25,"_123":124,"_125":58,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_32":44,"_37":45,"_46":-5,"_47":25,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":25},"version",6,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":20,"_34":36,"_37":38,"_39":14,"_40":41,"_24":25},"previous",{"_30":31,"_32":28,"_33":20,"_34":35},"deleted",false,"deletedHere","path","README.md","latestPath","fileId","01a080e1-be0d-720f-a0a0-9153a0ca3e53","name","fileType","content","# 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","# chitien-inquiry\n\n齊天旅行社 (Chi-Tien Travel) 官網詢問表單的後端。\n\n- `POST /inquiry` 接收網站表單（JSON，以 text/plain 送出避免 CORS preflight），存進 SQLite `inquiries` 表，並用 std/email 寄通知信到帳號信箱（回覆信件即回給客人）。\n- `GET /admin?key=INQUIRY_ADMIN_KEY` 查看所有詢問。\n- `GET /health` 健康檢查。\n\n防護：honeypot 欄位 `website`、每個 IP 15 分鐘內最多 5 筆、欄位長度限制、控制字元過濾。\n","createdAt",["D",1788868842846],"branchVersion","branchId","4bb477fd-f17c-45e1-8c45-9ac232bb7f1e","id","2e9fda9f-c072-4ae0-a75e-c7ccaadd31aa","chitien-inquiry",["D",1788868672868],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","齊天旅行社網站詢問表單後端: 存 SQLite + email 通知","imageUrl","04d840cc-4bfb-411e-9b63-ee625b96a32a","pinnedFileId","01a080e1-be0d-720f-a0a0-9bf8a8e4498f","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019edd59-7b3e-722d-a9c9-2bb34b53ed67","tursoName","2e9fda9fc0724ae0a75ec7ccaadd31aa","tursoHostname","2e9fda9fc0724ae0a75ec7ccaadd31aa-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789651264012],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_107":103},"org",{"_99":98,"_100":101,"_102":103,"_18":54,"_104":105,"_106":25},"branch",{"_13":88,"_32":89,"_42":41,"_90":43,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":44,"_97":98},"isOwned",7,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","piyatat726","handle","displayName","哲齊許","avatar","https://lh3.googleusercontent.com/a/ACg8ocL--LqhYafFVZniKIfsTcCNAYb_-LmvuCWSdg_tAqidOaXRAHs=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_32":44,"_37":197,"_46":-5,"_47":25,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":198,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":199,"_83":200,"_85":201,"_87":25},"tree",[172,174,175,176],"files",[172,173,174,175,176],"counts",{"_162":62,"_163":140,"_164":62,"_165":166,"_167":168},"contents",[130,131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":156,"_32":157,"_30":158,"_136":-5,"_40":41,"_39":140,"_138":58,"_37":159,"_13":62,"_33":160,"_34":-5,"_24":25,"_143":-5,"_27":161},{"_42":153,"_32":28,"_30":31,"_136":-5,"_40":41,"_39":14,"_138":58,"_37":154,"_13":140,"_33":20,"_34":36,"_24":25,"_143":-5,"_27":155},{"_42":145,"_32":146,"_30":147,"_136":-5,"_40":41,"_39":148,"_138":58,"_37":149,"_13":140,"_33":150,"_34":151,"_24":25,"_143":-5,"_27":152},{"_42":134,"_32":135,"_30":56,"_136":-5,"_40":41,"_39":137,"_138":58,"_37":139,"_13":140,"_33":141,"_34":142,"_24":25,"_143":-5,"_27":144},"044e36b1-4d4b-4ec4-9882-aad3f02b99d6","main.tsx","parentId",5,"latest",["D",1788868821249],1,"http","/** @jsxImportSource npm:hono/jsx */\nimport { Hono } from \"npm:hono\";\nimport { email } from \"https://esm.town/v/std/email\";\nimport { addInquiry, countRecentByIp, listInquiries } from \"./db.ts\";\n\n// 齊天旅行社網站詢問表單後端\n// POST /inquiry (body: JSON sent as text/plain to avoid CORS preflight)\n// GET /admin?key=INQUIRY_ADMIN_KEY -> 詢問列表\n// GET /health\n\nconst app = new Hono();\n\nconst LIMIT = { name: 80, email: 160, phone: 60, month: 40, party: 40, message: 4000, dest: 40 };\n\nasync function sha256(s: string): Promise {\n const buf = await crypto.subtle.digest(\"SHA-256\", new TextEncoder().encode(s));\n return [...new Uint8Array(buf)].map((b) => b.toString(16).padStart(2, \"0\")).join(\"\");\n}\n\n// strip ASCII control characters (keep tab/newline), trim, cap length\nconst CONTROL_RE = new RegExp(\"[\\\\x00-\\\\x08\\\\x0B\\\\x0C\\\\x0E-\\\\x1F]\", \"g\");\nfunction clean(v: unknown, max: number): string {\n return String(v ?? \"\").replace(CONTROL_RE, \"\").trim().slice(0, max);\n}\n\nfunction fmtDate(iso: string): string {\n // created_at is UTC from sqlite; show Taipei time\n const d = new Date(iso.replace(\" \", \"T\") + \"Z\");\n return d.toLocaleString(\"zh-TW\", { timeZone: \"Asia/Taipei\", hour12: false });\n}\n\napp.get(\"/\", (c) => c.json({ service: \"chitien-inquiry\", ok: true }));\napp.get(\"/health\", (c) => c.text(\"ok\"));\n\napp.post(\"/inquiry\", async (c) => {\n let body: any = {};\n try {\n body = JSON.parse(await c.req.text());\n } catch {\n return c.json({ ok: false, error: \"bad_json\" }, 400);\n }\n\n // Honeypot: real users never fill this. Pretend success so bots move on.\n if (clean(body.website, 200)) return c.json({ ok: true, id: 0 });\n\n const name = clean(body.name, LIMIT.name);\n const emailAddr = clean(body.email, LIMIT.email);\n const phone = clean(body.phone, LIMIT.phone);\n const dests: string[] = Array.isArray(body.destinations)\n ? body.destinations.map((d: unknown) => clean(d, LIMIT.dest)).filter(Boolean).slice(0, 20)\n : [];\n const month = clean(body.month, LIMIT.month);\n const party = clean(body.party, LIMIT.party);\n const message = clean(body.message, LIMIT.message);\n const lang = clean(body.lang, 5) || \"zh\";\n\n if (name.length < 1) return c.json({ ok: false, error: \"name_required\" }, 400);\n if (!/^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/.test(emailAddr)) return c.json({ ok: false, error: \"email_invalid\" }, 400);\n if (!message && dests.length === 0) return c.json({ ok: false, error: \"empty\" }, 400);\n\n const ip = c.req.header(\"x-forwarded-for\")?.split(\",\")[0].trim() || \"unknown\";\n const ipHash = (await sha256(ip)).slice(0, 24);\n if ((await countRecentByIp(ipHash, 15)) >= 5) {\n return c.json({ ok: false, error: \"rate_limited\" }, 429);\n }\n\n const id = await addInquiry({\n name,\n email: emailAddr,\n phone,\n destinations: dests.join(\"、\"),\n month,\n party,\n message,\n lang,\n ip_hash: ipHash,\n user_agent: clean(c.req.header(\"user-agent\"), 200),\n });\n\n const lines = [\n `齊天旅行社網站新詢問 #${id}`,\n \"\",\n `姓名：${name}`,\n `Email：${emailAddr}`,\n `電話 / LINE：${phone || \"未填\"}`,\n `想去的地方：${dests.join(\"、\") || \"未指定\"}`,\n `預計出發：${month || \"未填\"}`,\n `人數：${party || \"未填\"}`,\n `語言：${lang}`,\n \"\",\n \"留言：\",\n message || \"（無）\",\n \"\",\n \"直接回覆此信即可回信給客人。\",\n ];\n\n try {\n await email({\n subject: `【齊天旅行社網站詢問】${name}｜${dests.join(\"、\") || \"未指定目的地\"}`,\n text: lines.join(\"\\n\"),\n replyTo: emailAddr,\n });\n } catch (e) {\n console.error(\"email notification failed\", e);\n }\n\n return c.json({ ok: true, id });\n});\n\napp.get(\"/admin\", async (c) => {\n const key = c.req.query(\"key\") ?? \"\";\n const expected = Deno.env.get(\"INQUIRY_ADMIN_KEY\") ?? \"\";\n if (!expected || key !== expected) return c.text(\"Unauthorized\", 401);\n const rows = await listInquiries(300);\n return c.html(\n \n \n \n \n \n 齊天旅行社網站詢問\n \n \n \n

網站詢問（共 {rows.length} 筆，最新在上）

\n {rows.length === 0 &&

目前還沒有詢問。

}\n {rows.map((r) => (\n

#{r.id}・{fmtDate(r.created_at)}・{r.lang}

{r.name}　{r.email}　電話/LINE：{r.phone || \"未填\"}

目的地：{r.destinations || \"未指定\"}　出發：{r.month || \"未填\"}　人數：{r.party || \"未填\"}

{r.message || \"（無留言）\"}

\n ))}\n \n ,\n );\n});\n\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","label",[135],"fcf36612-ff8c-4e05-b935-4371de93a7d6","db.ts","01a080e1-be0d-720f-a0a0-95f2ff9c7dc2",2,["D",1788868727973],"script","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport interface Inquiry {\n id: number;\n name: string;\n email: string;\n phone: string;\n destinations: string;\n month: string;\n party: string;\n message: string;\n lang: string;\n ip_hash: string;\n user_agent: string;\n created_at: string;\n}\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS inquiries (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n email TEXT NOT NULL,\n phone TEXT NOT NULL DEFAULT '',\n destinations TEXT NOT NULL DEFAULT '',\n month TEXT NOT NULL DEFAULT '',\n party TEXT NOT NULL DEFAULT '',\n message TEXT NOT NULL DEFAULT '',\n lang TEXT NOT NULL DEFAULT 'zh',\n ip_hash TEXT NOT NULL DEFAULT '',\n user_agent TEXT NOT NULL DEFAULT '',\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n)`);\n\nexport async function addInquiry(i: Omit): Promise {\n const r = await sqlite.execute({\n sql: `INSERT INTO inquiries (name, email, phone, destinations, month, party, message, lang, ip_hash, user_agent)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [i.name, i.email, i.phone, i.destinations, i.month, i.party, i.message, i.lang, i.ip_hash, i.user_agent],\n });\n return Number(r.lastInsertRowid ?? 0);\n}\n\nexport async function countRecentByIp(ipHash: string, minutes: number): Promise {\n const r = await sqlite.execute({\n sql: `SELECT COUNT(*) AS n FROM inquiries WHERE ip_hash = ? AND created_at >= datetime('now', ?)`,\n args: [ipHash, `-${minutes} minutes`],\n });\n return Number((r.rows[0] as any)?.n ?? 0);\n}\n\nexport async function listInquiries(limit = 300): Promise {\n const r = await sqlite.execute({\n sql: `SELECT id, name, email, phone, destinations, month, party, message, lang, created_at\n FROM inquiries ORDER BY id DESC LIMIT ?`,\n args: [limit],\n });\n return r.rows as unknown as Inquiry[];\n}\n",[146],"b7bf10e0-84e2-4dee-b7f6-46d8ccd04908",["D",1788868842846],[28],"83808d2d-83b4-48ca-8033-5ef2f339ec00","components","01a080e1-be0d-720f-a0a0-8c994b4d2526",["D",1788868672868],"directory",[157],"pulls","branches","forks","envVars",{"_169":140,"_171":62},"connections",{"_169":62,"_170":62},"count","unfilledCount","emptyCount",{"_42":156,"_32":157,"_30":158,"_136":-5,"_40":41,"_39":140,"_138":58,"_37":194,"_13":62,"_33":160,"_34":-5,"_24":25,"_143":-5,"_178":195,"_27":196},{"_42":187,"_32":188,"_30":189,"_136":158,"_40":41,"_39":140,"_138":25,"_37":190,"_13":62,"_33":150,"_34":191,"_24":25,"_143":-5,"_178":192,"_27":193},{"_42":153,"_32":28,"_30":31,"_136":-5,"_40":41,"_39":14,"_138":58,"_37":184,"_13":140,"_33":20,"_34":36,"_24":25,"_143":-5,"_178":185,"_27":186},{"_42":145,"_32":146,"_30":147,"_136":-5,"_40":41,"_39":148,"_138":58,"_37":181,"_13":140,"_33":150,"_34":151,"_24":25,"_143":-5,"_178":182,"_27":183},{"_42":134,"_32":135,"_30":56,"_136":-5,"_40":41,"_39":137,"_138":58,"_37":177,"_13":140,"_33":141,"_34":142,"_24":25,"_143":-5,"_178":179,"_27":180},["D",1788868821249],"children",[],[135],["D",1788868727973],[],[146],["D",1788868842846],[],[28],"5a82b9c4-f1ea-4734-92e8-8e3f3f69b152","Layout.tsx","01a080e1-be0d-720f-a0a0-875daae02b75",["D",1788868672868],"/** @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",[],[157,188],["D",1788868672868],[173],[157],["D",1788868672868],["D",1789651264012],{"_99":98,"_107":103},{"_99":98,"_100":101,"_102":103,"_18":54,"_104":105,"_106":25},{"_13":88,"_32":89,"_42":41,"_90":43,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":44,"_97":98},"ctx",{"_81":-5,"_127":235,"_236":237,"_238":239,"_240":25,"_241":25,"_242":25,"_243":58,"_244":-5,"_245":-7,"_246":-7,"_247":62,"_248":25,"_249":25,"_250":-5,"_251":25,"_252":25,"_253":25,"_254":-5},"ENV",{"_206":207,"_208":209,"_210":89,"_211":212,"_213":214,"_215":216,"_217":218,"_219":220,"_221":222,"_223":224,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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"]

Diff · v6