![]() ![]() |
Home |
How it works |
Projects archive |
Contact Us Air Compressor Bot |
|
| The Career Path of Freelance Programming Jobs |
Rental Item Availability |
![]() |
Bidding Time: |
22/05/2006 23:33 - 29/05/2006 23:33 |
Budget: |
N/A |
Status: |
Closed |
|
|
|
Job Type: |
|
Description: |
I have a script that is supposed to check the availability of items in the database for rental. Basically an item can be rented out for a given period of time which would make it unavailable to any new rentals that would fall within that same date range. Think of it like a car rental reservation program. The part that checks item availability does not function properly and the original programmer has disappeared on me. So I need someone who can fix just this one part of the script. I have attached the script in question and the part that needs fixing is between line 266 and line 513 and is tagged as show_add_item_2. Here is what I need it to do... 1) check the out time of all rentals in the database and compare it to the in and out time of the new reservation. 2) check the in time of all rentals in the database and compare it to the in and out time of the new reservation. 3) Display only items which are not rented out during any part of the new reservation. Example... If I rented out Car A during June 9th through June 12th then Car A cannot be available for any rental which has an Out or In date that falls between June 9th or June 12th. Im looking for a programmer who can do this quickly. I am already way behind schedule with this program since the original programmer has decided to be unreachable. Please PM me any questions Thanks in advance Related Projects: This project is the proprietary information of .
Click here to remove this project from OUR database.
|
Operating System: |
Linux |
Database System: |
MySQL |
| <<< back |
|
| Home | Projects archive | RSS | Resources | Links | Contact Us | © 2004-2008 ProjectsList.biz /0.393 |