{"id":140865,"date":"2023-01-11T11:09:01","date_gmt":"2023-01-11T02:09:01","guid":{"rendered":"https:\/\/support.questetra.com\/?p=140865"},"modified":"2023-08-31T17:57:19","modified_gmt":"2023-08-31T08:57:19","slug":"two-dates-calculate-duration-exclude-close-days-202301","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/ja\/addons\/two-dates-calculate-duration-exclude-close-days-202301\/","title":{"rendered":"2\u3064\u306e\u65e5\u4ed8,\u55b6\u696d\u65e5\u6570\u306e\u8a08\u7b97"},"content":{"rendered":"\n

2\u3064\u306e\u65e5\u4ed8,\u55b6\u696d\u65e5\u6570\u306e\u8a08\u7b97<\/strong><\/h4>\n\n\n\n

Two Dates, Calculate Business Days<\/a><\/p>\n\n\n\n

\u65e5\u4ed8A\u304b\u3089\u65e5\u4ed8B\u307e\u3067\u306e\u55b6\u696d\u65e5\u6570\u3092\u7b97\u51fa\u3057\u307e\u3059\u3002\u3042\u3089\u304b\u3058\u3081\u795d\u796d\u65e5\u306e\u8a2d\u5b9a\u304c\u5fc5\u8981\u3067\u3059\u3002\u4f1a\u793e\u30aa\u30ea\u30b8\u30ca\u30eb\u306e\u4f11\u65e5\u3092\u8ffd\u52a0\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\u3002\u4f8b\u3048\u3070\u3001\u5f53\u6708\u306e\u55b6\u696d\uff08\u7a3c\u50cd\uff09\u65e5\u6570\u3092\u4e88\u3081\u7b97\u51fa\u3057\u3001\u4f5c\u696d\u8a08\u753b\u3059\u308b\u3068\u3044\u3063\u305f\u696d\u52d9\u306b\u5229\u7528\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n

\"Auto<\/figure>\n\n\n\n
\n
Configs for this Auto Step<\/summary>
\n
\n
conf_DataIdA<\/dt>
A: \u65e5\u4ed8\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 *<\/span><\/dd>\n
conf_DataIdB<\/dt>
B: \u65e5\u4ed8\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 *<\/span>\/dd>\n
conf_HolidayMasterFileName<\/dt>
C: \u795d\u796d\u65e5\u30de\u30b9\u30bf\u30d5\u30a1\u30a4\u30eb\u540d *<\/span><\/dd>\n
conf_IsShareHolidayMaster<\/dt>
D: \u795d\u796d\u65e5\u30de\u30b9\u30bf\u30d5\u30a1\u30a4\u30eb\u306e\u5171\u6709\u7a2e\u5225\uff08ON:\u5171\u6709\uff09<\/dd>\n
conf_DataIdE<\/dt>
E: \u5b9a\u4f11\u65e5\u3068\u306a\u308b\u66dc\u65e5\u3068\u66dc\u65e5\u8868\u8a18\u3092\u5404\u884c\u306b\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044 (\u4f8b “0,\u65e5\u66dc\u65e5” )#{EL}<\/sup><\/span><\/dd>\n
conf_DataIdF<\/dt>
F: \u7b97\u51fa\u3055\u308c\u305f\u55b6\u696d\u65e5\u65e5\u6570\u304c\u683c\u7d0d\u3055\u308c\u308b\u6570\u5024\u578b\u30c7\u30fc\u30bf\u9805\u76ee\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0) *<\/span><\/dd>\n\n<\/dl>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
\n
Script (click to open)<\/summary>
\n
\nmain();\nfunction main(){\n\/\/\/\/\/\/\/\/ START "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst startDateObj          = configs.getObject("conf_DataIdA");\nconst endDateObj            = configs.getObject("conf_DataIdB");\nconst holidayMasterFileName = configs.get("conf_HolidayMasterFileName");\nconst strIsShare            = configs.get("conf_IsShareHolidayMaster");\nconst closedDaysConfigs     = configs.get("conf_DataIdE");\nconst daysCountObj          = configs.getObject("conf_DataIdF");\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\nconst startDate  = engine.findData( startDateObj );\nlet   endDate    = engine.findData( endDateObj );\nlet   strEndDate = "";\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\nif ( startDate === null){\n  engine.log("Start Date is null. Business Day Count is zero.");\n  engine.setData( daysCountObj , new java.math.BigDecimal( 0 ) );\n  return;\n}\nif ( endDate === null ){\n  engine.log("End Date is null. Force Set Today to End Date.");\n  let now = new Date();\n  endDate = java.sql.Date.valueOf(now.getFullYear() + "-" + (now.getMonth()+1).toString().padStart(2, '0') + "-" + now.getDate().toString().padStart(2, '0'));\n  engine.setData( endDateObj , endDate);\n  now.setDate(now.getDate() + 1 );\n  strEndDate = now.getFullYear() + "-" + (now.getMonth()+1).toString().padStart(2, '0') + "-" + now.getDate().toString().padStart(2, '0');\n}else{\n  strEndDate = toBpmDateStr( endDate.addDays(1) );\n}\nengine.log("strEndDate: " + strEndDate);\n\/\/ Check starDate > endDate\nconst milliSecStartDate = toJsDate( toBpmDateStr( startDate ) ).getTime();\nconst milliSecEndDate = toJsDate( strEndDate ).getTime();  \/\/ include last day\nconst milliSecDuration = milliSecEndDate - milliSecStartDate;\nif ( milliSecStartDate >= milliSecEndDate ){\n  engine.log("Start Date >= End Date. Business Day Count is zero.");\n  engine.setData( daysCountObj , new java.math.BigDecimal( 0 ) );\n  return;\n}\n\nlet excludeCount = 0;\nlet closedDays = new Array();\nif (closedDaysConfigs !== null){\n    closedDays = closedDaysConfigs.split("\\n");\n}\nengine.log("closedDays lenght: " + closedDays.length);\nconst allDurationDaysCount =  milliSecDuration \/1000 \/60 \/60 \/24 ;\nengine.log("All Duration Days: " + allDurationDaysCount);\n\/\/ Chack Master Kind\nlet isShare = true;\nif (strIsShare === "false"){\n  isShare = false;\n}\n\/\/ Holiday Master Check\nconst holidayConfigList = itemDao.findAll( holidayMasterFileName , isShare);\nfor (let i=0; i < holidayConfigList.size(); i++){\n  let config = holidayConfigList.get(i);\n  let dateObjHoriday = toJsDate( config.getValue() );\n  let milliSecHoridayDate = toJsDate( config.getValue() ).getTime();\n  let horidayName = config.getDisplay();\n  if (( milliSecStartDate <= milliSecHoridayDate )&&( milliSecEndDate >= milliSecHoridayDate )){\n    engine.log("Exclude Holiday: " + config.getValue() + " " + horidayName);\n    excludeCount++;\n    \/\/ Avoid Duplication (Holiday and Weekly Closed Day)\n    for (let j=0; j < closedDays.length; j++){\n      let closedDay = closedDays[j].split(",");\n      if (closedDay[0] === (dateObjHoriday.getDay() + "")){\n        engine.log(config.getValue() + " " + horidayName + " " + closedDay[1]);\n        excludeCount--;\n        break;\n      }\n    }\n  }\n}\n\/\/ "Days of Week to be Closed" Check\nfor (let i=0; i < allDurationDaysCount; i++){\n  let dateObjTargetDate =  toJsDate( startDate.addDays(i) + "" );\n  for (let j=0; j < closedDays.length; j++){\n    let closedDay = closedDays[j].split(",");\n    if (closedDay[0] === (dateObjTargetDate.getDay() + "")){\n      engine.log("Exclude Close Days: " + (startDate.addDays(i) + ""));\n      excludeCount++;\n      break;\n    }\n  }\n}\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nengine.log("Exclude Count: " + excludeCount);\nengine.log("Business Days Count: " + (allDurationDaysCount - excludeCount));\nengine.setData( daysCountObj , new java.math.BigDecimal(allDurationDaysCount - excludeCount) );\n} \/\/\/\/\/\/\/\/ END "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\nfunction toJsDate( bpmsDateOrDatetimeStr ){\n\/\/ BPMS Date:     "2020-04-01"  (subtype "Y\/M" "M\/D" "Y", not supported)\n\/\/ BPMS Datetime: "2020-04-01 23:59"\nlet year       = 0;\nlet monthIndex = 0;\nlet day        = 0;\nlet hours      = 0;\nlet minutes    = 0;\n\n\/\/  The ECMA\/JavaScript Date object has a large number of methods.\n\/\/ "Date.parse" is danger (strongly discouraged)\n\/\/ - new Date("2014-11-10") \/\/ Mon Nov 10 2014 09:00:00 GMT+0900 (JST)\n\/\/ - new Date(2014, 10, 10) \/\/ Mon Nov 10 2014 00:00:00 GMT+0900 (JST)\nlet arrDatetime = bpmsDateOrDatetimeStr.split(" ");\nif( arrDatetime.length === 1 ){\n  let arrDateParts = arrDatetime[0].split("-");\n  year       = parseInt(arrDateParts[0], 10);\n  monthIndex = parseInt(arrDateParts[1], 10) - 1;\n  day        = parseInt(arrDateParts[2], 10);\n}\nif( arrDatetime.length === 2 ){\n  let arrDateParts = arrDatetime[0].split("-");\n  let arrTimeParts = arrDatetime[1].split(":");\n  year       = parseInt(arrDateParts[0], 10);\n  monthIndex = parseInt(arrDateParts[1], 10) - 1;\n  day        = parseInt(arrDateParts[2], 10);\n  hours      = parseInt(arrTimeParts[0], 10);\n  minutes    = parseInt(arrTimeParts[1], 10);\n}\nreturn new Date( year, monthIndex, day, hours, minutes );\n}\n\/* toBpmDateStr()\n param : com.questetra.bpms.util.AddableDate\n return: string\n*\/\nfunction toBpmDateStr(q_date){\n    if(q_date !== null){\n        return dateFormatter.format('yyyy-MM-dd', q_date.getFirstTimeInDate());\n    }else{\n        return '';\n    }\n}\n\n<\/code><\/pre><\/div>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
Download<\/span><\/h3>\n\n\n\n