本帖最后由 wade 于 2018-7-17 15:22 编辑
你看看我的思路:我的思路就是"申请人"提交表单到"部门审批",在"部门审批"这个节点这里我没有用getWebUser().getName(),所以系部门签字这里是空的,当我从"系部门审批"提交到"教务处督导员"我就获取上一节点审批人(系部门审批)的姓名并且赋值到系部门签字这里,那段sql查询可以获取上一节点的流程处理人。
(function() {
var curDoc = getCurrentDocument();
var domainid = getDomainid();
var curDocName = curDoc.getItemValueAsString("系部负责人签字");
if (curDocName != null && curDocName != "") {
return curDocName;
}else {
var statelabel = getStateLabel();
if (statelabel == "教务处督导员") {
var nodeName="部门审批"; //流程节点名称
var sql="select id,actorid as item_actorid,name as item_name,'" + domainid + "' as domainid from T_ACTORHIS r where NODEHIS_ID in (select ID from t_relationhis where docid='"+curDoc.getId()+"' and startnodename='"+nodeName+"') ORDER BY r.PROCESSTIME DESC LIMIT 1";
println("sql----"+sql);
var datas = queryBySQL(sql);
for (var it = datas.iterator(); it.hasNext();) {
var d = it.next();
var userid = d.getItemValueAsString("actorid");
var userVO = getUserById(userid);
curDocName=userVO.getName();
}
}
}
return curDocName;
})() |