From 573c491b4a1ba60e12a5678a01c1546c0077c1ee Mon Sep 17 00:00:00 2001
From: admin <weikou2014>
Date: 星期二, 30 七月 2019 09:07:42 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'
---
fanli/src/main/java/com/yeshi/fanli/dao/mybatis/HongBaoV2Mapper.java | 172 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 172 insertions(+), 0 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 8fd3557..c47aa81 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,8 +1,180 @@
package com.yeshi.fanli.dao.mybatis;
+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.dto.HongBaoDTO;
import com.yeshi.fanli.entity.bus.user.HongBaoV2;
public interface HongBaoV2Mapper extends BaseMapper<HongBaoV2> {
+ HongBaoV2 selectByPrimaryKeyForUpdate(Long id);
+
+ /**
+ * 鑾峰彇瀛愮孩鍖呭垪琛�
+ *
+ * @param id
+ * @return
+ */
+ List<HongBaoV2> listChildrenById(Long id);
+
+ /**
+ * 鑾峰彇濂栭噾鍒楄〃锛�1.4.9涔嬪墠锛�
+ *
+ * @param uid
+ * @param start
+ * @param count
+ * @return
+ */
+ List<HongBaoDTO> listJiangJinByUid(@Param("uid") Long uid, @Param("start") long start, @Param("count") int count);
+
+ /**
+ * 鑾峰彇濂栭噾鏁伴噺锛�1.4.9涔嬪墠锛�
+ *
+ * @param uid
+ * @return
+ */
+ Long countJiangJinByUid(Long uid);
+
+ /**
+ * 鑾峰彇鎬荤殑鎻愭垚閲戦
+ *
+ * @param uid
+ * @return
+ */
+ BigDecimal getTotalTiChengMoney(Long uid);
+
+ /**
+ * 鑾峰彇鎬荤殑鎻愭垚绗旀暟
+ *
+ * @param uid
+ * @return
+ */
+ int getTotalTiChengCount(Long uid);
+
+ /**
+ * 鑾峰彇杩樻湭鍒拌处鐨勬彁鎴愰噾棰�
+ *
+ * @param uid
+ * @return
+ */
+ BigDecimal getUnGetTiChengMoney(Long uid);
+
+ /**
+ * 鑾峰彇鎬诲叡杩斿埄閲戦
+ *
+ * @param uid
+ * @return
+ */
+ BigDecimal getTotalFanLiMoney(Long uid);
+
+ /**
+ * 鑾峰彇杩樻湭鍒拌处鐨勯噾棰�
+ *
+ * @param uid
+ * @return
+ */
+ 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
+ * @param count
+ * @return
+ */
+ List<HongBaoV2> listCanBalanceHongBaoByType(@Param("type") int type, @Param("count") int count);
+
+ /**
+ * 鑾峰彇鑳藉缁撶畻鐨勫垎浜禋鍜岄個璇疯禋鐨勭敤鎴峰垪琛�
+ *
+ * @param count
+ * @return
+ */
+ List<Long> listUidCanBanlanceShareAndInvite(int count);
+
+ /**
+ * 鏍规嵁鐢ㄦ埛ID锛岀被鍨嬭幏鍙栬兘澶熺粨绠楃殑绾㈠寘
+ *
+ * @param type
+ * @param uid
+ * @param count
+ * @return
+ */
+ List<HongBaoV2> listCanBalanceHongBaoByTypeAndUid(@Param("types") List<Integer> type, @Param("uid") Long uid,
+ @Param("count") int count);
+
+ /**
+ * 鏍规嵁鐢ㄦ埛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();
+
}
\ No newline at end of file
--
Gitblit v1.8.0