timelineUrlTempletAction.jsp
2.83 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
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ page import="weaver.general.Util"%>
<%@ page import="net.sf.json.JSONObject"%>
<%@ page import="net.sf.json.JSONArray"%>
<%@ page import="com.weaver.formmodel.mobile.manager.MobileUserInit"%>
<%@ page import="weaver.hrm.User"%>
<%@ page import="weaver.conn.RecordSet"%>
<%@ page import="weaver.general.SplitPageUtil"%>
<%@ page import="weaver.general.SplitPageParaBean"%>
<%
/*在移动端这样获取当前用户*/
User user = MobileUserInit.getUser(request, response);
if(user == null){
return;
}
int pageNo = Util.getIntValue(request.getParameter("pageNo"), 1);
int pageSize = Util.getIntValue(request.getParameter("pageSize"), 10);
String timefieldname = Util.null2String(request.getParameter("timefieldname"));
String timefilter = Util.null2String(request.getParameter("timefilter"));
String searchKey = Util.null2String(request.getParameter("searchKey"));
String sql = "select id,lastname,mobile,createdate,created from hrmresource";
/*先通过时间字段聚合进行分页，标准代码*/
SplitPageParaBean spp = new SplitPageParaBean();
String groupSql = timefieldname;
String sqlWhere = "1=1";
if(!"".equals(timefilter)){
groupSql += " having " + timefieldname + " in ('" + timefilter + "')";
}
if(!"".equals(searchKey)){
sqlWhere += " and upper(lastname) like '%" + searchKey.toUpperCase() + "%' ";
}
spp.setSqlFrom("("+sql+") t1");
spp.setPrimaryKey("id");
spp.setSqlWhere(sqlWhere);
spp.setBackFields(timefieldname);
spp.setSqlGroupBy(groupSql);
spp.setSqlOrderBy(timefieldname);
spp.setSortWay(spp.DESC);
SplitPageUtil spu = new SplitPageUtil();
spu.setSpp(spp);
RecordSet rs = spu.getCurrentPageRs(pageNo,pageSize);
int totalSize = spu.getRecordCount();
/*通过分页之后的时间字段值作为条件筛选出需要的数据，标准代码*/
StringBuilder timefieldFilter = new StringBuilder();
while(rs.next()){
timefieldFilter.append("'" + rs.getString(timefieldname) + "',");
}
if(timefieldFilter.length() > 0){
sqlWhere += " and " + timefieldname + " in (" + timefieldFilter.substring(0, timefieldFilter.length() - 1) + ")";
spp.setSqlWhere(sqlWhere);
} else {
spp.setSqlWhere("1!=1");
}
spp.setBackFields("*");
spp.setSqlGroupBy("");
spp.setSqlOrderBy("");
spu.setSpp(spp);
rs = spu.getAllRs();
/*将查询结果按照 字段名作为key，字段值作为value 动态封装成json，标准代码*/
JSONArray datas = new JSONArray();
String[] columnNames = rs.getColumnName();
while(rs.next()){
JSONObject jsonObj = new JSONObject();
for(String columnName : columnNames){
jsonObj.put(columnName.toLowerCase(), Util.formatMultiLang(rs.getString(columnName)));
}
datas.add(jsonObj);
}
JSONObject resultObj = new JSONObject();
resultObj.put("totalSize", totalSize);
resultObj.put("datas", JSONArray.fromObject(datas));
out.print(resultObj);
%>