JHotelReservation Forum - Room prices in other currency

Hi,

This component was made with room prices in $, what if the hotel is from country like Indonesia (which is where I came from) that needs the room prices in 7 digits

The component doesn't seems to accept 1.000.000 (rupiah currency equal to 90$) :(

Is it ok if I just change the structure of the room price table from decimal(7,2) to decimal(9,2) ??

What other tables should I change that are affected by this changes?

Hi Erwin, 

Please send us you Joomla login via the contact form and we'll take care of it. As of our next release we'll adopt bigger decimal values. 

Hi Mike,

I have the website installed in my hosting currently. But it should be installed in my client's hosting. So I will be happy if you would kindly tell me what tables to change. For the mean time I will give the Joomla login for the pre-production(not live yet) website.

Thank you

Hi Erwin, 

You have to change the decimals from (7,2) to (9,2) in the following tables:

hotelreservation_rooms_rates

hotelreservation_rooms_rate_prices

hotelreservation_offers_rate_prices

hotelreservation_offers_rooms_price

hotelreservation_offers_rates

hotelreservation_hotels

We tried to modify them on your website but we couldn't access the database. Let us know if there's anything else. 

Hi Mike,

I have changed the table structures according to your suggestion. It all seemed ok until I received the reservation email which showed the wrong price for the reservation. (Eg. the reservation price was 1million but the price inside the email was 999.999,99 a sign of decimal limitation)

It seemed there are other tables associated with the reservation process that causes emails to have the wrong prices. Can we somehow fix this ? Are there any other tables that I need to change?

Erwin, 

I forgot about the confirmation tables, sorry. The best thing would be to search through all the hotel tables and change the decimal size.