account_stat.jsp

电信的网厅的整站代码

<%@ page contentType="text/html; charset=gb2312" errorPage=""%>
<%@ page import="com.doone.fj1w.fjmgr.monitor.*"%>
<%@ page import="com.doone.fj1w.fjmgr.order.DisplayPage"%>
<%@ page import="com.doone.uurm.WebAuth"%>
<%@ page import="com.doone.data.DataTable"%>
<%@page import="java.util.*"%>
<%@page import="com.doone.data.*"%>


<%request.setCharacterEncoding("gb2312");%>
<%String sPurvICode="NGB006003";%>
<%
    WebAuth auth = WebAuth.getInstance(request);
 
    if ( ! auth.IsAuthed() ) {
	    out.write("<script language=\"javascript\">self.parent.location.replace(\"" + request.getContextPath() + "/view/login/login.jsp" + "\");</script>");
	    return;
    }
	else if ( ! auth.CheckPurv(sPurvICode) ) {
	    out.write("<script language=javascript src=\"../../common/script/RightForbidden.js\"></script>");
	    return;
	}   
	    DataTable dataTable=null;
	    String area="";
	    String lx="";
	    String month="";
	    String year="";
	    String city="";
        Account_Stat AccS=new Account_Stat();
        String quarter=request.getParameter("quarter");
        String xun=request.getParameter("xun");
        String week=request.getParameter("week");
        String rq=request.getParameter("rq");
        String time_style=request.getParameter("time_style");
        String relationproduct=request.getParameter("relationproduct");
        if(time_style==null||time_style.equals("")||time_style.equals("null")){time_style="";}
        if(quarter==null||quarter.equals("")||quarter.equals("null")){quarter="";}
        if(xun==null||xun.equals("")||xun.equals("null")){xun="";}
        if(week==null||week.equals("")||week.equals("null")){week="";}
        if(rq==null||rq.equals("")||rq.equals("null")){rq="";} 
        if(relationproduct==null||relationproduct.equals("")||relationproduct.equals("null")){relationproduct="";}
	    String start=request.getParameter("StartTIME");
        String end=request.getParameter("EndTIME");
       if(request.getParameter("year1")!=null&&!request.getParameter("year1").equals("null")&&!request.getParameter("year1").equals("")){year=request.getParameter("year1");}
       else if(request.getParameter("year2")!=null&&!request.getParameter("year2").equals("null")&&!request.getParameter("year2").equals("")){year=request.getParameter("year2");}
       else if(request.getParameter("year3")!=null&&!request.getParameter("year3").equals("null")&&!request.getParameter("year3").equals("")){year=request.getParameter("year3");}
       else if(request.getParameter("year4")!=null&&!request.getParameter("year4").equals("null")&&!request.getParameter("year4").equals("")){year=request.getParameter("year4");}
       else if(request.getParameter("year5")!=null&&!request.getParameter("year5").equals("null")&&!request.getParameter("year5").equals("")){year=request.getParameter("year5");}
       else{year="";}
       if(request.getParameter("month1")!=null&&!request.getParameter("month1").equals("null")&&!request.getParameter("month1").equals("")){month=request.getParameter("month1");}
       else if(request.getParameter("month2")!=null&&!request.getParameter("month2").equals("null")&&!request.getParameter("month2").equals("")){month=request.getParameter("month2");}
       else if(request.getParameter("month3")!=null&&!request.getParameter("month3").equals("null")&&!request.getParameter("month3").equals("")){month=request.getParameter("month3");} 
       else{month="";}
       if(month.length()==1){month="0"+month;}
        if(auth.getCityCode()==null || auth.getCityCode().equals("")||auth.getCityCode().equals("null"))
        {
        if(request.getParameter("city")!=null&&!request.getParameter("city").equals("")&&!request.getParameter("city").equals("null"))
           {city=request.getParameter("city");}
        else{city="";}
       } 
      else{city=auth.getCityCode();}
      
       if(request.getParameter("LX")!=null&&!request.getParameter("LX").equals("null")&&!request.getParameter("LX").equals("")){lx=request.getParameter("LX");}
       else{lx="";}
       if(start==null ||start=="" || end==null || end=="")
        {start="";end="";}
        try{
        if(auth.getCityCode()==null || auth.getCityCode().equals("")){
        dataTable=AccS.getCount(year,quarter,month,xun,week,rq,start,end,lx,city,relationproduct);
        }else{
         area=request.getParameter("area");
         if(area==null||area.equals("null")||area.equals("")){area="";}
         dataTable=AccS.getareaCount(year,quarter,month,xun,week,rq,start,end,lx,city,area,relationproduct);
        }
        }
        catch(Exception ex){ex.printStackTrace();}
 
