| | |
| | | @Transactional(rollbackFor = {BusinessException.class, Exception.class}) |
| | | public Integer create(Bookings bookings) { |
| | | LoginUserInfo user = bookings.getLoginUserInfo(); |
| | | user.setId(bookings.getCreator()); |
| | | isCreateParamValid(bookings, user); |
| | | bookings.setCreateDate(new Date()); |
| | | bookings.setCreator(user.getId()); |
| | |
| | | for (int i = 0; i < bookings.getBookingTimeList().size(); i++) { |
| | | BookingTime s = bookings.getBookingTimeList().get(i); |
| | | if (!Objects.isNull(bookList) && bookList.size() > MeetConstants.ZERO) { |
| | | |
| | | List<Bookings> detailDataDtoStream = |
| | | bookList.stream().filter(a -> MeetConstants.equalsInteger(s.getTimeId(), a.getRoomTimeId()) |
| | | ).collect(Collectors.toList()); |
| | |
| | | .apply(" id in ( select u.OBJ_ID from meeting_user_rel u where u.USER_ID = '" + userId + "' and u.ISDELETED = 0 and OBJ_TYPE = 1 ) ") |
| | | .eq("ISDELETED",MeetConstants.ZERO) |
| | | // .eq("STATUS",MeetConstants.ZERO) |
| | | .apply(" ROOM_ID in ( select r.id from rooms r where r.ISDELETED = 0 and r.STATUS = 0 )") |
| | | .apply(" ROOM_ID in ( select r.id from meeting_rooms r where r.ISDELETED = 0 and r.STATUS = 0 )") |
| | | .like(StringUtils.isNotBlank(dateMsg), "START_TIME", dateMsg)); |
| | | } |
| | | |
| | |
| | | page.getRecords().forEach(j->{ |
| | | j.setPrefixUrl(path); |
| | | if(bookingsMapper.selectCount(new QueryWrapper<Bookings>() |
| | | .exists(" select 1 from meeting_user_rel u where u.OBJ_ID = bookings.id and u.USER_ID = '"+j.getId()+"' and u.OBJ_TYPE = 1 ") |
| | | .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") |
| | | ) |