Seasonal Pricing for a Hotel Room
Posted
by
Laykes
on Stack Overflow
See other posts from Stack Overflow
or by Laykes
Published on 2011-01-18T00:38:40Z
Indexed on
2011/01/18
0:53 UTC
Read the original article
Hit count: 150
I am trying to manage seasonal prices for hotel rooms.
The only way that I can think of doing it would be to use:
| DayDate |EndDate | A | B
-----------------------------------------------
| 2010/07/1 |2010/07/2 | 200 | 40
| 2010/07/3 |2010/07/4 | 150 | 40
| 2010/07/5 |2010/07/5 | 150 | 50
| 2010/07/6 |2010/07/7 | 200 | 50
| 2010/07/8 |2010/07/9 | 100 | 60
etc.. (table taken from another question).
The problem is: I don't want my seasons to be year specific. Seasons for rooms shouldn't change year on year. I don't want my users to have to enter the seasonal information several times.
I am also going to have thousands of rooms, so I don't know a way to make this easily manageable.
I'm using mysql and php.
© Stack Overflow or respective owner