Project Time Management System in CSIT
This is a web-based application that provides an online platform for a certain company's employees to report/record their time allotted or time retendered per project. The system also helps the company to monitor their employees' rendered time and work done per project. This has a pleasant user interface and user-friendly functionalities.
Our project consists of
- ptms : Frontend application.
- ptms API: Backend application API with MySQL Workbench.
- ✅ HTML for creating frontend application.
- ✅ JavaScript for building our frontend HTML application
- ✅ Bootstrap for styling our application.
Our main language of development is PHP
- MySQL Workbench for our database.
First, check the required
- Bitnami Applications for PHP or other application server.
You can check by typing
into the your browser.
http://localhost:8080
You can download Bitnami here
You go to your browser and paste url http://localhost:8080/Name your project folder.
will see the web application runs at http://localhost:8080/Name your project folder.
Reminder: this topic needs to be done only once.
check file initialize.php to setting base_url that is correct port and project folder fo but in my setting port is 8888 you should change it Usually the normal port is at 80 or http://localhost
and correct name database user name and password
Reminder: this topic needs to be done only once.
At ptms, we use MySQL Workbench to store user data and credentials, this section will teach you how to set up the database locally. But first of all
- You should have MySQL Workbench installed in your machine.
- You should know your master password of
phpmyadmin
superuser. (They will ask for it during the installation).
If top 2 requirements surpassed. You're ready to develop ptms's database. These are steps to get the database running.
if you want to develop more database use My SQL Workbench for easy to add more table or etc.
WARNING: You should follow the instructions exactly or you'll end up with a broken database that's super hard to work with and fix.
-
Go your browser
Login php my admin on your browser
Next
CREATE DATABASE "ptms" select utf8 unicode ci and then click Create ;
This means you've successfully created a database.
-
import simple database
Click import on your database and select file.sql on floder db
and click go You should see a message saying
Import has been successfully finished.
This means you've import successfully to the database.
- 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
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/
admin
- jimmyyjp password 9981
- phuwin password 9981
- fforce password 9981
- kasibook password 9981
staff
- ppromxx password 9981
- seatawinan password 9981
- bbverpj password 9981
- firstkp password 9981
Employee
- yin@nu.ac.th password 9981
- bestboom@nu.ac.th password 9981