flowAttendTime
11de-f053-df18d577-aeb6-19a7865cfdb6
11de-f053-df18d577-aeb6-19a7865cfdb6
" + stateLabel);
// println("prevAuditNodeJSONStr-->" + prevAuditNodeJSONStr);
if(isNotNull(prevAuditNodeJSONStr) && isNotNull(stateLabel)) {
var prevAuditNodeJSONArray= Packages.net.sf.json.JSONArray.fromObject(prevAuditNodeJSONStr);
var prevAuditNodeJSON = prevAuditNodeJSONArray.getJSONObject(0);
var prevAuditNode = prevAuditNodeJSON.get("prevAuditNode");
// println("stateLabel-->" + stateLabel);
// println("prevAuditNodeJSONStr-->" + prevAuditNodeJSONStr);
var docProcess = getDocumentProcess();
var formProcess = getFormProcess();
//需要更新的表
var newForm = formProcess.doViewByFormName("BUSINESS_PENDDING_DAY",getApplication());
if((prevAuditNodeJSONStr.indexOf("部门主要负责人办理中") > -1 || prevAuditNodeJSONStr.indexOf("未提交") > -1) && stateLabel.indexOf("主、会办部门办理中") > -1 ) {
// println("插入数据---" );
var hostDeptId = "";
var helpDeptId = "";
if(stateLabel.indexOf("区县局") > -1) {
hostDeptId = doc.getItemValueAsString("COUNTY_HOST_DEPT_ID");
helpDeptId = doc.getItemValueAsString("COUNTY_HELP_DEPT_ID");
}else if(stateLabel.indexOf("市局") > -1) {
hostDeptId = doc.getItemValueAsString("CITY_HOST_DEPT_ID");
helpDeptId = doc.getItemValueAsString("CITY_HELP_DEPT_ID");
}else if(stateLabel.indexOf("省局") > -1) {
hostDeptId = doc.getItemValueAsString("PROVINCE_HOST_DEPT_ID");
helpDeptId = doc.getItemValueAsString("PROVINCE_HELP_DEPT_ID");
}else if(stateLabel.indexOf("网信办") > -1) {
hostDeptId = doc.getItemValueAsString("CAC_HOST_DEPT_ID");
helpDeptId = doc.getItemValueAsString("CAC_HELP_DEPT_ID");
}
/* if((prevAuditNodeJSONStr.indexOf("提出人部门主要负责人办理中") > -1 || prevAuditNodeJSONStr.indexOf("未提交") > -1 ) && stateLabel.indexOf("区县局主、会办部门办理中") > -1 ) {
hostDeptId = doc.getItemValueAsString("COUNTY_HOST_DEPT_ID");
helpDeptId = doc.getItemValueAsString("COUNTY_HELP_DEPT_ID");
}else if((prevAuditNodeJSONStr.indexOf("区县局部门主要负责人办理中") > -1 || prevAuditNodeJSONStr.indexOf("未提交") > -1 || prevAuditNodeJSONStr.indexOf("提出人部门主要负责人办理中") > -1) && stateLabel.indexOf("市局主、会办部门办理中") > -1 ) {
hostDeptId = doc.getItemValueAsString("CITY_HOST_DEPT_ID");
helpDeptId = doc.getItemValueAsString("CITY_HELP_DEPT_ID");
}else if((prevAuditNodeJSONStr.indexOf("市局部门主要负责人办理中") > -1 || prevAuditNodeJSONStr.indexOf("未提交") > -1 || prevAuditNodeJSONStr.indexOf("提出人部门主要负责人办理中") > -1) && stateLabel.indexOf("省局主、会办部门办理中") > -1 ) {
hostDeptId = doc.getItemValueAsString("PROVINCE_HOST_DEPT_ID");
helpDeptId = doc.getItemValueAsString("PROVINCE_HELP_DEPT_ID");
}else if((prevAuditNodeJSONStr.indexOf("省部门主要负责人办理中") > -1 || prevAuditNodeJSONStr.indexOf("未提交") > -1 || prevAuditNodeJSONStr.indexOf("提出人部门主要负责人办理中") > -1) && stateLabel.indexOf("网信办主、会办部门办理中") > -1 ) {
hostDeptId = doc.getItemValueAsString("CAC_HOST_DEPT_ID");
helpDeptId = doc.getItemValueAsString("CAC_HELP_DEPT_ID");
} */
// println("hostDeptId---" + hostDeptId);
// println("helpDeptId---" + helpDeptId);
//插入主办
var hostDeptSelSQL = "SELECT DOMAINID FROM TLK_BUSINESS_PENDDING_DAY WHERE PARENT='"+ docId +"' AND ITEM_DEPT_ID = '"+ hostDeptId +"' AND ITEM_STATE = '0'";
// println("hostDeptSelSQL---" + hostDeptSelSQL);
var countyHostDeptCount = countBySQL(hostDeptSelSQL);
if(countyHostDeptCount <= 0) {
var newDoc = docProcess.doNew(newForm,getWebUser(),sysfunction.getParamsTable());
var businessPenddingDayId = new Packages.cn.myapps.util.sequence.Sequence().getSequence();
newDoc.setId(businessPenddingDayId);
newDoc.setParent(docId);
newDoc.setAuthor(webUserId);
newDoc.setIstmp(false);
newDoc.setApplicationid(applicationId);
newDoc.setDomainid(domainid);
newDoc.addStringItem("DEPT_ID",hostDeptId);
newDoc.addStringItem("STATE","0");
newDoc.addDateItem("START_TIME",getToday());
docProcess.doCreate(newDoc);
}
if(isNotNull(helpDeptId)) {
var helpDeptIds = splitText(helpDeptId, ";");
for (var i = 0; i < helpDeptIds.length; i ++) {
var helpDeptSelSQL = "SELECT DOMAINID FROM TLK_BUSINESS_PENDDING_DAY WHERE PARENT='"+ docId +"' AND ITEM_DEPT_ID = '"+ helpDeptIds[i] +"' AND ITEM_STATE = '0'";
// println("helpDeptSelSQL---" + helpDeptSelSQL);
var countyHelpDeptCount = countBySQL(helpDeptSelSQL);
if(countyHelpDeptCount <= 0) {
var helpDeptNewDoc = docProcess.doNew(newForm,getWebUser(),sysfunction.getParamsTable());
var businessPenddingDayId = new Packages.cn.myapps.util.sequence.Sequence().getSequence();
helpDeptNewDoc.setId(businessPenddingDayId);
helpDeptNewDoc.setParent(docId);
helpDeptNewDoc.setAuthor(webUserId);
helpDeptNewDoc.setIstmp(false);
helpDeptNewDoc.setApplicationid(applicationId);
helpDeptNewDoc.setDomainid(domainid);
helpDeptNewDoc.addStringItem("DEPT_ID",helpDeptIds[i]);
helpDeptNewDoc.addStringItem("STATE","0");
helpDeptNewDoc.addDateItem("START_TIME",getToday());
docProcess.doCreate(helpDeptNewDoc);
}
}
}
}
if(prevAuditNodeJSONStr.indexOf("主要负责人办理") > -1 && (stateLabel.indexOf("提出部门") > -1 || stateLabel.indexOf("主、会办部门办理") > -1 || stateLabel.indexOf("主办部门业务保障岗办理") > -1 )) {
// println("更新数据---" );
//更新
var updateSQL = "UPDATE TLK_BUSINESS_PENDDING_DAY SET ITEM_STATE = '1',ITEM_END_TIME=to_timestamp('"+ today +"','yyyy-mm--dd hh24:mi:ss.ff') WHERE PARENT='"+ docId +"' AND ITEM_DEPT_ID = '"+ defaultDepartment +"' AND ITEM_STATE = '0'";
// println("updateSQL---" + updateSQL);
sysfunction.updateByDSName(updateSQL);
}
flowAttendTime.setReturnFlowAttendTime();
}
},
/**
* author : Andy
* 需要引用的函数库 ： flowAttendTime
* 使用范围：待办界面查询办理时限
*
*/
getAttendTime : function() {
var webUser = getWebUser();
var webUserId = webUser.getId();
var defaultDepartment = webUser.getDefaultDepartment();
var doc = getCurrentDocument();
var docId = doc.getId();
var stateLabel = doc.getStateLabel();
// println("defaultDepartment-->" + defaultDepartment);
// println("docId-->" + docId);
var hostDeptId = "";
var helpDeptId = "";
var flag = false;
if(isNotNull(stateLabel)) {
// println("stateLabel-->" + stateLabel);
if(stateLabel.substring(0,3).indexOf("区县局") > -1) {
hostDeptId = doc.getItemValueAsString("COUNTY_HOST_DEPT_ID");
helpDeptId = doc.getItemValueAsString("COUNTY_HELP_DEPT_ID");
if(helpDeptId.indexOf(defaultDepartment) > -1) {
flag = true;
}
}else if(stateLabel.substring(0,3).indexOf("市局",0) > -1) {
hostDeptId = doc.getItemValueAsString("CITY_HOST_DEPT_ID");
helpDeptId = doc.getItemValueAsString("COUNTY_HELP_DEPT_ID");
if(helpDeptId.indexOf(defaultDepartment) > -1) {
flag = true;
}
}else if(stateLabel.substring(0,3).indexOf("省局",0) > -1) {
hostDeptId = doc.getItemValueAsString("PROVINCE_HOST_DEPT_ID");
helpDeptId = doc.getItemValueAsString("COUNTY_HELP_DEPT_ID");
if(helpDeptId.indexOf(defaultDepartment) > -1) {
flag = true;
}
}else if(stateLabel.substring(0,3).indexOf("网信办",0) > -1) {
hostDeptId = doc.getItemValueAsString("CAC_HOST_DEPT_ID");
helpDeptId = doc.getItemValueAsString("COUNTY_HELP_DEPT_ID");
if(helpDeptId.indexOf(defaultDepartment) > -1) {
flag = true;
}
}
var sql = "";
if(flag) {
sql = "SELECT DOMAINID,ITEM_START_TIME FROM TLK_BUSINESS_PENDDING_DAY WHERE ITEM_DEPT_ID='"+ defaultDepartment +"' AND PARENT='"+ docId +"' AND ITEM_STATE='0' AND ROWNUM=1 ORDER BY ITEM_START_TIME DESC";
}else {
sql = "SELECT DOMAINID,ITEM_START_TIME FROM TLK_BUSINESS_PENDDING_DAY WHERE ITEM_DEPT_ID='"+ hostDeptId +"' AND PARENT='"+ docId +"' AND ITEM_STATE='0' AND ROWNUM=1 ORDER BY ITEM_START_TIME DESC";
}
// println("sql-->" + sql);
var fDoc = findBySQL(sql);
if(fDoc != null) {
var start_time = fDoc.getItemValueAsDate("START_TIME") + "";
// println("start_time-->" + start_time);
var timesCount = getWorkingTimesCount(start_time,format(getToday(),"yyyy-MM-dd HH:mm:ss"));
// var timesCount = getWorkingTimesCount(start_time,"2018-04-08 23:59:59");
// println("timesCount-->" + timesCount);
if(timesCount >= 0) {
/* var dayCount = timesCount / 8;
//var hoursCount = timesCount % 8;
dayCount = 5 - dayCount;
if(dayCount >= 0) {
//return dayCount + "天" + hoursCount + "小时";
return dayCount + "天";
}else {
return "超时";
}*/
var timesCountDecimal = new Packages.java.math.BigDecimal(timesCount);
var timesCountDecimal2 = new Packages.java.math.BigDecimal(8);
//var dayCount = timesCount / 8;
var dayCount = timesCountDecimal.divide(timesCountDecimal2);
//var hoursCount = timesCount % 8;
dayCount = 5 - dayCount;
// println("dayCount--->" + dayCount);
var newDayCount = new Packages.java.text.DecimalFormat("#.00").format(dayCount);
if(dayCount >= 0) {
// return dayCount + "天" + hoursCount + "小时";
return newDayCount + "天";
}else {
return "超时";
}
}else {
return "超时";
}
}
}
return "";
}
}]]>
65