easyexcel自定义合并策略和自定义消息转换器

EasyExce简单使用案例
Easyexcel针对导出的订单进行合并

背景

退款系统，导出订单详细信息，订单中有需要合并的列需要对其列中同样的数据进行合并

具体难点

比如用户ID，一个用户有多个订单所以需要将用户id同样的进行合并，同时从数据库查询出来的话还uid可能不在一起还需要排序处理

最终实现效果

主要是实现合并

订单实体OrderPayModel

1、long类型用自带的LongStringConverter转换器处理，给它转换成了字符类型。这里不知道为什么它有默认的转换器没有去转换，而日期自动就去转换了，后面再研究吧
2、CashType、PayStatus、OrderStatus、PayResultStatus、NotifyResultStatus 这些是类的属性，需要我们自己去写转换器进行转换

    @Getter
    @Setter
    @EqualsAndHashCode
    @ToString
    public class OrderPayModel{
        @ColumnWidth(20)
        @ExcelProperty({"用户id"})
        private long uid;
        @ColumnWidth(10)
        @ExcelProperty({"余额"})
        private int balance;
        @ColumnWidth(10)
        @ExcelProperty({"赠币"})
        private int coupon;
        @ColumnWidth(14)
        @ExcelProperty({"合计退款"})
        private int totalRefundAmount;
        @ColumnWidth(14)
        @ExcelProperty({"差额"})
        private int differenceAmount;
        @ColumnWidth(10)
        @ExcelProperty({"产品线"})
        private String appId;
        @ColumnWidth(30)
        @ExcelProperty({"订单号"})
        private String orderNo;
        @ColumnWidth(32)
        @ExcelProperty({"外部订单号"})
        private String outTradeNo;
        @ColumnWidth(12)
        @ExcelProperty({"订单金额"})
        private Integer amount;
        @ColumnWidth(15)
        @ExcelProperty({"商品名称"})
        private String productName;
        @ColumnWidth(20)
        @ExcelProperty({"订单创建时间"})
        private Date createTime;


        @ExcelIgnore
        private int payId;

        @ColumnWidth(12)
        @ExcelProperty({"支付类型"})
        private CashType payType;
        @ColumnWidth(12)
        @ExcelProperty({"付款金额"})
        private int payAmount;
        @ColumnWidth(12)
        @ExcelProperty({"退款金额"})
        private int refundAmount;
        @ColumnWidth(12)
        @ExcelProperty({"是否全退"})
        private String isRefundAll;
        @ColumnWidth(12)
        @ExcelProperty({"支付状态"})
        private PayStatus payStatus;
        @ColumnWidth(20)
        @ExcelProperty({"支付时间"})
        private Date payTime;
        @ColumnWidth(30)
        @ExcelProperty({"交易流水号"})
        private String transactionId;

        @ColumnWidth(12)
        @ExcelProperty({"支付状态"})
        private OrderStatus orderStatus;
        @ColumnWidth(12)
        @ExcelProperty({"支付结果"})
        private PayResultStatus payResult;
        @ColumnWidth(12)
        @ExcelProperty({"通知结果"})
        private NotifyResultStatus notifyResult;
    }
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75

自定义合并策略

这个可以参考LoopMergeStrategy和OnceAbsoluteMergeStrategy实现自己想要的功能。
思路：就是拿到需要合并的uid即用户ID以前对其排序，相同的uid放在一起，然后去合并的时候提前预处理一下，把这些需要合并的uid进行分组，分组集合中存放的数字是需要合并的uid合并的行数，默认1不需要合并
注意点
1、继承了AbstractMergeStrategy，它的方法afterCellDispose默认就过滤了头，我们不需要子类去重写它了，因为头已经过滤了，我们只需要重写它的merge方法，自己去定义合并
2、这里我们需要着重的理解下rowIndex，这个是开始合并的初始行，我们利用了跳过了头，从第一行开始，刚好从第一行遍历列到第四列，就合并完成了。以后再进来就不满足条件了。另外这里也可以自己放到外面，比如new对象的时候把它传进来，但是一般都是从第一行开始合并的，所以在类中直接写死了。
3、其他需要注意的点都在代码中注释了。

public class CustomMergeStrategy extends AbstractMergeStrategy {

    /**
     * 合并的行 分组合并  [1 1 2] 代表第二、三行不需要合并、四五行需要合并成一个单元格
     */
    private List<Integer>mergeFieldGroup;

