📄 finapprovalstat.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="cn.com.aheadsoft.recordset.FinanceExpenseAccountRecordSet" %>
<%@ page import="cn.com.aheadsoft.util.StringFormat" %>
<%@ page import="java.util.Date" %>
<%@ page import="java.util.Date" %>
<%@ page import="java.text.SimpleDateFormat" %>
<%@ page import="java.util.Calendar" %>
<jsp:useBean id="userinfo" scope="session" class="cn.com.aheadsoft.util.UserInfo"/>
<jsp:useBean id="upm" scope="session" class="cn.com.aheadsoft.manage.UserPurviewManage"/>
<html>
<head>
<link rel="stylesheet" type="text/css" href="/krm/jsp/css/css.css">
<title>财务单据统计信息</title>
<%
String approvalStatType=request.getParameter("statType");
String statDateBegin = (String)request.getAttribute("statDateBegin");
String statDateEnd = (String)request.getAttribute("statDateEnd");
%>
<script src="/krm/jsp/jscript/Calendar.js"></script>
<script>
<!--
function atSubmit(obj){
isOK=false;
lab="";
for(i=0;i<obj.length;i++){
if(obj.elements[i].value!=null && obj.elements[i].value!=""){
isOK=true;
}else{
isOK=false;
lab=obj.elements[i].alt;
obj.elements[i].focus();
break;
}
}
if(!isOK){
alert("请选择"+lab+"！");
return false;
}else{
//obj.submit();
}
}
-->
</script>
</head>
<%
String nowDate = new SimpleDateFormat("yyyy-MM-dd").format(new Date());
%>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" >
<table width="100%" align="center" border="0" cellpadding="0" cellspacing="0" >
<tr height="8">
<td class="trA"> 您的位置：财务管理 >> 财务审批 >> <font class="fontcolor">单据统计</font></td>
</tr>
<tr height="8">
<td></td>
</tr>
<tr>
<td align="center" >
<table border="0" cellpadding="0" cellspacing="0" width="98%" align="center" >
<tr >
<td class="tdA" colspan="9">统计条件</td>
</tr>
<form action="/krm/servlet/finapprovalstatservlet" method="post" name="appStat" onsubmit="return atSubmit(this)">
<tr>
<td width="100" align="center" class="common bgcolor" >统计类型</td>
<td class="common"><select name="statType" alt="统计类型" >
<option value="item" >按任务统计</option>
<option value="dept" >按部门统计</option>
<option value="expenser" selected>按报销人统计</option>
</select> </td>
</tr>
<tr>
<td width="100" align="center" class="common bgcolor" >报销时间</td>
<% Calendar calendar= Calendar.getInstance();
int nowYear=calendar.get(Calendar.YEAR); %>
<td class="common">
<input type="text" readonly="true" class="middle" name="A_Date" alt="报销时间" style="width:80" <%if(statDateBegin!=null){%> value="<%=statDateBegin%>"<%}%>>
<a href="javascript:show_calendar('appStat.A_Date');"><image src="/krm/jsp/image/selectdate.gif" border="0"></a>
至
<input type="text" readonly="true" class="middle" name="A_Date_end" alt="报销时间" style="width:80" <%if(statDateEnd!=null){%> value="<%=statDateEnd%>"<%}else {%>value="<%=nowDate%>"<%}%> >
<a href="javascript:show_calendar('appStat.A_Date_end');" id="DateSelect"><image src="/krm/jsp/image/selectdate.gif" border="0"></a>
</td>
</tr>
<input type="Hidden" name="status" value="q">
<tr><td class="tdC" align="center" colspan="2">
<INPUT name="Button1" type="submit" onmouseover="this.className='button2'" onmouseout="this.className='button1'" class="button1" value="提 交">
</td>
</tr>
</form>
</table>
<br>
<table border="0" cellpadding="0" cellspacing="0" width="98%" align="center" class="collapse">
<tr >
<% if(approvalStatType.equals("item")){
%>
<td class="tdA" colspan="9"><%=statDateBegin%>至<%=statDateEnd%>按任务统计列表</td>
<% }%>
<% if(approvalStatType.equals("dept")){
%>
<td class="tdA" colspan="9"><%=statDateBegin%>至<%=statDateEnd%>按部门统计列表</td>
<% }%>
<% if(approvalStatType.equals("expenser")){
%>
<td class="tdA" colspan="9"><%=statDateBegin%>至<%=statDateEnd%>按报销人统计列表</font></td>
<% }%>
<% if(approvalStatType.equals("all")){
%>
<td class="tdA" colspan="9">按报销人全部报销单统计列表</td>
<% }%>
</tr>
<%
if(approvalStatType.equals("item")){
%>
<tr>
<td width="10%" class="tdB" align="center" nowrap>序号</td>
<!--李光文2004-03-04-->
<td width="30%" class="tdB" align="center">任务名称</td>
<td width="20%" class="tdB" align="center">单据总数</td>
<td width="20%" class="tdB" align="center">总金额</td>
<td width="20%" class="tdB" align="center">详细信息</td>
</tr>
<% } %>
<%
if(approvalStatType.equals("dept")){
%>
<tr>
<td width="10%" class="tdB" align="center" nowrap>序号</td>
<!--李光文2004-03-04-->
<td width="30%" class="tdB" align="center">部门名称</td>
<td width="20%" class="tdB" align="center">单据总数</td>
<td width="20%" class="tdB" align="center">总金额</td>
<td width="20%" class="tdB" align="center">详细信息</td>
</tr>
<% } %>
<%
if(approvalStatType.equals("expenser")){
%>
<tr>
<td width="10%" class="tdB" align="center" nowrap>序号</td>
<!--李光文2004-03-04-->
<td width="30%" class="tdB" align="center">报销人名称</td>
<td width="20%" class="tdB" align="center">单据总数</td>
<td width="20%" class="tdB" align="center">总金额</td>
<td width="20%" class="tdB" align="center">详细信息</td>
</tr>
<% } %>
<%
if(approvalStatType.equals("all")){
%>
<tr>
<td width="10%" class="tdB" align="center" nowrap>序号</td>
<!--李光文2004-03-04-->
<td width="30%" class="tdB" align="center">报销人名称</td>
<td width="20%" class="tdB" align="center">任务名称</td>
<td width="20%" class="tdB" align="center">单据总数</td>
<td width="20%" class="tdB" align="center">总金额</td>
</tr>
<% } %>
<%
FinanceExpenseAccountRecordSet finExpAccRecordset = (FinanceExpenseAccountRecordSet)request.getAttribute("AppStat");
if(finExpAccRecordset != null && finExpAccRecordset.size() > 0) {
int num = 1;
while(finExpAccRecordset.next()) {
%>
<% if(approvalStatType.equals("item")){ %>
<tr <%
if(num%2==0){
%> class="bgcolor"<%}%>>
<td width="10%" align="center" class="common"><%=num%></td> <!--李光文2004-03-04-->
<td width="30%" class="common" align="center"><%= StringFormat.Source2GB(finExpAccRecordset.getEI_ItemName()) %></td>
<td width="20%" class="common" align="center"><%= StringFormat.Source2GB(finExpAccRecordset.getBillSum()) %></td>
<td width="20%" class="common" align="center"><%= StringFormat.Source2GB(finExpAccRecordset.getMoneySum()) %></td>
<td width="20%" class="common" align="center"> <a href="/krm/servlet/financestatinfoservlet?&status=q&statType=item&BillSum=<%= StringFormat.Source2GB(finExpAccRecordset.getBillSum()) %>&MoneySum=<%= StringFormat.Source2GB(finExpAccRecordset.getMoneySum()) %>&itemid=<%= StringFormat.Source2GB(finExpAccRecordset.getEI_ItemID()) %>&statDateBegin=<%=statDateBegin%>&statDateEnd=<%=statDateEnd%>">详细信息</a>
</td>
</tr>
<% } %>
<% if(approvalStatType.equals("dept")){ %>
<tr <%
if(num%2==0){
%> class="bgcolor"<%}%>>
<td width="10%" align="center" class="common"><%=num%></td><!--李光文2004-03-04-->
<td width="30%" class="common" align="center"><%= StringFormat.Source2GB(finExpAccRecordset.getEI_DeptName()) %></td>
<td width="20%" class="common" align="center"><%= StringFormat.Source2GB(finExpAccRecordset.getBillSum()) %></td>
<td width="20%" class="common" align="center"><%= StringFormat.Source2GB(finExpAccRecordset.getMoneySum()) %></td>
<td width="20%" class="common" align="center"> <a href="/krm/servlet/financestatinfoservlet?&status=q&statType=dept&BillSum=<%= StringFormat.Source2GB(finExpAccRecordset.getBillSum()) %>&MoneySum=<%= StringFormat.Source2GB(finExpAccRecordset.getMoneySum()) %>&deptid=<%= StringFormat.Source2GB(finExpAccRecordset.getEI_DeptID()) %>&statDateBegin=<%=statDateBegin%>&statDateEnd=<%=statDateEnd%>">详细信息</a>
</td>
</tr>
<% } %>
<% if(approvalStatType.equals("expenser")){ %>
<tr <%
if(num%2==0){
%> class="bgcolor"<%}%>>
<td width="10%" align="center" class="common"><%=num%></td><!--李光文2004-03-04-->
<td width="30%" class="common" align="center"><%= StringFormat.Source2GB(finExpAccRecordset.getEI_UserName()) %></td>
<td width="20%" class="common" align="center"><%= StringFormat.Source2GB(finExpAccRecordset.getBillSum()) %></td>
<td width="20%" class="common" align="center"><%= StringFormat.Source2GB(finExpAccRecordset.getMoneySum()) %></td>
<td width="20%" class="common" align="center"> <a href="/krm/servlet/financestatinfoservlet?&status=q&statType=expenser&BillSum=<%= StringFormat.Source2GB(finExpAccRecordset.getBillSum()) %>&MoneySum=<%= StringFormat.Source2GB(finExpAccRecordset.getMoneySum()) %>&userid=<%= StringFormat.Source2GB(finExpAccRecordset.getEI_UserID()) %>&statDateBegin=<%=statDateBegin%>&statDateEnd=<%=statDateEnd%>">详细信息</a>
</td>
</tr>
<% } %>
<% if(approvalStatType.equals("all")){ %>
<tr <%
if(num%2==0){
%> class="bgcolor"<%}%>>
<td width="10%" align="center" class="common" nowrap><%=num%></td><!--李光文2004-03-04-->
<td width="30%" class="common" align="center"><%= StringFormat.Source2GB(finExpAccRecordset.getEI_UserName()) %></td>
<td width="20%" class="common" align="center"><%= StringFormat.Source2GB(finExpAccRecordset.getEI_ItemName()) %></td>
<td width="20%" class="common" align="center"><%= StringFormat.Source2GB(finExpAccRecordset.getBillSum()) %></td>
<td width="20%" class="common" align="center"><%= StringFormat.Source2GB(finExpAccRecordset.getMoneySum()) %></td>
</tr>
<% } %>
<%
num++;
}
}
%>
<tr><td colspan="5" class="tdC"> </td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -