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()">&nbsp;&nbsp;输出到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 + -
显示快捷键?