fgary6861 wrote:chintaka,
great job on this. one question, how do you know if you have availability to be able to sell the hotel room? Are you checking an availability file or just taking the reservation? what if the client books it and it isnt available?
I am working on a similar application and was curious how you handle this. My application is for a the actual property so I have to know if I can give that room or not.....
fgary6861
Hi,Thanks a lot chintaka ,
For fgary6861,I think you need to add two new colms Datetime (Arrival,Depature) to nop_productvariant table .
Simply,when you add rooms, quntity colum of pv tabale will be number of available rooms.
Now,using the excellent work of chintaka ,we can let sd as Arrival & ed as Depature,
you also need to modify the search sp to include a join for both dates.
I hope this is useful for you.