ExcleFieldOperation.jsp
7.02 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
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
<%@page import="com.weaver.formmodel.util.StringHelper" %>
<%@page import="weaver.systeminfo.SystemEnv"%>
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ include file="/formmode/checkright4setting.jsp" %>
<%@ page import="weaver.general.*" %>
<%@page import="net.sf.json.*"%>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="rs2" class="weaver.conn.RecordSet" scope="page" />
<%
User user = HrmUserVarify.getUser(request, response);
String id = Util.null2String(request.getParameter("id"));
String modeid = Util.null2String(request.getParameter("modeid"));
String formid = Util.null2String(request.getParameter("formid"));
int field_rownum = Util.getIntValue(request.getParameter("field_rownum"),0);
String action = Util.null2String(request.getParameter("action"));
String selectid = Util.null2String(request.getParameter("selectid"));
String note = Util.null2String(request.getParameter("note"));
String sql = "";
String sqlwhere = " and modeid="+StringHelper.empty2Null(modeid)+" and formid="+StringHelper.empty2Null(formid)+" and ( fieldid in ('-1000','-1001','-1002') or exists (select 1 from workflow_billfield b where b.billid="+StringHelper.empty2Null(formid)+" and b.id=a.fieldid) )";
String sql2 = "select a.fieldid from mode_import_template a where 1=1 "+sqlwhere+" order by a.dsporder,a.fieldid ";
rs2.execute(sql2);//设置的字段
int count = rs2.getCounts();
sqlwhere = "";
if(count>0){
sqlwhere = " and exists (select 1 from mode_import_template c where c.fieldid=a.id and c.modeid="+StringHelper.empty2Null(modeid)+" and c.formid="+StringHelper.empty2Null(formid)+" )";
}
if(action.equals("getFieldIds")){
JSONObject object = new JSONObject();
boolean flag = false;
if(Util.getIntValue(id)<1){
sql = "insert into mode_excelField (modeid,formid,note) values ("+StringHelper.empty2Null(modeid)+","+StringHelper.empty2Null(formid)+",'"+note+"')";
rs.executeSql(sql);
sql = "select MAX(id) as id from mode_excelField";
rs.executeSql(sql);
if(rs.next()){
id = rs.getString("id");
for(int i=0;i<field_rownum;i++){
String fieldids = Util.null2String(request.getParameter("fieldids_"+i));
String tempselectid = Util.null2String(request.getParameter("selectid_"+i));
String selectvalue = Util.null2String(request.getParameter("selectvalue_"+i));
if(fieldids.equals("")){
continue;
}
sql = "insert into mode_excelFieldDetail(mainid,fieldid,selectids,selectvalue) values ("+StringHelper.empty2Null(id)+",'"+fieldids+"','"+tempselectid+"',"+StringHelper.empty2Null(selectvalue)+")";
rs.executeSql(sql);
flag = true;
}
object.accumulate("id",id);
object.accumulate("flag",flag);
}
}else{
sql = "update mode_excelField set note ='"+note+"' where id="+id;
rs.executeSql(sql);
sql = "delete mode_excelFieldDetail where mainid="+id;
rs.executeSql(sql);
for(int i=0;i<field_rownum;i++){
String fieldids = Util.null2String(request.getParameter("fieldids_"+i));
String tempselectid = Util.null2String(request.getParameter("selectid_"+i));
String selectvalue = Util.null2String(request.getParameter("selectvalue_"+i));
if(fieldids.equals("")){
continue;
}
sql = "insert into mode_excelFieldDetail(mainid,fieldid,selectids,selectvalue) values ("+id+",'"+fieldids+"','"+tempselectid+"',"+selectvalue+")";
rs.executeSql(sql);
flag = true;
}
object.accumulate("id",id);
object.accumulate("flag",flag);
}
sql = "select * from mode_DataBatchImport where modeid="+StringHelper.empty2Null(modeid);
rs.executeSql(sql);
if(rs.next()){
String tempid = rs.getString("id");
sql = "update mode_DataBatchImport set validateid="+StringHelper.empty2Null(id)+" where id="+StringHelper.empty2Null(tempid);
rs.executeSql(sql);
}else{
sql = "insert into mode_DataBatchImport (validateid,modeid) values("+StringHelper.empty2Null(id)+","+StringHelper.empty2Null(modeid)+")";
rs.executeSql(sql);
}
response.getWriter().write(object.toString());
} else if(action.equals("getSelectInfo")){
JSONObject object = new JSONObject();
JSONArray array = new JSONArray();
sql = "select * from workflow_SelectItem where fieldid="+StringHelper.empty2Null(selectid);
rs.executeSql(sql);
while(rs.next()){
JSONObject temp = new JSONObject();
String label = rs.getString("selectname");
String value = rs.getString("selectvalue");
temp.accumulate("label",label);
temp.accumulate("value",value);
array.add(temp);
}
object.accumulate("info",array);
response.reset();
response.getWriter().print(object.toString());
return;
}else if(action.equals("getSelectId")){
formid = request.getParameter("formid");
if(count>0){
//sql = "select a.id,a.detailtable,b.* from workflow_billfield a, htmllabelindex b where a.billid="+formid+" and fieldhtmltype=5 and b.id=a.fieldlabel "+sqlwhere;
sql = "select a.id,a.detailtable,b.* from workflow_billfield a, htmllabelindex b where a.billid="+StringHelper.empty2Null(formid)+" and fieldhtmltype=5 and b.id=a.fieldlabel "+sqlwhere;
}else{
sql="select a.id,a.detailtable,b.* ,c.needExcel from workflow_billfield a, htmllabelindex b, ModeFormFieldExtend c where c.needExcel = 1 and a.billid=c.formId "
+"and a.id=c.fieldId and a.billid="+StringHelper.empty2Null(formid)+" and fieldhtmltype=5 and b.id=a.fieldlabel union select a.id,a.detailtable,c.*,1 as needExcel from workflow_billfield a ,HtmlLabelindex c where "
+"a.billid="+StringHelper.empty2Null(formid)+" and c.id=a.fieldlabel and fieldhtmltype=5 and not exists (select 1 from ModeFormFieldExtend b where b.formid=a.billid and b.formid="+StringHelper.empty2Null(formid)+" and b.fieldId=a.id)";
}
JSONObject object = new JSONObject();
JSONArray array = new JSONArray();
rs.executeSql(sql);
while(rs.next()){
JSONObject temp = new JSONObject();
String tempfieldid = rs.getString("id");
String templabel = rs.getString("indexdesc");
String detailtable = rs.getString("detailtable");
if(detailtable != null && !detailtable.equals("")){
templabel = templabel + "("+ SystemEnv.getHtmlLabelName(126218, user.getLanguage()) +detailtable.substring(detailtable.length()-1,detailtable.length())+")";
}
temp.accumulate("tempfieldid",tempfieldid);
temp.accumulate("templabel",templabel);
array.add(temp);
}
object.accumulate("info",array);
response.getWriter().write(object.toString());
}else if(action.equals("clearAll")){
modeid = request.getParameter("modeid");
sql = "select * from mode_excelField where modeid="+StringHelper.empty2Null(modeid);
String mainid = "";
rs.executeSql(sql);
if(rs.next()){
mainid = rs.getString("id");
}
sql = "update mode_excelField set note='' where modeid="+StringHelper.empty2Null(modeid);
rs.executeSql(sql);
sql = "delete mode_excelFieldDetail where mainid="+StringHelper.empty2Null(mainid);
rs.executeSql(sql);
}
%>