[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_106":107,"_108":109},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","kfieseler","name","ndx-parts-dev","path","fuel_daystory.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":53,"_54":-5,"_55":56,"_57":58,"_59":32,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_13":44},"permalink","https://www.val.town/x/kfieseler/ndx-parts-dev/code/fuel_daystory.ts","extension","id","564d138c-4132-4b5f-bc15-8311c1595c5b","fileId","d0a5edee-9db7-11f1-b1ff-1607ee4eb77e","parentId","branchId","1ba53fed-b2e4-413d-8a29-62afbe01b059","branchVersion",2381,"latest",true,"createdAt",["D",1787523725922],"version",33,"fileType","script","content","// fuel_daystory.ts — how the truck's day actually drove, from Tenna GPS\n// (Kaden 8/21: the Auburn Bay shop board treatment — on-site / travel / yard\n// split with percentages, miles driven, gaps, and per-stop in/out times).\n//\n// HOW: a fuel truck's engine (and PTO) runs while pumping, so Tenna often\n// records ONE \"trip\" spanning the whole route. The per-stop truth lives in\n// trip-events (pto on/off + idling, each with lat/lon). We resolve every\n// event against our own site pins (fl_site_geo) and read the day from that:\n// PTO windows are literal pumping time. Trips still supply ignition\n// boundaries and true odometer miles. All of it publishes overnight —\n// perfect for the Review tab (yesterday), thin for today.\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// the three fuel trucks' Tenna asset ids (stable UUIDs, probed 8/21)\nconst TRUCKS: { label: string; fleet: string; id: string }[] = [\n { label: \"4101\", fleet: \"4101/2\", id: \"e4d2a105-8e6c-49c8-b01d-449c87cfe19a\" },\n { label: \"4100\", fleet: \"4100/2\", id: \"7f714a47-81e4-4578-a107-62a421ad2694\" },\n { label: \"F250\", fleet: \"006\", id: \"a6730008-de59-41f1-aaba-afcba5bdabf4\" },\n];\nconst nap = (ms: number) => new Promise((r) => setTimeout(r, ms));\n\nfunction pacClock(iso: string): string {\n return new Date(iso).toLocaleTimeString(\"en-US\", { timeZone: \"America/Los_Angeles\", hour: \"numeric\", minute: \"2-digit\" });\n}\nfunction fmtMin(m: number): string {\n m = Math.round(m);\n const h = Math.floor(m / 60), r = m % 60;\n return h ? h + \"h\" + String(r).padStart(2, \"0\") : r + \"m\";\n}\nfunction havKm(aLat: number, aLon: number, bLat: number, bLon: number): number {\n const R = 6371, dLa = (bLat - aLat) * Math.PI / 180, dLo = (bLon - aLon) * Math.PI / 180;\n const x = Math.sin(dLa / 2) ** 2 + Math.cos(aLat * Math.PI / 180) * Math.cos(bLat * Math.PI / 180) * Math.sin(dLo / 2) ** 2;\n return 2 * R * Math.asin(Math.sqrt(x));\n}\n\nasync function tennaPages(path: string, base: string): Promise {\n const key = Deno.env.get(\"TENNA_KEY\") ?? \"\";\n if (!key) return [];\n const out: any[] = [];\n for (let off = 0; off < 900; off += 100) {\n let r: Response | null = null;\n // 429s are routine (5 req/s account-wide, shared with everything else).\n // Swallowing one here would cache a FALSE-EMPTY day — retry, never skip.\n for (let tries = 0; tries < 7; tries++) {\n r = await fetch(\"https://api.tenna.com/v1/\" + path + base + \"&limit=100&offset=\" + off, {\n headers: { Authorization: \"Bearer \" + key },\n });\n if (r.status !== 429) break;\n await nap(1500 + tries * 1500); // up to ~10s — the 5/s budget is account-wide\n }\n if (!r || !r.ok) {\n if (r && r.status === 429) throw new Error(\"tenna 429 after retries — \" + path);\n break;\n }\n const rows = (await r.json()).results || [];\n out.push(...rows);\n if (rows.length < 100) break;\n await nap(320);\n }\n return out;\n}\n\nfunction utcWindow(date: string): { from: string; to: string } {\n const d2 = new Date(date + \"T12:00:00Z\");\n d2.setUTCDate(d2.getUTCDate() + 1);\n return { from: date + \"T07:00:00Z\", to: d2.toISOString().slice(0, 10) + \"T07:00:00Z\" };\n}\n\n// A FUEL SUPPLIER IS NOT A JOB AND NOT A MYSTERY (Kaden 8/24).\n// He keeps security perimeters for Rebel and River City in Tenna, but every\n// geofence endpoint on the read API 403s and perimeters are not sites, so they\n// never reach us. Pinned by hand instead, source 'fuel-vendor'. A dwell inside\n// one is the truck filling its own tank: it is neither on-site work nor\n// unexplained off-fence time, and it gets its own bucket, like the yard.\ntype Pin = { name: string; lat: number; lon: number; kind: \"yard\" | \"site\" | \"fuel\" };\n\nasync function loadPins(): Promise {\n const rows = (await sqlite.execute(\"SELECT site, lat, lon, source FROM fl_site_geo WHERE lat IS NOT NULL AND lon IS NOT NULL\")).rows as any[];\n return rows.map((r) => ({\n name: String(r[0]),\n lat: Number(r[1]),\n lon: Number(r[2]),\n kind: String(r[3] ?? \"\").startsWith(\"fuel-vendor\")\n ? \"fuel\" as const\n : /yard|shop/i.test(String(r[0])) ? \"yard\" as const : \"site\" as const,\n }));\n}\nfunction nearestPin(pins: Pin[], lat: number, lon: number): Pin | null {\n // 600 m for a job site — a big dirt job is a big fence. A fuel supplier is a\n // small yard, and Rebel's sits on Sahara a block off the 95: at 600 m a truck\n // stuck at the light on the way home from Creech reads as a refill. Caught on\n // the very first rebuilt day (6/8, 4100). Vendors get a tight fence.\n let best: Pin | null = null, bd = Infinity;\n for (const p of pins) {\n const lim = p.kind === \"fuel\" ? 0.25 : 0.6;\n const d = havKm(lat, lon, p.lat, p.lon);\n if (d < lim && d < bd) { bd = d; best = p; }\n }\n return best;\n}\n\nexport async function computeDayStory(date: string): Promise {\n const w = utcWindow(date);\n const win = \"?timestamp_from=\" + w.from + \"×tamp_to=\" + w.to;\n const pins = await loadPins();\n\n // gallons keyed per site that day — ties each GPS stop back to the log\n const galBySite = new Map();\n for (const r of (await sqlite.execute({\n sql: `SELECT j.jobname, SUM(m.gal), COUNT(m.gal) FROM fl_mach m JOIN fl_job j ON j.id = m.job_id\n WHERE j.date = ? AND m.gal IS NOT NULL GROUP BY j.jobname`,\n args: [date],\n })).rows as any[]) galBySite.set(String(r[0]), { gal: Number(r[1]) || 0, n: Number(r[2]) || 0 });\n // pre-app history (before 7/29) has no log rows at all — fall back to\n // Tenna's own fuel entries for that day so old stops still show gallons\n if (!galBySite.size) {\n const fe = await tennaPages(\"fuel-entries\", \"?pumped_at_time_from=\" + w.from + \"&pumped_at_time_to=\" + w.to);\n for (const e of fe) {\n const g = parseFloat(String(e.gallons ?? \"\"));\n if (isNaN(g)) continue;\n const sn = String(e.site_name ?? \"\").trim() || \"Unknown site\";\n const cur = galBySite.get(sn) || { gal: 0, n: 0 };\n cur.gal += g;\n cur.n++;\n galBySite.set(sn, cur);\n }\n }\n // gallons keyed under the catch-all \"Not on the route (Tenna)\" job never\n // match a site name — hold them per truck so a big unmatched pumping stop\n // can still claim them (honestly labeled)\n const offGal = new Map();\n for (const r of (await sqlite.execute({\n sql: `SELECT j.truck, SUM(m.gal), COUNT(m.gal) FROM fl_mach m JOIN fl_job j ON j.id = m.job_id\n WHERE j.date = ? AND m.gal IS NOT NULL AND j.jobname LIKE 'Not on the route%' GROUP BY j.truck`,\n args: [date],\n })).rows as any[]) offGal.set(String(r[0]), { gal: Number(r[1]) || 0, n: Number(r[2]) || 0 });\n const drivers = new Map();\n for (const r of (await sqlite.execute({ sql: \"SELECT truck, driver FROM fl_day WHERE date = ?\", args: [date] })).rows as any[]) {\n drivers.set(String(r[0]), String(r[1] ?? \"\"));\n }\n\n const trucks: any[] = [];\n let anyData = false;\n for (const tk of TRUCKS) {\n const trips = await tennaPages(\"trips\", win + \"&asset_id=\" + tk.id);\n await nap(320);\n const events = await tennaPages(\"trip-events\", win + \"&asset_id=\" + tk.id);\n await nap(320);\n if (!trips.length && !events.length) continue;\n anyData = true;\n\n // one point stream: trip ignition boundaries (they carry Tenna's own site\n // names) + every pto/idling event (lat/lon resolved against our pins)\n type Pt = { ts: number; site: string | null; kind: \"yard\" | \"site\" | null; lat?: number; lon?: number; ptoOn?: boolean; ptoOff?: boolean };\n const pts: Pt[] = [];\n let km = 0;\n for (const t of trips) {\n km += Number(t.distance) || 0;\n for (const side of [\"start\", \"end\"] as const) {\n const nm = t[side + \"_site_name\"] ? String(t[side + \"_site_name\"]) : null;\n pts.push({\n ts: Date.parse(String(t[side + \"_date\"])),\n site: nm,\n kind: nm ? (/yard|shop/i.test(nm) ? \"yard\" : \"site\") : null,\n });\n }\n }\n for (const e of events) {\n const ty = String(e.type ?? \"\");\n if (!/pto|idl/i.test(ty)) continue;\n const p = nearestPin(pins, Number(e.lat), Number(e.lon));\n pts.push({\n ts: Date.parse(String(e.timestamp)),\n site: p ? p.name : null,\n kind: p ? p.kind : null,\n lat: Number(e.lat),\n lon: Number(e.lon),\n ptoOn: /pto on/i.test(ty),\n ptoOff: /pto off/i.test(ty),\n });\n }\n pts.sort((a, b) => a.ts - b.ts);\n if (!pts.length) continue;\n\n // group consecutive points at the same place into stops\n type Stop = { site: string | null; kind: \"yard\" | \"site\" | null; first: number; last: number; ptoMs: number; sumLat: number; sumLon: number; nPos: number };\n const stopsArr: Stop[] = [];\n let cur: Stop | null = null;\n let ptoStart: number | null = null;\n for (const p of pts) {\n if (cur && p.site === cur.site) {\n cur.last = p.ts;\n } else {\n if (cur && ptoStart != null) { cur.ptoMs += cur.last - ptoStart; ptoStart = null; }\n cur = { site: p.site, kind: p.kind, first: p.ts, last: p.ts, ptoMs: 0, sumLat: 0, sumLon: 0, nPos: 0 };\n stopsArr.push(cur);\n }\n if (p.lat != null && isFinite(p.lat)) { cur.sumLat += p.lat; cur.sumLon += Number(p.lon); cur.nPos++; }\n if (p.ptoOn && ptoStart == null) ptoStart = p.ts;\n if (p.ptoOff && ptoStart != null) { cur.ptoMs += p.ts - ptoStart; ptoStart = null; }\n }\n if (cur && ptoStart != null) cur.ptoMs += cur.last - ptoStart;\n\n // a big job (Creech is miles across) can put the pump WAY outside the\n // 600 m pin radius — a no-fence cluster that spent real PTO time gets a\n // second look against the pins at working-site scale\n for (const s of stopsArr) {\n if (s.site || s.ptoMs < 5 * 60000 || !s.nPos) continue;\n let best: Pin | null = null, bd = 9; // km\n for (const p of pins) {\n // NEVER at this range for a fuel supplier. The 9 km reach exists for\n // Creech-sized dirt; letting a vendor claim anything within 9 km would\n // relabel real jobs as refuelling, which is the opposite of the point.\n if (p.kind === \"fuel\") continue;\n const d = havKm(s.sumLat / s.nPos, s.sumLon / s.nPos, p.lat, p.lon);\n if (d < bd) { bd = d; best = p; }\n }\n if (best) { s.site = best.name; s.kind = best.kind; }\n }\n // re-merge neighbors the second look may have united\n for (let i = stopsArr.length - 1; i > 0; i--) {\n if (stopsArr[i].site && stopsArr[i].site === stopsArr[i - 1].site) {\n stopsArr[i - 1].last = stopsArr[i].last;\n stopsArr[i - 1].ptoMs += stopsArr[i].ptoMs;\n stopsArr.splice(i, 1);\n }\n }\n\n // stitch the day: stop dwells + the travel between them\n const timeline: any[] = [];\n const claimed = new Set(); // gallon buckets already tied to a stop\n let onsiteMin = 0, travelMin = 0, yardMin = 0, gapMin = 0, fuelMin = 0, gaps45 = 0, nStops = 0;\n timeline.push({ kind: \"start\", at: pacClock(new Date(stopsArr[0].first).toISOString()), name: stopsArr[0].site || \"no fence\" });\n for (let i = 0; i < stopsArr.length; i++) {\n const s = stopsArr[i];\n const m = (s.last - s.first) / 60000;\n const ptoMin = Math.round(s.ptoMs / 60000);\n if (m >= 2 || ptoMin >= 2) {\n let kind = s.kind === \"yard\" ? \"yard\" : s.kind === \"fuel\" ? \"fuel\" : s.site ? \"site\" : \"gap\";\n // Filling a fuel truck is not a two-minute job — the real ones run\n // 20-60 min. A short pause inside a vendor's fence is traffic, and it\n // goes back to off-fence time rather than quietly excusing itself.\n if (kind === \"fuel\" && m < 8) kind = \"gap\";\n if (kind === \"yard\") yardMin += m;\n else if (kind === \"fuel\") fuelMin += m; // filling the truck — its own bucket\n else if (kind === \"site\") { onsiteMin += m; nStops++; }\n else { gapMin += m; if (m >= 45) gaps45++; }\n // the log and the pin book can hold different vintages of a site's\n // name (Creech DRP vs Creech CR-0127) — fall back to first-word match.\n // Only a stop that actually PUMPED (pto) claims gallons, and each\n // gallon bucket is claimed once — a drive-through next to the real\n // stop must not mirror its numbers.\n let gk: { gal: number; n: number } | undefined;\n let gkey = \"\";\n // a refill puts fuel INTO the truck; it can never claim gallons that\n // went out of it\n if (s.site && ptoMin >= 2 && kind !== \"fuel\") {\n if (galBySite.has(s.site)) { gk = galBySite.get(s.site); gkey = s.site; }\n else {\n const w1 = s.site.split(\" \")[0].toLowerCase();\n if (w1.length > 3) {\n for (const [k, v] of galBySite) {\n if (k.split(\" \")[0].toLowerCase() === w1) { gk = v; gkey = k; break; }\n }\n }\n }\n if (gk && claimed.has(gkey)) gk = undefined;\n else if (gk) claimed.add(gkey);\n }\n // a gap dwell carries its GPS spot + nearest known pin, so \"off the\n // map\" is checkable in one tap instead of a mystery (Kaden 8/22)\n // EVERY dwell keeps its GPS average, not just the gaps (DEV-304).\n // These are real fixes off the truck's own tracker, and they are what\n // lets the completed map show where the truck ACTUALLY sat rather than\n // where the site pin says the job is — the two are often not the same,\n // and the difference is the point of reviewing a finished route.\n let gapLat: number | null = null, gapLon: number | null = null;\n let nearName: string | null = null, nearMi: number | null = null;\n if (s.nPos) {\n gapLat = Math.round((s.sumLat / s.nPos) * 100000) / 100000;\n gapLon = Math.round((s.sumLon / s.nPos) * 100000) / 100000;\n }\n if (kind === \"gap\" && gapLat != null && gapLon != null) {\n let bd2 = 40; // km\n for (const p of pins) {\n const dk = havKm(gapLat, gapLon, p.lat, p.lon);\n if (dk < bd2) { bd2 = dk; nearName = p.name; }\n }\n if (nearName) nearMi = Math.round(bd2 * 0.621371 * 10) / 10;\n }\n timeline.push({\n kind,\n from: pacClock(new Date(s.first).toISOString()),\n to: pacClock(new Date(s.last).toISOString()),\n min: Math.round(m), dur: fmtMin(m),\n pto: ptoMin >= 2 ? fmtMin(ptoMin) : null,\n name: s.site || \"no fence (between sites)\",\n gal: gk ? Math.round(gk.gal) : null,\n fills: gk ? gk.n : null,\n lat: gapLat, lon: gapLon, near: nearName, nearMi,\n });\n }\n const nx = stopsArr[i + 1];\n if (nx) {\n const tm = (nx.first - s.last) / 60000;\n if (tm >= 2) {\n travelMin += tm;\n if (tm >= 45) gaps45++;\n timeline.push({\n kind: \"travel\",\n from: pacClock(new Date(s.last).toISOString()),\n to: pacClock(new Date(nx.first).toISOString()),\n min: Math.round(tm), dur: fmtMin(tm), long: tm >= 45,\n name: (s.site || \"no fence\") + \" → \" + (nx.site || \"no fence\"),\n });\n }\n }\n }\n const lastS = stopsArr[stopsArr.length - 1];\n timeline.push({ kind: \"end\", at: pacClock(new Date(lastS.last).toISOString()), name: lastS.site || \"no fence\" });\n\n // one big pumping stop with nothing keyed + off-route gallons on this\n // truck the same day → those gallons almost surely belong to that stop\n const offG = offGal.get(tk.label);\n if (offG && offG.gal > 0) {\n const cands = timeline.filter((t) => t.kind === \"site\" && t.gal == null && t.pto);\n if (cands.length === 1) {\n cands[0].gal = Math.round(offG.gal);\n cands[0].fills = offG.n;\n cands[0].off = true; // keyed under \"Not on the route (Tenna)\"\n }\n }\n\n const total = onsiteMin + travelMin + yardMin + gapMin + fuelMin;\n const pct = (m: number) => total ? Math.round((m / total) * 100) : 0;\n trucks.push({\n truck: tk.label,\n driver: drivers.get(tk.label) || \"\",\n miles: Math.round(km * 0.621371 * 10) / 10,\n stops: nStops,\n gaps45,\n onsite: { min: Math.round(onsiteMin), dur: fmtMin(onsiteMin), pct: pct(onsiteMin) },\n travel: { min: Math.round(travelMin), dur: fmtMin(travelMin), pct: pct(travelMin) },\n yard: { min: Math.round(yardMin), dur: fmtMin(yardMin), pct: pct(yardMin) },\n gap: { min: Math.round(gapMin), dur: fmtMin(gapMin), pct: pct(gapMin) },\n // filling the truck's own tank — a cost of the day, not a job and not a\n // mystery (Kaden 8/24)\n fuel: { min: Math.round(fuelMin), dur: fmtMin(fuelMin), pct: pct(fuelMin) },\n timeline,\n });\n }\n return {\n date,\n // shape version — bump when the classification changes so the rebuild\n // sweep can tell which cached days are stale (2 = the refuel bucket)\n storyV: 2,\n trucks,\n note: anyData ? \"\" : \"no GPS data for this day yet — Tenna publishes trips overnight\",\n };\n}\n\n// cached wrapper — trips only change overnight, so a few hours of cache is free\nexport async function dayStoryCached(date: string, force = false): Promise {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS fl_daystory (date TEXT PRIMARY KEY, json TEXT, at TEXT)`);\n if (!force) {\n const row = ((await sqlite.execute({ sql: \"SELECT json, at FROM fl_daystory WHERE date = ?\", args: [date] })).rows as any[])[0];\n if (row) {\n const age = Date.now() - Date.parse(String(row[1]));\n const cached = JSON.parse(String(row[0]));\n // an empty story for a recent day gets retried sooner (data may have landed since)\n const ttl = cached.trucks?.length ? 6 * 3600000 : 45 * 60000;\n if (isFinite(age) && age < ttl) return cached;\n }\n }\n const out = await computeDayStory(date);\n await sqlite.execute({\n sql: \"INSERT INTO fl_daystory (date, json, at) VALUES (?, ?, ?) ON CONFLICT (date) DO UPDATE SET json = excluded.json, at = excluded.at\",\n args: [date, JSON.stringify(out), new Date().toISOString()],\n });\n return out;\n}\n\n// ---------- week / month roll-up (Kaden 8/21: \"a look per week and month\") ----------\n// Aggregates the CACHED day stories in a date range — no Tenna calls here.\n// The archive fills itself: the 5 AM reconcile stores yesterday's story every\n// night, and history was backfilled once. Gallons come fresh from the log.\nexport async function reviewAgg(start: string, end: string): Promise {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS fl_daystory (date TEXT PRIMARY KEY, json TEXT, at TEXT)`);\n const srows = (await sqlite.execute({\n sql: \"SELECT date, json FROM fl_daystory WHERE date >= ? AND date <= ? ORDER BY date\",\n args: [start, end],\n })).rows as any[];\n const stories = new Map();\n for (const r of srows) {\n try {\n const s = JSON.parse(String(r[1]));\n if (s.trucks && s.trucks.length) stories.set(String(r[0]), s);\n } catch { /* skip bad row */ }\n }\n\n // gallons + fills keyed per date+truck from the log (cheap, always current)\n const galByDT = new Map();\n for (const r of (await sqlite.execute({\n sql: `SELECT j.date, j.truck, SUM(m.gal), COUNT(m.gal) FROM fl_mach m JOIN fl_job j ON j.id = m.job_id\n WHERE j.date >= ? AND j.date <= ? AND m.gal IS NOT NULL GROUP BY j.date, j.truck`,\n args: [start, end],\n })).rows as any[]) galByDT.set(String(r[0]) + \"|\" + String(r[1]), { gal: Number(r[2]) || 0, n: Number(r[3]) || 0 });\n\n const per = new Map();\n for (const [date, s] of stories) {\n for (const t of s.trucks) {\n let a = per.get(t.truck);\n if (!a) {\n a = { truck: t.truck, onsiteMin: 0, travelMin: 0, yardMin: 0, gapMin: 0, fuelMin: 0, miles: 0, stops: 0, gaps45: 0, gal: 0, fills: 0, days: [] };\n per.set(t.truck, a);\n }\n // pre-app days keep no log rows — fall back to the gallons the day\n // story itself tied to the stops (Tenna fuel entries)\n let g = galByDT.get(date + \"|\" + t.truck);\n if (!g) {\n g = { gal: 0, n: 0 };\n for (const st of (t.timeline || [])) {\n if ((st.kind === \"site\" || st.kind === \"yard\") && st.gal) { g.gal += st.gal; g.n += st.fills || 0; }\n }\n }\n a.onsiteMin += t.onsite.min; a.travelMin += t.travel.min; a.yardMin += t.yard.min; a.gapMin += t.gap.min;\n a.fuelMin += (t.fuel?.min ?? 0);\n a.miles += t.miles; a.stops += t.stops; a.gaps45 += t.gaps45; a.gal += g.gal; a.fills += g.n;\n a.days.push({\n date, driver: t.driver || \"\",\n onsiteMin: t.onsite.min, onsiteDur: t.onsite.dur, onsitePct: t.onsite.pct,\n travelMin: t.travel.min, travelDur: t.travel.dur,\n yardMin: t.yard.min, gapMin: t.gap.min, fuelMin: (t.fuel?.min ?? 0),\n miles: t.miles, stops: t.stops, gaps45: t.gaps45, gal: Math.round(g.gal),\n });\n }\n }\n\n // coverage: which Mon–Fri days through yesterday have no GPS story yet\n const yday = new Date(Date.now() - 7 * 3600 * 1000 - 86400000).toISOString().slice(0, 10);\n const missing: string[] = [];\n let workdays = 0;\n const cur = new Date(start + \"T12:00:00Z\");\n while (true) {\n const ds = cur.toISOString().slice(0, 10);\n if (ds > end || ds > yday) break;\n const dow = cur.getUTCDay();\n if (dow !== 0 && dow !== 6) {\n workdays++;\n if (!stories.has(ds)) missing.push(ds);\n }\n cur.setUTCDate(cur.getUTCDate() + 1);\n }\n\n const trucks = [...per.values()].map((a) => {\n const total = a.onsiteMin + a.travelMin + a.yardMin + a.gapMin + a.fuelMin;\n const pc = (m: number) => total ? Math.round((m / total) * 100) : 0;\n const mk = (m: number) => ({ min: Math.round(m), dur: fmtMin(m), pct: pc(m) });\n return {\n truck: a.truck,\n dayCount: a.days.length,\n miles: Math.round(a.miles * 10) / 10,\n stops: a.stops, gaps45: a.gaps45,\n gal: Math.round(a.gal), fills: a.fills,\n onsite: mk(a.onsiteMin), travel: mk(a.travelMin), yard: mk(a.yardMin), gap: mk(a.gapMin),\n fuel: mk(a.fuelMin),\n days: a.days.sort((x: any, y: any) => x.date < y.date ? -1 : 1),\n };\n }).sort((x, y) => y.onsite.min - x.onsite.min);\n\n let totalGal = 0;\n for (const v of galByDT.values()) totalGal += v.gal;\n return { start, end, trucks, totalGal: Math.round(totalGal), workdays, missing };\n}\n","deleted",false,"label",[14],"1730b37d-28eb-4a6b-8ba7-7294e47bbdb7",["D",1785517935233],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","DEV copy of NDX Parts — staging. Writes to TEST board.","imageUrl","userId","ab88c973-4988-481a-90fe-82231ca2dbda","pinnedFileId","ffd44ea0-8d02-11f1-95b0-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019fb4e5-7efe-7110-bc8f-c886bb63dd3f","tursoName","1730b37d28eb4a6b8ba77294e47bbdb7","tursoHostname","1730b37d28eb4a6b8ba77294e47bbdb7-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789452068287],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_105":100},"org",{"_9":10,"_99":100,"_101":100,"_55":56,"_102":103,"_104":42},"branch",{"_35":89,"_11":90,"_22":28,"_91":45,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":12,"_98":10},"isOwned",2869,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","","avatar","tier","pro","canRestrictVals","profileImageUrl","ctx",{"_82":-5,"_139":140,"_141":142,"_143":144,"_145":42,"_146":42,"_147":42,"_148":32,"_149":-5,"_150":-7,"_151":-7,"_152":63,"_153":42,"_154":42,"_155":-5,"_156":42,"_157":42,"_158":42,"_159":-5},"ENV",{"_110":111,"_112":113,"_114":90,"_115":116,"_117":118,"_119":120,"_121":122,"_123":124,"_125":126,"_127":128,"_129":130,"_131":132,"_133":134,"_135":136,"_137":138},"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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]