{"id":140651,"date":"2022-12-29T17:08:56","date_gmt":"2022-12-29T08:08:56","guid":{"rendered":"https:\/\/support.questetra.com\/?p=140651"},"modified":"2022-12-29T17:08:58","modified_gmt":"2022-12-29T08:08:58","slug":"two-datetimes-calculate-duration-2022","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/ja\/addons\/two-datetimes-calculate-duration-2022\/","title":{"rendered":"2\u3064\u306e\u65e5\u6642, \u7d4c\u904e\u6642\u9593\u306e\u8a08\u7b97"},"content":{"rendered":"\n

2\u3064\u306e\u65e5\u6642, \u7d4c\u904e\u6642\u9593\u306e\u8a08\u7b97<\/strong><\/h4>\n\n\n\n

Two Datetimes, Calculate Duration<\/a><\/p>\n\n\n\n

\u65e5\u6642A\u304b\u3089\u65e5\u6642B\u307e\u3067\u306e\u7d4c\u904e\u6642\u9593\u3092\u7b97\u51fa\u3057\u307e\u3059\u3002\u7d4c\u904e\u65e5\u6570\uff08\u4f8b “1.38\u65e5”\uff09\u3001\u7d4c\u904e\u6642\u9593\u6570\uff08\u4f8b “33.33\u6642\u9593”\uff09\u3001\u7d4c\u904e\u5206\u6570\uff08\u4f8b “2000.00\u5206”\uff09\u3001\u7d4c\u904e\u6642\u9593\uff08\u4f8b “33:20″\uff09\u306e\u3044\u305a\u308c\u304b\u3001\u3082\u3057\u304f\u306f\u8907\u6570\u3092\u51fa\u529b\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002B\u304cA\u3088\u308a\u3082\u904e\u53bb\u6642\u523b\u306e\u5834\u5408\u306f\u30de\u30a4\u30ca\u30b9\u7b26\u53f7\u304c\u4ed8\u4e0e\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n

\"Auto<\/figure>\n\n\n\n
\n
Configs for this Auto Step<\/summary>
\n
\n
StrConfA<\/dt>
A: \u65e5\u6642\uff08\u4f8b “2022-12-31 00:00″\uff09\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044 *<\/span>#{EL}<\/sup><\/span><\/dd>\n
StrConfB<\/dt>
B: \u65e5\u6642\uff08\u4f8b “2023-01-01 09:20″\uff09\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044 *<\/span>#{EL}<\/sup><\/span><\/dd>\n
SelectConfC<\/dt>
C: \u7d4c\u904e\u65e5\u6570\uff08Days\uff09\u304c\u683c\u7d0d\u3055\u308c\u308b\u6570\u5024\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0)<\/dd>\n
SelectConfD<\/dt>
D: \u7d4c\u904e\u6642\u9593\u6570\uff08Hours\uff09\u304c\u683c\u7d0d\u3055\u308c\u308b\u6570\u5024\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0)<\/dd>\n
SelectConfE<\/dt>
E: \u7d4c\u904e\u5206\u6570\uff08Minutes\uff09\u304c\u683c\u7d0d\u3055\u308c\u308b\u6570\u5024\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0)<\/dd>\n
SelectConfF<\/dt>
F: \u7d4c\u904e\u6642\u9593\u6587\u5b57\u5217\uff08h:mm\uff09\u304c\u683c\u7d0d\u3055\u308c\u308b\u6587\u5b57\u5217\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0)<\/dd>\n\n<\/dl>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
\n
Script (click to open)<\/summary>
\n
\/\/ GraalJS Script (engine type: 2)\n\n\/\/\/\/\/\/\/\/ START "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\nmain();\nfunction main(){\n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\n\nconst strTimeA          = configs.get      ( "StrConfA" );     \/\/\/ REQUIRED\n  if( strTimeA        === "" ){\n    throw new Error( "\\n AutomatedTask ConfigError:" +\n                     " Config {A: String} is empty \\n" );\n  }\nconst strTimeB          = configs.get      ( "StrConfB" );     \/\/\/ REQUIRED\n  if( strTimeB        === "" ){\n    throw new Error( "\\n AutomatedTask ConfigError:" +\n                     " Config {B: String} is empty \\n" );\n  }\nconst numPocketDays     = configs.getObject( "SelectConfC" );  \/\/ NotRequired\nconst numPocketHours    = configs.getObject( "SelectConfD" );  \/\/ NotRequired\nconst numPocketMinutes  = configs.getObject( "SelectConfE" );  \/\/ NotRequired\nconst strPocketTime     = configs.getObject( "SelectConfF" );  \/\/ NotRequired\n\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\n\/\/ (Nothing. Retrieved via Expression Language in Config Retrieving)\n\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\nconst dateTimeA       = parseAsLocalDate ( strTimeA );\nconst dateTimeB       = parseAsLocalDate ( strTimeB );\nconst numMsecA        = dateTimeA.getTime();\nconst numMsecB        = dateTimeB.getTime();\nconst numMsecDuration = numMsecB - numMsecA;\n\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nif( numPocketDays !== null ){\n  engine.setData ( numPocketDays,\n    new java.math.BigDecimal( numMsecDuration \/1000 \/60 \/60 \/24 )\n  );\n}\nif( numPocketHours !== null ){\n  engine.setData ( numPocketHours,\n    new java.math.BigDecimal( numMsecDuration \/1000 \/60 \/60 )\n  );\n}\nif( numPocketMinutes !== null ){\n  engine.setData ( numPocketMinutes,\n    new java.math.BigDecimal( numMsecDuration \/1000 \/60 )\n  );\n}\nif( strPocketTime !== null ){\n  let numPositiveIntM = Math.floor ( Math.abs ( ( numMsecDuration \/1000 \/60 ) ) );\n  \/\/  eg, 2000.00m -> 2000m,  -7.38m -> 7,  -67.38m -> 67\n  let numH = Math.floor ( numPositiveIntM \/60 );\n  let numM = numPositiveIntM %60;\n  if ( numMsecDuration < 0 ){\n    engine.setData ( strPocketTime, '-' + numH + ":" + ( '0' + numM ).slice( -2 ) );\n  }else{\n    engine.setData ( strPocketTime,       numH + ":" + ( '0' + numM ).slice( -2 ) );\n  }\n}\n\n\n} \/\/\/\/\/\/\/\/ END "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\nfunction parseAsLocalDate ( str ){ \/\/ strDateOrDatetime\n  \/\/\n  \/\/ Searches a Date-or-Datetime String for YYYY, MM, DD, hh:mm in that order and\n  \/\/  returns JavaScript `Date` object.\n  \/\/ Any format is forcibly recognized as LOCAL DATETIME. -- UNIQUE --\n  \/\/ Supports "ISO 8601 format", "BPMS date format", "BPMS datetime format", etc,,,\n  \/\/\n  \/\/ String "2022-12-31 23:59"          (Questetra BPMS datetime format)\n  \/\/ \u21d2 Date 2022-12-31T23:59:00+XX:00\n  \/\/ String "2022-12-31 23:59:59"       (SQL Time format)\n  \/\/ \u21d2 Date 2022-12-31T23:59:00+XX:00\n  \/\/ String "2022-12-31T23:59:59.999Z"  (ISO 8601 format)\n  \/\/ \u21d2 Date 2022-12-31T23:59:00+XX:00   \/\/ UNIQUE: Timezone not evaluated\n  \/\/ String "2022-12-31"                (Questetra BPMS date format) \n  \/\/ \u21d2 Date 2022-12-31T00:00:00+XX:00   \/\/ UNIQUE: not UTC\n  \/\/ String "2022\/12\/31"                (Windows date-ja format)\n  \/\/ \u21d2 Date 2022-12-31T00:00:00+XX:00   \/\/ UNIQUE: not UTC\n  \/\/ String "2022\u5e7412\u670831\u65e5"            (\u65e5\u672c\u8a9e\/Japanese)\n  \/\/ \u21d2 Date 2022-12-31T00:00:00+XX:00\n  \/\/\n  \/\/ String "20221231"\n  \/\/ \u21d2 Date 2022-12-31T00:00:00+XX:00   \/\/ UNIQUE: not UTC\n  \/\/ String "20221231T235959Z"          (ISO 8601 format)\n  \/\/ \u21d2 Date 2022-12-31T23:59:00+XX:00   \/\/ UNIQUE: Timezone not evaluated\n  \/\/ String "20221231T2359"\n  \/\/ \u21d2 Date 2022-12-31T23:59:00+XX:00\n\n  if( str === "" ){\n    throw new Error( "\\n AutomatedTask ParseDateError:" +\n                     " String is empty \\n" );\n  }\n  const arrNumParts = str.match( \/\\d+\/g );\n  if( arrNumParts === null ){\n    throw new Error( "\\n AutomatedTask ParseDateError:" +\n                     " No numeric characters in: " + str + "\\n" );\n  }\n\n  \/\/\/ function default\n  let numYear    = 0; \/\/ limit in QBPMS: 1900 to 2100 (asof 2022-12)\n  let indexMonth = 0;\n  let numDay     = 0;\n  let numHours   = 0;\n  let numMinutes = 0;\n\n  \/\/\/ case: startsWith YYYYMMDD\n  if( arrNumParts[0].length === 8 ){\n    numYear      = parseInt( arrNumParts[0].slice( 0, 4 ), 10 );\n    indexMonth   = parseInt( arrNumParts[0].slice( 4, 6 ), 10 ) - 1;\n    numDay       = parseInt( arrNumParts[0].slice( 6, 8 ), 10 );\n    if( arrNumParts.length > 1 ){ \/\/ "20221231T2359"\n      numHours   = parseInt( arrNumParts[1].slice( 0, 2 ), 10 );\n      numMinutes = parseInt( arrNumParts[1].slice( 2, 4 ), 10 );\n    }\n\n  \/\/\/ case: not startsWith YYYYMMDD, like "2022-12-31 23:59"\n  }else{\n    if( arrNumParts.length < 3){\n      throw new Error( "\\n AutomatedTask ParseDateError:" +\n                       " 3 Parts of numeric characters are needed in: " + str + "\\n" );\n    }\n    numYear      = parseInt( arrNumParts[0], 10 );\n    indexMonth   = parseInt( arrNumParts[1], 10 ) - 1;\n    numDay       = parseInt( arrNumParts[2], 10 );\n    if( arrNumParts.length > 4){\n      numHours   = parseInt( arrNumParts[3], 10 );\n      numMinutes = parseInt( arrNumParts[4], 10 );\n    }\n  }\n\n  \/\/\/ return JavaScript `Date` object\n  return new Date( numYear, indexMonth, numDay, numHours, numMinutes );\n}\n\n\n\n\/*\nNotes:\n- When the process reaches the automated step, the "Two Datetimes" will be automatically evaluated.\n    - If "A: Process start time" and "B:`#{#now}`", the elapsed time to this step will be calculated.\n- This automatic process evaluates both "2022-12-31" and "2022-12-31 00:00" as local time.\n    - On JST platform (+9), both are interpreted as "2022-12-30T15:00:00Z" (2022-12-31T00:00:00+09:00).\n    - Even if in ISO 8601 format with time zone, it is still evaluated as local time.\n    - https:\/\/support.questetra.com\/addons\/converter-date-or-datetime-string-to-workflow-datetime-2022\/\n- Datetime-A or Datetime-B can be set in various formats.\n    - Fixed config\n        - `2022-12-31 00:00`.\n        - `2022-12-31 00:00`\n        - `2022-12-31` (= `2022-12-31 00:00`)\n        - `2022-12-31` (= `2022-12-31 00:00`)\n    - Dynamic config (Referring to process data)\n        - `#{#q_TimeOfBirth}`\n            - (Fixed time)\n        - `#{#q_LastDayOfFiscalYear} 18:00`\n            - (DATE data + Fixed time)\n        - `#{#q_BirthDay}`\n            - (If only DATE is set, assumed to be 00:00.)\n        - `#{#q_OrderReceivedTime.addMonths(1).getLastTimeInMonth().getFirstTimeInDate().addHours(7)}`\n            - 7:00 AM of the last day of the month following the "Order Received Time".\n        - `#{processInstanceStartDatetime}` (process start time)\n        - `#{#now}` (token arrival time)\n    - R2272: Output of Strings via EL syntax https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024292872-R2272\n        - R2271: Output of Date and Datetime Data via EL syntax https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024292672-R2271\n\nNotes (ja):\n- \u6848\u4ef6\uff08\u30c8\u30fc\u30af\u30f3\uff09\u304c\u3053\u306e\u81ea\u52d5\u5de5\u7a0b\u306b\u5230\u9054\u3057\u305f\u969b\u3001\u300c2\u3064\u306e\u6642\u523b\u300d\u304c\u8a55\u4fa1\u3055\u308c\u307e\u3059\u3002\n    - \u305f\u3068\u3048\u3070\u300cA:\u30d7\u30ed\u30bb\u30b9\u958b\u59cb\u65e5\u6642\u300d\u300cB:`#{#now}`\u300d\u3068\u30bb\u30c3\u30c8\u3059\u308c\u3070\u3001\u81ea\u52d5\u5de5\u7a0b\u307e\u3067\u306e\u6240\u7528\u6642\u9593\u304c\u7b97\u51fa\u3055\u308c\u307e\u3059\u3002\n- \u3053\u306e\u81ea\u52d5\u5de5\u7a0b\u3067\u306f "2022-12-31" \u3082 "2022-12-31 00:00" \u3082\u30ed\u30fc\u30ab\u30eb\u30bf\u30a4\u30e0\u3068\u3057\u3066\u8a55\u4fa1\u3057\u307e\u3059\u3002UNIQUE\n    - JST\u57fa\u76e4(+9)\u306e\u5834\u5408\u3001\u3069\u3061\u3089\u3082 "2022-12-30T15:00:00Z" (2022-12-31T00:00:00+09:00) \u3068\u89e3\u91c8\u3055\u308c\u307e\u3059\u3002\n    - \u4eee\u306b\u30bf\u30a4\u30e0\u30be\u30fc\u30f3\u304c\u8a18\u8f09\u3055\u308c\u305f ISO 8601 \u5f62\u5f0f\u3067\u3042\u3063\u3066\u3082\u3001\u30ed\u30fc\u30ab\u30eb\u30bf\u30a4\u30e0\u3068\u3057\u3066\u8a55\u4fa1\u3055\u308c\u307e\u3059\u3002\n    - https:\/\/support.questetra.com\/ja\/addons\/converter-date-or-datetime-string-to-workflow-datetime-2022\/\n- \u69d8\u3005\u306a\u66f8\u5f0f\u3067\u300c\u65e5\u6642A\u30fb\u65e5\u6642B\u300d\u3092\u30bb\u30c3\u30c8\u3067\u304d\u307e\u3059\u3002\n    - \u56fa\u5b9a\u7684\u306a\u8a2d\u5b9a\n        - `2022-12-31 00:00`\n        - `2022\/12\/31 00:00`\n        - `2022-12-31` (= `2022-12-31 00:00`)\n        - `2022\u5e7412\u670831\u65e5` (= `2022-12-31 00:00`)\n        - `20221231 235959` (= `2022-12-31 23:59`)\n    - \u52d5\u7684\u306a\u8a2d\u5b9a\uff08\u30d7\u30ed\u30bb\u30b9\u30c7\u30fc\u30bf\u7b49\u3092\u53c2\u7167\u3059\u308b\u8a2d\u5b9a\uff09\n        - `#{#q_TimeOfBirth}`\n            - (Fixed time)\n        - `#{#q_LastDayOfFiscalYear} 18:00`\n            - (DATE data + Fixed time)\n        - `#{#q_BirthDay}`\n            - (If only DATE is set, assumed to be 00:00.)\n        - `#{#q_OrderReceivedTime.addMonths(1).getLastTimeInMonth().getFirstTimeInDate().addHours(7)}`\n            - DATETIME "\u53d7\u6ce8\u6642\u523b" \u306e\u7fcc\u6708\u306e\u672b\u65e5\u306e\u671d7\u6642\n        - `#{processInstanceStartDatetime}` (\u30d7\u30ed\u30bb\u30b9\u958b\u59cb\u65e5\u6642)\n        - `#{#now}` (\u30c8\u30fc\u30af\u30f3\u304c\u3053\u306e\u81ea\u52d5\u5de5\u7a0b\u306b\u5230\u9054\u3057\u305f\u6642\u523b)\n    - R2272: EL\u5f0f\u306b\u3088\u308b\u6587\u5b57\u5217\u3068\u3057\u3066\u306e\u51fa\u529b\uff08\u30c7\u30fc\u30bf\u8a2d\u5b9a\u5f0f\uff09 https:\/\/questetra.zendesk.com\/hc\/ja\/articles\/360024292872-R2272\n        - \u2514 R2271: EL\u5f0f\u306b\u3088\u308b\u65e5\u4ed8\u65e5\u6642\u3068\u3057\u3066\u306e\u51fa\u529b\uff08\u30c7\u30fc\u30bf\u8a2d\u5b9a\u5f0f\uff09 https:\/\/questetra.zendesk.com\/hc\/ja\/articles\/360024292672-R2271\n*\/\n\n<\/code><\/pre><\/div>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
Download<\/span><\/h3>\n\n\n\n