| | |
| | | package com.yeshi.fanli.dao.mybatis.integral; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | |
| | |
| | | public interface IntegralDetailMapper extends BaseMapper<IntegralDetail> { |
| | | |
| | | /** |
| | | * 根据唯一值查询明细 |
| | | * @param uniqueKey |
| | | * @return |
| | | */ |
| | | IntegralDetail getDetailByUniqueKey(@Param("uniqueKey")String uniqueKey); |
| | | |
| | | /** |
| | | * 获取用户总共有多少记录数据 |
| | | * |
| | | * @param uid |
| | | * @return |
| | | */ |
| | | Long selectCountByUid(@Param("uid") Long uid); |
| | | Long selectCountByUid(@Param("uid") Long uid, @Param("type")Integer type); |
| | | |
| | | /** |
| | | * 按用户ID和最大时间检索月份的数量 |
| | |
| | | * @param maxDate |
| | | * @return |
| | | */ |
| | | int selectMonthCountByUid(@Param("uid") Long uid, @Param("date") Date maxDate); |
| | | int selectMonthCountByUid(@Param("uid") Long uid, @Param("date") Date maxDate, @Param("type")Integer type); |
| | | |
| | | |
| | | /** |
| | |
| | | * @param date |
| | | * @return |
| | | */ |
| | | Long selectCountByUidAndMaxCreateTime(@Param("uid") Long uid, @Param("date") Date date); |
| | | Long selectCountByUidAndMaxCreateTime(@Param("uid") Long uid, @Param("date") Date date, @Param("type")Integer type); |
| | | |
| | | |
| | | /** |
| | |
| | | * @param date |
| | | * @return |
| | | */ |
| | | List<IntegralDetail> selectByMaxCreateTime(@Param("uid") Long uid, @Param("date") Date date, @Param("count") int count); |
| | | List<IntegralDetail> selectByMaxCreateTime(@Param("uid") Long uid, @Param("date") Date date, @Param("count") int count, @Param("type")Integer type); |
| | | |
| | | |
| | | /** |
| | |
| | | * @param count |
| | | * @return |
| | | */ |
| | | List<IntegralDetail> selectByUidWithIndexId(@Param("uid") Long uid, @Param("id") Long id, @Param("count") int count); |
| | | List<IntegralDetail> selectByUidWithIndexId(@Param("uid") Long uid, @Param("id") Long id, @Param("count") int count, @Param("type")Integer type); |
| | | |
| | | |
| | | /** |
| | |
| | | */ |
| | | List<IntegralMonthVO> selectMonthMoneyByUid(@Param("uid") Long uid, @Param("dateFormat") List<String> dateFormat); |
| | | |
| | | |
| | | /** |
| | | * 统计历史到账 |
| | | * @param uniqueKey |
| | | * @return |
| | | */ |
| | | BigDecimal getCumulativeMoney(@Param("uid") Long uid); |
| | | |
| | | |
| | | /** |
| | | * 统计当日新增金币 |
| | | * @param uniqueKey |
| | | * @return |
| | | */ |
| | | Long countNewAddByDate(@Param("preDay") String preDay); |
| | | |
| | | /** |
| | | * 列表查询 |
| | | * @param start |
| | | * @param count |
| | | * @param key |
| | | * @return |
| | | */ |
| | | List<IntegralDetail> listQuery(@Param("start")long start, @Param("count")int count, @Param("key")String key); |
| | | |
| | | Long countQuery(@Param("key")String key); |
| | | |
| | | /** |
| | | * 共计已消耗金币数 |
| | | * @param uid |
| | | * @return |
| | | */ |
| | | Long sumUseGoldCoin(@Param("uid")Long uid); |
| | | } |