get_non_split_flow.jsp
2.67 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
<%@ page import="com.engine.kq.enums.KqSplitFlowTypeEnum" %>
<%@ page import="weaver.conn.RecordSet" %>
<%@ page import="weaver.general.Util" %>
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%
try {
String formid = Util.null2String(request.getParameter("formid"));
String workflowid = Util.null2String(request.getParameter("workflowid"));
if(formid.length() == 0){
out.println("param formid is null:<br/>");
return ;
}
int kqtype = Util.getIntValue(Util.null2String(request.getParameter("kqtype")));
if(kqtype < 0){
out.println("param kqtype is null:<br/>");
return ;
}
String tablename = "";
if(kqtype == KqSplitFlowTypeEnum.LEAVE.getFlowtype()){
tablename = KqSplitFlowTypeEnum.LEAVE.getTablename();
}else if(kqtype == KqSplitFlowTypeEnum.EVECTION.getFlowtype()){
tablename = KqSplitFlowTypeEnum.EVECTION.getTablename();
}else if(kqtype == KqSplitFlowTypeEnum.OUT.getFlowtype()){
tablename = KqSplitFlowTypeEnum.OUT.getTablename();;
}else if(kqtype == KqSplitFlowTypeEnum.OVERTIME.getFlowtype()){
tablename = KqSplitFlowTypeEnum.OVERTIME.getTablename();;
}else if(kqtype == KqSplitFlowTypeEnum.SHIFT.getFlowtype()){
tablename = KqSplitFlowTypeEnum.SHIFT.getTablename();;
}else if(kqtype == KqSplitFlowTypeEnum.OTHER.getFlowtype()){
tablename = KqSplitFlowTypeEnum.OTHER.getTablename();;
}else if(kqtype == KqSplitFlowTypeEnum.CARD.getFlowtype()){
tablename = KqSplitFlowTypeEnum.CARD.getTablename();;
}else if(kqtype == KqSplitFlowTypeEnum.LEAVEBACK.getFlowtype()){
tablename = KqSplitFlowTypeEnum.LEAVEBACK.getTablename();;
}else{
out.print("考勤流程没有找到对应类型:kqtype:"+kqtype);
return;
}
RecordSet rs = new RecordSet();
String sql = "select * from formtable_main_"+formid+" a left join workflow_requestbase b on a.requestid = b.requestid where b.currentnodetype=3 and a.requestid not in (select requestid from "+tablename+" ) ";
rs.executeQuery(sql);
int columncount;
columncount=rs.getColCounts();
while (rs.next()){
//添加列值
String msg = "";
for(int i=0;i<columncount;i++) {
String tempstr = rs.getColumnName(i + 1);
String tempVal = rs.getString(tempstr);
msg += tempstr+":"+tempVal+"---";
}
out.print(msg+"<br/><br/><br/><br/>");
}
}catch (Exception e){
e.printStackTrace();;
}
%>