// Audit Export - NSC inspection-ready single-page report. // Designed to print to letter PDF, fit-to-page. const AuditExport = ({ unitId, year, month, weightFilter, onClose }) => { const D = window.NORFAB_DATA; const monthLabel = new Date(year, month, 1).toLocaleDateString("en-US", { month: "long", year: "numeric" }); const fromISO = `${year}-${String(month + 1).padStart(2, "0")}-01`; const lastDay = new Date(year, month + 1, 0).getUTCDate(); const toISO = `${year}-${String(month + 1).padStart(2, "0")}-${String(lastDay).padStart(2, "0")}`; // tripsForRange in data.js has signature (driverId, fromISO, toISO) - the // 4-arg call previously here silently filtered nothing (positional shift). // Inline filter to actually honor unitId + weightFilter. const trips = (D.TRIPS || []).filter(t => { if (!t.date || t.date < fromISO || t.date > toISO) return false; if (unitId && unitId !== "ALL" && t.unit !== unitId) return false; if (weightFilter && weightFilter !== "all") { const u = (D.UNITS || []).find(x => x.id === t.unit); if (!u) return false; if (weightFilter === "heavy" && u.klass !== "heavy") return false; if (weightFilter === "light" && u.klass !== "light") return false; } return true; }); const totalKm = trips.reduce((s, t) => s + t.km, 0); const flagged = trips.filter(t => t.flagged); const days = new Set(trips.map(t => t.date)).size; const unitsActive = new Set(trips.map(t => t.unit)); const generated = new Date(Date.UTC(2026, 4, 7, 16, 22)).toLocaleString("en-CA", { timeZone: "America/Edmonton" }); // Group by unit, then by date const byUnit = {}; for (const t of trips) { if (!byUnit[t.unit]) byUnit[t.unit] = {}; if (!byUnit[t.unit][t.date]) byUnit[t.unit][t.date] = { trips: [], km: 0, flags: 0 }; byUnit[t.unit][t.date].trips.push(t); byUnit[t.unit][t.date].km += t.km; if (t.flagged) byUnit[t.unit][t.date].flags++; } // ---------- Section 1 data: driver roster for the period ---------- // Union of drivers who appear in trips OR DVIs for the period. const dvirsInPeriod = (D.DVIR || []).filter(d => d.date_local >= fromISO && d.date_local <= toISO); const rosterNames = new Set(); for (const t of trips) if (t.driver_name) rosterNames.add(t.driver_name); for (const d of dvirsInPeriod) if (d.driver_name) rosterNames.add(d.driver_name); const roster = [...rosterNames].sort().map(name => { const myTrips = trips.filter(t => t.driver_name === name); const myDvirs = dvirsInPeriod.filter(d => d.driver_name === name); const unitCounts = myTrips.reduce((acc, t) => { acc[t.unit] = (acc[t.unit] || 0) + 1; return acc; }, {}); const primaryUnit = Object.entries(unitCounts).sort((a, b) => b[1] - a[1])[0]; return { name, primaryUnit: primaryUnit ? primaryUnit[0] : "", daysActive: new Set(myTrips.map(t => t.date)).size, trips: myTrips.length, dvirs: myDvirs.length, km: myTrips.reduce((s, t) => s + t.km, 0), }; }); // ---------- Section 2 data: daily compliance grid (Day x Unit x Driver) ---------- // One row per unique (date, unit, driver_name) where the unit operated. const gridMap = new Map(); for (const t of trips) { const key = `${t.date}|${t.unit}|${t.driver_name || "(unknown)"}`; if (!gridMap.has(key)) { gridMap.set(key, { date: t.date, unit: t.unit, driver_id: t.driver, driver_name: t.driver_name || "(unknown)", trips: 0, km: 0, }); } const row = gridMap.get(key); row.trips++; row.km += t.km; } const dailyGrid = [...gridMap.values()].sort((a, b) => a.date.localeCompare(b.date) || a.unit.localeCompare(b.unit) || a.driver_name.localeCompare(b.driver_name) ).map(row => { const preDvi = (D.DVIR || []).some(d => d.date_local === row.date && d.unit === row.unit && d.trip_type === "Pre"); const postDvi = (D.DVIR || []).some(d => d.date_local === row.date && d.unit === row.unit && d.trip_type === "Post"); let hosState = "", hosHours = null; if (typeof D.dayCompliance === "function") { try { const c = D.dayCompliance(row.driver_id, row.date); if (c && c.state) hosState = c.state; if (c && c.totalHours != null) hosHours = c.totalHours; else if (c && c.hours != null) hosHours = c.hours; } catch (e) { /* leave defaults */ } } return { ...row, preDvi, postDvi, hosState, hosHours }; }); // ---------- Section 3 data: DVI completion log ---------- const dvirLog = [...dvirsInPeriod].sort((a, b) => a.date_local.localeCompare(b.date_local) || ((a.time_min || 0) - (b.time_min || 0)) ); // ---------- Section 4 data: HOS / 160 km exemption per-driver summary ---------- const hosSummary = roster.map(r => { const myDays = [...new Set(trips.filter(t => t.driver_name === r.name).map(t => t.date))]; let exempt = 0, outOfRadius = 0, overHours = 0, unknown = 0; const driverId = (trips.find(t => t.driver_name === r.name) || {}).driver; if (driverId && typeof D.dayCompliance === "function") { for (const day of myDays) { try { const c = D.dayCompliance(driverId, day); const state = (c && c.state) || ""; if (/exempt|ok|compliant/i.test(state)) exempt++; else if (/radius|160/i.test(state)) outOfRadius++; else if (/hour|15h|shift/i.test(state)) overHours++; else unknown++; } catch (e) { unknown++; } } } else { unknown = myDays.length; } return { name: r.name, daysWorked: myDays.length, exempt, outOfRadius, overHours, unknown }; }); // ---------- Section 5 data: exception details ---------- const exceptionRows = []; for (const row of dailyGrid) { if (!row.preDvi) { exceptionRows.push({ kind: "Missing pre-trip DVI", date: row.date, unit: row.unit, driver: row.driver_name, detail: `${row.trips} trip(s), ${row.km.toFixed(1)} km logged with no pre-trip inspection on file` }); } } for (const t of trips) { if (t.outside_radius) { exceptionRows.push({ kind: "Outside 160 km exemption radius", date: t.date, unit: t.unit, driver: t.driver_name || "(unknown)", detail: `Max radius ~${(t.site_dist || 0).toFixed(1)} km from day-start (limit 160 km)` }); } } // Sort exceptions by date, then kind exceptionRows.sort((a, b) => a.date.localeCompare(b.date) || a.kind.localeCompare(b.kind)); return (
{/* Toolbar (hidden on print) */}
NSC compliance report · {monthLabel}
{/* One button: the browser print dialog is also the PDF exporter (destination "Save as PDF"). A separate Download PDF button was an unwired stub — removed rather than duplicating Print. */} } onClick={() => window.print()}>Print / Save PDF
{/* Page */}
{/* Letterhead */}
Cascade Freight
Cascade Freight Inc.
{D.PPB.name}
(555) 010-0100 · cascadefreight.example
NSC Compliance Report
{monthLabel}
Generated {generated} MDT
Document ID: NF-{year}{String(month + 1).padStart(2, "0")}-{unitId === "ALL" ? "FLEET" : unitId}
{/* SFC + carrier identification */}
Carrier identification {[ ["Legal name", D.SFC.carrier], ["NSC number", D.SFC.nsc], ["Classification", D.SFC.classification], ["Principal place", D.PPB.name], ].map(([k, v]) => ( ))}
{k} {v}
Reporting scope {[ ["Period", `${fromISO} to ${toISO}`], ["Unit filter", unitId === "ALL" ? "All fleet units" : unitId], ["Weight class", weightFilter === "heavy" ? "≥ 11,794 kg (NSC time-record)" : weightFilter === "light" ? "< 11,794 kg" : "All weights"], ["Trip threshold", "≥ 0.60 km logged"], ].map(([k, v]) => ( ))}
{k} {v}
{/* Summary */}
{[ ["Active units", unitsActive.size], ["Days with data", days], ["Trips logged", trips.length], ["Distance (km)", totalKm.toFixed(1)], ["Flags", flagged.length], ].map(([k, v], i) => (
{k}
{v}
))}
{/* Statement */}
Compliance statement. All trips logged via fixed GPS telematics on carrier-owned units, delivered hourly by the upstream provider and persisted to immutable storage. Flags indicate trips that either ended outside the 1.5 km return-to-origin radius or operated beyond the 160 km Alberta exemption radius for time-record–required units (≥ 11,794 kg GVW). This document is generated automatically from the source telemetry; raw evidence is retained for the period required by NSC Standard 9.
{/* Per-unit breakdown */}
Per-unit summary {[ ["Unit", "left"], ["Class", "left"], ["Driver", "left"], ["Days", "right"], ["Trips", "right"], ["Distance (km)", "right"], ["Flags", "right"], ["Status", "left"], ].map(([h, a]) => ( ))} {Object.keys(byUnit).sort().map(uid => { const u = D.UNITS.find(x => x.id === uid); const utrips = trips.filter(t => t.unit === uid); const ukm = utrips.reduce((s, t) => s + t.km, 0); const uflags = utrips.filter(t => t.flagged).length; const udays = new Set(utrips.map(t => t.date)).size; return ( ); })}
{h}
{uid} {u.klass === "heavy" ? "Heavy" : "Light"} {u.driver} {udays} {utrips.length} {ukm.toFixed(1)} {uflags} {uflags === 0 ? ● Compliant : ● Review ({uflags})}
{/* Flag detail */} {flagged.length > 0 && (
Flagged trips · detail {["Date", "Unit", "Driver", "Time", "Site", "Km", "Reason"].map(h => ( ))} {flagged.slice(0, 18).map(t => ( ))} {flagged.length > 18 && ( )}
{h}
{t.date} {t.unit} {t.driver} {D.minToHHMM(t.start_min)} {t.site} {t.km.toFixed(1)} {t.outside_radius ? "Outside 160 km exemption radius (from day-start)" : ((t.flags && t.flags[0]) || "Flagged in source data")}
+ {flagged.length - 18} additional flagged trips. See full ledger.
)} {/* Section 1: Driver roster for the audit period */} {roster.length > 0 && (
Driver roster · {monthLabel} {[["Driver", "left"], ["Primary unit", "left"], ["Days active", "right"], ["Trips", "right"], ["DVIs filed", "right"], ["Distance (km)", "right"]].map(([h, a]) => ( ))} {roster.map(r => ( ))}
{h}
{r.name} {r.primaryUnit} {r.daysActive} {r.trips} {r.dvirs} {r.km.toFixed(1)}
)} {/* Section 2: Daily compliance grid */} {dailyGrid.length > 0 && (
Daily compliance grid · Day × Unit × Driver
One row per operating day, per unit, per driver. Pre = pre-trip DVI on file; Post = post-trip DVI on file; HOS = 160 km exemption status for that driver's day.
{[["Date", "left"], ["Unit", "left"], ["Driver", "left"], ["Trips", "right"], ["Km", "right"], ["Pre DVI", "center"], ["Post DVI", "center"], ["HOS state", "left"]].map(([h, a]) => ( ))} {dailyGrid.slice(0, 60).map((row, i) => ( ))} {dailyGrid.length > 60 && ( )}
{h}
{row.date} {row.unit} {row.driver_name} {row.trips} {row.km.toFixed(1)} {row.preDvi ? "Yes" : "No"} {row.postDvi ? "Yes" : "No"} {row.hosState}{row.hosHours != null && · {row.hosHours.toFixed(2)}h}
+ {dailyGrid.length - 60} additional rows. See full digital record.
)} {/* Section 3: DVI completion log */} {dvirLog.length > 0 && (
DVI completion log · {monthLabel}
Every pre-trip and post-trip inspection filed during the period. Defect details and signatures are in the source PDFs, retained for the full audit retention period.
{[["Date", "left"], ["Time", "left"], ["Unit", "left"], ["Driver", "left"], ["Type", "left"], ["Odometer", "right"]].map(([h, a]) => ( ))} {dvirLog.slice(0, 60).map((d, i) => ( ))} {dvirLog.length > 60 && ( )}
{h}
{d.date_local} {d.time_local || ""} {d.unit} {d.driver_name} {d.trip_type} {d.odometer_km != null ? d.odometer_km.toLocaleString() : ""}
+ {dvirLog.length - 60} additional inspections. See source PDFs.
)} {/* Section 4: HOS / 160 km exemption per-driver summary */} {hosSummary.length > 0 && (
HOS & 160 km exemption summary · per driver
Each driver's day-by-day status under AB Reg 317/2002 §78. "Exempt" = met all three conditions (within 160 km of day-start, returned to day-start, released within 15h). Other columns flag specific exception types.
{[["Driver", "left"], ["Days worked", "right"], ["Exempt", "right"], ["Outside 160 km", "right"], ["Over 15 h shift", "right"], ["Unclassified", "right"]].map(([h, a]) => ( ))} {hosSummary.map(h => ( ))}
{h}
{h.name} {h.daysWorked} {h.exempt} {h.outOfRadius} {h.overHours} {h.unknown}
)} {/* Section 5: Exception detail */} {exceptionRows.length > 0 && (
Exception detail · items flagged for review {["Date", "Type", "Unit", "Driver", "Detail"].map(h => ( ))} {exceptionRows.slice(0, 40).map((x, i) => ( ))} {exceptionRows.length > 40 && ( )}
{h}
{x.date} {x.kind} {x.unit} {x.driver} {x.detail}
+ {exceptionRows.length - 40} additional exceptions. See full ledger.
)} {/* Section 6: External records pointer (always shown) */}
External records (not in this packet)
The records below are required for a complete NSC audit but are maintained outside this fleet-telemetry pipeline. They are produced on request from their respective custodians.
{[ ["Driver commercial licences (Class 1/3), validity, endorsements", "HR file"], ["Driver medical certificates", "HR file"], ["Driver abstracts (current and on-hire)", "HR file"], ["CVIP annual vehicle inspection certificates", "Maintenance file"], ["Insurance / pink slip per vehicle", "Admin file"], ["Incident, collision, and at-fault reports", "Safety file"], ["Drug & alcohol policy and testing records", "HR file"], ["TDG / dangerous goods training, if applicable", "HR file"], ["Driver hire-on records (interview, references, training sign-off)", "HR file"], ["DVI source PDFs with full defect text and signatures", "SiteDocs archive (2-yr retention)"], ].map(([record, where]) => ( ))}
Record type Where to obtain
{record} {where}
{/* Sign-off */}
{["Prepared by (Compliance Officer)", "Inspector / Auditor"].map(label => (
{label}
Name · Signature · Date
))}
Cascade Freight Inc. · Internal compliance document Page 1 of 1
); }; window.AuditExport = AuditExport;