FnaInvoiceList.jsp 9.22 KB

Raw Blame History Permalink

<%@page import="org.apache.commons.lang.StringEscapeUtils"%>
<%@page import="weaver.fna.general.FnaCommon"%>
<%@ page import="weaver.general.Util,java.text.SimpleDateFormat" %>
<%@ page import="weaver.workflow.request.RequestBrowser" %>
<%@ page import="weaver.workflow.workflow.WorkflowVersion" %>

<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ taglib uri="/browserTag" prefix="brow"%>
<%@ taglib uri="/WEB-INF/weaver.tld" prefix="wea"%>
<%@ include file="/systeminfo/init_wev8.jsp" %>
<jsp:useBean id="RecordSet" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<HTML>
<HEAD>
	<LINK REL=stylesheet type=text/css HREF=/css/Weaver_wev8.css>
	<style type="text/css">
		.LayoutTable .fieldName {
			padding-left:20px!important;
		}
	</style>
</HEAD>
<%
String nameQuery = Util.null2String(request.getParameter("nameQuery")).trim();
String advQry_kprq1 = Util.null2String(request.getParameter("createdatestart")).trim();
String advQry_kprq2 = Util.null2String(request.getParameter("createdateend")).trim();

String invoiceNumber = Util.null2String(request.getParameter("invoiceNumber"));
String seller = Util.null2String(request.getParameter("seller"));
int userid = user.getUID();
%>
<BODY style='overflow-x:hidden'>
<jsp:include page="/systeminfo/commonTabHead.jsp">
   <jsp:param name="mouldID" value="workflow"/>
   <jsp:param name="navName" value="<%=SystemEnv.getHtmlLabelName(132211,user.getLanguage())%>"/>
</jsp:include>
<table id="topTitle" cellpadding="0" cellspacing="0">
	<tr>
		<td></td>
		<td class="rightSearchSpan" style="text-align:right;">
			<input type="button" value="<%=SystemEnv.getHtmlLabelName(197,user.getLanguage())%>" class="e8_btn_top"  onclick="dosubmit()"/>
			<span title="<%=SystemEnv.getHtmlLabelName(23036,user.getLanguage())%>" class="cornerMenu"></span>
		</td>
	</tr>
</table>
<%@ include file="/systeminfo/RightClickMenuConent_wev8.jsp" %>
<%
	RCMenu += "{"+SystemEnv.getHtmlLabelName(197,user.getLanguage())+",javascript:dosubmit(),_self} " ;
	RCMenuHeight += RCMenuHeightStep;
	RCMenu += "{"+SystemEnv.getHtmlLabelName(199,user.getLanguage())+",javascript:onResetwf(),_self} " ;
	RCMenuHeight += RCMenuHeightStep;
	RCMenu += "{"+SystemEnv.getHtmlLabelName(201,user.getLanguage())+",javascript:btncancel_onclick(),_self} " ;
	RCMenuHeight += RCMenuHeightStep;
	RCMenu += "{"+SystemEnv.getHtmlLabelName(311,user.getLanguage())+",javascript:submitClear(),_self} " ;
	RCMenuHeight += RCMenuHeightStep;
