| | |
|---|
| | | .eq(CarUseBook::getIsdeleted,Constants.ZERO) |
|---|
| | | .isNotNull(CarUseBook::getDriverId) |
|---|
| | | .apply(" car_id in ( SELECT k.CAR_ID FROM jk_cabinet_grid j inner join jk_keys k on j.KEY_ID = k.ID where j.isdeleted = 0 and k.isdeleted = 0 ) ") |
|---|
| | | .apply(" (" + |
|---|
| | | "( NOW() > DATE_SUB(START_TIME, INTERVAL "+earlyConfig+" MINUTE) and now() < end_time and KEY_STATUS = 0 ) " + |
|---|
| | | "or" + |
|---|
| | | " KEY_STATUS = 1 " + |
|---|
| | | ") ") |
|---|
| | | .apply(" ( ( NOW() > DATE_SUB(START_TIME, INTERVAL "+earlyConfig+" MINUTE) and now() < end_time ) or KEY_STATUS = 1 ) ") |
|---|
| | | ); |
|---|
| | | if(CollectionUtils.isNotEmpty(carUseBookList)){ |
|---|
| | | driverList.addAll(memberMapper.selectList(new QueryWrapper<Member>().lambda() |
|---|
