[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_105":106,"_107":108},"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","_fill19.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":36,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":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/_fill19.ts","extension","id","77f58adb-5247-4e17-8578-3e52f7317b6b","fileId","912ac364-9c3c-11f1-9ffe-1607ee4eb77e","parentId","branchId","1ba53fed-b2e4-413d-8a29-62afbe01b059","branchVersion",1626,"latest",true,"createdAt",["D",1787191937258],"version",0,"fileType","script","content","// HOW CLOSE WITHOUT THE APP (Kaden 8/19): nobody used the app today — fill\n// today's route cards from Tenna alone, using the nightly reconcile's EXACT\n// rules (gal only where NULL, tenna_hours where NULL, off-route stops\n// surfaced, dupes summed + notated). Deliberately NOT the full reconcile():\n// no snapshot (that belongs to 5 AM alone), no archive. Idempotent — the\n// real 5 AM run tomorrow sees gal already set and fills nothing twice.\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { rows } from \"./core.ts\";\nimport { assistantMap } from \"./fuel_reconcile.ts\";\n\nconst date = \"2026-08-19\";\nconst key = Deno.env.get(\"TENNA_KEY\") ?? \"\";\nconst FUELER_BY_FIRST: Record = { gustavo: \"Gustavo\", carlos: \"Carlos\", juan: \"Juan V\", makana: \"Makana\" };\nconst toPac = (iso: string) => new Date(Date.parse(iso) - 7 * 3600 * 1000).toISOString().slice(0, 10);\n\n// pull today's entries, keeping the raw first entry for a field check\nconst raw: any[] = [];\nfor (let off = 0; off < 1000; off += 100) {\n const r = await fetch(\"https://api.tenna.com/v1/fuel-entries?limit=100&offset=\" + off + \"&sort=-pumped_at_time\", {\n headers: { Authorization: \"Bearer \" + key },\n });\n if (!r.ok) break;\n const items: any[] = (await r.json()).results ?? [];\n if (!items.length) break;\n let past = false;\n for (const e of items) {\n const d = toPac(String(e.pumped_at_time ?? \"\"));\n if (d < date) { past = true; break; }\n if (d === date) raw.push(e);\n }\n if (past || items.length < 100) break;\n}\nconsole.log(\"today entries:\", raw.length);\nif (raw[0]) console.log(\"fields:\", Object.keys(raw[0]).join(\", \"));\n\ntype E = { fueler: string; first: string; unit: string; name: string; gal: number; hours: number | null; site: string; at: string };\nconst entries: E[] = [];\nlet noFueler = 0;\nfor (const e of raw) {\n const first = String(e.fueler_contact_first_name ?? \"\").trim().toLowerCase().split(\" \")[0];\n const fueler = FUELER_BY_FIRST[first] ?? \"\";\n const unit = String(e.asset_fleet ?? \"\").trim();\n const gal = parseFloat(String(e.gallons ?? \"\"));\n if (!unit || isNaN(gal)) continue;\n if (!fueler) { noFueler++; console.log(\" no fueler match:\", unit, gal + \"g, first_name=\" + JSON.stringify(e.fueler_contact_first_name)); continue; }\n entries.push({\n fueler, first, unit, name: String(e.asset_name ?? \"\").trim().slice(0, 80), gal,\n hours: e.fuel_entry_asset_hours != null ? Number(e.fuel_entry_asset_hours) : null,\n site: String(e.site_name ?? \"\").trim() || \"Unknown site\", at: String(e.pumped_at_time ?? \"\"),\n });\n}\nconst amap = await assistantMap(date);\nfor (const e of entries) { const drv = amap[date + \"|\" + e.fueler]; if (drv) e.fueler = drv; }\nconsole.log(\"usable:\", entries.length, \"· skipped (no fueler):\", noFueler);\nconsole.log(\"by fueler:\", JSON.stringify(entries.reduce((a: any, e) => (a[e.fueler] = (a[e.fueler] || 0) + 1, a), {})));\n\n// dupe detection — reconcile's exact signature\nconst dupeNote: Record = {};\n{\n const sorted = entries.slice().sort((a, b) => a.at.localeCompare(b.at));\n for (let i = 0; i < sorted.length; i++) {\n const a = sorted[i];\n if (a.site !== \"Unknown site\") continue;\n for (let k = i + 1; k < sorted.length; k++) {\n const b = sorted[k];\n if (Date.parse(b.at) - Date.parse(a.at) > 15 * 60000) break;\n if (b.unit !== a.unit || b.fueler !== a.fueler) continue;\n if (b.site !== \"Unknown site\" || Math.abs(b.gal - a.gal) > 1) continue;\n const hhmm = new Date(Date.parse(a.at) - 7 * 3600 * 1000).toISOString().slice(11, 16);\n dupeNote[a.fueler + \"|\" + a.unit] = \"⚠ possible Tenna duplicate — \" + a.unit + \" entered again (\"\n + a.gal + \" gal + \" + b.gal + \" gal) within minutes of \" + hhmm\n + \", no geofence site. If one fill was real, the meter tie shows the overage.\";\n }\n }\n}\n\n// group fueler -> unit -> summed\nconst byF: Record> = {};\nfor (const e of entries) {\n byF[e.fueler] = byF[e.fueler] ?? {};\n if (byF[e.fueler][e.unit]) { byF[e.fueler][e.unit].gal += e.gal; byF[e.fueler][e.unit].n++; }\n else byF[e.fueler][e.unit] = { ...e, n: 1 };\n}\n\n// truck resolution (reconcile's truckOf, inlined)\nasync function truckOf(person: string): Promise {\n const mine = rows(await sqlite.execute({ sql: \"SELECT truck FROM fl_day WHERE date = ? AND driver = ? LIMIT 1\", args: [date, person] }))[0];\n if (mine) return String(mine.truck);\n const on = rows(await sqlite.execute({\n sql: \"SELECT truck FROM fl_day WHERE date = ? UNION SELECT truck FROM fl_job WHERE date = ? AND truck <> ''\", args: [date, date],\n })).map((x) => String(x.truck)).filter(Boolean);\n if (on.length === 1) return on[0];\n const usual = rows(await sqlite.execute({ sql: \"SELECT truck FROM fl_day WHERE driver = ? AND truck <> '' ORDER BY date DESC LIMIT 1\", args: [person] }))[0];\n if (usual && on.includes(String(usual.truck))) return String(usual.truck);\n return usual ? String(usual.truck) : \"\";\n}\n\nlet filled = 0, extra = 0;\nfor (const fueler of Object.keys(byF)) {\n const truck = await truckOf(fueler);\n console.log(\"fueler\", fueler, \"-> truck\", JSON.stringify(truck));\n if (!truck) continue;\n const units = byF[fueler];\n const jobs = rows(await sqlite.execute({ sql: \"SELECT id, jobname FROM fl_job WHERE date = ? AND truck = ?\", args: [date, truck] }));\n if (!jobs.length) { console.log(\" no jobs for\", truck, \"— would build day (unexpected today)\"); continue; }\n const jids = jobs.map((j) => j.id);\n const machs = rows(await sqlite.execute({\n sql: \"SELECT id, unit, gal, tenna_hours FROM fl_mach WHERE job_id IN (\" + jids.map(() => \"?\").join(\",\") + \")\", args: jids,\n }));\n const seen = new Set();\n for (const m of machs) {\n const t = units[String(m.unit)];\n if (!t) continue;\n seen.add(String(m.unit));\n const newGal = m.gal == null ? Math.round(t.gal * 10) / 10 : null;\n const newTh = m.tenna_hours == null ? t.hours : null;\n if (newGal != null || newTh != null) {\n await sqlite.execute({\n sql: \"UPDATE fl_mach SET gal = COALESCE(?, gal), tenna_hours = COALESCE(?, tenna_hours), status = CASE WHEN COALESCE(status,'') = '' THEN 'fueled' ELSE status END WHERE id = ?\",\n args: [newGal, newTh, m.id],\n });\n filled++;\n }\n }\n const missing = Object.keys(units).filter((u) => !seen.has(u));\n if (missing.length) {\n const r = await sqlite.execute({\n sql: \"INSERT INTO fl_job (date, truck, ord, jobno, jobname, kind, added_by, closed_at, legacy_fueler) VALUES (?, ?, 99, '', 'Not on the route (Tenna)', 'job', 'Tenna', ?, '')\",\n args: [date, truck, new Date().toISOString()],\n });\n const jid = Number(r.lastInsertRowid);\n for (const u of missing) {\n const m = units[u];\n await sqlite.execute({\n sql: \"INSERT INTO fl_mach (job_id, unit, name, status, gal, tenna_hours, added) VALUES (?, ?, ?, 'fueled', ?, ?, 1)\",\n args: [jid, m.unit, m.name, Math.round(m.gal * 10) / 10, m.hours],\n });\n extra++;\n console.log(\" OFF-ROUTE on \" + truck + \": \" + u + \" \" + m.gal + \"g\");\n }\n }\n}\n// dupe notes\nlet notated = 0;\nfor (const k2 of Object.keys(dupeNote)) {\n const [fueler, unit] = k2.split(\"|\");\n const dTruck = await truckOf(fueler);\n if (!dTruck) continue;\n const m = rows(await sqlite.execute({\n sql: \"SELECT m.id, m.note FROM fl_mach m JOIN fl_job j ON j.id = m.job_id WHERE j.date = ? AND j.truck = ? AND m.unit = ? LIMIT 1\",\n args: [date, dTruck, unit],\n }))[0];\n if (!m || String(m.note ?? \"\").includes(\"Tenna duplicate\")) continue;\n await sqlite.execute({ sql: \"UPDATE fl_mach SET note = ? WHERE id = ?\", args: [((m.note ? m.note + \" \" : \"\") + dupeNote[k2]).slice(0, 400), m.id] });\n notated++;\n}\nconsole.log(\"FILLED:\", filled, \"· off-route adds:\", extra, \"· dupe notes:\", notated);\n\n// the scorecard\nconst after = rows(await sqlite.execute({\n sql: `SELECT j.truck, j.jobname, COUNT(m.id) mach, SUM(CASE WHEN m.gal IS NOT NULL THEN 1 ELSE 0 END) fueled, COALESCE(SUM(m.gal),0) gal\n FROM fl_job j LEFT JOIN fl_mach m ON m.job_id = j.id WHERE j.date = ? GROUP BY j.id ORDER BY j.truck, j.ord`,\n args: [date],\n}));\nfor (const s of after) console.log(\" \" + s.truck + \" > \" + s.jobname + \" — \" + s.fueled + \"/\" + s.mach + \" fueled · \" + Math.round(Number(s.gal) * 10) / 10 + \" gal\");\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","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,"_104":99},"org",{"_9":10,"_98":99,"_100":99,"_55":56,"_101":102,"_103":42},"branch",{"_35":88,"_11":89,"_22":28,"_90":45,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":12,"_97":10},"isOwned",2869,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","","avatar","tier","pro","canRestrictVals","profileImageUrl","ctx",{"_81":-5,"_138":139,"_140":141,"_142":143,"_144":42,"_145":42,"_146":42,"_147":32,"_148":-5,"_149":-7,"_150":-7,"_151":36,"_152":42,"_153":42,"_154":-5,"_155":42,"_156":42,"_157":42,"_158":-5},"ENV",{"_109":110,"_111":112,"_113":89,"_114":115,"_116":117,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135,"_136":137},"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"]