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
package com.tcm.training.admin.trade.mapper;
 
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.tcm.training.admin.trade.entity.PaymentFlow;
import com.tcm.training.admin.trade.row.PaymentFlowRow;
import com.tcm.training.admin.trade.row.PaymentFlowSyncRow;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
 
import java.time.LocalDateTime;
import java.util.List;
 
@Mapper
public interface PaymentFlowMapper extends BaseMapper<PaymentFlow> {
 
    IPage<PaymentFlowRow> selectPaymentFlowPage(IPage<PaymentFlowRow> page,
                                                @Param("flowNo") String flowNo,
                                                @Param("businessOrderNo") String businessOrderNo,
                                                @Param("userPhone") String userPhone,
                                                @Param("productKeyword") String productKeyword,
                                                @Param("businessType") String businessType,
                                                @Param("flowType") String flowType,
                                                @Param("paymentMethod") String paymentMethod,
                                                @Param("tradeStatus") String tradeStatus,
                                                @Param("tradeFrom") LocalDateTime tradeFrom,
                                                @Param("tradeTo") LocalDateTime tradeTo);
 
    List<PaymentFlowRow> selectPaymentFlowList(@Param("flowNo") String flowNo,
                                               @Param("businessOrderNo") String businessOrderNo,
                                               @Param("userPhone") String userPhone,
                                               @Param("productKeyword") String productKeyword,
                                               @Param("businessType") String businessType,
                                               @Param("flowType") String flowType,
                                               @Param("paymentMethod") String paymentMethod,
                                               @Param("tradeStatus") String tradeStatus,
                                               @Param("tradeFrom") LocalDateTime tradeFrom,
                                               @Param("tradeTo") LocalDateTime tradeTo);
 
    List<PaymentFlowSyncRow> selectMissingCoursePaymentRows();
 
    List<PaymentFlowSyncRow> selectMissingCourseRefundRows();
 
    List<PaymentFlowSyncRow> selectMissingMemberPaymentRows();
 
    List<PaymentFlowSyncRow> selectMissingMemberRefundRows();
}