跳转到主要内容

未能生成预算费用执行数据的流程处理

问题:

在报销流程、借款流程以及还款流程,因流程的版本迭代更新,可能因操作或者配置失误导致报销等流程执行时不能扣除预算数,导致预算数据统计不准确。

官方工具:

本功能仅能处理: 1、仅是预申请、或者仅是事后报销的报销流程;
2、自定义表单借还款流程;
请将附件中的文件按目录更新到用户oa服务器上,不需要重启oa服务
更新后,请使用sysadmin用户登录,并访问以下地址:
/fna/do/QueryRequest.jsp 这是一个查询页面,使用requestid查询出该条流程,并右键执行action按钮
1、报销流程:会重新冻结(流程不在创建节点)并扣除(流程已经归档)流程中当前填写的预算数据。
注:如果该条报销流程是预申请流程,则会一并清除相关的事后报销的冲销记录(如果有的话)。请再次重新生成相关事后报销冲销记录!
2、借款流程:会重新生成借款(流程不在创建节点)
注:当重新生成借款时,如果该流程已经有被冲销/还款的记录,则会一并清除相关的冲销/还款记录(如果有的话)。请再次重新生成还款记录!
3、还款流程:会重新冻结借款数据(流程不在创建节点)并冲销/还款(流程已经归档)流程中当前填写的预算数据。
注:此功能只支持e8、e9后台配置的报销流程、只支持标准功能不支持二次开发的功能、不支持开启了结转并进行了结转的流程数据。

DoFnaBudgetAdd.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8" %> 
<%@ taglib uri="/WEB-INF/weaver.tld" prefix="wea"%><!--added by xwj for td2023 on 2005-05-20-->
<%@ include file="/systeminfo/init_wev8.jsp" %>
<%@ page import="weaver.general.GCONST" %>
<%@ page import="weaver.general.IsGovProj" %>
<%@ page import="weaver.general.Util" %>
<%@ page import="java.util.*" %>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<%@page import="weaver.soa.workflow.request.RequestService"%>
<%@page import="weaver.soa.workflow.request.RequestInfo"%>
<%@page import="weaver.interfaces.workflow.action.Action"%>
<%@page import="weaver.soa.workflow.request.Property"%>
<%@page import="weaver.interfaces.workflow.action.FnaBorrowEffectNew"%>
<%@page import="weaver.interfaces.workflow.action.FnaBorrowReverseNew"%>
<%@page import="weaver.interfaces.workflow.action.WorkflowFnaInWorkflowNew"%>
<%@page import="weaver.interfaces.workflow.action.WorkflowFnaEffectNew"%>
<%@page import="weaver.interfaces.workflow.action.FnaBorrowReleaseFreezeNew"%>
<%@page import="weaver.interfaces.workflow.action.FnaBorrowFreezeNew"%>
<%@page import="weaver.interfaces.workflow.action.FnaBorrowReleaseNew"%>
<%@page import="weaver.interfaces.workflow.action.WorkflowFnaRejectNew"%>
<%@page import="weaver.fna.budget.FnaWfSet"%><HTML><HEAD>
</head>
<%
String userid=""+user.getUID();

if(!HrmUserVarify.checkUserRight("DoFnaBudgetAddAction:page11223",user)){
	response.sendRedirect("/notice/noright.jsp") ;
	return ;
}

if(user.getUID()!=1){
	response.sendRedirect("/notice/noright.jsp") ;
	return ;
}

String errorMsg = "";

BaseBean bb = new BaseBean();

