// GraalJS Script (engine type: 2)
//////// START "main()" /////////////////////////////////////////////////////////////////
main();
function main(){
//// == Config Retrieving / 工程コンフィグの参照 ==
const strHolidays = configs.get( "StrConfA1" ); // NotRequired ///////////
if( strHolidays === "" ){
engine.log( " AutomatedTask ConfigWarning:" +
" Config {A1: Holidays} is empty" );
}
let arr2dHolidays = parseTwoColOfCsv( strHolidays );
const strClosedDays = configs.get( "StrConfB1" ); // NotRequired ///////////
if( strClosedDays === "" ){
engine.log( " AutomatedTask ConfigWarning:" +
" Config {B1: Closed DaysOfWeek} is empty" );
}
let arr2dClosedDays = parseTwoColOfCsv( strClosedDays );
const strOpenDespiteWeekends = configs.get( "StrConfB2" ); // NotRequired ///////////
let arrOpenDespiteWeekends = strOpenDespiteWeekends.split("\n");
const strTarget = configs.get( "StrConfC1" ); /// REQUIRED /////////////
if( strTarget === "" ){
throw new Error( "\n AutomatedTask ConfigError:" +
" Config {C1: Date or Datetime} is empty \n" );
}
let dateTarget = parseDateAsMidnight( strTarget ); // the first of the date
engine.log( " AutomatedTask ConfigLog:" +
" DayOfWeek of " + strTarget + " (Sun=0,Mon=1): " + dateTarget.getDay() );
const strPocketOutput = configs.getObject( "SelectConfD1" ); /// REQUIRED ///////////
//// == Data Retrieving / ワークフローデータの参照 ==
// (Nothing. Retrieved via Expression Language in Config Retrieving)
//// == Calculating / 演算 ==
let strOutput = "";
for( let i = 0; i < arr2dHolidays.length; i++ ){
let dateTmp = parseDateAsMidnight( arr2dHolidays[i][0] ); // the first of the date, "00:00"
if( dateTmp.getTime() === dateTarget.getTime() ){
strOutput = arr2dHolidays[i][1];
break;
}
}
if( strOutput !== "" ){
engine.log( " AutomatedTask RuntimeLog:" +
" Holiday" );
}else{
engine.log( " AutomatedTask RuntimeLog:" +
" Not holiday" );
for( let i = 0; i < arr2dClosedDays.length; i++ ){
if( arr2dClosedDays[i][0] === dateTarget.getDay() + "" ){ // Matches Closing Day
engine.log( " AutomatedTask RuntimeLog: " +
arr2dClosedDays[i][1] );
let boolOpen = false;
if( strOpenDespiteWeekends !== "" ){
for( let j = 0; j < arrOpenDespiteWeekends.length; j++ ){
let dateTmp = parseDateAsMidnight( arrOpenDespiteWeekends[j] );
if( dateTmp.getTime() === dateTarget.getTime() ){
boolOpen = true;
break;
}
}
}
if( ! boolOpen ){
strOutput = arr2dClosedDays[i][1];
}else{
engine.log( " AutomatedTask RuntimeLog:" +
" but be Open despite " + arr2dClosedDays[i][1] );
}
break;
}
}
}
//// == Data Updating / ワークフローデータへの代入 ==
engine.setData( strPocketOutput, strOutput );
} //////// END "main()" /////////////////////////////////////////////////////////////////
function parseDateAsMidnight( str ) { // Transform date from String to Date
if( str === "" ){
throw new Error( "\n AutomatedTask ParseDateError:" +
" String is empty \n" );
}
var arrNumParts = str.match( /\d+/g );
if( arrNumParts === null ){
throw new Error( "\n AutomatedTask ParseDateError:" +
" No numeric characters in: " + str + "\n" );
}
if( arrNumParts.length < 3){
throw new Error( "\n AutomatedTask ParseDateError:" +
" 3 Parts of numeric characters are needed in: " + str + "\n" );
}
return new Date( parseInt(arrNumParts[0], 10),
parseInt(arrNumParts[1], 10) - 1,
parseInt(arrNumParts[2], 10) ); // months are 0-based
// Note: new Date("2014-11-10") // Mon Nov 10 2014 09:00:00 GMT+0900 (JST)
// Note: new Date(2014, 10, 10) // Mon Nov 10 2014 00:00:00 GMT+0900 (JST)
}
// Parses CSV string and Creates a 2D array.
function parseTwoColOfCsv( strCsv ){
const arrCsv = strCsv.split("\n");
let arr2d = [];
for( let i = 0; i < arrCsv.length; i++ ){
if( arrCsv[i] === "" ){ continue; } // Skip blank lines
let arrTmp = [];
let arrCells = arrCsv[i].split(",");
for( let j = 0; j < arrCells.length; j++ ){
arrTmp[0] = arrCells[0];
arrTmp[1] = arrCells[1];
// Refer to only the first two columns of CSV.
}
arr2d.push( arrTmp );
}
return arr2d;
}
/*
Notes:
- When the process reaches the automated task, judges whether the date corresponds to a national holiday or a regular closing day.
- `YYYY-MM-DD` (date type format), `YYYY/MM/DD`, etc.
- `YYYY-MM-DD hh:mm` (datetime data format) can also be determined.
- If it corresponds to "A1. Holiday list" of the config value, the name of the holiday is stored.
- You need to list all the holidays of all years.
- It is also possible to add "company-defined holidays" to the holiday list.
- The CSV file in the Cabinet Office "About National Holidays" is useful. (JAPAN)
- https://www8.cao.go.jp/chosei/shukujitsu/gaiyou.html
- https://www8.cao.go.jp/chosei/shukujitsu/syukujitsu.csv
- 2022/1/1,New Year's Day 2022/1/10,Coming-of-Age Day 2022/2/11,National Foundation Day 2022/2/23,Emperor's Birthday
- If the config value "B1. Regular closing days" is applicable, the day name is stored.
- However, if it corresponds to "a day that is not closed specially", an empty string will be stored.
- Set the regular holidays with a number from 0-6. (Sunday-Saturday: 0-6)
- If it falls on a national holiday, it will not be judged whether it is a regular closing day.
- If no reason to close, an empty string is stored.
APPENDIX:
- Refers to only the first two columns of CSV.
- No error will occur even if the memo is written in the third column.
- (1st row, 2nd row, remarks memo)
- No problem if the data is for holidays of about 50 years (about 1000 lines).
- If you set a large number of "A1. Holiday list" that exceeds 10,000 lines, an error may occur.
Notes-ja:
- 案件が自動処理工程に到達した際、日付データが祝祭日や定休日に該当するか、判定できます。
- `YYYY-MM-DD` (日付型データの書式) や `YYYY/MM/DD` など
- `YYYY-MM-DD hh:mm` (日時型データの書式) も判定できます。
- コンフィグ値の「A1.祝祭日リスト」に該当する場合に、祝祭日の名前が格納されます。
- 全ての年の全ての祝祭日をリストアップする必要があります。（実務上必要とされる範囲）
- 祝祭日リストに「会社が定めた休日」を追加することも可能です。
- 内閣府「国民の祝日について」にあるCSVファイルが有用です。
- https://www8.cao.go.jp/chosei/shukujitsu/gaiyou.html
- https://www8.cao.go.jp/chosei/shukujitsu/syukujitsu.csv
- 2022/1/1,元日 2022/1/10,成人の日 2022/2/11,建国記念の日 2022/2/23,天皇誕生日
- コンフィグ値「B1.定休日（休業する曜日）」に該当する場合に、曜日名が格納されます。
- ただし「特別に休業としない日」に該当した場合には、空文字が格納されます。
- 定休曜日は 0-6 の数字で設定します。（Sunday - Saturday : 0 - 6）
- 祝祭日に該当する場合、定休日判定は行われません。
- いずれの休日にも該当しない場合、空文字が格納されます。
APPENDIX-ja:
- CSV設定は、先頭の2列だけが参照されます。
- 3列目にメモが記載されていてもエラーにはなりません
- （1列目,2列目,備考メモ）
- 50年程度の祝祭日データ（1000行程度）であれば問題ありません。
- 1万行を超えるような大量の「A1.祝祭日リスト」を設定するとエラーとなる場合があります。
*/
Pingback: Date, Calc after N Business Days – Questetra Support