excelAjaxData.jsp
5.38 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
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ page import="org.json.JSONObject" %>
<%@ page import="net.sf.json.JSONArray"%>
<%@ page import="weaver.general.Util" %>
<%@ page import="weaver.hrm.User" %>
<%@ page import="weaver.hrm.HrmUserVarify" %>
<%@ page import="java.util.*" %>
<jsp:useBean id="ExcelLayoutManager" class="weaver.workflow.exceldesign.ExcelLayoutManager" scope="page" />
<jsp:useBean id="HtmlLayoutOperate" class="weaver.workflow.exceldesign.HtmlLayoutOperate" scope="page" />
<jsp:useBean id="FormatFieldValue" class="weaver.workflow.exceldesign.FormatFieldValue" scope="page" />
<jsp:useBean id="FinancialElement" class="weaver.workflow.field.FinancialElement" scope="page" />
<jsp:useBean id="DetailRowMergeManager" class="weaver.workflow.exceldesign.DetailRowMergeManager" scope="page" />
<%
User user = HrmUserVarify.getUser(request, response);
String src=Util.null2String(request.getParameter("src"));
if("getMainFields".equals(src)){
ExcelLayoutManager.setRequest(request);
ExcelLayoutManager.setUser(user);
JSONObject json = new org.json.JSONObject();
json =ExcelLayoutManager.getMainFields();
out.print(json);
}else if("getDetailFields".equals(src)){
ExcelLayoutManager.setRequest(request);
ExcelLayoutManager.setUser(user);
JSONObject json = new org.json.JSONObject();
json = ExcelLayoutManager.getDetailFields();
out.print(json);
}else if("getWfNodes".equals(src)){
ExcelLayoutManager.setRequest(request);
ExcelLayoutManager.setUser(user);
JSONObject json = new org.json.JSONObject();
json = ExcelLayoutManager.getWfNodes();
out.print(json);
}else if("getFieldClassify".equals(src)){
int formid = Util.getIntValue(request.getParameter("formid"),0);
int isbill = Util.getIntValue(request.getParameter("isbill"));
Map<String,String> map = ExcelLayoutManager.getFieldClassify(formid, isbill);
net.sf.json.JSONObject json = new net.sf.json.JSONObject().fromObject(map);
out.print(json);
}else if("formatToDate".equals(src)){
int languageid = Util.getIntValue(request.getParameter("languageid"),-1);
String formatVal=FormatFieldValue.FormatToDate(Util.null2String(request.getParameter("realVal")),Util.getIntValue(request.getParameter("formatPattern"),-1));
if(languageid == 8){
formatVal=FormatFieldValue.FormatToDate(Util.null2String(request.getParameter("realVal")),Util.getIntValue(request.getParameter("formatPattern"),-1),languageid);
}
out.print(formatVal);
}else if("formatToTime".equals(src)){
String formatVal=FormatFieldValue.FormatToTime(Util.null2String(request.getParameter("realVal")),Util.getIntValue(request.getParameter("formatPattern"),-1));
out.print(formatVal);
}else if("formatToPercent".equals(src)){
String formatVal=FormatFieldValue.FormatToPercent(Util.null2String(request.getParameter("realVal")),Util.getIntValue(request.getParameter("decimals"),-1));
out.print(formatVal);
}else if("formatToScience".equals(src)){
String formatVal=FormatFieldValue.FormatToScience(Util.null2String(request.getParameter("realVal")),Util.getIntValue(request.getParameter("decimals"),-1));
out.print(formatVal);
}else if("formatToSpecial".equals(src)){
String formatVal=FormatFieldValue.FormatToSpecial(Util.null2String(request.getParameter("realVal")),Util.getIntValue(request.getParameter("formatPattern"),-1));
out.print(formatVal);
}else if("formatToMoneyUpper".equals(src)){
String formatVal=FormatFieldValue.FormatToMoneyUpper(Util.null2String(request.getParameter("realVal")));
out.print(formatVal);
}else if("transFinancialVal".equals(src)){
String fieldval=request.getParameter("fieldval");
char[] valArr=FinancialElement.getValCharArr(fieldval);
out.print(new String(valArr));
}else if("getHistoryLayout".equals(src)){
String wfid = Util.null2String(request.getParameter("wfid"));
String nodeid = Util.null2String(request.getParameter("nodeid"));
int layouttype = Util.getIntValue(request.getParameter("layouttype"));
int languageid = Util.getIntValue(request.getParameter("languageid"));
List historylist = HtmlLayoutOperate.getHistoryLayout(wfid, nodeid, request.getParameter("formid"), request.getParameter("isbill"), layouttype, languageid);
JSONArray result = new net.sf.json.JSONArray();
out.print(result.fromObject(historylist));
}else if("deleteLayout".equals(src)){
int layoutid = Util.getIntValue(request.getParameter("layoutid"));
String result = HtmlLayoutOperate.deleteLayout(layoutid, user.getUID());
out.print(result);
}else if("setLayoutToActive".equals(src)){
int wfid = Util.getIntValue(request.getParameter("wfid"));
int nodeid = Util.getIntValue(request.getParameter("nodeid"));
int formid = Util.getIntValue(request.getParameter("formid"));
int isbill = Util.getIntValue(request.getParameter("isbill"));
int layouttype = Util.getIntValue(request.getParameter("layouttype"));
int layoutid = Util.getIntValue(request.getParameter("layoutid"));
String result = HtmlLayoutOperate.setLayoutToActive(wfid, nodeid, formid, isbill, layouttype, layoutid);
out.print(result);
}else if("saveChooseLayout".equals(src)){
HtmlLayoutOperate.setRequest(request);
String result = HtmlLayoutOperate.saveLayout_choose();
out.print(result);
}else if("saveDetailMergeInfo".equals(src)){
int nodeid = Util.getIntValue(request.getParameter("nodeid"));
int groupid = Util.getIntValue(request.getParameter("groupid"));
String mergeFields = Util.null2String(request.getParameter("mergeFields"));
out.print(DetailRowMergeManager.saveMergeInfo(nodeid, groupid, mergeFields));
}
%>