解决方案 »
- struts2 频繁调用某个action的一个方法写日志带来的性能问题?
- JSP导出word文档后保存的问题【在线等待】
- 请教一个多表连接的问题 急!
- 关于正则表达式问题
- jetty作为嵌入式的服务器时报错
- 关于生成xml问题?我很急望各位帮帮我。。。。
- 200分。。。。那里有Programming Jakarta Struts(全) 下载?
- 关于权限设置问题
- public static final String Driver=getServletConfig().getInitParameter("Driver"); 为什么报方法servletconfig()不能构成?
- Release Version 和 Integration Version 是什么意思和区别?
- jsp空间 javabean 访问不了 提示 The value for the useBean class attribute is
- EXTJS grid修改后用户信息后,页面没有显示修改后的数据 ?? 求救
FROM (SELECT E.CENTERNAME,
E.AREANAME,
E.TEAMNAME,
(SELECT COUNT(1)
FROM EKBS_ONLINE O
WHERE O.TEAMNAME = E.TEAMNAME
AND '0' <> NVL(O.TEAMNAME, '0')
AND '0' <> NVL(O.AREANAME, '0')
AND '0' <> NVL(O.TEAMNAME, '0')
AND LOGINDATE = TRUNC(SYSDATE)
AND 8 > TO_NUMBER(TO_CHAR(LOGINONTIME, 'hh24'))
AND ('0' = NVL(TO_CHAR(O.LOGINOUTTIME, 'hh24'), '0') OR
8 <= TO_NUMBER(TO_CHAR(LOGINOUTTIME, 'hh24')))) AS EIGHT,
(SELECT COUNT(1)
FROM EKBS_ONLINE O
WHERE O.TEAMNAME = E.TEAMNAME
AND '0' <> NVL(O.TEAMNAME, '0')
AND '0' <> NVL(O.AREANAME, '0')
AND '0' <> NVL(O.TEAMNAME, '0')
AND LOGINDATE = TRUNC(SYSDATE)
AND 9 > TO_NUMBER(TO_CHAR(LOGINONTIME, 'hh24'))
AND ('0' = NVL(TO_CHAR(O.LOGINOUTTIME, 'hh24'), '0') OR
9 <= TO_NUMBER(TO_CHAR(LOGINOUTTIME, 'hh24')))) AS NINE,
(SELECT COUNT(1)
FROM EKBS_ONLINE O
WHERE O.TEAMNAME = E.TEAMNAME
AND '0' <> NVL(O.TEAMNAME, '0')
AND '0' <> NVL(O.AREANAME, '0')
AND '0' <> NVL(O.TEAMNAME, '0')
AND LOGINDATE = TRUNC(SYSDATE)
AND 10 > TO_NUMBER(TO_CHAR(LOGINONTIME, 'hh24'))
AND ('0' = NVL(TO_CHAR(O.LOGINOUTTIME, 'hh24'), '0') OR
10 <= TO_NUMBER(TO_CHAR(LOGINOUTTIME, 'hh24')))) AS TEN,
(SELECT COUNT(1)
FROM EKBS_ONLINE O
WHERE O.TEAMNAME = E.TEAMNAME
AND '0' <> NVL(O.TEAMNAME, '0')
AND '0' <> NVL(O.AREANAME, '0')
AND '0' <> NVL(O.TEAMNAME, '0')
AND LOGINDATE = TRUNC(SYSDATE)
AND 11 > TO_NUMBER(TO_CHAR(LOGINONTIME, 'hh24'))
AND ('0' = NVL(TO_CHAR(O.LOGINOUTTIME, 'hh24'), '0') OR
11 <= TO_NUMBER(TO_CHAR(LOGINOUTTIME, 'hh24')))) AS ELEVEN,
(SELECT COUNT(1)
FROM EKBS_ONLINE O
WHERE O.TEAMNAME = E.TEAMNAME
AND '0' <> NVL(O.TEAMNAME, '0')
AND '0' <> NVL(O.AREANAME, '0')
AND '0' <> NVL(O.TEAMNAME, '0')
AND LOGINDATE = TRUNC(SYSDATE)
AND 12 > TO_NUMBER(TO_CHAR(LOGINONTIME, 'hh24'))
AND ('0' = NVL(TO_CHAR(O.LOGINOUTTIME, 'hh24'), '0') OR
12 <= TO_NUMBER(TO_CHAR(LOGINOUTTIME, 'hh24')))) AS TWELVE,
(SELECT COUNT(1)
FROM EKBS_ONLINE O
WHERE O.TEAMNAME = E.TEAMNAME
AND '0' <> NVL(O.TEAMNAME, '0')
AND '0' <> NVL(O.AREANAME, '0')
AND '0' <> NVL(O.TEAMNAME, '0')
AND LOGINDATE = TRUNC(SYSDATE)
AND 13 > TO_NUMBER(TO_CHAR(LOGINONTIME, 'hh24'))
AND ('0' = NVL(TO_CHAR(O.LOGINOUTTIME, 'hh24'), '0') OR
13 <= TO_NUMBER(TO_CHAR(LOGINOUTTIME, 'hh24')))) AS THIRTEEN,
(SELECT COUNT(1)
FROM EKBS_ONLINE O
WHERE O.TEAMNAME = E.TEAMNAME
AND '0' <> NVL(O.TEAMNAME, '0')
AND '0' <> NVL(O.AREANAME, '0')
AND '0' <> NVL(O.TEAMNAME, '0')
AND LOGINDATE = TRUNC(SYSDATE)
AND 14 > TO_NUMBER(TO_CHAR(LOGINONTIME, 'hh24'))
AND ('0' = NVL(TO_CHAR(O.LOGINOUTTIME, 'hh24'), '0') OR
14 <= TO_NUMBER(TO_CHAR(LOGINOUTTIME, 'hh24')))) AS FOURTEEN,
(SELECT COUNT(1)
FROM EKBS_ONLINE O
WHERE O.TEAMNAME = E.TEAMNAME
AND '0' <> NVL(O.TEAMNAME, '0')
AND '0' <> NVL(O.AREANAME, '0')
AND '0' <> NVL(O.TEAMNAME, '0')
AND LOGINDATE = TRUNC(SYSDATE)
AND 15 > TO_NUMBER(TO_CHAR(LOGINONTIME, 'hh24'))
AND ('0' = NVL(TO_CHAR(O.LOGINOUTTIME, 'hh24'), '0') OR
15 <= TO_NUMBER(TO_CHAR(LOGINOUTTIME, 'hh24')))) AS FIFTEEN,
(SELECT COUNT(1)
FROM EKBS_ONLINE O
WHERE O.TEAMNAME = E.TEAMNAME
AND '0' <> NVL(O.TEAMNAME, '0')
AND '0' <> NVL(O.AREANAME, '0')
AND '0' <> NVL(O.TEAMNAME, '0')
AND LOGINDATE = TRUNC(SYSDATE)
AND 16 > TO_NUMBER(TO_CHAR(LOGINONTIME, 'hh24'))
AND ('0' = NVL(TO_CHAR(O.LOGINOUTTIME, 'hh24'), '0') OR
16 <= TO_NUMBER(TO_CHAR(LOGINOUTTIME, 'hh24')))) AS SIXTEEN,
(SELECT COUNT(1)
FROM EKBS_ONLINE O
WHERE O.TEAMNAME = E.TEAMNAME
AND '0' <> NVL(O.TEAMNAME, '0')
AND '0' <> NVL(O.AREANAME, '0')
AND '0' <> NVL(O.TEAMNAME, '0')
AND LOGINDATE = TRUNC(SYSDATE)
AND 17 > TO_NUMBER(TO_CHAR(LOGINONTIME, 'hh24'))
AND ('0' = NVL(TO_CHAR(O.LOGINOUTTIME, 'hh24'), '0') OR
17 <= TO_NUMBER(TO_CHAR(LOGINOUTTIME, 'hh24')))) AS SEVENTEEN,
(SELECT COUNT(1)
FROM EKBS_ONLINE O
WHERE O.TEAMNAME = E.TEAMNAME
AND '0' <> NVL(O.TEAMNAME, '0')
AND '0' <> NVL(O.AREANAME, '0')
AND '0' <> NVL(O.TEAMNAME, '0')
AND LOGINDATE = TRUNC(SYSDATE)
AND 18 > TO_NUMBER(TO_CHAR(LOGINONTIME, 'hh24'))
AND ('0' = NVL(TO_CHAR(O.LOGINOUTTIME, 'hh24'), '0') OR
18 <= TO_NUMBER(TO_CHAR(LOGINOUTTIME, 'hh24')))) AS EIGHTEEN,
(SELECT COUNT(1)
FROM EKBS_ONLINE O
WHERE O.TEAMNAME = E.TEAMNAME
AND '0' <> NVL(O.TEAMNAME, '0')
AND '0' <> NVL(O.AREANAME, '0')
AND '0' <> NVL(O.TEAMNAME, '0')
AND LOGINDATE = TRUNC(SYSDATE)
AND 19 > TO_NUMBER(TO_CHAR(LOGINONTIME, 'hh24'))
AND ('0' = NVL(TO_CHAR(O.LOGINOUTTIME, 'hh24'), '0') OR
19 <= TO_NUMBER(TO_CHAR(LOGINOUTTIME, 'hh24')))) AS NINETEEN,
('-') AS TWENTY
FROM EKBS_ONLINE E
WHERE LOGINDATE = TRUNC(SYSDATE)
AND '0' <> NVL(E.TEAMNAME, '0')
AND '0' <> NVL(E.AREANAME, '0')
AND '0' <> NVL(E.CENTERNAME, '0')
GROUP BY E.TEAMNAME, E.AREANAME, E.CENTERNAME
ORDER BY E.TEAMNAME)
WHERE ROWNUM <= 100
//n 检测鼠标相对于用户屏幕的水平位置 - 网页正文部分左:求出鼠标在当前窗口上的水平位置(参照:当前窗口右上角为0、0坐标)
//m 网页正文全文宽 20这个值是指关闭按钮的宽度
//b=false,鼠标在当前窗口内 水平坐标
//b= true;鼠标在当前窗口外 水平坐标
//y 垂直坐标 y>0鼠标在当前窗口内 ;y<0 鼠标在当前窗口外
//window.event.altKey 当alt键按下时,值为 TRUE ,否则为 FALSE 。只读。
function onunload_handler(){
// IE6 浏览器执行 判断当前浏览器版本 begin
if (window.ActiveXObject) {
var ua = navigator.userAgent.toLowerCase();
var ie=ua.match(/msie ([\d.]+)/)[1]
if(ie==6.0){
if(window.event.clientX <= 0 || window.event.clientY <=0){
$.ajax({
type: "POST",
url: "${ctx}/monitor/closeBrowser.do",
async:false,
success: function(){
}
});
}else {
//刷新
}
}
}
// IE6 浏览器执行 判断当前浏览器版本 end
var n = window.event.screenX - window.screenLeft;
var m = document.documentElement.scrollWidth-20;
var b = n > m;
var y = window.event.clientY;
//关闭而非刷新
if (b && y < 0 || window.event.altKey)
{
$.ajax({
type: "POST",
url: "${ctx}/monitor/closeBrowser.do",
async:false,
success: function(){
}
});
}
}
//点击登出按钮
function closeWindows(){
$.ajax({
type: "POST",
url: "${ctx}/monitor/closeBrowser.do",
async:false,
success: function(){
}
});
window.close();
}