| | |
| | | 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()); |
| | |
| | | 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(), "未查询到预约记录"); |
| | | } |
| | | |
| | |
| | | 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())) |
| | |
| | | //预约人 |
| | | 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); |
| | |
| | | //查询是否处于会议中 |
| | | 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); |