Page 1 of 1

Applying date parametres

Posted: Wed Jan 29, 2014 4:15 pm
by Tony123
Hi everybody,

I'm fairly new to Php and am creating a management system for hotel booking. I have various tables which include Profile (Customer details etc), Hotel Bookings & Staff availability.

I'm currently struggling with invoicing; I require the system to differentiate between daily bookings and weekly booking using the 'Start Date' and 'End Date' of the booking so I can assign a price based on the length of the booking.

Eg.

Customer A will be charged 4 x Daily Rate if he books between Monday 1st Jan - Thursday 4th Jan
Customer B will be charged 1 x weekly Rate if he books between Monday 1st Jan and Friday 5th Jan
Customer C will be charged 1 x Weekly and 2 x Daily rates if he books between Monday 1st Jan and Tuesday 9th Jan.


Any ideas on how to tackle this would be appreciated, thanks guys!


Tony

Re: Applying date parametres

Posted: Wed Jan 29, 2014 5:08 pm
by requinix
How do weekends figure in?

Re: Applying date parametres

Posted: Thu Jan 30, 2014 11:31 am
by Tony123
We're just working it for weekdays, so essentially the Hotel is closed on weekends.

I believe a solution presented itself, going to try the dateTime::Diff etc - This should work!

Thanks for response.

Re: Applying date parametres

Posted: Thu Jan 30, 2014 12:26 pm
by requinix
DateTime::diff() is half the story: you need to know what days of the week the start and end dates are too. Because January 31-27 (2014) is 5 weekdays while January 27-23 is only 3 weekdays.