|  |  | 
 |  |  |     @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") | 
 |  |  |                     ) |