From f4a0f2acc63d7785eab108419a4e16f5f688cb95 Mon Sep 17 00:00:00 2001 From: yujian <yujian@163.com> Date: 星期六, 18 一月 2020 12:06:27 +0800 Subject: [PATCH] 用户注册信息 --- fanli/src/main/java/com/yeshi/fanli/dao/mybatis/HongBaoV2Mapper.java | 116 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++- 1 files changed, 113 insertions(+), 3 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 fd1a012..6369fe6 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 @@ -23,6 +23,12 @@ List<HongBaoV2> listChildrenById(Long id); /** + * 鑾峰彇瀛愮孩鍖呭垪琛� + * @param idList + * @return + */ + List<HongBaoV2> listChildrenByIds(@Param("idList") List<Long> idList); + /** * 鑾峰彇濂栭噾鍒楄〃锛�1.4.9涔嬪墠锛� * * @param uid @@ -127,8 +133,17 @@ * @param count * @return */ - List<HongBaoV2> listCanBalanceHongBaoByTypeAndUid(@Param("types") List<Integer> type, @Param("uid") Long uid, - @Param("count") int count); + List<HongBaoV2> listCanBalanceHongBaoByTypeAndUid(@Param("types") List<Integer> type, @Param("uid") Long uid, @Param("orderType") Integer orderType, + @Param("start") long start, @Param("count") int count); + + /** + * 璁$畻鍙互缁撶畻绾㈠寘鐨勬暟閲� + * + * @param type + * @param uid + * @return + */ + long countCanBalanceHongBaoByTypeAndUid(@Param("types") List<Integer> type, @Param("uid") Long uid, @Param("orderType") Integer orderType); /** * 鏍规嵁鐢ㄦ埛ID锛岃鍗曠姸鎬佸拰缁撶畻鏃堕棿缁熻閭�璇疯禋鐨勮鍗曟暟閲� @@ -139,6 +154,101 @@ * @return */ Long countInviteOrderCountByUidAndSettleTime(@Param("uid") Long uid, @Param("state") int state, - @Param("minDate") Date minDate, @Param("maxDate") Date maxDate); + @Param("minDate") Date minDate, @Param("maxDate") Date maxDate,@Param("orderType") int orderType); + + /** + * 鏍规嵁鐢ㄦ埛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,@Param("orderType") Integer orderType); + + /** + * 閫氳繃鐢ㄦ埛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); + + /** + * 鏍规嵁璁㈠崟鏉ユ簮绫诲瀷涓庝氦鏄揑D鍒楄〃鏌ヨ璁㈠崟淇℃伅 + * + * @param sourceType + * @param tradeId + * @return + */ + List<HongBaoV2> listBySourceTypeAndTradeIdListAndUid(@Param("sourceType") int sourceType, @Param("uid") long uid, + @Param("tradeIdList") List<String> tradeIdList); + + /** + * 鏍规嵁鐘舵�侊紝绫诲瀷锛岀敤鎴稩D妫�绱� + * @param stateList + * @param typeList + * @param uid + * @return + */ + List<HongBaoV2> listByStateAndTypeAndUid(@Param("stateList") List<Integer> stateList, + @Param("typeList") List<Integer> typeList, @Param("uid") Long uid,@Param("start") long start,@Param("count")int count); + + + /** + * 鏍规嵁ID鎵归噺鏌ヨ + * @param idList + * @return + */ + List<HongBaoV2> listByIds(@Param("idList") List<Long> idList); + + + /** + * 鏍规嵁璁㈠崟浜ゆ槗id鏌ヨ绾㈠寘 + * @param idList + * @return + */ + List<HongBaoDTO> listByOrderTradeId(@Param("tradeId") String tradeId); + } \ No newline at end of file -- Gitblit v1.8.0