流程审批历史的函数

function testhis(){
    var curDoc = getCurrentDocument();
    var message="<table cellSpacing='0' cellPadding='1' width='100%' align='center' style='border:solid #cccccc;border-width:1px 0px 0px 1px;'><tbody><tr style='line-height:22px;'><td style='align:center;font-size:larger;font-family: Arial;border:solid #cccccc;border-width:0px 1px 1px 0px;background-color:#EFF0F1;width=150px;' >审批节点</td><td style='align:center;font-size:larger;font-family: Arial;border:solid #cccccc;border-width:0px 1px 1px 0px;background-color:#EFF0F1;width=110px' >办理人签字</td><td style='align:center;font-size:larger;font-family: Arial;border:solid #cccccc;border-width:0px 1px 1px 0px;background-color:#EFF0F1;width=100px' >签核状态</td><td style='font-size:larger;font-family: Arial;border:solid #cccccc;border-width:0px 1px 1px 0px;background-color:#EFF0F1;'  >签核意见</td><td style='font-size:larger;font-family: Arial;border:solid #cccccc;border-width:0px 1px 1px 0px;background-color:#EFF0F1;width=150px' >办理时间</td></tr>";
    var txtNo = curDoc.getId();
    var sql = "select acthis.nodehis_id,acthis.name,acthis.attitude,acthis.processtime,relhis.startNodename, relhis.flowoperation from T_Actorhis acthis with(nolock), t_relationhis relhis with(nolock) where acthis.nodehis_id=relhis.id and acthis.flowstatert_id = relhis.flowstatert_id and acthis.flowstatert_id = (select top 1 state from t_document with(nolock) where id ='"+txtNo+"') order by acthis.processtime";
    var datas  = queryByDSName("数据源",sql);
    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 = "";
            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) {
                if (name!=null && name.equals("系统管理员")) {
                    status = "系统干预";
                } else {
                    status = "提交至回退人";
                }
                //name = "系统干预";
            }  else if (statusNum == 100) {
                status = "提交至回退人";
            }

            if(count>1){
                message += "<tr style='line-height:22px;'><td style='font-size:larger;font-family: Arial;border:solid #cccccc;border-width:0px 1px 1px 0px;align:center;'>"+nodeName+"</td><td style='font-size:larger;font-family: Arial;border:solid #cccccc;border-width:0px 1px 1px 0px;align:center;'><font style='font-weight:bold;'>"+name+"</font></td><td style='font-size:larger;font-family: Arial;border:solid #cccccc;border-width:0px 1px 1px 0px;'>"+status+"</td><td style='font-size:larger;font-family: Arial;border:solid #cccccc;border-width:0px 1px 1px 0px;'>"+attitude+"</td><td style='align:center;font-size:larger;font-family: Arial;border:solid #cccccc;border-width:0px 1px 1px 0px;'>"+time+"</td></tr>";
            }
        }
    }
    message += "</tbody></table>";
    return message;
}