網站詢問（共 {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",[18],"pulls","branches","forks","envVars",{"_172":40,"_174":26},"connections",{"_172":26,"_173":26},"count","unfilledCount","emptyCount",{"_33":200,"_13":201,"_67":202,"_43":-5,"_35":36,"_158":40,"_159":95,"_37":203,"_39":26,"_69":204,"_161":-5,"_71":24,"_163":-5,"_180":205,"_17":206},{"_33":192,"_13":193,"_67":194,"_43":-5,"_35":36,"_158":195,"_159":95,"_37":196,"_39":40,"_69":21,"_161":197,"_71":24,"_163":-5,"_180":198,"_17":199},{"_33":183,"_13":184,"_67":185,"_43":-5,"_35":36,"_158":186,"_159":95,"_37":187,"_39":40,"_69":188,"_161":189,"_71":24,"_163":-5,"_180":190,"_17":191},{"_33":157,"_13":18,"_67":68,"_43":-5,"_35":36,"_158":77,"_159":95,"_37":179,"_39":40,"_69":70,"_161":162,"_71":24,"_163":-5,"_180":181,"_17":182},["D",1788868821249],"children",[],[18],"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",[],[184],"b7bf10e0-84e2-4dee-b7f6-46d8ccd04908","README.md","01a080e1-be0d-720f-a0a0-9153a0ca3e53",6,["D",1788868842846],"# 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",[],[193],"83808d2d-83b4-48ca-8033-5ef2f339ec00","components","01a080e1-be0d-720f-a0a0-8c994b4d2526",["D",1788868672868],"directory",[],[201],["D",1788868672868],["D",1789651264012],{"_11":12,"_135":74},{"_11":12,"_130":131,"_73":74,"_30":72,"_132":133,"_134":24},{"_39":121,"_13":16,"_33":36,"_122":84,"_123":-5,"_124":-5,"_125":-5,"_126":-5,"_127":-5,"_128":14,"_129":12},"ctx",{"_54":-5,"_154":245,"_246":247,"_248":249,"_250":24,"_251":24,"_252":24,"_253":95,"_254":-5,"_255":-7,"_256":-7,"_257":26,"_258":24,"_259":24,"_260":-5,"_261":24,"_262":24,"_263":24,"_264":-5},"ENV",{"_216":217,"_218":219,"_220":16,"_221":222,"_223":224,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244},"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"]

History · main.tsx