资源描述
mybatisPlus的lambdaQueryWrapper的模糊和or和排序分页查询LambdaQueryWrapperlambdaQueryWrapper=Wrappers.lambdaQuery();lambdaQueryWrapper.eq(StoreConsumer:getStoreId,req.getStoreId();if(req.getName()!=null)lambdaQueryWrapper.like(StoreConsumer:getName,req.getName();if(req.getMobile()!=null)lambdaQueryWrapper.like(StoreConsumer:getMobile,req.getMobile();if(req.getPayCount()!=null)lambdaQueryWrapper.eq(StoreConsumer:getPayCount,req.getPayCount();if(req.getIntegral()!=null)lambdaQueryWrapper.eq(StoreConsumer:getIntegral,req.getIntegral();if(Objects.nonNull(req.getStartRegisterTime()lambdaQueryWrapper.apply(ObjectUtil.isNotNull(req.getStartRegisterTime(),DATE_FORMAT(created,%Y-%m-%d)=0,req.getStartRegisterTime();if(Objects.nonNull(req.getEndRegisterTime()lambdaQueryWrapper.apply(ObjectUtil.isNotNull(req.getEndRegisterTime(),DATE_FORMAT(created,%Y-%m-%d)wrapper.ge(StoreConsumer:getSuccessOrder,s.getSuccessOrder().or().ge(StoreConsumer:getPayCount,s.getPayCount().or().ge(StoreConsumer:getPayMoney,s.getPayMoney().or().ge(StoreConsumer:getIntegral,s.getIntegral();lambdaQueHWraillr.orderB|DestoreConsumer|btR|sterTime|H
展开阅读全文