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.
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!