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 | 148 ++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 146 insertions(+), 2 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..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
@@ -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;
@@ -21,6 +22,12 @@
*/
List<HongBaoV2> listChildrenById(Long id);
+ /**
+ * 鑾峰彇瀛愮孩鍖呭垪琛�
+ * @param idList
+ * @return
+ */
+ List<HongBaoV2> listChildrenByIds(@Param("idList") List<Long> idList);
/**
* 鑾峰彇濂栭噾鍒楄〃锛�1.4.9涔嬪墠锛�
*
@@ -80,6 +87,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 +133,122 @@
* @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锛岃鍗曠姸鎬佸拰缁撶畻鏃堕棿缁熻閭�璇疯禋鐨勮鍗曟暟閲�
+ *
+ * @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,@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