String reqIds = Util.null2String(request.getParameter("reqIds")).trim();
String[] reqIdsArray = reqIds.split(",");
for(int i=0;i<reqIdsArray.length;i++){
	int requestId = Util.getIntValue(Util.null2String(reqIdsArray[i]).trim(), 0);
	if(requestId > 0){
		try{
			RequestService requestService = new RequestService();
			
			String sql = "select '本功仅能处理:仅是预申请、或者仅是事后报销的报销流程' memo2, e.fnaWfType, e.fnaWfTypeColl, e.fnaWfTypeReverse, d.formid, a.workflowid, d.workflowname, a.requestid, a.requestname, a.currentnodetype, a.currentnodeid, b.nodename, a.creater, a.createdate \n" +
				" FROM workflow_requestbase a \n" +
				" JOIN workflow_nodebase b on a.currentnodeid = b.id \n" +
				" JOIN workflow_base d on a.workflowid = d.id \n" +
				" JOIN fnaFeeWfInfo e on a.workflowid = e.workflowid \n"+
				" where a.currentnodetype <> 0 \n" +
	        	" and a.requestid = "+requestId+" "+
				" order by a.createdate, a.requestid, a.requestname";
			bb.writeLog(sql);
			rs.executeSql(sql);
			if(rs.next()){
				int workflowid = rs.getInt("workflowid");
				int _workflowid = workflowid;
				int currentnodetype = rs.getInt("currentnodetype");
				int formid = rs.getInt("formid");
				int formidABS = Math.abs(formid);
				String fnaWfType = Util.null2String(rs.getString("fnaWfType")).trim();
				int fnaWfTypeColl = rs.getInt("fnaWfTypeColl");
				int fnaWfTypeReverse = rs.getInt("fnaWfTypeReverse");

				if("fnaFeeWf".equals(fnaWfType)){//报销流程
					if(true){//启用报销
						if(currentnodetype == 0){
							WorkflowFnaRejectNew action = new WorkflowFnaRejectNew();
							RequestInfo requestInfo = requestService.getRequest(requestId);
							requestInfo.getRequestManager().setWorkflowid(workflowid);
							requestInfo.getRequestManager().setFormid(formid);
							requestInfo.getRequestManager().setSrc("submit");
							action.execute(requestInfo);
							if(!"".equals(requestInfo.getRequestManager().getMessageid())){
								throw new Exception(requestInfo.getRequestManager().getMessagecontent());
							}
						}
					
						if(currentnodetype > 0){
		            		//冻结-节点前附加操作
		            		String frozeNode1Ids = FnaWfSet.getActionSet4Wf(_workflowid, "frozeNode1Ids");
		            		//冻结-节点后附加操作
		            		String frozeNode2Ids = FnaWfSet.getActionSet4Wf(_workflowid, "frozeNode2Ids");
		            		//冻结-出口附加操作
		            		String frozeNode3Ids = FnaWfSet.getActionSet4Wf(_workflowid, "frozeNode3Ids");
		        			
		        			//配置了冻结预算的action(workflowFnaInWorkflowNew)
		        			if((!"".equals(frozeNode1Ids) || !"".equals(frozeNode2Ids) || !"".equals(frozeNode3Ids))){
								WorkflowFnaInWorkflowNew action = new WorkflowFnaInWorkflowNew();
								RequestInfo requestInfo = requestService.getRequest(requestId);
								requestInfo.getRequestManager().setWorkflowid(workflowid);
								requestInfo.getRequestManager().setFormid(formid);
								requestInfo.getRequestManager().setSrc("submit");
								action.execute(requestInfo);
								if(!"".equals(requestInfo.getRequestManager().getMessageid())){
									throw new Exception(requestInfo.getRequestManager().getMessagecontent());
								}
		        			}
						}
						
						if(currentnodetype == 3){
		        			//扣除-节点前附加操作
		        			String deductNode1Ids = FnaWfSet.getActionSet4Wf(_workflowid, "deductNode1Ids");
		        			//扣除-节点后附加操作
		        			String deductNode2Ids = FnaWfSet.getActionSet4Wf(_workflowid, "deductNode2Ids");
		        			//扣除-出口附加操作
		        			String deductNode3Ids = FnaWfSet.getActionSet4Wf(_workflowid, "deductNode3Ids");
		
		        			//配置了扣除预算的action(WorkflowFnaEffectNew)
		        			if(!"".equals(deductNode1Ids) || !"".equals(deductNode2Ids) || !"".equals(deductNode3Ids)){
								WorkflowFnaEffectNew action = new WorkflowFnaEffectNew();
								RequestInfo requestInfo = requestService.getRequest(requestId);
								requestInfo.getRequestManager().setWorkflowid(workflowid);
								requestInfo.getRequestManager().setFormid(formid);
								requestInfo.getRequestManager().setSrc("submit");
								action.execute(requestInfo);
								if(!"".equals(requestInfo.getRequestManager().getMessageid())){
									throw new Exception(requestInfo.getRequestManager().getMessagecontent());
								}
		        			}
						}
					}
					
					if((fnaWfTypeReverse>0 && fnaWfTypeColl>0)){//启用还款
						if(currentnodetype == 0){
							FnaBorrowReleaseFreezeNew action = new FnaBorrowReleaseFreezeNew();
							RequestInfo requestInfo = requestService.getRequest(requestId);
							requestInfo.getRequestManager().setWorkflowid(workflowid);
							requestInfo.getRequestManager().setFormid(formid);
							requestInfo.getRequestManager().setSrc("submit");
							action.execute(requestInfo);
							if(!"".equals(requestInfo.getRequestManager().getMessageid())){
								throw new Exception(requestInfo.getRequestManager().getMessagecontent());
							}
						}
					
						if(currentnodetype > 0){
							FnaBorrowFreezeNew action = new FnaBorrowFreezeNew();
							RequestInfo requestInfo = requestService.getRequest(requestId);
							requestInfo.getRequestManager().setWorkflowid(workflowid);
							requestInfo.getRequestManager().setFormid(formid);
							requestInfo.getRequestManager().setSrc("submit");
							action.execute(requestInfo);
							if(!"".equals(requestInfo.getRequestManager().getMessageid())){
								throw new Exception(requestInfo.getRequestManager().getMessagecontent());
							}
						}
					
						if(currentnodetype == 3){
		        			//冲销借款-节点前附加操作
		        			String repaymentBorrowNode1Ids = FnaWfSet.getActionSet4Wf(_workflowid, "repaymentBorrowNode1Ids");
		        			//冲销借款-节点后附加操作
		        			String repaymentBorrowNode2Ids = FnaWfSet.getActionSet4Wf(_workflowid, "repaymentBorrowNode2Ids");
		        			//冲销借款-出口附加操作
		        			String repaymentBorrowNode3Ids = FnaWfSet.getActionSet4Wf(_workflowid, "repaymentBorrowNode3Ids");
		        			//配置了冲销借款的action(fnaBorrowReverseNew)
		        			if(!"".equals(repaymentBorrowNode1Ids) || !"".equals(repaymentBorrowNode2Ids) || !"".equals(repaymentBorrowNode3Ids)){
								FnaBorrowReverseNew action = new FnaBorrowReverseNew();
								RequestInfo requestInfo = requestService.getRequest(requestId);
								requestInfo.getRequestManager().setWorkflowid(workflowid);
								requestInfo.getRequestManager().setFormid(formid);
								requestInfo.getRequestManager().setSrc("submit");
								action.execute(requestInfo);
								if(!"".equals(requestInfo.getRequestManager().getMessageid())){
									throw new Exception(requestInfo.getRequestManager().getMessagecontent());
								}
		        			}
						}
					}
				}
				
				if("borrow".equals(fnaWfType)){//借款流程
					if(currentnodetype == 0){
						FnaBorrowReleaseNew action = new FnaBorrowReleaseNew();
						RequestInfo requestInfo = requestService.getRequest(requestId);
						requestInfo.getRequestManager().setWorkflowid(workflowid);
						requestInfo.getRequestManager().setFormid(formid);
						requestInfo.getRequestManager().setSrc("submit");
						action.execute(requestInfo);
						if(!"".equals(requestInfo.getRequestManager().getMessageid())){
							throw new Exception(requestInfo.getRequestManager().getMessagecontent());
						}
					}

					if(currentnodetype > 0){
	            		//扣除-节点前附加操作
	            		String deductBorrowNode1Ids = FnaWfSet.getActionSet4Wf(_workflowid, "deductBorrowNode1Ids");
	            		//扣除-节点后附加操作
	            		String deductBorrowNode2Ids = FnaWfSet.getActionSet4Wf(_workflowid, "deductBorrowNode2Ids");
	            		//扣除-出口附加操作
	            		String deductBorrowNode3Ids = FnaWfSet.getActionSet4Wf(_workflowid, "deductBorrowNode3Ids");
	        			//配置了生成借款的action(FnaBorrowEffectNew)
	        			if(!"".equals(deductBorrowNode1Ids) || !"".equals(deductBorrowNode2Ids) || !"".equals(deductBorrowNode3Ids)){
							FnaBorrowEffectNew action = new FnaBorrowEffectNew();
							RequestInfo requestInfo = requestService.getRequest(requestId);
							requestInfo.getRequestManager().setWorkflowid(workflowid);
							requestInfo.getRequestManager().setFormid(formid);
							requestInfo.getRequestManager().setSrc("submit");
							action.execute(requestInfo);
							if(!"".equals(requestInfo.getRequestManager().getMessageid())){
								throw new Exception(requestInfo.getRequestManager().getMessagecontent());
							}
	        			}
					}
				}

				if("repayment".equals(fnaWfType)){//还款流程
					if(currentnodetype == 0){
						FnaBorrowReleaseFreezeNew action = new FnaBorrowReleaseFreezeNew();
						RequestInfo requestInfo = requestService.getRequest(requestId);
						requestInfo.getRequestManager().setWorkflowid(workflowid);
						requestInfo.getRequestManager().setFormid(formid);
						requestInfo.getRequestManager().setSrc("submit");
						action.execute(requestInfo);
						if(!"".equals(requestInfo.getRequestManager().getMessageid())){
							throw new Exception(requestInfo.getRequestManager().getMessagecontent());
						}
					}
				
					if(currentnodetype > 0){
						FnaBorrowFreezeNew action = new FnaBorrowFreezeNew();
						RequestInfo requestInfo = requestService.getRequest(requestId);
						requestInfo.getRequestManager().setWorkflowid(workflowid);
						requestInfo.getRequestManager().setFormid(formid);
						requestInfo.getRequestManager().setSrc("submit");
						action.execute(requestInfo);
						if(!"".equals(requestInfo.getRequestManager().getMessageid())){
							throw new Exception(requestInfo.getRequestManager().getMessagecontent());
						}
					}
				
					if(currentnodetype == 3){
	        			//冲销借款-节点前附加操作
	        			String repaymentBorrowNode1Ids = FnaWfSet.getActionSet4Wf(_workflowid, "repaymentBorrowNode1Ids");
	        			//冲销借款-节点后附加操作
	        			String repaymentBorrowNode2Ids = FnaWfSet.getActionSet4Wf(_workflowid, "repaymentBorrowNode2Ids");
	        			//冲销借款-出口附加操作
	        			String repaymentBorrowNode3Ids = FnaWfSet.getActionSet4Wf(_workflowid, "repaymentBorrowNode3Ids");
	        			//配置了冲销借款的action(FnaBorrowReverseNew)
	        			if(!"".equals(repaymentBorrowNode1Ids) || !"".equals(repaymentBorrowNode2Ids) || !"".equals(repaymentBorrowNode3Ids)){
							FnaBorrowReverseNew action = new FnaBorrowReverseNew();
							RequestInfo requestInfo = requestService.getRequest(requestId);
							requestInfo.getRequestManager().setWorkflowid(workflowid);
							requestInfo.getRequestManager().setFormid(formid);
							requestInfo.getRequestManager().setSrc("submit");
							action.execute(requestInfo);
							if(!"".equals(requestInfo.getRequestManager().getMessageid())){
								throw new Exception(requestInfo.getRequestManager().getMessagecontent());
							}
	        			}
					}
				}
			}
		}catch(Exception e){
			errorMsg = e.getMessage();
		}
	}
}