    /**
     * 目标合并列下标
     */
    private List<Integer>targetColumnIndex;

    // 合并的行起始 除了头开始合并并且只合并一次(一次就把目标合并的列下所有行统一合并)
    private Integer rowIndex;


    /**
     *
     * @param mergeFieldGroup 需要进行合并的uid集合 即 针对集合中相同的uid进行合并
     * @param targetColumnIndex 要进行合并的列都有哪些列 即 目标合并列下标
     */
    public CustomMergeStrategy(List<String> mergeFieldGroup, List<Integer> targetColumnIndex) {
        // 相同的集合需要处理一下 比如 uid集合为[1,1,2,2,2,3] 那么处理后的形成一个分组 [2,3,1]说明第[2~3]、[4~6]需要合并 这里默认头为第一行
        this.mergeFieldGroup = mergeFieldGroupFormat(mergeFieldGroup);
        this.targetColumnIndex = targetColumnIndex;
    }

    /**
     *
     * @param mergeFieldGroup
     * 统计每个uid要合并个数
     * @return
     */
    private List<Integer> mergeFieldGroupFormat(List<String> mergeFieldGroup) {
        if(CollectionUtils.isEmpty(mergeFieldGroup)){
            return Collections.emptyList();
        }
        List<Integer>mergeFieldGroupFormat=new ArrayList<>();
        //uid需要合并的个数 值为1 的时候不需要合并
        int rowCnt=1;
        // 从第二个元素开始比较前一个相同 防止指针越界
        for (int i = 1; i < mergeFieldGroup.size(); i++) {
            if(mergeFieldGroup.get(i).equals(mergeFieldGroup.get(i-1))){
                rowCnt++;
            }else {
                mergeFieldGroupFormat.add(rowCnt);
                rowCnt=1;
            }
        }
        mergeFieldGroupFormat.add(rowCnt);
        return mergeFieldGroupFormat;
    }

    @Override
    protected void merge(Sheet sheet, Cell cell, Head head, Integer relativeRowIndex) {

        if(Objects.equals(null,rowIndex)){
            //第一次null 开始合并 此后不在合并
            rowIndex=cell.getRowIndex();
        }
        if(cell.getRowIndex()== rowIndex && targetColumnIndex.contains(cell.getColumnIndex())){
            mergeGroupColum(sheet,cell.getColumnIndex());
        }
    }

    private void mergeGroupColum(Sheet sheet, int columnIndex) {
        // currentRow 当前所在的行
        int currentRow=rowIndex;
        for(Integer count:mergeFieldGroup){
            if(count.equals(1)){//不需要合并
                currentRow+=count;// 这里要一直统计当前行位置
                continue;
            }
            // merge cell 参考 LoopMergeStrategy 合并策略
            sheet.addMergedRegionUnsafe(new CellRangeAddress(currentRow,currentRow+count-1,columnIndex,columnIndex));
            currentRow+=count;
        }
    }
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79

自定义转换器(一些状态转换)

这个主要用来对实体中的属性进行转换

CashTypeStringConverter

package com.xxx.excel.converters;

import com.alibaba.excel.converters.Converter;
import com.alibaba.excel.enums.CellDataTypeEnum;
import com.alibaba.excel.metadata.GlobalConfiguration;
import com.alibaba.excel.metadata.data.ReadCellData;
import com.alibaba.excel.metadata.data.WriteCellData;
import com.alibaba.excel.metadata.property.ExcelContentProperty;
import com.alibaba.excel.util.NumberUtils;
import com.xxx.excel.consts.CashType;

public class CashTypeStringConverter implements Converter<CashType> {
    public CashTypeStringConverter() {
    }

    public Class<CashType> supportJavaTypeKey() {
        return CashType.class;
    }

    public CellDataTypeEnum supportExcelTypeKey() {
        return CellDataTypeEnum.STRING;
    }

    @Override
    public CashType convertToJavaData(ReadCellData cellData, ExcelContentProperty excelContentProperty
            , GlobalConfiguration globalConfiguration) throws Exception {
        return CashType.from((NumberUtils.parseInteger(cellData.getStringValue(), excelContentProperty)));
    }

