Performance Indicator System using PHP/MySQLi with Source Code

This project is entitled Performance Indicator System that was developed using PHP/MySQLi. This is a system that determines the performance of the entities involved in the system. In this system's case, it determines the top product and dealer and presents a yearly graph of the sales of products with the use of Chart.js Library. This system features a purchase reservation on the dealer side and system management on both the admin and staff side. Also, on the stock side, it can update stocks of products. In this system, the dealer is allowed only to reserve or purchase products quantity that will cost not more than their credits. Each dealer credit can be set in this system dynamically which can be manipulated or managed by the users that have access to the users' list. The system also generates printable reports of the sales and inventory list. These reports can be filtered by the custom selected date range. The system has multiple types of users which are the administrator, dealer, staff, and the stock in charge. The access/permissions of each user level will be stated below.

This project is free to download. Feel Free to download and modify the source code the way you desire. This project was developed using PHP, HTML, CSS, Javascript, and Bootstrap for the design.

Features

Administrator

• Home Page
• View Performance
• Manage Reservations
  • Pending
  • Confirmed
  • Declined
  • Expired
• Manage Master Files
  • Users
    • Employees
    • Dealers
  • Products
• Generate Reports
  • Sales Report
  • Inventory Report
• System Logs
  • User Logs
  • Activity Logs

Dealer

• View Product List by Category
• Create Reservation
• View Reservation List
• View Reservation Details

Staff

• View Performance
• Manage Reservations
  • Pending
  • Confirmed
  • Declined
  • Expired
• Manage Master Files
  • Dealers
  • Products
• Generate Reports
  • Sales Report

Stock In-Charge

• Manage Reservation Claims
• Manage Products/Inventory
• Generate Reports
  • Inventory Report

How to Run

Requirements

• Download and Install any local web server such as XAMPP/WAMP.
• Download the provided source code zip file. (download button is located below)

Installation/Setup

1. Open your XAMPP/WAMP's Control Panel and start the "Apache" and "MySQL".
2. Extract the downloaded source code file.
3. If you are using XAMPP, copy the extracted source code folder and paste it into the XAMPP's "htdocs" directory. And If you are using WAMP, paste it into the "www" directory.
4. Browse the PHPMyAdmin in a browser. i.e. http://localhost/phpmyadmin
5. Create a new database naming "opils".
6. Import the provided SQL file. The file is known as "opils.sql" located inside the db folder.
7. Browse the Performance Indicator System in a browser. i.e. http://localhost/opils

Credentials

Admin

Username: admin
Password: admin

Sample Dealer

Username: julyn
Password: julyn

Sample Staff

Username: clene
Password: clene

Sample Stock In-charge

Username: rudy
Password: rudy

Demo

That's it! You can now explore the features and functionalities of this Online Performance Indicator System Project to have a better idea about this PHP/MySQLi Project. I hope this PHP Project Source Code will help you with what you are looking for and for your future project.

You're free to modify or change the system depending on your preference. If you have comments or questions, feel free to comment or message me.

Happy Coding :)