[{"_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_yesterday.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_yesterday.ts","extension","id","a31bd020-8fda-4a2c-8ef1-a6f875f1f933","fileId","4540af28-9b78-11f1-88dd-1607ee4eb77e","parentId","branchId","1ba53fed-b2e4-413d-8a29-62afbe01b059","branchVersion",2687,"latest",true,"createdAt",["D",1787796726276],"version",34,"fileType","script","content","// YESTERDAY — did we get it right?\n//\n// Kaden 8/18: \"previous days routes what jobs were hit how much fuel hour\n// meters. does everything match our other sources. and what was missed. was a\n// machine not hit that ran heavy, did we skip a job and they got low on fuel,\n// was the route not efficient.\"\n//\n// This is the trust screen. It is the thing that earns the app the right to be\n// believed, and the shape of it is deliberate:\n//\n// DISAGREEMENTS ARE THE PRODUCT. Not a clean checkmark — the list of what\n// does not line up. A screen that says \"all good\" every morning teaches\n// people to stop reading it.\n//\n// Four sources, one day:\n// the app's own log — what the driver wrote down\n// the truck's meter — what actually went through the pump\n// Tenna utilization — which machines ran, in hours, with the site attached\n// Tenna fuel-entries — fills keyed into Tenna by anyone, including people\n// who are not us\n//\n// READ-ONLY over every external source. Writes nothing.\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { rows, isYardSite } from \"./core.ts\";\n\nconst METER_TOL = 5;\n\nexport type Finding = {\n kind: string;\n severity: \"bad\" | \"warn\" | \"info\";\n what: string;\n detail: string;\n // --- added 8/23 for the audit inbox. NONE of these change which findings\n // are produced or how severe they are; they only give each one an identity\n // a manager's decision can be filed against, and a short headline. ---\n id?: string; // stable within a day: kind + subject\n title?: string; // \"Meter Mismatch\", \"Unvisited Activity\"\n lines?: string[]; // the same facts as `detail`, split for scanning\n state?: string; // open | reviewed | resolved | expected\n note?: string;\n stateBy?: string;\n stateAt?: string;\n};\n\n// A finding is an item in an inbox now, so it needs a NAME — the thing a\n// manager scans down the left edge — separate from the sentence that explains\n// it. The sentences were written with care and are kept verbatim as the\n// detail; this is only a headline in front of them.\nconst TITLES: Record = {\n \"no-meter\": \"No Truck Meter\",\n \"meter-gap\": \"Pump vs Log Mismatch\",\n \"unsigned\": \"Day Not Signed\",\n \"on-site-but-skipped\": \"Skipped On Site\",\n \"ran-not-hit\": \"Unvisited Activity\",\n \"run-hours-meter-stuck\": \"Tracker Stuck\",\n \"run-hours-over-report\": \"Run Hours Disputed\",\n \"run-hours-under-report\": \"Run Hours Disputed\",\n \"run-hours-unverified\": \"Run Hours Unverified\",\n \"run-hours-no-meter\": \"No Meter Reading\",\n \"fuelled-but-idle\": \"Fueled, No Run Time\",\n \"site-name-mismatch\": \"Site Name Mismatch\",\n \"tenna-only-fill\": \"Fill Not On Our Log\",\n \"hours-disagree\": \"Meter Mismatch\",\n \"fill-double-key\": \"Possible Double Entry\",\n \"fill-meter-prefilled\": \"Meter Not Read\",\n \"fill-meter-off\": \"Meter Mismatch\",\n \"stop-not-closed\": \"Stop Not Closed\",\n \"stop-nothing-done\": \"Nothing Logged At Stop\",\n \"keyed-meter-impossible\": \"Meter Can't Be Right\",\n};\nconst titleFor = (kind: string) =>\n TITLES[kind] ??\n (kind.startsWith(\"run-hours-\") ? \"Run Hours Disputed\" : kind.replace(/-/g, \" \"));\n\n// The id must survive a re-run of the report — a decision filed yesterday has\n// to still find its exception tomorrow. kind + subject is stable because the\n// subject is a fleet number, a truck, or a site name, none of which the report\n// invents. Duplicates inside one kind get a counter rather than colliding and\n// silently sharing one manager's decision.\n// Meters run to five digits. 18609 and 18478.7 sitting one above the other are\n// two numbers a manager has to subtract by eye; 18,609 and 18,478.7 are two\n// numbers he can see are 130 apart.\nconst nf = (n: number) => {\n const r = Math.round(n * 10) / 10;\n const [i, d] = String(Math.abs(r)).split(\".\");\n return (r < 0 ? \"-\" : \"\") + i.replace(/\\B(?=(\\d{3})+(?!\\d))/g, \",\") + (d ? \".\" + d : \"\");\n};\n\nfunction stampIds(findings: Finding[]) {\n const seen: Record = {};\n for (const f of findings) {\n const slug = (f.kind + \"-\" + f.what).toLowerCase()\n .replace(/[^a-z0-9]+/g, \"-\").replace(/^-|-$/g, \"\").slice(0, 80);\n const n = (seen[slug] = (seen[slug] ?? 0) + 1);\n f.id = n === 1 ? slug : slug + \"-\" + n;\n f.title = titleFor(f.kind);\n if (!f.lines || !f.lines.length) f.lines = [f.detail];\n }\n}\n\n// THE DATE FILTER IS NOT THE SAME ON EVERY ENDPOINT. Measured 8/18:\n// asset-utilizations-daily / asset-readings-daily -> date_from & date_to\n// fuel-entries -> 422 \"date_from is not\n// allowed\"; it wants\n// pumped_at_time_from\n// Getting this wrong does not error in a way anyone notices — the paging loop\n// just breaks and the report quietly says the source had nothing, which is\n// exactly how a cross-check screen starts lying. Hence the `sources` block in\n// the result: an empty source must be visible as empty, never as agreement.\nasync function tennaDay(path: string, date: string): Promise {\n const key = Deno.env.get(\"TENNA_KEY\") ?? \"\";\n if (!key) return [];\n const next = new Date(Date.parse(date + \"T00:00:00Z\") + 86400000).toISOString().slice(0, 10);\n const filter = path === \"fuel-entries\"\n ? \"&pumped_at_time_from=\" + date + \"&pumped_at_time_to=\" + next\n : \"&date_from=\" + date + \"&date_to=\" + date;\n const out: any[] = [];\n for (let off = 0; off < 1500; off += 100) {\n let r: Response | null = null;\n for (let a = 0; a < 3; a++) {\n if (a) await new Promise((s) => setTimeout(s, 1200 * a));\n r = await fetch(\n \"https://api.tenna.com/v1/\" + path + \"?limit=100&offset=\" + off + filter,\n { headers: { Authorization: \"Bearer \" + key } },\n );\n if (r.ok) break;\n if (r.status !== 429 && r.status < 500) break;\n }\n if (!r || !r.ok) {\n console.log(\"yesterday: \" + path + \" stopped at offset \" + off + \" with \" + (r?.status ?? \"no response\"));\n break;\n }\n // envelope is {metadata, results} — never data/items\n const got: any[] = (await r.json()).results ?? [];\n out.push(...got);\n if (got.length < 100) break;\n await new Promise((s) => setTimeout(s, 250));\n }\n // belt and braces: whatever the server did with the filter, keep only the day\n if (path === \"fuel-entries\") {\n return out.filter((e: any) => String(e.pumped_at_time ?? \"\").slice(0, 10) === date);\n }\n return out;\n}\n\nconst base = (u: unknown) => String(u ?? \"\").split(\"/\")[0].trim();\n\nexport async function yesterdayReport(date: string) {\n const findings: Finding[] = [];\n\n // ---------- 1. THE TIE-OUT, per truck ----------\n const trucks: any[] = [];\n for (const d of rows(await sqlite.execute({\n sql: `SELECT date, truck, driver, assistant, meter_start ms, meter_end me, approved_at ap, started_at st\n FROM fl_day WHERE date = ? ORDER BY truck`,\n args: [date],\n }))) {\n // The tie-out asks one question: did as much fuel go on the log as went\n // through the truck's pump? A REFUEL stop is the truck filling ITSELF —\n // 30 gal of red diesel out of the yard tank on 8/18 — which never passes\n // through that pump. Counting it made a day that reconciled to the gallon\n // read as 30 over.\n //\n // But a silent exclusion is the same class of bug this screen exists to\n // catch, so the refuel gallons are counted separately and SAID OUT LOUD in\n // the finding rather than quietly dropped.\n const logged = Number((rows(await sqlite.execute({\n sql: `SELECT COALESCE(ROUND(SUM(m.gal),1),0) g FROM fl_mach m JOIN fl_job j ON j.id = m.job_id\n WHERE j.date = ? AND j.truck = ? AND COALESCE(j.kind,'') <> 'refuel'`,\n args: [date, String(d.truck)],\n }))[0] as any).g);\n const refuelGal = Number((rows(await sqlite.execute({\n sql: `SELECT COALESCE(ROUND(SUM(m.gal),1),0) g FROM fl_mach m JOIN fl_job j ON j.id = m.job_id\n WHERE j.date = ? AND j.truck = ? AND COALESCE(j.kind,'') = 'refuel'`,\n args: [date, String(d.truck)],\n }))[0] as any).g);\n const ms = d.ms == null ? null : Number(d.ms);\n const me2 = d.me == null ? null : Number(d.me);\n const moved = ms != null && me2 != null ? Math.round((me2 - ms) * 10) / 10 : null;\n const gap = moved != null ? Math.round((moved - logged) * 10) / 10 : null;\n trucks.push({\n truck: String(d.truck), driver: String(d.driver ?? \"\"), assistant: String(d.assistant ?? \"\"),\n logged, refuelGal, meterMoved: moved, gap,\n ties: gap == null ? null : Math.abs(gap) <= METER_TOL,\n signed: !!d.ap, started: !!d.st,\n });\n if (gap == null) {\n findings.push({\n kind: \"no-meter\", severity: \"warn\", what: String(d.truck),\n detail: \"no start/end meter on this day — nothing can be checked against the pump\",\n });\n } else if (Math.abs(gap) > METER_TOL) {\n findings.push({\n kind: \"meter-gap\", severity: \"bad\", what: String(d.truck),\n lines: [\n \"Fuel log: \" + logged + \" gal\",\n \"Truck meter moved: \" + moved + \" gal\",\n \"Difference: \" + (gap > 0 ? \"+\" : \"\") + gap + \" gal\",\n ].concat(refuelGal ? [\"Truck refuel excluded: \" + refuelGal + \" gal (never went through the pump)\"] : []),\n detail: (gap > 0\n ? \"logged \" + logged + \" gal but the meter moved \" + moved + \" — \" + gap + \" gal never went on the log\"\n : \"logged \" + logged + \" gal but the meter only moved \" + moved + \" — \" + Math.abs(gap) + \" gal more on the log than through the pump\")\n + (refuelGal ? \" (a further \" + refuelGal + \" gal of truck refuel is excluded — it did not go through the pump)\" : \"\"),\n });\n }\n if (!d.ap) {\n findings.push({\n kind: \"unsigned\", severity: \"warn\", what: String(d.truck),\n detail: \"the day was never signed\",\n });\n }\n }\n\n // ---------- 2. WHAT WE HIT ----------\n const hit = new Map();\n for (const r of rows(await sqlite.execute({\n sql: `SELECT m.unit, m.gal, m.hours, m.acts, m.status, j.jobname FROM fl_mach m JOIN fl_job j ON j.id = m.job_id\n WHERE j.date = ?`,\n args: [date],\n }))) {\n hit.set(base(r.unit), {\n unit: String(r.unit),\n gal: r.gal == null ? null : Number(r.gal),\n hours: r.hours == null ? null : Number(r.hours),\n site: String(r.jobname), acts: String(r.acts ?? r.status ?? \"\"),\n });\n }\n\n // ---------- 3. WHAT ACTUALLY RAN, from Tenna ----------\n // Run hours no longer come straight off the utilization feed. On 8/18 that\n // feed said 306/2 ran 16 h; its hour meter moved 8.1. fuel_ran.ts holds every\n // figure against the machine's own meter and prefers the meter when they\n // fight — see that file for why. Nothing is corrected silently.\n //\n // The readings pull is hoisted above this block so ranChecked() can reuse it\n // rather than walking the same endpoint a second time.\n const util = await tennaDay(\"asset-utilizations-daily\", date);\n const readings = await tennaDay(\"asset-readings-daily\", date);\n const { ranChecked } = await import(\"./fuel_ran.ts\");\n const ran = await ranChecked(date, util, readings);\n\n // the headline question: what ran hard and never got touched?\n //\n // Our own fuel trucks run all day BY DEFINITION — 4101 showed 12.1h on 8/17,\n // which is the truck doing the route, not a machine anybody missed. They fill\n // at the station and are never a stop. Same exclusion the router uses.\n const OUR_TRUCK = /^(4100|4101)$/;\n const missed = ran.filter((r) =>\n !hit.has(r.unit) && !isYardSite(r.site) && r.hours >= 1 && !OUR_TRUCK.test(r.unit)\n );\n // Two different failures wear the same clothes. Either the truck never went\n // to that site, or it went and this machine was not on the list. The second\n // one is worse — somebody stood on that dirt and drove past it.\n const stopsSites = rows(await sqlite.execute({\n sql: \"SELECT DISTINCT jobname FROM fl_job WHERE date = ?\",\n args: [date],\n })).map((r: any) => String(r.jobname).trim());\n const sitesVisited = new Set(stopsSites.map((s) => s.toLowerCase()));\n for (const m of missed.slice(0, 25)) {\n const went = m.site && sitesVisited.has(m.site.trim().toLowerCase());\n findings.push({\n kind: went ? \"on-site-but-skipped\" : \"ran-not-hit\",\n severity: m.hours >= 6 ? \"bad\" : \"warn\",\n what: m.fleet,\n lines: [\n \"Ran \" + m.hours + \"h at \" + (m.site || \"No Site\"),\n went\n ? \"A fuel truck WAS at this stop — the machine never made the list.\"\n : \"No fuel truck visited this location.\",\n ].concat(m.source === \"meter\" ? [\"Tenna claimed \" + m.reported + \"h; held against the machine's own meter.\"] : []),\n detail: (went\n ? \"ran \" + m.hours + \"h at \" + m.site + \" — a truck WAS at that stop and this machine never made the list\"\n : \"ran \" + m.hours + \"h at \" + (m.site || \"no site\") + \" and no truck went there\")\n // never let a meter-corrected figure look like the app quietly\n // disagreeing with Tenna — show Tenna's own claim alongside it\n + (m.source === \"meter\" ? \" (Tenna claimed \" + m.reported + \"h)\" : \"\"),\n });\n }\n\n // ---------- 3b. WHERE THE TWO HOUR SOURCES FIGHT ----------\n // Surfaced rather than swallowed. An over-report that silently became a\n // smaller number would be exactly the kind of invisible correction this\n // screen exists to prevent.\n // no-meter is different from the other flags: when it hits more than a\n // handful of machines at once, that's the READINGS PULL coming up short,\n // not sixty broken meters — one line says so; sixty lines bury the report.\n const noMeter = ran.filter((x: any) => x.flag === \"no-meter\");\n for (const r of ran.filter((x: any) => x.flag && x.flag !== \"no-meter\")) {\n findings.push({\n kind: \"run-hours-\" + r.flag,\n severity: r.flag === \"meter-stuck\" ? \"warn\" : \"info\",\n what: r.fleet,\n detail: r.why,\n });\n }\n if (noMeter.length > 5) {\n findings.push({\n kind: \"run-hours-unverified\", severity: \"warn\", what: noMeter.length + \" machines\",\n detail: \"no meter readings for any of them on both days, so their run hours are UNVERIFIED. \"\n + \"This many at once usually means Tenna didn't return the readings, not that the meters are broken\",\n });\n } else {\n for (const r of noMeter) {\n findings.push({ kind: \"run-hours-no-meter\", severity: \"info\", what: r.fleet, detail: r.why });\n }\n }\n\n // and the reverse — we serviced something Tenna says never moved\n const idleButHit: string[] = [];\n const ranSet = new Set(ran.map((r) => r.unit));\n for (const [u, h] of hit) {\n if (h.gal != null && h.gal > 0 && util.length && !ranSet.has(u)) idleButHit.push(h.unit);\n }\n if (idleButHit.length) {\n findings.push({\n kind: \"fuelled-but-idle\", severity: \"info\", what: idleButHit.length + \" machines\",\n detail: \"took fuel but Tenna logged no run time: \" + idleButHit.slice(0, 10).join(\", \")\n + \" — normal for a top-off before a job starts, worth a look if it repeats\",\n });\n }\n\n // ---------- 3b. THE SAME SITE UNDER TWO SPELLINGS ----------\n // Caught by this report on its first run: our route said \"Chinnatown Relocate\n // Contaminated Soils (G)\" and Tenna says \"Chinatown ...\". One letter, and the\n // join silently fails — the report then tells you no truck went to a site a\n // truck spent the morning at. A near-miss is worse than a clean miss because\n // it looks like an answer.\n const norm = (s: string) => s.toLowerCase().replace(/[^a-z0-9]/g, \"\");\n const ourSites = [...new Set(stopsSites)];\n const tennaSites = [...new Set(ran.map((r) => r.site).filter((s) => s && !isYardSite(s)))];\n for (const t of tennaSites) {\n if (ourSites.some((o) => norm(o) === norm(t))) continue;\n const nt = norm(t);\n // Real edit distance, because the difference is usually ONE inserted\n // letter and it can sit anywhere. \"Chinnatown\" vs \"Chinatown\" differs at\n // character 5, which defeats any prefix comparison — the first version of\n // this check used one and silently found nothing.\n const near = ourSites.find((o) => {\n const no = norm(o);\n if (Math.abs(no.length - nt.length) > 3) return false;\n let prev = Array.from({ length: nt.length + 1 }, (_, i) => i);\n for (let i = 1; i <= no.length; i++) {\n const cur = [i];\n for (let j = 1; j <= nt.length; j++) {\n cur[j] = Math.min(\n prev[j] + 1,\n cur[j - 1] + 1,\n prev[j - 1] + (no[i - 1] === nt[j - 1] ? 0 : 1),\n );\n }\n prev = cur;\n }\n const dist = prev[nt.length];\n // a couple of characters out of a long name is a typo; more is a\n // different job that happens to start the same way\n return dist > 0 && dist <= Math.max(2, Math.floor(nt.length * 0.08));\n });\n if (near) {\n findings.push({\n kind: \"site-name-mismatch\", severity: \"warn\", what: t,\n detail: 'our route calls this \"' + near + '\" — one of the two is misspelled, and the mismatch breaks every cross-check on that job',\n });\n }\n }\n\n // ---------- 4. FILLS TENNA KNOWS ABOUT AND WE DO NOT ----------\n const entries = await tennaDay(\"fuel-entries\", date);\n const tennaFills = entries.map((e: any) => ({\n unit: base(e.asset_fleet), fleet: String(e.asset_fleet),\n gal: Number(e.gallons) || 0, at: String(e.pumped_at_time ?? \"\"),\n meter: e.fuel_entry_asset_hours == null ? null : Number(e.fuel_entry_asset_hours),\n }));\n const tennaGal = Math.round(tennaFills.reduce((a, f) => a + f.gal, 0) * 10) / 10;\n const ourGal = trucks.reduce((a, t) => a + t.logged, 0);\n const notInApp = tennaFills.filter((f) => !hit.has(f.unit));\n if (notInApp.length) {\n findings.push({\n kind: \"tenna-only-fill\", severity: \"warn\", what: notInApp.length + \" fills\",\n detail: \"keyed into Tenna but not on our log: \"\n + notInApp.slice(0, 8).map((f) => f.fleet + \" \" + f.gal + \"g\").join(\", \"),\n });\n }\n\n // ---------- 5. METER READINGS vs TENNA ----------\n // `readings` is fetched up in section 3 now, so ranChecked() and this block\n // share one pull instead of walking the endpoint twice.\n const tHours: Record = {};\n for (const r of readings) {\n if (r.cumulative_hours_end_of_day != null) tHours[base(r.asset_fleet)] = Number(r.cumulative_hours_end_of_day);\n }\n const koff: Record = {};\n for (const r of rows(await sqlite.execute('SELECT unit, \"offset\" AS o FROM fl_offset'))) {\n koff[base(r.unit)] = Number(r.o);\n }\n let checked = 0;\n for (const [u, h] of hit) {\n if (h.hours == null || tHours[u] == null) continue;\n checked++;\n const off = koff[u] ?? 0;\n const d = Math.round((h.hours - tHours[u] - off) * 10) / 10;\n if (Math.abs(d) >= 8) {\n findings.push({\n kind: \"hours-disagree\", severity: \"info\", what: h.unit,\n lines: [\n \"Fuel log: \" + nf(h.hours) + \"h\",\n \"Tenna end-of-day: \" + nf(tHours[u]) + \"h\",\n \"Difference: \" + (d > 0 ? \"+\" : \"\") + nf(d) + \"h\",\n ].concat(off ? [\"Known offset applied: \" + (off > 0 ? \"+\" : \"\") + off + \"h\"] : []),\n detail: \"we wrote \" + h.hours + \"h, Tenna ended the day at \" + (Math.round(tHours[u] * 10) / 10) + \"h\"\n + (off ? \" (known offset \" + off + \"h applied)\" : \"\") + \" — \" + (d > 0 ? \"+\" : \"\") + d + \"h apart\",\n });\n }\n }\n\n // ---------- 5b. THE METER KEYED WITH EACH FILL ----------\n // Every on-site fill carries a hand-keyed meter, and Tenna's readings feed\n // carries the tracker's own end-of-day figure. Built 8/19 after a no-app\n // day proved the pair catches three different failures the other checks\n // miss. Expected shape: keyed-at-fill sits AT or a few hours BELOW the\n // end-of-day reading (the machine keeps working after its fill) — that gap\n // is information, not error. What gets flagged:\n // · two identical entries (same gal, same meter) minutes apart — the\n // double-tap the geofence-based dupe detector can't see (512/2, 8/19)\n // · a keyed meter that exactly matches a STUCK tracker — the fueler\n // accepted Tenna's pre-fill instead of reading the dash (607/2, 8/19)\n // · keyed above where the day ended, or >24h below it — a typo, or the\n // stored offset is wrong (306/2's +85h offset died this way, 8/19)\n {\n const sortedFills = tennaFills.slice().sort((a, b) => a.at.localeCompare(b.at));\n const doubled = new Set();\n for (let i = 0; i < sortedFills.length; i++) {\n const a = sortedFills[i];\n for (let k = i + 1; k < sortedFills.length; k++) {\n const b = sortedFills[k];\n if (Date.parse(b.at) - Date.parse(a.at) > 15 * 60000) break;\n if (b.fleet !== a.fleet || doubled.has(a.fleet)) continue;\n if (Math.abs(b.gal - a.gal) > 0.5) continue;\n if (a.meter == null || b.meter == null || a.meter !== b.meter) continue;\n doubled.add(a.fleet);\n findings.push({\n kind: \"fill-double-key\", severity: \"warn\", what: a.fleet,\n detail: \"two identical fuel entries (\" + a.gal + \" gal, meter \" + a.meter + \") minutes apart — \"\n + \"looks like a double-tap; if one fill was real the day is \" + a.gal + \" gal over\",\n });\n }\n }\n const stuck = new Set(ran.filter((r) => r.flag === \"meter-stuck\").map((r) => r.unit));\n // A hand-keyed dash read on OUR log (the fueler's, or a manager keying the\n // paper log after the fact) beats the meter riding on Tenna's entry, which\n // is often just Tenna's pre-fill accepted untouched. Before the paper\n // started getting keyed in, this check compared Tenna's number to Tenna's\n // number and cried wolf on every machine with a real offset (306/2, 8/20).\n const appH: Record = {};\n for (const x of rows(await sqlite.execute({\n sql: `SELECT m.unit u, m.hours h FROM fl_mach m JOIN fl_job j ON j.id = m.job_id\n WHERE j.date = ? AND m.hours IS NOT NULL`,\n args: [date],\n }))) appH[String(x.u)] = Number(x.h);\n const checkedFills = new Set();\n for (const f of sortedFills) {\n if (f.meter == null || checkedFills.has(f.fleet + \"|\" + f.meter)) continue;\n checkedFills.add(f.fleet + \"|\" + f.meter);\n const eod = tHours[f.unit];\n if (eod == null) continue; // no reading to check against (today's batch not landed yet)\n const dash = appH[f.fleet];\n if (stuck.has(f.unit)) {\n // the tracker is dead — comparing anything to its end-of-day figure\n // proves nothing. Say what the dash showed, if anyone read it.\n if (dash != null && Math.abs(dash - eod) > 0.5) {\n findings.push({\n kind: \"fill-meter-prefilled\", severity: \"info\", what: f.fleet,\n detail: \"the dash read \" + dash + \" at this fill while the stuck tracker sat at \" + (Math.round(eod * 10) / 10)\n + \" — the dash is alive; the tracker is what's blind\",\n });\n } else if (Math.abs(f.meter - eod) < 0.2) {\n findings.push({\n kind: \"fill-meter-prefilled\", severity: \"warn\", what: f.fleet,\n detail: \"the meter keyed with this fill (\" + f.meter + \") matches the STUCK tracker exactly — \"\n + \"that is Tenna's pre-fill accepted, not a reading off the dash; this machine's hours are still blind\",\n });\n }\n continue;\n }\n const use = dash != null ? dash : f.meter;\n const lbl = dash != null ? \"dash meter \" : \"fill keyed meter \";\n const off = koff[f.unit] ?? 0;\n const d = Math.round((use - eod - off) * 10) / 10;\n if (d > 2) {\n findings.push({\n kind: \"fill-meter-off\", severity: \"warn\", what: f.fleet,\n lines: [\n (dash != null ? \"Fuel log: \" : \"Fill keyed meter: \") + nf(use) + \"h\",\n \"Tenna end-of-day: \" + nf(eod) + \"h\",\n \"Difference: +\" + nf(d) + \"h — a fill cannot sit ahead of the day's end\",\n ].concat(off ? [\"Known offset applied: \" + (off > 0 ? \"+\" : \"\") + off + \"h\"] : []),\n detail: lbl + use + \" but Tenna's tracker ended the day at \" + (Math.round(eod * 10) / 10)\n + (off ? \" (offset \" + (off > 0 ? \"+\" : \"\") + off + \" applied)\" : \"\")\n + \" — a fill can't sit ahead of the day's end; typo, or the offset is wrong\",\n });\n } else if (d < -24) {\n findings.push({\n kind: \"fill-meter-off\", severity: \"warn\", what: f.fleet,\n lines: [\n (dash != null ? \"Fuel log: \" : \"Fill keyed meter: \") + nf(use) + \"h\",\n \"Tenna end-of-day: \" + nf(eod) + \"h\",\n \"Difference: \" + nf(d) + \"h — more than a full day's run apart\",\n ].concat(off ? [\"Known offset applied: \" + (off > 0 ? \"+\" : \"\") + off + \"h\"] : []),\n detail: lbl + use + \", Tenna's tracker ended the day at \" + (Math.round(eod * 10) / 10)\n + (off ? \" (offset \" + (off > 0 ? \"+\" : \"\") + off + \" applied)\" : \"\")\n + \" — \" + d + \"h apart, more than a full day's run; typo, or the stored offset is wrong\",\n });\n }\n }\n }\n\n // ---------- 5c. A KEYED METER THAT CANNOT BE TRUE ----------\n // Deliberately the ONE meter check on this screen that needs no external\n // source. 8/26 proved why: asset-readings-daily came back empty and every\n // check in 5 and 5b silently did nothing, while 801/2 sat on the log keyed\n // 391h ahead of its own tracker. See fuel_meterflag.ts.\n //\n // It is also the check a manager can actually ACT on, so it is aimed at the\n // field he edits rather than at a paragraph: the same flags ride on\n // /api/fuel/histlog and mark the machine's row on the fix screen.\n try {\n const { keyedMeterFlags } = await import(\"./fuel_meterflag.ts\");\n const mflags = await keyedMeterFlags(date);\n for (const u of Object.keys(mflags)) {\n const f = mflags[u];\n findings.push({\n kind: \"keyed-meter-impossible\",\n severity: f.level,\n what: f.unit,\n lines: f.lines,\n detail: f.why,\n });\n }\n } catch (e) {\n console.log(\"yesterday: keyed-meter check unavailable — \" + String(e).slice(0, 200));\n }\n\n // ---------- 6. THE ROUTE ITSELF ----------\n const stops = rows(await sqlite.execute({\n sql: `SELECT j.id, j.truck, j.jobname, j.ord, j.closed_at,\n (SELECT COUNT(*) FROM fl_mach m WHERE m.job_id = j.id) mach,\n (SELECT COUNT(*) FROM fl_mach m WHERE m.job_id = j.id AND m.gal IS NOT NULL) fuelled\n FROM fl_job j WHERE j.date = ? ORDER BY j.truck, j.ord`,\n args: [date],\n })).map((r: any) => ({\n truck: String(r.truck), site: String(r.jobname), ord: Number(r.ord),\n machines: Number(r.mach), fuelled: Number(r.fuelled), closed: !!r.closed_at,\n }));\n for (const s of stops) {\n if (!s.closed) {\n findings.push({ kind: \"stop-not-closed\", severity: \"warn\", what: s.truck + \" · \" + s.site, detail: \"never closed this stop out\" });\n } else if (s.machines && !s.fuelled) {\n findings.push({ kind: \"stop-nothing-done\", severity: \"info\", what: s.truck + \" · \" + s.site, detail: \"closed with \" + s.machines + \" machines and no fuel logged against any of them\" });\n }\n }\n\n const order = { bad: 0, warn: 1, info: 2 } as Record;\n findings.sort((a, b) => order[a.severity] - order[b.severity]);\n\n // A DAY WITH NOTHING IN IT IS NOT A DAY THAT CHECKS OUT.\n // Stepping back to a Saturday first showed \"Everything lines up — every\n // source agrees\", which is the exact failure this screen exists to avoid:\n // absence of evidence rendered as agreement. If no truck went out, no stop\n // was logged and nothing ran, say so plainly and drop the source warnings —\n // an empty Tenna feed on a day nobody worked is not a fault.\n const quiet = !trucks.length && !stops.length && !ran.length;\n if (quiet) findings.length = 0;\n\n // ---------- 7. WHAT A MANAGER ALREADY DECIDED ABOUT EACH ONE ----------\n // The report itself is still recomputed from the four sources every time —\n // a decision NEVER suppresses a check, it only records that a human looked.\n // So a resolved exception that comes back tomorrow comes back: the finding\n // is regenerated, and it is the STATE that is looked up, not the finding.\n stampIds(findings);\n let history: any[] = [];\n try {\n const st: Record = {};\n for (const r of rows(await sqlite.execute({\n sql: \"SELECT eid, state, note, who, at FROM fl_exc WHERE day = ?\",\n args: [date],\n }))) st[String(r.eid)] = r;\n for (const f of findings) {\n const s = st[f.id!];\n f.state = s ? String(s.state) : \"open\";\n if (s) {\n f.note = String(s.note ?? \"\");\n f.stateBy = String(s.who ?? \"\");\n f.stateAt = String(s.at ?? \"\");\n }\n }\n // Every decision ever filed on this day, including ones whose exception no\n // longer fires — \"keep a record of what happened\" has to survive the\n // exception going away, or the record is only ever a record of open items.\n history = rows(await sqlite.execute({\n sql: `SELECT eid, state, prev, note, who, at, kind, severity, what, detail\n FROM fl_exc_log WHERE day = ? ORDER BY id DESC LIMIT 200`,\n args: [date],\n }));\n } catch (e) {\n // the store is an ADDITION to this screen; if it is missing or unhappy the\n // reconciliation must still render, with everything simply open\n console.log(\"yesterday: exception states unavailable — \" + String(e).slice(0, 200));\n for (const f of findings) if (!f.state) f.state = \"open\";\n }\n const openF = findings.filter((f) => f.state === \"open\" || f.state === \"reviewed\");\n const counts = {\n critical: openF.filter((f) => f.severity === \"bad\").length,\n review: openF.filter((f) => f.severity === \"warn\").length,\n info: openF.filter((f) => f.severity === \"info\").length,\n open: openF.length,\n handled: findings.length - openF.length,\n total: findings.length,\n };\n\n return {\n counts,\n history,\n date,\n quiet,\n trucks,\n stops,\n totals: {\n loggedGal: Math.round(ourGal * 10) / 10,\n tennaGal,\n machinesTouched: hit.size,\n machinesRan: ran.length,\n ranHours: Math.round(ran.reduce((a, r) => a + r.hours, 0) * 10) / 10,\n hoursChecked: checked,\n },\n // The \"Ran hardest\" list is for iron somebody might have missed. The 41xx\n // series — both fuel trucks and the dump/haul tractors — runs all day BY\n // being driven; hours are their job, not a signal (Kaden 8/22: \"These\n // should be removed from worked the hardest the fuel trucks and haul\n // trucks\"). Display-only filter: every cross-check above still sees them.\n ran: ran.filter((r) => !/^41\\d\\d$/.test(r.unit)).slice(0, 40),\n missed,\n findings,\n // did every source actually answer? A silent empty source must never read\n // as \"nothing was wrong\".\n sources: {\n app: true,\n tennaUtilization: util.length > 0,\n tennaFuelEntries: entries.length > 0,\n tennaReadings: readings.length > 0,\n },\n };\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"]