A prototype for carrier-facility synchronization and real-time shipment lifecycle management.
Transportation Management system is a full-stack TMS designed to bridge the visibility gap between logistics providers and third-party carriers. It transforms manual yard management into a data-driven operation, focusing on driver accountability, asset uptime, and facility throughput.
I built this system while working as a driver after seeing the constant friction between logistics staff and carriers. Inefficiencies weren't just about data; they were about accountability. When "missed messages" and "lost paperwork" become the standard excuse for delays, the whole yard slows down.
This TMS removes the "he-said, she-said" by creating a definitive, timestamped digital record of every assignment, refusal, and handoff.
- Dynamic Asset Orchestration: Real-time reassignment of drivers to specific facility doors and yard locations based on priority.
- Out-of-Service (OOS) Lifecycle: Integrated maintenance workflow where refused loads automatically trigger trailer OOS status and task assignment for repairs.
- Chain of Custody: Seamless shipment handoffs between drivers with digital "paper trails" and BOL image integration.
- Logistics Pause & Divert: Advanced driver controls for facility stops and shipment pausing, reflecting real-world road conditions and scheduling shifts.
- Goal-Driven Operations: Automated monitoring of facility-specific shipment targets to ensure daily KPIs are met.
- SQLite3 Integration: Utilized for low-latency, file-based relational storage, ideal for high-speed local processing of yard moves and logs.
- Relational Schema: Designed to handle complex many-to-many relationships between drivers, trailers, and multi-stop shipments.
- Data-Heavy UI: Leveraging DataTables and jQuery for high-density information display, allowing dispatchers to filter thousands of records instantly.
- Responsive Management: A Mobile-First approach for driver inputs (refusals, handoffs) combined with a Desktop-First dashboard for facility managers.
The system doesn't just store data; it interprets it to reduce "dwell time" (wait times at facilities):
- Throughput Monitoring: Visualizing shipments per month to identify seasonal peaks.
- Bottleneck Identification: Real-time tracking of facility wait times to optimize door assignments.
- PHP 8.0+
- SQLite3 PHP Extension (Usually included by default, ensure it's enabled in
php.ini)
- Clone the repository
git clone https://github.com/ronbodnar/tms-prototype.git
cd tms-prototype- Set Permissions
The web server needs write access to the SQLite database file and the directory it sits in.
chmod -R 775 data/
chmod 664 data/tms.db- Run the Application
For local development, you can use the built-in PHP server:
php -S localhost:8000Open http://localhost:8000 in your browser.
Alternatively, move the files to your web server root (e.g., /var/www/html or XAMPP's htdocs).
Created by Ron Bodnar
- LinkedIn: linkedin.com/in/ronbodnar
- Portfolio: ronbodnar.com
Distributed under the MIT License. See LICENSE for more information.