templateFieldAjax.jsp
5.12 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
<%@ page language="java" contentType="text/html; charset=utf-8" %>
<%@ page import="weaver.general.Util" %>
<%@ page import="weaver.systeminfo.SystemEnv" %>
<%@ page import="weaver.conn.RecordSet" %>
<%@ page import="java.util.*" %>
<%@ page import="net.sf.json.JSONArray" %>
<%@ page import="net.sf.json.JSONObject" %>
<%@ page import="weaver.hrm.*" %>
<%@ page import="weaver.workflow.form.FormManager" %>
<%@ page import="weaver.workflow.form.QuoteFieldManager" %>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="userDefinedBrowserTypeComInfo" class="weaver.workflow.field.UserDefinedBrowserTypeComInfo" scope="page" />
<%
User user = HrmUserVarify.getUser (request , response);
String method = Util.null2String(request.getParameter("method"));
if("settemplate".equals(method)){
String tablename = "mainfield".equals(Util.null2String(request.getParameter("beltype")))?"workflow_formdict":"workflow_formdictdetail";
String fieldid = Util.null2String(request.getParameter("fieldid"));
rs.executeSql("update "+tablename+" set istemplate='1' where id="+fieldid);
}else if("choosefield".equals(method)){
String src = Util.null2String(request.getParameter("src"));
String selIds = Util.null2String(request.getParameter("systemIds"));
String tablename = "1".equals(Util.null2String(request.getParameter("isdetail")))?"workflow_formdictdetail":"workflow_formdict";
String sql = "select * from "+tablename+" where istemplate='1'";
JSONArray jsonArr = new JSONArray();
if("src".equalsIgnoreCase(src)){
String search_fieldname = Util.null2String(request.getParameter("search_fieldname")).trim();
int search_fieldtype = Util.getIntValue(request.getParameter("search_fieldtype"));
if(!"".equals(search_fieldname))
sql += " and (fieldname like '%"+search_fieldname+"%' or description like '%"+search_fieldname+"%')";
if(search_fieldtype>0)
sql += " and fieldhtmltype="+search_fieldtype;
sql += " order by id";
rs.executeSql(sql);
while(rs.next()){
String fieldid = rs.getString("id");
if((","+selIds+",").indexOf(","+fieldid+",") == -1){
JSONObject tmp = new JSONObject();
String name = "<span class=\"fieldname\">"+rs.getString("fieldname");
String fielddescription = Util.null2String(rs.getString("description"));
if(!"".equals(fielddescription))
name += " ("+fielddescription+")";
name += "</span></br>";
name += QuoteFieldManager.transFieldType(Util.getIntValue(rs.getString("fieldhtmltype")), Util.getIntValue(rs.getString("type"),0), "-", user.getLanguage());
tmp.put("id", fieldid);
tmp.put("name", name);
jsonArr.add(tmp);
}
}
}else if("dest".equalsIgnoreCase(src)){
}
JSONObject json = new JSONObject();
json.put("currentPage", 1);
json.put("totalPage", 1);
json.put("mapList", jsonArr.toString());
out.println(json.toString());
}else if("getfieldinfo".equals(method)){
String tablename = "1".equals(request.getParameter("isdetail"))?"workflow_formdictdetail":"workflow_formdict";
String fieldids = Util.null2String(request.getParameter("fieldids"));
RecordSet rs1 = new RecordSet();
List<Map<String,String>> fieldlist = new ArrayList<Map<String,String>>();
String[] fieldArr = fieldids.split(",");
String[] columnArr = new String[]{"id","fieldname","fielddbtype","fieldhtmltype","type","description","textheight","imgheight","imgwidth","qfws","textheight_2","fieldshowtypes"};
Map fq_map = FormManager.getRightAttr(user.getLanguage());
for(String fieldid : fieldArr){ //保证顺序循环查询
rs.executeSql("select * from "+tablename+" where id="+fieldid);
if(!rs.next()) continue;
Map<String,String> fieldmap = new HashMap<String,String>();
for(String column : columnArr){
fieldmap.put(column, Util.null2String(rs.getString(column)));
}
if("3".equals(fieldmap.get("fieldhtmltype"))){ //浏览按钮
int type = Util.getIntValue(rs.getString("type"));
if(type == 161 || type == 162){
fieldmap.put("custombrowsername", userDefinedBrowserTypeComInfo.getName(rs.getString("fielddbtype")));
}else if(type == 165 || type == 166 || type == 167 || type == 168){ //分权属性
String fq_ids[] = Util.null2String(rs.getString("textheight_2")).split(",");
String fqdefaultattr = "";
for(int k=0; k<fq_ids.length;k++){
if(fq_ids[k].equals("0") || fq_ids[k].equals(""))
continue;
fqdefaultattr += ","+fq_map.get(fq_ids[k]);
}
if(fqdefaultattr.startsWith(",")) fqdefaultattr = fqdefaultattr.substring(1);
fieldmap.put("fqdefaultattr", fqdefaultattr);
}
}else if("7".equals(fieldmap.get("fieldhtmltype"))){ //特殊字段
rs1.executeSql("select * from workflow_specialfield where fieldid="+fieldid+" and isbill=0");
if(rs1.next()){
fieldmap.put("displayname", Util.null2String(rs1.getString("displayname")));
fieldmap.put("linkaddress", Util.null2String(rs1.getString("linkaddress")));
String descriptivetext = Util.null2String(rs1.getString("descriptivetext"));
descriptivetext = descriptivetext.replace("<br>","\n").replace(" "," ");
fieldmap.put("descriptivetext", descriptivetext);
}
}
fieldlist.add(fieldmap);
}
out.println(JSONArray.fromObject(fieldlist).toString());
}
%>