Đang Thực Hiện

PHP/MySQL/Javascript Timesheet Intranet

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.

Kỹ năng: Javascript, PHP, Thiết kế trang web

Xem thêm: javascript timesheet, timesheet mysql, php mysql timesheet, timesheet php mysql, timesheet javascript, php timesheet, timesheet php javascript, mysql timesheet, javascript time sheet, intranet project php, php daily timesheet, project timesheet php script, intranet javascript, projects php mysql javascript, work php online, php online job, php mysql job, php mysql create, php job online, php company, online php work, online php job, job javascript, javascript download, get value javascript

Về Bên Thuê:
( 1 nhận xét ) Washington, DC, United States

Mã Dự Án: #49033

Đã trao cho:

justinsylas

Sir, we well in this kind of projects.(www.thesalesclub.com) kind regards, justin

$300 USD trong 15 ngày
(38 Đánh Giá)
6.6

6 freelancer đang chào giá trung bình $289 cho công việc này

phpMaestro

Hi, We have over 5 years of experience of web designing, search engine optimisation and web programming on php and other web technologies and programmed many applications. We are confident to complete this project with Thêm

$300 USD trong 10 ngày
(266 Đánh Giá)
9.2
Maestros

Plz check PMB

$300 USD trong 15 ngày
(131 Đánh Giá)
8.4
cstl

Chandusoft is a customer-specific service oriented company has got an Professional and creative team with 6 years experience in Web design and development. We have expertise and experience in ecommerce site development Thêm

$240 USD trong 10 ngày
(20 Đánh Giá)
7.0
websoftinfo

Our bid is for really very high quality work for your PHP/MySQL/Javascript Timesheet Intranet that will be made to be upgradable in case you need some upgrades in future. We will always be available for upgrades. Our b Thêm

$300 USD trong 10 ngày
(77 Đánh Giá)
6.6
krrk

Please check PMB for complete details and will discuss more about the work flow and specficiations.

$295 USD trong 5 ngày
(1 Đánh Giá)
5.1