Select values between 2 seasons

fabianvargas

Hi:
I'm new in the Forum, but I need your urgent help.
I'm creating a booking system, but my php skills are not so good... so I need all the help that I can find.
This is my situation: I have two tables
dmc_rates
this table have the rates for the hotels (and the rooms caractheristics...)
dmc_temporadas
in this I have the different season for each hotel

The user choose 2 days (example: 2006-07-20 as check in an 2006-07-25 as check out. The system have to calculate the SUM of the prices of the days... total: 6 days..
When the user select the values in the same season is very easy, but when the user select values from 2 different seasons is very hard for me)
Some one can help to create something that works for this situation?

I think that I have to create an array with the list of days and search the price for each day and the SUM the values...
But I don't know how to start?
Thanks in advance

Fabián

bpat1434

Here's my input....

1.) You need to specify when the seasons begin. And since they shouldn't overlap, and there shouldn't be any "non-season" time, the beginning of one will also mark the end of the previous. Something like:

Summer: May 5
Fall: September 20
Winter: November 30
Spring: March 1

2.) You need a way to know when the days fall in two different seasons, and how many days per season there are. This is just a matter of comparing time-stamps and precise calculation. You'd need to take the first date, and the date of the new season, subtract them, then mathematically solve for the number of days that is. THen you take that new season date, and subtract it from the end date, and solve for days. Now you have two lengths for each seasonal stay.

3.) You need to specify what price for what season, and even what price per destination per season. I'm sure you've got this done already 🙂

Hope that helps.....

fabianvargas

Thanks for your fast answer.
I'll try to explain what I have with more especific examples

The problem is this... Are many different hotels so, my rates table is this
id_rate (the autonumerical ID)
id_proveedores (The id of each client)
id_tipo (the id of the room)
id_ocup (the id of the occupation... single, double, triple)
rate (the rate)
id_temporada (the season for this rate)

My season table is this
id_temporada (the season id)
id_proveedores (the client ID)
inicio (season start date)
end (season end date)

I have the season starting and ending dates.

I was thinking is exist the way to first extrat the list of all day between the 2 selected days bay the user, and then extract from the database the value of each particular day, and finally make the SUM

I'm waiting for any help...
Thanks in advance

Fabián

bpat1434

Store the start and end dates as unix-timestamps (seconds) and then when the user selects a start and end date, you can get both the seasons needed:

WHERE inicio <= $startdate
OR end >= $enddate