| | |
| | | package com.yeshi.fanli.dao.mybatis.tlj;
|
| | |
|
| | | import java.math.BigDecimal;
|
| | | import java.util.Date;
|
| | | import java.util.List;
|
| | |
|
| | | import org.apache.ibatis.annotations.Param;
|
| | |
|
| | | import com.yeshi.fanli.dao.BaseMapper;
|
| | | import com.yeshi.fanli.entity.bus.tlj.UserTaoLiJinOrigin;
|
| | |
|
| | | public interface UserTaoLiJinOriginMapper extends BaseMapper<UserTaoLiJinOrigin> {
|
| | |
|
| | | /**
|
| | | * 根据日期类型统计金额
|
| | | * @param uid
|
| | | * @param dateType 1今日 、2昨日、3本月、4上月
|
| | | * @return
|
| | | */
|
| | | BigDecimal countMoneyByDate(@Param("uid")long uid, @Param("dateType")int dateType);
|
| | | |
| | | |
| | | /**
|
| | | * 根据用户、来源统计
|
| | | * @param uid
|
| | | * @param origin
|
| | | * @return
|
| | | */
|
| | | long countByUidAndOrigin(@Param("uid")long uid, @Param("origin")String origin);
|
| | | |
| | | /**
|
| | | * 根据用户、来源统计
|
| | | * @param uid
|
| | | * @param origin
|
| | | * @return
|
| | | */
|
| | | UserTaoLiJinOrigin getByUidAndOrigin(@Param("uid")long uid, @Param("origin")String origin);
|
| | | |
| | | /**
|
| | | * 统计本月等级红包
|
| | | * @param uid
|
| | | * @param origin
|
| | | * @return
|
| | | */
|
| | | long countRankByThisMonth(@Param("uid")long uid);
|
| | | |
| | | |
| | | /**
|
| | | * 统计本月等级红包
|
| | | * @param uid
|
| | | * @param origin
|
| | | * @return
|
| | | */
|
| | | UserTaoLiJinOrigin getRankByThisMonth(@Param("uid")long uid, @Param("type")String type);
|
| | | |
| | | |
| | | /**
|
| | | * 查询过期的红包 排除等级
|
| | | * @param date
|
| | | * @return
|
| | | */
|
| | | List<UserTaoLiJinOrigin> getOverdueTaoLiJin(@Param("uid")long uid, @Param("date")Date date);
|
| | | |
| | | |
| | | /**
|
| | | * 查询过期的红包-等级
|
| | | * @param date
|
| | | * @return
|
| | | */
|
| | | List<UserTaoLiJinOrigin> getOverdueTaoLiJinByRank(@Param("uid")long uid, @Param("date")Date date);
|
| | | |
| | | /**
|
| | | * 查询剩余淘礼金
|
| | | * @param uid
|
| | | * @return
|
| | | */
|
| | | List<UserTaoLiJinOrigin> getSurplusLiJin(@Param("uid")long uid);
|
| | | |
| | | |
| | | /**
|
| | | * 统计用户红包记录
|
| | | * @param uid
|
| | | * @return
|
| | | */
|
| | | long countByUidAndType(@Param("uid")long uid, @Param("type")String type);
|
| | | |
| | | |
| | | /**
|
| | | * 统计金额
|
| | | * @param rightsId
|
| | | * @param origin
|
| | | * @return
|
| | | */
|
| | | BigDecimal countMoneyByOrigin(@Param("rightsId")String rightsId, @Param("origin")String origin);
|
| | | |
| | | /**
|
| | | * 根据淘礼金id查询
|
| | | * @param rightsId
|
| | | * @return
|
| | | */
|
| | | UserTaoLiJinOrigin getOriginByRightsId(@Param("rightsId")String rightsId);
|
| | | |
| | | package com.yeshi.fanli.dao.mybatis.tlj; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | import com.yeshi.fanli.dao.BaseMapper; |
| | | import com.yeshi.fanli.entity.bus.tlj.UserTaoLiJinOrigin; |
| | | |
| | | public interface UserTaoLiJinOriginMapper extends BaseMapper<UserTaoLiJinOrigin> { |
| | | |
| | | /** |
| | | * 根据日期类型统计金额 |
| | | * @param uid |
| | | * @param dateType 1今日 、2昨日、3本月、4上月 |
| | | * @return |
| | | */ |
| | | BigDecimal countMoneyByDate(@Param("uid")long uid, @Param("dateType")int dateType); |
| | | |
| | | |
| | | /** |
| | | * 根据用户、来源统计 |
| | | * @param uid |
| | | * @param origin |
| | | * @return |
| | | */ |
| | | long countByUidAndOrigin(@Param("uid")long uid, @Param("origin")String origin); |
| | | |
| | | /** |
| | | * 根据用户、来源统计 |
| | | * @param uid |
| | | * @param origin |
| | | * @return |
| | | */ |
| | | UserTaoLiJinOrigin getByUidAndOrigin(@Param("uid")long uid, @Param("origin")String origin); |
| | | |
| | | /** |
| | | * 统计本月等级红包 |
| | | * @param uid |
| | | * @param origin |
| | | * @return |
| | | */ |
| | | long countRankByThisMonth(@Param("uid")long uid); |
| | | |
| | | |
| | | /** |
| | | * 统计本月等级红包 |
| | | * @param uid |
| | | * @param origin |
| | | * @return |
| | | */ |
| | | UserTaoLiJinOrigin getRankByThisMonth(@Param("uid")long uid, @Param("type")String type); |
| | | |
| | | |
| | | /** |
| | | * 查询过期的红包 排除等级 |
| | | * @param date |
| | | * @return |
| | | */ |
| | | List<UserTaoLiJinOrigin> getOverdueTaoLiJin(@Param("uid")long uid, @Param("date")Date date); |
| | | |
| | | |
| | | /** |
| | | * 查询过期的红包-等级 |
| | | * @param date |
| | | * @return |
| | | */ |
| | | List<UserTaoLiJinOrigin> getOverdueTaoLiJinByRank(@Param("uid")long uid, @Param("date")Date date); |
| | | |
| | | /** |
| | | * 查询剩余淘礼金 |
| | | * @param uid |
| | | * @return |
| | | */ |
| | | List<UserTaoLiJinOrigin> getSurplusLiJin(@Param("uid")long uid); |
| | | |
| | | |
| | | /** |
| | | * 统计用户红包记录 |
| | | * @param uid |
| | | * @return |
| | | */ |
| | | long countByUidAndType(@Param("uid")long uid, @Param("type")String type); |
| | | |
| | | |
| | | /** |
| | | * 统计金额 |
| | | * @param rightsId |
| | | * @param origin |
| | | * @return |
| | | */ |
| | | BigDecimal countMoneyByOrigin(@Param("rightsId")String rightsId, @Param("origin")String origin); |
| | | |
| | | /** |
| | | * 根据淘礼金id查询 |
| | | * @param rightsId |
| | | * @return |
| | | */ |
| | | UserTaoLiJinOrigin getOriginByRightsId(@Param("rightsId")String rightsId); |
| | | |
| | | } |