This project is for a car rental bookings site by travel agencies.
The script will be integrated into an existing page php page. It uses a MySQL website.
Following are the specifications for the script:
The user must be able to input “Date of Rental”, “Time of Rental”, “Date of Return”, “Time of Return”, “Rate Code”, “Car Class”
“Date of Rental”, “Time of Rental”, “Date of Return”, “Time of Return” must be used to calculate the number of days based on a 24 hour period. Anything over the 24 hours will counted as an extra day. That value is then multiplied by the value on the “Rate Code”/“Car Class” row in a MySQL database.
Of course, additional fields like first name, last name, pickup city, dropoff city will be in the same page, but don’t really need to be part of the page.
Process of the booking:
1. User enters the information above.
2. User submits the information
3. Response page will show, “Date of Rental”, “Time of Rental”, “Date of Return”, “Time of Return”, “Rate Code”, “Car Class” and the “Price of the Rental”. Along with the other information on that was entered on the previous web page.
Payment is made after completion.
Clarification calculating the cost of the rental:
The cost of the rental is calclated by looking up the weekly and daily value associated with the chosen car class and rate code. The row on the table contains the columns: rate code, car class, daily rate, weekly rate.
The daily rate applies when there is 1, 2, or 3 days. Weekly rates applies to 4, 5, 6, 7 days.
The maximum number of days per rental is 28 days.
The chart below shows how to calculate the pricing of the rental base on more the a 7 day week.
1 = 1 day
2 = 2 day
3 = 3 day
4 = 1 week
5 = 1 week
6 = 1 week
7 = 1 week
8 = 1 week + 1 day
9 = 1 week + 2 days
10 = 1 week + 3 days
11 = 2 weeks
12 = 2 weeks
13 = 2 weeks
14 = 2 weeks
15 = 2 weeks + 1 day
16 = 2 weeks + 2 days
17 = 2 weeks + 3 days
18 = 3 weeks
19 = 3 weeks
20 = 3 weeks
21 = 3 weeks
22 = 3 weeks + 1 day
23 = 3 weeks + 2 days
24 = 3 weeks + 3 days
25 = 4 weeks
26 = 4 weeks
27 = 4 weeks
28 = 4 weeks
Here is the MYSql Table:
CREATE TABLE `tbl_ratesFL` (
`IDratesFL` tinyint(2) NOT NULL auto_increment,
`cartype` varchar(12) default NULL,
`ONE_D` int(6) default NULL,
`ONE_W` int(6) default NULL,
`TWO_D` int(6) default NULL,
`TWO_W` int(6) default NULL,
`THREE_D` int(6) default NULL,
`THREE_W` int(6) default NULL,
`FOUR_D` int(6) default NULL,
`FOUR_W` int(6) default NULL,
`FIVE_D` int(6) default NULL,
`FIVE_W` int(6) default NULL,
PRIMARY KEY (`IDratesFL`,`IDratesFL`)
) TYPE=MyISAM AUTO_INCREMENT=33 ;
18 freelance font une offre moyenne de $73 pour ce travail
Dear Sirs! Thank you for considering our bid. We've gone through your description and are ready to create the Booking Script you require. Our company has been in the sphere of web development and programming for 10 yea Plus
Dear Sir/ Madam, We have examined your request and would be glad to develop the required script for you. More than 7 years of experience in the field of web technologies and programming help us achieve outstanding Plus
Our bid is for really very high quality work for your Booking Script that will be made to be upgradable in case you need some upgrades in future. We will always be available for upgrades. Our bid includes six week fre Plus
I have been developing sites for a few years now. I believe I can give you the support that you need. I have completed a wide range of sites and systems. A few of them are: [url removed, login to view] [url removed, login to view] www. Plus
Hello Sir, I go through very well your specification that you have been specified over here. We grab your idea and surely give you the script as per your needs. Please open PMB for further discussions and there I can d Plus
I have been working for 5 years on PHP and ASP sites. I offer dependable and fast solutions with complete support. Now I dont promise a cheap solution nor do I promise a fast delivery schedule but i do promise a so Plus