您所在位置：主题：奇怪的统计问题
fenxi
[专家分：0] 发布于 2009-05-03 21:15:00
<%@LANGUAGE="VBSCRIPT"%><head>
<!--#include file="conn.asp"-->
<% sql_sd_js="select count(*) from user_bdb where 派单标志<>True"
sql_hd_js="select count(*) from user_bdb where 派单标志=True and 回单标志<>True"
sql_hh_js="select count(*) from user_bdb where 回访得分<1 and 回单标志=True"
dd="n"
nowsj=now()
sql_csd_js="select count(*) from user_bdb where 派单标志=True and 回单标志<>True and now()>DateAdd('"&dd&"',故障时限,受理时间)"
sql_gc_js="select count(*) from user_gc where 进程标志=1"
sql_csd_zs="select count(*) from user_bdb where 回单标志=True and 回单时间>date()-day(now)+1"
sql_csd_cs="select count(*) from user_bdb where 回单标志=True and 故障历时>故障时限 and 回单时间>date()-day(now)+1"
set rs_csd_js=server.createobject("adodb.recordset")
rs_csd_js.open sql_csd_zs,conn,1,1
jls_zs=rs_csd_js(0)
rs_csd_js.close
set rs_csd_js=nothing
'本月障碍总数统计计数结束
set rs_csd_js=server.createobject("adodb.recordset")
rs_csd_js.open sql_csd_cs,conn,1,1
jls_csl=rs_csd_js(0)
rs_csd_js.close
set rs_csd_js=nothing
'超时率统计计数结束
'施工工程计数开始
set rs_wsd_js=server.createobject("adodb.recordset")
rs_wsd_js.open sql_gc_js,conn,1,1
jls_gc=rs_wsd_js(0)
rs_wsd_js.close
set rs_wsd_js=nothing
'施工工程计数结束
'未派单统计计数开始
set rs_wsd_js=server.createobject("adodb.recordset")
rs_wsd_js.open sql_sd_js,conn,1,1
jls_wsd=rs_wsd_js(0)
rs_wsd_js.close
set rs_wsd_js=nothing
'未派单统计计数结束
'未回单统计计数开始
set rs_whd_js=server.createobject("adodb.recordset")
rs_whd_js.open sql_hd_js,conn,1,1
jls_whd=rs_whd_js(0)
rs_whd_js.close
set rs_whd_js=nothing
'未回单统计计数结束
'未回访统计计数开始
set rs_wsd_js=server.createobject("adodb.recordset")
rs_wsd_js.open sql_hh_js,conn,1,1
jls_whh=rs_wsd_js(0)
rs_wsd_js.close
set rs_wsd_js=nothing
'未回访统计计数结束
'超时单统计计数开始
set rs_csd_js=server.createobject("adodb.recordset")
rs_csd_js.open sql_csd_js,conn,1,1
jls_csd=rs_csd_js(0)
rs_csd_js.close
set rs_csd_js=nothing
'超时单统计计数结束
exec="select * from user "
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,1
%>
<%
rs.PageSize=20
pagecount=rs.PageCount
page=int(request.QueryString ("page"))
if page<=0 then page=1
if request.QueryString("page")="" then
page=1
end if
if not rs.eof then
rs.AbsolutePage = page
end if
%>
<style type="text/css">
<!--
.STYLE1 {font-size: 12px}
.STYLE20 {color: #9900FF}
.STYLE21 {color: #FF0000}
.STYLE22 {color: #006600}
.STYLE26 {color: #FF0066}
.STYLE30 {font-size: 12px; color: #000000; }
body {
margin-top: 5px;
}
.STYLE31 {
font-size: 24px;
font-weight: bold;
}
.STYLE32 {color: #000000}
-->
</style>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" /><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><span class="STYLE1"><span class="STYLE22">未派修:<a href="zibx_wsd.asp"><%=response.write(jls_wsd)%></a>;</span> <span class="STYLE8 STYLE20">未回单:<a href="zicl_wsd.asp"><%=response.write(jls_whd)%></a></span><span class="STYLE20">;</span> <span class="STYLE9 STYLE21">超时单:<%=response.write(jls_csd)%></span> <span class="STYLE30">未回访:<a href="hhcl_wsd.asp"><%=response.write(jls_whh)%></a></span> <span class="STYLE30">施工中工程:<a href="user_gc_2.asp"><%=response.write(jls_gc)%></a></span>
<% date_1=ya %>
</span></td>
<td><div align="right" class="STYLE30">本月统计：障碍总数: <%=response.write(jls_zs)%> ;超时:<span class="STYLE26"><%=response.write(jls_csl)%></span>;超时率:<span class="STYLE26"><%=response.write(Formatnumber(jls_csl/jls_zs*100))%></span>%</div></td>
</tr>
</table>
<form id="form1" name="form1" method="post" action="tj_whzl_find.asp">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<script language="JavaScript" src="calendar.js"></script>
<td height="26"><div align="left"><span class="STYLE1">查询日期：
<%cxrq_n1=session("cxrq_v1")
cxrq_n2=session("cxrq_v2")
if len(cxrq_n1)=0 then
cxrq_n1=Year(Date)&"-"&Month(Date)&"-1"
cxrq_n2=date()
end if %>
<input name="cxrq_1"id="cxrq_1" onFocus="calendar()" value="<%=cxrq_n1%>" size="17" maxlength="12">
至
<input name="cxrq_2" value="<%=cxrq_n2%>"id="cxrq_2" onFocus="calendar()" size="17" maxlength="12">
</span>
<input type="submit" name="Submit" value="提交">
</div>
<div align="center"></div> </td>
</tr>
</table>
</form>
<div align="center">
<span class="STYLE8 STYLE31">维 护 质 量 龙 虎 榜 </span> </div>
<table width="100%" border="2" cellspacing="0" bordercolor="#006600" style="border-collapse:collapse;" >
<tr align="center">
<td height="25" bgcolor="#CCCCCC" class="STYLE1"> </td>
<td height="25" colspan="3" bgcolor="#CCCCCC" class="STYLE1"><span class="STYLE30">障碍维护情况</span></td>
<td height="25" colspan="4" bgcolor="#CCCCCC" class="STYLE1">预约超时情况</td>
<td height="25" colspan="3" bgcolor="#CCCCCC" class="STYLE1">电话接听情况</td>
<td height="25" colspan="2" bgcolor="#CCCCCC" class="STYLE1"><span class="STYLE30">障碍维护质量</span></td>
</tr>
<tr align="center">
<td width="8%" height="25" bgcolor="#CCCCCC" class="STYLE1">姓名</td>
<td width="8%" height="25" bgcolor="#CCCCCC" class="STYLE1"><span class="STYLE30">障碍总数</span></td>
<td width="8%" height="25" bgcolor="#CCCCCC" class="STYLE1"><span class="STYLE30">障碍超时</span></td>
<td width="7%" height="25" bgcolor="#CCCCCC" class="STYLE1"><span class="STYLE30">超时率</span></td>
<td width="8%" height="25" bgcolor="#CCCCCC" class="STYLE1">预约总数</td>
<td width="7%" height="25" bgcolor="#CCCCCC" class="STYLE1">预约<span class="STYLE30">率</span></td>
<td width="8%" height="25" bgcolor="#CCCCCC" class="STYLE1">预约超时</td>
<td width="7%" height="25" bgcolor="#CCCCCC" class="STYLE1"><span class="STYLE30">超时率</span></td>
<td width="8%" bgcolor="#CCCCCC" class="STYLE1">电话关机</td>
<td width="8%" height="25" bgcolor="#CCCCCC" class="STYLE1">无人接听</td>
<td width="8%" bgcolor="#CCCCCC" class="STYLE1">电话接通率</td>
<td width="8%" bgcolor="#CCCCCC" class="STYLE1">障碍历时</td>
<td width="8%" height="25" bgcolor="#CCCCCC" class="STYLE1">平均历时</td>
</tr>
<tr align="center">
<td width="8%" height="26" bgcolor="#CCCCCC" class="STYLE1">合计</td>
<%
sql_tj_zs="select count(*) from user_bdb where 回单标志=True and 回单时间>date()-day(now)+1"
sql_tj_cs="select count(*) from user_bdb where 回单标志=True and 故障历时>故障时限 and 回单时间>date()-day(now)+1"
sql_tj_uzs="select count(*) from user_bdb where 回单标志=True and len(何时预约)>0 and 回单时间>date()-day(now)+1"
sql_tj_ucs="select count(*) from user_bdb where 回单标志=True and DateAdd('"&dd&"',30,派单时间)>何时预约 and 回单时间>date()-day(now)+1"
sql_tj_gj="select count(*) from user_bdb where 回单标志=True and 电话通知='电话已关机' and 回单时间>date()-day(now)+1"
sql_tj_wj="select count(*) from user_bdb where 回单标志=True and 电话通知='电话无人接听' and 回单时间>date()-day(now)+1"
sql_tj_zi="select sum(故障历时) from user_bdb where 回单标志=True and 回单时间>date()-day(now)+1"
if cxrq_n1<>"" or cxrq_n2<>"" then
sql_tj_zs="select count(*) from user_bdb where 回单标志=True and 回单时间>=#"&cxrq_n1&"# and 回单时间<=#"&cxrq_n2&"# "
sql_tj_cs="select count(*) from user_bdb where 回单标志=True and 回单时间>=#"&cxrq_n1&"# and 回单时间<=#"&cxrq_n2&"# and 故障历时>故障时限 "
sql_tj_uzs="select count(*) from user_bdb where 回单标志=True and 回单时间>=#"&cxrq_n1&"# and 回单时间<=#"&cxrq_n2&"# and len(何时预约)>0 "
sql_tj_ucs="select count(*) from user_bdb where 回单标志=True and 回单时间>=#"&cxrq_n1&"# and 回单时间<=#"&cxrq_n2&"# and DateAdd('"&dd&"',30,派单时间)>何时预约 "
sql_tj_gj="select count(*) from user_bdb where 回单标志=True and 电话通知='电话已关机' and 回单时间>=#"&cxrq_n1&"# and 回单时间<=#"&cxrq_n2&"#"
sql_tj_wj="select count(*) from user_bdb where 回单标志=True and 电话通知='电话无人接听' and 回单时间>=#"&cxrq_n1&"# and 回单时间<=#"&cxrq_n2&"#"
sql_tj_zi="select sum(故障历时) from user_bdb where 回单标志=True and 回单时间>=#"&cxrq_n1&"# and 回单时间<=#"&cxrq_n2&"# "
end if
set rs_tj_js=server.createobject("adodb.recordset")
rs_tj_js.open sql_tj_zs,conn,1,1
tj_zs=rs_tj_js(0)
rs_tj_js.close
set rs_tj_js=nothing
'本月障碍总数统计计数结束
set rs_tj_js=server.createobject("adodb.recordset")
rs_tj_js.open sql_tj_cs,conn,1,1
tj_csl=rs_tj_js(0)
rs_tj_js.close
set rs_tj_js=nothing
'超时率统计计数结束
set rs_tj_js=server.createobject("adodb.recordset")
rs_tj_js.open sql_tj_uzs,conn,1,1
tj_uzs=rs_tj_js(0)
rs_tj_js.close
set rs_tj_js=nothing
'本月预约总数统计计数结束
set rs_tj_js=server.createobject("adodb.recordset")
rs_tj_js.open sql_tj_ucs,conn,1,1
tj_ucs=rs_tj_js(0)
rs_tj_js.close
set rs_tj_js=nothing
'超时率统计计数结束
set rs_tj_js=server.createobject("adodb.recordset")
rs_tj_js.open sql_tj_zi,conn,1,1
tj_zi=rs_tj_js(0)
rs_tj_js.close
set rs_tj_js=nothing
'障碍历时统计计数结束
set rs_tj_js=server.createobject("adodb.recordset")
rs_tj_js.open sql_tj_gj,conn,1,1
tj_gj=rs_tj_js(0)
rs_tj_js.close
set rs_tj_js=nothing
'关机统计计数结束
set rs_tj_js=server.createobject("adodb.recordset")
rs_tj_js.open sql_tj_wj,conn,1,1
tj_wj=rs_tj_js(0)
rs_tj_js.close
set rs_tj_js=nothing
'无人接听统计计数结束%>
结果是统计结果不同：
未派修:1; 未回单:7; 超时单:3 未回访:36 施工中工程:1 本月统计：障碍总数: 20 ;超时:4;超时率:20.00%
维 护 质 量 龙 虎 榜
障碍维护情况 预约超时情况 电话接听情况 障碍维护质量
姓名 障碍总数 障碍超时 超时率 预约总数 预约率 预约超时 超时率 电话关机 无人接听 电话接通率 障碍历时 平均历时
合计 13 3 23.08 6 46.15 4+7 84.62 1 0 92 5294 407.23
<!--#include file="conn.asp"-->
<% sql_sd_js="select count(*) from user_bdb where 派单标志<>True"
sql_hd_js="select count(*) from user_bdb where 派单标志=True and 回单标志<>True"
sql_hh_js="select count(*) from user_bdb where 回访得分<1 and 回单标志=True"
dd="n"
nowsj=now()
sql_csd_js="select count(*) from user_bdb where 派单标志=True and 回单标志<>True and now()>DateAdd('"&dd&"',故障时限,受理时间)"
sql_gc_js="select count(*) from user_gc where 进程标志=1"
sql_csd_zs="select count(*) from user_bdb where 回单标志=True and 回单时间>date()-day(now)+1"
sql_csd_cs="select count(*) from user_bdb where 回单标志=True and 故障历时>故障时限 and 回单时间>date()-day(now)+1"
set rs_csd_js=server.createobject("adodb.recordset")
rs_csd_js.open sql_csd_zs,conn,1,1
jls_zs=rs_csd_js(0)
rs_csd_js.close
set rs_csd_js=nothing
'本月障碍总数统计计数结束
set rs_csd_js=server.createobject("adodb.recordset")
rs_csd_js.open sql_csd_cs,conn,1,1
jls_csl=rs_csd_js(0)
rs_csd_js.close
set rs_csd_js=nothing
'超时率统计计数结束
'施工工程计数开始
set rs_wsd_js=server.createobject("adodb.recordset")
rs_wsd_js.open sql_gc_js,conn,1,1
jls_gc=rs_wsd_js(0)
rs_wsd_js.close
set rs_wsd_js=nothing
'施工工程计数结束
'未派单统计计数开始
set rs_wsd_js=server.createobject("adodb.recordset")
rs_wsd_js.open sql_sd_js,conn,1,1
jls_wsd=rs_wsd_js(0)
rs_wsd_js.close
set rs_wsd_js=nothing
'未派单统计计数结束
'未回单统计计数开始
set rs_whd_js=server.createobject("adodb.recordset")
rs_whd_js.open sql_hd_js,conn,1,1
jls_whd=rs_whd_js(0)
rs_whd_js.close
set rs_whd_js=nothing
'未回单统计计数结束
'未回访统计计数开始
set rs_wsd_js=server.createobject("adodb.recordset")
rs_wsd_js.open sql_hh_js,conn,1,1
jls_whh=rs_wsd_js(0)
rs_wsd_js.close
set rs_wsd_js=nothing
'未回访统计计数结束
'超时单统计计数开始
set rs_csd_js=server.createobject("adodb.recordset")
rs_csd_js.open sql_csd_js,conn,1,1
jls_csd=rs_csd_js(0)
rs_csd_js.close
set rs_csd_js=nothing
'超时单统计计数结束
exec="select * from user "
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,1
%>
<%
rs.PageSize=20
pagecount=rs.PageCount
page=int(request.QueryString ("page"))
if page<=0 then page=1
if request.QueryString("page")="" then
page=1
end if
if not rs.eof then
rs.AbsolutePage = page
end if
%>
<style type="text/css">
<!--
.STYLE1 {font-size: 12px}
.STYLE20 {color: #9900FF}
.STYLE21 {color: #FF0000}
.STYLE22 {color: #006600}
.STYLE26 {color: #FF0066}
.STYLE30 {font-size: 12px; color: #000000; }
body {
margin-top: 5px;
}
.STYLE31 {
font-size: 24px;
font-weight: bold;
}
.STYLE32 {color: #000000}
-->
</style>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" /><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><span class="STYLE1"><span class="STYLE22">未派修:<a href="zibx_wsd.asp"><%=response.write(jls_wsd)%></a>;</span> <span class="STYLE8 STYLE20">未回单:<a href="zicl_wsd.asp"><%=response.write(jls_whd)%></a></span><span class="STYLE20">;</span> <span class="STYLE9 STYLE21">超时单:<%=response.write(jls_csd)%></span> <span class="STYLE30">未回访:<a href="hhcl_wsd.asp"><%=response.write(jls_whh)%></a></span> <span class="STYLE30">施工中工程:<a href="user_gc_2.asp"><%=response.write(jls_gc)%></a></span>
<% date_1=ya %>
</span></td>
<td><div align="right" class="STYLE30">本月统计：障碍总数: <%=response.write(jls_zs)%> ;超时:<span class="STYLE26"><%=response.write(jls_csl)%></span>;超时率:<span class="STYLE26"><%=response.write(Formatnumber(jls_csl/jls_zs*100))%></span>%</div></td>
</tr>
</table>
<form id="form1" name="form1" method="post" action="tj_whzl_find.asp">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<script language="JavaScript" src="calendar.js"></script>
<td height="26"><div align="left"><span class="STYLE1">查询日期：
<%cxrq_n1=session("cxrq_v1")
cxrq_n2=session("cxrq_v2")
if len(cxrq_n1)=0 then
cxrq_n1=Year(Date)&"-"&Month(Date)&"-1"
cxrq_n2=date()
end if %>
<input name="cxrq_1"id="cxrq_1" onFocus="calendar()" value="<%=cxrq_n1%>" size="17" maxlength="12">
至
<input name="cxrq_2" value="<%=cxrq_n2%>"id="cxrq_2" onFocus="calendar()" size="17" maxlength="12">
</span>
<input type="submit" name="Submit" value="提交">
</div>
<div align="center"></div> </td>
</tr>
</table>
</form>
<div align="center">
<span class="STYLE8 STYLE31">维 护 质 量 龙 虎 榜 </span> </div>
<table width="100%" border="2" cellspacing="0" bordercolor="#006600" style="border-collapse:collapse;" >
<tr align="center">
<td height="25" bgcolor="#CCCCCC" class="STYLE1"> </td>
<td height="25" colspan="3" bgcolor="#CCCCCC" class="STYLE1"><span class="STYLE30">障碍维护情况</span></td>
<td height="25" colspan="4" bgcolor="#CCCCCC" class="STYLE1">预约超时情况</td>
<td height="25" colspan="3" bgcolor="#CCCCCC" class="STYLE1">电话接听情况</td>
<td height="25" colspan="2" bgcolor="#CCCCCC" class="STYLE1"><span class="STYLE30">障碍维护质量</span></td>
</tr>
<tr align="center">
<td width="8%" height="25" bgcolor="#CCCCCC" class="STYLE1">姓名</td>
<td width="8%" height="25" bgcolor="#CCCCCC" class="STYLE1"><span class="STYLE30">障碍总数</span></td>
<td width="8%" height="25" bgcolor="#CCCCCC" class="STYLE1"><span class="STYLE30">障碍超时</span></td>
<td width="7%" height="25" bgcolor="#CCCCCC" class="STYLE1"><span class="STYLE30">超时率</span></td>
<td width="8%" height="25" bgcolor="#CCCCCC" class="STYLE1">预约总数</td>
<td width="7%" height="25" bgcolor="#CCCCCC" class="STYLE1">预约<span class="STYLE30">率</span></td>
<td width="8%" height="25" bgcolor="#CCCCCC" class="STYLE1">预约超时</td>
<td width="7%" height="25" bgcolor="#CCCCCC" class="STYLE1"><span class="STYLE30">超时率</span></td>
<td width="8%" bgcolor="#CCCCCC" class="STYLE1">电话关机</td>
<td width="8%" height="25" bgcolor="#CCCCCC" class="STYLE1">无人接听</td>
<td width="8%" bgcolor="#CCCCCC" class="STYLE1">电话接通率</td>
<td width="8%" bgcolor="#CCCCCC" class="STYLE1">障碍历时</td>
<td width="8%" height="25" bgcolor="#CCCCCC" class="STYLE1">平均历时</td>
</tr>
<tr align="center">
<td width="8%" height="26" bgcolor="#CCCCCC" class="STYLE1">合计</td>
<%
sql_tj_zs="select count(*) from user_bdb where 回单标志=True and 回单时间>date()-day(now)+1"
sql_tj_cs="select count(*) from user_bdb where 回单标志=True and 故障历时>故障时限 and 回单时间>date()-day(now)+1"
sql_tj_uzs="select count(*) from user_bdb where 回单标志=True and len(何时预约)>0 and 回单时间>date()-day(now)+1"
sql_tj_ucs="select count(*) from user_bdb where 回单标志=True and DateAdd('"&dd&"',30,派单时间)>何时预约 and 回单时间>date()-day(now)+1"
sql_tj_gj="select count(*) from user_bdb where 回单标志=True and 电话通知='电话已关机' and 回单时间>date()-day(now)+1"
sql_tj_wj="select count(*) from user_bdb where 回单标志=True and 电话通知='电话无人接听' and 回单时间>date()-day(now)+1"
sql_tj_zi="select sum(故障历时) from user_bdb where 回单标志=True and 回单时间>date()-day(now)+1"
if cxrq_n1<>"" or cxrq_n2<>"" then
sql_tj_zs="select count(*) from user_bdb where 回单标志=True and 回单时间>=#"&cxrq_n1&"# and 回单时间<=#"&cxrq_n2&"# "
sql_tj_cs="select count(*) from user_bdb where 回单标志=True and 回单时间>=#"&cxrq_n1&"# and 回单时间<=#"&cxrq_n2&"# and 故障历时>故障时限 "
sql_tj_uzs="select count(*) from user_bdb where 回单标志=True and 回单时间>=#"&cxrq_n1&"# and 回单时间<=#"&cxrq_n2&"# and len(何时预约)>0 "
sql_tj_ucs="select count(*) from user_bdb where 回单标志=True and 回单时间>=#"&cxrq_n1&"# and 回单时间<=#"&cxrq_n2&"# and DateAdd('"&dd&"',30,派单时间)>何时预约 "
sql_tj_gj="select count(*) from user_bdb where 回单标志=True and 电话通知='电话已关机' and 回单时间>=#"&cxrq_n1&"# and 回单时间<=#"&cxrq_n2&"#"
sql_tj_wj="select count(*) from user_bdb where 回单标志=True and 电话通知='电话无人接听' and 回单时间>=#"&cxrq_n1&"# and 回单时间<=#"&cxrq_n2&"#"
sql_tj_zi="select sum(故障历时) from user_bdb where 回单标志=True and 回单时间>=#"&cxrq_n1&"# and 回单时间<=#"&cxrq_n2&"# "
end if
set rs_tj_js=server.createobject("adodb.recordset")
rs_tj_js.open sql_tj_zs,conn,1,1
tj_zs=rs_tj_js(0)
rs_tj_js.close
set rs_tj_js=nothing
'本月障碍总数统计计数结束
set rs_tj_js=server.createobject("adodb.recordset")
rs_tj_js.open sql_tj_cs,conn,1,1
tj_csl=rs_tj_js(0)
rs_tj_js.close
set rs_tj_js=nothing
'超时率统计计数结束
set rs_tj_js=server.createobject("adodb.recordset")
rs_tj_js.open sql_tj_uzs,conn,1,1
tj_uzs=rs_tj_js(0)
rs_tj_js.close
set rs_tj_js=nothing
'本月预约总数统计计数结束
set rs_tj_js=server.createobject("adodb.recordset")
rs_tj_js.open sql_tj_ucs,conn,1,1
tj_ucs=rs_tj_js(0)
rs_tj_js.close
set rs_tj_js=nothing
'超时率统计计数结束
set rs_tj_js=server.createobject("adodb.recordset")
rs_tj_js.open sql_tj_zi,conn,1,1
tj_zi=rs_tj_js(0)
rs_tj_js.close
set rs_tj_js=nothing
'障碍历时统计计数结束
set rs_tj_js=server.createobject("adodb.recordset")
rs_tj_js.open sql_tj_gj,conn,1,1
tj_gj=rs_tj_js(0)
rs_tj_js.close
set rs_tj_js=nothing
'关机统计计数结束
set rs_tj_js=server.createobject("adodb.recordset")
rs_tj_js.open sql_tj_wj,conn,1,1
tj_wj=rs_tj_js(0)
rs_tj_js.close
set rs_tj_js=nothing
'无人接听统计计数结束%>
结果是统计结果不同：
未派修:1; 未回单:7; 超时单:3 未回访:36 施工中工程:1 本月统计：障碍总数: 20 ;超时:4;超时率:20.00%
维 护 质 量 龙 虎 榜
障碍维护情况 预约超时情况 电话接听情况 障碍维护质量
姓名 障碍总数 障碍超时 超时率 预约总数 预约率 预约超时 超时率 电话关机 无人接听 电话接通率 障碍历时 平均历时
合计 13 3 23.08 6 46.15 4+7 84.62 1 0 92 5294 407.23