| | |
|---|
| | | */ |
|---|
| | | @Override |
|---|
| | | public void autoStart(){ |
|---|
| | | List<Rooms> roomList = roomsMapper.selectList(new QueryWrapper<Rooms>() |
|---|
| | | .lambda().eq(Rooms::getIsdeleted,Constants.ZERO).eq(Rooms::getStatus,Constants.ZERO)); |
|---|
| | | 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) |
|---|
| | | .apply(" DATE_FORMAT(NOW(), '%Y-%m-%d') = DATE_FORMAT(START_TIME, '%Y-%m-%d') ") |
|---|
| | | if(bookingsMapper.selectCount(new QueryWrapper<Bookings>().lambda().eq(Bookings::getIsdeleted,Constants.ZERO) |
|---|
| | | .eq(Bookings::getStatus,Constants.ZERO).eq(Bookings::getRoomId,rooms.getId()).isNotNull(Bookings::getStartTimeReal). |
|---|
| | | apply(" DATE_FORMAT(NOW(), '%Y-%m-%d') = DATE_FORMAT(START_TIME, '%Y-%m-%d') ") |
|---|
| | | )<=Constants.ZERO){ |
|---|
| | | //根据会议室获取可以开启的会议记录（第一条记录） |
|---|
| | | Bookings bookings = bookingsMapper.selectOne(new QueryWrapper<Bookings>().lambda() |
|---|
