后台结算记录

jiangping

2023-10-10 d7d6facdf81c4d666c8c71e44121116079d96700

后台结算记录

 server/platform/src/main/java/com/doumee/api/business/RefundController.java

@@ -6,7 +6,10 @@
import com.doumee.core.model.ApiResponse;
import com.doumee.core.model.PageData;
import com.doumee.core.model.PageWrap;
import com.doumee.core.utils.DateUtil;
import com.doumee.dao.business.model.Refund;
import com.doumee.dao.business.model.RefundPlatExportVO;
import com.doumee.dao.business.vo.GoodsorderExportVO;
import com.doumee.service.business.RefundService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
@@ -73,6 +76,12 @@
    public ApiResponse<PageData<Refund>> findPage (@RequestBody PageWrap<Refund> pageWrap) {
        return ApiResponse.success(refundService.findPage(pageWrap));
    }
    @ApiOperation("后台结算记录")
    @PostMapping("/page")
    @RequiresPermissions("business:refund:query")
    public ApiResponse<PageData<Refund>> findPlatPage (@RequestBody PageWrap<Refund> pageWrap) {
        return ApiResponse.success(refundService.findPlatPage(pageWrap));
    }

    @ApiOperation("导出Excel")
    @PostMapping("/exportExcel")
@@ -81,6 +90,13 @@
        ExcelExporter.build(Refund.class).export(refundService.findPage(pageWrap).getRecords(), "退款信息表", response);
    }

    @ApiOperation("导出后台结算记录Excel")
    @PostMapping("/exportPlatExcel")
    @RequiresPermissions("business:refund:exportExcel")
    public void exportPlatExcel (@RequestBody PageWrap<Refund> pageWrap, HttpServletResponse response) {
        ExcelExporter.build(RefundPlatExportVO.class).exportWithFirstAndEnd(refundService.findPlatExportPage(pageWrap.getModel()), "后台结算记录_"+System.currentTimeMillis(),"后台结算记录_"+ DateUtil.getPlusTime2(DateUtil.getCurrentDate()),null, response);
    }

    @ApiOperation("根据ID查询")
    @GetMapping("/{id}")
    @RequiresPermissions("business:refund:query")

 server/platform/src/main/java/com/doumee/api/common/CaptchaController.java

@@ -12,6 +12,7 @@
import org.springframework.web.bind.annotation.RestController;

/**
 * @author Eva.
 * @author Eva.Caesar Liu
 * @date 2023/02/14 11:14
 */
