[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_173":174,"_175":176},"routes/_app.x.$handle.$name",{"_98":97,"_32":45,"_107":88,"_27":108,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":25,"_122":123,"_124":125,"_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",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":25},"version",12,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","views.ts","latestPath","fileId","1cb325ee-68e3-11f1-909c-1607ee4eb77e","name","fileType","script","content","import { html, raw } from \"npm:hono/html\";\n\n// ---- Types mirroring the route.published payload ----\nexport interface Order {\n uuid: string;\n status: string;\n uri: string;\n customerOrderNumber: string;\n routificOrderNumber: string;\n}\nexport interface TimelineEntry {\n sequence: number;\n type: \"start_location\" | \"delivering_stop\" | \"end_location\" | \"idling\";\n stopUuid: string;\n plannedArrivalTime?: string;\n plannedDepartureTime?: string;\n actualArrivalTime?: string;\n actualDepartureTime?: string;\n distanceFromPreviousStopInKilometers?: number;\n orders?: Order[];\n}\nexport interface RoutePayload {\n route: {\n uuid: string;\n name: string;\n date: string;\n status: string;\n workspaceId: number;\n workingTimeInSeconds: number;\n distanceInKilometers: number;\n ordersCount: number;\n driver: { uuid: string; name: string | null; email: string } | null;\n };\n timeline: TimelineEntry[];\n}\n\nexport interface RouteRow {\n uuid: string;\n payload: RoutePayload;\n received_at: string;\n}\n\n// ---- Helpers ----\nconst fmtTime = (iso?: string) =>\n iso ? new Date(iso).toLocaleTimeString([], { hour: \"numeric\", minute: \"2-digit\" }) : \"—\";\n\nconst fmtDuration = (secs: number) => {\n const h = Math.floor(secs / 3600);\n const m = Math.round((secs % 3600) / 60);\n return h ? `${h}h ${m}m` : `${m}m`;\n};\n\nconst statusBadge = (status: string) => {\n const colors: Record = {\n planned: \"bg-slate-100 text-slate-700\",\n published: \"bg-blue-100 text-blue-700\",\n executing: \"bg-amber-100 text-amber-700\",\n completed: \"bg-emerald-100 text-emerald-700\",\n };\n return html`${status}`;\n};\n\n/** Flatten the timeline into one entry per order, in loading order (last drop loaded first). */\ninterface PackOrder extends Order {\n stopSequence: number;\n eta?: string;\n loadNumber: number;\n tote: string;\n}\nfunction packOrders(payload: RoutePayload): PackOrder[] {\n const stops = payload.timeline\n .filter((t) => t.type === \"delivering_stop\")\n .sort((a, b) => a.sequence - b.sequence);\n const loadingStops = [...stops].reverse(); // index 0 = first into the van (last delivery)\n const out: PackOrder[] = [];\n loadingStops.forEach((stop, i) => {\n const loadNumber = i + 1;\n const tote = \"T\" + String(loadNumber).padStart(2, \"0\");\n (stop.orders ?? []).forEach((o) =>\n out.push({ ...o, stopSequence: stop.sequence, eta: stop.plannedArrivalTime, loadNumber, tote }),\n );\n });\n return out;\n}\n\n// Static client script: localStorage-backed checklist + barcode rendering. No server interpolation.\nconst CLIENT_SCRIPT = `\n(function(){\n var root = document.querySelector('[data-route]');\n if(!root) return;\n var routeId = root.getAttribute('data-route');\n var boxes = Array.prototype.slice.call(document.querySelectorAll('input[data-order]'));\n function key(order){ return 'pack:' + routeId + ':' + order; }\n function refresh(){\n var done = boxes.filter(function(b){ return b.checked; }).length;\n var total = boxes.length;\n var pct = total ? Math.round(done * 100 / total) : 0;\n var bar = document.getElementById('progress-bar');\n var label = document.getElementById('progress-label');\n if(bar) bar.style.width = pct + '%';\n if(label) label.textContent = done + ' / ' + total + ' packed';\n boxes.forEach(function(b){\n var rowEl = b.closest('[data-row]');\n if(rowEl) rowEl.style.opacity = b.checked ? '0.5' : '1';\n });\n }\n boxes.forEach(function(b){\n if(localStorage.getItem(key(b.getAttribute('data-order'))) === '1') b.checked = true;\n b.addEventListener('change', function(){\n localStorage.setItem(key(b.getAttribute('data-order')), b.checked ? '1' : '0');\n refresh();\n });\n });\n refresh();\n if(window.JsBarcode){\n document.querySelectorAll('svg[data-barcode]').forEach(function(svg){\n try{ JsBarcode(svg, svg.getAttribute('data-barcode'), {format:'CODE128', displayValue:false, height:38, margin:0, width:1.6}); }catch(e){}\n });\n }\n var resetBtn = document.getElementById('reset-btn');\n if(resetBtn) resetBtn.addEventListener('click', function(){\n boxes.forEach(function(b){ b.checked = false; localStorage.removeItem(key(b.getAttribute('data-order'))); });\n refresh();\n });\n})();\n`;\n\n// Polls the server and reloads the page when a new route arrives or an existing one changes.\nconst POLL_SCRIPT = `\n(function(){\n var baseline = null;\n function check(){\n fetch('/api/state', { cache: 'no-store' })\n .then(function(r){ return r.json(); })\n .then(function(s){\n var sig = s.count + ':' + s.latest;\n if(baseline === null){ baseline = sig; return; }\n if(sig !== baseline){ location.reload(); }\n })\n .catch(function(){});\n }\n setInterval(check, 3000);\n check();\n})();\n`;\n\n// ---- Shared HTML shell ----\nfunction shell(title: string, body: unknown, withScript = false, autoReload = false) {\n return html`\n \n \n \n \n ${title}\n \n \n ${withScript\n ? html``\n : \"\"}\n \n \n \n

${body}

\n ${withScript ? html`` : \"\"}\n \n `;\n}\n\n// ---- Dashboard: all published routes ----\nexport function dashboardPage(rows: RouteRow[]) {\n const cards = rows.length\n ? rows.map((row) => {\n const r = row.payload.route;\n const stops = row.payload.timeline.filter((t) => t.type === \"delivering_stop\").length;\n return html`\n

${r.name}

${r.date}

\n ${statusBadge(r.status)}\n

\n \n ${(r.driver?.name ?? \"—\").slice(0, 1).toUpperCase()}\n \n ${r.driver?.name ?? \"Unassigned\"}\n

${stops}

stops

${r.ordersCount}

orders

${r.distanceInKilometers}

Open packing →

\n `;\n })\n : html`

📦

No routes yet

Publish a route in Routific and it'll appear here.

`;\n\n return shell(\n \"Warehouse — Packing Queue\",\n html`\n

Warehouse Ops

Packing Queue

\n A route to pack appears here the moment a dispatcher publishes it in Routific.\n

${cards}

\n Powered by the route.published webhook · view source\n

\n `,\n );\n}\n\n// ---- Packing workspace for one route ----\nexport function loadSheetPage(row: RouteRow) {\n const r = row.payload.route;\n const driver = r.driver?.name ?? \"Unassigned\";\n const orders = packOrders(row.payload);\n const stopCount = new Set(orders.map((o) => o.stopSequence)).size;\n\n // Pick / pack checklist rows (loading order).\n const checklistRows = orders.map(\n (o) => html`\n \n \n \n \n \n ${o.loadNumber}\n \n \n ${o.tote}\n \n

${o.customerOrderNumber}

${o.routificOrderNumber}

\n \n \n stop #${o.stopSequence}
ETA ${fmtTime(o.eta)}\n \n `,\n );\n\n // Printable parcel labels (one per order).\n const labels = orders.map(\n (o) => html`

${r.name} · ${r.date}

${driver}

${o.tote}

tote

\n Load ${o.loadNumber}\n drop stop #${o.stopSequence} · ETA ${fmtTime(o.eta)}\n

\n \n

\n ${o.customerOrderNumber}\n ${o.routificOrderNumber}\n

`,\n );\n\n return shell(\n `Packing — ${r.name}`,\n html`\n

\n ← Packing queue\n

\n\n \n

${r.name}

\n ${statusBadge(r.status)}\n

${r.date}

\n \n ${driver.slice(0, 1).toUpperCase()}\n \n ${driver}\n

${stopCount}

stops

${orders.length}

orders

${fmtDuration(r.workingTimeInSeconds)}

est. time

\n Pick each order into its tote and tick it off. Totes are numbered in loading order —\n load Tote T01 first (deepest in the van) so the first delivery sits at the doors.\n Then print the parcel labels below.\n

\n\n \n

\n Packing progress\n 0 / ${orders.length} packed\n

\n \n \n

\n\n \n

📋 Pick & pack list · loading order

\n \n \n \n \n \n \n \n \n \n \n ${checklistRows}\n

✓	Load	Tote	Order	Drop

\n\n \n

${r.name} · ${r.date}

${driver} · ${orders.length} parcels

🏷️ Parcel labels

${labels}

\n\n

\n Generated from the route.published webhook · received ${row.received_at} ·\n view source\n

\n `,\n true,\n );\n}\n\nexport { raw };\n","import { html, raw } from \"npm:hono/html\";\n\n// ---- Types mirroring the route.published payload ----\nexport interface Order {\n uuid: string;\n status: string;\n uri: string;\n customerOrderNumber: string;\n routificOrderNumber: string;\n}\nexport interface TimelineEntry {\n sequence: number;\n type: \"start_location\" | \"delivering_stop\" | \"end_location\" | \"idling\";\n stopUuid: string;\n plannedArrivalTime?: string;\n plannedDepartureTime?: string;\n actualArrivalTime?: string;\n actualDepartureTime?: string;\n distanceFromPreviousStopInKilometers?: number;\n orders?: Order[];\n}\nexport interface RoutePayload {\n route: {\n uuid: string;\n name: string;\n date: string;\n status: string;\n workspaceId: number;\n workingTimeInSeconds: number;\n distanceInKilometers: number;\n ordersCount: number;\n driver: { uuid: string; name: string | null; email: string } | null;\n };\n timeline: TimelineEntry[];\n}\n\nexport interface RouteRow {\n uuid: string;\n payload: RoutePayload;\n received_at: string;\n}\n\n// ---- Helpers ----\nconst fmtTime = (iso?: string) =>\n iso ? new Date(iso).toLocaleTimeString([], { hour: \"numeric\", minute: \"2-digit\" }) : \"—\";\n\nconst fmtDuration = (secs: number) => {\n const h = Math.floor(secs / 3600);\n const m = Math.round((secs % 3600) / 60);\n return h ? `${h}h ${m}m` : `${m}m`;\n};\n\nconst statusBadge = (status: string) => {\n const colors: Record = {\n planned: \"bg-slate-100 text-slate-700\",\n published: \"bg-blue-100 text-blue-700\",\n executing: \"bg-amber-100 text-amber-700\",\n completed: \"bg-emerald-100 text-emerald-700\",\n };\n return html`${status}`;\n};\n\n/** Flatten the timeline into one entry per order, in loading order (last drop loaded first). */\ninterface PackOrder extends Order {\n stopSequence: number;\n eta?: string;\n loadNumber: number;\n tote: string;\n}\nfunction packOrders(payload: RoutePayload): PackOrder[] {\n const stops = payload.timeline\n .filter((t) => t.type === \"delivering_stop\")\n .sort((a, b) => a.sequence - b.sequence);\n const loadingStops = [...stops].reverse(); // index 0 = first into the van (last delivery)\n const out: PackOrder[] = [];\n loadingStops.forEach((stop, i) => {\n const loadNumber = i + 1;\n const tote = \"T\" + String(loadNumber).padStart(2, \"0\");\n (stop.orders ?? []).forEach((o) =>\n out.push({ ...o, stopSequence: stop.sequence, eta: stop.plannedArrivalTime, loadNumber, tote }),\n );\n });\n return out;\n}\n\n// Static client script: localStorage-backed checklist + barcode rendering. No server interpolation.\nconst CLIENT_SCRIPT = `\n(function(){\n var root = document.querySelector('[data-route]');\n if(!root) return;\n var routeId = root.getAttribute('data-route');\n var boxes = Array.prototype.slice.call(document.querySelectorAll('input[data-order]'));\n function key(order){ return 'pack:' + routeId + ':' + order; }\n function refresh(){\n var done = boxes.filter(function(b){ return b.checked; }).length;\n var total = boxes.length;\n var pct = total ? Math.round(done * 100 / total) : 0;\n var bar = document.getElementById('progress-bar');\n var label = document.getElementById('progress-label');\n if(bar) bar.style.width = pct + '%';\n if(label) label.textContent = done + ' / ' + total + ' packed';\n boxes.forEach(function(b){\n var rowEl = b.closest('[data-row]');\n if(rowEl) rowEl.style.opacity = b.checked ? '0.5' : '1';\n });\n }\n boxes.forEach(function(b){\n if(localStorage.getItem(key(b.getAttribute('data-order'))) === '1') b.checked = true;\n b.addEventListener('change', function(){\n localStorage.setItem(key(b.getAttribute('data-order')), b.checked ? '1' : '0');\n refresh();\n });\n });\n refresh();\n if(window.JsBarcode){\n document.querySelectorAll('svg[data-barcode]').forEach(function(svg){\n try{ JsBarcode(svg, svg.getAttribute('data-barcode'), {format:'CODE128', displayValue:false, height:38, margin:0, width:1.6}); }catch(e){}\n });\n }\n var resetBtn = document.getElementById('reset-btn');\n if(resetBtn) resetBtn.addEventListener('click', function(){\n boxes.forEach(function(b){ b.checked = false; localStorage.removeItem(key(b.getAttribute('data-order'))); });\n refresh();\n });\n})();\n`;\n\n// Polls the server and reloads the page when a new route arrives or an existing one changes.\nconst POLL_SCRIPT = `\n(function(){\n var baseline = null;\n function check(){\n fetch('/api/state', { cache: 'no-store' })\n .then(function(r){ return r.json(); })\n .then(function(s){\n var sig = s.count + ':' + s.latest;\n if(baseline === null){ baseline = sig; return; }\n if(sig !== baseline){ location.reload(); }\n })\n .catch(function(){});\n }\n setInterval(check, 3000);\n check();\n})();\n`;\n\n// ---- Shared HTML shell ----\nfunction shell(title: string, body: unknown, withScript = false, autoReload = false) {\n return html`\n \n \n \n \n ${title}\n \n \n ${withScript\n ? html``\n : \"\"}\n \n \n \n

${body}

\n ${withScript ? html`` : \"\"}\n ${autoReload ? html`` : \"\"}\n \n `;\n}\n\n// ---- Dashboard: all published routes ----\nexport function dashboardPage(rows: RouteRow[]) {\n const cards = rows.length\n ? rows.map((row) => {\n const r = row.payload.route;\n const stops = row.payload.timeline.filter((t) => t.type === \"delivering_stop\").length;\n return html`\n

${r.name}

${r.date}

\n ${statusBadge(r.status)}\n

\n \n ${(r.driver?.name ?? \"—\").slice(0, 1).toUpperCase()}\n \n ${r.driver?.name ?? \"Unassigned\"}\n

${stops}

stops

${r.ordersCount}

orders

${r.distanceInKilometers}

Open packing →

\n `;\n })\n : html`

📦

No routes yet

Publish a route in Routific and it'll appear here.

`;\n\n return shell(\n \"Warehouse — Packing Queue\",\n html`\n

Warehouse Ops

Packing Queue

\n A route to pack appears here the moment a dispatcher publishes it in Routific.\n

${cards}

\n Powered by the route.published webhook · view source\n

${o.customerOrderNumber}

${o.routificOrderNumber}

\n \n \n stop #${o.stopSequence}
ETA ${fmtTime(o.eta)}\n \n `,\n );\n\n // Printable parcel labels (one per order).\n const labels = orders.map(\n (o) => html`

${r.name} · ${r.date}

${driver}

${o.tote}

tote

\n Load ${o.loadNumber}\n drop stop #${o.stopSequence} · ETA ${fmtTime(o.eta)}\n

\n \n

\n ${o.customerOrderNumber}\n ${o.routificOrderNumber}\n

`,\n );\n\n return shell(\n `Packing — ${r.name}`,\n html`\n

\n ← Packing queue\n

\n\n \n

${r.name}

\n ${statusBadge(r.status)}\n

${r.date}

\n \n ${driver.slice(0, 1).toUpperCase()}\n \n ${driver}\n

${stopCount}

stops

${orders.length}

orders

${fmtDuration(r.workingTimeInSeconds)}

est. time

\n\n \n

\n Packing progress\n 0 / ${orders.length} packed\n

\n \n \n

\n\n \n

📋 Pick & pack list · loading order

\n \n \n \n \n \n \n \n \n \n \n ${checklistRows}\n

✓	Load	Tote	Order	Drop

\n\n \n

${r.name} · ${r.date}

${driver} · ${orders.length} parcels

🏷️ Parcel labels

${labels}

\n\n

\n Generated from the route.published webhook · received ${row.received_at} ·\n view source\n

\n `,\n true,\n );\n}\n\nexport { raw };\n","createdAt",["D",1781547581744],"branchVersion","branchId","416699fb-87bb-4947-837e-8684a1943bac","id","0bff063f-f596-462d-9c4d-f1e73dcec5f6","routific-load-sheet",["D",1781545960614],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Warehouse Load & Pick Sheet — route.published webhook demo","imageUrl","544882c0-c67e-4d71-bc1f-ed58e07f7c7e","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019ecc2b-2b10-749b-8dc9-2ec5893d17c5","tursoName","0bff063ff596462d9c4df1e73dcec5f6","tursoHostname","0bff063ff596462d9c4df1e73dcec5f6-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789498239291],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_106":102},"org",{"_98":97,"_99":100,"_101":102,"_18":55,"_103":104,"_105":25},"branch",{"_13":87,"_32":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"isOwned",26,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","jamilwahid","handle","displayName","Jamil Wahid","avatar","https://lh3.googleusercontent.com/a/ACg8ocKQ0SrZl5L7F-fqeqL30bOiCiV80k3F2YGlLzXS20GmhceNGk4d=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":168,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":169,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":170,"_82":171,"_84":172,"_86":25},"tree",[159,160],"files",[159,160],"counts",{"_148":61,"_149":150,"_151":61,"_152":153,"_154":155},"contents",[130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":139,"_32":140,"_30":141,"_133":-5,"_41":42,"_40":142,"_134":25,"_38":143,"_13":144,"_33":145,"_35":146,"_24":25,"_137":-5,"_27":147},{"_43":132,"_32":28,"_30":31,"_133":-5,"_41":42,"_40":14,"_134":25,"_38":135,"_13":136,"_33":34,"_35":37,"_24":25,"_137":-5,"_27":138},"db503f64-9081-46bc-ba8e-f9cd512123c6","parentId","latest",["D",1781547581744],4,"label",[28],"4531a5ac-5836-4dea-ab78-fa9bf9a5db48","main.ts","496ba7dc-68e3-11f1-b401-1607ee4eb77e",10,["D",1781547562259],6,"http","import { Hono } from \"npm:hono\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\nimport { dashboardPage, loadSheetPage, type RoutePayload, type RouteRow } from \"./views.ts\";\n\nconst TABLE = \"routific_routes\";\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE} (\n uuid TEXT PRIMARY KEY,\n payload TEXT NOT NULL,\n received_at TEXT NOT NULL\n)`);\n\n/** Verify the Routific HMAC-SHA256 signature against the raw body. */\nasync function verifySignature(rawBody: string, header: string | null, secret: string): Promise {\n if (!header?.startsWith(\"v0=\")) return false;\n const signatures = header.slice(3).split(\",\").map((s) => s.trim());\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 mac = await crypto.subtle.sign(\"HMAC\", key, new TextEncoder().encode(rawBody));\n const expected = [...new Uint8Array(mac)].map((b) => b.toString(16).padStart(2, \"0\")).join(\"\");\n // constant-time-ish comparison\n return signatures.some((sig) => sig.length === expected.length && timingSafeEqual(sig, expected));\n}\n\nfunction timingSafeEqual(a: string, b: string): boolean {\n let mismatch = a.length === b.length ? 0 : 1;\n const len = Math.max(a.length, b.length);\n for (let i = 0; i < len; i++) mismatch |= a.charCodeAt(i) ^ b.charCodeAt(i);\n return mismatch === 0;\n}\n\nconst app = new Hono();\napp.onError((err) => Promise.reject(err));\n\n// --- Webhook receiver: route.published ---\napp.post(\"/webhook\", async (c) => {\n const rawBody = await c.req.text();\n const topic = c.req.header(\"x-routific-topic\");\n const secret = Deno.env.get(\"ROUTIFIC_WEBHOOK_SECRET\");\n\n // Signature verification is opt-in: set ROUTIFIC_VERIFY_SIGNATURE=true (and a correct\n // ROUTIFIC_WEBHOOK_SECRET) to enforce it. Off by default so the demo is plug-and-play.\n if (Deno.env.get(\"ROUTIFIC_VERIFY_SIGNATURE\") === \"true\" && secret) {\n const ok = await verifySignature(rawBody, c.req.header(\"x-routific-signature\") ?? null, secret);\n if (!ok) return c.text(\"invalid signature\", 401);\n }\n\n let body: { type?: string; data?: RoutePayload };\n try {\n body = JSON.parse(rawBody);\n } catch {\n return c.text(\"invalid json\", 400);\n }\n\n if (body.type !== \"route.published\" || !body.data?.route?.uuid) {\n // Acknowledge other topics so Routific doesn't retry; we only act on route.published.\n return c.json({ ok: true, ignored: topic ?? body.type ?? \"unknown\" });\n }\n\n await sqlite.execute({\n sql: `INSERT INTO ${TABLE} (uuid, payload, received_at) VALUES (?, ?, ?)\n ON CONFLICT(uuid) DO UPDATE SET payload = excluded.payload, received_at = excluded.received_at`,\n args: [body.data.route.uuid, JSON.stringify(body.data), new Date().toISOString()],\n });\n\n return c.json({ ok: true, stored: body.data.route.uuid });\n});\n\nasync function loadRows(): Promise {\n const res = await sqlite.execute(`SELECT uuid, payload, received_at FROM ${TABLE} ORDER BY received_at DESC`);\n return res.rows.map((row) => ({\n uuid: row.uuid as string,\n payload: JSON.parse(row.payload as string) as RoutePayload,\n received_at: new Date(row.received_at as string).toLocaleString(),\n }));\n}\n\n// --- Lightweight state signature for auto-refresh polling ---\napp.get(\"/api/state\", async (c) => {\n const res = await sqlite.execute(\n `SELECT COUNT(*) AS count, COALESCE(MAX(received_at), '') AS latest FROM ${TABLE}`,\n );\n const r = res.rows[0];\n return c.json({ count: Number(r.count), latest: r.latest as string });\n});\n\n// --- Warehouse dashboard ---\napp.get(\"/\", async (c) => c.html(dashboardPage(await loadRows()).toString()));\n\n// --- Load & pick sheet for one route ---\napp.get(\"/route/:uuid\", async (c) => {\n const res = await sqlite.execute({\n sql: `SELECT uuid, payload, received_at FROM ${TABLE} WHERE uuid = ?`,\n args: [c.req.param(\"uuid\")],\n });\n if (res.rows.length === 0) return c.text(\"Route not found\", 404);\n const row = res.rows[0];\n const data: RouteRow = {\n uuid: row.uuid as string,\n payload: JSON.parse(row.payload as string) as RoutePayload,\n received_at: new Date(row.received_at as string).toLocaleString(),\n };\n return c.html(loadSheetPage(data).toString());\n});\n\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\nexport default app.fetch;\n",[140],"pulls","branches",1,"forks","envVars",{"_156":150,"_158":61},"connections",{"_156":61,"_157":61},"count","unfilledCount","emptyCount",{"_43":139,"_32":140,"_30":141,"_133":-5,"_41":42,"_40":142,"_134":25,"_38":165,"_13":144,"_33":145,"_35":146,"_24":25,"_137":-5,"_162":166,"_27":167},{"_43":132,"_32":28,"_30":31,"_133":-5,"_41":42,"_40":14,"_134":25,"_38":161,"_13":136,"_33":34,"_35":37,"_24":25,"_137":-5,"_162":163,"_27":164},["D",1781547581744],"children",[],[28],["D",1781547562259],[],[140],["D",1781545960614],["D",1789498239291],{"_98":97,"_106":102},{"_98":97,"_99":100,"_101":102,"_18":55,"_103":104,"_105":25},{"_13":87,"_32":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"ctx",{"_80":-5,"_127":206,"_207":208,"_209":210,"_211":25,"_212":25,"_213":25,"_214":125,"_215":-5,"_216":-7,"_217":-7,"_218":61,"_219":25,"_220":25,"_221":-5,"_222":25,"_223":25,"_224":25,"_225":-5},"ENV",{"_177":178,"_179":180,"_181":88,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201,"_202":203,"_204":205},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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 · v12