[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_167":168,"_169":170},"routes/_app.x.$handle.$name",{"_96":95,"_31":43,"_105":86,"_26":106,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":24,"_120":121,"_122":24,"_123":-5,"_124":-5,"_125":126},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_31":43,"_36":44,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":-5,"_55":24,"_56":-5,"_57":-5,"_58":59,"_60":61,"_62":63,"_64":65,"_66":67,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":24},"version",3,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":27,"_32":33,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","deleted",false,"deletedHere","path","main.ts","latestPath","fileId","496ba7dc-68e3-11f1-b401-1607ee4eb77e","name","fileType","script","content","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 // Verify signature only if a secret is configured (keeps the demo plug-and-play).\n if (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// --- 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","createdAt",["D",1781546082366],"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",{"_96":95,"_104":100},"org",{"_96":95,"_97":98,"_99":100,"_18":53,"_101":102,"_103":24},"branch",{"_13":85,"_31":86,"_41":40,"_87":42,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":43,"_94":95},"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",{"_41":42,"_31":43,"_36":162,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":-5,"_55":24,"_56":-5,"_57":-5,"_58":59,"_60":61,"_62":63,"_64":65,"_66":163,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":164,"_80":165,"_82":166,"_84":24},"tree",[153,154],"files",[153,154],"counts",{"_143":59,"_144":136,"_145":59,"_146":147,"_148":149},"contents",[127,128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":140,"_31":27,"_29":30,"_132":-5,"_39":40,"_38":14,"_134":24,"_36":141,"_13":59,"_32":33,"_34":35,"_23":24,"_138":-5,"_26":142},{"_41":129,"_31":130,"_29":131,"_132":-5,"_39":40,"_38":133,"_134":24,"_36":135,"_13":136,"_32":33,"_34":137,"_23":24,"_138":-5,"_26":139},"b0e6348b-f20a-4ab4-9801-1d42ec485600","views.ts","1cb325ee-68e3-11f1-909c-1607ee4eb77e","parentId",2,"latest",["D",1781546059749],1,"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// ---- Shared HTML shell ----\nfunction shell(title: string, body: unknown) {\n return html`\n \n \n \n \n ${title}\n \n \n \n \n \n

${body}

\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}

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

📦

No routes yet

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

`;\n\n return shell(\n \"Warehouse — Load & Pick Sheets\",\n html`\n

Warehouse Ops

Load & Pick Sheets

\n Auto-generated the moment a dispatcher publishes a route in Routific.\n

${cards}

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

\n `,\n );\n}\n\n// ---- Load & Pick sheet for one route (reverse-loading order) ----\nexport function loadSheetPage(row: RouteRow) {\n const r = row.payload.route;\n const stops = row.payload.timeline\n .filter((t) => t.type === \"delivering_stop\")\n .sort((a, b) => a.sequence - b.sequence);\n\n // Loading order = reverse of delivery order: last drop loaded first (front/bottom of van),\n // first drop loaded last (at the doors).\n const loadingOrder = [...stops].reverse();\n\n const rowsHtml = loadingOrder.map((stop, i) => {\n const orders = stop.orders ?? [];\n return html`\n \n \n \n \n

\n ${i + 1}\n

\n \n \n

Delivery stop #${stop.sequence}

ETA ${fmtTime(stop.plannedArrivalTime)}

\n \n \n ${orders.map(\n (o) => html`

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

`,\n )}\n \n \n ${orders.length} item${orders.length === 1 ? \"\" : \"s\"}\n \n `;\n });\n\n return shell(\n `Load Sheet — ${r.name}`,\n html`\n

\n ← All routes\n

\n\n

${r.name}

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

${r.date}

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

${stops.length}

stops

${r.ordersCount}

orders

${fmtDuration(r.workingTimeInSeconds)}

est. time

\n \n 🖨️ Print\n \n

\n\n

\n Reverse-loading order. Load item #1 first (deepest in the van) and\n finish with the last row — so the first delivery is right at the doors. No digging at every stop.\n

\n\n

\n \n \n \n \n \n \n \n \n \n \n ${rowsHtml}\n

✓	Load #	Drop sequence	Order #	Items

\n\n

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

\n `,\n );\n}\n\nexport { raw };\n","label",[130],"1dbcdee2-e293-43e3-b0a4-0d50a0daa695",["D",1781546082366],[27],"pulls","branches","forks","envVars",{"_150":136,"_152":59},"connections",{"_150":59,"_151":59},"count","unfilledCount","emptyCount",{"_41":140,"_31":27,"_29":30,"_132":-5,"_39":40,"_38":14,"_134":24,"_36":159,"_13":59,"_32":33,"_34":35,"_23":24,"_138":-5,"_156":160,"_26":161},{"_41":129,"_31":130,"_29":131,"_132":-5,"_39":40,"_38":133,"_134":24,"_36":155,"_13":136,"_32":33,"_34":137,"_23":24,"_138":-5,"_156":157,"_26":158},["D",1781546059749],"children",[],[130],["D",1781546082366],[],[27],["D",1781545960614],["D",1789498239291],{"_96":95,"_104":100},{"_96":95,"_97":98,"_99":100,"_18":53,"_101":102,"_103":24},{"_13":85,"_31":86,"_41":40,"_87":42,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":43,"_94":95},"ctx",{"_78":-5,"_124":200,"_201":202,"_203":204,"_205":24,"_206":24,"_207":24,"_208":209,"_210":-5,"_211":-7,"_212":-7,"_213":59,"_214":24,"_215":24,"_216":-5,"_217":24,"_218":24,"_219":24,"_220":-5},"ENV",{"_171":172,"_173":174,"_175":86,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197,"_198":199},"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",true,"preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v3