We have a MySQL database in which we store timesheet data for our company. We bill by project, sub-project, and phase. All work is billed to a project, and there may be a sub-project and/or a phase.
If you are the winning bidder, then I will get you a MySQL dump file that you can use to simulate our dB. We have tables established for employees, projects, sub-projects, phases, and time records (timesheet data).
I'm looking for a PHP/MySQL interface to work as an Intranet-based timesheet. You can completely forget about looks at this point. All I want is the guts of a working Intranet site. I will add all of the look/feel stuff later.
Users will need to login using a password. Once logged in, users should be presented with one weeks worth of time entry slots. The script should scan the dB first and see if he/she has already entered any time in for that week. If so, it should display the time already entered, allowing the user to edit/add/modify the entries. Once the user has finished with the week, he/she can click save to dump the data back to the dB. Note that it needs to be dummy proof. So if the dB pulls time data for one day, and then the user deletes the value, the script needs to recognize this and delete the associated time record.
The user should be able to move forward/backward one week at a time. If he/she clicks a forward/backward button and hasn't saved any changes, then he/she should be notified of such.
For a *start* of how I want the timesheet to work, see the HTM file that I've uploaded. This is from an online company that sort of does what I need to do. You will need to insert JS to make the columns/rows add correctly.
If you download the Excel file, you will see a working example of what I want, except pulled from/and updated to a dB. (And only showing one week at a time, not an entire month as the Excel file does.)
The web version needs to work like the Excel version. You will see that the Excel version uses dependent lists. If you pick certain projects you will only get the applicable sub-projects. I need the PHP version to also draw this list reference from the dB and create JS dependent lists to give subprojects specific to a project and fill in the appropriate job number, also drawn from the dB. The phase drop-down list should also be drawn from the dB.