[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_224":225,"_226":227},"routes/_app.x.$handle.$name",{"_99":98,"_32":46,"_108":89,"_27":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_20":-5,"_120":-5,"_121":-5,"_122":25,"_123":124,"_125":126,"_127":-5,"_128":-5,"_129":130},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":-5,"_58":25,"_59":-5,"_60":-5,"_61":62,"_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":25},"version",7,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","backend/reminders.ts","latestPath","fileId","68f15d24-7f0c-11f1-8163-1607ee4eb77e","name","reminders.ts","fileType","script","content","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, dateOnly, 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 `

${d.name}` +\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","createdAt",["D",1783982743266],"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",1789576313835],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_107":103},"org",{"_99":98,"_100":101,"_102":103,"_18":56,"_104":105,"_106":25},"branch",{"_13":88,"_32":89,"_44":43,"_90":45,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":46,"_97":98},"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",{"_44":45,"_32":46,"_39":219,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":-5,"_58":25,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":220,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":221,"_83":222,"_85":223,"_87":25},"tree",[168,172,175],"files",[168,169,170,171,172,173,174,175],"counts",{"_158":62,"_159":138,"_160":62,"_161":162,"_163":164},"contents",[131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_44":152,"_32":153,"_30":154,"_137":-5,"_42":43,"_41":155,"_139":126,"_39":156,"_13":62,"_34":150,"_36":-5,"_24":25,"_143":-5,"_27":157},{"_44":145,"_32":146,"_30":147,"_137":-5,"_42":43,"_41":148,"_139":126,"_39":149,"_13":62,"_34":150,"_36":-5,"_24":25,"_143":-5,"_27":151},{"_44":134,"_32":135,"_30":136,"_137":-5,"_42":43,"_41":138,"_139":25,"_39":140,"_13":62,"_34":141,"_36":142,"_24":25,"_143":-5,"_27":144},"4d1c9dca-cf17-4d31-a7e0-c72b79ad8d21","index.ts","0fdb1676-7f0c-11f1-8c45-1607ee4eb77e","parentId",1,"latest",["D",1783982520731],"http","export default async function (req: Request): Promise {\n return new Response(\"ADV160 tracker booting…\");\n}\n","label",[135],"c4c3ea31-fbd0-44f4-8894-8c3685d3b941","shared","5d0b691e-d378-4a63-921e-5f1b6586c89e",2,["D",1783982540199],"directory",[146],"dc27a954-22e0-47fc-b8ad-3b4d86ada28d","backend","977ebdc0-ab7e-4b24-8641-5c8d6c6d9182",4,["D",1783982589287],[153],"pulls","branches","forks","envVars",{"_165":138,"_167":62},"connections",{"_165":62,"_166":62},"count","unfilledCount","emptyCount",{"_44":152,"_32":153,"_30":154,"_137":-5,"_42":43,"_41":155,"_139":126,"_39":216,"_13":62,"_34":150,"_36":-5,"_24":25,"_143":-5,"_177":217,"_27":218},{"_44":209,"_32":210,"_30":211,"_137":154,"_42":43,"_41":155,"_139":25,"_39":212,"_13":62,"_34":35,"_36":213,"_24":25,"_143":-5,"_177":214,"_27":215},{"_44":205,"_32":33,"_30":31,"_137":154,"_42":43,"_41":14,"_139":25,"_39":206,"_13":138,"_34":35,"_36":38,"_24":25,"_143":-5,"_177":207,"_27":208},{"_44":198,"_32":189,"_30":199,"_137":154,"_42":43,"_41":200,"_139":25,"_39":201,"_13":62,"_34":35,"_36":202,"_24":25,"_143":-5,"_177":203,"_27":204},{"_44":145,"_32":146,"_30":147,"_137":-5,"_42":43,"_41":148,"_139":126,"_39":195,"_13":62,"_34":150,"_36":-5,"_24":25,"_143":-5,"_177":196,"_27":197},{"_44":188,"_32":189,"_30":190,"_137":147,"_42":43,"_41":148,"_139":25,"_39":191,"_13":62,"_34":35,"_36":192,"_24":25,"_143":-5,"_177":193,"_27":194},{"_44":180,"_32":181,"_30":182,"_137":147,"_42":43,"_41":183,"_139":25,"_39":184,"_13":62,"_34":35,"_36":185,"_24":25,"_143":-5,"_177":186,"_27":187},{"_44":134,"_32":135,"_30":136,"_137":-5,"_42":43,"_41":138,"_139":25,"_39":176,"_13":62,"_34":141,"_36":142,"_24":25,"_143":-5,"_177":178,"_27":179},["D",1783982520731],"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",[],[146,181],"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",[],[146,189],["D",1783982540199],[173,174],[146],"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",[],[153,189],"637c1d78-0798-4f03-82dc-3e3fed516e7d",["D",1783982743266],[],[153,33],"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",[],[153,210],["D",1783982589287],[169,170,171],[153],["D",1783982520711],["D",1789576313835],{"_99":98,"_107":103},{"_99":98,"_100":101,"_102":103,"_18":56,"_104":105,"_106":25},{"_13":88,"_32":89,"_44":43,"_90":45,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":46,"_97":98},"ctx",{"_81":-5,"_128":257,"_258":259,"_260":261,"_262":25,"_263":25,"_264":25,"_265":126,"_266":-5,"_267":-7,"_268":-7,"_269":62,"_270":25,"_271":25,"_272":-5,"_273":25,"_274":25,"_275":25,"_276":-5},"ENV",{"_228":229,"_230":231,"_232":89,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248,"_249":250,"_251":252,"_253":254,"_255":256},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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 · v7