%>
<%@ include file="/systeminfo/RightClickMenuConent_wev8.jsp" %>
<script type="text/javascript">
function _goBack(){
	window.location.href = "/fna/do/QueryRequest.jsp?reqIds=<%=reqIds %>";
}
</script>
<%
RCMenu += "{返回,javascript:_goBack(),_self}" ;
RCMenuHeight += RCMenuHeightStep ;
%>
<%if("".equals(errorMsg)){ %>
请检查流程预算(借还款)数据是否正确生成,右键返回查询界面
<%}else{ %>
流程预算(借还款)数据生成失败:<%=errorMsg %>,右键返回查询界面
<%} %>
<%@ include file="/systeminfo/RightClickMenu_wev8.jsp" %>
<BODY>

</html>

QueryRequest.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8" %> 
<%@ taglib uri="/WEB-INF/weaver.tld" prefix="wea"%><!--added by xwj for td2023 on 2005-05-20-->
<%@ include file="/systeminfo/init_wev8.jsp" %>
<%@ page import="weaver.general.GCONST" %>
<%@ page import="weaver.general.IsGovProj" %>
<%@ page import="weaver.general.Util" %>
<%@ page import="java.util.*" %>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="UserDefaultManager" class="weaver.docs.tools.UserDefaultManager" scope="session" />

