Applying date parametres
Posted: Wed Jan 29, 2014 4:15 pm
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
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