HotelDruid

Dear Marco,

I hope that you are well. We are testing PHP Residence at the moment.
Please find below some question, related to our work with PHP Residence.

1. I would like to make a discount of 10% of the prices for 7 or more nights stay. Please advise how I can make it. Should I make special tarif, which will be active in case of 7 or more nights stay?
2. I can not open the inventory part of the apartments. Please find below the error that appears:

Inventory of apartment 13G1P.

ERROR in: select * from relinventario where idappartamento = '13G1P'
order by idbeneinventario .
Can you explain what it means?

Thank you in advance.

Kind regards,
Nikola Vasilski

freya wrote: 1. I would like to make a discount of 10% of the prices for 7 or more nights stay. Please advise how I can make it. Should I make special tarif, which will be active in case of 7 or more nights stay?

Hello Nikola, you can add an extra cost and select it to be automatically assigned when a rate is choosen and the reservation has more than 7 days.

freya wrote:2. I can not open the inventory part of the apartments. Please find below the error that appears:

Inventory of apartment 13G1P.

ERROR in: select * from relinventario where idappartamento = '13G1P'
order by idbeneinventario .

Where exactly do you get this error? From the inventory table, the apartments table or other?

Marco

I cannot help you with the 7 day things but I can help you with the problem you have with the inventory:

the inventory table assume all appartement are number (the table structure is made of an int(11)) but in your case (and mine also) this is not true, room are not only number.

the solution can be one of the following:
- use number
- alter table structure

please see the post I made in the bug report for more information