<%@page import="org.apache.commons.lang.StringEscapeUtils"%><HTML><HEAD>
<LINK href="/css/Weaver_wev8.css" type="text/css" rel=STYLESHEET>
<SCRIPT language="javascript" src="../../js/weaver_wev8.js"></script>

</head>
<%
String userid=""+user.getUID();

if(!HrmUserVarify.checkUserRight("DoFnaBudgetAddAction:page11223",user)){
	response.sendRedirect("/notice/noright.jsp") ;
	return ;
}

if(user.getUID()!=1){
	response.sendRedirect("/notice/noright.jsp") ;
	return ;
}

int isgoveproj = Util.getIntValue(IsGovProj.getPath(),0);//0:非政务系统,1:政务系统
String imagefilename = "/images/hdDOC.gif";
String titlename = "查询流程";
String needfav ="1";
String needhelp ="";


int perpage=200;

String reqIds = Util.null2String(request.getParameter("reqIds")).trim();
String[] reqIdsArray = reqIds.split(",");
reqIds = "";
for(int i=0;i<reqIdsArray.length;i++){
	int requestId = Util.getIntValue(Util.null2String(reqIdsArray[i]).trim(), 0);
	if(requestId > 0){
		if(!"".equals(reqIds)){
			reqIds += ",";
		}
		reqIds += requestId;
	}
}

