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
Applying date parametres
Moderator: General Moderators
Re: Applying date parametres
How do weekends figure in?
Re: Applying date parametres
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.
I believe a solution presented itself, going to try the dateTime::Diff etc - This should work!
Thanks for response.
Re: Applying date parametres
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.