[{"_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":16,"_17":18,"_44":-7,"_168":-5,"_19":169,"_170":171,"_172":173,"_174":175,"_176":177,"_21":178,"_179":-5,"_180":-5,"_181":24,"_182":183,"_184":131,"_185":-5,"_186":-5,"_187":188},"routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":22,"_23":24,"_25":26,"_27":28,"_29":24,"_30":-5},"handle","emozh","name","gyg-bookings","branchName","main","path","main.ts","project",{"_38":119,"_13":14,"_42":120,"_121":-5,"_122":24,"_123":124,"_125":124,"_126":-5,"_127":-5,"_30":71,"_128":129,"_130":131,"_132":-5,"_133":-5,"_134":26,"_46":47,"_135":-5,"_136":-5,"_137":-5,"_138":-5,"_139":140,"_141":140,"_142":143,"_144":143,"_145":143,"_146":140,"_147":140,"_56":148,"_149":150,"_151":152,"_153":24},"file",{"_66":67,"_13":18,"_68":69,"_70":24,"_118":-5},"isDirectory",false,"page",0,"history",[31,32,33,34,35,36,37],"hasNext","userId",{"_38":111,"_40":41,"_42":112,"_44":113,"_46":47,"_48":103,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":-5,"_56":114,"_21":115,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":116},{"_38":103,"_40":41,"_42":104,"_44":105,"_46":47,"_48":106,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":-5,"_56":107,"_21":108,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":109},{"_38":96,"_40":41,"_42":97,"_44":98,"_46":47,"_48":89,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":-5,"_56":99,"_21":100,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":101},{"_38":89,"_40":41,"_42":90,"_44":91,"_46":47,"_48":82,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":-5,"_56":92,"_21":93,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":94},{"_38":82,"_40":41,"_42":83,"_44":84,"_46":47,"_48":74,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":-5,"_56":85,"_21":86,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":87},{"_38":74,"_40":41,"_42":75,"_44":76,"_46":47,"_48":77,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":-5,"_56":78,"_21":79,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":80},{"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":-5,"_56":57,"_21":58,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":64},"id","d258efdf-1dc5-4665-8717-a719606b43da","branchId","8b86a9c6-fe40-41da-b557-89612b01f8b1","createdAt",["D",1789504616482],"version",1,"orgId","01a0465b-a310-7790-a32f-8b6426eb6648","parentId","incomingCommitId","aiChatMessageId","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle","source","clientLabel","user",{"_38":71,"_46":47,"_11":12,"_72":73},{"_66":67,"_13":18,"_68":69,"_70":24},"pull","merge","revert","multiple","commits",[65],{"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":-5,"_56":57,"_21":58,"_59":-5,"_60":-5,"_61":-5},"fileId","3168b706-b145-11f1-976a-1607ee4eb77e","fileType","interval","deleted","159ec370-beca-4817-8fff-86948c62b68c","avatar","https://lh3.googleusercontent.com/a/ACg8ocLxwnoJwJmE9vXG2JGoSATvN3fLUGTJl0pIFoYjPTg2Qai5jQ=s96-c","dea822b4-61d0-4c32-bf09-16319a3c87b3",["D",1789506871152],4,"255851ec-8f22-47e0-9322-6b0f2ab28574",{"_38":71,"_46":47,"_11":12,"_72":73},{"_66":67,"_13":18,"_68":69,"_70":24},[81],{"_38":74,"_40":41,"_42":75,"_44":76,"_46":47,"_48":77,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":-5,"_56":78,"_21":79,"_59":-5,"_60":-5,"_61":-5},"2a70dba0-e314-40fc-8577-1fd888d3fcee",["D",1789506880821],5,{"_38":71,"_46":47,"_11":12,"_72":73},{"_66":67,"_13":18,"_68":69,"_70":24},[88],{"_38":82,"_40":41,"_42":83,"_44":84,"_46":47,"_48":74,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":-5,"_56":85,"_21":86,"_59":-5,"_60":-5,"_61":-5},"02c68538-9527-4118-b6dd-0d4aa95709ca",["D",1789507064206],6,{"_38":71,"_46":47,"_11":12,"_72":73},{"_66":67,"_13":18,"_68":69,"_70":24},[95],{"_38":89,"_40":41,"_42":90,"_44":91,"_46":47,"_48":82,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":-5,"_56":92,"_21":93,"_59":-5,"_60":-5,"_61":-5},"89f913f7-aae0-45fb-a969-a81f003d02f5",["D",1789507287025],7,{"_38":71,"_46":47,"_11":12,"_72":73},{"_66":67,"_13":18,"_68":69,"_70":24},[102],{"_38":96,"_40":41,"_42":97,"_44":98,"_46":47,"_48":89,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":-5,"_56":99,"_21":100,"_59":-5,"_60":-5,"_61":-5},"6cd6870d-a541-40ca-9005-eaa6c1eefee4",["D",1789507642707],9,"107bd94c-6022-48e9-a19e-14c632408fda",{"_38":71,"_46":47,"_11":12,"_72":73},{"_66":67,"_13":18,"_68":69,"_70":24},[110],{"_38":103,"_40":41,"_42":104,"_44":105,"_46":47,"_48":106,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":-5,"_56":107,"_21":108,"_59":-5,"_60":-5,"_61":-5},"6c13fa11-6d4f-4164-88d9-fe2d300970bf",["D",1789508004766],10,{"_38":71,"_46":47,"_11":12,"_72":73},{"_66":67,"_13":18,"_68":69,"_70":24},[117],{"_38":111,"_40":41,"_42":112,"_44":113,"_46":47,"_48":103,"_49":-5,"_50":-5,"_51":-5,"_52":-5,"_53":-5,"_54":-5,"_55":-5,"_56":114,"_21":115,"_59":-5,"_60":-5,"_61":-5},"deletedAtVersion","9360f2b1-dcfc-4c30-8316-f47643ca6eea",["D",1789504616159],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","pinnedFileId","fe07116c-b146-11f1-8f52-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_11":12,"_167":73},"org",{"_11":12,"_162":163,"_72":73,"_30":71,"_164":165,"_166":24},"branch",{"_44":113,"_13":16,"_38":41,"_154":119,"_155":-5,"_156":-5,"_157":-5,"_158":-5,"_159":-5,"_160":14,"_161":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","E Mozh","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_38":119,"_13":14,"_42":222,"_121":-5,"_122":24,"_123":124,"_125":124,"_126":-5,"_127":-5,"_30":71,"_128":129,"_130":131,"_132":-5,"_133":-5,"_134":26,"_46":47,"_135":-5,"_136":-5,"_137":-5,"_138":-5,"_139":140,"_141":140,"_142":143,"_144":143,"_145":143,"_146":140,"_147":140,"_56":223,"_149":224,"_151":225,"_153":24},"tree",[207,208],"files",[207,208],"counts",{"_197":26,"_198":45,"_199":26,"_200":201,"_202":203},"contents",[],{"_38":189,"_13":18,"_66":67,"_48":-5,"_40":41,"_190":113,"_191":131,"_42":192,"_44":91,"_68":69,"_193":194,"_70":24,"_195":-5,"_17":196},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},"be9250b4-2ff9-4ecf-9488-15fa1e833022","branchVersion","latest",["D",1789508004766],"content","// GYG booking counter — runs on val.town (Deno) every hour.\n// Reads \"New booking on GetYourGuide\" e-mails from Gmail via the Gmail API,\n// stores every booking once (by Gmail message id), and when something new\n// arrived sends one Telegram message: the new bookings + the running day total\n// (owner's local calendar day). Commission = 8 % of the booking price, converted to USD\n// at the ECB reference rate (via frankfurter, which republishes ECB data).\n// Nothing is sent when nothing changed. Days roll over on their own.\n//\n// Env vars (val.town → Environment variables):\n// GMAIL_CLIENT_ID, GMAIL_CLIENT_SECRET, GMAIL_REFRESH_TOKEN (scope gmail.readonly)\n// TG_BOT_TOKEN, TG_CHAT_ID (comma-separated chat ids)\n// Source of truth: travel-builder/tools/gyg-bookings/main.ts — push with push.mjs.\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nconst COMMISSION = 0.08;\nconst TZ = \"America/Vancouver\"; // owner's local day\nconst ACCOUNTS: Record = { \"tsegelnyk@gmail.com\": \"ot\", \"olga.eksaurova@gmail.com\": \"eks\" };\nconst GMAIL_QUERY = 'from:do-not-reply@notification.getyourguide.com subject:\"New booking\" newer_than:3d';\n\nconst env = (k: string) => {\n const v = Deno.env.get(k);\n if (!v) throw new Error(`env ${k} is not set`);\n return v.trim();\n};\n\n// ---------- storage ----------\nasync function ensureSchema() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS gyg_bookings (\n msg_id TEXT PRIMARY KEY,\n received_at INTEGER NOT NULL,\n day TEXT NOT NULL,\n ref TEXT,\n tour TEXT,\n tour_date TEXT,\n amount REAL NOT NULL,\n currency TEXT NOT NULL,\n usd REAL NOT NULL,\n notified INTEGER NOT NULL DEFAULT 0,\n account TEXT\n )`);\n try { await sqlite.execute(\"ALTER TABLE gyg_bookings ADD COLUMN account TEXT\"); } catch { /* exists */ }\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS gyg_fx (\n day TEXT PRIMARY KEY,\n rates TEXT NOT NULL\n )`);\n}\nconst rows = (r: any) => r.rows.map((row: any[]) => Object.fromEntries(r.columns.map((c: string, i: number) => [c, row[i]])));\n\n// ---------- helpers ----------\nfunction localDay(ms: number): string {\n // YYYY-MM-DD in TZ\n return new Intl.DateTimeFormat(\"sv-SE\", { timeZone: TZ, year: \"numeric\", month: \"2-digit\", day: \"2-digit\" }).format(new Date(ms));\n}\nfunction kyivPretty(day: string): string {\n const [, m, d] = day.split(\"-\").map(Number);\n const months = [\"jan\", \"feb\", \"mar\", \"apr\", \"may\", \"jun\", \"jul\", \"aug\", \"sep\", \"oct\", \"nov\", \"dec\"];\n return `${months[m - 1]} ${d}`;\n}\nconst money = (n: number) => n.toLocaleString(\"en-US\", { minimumFractionDigits: 1, maximumFractionDigits: 1 });\nconst whole = (n: number) => Math.round(n).toLocaleString(\"en-US\");\nconst esc = (s: string) => s.replace(/&/g, \"&\").replace(//g, \">\");\n\n// ---------- ECB rates (EUR base) ----------\nasync function ecbRates(day: string): Promise> {\n const cached = rows(await sqlite.execute({ sql: \"SELECT rates FROM gyg_fx WHERE day = ?\", args: [day] }));\n if (cached.length) return JSON.parse(cached[0].rates);\n const r = await fetch(\"https://api.frankfurter.dev/v1/latest?base=EUR\");\n if (!r.ok) throw new Error(`frankfurter ${r.status}`);\n const j = await r.json();\n const rates = { EUR: 1, ...j.rates };\n await sqlite.execute({ sql: \"INSERT OR REPLACE INTO gyg_fx (day, rates) VALUES (?, ?)\", args: [day, JSON.stringify(rates)] });\n return rates;\n}\nfunction toUsd(amount: number, currency: string, rates: Record): number {\n if (currency === \"USD\") return amount;\n const c = rates[currency];\n if (!c || !rates.USD) throw new Error(`no ECB rate for ${currency}`);\n return (amount / c) * rates.USD;\n}\n\n// ---------- Gmail ----------\nasync function gmailToken(): Promise {\n const r = await fetch(\"https://oauth2.googleapis.com/token\", {\n method: \"POST\",\n headers: { \"content-type\": \"application/x-www-form-urlencoded\" },\n body: new URLSearchParams({\n client_id: env(\"GMAIL_CLIENT_ID\"),\n client_secret: env(\"GMAIL_CLIENT_SECRET\"),\n refresh_token: env(\"GMAIL_REFRESH_TOKEN\"),\n grant_type: \"refresh_token\",\n }),\n });\n const j = await r.json();\n if (!j.access_token) throw new Error(\"gmail token: \" + JSON.stringify(j).slice(0, 200));\n return j.access_token;\n}\nasync function gmail(path: string, token: string) {\n const r = await fetch(`https://gmail.googleapis.com/gmail/v1/users/me/${path}`, { headers: { authorization: `Bearer ${token}` } });\n if (!r.ok) throw new Error(`gmail ${path}: ${r.status} ${(await r.text()).slice(0, 200)}`);\n return r.json();\n}\nfunction b64url(s: string): string {\n const bin = atob(s.replace(/-/g, \"+\").replace(/_/g, \"/\"));\n return new TextDecoder().decode(Uint8Array.from(bin, (c) => c.charCodeAt(0)));\n}\nfunction bodyText(payload: any): string {\n // Prefer text/plain, fall back to stripped HTML. Walk multipart trees.\n let plain = \"\", html = \"\";\n const walk = (p: any) => {\n if (!p) return;\n if (p.mimeType === \"text/plain\" && p.body?.data) plain += b64url(p.body.data);\n if (p.mimeType === \"text/html\" && p.body?.data) html += b64url(p.body.data);\n (p.parts || []).forEach(walk);\n };\n walk(payload);\n if (plain.trim()) return plain;\n return html\n .replace(//gi, \" \")\n .replace(//gi, \"\\n\").replace(/<\\/(p|div|tr|li|h\\d)>/gi, \"\\n\")\n .replace(/<[^>]+>/g, \" \")\n .replace(/ /g, \" \").replace(/&/g, \"&\").replace(/'/g, \"'\").replace(/"/g, '\"')\n .replace(/[ \\t]+/g, \" \");\n}\n\ntype Booking = { msg_id: string; received_at: number; ref: string; account: string; tour: string; tour_date: string; amount: number; currency: string };\n\nfunction parseBooking(msg: any): Booking | null {\n const headers = Object.fromEntries((msg.payload?.headers || []).map((h: any) => [h.name.toLowerCase(), h.value]));\n const subject: string = headers.subject || \"\";\n const ref = (subject.match(/\\b([A-Z]\\d{5,})\\b/) || [])[1] || \"\";\n const to = (headers.to || \"\").toLowerCase();\n const account = Object.entries(ACCOUNTS).find(([mail]) => to.includes(mail))?.[1] || \"?\";\n const text = bodyText(msg.payload);\n const price = text.match(/Price:\\s*([\\d.,]+)\\s*([A-Z]{3})/i);\n if (!price) return null;\n const amount = parseFloat(price[1].replace(/,/g, \"\"));\n const currency = price[2].toUpperCase();\n const tourDate = (text.match(/Date:\\s*(\\d{2}-\\d{2}-\\d{4})/) || [])[1] || \"\";\n // Tour name: the bold line between \"product:\" and \"Date:\"\n const m = text.match(/product:\\s*([\\s\\S]*?)\\s*Date:/i);\n const tour = (m ? m[1] : \"\").replace(/\\s+/g, \" \").trim() || \"(tour name not parsed)\";\n return { msg_id: msg.id, received_at: Number(msg.internalDate), ref, account, tour, tour_date: tourDate, amount, currency };\n}\n\n// ---------- Telegram ----------\nasync function tg(html: string) {\n // TG_CHAT_ID may hold several ids, comma-separated (owner + Olga).\n for (const chat_id of env(\"TG_CHAT_ID\").split(\",\").map((s) => s.trim()).filter(Boolean)) {\n const r = await fetch(`https://api.telegram.org/bot${env(\"TG_BOT_TOKEN\")}/sendMessage`, {\n method: \"POST\",\n headers: { \"content-type\": \"application/json\" },\n body: JSON.stringify({ chat_id, text: html, parse_mode: \"HTML\", disable_web_page_preview: true }),\n });\n const j = await r.json();\n if (!j.ok) console.error(\"telegram\", chat_id, JSON.stringify(j).slice(0, 200));\n }\n}\n\nfunction fmtDate(d: string) { // 17-10-2026 → 17.10.2026\n return d ? d.replace(/-/g, \".\") : \"\";\n}\n\nfunction buildMessage(fresh: any[], dayRows: any[], day: string): string {\n const lines: string[] = [];\n const n = dayRows.length;\n const positions = new Map(dayRows.map((r, i) => [r.msg_id, i + 1]));\n for (const b of fresh) {\n const amount = b.currency === \"USD\" ? `$${money(b.amount)}` : `${money(b.amount)} ${b.currency.toLowerCase()} ($${money(b.usd)})`;\n lines.push(\n `booking #${positions.get(b.msg_id) ?? \"?\"}, ${b.account}`,\n esc(b.tour),\n `${amount}, commission $${money(b.usd * COMMISSION)}`,\n \"\",\n );\n }\n const sum = dayRows.reduce((s, r) => s + r.usd, 0);\n const by = (acc: string) => dayRows.filter((r) => r.account === acc).reduce((s, r) => s + r.usd, 0) * COMMISSION;\n lines.push(`total: ${n} booking${n === 1 ? \"\" : \"s\"}, $${whole(sum)}, commission $${money(sum * COMMISSION)} (ot $${money(by(\"ot\"))}, eks $${money(by(\"eks\"))})`);\n return lines.join(\"\\n\");\n}\n\n// ---------- main ----------\nexport async function notifyLatest() {\n await ensureSchema();\n const last = rows(await sqlite.execute(\"SELECT * FROM gyg_bookings ORDER BY received_at DESC LIMIT 1\"));\n if (!last.length) return \"no bookings\";\n const dayRows = rows(await sqlite.execute({ sql: \"SELECT * FROM gyg_bookings WHERE day = ? ORDER BY received_at\", args: [last[0].day] }));\n await tg(buildMessage(last, dayRows, last[0].day));\n return \"sent latest\";\n}\n\nexport async function resync() {\n await ensureSchema();\n await sqlite.execute(\"DELETE FROM gyg_bookings\");\n return run({ notify: false });\n}\n\nexport default async function run(opts: { notify?: boolean } = {}) {\n const notify = opts.notify !== false;\n await ensureSchema();\n const token = await gmailToken();\n const list = await gmail(`messages?q=${encodeURIComponent(GMAIL_QUERY)}&maxResults=50`, token);\n const ids: string[] = (list.messages || []).map((m: any) => m.id);\n if (!ids.length) return \"no booking mails in the last 3 days\";\n\n const known = new Set(\n rows(await sqlite.execute({ sql: `SELECT msg_id FROM gyg_bookings WHERE msg_id IN (${ids.map(() => \"?\").join(\",\")})`, args: ids })).map((r: any) => r.msg_id),\n );\n const newIds = ids.filter((id) => !known.has(id));\n if (!newIds.length) return `nothing new (${ids.length} known)`;\n\n const today = localDay(Date.now());\n const rates = await ecbRates(today);\n const inserted: string[] = [];\n for (const id of newIds) {\n const msg = await gmail(`messages/${id}?format=full`, token);\n const b = parseBooking(msg);\n if (!b) { console.warn(\"unparsed mail\", id, msg.snippet); continue; }\n const day = localDay(b.received_at);\n const usd = toUsd(b.amount, b.currency, rates);\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO gyg_bookings (msg_id, received_at, day, ref, account, tour, tour_date, amount, currency, usd) VALUES (?,?,?,?,?,?,?,?,?,?)`,\n args: [b.msg_id, b.received_at, day, b.ref, b.account, b.tour, b.tour_date, b.amount, b.currency, usd],\n });\n inserted.push(id);\n }\n if (!inserted.length) return \"new mails but none parsed\";\n if (!notify) return `stored ${inserted.length} (silent)`;\n\n // Group the fresh bookings by their Kyiv day (a mail from 23:50 and one from 00:10 are two days).\n const fresh = rows(await sqlite.execute({\n sql: `SELECT * FROM gyg_bookings WHERE msg_id IN (${inserted.map(() => \"?\").join(\",\")}) ORDER BY received_at`,\n args: inserted,\n }));\n const days = [...new Set(fresh.map((r: any) => r.day))].sort();\n for (const day of days) {\n const dayRows = rows(await sqlite.execute({ sql: \"SELECT * FROM gyg_bookings WHERE day = ? ORDER BY received_at\", args: [day] }));\n await tg(buildMessage(fresh.filter((r: any) => r.day === day), dayRows, day));\n }\n await sqlite.execute({ sql: `UPDATE gyg_bookings SET notified = 1 WHERE msg_id IN (${inserted.map(() => \"?\").join(\",\")})`, args: inserted });\n return `sent ${inserted.length} new booking(s)`;\n}\n","label",[18],"pulls","branches","forks","envVars",{"_204":91,"_206":26},"connections",{"_204":26,"_205":26},"count","unfilledCount","emptyCount",{"_38":189,"_13":18,"_66":67,"_48":-5,"_40":41,"_190":113,"_191":131,"_42":219,"_44":91,"_68":69,"_193":194,"_70":24,"_195":-5,"_216":220,"_17":221},{"_38":209,"_13":210,"_66":129,"_48":-5,"_40":41,"_190":211,"_191":131,"_42":212,"_44":213,"_68":214,"_193":215,"_70":24,"_195":-5,"_216":217,"_17":218},"d684b59c-813d-4a3f-9705-260d967642bb","run.ts",8,["D",1789507287523],2,"http","// Manual trigger for the hourly job: GET ?key=. Same code path as the interval.\n// &dump=1 prints stored bookings; &resync=1 wipes and re-imports silently; &last=1 re-sends the latest booking.\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport run, { notifyLatest, resync } from \"./main.ts\";\nexport default async function (req: Request): Promise {\n const u = new URL(req.url);\n const key = u.searchParams.get(\"key\");\n if (!key || key !== Deno.env.get(\"RUN_KEY\")) return new Response(\"forbidden\", { status: 403 });\n try {\n if (u.searchParams.get(\"dump\")) {\n const r = await sqlite.execute(\"SELECT day, account, tour, tour_date, amount, currency, round(usd,2) usd FROM gyg_bookings ORDER BY received_at DESC LIMIT 100\");\n return new Response(r.rows.map((x: any[]) => x.join(\" | \")).join(\"\\n\"));\n }\n if (u.searchParams.get(\"resync\")) return new Response(await resync());\n if (u.searchParams.get(\"last\")) return new Response(await notifyLatest());\n return new Response(await run());\n } catch (e) { return new Response(\"error: \" + (e instanceof Error ? e.message : String(e)), { status: 500 }); }\n}\n","children",[],[210],["D",1789508004766],[],[18],["D",1789504616159],{"_11":12,"_167":73},{"_11":12,"_162":163,"_72":73,"_30":71,"_164":165,"_166":24},{"_44":113,"_13":16,"_38":41,"_154":119,"_155":-5,"_156":-5,"_157":-5,"_158":-5,"_159":-5,"_160":14,"_161":12},"ctx",{"_56":-5,"_186":259,"_260":261,"_262":263,"_264":24,"_265":24,"_266":24,"_267":131,"_268":-5,"_269":-7,"_270":-7,"_271":26,"_272":24,"_273":24,"_274":-5,"_275":24,"_276":24,"_277":24,"_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"]

History · main.ts