queanddealwithreport.jsp
来自「java jsp教程」· JSP 代码 · 共 195 行
JSP
195 行
<!--/jsp/plan/AddNewPlan.jsp, by lyf, 2005-09-26-->
<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="java.util.Iterator" %>
<%@ page import="java.util.List" %>
<%@ page import="com.icss.cnpc.util.Config" %>
<%@ page import="com.icss.cnpc.util.CommUtil" %>
<%@ page import="com.icss.cnpc.report.vo.ResultVO" %>
<%@ page import="com.icss.cnpc.base.vo.CodeItemInfo" %>
<%
response.setHeader("Pragma", "No-cache");
response.setHeader("Cache-Control", "no-cache");
response.setDateHeader("Expires", 0);
%>
<%
CommUtil comutil=new CommUtil();
List typeList=(List)request.getAttribute("typeList");
List resultlist=(List)request.getAttribute("resultlist");
%>
<HTML><HEAD><TITLE>查询计划</TITLE>
<link rel="stylesheet" href="<%=request.getContextPath()%>/css/style.css">
<SCRIPT language=JavaScript src="<%=request.getContextPath()%>/common/common.js"></SCRIPT>
<SCRIPT LANGUAGE="JavaScript" src="<%=request.getContextPath()%>/common/calendar.js"></SCRIPT>
<style type="text/css">
<!--
.style2 {font-size: 14px; }
-->
</style>
</HEAD>
<SCRIPT language=JavaScript>
function selectUnit()
{
wx=200;
wy=200;
urlstr="../base/base_unit_audit.html";
x=(window.screen.width-wx)/2;
y=(window.screen.height-wy)/2;
wposition=",left="+x+",top="+y;
window.open(urlstr,"选择单位","width="+wx+",height="+wy+",scrollbars=yes,status=no"+wposition);
}
function outputExcel()
{
alert('Excel输出报表')
}
</SCRIPT>
<body background=../images/grid.gif bgColor=#eef4ff>
<form name="form1">
<input type="hidden" name="option" value="search">
<TABLE cellSpacing=0 cellPadding=0 width="98%" align=center border=0>
<TR>
<TD align=middle>
<TABLE cellSpacing=1 borderColorDark=#dfdfff cellPadding=2
align=center bgColor=#3399CC borderColorLight=#003366
border=0 width="98%">
<TBODY>
<TR bgcolor="#a6d0f2">
<TD width="10%" height=30 align=middle><div align="right">时间:</div></TD>
<TD width="20%" height=30 align=middle><div align="left">
<select name="year">
<%=comutil.mkYearOptions(null)%>
</select>
年
<select name="quarter">
<option selected value="all">--------</option>
<option value="1">第一季度</option>
<option value="2">第二季度</option>
<option value="3">第三季度</option>
<option value="4">第四季度</option>
</select>
</TD>
<TD width="10%" align=middle><div align="right">填报单位:</div></TD>
<TD width="25%" align=middle><div align="left">
<input name="united" type="text" id="audit" size="25" readonly>
<img src="<%=request.getContextPath()%>/images/icon-15.gif" alt="选择被审计单位" width="22" height="22" class="bt1" style="cursor:hand;" onClick="selectUnit()">
</TD>
<TD width="14%" align=middle>
<img src="<%=request.getContextPath()%>/images/report.GIF" alt="输出到Excel文件" width="18" height="18" style="cursor:hand;" onClick="outputExcel()">
<a href="#" onClick="outputExcel()"> 输出到Excel文件</a>
</td>
</TR>
</TBODY>
</TABLE>
<div align="center"><br>
<img src="../images/find.gif" style="cursor:hand" align="absmiddle" alt="查找" onClick="submit()"><br>
</div>
</TD></TR>
<tr>
<td>
<p> </p>
<table width="100%" border="0" cellspacing="1" cellpadding="2" align="center" bordercolordark="#DFDFFF" bordercolorlight="#003366" bgcolor="#b3c4db">
<tr bgcolor="#a6d0f2">
<td height="29" colspan="9" ><div align="center" class="style4">审出违纪违规问题及处理情况分类表(财务)</div></td>
</tr>
<tr bgcolor="#EEF4FF">
<td width="55" bgcolor="#EEF4FF" rowspan="2"><div align="center">序号</div></td>
<td width="242" bgcolor="#EEF4FF"rowspan="2" align="center" valign="middle">项目</td>
<td width="132" bgcolor="#EEF4FF" rowspan="2"><div align="center">本季审出问题金额</div></td>
<td width="126" bgcolor="#EEF4FF" rowspan="2"><div align="center">本年累计审出问题金额</div></td>
<td width="130" bgcolor="#EEF4FF" rowspan="2"><div align="center">本年累计纠正处理金额</div></td>
<td colspan="4" bgcolor="#EEF4FF"><div align="center">其中</div></td>
</tr>
<tr bgcolor="#EEF4FF">
<td width="48" bgcolor="#EEF4FF"><div align="center">内部收缴</div></td>
<td width="50" bgcolor="#EEF4FF"><div align="center">内部罚款</div></td>
<td width="46" bgcolor="#EEF4FF"><div align="center">调整帐目</div></td>
<td width="76" bgcolor="#EEF4FF"><div align="center">其他</div></td>
</tr>
<%
if(typeList!=null && typeList.size()!=0 && resultlist!=null && resultlist.size()!=0)
{
int recordnum1=0;
int recordnum2=0;
int recordnum3=0;
String level1="";
String level2="";
String level3="";
Iterator i = typeList.iterator();
Iterator j = resultlist.iterator();
while(i.hasNext()){
CodeItemInfo codeinfo = (CodeItemInfo)i.next();
String codename=codeinfo.getCodename();
String codeno=codeinfo.getCodeno();
String parentcode=codeinfo.getParentno();
System.out.println("codeno="+codeno);
if(codeno.equals("wtlb001"))
codename=codename+"问题合计";
if(codeno.length()==10)
{
recordnum1++;
recordnum2=0;
recordnum3=0;
level2="";
level3="";
}
if(codeno.length()==13)
{
recordnum2++;
recordnum3=0;
level3="";
System.out.println("codename="+codename);
System.out.println("recordnum1="+recordnum1);
System.out.println("recordnum2="+recordnum2);
}
if(codeno.length()==16)
{
recordnum3++;
}
level1=""+recordnum1;
if(recordnum1==0)
level1="";
if(recordnum2!=0)
level2="."+recordnum2;
if(recordnum3!=0)
level3="."+recordnum3;
String listnum=level1+level2+level3;
%>
<!--以下为显示统计指标值-->
<%
ResultVO resultVO = (ResultVO)j.next();
Float quartercount=resultVO.getQuartercount();//本季审出问题金额
Float yearauditcount=resultVO.getYearauditcount();//本年累计审出问题金额
Float yeardealcount=resultVO.getYeardealcount();//本年累计纠正处理金额
Float takeovercount=resultVO.getTakeovercount();//内部收缴
Float forfeitcount=resultVO.getForfeitcount();//内部罚款
Float adjustcount=resultVO.getAdjustcount();//调整帐目
Float othercount=resultVO.getOthercount();//其他
//String codetype=resultVO.getCodetype();//问题类型编码
%>
<tr bgcolor="#EEF4FF">
<td width="55" height="22" bgcolor="#EEF4FF"><div align="center"><%=listnum%></div></td>
<td width="242" height="22" bgcolor="#EEF4FF"><div align="left"><%=codename%></div></td>
<td width="132" bgcolor="#EEF4FF"><%if(quartercount!=null)out.print(quartercount);%></td>
<td width="126" bgcolor="#EEF4FF"><%if(yearauditcount!=null)out.print(yearauditcount);%></td>
<td width="130" bgcolor="#EEF4FF"><%if(yeardealcount!=null)out.print(yeardealcount);%></td>
<td width="48" bgcolor="#EEF4FF"><%if(takeovercount!=null)out.print(takeovercount);%></td>
<td width="50" bgcolor="#EEF4FF"><%if(forfeitcount!=null)out.print(forfeitcount);%></td>
<td width="46" bgcolor="#EEF4FF"><%if(adjustcount!=null)out.print(adjustcount);%></td>
<td width="76" bgcolor="#EEF4FF"><%if(othercount!=null)out.print(othercount);%></td>
</tr>
<%}}%>
</table></td>
</tr>
</TABLE>
</form>
</BODY></HTML>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?