| | |
| | | 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.dto.ChartTDO;
|
| | | 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 dateType
|
| | | * @param year
|
| | | * @param startTime
|
| | | * @param endTime
|
| | | * @return
|
| | | */
|
| | | List<ChartTDO> 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<ChartTDO> 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<ChartTDO> 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("source") String source); |
| | | |
| | | |
| | | /** |
| | | * 统计券每日新增数量 |
| | | * @param type |
| | | * @param preDay |
| | | * @return |
| | | */ |
| | | BigDecimal countCouponNumByDay(@Param("type") String type, @Param("preDay") String preDay, @Param("source") String source); |
| | | |
| | | |
| | | /** |
| | | * 统计券数量 |
| | | * @param state |
| | | * @param activated |
| | | * @param list |
| | | * @return |
| | | */ |
| | | Long countCouponNum(@Param("uid")Long uid, @Param("state") Integer state, @Param("activated") Integer activated, |
| | | @Param("list")List<String> list, @Param("listSource")List<String> listSource); |
| | | } |