Business rules for working days in WEBCON BPS

Use universal global business rules in your processes. Using the working days calendar in WEBCON BPS.

Working days calendar

WEBCON BPS allows you to define non-working days in your organization. Thanks to this, we can use standard functions such as performing timeouts only on business days. Another standard feature is displaying on SWE reports, how many business days a given workflow instance is in the current step. You can read about it in the article: Working days calendar in WEBCON BPS.

In this post, I would like to present to you 3 ready-to-use business rules that you can use in all processes! What can you use them for?

Checking if the indicated date is a working day
Calculating how many business days occur between the dates indicated
Calculation of the next (or earlier) business day relative to the indicated date and working days amount

Adding functions on the database

Note: In the example I described, SQL functions are created in the WEBCON BPS content database. This is not recommended by the software developer. Creating custom objects and tampering with the WEBCON BPS database may result in the manufacturer’s warranty loss. I recommend creating these functions on a separate SQL database.

Function 1 – Checking if the day is a working day

The following function checks whether the date indicated is a business day. Returns 1 when the checked date is a working date. Otherwise, it returns 0.

 CREATE FUNCTION [dbo].[Zz_calendar_isworkingday] (@Date DATETIME)
returns INT
AS
  BEGIN
      DECLARE @result INT

      IF EXISTS(SELECT 1
                FROM   calendars
                WHERE  Cast(@Date AS DATE) = cal_workingdate
                       AND cal_isdeleted = 0
                       AND cal_isworkingday = 1)
        SET @result = 1
      ELSE
        SET @result = 0

      RETURN @result
  END

go

Function 2 – Counting working days

The following function counts the working days in the indicated date range. Edge days are also included.

 CREATE FUNCTION [dbo].[Zz_calendar_countworkdays] (@DateStart DATE,
                                                   @DateStop  DATE)
returns INT
AS
  BEGIN
      RETURN
        (SELECT Count(1)
         FROM   calendars
         WHERE  cal_workingdate BETWEEN @DateStart AND @DateStop
                AND cal_isworkingday = 1
                AND cal_isdeleted = 0)
  END

go

Function 3 – Checking the next working day

The following procedure returns the date of the next business day after the specified number of days. The number of days can be positive or negative. If the number is positive, the function returns the next business day. If the number is negative, the function returns the day preceding the day(s) off.




CREATE FUNCTION[dbo].[Zz_calendar_returnworkday] (@Date DATE,
@NumberOfDays                                           INT)
returns DATETIME AS
BEGIN
  DECLARE @result    DATE
  DECLARE @absNumber INT
  IF ( Sign(@NumberOfDays) = 1 )
  SET @result =
  (
           SELECT TOP 1
                    cal_workingdate
           FROM     (
                             SELECT   TOP (@NumberOfDays) cal_workingdate
                             FROM     calendars
                             WHERE    cal_isworkingday = 1
                             AND      cal_isdeleted    = 0
                             AND      cal_workingdate > @date
                             ORDER BY cal_workingdate) AS WorkingDays
           ORDER BY cal_workingdate DESC)
  ELSE
  IF(( Sign(@NumberOfDays) = 0 ))
  SET @result =
  (
           SELECT TOP 1
                    cal_workingdate
           FROM     (
                             SELECT TOP 1
                                      cal_workingdate
                             FROM     calendars
                             WHERE    cal_isworkingday = 1
                             AND      cal_isdeleted    = 0
                             AND      cal_workingdate >= @date
                             ORDER BY cal_workingdate) AS WorkingDays
           ORDER BY cal_workingdate DESC)
  ELSE
  IF(( Sign(@NumberOfDays) = -1 ))
  BEGIN
    SET @absNumber = Abs(@NumberOfDays)
    SET @result =
    (
             SELECT TOP 1
                      cal_workingdate
             FROM     (
                               SELECT   TOP (@absNumber) cal_workingdate
                               FROM     calendars
                               WHERE    cal_isworkingday = 1
                               AND      cal_isdeleted    = 0
                               AND      cal_workingdate < @date
                               ORDER BY cal_workingdate DESC) AS WorkingDays
             ORDER BY cal_workingdate ASC)
  END
  RETURN @result
END
go

Creating global business rules

After creating the above functions, it’s time to create parameterized business rules that will make use of them. Below are presented all of them.

The business rule checking if a day is a business day

The business rule is counting business days

The business rule returns next business day after a given amount of days

Using prepared business rules

Below I show how to configure form fields using my business rules. Of course, this is just an example. You can use these rules anyway you like.

The default value of "Is working day?" form field — The default value of “Is working day?” form field

The default value of "How many working days?" form field — The default value of “How many working days?” form field

The default value of "Next working date (after Start Date)" form field — The default value of “Next working date (after Start Date)” form field

Summary

Thanks to these three business rules, you’ll be able to create more comprehensive business solutions. In addition, once prepared, they can be used in all processes you create and save your time.

If you have any questions, feel free to ask them in the comment section.

Featured image Designed by Ibrandify / Freepik

Business rules for working days in WEBCON BPS

Working days calendar

Adding functions on the database

Function 1 – Checking if the day is a working day

Function 2 – Counting working days

Function 3 – Checking the next working day

Creating global business rules

Using prepared business rules

Summary

1 thought on “Business rules for working days in WEBCON BPS”

Leave a Reply Cancel reply

Working days calendar

Adding functions on the database

Function 1 – Checking if the day is a working day

Function 2 – Counting working days

Function 3 – Checking the next working day

Creating global business rules

Using prepared business rules

Summary

Share this:

1 thought on “Business rules for working days in WEBCON BPS”

Leave a Reply Cancel reply