%>
<%@ include file="/systeminfo/RightClickMenu_wev8.jsp" %>
<div class="zDialog_div_content">
<FORM NAME=SearchForm STYLE="margin-bottom:0" action="FnaInvoiceList.jsp" method=post>
<input type="hidden" name="issearch" id="issearch"  >
	<wea:layout type="4col">
		<wea:group context='<%=SystemEnv.getHtmlLabelName(32905, user.getLanguage()) %>'>
			<wea:item><%=SystemEnv.getHtmlLabelName(17213,user.getLanguage())%></wea:item><!-- 开票日期 -->
			<wea:item>
				<button type="button" class=Calendar id=selectbirthday
							onclick="getTheDate(createdatestart,createdatestartspan)"></BUTTON>
						<SPAN id=createdatestartspan><%=advQry_kprq1%></SPAN>
			  			- &nbsp;<button type="button" class=Calendar id=selectbirthday1
							onclick="getTheDate(createdateend,createdateendspan)"></BUTTON>
						<SPAN id=createdateendspan><%=advQry_kprq2%></SPAN>
						<input type="hidden" id=createdatestart name="createdatestart"
							value="<%=advQry_kprq1%>">
						<input type="hidden" id="createdateend" name="createdateend"
							value="<%=advQry_kprq2%>">
			</wea:item>
			<wea:item><%=SystemEnv.getHtmlLabelName(900,user.getLanguage())%></wea:item><!-- 发票号码 -->
			<wea:item>
				<input class=InputStyle type="text" name="invoiceNumber"  value='<%=invoiceNumber%>'>
			</wea:item>
			<wea:item><%=SystemEnv.getHtmlLabelName(131490,user.getLanguage())%></wea:item><!-- 销售方 -->
			<wea:item>
				<input class=InputStyle type="text" name="seller"  value='<%=seller%>'>
			</wea:item>
	    </wea:group>
	    <wea:group context="" attributes="{'groupDisplay':'none'}">
	    	<wea:item attributes="{'colspan':'full','isTableList':'true'}">
	    		<%
		    		//设置好搜索条件
		    		String backFields =" a.* ";
		    		String fromSql = " from FnaInvoiceLedger a ";
		    		//验票为真的发票才能选择的到
		    		StringBuffer sqlWhere = new StringBuffer(" where 1=1 and Authenticity = 1 ");
		    		if(!"".equals(advQry_kprq2)){
		    			sqlWhere.append(" and a.billingDate <= '").append(StringEscapeUtils.escapeSql(advQry_kprq2)).append("' ");
		    		}
		    		if(!"".equals(advQry_kprq1)){
		    			sqlWhere.append(" and a.billingDate >= '").append(StringEscapeUtils.escapeSql(advQry_kprq1)).append("' ");
		    		}

		    		if(!"".equals(invoiceNumber)){
		    			sqlWhere.append(" and a.invoiceNumber like '%").append(StringEscapeUtils.escapeSql(invoiceNumber.trim())).append("%'");
		    		}

		    		if(!"".equals(seller)){
		    			sqlWhere.append(" and a.seller like '%").append(StringEscapeUtils.escapeSql(seller.trim())).append("%'");
		    		}

		    		sqlWhere.append(" and a.userid_new = ").append(userid);
		    		sqlWhere.append(" and a.status = '0' ");
		    		String orderBy=" a.billingDate ";
// 		    		out.println("select "+backFields+" "+fromSql+" "+sqlWhere+" order by "+orderBy);
		    		String tableString=""+
		    				"<table instanceid=\"FNA_FnaUfJybInner_GRIDVIEW_INNER_LIST\" "+
		    					" pagesize=\"10\" tabletype=\"none\">"+
		    					" <checkboxpopedom  id=\"checkbox\" />"+
		    					"<sql backfields=\""+Util.toHtmlForSplitPage(backFields)+"\" sqlform=\""+Util.toHtmlForSplitPage(fromSql)+"\" "+
		    					" sqlwhere=\""+Util.toHtmlForSplitPage(sqlWhere.toString())+"\" sqlorderby=\""+Util.toHtmlForSplitPage(orderBy)+"\" "+
		    					" sqlprimarykey=\"id\" sqlsortway=\"Asc\" />"+
		    					"<head>"+
		    						"<col width=\"0%\" hide=\"true\" transmethod=\"weaver.general.KnowledgeTransMethod.forHtml\" text=\"\" column=\"id\" />"+//ID
		    						"<col width=\"15%\" text=\""+SystemEnv.getHtmlLabelName(900,user.getLanguage())+"\" column=\"invoiceNumber\" orderkey=\"invoiceNumber\" />"+//发票号码
		    						"<col width=\"15%\" text=\""+SystemEnv.getHtmlLabelName(17213,user.getLanguage())+"\" column=\"billingDate\" orderkey=\"billingDate\" />"+//开票日期
		    						"<col width=\"25%\" text=\""+SystemEnv.getHtmlLabelName(131490,user.getLanguage())+"\" column=\"seller\" />"+//销售方
		    						"<col width=\"30%\" text=\""+SystemEnv.getHtmlLabelName(131491,user.getLanguage())+"\" column=\"purchaser\" />"+//购买方
		    						"<col width=\"15%\" text=\""+SystemEnv.getHtmlLabelName(131496,user.getLanguage())+"\" column=\"taxIncludedPrice\" orderkey=\"taxIncludedPrice\" />"+//价税合计
		    					"</head>"+
		    				"</table>";
	    		%>
	    		<wea:SplitPageTag  tableString='<%=tableString%>' isShowTopInfo="false"  mode="run"/>
	    	</wea:item>
		</wea:group>
	</wea:layout>
