Opensource and web-based Fleet Maintenance Management System based on PHP and MySql
Fleetco is a free & opensource and web-based vehicle fleet maintenance management system written in PHP with MySQL database backend. Fleetco was initially designed for trucking companies but it can be useful for any person or company having a fleet of vehicles. It can be installed on a web server or on a local machine with the use of third-party software such as XAMPP.
It will allow the management to have full control of the maintenance of a vehicle fleet. For instance, the management will be able to answer any questions including:
- Which vehicle/s is giving less than the desired fuel economy?
- Which vehicle/s is getting more repairs?
- How much cost incurred on each and every vehicle in the fleet for a selected period?
- If a company is to sell a vehicle, which one should be the first?
- What is the status of the maintenance inventory stock such as spare tires, engine oil, etc.
It will record and analyze all sorts of expenses relating to vehicle maintenance. It also has an inventory module and accident tracking system. All reports can be easily exported to MS Excel and other formats.
What is New in Version 2
- Fueling Record Maintenance
- Repair Record Maintenance
- Maintenance Record Maintenance
- Inventory Module
- Accident Reporting
- Fuel Efficiency Reports
- Vehicle Expense Reports
- Bootstrap responsive theme
- Customizable columns
- Hide/view columns
- Miscellaneous improvements and bug fixes
System Requirements (Version 2)
- Web server (XAMPP can also be used for local machines)
- PHP 5.0 to 7.0 with mcrypt extension enabled (PHP 7+ may not have mcrypt extension by default)
- MySQL Database
NB: The later PHP versions (above 7.0) may not include mcrypt extension by default. Therefore PHP v7.0 or a lower PHP version is recommended. If you are using XAMPP, please use an older version that has a lower PHP version that is v 7.0 or less. (The upcoming version will support later PHP versions)
Installation on a Local Computer
Installation on a Web Server
1. Unzip the file
2. Upload the file to the hosting root or folder
3. Create a MySQL database using PHPMyAdmin or otherwise
4. In the unzip folder, locate the SQL dump file called mysql-dump-with dummy-data.sql.
5. Import this SQL dump to the database created (This database contains some sample data which you can delete later)
6. Enter the database connectivity details as follows:
Find “ConnectionManager.php” in connections folder and on line 254-258 find below block of code:
- $data[“connInfo”] = “database_host_name”;
- $data[“connInfo”] = “database_user_name”;
- $data[“connInfo”] = “database_user_password”;
- $data[“connInfo”] = “database_port_number”;
- $data[“connInfo”] = “database_name”;
Update your database connectivity details above.
Default values for database port & hostname as follows:
database_host_name = localhost
database_port_number = 3306
If the above default details do not work, contact your hosting provider for the same.
7. Then visit the URL and the login screen should appear now.
8. Use the following admin logins:
Once you log in, go to Admin Area. You can create any no of users with various user rights to different tables. You may delete sample data.