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:
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..
"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!