WorkflowUnoperatorPersons.jsp
3.94 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
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ page import="weaver.general.Util" %>
<%@ page import="java.io.Writer"%>
<%@ page import="java.util.Set" %>
<%@ page import="java.util.HashSet" %>
<jsp:useBean id="rc" class="weaver.hrm.resource.ResourceComInfo" scope="page" />
<jsp:useBean id="cci" class="weaver.crm.Maint.CustomerInfoComInfo" scope="page" />
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<%
String requestid=Util.null2String(request.getParameter("requestid"));
String returntdid=Util.null2String(request.getParameter("returntdid"));
String returnStr="";
if(requestid.indexOf("-")==-1) {
//增加isremark字段，用来判断是否归档节点
//rs.executeSql("select distinct userid,usertype,agenttype,agentorbyagentid from workflow_currentoperator where (isremark in ('0','1','5','7','8','9') or (isremark='4' and viewtype=0)) and requestid = " + requestid);
rs.executeSql("select distinct userid,usertype,agenttype,agentorbyagentid,isremark,showorder,id,groupid from workflow_currentoperator where (isremark in ('0','1','5','7','8','9','11') or (isremark='4' and viewtype=0)) and requestid = " + requestid + " order by isremark,groupid,showorder asc ,id asc");
Set<String> sets = new HashSet<String>();
while (rs.next()) {
//去除重复
String key = rs.getString("userid") + ":" + rs.getString("usertype") + ":" + rs.getString("agenttype") + ":" + rs.getString("agentorbyagentid");
if(sets.contains(key)){
continue;
} else {
sets.add(key);
}
if (returnStr.equals("")) {
if (rs.getInt("usertype") == 0) {
//if(rs.getInt("agenttype")==2)
// returnStr += rc.getResourcename(rs.getString("agentorbyagentid"))+"->"+rc.getResourcename(rs.getString("userid"));
//else
// returnStr += rc.getResourcename(rs.getString("userid"));
if (rs.getInt("agenttype") == 2) {
returnStr += rc.getResourcename(rs.getString("agentorbyagentid")) + "->" + rc.getResourcename(rs.getString("userid"));
//判断是否被代理者,如果是，则不显示该记录
} else if (rs.getInt("agenttype") == 1 && rs.getInt("isremark") == 4) {
continue;
} else {
returnStr += rc.getResourcename(rs.getString("userid"));
}
} else {
returnStr += cci.getCustomerInfoname(rs.getString("userid"));
}
} else {
if (rs.getInt("usertype") == 0) {
//if(rs.getInt("agenttype")==2)
// returnStr += ","+rc.getResourcename(rs.getString("agentorbyagentid"))+"->"+rc.getResourcename(rs.getString("userid"));
//else
// returnStr += ","+rc.getResourcename(rs.getString("userid"));
if (rs.getInt("agenttype") == 2) {
returnStr += "," + rc.getResourcename(rs.getString("agentorbyagentid")) + "->" + rc.getResourcename(rs.getString("userid"));
//判断是否被代理者,如果是，则不显示该记录
} else if (rs.getInt("agenttype") == 1 && rs.getInt("isremark") == 4) {
continue;
} else {
returnStr += "," + rc.getResourcename(rs.getString("userid"));
}
} else {
//TD11591(人力资源与客户同时存在时、加','处理)
returnStr += "," + cci.getCustomerInfoname(rs.getString("userid"));
}
}
}
out.print(returnStr);
}else{
rs.executeSql("select distinct userid from ofs_todo_data where requestid="+requestid+" and isremark in(0,8,9) ");
while(rs.next()){
returnStr += rc.getResourcename(rs.getString("userid"))+",";
}
if(returnStr.endsWith(",")){
returnStr = returnStr.substring(0,returnStr.length()-1);
}
out.print(returnStr);
}
%>