| | |
|---|
| | | //查询车辆所有人员信息 |
|---|
| | | List<Member> memberList = memberMapper.selectJoinList(Member.class,new MPJLambdaWrapper<Member>() |
|---|
| | | .selectAll(Member.class) |
|---|
| | | .leftJoin(CarDriver.class,CarDriver::getMemberId,Member::getId) |
|---|
| | | .leftJoin(Cars.class,Cars::getMemberId,Member::getId) |
|---|
| | | .leftJoin(JkKeys.class,JkKeys::getCarId,Cars::getId) |
|---|
| | | .eq(Member::getIsdeleted,Constants.ZERO) |
|---|
| | | .eq(CarDriver::getIsdeleted,Constants.ZERO) |
|---|
| | | .eq(CarDriver::getStatus,Constants.ZERO) |
|---|
| | | .isNotNull(Member::getFaceImg) |
|---|
| | | .in(CarDriver::getCarId,carIdList) |
|---|
| | | .in(JkKeys::getId,carIdList) |
|---|
| | | ); |
|---|
| | | if(CollectionUtils.isNotEmpty(memberList)){ |
|---|
| | | Set<Member> memberSet = new HashSet<>(memberList); |
|---|
