I have a table booking site for restaurants. I need a page that describes the booking situation for the same day years back in time.
(Example. Today March 14th 2008 the restaurant has reservations for 1408 people in the future. Now I want to know how many reservations I had in the future the same day 1 year ago, 2 years ago.)
This can't be calculated on load. So I want one page that is run daily that checks the booking situation the previous day and the years before and diaplsys the results on a new page that looks like this:
Restaurant: x
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 2006? ? ? ? ? ? ? ? ? ? 2007? ? ? ? ? ? ? ? 2008
-----------------------------------------------------
March 12? ? ? ? ? 1212? ? ? ? ? ? ? ? ? 1602? ? ? ? ? ? ? ? ? ? 1900
March 13? ? ? ? ? ? 1185? ? ? ? ? ? ? ? ? 1630? ? ? ? ? ? ? ? ? ? 1925
All reservations are in a table with these columns:
REST (restaurant_id)
AMOUNT? (number of people in the reservation)
DINNER_START? (date and time in unix timestamp format)
STATUS? (if reservation is valid)
REG_DATE? (date mode when reservation was taken)
## Deliverables
I have attached a screen dump of the table structure. You will see that there are other fields in the table, but they are not needed for this project. I have also attached data from the table, so if anyone wants to create the page and test, go ahead.