int isFromQry = Util.getIntValue(request.getParameter("isFromQry"), 0);
int requestId = Util.getIntValue(request.getParameter("requestId"), 0);
int wfid = Util.getIntValue(request.getParameter("wfid"), 0);
String requestmark = Util.null2String(request.getParameter("requestmark")).trim();
String createDay1 = Util.null2String(request.getParameter("createDay1")).trim();
String createDay2 = Util.null2String(request.getParameter("createDay2")).trim();
String fnaWfType = Util.null2String(request.getParameter("fnaWfType")).trim();
if("".equals(fnaWfType)){
	fnaWfType = "fnaFeeWf";
}
int cbx1 = Util.getIntValue(request.getParameter("cbx1"), 0);
int cbx2 = Util.getIntValue(request.getParameter("cbx2"), 0);
int cbx3 = Util.getIntValue(request.getParameter("cbx3"), 0);

boolean showCbx1 = true;
boolean showCbx2 = true;
boolean showCbx3 = true;

String tableString = "";

String backfields = " a.requestmark, a.workflowid, d.workflowname, a.requestid, a.requestname, \n" +
		"	a.currentnodetype, a.currentnodeid, b.nodename, \n" +
		"	a.creater, c.lastname, a.createdate ";
String fromSql = " FROM workflow_requestbase a \n" +
		" JOIN workflow_nodebase b on a.currentnodeid = b.id \n" +
		" LEFT JOIN HrmResource c on a.creater = c.id \n"+
		" JOIN workflow_base d on a.workflowid = d.id \n" +
		" JOIN fnaFeeWfInfo e on a.workflowid = e.workflowid \n";
