ADV160 Maintenance

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_322":323,"_324":325},"routes/_app.x.$handle.$name",{"_97":96,"_31":44,"_106":87,"_26":107,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":24,"_121":122,"_123":124,"_125":-5,"_126":-5,"_127":128},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":-5,"_56":24,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":68,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":24},"version",16,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","frontend/lib/format.ts","latestPath","fileId","27eb33b2-7f0d-11f1-a142-1607ee4eb77e","name","format.ts","fileType","script","content","export function money(currency: string, v: number | null | undefined): string {\n if (v == null) return \"—\";\n try {\n return new Intl.NumberFormat(undefined, { style: \"currency\", currency, maximumFractionDigits: 2 })\n .format(v);\n } catch (_) {\n return `${currency} ${v.toFixed(2)}`;\n }\n}\n\nexport function km(v: number | null | undefined): string {\n if (v == null) return \"—\";\n return `${Math.round(v).toLocaleString()} km`;\n}\n\nexport function fdate(s: string | null | undefined): string {\n if (!s) return \"—\";\n const d = new Date(`${String(s).slice(0, 10)}T00:00:00`);\n if (isNaN(d.getTime())) return String(s);\n return d.toLocaleDateString(undefined, { year: \"numeric\", month: \"short\", day: \"numeric\" });\n}\n\nexport function monthLabel(ym: string): string {\n const d = new Date(`${ym}-01T00:00:00`);\n if (isNaN(d.getTime())) return ym;\n return d.toLocaleDateString(undefined, { year: \"numeric\", month: \"short\" });\n}\n\nexport function num(v: number | null | undefined, digits = 1): string {\n if (v == null) return \"—\";\n return v.toLocaleString(undefined, { maximumFractionDigits: digits });\n}\n\nexport function todayISO(): string {\n return new Date().toISOString().slice(0, 10);\n}\n","createdAt",["D",1783982990612],"branchVersion","branchId","58afea27-3712-426c-ac55-6ff71fa69b2d","id","1f303e60-ab6b-42ff-8f49-6eb8e87de881","adv160-tracker",["D",1783982520711],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Honda ADV160 maintenance tracker (PWA)","imageUrl","49091ede-0c48-4a6b-bdf2-2c256984d2e3","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019ef139-9657-71ac-a5f0-37f41375e2b5","tursoName","1f303e60ab6b42ff8f496eb8e87de881","tursoHostname","1f303e60ab6b42ff8f496eb8e87de881-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789489305251],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_97":96,"_105":101},"org",{"_97":96,"_98":99,"_100":101,"_18":54,"_102":103,"_104":24},"branch",{"_13":86,"_31":87,"_42":41,"_88":43,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":44,"_95":96},"isOwned",158,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","joshuaballesta","handle","displayName","Joshua Ballesta","avatar","https://lh3.googleusercontent.com/a/ACg8ocIq5SbD8bqDShV77ZIQSf_McOeZWlWCW6SFQ5xEjysyl4FV0ftx=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":317,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":-5,"_56":24,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":318,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":319,"_81":320,"_83":321,"_85":24},"tree",[181,185,187,196,199],"files",[181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199],"counts",{"_171":60,"_172":141,"_173":60,"_174":175,"_176":177},"contents",[129,130,131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_42":165,"_31":166,"_29":167,"_137":-5,"_40":41,"_39":168,"_139":124,"_37":169,"_13":60,"_33":151,"_35":-5,"_23":24,"_144":-5,"_26":170},{"_42":159,"_31":160,"_29":161,"_137":-5,"_40":41,"_39":162,"_139":124,"_37":163,"_13":60,"_33":151,"_35":-5,"_23":24,"_144":-5,"_26":164},{"_42":153,"_31":154,"_29":155,"_137":-5,"_40":41,"_39":156,"_139":124,"_37":157,"_13":60,"_33":151,"_35":-5,"_23":24,"_144":-5,"_26":158},{"_42":146,"_31":147,"_29":148,"_137":-5,"_40":41,"_39":149,"_139":124,"_37":150,"_13":60,"_33":151,"_35":-5,"_23":24,"_144":-5,"_26":152},{"_42":134,"_31":135,"_29":136,"_137":-5,"_40":41,"_39":138,"_139":24,"_37":140,"_13":141,"_33":142,"_35":143,"_23":24,"_144":-5,"_26":145},"519d7c32-5e37-4455-b850-a92fb682e810","index.ts","0fdb1676-7f0c-11f1-8c45-1607ee4eb77e","parentId",8,"latest",["D",1783982809213],1,"http","/**\n * Honda ADV160 maintenance tracker — HTTP entry.\n * Serves the React PWA and a JSON API. All /api/* routes are gated by\n * \"Log in with Val Town\", restricted to the owner account.\n */\nimport { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport {\n getOAuthUserData,\n oauthMiddleware,\n} from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\nimport {\n getFuelLogs,\n getRecords,\n getServiceTypes,\n getSettings,\n getVehicle,\n ready,\n sqlite,\n} from \"./backend/db.ts\";\nimport { computeDue, dateOnly, estimateKmPerDay } from \"./backend/schedule.ts\";\nimport { runReminders } from \"./backend/reminders.ts\";\nimport { CATEGORIES } from \"./shared/schedule.ts\";\nimport type { FuelLog, ServiceRecord, ServiceType } from \"./shared/types.ts\";\n\nconst OWNER = \"joshuaballesta\";\n\nconst app = new Hono();\napp.onError((err) => Promise.reject(err));\n\n// ---------- Static frontend (public; contains no private data) ----------\napp.get(\"/\", () => serveFile(\"/frontend/index.html\"));\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\napp.get(\"/shared/**/*\", (c) => serveFile(c.req.path));\napp.get(\"/sw.js\", () => serveFile(\"/frontend/sw.js\"));\napp.get(\"/manifest.json\", () => serveFile(\"/frontend/manifest.json\"));\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// ---------- Auth gate for the whole API ----------\napp.use(\"/api/*\", async (c, next) => {\n const session = await getOAuthUserData(c.req.raw);\n if (!session?.user) {\n return c.json({ error: \"unauthorized\", login: \"/auth/login\" }, 401);\n }\n if (session.user.username !== OWNER) {\n return c.json({ error: \"forbidden\" }, 403);\n }\n await next();\n});\n\n// ---------- Helpers ----------\nfunction n(x: unknown): number | null {\n if (x === \"\" || x === null || x === undefined) return null;\n const v = Number(x);\n return Number.isFinite(v) ? v : null;\n}\nfunction reqNum(x: unknown, fallback = 0): number {\n const v = n(x);\n return v == null ? fallback : v;\n}\nfunction s(x: unknown): string {\n return x == null ? \"\" : String(x);\n}\n\nconst EXT_MIME: Record = {\n jpg: \"image/jpeg\",\n jpeg: \"image/jpeg\",\n png: \"image/png\",\n webp: \"image/webp\",\n gif: \"image/gif\",\n};\n\nfunction extFor(mime: string): string {\n if (mime.includes(\"png\")) return \"png\";\n if (mime.includes(\"webp\")) return \"webp\";\n if (mime.includes(\"gif\")) return \"gif\";\n return \"jpg\";\n}\n\nfunction dataUrlToBytes(dataUrl: string): { bytes: Uint8Array; mime: string } | null {\n const m = /^data:([^;]+);base64,(.*)$/s.exec(dataUrl);\n if (!m) return null;\n const mime = m[1];\n const bin = atob(m[2]);\n const bytes = new Uint8Array(bin.length);\n for (let i = 0; i < bin.length; i++) bytes[i] = bin.charCodeAt(i);\n return { bytes, mime };\n}\n\nasync function storePhotos(dataUrls: string[]): Promise {\n const keys: string[] = [];\n for (const url of dataUrls.slice(0, 6)) {\n const parsed = dataUrlToBytes(url);\n if (!parsed) continue;\n const ext = extFor(parsed.mime);\n const key = `photo:${Date.now()}-${Math.random().toString(36).slice(2, 8)}.${ext}`;\n await blob.set(key, parsed.bytes);\n keys.push(key);\n }\n return keys;\n}\n\nasync function deletePhotos(keys: string[]): Promise {\n for (const k of keys) {\n try {\n await blob.delete(k);\n } catch (_) { /* ignore missing */ }\n }\n}\n\n// Bump the vehicle's current odometer if a newer/higher reading arrives.\nasync function maybeAdvanceOdometer(km: number | null, when: string): Promise {\n if (km == null) return;\n const v = await getVehicle();\n if (km > v.current_odometer_km) {\n await sqlite.execute({\n sql: \"UPDATE vehicle SET current_odometer_km = ?, odometer_updated_at = ? WHERE id = 1\",\n args: [km, new Date().toISOString()],\n });\n await sqlite.execute({\n sql: \"INSERT INTO odometer_readings (km, recorded_at) VALUES (?, ?)\",\n args: [km, dateOnly(when) || new Date().toISOString().slice(0, 10)],\n });\n }\n}\n\n// Fuel economy between consecutive full-tank fills (km per liter).\nfunction fuelEconomy(fuel: FuelLog[]) {\n const asc = [...fuel].sort((a, b) => a.odometer_km - b.odometer_km);\n const segments: { from_km: number; to_km: number; distance: number; liters: number; km_per_l: number; date: string }[] = [];\n let lastFull: FuelLog | null = null;\n let litersSinceFull = 0;\n for (const f of asc) {\n if (lastFull) litersSinceFull += f.liters;\n if (f.is_full_tank === 1) {\n if (lastFull) {\n const distance = f.odometer_km - lastFull.odometer_km;\n if (distance > 0 && litersSinceFull > 0) {\n segments.push({\n from_km: lastFull.odometer_km,\n to_km: f.odometer_km,\n distance,\n liters: litersSinceFull,\n km_per_l: distance / litersSinceFull,\n date: f.filled_at,\n });\n }\n }\n lastFull = f;\n litersSinceFull = 0;\n }\n }\n const totalDist = segments.reduce((a, x) => a + x.distance, 0);\n const totalLiters = segments.reduce((a, x) => a + x.liters, 0);\n return {\n segments,\n average_km_per_l: totalLiters > 0 ? totalDist / totalLiters : null,\n };\n}\n\nfunction costSummary(\n records: ServiceRecord[],\n fuel: FuelLog[],\n types: ServiceType[],\n) {\n const catById = new Map(types.map((t) => [t.id, t.category]));\n const serviceTotal = records.reduce((a, r) => a + (r.cost ?? 0), 0);\n const fuelTotal = fuel.reduce(\n (a, f) => a + (f.total_cost ?? (f.price_per_liter ? f.price_per_liter * f.liters : 0)),\n 0,\n );\n const byMonth: Record = {};\n const add = (month: string, key: \"service\" | \"fuel\", amt: number) => {\n if (!amt) return;\n byMonth[month] ??= { service: 0, fuel: 0 };\n byMonth[month][key] += amt;\n };\n for (const r of records) add((r.performed_at || \"\").slice(0, 7), \"service\", r.cost ?? 0);\n for (const f of fuel) {\n add((f.filled_at || \"\").slice(0, 7), \"fuel\", f.total_cost ?? (f.price_per_liter ? f.price_per_liter * f.liters : 0));\n }\n const byCategory: Record = {};\n for (const r of records) {\n if (!r.cost) continue;\n const cat = r.service_type_id != null ? (catById.get(r.service_type_id) ?? \"Other\") : \"Other\";\n byCategory[cat] = (byCategory[cat] ?? 0) + r.cost;\n }\n return {\n service_total: serviceTotal,\n fuel_total: fuelTotal,\n total: serviceTotal + fuelTotal,\n by_month: byMonth,\n by_category: byCategory,\n };\n}\n\n// Full application state — returned on load and after each mutation.\nasync function buildState() {\n await ready();\n const [vehicle, settings, serviceTypes, records, fuel] = await Promise.all([\n getVehicle(),\n getSettings(),\n getServiceTypes(),\n getRecords(),\n getFuelLogs(),\n ]);\n const readingsRes = await sqlite.execute(\n \"SELECT km, recorded_at FROM odometer_readings ORDER BY recorded_at\",\n );\n const readings = readingsRes.rows.map((r) => ({\n km: Number(r.km),\n recorded_at: String(r.recorded_at),\n }));\n const kmPerDay = estimateKmPerDay(vehicle, readings);\n const due = computeDue(vehicle, settings, serviceTypes, records, kmPerDay);\n return {\n vehicle,\n settings,\n service_types: serviceTypes,\n records,\n fuel,\n due,\n km_per_day: kmPerDay,\n fuel_economy: fuelEconomy(fuel),\n costs: costSummary(records, fuel, serviceTypes),\n categories: CATEGORIES,\n };\n}\n\n// ---------- API routes ----------\napp.get(\"/api/bootstrap\", async (c) => c.json(await buildState()));\n\napp.put(\"/api/vehicle\", async (c) => {\n const b = await c.req.json();\n await sqlite.execute({\n sql: `UPDATE vehicle SET name=?, make=?, model=?, year=?, plate=?, color=?,\n baseline_odometer_km=?, baseline_date=? WHERE id=1`,\n args: [\n s(b.name),\n s(b.make),\n s(b.model),\n n(b.year),\n s(b.plate),\n s(b.color),\n reqNum(b.baseline_odometer_km),\n dateOnly(s(b.baseline_date)) || new Date().toISOString().slice(0, 10),\n ],\n });\n return c.json(await buildState());\n});\n\napp.post(\"/api/odometer\", async (c) => {\n const b = await c.req.json();\n const km = n(b.km);\n if (km == null) return c.json({ error: \"km required\" }, 400);\n const when = dateOnly(s(b.recorded_at)) || new Date().toISOString().slice(0, 10);\n await sqlite.execute({\n sql: \"INSERT INTO odometer_readings (km, recorded_at) VALUES (?, ?)\",\n args: [km, when],\n });\n await sqlite.execute({\n sql: \"UPDATE vehicle SET current_odometer_km=?, odometer_updated_at=? WHERE id=1\",\n args: [km, new Date().toISOString()],\n });\n return c.json(await buildState());\n});\n\napp.post(\"/api/service-types\", async (c) => {\n const b = await c.req.json();\n await sqlite.execute({\n sql: `INSERT INTO service_types\n (service_key, name, category, interval_km, interval_months, first_km, first_months, enabled, note)\n VALUES (NULL, ?, ?, ?, ?, ?, ?, 1, ?)`,\n args: [\n s(b.name) || \"Custom service\",\n s(b.category) || \"Other\",\n n(b.interval_km),\n n(b.interval_months),\n n(b.first_km),\n n(b.first_months),\n s(b.note),\n ],\n });\n return c.json(await buildState());\n});\n\napp.put(\"/api/service-types/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const b = await c.req.json();\n await sqlite.execute({\n sql: `UPDATE service_types SET name=?, category=?, interval_km=?, interval_months=?,\n first_km=?, first_months=?, enabled=?, note=? WHERE id=?`,\n args: [\n s(b.name),\n s(b.category) || \"Other\",\n n(b.interval_km),\n n(b.interval_months),\n n(b.first_km),\n n(b.first_months),\n b.enabled ? 1 : 0,\n s(b.note),\n id,\n ],\n });\n return c.json(await buildState());\n});\n\napp.delete(\"/api/service-types/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n await sqlite.execute({ sql: \"DELETE FROM service_types WHERE id=?\", args: [id] });\n return c.json(await buildState());\n});\n\n// Snooze reminders for a service type by 7 days (marks it reminded now).\napp.post(\"/api/service-types/:id/snooze\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n await sqlite.execute({\n sql: \"UPDATE service_types SET last_reminder_sent_at=? WHERE id=?\",\n args: [new Date().toISOString(), id],\n });\n return c.json(await buildState());\n});\n\napp.post(\"/api/records\", async (c) => {\n const b = await c.req.json();\n const photos: string[] = Array.isArray(b.photos) ? b.photos : [];\n const keys = await storePhotos(photos);\n const km = n(b.odometer_km);\n const performed = dateOnly(s(b.performed_at)) || new Date().toISOString().slice(0, 10);\n await sqlite.execute({\n sql: `INSERT INTO service_records\n (service_type_id, name, performed_at, odometer_km, cost, notes, photo_keys, created_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n n(b.service_type_id),\n s(b.name) || \"Service\",\n performed,\n km,\n n(b.cost),\n s(b.notes),\n JSON.stringify(keys),\n new Date().toISOString(),\n ],\n });\n await maybeAdvanceOdometer(km, performed);\n return c.json(await buildState());\n});\n\napp.delete(\"/api/records/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const r = await sqlite.execute({\n sql: \"SELECT photo_keys FROM service_records WHERE id=?\",\n args: [id],\n });\n if (r.rows[0]) {\n try {\n await deletePhotos(JSON.parse(String(r.rows[0].photo_keys) || \"[]\"));\n } catch (_) { /* ignore */ }\n }\n await sqlite.execute({ sql: \"DELETE FROM service_records WHERE id=?\", args: [id] });\n return c.json(await buildState());\n});\n\napp.post(\"/api/fuel\", async (c) => {\n const b = await c.req.json();\n const km = n(b.odometer_km);\n const liters = n(b.liters);\n if (km == null || liters == null) return c.json({ error: \"odometer_km and liters required\" }, 400);\n const ppl = n(b.price_per_liter);\n const total = n(b.total_cost) ?? (ppl != null ? ppl * liters : null);\n const filled = dateOnly(s(b.filled_at)) || new Date().toISOString().slice(0, 10);\n await sqlite.execute({\n sql: `INSERT INTO fuel_logs\n (filled_at, odometer_km, liters, price_per_liter, total_cost, is_full_tank, notes, created_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n filled,\n km,\n liters,\n ppl,\n total,\n b.is_full_tank === false ? 0 : 1,\n s(b.notes),\n new Date().toISOString(),\n ],\n });\n await maybeAdvanceOdometer(km, filled);\n return c.json(await buildState());\n});\n\napp.delete(\"/api/fuel/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n await sqlite.execute({ sql: \"DELETE FROM fuel_logs WHERE id=?\", args: [id] });\n return c.json(await buildState());\n});\n\napp.put(\"/api/settings\", async (c) => {\n const b = await c.req.json();\n await sqlite.execute({\n sql: `UPDATE settings SET reminder_lead_days=?, reminder_lead_km=?, currency=?, timezone=?, email=? WHERE id=1`,\n args: [\n reqNum(b.reminder_lead_days, 7),\n reqNum(b.reminder_lead_km, 200),\n s(b.currency) || \"PHP\",\n s(b.timezone) || \"Asia/Manila\",\n s(b.email),\n ],\n });\n return c.json(await buildState());\n});\n\n// Manually trigger the reminder email (for testing the email path).\napp.post(\"/api/send-reminder\", async (c) => {\n const result = await runReminders(true);\n return c.json(result);\n});\n\n// Serve a stored photo (auth-gated by the /api/* middleware).\napp.get(\"/api/photos/:key\", async (c) => {\n const key = c.req.param(\"key\");\n try {\n const res = await blob.get(key);\n const ext = key.split(\".\").pop()?.toLowerCase() ?? \"jpg\";\n const bytes = await res.arrayBuffer();\n return new Response(bytes, {\n headers: {\n \"Content-Type\": EXT_MIME[ext] ?? \"application/octet-stream\",\n \"Cache-Control\": \"private, max-age=86400\",\n },\n });\n } catch (_) {\n return c.json({ error: \"not found\" }, 404);\n }\n});\n\nexport default oauthMiddleware(app.fetch);\n","label",[135],"c4c3ea31-fbd0-44f4-8894-8c3685d3b941","shared","5d0b691e-d378-4a63-921e-5f1b6586c89e",2,["D",1783982540199],"directory",[147],"0387f0c2-b02a-4a5d-b98e-8eecf3f47c0c","frontend","0a32be25-01b2-402c-8164-5bf113cfeef5",10,["D",1783982946331],[154],"708696d0-6c9f-4e35-8a47-3219afefd46b","cron","4dbacbf6-905c-45ec-b40a-702b9456ef85",9,["D",1783982824101],[160],"dc27a954-22e0-47fc-b8ad-3b4d86ada28d","backend","977ebdc0-ab7e-4b24-8641-5c8d6c6d9182",4,["D",1783982589287],[166],"pulls","branches","forks","envVars",{"_178":141,"_180":60},"connections",{"_178":60,"_179":60},"count","unfilledCount","emptyCount",{"_42":165,"_31":166,"_29":167,"_137":-5,"_40":41,"_39":168,"_139":124,"_37":314,"_13":60,"_33":151,"_35":-5,"_23":24,"_144":-5,"_201":315,"_26":316},{"_42":307,"_31":308,"_29":309,"_137":167,"_40":41,"_39":168,"_139":24,"_37":310,"_13":60,"_33":34,"_35":311,"_23":24,"_144":-5,"_201":312,"_26":313},{"_42":300,"_31":283,"_29":301,"_137":167,"_40":41,"_39":302,"_139":24,"_37":303,"_13":141,"_33":34,"_35":304,"_23":24,"_144":-5,"_201":305,"_26":306},{"_42":293,"_31":213,"_29":294,"_137":167,"_40":41,"_39":295,"_139":24,"_37":296,"_13":60,"_33":34,"_35":297,"_23":24,"_144":-5,"_201":298,"_26":299},{"_42":159,"_31":160,"_29":161,"_137":-5,"_40":41,"_39":162,"_139":124,"_37":290,"_13":60,"_33":151,"_35":-5,"_23":24,"_144":-5,"_201":291,"_26":292},{"_42":282,"_31":283,"_29":284,"_137":161,"_40":41,"_39":162,"_139":124,"_37":285,"_13":60,"_33":286,"_35":287,"_23":24,"_144":-5,"_201":288,"_26":289},{"_42":153,"_31":154,"_29":155,"_137":-5,"_40":41,"_39":156,"_139":124,"_37":279,"_13":60,"_33":151,"_35":-5,"_23":24,"_144":-5,"_201":280,"_26":281},{"_42":275,"_31":266,"_29":262,"_137":155,"_40":41,"_39":270,"_139":124,"_37":276,"_13":60,"_33":151,"_35":-5,"_23":24,"_144":-5,"_201":277,"_26":278},{"_42":267,"_31":268,"_29":269,"_137":262,"_40":41,"_39":270,"_139":24,"_37":271,"_13":60,"_33":34,"_35":272,"_23":24,"_144":-5,"_201":273,"_26":274},{"_42":261,"_31":32,"_29":30,"_137":262,"_40":41,"_39":14,"_139":124,"_37":263,"_13":60,"_33":34,"_35":36,"_23":24,"_144":-5,"_201":264,"_26":265},{"_42":253,"_31":254,"_29":255,"_137":155,"_40":41,"_39":256,"_139":124,"_37":257,"_13":60,"_33":34,"_35":258,"_23":24,"_144":-5,"_201":259,"_26":260},{"_42":245,"_31":246,"_29":247,"_137":155,"_40":41,"_39":248,"_139":24,"_37":249,"_13":60,"_33":20,"_35":250,"_23":24,"_144":-5,"_201":251,"_26":252},{"_42":238,"_31":239,"_29":240,"_137":155,"_40":41,"_39":156,"_139":24,"_37":241,"_13":60,"_33":20,"_35":242,"_23":24,"_144":-5,"_201":243,"_26":244},{"_42":230,"_31":231,"_29":232,"_137":155,"_40":41,"_39":233,"_139":24,"_37":234,"_13":60,"_33":20,"_35":235,"_23":24,"_144":-5,"_201":236,"_26":237},{"_42":222,"_31":223,"_29":224,"_137":155,"_40":41,"_39":225,"_139":24,"_37":226,"_13":60,"_33":34,"_35":227,"_23":24,"_144":-5,"_201":228,"_26":229},{"_42":146,"_31":147,"_29":148,"_137":-5,"_40":41,"_39":149,"_139":124,"_37":219,"_13":60,"_33":151,"_35":-5,"_23":24,"_144":-5,"_201":220,"_26":221},{"_42":212,"_31":213,"_29":214,"_137":148,"_40":41,"_39":149,"_139":24,"_37":215,"_13":60,"_33":34,"_35":216,"_23":24,"_144":-5,"_201":217,"_26":218},{"_42":204,"_31":205,"_29":206,"_137":148,"_40":41,"_39":207,"_139":24,"_37":208,"_13":60,"_33":34,"_35":209,"_23":24,"_144":-5,"_201":210,"_26":211},{"_42":134,"_31":135,"_29":136,"_137":-5,"_40":41,"_39":138,"_139":24,"_37":200,"_13":141,"_33":142,"_35":143,"_23":24,"_144":-5,"_201":202,"_26":203},["D",1783982809213],"children",[],[135],"9c339fe4-098a-4309-9bf3-361a1028cb33","types.ts","1fb2d476-7f0c-11f1-b04b-1607ee4eb77e",3,["D",1783982547320],"// Shared TypeScript types used by both the backend and the browser frontend.\n\nexport interface Vehicle {\n id: number;\n name: string;\n make: string;\n model: string;\n year: number | null;\n plate: string;\n color: string;\n baseline_odometer_km: number;\n baseline_date: string; // ISO date (yyyy-mm-dd)\n current_odometer_km: number;\n odometer_updated_at: string; // ISO datetime\n}\n\nexport interface Settings {\n id: number;\n reminder_lead_days: number;\n reminder_lead_km: number;\n currency: string;\n timezone: string;\n email: string;\n}\n\nexport interface ServiceType {\n id: number;\n service_key: string | null;\n name: string;\n category: string;\n interval_km: number | null;\n interval_months: number | null;\n first_km: number | null;\n first_months: number | null;\n enabled: number; // 0 | 1\n note: string;\n last_reminder_sent_at: string | null;\n}\n\nexport interface ServiceRecord {\n id: number;\n service_type_id: number | null;\n name: string;\n performed_at: string; // ISO date\n odometer_km: number | null;\n cost: number | null;\n notes: string;\n photo_keys: string[];\n created_at: string;\n}\n\nexport interface FuelLog {\n id: number;\n filled_at: string; // ISO date\n odometer_km: number;\n liters: number;\n price_per_liter: number | null;\n total_cost: number | null;\n is_full_tank: number; // 0 | 1\n notes: string;\n created_at: string;\n}\n\nexport type DueStatus = \"overdue\" | \"due_soon\" | \"ok\" | \"unknown\";\n\nexport interface DueInfo {\n service_type_id: number;\n name: string;\n category: string;\n enabled: boolean;\n last_done_km: number | null;\n last_done_date: string | null;\n next_due_km: number | null;\n next_due_date: string | null;\n km_remaining: number | null;\n days_remaining: number | null;\n projected_due_date: string | null;\n status: DueStatus;\n reason: string;\n}\n",[],[147,205],"778e39ec-ebf4-49d6-afd0-904c468ded88","schedule.ts","1b755bae-7f0c-11f1-84c2-1607ee4eb77e",["D",1783982540199],"// Default Honda ADV160 maintenance schedule.\n// \"confirmed\" = from Honda's official ADV160 owner's manual / maintenance schedule.\n// \"est.\" = sensible default; verify against your owner's manual (regional manuals differ)\n// and edit in Settings. Every interval here is user-editable in the app.\n\nexport interface DefaultService {\n key: string;\n name: string;\n category: string;\n interval_km: number | null;\n interval_months: number | null;\n first_km: number | null;\n first_months: number | null;\n note: string;\n}\n\nexport const DEFAULT_SERVICES: DefaultService[] = [\n {\n key: \"engine_oil\",\n name: \"Engine oil\",\n category: \"Engine\",\n interval_km: 6000,\n interval_months: 12,\n first_km: 1000,\n first_months: 1,\n note: \"Confirmed: first change at 1,000 km, then every 6,000 km. Time interval is a common default.\",\n },\n {\n key: \"oil_filter\",\n name: \"Engine oil filter\",\n category: \"Engine\",\n interval_km: 12000,\n interval_months: 24,\n first_km: 1000,\n first_months: null,\n note: \"Estimated — verify with owner's manual.\",\n },\n {\n key: \"valve_clearance\",\n name: \"Valve clearance (inspect)\",\n category: \"Engine\",\n interval_km: 24000,\n interval_months: null,\n first_km: null,\n first_months: null,\n note: \"Confirmed: inspect every 24,000 km.\",\n },\n {\n key: \"drive_belt\",\n name: \"Drive belt (inspect)\",\n category: \"Transmission\",\n interval_km: 24000,\n interval_months: null,\n first_km: null,\n first_months: null,\n note: \"Confirmed: inspect every 24,000 km.\",\n },\n {\n key: \"final_drive_oil\",\n name: \"Final drive (gear) oil\",\n category: \"Transmission\",\n interval_km: 12000,\n interval_months: 24,\n first_km: null,\n first_months: null,\n note: \"Time interval confirmed (every 2 years); km is a common default.\",\n },\n {\n key: \"spark_plug\",\n name: \"Spark plug\",\n category: \"Engine\",\n interval_km: 24000,\n interval_months: null,\n first_km: null,\n first_months: null,\n note: \"Estimated — verify with owner's manual.\",\n },\n {\n key: \"air_cleaner\",\n name: \"Air cleaner\",\n category: \"Engine\",\n interval_km: 12000,\n interval_months: null,\n first_km: null,\n first_months: null,\n note: \"Estimated — verify with owner's manual.\",\n },\n {\n key: \"brake_fluid\",\n name: \"Brake fluid\",\n category: \"Brakes\",\n interval_km: null,\n interval_months: 24,\n first_km: null,\n first_months: null,\n note: \"Every 2 years (common default).\",\n },\n {\n key: \"coolant\",\n name: \"Coolant\",\n category: \"Cooling\",\n interval_km: 24000,\n interval_months: 36,\n first_km: null,\n first_months: null,\n note: \"Estimated — verify with owner's manual.\",\n },\n {\n key: \"general_inspection\",\n name: \"General inspection (brakes, tires, lights, bolts)\",\n category: \"General\",\n interval_km: 6000,\n interval_months: 6,\n first_km: null,\n first_months: null,\n note: \"General periodic check-up default.\",\n },\n];\n\nexport const CATEGORIES = [\n \"Engine\",\n \"Transmission\",\n \"Brakes\",\n \"Cooling\",\n \"Suspension\",\n \"Electrical\",\n \"General\",\n \"Other\",\n];\n",[],[147,213],["D",1783982540199],[197,198],[147],"b9849492-3989-4e7a-9e73-b0603823964a","sw.js","13530b64-7f0d-11f1-8d0b-1607ee4eb77e",12,["D",1783982956060],"// Service worker: makes the app installable and openable offline.\n// Strategy: network-first for GET (so new code/data loads when online),\n// falling back to cache when offline. /api and /auth are never cached.\nconst CACHE = \"adv160-v1\";\nconst SHELL = [\"/\", \"/frontend/index.html\", \"/frontend/app.tsx\", \"/manifest.json\", \"/frontend/icon.svg\"];\n\nself.addEventListener(\"install\", (e) => {\n e.waitUntil(\n caches.open(CACHE).then((c) => c.addAll(SHELL)).then(() => self.skipWaiting()),\n );\n});\n\nself.addEventListener(\"activate\", (e) => {\n e.waitUntil(\n caches.keys()\n .then((keys) => Promise.all(keys.filter((k) => k !== CACHE).map((k) => caches.delete(k))))\n .then(() => self.clients.claim()),\n );\n});\n\nself.addEventListener(\"fetch\", (e) => {\n const url = new URL(e.request.url);\n if (e.request.method !== \"GET\") return;\n if (url.pathname.startsWith(\"/api/\") || url.pathname.startsWith(\"/auth/\")) return;\n\n e.respondWith(\n fetch(e.request)\n .then((res) => {\n const copy = res.clone();\n caches.open(CACHE).then((c) => c.put(e.request, copy)).catch(() => {});\n return res;\n })\n .catch(() =>\n caches.match(e.request).then((r) => r || caches.match(\"/\"))\n ),\n );\n});\n",[],[154,223],"0b65acd7-a359-4cff-9f98-8fc3811c46d3","manifest.json","0f7b7c4c-7f0d-11f1-ba89-1607ee4eb77e",11,["D",1783982949616],"{\n \"name\": \"ADV160 Maintenance\",\n \"short_name\": \"ADV160\",\n \"description\": \"Maintenance tracker for a Honda ADV160 — service due dates, fuel, costs and email reminders.\",\n \"start_url\": \"/\",\n \"scope\": \"/\",\n \"display\": \"standalone\",\n \"background_color\": \"#ffffff\",\n \"theme_color\": \"#C8102E\",\n \"orientation\": \"portrait-primary\",\n \"icons\": [\n { \"src\": \"/frontend/icon.svg\", \"sizes\": \"any\", \"type\": \"image/svg+xml\", \"purpose\": \"any\" },\n { \"src\": \"/frontend/icon.svg\", \"sizes\": \"any\", \"type\": \"image/svg+xml\", \"purpose\": \"maskable\" }\n ]\n}\n",[],[154,231],"f56272df-7693-4475-a05b-84df80d79abd","index.html","0d8a809a-7f0d-11f1-a074-1607ee4eb77e",["D",1783982946331],"\n\n \n \n \n ADV160 Maintenance\n \n \n \n \n \n \n \n \n \n \n

