根据客户需求,用户要的是后台历史节点信息。如下模板
//审批意见
function testhis() {
var curDoc = getCurrentDocument();
var message = "";
var txtNo = curDoc.getId();
var webUser = getWebUser();
var docNamestr = curDoc.getFormname();
if(docNamestr!=null){
var docName = docNamestr.substring(docNamestr.lastIndexOf("/") + 1,
docNamestr.trim().length());
var sql = "select nodehis_id,name,attitude,processtime from t_actorhis where flowstatert_id in (select state from tlk_"
+ docName + " where id ='" + txtNo + "') order by processtime";
var datas = queryByDSName("tbpmDataSource", sql);
var count = 0;
if (datas != null && datas.size() > 0) {
message += "<br/><table class='history_table' cellSpacing='0' cellPadding='1' align='center'>"
+ "<tbody><tr><td colspan='4' class='td_title'>审批历史</td></tr>"
+ "<tr class='thead'>"
+ "<td>办理人</td>"
+ "<td>操作</td>"
+ "<td>办理意见</td>"
// + "<td>备注信息</td>"
+ "<td>办理时间</td>"
+ "</tr>";
for ( var iter = datas.iterator(); iter.hasNext();) {
count = count + 1;
var doc = iter.next();
var name = doc.get("NAME");
var namebak = name;
if (name.equals("system")) {
name = "自动审批";
}
var attitude = "";
var att = doc.get("ATTITUDE");
if (att != null && att.trim().length() > 0) {
attitude = att;
}
var time1 = doc.get("PROCESSTIME");
var time = format(time1, "yyyy-MM-dd");
// var time= parseDate(time2,"yyyy-MM-dd HH:mm:ss");
var id = doc.get("NODEHIS_ID");
var nodeName = "";
var status = "";
var sql1 = "select startNodename,flowoperation from t_relationhis where id = '"
+ id + "' order by actiontime";
var datas1 = queryByDSName("tbpmDataSource", sql1);
if (datas1 != null && datas1.size() > 0) {
var hisdate = datas1.iterator().next();
nodeName = hisdate.get("STARTNODENAME");
var statusNum = hisdate.get("FLOWOPERATION") - 0;
if (statusNum == 80) {
if (name.indexOf("[") >= 0 || name.indexOf("]") >= 0) {
status = "代理审批";
} else {
status = "同意";
}
} else if (statusNum == 81) {
status = "不同意";
} else if (statusNum == 7) {
status = "完成";
} else if (statusNum == 87) {
status = "同意";
// if(webUser!=null && webUser.getLoginno().equals("sysadmin")){
// status="自动审批";
// }
// } else if (statusNum == 85) {
// status = "回撤";
// } else if (statusNum == 86) {
// status = "系统干预";
// name = "系统干预";
}
//83--流转到自动节点
}
if (count > 1) {
message += "<tr><td>"
+ name
+ "</td><td>"
+ nodeName
+ "</td><td>"
+ status
// + "</td><td>"
+ " "
+ attitude
+ "</td><td>"
+ time + "</td></tr>";
}
}
message += "</tbody></table>";
}
}
return message;
} |