| | |
| | | MPJLambdaWrapper<BikeRepair> queryWrapper = new MPJLambdaWrapper<>(); |
| | | Utils.MP.blankToNull(pageWrap.getModel()); |
| | | queryWrapper.leftJoin(Member.class,Member::getId,BikeRepair::getMemberId) |
| | | .leftJoin(Bikes.class,Bikes::getId,BikeRepair::getBinkeId) |
| | | .leftJoin(BaseParam.class,BaseParam::getId,Bikes::getParamId); |
| | | .leftJoin(Bikes.class,Bikes::getCode,BikeRepair::getBinkeId) |
| | | .leftJoin(BaseParam.class,BaseParam::getId,BikeRepair::getTypeId); |
| | | queryWrapper.selectAll(BikeRepair.class) |
| | | .selectAs(Member::getOpenid,BikeRepairDTO::getOpenid) |
| | | .selectAs(Bikes::getCode,BikeRepairDTO::getBikeCode) |
| | | .selectAs(BikeRepair::getBinkeId,BikeRepairDTO::getBikeCode) |
| | | .selectAs(BaseParam::getName,BikeRepairDTO::getBikeTypeName); |
| | | queryWrapper.like(StringUtils.isNotEmpty(pageWrap.getModel().getOpenid()),Member::getOpenid,pageWrap.getModel().getOpenid()) |
| | | .like(StringUtils.isNotEmpty(pageWrap.getModel().getBikeCode()),Bikes::getCode,pageWrap.getModel().getBikeCode()) |