| | |
|---|
| | | .eq(JkKeys::getRoleType,Constants.ONE) |
|---|
| | | // .eq(Cars::getMemberId,dto.getMemberId()) |
|---|
| | | .isNotNull(JkCabinetGrid::getKeyId) |
|---|
| | | .apply(" t2.code in ( select c.car_code from car_use_book c where c.isdeleted = 0 and NOW() > DATE_SUB(c.START_TIME, INTERVAL "+earlyConfig+" MINUTE) and now() < c.end_time and c.DRIVER_ID = "+dto.getMemberId()+" ) ") |
|---|
| | | .apply(" ( t2.code in ( select c.car_code from car_use_book c where c.isdeleted = 0 and NOW() > DATE_SUB(c.START_TIME, INTERVAL "+earlyConfig+" MINUTE) and now() < c.end_time " + |
|---|
| | | " and c.DRIVER_ID = "+dto.getMemberId()+" )" + |
|---|
| | | " or t2.code in ( select c.car_code from car_use_book c inner join cars c1 on c.CAR_ID = c1.ID where c1.MEMBER_ID = 6611 AND NOW() > DATE_SUB( c.START_TIME, INTERVAL 30 MINUTE ) AND now() < c.end_time )" + |
|---|
| | | " )" + |
|---|
| | | " ") |
|---|
| | | ); |
|---|
| | | |
|---|
| | | for (JkCabinetGrid jkCabinetGrid:jkCabinetGridList) { |
|---|
