İptal Edildi

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.

Beceriler: Javascript, PHP, Web Sitesi Tasarımı

Daha fazlasını görün: timesheet intranet, php mysql timesheet, php timesheet, work php online, php online job, php mysql job, php mysql create, php job online, php company, online php work, online php job, js do, get value javascript, get php projects work, get php projects online, get php projects, draw want, uses excel, online mysql database, if js, excel uses, want employees, get php, download mysql, simulate

İşveren Hakkında:
( 1 değerlendirme ) Washington, DC, United States

Proje NO: #43546

4 freelancer bu iş için ortalamada 300$ teklif veriyor

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 Daha fazlası

in 10 gün içinde300$ USD
(264 Değerlendirme)
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 fields.We are 100 Daha fazlası

in 10 gün içinde300$ USD
(76 Değerlendirme)
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. Daha fazlası

in 28 gün içinde298$ USD
(8 Değerlendirme)
5.9
webdreamer

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

in 30 gün içinde300$ USD
(8 Değerlendirme)
4.5