Managing Hours of Operations

[enrique]

What is best practice in regards to hours of operations?

We currently are using statistical days and tables but there is a current limitation we have come across. We can't have spanning days (i.e. Department opens at 6am Monday and closes at 2am Tuesday) since you can't set two different set of hours for the same day of the week in the same stat table. We obviously can have a block in IRD that can have an IF statement but that would mean I would have to give people access to IRD to modify hours of operation and train them and...well lets just say this is a nightmare solution. Are most people just managing hours in a database and doing DB queries?

[cavagnaro]

I use list objects or a Web service

Enviado de meu E6633 usando Tapatalk

[Tambo]

list objects are best for this, or close department for 1 min at 23:59 which isn't great

[Dionysis]

The GAX schedule parameter allows you to set multiple time blocks in one day and provides a very nice interface for business users to set times in, which makes it possible to achieve what you're looking for.

But there are 2 big shortcomings of this method.

1 - Daylight Savings is no longer automatic, unless you can use the web server's local time and not set a specific timezone.
2- The resulting list is difficult to parse in IRD.  So much so that I use a custom web service to do it.  Here's what the list looks like:

[code]
[OPM]
Hours = OPM_Hours

[OPM_Hours]
pattern1 = W//3/00:00-24:00
pattern2 = W//5/00:30-24:00
pattern3 = W//4/00:00-24:00
pattern4 = W//6/00:00-24:00
pattern5 = W/+10:00/2/04:30-07:00,09:00-10:30,11:30-12:30,13:00-18:30,21:00-24:00
[/code]

The format is:
<Type of Entry>/<Time zone offset>/<Day>/<time ranges>

Type of Entry = Day of week (above) or Date
Time zone offset = Number of hours different to GMT or blank to use server time.  eg. -5
Day = Numbered day of week (1 = Monday, 2 = Tuesday etc), or DD/MM/YYYY
Time ranges = Comma separated list of time ranges in HH:MM format.

[terry]

Basically in caser of statdays using you can set different sets of hours (assuming relatively up to date URS)
Possible options:
  - set business day end time before business day start time.
    Start time = 8 PM and end time = 4 AM means from 8 PM to the end of day and also from start of day to 4 AM

  - use intervals instead of (in addition to start and end time). Like set start and end time both to 12 AM (basically to disable them using of start and end day at all).
    Define interval length (say 60 min) - as result entire day logically is cut into 24 of 60 minutes intervals (counted from 1 to 24).
    Add into stat day those intervals (only counter matter) that you need - adding intervals with number 1,2,3,4,5,6,  13,14,15,  21,22,23,24 will result
    function return true from 12 AM to 6 AM, from 12 PM to 3 PM and from 8 PM to midnight.

   

[cavagnaro]

[quote author=Tambo link=topic=9841.msg44644#msg44644 date=1473925627]
list objects are best for this, or close department for 1 min at 23:59 which isn't great
[/quote]
When you put 23:59 it goes until 23:59:59.999999 actually

[Tambo]

every day is a school day