operation.jsp
6 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
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ page import="weaver.general.Util" %>
<%@ page import="weaver.file.FileUpload" %>
<%@ include file="/systeminfo/init_wev8.jsp" %>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="hpsu" class="weaver.homepage.style.HomepageStyleUtil" scope="page"/>
<%
String method = Util.null2String(request.getParameter("method"));
int templateId = Util.getIntValue(request.getParameter("templateId"));
int subCompanyId = Util.getIntValue(request.getParameter("subCompanyId"));
String templateName = Util.null2String(request.getParameter("templateName"));
String templateTitle = Util.null2String(request.getParameter("templateTitle"));
int extendtempletid = Util.getIntValue(request.getParameter("extendtempletid"));
int extandHpThemeId = Util.getIntValue(request.getParameter("extandHpThemeId"), 0);
String sbmtskvToStr = Util.null2String(request.getParameter("sbmtskvToStr"));
String islock = Util.null2String(request.getParameter("themeLock"));
String[] themeArray = sbmtskvToStr.split(",");
if (themeArray == null) {
themeArray = new String[0];
}
String instLock = "";
String sql="";
if("edit".equals(method)){
if(extandHpThemeId == 0){
sql=new StringBuffer("insert into extandHpTheme(templateId, subCompanyId) values (")
.append(templateId).append(", ").append(subCompanyId).append(")").toString();
rs.executeSql(sql);
rs.executeSql("select max(id) from extandHpTheme");
if(rs.next()) {
extandHpThemeId = rs.getInt(1);
}
for (int i=0; i<themeArray.length; i++) {
String sbmts = themeArray[i];
String sbmtsIsOpen = Util.null2String(request.getParameter(sbmts + "isopen"));
if (sbmtsIsOpen == null || sbmtsIsOpen.equals("")) {
sbmtsIsOpen = "0";
}
String[] tsarry = sbmts.split("-");
String theme = tsarry[0];
String skin = tsarry[1];
if (sbmts.equals(islock)) {
instLock = "1";
} else {
instLock = "0";
}
rs.execute("insert into extandHpThemeItem(extandHpThemeId, theme, skin, isopen, islock) values(" + extandHpThemeId + ",'" + theme + "', '" + skin + "'," + sbmtsIsOpen + "," + instLock + ")");
}
} else {
for (int i=0; i<themeArray.length; i++) {
String sbmts = themeArray[i];
String sbmtsIsOpen = Util.null2String(request.getParameter(sbmts + "isopen"));
if (sbmtsIsOpen.equals("")) {
sbmtsIsOpen = "0";
}
String[] tsarry = sbmts.split("-");
if (tsarry != null && tsarry.length == 2) {
String theme = tsarry[0];
String skin = tsarry[1];
if (sbmts.equals(islock)) {
instLock = "1";
} else {
instLock = "0";
}
rs.execute("select extandHpThemeId from extandHpThemeItem where extandHpThemeId=" + extandHpThemeId + " and theme='" + theme.trim() + "' and skin='" + skin.trim() + "'");
if (rs.next()) {
sql = "update extandHpThemeItem set isopen=" + sbmtsIsOpen + ", islock=" + instLock + " where extandHpThemeId=" + extandHpThemeId + " and theme='" + theme + "' and skin='" + skin + "'";
} else {
sql = "insert into extandHpThemeItem(extandHpThemeId, theme, skin, isopen, islock) values(" + extandHpThemeId + ",'" + theme + "', '" + skin + "'," + sbmtsIsOpen + "," + instLock + ")";
}
rs.executeSql(sql);
}
}
}
sql = "update SystemTemplate set extendtempletid="+extendtempletid+",extendtempletvalueid=" + extandHpThemeId + " where id=" + templateId;
rs.executeSql(sql);
response.sendRedirect("setting.jsp?templateId="+templateId+"&subCompanyId="+subCompanyId+"&extendtempletid="+extendtempletid);
} else if("saveas".equals(method)){
sql=new StringBuffer("insert into extandHpTheme(templateId, subCompanyId) values (")
.append(templateId).append(", ").append(subCompanyId).append(")").toString();
rs.executeSql(sql);
rs.executeSql("select max(id) from extandHpTheme");
if(rs.next()) {
extandHpThemeId = rs.getInt(1);
}
for (int i=0; i<themeArray.length; i++) {
String sbmts = themeArray[i];
String sbmtsIsOpen = Util.null2String(request.getParameter(sbmts + "isopen"));
if (sbmtsIsOpen == null || sbmtsIsOpen.equals("")) {
sbmtsIsOpen = "0";
}
String[] tsarry = sbmts.split("-");
String theme = tsarry[0];
String skin = tsarry[1];
if (sbmts.equals(islock)) {
instLock = "1";
} else {
instLock = "0";
}
rs.execute("insert into extandHpThemeItem(extandHpThemeId, theme, skin, isopen, islock) values(" + extandHpThemeId + ",'" + theme + "', '" + skin + "'," + sbmtsIsOpen + "," + instLock + ")");
}
sql = "INSERT INTO SystemTemplate (templateName,companyId,logo,topBgColor,topBgImage,toolbarBgColor,toolbarBgImage,leftbarBgColor,leftbarBgImage,leftbarBgImageH,leftbarFontColor,menubarBgColor,menubtnBgColor,menubtnBgColorActive,menubtnBgColorHover,menubtnBorderColorActive,menubtnBorderColorHover,menubtnFontColor,templateTitle,extendtempletid,extendtempletvalueid) VALUES ('"+templateName+"',"+subCompanyId+",'','#172971','','#DDDDDD','','#C4C4C4','','','#444444','#172971','#172971','#42549E','#42549E','#172971','#172971','#FFFFFF','"+templateTitle+"',"+extendtempletid+","+extandHpThemeId+")";
rs.executeSql(sql);
rs.executeSql("select max(id) from SystemTemplate");
if(rs.next()) templateId=rs.getInt(1);
sql = "update extandHpTheme set templateid=" + templateId + " where id=" + extandHpThemeId;
rs.executeSql(sql);
response.sendRedirect("/systeminfo/template/templateList.jsp?subCompanyId="+subCompanyId);
return;
} else if("delete".equals(method)){
sql = "DELETE FROM SystemTemplate WHERE id="+templateId;
rs.executeSql(sql);
sql = "DELETE FROM extandHpThemeItem WHERE extandHpThemeId=(select id from extandHpTheme where templateId=" +templateId+" and subCompanyId="+subCompanyId + ")";
rs.executeSql(sql);
sql = "DELETE FROM extandHpTheme WHERE templateId="+templateId+" and subCompanyId="+subCompanyId;
rs.executeSql(sql);
response.sendRedirect("/systeminfo/template/templateList.jsp?subCompanyId="+subCompanyId);
return;
}
%>