📄 report3_proj.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">
<%
System.out.println("做为报表穿透式弹出窗口");
StringBuffer param=new StringBuffer();
String beginDate=request.getParameter("beginDate");
String endDate=request.getParameter("endDate");
String orgCode=request.getParameter("orgCode");
String projtype=request.getParameter("projtype");
String state=request.getParameter("state");
param.append("beginDate="+beginDate);
param.append(";year='"+beginDate.substring(0,4)+"'");
StringBuffer clause1=new StringBuffer();
clause1.append(" and 1=1 ");
if(projtype==null)
projtype="";
if(!projtype.equals("caiwu"))//项目类别
param.append(";projtype='"+projtype+"'");
//else
// clause1.append(" and substr(tplan.projecttypeid,0,7)!='xmlb002' and substr(tplan.projecttypeid,0,7)!='xmlb003' ");
if(state==null)
state="";
if(state.equals("0"))//0－年度计划数目（即计划内的计划）
{
clause1.append(" and substr(tplan.PLANTYPEID,0,7)='jhlb001' ");
}else if(state.equals("1"))//1－年度计划调增数（即计划外的计划）
{
clause1.append(" and substr(tplan.PLANTYPEID,0,7)='jhlb002' and tplan.state!='c'");
//clause1.append(" and (tproj.projectstate='6' or tproj.projectstate='7') "+
// "and tproj.enddate >= to_date('"+beginDate+"','yyyy-mm-dd') and tproj.enddate <= to_date('"+endDate+"','yyyy-mm-dd')");
}else if(state.equals("2"))//2－年度计划调减数（即消项的计划）
{
clause1.append(" and tplan.state='c' ");
//clause1.append(" and tproj.projectstate!='6' and tproj.projectstate!='7' ");
}else if(state.equals("3"))//3－调整后计划数
{
clause1.append(" and (instr(tplan.PLANTYPEID,'jhlb001')=1 or instr(tplan.PLANTYPEID,'jhlb002')=1) and tplan.state!='c'");
}else if(state.equals("4"))//4－本年累计完成
{
clause1.append(" and tproj.projectstate in('6','7') and tproj.enddate>=to_date('"+beginDate+"','yyyy-mm-dd') and tproj.enddate<=to_date('"+endDate+"','yyyy-mm-dd') ");
}else if(state.equals("5"))//5－结束的、海外的计划
{
clause1.append(" and tproj.projectstate in('6','7') and tproj.enddate>=to_date('"+beginDate+"','yyyy-mm-dd') and tproj.enddate<=to_date('"+endDate+"','yyyy-mm-dd') and tplan.isabroad='0'");
}else if(state.equals("6"))//6－在审的（执行中）
{
clause1.append(" and tplan.state='6' ");
}else if(state.equals("7"))//7－全部(包括计划内计划外）、海外的计划
{
clause1.append(" and tplan.isabroad='0'");
}
param.append(";clause=\""+clause1.toString()+"\"");
param.append(";endDate="+endDate);
if(orgCode!=null && !orgCode.equals(""))
{
param.append(";orgCode='"+orgCode+"'");
param.append(";macro_lengthorg="+orgCode.length());
}
%>
</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="report3_proj.raq"
width="900"
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 + -