\n \n \n \n\n",[],[154,239],"1f3b3c2b-2e39-496d-ad5c-0fc5f011dfbb","icon.svg","16eae79c-7f0d-11f1-ae2e-1607ee4eb77e",13,["D",1783982962088],"\n",[],[154,246],"157a7bf9-a860-48da-b484-25ea0d1e612f","app.tsx","18adaf38-7f0d-11f1-b187-1607ee4eb77e",14,["D",1783982964999],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst root = document.getElementById(\"root\");\nif (!root) throw new Error(\"No #root element\");\ncreateRoot(root).render();\n\n// Register the service worker for installability + offline shell.\nif (\"serviceWorker\" in navigator) {\n window.addEventListener(\"load\", () => {\n navigator.serviceWorker.register(\"/sw.js\").catch((e) => console.warn(\"SW failed\", e));\n });\n}\n",[],[154,254],"0ae5cdf8-e47f-4e09-bffe-08ec848ada83","2ac53dcb-575d-4f9f-b0d8-7b720b7a17cc",["D",1783982990612],[],[154,266,32],"lib","be9aa650-2624-4b51-8eb7-51943cb7471a","api.ts","249219b0-7f0d-11f1-b130-1607ee4eb77e",15,["D",1783982984924],"import type {\n DueInfo,\n FuelLog,\n ServiceRecord,\n ServiceType,\n Settings,\n Vehicle,\n} from \"../../shared/types.ts\";\n\nexport interface FuelSegment {\n from_km: number;\n to_km: number;\n distance: number;\n liters: number;\n km_per_l: number;\n date: string;\n}\nexport interface FuelEconomy {\n segments: FuelSegment[];\n average_km_per_l: number | null;\n}\nexport interface Costs {\n service_total: number;\n fuel_total: number;\n total: number;\n by_month: Record;\n by_category: Record;\n}\nexport interface AppState {\n vehicle: Vehicle;\n settings: Settings;\n service_types: ServiceType[];\n records: ServiceRecord[];\n fuel: FuelLog[];\n due: DueInfo[];\n km_per_day: number | null;\n fuel_economy: FuelEconomy;\n costs: Costs;\n categories: string[];\n}\n\nexport class AuthError extends Error {\n constructor(public status: number) {\n super(\"auth\");\n }\n}\n\nasync function fetchJSON(path: string, method = \"GET\", body?: unknown): Promise {\n const res = await fetch(path, {\n method,\n headers: body ? { \"Content-Type\": \"application/json\" } : undefined,\n body: body ? JSON.stringify(body) : undefined,\n });\n if (res.status === 401 || res.status === 403) throw new AuthError(res.status);\n if (!res.ok) throw new Error(`${method} ${path} -> ${res.status}`);\n return res.json() as Promise;\n}\n\nexport const api = {\n bootstrap: () => fetchJSON(\"/api/bootstrap\"),\n updateVehicle: (v: Record) => fetchJSON(\"/api/vehicle\", \"PUT\", v),\n addOdometer: (km: number, recorded_at?: string) =>\n fetchJSON(\"/api/odometer\", \"POST\", { km, recorded_at }),\n addServiceType: (t: Record) => fetchJSON(\"/api/service-types\", \"POST\", t),\n updateServiceType: (id: number, t: Record) =>\n fetchJSON(`/api/service-types/${id}`, \"PUT\", t),\n deleteServiceType: (id: number) => fetchJSON(`/api/service-types/${id}`, \"DELETE\"),\n snooze: (id: number) => fetchJSON(`/api/service-types/${id}/snooze`, \"POST\", {}),\n addRecord: (r: Record) => fetchJSON(\"/api/records\", \"POST\", r),\n deleteRecord: (id: number) => fetchJSON(`/api/records/${id}`, \"DELETE\"),\n addFuel: (f: Record) => fetchJSON(\"/api/fuel\", \"POST\", f),\n deleteFuel: (id: number) => fetchJSON(`/api/fuel/${id}`, \"DELETE\"),\n updateSettings: (s: Record) => fetchJSON(\"/api/settings\", \"PUT\", s),\n sendReminder: () =>\n fetchJSON<{ sent: boolean; reason: string; included: string[] }>(\"/api/send-reminder\", \"POST\", {}),\n};\n\nexport function photoUrl(key: string): string {\n return `/api/photos/${encodeURIComponent(key)}`;\n}\n",[],[154,266,268],"771dffc2-0eeb-4e2b-97e1-e1b1fe9a9852",["D",1783982984924],[189,190],[154,266],["D",1783982946331],[188,191,192,193,194,195],[154],"8b212fd4-43df-4663-a003-bb92fd201d54","reminders.ts","c4ad43e4-7f0c-11f1-9765-1607ee4eb77e",["D",1783982824101],"interval","// Daily reminder job. Recomputes what's due and emails a throttled digest\n// (each service is reminded at most once per 7 days). Verify manually with run_file.\nimport { runReminders } from \"../backend/reminders.ts\";\n\nexport default async function (interval: Interval) {\n const result = await runReminders(false);\n console.log(\"reminder run:\", JSON.stringify(result));\n}\n",[],[160,283],["D",1783982824101],[186],[160],"8e0d8283-511f-4048-b4fd-f8cbfd2335a3","5272b174-7f0c-11f1-ab1f-1607ee4eb77e",5,["D",1783982632435],"// Pure due-date / reminder calculation. No DB access here so it can be unit-reasoned\n// and reused by both the HTTP API and the daily cron job.\n\nimport type {\n DueInfo,\n DueStatus,\n ServiceRecord,\n ServiceType,\n Settings,\n Vehicle,\n} from \"../shared/types.ts\";\n\nconst DAY_MS = 24 * 60 * 60 * 1000;\n\nexport function dateOnly(s: string): string {\n return (s || \"\").slice(0, 10);\n}\n\nfunction parseUTC(s: string): Date {\n return new Date(`${dateOnly(s)}T00:00:00Z`);\n}\n\nexport function todayISO(): string {\n return new Date().toISOString().slice(0, 10);\n}\n\nexport function addMonths(dateStr: string, months: number): string {\n const d = parseUTC(dateStr);\n const day = d.getUTCDate();\n d.setUTCMonth(d.getUTCMonth() + months);\n // Clamp end-of-month overflow (e.g. Jan 31 + 1mo -> Feb 28).\n if (d.getUTCDate() < day) d.setUTCDate(0);\n return d.toISOString().slice(0, 10);\n}\n\nexport function daysBetween(fromISO: string, toISO: string): number {\n return Math.round((parseUTC(toISO).getTime() - parseUTC(fromISO).getTime()) / DAY_MS);\n}\n\n// Estimate average km/day from odometer history, falling back to the baseline.\nexport function estimateKmPerDay(\n vehicle: Vehicle,\n readings: { km: number; recorded_at: string }[],\n): number | null {\n const pts = [...readings]\n .map((r) => ({ km: r.km, at: dateOnly(r.recorded_at) }))\n .sort((a, b) => (a.at < b.at ? -1 : 1));\n if (pts.length >= 2) {\n const first = pts[0];\n const last = pts[pts.length - 1];\n const days = daysBetween(first.at, last.at);\n const km = last.km - first.km;\n if (days >= 1 && km > 0) return km / days;\n }\n // Fallback: distance covered since the vehicle baseline.\n const days = daysBetween(vehicle.baseline_date, todayISO());\n const km = vehicle.current_odometer_km - vehicle.baseline_odometer_km;\n if (days >= 1 && km > 0) return km / days;\n return null;\n}\n\nfunction fmtKm(n: number): string {\n return `${Math.round(n).toLocaleString(\"en-US\")} km`;\n}\n\nexport function computeDue(\n vehicle: Vehicle,\n settings: Settings,\n serviceTypes: ServiceType[],\n records: ServiceRecord[],\n kmPerDay: number | null,\n): DueInfo[] {\n const currentKm = vehicle.current_odometer_km;\n const today = todayISO();\n const leadDays = settings.reminder_lead_days;\n const leadKm = settings.reminder_lead_km;\n\n const out: DueInfo[] = serviceTypes.map((st) => {\n // Most recent record for this service type (records already sorted desc by date).\n const last = records.find((r) => r.service_type_id === st.id) ?? null;\n\n const baseKm = last?.odometer_km ?? vehicle.baseline_odometer_km;\n const baseDate = last ? dateOnly(last.performed_at) : vehicle.baseline_date;\n\n // Choose km interval: use \"first\" interval only when the service was never done.\n const kmInterval = last ? st.interval_km : (st.first_km ?? st.interval_km);\n const monthInterval = last ? st.interval_months : (st.first_months ?? st.interval_months);\n\n const nextDueKm = kmInterval != null ? baseKm + kmInterval : null;\n const nextDueDate = monthInterval != null ? addMonths(baseDate, monthInterval) : null;\n\n const kmRemaining = nextDueKm != null ? nextDueKm - currentKm : null;\n const daysRemaining = nextDueDate != null ? daysBetween(today, nextDueDate) : null;\n\n // Project when the km-based service will be reached, given usage rate.\n let projectedDueDate: string | null = null;\n if (kmRemaining != null && kmPerDay && kmPerDay > 0) {\n const daysToKm = Math.round(kmRemaining / kmPerDay);\n const d = new Date(Date.now() + daysToKm * DAY_MS);\n projectedDueDate = d.toISOString().slice(0, 10);\n }\n\n let status: DueStatus = \"ok\";\n const reasons: string[] = [];\n\n if (nextDueKm == null && nextDueDate == null) {\n status = \"unknown\";\n reasons.push(\"No interval set\");\n } else {\n const overdueKm = kmRemaining != null && kmRemaining <= 0;\n const overdueTime = daysRemaining != null && daysRemaining < 0;\n const soonKm = kmRemaining != null && kmRemaining > 0 && kmRemaining <= leadKm;\n const soonTime = daysRemaining != null && daysRemaining >= 0 && daysRemaining <= leadDays;\n const soonProjected = projectedDueDate != null &&\n daysBetween(today, projectedDueDate) <= leadDays;\n\n if (overdueKm) reasons.push(`Over by ${fmtKm(-(kmRemaining as number))}`);\n if (overdueTime) reasons.push(`${-(daysRemaining as number)} days overdue`);\n if (!overdueKm && soonKm) reasons.push(`${fmtKm(kmRemaining as number)} left`);\n if (!overdueTime && soonTime) reasons.push(`due in ${daysRemaining} days`);\n if (!overdueKm && !overdueTime && !soonKm && !soonTime && soonProjected) {\n reasons.push(`~${daysBetween(today, projectedDueDate as string)} days at current usage`);\n }\n\n if (overdueKm || overdueTime) status = \"overdue\";\n else if (soonKm || soonTime || soonProjected) status = \"due_soon\";\n else status = \"ok\";\n }\n\n return {\n service_type_id: st.id,\n name: st.name,\n category: st.category,\n enabled: st.enabled === 1,\n last_done_km: last?.odometer_km ?? null,\n last_done_date: last ? dateOnly(last.performed_at) : null,\n next_due_km: nextDueKm,\n next_due_date: nextDueDate,\n km_remaining: kmRemaining,\n days_remaining: daysRemaining,\n projected_due_date: projectedDueDate,\n status,\n reason: reasons.join(\" · \"),\n };\n });\n\n // Sort: overdue first, then due_soon, then ok, then unknown; within a group by urgency.\n const rank: Record = { overdue: 0, due_soon: 1, ok: 2, unknown: 3 };\n out.sort((a, b) => {\n if (rank[a.status] !== rank[b.status]) return rank[a.status] - rank[b.status];\n const av = urgencyValue(a);\n const bv = urgencyValue(b);\n return av - bv;\n });\n return out;\n}\n\nfunction urgencyValue(d: DueInfo): number {\n // Lower = more urgent. Combine remaining days and a km->days proxy.\n const candidates: number[] = [];\n if (d.days_remaining != null) candidates.push(d.days_remaining);\n if (d.projected_due_date != null) {\n candidates.push(daysBetween(todayISO(), d.projected_due_date));\n }\n if (candidates.length === 0) return Number.MAX_SAFE_INTEGER;\n return Math.min(...candidates);\n}\n",[],[166,213],"637c1d78-0798-4f03-82dc-3e3fed516e7d","68f15d24-7f0c-11f1-8163-1607ee4eb77e",7,["D",1783982743266],"import { email } from \"https://esm.town/v/std/email\";\nimport {\n getRecords,\n getServiceTypes,\n getSettings,\n getVehicle,\n ready,\n sqlite,\n} from \"./db.ts\";\nimport { computeDue, estimateKmPerDay } from \"./schedule.ts\";\nimport type { DueInfo } from \"../shared/types.ts\";\n\nconst THROTTLE_DAYS = 7;\n\nfunction fmtDate(s: string | null): string {\n return s ? s : \"—\";\n}\n\nfunction lineFor(d: DueInfo): string {\n const bits: string[] = [];\n if (d.next_due_km != null) bits.push(`at ${Math.round(d.next_due_km).toLocaleString(\"en-US\")} km`);\n if (d.next_due_date != null) bits.push(`by ${d.next_due_date}`);\n const when = bits.length ? ` — due ${bits.join(\" / \")}` : \"\";\n const reason = d.reason ? ` (${d.reason})` : \"\";\n return `${d.name}${when}${reason}`;\n}\n\nexport interface ReminderResult {\n sent: boolean;\n reason: string;\n included: string[];\n}\n\n// Compute due items, filter to actionable + un-throttled ones, email a digest,\n// and record last_reminder_sent_at. Safe to call from cron or a manual trigger.\nexport async function runReminders(force = false): Promise {\n await ready();\n const [vehicle, settings, serviceTypes, records] = await Promise.all([\n getVehicle(),\n getSettings(),\n getServiceTypes(),\n getRecords(),\n ]);\n\n const readingsRes = await sqlite.execute(\n \"SELECT km, recorded_at FROM odometer_readings ORDER BY recorded_at\",\n );\n const readings = readingsRes.rows.map((r) => ({\n km: Number(r.km),\n recorded_at: String(r.recorded_at),\n }));\n const kmPerDay = estimateKmPerDay(vehicle, readings);\n\n const due = computeDue(vehicle, settings, serviceTypes, records, kmPerDay);\n const byId = new Map(serviceTypes.map((s) => [s.id, s]));\n\n const now = Date.now();\n const actionable = due.filter((d) => {\n if (!d.enabled) return false;\n if (d.status !== \"overdue\" && d.status !== \"due_soon\") return false;\n if (force) return true;\n const st = byId.get(d.service_type_id);\n const last = st?.last_reminder_sent_at;\n if (!last) return true;\n const ageDays = (now - new Date(last).getTime()) / (24 * 60 * 60 * 1000);\n return ageDays >= THROTTLE_DAYS;\n });\n\n if (actionable.length === 0) {\n return { sent: false, reason: \"Nothing due (or all recently reminded)\", included: [] };\n }\n\n const overdue = actionable.filter((d) => d.status === \"overdue\");\n const soon = actionable.filter((d) => d.status === \"due_soon\");\n\n const currencyKm = `${Math.round(vehicle.current_odometer_km).toLocaleString(\"en-US\")} km`;\n const section = (title: string, items: DueInfo[]) =>\n items.length\n ? `\\n${title}\\n` + items.map((d) => ` • ${lineFor(d)}`).join(\"\\n\")\n : \"\";\n\n const text =\n `Maintenance due for your ${vehicle.year ?? \"\"} ${vehicle.make} ${vehicle.model} (${vehicle.name}).\\n` +\n `Current odometer: ${currencyKm}.\\n` +\n section(\"OVERDUE\", overdue) +\n section(\"DUE SOON\", soon) +\n `\\n\\nOpen your tracker to log or snooze these.`;\n\n const htmlItem = (d: DueInfo, color: string) =>\n `

${d.name}` +\n `

` +\n (d.next_due_km != null ? `Due at ${Math.round(d.next_due_km).toLocaleString(\"en-US\")} km. ` : \"\") +\n (d.next_due_date != null ? `Due by ${fmtDate(d.next_due_date)}. ` : \"\") +\n (d.reason ? `${d.reason}.` : \"\") +\n `

`;\n\n const html =\n `

` +\n `

🏍️ Maintenance due

` +\n `

${vehicle.year ?? \"\"} ${vehicle.make} ${vehicle.model} · odometer ${currencyKm}

` +\n (overdue.length\n ? `

Overdue

${overdue.map((d) => htmlItem(d, \"#c0392b\")).join(\"\")}`\n : \"\") +\n (soon.length\n ? `

Due soon

${soon.map((d) => htmlItem(d, \"#b7791f\")).join(\"\")}`\n : \"\") +\n `

Open your maintenance tracker →

` +\n `

`;\n\n await email({\n subject: `🏍️ ADV160 maintenance: ${actionable.length} item${actionable.length === 1 ? \"\" : \"s\"} due`,\n text,\n html,\n });\n\n // Record that we reminded about these service types.\n const nowIso = new Date().toISOString();\n await sqlite.batch(\n actionable.map((d) => ({\n sql: \"UPDATE service_types SET last_reminder_sent_at = ? WHERE id = ?\",\n args: [nowIso, d.service_type_id],\n })),\n );\n\n return {\n sent: true,\n reason: `Emailed ${actionable.length} item(s)`,\n included: actionable.map((d) => d.name),\n };\n}\n\n// The public endpoint host is only needed for the email link; keep it best-effort.\nfunction valSlug(): string {\n return \"adv160-tracker.web.val.run\";\n}\n",[],[166,283],"8dbf20a4-cb9a-4906-a139-117d3cb18cff","db.ts","38b648ae-7f0c-11f1-93a5-1607ee4eb77e",["D",1783982589287],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { DEFAULT_SERVICES } from \"../shared/schedule.ts\";\nimport type {\n FuelLog,\n ServiceRecord,\n ServiceType,\n Settings,\n Vehicle,\n} from \"../shared/types.ts\";\n\n// ---- Schema + seed (idempotent, memoized so it runs once per warm instance) ----\n\nlet readyPromise: Promise | null = null;\n\nexport function ready(): Promise {\n if (!readyPromise) readyPromise = init();\n return readyPromise;\n}\n\nfunction today(): string {\n return new Date().toISOString().slice(0, 10);\n}\n\nasync function init(): Promise {\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS vehicle (\n id INTEGER PRIMARY KEY,\n name TEXT NOT NULL DEFAULT '',\n make TEXT NOT NULL DEFAULT '',\n model TEXT NOT NULL DEFAULT '',\n year INTEGER,\n plate TEXT NOT NULL DEFAULT '',\n color TEXT NOT NULL DEFAULT '',\n baseline_odometer_km INTEGER NOT NULL DEFAULT 0,\n baseline_date TEXT NOT NULL,\n current_odometer_km INTEGER NOT NULL DEFAULT 0,\n odometer_updated_at TEXT NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS settings (\n id INTEGER PRIMARY KEY,\n reminder_lead_days INTEGER NOT NULL DEFAULT 7,\n reminder_lead_km INTEGER NOT NULL DEFAULT 200,\n currency TEXT NOT NULL DEFAULT 'PHP',\n timezone TEXT NOT NULL DEFAULT 'Asia/Manila',\n email TEXT NOT NULL DEFAULT ''\n )`,\n `CREATE TABLE IF NOT EXISTS odometer_readings (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n km INTEGER NOT NULL,\n recorded_at TEXT NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS service_types (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n service_key TEXT,\n name TEXT NOT NULL,\n category TEXT NOT NULL DEFAULT 'Other',\n interval_km INTEGER,\n interval_months INTEGER,\n first_km INTEGER,\n first_months INTEGER,\n enabled INTEGER NOT NULL DEFAULT 1,\n note TEXT NOT NULL DEFAULT '',\n last_reminder_sent_at TEXT\n )`,\n `CREATE TABLE IF NOT EXISTS service_records (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n service_type_id INTEGER,\n name TEXT NOT NULL,\n performed_at TEXT NOT NULL,\n odometer_km INTEGER,\n cost REAL,\n notes TEXT NOT NULL DEFAULT '',\n photo_keys TEXT NOT NULL DEFAULT '[]',\n created_at TEXT NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS fuel_logs (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n filled_at TEXT NOT NULL,\n odometer_km INTEGER NOT NULL,\n liters REAL NOT NULL,\n price_per_liter REAL,\n total_cost REAL,\n is_full_tank INTEGER NOT NULL DEFAULT 1,\n notes TEXT NOT NULL DEFAULT '',\n created_at TEXT NOT NULL\n )`,\n ]);\n\n // Seed the single vehicle row.\n const v = await sqlite.execute(\"SELECT COUNT(*) AS n FROM vehicle\");\n if (Number(v.rows[0].n) === 0) {\n await sqlite.execute({\n sql: `INSERT INTO vehicle\n (id, name, make, model, year, plate, color, baseline_odometer_km, baseline_date, current_odometer_km, odometer_updated_at)\n VALUES (1, ?, 'Honda', 'ADV160', 2026, '', 'Pearl White', 0, ?, 0, ?)`,\n args: [\"My ADV160\", today(), new Date().toISOString()],\n });\n }\n\n // Seed settings.\n const s = await sqlite.execute(\"SELECT COUNT(*) AS n FROM settings\");\n if (Number(s.rows[0].n) === 0) {\n await sqlite.execute(\n \"INSERT INTO settings (id, reminder_lead_days, reminder_lead_km, currency, timezone, email) VALUES (1, 7, 200, 'PHP', 'Asia/Manila', '')\",\n );\n }\n\n // Seed the ADV160 service schedule.\n const st = await sqlite.execute(\"SELECT COUNT(*) AS n FROM service_types\");\n if (Number(st.rows[0].n) === 0) {\n await sqlite.batch(\n DEFAULT_SERVICES.map((d) => ({\n sql: `INSERT INTO service_types\n (service_key, name, category, interval_km, interval_months, first_km, first_months, enabled, note)\n VALUES (?, ?, ?, ?, ?, ?, ?, 1, ?)`,\n args: [\n d.key,\n d.name,\n d.category,\n d.interval_km,\n d.interval_months,\n d.first_km,\n d.first_months,\n d.note,\n ],\n })),\n );\n }\n}\n\n// ---- Row mappers ----\n\nfunction num(x: unknown): number {\n return x == null ? 0 : Number(x);\n}\nfunction maybeNum(x: unknown): number | null {\n return x == null ? null : Number(x);\n}\nfunction str(x: unknown): string {\n return x == null ? \"\" : String(x);\n}\n\nexport function mapVehicle(r: Record): Vehicle {\n return {\n id: num(r.id),\n name: str(r.name),\n make: str(r.make),\n model: str(r.model),\n year: maybeNum(r.year),\n plate: str(r.plate),\n color: str(r.color),\n baseline_odometer_km: num(r.baseline_odometer_km),\n baseline_date: str(r.baseline_date),\n current_odometer_km: num(r.current_odometer_km),\n odometer_updated_at: str(r.odometer_updated_at),\n };\n}\n\nexport function mapSettings(r: Record): Settings {\n return {\n id: num(r.id),\n reminder_lead_days: num(r.reminder_lead_days),\n reminder_lead_km: num(r.reminder_lead_km),\n currency: str(r.currency),\n timezone: str(r.timezone),\n email: str(r.email),\n };\n}\n\nexport function mapServiceType(r: Record): ServiceType {\n return {\n id: num(r.id),\n service_key: r.service_key == null ? null : str(r.service_key),\n name: str(r.name),\n category: str(r.category),\n interval_km: maybeNum(r.interval_km),\n interval_months: maybeNum(r.interval_months),\n first_km: maybeNum(r.first_km),\n first_months: maybeNum(r.first_months),\n enabled: num(r.enabled),\n note: str(r.note),\n last_reminder_sent_at: r.last_reminder_sent_at == null ? null : str(r.last_reminder_sent_at),\n };\n}\n\nexport function mapRecord(r: Record): ServiceRecord {\n let photos: string[] = [];\n try {\n photos = JSON.parse(str(r.photo_keys) || \"[]\");\n } catch (_) {\n photos = [];\n }\n return {\n id: num(r.id),\n service_type_id: maybeNum(r.service_type_id),\n name: str(r.name),\n performed_at: str(r.performed_at),\n odometer_km: maybeNum(r.odometer_km),\n cost: maybeNum(r.cost),\n notes: str(r.notes),\n photo_keys: photos,\n created_at: str(r.created_at),\n };\n}\n\nexport function mapFuel(r: Record): FuelLog {\n return {\n id: num(r.id),\n filled_at: str(r.filled_at),\n odometer_km: num(r.odometer_km),\n liters: num(r.liters),\n price_per_liter: maybeNum(r.price_per_liter),\n total_cost: maybeNum(r.total_cost),\n is_full_tank: num(r.is_full_tank),\n notes: str(r.notes),\n created_at: str(r.created_at),\n };\n}\n\n// ---- High-level reads used by both the API and the cron job ----\n\nexport async function getVehicle(): Promise {\n await ready();\n const r = await sqlite.execute(\"SELECT * FROM vehicle WHERE id = 1\");\n return mapVehicle(r.rows[0]);\n}\n\nexport async function getSettings(): Promise {\n await ready();\n const r = await sqlite.execute(\"SELECT * FROM settings WHERE id = 1\");\n return mapSettings(r.rows[0]);\n}\n\nexport async function getServiceTypes(): Promise {\n await ready();\n const r = await sqlite.execute(\n \"SELECT * FROM service_types ORDER BY category, name\",\n );\n return r.rows.map(mapServiceType);\n}\n\nexport async function getRecords(): Promise {\n await ready();\n const r = await sqlite.execute(\n \"SELECT * FROM service_records ORDER BY performed_at DESC, id DESC\",\n );\n return r.rows.map(mapRecord);\n}\n\nexport async function getFuelLogs(): Promise {\n await ready();\n const r = await sqlite.execute(\n \"SELECT * FROM fuel_logs ORDER BY odometer_km DESC, id DESC\",\n );\n return r.rows.map(mapFuel);\n}\n\nexport { sqlite };\n",[],[166,308],["D",1783982589287],[182,183,184],[166],["D",1783982520711],["D",1789489305251],{"_97":96,"_105":101},{"_97":96,"_98":99,"_100":101,"_18":54,"_102":103,"_104":24},{"_13":86,"_31":87,"_42":41,"_88":43,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":44,"_95":96},"ctx",{"_79":-5,"_126":355,"_356":357,"_358":359,"_360":24,"_361":24,"_362":24,"_363":124,"_364":-5,"_365":-7,"_366":-7,"_367":60,"_368":24,"_369":24,"_370":-5,"_371":24,"_372":24,"_373":24,"_374":-5},"ENV",{"_326":327,"_328":329,"_330":87,"_331":332,"_333":334,"_335":336,"_337":338,"_339":340,"_341":342,"_343":344,"_345":346,"_347":348,"_349":350,"_351":352,"_353":354},"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","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v16