|  |  |  | 
|---|
|  |  |  | public Integer create(Bookings bookings) { | 
|---|
|  |  |  | LoginUserInfo user = bookings.getLoginUserInfo(); | 
|---|
|  |  |  | Rooms rooms = roomsMapper.selectById(bookings.getRoomId()); | 
|---|
|  |  |  | if(rooms==null ){ | 
|---|
|  |  |  | if(rooms==null||Constants.equalsInteger(rooms.getIsdeleted(),Constants.ONE) ){ | 
|---|
|  |  |  | throw  new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"对不起,该会议室暂时无法预约"); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | bookings.setRoomName(rooms.getName()); | 
|---|
|  |  |  | 
|---|
|  |  |  | s.setCreator(user.getId()); | 
|---|
|  |  |  | s.setObjId(bookings.getId()); | 
|---|
|  |  |  | s.setType(MeetConstants.TWO); | 
|---|
|  |  |  | s.setObjType(MeetConstants.ZERO); | 
|---|
|  |  |  | s.setObjType(Constants.MultiFile.MEETING_BOOKS.getKey()); | 
|---|
|  |  |  | multifileJoinMapper.insert(s); | 
|---|
|  |  |  | }); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | 
|---|
|  |  |  | for (int i = 0; i < bookings.getBookingTimeList().size(); i++) { | 
|---|
|  |  |  | BookingTime s = bookings.getBookingTimeList().get(i); | 
|---|
|  |  |  | RoomTime roomTime = roomTimeJoinMapper.selectById(s.getTimeId()); | 
|---|
|  |  |  | if(Objects.isNull(roomTime)){ | 
|---|
|  |  |  | if(Objects.isNull(roomTime) ||Constants.equalsInteger(roomTime.getIsdeleted(),Constants.ONE)){ | 
|---|
|  |  |  | throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"存在未查询到的配置日期,请刷新重试"); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | String endRoomTime = gsDate + " " + roomTime.getEndTime()+":00"; | 
|---|
|  |  |  | 
|---|
|  |  |  | Integer s=ids.get(i); | 
|---|
|  |  |  |  | 
|---|
|  |  |  | Bookings bkjs = bookingsMapper.selectById(s); | 
|---|
|  |  |  | if (Objects.isNull(bkjs)) { | 
|---|
|  |  |  | if (Objects.isNull(bkjs)||Constants.equalsInteger(bkjs.getIsdeleted(),Constants.ONE)) { | 
|---|
|  |  |  | throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(), "未查询到预约记录"); | 
|---|
|  |  |  | } | 
|---|
|  |  |  |  | 
|---|
|  |  |  | 
|---|
|  |  |  | @Transactional(rollbackFor = {BusinessException.class, Exception.class}) | 
|---|
|  |  |  | public void updateById(Bookings bookings) { | 
|---|
|  |  |  | Bookings dbBookings = bookingsMapper.selectById(bookings.getId()); | 
|---|
|  |  |  | if(dbBookings==null ||Constants.equalsInteger(dbBookings.getIsdeleted(),Constants.ONE)){ | 
|---|
|  |  |  | throw new BusinessException(ResponseStatus.DATA_EMPTY); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | if(dbBookings.getStatus().equals(MeetConstants.ONE)){ | 
|---|
|  |  |  | throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "本次操作失败,预约状态已流转"); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | Rooms rooms = roomsMapper.selectById(dbBookings.getRoomId()); | 
|---|
|  |  |  | if(rooms==null ){ | 
|---|
|  |  |  | if(rooms==null||Constants.equalsInteger(rooms.getIsdeleted(),Constants.ONE) ){ | 
|---|
|  |  |  | throw  new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"对不起,该会议室暂时无法预约"); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | bookings.setRoomName(rooms.getName()); | 
|---|
|  |  |  | 
|---|
|  |  |  | bookingsMapper.updateById(bookings);*/ | 
|---|
|  |  |  |  | 
|---|
|  |  |  | Bookings bookings = bookingsMapper.selectById(bs.getId()); | 
|---|
|  |  |  | if (Objects.isNull(bookings)) { | 
|---|
|  |  |  | if (Objects.isNull(bookings)||Constants.equalsInteger(bookings.getIsdeleted(),Constants.ONE)) { | 
|---|
|  |  |  | throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(), "未查询到预约记录"); | 
|---|
|  |  |  | } | 
|---|
|  |  |  |  | 
|---|
|  |  |  | 
|---|
|  |  |  |  | 
|---|
|  |  |  | //查询是否有权限 | 
|---|
|  |  |  | s.setHasRole(getHasRoleByParam(s,userInfo,adminList)); | 
|---|
|  |  |  | /*  //服务项 | 
|---|
|  |  |  | /*  //服务项 | 
|---|
|  |  |  | MPJLambdaWrapper<ProjectRel> prquery = new MPJLambdaWrapper<>(); | 
|---|
|  |  |  | prquery.selectAll(ProjectRel.class); | 
|---|
|  |  |  | prquery.eq(ProjectRel::getIsdeleted, MeetConstants.ZERO); | 
|---|
|  |  |  | 
|---|
|  |  |  | throw new BusinessException(ResponseStatus.BAD_REQUEST); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | Bookings bookings = bookingsMapper.selectOne(new QueryWrapper<Bookings>().lambda() | 
|---|
|  |  |  | .eq(Bookings::getIsdeleted,Constants.ZERO) | 
|---|
|  |  |  | .eq(Bookings::getRoomId,bean.getRoomId()) | 
|---|
|  |  |  | .ge(Bookings::getEndTime,DateUtil.getPlusTime(bean.getEndTime())) | 
|---|
|  |  |  | .le(Bookings::getStartTime,DateUtil.getPlusTime(bean.getStartTime())) | 
|---|
|  |  |  | 
|---|
|  |  |  | @Override | 
|---|
|  |  |  | public MeetingDetailResponse getMeetingDetail(Integer id,Integer sysUserId) { | 
|---|
|  |  |  | MeetingDetailResponse meetingDetailResponse = bookingsMapper.meetingDetail(id); | 
|---|
|  |  |  | if (Objects.isNull(meetingDetailResponse)) { | 
|---|
|  |  |  | if (Objects.isNull(meetingDetailResponse) | 
|---|
|  |  |  | || Constants.equalsInteger(meetingDetailResponse.getIsdeleted(),Constants.ONE) ) { | 
|---|
|  |  |  | throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(), "未查询到会议详情"); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | //预约人 | 
|---|
|  |  |  | meetingDetailResponse.setBookingUser(systemUserService.findById(meetingDetailResponse.getBookingUserId())); | 
|---|
|  |  |  | //时间段列表 | 
|---|
|  |  |  | meetingDetailResponse.setBookingTimeList(bookingTimeMapper.selectList(new QueryWrapper<BookingTime>() | 
|---|
|  |  |  | .eq("BOOKING_ID", id) | 
|---|
|  |  |  | .eq("ISDELETED", MeetConstants.ZERO) | 
|---|
|  |  |  | meetingDetailResponse.setBookingTimeList(bookingTimeMapper.selectList(new QueryWrapper<BookingTime>().lambda() | 
|---|
|  |  |  | .eq(BookingTime::getBookingId, id) | 
|---|
|  |  |  | .eq(BookingTime::getIsdeleted, MeetConstants.ZERO) | 
|---|
|  |  |  | )); | 
|---|
|  |  |  | //参会人员列表 | 
|---|
|  |  |  | List<UserResponse> userResponseList = systemUserService.getUserList(id); | 
|---|
|  |  |  | 
|---|
|  |  |  | i.setPrefixUrl(projectsPath); | 
|---|
|  |  |  | }); | 
|---|
|  |  |  | meetingDetailResponse.setProjectsResponseList(projectsResponseList); | 
|---|
|  |  |  | List<Multifile> multiFileList = multifileMapper.selectList(new QueryWrapper<Multifile>() | 
|---|
|  |  |  | .eq("OBJ_ID", id) | 
|---|
|  |  |  | .eq("OBJ_TYPE", MeetConstants.ZERO) | 
|---|
|  |  |  | List<Multifile> multiFileList = multifileMapper.selectList(new QueryWrapper<Multifile>().lambda() | 
|---|
|  |  |  | .eq(Multifile::getObjId, id) | 
|---|
|  |  |  | .eq(Multifile::getObjType, Constants.MultiFile.MEETING_BOOKS.getKey()) | 
|---|
|  |  |  | .eq(Multifile::getIsdeleted, MeetConstants.ZERO) | 
|---|
|  |  |  | ); | 
|---|
|  |  |  | multiFileList.forEach(i -> { | 
|---|
|  |  |  | i.setFileurlFull(projectsPath); | 
|---|
|  |  |  | 
|---|
|  |  |  | //附件信息 | 
|---|
|  |  |  | meetingDetailResponse.setMultiFileList(multiFileList); | 
|---|
|  |  |  | //会议室管理人员 | 
|---|
|  |  |  | List<UserRel> userRelList = userRelMapper.selectList(new QueryWrapper<UserRel>() | 
|---|
|  |  |  | .eq("ISDELETED",MeetConstants.ZERO) | 
|---|
|  |  |  | .eq("OBJ_ID", meetingDetailResponse.getRoomId()) | 
|---|
|  |  |  | .eq("OBJ_TYPE",MeetConstants.ZERO) | 
|---|
|  |  |  | List<UserRel> userRelList = userRelMapper.selectList(new QueryWrapper<UserRel>().lambda() | 
|---|
|  |  |  | .eq(UserRel::getIsdeleted,MeetConstants.ZERO) | 
|---|
|  |  |  | .eq(UserRel::getObjId, meetingDetailResponse.getRoomId()) | 
|---|
|  |  |  | .eq(UserRel::getObjType,MeetConstants.ZERO) | 
|---|
|  |  |  | ); | 
|---|
|  |  |  | if(Constants.equalsInteger(sysUserId,meetingDetailResponse.getBookingUserId())){ | 
|---|
|  |  |  | meetingDetailResponse.setIsAdmin(Constants.ONE); | 
|---|
|  |  |  | 
|---|
|  |  |  | public Integer reservationMeeting(BookingsRequest bookingsRequest) { | 
|---|
|  |  |  | Bookings bookings = new Bookings(); | 
|---|
|  |  |  | BeanUtils.copyProperties(bookingsRequest, bookings); | 
|---|
|  |  |  | bookings.setJoinNotice(bookingsRequest.getJoinNotice()); | 
|---|
|  |  |  | if (Objects.isNull(bookingsRequest.getId())) { | 
|---|
|  |  |  | this.create(bookings); | 
|---|
|  |  |  | return bookings.getId(); | 
|---|
|  |  |  | 
|---|
|  |  |  | .replace("{参会人员姓名}",StringUtils.defaultString(i.getRealName(),"")) | 
|---|
|  |  |  | .replace("{会议主题}",StringUtils.defaultString(bookings.getName(),"")) | 
|---|
|  |  |  | .replace("{会议室名称}",StringUtils.defaultString(bookings.getRoomName(),"")) | 
|---|
|  |  |  | .replace("{会议时间段}",StringUtils.defaultString(timeInfo,""))); | 
|---|
|  |  |  | .replace("{会议时间段}",StringUtils.defaultString(timeInfo,"")) | 
|---|
|  |  |  | .replace("{会议备注}",StringUtils.defaultString(bookings.getRemark(),""))); | 
|---|
|  |  |  | smsEmailList.add(smsEmail); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | } | 
|---|
|  |  |  | 
|---|
|  |  |  | .replace("{参会人员姓名}",StringUtils.defaultString(systemUser.getRealname(),"")) | 
|---|
|  |  |  | .replace("{会议主题}",StringUtils.defaultString(bookings.getName(),"")) | 
|---|
|  |  |  | .replace("{会议室名称}",StringUtils.defaultString(bookings.getRoomName(),"")) | 
|---|
|  |  |  | .replace("{会议备注}",StringUtils.defaultString(bookings.getRemark(),"")) | 
|---|
|  |  |  | .replace("{会议时间段}",StringUtils.defaultString(timeInfo,""))); | 
|---|
|  |  |  | smsEmailList.add(smsEmail); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | 
|---|
|  |  |  | //查询是否处于会议中 | 
|---|
|  |  |  | page.getRecords().forEach(j->{ | 
|---|
|  |  |  | j.setPrefixUrl(path); | 
|---|
|  |  |  | if(bookingsMapper.selectCount(new QueryWrapper<Bookings>() | 
|---|
|  |  |  | if(bookingsMapper.selectCount(new QueryWrapper<Bookings>() .lambda() | 
|---|
|  |  |  | .eq(Bookings::getIsdeleted,Constants.ZERO) | 
|---|
|  |  |  | .exists(" select 1 from meeting_user_rel u where u.OBJ_ID = meeting_book.id and  u.USER_ID = '"+j.getId()+"' and u.OBJ_TYPE = 1    ") | 
|---|
|  |  |  | .and(i -> i.between("START_TIME", pageWrap.getModel().getStartTime()+":00",pageWrap.getModel().getEndTime()+":00") | 
|---|
|  |  |  | .or().between("END_TIME", pageWrap.getModel().getStartTime()+":00",pageWrap.getModel().getEndTime()+":00") | 
|---|
|  |  |  | .and(i -> i.between(Bookings::getStartTime, pageWrap.getModel().getStartTime()+":00",pageWrap.getModel().getEndTime()+":00") | 
|---|
|  |  |  | .or().between(Bookings::getEndTime, pageWrap.getModel().getStartTime()+":00",pageWrap.getModel().getEndTime()+":00") | 
|---|
|  |  |  | ) | 
|---|
|  |  |  | )>Constants.ZERO){ | 
|---|
|  |  |  | j.setStatus(Constants.ONE); | 
|---|