📄 ywslclientlist.jsp
字号:
<%@ page contentType="text/html; charset=GBK" errorPage=""%>
<%@ page import=" com.doone.fj1w.fjmgr.statana.*"%>
<%@ page import="com.doone.uurm.WebAuth"%>
<%@ page import="com.doone.data.DataTable"%>
<%request.setCharacterEncoding("GBK");%>
<%String sPurvICode="NGB006001";%>
<%!
String flag="0";
%>
<%
DataTable dt=new DataTable();
String countstr="";
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;
}
ywsl_count ywsl_count=new ywsl_count();
String citycode=request.getParameter("city");
String areacode=request.getParameter("area");
String year=request.getParameter("year");
String quarter=request.getParameter("quarter");
String month=request.getParameter("month");
String xun=request.getParameter("xun");
String week=request.getParameter("week");
String rq=request.getParameter("rq");
String start=request.getParameter("start");
String end=request.getParameter("end");
String slzt=request.getParameter("slzt");
String sllx=request.getParameter("sllx");
String ywlx=request.getParameter("ywlx");
if(year==null||year.equals("")||year.equals("null")){year="";}
if(quarter==null||quarter.equals("")||quarter.equals("null")){quarter="";}
if(month==null||month.equals("")||month.equals("null")){month="";}
if(xun==null||xun.equals("")||xun.equals("null")){xun="";}
if(rq==null||rq.equals("")||rq.equals("null")){rq="";}
if(start==null || start=="")start="";
if(end==null || end=="")end="";
if(slzt==null||slzt.equals("")||slzt.equals("null")){slzt="";}
if(sllx==null||sllx.equals("")||sllx.equals("null")){sllx="";}
if(ywlx==null||ywlx.equals("")||ywlx.equals("null")){ywlx="";}
String pageNo=request.getParameter("PageNo");
if(pageNo==null || pageNo=="")pageNo="1";
try{
dt=ywsl_count.getarealist(citycode,areacode,ywlx,sllx,slzt,year,quarter,month,xun,week,rq,start,end,pageNo,flag);
countstr=ywsl_count.getarealistPageNo(citycode,areacode,ywlx,sllx,slzt,year,quarter,month,xun,week,rq,start,end);
}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 check()
{
if(form1.StartTIME.value>form1.EndTIME.value){
alert("结束时间不能比开始时间晚!");
document.all.EndTIME.focus();
return false;
}
}
//-->
</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();">
<div onresize="cltScript_Toolbar();" style="width: 100%">
<div id="divMain" style="overflow: auto" align="center">
<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:gotoinput()"
id="ibtnExport"
style="behavior:url(../../common/button.htc)"
DefaultClass="btnDefault"
OverClass="btnOver"
DownClass="btnDown"
title="将列表的内容导出到Excel中">返回</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> </td>
</tr>
</table>
<div id="divTop" style="overflow: hidden">
<jsp:include page="../../common/inc_top.jsp" >
<jsp:param name="purvCode" value="<%=sPurvICode%>"/>
</jsp:include>
</div>
<table style="font-size: 9pt; border-bottom: #efefef 1px outset" cellspacing="0"
cellpadding="0" width="100%" border="0" class="OuterTable">
<tr class="OuterHead">
<td class="title_td" align="left" width="5%">业务受理统计详细列表 你统计的方式为：
<%if(!year.equals("")){out.print(year);out.print("年");}
if(!quarter.equals("")){out.println("第");out.print(quarter);out.print("季度");}
if(!month.equals("")){out.println("第");out.print(month);out.print("月");}
if(!xun.equals("")){
if(xun.equals("1")){out.print("上旬");}
if(xun.equals("2")){out.print("中旬");}
if(xun.equals("3")){out.print("下旬");}
}
if(!week.equals("")){
if(week.equals("1")){out.print("第一周");}
if(week.equals("2")){out.print("第二周");}
if(week.equals("3")){out.print("第三周");}
if(week.equals("4")){out.print("第四周");}
}
if(!rq.equals("")){out.print(rq.substring(0,4));out.print("年");out.print(rq.substring(5,7));out.print("月");out.print(rq.substring(8,10));out.print("日");}
if(!start.equals("")){out.print(start);out.print("--");}
if(!end.equals("")){out.print(end);}
%></td>
</tr>
</table>
<table style="font-size: 9pt; border-bottom: #efefef 1px outset" cellspacing="0"
cellpadding="0" width="100%" border="0" class="OuterTable">
<tr class="OuterHead">
<td class="title_td" align="left" width="3%">用户名称</td>
<td class="title_td" align="left" width="5%">就近电话/移机号码</td>
<td class="title_td" align="left" width="6%">邮件地址</td>
<td class="title_td" align="left" width="6%">联系电话</td>
<td class="title_td" align="left" width="6%">受理时间</td>
<td class="title_td" align="left" width="6%">希望开通时间</td>
</tr>
</table>
<table id="prodfunList" border=0 width=100% cellspacing=0 cellpadding=1
style="behavior:url(../../common/table.htc)"
DefaultClass="DefaltRow"
SelectedClass="SelectedRow"
keyName="key"
multiple="true"
class="InnerTable">
<% if(dt!=null){
for(int i=0;i<dt.getRows().getCount();i++){
%>
<tr class="InnerMain" style="color: black" key="">
<td class="body_td" align="left" width="3%" nowrap><%=dt.getRow(i).getString("USERNAME")%></td>
<td class="body_td" align="left" width="5%" nowrap><%=dt.getRow(i).getString("ABOUTTEL")%></td>
<td class="body_td" align="left" width="6%" nowrap><%=dt.getRow(i).getString("EMAIL")%></td>
<td class="body_td" align="left" width="6%" nowrap><%=dt.getRow(i).getString("RELATIONTEL")%></td>
<td class="body_td" align="left" width="6%" nowrap><%=dt.getRow(i).getString("ACCEPTTIME")%></td>
<td class="body_td" align="left" width="6%" nowrap><%=dt.getRow(i).getString("HOPEUSETIME")%></td>
</tr>
<%}
}%>
</table>
<table cellpadding="0" cellspacing="0" border="0" width="100%" class="OuterTable">
<tr class="OuterFoot">
<td align="left" class="foot_td" nowrap width="5%">本页共<%=dt.getRows().getCount()%>条记录</td>
<td align="left" class="foot_td" nowrap width="5%">第<%=pageNo%>页 </td>
<td align="left" class="foot_td" nowrap width="5%">共<%=countstr%>页</td>
<td align="right" class="foot_td" nowrap width="70%">
<%
int PageCount = Integer.parseInt(countstr);
int ShowPage = Integer.parseInt(pageNo);
//当记录数小于10*10的时候
if(PageCount<=10){
out.print("分页：<font face=webdings>9</font>");
for(int i=1;i<=PageCount;i++){
out.print("<a href=\"ywslclientlist.jsp?PageNo="+i+"&city="+citycode+"&area="+areacode+"&year="+year+"&sllx="+sllx+"&slzt="+slzt+"&ywlx="+ywlx+"&quarter="+quarter+"&month="+month+"&xun="+xun+"&week="+week+"&rq="+rq+"&starttime="+start+"&endtime="+end+"\"> "+i+"</a>");
}
out.print(" <Font face=webdings>:</font>");
}else{
//当记录数大于10*10
int tempNum = (ShowPage-1)/10;
if(tempNum==0){
tempNum=0;
//处于第一个10页的时候
out.print("分页：<font face=webdings>9</font>");
}else{
//处于中间页面位置
out.print(" 分页：<a href=\"ywslclientlist.jsp?PageNo="+"1"+"&city="+citycode+"&area="+areacode+"&year="+year+"&sllx="+sllx+"&slzt="+slzt+"&ywlx="+ywlx+"&quarter="+quarter+"&month="+month+"&xun="+xun+"&week="+week+"&starttime="+start+"&endtime="+end+"\" title=\"首页\"><font face=webdings>9</font></a> <a href=\"ywslclientlist.jsp?PageNo="+tempNum*10+"&city="+citycode+"&area="+areacode+"&year="+year+"&sllx="+sllx+"&slzt="+slzt+"&ywlx="+ywlx+"&quarter="+quarter+"&month="+month+"&xun="+xun+"&week="+week+"&starttime="+start+"&endtime="+end+"\" title=\"前十页\"><font face=webdings>7</font></a>");
}
//判断是否是最后一页
if(PageCount/10!=tempNum){
//当不是最后一页的时候
for(int i=1;i<=10;i++){
int tempShowPage = tempNum*10+i;
out.print("<a href=\"ywslclientlist.jsp?PageNo="+tempShowPage+"&city="+citycode+"&area="+areacode+"&year="+year+"&sllx="+sllx+"&slzt="+slzt+"&ywlx="+ywlx+"&quarter="+quarter+"&month="+month+"&xun="+xun+"&week="+week+"&starttime="+start+"&endtime="+end+"\"> ");
if(ShowPage==tempShowPage){
out.print(" <font color=\"#FF0000\">"+tempShowPage+"</font>");
}else{
out.print(tempShowPage);
}
out.print("</a>");
}
int n=tempNum*10+10+1;
out.print("<a href=\"ywslclientlist.jsp?PageNo="+String.valueOf(n)+"&city="+citycode+"&area="+areacode+"&year="+year+"&sllx="+sllx+"&slzt="+slzt+"&ywlx="+ywlx+"&quarter="+quarter+"&month="+month+"&xun="+xun+"&week="+week+"&starttime="+start+"&endtime="+end+"\" title=\"后十页\"><font face=webdings>8</font></a> <a href=\"ywslclientlist.jsp?PageNo="+PageCount+"&city="+citycode+"&area"+areacode+"&year="+year+"&sllx="+sllx+"&slzt="+slzt+"&ywlx="+ywlx+"&quarter="+quarter+"&month="+month+"&xun="+xun+"&week="+week+"&starttime="+start+"&endtime="+end+"\" title=\"尾页\"><Font face=webdings>:</font></a>");
}else{
//取最后剩余的页数
for(int i=1;i<=PageCount%10;i++){
int tempShowPage = tempNum*10+i;
out.print(" <a href=\"ywslclientlist.jsp?PageNo="+tempShowPage+"&city="+citycode+"&area="+areacode+"&year="+year+"&sllx="+sllx+"&slzt="+slzt+"&ywlx="+ywlx+"&quarter="+quarter+"&month="+month+"&xun="+xun+"&week="+week+"&starttime="+start+"&endtime="+end+"\"> ");
if(ShowPage==tempShowPage){
out.print(" <font color=\"#FF0000\">"+tempShowPage+"</font>");
}else{
out.print(tempShowPage);
}
out.print("</a>");
}
out.print("<Font face=webdings>:</font>");
}
}
%>
</td>
</tr>
</table>
</div>
</div>
<iframe name="iframe1" style="" src="" frameborder=0 width="0" height="0" scrolling="no"></iframe>
</body>
</html>
<Script language="javascript">
function e()
{
var no=<%=pageNo%>;
var sURL = "ywslclientlistexcel.jsp?PageNo=" + no+"&ywlx=<%=ywlx%>&sllx=<%=sllx%>&slzt=<%=slzt%>&citycode=<%=citycode%>&areacode=<%=areacode%>&year=<%=year%>&quarter=<%=quarter%>&month=<%=month%>&xun=<%=xun%>&week=<%=week%>&rq=<%=rq%>&start=<%=start%>&end=<%=end%>";
//alert(sURL);
window.open(sURL,'windowRef','width=800,height=600,top=20,left=60,screenX=10,screenY=20,status=yes',scrollbar='yes');
}
function gotoinput(){
window.location.href="Operationlist.jsp";
}
</script>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -