📄 report1_org.jsp
字号:
<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="java.util.*" %>
<%@ page import="com.icss.cnpc.util.*" %>
<%@ page import="com.icss.cnpc.plan.vo.*" %>
<%@ taglib uri="/WEB-INF/runqianReport.tld" prefix="report"%>
<%@ page session="true" import="java.lang.StringBuffer,com.runqian.report.usermodel.*"%>
<%@ page import="com.icss.cnpc.util.Config" %>
<%
response.setHeader("Pragma", "No-cache");
response.setHeader("Cache-Control", "no-cache");
response.setDateHeader("Expires", 0);
%>
<%
String root = request.getContextPath();
%>
<html>
<link rel="stylesheet" href="<%=root%>/css/style.css">
<SCRIPT language="JavaScript" src="<%=root%>/common/common.js"></SCRIPT>
</script>
<head>
<title>报表</title>
</head>
<BODY text=#000000 leftMargin=0 background=<%=root%>/images/grid.gif
topMargin=10 >
<form name="form1">
<%
StringBuffer param=new StringBuffer();
StringBuffer clause=new StringBuffer();
String orgCode=request.getParameter("orgCode");
String isaudit=request.getParameter("isaudit");
String orglevel=request.getParameter("orglevel");
String isstate=request.getParameter("isstate");
String type=request.getParameter("type");
String beginDate=request.getParameter("beginDate");
String endDate=request.getParameter("endDate");
String other=request.getParameter("other");
String parent=request.getParameter("parent");
String reportfile="";
if("1".equals(type))//应审单位
{
if("0".equals(orglevel))//中石油
{
if("1".equals(orgCode))//集团公司应审单位
{
clause.append(" and r.ORGLEVEL=1 and t.ISAUDIT='0' ");
}else if("2".equals(orgCode))//中油股份公司应审单位
{
clause.append(" and r.ORGLEVEL=2 and t.isstate='1' and t.ISAUDIT='0' ");
}else if("3".equals(orgCode))//非上市单位应审单位
{
clause.append(" and r.ORGLEVEL=2 and t.isstate='0' and t.ISAUDIT='0' ");
}else//总的应审单位
{
clause.append(" and ((r.ORGLEVEL=1 and t.ISAUDIT='0') or"
+" (r.ORGLEVEL=2 and t.ISAUDIT='0')) ");
}
}
else//非中石油
{
int length=orgCode.length();
if("1".equals(isaudit))
{
clause.append(" and length(t.unitcode)="+length+" "+
" and substr(t.unitcode,0,length(unitcode)-3)='"+orgCode.substring(0,length-3)+"'"+
" and t.isstate='"+isstate+"' and t.isaudit='0'");
}
else if("0".equals(isaudit))
{
clause.append(" and instr(t.unitcode,'"+orgCode+"')=1 and t.isaudit='0' and length(t.unitcode)-3="+length);
}
}
reportfile="report_auditedorg.raq";
}
else if("2".equals(type))//已审单位
{
int length=orgCode.length();
clause.append(" and a.ENDDATE>=to_date('"+beginDate+"','yyyy-mm-dd') and a.ENDDATE<=to_date('"+endDate+"','yyyy-mm-dd') ");
if(!"1".equals(other) && !"2".equals(other))
clause.append(" and substr(b.projecttypeid,0,7)!='xmlb002' and substr(b.projecttypeid,0,7)!='xmlb003' ");
if("1".equals(other))//报表一专项审计的已审单位
clause.append(" and instr(a.projecttype,'xmlb007')=1 ");
if("2".equals(other))//报表一境外审计的已审单位
clause.append(" and a.ifabroad='1' ");
if("0".equals(orglevel))//中石油
{
clause.append(" and substr(a.auditingorgno,0,"+length+")='"+orgCode.substring(0,length)+"' and (d.orglevel='dwjb001' OR d.orglevel='dwjb002')");
}
else if("1".equals(orglevel))//一级机构
{
//length=6;
if("1".equals(isaudit))//一级审计单位
clause.append(" and substr(a.auditingorgno,0,"+length+")='"+orgCode.substring(0,length)+"' and d.orglevel='dwjb001' ");
if("0".equals(isaudit))//一级被审单位
clause.append(" and substr(a.auditingorgno,0,"+length+")='"+orgCode.substring(0,length)+"' and d.orglevel='dwjb002' ");
}
else if("2".equals(orglevel))//二级机构
{
//length=9;
if("1".equals(isaudit))//二级审计单位
clause.append(" and substr(a.auditingorgno,0,"+length+")='"+orgCode.substring(0,length)+"' and d.orglevel='dwjb002' ");
if("0".equals(isaudit))//二级被审单位
clause.append(" and substr(a.auditingorgno,0,"+length+")='"+orgCode.substring(0,length)+"' and d.orglevel='dwjb003' ");
}
if("3".equals(isstate))//三级机构
{
//length=12;
clause.append(" and substr(a.auditingorgno,0,"+length+")='"+orgCode.substring(0,length)+"' ");
}
reportfile="report_auditedorg1.raq";
param.append("length="+length+";");
}
else if("3".equals(type))//报表4得应审单位
{
//在这里传过来的参数意义有所变化，如下：
//orgCode---机构编码orgCode
//isaudit---是否审计(cisaudit)
//orglevel---级别clevel
//isstate---是否机构cisorg
//beginDate---是否机构sisorg
//endDate---是否审计sisaudit
String cisorg=isstate;//E4
String cisaudit=isaudit;//D4
String clevel=orglevel;//F4
String sisorg=beginDate;//@isjigou
String sisaudit=endDate;//@isshenji
String cisstate=other;//C4
int length=orgCode.length();
if("1".equals(cisorg) && "1".equals(cisaudit))
clause.append(" and 1=1 and length(t.unitcode)="+length+" and substr(t.unitcode,0,"+(length-3)+")='"+orgCode.substring(0,length-3)+"' and t.isaudit='0' and t.isstate='"+cisstate+"'");
//E4='H' and D4='1',
//ds_org.sum( counted,len(B4)=len(unitcode) and left(unitcode,len(unitcode)-3)=left(B4,len(B4)-3) and isaudit='0' and isstate=C4),
else if("1".equals(cisorg) && "0".equals(cisaudit))
clause.append(" and 2=2 and length(t.unitcode)="+(length+3)+" and substr(t.unitcode,0,length(t.unitcode)-3)='"+orgCode+"' and t.isaudit='0' and t.isstate='"+cisstate+"'");
//E4='H' and D4='0',
//ds_org.sum( counted,len(unitcode)=len(B4)+3 and left(unitcode,len(unitcode)-3)=B4 and isaudit='0' and isstate=C4 ),
else if("2".equals(clevel) && "1".equals(cisaudit))
clause.append(" and 3=3 and length(t.unitcode)="+parent.length()+" and substr(t.unitcode,0,length(t.unitcode)-3)='"+parent.substring(0,parent.length()-3)+"' and t.isaudit='0' and t.isstate='"+cisstate+"'");
//D4='1' and F4=2,
//ds_org.sum( counted,len(@orgCode)=len(unitcode) and left(unitcode,len(unitcode)-3)=left(@orgCode,len(@orgCode)-3) and isaudit='0' and isstate=C4 ),
else if("3".equals(clevel) && "1".equals(cisaudit) && "0".equals(sisorg))
clause.append(" and 4=4 and t.orglevel='dwjb001' and t.isaudit='0' and t.isstate='"+cisstate+"'");
//D4='1' and F4=3 and @isjigou='0',
//ds_org.sum( counted,orglevelnum=1 and isaudit='0' and isstate=C4 ),
else if("3".equals(clevel) && "1".equals(cisaudit) && "1".equals(sisorg) && "1".equals(sisaudit))
clause.append(" and 5=5 and t.orglevel='dwjb002' and substr(t.unitcode,0,length(t.unitcode)-3)='"+parent.substring(0,parent.length()-3)+"' and t.isaudit='0'");
//D4='1' and F4=3 and @isjigou='1' and isshenji='1',
//ds_org.sum( counted,orglevelnum=2 and left(unitcode,len(unitcode)-3)=left(@orgCode,len(@orgCode)-3) and t.isaudit='0' ),
else if("3".equals(clevel) && "1".equals(cisaudit) && "1".equals(sisorg) && "0".equals(sisaudit))
//clause.append(" and 6=6 and t.orglevel='dwjb003' and substr(t.unitcode,0,length(t.unitcode))='"+parent+"' and t.isaudit='0' ");
clause.append(" and 6=6 and t.orglevel='dwjb003' and instr(t.unitcode,'"+parent+"')=1 and t.isaudit='0' ");
//D4='1' and F4=3 and @isjigou='1' and isshenji='0',
//ds_org.sum( counted,orglevelnum=3 and left(unitcode,len(unitcode)-3)=@orgCode and isaudit='0' ) )
reportfile="report_auditedorg.raq";
}else if("4".equals(type))//报表4已审单位
{
int length=orgCode.length();
clause.append(" and a.ENDDATE>=to_date('"+beginDate+"','yyyy-mm-dd') and a.ENDDATE<=to_date('"+endDate+"','yyyy-mm-dd') ");
if(!"1".equals(other) && !"2".equals(other))
clause.append(" and substr(b.projecttypeid,0,7)!='xmlb002' and substr(b.projecttypeid,0,7)!='xmlb003' ");
if("1".equals(orglevel))//一级机构
{
//length=6;
if("1".equals(isaudit))//一级审计单位
clause.append(" and substr(a.auditingorgno,0,"+length+")='"+orgCode.substring(0,length)+"' and d.orglevel='dwjb001' ");
if("0".equals(isaudit))//一级被审单位
clause.append(" and substr(a.auditingorgno,0,"+length+")='"+orgCode.substring(0,length)+"' and d.orglevel='dwjb002' ");
}
else if("2".equals(orglevel))//二级机构
{
//length=9;
if("1".equals(isaudit))//二级审计单位
{
if("0".equals(isstate))//在这里isstate为是否机构,二级非机构审计单位（如集团审计部一处）
clause.append(" and substr(a.auditingorgno,0,"+length+")='"+orgCode.substring(0,length)+"' and d.orglevel='dwjb001' ");
else
clause.append(" and substr(a.auditingorgno,0,"+length+")='"+orgCode.substring(0,length)+"' and d.orglevel='dwjb002' ");
}
if("0".equals(isaudit))//二级被审单位
clause.append(" and substr(a.auditingorgno,0,"+length+")='"+orgCode.substring(0,length)+"' and d.orglevel='dwjb003' ");
}
else if("3".equals(orglevel))//三级机构
{
//length=12;
clause.append(" and substr(a.auditingorgno,0,"+length+")='"+orgCode.substring(0,length)+"' ");
}
reportfile="report_auditedorg1.raq";
param.append("length="+length+";");
}
param.append("clause=\""+clause.toString()+"\";");
param.append("beginDate='"+beginDate+"';");
param.append("endDate='"+endDate+"';");
param.append("orgCodeUnit='"+orgCode+"';");
param.append("orgCode='"+orgCode+"';");
System.out.println("clause-->"+clause);
System.out.println("reportfile-->"+reportfile);
%>
</form>
<TABLE cellSpacing=0 cellPadding=0 width="100%" align=center border=0>
<TBODY>
<br>
<TR>
<TD align=middle width="100%" >
<report:html name="report1" reportFileName="<%=reportfile%>"
width="810"
height="600"
funcBarLocation="bottom"
needPageMark="yes"
separator=" "
needSaveAsExcel="yes"
needSaveAsPdf="no"
needPrint="no"
firstPageLabel="第一页"
prevPageLabel="上一页"
nextPageLabel="下一页"
lastPageLabel="最后页"
pageMarkLabel="第{currpage}页/共{totalPage}页"
printLabel="打印"
generateParamForm="no"
displayNoLinkPageMark="yes"
canModifyBeforePrint="yes"
params="<%=param.toString()%>"
submit="提交到服务器"
needOfflineInput="yes"
needImportExcel="yes"
excelPageStyle="0"
importExcelLabel="导入excel"
/>
</TD>
</TR>
<tr><td>
</td></tr>
<tr><td align="center">
<img src="<%=root%>/images/close.gif" style="cursor:hand;" align="absmiddle" alt="返回" onClick="window.close()">
</td></tr>
</TBODY>
</TABLE>
<br>
</body>
</html>
<%@ include file="func.jsp"%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -