re_overall.jsp
1.97 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
<%@ page import="com.alibaba.fastjson.JSON" %>
<%@ page import="com.engine.kq.timer.KQQueue" %>
<%@ page import="com.engine.kq.timer.KQTaskBean" %>
<%@ page import="com.engine.kq.wfset.util.SplitActionUtil" %>
<%@ page import="java.util.ArrayList" %>
<%@ page import="java.util.List" %>
<%@ page import="weaver.conn.RecordSet" %>
<%@ page import="weaver.general.Util" %>
<%@ page import="weaver.hrm.resource.ResourceComInfo" %>
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%
try {
String toDate = Util.null2String(request.getParameter("toDate"));
String fromDate = Util.null2String(request.getParameter("fromDate"));
if(fromDate.length() == 0){
out.println("param fromDate is null:<br/>");
return ;
}
if(toDate.length() == 0){
out.println("param toDate is null:<br/>");
return ;
}
ResourceComInfo rci = new ResourceComInfo();
RecordSet rs = new RecordSet();
while (rci.next()){
String resourceid = rci.getResourceid();
String sql_del = "delete from kq_flow_overtime where resourceid = "+resourceid+" and belongdate between '"+fromDate+"' and '"+toDate+"'";
out.print("sql_del:1::"+sql_del+"<br/>");
rs.executeUpdate(sql_del);
sql_del = "delete from kq_overtime_signtask where resourceid = "+resourceid+" and belongdate between '"+fromDate+"' and '"+toDate+"'";
rs.executeUpdate(sql_del);
out.print("sql_del:2::"+sql_del+"<br/>");
List<KQTaskBean> tasks = new ArrayList<>();
SplitActionUtil splitActionUtil = new SplitActionUtil();
splitActionUtil.pushOverTimeTasks(fromDate, toDate, resourceid,tasks);
out.print(JSON.toJSON(tasks));
if(!tasks.isEmpty()){
KQQueue.writeTasks(tasks);
}
}
} catch (Exception e) {
e.printStackTrace();
out.print(e.getMessage());
}
%>