ChkMeetingService.jsp
4.04 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
<%@ page language="java" contentType="text/html; charset=UTF-8"%>
<%@ page import="weaver.general.*"%>
<%@ page import="java.util.*" %>
<%@page import="weaver.hrm.HrmUserVarify"%>
<%@page import="weaver.hrm.User"%>
<%@page import="weaver.systeminfo.SystemEnv"%>
<jsp:useBean id="RecordSet" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="meetingSetInfo" class="weaver.meeting.Maint.MeetingSetInfo" scope="page"/>
<jsp:useBean id="MeetingRoomComInfo" class="weaver.meeting.Maint.MeetingRoomComInfo" scope="page"/>
<jsp:useBean id="MeetingUtil" class="weaver.meeting.MeetingUtil" scope="page"/>
<%
User user = HrmUserVarify.getUser (request , response) ;
//会议服务
String serviceItems=Util.null2String(request.getParameter("serviceitems"));
String begindate=Util.null2String(request.getParameter("begindate"));
String begintime=Util.null2String(request.getParameter("begintime"));
String enddate=Util.null2String(request.getParameter("enddate"));
String endtime=Util.null2String(request.getParameter("endtime"));
String requestid = Util.null2String(request.getParameter("requestid"));
String meetingids=Util.null2String(request.getParameter("meetingid"));
String formid=Util.null2String(request.getParameter("formid"));
String returnstr = "0";
String whereStr="";
if(!"".equals(requestid)) {
RecordSet.executeSql("select approveid from Bill_Meeting where requestid="+requestid);
if(RecordSet.next()) {
meetingids = Util.null2String(RecordSet.getString("approveid"));
}
}
if("85".equals(formid)){//来自会议系统表单 手机审批
serviceItems=MeetingUtil.getMeetingServiceItems(meetingids);
}
if(meetingSetInfo.getServiceConflictChk() == 1 &&!"".equals(serviceItems)){
RecordSet.executeSql("select t1.id,t1.begindate,t1.enddate,t1.begintime,t1.endtime,t2.items from meeting t1,meeting_service_new t2 where t1.id=t2.meetingid and t1.meetingstatus in (1,2) and t1.repeatType = 0 and t1.isdecision<2 and (t1.cancel is null or t1.cancel<>'1') and (t1.begindate <= '"+enddate+"' and t1.enddate >='"+begindate+"')");
while(RecordSet.next()) {
String begindatetmp = Util.null2String(RecordSet.getString("begindate"));
String begintimetmp = Util.null2String(RecordSet.getString("begintime"));
String enddatetmp = Util.null2String(RecordSet.getString("enddate"));
String endtimetmp = Util.null2String(RecordSet.getString("endtime"));
String items = Util.null2String(RecordSet.getString("items"));
String itemname = Util.null2String(RecordSet.getString("itemname"));
String mid = Util.null2String(RecordSet.getString("id"));
String str1 = begindate+" "+begintime;
String str2 = enddatetmp+" "+endtimetmp;
String str3 = enddate+" "+endtime;
String str4 = begindatetmp+" "+begintimetmp;
if(!mid.equals(meetingids)&&(str1.compareTo(str2) < 0 && str3.compareTo(str4) > 0)){//时间存在冲突的会议记录
String[] arrItems=items.split(",");
for(int i=0;i<arrItems.length;i++){//遍历会议服务中的多个服务项目
//如果服务项目不为空 且当前会议使用了此项目 且没有存在于查询条件中 将其拼接至查询条件
if(!"".equals(arrItems[i]) && (","+serviceItems+",").indexOf(","+arrItems[i]+",")>-1&&(","+whereStr+",").indexOf(","+arrItems[i]+",")<0){
if(!whereStr.equals("")){
whereStr+=",";
}
whereStr+=arrItems[i];
}
}
}
}
if(!whereStr.isEmpty()){
//查询开启冲突检测类型的服务类别中的冲突项目名称
RecordSet.executeSql("select itemname from Meeting_Service_Item t1,meeting_service_type t2 where t2.usecheck=1 and t1.type=t2.id and t1.id in ("+whereStr+")");
while(RecordSet.next()){
if("0".equals(returnstr)){
returnstr="["+RecordSet.getString("itemname")+"]";
}else{
returnstr+="\n["+RecordSet.getString("itemname")+"]";
}
}
}
if(!returnstr.equals("0")){
if(meetingSetInfo.getServiceConflict()==1){
returnstr+="\n"+SystemEnv.getHtmlLabelName(128457,user.getLanguage());
}else if(meetingSetInfo.getServiceConflict()==2){
returnstr+="\n"+SystemEnv.getHtmlLabelName(128456,user.getLanguage());
}
}
}
out.write(returnstr);
%>