Applying date parametres

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
Tony123
Forum Newbie
Posts: 2
Joined: Wed Jan 29, 2014 4:14 pm

Applying date parametres

Post 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
User avatar
requinix
Spammer :|
Posts: 6617
Joined: Wed Oct 15, 2008 2:35 am
Location: WA, USA

Re: Applying date parametres

Post by requinix »

How do weekends figure in?
Tony123
Forum Newbie
Posts: 2
Joined: Wed Jan 29, 2014 4:14 pm

Re: Applying date parametres

Post 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.
User avatar
requinix
Spammer :|
Posts: 6617
Joined: Wed Oct 15, 2008 2:35 am
Location: WA, USA

Re: Applying date parametres

Post 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.
Post Reply