| | |
| | | package com.yeshi.fanli.dao.mybatis.user; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | import com.yeshi.fanli.vo.user.SystemCouponVO; |
| | | import com.yeshi.fanli.vo.user.UserSystemCouponCountVO; |
| | | |
| | | public interface UserSystemCouponCountMapper { |
| | | |
| | | /** |
| | | * 奖励券统计 |
| | | * @param start |
| | | * @param count |
| | | * @param key |
| | | * @param keyType |
| | | * @param state |
| | | * @param percent |
| | | * @return |
| | | */ |
| | | List<UserSystemCouponCountVO> listRebateCoupon(@Param("start") long start, @Param("count") int count, |
| | | @Param("key") String key, @Param("keyType") Integer keyType, |
| | | @Param("state") Integer state, @Param("percent") Integer percent); |
| | | |
| | | Long countRebateCoupon(@Param("key") String key, @Param("keyType") Integer keyType, |
| | | @Param("state") Integer state, @Param("percent") Integer percent); |
| | | |
| | | |
| | | /** |
| | | * 系统奖励券统计 |
| | | * @param start |
| | | * @param count |
| | | * @param key |
| | | * @param keyType |
| | | * @param state |
| | | * @param percent |
| | | * @return |
| | | */ |
| | | List<SystemCouponVO> listSystemCouponByRebate(@Param("start") long start, @Param("count") int count, |
| | | @Param("key") String key, @Param("sort") Integer sort); |
| | | |
| | | Long countSystemCouponRebate(@Param("key") String key); |
| | | |
| | | /** |
| | | * 统计奖励金额 |
| | | * @return |
| | | */ |
| | | BigDecimal countRebateMoneyByCouponId(@Param("couponId") Long couponId); |
| | | |
| | | |
| | | /** |
| | | * 系统奖励券统计 |
| | | * @param start |
| | | * @param count |
| | | * @param key |
| | | * @param keyType |
| | | * @param state |
| | | * @param percent |
| | | * @return |
| | | */ |
| | | List<SystemCouponVO> listSystemCouponByFree(@Param("start") long start, @Param("count") int count, |
| | | @Param("key") String key, @Param("sort") Integer sort); |
| | | |
| | | Long countSystemCouponFree(@Param("key") String key); |
| | | |
| | | /** |
| | | * 统计免单金额 |
| | | * @return |
| | | */ |
| | | BigDecimal countFreeMoneyByCouponId(@Param("couponId") Long couponId); |
| | | |
| | | |
| | | /** |
| | | * 免单券 |
| | | * @param start |
| | | * @param count |
| | | * @param key |
| | | * @param keyType |
| | | * @param state |
| | | * @param percent |
| | | * @return |
| | | */ |
| | | List<UserSystemCouponCountVO> listFreeCoupon(@Param("start") long start, @Param("count") int count, |
| | | @Param("key") String key, @Param("keyType") Integer keyType, |
| | | @Param("state") Integer state, @Param("activated") Integer activated); |
| | | |
| | | Long countFreeCoupon(@Param("key") String key, @Param("keyType") Integer keyType, |
| | | @Param("state") Integer state, @Param("activated") Integer activated); |
| | | |
| | | |
| | | /** |
| | | * 免单券使用记录 |
| | | * @param start |
| | | * @param count |
| | | * @param key |
| | | * @param keyType |
| | | * @param state |
| | | * @param percent |
| | | * @return |
| | | */ |
| | | List<UserSystemCouponCountVO> listFreeCouponRecord(@Param("start") long start, @Param("count") int count, |
| | | @Param("key") String key, @Param("keyType") Integer keyType, |
| | | @Param("state") Integer state); |
| | | |
| | | Long countFreeCouponRecord(@Param("key") String key, @Param("keyType") Integer keyType, |
| | | @Param("state") Integer state); |
| | | |
| | | /** |
| | | * 奖励券使用数量曲线图 |
| | | * @param dateType |
| | | * @param year |
| | | * @param startTime |
| | | * @param endTime |
| | | * @return |
| | | */ |
| | | List<Map<String, Object>> getRebateCouponUsedNumToCharts(@Param("dateType") Integer dateType, @Param("year") String year, |
| | | @Param("startTime")String startTime, @Param("endTime")String endTime); |
| | | |
| | | |
| | | /** |
| | | * 奖励券使用成功金额曲线图 |
| | | * @param dateType |
| | | * @param year |
| | | * @param startTime |
| | | * @param endTime |
| | | * @return |
| | | */ |
| | | List<Map<String, Object>> getRebateCouponMoneyToCharts(@Param("dateType") Integer dateType, @Param("year") String year, |
| | | @Param("startTime")String startTime, @Param("endTime")String endTime); |
| | | |
| | | |
| | | /** |
| | | * 奖励券使用成功金额曲线图 |
| | | * @param dateType |
| | | * @param year |
| | | * @param startTime |
| | | * @param endTime |
| | | * @return |
| | | */ |
| | | List<Map<String, Object>> getFreeCouponMoneyToCharts(@Param("dateType") Integer dateType, @Param("year") String year, |
| | | @Param("startTime")String startTime, @Param("endTime")String endTime, @Param("couponType")String couponType); |
| | | |
| | | package com.yeshi.fanli.dao.mybatis.user;
|
| | |
|
| | | import java.math.BigDecimal;
|
| | | import java.util.List;
|
| | |
|
| | | import org.apache.ibatis.annotations.Param;
|
| | |
|
| | | import com.yeshi.fanli.entity.bus.user.UserSystemCouponRecord;
|
| | | import com.yeshi.fanli.vo.user.SystemCouponVO;
|
| | | import com.yeshi.fanli.vo.user.UserSystemCouponCountVO;
|
| | |
|
| | | public interface UserSystemCouponCountMapper {
|
| | | |
| | | /**
|
| | | * 奖励券统计
|
| | | * @param start
|
| | | * @param count
|
| | | * @param key
|
| | | * @param keyType
|
| | | * @param state
|
| | | * @param percent
|
| | | * @return
|
| | | */
|
| | | List<UserSystemCouponCountVO> listRebateCoupon(@Param("start") long start, @Param("count") int count, |
| | | @Param("key") String key, @Param("keyType") Integer keyType,
|
| | | @Param("state") Integer state, @Param("percent") Integer percent);
|
| | | |
| | | Long countRebateCoupon(@Param("key") String key, @Param("keyType") Integer keyType,
|
| | | @Param("state") Integer state, @Param("percent") Integer percent);
|
| | | |
| | | |
| | | /**
|
| | | * 系统奖励券统计
|
| | | * @param start
|
| | | * @param count
|
| | | * @param key
|
| | | * @param keyType
|
| | | * @param state
|
| | | * @param percent
|
| | | * @return
|
| | | */
|
| | | List<SystemCouponVO> listSystemCouponByRebate(@Param("start") long start, @Param("count") int count, |
| | | @Param("key") String key, @Param("sort") Integer sort);
|
| | | |
| | | Long countSystemCouponRebate(@Param("key") String key);
|
| | | |
| | | /**
|
| | | * 统计奖励金额
|
| | | * @return
|
| | | */
|
| | | BigDecimal countRebateMoneyByCouponId(@Param("couponId") Long couponId);
|
| | | |
| | | |
| | | /**
|
| | | * 系统奖励券统计
|
| | | * @param start
|
| | | * @param count
|
| | | * @param key
|
| | | * @param keyType
|
| | | * @param state
|
| | | * @param percent
|
| | | * @return
|
| | | */
|
| | | List<SystemCouponVO> listSystemCouponByFree(@Param("start") long start, @Param("count") int count, |
| | | @Param("key") String key, @Param("sort") Integer sort);
|
| | | |
| | | Long countSystemCouponFree(@Param("key") String key);
|
| | | |
| | | /**
|
| | | * 统计免单金额
|
| | | * @return
|
| | | */
|
| | | BigDecimal countFreeMoneyByCouponId(@Param("couponId") Long couponId);
|
| | | |
| | | |
| | | /**
|
| | | * 免单券
|
| | | * @param start
|
| | | * @param count
|
| | | * @param key
|
| | | * @param keyType
|
| | | * @param state
|
| | | * @param percent
|
| | | * @return
|
| | | */
|
| | | List<UserSystemCouponCountVO> listFreeCoupon(@Param("start") long start, @Param("count") int count, |
| | | @Param("key") String key, @Param("keyType") Integer keyType,
|
| | | @Param("state") Integer state, @Param("activated") Integer activated);
|
| | | |
| | | Long countFreeCoupon(@Param("key") String key, @Param("keyType") Integer keyType,
|
| | | @Param("state") Integer state, @Param("activated") Integer activated);
|
| | | |
| | | |
| | | /**
|
| | | * 免单券使用记录
|
| | | * @param start
|
| | | * @param count
|
| | | * @param key
|
| | | * @param keyType
|
| | | * @param state
|
| | | * @param percent
|
| | | * @return
|
| | | */
|
| | | List<UserSystemCouponRecord> listFreeCouponRecord(@Param("start") long start, @Param("count") int count, |
| | | @Param("key") String key, @Param("keyType") Integer keyType,
|
| | | @Param("state") Integer state);
|
| | | |
| | | Long countFreeCouponRecord(@Param("key") String key, @Param("keyType") Integer keyType,
|
| | | @Param("state") Integer state);
|
| | | |
| | | |
| | | |
| | | /**
|
| | | * 统计奖励券金额成功金额
|
| | | * @param type
|
| | | * @param preDay
|
| | | * @return
|
| | | */
|
| | | BigDecimal countRebateMoneyByDay(@Param("preDay") String preDay);
|
| | | |
| | | |
| | | /**
|
| | | * 统计免单金额成功金额
|
| | | * @param type
|
| | | * @param preDay
|
| | | * @return
|
| | | */
|
| | | BigDecimal countFreeMoneyByTypeAndDay(@Param("type") String type, @Param("preDay") String preDay);
|
| | | |
| | | |
| | | /**
|
| | | * 统计券每日新增数量
|
| | | * @param type
|
| | | * @param preDay
|
| | | * @return
|
| | | */
|
| | | BigDecimal countCouponNumByDay(@Param("type") String type, @Param("preDay") String preDay);
|
| | | |
| | | } |