</FORM>
</div>
<div id="zDialog_div_bottom" class="zDialog_div_bottom">
	<wea:layout needImportDefaultJsAndCss="false">
		<wea:group context="" attributes='{\"groupDisplay\":\"none\"}'>
			<wea:item type="toolbar">
				<input type="button" value="<%=SystemEnv.getHtmlLabelName(311, user.getLanguage())%>"
					 accessKey="2" id="btnclear" class="zd_btn_submit" onclick="submitClear()" />

					  <input type="button" class=zd_btn_submit  id=btncancel onclick="btncancel_onclick();" value="<%=SystemEnv.getHtmlLabelName(201,user.getLanguage())%>">
			</wea:item>
		</wea:group>
	</wea:layout>
	<script type="text/javascript">
		jQuery(document).ready(function(){
			resizeDialog(document);
		});
	</script>
</div>
<script type="text/javascript">
var dialog = null;
try{
	parentWin = parent.parent.getParentWindow(parent);
	dialog = parent.parent.getDialog(parent);
}catch(e){}

function afterDoWhenLoaded(){
	jQuery(".ListStyle").children("tbody").find("tr[class!='Spacing']").bind("click",function(){
	    var name = $(this).find("td:eq(2)").html().trim();
	    if(name.indexOf("<font>")!=-1){
	        name = name.substring(0,name.indexOf("<font>"));
	    }
		var returnjson = {id:$(this).find("td:eq(1)").text().trim(),name:name};
		if(dialog){
		    try{
		        dialog.callback(returnjson);
		    }catch(e){}
			try{
		        dialog.close(returnjson);
			}catch(e){}
		}else{
		    window.parent.returnValue  = returnjson;
		    window.parent.close();
		}
	});
};

function submitClear(){
	var returnjson = {id:"",name:""};
	if(dialog){
	    try{
	        dialog.callback(returnjson);
	    }catch(e){}
		try{
	        dialog.close(returnjson);
		}catch(e){}
	}else{
	   	window.parent.returnValue = returnjson;
		window.parent.close();
	 }
}
function dosubmit(){
	document.getElementById("issearch").value="issearch";
	jQuery('select:disabled').attr('disabled', false);
	document.SearchForm.submit();
}
function onResetwf(){
	document.SearchForm.reset();
	jQuery("#createdatestartspan").html("");
	jQuery("#createdatestart").val("");
	jQuery("#createdateendspan").html("");
	jQuery("#createdateend").val("");
}
function btncancel_onclick(){
	if(dialog){
		dialog.close();
	}else{
		window.parent.close();
	}
}
</script>
<SCRIPT language="javascript" src="/js/datetime_wev8.js"></script>
<SCRIPT language="javascript" src="/js/JSDateTime/WdatePicker_wev8.js"></script>
</BODY>
</HTML>