ChartMeetingAbsent.jsp
4.9 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
<!DOCTYPE HTML>
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ page import="weaver.general.Util" %>
<%@ page import="java.util.*" %>
<%@ page import="net.sf.json.JSONArray" %>
<%@ include file="/systeminfo/init_wev8.jsp" %>
<jsp:useBean id="SystemLogItemTypeComInfo" class="weaver.systeminfo.SystemLogItemTypeComInfo" scope="page" />
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<%
boolean isLogView = HrmUserVarify.checkUserRight("LogView:View", user);
if(!isLogView) {
response.sendRedirect("/notice/noright.jsp") ;
return ;
}
String relatedname = java.net.URLDecoder.decode(Util.null2String(request.getParameter("relatedname")));
String itemname = java.net.URLDecoder.decode(Util.null2String(request.getParameter("itemname")));
String fromdate = Util.null2String(request.getParameter("fromdate")) ;
String todate = Util.null2String(request.getParameter("todate")) ;
String doccreatedateselect = Util.null2String(request.getParameter("doccreatedateselect"));
if(doccreatedateselect.equals(""))doccreatedateselect="1";
if(!doccreatedateselect.equals("") && !doccreatedateselect.equals("0") && !doccreatedateselect.equals("6")){
fromdate = TimeUtil.getDateByOption(doccreatedateselect,"0");
todate = TimeUtil.getDateByOption(doccreatedateselect,"1");
}
String currentuser = Util.null2String(request.getParameter("currentuser"));
//System.out.println("current::"+currentuser);
if(currentuser.equals("")){
currentuser = ""+user.getUID();
}
int operatesmalltype = Util.getIntValue(request.getParameter("operatesmalltype"),0);//0: 维护日志 1：操作日志
String sqlWhere = " where sml.operateItem = sli.itemId and sli.itemid != 60 ";
if(operatesmalltype==1){
sqlWhere += " and sml.operatesmalltype=1 ";
}else{
sqlWhere += " and (sml.operatesmalltype!=1 or sml.operatesmalltype is null) ";
}
//System.out.println(relatedname);
if(!relatedname.equals("")){
sqlWhere += " and relatedName like '%"+relatedname+"%'";
}
if(!itemname.equals("")){
sqlWhere += " and itemdesc like '%"+itemname+"%'";
}
if(!"-1".equals(currentuser)){
sqlWhere += " and sml.operateuserid="+currentuser;
}
if(!"".equals(fromdate)){
sqlWhere += " and sml.operatedate >= '"+fromdate+"'";
}
if(!"".equals(todate)){
sqlWhere += " and sml.operatedate <= '"+todate+"'";
}
String absentSql = "select COUNT(*) as total, sli.typeid from SysMaintenanceLog sml,SystemLogItem sli "+
sqlWhere +
"group by sli.typeid order by total desc";
rs.executeSql(absentSql);
//System.out.println("absentSql:"+absentSql);
Map map=null;
List list=new ArrayList();
String name="";
String typeid = "";
int total = 0;
while(rs.next()){
map= new HashMap();
typeid = Util.null2String(rs.getString("typeid"));
if(typeid.equals(""))continue;
total = rs.getInt("total");
if(total==0)continue;
map.put("name",SystemLogItemTypeComInfo.getSystemLogItemlabelname(typeid,""+user.getLanguage()+"+"+operatesmalltype));
map.put("data",new int[]{total});
list.add(map);
}
String absentJsonStr=JSONArray.fromObject(list).toString();
%>
<HTML>
<HEAD>
</HEAD>
<BODY width=100% height=100%>
<div id="AbsentDiv" style="margin: 5 auto;margin-top:10px; min-width: 400px; height: 210px;"></div>
</BODY>
<script type="text/javascript" src="/js/highcharts/highcharts_wev8.js"></script>
<script type="text/javascript" src="/js/highcharts/modules/no-data-to-display_wev8.js"></script>
<SCRIPT LANGUAGE="JavaScript">
var isInternetExplorer = navigator.userAgent.indexOf('MSIE') != -1;
var jsonStr='<%=absentJsonStr%>';
var jsonData=eval('('+jsonStr+')');
if(isInternetExplorer){
setTimeout('showAbsentDiv()',800);
}else{
setTimeout('showAbsentDiv()',10);
}
function showAbsentDiv(){
$('#AbsentDiv').highcharts({
chart: {
type: 'column',
//borderColor: '#DADADA',
borderWidth:0
},
title: {
text: '',// 会议+缺席+次数+统计+排名',
style: {
color: '#000000',
fontSize: '24px'
}
},
tooltip:{
headerFormat: '<span style="font-size: 10px">{point.key}</span>',
pointFormat: '<span style="color:{series.color}">{series.name}</span>: <b>{point.y}</b><br/>'
},
plotOptions: {
column: {
pointWidth: 10
}
},
xAxis: {
categories: [' ']
},
yAxis: {
min: 0,
tickPixelInterval:30,
title: {
text: ' '
},
allowDecimals:false
},
credits: {
enabled: false
},
lang: {
noData: "<%=SystemEnv.getHtmlLabelName(26161,user.getLanguage())+SystemEnv.getHtmlLabelName(563,user.getLanguage()) %>" //没有 + 数据
},
series:jsonData
});
}
</SCRIPT>
</HTML>