Transport operations system
Transport Operations Platform
Drivers Management turns an exception-heavy transport operation into a clear system: drivers, shifts, calendar, schedules, vacations, compensations, reports, fleet, and settings live together with company rules, history, and traceability.
Year
2026
Duration
Long-running evolving product
Budget range
High-scope custom system
Service
Custom internal application
Case notes
What had to be solved and how it was shaped.
Challenge
The challenge was not creating another dashboard. It was translating labor rules, company changes, individual conditions, holidays, bonuses, rests, history, and period locks into a fast interface an operations team can use every day without breaking sensitive data.
Solution
I designed a modular React, TypeScript, and Supabase application: each area has its own workflow, while sharing roles, tenant context, calculation rules, audit logs, imports, exports, and a data layer built to evolve.
Outcome
A daily operations tool prepared for real work: intelligent search, individual rules, variable calculations, Excel imports, PDF/Excel exports, audit logs, and multi-company modules.
Results
- Complete management of drivers, shifts, vacations, compensations, fleet, and reporting from one platform
- Advanced rules for individual conditions, automatic variables, holidays, rests, effective hours, and period locks
- Excel import/export, PDF reports, audit logs, roles, multi-company support, and foundations for email/WhatsApp notifications
Scope
Technology
A stack chosen for the job, not for decoration.
Capability map
Every layer that makes this project substantial.
Central operations platform
The product works as a daily control center for a transport operation, not as a loose collection of screens.
- Navigation across core areas: Drivers, Calendar, Scheduling, Reports, Compensations, Vacations, Audit, and Settings
- Multi-company architecture prepared to separate data, rules, and configuration by tenant
- Interface designed for non-technical teams that need speed, clarity, and safety around sensitive data
Access, roles, and security
The system foundation prioritizes sessions, permissions, and information isolation before any visible feature.
- Supabase Auth login and user validation before internal modules are rendered
- Operational roles for administration, management, and users with different access levels
- Row Level Security, tenant policies, and protected routes to prevent data leakage
Advanced driver management
The driver module centralizes each person's operational profile and reduces friction across search, filters, and daily maintenance.
- Full CRUD with company, status, driver number, contact details, and internal notes
- Search by name, surname, and number with accent normalization and relevance ranking
- Filters by status, company, and individual conditions, plus Excel import/export for bulk work
Individual conditions and company synchronization
The system models special driver conditions and keeps data coherent when company or applicable rules change.
- Daily, weekly, or monthly individual condition configuration with dates, notes, and fixed amounts
- Preview of affected shifts when a driver changes company
- Controlled variable synchronization and archived-period exclusion to protect historical data
Calendar and shift engine
The calendar does more than render days: it calculates work types, times, rests, excess hours, variables, and real operational exceptions.
- Monthly and daily views with shift creation, editing, and deletion
- Continuous or split shifts with one or two time ranges and total/effective hour calculation
- Shift types, observations, delivered report date, and manual or automatic variables
Bulk operations and data quality
For real operations, the system includes tools that speed up repetitive work without sacrificing validation.
- Bulk shift creation, test data, and month cleanup when a scenario needs to be reset
- Daily shift-number validation to prevent duplicates and database 409 errors
- Pagination, sorting, and refined dialog UX for days with many shifts
Scheduling, planning, and publishing
Planning separates what is being built from what is published, with support for annotations and operational checks.
- Weekly, monthly, quarterly, or custom-period scheduling with company and driver filters
- Database persistence for seasonal plans, targets, and annotations
- Publishing shifts to the calendar with automatic variables applied by company and work type
Reports, payroll, and closing
The reporting area turns daily data into economic, historical, and actionable administration views.
- Date, company, and driver filters with active tags and locked views
- Driver summaries, variables, individual conditions, fixed monthly amounts, CP+QM, and holiday compensation
- Period archive and reopening flows for closing work while preserving consultation
Professional exports
The application is prepared to move information out of the system in formats administration teams can use directly.
- PDF, Excel, and advanced Excel export from reports and weekly summaries
- Weekly summary with daily hours, presence, effective hours, excess hours, and economic impact
- Specific helpers for payroll export and column configuration
Compensations and holidays
The system tracks compensations with status, dates, and direct relation to the shifts that originated them.
- Filterable and searchable compensations list
- Compensatory-day granting with date, day type, and visual status
- Editing for granted compensations and clear pending, used, or resolved states
Vacations and monthly history
The vacations module blends calculation, history, and controlled editing to avoid parallel spreadsheets.
- Driver search and vacation metric cards
- Plus Vacaciones calculation and related variable breakdown
- Editable monthly history, structured saves, Excel import, and template download
Settings and business rules
Rules live inside the product so operations can evolve without code changes for every small adjustment.
- Management for companies, variables, variable rules, holidays, and shift types
- Seniority rates and associated recalculations
- Configuration for vacations, history, reports, and communication
Audit and traceability
Every important operation needs a trace to understand who did what and when.
- Audit module with filters by user, action, resource, and date range
- CSV export and controlled cleanup for old records
- Toasts, confirmations, and progress states for creation, editing, deletion, imports, and synchronizations
Fleet, staff, and modular growth
The architecture leaves room to grow beyond drivers without mixing domains that should remain separate.
- Fleet module designed to evolve bus control, compliance, and related data
- Staff attendance roadmap separated from drivers, shifts, payroll, and vacations
- Modular design so new domains can be added without breaking the operational core
Notifications and operational delivery
The project includes real foundations for sending shifts and events from the platform.
- Technical WhatsApp queue with tenant settings, driver preferences, and delivery status
- Daily email test via Supabase Edge Function and Resend to validate shift delivery
- Design prepared for retries, delivery audit, and future full integration with Meta Cloud API
Migrations and self-hosted deployment
The system accounts for real production cases where the database does not always follow the ideal path.
- Supabase migrations and production SQL for critical entities
- Self-hosted schema reconciliation with migra when migration history does not exist
- Scripts and verification checks to compare the expected schema against a remote database