@@ -24,10 +25,7 @@
    @Autowired
    private CaptchaService captchaService;

    /**
     * @author Eva.Caesar Liu
     * @date 2023/02/14 11:14
     */

    @ApiOperation("获取图片验证码")
    @GetMapping("/captcha")
    public ApiResponse<CaptchaService.Captcha> getCaptcha() {

 server/services/src/main/java/com/doumee/core/constants/Constants.java

@@ -187,6 +187,55 @@
                this.info = info;
            }
        }

    public enum REFUND_TYPE{
        // '退款类型 0用户结算退款 1平台自动结算退款 2强制结算退款 3结算后退款'
        NORMAL(  0,"用户结算退款",""),

        PLAT_AUTO( 1,"平台自动结算退款",""),

        PLAT_FORCE( 2,"强制结算退款",""),

        BACK( 3,"结算后退款",""),

        ;
        String name;

        Integer key;

        String info;


        REFUND_TYPE(Integer key,String name, String info) {
            this.name = name;
            this.key = key;
            this.info = info;
        }

        public String getName() {
            return name;
        }

        public void setName(String name) {
            this.name = name;
        }

        public Integer getKey() {
            return key;
        }

        public void setKey(Integer key) {
            this.key = key;
        }

        public String getInfo() {
            return info;
        }

        public void setInfo(String info) {
            this.info = info;
        }
    }
        public enum MEMBER_RIDES_STATUS{
//            0请求开锁中 1骑行中 2已还车  3开锁失败
            LOCKING("请求开锁中", 0,"请求开锁中"),

 server/services/src/main/java/com/doumee/dao/business/join/RefundJoinMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,13 @@
package com.doumee.dao.business.join;

import com.doumee.dao.business.model.Goodsorder;
import com.doumee.dao.business.model.Refund;
import com.github.yulichang.base.mapper.MPJJoinMapper;
import org.springframework.stereotype.Repository;

/**
 * @author T14
 */
@Repository
public interface RefundJoinMapper extends MPJJoinMapper<Refund> {
}

 server/services/src/main/java/com/doumee/dao/business/model/Goodsorder.java

@@ -104,13 +104,14 @@

    @ApiModelProperty(value = "结算类型 0自动结算 1平台人工结算 2系统自动结算")
    private Integer closeType;

    @ApiModelProperty(value = "用户openid" )
    @TableField(exist = false)
    private String memberOpenid;
    @ApiModelProperty(value = "查询开始日期（包含）", example = "2023-10-01 15:12:01")
    @TableField(exist = false)
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date startDate;
    @ApiModelProperty(value = "用户openid" )
    @TableField(exist = false)
    private String memberOpenid;
    @ApiModelProperty(value = "查询截止日期（包含）", example = "2023-10-09 15:12:05")
    @TableField(exist = false)
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")

 server/services/src/main/java/com/doumee/dao/business/model/Refund.java

@@ -8,6 +8,7 @@
import com.fasterxml.jackson.annotation.JsonFormat;
import java.util.Date;
import java.math.BigDecimal;
import java.util.List;

/**
 * é€€æ¬¾ä¿¡æ¯è¡¨
@@ -58,6 +59,10 @@
    @ExcelColumn(name="用户编码（关联member表）")
    private String memberId;

    @ApiModelProperty(value = "可退金额", example = "1")
    @ExcelColumn(name="可退回押金（元）" )
    private BigDecimal canBanlance;

    @ApiModelProperty(value = "交易金额", example = "1")
    @ExcelColumn(name="交易金额")
    private BigDecimal money;
@@ -83,9 +88,12 @@
    //@JsonFormat(pattern = "yyyy-MM-dd")
    private Date doneDate;

    @ApiModelProperty(value = "退款类型 0结算退款 1强制结算退款 2结算后退款", example = "1")
    @ExcelColumn(name="退款类型 0结算退款 1强制结算退款 2结算后退款")
    @ApiModelProperty(value = "退款类型 0用户结算退款 1平台自动结算退款 2强制结算退款 3结算后退款'", example = "1")
    @ExcelColumn(name="退款类型 0用户结算退款 1平台自动结算退款 2强制结算退款 3结算后退款'")
    private Integer type;
    @ApiModelProperty(value = "退款类型 0结算退款 1强制结算退款 2结算后退款", example = "1")
    @TableField(exist = false)
    private List<Integer> typeList;

    @ApiModelProperty(value = "退款关联订单编码")
    @ExcelColumn(name="退款关联订单编码")
@@ -94,10 +102,29 @@
    @ApiModelProperty(value = "退款原因")
    @ExcelColumn(name="退款原因")
    private String reason;
    @ApiModelProperty(value = "操作人")
    @TableField(exist = false)
    private String creatorName;

    @ApiModelProperty(value = "用户")
    @TableField(exist = false)
    private String openid;
    @ApiModelProperty(value = "支付押金交易单号")
    @TableField(exist = false)
    private String payOnlineOrderid;


    @ApiModelProperty(value = "交易笔数", example = "0")
    @TableField(exist = false)
    private int countNum;
    @ApiModelProperty(value = "查询开始日期（包含）", example = "2023-10-01 15:12:01")
    @TableField(exist = false)
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date startDate;
    @ApiModelProperty(value = "查询截止日期（包含）", example = "2023-10-09 15:12:05")
    @TableField(exist = false)
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date endDate;


}

 server/services/src/main/java/com/doumee/dao/business/vo/GoodsorderExportVO.java

@@ -23,38 +23,38 @@
public class GoodsorderExportVO {

    @ApiModelProperty(value = "编码")
    @ExcelColumn(name="订单编号",width = 10,align = HorizontalAlignment.CENTER)
    @ExcelColumn(name="订单编号",index = 1,width = 10,align = HorizontalAlignment.CENTER)
    private String id;
    @ApiModelProperty(value = "订单编码")
//    @ExcelColumn(name="订单编码")
    private String code;
    @ApiModelProperty(value = "用户编码（关联member表）")
    @ExcelColumn(name="用户",width = 10,align = HorizontalAlignment.CENTER)
    @ExcelColumn(name="用户",width = 10,index = 2,align = HorizontalAlignment.CENTER)
    private String openid;

    @ApiModelProperty(value = "交易金额")
    @ExcelColumn(name="支付金额",width = 10,align = HorizontalAlignment.CENTER)
    @ExcelColumn(name="支付金额",width = 10,index = 3,align = HorizontalAlignment.CENTER)
    private BigDecimal money;


    @ApiModelProperty(value = "支付时间")
    @ExcelColumn(name="支付时间",width = 10,align = HorizontalAlignment.CENTER)
    @ExcelColumn(name="支付时间",width = 10,index = 4,align = HorizontalAlignment.CENTER)
    private Date payDate;

    @ApiModelProperty(value = "结算金额(分）")
    @ExcelColumn(name="结算金额",width = 10,align = HorizontalAlignment.CENTER)
    @ExcelColumn(name="结算金额",width = 10,index = 5,align = HorizontalAlignment.CENTER)
    private BigDecimal closeMoney;

    @ApiModelProperty(value = "结算时间")
    @ExcelColumn(name="结算时间",width = 10,align = HorizontalAlignment.CENTER)
    @ExcelColumn(name="结算时间",width = 10,index = 6,align = HorizontalAlignment.CENTER)
    private Date closeDate;

    @ApiModelProperty(value = "退款金额(分）")
    @ExcelColumn(name="退款金额",width = 10,align = HorizontalAlignment.CENTER)
    @ExcelColumn(name="退款金额",width = 10,index = 7,align = HorizontalAlignment.CENTER)
    private BigDecimal refundMoney;

    @ApiModelProperty(value = "退款时间")
    @ExcelColumn(name="退款时间",width = 10,align = HorizontalAlignment.CENTER)
    @ExcelColumn(name="退款时间",width = 10,index = 8,align = HorizontalAlignment.CENTER)
    private Date refundDate;

}

 server/services/src/main/java/com/doumee/dao/business/vo/RefundPlatExportVO.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,52 @@
package com.doumee.dao.business.model;

import com.baomidou.mybatisplus.annotation.*;
import com.doumee.core.annotation.excel.ExcelColumn;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import com.fasterxml.jackson.annotation.JsonFormat;
import org.apache.poi.ss.usermodel.HorizontalAlignment;

import java.util.Date;
import java.math.BigDecimal;
import java.util.List;

/**
 * é€€æ¬¾ä¿¡æ¯è¡¨
 * @author æ±Ÿè¹„蹄
 * @date 2023/09/27 18:06
 */
@Data
@ApiModel("后台结算导出信息")
public class RefundPlatExportVO {

    @ApiModelProperty(value = "编码")
    @ExcelColumn(name="编码",width = 10,index = 2,align = HorizontalAlignment.CENTER)
    private String id;
    @ApiModelProperty(value = "用户")
    @ExcelColumn(name="退款交易单号" ,width = 10,index = 2,align = HorizontalAlignment.CENTER)
    private String openid;
    @ApiModelProperty(value = "支付押金交易单号")
    @ExcelColumn(name="退款交易单号" ,width = 10,index = 3,align = HorizontalAlignment.CENTER)
    private String payOnlineOrderid;
    @ApiModelProperty(value = "可退金额", example = "1")
    @ExcelColumn(name="可退回押金（元）"   ,width = 10,index = 4,align = HorizontalAlignment.CENTER)
    private BigDecimal canBanlance;
    @ApiModelProperty(value = "交易金额", example = "1")
    @ExcelColumn(name="退回押金(元)"  ,width = 10,index = 5,align = HorizontalAlignment.CENTER)
    private BigDecimal money;
    @ApiModelProperty(value = "退款交易单号")
    @ExcelColumn(name="退款交易单号" ,width = 10,index = 6,align = HorizontalAlignment.CENTER)
    private String onlineOrderid;
    @ApiModelProperty(value = "操作时间")
    @ExcelColumn(name="操作时间" ,width = 10,index = 7,align = HorizontalAlignment.CENTER)
    private Date doneDate;
    @ApiModelProperty(value = "操作人")
    @ExcelColumn(name="退款交易单号" ,width = 10,index = 8,align = HorizontalAlignment.CENTER)
    private String creatorName;
    @ApiModelProperty(value = "退款原因")
    @ExcelColumn(name="原因" ,width = 10,index = 9,align = HorizontalAlignment.CENTER)
    private String reason;

}

 server/services/src/main/java/com/doumee/service/business/RefundService.java

@@ -3,6 +3,8 @@
import com.doumee.core.model.PageData;
import com.doumee.core.model.PageWrap;
import com.doumee.dao.business.model.Refund;
import com.doumee.dao.business.model.RefundPlatExportVO;

import java.util.List;

/**
@@ -94,4 +96,8 @@
     * @return long
     */
    long count(Refund refund);

    PageData<Refund>  findPlatPage(PageWrap<Refund> pageWrap);

    List<RefundPlatExportVO>  findPlatExportPage(  Refund pageWrap);
}

 server/services/src/main/java/com/doumee/service/business/impl/GoodsorderServiceImpl.java

