operationlist.jsp

电信的网厅的整站代码

<%@ page import="com.doone.uurm.UserFactory,
                 com.doone.data.*,
                 com.doone.uurm.WebAuth,
                 com.doone.fj1w.fjmgr.statana.*,
                 com.doone.uurm.IOrgInfo"%>
                 <%@page import="java.util.*"%>
<%@ page contentType="text/html; charset=GBK" %>
<%request.setCharacterEncoding("GBK");%>
<%String sPurvICode="NGB006001";%>
<%! 
   
    String sllx="";
    String week="";
	String ywlx="";
	String start="";
	String end="";
	String citystr="";
	String area="";
	String month="";
	String quarter="";
	String xun="";
	String rq="";
	String year="";
	String time_style="";
	String slzt="";
	String falg="0";
	String countstr="";
	DataTable dt=null;
	ywsl_count ywsl_count=new ywsl_count();
	DataRow dr = null;
%>
	
<%
   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;
	}
	 slzt=request.getParameter("slzt");
	 sllx=request.getParameter("sllx");
	 ywlx=request.getParameter("ywlx");
	 quarter=request.getParameter("quarter");
	 start=request.getParameter("starttime");
     end=request.getParameter("endtime");
     xun=request.getParameter("xun");
     rq=request.getParameter("rq");
     time_style=request.getParameter("time_style");
     String pageNo=request.getParameter("PageNo");
     area=request.getParameter("area");
     week=request.getParameter("week");
     if(area==null||area.equals("null")||area.equals("")){area="";}
	 if(pageNo==null || pageNo=="")pageNo="1";
     if(time_style==null||time_style.equals("")||time_style.equals("null")){time_style="";}
     if(slzt==null||slzt.equals("null")||slzt.equals("")){slzt="";}
     if(sllx==null||sllx.equals("null")||sllx.equals("")){sllx="";}
     if(ywlx==null||ywlx.equals("null")||ywlx.equals("")){ywlx="";}
     if(start==null||start.equals("null")||start.equals("")){start="";}
     if(end==null||end.equals("null")||end.equals("")){end="";}
     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(auth.getCityCode()==null || auth.getCityCode().equals("null")||auth.getCityCode().equals("")){
        if(request.getParameter("city")!=null&&!request.getParameter("city").equals("")&&!request.getParameter("city").equals("null"))
           {citystr=request.getParameter("city");}
         else{citystr="";}
     }else{
        citystr=auth.getCityCode();
     }
    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 if(request.getParameter("year")!=null&&!request.getParameter("year").equals("null")&&!request.getParameter("year").equals("")){year=request.getParameter("year");}
    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 if(request.getParameter("month")!=null&&!request.getParameter("month").equals("null")&&!request.getParameter("month").equals("")){month=request.getParameter("month");}
    else{month="";}
    if(month.length()==1){month="0"+month;}         
    try{
    dt=ywsl_count.getareaCount(citystr,area,ywlx,sllx,slzt,year,quarter,month,xun,week,rq,start,end,pageNo,falg);
    countstr=ywsl_count.getareaPageNo(citystr,area,ywlx,sllx,slzt,year,quarter,month,xun,week,rq,start,end);}
    catch(Exception ex){ex.printStackTrace();
    }
%>	    
	    
<html>
<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;
                }
            }
         }
	 }
//-->
</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>
<title>业务受理量汇总表</title>
<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" />
</head>

<body onLoad="fn_onload();show();">
<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:ex()" 
							id="ibtnExport" 
							style="behavior:url(../../common/button.htc)" 
							DefaultClass="btnDefault" 
							OverClass="btnOver" 
							DownClass="btnDown" 
							title="将列表的内容导出到Excel中">导出Excel</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="OperationList.jsp">
