Lojaroute

Problem

Dispatchers were assigning vehicles by phone with no live view of where the fleet was. Deliveries had no proof of handoff, so disputes came down to one person's word against another's. Cash collected on delivery was reconciled on paper at the end of each day, and discrepancies were often found too late to trace.

Solution

A multi-tenant fleet platform pairing a dispatcher dashboard with a driver mobile app. Every branch's data is isolated at the database layer, vehicle positions stream live to the dispatch board, and cash-on-delivery reconciles automatically as drivers complete jobs.

Key Features

• Branch-level data isolation enforced in the database rather than the UI — operators running multiple branches never see each other's jobs, and a bug in the frontend cannot leak them
• Cryptographically signed QR handoff verification that produces tamper-evident proof of pickup and delivery, settling disputes without SMS or OTP costs
• Live fleet positions streamed to the dispatch board, so dispatchers assign work against real vehicle locations instead of phone estimates
• Cash-on-delivery handled as a state machine with automatic timeout recovery, so a stalled payment never blocks a driver at the door
• Route playback with stop detection, giving operators an auditable record of where a vehicle actually stopped and for how long
• Self-healing payment gateway workers that recover abandoned transaction sessions without manual intervention
• B2B client portal with self-registration, KYB document verification, and per-contract rate cards, removing manual onboarding for corporate accounts

Challenges

• Guaranteeing tenant and branch isolation across 95+ relational tables. Enforcing it in query middleware rather than per-endpoint meant a missed check in a single route could not expose another operator's data.
• Keeping the dispatch board responsive while consuming high-frequency GPS streams from an active fleet, without the main thread stalling as vehicle count grew.
• Making handoff verification work in low-connectivity areas where drivers actually operate — which ruled out any design dependent on SMS delivery or a reliable connection at the doorstep.

Results

• Shipped a production fleet platform serving multiple operators, with B2B client onboarding and automated billing running unattended.
• Cut booking creation time with a guided multi-step wizard offering live price estimation and draft persistence, so interrupted bookings resume instead of restarting.
• Replaced end-of-day paper cash reconciliation with an automated pipeline, removing driver wait time at handoff and surfacing discrepancies the same day rather than the next.