查询当前审批人，下一步审批人

代码：
Map<String, List<BizProcessStatus>> allPro = WorkflowServiceHelper.getBizProcessStatus(ids);

  for (Map.Entry<String, List<BizProcessStatus>> pro :
           proMap.entrySet()) {
       List<BizProcessStatus> nodeList=pro.getValue();

       for (BizProcessStatus node :
               nodeList) {
           nodeName = node.getCurrentNodeName();
           String auditor = node.getParticipantName();
           if (auditor != null && !"".equals(auditor.trim())) {
               participantName.append(",");
               participantName.append(auditor);
           }
       }
       nodeMap.put(pro.getKey(),nodeName);
        auditorsMap.put(pro.getKey(),participantName.toString().replaceFirst(",",""));
   }

sql:

select a.fbusinesskey,a.FSUSPENSIONSTATE,b.FACTIVITYNAME,d.FPARTICIPANTNAME,a.fprocesstype,c.fcategory,c.fparenttaskid,c.fid  

from t_wf_execution a  

INNER JOIN t_wf_execution_l b on a.fid = b.fid AND b.FLOCALEID = 'zh_CN' 

LEFT JOIN t_wf_task c on a.FPROCINSTID = c.FPROCINSTID 

LEFT JOIN t_wf_task_l d on d.FID = c.FID AND d.FLOCALEID = 'zh_CN' 

where  a.fbusinesskey in (表单id) and a.fisscope='0' and a.fisactive='1' 

集成脚本：

var sql = "SELECT  b.FACTIVITYNAME,d.FPARTICIPANTNAME FROM  t_wf_execution@WFS a  INNER JOIN t_wf_execution_l b on a.fid = b.fid AND b.FLOCALEID = 'zh_CN' LEFT JOIN t_wf_task c on a.FPROCINSTID = c.FPROCINSTID LEFT JOIN t_wf_task_l d on d.FID = c.FID AND d.FLOCALEID = 'zh_CN' WHERE  a.fbusinesskey =? and a.fisscope='0' and a.fisactive='1' ";

var list = query_list($src, sql, [param], [VARCHAR,VARCHAR]);

var name="";

if(list){

  for(var obj:list){

    if(name == ""){

      name += obj.factivityname+"/"+obj.fparticipantname ;

    }else{

      name += ","+ obj.factivityname+"/"+obj.fparticipantname;

    }

  }

}

 return name;