Elxis CMS Forum

Extensions => Components => Topic started by: sanchez on January 23, 2011, 12:33:26

Title: IOS Reservation Problem with double booking
Post by: sanchez on January 23, 2011, 12:33:26
Hallo, i have the follow problem:
I have a small Hotel with 13 Rooms:
8 double rooms,
4 single rooms
1 small apartment.

Ok we have two type of price, normal price and Fairs or expositions prices,
 
8 double rooms:  double room price normal 45€ and Fair price 99€
4 single rooms :  Single room price normal 29€ and fair price 60€
1 small apartment: normal price 35€ and fair price 70€

so ok we dont whant that when people book a room show the price from 45€ to 99€,
so we create for each room type, two diferents rooms, example :

8 double rooms (N) 45€ and 8 double rooms (F) 99€
4 single rooms  (N) 29€ and 4 single rooms (F)  60€
1 small apartment (N) 35€ and 1 apartment (F) 70€

Ok now we have a fair from 15.02 until 20.02.2011, during those days are just the rooms
with the fair prices available, and now my problem i have just 13 rooms, but i allmost get
reservation 30 rooms, example:

8 double rooms (F) 99€ available from 15-20.02.2011 and i get booked 21 rooms
4 single rooms (F)  60€ available from 15-20.02.2011  and i get booked 6 rooms
1 Small apartment (F) 70€ available from 15-20.02.2011 and i get booked 3 apartments

and if i try to book moore rooms from 15-20.02.2011 there are still 13 rooms available  >:(.

SO WHAT CAN I DO TO RESOLVE THIS BIG PROBLEM?

Title: Re: IOS Reservation Problem with double booking
Post by: sanchez on January 24, 2011, 21:30:33
no body can help me  >:(
Title: Re: IOS Reservation Problem with double booking
Post by: datahell on January 24, 2011, 22:34:51
Sancez you have send me 3 emails with this question and I have replied to all of them.
Don't you get my emails? Please check if my emails are marked as spam or use an other email address from an other mail server to contact me.
Title: Re: IOS Reservation Problem with double booking
Post by: e-isodos on January 24, 2011, 22:36:04
Why don't you adjust room availability to 0 to the rooms that are 45€ for the periods you sell them 99€  and the opposite. (15-2 to 20-2)
In that way customers won't see the 45 to 99 euros and you have the rooms that really exist to the hotel

This is possible at IOS RES 3.5 (I am not sure for past versions)
Title: Re: IOS Reservation Problem with double booking
Post by: datahell on January 24, 2011, 22:43:32
This is a smart solution e-isodos ;) although I have n't understood what the "fair prices" are and why the standard seasons pricing system is not enough for this problem.
Title: Re: IOS Reservation Problem with double booking
Post by: sanchez on January 24, 2011, 22:57:40
Fair prices ist (International Exposition Prices) those days are people for all over the wordl , hier in nuremberg we dont have season or not much tourist so we just have two prices type normal and Fair prices :D
Title: Re: IOS Reservation Problem with double booking
Post by: sanchez on January 24, 2011, 23:06:33
Hallo,
How i can change the booking form, we have available just like this

Name
Last name
Adress:  (all my bookings the people just white donw the street, and i not available to sea the city and country where they from)
Email:
Telefon:
Mobil:
Fax:
VAT:

Ok now i will like to change like this:

Title:
Name:
Last Name:
Street:
Zip code and city:
Country:
Email:
Cell Phone number.

Please how i can change that?
Title: Re: IOS Reservation Problem with double booking
Post by: datahell on January 24, 2011, 23:07:35
My recommendation is to follow the standard procedure as shown bellow:

Create the following seasons (dates-price pairs):
from 2011-01-01 to 2011-02-14 price: 45 EUR
from 2011-02-15 to 2011-02-20 price: 99 EUR
from 2011-02-21 to 2011-12-31 price: 45 EUR

The disadvantage for you with the above method is that the customer can also see the standard prices for the non-expo dates but I don't get why this is bad. I really wonder why? It is normal to have different prices for a specific season, all hotels do that.

If this solution is not good for you try the e-isodos solution as he described it above.

For your second question I copy-paste here my email reply ( you got my email, did you read it? )

It needs to modify IOSR component to do that and this is something you
have to do by your self. I can only guide you into this.

As the database has only one field for the address the trick is to join
the street/zip/city/country elements after the submit in order to
compose the final address.

Display in the form these elements: street, city, zip, country.
After the form is submitted join these fields to form the "oaddress"
field that will be stored in the database:

oaddress = {street} + {city}, {zip} , {Country}

example php code:

$oaddress = $_POST['street'].' '.$_POST['city'].', '.$_POST['zip'].',
'.$_POST['country'];

Related IOSR files:
components/com_reservations/fviews/booking.html.php  (around line 460)
components/com_reservations/fcontrollers/booking.controller.php (around
line 553)
Title: Re: IOS Reservation Problem with double booking
Post by: sanchez on January 24, 2011, 23:22:38
How much cost if you do that for me?
Title: Re: IOS Reservation Problem with double booking
Post by: sanchez on January 24, 2011, 23:27:47
but i think it must be a problem with the component. because ist logic, if i have 8 rooms vacan and pleople book 4 rooms , they must be just 4 available and not 8, one room tipy ist one room type.  ???
Title: Re: IOS Reservation Problem with double booking
Post by: e-isodos on January 24, 2011, 23:37:57
The component is Excellent!!

You must thing like a computer and not as a human !!!

8 double rooms (N) 45€ and 8 double rooms (F) 99€  === 16 rooms available
4 single rooms  (N) 29€ and 4 single rooms (F)  60€ ===== 8 rooms available
1 small apartment (N) 35€ and 1 apartment (F) 70€ ==== 2 rooms available
-------------------------------------------------------------------------------------------
                                                      TOTAL                      26 rooms available all year

The component is not in your mind

You should do 2 periods
A period for 15-2 to 20-2

0 double rooms (N) 45€ and 8 double rooms (F) 99€  === 8 rooms available
0 single rooms  (N) 29€ and 4 single rooms (F)  60€ ===== 4 rooms available
0 small apartment (N) 35€ and 1 apartment (F) 70€ ====1 rooms available

B period (all the other year)
8 double rooms (N) 45€ and 0 double rooms (F) 99€  ===  8 rooms available
4 single rooms  (N) 29€ and 0 single rooms (F)  60€ ===== 4 rooms available
1 small apartment (N) 35€ and 0 apartment (F) 70€ ==== 1 rooms available


Title: Re: IOS Reservation Problem with double booking
Post by: sanchez on January 24, 2011, 23:45:01
resolb ;D , it whas main configuration, check available was set to no, now i set to yes and it works, and to split the room its a god soliton   ;D