Web-Based Fleet Management · Healthcare Sector

Vehicle Management
System (VMS)

A centralized digital platform that replaces manual vehicle registers, fuel books, maintenance logs, and insurance files with an integrated, role-aware fleet management system built for healthcare institutions.

🚗 Fleet Registry ⛽ Fuel Monitoring 🔧 Maintenance Tracking 📋 Compliance Management 📊 Analytics & Reports
7
Core Components
10
Database Entities
3
User Roles (RBAC)
OTP
2-Factor Auth
PDF+XLS
Export Formats
Auto
Expiry Alerts

Three-Tier Architecture

A classic three-tier model separating the presentation, application, and data layers — ensuring maintainability, scalability, and clean security boundaries.

Presentation
Layer
HTML5 CSS3 Bootstrap JavaScript AJAX Chart.js DataTables.js
Application
Layer
PHP Business Logic Authentication Engine RBAC Module Notification Engine Reporting Engine PHPMailer FPDF / TCPDF
Data
Layer
MySQL Database Vehicle Records Fuel Logs Maintenance Records Compliance Data phpMyAdmin

Seven Integrated Modules

Each module addresses a specific operational domain of healthcare fleet management, from secure login through to PDF report generation.

🔐

User Authentication & Security

Secure login with Bcrypt password hashing, OTP two-factor verification, session management, and full audit trail logging for all user activity.

OTPBcryptAudit LogSession Control
🚗

Vehicle Registry Management

Complete fleet registry with vehicle registration, profile management, fuel type classification, and real-time operational status tracking across all institutions.

Fleet RegistryStatus TrackingProfile Editing

Fuel Management System

Structured fuel entry recording with automated consumption calculations, cost analysis per vehicle, and trend reporting to identify inefficiencies.

Consumption CalcCost TrendsFuel Reports
🔧

Maintenance Management

Preventive maintenance scheduling by mileage or calendar interval, corrective repair tracking, service history per vehicle, and cost recording for budget analysis.

PreventiveCorrectiveCost Recording
📋

Insurance & License Management

Digital storage of insurance certificates and revenue licenses, expiry date tracking, automated renewal reminders, and compliance status dashboards.

Expiry AlertsRenewal TrackingCompliance
📁

Document Management

Paperless archive for service bills, insurance certificates, and revenue licenses. All uploaded files stored and indexed against vehicle records for instant audit retrieval.

UploadPaperless ArchiveAudit-Ready
📊

Reporting & Analytics Engine

Consolidated vehicle, fuel, maintenance, and compliance reports. One-click export to PDF (FPDF/TCPDF) and Excel formats for management review and audit submission.

PDF ExportExcel ExportDashboards

Application Interface — Demo Data

All vehicle registrations, fuel figures, and records shown are entirely fictional. This preview demonstrates the layout and data workflow of the live system.

Vehicle Management System · Fleet Dashboard ·

Fleet Dashboard — Operational Overview

42
Total Fleet
↑ 2 this quarter
34
Running
81% availability
5
Under Repair
3 due back soon
3
Compliance Due
Within 30 days

Vehicle Registry — Recent Entries

⚠ Demo Data Only
Reg. Number Type Fuel Institution Last Service Insurance Status

Built-In Fleet Analytics

All reports are generated server-side and exportable to PDF or Excel. Charts are rendered client-side via Chart.js from live MySQL data.

Monthly Fuel Consumption — Litres (Demo)

Fleet Status Breakdown (Demo)

Maintenance Cost by Month — LKR (Demo)

Fuel Cost vs. Maintenance Cost Trend (Demo)

Login to Report — 8 Steps

A structured sequential flow from user login through to report generation, with automatic notification triggers at each compliance checkpoint.

1

User Login

Web browser access via secure login

2

Auth & OTP

Credentials + OTP two-factor verification

3

Role Check

RBAC enforces scoped access permissions

4

Dashboard

Role-specific widgets rendered

5

Module Access

Vehicle / Fuel / Maintenance / Compliance

6

DB Transactions

All entries persisted in MySQL

7

Notifications

Auto expiry reminders triggered

8

Reports

PDF & Excel export generated

10 Core Database Entities

MySQL schema designed around fleet management domains, each entity responsible for a distinct set of operational records.

👤 Users
Username · Password Hash · User Role · Institution Assignment
🏥 Institutions
Institution Details · Type · Region
🚗 Vehicles
Registration No. · Vehicle Type · Fuel Type · Operational Status
Fuel Logs
Quantity · Cost · Date · Vehicle Reference
🔧 Services
Service Type · Provider · Cost · Service History
📋 Insurance
Policy Details · Expiry Dates · Certificate Files
📃 Licenses
Revenue License Details · Renewal Dates
🗺️ Trips
Vehicle Usage · Movement Records · Purpose
🔔 Notifications
Alert History · Reminder Records · Delivery Status
📁 Documents
Uploaded Files · File References · Vehicle Link

Multi-Layer Security Design

Built to protect fleet data against unauthorised access, session hijacking, and data breaches across all user roles.

🔐 Authentication

Username/password validation combined with OTP two-factor verification. All sessions validated server-side with automatic blocking on unauthorised access attempts.

🛡️ RBAC — Three Roles

Admin, Unit Officer, and Institution User roles with scoped access permissions. Each role sees only the data and modules relevant to their function.

🔑 Password Security

Bcrypt-based hashing via PHP's password_hash() and password_verify(). No plain-text credentials stored.

✅ Data Validation

Server-side input validation on all form submissions. Form-level integrity checks prevent malformed or malicious data from reaching the database layer.

📋 Audit Trail

Comprehensive login tracking and activity logging. All data modifications are time-stamped and attributed to specific users for full accountability.

🔒 Session Security

Active session validation on every request. Expired or invalid sessions are automatically invalidated and redirected to the login page.

Open-Source & Production-Grade

Entirely open-source stack — no licensing costs, well-supported community, deployable on existing XAMPP infrastructure.

Frontend

HTML5CSS3 BootstrapJavaScript AJAXChart.js DataTables.jsFont Awesome

Backend

PHP PHPMailer FPDF TCPDF

Database

MySQL phpMyAdmin

Dev Environment

XAMPP Server Apache

Scalability & Future Architecture

The VMS is architected with future expansion in mind, aligned with national digital health infrastructure plans.

📍 GPS Tracking

Real-time location monitoring integrated into the fleet dashboard.

📱 Mobile Application

Cross-platform mobile client for field officers and drivers.

🤖 Predictive Maintenance

AI-driven alerts based on usage patterns and historical service data.

☁️ Cloud Deployment

Migration to a managed cloud environment for high availability.

💾 Automated Backup

Scheduled backups and disaster recovery protocols.

🔗 Gov. Integration

API interfaces with national e-Government platforms and health data systems.

📈 AI Fleet Analytics

Machine learning models for fuel efficiency and cost optimisation.

🌐 Multi-Language

Tamil and Sinhala language interface support for wider accessibility.

A Portfolio Demonstration of Healthcare Fleet Systems

VMS illustrates full-stack web application development applied to a real administrative problem — replacing paper registers with a secure, role-aware digital platform.

GitHub Repository View Portfolio

👨‍💻 About the Developer

Dr. T. Jeevaraj

Dr. Thangarasa Jeevaraaj

MBBS · MCGP · MSc Biomedical Informatics · MD Trainee, Health Informatics
PGIM, University of Colombo · Sri Lanka

Clinician-developer working at the intersection of medicine and software engineering. Builds open-source digital health tools — from community disease surveillance apps to healthcare fleet management systems — aimed at improving health system efficiency in resource-limited settings.

🌐 Website 📄 CV 💻 Dev Portfolio LinkedIn 𝕏 Twitter 📚 Book