package com.stylefeng.guns.modular.system.dao;

import com.baomidou.mybatisplus.plugins.Page;
import com.stylefeng.guns.modular.system.model.UserCouponRecord;
import com.baomidou.mybatisplus.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * <p>
 * 用户优惠券记录 Mapper 接口
 * </p>
 *
 * @author stylefeng
 * @since 2020-06-17
 */
public interface UserCouponRecordMapper extends BaseMapper<UserCouponRecord> {
    List<Map<String,Object>> getList(@Param("page") Page<Map<String, Object>> page,
                                     @Param("beginTime") String beginTime,
                                     @Param("endTime") String endTime,
                                     @Param("userName") String userName,
                                     @Param("userPhone") String userPhone,
                                     @Param("couponActivityId") Integer couponActivityId,
                                     @Param("activityType") Integer activityType,
                                     @Param("state") Integer state);

    List<Map<String,Object>> getRedList(@Param("page") Page<Map<String, Object>> page,
                                     @Param("beginTime") String beginTime,
                                     @Param("endTime") String endTime,
                                     @Param("userName") String userName,
                                     @Param("userPhone") String userPhone,
                                     @Param("couponActivityId") Integer couponActivityId,
                                     @Param("state") Integer state);

    Map<String,Object> getCouponStatic(
                                     @Param("beginTime") String beginTime,
                                     @Param("endTime") String endTime,
                                     @Param("activityId") Integer activityId,
                                     @Param("activityType") Integer activityType);

    Map<String,Object> getRedStatic(
            @Param("beginTime") String beginTime,
            @Param("endTime") String endTime,
            @Param("activityId") Integer activityId);

    Map<String,Object> getRegStatic(
            @Param("beginTime") String beginTime,
            @Param("endTime") String endTime,
            @Param("activityId") Integer activityId);

    Map<String,Object> getDiscountStatic(
            @Param("beginTime") String beginTime,
            @Param("endTime") String endTime,
            @Param("activityId") Integer activityId);

    List<Map<String,Object>> getBlanceList(@Param("page") Page<Map<String, Object>> page,
                                     @Param("beginTime") String beginTime,
                                     @Param("endTime") String endTime,
                                     @Param("activityId") Integer activityId);


    List<Map<String, Object>> queryCouponRegister(@Param("type") Integer type, @Param("name") String name,
                                                  @Param("start") String start, @Param("end") String end,
                                                  @Param("companyId") Integer companyId, @Param("offset") Integer offset,
                                                  @Param("limit") Integer limit);

    int queryCouponRegisterCount(@Param("type") Integer type, @Param("name") String name,
                                 @Param("start") String start, @Param("end") String end,
                                 @Param("companyId") Integer companyId);



    List<Map<String, Object>> queryCouponRegisterInfo(@Param("type") Integer type, @Param("name") String name,
                                                      @Param("start") String start, @Param("end") String end,
                                                      @Param("companyId") Integer companyId, @Param("offset") Integer offset,
                                                      @Param("limit") Integer limit);

    int queryCouponRegisterInfoCount(@Param("type") Integer type, @Param("name") String name,
                                     @Param("start") String start, @Param("end") String end,
                                     @Param("companyId") Integer companyId);


    List<Map<String, Object>> queryCouponRegisterInfo1(@Param("name") String name, @Param("start") String start,
                                                       @Param("end") String end, @Param("companyId") Integer companyId,
                                                       @Param("offset") Integer offset, @Param("limit") Integer limit);

    int queryCouponRegisterInfo1Count(@Param("name") String name, @Param("start") String start,
                                      @Param("end") String end, @Param("companyId") Integer companyId);


}