%>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../../common/style/main.css" rel="stylesheet" type="text/css" />
<link href="../../common/style/Sty01.css" rel="stylesheet" type="text/css" />
<title>注册帐号统计</title>

<SCRIPT LANGUAGE="JavaScript">
<!--
	function fn_onload() {
		cltScript_Toolbar();
	}
		
	function cltScript_Toolbar() {
        if ( self.parent != self ){
            var pel = parent.document.all.tags("frame");
            for ( i=0; i< pel.length; i++){
                if ( pel(i).name == "main") {
					divTop.style.width = pel(i).width;
					divMain.style.width = pel(i).width;
					divMain.style.height = pel(i).height - divTop.clientHeight;
                }
            }
         }
	 }
	 function help() {
 	 window.open("Account_Help.jsp","windowRef","width=270,height=146,top=150,left=200,screenX=10,screenY=20");
	}
	 function check()
{


	if(form1.StartTIME.value>form1.EndTIME.value){
		alert("结束时间不能比开始时间晚!");
		document.all.EndTIME.focus();
		return false;
	}

 if("1"=="<%=time_style%>"){
 document.all("succ_one").style.display ="";
 document.all("succ_two").style.display ="none";
 document.all("succ_three").style.display ="none";
 document.all("succ_six").style.display ="none";
 document.all("succ_four").style.display ="none";
 document.all("succ_five").style.display ="none";
 document.all("succ_serven").style.display ="none"; 
}


else if("2"=="<%=time_style%>"){
 document.all("succ_two").style.display ="";
 document.all("succ_one").style.display ="none";
 document.all("succ_three").style.display ="none";
 document.all("succ_six").style.display ="none";
 document.all("succ_four").style.display ="none";
 document.all("succ_five").style.display ="none";
 document.all("succ_serven").style.display ="none"; 
  
}

else if("3"=="<%=time_style%>"){
 document.all("succ_three").style.display ="";
 document.all("succ_one").style.display ="none";
 document.all("succ_two").style.display ="none";
 document.all("succ_six").style.display ="none";
 document.all("succ_four").style.display ="none";
 document.all("succ_five").style.display ="none";
 document.all("succ_serven").style.display ="none"; 
}

else if("4"=="<%=time_style%>"){
 document.all("succ_four").style.display ="";
 document.all("succ_one").style.display ="none";
 document.all("succ_two").style.display ="none";
 document.all("succ_six").style.display ="none";
 document.all("succ_three").style.display ="none";
 document.all("succ_serven").style.display ="none"; 
}

else if("5"=="<%=time_style%>"){
 document.all("succ_five").style.display ="";
 document.all("succ_one").style.display ="none";
 document.all("succ_two").style.display ="none";
 document.all("succ_six").style.display ="none";
 document.all("succ_three").style.display ="none";
 document.all("succ_serven").style.display ="none"; 
}

else if("6"=="<%=time_style%>"){
 document.all("succ_six").style.display ="";
 document.all("succ_one").style.display ="none";
 document.all("succ_two").style.display ="none";
 document.all("succ_three").style.display ="none";
 document.all("succ_four").style.display ="none";
 document.all("succ_serven").style.display ="none";
}
else if("7"=="<%=time_style%>"){
 document.all("succ_serven").style.display ="";
 document.all("succ_six").style.display ="none";
 document.all("succ_one").style.display ="none";
 document.all("succ_two").style.display ="none";
 document.all("succ_three").style.display ="none";
 document.all("succ_four").style.display ="none";


}

else{

 document.all("succ_one").style.display ="none";
 document.all("succ_two").style.display ="none";
 document.all("succ_three").style.display ="none";
 document.all("succ_four").style.display ="none";
 document.all("succ_six").style.display ="none";
 document.all("succ_five").style.display ="none";
 document.all("succ_serven").style.display ="none";







}
	
	
	}
//-->
</SCRIPT>
<link rel="stylesheet" type="text/css" media="all" href="../calendar/calendar-brown.css"/>
<script type="text/javascript" src="../calendar/calendar.js"></script>
<script type="text/javascript" src="../calendar/calendar-zh.js"></script>
<script type="text/javascript" src="../calendar/calendar-action.js"></script>


</head>

<body onLoad="fn_onload();check();">
<div onresize="cltScript_Toolbar();" style="width: 100%">
			<div id="divTop" style="overflow: hidden">
			     <table id="ibtnPanel" style="font-size: 9pt; border-bottom: #efefef 1px outset" cellspacing="0"
					cellpadding="0" width="100%" border="0">
					  <tr bgcolor="#efefef" height="33">
						    <td valign="middle" align="center" width="91" 
							onclick="javascript:form1.submit()" 
							id="ibtnExport" 
							style="behavior:url(../../common/button.htc)" 
							DefaultClass="btnDefault" 
							OverClass="btnOver" 
							DownClass="btnDown" 
							title="按不同的条件进行统计">统计</td>
							<td valign="middle" align="center" width="91" 
							onclick="javascript:e()" 
							id="ibtnExport" 
							style="behavior:url(../../common/button.htc)" 
							DefaultClass="btnDefault" 
							OverClass="btnOver" 
							DownClass="btnDown" 
							title="将列表的内容导出到Excel中">导出Excel</td>
							<td valign="middle" align="center" width="91" 
							onclick="javascript:help()" 
							id="ibtnExport" 
							style="behavior:url(../../common/button.htc)" 
							DefaultClass="btnDefault" 
							OverClass="btnOver" 
							DownClass="btnDown" 
							title="帮助">帮助</td>
							<td>&nbsp; &nbsp;  </td>
				   </tr>
				</table>
				<jsp:include page="../../common/inc_top.jsp" >
					<jsp:param name="purvCode" value="<%=sPurvICode%>"/>
				</jsp:include>
<form name="form1" method="post" action="">
<table width="1004">
<tr>
<%if(auth.getCityCode()==null || auth.getCityCode().equals("")){%>
<td class="Caption_Td" width="155">地市
<select name="city">
     <option value="">-请选择-</option>
          <%
                                    DataTable dtcity=AccS.getCity();
                                    for(int i=0;i<dtcity.getRows().getCount();i++){
                                    out.print("<option value='"+dtcity.getRow(i).getString("citycode")+"' ");
                                    if(city.equals(dtcity.getRow(i).getString("citycode")))
                                     {out.print(" selected>");}
                                     else{out.print(">");} 
                                     out.print(dtcity.getRow(i).getString("cityname"));
                                     out.print("</option>"); 
                                    
                                    }%> 
        </select></td>
 <%   }else{%>
 <td width="129" class="Caption_Td">地区
 <select name="area">
      <option value="">-请选择-</option>
        <%
           DataTable dtarea=AccS.getarea(auth.getCityCode());
           for(int i=0;i<dtarea.getRows().getCount();i++){
            DataRow dr=dtarea.getRow(i);
            out.print("<option value='" + dr.getString("AREACODE") + "'");
            if(area.equals(dr.getString("AREACODE"))){out.print("selected>");}
            else{out.print(">");}
            out.print(dr.getString("AREANAME"));
            out.print("</option>");
           }
           
           %>
        </select> </td>
 <%}%>
 <td width="194" class="Caption_Td">类型
   <select name="LX">
     <option value="">-全部-</option>
     <option value="E" <%if(lx.equals("E")) out.print("selected");%>>在用</option>
     <option value="D" <%if(lx.equals("D")) out.print("selected");%>>已注销</option>
   </select>
   <label>
   <input type="checkbox" name="relationproduct"  value="1"   <%if(relationproduct.equals("1")) out.print("checked");%>>
   关联产品的注册统计</label></td>
 
 <td width="125" class="Caption_Td">时间
 <select name="time_style" onChange="change()">
                                <option value=" " >-请选择-</option>
                                <option value="1" <%if(time_style.equals("1")) out.print("selected");%>>年</option>
                                <option value="2" <%if(time_style.equals("2")) out.print("selected");%>>季度</option>
                                <option value="3" <%if(time_style.equals("3")) out.print("selected");%>>月</option>
                                <option value="4" <%if(time_style.equals("4")) out.print("selected");%>>旬</option>
                                <option value="7" <%if(time_style.equals("7")) out.print("selected");%>>周</option>
                                <option value="6" <%if(time_style.equals("6")) out.print("selected");%>>日</option>
        </select>  </td>
 </tr>
 </table>