網站詢問（共 {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","children",[],[180],"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",[],[189],["D",1788868842846],[],[18],"83808d2d-83b4-48ca-8033-5ef2f339ec00","components","01a080e1-be0d-720f-a0a0-8c994b4d2526",["D",1788868672868],"directory",[],[201],["D",1788868672868],["D",1789651264012],{"_11":12,"_135":73},{"_11":12,"_130":131,"_72":73,"_30":71,"_132":133,"_134":24},{"_39":121,"_13":16,"_33":36,"_122":83,"_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 · README.md