Home | How it works | Projects archive | Contact Us
Air Compressor Bot
 
The Career Path of Freelance Programming Jobs 

   PHP/MySQL/JS Timesheet Intranet

Bidding Time:
08/02/2006 22:04 - 15/02/2006 00:00
Budget:
$100-300
Status:
Closed


Job Type:
PHP, Website Design, Javascript
Description:



Professional Hosting from Just Host

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.

Start your work-at-home career for $7.00. Get direct access to thousands of freelance and home-based jobs. Click here to find work now.

Related Projects:
Training System In Php
Script Specification Advice
Buying Ready To Go Php Scripts
Logo for Health Services Company
Suchgreatdeals

This project is the proprietary information of . Click here to remove this project from OUR database.
Operating System:
MS Windows
Database System:
MySQL
<<< back

Recent Projects Archive:

Thursday - Wednesday - Tuesday - Monday - Sunday - Saturday - Friday

View all freelance web projects

 
Home | Projects archive | RSS | Resources | Links | Contact Us © 2004-2008 ProjectsList.biz /10.983