Online Project Time Management System in PHP MySQL

Description

The Online Project Time Management System is a web-based application platform for recording the employee’s time rendered for work on an assigned project. This has a user-friendly interface functionalities. 

About the System

This project was developed using the following:

• XAMPP v3.3.0 as local webserver that has a PHP Version 8.0.7
• PHP Language
• MySQL Database
• HTML
• CSS
• JavaScript
• jQuery
• Ajax
• Bootstrap
• AdminLTE

This Online Project Time Management System has an Admin Panel where the company’s management can encode their employees’ credentials to access the system. The system has 2 types of users who can access the Admin Panel which are the Administrator and Staff. The Administrators are the users that have the privilege to access all the features and functionalities of the Admin side of the system while the Staff has only limited access to it. The employees are required to log in with their system credentials to allow them to report their work on specific projects, generate reports, and manage their accounts.

Features of the System

The Admin Panel includes the following features

• Secure Login and Logout
• Dashboard
  • Display the summary of lists
• Work Type List Management
  • Add New Work Type
  • List All Work Types
  • View Work Type
  • Update Work Type
  • Delete Work Type
• Employee Management
  • Add New Employee
  • List All Employees
  • View Employee Details
  • Update Employee Details
  • Delete Employee Details
• Project Management
  • Add New Project
  • List All Project
  • View Project Details
  • Update Project Details
  • List Project’s Employees Report List
  • View Employees Report
  • Overwrite Employees Report
  • Delete Employees Report
  • Close Project
  • Delete Project Record
• Reports
  • Total Rendered Time
  • Rendered Time of Employees
  • Employee Time Allotted Per Project
  • Print Reports

• Manage User List (CRUD)
• Manage Account Details/Credentials
• Manage System Information

The Employee-Side Panel includes the following features:

• Secure Login and Logout
• Project Management
  • List All Project
  • Add New Report Per Project
  • View Project Details
  • List Reports on Project
  • Update Report
  • Delete Report
• Reports
  • Rendered Time Summary
  • Time Allotted Per Project
  • Print Reports
• Manage Account Details/Credentials

System Snapshots of some Features

Dashboard (Admin-Side)

Rendered Time of Employees Report (Admin-Side)

Employee Report on Project Details (User-Side)

Employee Report on Project Form Modal (User-Side)

Time Allotted per Project Report (User-Side)

How to Run

To run this system you must have download and installed a local web server such as the XAMPP on your PC or laptop (for Windows).

1^st Step: Enable the GDLibrary in your php.ini file.

2^nd Step: Open your XAMPP Control Panel start Apache and MySQL

3rd Step:  Download and Extract the source code file zip file (See download button)

4^th  Step: Copy the extracted source code folder and paste it into the xampp/htdocs

5^th Step: Open a browser and go to URL “http://localhost/phpmyadmin/”

6^th Step: Create a new database naming ptms_db

7^th Step:  Click on the “Import” tab and select “ptms_db.sql” file which is located inside the database folder. Click on Go.

After Creating Database

8^th Step:  Browse the Online Project Time Management System in a browser i.e. http://localhost/ptms/ for the employee side and http://localhost/ptms/admin for the admin side.

Default Admin Access

Username: admin
Password: admin123

Sample Employee Access

Email: mcooper@sample.com
Password: mcooper123