@@ -151,14 +151,14 @@
    @Override
    public   List<GoodsorderExportVO> findExportNotBikPage(Goodsorder model){
        List<GoodsorderExportVO> list = new ArrayList<>();
        model.setPayStatus(Constants.ONE); //只查询支付成功的
        MPJLambdaWrapper<Goodsorder> queryWrapper = initQueryParamByModel(model);

        List<Goodsorder> goodsorderList = goodsorderJoinMapper.selectJoinList(Goodsorder.class,queryWrapper);
        if(goodsorderList!=null){
            for(Goodsorder order : goodsorderList){
                GoodsorderExportVO vo = new GoodsorderExportVO();
                vo.setId(order.getId());
                vo.setOpenid(order.getMemberName());
                vo.setOpenid(order.getMemberOpenid());
                vo.setPayDate(order.getPayDate());
                vo.setCloseDate(order.getCloseDate());
                vo.setCloseDate(order.getCloseDate());
@@ -173,8 +173,7 @@
    private MPJLambdaWrapper<Goodsorder> initQueryParamByModel(Goodsorder model) {
        MPJLambdaWrapper<Goodsorder> queryWrapper = new MPJLambdaWrapper<>();
        Utils.MP.blankToNull(model);
        //只查询支付成功的
        model.setPayStatus(Constants.ONE);

        queryWrapper.selectAll(Goodsorder.class);
        queryWrapper.selectAs(Member::getOpenid, Goodsorder::getMemberOpenid);
        queryWrapper.leftJoin(Member.class, Member::getId  ,Goodsorder::getMemberId);

 server/services/src/main/java/com/doumee/service/business/impl/RefundServiceImpl.java

@@ -1,19 +1,30 @@
package com.doumee.service.business.impl;

import com.doumee.core.constants.Constants;
import com.doumee.core.model.PageData;
import com.doumee.core.model.PageWrap;
import com.doumee.core.utils.Utils;
import com.doumee.dao.business.RefundMapper;
import com.doumee.dao.business.join.RefundJoinMapper;
import com.doumee.dao.business.model.Goodsorder;
import com.doumee.dao.business.model.Member;
import com.doumee.dao.business.model.Refund;
import com.doumee.dao.business.model.RefundPlatExportVO;
import com.doumee.dao.business.vo.GoodsorderExportVO;
import com.doumee.dao.system.model.SystemUser;
import com.doumee.service.business.RefundService;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.github.yulichang.wrapper.MPJLambdaWrapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.util.CollectionUtils;

import java.math.BigDecimal;
import java.sql.Ref;
import java.util.ArrayList;
import java.util.List;

/**
@@ -26,6 +37,8 @@

    @Autowired
    private RefundMapper refundMapper;
    @Autowired
    private RefundJoinMapper refundJoinMapper;

    @Override
    public String create(Refund refund) {
@@ -85,75 +98,73 @@
    }
  
    @Override
    public PageData<Refund>  findPlatPage(PageWrap<Refund> pageWrap) {
        pageWrap.getModel().setTypeList(new ArrayList<>());
        //强制结算退款 å’Œ ç»“算后退款
        pageWrap.getModel().getTypeList().add(Constants.REFUND_TYPE.PLAT_FORCE.getKey());
        pageWrap.getModel().getTypeList().add(Constants.REFUND_TYPE.BACK.getKey());
        pageWrap.getModel().setStatus(Constants.TWO);
        IPage<Goodsorder> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
        MPJLambdaWrapper<Refund> queryWrapper = initQueryParamByModel(pageWrap.getModel());
        return PageData.from(refundJoinMapper.selectJoinPage(page, Refund.class,queryWrapper));
    }
    @Override
    public List<RefundPlatExportVO>  findPlatExportPage( Refund pageWrap) {
        pageWrap.setTypeList(new ArrayList<>());
        //强制结算退款 å’Œ ç»“算后退款
        pageWrap.getTypeList().add(Constants.REFUND_TYPE.PLAT_FORCE.getKey());
        pageWrap.getTypeList().add(Constants.REFUND_TYPE.BACK.getKey());
        pageWrap.setStatus(Constants.TWO);
        MPJLambdaWrapper<Refund> queryWrapper = initQueryParamByModel(pageWrap);

        List<Refund> list = refundJoinMapper.selectJoinList(  Refund.class,queryWrapper);
        List<RefundPlatExportVO> result = new ArrayList<>();

        if(list!=null){
            for(Refund order : list){
                RefundPlatExportVO vo = new RefundPlatExportVO();
                vo.setId(order.getId());
                vo.setOpenid(order.getOpenid());
                vo.setDoneDate(order.getDoneDate());
                vo.setMoney(Constants.formatDecimalNum(order.getMoney()).divide(new BigDecimal(100), 2, BigDecimal.ROUND_UP));
                vo.setCanBanlance(Constants.formatDecimalNum(order.getCanBanlance()).divide(new BigDecimal(100), 2, BigDecimal.ROUND_UP));
                vo.setOnlineOrderid(order.getOnlineOrderid());
                vo.setPayOnlineOrderid(order.getPayOnlineOrderid());
                vo.setCreatorName(order.getCreatorName());
                vo.setReason(order.getReason());
                result.add(vo);
            }
        }
        return  result;
    }

    private MPJLambdaWrapper<Refund> initQueryParamByModel(Refund model) {
        MPJLambdaWrapper<Refund> queryWrapper = new MPJLambdaWrapper<>();
        Utils.MP.blankToNull(model);
        //只查询支付成功的
        queryWrapper.selectAll(Refund.class);
        queryWrapper.selectAs(SystemUser::getRealname, Refund::getCreatorName);
        queryWrapper.selectAs(Member::getOpenid, Refund::getOpenid);
        queryWrapper.leftJoin(Goodsorder.class, Goodsorder::getId  ,Refund::getObjId);
        queryWrapper.leftJoin(Member.class, Member::getId  ,Goodsorder::getMemberId);
        queryWrapper.leftJoin(SystemUser.class, SystemUser::getId  ,Refund::getCreator);
        //时间段筛选
        queryWrapper.ge(model.getStartDate()!=null, Refund::getDoneDate, model.getStartDate());
        queryWrapper.le(model.getEndDate()!=null, Refund::getDoneDate, model.getEndDate());
        queryWrapper.eq(model.getCreator() !=null,Refund::getCreator,model.getCreator());
        queryWrapper.eq(model.getStatus() !=null,Refund::getStatus,model.getStatus());
        queryWrapper.like(model.getPayOnlineOrderid() !=null,Goodsorder::getOnlineOrderid,model.getPayOnlineOrderid());
        queryWrapper.like(model.getOnlineOrderid() !=null,Refund::getOnlineOrderid,model.getOnlineOrderid());
        queryWrapper.like(model.getOpenid() !=null,Member::getOpenid,model.getOpenid());
        queryWrapper.eq(Goodsorder::getIsdeleted,Constants.ZERO);
        queryWrapper.orderByDesc(Refund::getDoneDate);
        return  queryWrapper;
    }
    @Override
    public PageData<Refund> findPage(PageWrap<Refund> pageWrap) {
        IPage<Refund> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
        QueryWrapper<Refund> queryWrapper = new QueryWrapper<>();
        Utils.MP.blankToNull(pageWrap.getModel());
        if (pageWrap.getModel().getId() != null) {
            queryWrapper.lambda().eq(Refund::getId, pageWrap.getModel().getId());
        }
        if (pageWrap.getModel().getCreateDate() != null) {
            queryWrapper.lambda().ge(Refund::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate()));
            queryWrapper.lambda().le(Refund::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate()));
        }
        if (pageWrap.getModel().getCreator() != null) {
            queryWrapper.lambda().eq(Refund::getCreator, pageWrap.getModel().getCreator());
        }
        if (pageWrap.getModel().getEditDate() != null) {
            queryWrapper.lambda().ge(Refund::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate()));
            queryWrapper.lambda().le(Refund::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate()));
        }
        if (pageWrap.getModel().getEditor() != null) {
            queryWrapper.lambda().eq(Refund::getEditor, pageWrap.getModel().getEditor());
        }
        if (pageWrap.getModel().getIsdeleted() != null) {
            queryWrapper.lambda().eq(Refund::getIsdeleted, pageWrap.getModel().getIsdeleted());
        }
        if (pageWrap.getModel().getInfo() != null) {
            queryWrapper.lambda().eq(Refund::getInfo, pageWrap.getModel().getInfo());
        }
        if (pageWrap.getModel().getCode() != null) {
            queryWrapper.lambda().eq(Refund::getCode, pageWrap.getModel().getCode());
        }
        if (pageWrap.getModel().getMemberId() != null) {
            queryWrapper.lambda().eq(Refund::getMemberId, pageWrap.getModel().getMemberId());
        }
        if (pageWrap.getModel().getMoney() != null) {
            queryWrapper.lambda().eq(Refund::getMoney, pageWrap.getModel().getMoney());
        }
        if (pageWrap.getModel().getStatus() != null) {
            queryWrapper.lambda().eq(Refund::getStatus, pageWrap.getModel().getStatus());
        }
        if (pageWrap.getModel().getPreOrderid() != null) {
            queryWrapper.lambda().eq(Refund::getPreOrderid, pageWrap.getModel().getPreOrderid());
        }
        if (pageWrap.getModel().getOnlineOrderid() != null) {
            queryWrapper.lambda().eq(Refund::getOnlineOrderid, pageWrap.getModel().getOnlineOrderid());
        }
        if (pageWrap.getModel().getPayWay() != null) {
            queryWrapper.lambda().eq(Refund::getPayWay, pageWrap.getModel().getPayWay());
        }
        if (pageWrap.getModel().getDoneDate() != null) {
            queryWrapper.lambda().ge(Refund::getDoneDate, Utils.Date.getStart(pageWrap.getModel().getDoneDate()));
            queryWrapper.lambda().le(Refund::getDoneDate, Utils.Date.getEnd(pageWrap.getModel().getDoneDate()));
        }
        if (pageWrap.getModel().getType() != null) {
            queryWrapper.lambda().eq(Refund::getType, pageWrap.getModel().getType());
        }
        if (pageWrap.getModel().getObjId() != null) {
            queryWrapper.lambda().eq(Refund::getObjId, pageWrap.getModel().getObjId());
        }
        if (pageWrap.getModel().getReason() != null) {
            queryWrapper.lambda().eq(Refund::getReason, pageWrap.getModel().getReason());
        }
        for(PageWrap.SortData sortData: pageWrap.getSorts()) {
            if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) {
                queryWrapper.orderByDesc(sortData.getProperty());
            } else {
                queryWrapper.orderByAsc(sortData.getProperty());
            }
        }
        return PageData.from(refundMapper.selectPage(page, queryWrapper));
        IPage<Goodsorder> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
        MPJLambdaWrapper<Refund> queryWrapper = initQueryParamByModel(pageWrap.getModel());
        return PageData.from(refundJoinMapper.selectJoinPage(page, Refund.class,queryWrapper));
    }

    @Override