String sqlWhere = " where 1=1 ";
if(isFromQry!=1){
	sqlWhere += " and 1=2 ";
}else{
    if(cbx1==1 && "fnaFeeWf".equals(fnaWfType)){
    	sqlWhere += " and not EXISTS (SELECT 1 from FnaExpenseInfo fei where fei.requestid = a.requestid) ";
    }
    if(cbx2==1 && "borrow".equals(fnaWfType)){
    	sqlWhere += " and not EXISTS (SELECT 1 from FnaBorrowInfo fbi where fbi.recordType in ('borrow') and fbi.amountBorrow is not null and fbi.amountBorrow <> 0.0 and fbi.requestid = a.requestid) ";
    }
    if(cbx3==1 && "repayment".equals(fnaWfType)){
    	sqlWhere += " and not EXISTS (SELECT 1 from FnaBorrowInfo fbi where fbi.recordType in ('reverse', 'freezeBorrow') and fbi.amountBorrow is not null and fbi.amountBorrow <> 0.0 and fbi.requestid = a.requestid) ";
    }
	sqlWhere += " and a.currentnodetype <> '0' ";
	if(!"".equals(createDay1)){
		sqlWhere += " and a.createdate >= '"+StringEscapeUtils.escapeSql(createDay1)+"' ";
	}
	if(!"".equals(createDay2)){
		sqlWhere += " and a.createdate <= '"+StringEscapeUtils.escapeSql(createDay2)+"' ";
	}
    if(!"".equals(requestmark)){
    	sqlWhere += " and a.requestmark = '"+StringEscapeUtils.escapeSql(requestmark)+"' ";
    }
	sqlWhere += " and e.fnaWfType = '"+StringEscapeUtils.escapeSql(fnaWfType)+"' ";
    if(!"".equals(reqIds)){
    	sqlWhere += " and a.requestid in ("+reqIds+") ";
    }
    if(requestId > 0){
    	sqlWhere += " and a.requestid = "+requestId+" ";
	}
    if(wfid > 0){
    	sqlWhere += " and a.workflowid = "+wfid+" ";
	}
}
String orderby = " a.createdate, a.requestid, a.requestname ";

String sqlprimarykey = "a.requestid"; 
  
out.println("本功仅能处理:<br />1、仅是预申请、或者仅是事后报销的报销流程<br />2、自定义表单借还款流程<br /><br /><br />");
out.println("1、报销流程:会重新冻结(流程不在创建节点)并扣除(流程已经归档)流程中当前填写的预算数据。<br />");
out.println("注:如果该条报销流程是预申请流程,则会一并清除相关的事后报销的冲销记录(如果有的话)。请再次重新生成相关事后报销冲销记录!<br />");
out.println("2、借款流程:会重新生成借款(流程不在创建节点) <br />");
out.println("注:当重新生成借款时,如果该流程已经有被冲销/还款的记录,则会一并清除相关的冲销/还款记录(如果有的话)。请再次重新生成还款记录!<br />");
out.println("3、还款流程:会重新冻结借款数据(流程不在创建节点)并冲销/还款(流程已经归档)流程中当前填写的预算数据。<br />");
out.println("<br />");
out.println("注:此功能只支持e8、e9后台配置的报销流程、只支持标准功能不支持二次开发的功能、不支持开启了结转并进行了结转的流程数据。<br /><br /><br />");
//out.println("select "+backfields+fromSql+sqlWhere+" order by "+orderby);

tableString =" <table instanceid=\"ecologyFnaDoQueryRequestTable\" tabletype=\"checkbox\" pagesize=\""+perpage+"\" >"+
             "	   <sql backfields=\""+Util.toHtmlForSplitPage(backfields)+"\" sqlform=\""+Util.toHtmlForSplitPage(fromSql)+"\" "+
             " 		sqlwhere=\""+Util.toHtmlForSplitPage(sqlWhere)+"\"  sqlorderby=\""+Util.toHtmlForSplitPage(orderby)+"\" "+
             " 		sqlprimarykey=\""+Util.toHtmlForSplitPage(sqlprimarykey)+"\" sqlsortway=\"Desc\" sqlisdistinct=\"true\" />"+
             "			<head>";
tableString+="				<col width=\"10%\"  text=\"请求id\" column=\"requestid\" orderkey=\"requestid\" />";
tableString+="				<col width=\"25%\"  text=\"流程名称\" column=\"requestname\" orderkey=\"requestname\" />";
tableString+="				<col width=\"25%\"  text=\"流程类型\" column=\"workflowname\" orderkey=\"workflowname\" />";
tableString+="				<col width=\"20%\"  text=\"当前节点\" column=\"nodename\" orderkey=\"nodename\" />";
tableString+="				<col width=\"10%\"  text=\"创建人\" column=\"lastname\" orderkey=\"lastname\" />";
tableString+="				<col width=\"10%\"  text=\"创建日期\" column=\"createdate\" orderkey=\"createdate\" />";
tableString+="			</head>"+   			
             "</table>";
