package com.tcm.training.admin.points.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.tcm.training.admin.points.entity.PointsLedger;
import com.tcm.training.admin.points.row.PointsLedgerRow;
import com.tcm.training.admin.points.row.PointsLedgerSummaryRow;
import com.tcm.training.admin.points.row.PointsLedgerSyncExchangeRow;
import com.tcm.training.admin.points.row.PointsLedgerSyncQuizRow;
import com.tcm.training.admin.points.row.PointsRegionOptionRow;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.time.LocalDateTime;
import java.util.List;

@Mapper
public interface PointsLedgerMapper extends BaseMapper<PointsLedger> {

    IPage<PointsLedgerRow> selectLedgerPage(IPage<PointsLedgerRow> page,
                                            @Param("userPhone") String userPhone,
                                            @Param("regionCode") String regionCode,
                                            @Param("clinicName") String clinicName,
                                            @Param("incomeExpenseType") String incomeExpenseType,
                                            @Param("businessType") String businessType,
                                            @Param("contentKeyword") String contentKeyword,
                                            @Param("referenceNo") String referenceNo,
                                            @Param("operatedFrom") LocalDateTime operatedFrom,
                                            @Param("operatedTo") LocalDateTime operatedTo);

    List<PointsLedgerRow> selectLedgerList(@Param("userPhone") String userPhone,
                                           @Param("regionCode") String regionCode,
                                           @Param("clinicName") String clinicName,
                                           @Param("incomeExpenseType") String incomeExpenseType,
                                           @Param("businessType") String businessType,
                                           @Param("contentKeyword") String contentKeyword,
                                           @Param("referenceNo") String referenceNo,
                                           @Param("operatedFrom") LocalDateTime operatedFrom,
                                           @Param("operatedTo") LocalDateTime operatedTo);

    PointsLedgerSummaryRow selectLedgerSummary(@Param("userPhone") String userPhone,
                                               @Param("regionCode") String regionCode,
                                               @Param("clinicName") String clinicName,
                                               @Param("incomeExpenseType") String incomeExpenseType,
                                               @Param("businessType") String businessType,
                                               @Param("contentKeyword") String contentKeyword,
                                               @Param("referenceNo") String referenceNo,
                                               @Param("operatedFrom") LocalDateTime operatedFrom,
                                               @Param("operatedTo") LocalDateTime operatedTo);

    List<PointsRegionOptionRow> selectRegionOptions();

    List<PointsLedgerSyncQuizRow> selectMissingQuizLedgerRows();

    List<PointsLedgerSyncExchangeRow> selectMissingExchangeLedgerRows();
}