SynergyElementPreview.jsp
5.18 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
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ page import="weaver.general.Util" %>
<%@ page import="java.text.SimpleDateFormat" %>
<%@ include file="/page/maint/common/initNoCache.jsp"%>
<jsp:useBean id="pu" class="weaver.page.PageUtil" scope="page"/>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="hpec" class="weaver.homepage.cominfo.HomepageElementCominfo" scope="page"/>
<jsp:useBean id="wbe" class="weaver.admincenter.homepage.WeaverBaseElementCominfo" scope="page" />
<jsp:useBean id="eu" class="weaver.page.element.ElementUtil" scope="page"/>
<jsp:useBean id="pc" class="weaver.page.PageCominfo" scope="page"/>
<jsp:useBean id="wpc" class="weaver.admincenter.homepage.WeaverPortalContainer" scope="page"/>
<jsp:useBean id="baseBean" class="weaver.general.BaseBean" scope="page" />
<%
String ebaseid=Util.null2String(request.getParameter("ebaseid"));
String styleid=Util.null2String(request.getParameter("styleid"));
String hpid=Util.null2String(request.getParameter("hpid"));
int subCompanyId = Util.getIntValue(request.getParameter("subCompanyId"),-1);
String layoutflag=Util.null2String(request.getParameter("layoutflag"));
String addType = Util.null2String(request.getParameter("addType"));
String fromModule = Util.null2String(request.getParameter("fromModule"));
boolean isSystemer=false;
//暂时注释下，还未申请权限
//if(HrmUserVarify.checkUserRight("homepage:Maint", user))
isSystemer=true;
ArrayList list = pu.getShareMaintListByUser(user.getUID()+"");
if(list.indexOf(hpid)!=-1){
isSystemer=true;
}
//if(opreateLevel>0&&subCompanyId!=-1) isSystemer=true;
int maxEid=0;
String managerStr="0";
if(isSystemer) managerStr="1";
//求用户的ID与分部ID
int userid=1;//pu.getHpUserId(hpid,""+subCompanyId,user);
int usertype=1;//pu.getHpUserType(hpid,""+subCompanyId,user);
//添加元素
String strSql="insert into hpElement(title,logo,islocked,ebaseid,isSysElement,hpid,styleid,marginTop,shareuser,scrolltype,fromModule,isuse) values('"+(user.getLanguage()==8?wbe.getTitleEN(ebaseid):wbe.getTitle(ebaseid))+"','"+wbe.getElogo(ebaseid)+"','1','"+ebaseid+"','"+managerStr+"',"+hpid+",'"+styleid+"','10','5_1','None','"+fromModule+"',1)";
rs.executeSql(strSql);
//baseBean.writeLog("SynergyElementPreview.jsp:===>"+strSql);
rs.executeSql("select max(id) from hpElement");
if(rs.next()){
maxEid=Util.getIntValue(rs.getString(1));
}
//baseBean.writeLog(maxEid);
hpec.addHpElementCache(""+maxEid);
String strUpdateSql="";
if("".equals(addType)){
if (rs.getDBType().equals("sqlserver")) {
strUpdateSql = "update hplayout set areaElements='" + maxEid + ",'+areaElements where hpid=" + hpid + " and areaflag='" + layoutflag + "' and userid=" + userid + " and usertype=" + usertype;
}else if(rs.getDBType().equals("mysql")){
strUpdateSql = "update hplayout set areaElements=concat('" + maxEid + ",',areaElements) where hpid=" + hpid + " and areaflag='" + layoutflag + "' and userid=" + userid + " and usertype=" + usertype;
} else {
strUpdateSql = "update hplayout set areaElements='" + maxEid + ",' || areaElements where hpid=" + hpid + " and areaflag='" + layoutflag + "' and userid=" + userid + " and usertype=" + usertype;
}
}else{
if (rs.getDBType().equals("sqlserver")) {
strUpdateSql = "update pagenewstemplatelayout set areaElements='" + maxEid + ",'+areaElements where templateid=" + hpid + " and areaFlag='" + layoutflag + "'";
}else if(rs.getDBType().equals("mysql")){
strUpdateSql = "update pagenewstemplatelayout set areaElements=concat('" + maxEid + ",',areaElements) where templateid=" + hpid + " and areaFlag='" + layoutflag + "'";
}else {
strUpdateSql = "update pagenewstemplatelayout set areaElements='" + maxEid + ",' || areaElements where templateid=" + hpid + " and areaFlag='" + layoutflag + "'";
}
}
//baseBean.writeLog(strUpdateSql+"33333 ");
rs.executeSql(strUpdateSql);
String date = new SimpleDateFormat("yyyy-MM-dd").format(new Date()).toString();
String time = new SimpleDateFormat("HH:mm:ss").format(new Date()).toString();
String areaStr = "insert into hpareaelement(hpid,eid,ebaseid,userid,usertype,module,modelastdate,modelasttime,ordernum) values("+hpid+","+maxEid+",'"+ebaseid+"',"+userid+","+usertype+",'"+fromModule+"','"+date+"','"+time+"',0)";
//baseBean.writeLog(areaStr);
rs.executeSql(areaStr);
//添加共享信息
String strInsertSql = "insert into hpElementSettingDetail(hpid,eid,userid,usertype,perpage,linkmode,sharelevel) values("+hpid+","+maxEid+","+userid+","+usertype+","+wbe.getPerpage(ebaseid)+","+wbe.getLinkmode(ebaseid)+",'2')";
baseBean.writeLog("SynergyElementPreview.jsp:===>"+strInsertSql);
rs.executeSql(strInsertSql);
out.println("<STYLE TYPE=\"text/css\">");
out.println(pu.getElementCss(hpid,""+maxEid));
out.println("</STYLE>");
if("synergy".equals(fromModule)){
if("".equals(addType)){
out.println(eu.getContainer(ebaseid,""+maxEid,hpid,styleid,"0","2",user,subCompanyId,userid,usertype,0));
}else{
out.println(eu.getContainer(ebaseid,""+maxEid,hpec.getStyleid(""+maxEid),user,true));
}
}else{
out.println(wpc.getElementFrame(ebaseid,""+maxEid,user));
}
%>