    @Override
    public WriteCellData convertToExcelData(CashType value, ExcelContentProperty excelContentProperty
            , GlobalConfiguration globalConfiguration) throws Exception {
        return new WriteCellData(value.text);
    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36

OrderStatusStringConverter

package com.xxx.excel.converters;

import com.alibaba.excel.converters.Converter;
import com.alibaba.excel.enums.CellDataTypeEnum;
import com.alibaba.excel.metadata.GlobalConfiguration;
import com.alibaba.excel.metadata.data.ReadCellData;
import com.alibaba.excel.metadata.data.WriteCellData;
import com.alibaba.excel.metadata.property.ExcelContentProperty;
import com.alibaba.excel.util.NumberUtils;
import com.xxx.excel.consts.OrderStatus;

public class OrderStatusStringConverter implements Converter<OrderStatus> {
    public OrderStatusStringConverter() {
    }

    @Override
    public Class<OrderStatus> supportJavaTypeKey() {
        return OrderStatus.class;
    }

    @Override
    public CellDataTypeEnum supportExcelTypeKey() {
        return CellDataTypeEnum.STRING;
    }

    @Override
    public OrderStatus convertToJavaData(ReadCellData cellData, ExcelContentProperty excelContentProperty
            , GlobalConfiguration globalConfiguration) throws Exception {
        return OrderStatus.from((NumberUtils.parseInteger(cellData.getStringValue(), excelContentProperty)));
    }

    @Override
    public WriteCellData convertToExcelData(OrderStatus value, ExcelContentProperty excelContentProperty
            , GlobalConfiguration globalConfiguration) throws Exception {
        return new WriteCellData(value.getText());
    }

}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39

PayStatusStringConverter

package com.xxx.excel.converters;

import com.alibaba.excel.converters.Converter;
import com.alibaba.excel.enums.CellDataTypeEnum;
import com.alibaba.excel.metadata.GlobalConfiguration;
import com.alibaba.excel.metadata.data.ReadCellData;
import com.alibaba.excel.metadata.data.WriteCellData;
import com.alibaba.excel.metadata.property.ExcelContentProperty;
import com.alibaba.excel.util.NumberUtils;
import com.xxx.excel.consts.PayStatus;

public class PayStatusStringConverter implements Converter<PayStatus> {
    public PayStatusStringConverter() {
    }

    @Override
    public Class<PayStatus> supportJavaTypeKey() {
        return PayStatus.class;
    }

    @Override
    public CellDataTypeEnum supportExcelTypeKey() {
        return CellDataTypeEnum.STRING;
    }

    @Override
    public PayStatus convertToJavaData(ReadCellData cellData, ExcelContentProperty excelContentProperty
            , GlobalConfiguration globalConfiguration) throws Exception {
        return PayStatus.from((NumberUtils.parseInteger(cellData.getStringValue(), excelContentProperty)));
    }

    @Override
    public WriteCellData convertToExcelData(PayStatus value, ExcelContentProperty excelContentProperty
            , GlobalConfiguration globalConfiguration) throws Exception {
        return new WriteCellData(value.getText());
    }

}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39

PayResultStatusStringConverter

package com.xxx.excel.converters;

import com.alibaba.excel.converters.Converter;
import com.alibaba.excel.enums.CellDataTypeEnum;
import com.alibaba.excel.metadata.GlobalConfiguration;
import com.alibaba.excel.metadata.data.ReadCellData;
import com.alibaba.excel.metadata.data.WriteCellData;
import com.alibaba.excel.metadata.property.ExcelContentProperty;
import com.alibaba.excel.util.NumberUtils;
import com.xxx.excel.consts.PayResultStatus;

public class PayResultStatusStringConverter implements Converter<PayResultStatus> {
    public PayResultStatusStringConverter() {
    }

    @Override
    public Class<PayResultStatus> supportJavaTypeKey() {
        return PayResultStatus.class;
    }

    @Override
    public CellDataTypeEnum supportExcelTypeKey() {
        return CellDataTypeEnum.STRING;
    }

    @Override
    public PayResultStatus convertToJavaData(ReadCellData cellData, ExcelContentProperty excelContentProperty
            , GlobalConfiguration globalConfiguration) throws Exception {
        return PayResultStatus.from((NumberUtils.parseInteger(cellData.getStringValue(), excelContentProperty)));
    }

    @Override
    public WriteCellData convertToExcelData(PayResultStatus value, ExcelContentProperty excelContentProperty
            , GlobalConfiguration globalConfiguration) throws Exception {
        return new WriteCellData(value.getText());
    }

}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39

NotifyResultStatusStringConverter

package com.xxx.excel.converters;

import com.alibaba.excel.converters.Converter;
import com.alibaba.excel.enums.CellDataTypeEnum;
import com.alibaba.excel.metadata.GlobalConfiguration;
import com.alibaba.excel.metadata.data.ReadCellData;
import com.alibaba.excel.metadata.data.WriteCellData;
import com.alibaba.excel.metadata.property.ExcelContentProperty;
import com.alibaba.excel.util.NumberUtils;
import com.xxx.excel.consts.NotifyResultStatus;

public class NotifyResultStatusStringConverter implements Converter<NotifyResultStatus> {
    public NotifyResultStatusStringConverter() {
    }

    @Override
    public Class<NotifyResultStatus> supportJavaTypeKey() {
        return NotifyResultStatus.class;
    }

    @Override
    public CellDataTypeEnum supportExcelTypeKey() {
        return CellDataTypeEnum.STRING;
    }

    @Override
    public NotifyResultStatus convertToJavaData(ReadCellData cellData, ExcelContentProperty excelContentProperty
            , GlobalConfiguration globalConfiguration) throws Exception {
        return NotifyResultStatus.from((NumberUtils.parseInteger(cellData.getStringValue(), excelContentProperty)));
    }

    @Override
    public WriteCellData convertToExcelData(NotifyResultStatus value, ExcelContentProperty excelContentProperty
            , GlobalConfiguration globalConfiguration) throws Exception {
        return new WriteCellData(value.text);
    }

}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39

转换实体

CashType

package com.xxx.excel.consts;

/**
 * @author liuyuanyuan on 2022/11/22
 * 1. 微信; 2. 支付宝
 */

public enum CashType {
    WEIXIN(1, "微信"),
    ALIPAY(2,"支付宝"),
    APPLE(3,"Apple"),
    COIN(11,"钱包"),
    UNKNOWN(-1,"unknown");


    public  int id;

    public  String text;

    CashType(Integer id, String text) {
        this.id = id;
        this.text = text;
    }

    public static CashType from(int id) {
        for(CashType cashType:CashType.values()){
            if(cashType.getId()==id){
                return cashType;
            }
        }
        return UNKNOWN;
    }
    public int getId(){
        return id;
    }
    public String getText(){
        return text;
    }

}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41

NotifyResultStatus

package com.xxx.excel.consts;

/**
 * @author liuyuanyuan on 2022/11/22
 */
public enum NotifyResultStatus {
    Normal(0,"初始化"),
    Success(1,"通知成功"),
    Failure(2,"通知失败"),
    UNKNOWN(-1,"UNKNOWN");
    public  int id;

    public  String text;

    NotifyResultStatus(int id, String text) {
        this.id = id;
        this.text = text;
    }

    public int getId() {
        return id;
    }

    public String getText() {
        return text;
    }
    public static NotifyResultStatus from(int id) {
        for(NotifyResultStatus notifyResultStatus:NotifyResultStatus.values()){
            if(notifyResultStatus.getId()==id){
                return notifyResultStatus;
            }
        }
        return UNKNOWN;
    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36

OrderStatus

package com.xxx.excel.consts;

/**
 * @author liuyuanyuan on 2022/11/22
 */
public enum OrderStatus {

    ReceivingOrder(1, "接收订单"),
    ToPay(2, "待支付"),
    PayCompleted(3, "支付完成"),
    TransactionCompleted(4, "交易成功"),
    TransactionFailed(5, "交易失败"),
    UNKNOWN(-1,"UNKNOWN");

    private int id;
    private String text;

    OrderStatus(int id, String text) {
        this.id = id;
        this.text = text;
    }

    public int getId() {
        return id;
    }

    public String getText() {
        return text;
    }
    public static OrderStatus from(int id){
        for(OrderStatus orderStatus:OrderStatus.values()){
            if(orderStatus.getId()==id){
                return orderStatus;
            }
        }
        return UNKNOWN;
    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39

PayResultStatus

package com.xxx.excel.consts;

/**
 * @author liuyuanyuan on 2022/11/22
 */
public enum PayResultStatus {
    Normal(0,"初始化"),
    Success(1,"支付成功"),
    Failure(2,"支付失败"),
    UNKNOWN(-1,"UNKNOWN");

    private int id;
    private String text;

    PayResultStatus(int id, String text) {
        this.id = id;
        this.text = text;
    }

    public int getId() {
        return id;
    }

    public String getText() {
        return text;
    }
    public static PayResultStatus from(int id){
        for(PayResultStatus payResultStatus:PayResultStatus.values()){
            if(payResultStatus.getId()==id){
                return payResultStatus;
            }
        }
        return UNKNOWN;
    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36

PayStatus

package com.xxx.excel.consts;

/**
 * @author liuyuanyuan on 2022/11/22
 */
public enum PayStatus {
    ToPay(1,"等待支付"),
    Cancel(2,"取消"),
    TimeoutOff(3,"超时关闭"),
    Success(4,"支付成功"),
    RepeatPay(5,"重复支付"),
    UNKNOWN(-1,"UNKNOWN")
    ;
    private int id;
    private String text;


    PayStatus(int id, String text){
        this.id=id;
        this.text=text;
    }
    public int getId() {
        return id;
    }

    public String getText() {
        return text;
    }
    public static PayStatus from(int id){
        for(PayStatus payStatus:PayStatus.values()){
            if(payStatus.getId()==id){
                return payStatus;
            }
        }
        return UNKNOWN;
    }

}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39

结果

测试自定义合并策略和自定义转换器

@Test
    void custommergeWrite(){
        String fileName = path + "custommergeWrite" + System.currentTimeMillis() + ".xlsx";
        List<OrderPayModel> orderPayModels = getOrderPayModels();
        EasyExcel.write(fileName,OrderPayModel.class)
                .registerWriteHandler(new CustomMergeStrategy(orderPayModels.stream().map(model->String.valueOf(model.getUid())).collect(Collectors.toList()),
                        ListUtils.newArrayList(0,1,2,3,4)))
                        // 这里是表格中有long类型 需要处理
                .registerConverter(new LongStringConverter())
                .registerConverter(new CashTypeStringConverter())
                .registerConverter(new OrderStatusStringConverter())
                .registerConverter(new PayStatusStringConverter())
                .registerConverter(new PayResultStatusStringConverter())
                .registerConverter(new NotifyResultStatusStringConverter())
                .sheet("微信订单")
                .doWrite(orderPayModels);

    }
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

订单数据模拟

这个数据一般是从数据库查询的，这里方便演示，直接模拟了下数据

private List<OrderPayModel> getOrderPayModels(){
        String str="[{\n" +
                "\"amount\": 3,\n" +
                "\"appId\": \"101\",\n" +
                "\"balance\": 600,\n" +
                "\"coupon\": 0,\n" +
                "\"createTime\": 1637551215000,\n" +
                "\"differenceAmount\": 507,\n" +
                "\"isRefundAll\": \"全退\",\n" +
                "\"notifyResult\": \"Success\",\n" +
                "\"orderNo\": \"TDYA211122085596798189568\",\n" +
                "\"orderStatus\": \"TransactionCompleted\",\n" +
                "\"outTradeNo\": \"8ac148e52c424a48a19a749fb2e7523f\",\n" +
                "\"payAmount\": 3,\n" +
                "\"payId\": 204905,\n" +
                "\"payResult\": \"Success\",\n" +
                "\"payStatus\": \"Success\",\n" +
                "\"payTime\": 1637551223000,\n" +
                "\"payType\": \"WEIXIN\",\n" +
                "\"productName\": \"充值3000\",\n" +
                "\"refundAmount\": 3,\n" +
                "\"totalRefundAmount\": 93,\n" +
                "\"transactionId\": \"4200001204202111227976892526\",\n" +
                "\"uid\": 80000438\n" +
                "},{\n" +
                "\"amount\": 1,\n" +
                "\"appId\": \"101\",\n" +
                "\"balance\": 3731,\n" +
                "\"coupon\": 0,\n" +
                "\"createTime\": 1640764608000,\n" +
                "\"differenceAmount\": 3729,\n" +
                "\"isRefundAll\": \"全退\",\n" +
                "\"notifyResult\": \"Success\",\n" +
                "\"orderNo\": \"TDYA211229120393975201792\",\n" +
                "\"orderStatus\": \"TransactionCompleted\",\n" +
                "\"outTradeNo\": \"cb9765a421f640d98619c8a3d648fb12\",\n" +
                "\"payAmount\": 1,\n" +
                "\"payId\": 205052,\n" +
                "\"payResult\": \"Success\",\n" +
                "\"payStatus\": \"Success\",\n" +
                "\"payTime\": 1640764628000,\n" +
                "\"payType\": \"WEIXIN\",\n" +
                "\"productName\": \"充值600\",\n" +
                "\"refundAmount\": 1,\n" +
                "\"totalRefundAmount\": 2,\n" +
                "\"transactionId\": \"4200001385202112298977096001\",\n" +
                "\"uid\": 80000705\n" +
                "},\n" +
                "{\n" +
                "\"amount\": 1,\n" +
                "\"appId\": \"101\",\n" +
                "\"balance\": 3731,\n" +
                "\"coupon\": 0,\n" +
                "\"createTime\": 1640764500000,\n" +
                "\"differenceAmount\": 3729,\n" +
                "\"isRefundAll\": \"全退\",\n" +
                "\"notifyResult\": \"Success\",\n" +
                "\"orderNo\": \"TDYA211229120167059161088\",\n" +
                "\"orderStatus\": \"TransactionCompleted\",\n" +
                "\"outTradeNo\": \"0b79d5c4c3de4ed09f6c3f957cf4ac2c\",\n" +
                "\"payAmount\": 1,\n" +
                "\"payId\": 205051,\n" +
                "\"payResult\": \"Success\",\n" +
                "\"payStatus\": \"Success\",\n" +
                "\"payTime\": 1640764523000,\n" +
                "\"payType\": \"WEIXIN\",\n" +
                "\"productName\": \"充值600\",\n" +
                "\"refundAmount\": 1,\n" +
                "\"totalRefundAmount\": 2,\n" +
                "\"transactionId\": \"4200001381202112294343499890\",\n" +
                "\"uid\": 80000705\n" +
                "},{\n" +
                "\"amount\": 31,\n" +
                "\"appId\": \"101\",\n" +
                "\"balance\": 77,\n" +
                "\"coupon\": 0,\n" +
                "\"createTime\": 1644477333000,\n" +
                "\"differenceAmount\": 17,\n" +
                "\"isRefundAll\": \"全退\",\n" +
                "\"notifyResult\": \"Success\",\n" +
                "\"orderNo\": \"TDYA220210115204503371776\",\n" +
                "\"orderStatus\": \"TransactionCompleted\",\n" +
                "\"outTradeNo\": \"af240aa5cf8449cca52cb3b3cc577a01\",\n" +
                "\"payAmount\": 31,\n" +
                "\"payId\": 205421,\n" +
                "\"payResult\": \"Success\",\n" +
                "\"payStatus\": \"Success\",\n" +
                "\"payTime\": 1644477343000,\n" +
                "\"payType\": \"WEIXIN\",\n" +
                "\"productName\": \"充值31\",\n" +
                "\"refundAmount\": 31,\n" +
                "\"totalRefundAmount\": 60,\n" +
                "\"transactionId\": \"4200001376202202105295797873\",\n" +
                "\"uid\": 1296377728268080892\n" +
                "},{\n" +
                "\"amount\": 1,\n" +
                "\"appId\": \"101\",\n" +
                "\"balance\": 77,\n" +
                "\"coupon\": 0,\n" +
                "\"createTime\": 1641883488000,\n" +
                "\"differenceAmount\": 17,\n" +
                "\"isRefundAll\": \"全退\",\n" +
                "\"notifyResult\": \"Success\",\n" +
                "\"orderNo\": \"TDYA220111111334924484608\",\n" +
                "\"orderStatus\": \"TransactionCompleted\",\n" +
                "\"outTradeNo\": \"3be05371eda54bcaaeaafd642b26f47a\",\n" +
                "\"payAmount\": 1,\n" +
                "\"payId\": 205135,\n" +
                "\"payResult\": \"Success\",\n" +
                "\"payStatus\": \"Success\",\n" +
                "\"payTime\": 1641883566000,\n" +
                "\"payType\": \"WEIXIN\",\n" +
                "\"productName\": \"充值600\",\n" +
                "\"refundAmount\": 1,\n" +
                "\"totalRefundAmount\": 60,\n" +
                "\"transactionId\": \"4200001407202201119718948110\",\n" +
                "\"uid\": 1296377728268080892\n" +
                "},{\n" +
                "\"amount\": 6,\n" +
                "\"appId\": \"101\",\n" +
                "\"balance\": 77,\n" +
                "\"coupon\": 0,\n" +
                "\"createTime\": 1639641952000,\n" +
                "\"differenceAmount\": 17,\n" +
                "\"isRefundAll\": \"全退\",\n" +
                "\"notifyResult\": \"Success\",\n" +
                "\"orderNo\": \"TDYA211216121534838472704\",\n" +
                "\"orderStatus\": \"TransactionCompleted\",\n" +
                "\"outTradeNo\": \"4c376a5938a647518dddb0356e517967\",\n" +
                "\"payAmount\": 6,\n" +
                "\"payId\": 204962,\n" +
                "\"payResult\": \"Success\",\n" +
                "\"payStatus\": \"Success\",\n" +
                "\"payTime\": 1639641959000,\n" +
                "\"payType\": \"WEIXIN\",\n" +
                "\"productName\": \"充值19800\",\n" +
                "\"refundAmount\": 6,\n" +
                "\"totalRefundAmount\": 60,\n" +
                "\"transactionId\": \"4200001415202112164957793301\",\n" +
                "\"uid\": 1296377728268080892\n" +
                "},{\n" +
                "\"amount\": 6,\n" +
                "\"appId\": \"101\",\n" +
                "\"balance\": 77,\n" +
                "\"coupon\": 0,\n" +
                "\"createTime\": 1639640989000,\n" +
                "\"differenceAmount\": 17,\n" +
                "\"isRefundAll\": \"全退\",\n" +
                "\"notifyResult\": \"Success\",\n" +
                "\"orderNo\": \"TDYA211216119516438724608\",\n" +
                "\"orderStatus\": \"TransactionCompleted\",\n" +
                "\"outTradeNo\": \"41482653f5da45d9a7b53cf138f55b58\",\n" +
                "\"payAmount\": 6,\n" +
                "\"payId\": 204961,\n" +
                "\"payResult\": \"Success\",\n" +
                "\"payStatus\": \"Success\",\n" +
                "\"payTime\": 1639640999000,\n" +
                "\"payType\": \"WEIXIN\",\n" +
                "\"productName\": \"充值19800\",\n" +
                "\"refundAmount\": 6,\n" +
                "\"totalRefundAmount\": 60,\n" +
                "\"transactionId\": \"4200001415202112165188105829\",\n" +
                "\"uid\": 1296377728268080892\n" +
                "},{\n" +
                "\"amount\": 5,\n" +
                "\"appId\": \"101\",\n" +
                "\"balance\": 77,\n" +
                "\"coupon\": 0,\n" +
                "\"createTime\": 1639639915000,\n" +
                "\"differenceAmount\": 17,\n" +
                "\"isRefundAll\": \"全退\",\n" +
                "\"notifyResult\": \"Success\",\n" +
                "\"orderNo\": \"TDYA211216117263384444928\",\n" +
                "\"orderStatus\": \"TransactionCompleted\",\n" +
                "\"outTradeNo\": \"e27b9504591647bc95934bc0ce505f5d\",\n" +
                "\"payAmount\": 5,\n" +
                "\"payId\": 204959,\n" +
                "\"payResult\": \"Success\",\n" +
                "\"payStatus\": \"Success\",\n" +
                "\"payTime\": 1639639929000,\n" +
                "\"payType\": \"WEIXIN\",\n" +
                "\"productName\": \"充值9800\",\n" +
                "\"refundAmount\": 5,\n" +
                "\"totalRefundAmount\": 60,\n" +
                "\"transactionId\": \"4200001141202112168829269532\",\n" +
                "\"uid\": 1296377728268080892\n" +
                "},{\n" +
                "\"amount\": 6,\n" +
                "\"appId\": \"101\",\n" +
                "\"balance\": 77,\n" +
                "\"coupon\": 0,\n" +
                "\"createTime\": 1639635870000,\n" +
                "\"differenceAmount\": 17,\n" +
                "\"isRefundAll\": \"全退\",\n" +
                "\"notifyResult\": \"Success\",\n" +
                "\"orderNo\": \"TDYA211216108779391680512\",\n" +
                "\"orderStatus\": \"TransactionCompleted\",\n" +
                "\"outTradeNo\": \"bf5c583f3fb74d38a9b8f58571366dea\",\n" +
                "\"payAmount\": 6,\n" +
                "\"payId\": 204957,\n" +
                "\"payResult\": \"Success\",\n" +
                "\"payStatus\": \"Success\",\n" +
                "\"payTime\": 1639635880000,\n" +
                "\"payType\": \"WEIXIN\",\n" +
                "\"productName\": \"充值19800\",\n" +
                "\"refundAmount\": 6,\n" +
                "\"totalRefundAmount\": 60,\n" +
                "\"transactionId\": \"4200001117202112162971443118\",\n" +
                "\"uid\": 1296377728268080892\n" +
                "},{\n" +
                "\"amount\": 2,\n" +
                "\"appId\": \"101\",\n" +
                "\"balance\": 77,\n" +
                "\"coupon\": 0,\n" +
                "\"createTime\": 1639626282000,\n" +
                "\"differenceAmount\": 17,\n" +
                "\"isRefundAll\": \"全退\",\n" +
                "\"notifyResult\": \"Success\",\n" +
                "\"orderNo\": \"TDYA211216088673385185280\",\n" +
                "\"orderStatus\": \"TransactionCompleted\",\n" +
                "\"outTradeNo\": \"34a22de2ae4f47e6a808eb61c0fb2ca3\",\n" +
                "\"payAmount\": 2,\n" +
                "\"payId\": 204956,\n" +
                "\"payResult\": \"Success\",\n" +
                "\"payStatus\": \"Success\",\n" +
                "\"payTime\": 1639626289000,\n" +
                "\"payType\": \"WEIXIN\",\n" +
                "\"productName\": \"充值1200\",\n" +
                "\"refundAmount\": 2,\n" +
                "\"totalRefundAmount\": 60,\n" +
                "\"transactionId\": \"4200001396202112165178615963\",\n" +
                "\"uid\": 1296377728268080892\n" +
                "},{\n" +
                "\"amount\": 1,\n" +
                "\"appId\": \"101\",\n" +
                "\"balance\": 77,\n" +
                "\"coupon\": 0,\n" +
                "\"createTime\": 1639626250000,\n" +
                "\"differenceAmount\": 17,\n" +
                "\"isRefundAll\": \"全退\",\n" +
                "\"notifyResult\": \"Success\",\n" +
                "\"orderNo\": \"TDYA211216088605340991488\",\n" +
                "\"orderStatus\": \"TransactionCompleted\",\n" +
                "\"outTradeNo\": \"fbdd9875217e4140a463394f810cf7bd\",\n" +
                "\"payAmount\": 1,\n" +
                "\"payId\": 204955,\n" +
                "\"payResult\": \"Success\",\n" +
                "\"payStatus\": \"Success\",\n" +
                "\"payTime\": 1639626258000,\n" +
                "\"payType\": \"WEIXIN\",\n" +
                "\"productName\": \"充值600\",\n" +
                "\"refundAmount\": 1,\n" +
                "\"totalRefundAmount\": 60,\n" +
                "\"transactionId\": \"4200001385202112168103181024\",\n" +
                "\"uid\": 1296377728268080892\n" +
                "},{\n" +
                "\"amount\": 2,\n" +
                "\"appId\": \"101\",\n" +
                "\"balance\": 77,\n" +
                "\"coupon\": 0,\n" +
                "\"createTime\": 1639551949000,\n" +
                "\"differenceAmount\": 17,\n" +
                "\"isRefundAll\": \"全退\",\n" +
                "\"notifyResult\": \"Success\",\n" +
                "\"orderNo\": \"TDYA211215113978585907200\",\n" +
                "\"orderStatus\": \"TransactionCompleted\",\n" +
                "\"outTradeNo\": \"39597284a464433a9583e6f52c231661\",\n" +
                "\"payAmount\": 2,\n" +
                "\"payId\": 204949,\n" +
                "\"payResult\": \"Success\",\n" +
                "\"payStatus\": \"Success\",\n" +
                "\"payTime\": 1639551956000,\n" +
                "\"payType\": \"WEIXIN\",\n" +
                "\"productName\": \"充值1200\",\n" +
                "\"refundAmount\": 2,\n" +
                "\"totalRefundAmount\": 60,\n" +
                "\"transactionId\": \"4200001235202112158640023642\",\n" +
                "\"uid\": 1296377728268080892\n" +
                "}\n" +
                "\n]";
        return JSONArray.parseArray(str,OrderPayModel.class).stream().sorted(Comparator.comparing(OrderPayModel::getUid))
                .collect(Collectors.toList());
    }
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283