📄 report3_person.jsp

📁 java jsp教程
💻 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("做为报表穿透式弹出窗口report3_person");
	StringBuffer param=new StringBuffer();
	String endDate=request.getParameter("endDate");
	String orgCode=request.getParameter("orgCode");
	String type=request.getParameter("type");
	String typeValue=request.getParameter("typeValue");
	System.out.println("[check]endDate:"+endDate+"|orgCode:"+orgCode+"|type:"+type+"|typeValue:"+typeValue);
	param.append("endDate="+endDate);
	if(type==null)
		type="";
	if(!type.equals("birthday"))
	{
		if(!type.equals("all"))
		{
			String clause1=" and a."+type+"='"+typeValue+"'";
			if(!type.equals("isfulltime")){
				clause1=clause1+" and a.isfulltime='1'";
			}
			param.append(";clause=\""+clause1+"\"");
		}
	}else if(!type.equals(""))
	{
		String a="(to_number(to_char(sysdate,'yyyy'))-to_number(to_char(a.birthday,'yyyy')))";
		String clause1="";
		if(typeValue.equals("1"))
			clause1=" and "+a+"<35";
		if(typeValue.equals("2"))
			clause1=" and "+a+">=35 and "+a+"<=49 ";
		if(typeValue.equals("3"))
			clause1=" and "+a+">=50";
		param.append(";clause=\""+clause1+"\"");
	}
	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_person.raq" 
					   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 + -