<table width="1008">
<tr>
<%if(auth.getCityCode()==null || auth.getCityCode().equals("")){%>

<td width="143" class="Caption_Td" nowrap="nowrap">受理地市
	<select name="city">
		<option value="" >-请选择-</option>
		<%
          DataTable dtcity=ywsl_count.getCity();
          for(int i=0;i<dtcity.getRows().getCount();i++){
            out.print("<option value='"+dtcity.getRow(i).getString("citycode")+"' ");
            if(citystr.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="143" class="Caption_Td">受理地区
<select name="area">
      <option value="">-请选择-</option>
        <%
           DataTable dtarea=ywsl_count.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="181" class="Caption_Td">业务类型
<select name="ywlx" id="ywlx"  style="width:120"  >
               <option value="">-全部-</option>
               <%
                DataTable  dt1=ywsl_count.query_pro(auth.getCityCode());
                   String p="";
                   for(int i=0;i<dt1.getRows().getCount();i++){
                   dr = dt1.getRow(i);
                   String productid=dr.getString("PRODUCTID");
                   String productname=dr.getString("PRODUCTNAME");
                   if(ywlx.equals(dr.getString("PRODUCTID"))){
                   p = p+ "<option value='" + productid + "'selected>" + productname +"</option>";}
                           else{
							p = p+ "<option value='" + productid + "'>" + productname +"</option>";
						  	  }	
                   
                   }
                   
                    out.print(p);
                  %>
			         			
      </select>
</td>

<td width="180" class="Caption_Td">受理类型

<select name="sllx" id="sllx"  style="width:120" >
              <option value="">-全部-</option>
              <option value="N" <%if(sllx.equals("N")) out.print("selected");%>>新装</option>
              <option value="A" <%if(sllx.equals("A")) out.print("selected");%>>新加</option>
              <option value="S" <%if(sllx.equals("s")) out.print("selected");%>>纯装</option> 
              <option value="M" <%if(sllx.equals("M")) out.print("selected");%>>移机</option> 
              <option value="D" <%if(sllx.equals("D")) out.print("selected");%>>宽带变速</option>
              <option value="C" <%if(sllx.equals("C")) out.print("selected");%>>关机</option>
              <option value="0" <%if(sllx.equals("0")) out.print("selected");%>>开机/复机</option>
      </select>
</td>

<td width="314" class="Caption_Td">受理状态
<select name="slzt" id="slzt"  style="width:120" >
              <option value="">-全部-</option>
              <option value="1" <%if(slzt.equals("1")) out.print("selected");%>>待处理</option>
              <option value="2" <%if(slzt.equals("2")) out.print("selected");%>>转派</option>
              <option value="3" <%if(slzt.equals("3")) out.print("selected");%>>挂起</option>
              <option value="8" <%if(slzt.equals("8")) out.print("selected");%>>作废</option> 
              <option value="9" <%if(slzt.equals("9")) out.print("selected");%>>完成</option>  
</select>
</td>

</tr>
<tr>
<td width="215" class="Caption_Td" colspan="5">时间方式
<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>



<div id="succ_one"  style="display:none">
<table width="1013">
<tr>
<td  class="Caption_Td" colspan="12">
<select name="year1">
                            <option value="">-请选择-</option>
							  <%
                             java.util.Date date = new java.util.Date();
                             java.util.Calendar calender = new java.util.GregorianCalendar();
                             calender.setTime(date);
                             int mmcalender=calender.get(Calendar.MONTH)+1;
							 for(int t=0;t<10;t++){
                             int yy=calender.get(Calendar.YEAR)-t;
							  %>
                                <option value="<%=yy%>"><%=yy%></option>
                                <%}%>
            </select>年
</td>                              


</tr>
</table>
</div>



<div id="succ_two"  style="display:none">
<table width="1006">
<tr>
<td class="Caption_Td" width="98">

<select name="year2" >
                                 <option value="">-请选择-</option>
							  <%
                             java.util.Date _date = new java.util.Date();
                             java.util.Calendar _calender = new java.util.GregorianCalendar();
                             _calender.setTime(_date);
                             int _mmcalender=calender.get(Calendar.MONTH)+1;
							 for(int t=0;t<10;t++){
                             int yy=calender.get(Calendar.YEAR)-t;
							  %>
                                <option value="<%=yy%>" ><%=yy%></option>
                                <%}%>
            </select>年