MeetingSubmitRequestJs.jsp
8.94 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
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
<%@page import="java.util.UUID"%>
<%@page import="weaver.hrm.HrmUserVarify"%>
<%@page import="weaver.hrm.User"%>
<%@page import="weaver.systeminfo.SystemEnv"%>
<%@page import="weaver.conn.RecordSet"%>
<%@page import="weaver.general.Util"%>
<%@page import="weaver.workflow.field.BrowserComInfo"%>
<%@page import="java.util.*"%>
<%@ page import="weaver.dateformat.UnifiedConversionInterface" %>
<%@ page import="com.api.workplan.util.TimeZoneCastUtil" %>
<jsp:useBean id="meetingSetInfo" class="weaver.meeting.Maint.MeetingSetInfo" scope="page"/>
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<style>
.ant-confirm-body .ant-confirm-content{
max-height:150px;
overflow-y:auto;
padding:10px 30px;
}
</style>
<%
String guid1 = UUID.randomUUID().toString();
User user = HrmUserVarify.getUser (request , response) ;
if(user==null){
response.sendRedirect("/notice/noright.jsp") ;
return ;
}
RecordSet rs = new RecordSet();
int requestid = Util.getIntValue(request.getParameter("requestid"),0);
int workflowid = Util.getIntValue(request.getParameter("workflowid"),0);
int formid = 0;
int currentnodetype = 0;
if(workflowid <= 0){
rs.executeSql("select workflowid, currentnodetype from workflow_requestbase where requestid = "+requestid);
if(rs.next()){
workflowid = Util.getIntValue(rs.getString("workflowid"), 0);
currentnodetype = Util.getIntValue(rs.getString("currentnodetype"), 0);
}
}
String meetingid="";
rs.executeSql("select * from meeting where requestid="+requestid);
if(rs.next()){
meetingid=rs.getString("id");
}
String address="";
String begindate="";
String begintime="";
String enddate="";
String endtime="";
String hrmmembers="";
String crmmembers="";
String resourcenum = "";
String crmsNumber = "";
String beginDateTime = "";
String endDateTime = "";
String customizeaddress = "";
int repeattype=0;
String itemsfieldid="";
String meetingType="";
String caller="";
String contacter="";
String hrmDepartments="";
String hrmSubCompanys="";
String otherParams = "";
String otherParamsFieldName = "";
//rs.executeSql("select id,fieldname from workflow_billfield where viewtype = 0 and billid=(select formid from workflow_base where id="+workflowid+") and lower(fieldname) in ('address','begindate','begintime','enddate','endtime','repeattype','hrmmembers','crmmembers','resourcenum','crmsnumber','resources','crms','totalmember','crmtotalmember','customizeaddress','begindatetime','enddatetime','meetingtype','caller','contacter','hrmDepartments','hrmSubCompanys')");
rs.executeQuery("select t1.id,t1.fieldname billFieldName,t2.fieldname from workflow_billfield t1 right join meeting_wf_relation t2 on t1.fieldname = t2.bill_fieldname" +
" where t2.billid=(select formid from workflow_base where id=? ) and t1.billid = (select formid from workflow_base where id=? ) and (t1.detailtable = '' or t1.detailtable is null)",workflowid,workflowid);
while(rs.next()){
if("address".equalsIgnoreCase(rs.getString("fieldname"))){
address=Util.null2String(rs.getString("id"));
}else if("begindate".equalsIgnoreCase(rs.getString("fieldname"))){
begindate=Util.null2String(rs.getString("id"));
}else if("begintime".equalsIgnoreCase(rs.getString("fieldname"))){
begintime=Util.null2String(rs.getString("id"));
}else if("enddate".equalsIgnoreCase(rs.getString("fieldname"))){
enddate=Util.null2String(rs.getString("id"));
}else if("endtime".equalsIgnoreCase(rs.getString("fieldname"))){
endtime=Util.null2String(rs.getString("id"));
}else if("hrmmembers".equalsIgnoreCase(rs.getString("fieldname")) || "resources".equalsIgnoreCase(rs.getString("fieldname"))){
hrmmembers=Util.null2String(rs.getString("id"));
}else if("crms".equalsIgnoreCase(rs.getString("fieldname")) || "crmmembers".equalsIgnoreCase(rs.getString("fieldname"))){
crmmembers=Util.null2String(rs.getString("id"));
}else if("repeatType".equalsIgnoreCase(rs.getString("fieldname"))){
repeattype=Util.getIntValue(rs.getString("id"),0);
}else if("resourcenum".equalsIgnoreCase(rs.getString("fieldname")) || "totalmember".equalsIgnoreCase(rs.getString("fieldname"))){
resourcenum=Util.null2String(rs.getString("id"));
}else if("crmsNumber".equalsIgnoreCase(rs.getString("fieldname")) || "crmtotalmember".equalsIgnoreCase(rs.getString("fieldname"))){
crmsNumber=Util.null2String(rs.getString("id"));
}else if("customizeaddress".equalsIgnoreCase(rs.getString("fieldname"))){
customizeaddress = Util.null2String(rs.getString("id"));
}else if("beginDateTime".equalsIgnoreCase(rs.getString("fieldname"))){
beginDateTime=Util.null2String(rs.getString("id"));
}else if("endDateTime".equalsIgnoreCase(rs.getString("fieldname"))){
endDateTime=Util.null2String(rs.getString("id"));
}else if("meetingtype".equalsIgnoreCase(rs.getString("fieldname"))){
meetingType=Util.null2String(rs.getString("id"));
}else if("caller".equalsIgnoreCase(rs.getString("fieldname"))){
caller=Util.null2String(rs.getString("id"));
}else if("contacter".equalsIgnoreCase(rs.getString("fieldname"))){
contacter=Util.null2String(rs.getString("id"));
}else if("hrmDepartments".equalsIgnoreCase(rs.getString("fieldname"))){
hrmDepartments=Util.null2String(rs.getString("id"));
}else if("hrmSubCompanys".equalsIgnoreCase(rs.getString("fieldname"))){
hrmSubCompanys=Util.null2String(rs.getString("id"));
}else{
if(!rs.getString("fieldname").equals("")){
otherParams += otherParams.equals("")?Util.null2String(rs.getString("id")):","+Util.null2String(rs.getString("id"));
otherParamsFieldName += otherParamsFieldName.equals("")?Util.null2String(rs.getString("fieldname")):","+Util.null2String(rs.getString("fieldname"));
}
}
}
rs.executeSql("select id,fieldname from workflow_billfield where viewtype = 1 and billid=(select formid from workflow_base where id="+workflowid+") and lower(fieldname) in ('items')");
while(rs.next()){
if("items".equalsIgnoreCase(rs.getString("fieldname"))){
itemsfieldid=Util.null2String(rs.getString("id"));
}
}
UnifiedConversionInterface uci = new UnifiedConversionInterface();
boolean needTimeZone = uci.getTimeZoneStatus();
if(needTimeZone && TimeZoneCastUtil.canCastZone){
needTimeZone = true;
}else{
needTimeZone = false;
}
%>
<script type="text/javascript">
var begindate="<%=begindate%>";
var begintime="<%=begintime%>";
var enddate="<%=enddate%>";
var endtime="<%=endtime%>";
var beginDateTime="<%=beginDateTime%>";
var endDateTime="<%=endDateTime%>";
var hrmmembers="<%=hrmmembers%>";
var crmmembers="<%=crmmembers%>";
var meetingid="<%=meetingid%>";
var address="<%=address%>";
var repeattype="<%=repeattype%>";
var resourcenum = "<%=resourcenum%>";
var crmsNumber = "<%=crmsNumber%>";
var customizeaddress = "<%=customizeaddress%>";
var memberConflictChk = "<%=meetingSetInfo.getMemberConflictChk()%>";
var roomConflictChk = "<%=meetingSetInfo.getRoomConflictChk()%>";
var serviceConflictChk = "<%=meetingSetInfo.getServiceConflictChk()%>";
var memberConflict = "<%=meetingSetInfo.getMemberConflict()%>";
var roomConflict = "<%=meetingSetInfo.getRoomConflict()%>";
var serviceConflict = "<%=meetingSetInfo.getServiceConflict()%>";
var maxRepeatDay = <%=meetingSetInfo.getZqhyzdkd()%>;
var maxRepeatMsg = "<%=SystemEnv.getHtmlLabelName(129693,user.getLanguage())%>";
var itemsfieldid = "<%=itemsfieldid%>";
var continueSubmit = "<%=SystemEnv.getHtmlLabelName(32873,user.getLanguage())%>?"
var forbiddenSubmit = "<%=SystemEnv.getHtmlLabelName(32874,user.getLanguage())%>"
var timeOrAddressMissData = "<%=SystemEnv.getHtmlLabelNames("81901,21695,2105,17023",user.getLanguage())%>";
var repeatMeetingSubmit = "<%=SystemEnv.getHtmlLabelNames("33277,24355",user.getLanguage())%>";
var meetingRoomConflictSubmit = "<%=SystemEnv.getHtmlLabelName(19095,user.getLanguage())%>";
var meetingRoomForbiddenSubmit = "<%=SystemEnv.getHtmlLabelName(32875,user.getLanguage())%>。";
var meetingServiceConflictSubmit = "<%=SystemEnv.getHtmlLabelName(128457,user.getLanguage())%>";
var meetingServiceForbiddenSubmit = "<%=SystemEnv.getHtmlLabelName(128456,user.getLanguage())%>";
var dateCheckMsg = "<%=SystemEnv.getHtmlLabelName(16722,user.getLanguage())%>";
var SystemTitle = "<%=SystemEnv.getHtmlLabelName(15172,user.getLanguage())%>"
var enableDateTime = "<%=SystemEnv.getHtmlLabelName(389239,user.getLanguage())%>"
var enableDateTimeCheck = "<%=SystemEnv.getHtmlLabelName(389241,user.getLanguage())%>"
var needTimeZone = <%=needTimeZone%>
var beginOrEndDateCompareMsg = "<%=SystemEnv.getHtmlLabelName(31832,user.getLanguage())%>"
var meetingType = "<%=meetingType%>"
var caller = "<%=caller%>"
var contacter = "<%=contacter%>"
var hrmDepartments = "<%=hrmDepartments%>"
var hrmSubCompanys = "<%=hrmSubCompanys%>"
var hrmChkMsg = "<%=SystemEnv.getHtmlLabelName(512362,user.getLanguage())%>"
var requestid = "<%=requestid%>"
var otherParams = "<%=otherParams%>";
var otherParamsFieldName = "<%=otherParamsFieldName%>"
</script>
<script type="text/javascript" src="/meeting/template/meetingSubmitRequestJs.js"></script>