Timesheet PHP Script

Overview

Each company needs a timesheet to record employee’s work hours. This website can do it for you. Creating a timesheet has never been so easy! It uses jQuery “Drag, Drop and Sort” feature to let you drag an item from a list, then drop to your compose area, then sort them if you want. You can also delete an item.

1. for users, there is a mobile friendly create timesheet page.
2. for managers, there is a review associates’ timesheets page.
3. for accounting department, there is a report page for exporting employee’s timesheet in csv, excel, JSON and pdf format. Then the accontant can do some analysis with the excel file or import the file into another website or database.
4. for CEO and management, there are dashboard and report pages. The dashboard page can show you the how many time is spent for each project. The report page can export timesheet report in excel, csv, JSON, and pdf format.

This website has access restriction feature. You can give access to a department (called “division” in this software), a role or an employee to read/create/edit/delete a specific page.

This website is responsive design. You can use it from your cellphone, iPad, Notepad. Then the layout will change accordingly. For example, here is a example for cellphone:

Documentation website:
https://timesheetdocumentation…

Demo URL (Email functionality is disabled):

http://timesheet2018.herokuapp.com/index.php/

website log in username: admin, password: K1H8G9p2A7V3i5Z6@T7!

After log in as admin, you can go to setting->user page to impersonate as manager or user to see a different menu

Company website:

https://mingsitservices.heroku…

Features

1. Responsive design. You can create a timesheet from cellphone.
2. Access pages based on your role. Managers review and approve your timesheet.
3. Managers can review associates’ timesheets. Managers can access dashboard to see charts. Managers can access report page to see and export files.
4. Admin role can change settings and impersonate as anyone in the system.
5. Auto email feature. Once a new timesheet is created, a timesheet is updated or a timesheet is reviewed by a manager, email can be sent to admins, managers and users.
6. Web hook feature. Once a new timesheet is created, a timesheet is updated or a timesheet is reviewed by a manager, the data can be posted to many outside websites.
7. Constant value can be changed by admin. The web application’s setting can be changed by changing the constant values.
8. Report page can let you export data as excel, csv, pdf or json files.
9. Dashboard page can show you each typecategory’s used hours. It’s for the higher management to see each typecategory’s progress.

Requirements

1. You can run it on any platform: Windows, Mac, Linux.

2. Database is MySQL. It’s free.

3. PHP

4. Apache, Nginx or IIS as web server

Instructions

1.    Create database and tables.

In a database tool such as MySQL Workbench, execute the SQL in file timesheet.sql.

2. Copy all the files into a folder.

3. set up web server: Apache, Nginx or IIS