php - Computing number of days which fall between predefined date ranges -

-

this complex situation ain. have booking system rooms booked.

the thing rates rooms aren't stored single value period based. room can have 1 daily rate between september december , adifferent rate march august, while have base rate other wise.

the rates table this:

roomid | rate | period_start | period_end

lets suppose rate room between 1st march 31st march 20 dollars/day , rate same room 15th april 30th may 30 dollars, aside rate flat rate of 15 dollars/day.

if room booked 1 client between 15th march 10th may, total cost be:

15th march - 31st march charged @ 20 dollars/day = 16x20 1st april - 14th april charged @ 15 dollars/day = 14x15 15th april - 10th may charged @ 30 dollars/day = 25x30

now how can compute value in code, need compute thenumber of days based upon rate periods if any, else use base rate them. complex thats how is. i'm using php mysql

this possible solution algorithm:

  1. find rate periods have non-empty intersection booking period
  2. for each rate period found in (1), compute number of days in intersection booking period, , multiply period's rate
  3. the remaining number of days (i.e. length of booking period in days less sum of days found in (2) base rate days

re (1), in order find rate periods intersect booking period, note 2 intervals (a,b) , (c,d) have empty intersection iff d < or c > b, can negate condition. should like:

select * rates     not (booking_end < period_start or                booking_start > period_end)

re (2), need find number of days between max(booking_start, period_start) , min(booking_end, period_end), inclusive. sure there utilities deal dates, in worst case can loop through it.

sorry, not sql/php wizard write actual code... :)


Comments

Post a Comment

Popular posts from this blog

Javascript line number mapping -

-
magically formatted comments change reported line number of javascript errors in browsers; this: //@line n "f" n line number , f file name. unfortunately, //@line appears ungoogleable. know there documentation on feature, , browsers support it? (i found references here , here .) from can find available in mozilla based browsers. it using js_setoptions command can turn these options on or off depending on values passed. https://developer.mozilla.org/en/js_setoptions
Read more

c# - Is it possible to remove an existing registration from Autofac container builder? -

-
something along lines: builder.registertype<mytype>().as<itype>(); builder.registertype<mytype2>().as<itype>(); builder.deregistertype<mytype>().as<itype>() var container = builder.build(); var types = container.resolve<ienumerable<itype>>(); assert.istrue(types.count == 1); assert.istrue(types[0].gettype == typeof(mytype2)); scenario: go through bunch of assemblies , go register types want make sure have 1 implementation of given type. need before create container. track on own nice if autofac me bit. this cannot done directly using containerbuilder , unless start on new one. mind you, having first built container should able construct new container filtering away unwanted types , reusing registrations first container. this: ... var container = builder.build(); builder = new containerbuilder(); var components = container.componentregistry.registrations .where(cr => cr.activator.limittype != typ...
Read more

php - Mysql PK and FK char(36) vs int(10) -

-
i have read mysql can handle indexes , searches better if tables keys integers rather char(36) uuid's. is worth converting int(10)? note: use 1 server , have have plans use multiple databases concurrently therefore removing 1 of big reasons using uuid. our tables innodb if makes difference. thanks in advance. usually rdbms can handle integer keys pk more efficient, other datatypes. reason how build index column, yes: long dont require string (or other typed) keys, should use integers. however: char(36) , int(10) far away being equal, because int(10) much smaller, char(36). dont know, if require many different keys, should keep in mind. update, complete last paragraph: int(10) 32-bit, char(36) 36 - ^byte^ (= 288-bit). not mean, int consumes less space, means, char(36) has 4 times more different keys.
Read more