I require php/javascript/jquery code to be created which:
A user will select a start and an end date from a datepicker (or something similar) in a form.
- From these selected dates the code will exclude dates that are 1) holidays (set within the code) 2) weekends
- It will return the working hours taken based upon the above dates using "9hrs per day" OR "8 hrs per day" (i.e - 4 days taken at 9 hours equals 36 hours taken)
- The code will create a new row for EACH day from the days selected, set the amount of hours per day for each and then submit in mysql db
(i.e. - if the user selects Feb/10 to Feb/14 - it will create new entries for each day (feb/10,feb/11,feb/12,feb/13,feb/14 - with a value of 9 for each entry the form is submitted using a unique ID so results can be fetched from the DB as necessary. If any dates fall on a holiday they would be excluded)
Project will be required to be completed as soon as possible.
Hi! I can help you with your project NOW. I am an experienced PHP/JS developer so it will be done quickly. Please check out my profile for background on my skills, past projects and portfolio.
Kindly let me know in case you would like us to complete the job together.
Thanks,
Denislav / beFreeStudio
My proposal is to write you a MySQL Store Procedure that will receive the information you mentioned from the datepicker, plus the hours per day and then the store will calculate the dates and make the inserts into the database.
Here is my proposed timeline
Day 1 - Send you some questions about details on your DB structure - You answer me back with that information.
Day 2 - Build the Store Procedure and send it to you (already tested of course)
Day 3 - Just in case we need any new interaction
I've worked with several different database (Oracle, MySQL, SQL Server) developing several different applications for Logistics, Telecommunications and Energy Industry.
I've even developed a database written entirely in MySQL to keep track of all the information related with Soccer Tournaments that I've used with friends.
My only condition is to use Milestone Payment for the entire project for our mutual benefit.
Let me know in case you have any question or comment about my proposal.
Regards,