|  |  |  | 
|---|
|  |  |  |  | 
|---|
|  |  |  | MPJLambdaWrapper<MemberRides> wrapper = new MPJLambdaWrapper<>(); | 
|---|
|  |  |  | wrapper.eq(MemberRides::getOrdreId,id); | 
|---|
|  |  |  | wrapper.ne(MemberRides::getStatus,Constants.MEMBER_RIDES_STATUS.LOCKING_DEFEAT.getKey()); | 
|---|
|  |  |  | wrapper.selectAll(MemberRides.class).selectAs(BaseParam::getName, MemberRides::getParamName); | 
|---|
|  |  |  | wrapper.leftJoin(BaseParam.class, BaseParam::getId, MemberRides::getParamId); | 
|---|
|  |  |  | wrapper.orderByDesc(BaseParam::getSortnum); | 
|---|
|  |  |  | 
|---|
|  |  |  | } | 
|---|
|  |  |  | } | 
|---|
|  |  |  | QueryWrapper<Refund> queryWrapper2 = new QueryWrapper<>(); | 
|---|
|  |  |  | queryWrapper2.lambda().ge(param.getStartDate() !=null,Refund::getDoneDate,Utils.Date.getStart(param.getStartDate())); | 
|---|
|  |  |  | queryWrapper2.lambda().le(param.getEndDate() !=null,Refund::getDoneDate,Utils.Date.getEnd(param.getEndDate())); | 
|---|
|  |  |  | if(Objects.nonNull(param.getStartDate())) { | 
|---|
|  |  |  | queryWrapper2.lambda().ge(Refund::getDoneDate, Utils.Date.getStart(param.getStartDate())); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | if(Objects.nonNull(param.getEndDate())) { | 
|---|
|  |  |  | queryWrapper2.lambda().le(Refund::getDoneDate, Utils.Date.getEnd(param.getEndDate())); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | queryWrapper2.lambda().eq(Refund::getIsdeleted, Constants.ZERO); | 
|---|
|  |  |  | queryWrapper2.select( "count(id) as count_num" | 
|---|
|  |  |  | ,"sum(money) as money" ); | 
|---|