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);
|
|
IPage<PointsLedgerRow> selectAppLedgerPage(IPage<PointsLedgerRow> page,
|
@Param("appUserId") Long appUserId,
|
@Param("incomeExpenseType") String incomeExpenseType);
|
|
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();
|
}
|