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();
}