%>
<body>
<%@ include file="/systeminfo/TopTitle_wev8.jsp" %>
<%@ include file="/systeminfo/RightClickMenuConent_wev8.jsp" %>
<%
RCMenu += "{"+SystemEnv.getHtmlLabelName(197,user.getLanguage())+",javascript:OnSearch(),_self}" ;
RCMenuHeight += RCMenuHeightStep ;

RCMenu += "{执行action,javascript:DoFnaBudgetAdd(),_self}" ;
RCMenuHeight += RCMenuHeightStep ;
%>


<form id=weaver name=frmmain method=post action="/fna/do/QueryRequest.jsp">
<input id="isFromQry" name="isFromQry" value="1" type="hidden" />

<br />
<input value="<%=SystemEnv.getHtmlLabelName(197,user.getLanguage()) %>" type="button" onclick="OnSearch()" />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<input value="执行action" type="button" onclick="DoFnaBudgetAdd()" />
<br />

<wea:layout type="4col">
	<wea:group context='查询条件' >
		<wea:item>流程路径workflowid</wea:item>
		<wea:item>
			<input id="wfid" name="wfid" value="<%=wfid %>" />
		</wea:item>

		<wea:item>流程id</wea:item>
		<wea:item>
			<input id="requestId" name="requestId" value="<%=requestId %>" />
		</wea:item>
		
		<wea:item>流程编号</wea:item>
		<wea:item>
			<input id="requestmark" name="requestmark" value="<%=requestmark %>" />
		</wea:item>
       	
		<wea:item>流程创建日期</wea:item>
		<wea:item>
			从<input id="createDay1" name="createDay1" value="<%=createDay1 %>" />
			至<input id="createDay2" name="createDay2" value="<%=createDay2 %>" />
		</wea:item>
       	
		<wea:item>流程类型</wea:item>
		<wea:item>
			<select id="fnaWfType" name="fnaWfType">
				<option value="fnaFeeWf" <%="fnaFeeWf".equals(fnaWfType)?"selected='selected'":"" %>>费用报销流程</option>
				<option value="borrow" <%="borrow".equals(fnaWfType)?"selected='selected'":"" %>>借款流程</option>
				<option value="repayment" <%="repayment".equals(fnaWfType)?"selected='selected'":"" %>>还款流程</option>
			</select>
		</wea:item>
		
	<%if(showCbx1){ %>
		<wea:item>只查询未能生成费用数据的流程</wea:item>
		<wea:item>
			<input id="cbx1" name="cbx1" value="1" type="checkbox" <%=(cbx1==1)?"checked='checked'":"" %> />
		</wea:item>
	<%} %>
	
	<%if(showCbx2){ %>
		<wea:item>只查询未能生成借款数据的流程</wea:item>
		<wea:item>
			<input id="cbx2" name="cbx2" value="1" type="checkbox" <%=(cbx2==1)?"checked='checked'":"" %> />
		</wea:item>
	<%} %>
	
	<%if(showCbx3){ %>
		<wea:item>只查询未能生成还款数据的流程</wea:item>
		<wea:item>
			<input id="cbx3" name="cbx3" value="1" type="checkbox" <%=(cbx3==1)?"checked='checked'":"" %> />
		</wea:item>
	<%} %>
	</wea:group>
	<wea:group context="" attributes="{\"groupDisplay\":\"none\"}" >
		<wea:item attributes="{'isTableList':'true'}">
        	<wea:SplitPageTag  tableString="<%=tableString%>"  mode="run" />
		</wea:item>
	</wea:group>
</wea:layout>

</form>
     
<%@ include file="/systeminfo/RightClickMenu_wev8.jsp" %>
</body>
<script language="javascript">
function OnSearch(){
	document.frmmain.submit();
}
function DoFnaBudgetAdd(){
	var reqIds = _xtable_CheckedCheckboxId();
	if(reqIds==null || reqIds==""){
		alert("请至少选择一条流程!");
		return;
	}
	var strMsg1 = "本功仅能处理:1、仅是预申请、或者仅是事后报销的报销流程;2、自定义表单借还款流程;";
	if(confirm(strMsg1+"确定要执行么?")){
		document.location.href = "/fna/do/DoFnaBudgetAdd.jsp?reqIds="+reqIds;
	}
}

</script>
</html>

附件: ecology.zip