En cours

PHP Timesheet

I am currently taking bids on a simple PHP based timesheet application. The primary use will be via iPad on a hosted site with PHP and mySQL.

The application will require the following pages/functions:

Admin Page:

Add/Delete Employee

Add/Delete Job Number

Add/Delete Cost Codes

Data Entry Page- We would like for this page to a multi line excel style page where we can eneter multiple employees time for a given day without having to submit then go back and start the process over again. 20 lines should be sufficient.

Choose Date for time entry - Calendar button preferably

Employee Name field should be a drop down box ordered by last name alphabetically

Job Number field should be a drop down box with all available job numbers

Cost code should be a drop down box with all available cost codes for that job. Please note: Each job has it's own unique cost codes. Please tie the job number to the cost codes.

Hours worked - Manual Entry - Text based data example : 1A or 3G, etc..

Report Page:

"Enter week ending date" function. For any given date that we enter on this page, we would like for the timesheets to generate appropriately. Please see the attached Excel form for an example of what this page should look like. Please calculate all fields appropriately.

For example: date entered is 5/13/2012. Upon hitting submit, the report should display the 6 days prior to 5/13/2012, all cost codes and hours that Employee X worked for each cost code and day. All hours should be added up and displayed on a per day basis. All hours for a given week should be added and displayed in the total hours field. The overtime hours field should have some conditional logic such as "If 'Total Hours' > 40 then 'Total Hours' - 40 = 'Overtime Hours' and 'Regular Hours' = 40, else 'Overtime hours' = 0 and 'Regular hours' = 'total hours'"

I look forward to your bids. Thanks!

Compétences : HTML, iPad, MySQL, PHP, Design de site internet

Voir plus : php timesheet, timesheet php, php simple timesheet excel, php timesheet entry, php timesheet excel, php simple timesheet application, php manual, php codes website design, design tie, data entry process available, data entry application design, conditional design, calendar style timesheet php, ipad timesheets, manual style, logic x, employee timesheet, php data entry display, php form mysql page, php display week calendar, application page data entry, data entry tie, submit data php simple, timesheet entry, time entry ipad

Concernant l'employeur :
( 3 commentaires ) St Augustine, United States

N° du projet : #1630025