flowHis
11de-f053-df18d577-aeb6-19a7865cfdb6
11de-f053-df18d577-aeb6-19a7865cfdb6
| 审批人 | 办理人签字 | 审批意见 | 办理时间 |
";
var txtNo = getItemValueAsString("表单编号");
var docNamestr = curDoc.getFormname();
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 ITEM_表单编号 ='"+txtNo+"') order by processtime";
var datas = queryByDSName("JSPTPD OA",sql);
var rtn="";
var count = 0;
if(datas!=null&&datas.size()>0){
for(var iter = datas.iterator();iter.hasNext();){
count = count + 1;
var doc = iter.next();
var name = doc.get("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 HH:mm:ss");
// var time= parseDate(time2,"yyyy-MM-dd HH:mm:ss");
var id = doc.get("nodehis_id");
var nodeName = "";
var sql1 = "select startNodename from t_relationhis where id = '"+id+"' order by actiontime";
var datas1 = queryByDSName("JSPTPD OA",sql1);
if(datas1!=null&&datas1.size()>0){
nodeName = datas1.iterator().next().get("startNodename");
}
if(count>1){
message += "| "+nodeName+" | "+name+" | "+attitude+" | "+time+" |
";
}
}
}
return message;
}
function testhis2(){
var curDoc = getCurrentDocument();
var message="| 审批节点 | 办理人签字 | 签核状态 | 签核意见 | 办理时间 |
";
var txtNo = curDoc.getId();
var docNamestr = curDoc.getFormname();
var docName = "";
if (docNamestr!=null) {
docName = docNamestr.substring(docNamestr.lastIndexOf("/")+1,docNamestr.trim().length());
}
var sql = "select nodehis_id,name,attitude,processtime from T_Actorhis with(nolock) where flowstatert_id in (select state from TLK_"+docName+" with(nolock) where id ='"+txtNo+"') order by processtime";
var datas = queryByDSName("JSPTPD OA",sql);
var rtn="";
var count = 0;
if(datas!=null&&datas.size()>0){
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("admin")) {
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 HH:mm:ss");
// 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 with(nolock) where id = '"+id+"' order by actiontime";
var datas1 = queryByDSName("JSPTPD OA",sql1);
println("sql="+sql);
println(datas1.size());
if(datas1!=null&&datas1.size()>0){
var hisdate = datas1.iterator().next();
nodeName = hisdate.get("startNodename");
var statusNum = hisdate.get("flowoperation")-0;
//println("签核状态签核状态签核状态签核状态签核状态"+statusNum);
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 = "自动审批";
attitude = "自动审批";
} else if (statusNum == 85) {
status = "回撤";
attitude = "回撤";
} else if (statusNum == 86) {
status = "系统干预";
name = "系统干预";
}
}
if(count>1){
message += "| "+nodeName+" | "+name+" | "+status+" | "+attitude+" | "+time+" |
";
}
}
}
message += "
";
return message;
}
function testhis(){
var curDoc = getCurrentDocument();
var message="| 审批节点 | 办理人签字 | 签核状态 | 签核意见 | 办理时间 |
";
var txtNo = curDoc.getId();
var sql = "select acthis.nodehis_id,acthis.name,acthis.attitude,acthis.processtime,relhis.startNodename, relhis.flowoperation from T_Actorhis acthis , t_relationhis relhis where acthis.nodehis_id=relhis.id and acthis.flowstatert_id = relhis.flowstatert_id and acthis.flowstatert_id = (select state from t_document where id ='"+txtNo+"') order by acthis.processtime";
var datas = queryByDSName("办公管理系统模板_DS",sql);
var count = 0;
println("sql="+sql);
println(datas.size());
if(datas!=null&&datas.size()>0){
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("admin")) {
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 HH:mm:ss");
// var time= parseDate(time2,"yyyy-MM-dd HH:mm:ss");
var id = doc.get("nodehis_id");
var nodeName = "";
var status = "";
nodeName = doc.get("startNodename");
var statusNum = doc.get("flowoperation")-0;
println("签核状态签核状态签核状态签核状态签核状态"+statusNum);
var attitude = "同意";
var att = doc.get("attitude");
if(att!=null&&att.trim().length()>0 && statusNum!=81){
attitude = att;
}
if (statusNum == 80) {
if (name.indexOf("[")>=0 || name.indexOf("]")>=0) {
status = "代理审批";
} else {
status = "同意";
}
} else if (statusNum == 81) {
status = "驳回";
if(att==null||att.trim().length()<=0){
attitude = "驳回";
}else{
attitude = att;
}
} else if (statusNum == 7) {
status = "完成";
} else if (statusNum == 87) {
status = "自动审批";
attitude = "自动审批";
} else if (statusNum == 85) {
status = "回撤";
attitude = "回撤";
} else if (statusNum == 86) {
status = "系统干预";
name = "系统干预";
}
if(count>1){
message += "| "+nodeName+" | "+name+" | "+status+" | "+attitude+" | "+time+" |
";
}
}
}
message += "
";
return message;
}]]>
12