| | |
|---|
| | | .eq(Bookings::getIsdeleted,Constants.ZERO) |
|---|
| | | .eq(Bookings::getStatus,Constants.ZERO) |
|---|
| | | .eq(Bookings::getRoomId,rooms.getId()) |
|---|
| | | .apply(" now() > START_TIME and now < END_TIME ") |
|---|
| | | .apply(" now() > START_TIME and now() < END_TIME ") |
|---|
| | | .isNull(Bookings::getStartTimeReal) |
|---|
| | | .orderByAsc(Bookings::getStartTime) |
|---|
| | | .last(" limit 1 ") |
|---|
| | |
|---|
| | | .eq(Bookings::getIsdeleted, MeetConstants.ZERO) |
|---|
| | | .eq(Bookings::getStatus, MeetConstants.ZERO) |
|---|
| | | .eq(Rooms::getId, rooms.getId()) |
|---|
| | | .apply("to_days(t.start_time) = to_days(now()) and t.end_time > now()")//子查询当天的 |
|---|
| | | .apply(" ( " + |
|---|
| | | " to_days(t.start_time) = to_days(now()) " + |
|---|
| | | " and ( t.START_TIME_REAL is not null or ( t.end_time > now() and t.START_TIME_REAL is null ) ) " + |
|---|
| | | " ) ")//子查询当天的 |
|---|
| | | .orderByAsc(Bookings::getStartTime); |
|---|
| | | Integer minute =getNearStartMinut(); |
|---|
| | | List<Bookings> meetingList =bookingsMapper.selectJoinList(Bookings.class,queryWrapper); |
|---|
