📄 paymentsum.jsp
字号:
<jsp:useBean id="invoice" class="src.wuyang.Invoice" scope="session"/>
<jsp:setProperty name="invoice" property="*" />
<jsp:useBean id="global" class="src.com.MyGlobal" scope="session"/>
<% if (global.isLogined == false) {
%>
<jsp:forward page="../pub/DBErr.jsp" >
<jsp:param name="rtcode" value="-4" />
</jsp:forward>
<% }
%>
<%! int recordNum; %>
<%
String str1[] = {"","-"};
String str2[] = {"应付","应收"};
invoice.whereClause = invoice.getWhereClause(request);
recordNum = invoice.query(invoice.whereClause,"deptId, employeeId, customerId, invoiceFlag");
if(recordNum == -1){
%>
<jsp:forward page="../pub/Err.jsp?ErrNo=3" />
<%
}else if(recordNum == 0){
%>
<jsp:forward page="../pub/Err.jsp?ErrNo=4" />
<%
}
%>
<html>
<head>
<title>应收/应付款汇总</title>
<link rel="stylesheet" href="css.css" type="text/css">
</head>
<body bgcolor=#949b93>
<table width="100%" border="1" height="90%" bordercolorlight="#616860" bordercolordark="#CCCCCC" bgcolor="#4c7171" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" class="textb">
<br>
<div align="center"><b><font color="#000000">应收/应付款汇总</font></b></div>
<table width="100%" border="1" class="textb" bordercolorlight="#000000" bordercolordark="#CCCCCC" cellpadding="0" cellspacing="0">
<tr bgcolor="#949b93">
<td >
<div align="center"><font color="#000000"><b>部门名称</b></font></div>
</td>
<td >
<div align="center"><font color="#000000"><b>相关人员</b></font></div>
</td>
<td >
<div align="center"><font color="#000000"><b>客户名称</b></font></div>
</td>
<td >
<div align="center"><font color="#000000"><b>发票金额</b></font></div>
</td>
<td >
<div align="center"><font color="#000000"><b>已付金额</b></font></div>
</td>
<td >
<div align="center"><font color="#000000"><b>应收/应付款</b></font></div>
</td>
<td >
<div align="center"><font color="#000000"><b>类型</b></font></div>
</td>
</tr>
<%
invoice.next();
int flag = invoice.getInvoiceFlag();
String customerId = invoice.getCustomerId();
float unPay = 0;
float invoiceMoney = 0;
float payMoney = 0;
float totalUnPay = 0;
%>
<tr>
<td ><%=invoice.getDeptName()%> </td>
<td ><%=invoice.getEmpName()%> </td>
<td ><%=invoice.getCustomerName()%> </td>
<%
for(int listCount = 0; listCount < recordNum ; listCount++) {
if (invoice.getInvoiceFlag() == 0) {
totalUnPay = totalUnPay + invoice.getUnPay();
} else {
totalUnPay = totalUnPay - invoice.getUnPay();
}
if ((invoice.getInvoiceFlag() == flag) && (customerId.equals(invoice.getCustomerId()))) {
unPay = unPay + invoice.getUnPay();
invoiceMoney = invoiceMoney + invoice.getInvoiceMoney();
payMoney = payMoney + invoice.getPayMoney();
} else {
%>
<td align="right" ><%=invoice.doubleFormat(invoiceMoney,2)%> </td>
<td align="right" ><%=invoice.doubleFormat(payMoney,2)%> </td>
<td align="right" ><%=str1[flag]%><%=invoice.doubleFormat(unPay,2)%> </td>
<td ><%=str2[flag]%></td>
</tr>
<tr>
<td ><%=invoice.getDeptName()%> </td>
<td ><%=invoice.getEmpName()%> </td>
<td ><%=invoice.getCustomerName()%> </td>
<% flag = invoice.getInvoiceFlag();
unPay = invoice.getUnPay();
invoiceMoney = invoice.getInvoiceMoney();
payMoney = invoice.getPayMoney();
customerId = invoice.getCustomerId();
}
invoice.next();
}
%>
<td align="right" ><%=invoice.doubleFormat(invoiceMoney,2)%> </td>
<td align="right" ><%=invoice.doubleFormat(payMoney,2)%> </td>
<td align="right" ><%=str1[flag]%><%=invoice.doubleFormat(unPay,2)%> </td>
<td ><%=str2[flag]%></td>
</tr>
</table>
<b>应收/应付款总计：<%=invoice.doubleFormat(totalUnPay,2)%>元 </b>
<p class="textb">
</td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -