?? pay_count.jsp
字號:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="incdb.jsp"%>
<%@ include file="sessionadmin.jsp"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<META HTTP-EQUIV="Pragma" CONTENT="no-cache">
<META HTTP-EQUIV="Cache-Control" CONTENT="no-cache">
<META HTTP-EQUIV="Expires" CONTENT="0">
<title>財務管理系統</title>
<SCRIPT language=javascript>
function Chk(theForm)
{
if (theForm.classid.value == "0"){
alert("請輸入你要選擇的部門!");
theForm.classid.focus();
return (false);
}else{
updated.style.display = '';
}
if (theForm.addtime_year.value == "0"){
alert("請輸入你要統計的年份!");
theForm.addtime_year.focus();
return (false);
}else{
updated.style.display = '';
}
}
</SCRIPT>
<script language="javascript">
function printsub()
{
if (confirm('請單擊“確定”按鈕開始打印，單擊“取消”按鈕不打印！'))
{
window.print();
}
}
</script>
<link rel="stylesheet" href="images/css.css" type="text/css" media="screen">
<%String action =(request.getParameter("action")==null?"":(request.getParameter("action")));
int sclassid =(request.getParameter("classid")==null?0:(Integer.parseInt(request.getParameter("classid"))));
int saddtime_year =(request.getParameter("addtime_year")==null?0:(Integer.parseInt(request.getParameter("addtime_year"))));
//String saddtime_year =(request.getParameter("addtime_year")==null?"":(request.getParameter("addtime_year")));
%>
</head>
<BODY text="#000000" topmargin=0>
<DIV id=overDiv style="Z-INDEX: 1; POSITION: absolute"></DIV>
<TABLE cellSpacing=1 cellPadding=0 width="98%" align=center border=0 class="tableBorder">
<TBODY>
<TR>
<FORM name="Form1" action="pay_count.jsp?action=search" method="post" onSubmit="return Chk(this);">
<th align=middle colSpan=6 height=22>
部門：
<SELECT name="classid">
<option value="0">--請選擇部門--</option>
<% Vector listclass = new Vector();
DispClass dispclass = new DispClass();
listclass = dispclass.allClass();
for(int i=0;i<listclass.size();i++) {
IClass classinfo = (IClass)listclass.elementAt(i);%>
<option value="<%=classinfo.getID()%>" <%if (classinfo.getID()==sclassid)
{out.println("selected");}
%>><%=classinfo.getName()%></option>
<%}%>
</select>
</SELECT>
年度：
<SELECT name="addtime_year">
<option value="0">--請選擇年份--</option>
<% Vector listpay = new Vector();
DispPay disppay = new DispPay();
listpay = disppay.allAddtime_year();
for(int i=0;i<listpay.size();i++) {
Pay payinfo = (Pay)listpay.elementAt(i);%>
<option value="<%=payinfo.getAddtime_year()%>" <%if (payinfo.getAddtime_year()==saddtime_year)
{out.println("selected");}
%>><%=payinfo.getAddtime_year()%></option>
<%}%>
</SELECT>
<input type="submit" name="Submit" value=" 點 擊 統 計 ">
年度統計表</th>
</FORM>
</TR>
<TR>
<td align=middle colSpan=6>
<DIV id="updated" style="DISPLAY: none" align="center">
<table width="100%" border="0" align="center" cellpadding="4" cellspacing="4">
<tr>
<td height="50">
<div align="center"><b>正在統計，請稍后...<b> <img height="15" alt="Laoding..." src="images/loading.gif" width="150"></b></b></div></td>
</tr>
</table>
</DIV>
<%
if (action.equals("search")){
%>
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td width="9%" height="25" class=forumrow>費用類型</td>
<td width="5%" class=forumrow><div align="center">1月</div></td>
<td width="5%" class=forumrow><div align="center">2月</div></td>
<td width="5%" class=forumrow><div align="center">3月</div></td>
<td width="5%" class=forumrow><div align="center">4月</div></td>
<td width="5%" class=forumrow><div align="center">5月</div></td>
<td width="5%" class=forumrow><div align="center">6月</div></td>
<td width="5%" class=forumrow><div align="center">7月</div></td>
<td width="5%" class=forumrow><div align="center">8月</div></td>
<td width="5%" class=forumrow><div align="center">9月</div></td>
<td width="5%" class=forumrow><div align="center">10月</div></td>
<td width="5%" class=forumrow><div align="center">11月</div></td>
<td width="5%" class=forumrow><div align="center">12月</div></td>
<td width="9%" class=forumrow><div align="center"><b>合計</b></div></td>
</tr>
<%
int totle_month;
int totle_year;
int totle_in[]=new int[13];
int totle_out[]=new int[13];
DispPaytype dispaytype = new DispPaytype();
Vector listpaytype = new Vector();
listpaytype = dispaytype.allPaytype();
for(int i=0;i<listpaytype.size();i++) {
Paytype paytypeinfo = (Paytype)listpaytype.elementAt(i);
%>
<tr bgcolor="#FFFFFF">
<td height="25"><%=paytypeinfo.getName()%>(<%if (paytypeinfo.getInout()==1)
{out.println("<font class=red>收入</font>");}
else{out.println("<font class=blue>支出</font>");}
%>)</td>
<%for (int j=1;j<13;j++)
{%>
<td>
<%
disppay.setClassid(sclassid);
disppay.setPaytypeid(paytypeinfo.getId());
disppay.setAddtime_year(saddtime_year);
disppay.setAddtime_month(j);
totle_month = disppay.totlemoney_month();
if (paytypeinfo.getInout()==1)
{out.println("<font class=red>"+totle_month+"</font>");}
else{out.println("<font class=blue>"+(0-totle_month)+"</font>");}
%>
</td>
<%}%>
<td>
<%
disppay.setClassid(sclassid);
disppay.setPaytypeid(paytypeinfo.getId());
disppay.setAddtime_year(saddtime_year);
totle_year = disppay.totlemoney_year();
if (paytypeinfo.getInout()==1)
{out.println("<font class=red>"+totle_year+"</font>");}
else{out.println("<font class=blue>"+(0-totle_year)+"</font>");}
%>
</td>
</tr>
<%}%>
<tr>
<td height="25" class=forumrow><b>支出合計</b></td>
<%for (int j=1;j<13;j++)
{%>
<td class=forumrow>
<%
disppay.setClassid(sclassid);
disppay.setInout(-1);
disppay.setAddtime_year(saddtime_year);
disppay.setAddtime_month(j);
totle_month = disppay.totleinout_month();
out.println("<font class=blue>"+(0-totle_month)+"</font>");
totle_out[j-1]=totle_month;
%>
</td>
<%}%>
<td class=forumrow>
<%
disppay.setClassid(sclassid);
disppay.setInout(-1);
disppay.setAddtime_year(saddtime_year);
totle_year = disppay.totleinout_year();
out.println("<font class=blue>"+(0-totle_year)+"</font>");
totle_out[12]=totle_year;
%>
</td>
</tr>
<tr>
<td height="25" class=forumrow><b>收入合計</b></td>
<%for (int j=1;j<13;j++)
{%>
<td class=forumrow>
<%
disppay.setClassid(sclassid);
disppay.setInout(1);
disppay.setAddtime_year(saddtime_year);
disppay.setAddtime_month(j);
totle_month = disppay.totleinout_month();
out.println("<font class=red>"+totle_month+"</font>");
totle_in[j-1]=totle_month;
%>
</td>
<%}%>
<td class=forumrow>
<%
disppay.setClassid(sclassid);
disppay.setInout(1);
disppay.setAddtime_year(saddtime_year);
totle_year = disppay.totleinout_year();
out.println("<font class=red>"+totle_year+"</font>");
totle_in[12]=totle_year;
%>
</td>
</tr>
<tr>
<td height="25" class=forumrow><b>收支平衡</b></td>
<%for (int j=1;j<13;j++){%>
<td class=forumrow><%=totle_in[j-1]-totle_out[j-1]%> </td>
<%}%>
<td class=forumrow><%=totle_in[12]-totle_out[12]%> </td>
</tr>
</table>
<%}%>
</td>
</TR>
</TBODY>
</TABLE>
<DIV id=data align=center></TABLE></TR></TABLE>
<CENTER>
<p><INPUT onclick="printsub();" type=button value='打印年度統計表' name=out_excel></SPAN></p>
</CENTER>
</BODY>
</HTML>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -