347c97ec4c
Add reporting.fn_fleet_segment() and reporting.v_vehicles, splitting the fleet into ticket-closing field_service vs specialist plant (crane/pick-up/motorbike) that does not close immediate customer tickets. The segment is DERIVED from tracksolid.devices.vehicle_models — itself an authoritative Tracksolid API field (sync_devices maps jimi.user.device.list -> vehicleModels) — so it stays API-current with no re-seeding; the manual vehicle_category column is intentionally unused. v_vehicles collapses the tracker+dashcam device pairs to one row per vehicle by reusing reporting.normalize_plate() and the same primary-device precedence as reporting.v_trips / v_live_positions (auto-merges 'KDS 453Y'/'KDS 453 Y', resolves within-plate model conflicts via the primary tracker). Verified live: 80 vehicles (61 field_service / 16 specialist / 3 unassigned), grafana_ro granted. Includes the supporting data-quality report. Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com> |
||
|---|---|---|
| .. | ||
| 260410_baseline_report.md | ||
| 260412_baseline_report.md | ||
| 260427_audit_output.txt | ||
| 260427_device_reconciliation.md | ||
| 260601_improvement_claude_48.html | ||
| 260605_ops_purge_backup.md | ||
| 260608_fleet_registry_data_quality.md | ||
| 260608_fleet_registry_data_quality.pdf | ||
| new_feature.txt | ||