Đã Hủy

PHP/MySQL/JS 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: timesheet intranet, php mysql timesheet, php timesheet, work php online, what does data entry do, what can i do with php and mysql, want to online job in excel data entry, php save as, php online job, php mysql job, php mysql create, php job online, php company, online php work, online php job, js do, i need data entry projects number, i m looking for employees, i look for data entry online job, how to get the data entry projects, how to get php projects, how to get a value in javascript, how to get a data entry job online, how can i get online data entry job, how can i get an online job

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

Mã Dự Án: #43546

4 freelancer đang chào giá trung bình $300 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
(264 Đánh Giá)
9.1
websoftinfo

Hello Sir We are an offshore well established company for about more than five years. We have experienced developers (PHP, ASP, ASP.NET, MYSQL, C# etc.) and those are dedicated in their respective [url removed, login to view] are 100 Thêm

$300 USD trong 10 ngày
(76 Đánh Giá)
6.6
rushi2440

Dear Sir, Myself Rushikesh Patel, I was working with Anand Systems Inc from last 4 years as Sr. Web Designer/Graphic Designer/Webmaster/Web Specialist/Web Master. Please find my resume attached in .doc word format. Thêm

$298 USD trong 28 ngày
(8 Đánh Giá)
5.9
webdreamer

Dear Sir, We have understood your requirements and ready to start. Please check your PMB for more details. Thanks

$300 USD trong 30 ngày
(8 Đánh Giá)
4.5