スプレッドシートにフロー毎の未処理件数を表示するポートレットの作成方法

function onInit (spread) {
  // フロー情報追加
  let addFlowInfo = function (childNodes, flowInfoList, innerFlag) {
    // ポートレットの表示対象にするフローグループIDを指定してください。
    const FLOW_GROUP = 'flow-group-a';
    $.map(childNodes, function(value, index) {
      if (value.type === 'flow_group' && value.parentFlowGroupId === FLOW_GROUP) {
        addFlowInfo(value.childNodes, flowInfoList, true);
      } else if (value.type === 'flow' && (value.parentFlowGroupId === FLOW_GROUP || innerFlag)) {
        let flowInfo = value.identify.substring(0, value.identify.indexOf('@'));
        flowInfoList.push({'Flow name' : value.label, 'Count number' : value.mattersCount, ' ' : flowInfo});
      }
    });
  };
  // ボタン追加
  let addButton = function (sheet, length) {
    const BUTTON_POS = 3;
    let dataPos = 4;
    for (let i = 0; i < length; i++) {
      let cellType = new GC.Spread.Sheets.CellTypes.Button();
      cellType.text('Go');
      sheet.setCellType(dataPos++, BUTTON_POS, cellType);
    }
  };

  $('
')
      .appendTo(document.body);

  const token = document.querySelector('meta[http-equiv="X-Intramart-Secure-Token"]').content;
  const baseUrl = jQuery('base').attr('href');
  const activeSheet = spread.getActiveSheet();
  let table  = activeSheet.tables.findByName('FlowTable');
  table.bindingPath('flowInfo');
  let sheetInfo = {};
  let tasks = {};
  let tableColumns = [];
  let datasource = {flowInfo : []};

  // 案件情報の取得
  $.ajax({ type: 'GET',
           // REST APIのURL
           url: baseUrl + 'api/workflow/flow-groups/active-matter-tasks',
           headers: {
             // セキュアトークン
             'X-Intramart-Secure-Token': token
           },
           async: true,
           dataType: 'json',
         }).done(function(response) {
           let data = response.data;
           $.map(data.flowTree, function(value, index) {
             addFlowInfo(value.childNodes, datasource.flowInfo);
           });
           let ds = new GC.Spread.Sheets.Bindings.CellBindingSource(datasource);
           activeSheet.setDataSource(ds);
           addButton(activeSheet, datasource.flowInfo.length);
         }).fail(function(response) {
           // セッションタイムアウトエラー
           if (response.status === 401) {
             imuiShowErrorMessage('Session Time Out');
             return;
           }
           // システムエラー
           imuiShowErrorMessage('System Error');
         });
}
function onSave (spread) {
}
function onImport (spread) {
}
function onExport (spread, context) {
}
function onPrint (spread, context) {
}

function handler(e, info) {
  let flowInfo = info.sheet.getCell(info.row, 3).text();
  // 案件一覧-未処理-画面のパス
  let path = 'im_workflow/matters/status/active-matter-tasks';
  let group, flowId;
  if (flowInfo.indexOf('/') > 0) {
    group = flowInfo.substring(0, flowInfo.indexOf('/'));
    flowId = flowInfo.substring(flowInfo.indexOf('/') + 1);
    path = path + '/group/' + group;
  } else {
    flowId = flowInfo;
  }
  path = path + '/flow/' + flowId;
  $('#wkf-portlet_golist').attr('action', path).submit();
}