From fe879975a3e8a0a1aa280fb839e02d159bfbcff8 Mon Sep 17 00:00:00 2001 From: admin <weikou2014> Date: 星期二, 27 八月 2019 18:04:38 +0800 Subject: [PATCH] 金币任务多次获取bug修改 --- fanli/src/main/java/com/yeshi/fanli/dao/mybatis/HongBaoV2Mapper.java | 102 ++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 101 insertions(+), 1 deletions(-) diff --git a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/HongBaoV2Mapper.java b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/HongBaoV2Mapper.java index 69ff463..2fd6bb6 100644 --- a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/HongBaoV2Mapper.java +++ b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/HongBaoV2Mapper.java @@ -1,6 +1,7 @@ package com.yeshi.fanli.dao.mybatis; import java.math.BigDecimal; +import java.util.Date; import java.util.List; import org.apache.ibatis.annotations.Param; @@ -80,6 +81,28 @@ BigDecimal getUnRecievedFanLiMoney(Long uid); /** + * 鏍规嵁鍒涘缓鏃堕棿涓庣敤鎴稩D鑾峰彇鏈埌璐︾殑閲戦 + * + * @param uid + * @param minDate + * @param maxDate + * @return + */ + BigDecimal getUnRecievedMoneyWithCreateTime(@Param("uid") Long uid, @Param("minDate") Date minDate, + @Param("maxDate") Date maxDate); + + /** + * 鏍规嵁棰勮棰嗗彇鏃堕棿涓庣敤鎴稩D鑾峰彇鏈埌璐︾殑閲戦 + * + * @param uid + * @param minDate + * @param maxDate + * @return + */ + BigDecimal getUnRecievedMoneyWithPreGetTime(@Param("uid") Long uid, @Param("minDate") Date minDate, + @Param("maxDate") Date maxDate); + + /** * 鏍规嵁绾㈠寘绫诲瀷鑾峰彇缁撶畻鍒楄〃 * * @param type @@ -104,7 +127,84 @@ * @param count * @return */ - List<HongBaoV2> listCanBalanceHongBaoByTypeAndUid(@Param("types") List<Integer> type, @Param("uid") Long uid, + List<HongBaoV2> listCanBalanceHongBaoByTypeAndUid(@Param("types") List<Integer> type, @Param("uid") Long uid,@Param("start") long start, @Param("count") int count); + + /** + * 璁$畻鍙互缁撶畻绾㈠寘鐨勬暟閲� + * @param type + * @param uid + * @return + */ + long countCanBalanceHongBaoByTypeAndUid(@Param("types") List<Integer> type, @Param("uid") Long uid); + + /** + * 鏍规嵁鐢ㄦ埛ID锛岃鍗曠姸鎬佸拰缁撶畻鏃堕棿缁熻閭�璇疯禋鐨勮鍗曟暟閲� + * + * @param uid + * @param minDate + * @param maxDate + * @return + */ + Long countInviteOrderCountByUidAndSettleTime(@Param("uid") Long uid, @Param("state") int state, + @Param("minDate") Date minDate, @Param("maxDate") Date maxDate); + + /** + * 鏍规嵁鐢ㄦ埛ID锛岃鍗曠姸鎬佸拰缁撶畻鏃堕棿缁熻鍒嗕韩璧氱殑璁㈠崟鏁伴噺 + * + * @param uid + * @param minDate + * @param maxDate + * @return + */ + Long countShareOrderCountByUidAndSettleTime(@Param("uid") Long uid, @Param("state") int state, + @Param("minDate") Date minDate, @Param("maxDate") Date maxDate); + + /** + * 閫氳繃鐢ㄦ埛ID鍜岀姸鎬佹煡璇㈡暟閲� + * + * @param uid + * @param state + * @return + */ + Long countByUidAndState(@Param("uid") Long uid, @Param("state") int state); + + /** + * 閫氳繃鐢ㄦ埛ID涓庣姸鎬佽绠楄祫閲� + * + * @param uid + * @param stateList + * @return + */ + BigDecimal computeMoneyByUidAndState(@Param("uid") Long uid, @Param("stateList") List<Integer> stateList); + + /** + * 鏈�杩�30澶╁唴浜х敓杩囧垎浜鍗曠殑鐢ㄦ埛 + * + * @return + */ + List<Long> getUidByNear30DayShareSucceed(); + + /** + * 鏍规嵁鐖剁敤鎴稩D锛岀姸鎬侊紝绫诲瀷鏌ヨ + * + * @param uid + * @param typeList + * @param stateList + * @return + */ + List<HongBaoV2> listByParentUidAndTypeAndState(@Param("uid") Long uid, @Param("typeList") List<Integer> typeList, + @Param("stateList") List<Integer> stateList, @Param("start") long start, @Param("count") int count); + + /** + * 鏍规嵁鐖剁敤鎴稩D锛岀姸鎬侊紝绫诲瀷鏌ヨ鏁伴噺 + * + * @param uid + * @param typeList + * @param stateList + * @return + */ + long countByParentUidAndTypeAndState(@Param("uid") Long uid, @Param("typeList") List<Integer> typeList, + @Param("stateList") List<Integer> stateList); } \ No newline at end of file -- Gitblit v1.8.0