| | |
| | | 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(); |
| | |
| | | .ne(Bookings::getId,bookings.getId()) |
| | | )>Constants.ZERO){ |
| | | throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"存在未开启会议,无法开始会议"); |
| | | }; |
| | | } |
| | | |
| | | if(bookingsMapper.selectCount(new QueryWrapper<Bookings>() |
| | | .lambda() |
| | |
| | | .eq(Bookings::getRoomId,bookings.getRoomId()) |
| | | )>Constants.ZERO){ |
| | | throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"当前开启时间与其他会议存在冲突,无法开始会议"); |
| | | }; |
| | | } |
| | | }else{ |
| | | if(bookings.getStartTime().getTime() > System.currentTimeMillis()){ |
| | | throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"未到会议申请开始时间,无法开始"); |
| | |
| | | .set(Bookings::getDoneInfo,"其他会议开始,自动关闭") |
| | | .apply(" ( END_TIME < now() or ( END_TIME > now() and START_TIME < now() and START_TIME_REAL is null ) )") |
| | | .eq(Bookings::getStatus,Constants.ZERO) |
| | | .ne(Bookings::getId,bookings.getId()) |
| | | .eq(Bookings::getRoomId,bookings.getRoomId()) |
| | | ); |
| | | |
| | |
| | | .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); |