| | |
|---|
| | | |
|---|
| | | roomsMapper.update(rooms, Wrappers.<Rooms>lambdaUpdate() |
|---|
| | | .set(Rooms::getFileType, rooms.getFileType()) |
|---|
| | | // .set(Rooms::getEndTime, rooms.getEndTime()) |
|---|
| | | // .set(Rooms::getStartTime, rooms.getStartTime()) |
|---|
| | | .set(Rooms::getLimitNum, rooms.getLimitNum()) |
|---|
| | | .set(Rooms::getTips, rooms.getTips()) |
|---|
| | | .set(Rooms::getIntervalTime, rooms.getIntervalTime()) |
|---|
| | | .set(Rooms::getImgurl, rooms.getImgurl()) |
|---|
| | | .eq(Rooms::getId, rooms.getId())); |
|---|
| | | |
|---|
| | |
|---|
| | | rooms.setEndTime(DateUtil.formatDate(endtime.getTime(), "yyyy-MM-dd HH:mm:ss")); |
|---|
| | | |
|---|
| | | |
|---|
| | | //TODO 更新会议室时间段 |
|---|
| | | //TODO更 新会议室时间段 |
|---|
| | | if (!Constants.equalsInteger(re, Constants.ONE)) { |
|---|
| | | updateRoomTimes(rooms, user); |
|---|
| | | } |
|---|
| | |
|---|
| | | IPage<Rooms> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); |
|---|
| | | MPJLambdaWrapper<Rooms> queryWrapper = new MPJLambdaWrapper<>(); |
|---|
| | | Utils.MP.blankToNull(pageWrap.getModel()); |
|---|
| | | |
|---|
| | | queryWrapper.selectAll(Rooms.class); |
|---|
| | | |
|---|
| | | queryWrapper.select("(select count(a.id) from meeting_book a where a.room_id=t.id and a.isdeleted=0 and a.status=0)",Rooms::getBookingNum); |
|---|
| | | queryWrapper.orderByDesc(Rooms::getCreateDate); |
|---|
| | | queryWrapper.eq(Rooms::getIsdeleted, Constants.ZERO); |
|---|
| | | queryWrapper.like(StringUtils.isNotBlank(pageWrap.getModel().getName()),Rooms::getName, pageWrap.getModel().getName()); |
|---|
| | |
|---|
| | | if(org.apache.commons.collections4.CollectionUtils.isNotEmpty(pageWrap.getModel().getSysList())){ |
|---|
| | | // queryWrapper.leftJoin(UserRel.class,UserRel::getObjId,Rooms::getId); |
|---|
| | | List<Integer> collect = pageWrap.getModel().getSysList().stream().map(UserRel::getUserId).collect(Collectors.toList()); |
|---|
| | | |
|---|
| | | queryWrapper.exists("select u.id from meeting_user_rel u where u.ISDELETED=0 and u.OBJ_ID =t.id and u.USER_ID in (" + StringUtils.strip(collect.toString(),"[]")+" )"); |
|---|
| | | } |
|---|
| | | |
|---|
