| | |
| | | } |
| | | |
| | | /** |
| | | * 自动开始会议 |
| | | */ |
| | | @Override |
| | | public void autoStart(){ |
| | | List<Rooms> roomList = roomsMapper.selectList(new QueryWrapper<Rooms>().lambda().eq(Rooms::getIsdeleted,Constants.ZERO).eq(Rooms::getStatus,Constants.ZERO)); |
| | | for (Rooms rooms:roomList) { |
| | | //查询当前会议室是否存在进行中的会议 |
| | | if(bookingsMapper.selectCount(new QueryWrapper<Bookings>().lambda().eq(Bookings::getIsdeleted,Constants.ZERO) |
| | | .eq(Bookings::getStatus,Constants.ZERO).isNotNull(Bookings::getStartTimeReal) |
| | | )<=Constants.ZERO){ |
| | | //根据会议室获取可以开启的会议记录(第一条记录) |
| | | Bookings bookings = bookingsMapper.selectOne(new QueryWrapper<Bookings>().lambda() |
| | | .eq(Bookings::getIsdeleted,Constants.ZERO) |
| | | .eq(Bookings::getStatus,Constants.ZERO) |
| | | .eq(Bookings::getRoomId,rooms.getId()) |
| | | .apply(" now() > START_TIME and now < END_TIME ") |
| | | .isNull(Bookings::getStartTimeReal) |
| | | .orderByAsc(Bookings::getStartTime) |
| | | .last(" limit 1 ") |
| | | ); |
| | | bookings.setStartTimeReal(new Date()); |
| | | bookings.setEditDate(new Date()); |
| | | bookingsMapper.updateById(bookings); |
| | | } |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * 提前开始 |
| | | * @param businessOverDTO |
| | | */ |