From 28cf328a098334b51a3e9d2d56f983fb8c862211 Mon Sep 17 00:00:00 2001
From: yujian <yujian@163.com>
Date: 星期六, 23 五月 2020 09:54:38 +0800
Subject: [PATCH] 足迹、收藏订单兼容新需求
---
fanli/src/main/java/com/yeshi/fanli/dao/mybatis/HongBaoV2CountMapper.java | 428 +++++++++++++++++++++++++----------------------------
1 files changed, 203 insertions(+), 225 deletions(-)
diff --git a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/HongBaoV2CountMapper.java b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/HongBaoV2CountMapper.java
index 9887052..c4107cb 100644
--- a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/HongBaoV2CountMapper.java
+++ b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/HongBaoV2CountMapper.java
@@ -1,226 +1,204 @@
-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.dto.ChartTDO;
-import com.yeshi.fanli.vo.order.HongBaoV2VO;
-
-public interface HongBaoV2CountMapper {
-
- /**
- * 缁熻鍘嗗彶鎬诲埌璐﹂噾棰�
- *
- * @param uid
- * @param state
- * @return
- */
- BigDecimal countMoneyByUidAndState(@Param("uid") Long uid, @Param("state") Integer state);
-
- /**
- * 缁熻鍘嗗彶绾㈠寘鏁伴噺
- *
- * @param uid
- * @param state
- * @return
- */
- Integer countNumberByUidAndState(@Param("uid") Long uid, @Param("state") Integer state);
-
- /**
- * 缁熻鐢ㄦ埛鎬荤殑绾㈠寘鏁伴噺
- *
- * @param uid
- * @return
- */
- Long countNumberByUid(@Param("uid") Long uid);
-
- /**
- * 缁熻鎬婚噾棰�
- *
- * @param channel
- * 娓犻亾
- * @param type
- * @param state
- * @param years
- * @param startTime
- * @param endTime
- * @return
- */
- List<ChartTDO> countHongBaoMoney(@Param("channel") String channel, @Param("dateType") Integer dateType,
- @Param("state") Integer state, @Param("year") String year, @Param("startTime") String startTime,
- @Param("endTime") String endTime);
-
- /**
- * 缁熻鎬讳釜鏁�
- *
- * @param channel
- * 娓犻亾
- * @param type
- * @param state
- * @param years
- * @param startTime
- * @param endTime
- * @return
- */
- List<ChartTDO> countHongBaoNum(@Param("channel") String channel, @Param("dateType") Integer dateType,
- @Param("state") Integer state, @Param("year") String year, @Param("startTime") String startTime,
- @Param("endTime") String endTime);
-
- /**
- * 缁熻鎬讳釜鏁�
- *
- * @param channel
- * 娓犻亾
- * @param type
- * @param state
- * @param years
- * @param startTime
- * @param endTime
- * @return
- */
- List<ChartTDO> countHongBaoType(@Param("dateType") Integer dateType, @Param("type") Integer type,
- @Param("year") String year, @Param("startTime") String startTime, @Param("endTime") String endTime);
-
- /**
- * 缁熻鎬讳釜鏁�
- *
- * @param channel
- * 娓犻亾
- * @param type
- * @param state
- * @param years
- * @param startTime
- * @param endTime
- * @return
- */
- List<ChartTDO> countHongBaoTotalNum(@Param("dateType") Integer dateType, @Param("year") String year,
- @Param("startTime") String startTime, @Param("endTime") String endTime);
-
- // 绱鎻愭垚璁㈠崟鏁伴噺锛堝寘鍚棤鏁堣鍗曪級
- int getTotalTiChengCount(Long uid);
-
-
- // 绱鎻愭垚绾㈠寘鏁伴噺锛堝寘鍚棤鏁堬級
- long getHongBaoCount(@Param("uid") Long uid, @Param("type") Integer type);
-
- /**
- * 缁熻鏈け鏁堣鍗曟暟閲�
- *
- * @param uid
- * @param dateType
- * @return
- */
- long countValidNumberByUid(@Param("uid") Long uid, @Param("dateType") Integer dateType);
-
- /**
- * 缁熻鏈埌璐�
- *
- * @param uid
- * @return
- */
- BigDecimal countWillGetMoneyByUid(@Param("uid") Long uid);
-
- Date getLastHongBaoTime(@Param("uid") Long uid);
-
- /**
- * 鏍规嵁娓犻亾 缁熻鏂板鐢ㄦ埛24灏忔椂鍐呬骇鐢熺殑璁㈠崟鏁伴噺
- *
- * @param channel
- * @return
- */
- List<ChartTDO> count24HOderByChannel(@Param("channel") String channel, @Param("type") Integer type,
- @Param("years") String years, @Param("startTime") String startTime, @Param("endTime") String endTime);
-
- List<HongBaoV2VO> listShareAndInviteMoney(@Param("start") long start, @Param("count") int count,
- @Param("date") String date);
-
- /**
- * 缁熻濂栧姳鍒告�婚噾棰�
- *
- * @return
- */
- BigDecimal countRebateCouponMoney();
-
- /**
- * 缁熻鐢ㄦ埛宸插埌璐�
- *
- * @param uid
- * @param typeList
- * @param minGetTime
- * @param maxGetTime
- * @return
- */
- BigDecimal sumAlreadyGetMoneyByUid(@Param("uid") Long uid, @Param("typeList") List<Integer> typeList,
- @Param("minGetTime") Date minGetTime, @Param("maxGetTime") Date maxGetTime);
-
- long countAlreadyGetMoneyByUid(@Param("uid") Long uid, @Param("typeList") List<Integer> typeList,
- @Param("minGetTime") Date minGetTime, @Param("maxGetTime") Date maxGetTime);
-
-
- /**
- * 缁熻杩斿埄璁㈠崟
- * @param uid
- * @return
- */
- long countRebateOrder(@Param("uid") Long uid);
-
- /**
- * 缁熻鍒嗕韩鍜岄個璇疯鍗�
- * @param uid
- * @return
- */
- long countShareOrInviteOrder(@Param("uid") Long uid);
-
- /**
- * 缁熻涓嬬骇浜х敓鏈夋晥鍒嗕韩濂栭噾
- * @param uid
- * @param teamUid 涓嬬骇id
- * @param endTime 缁撴潫鏃堕棿
- * @return
- */
-
- BigDecimal getOrderRewardByTeamUid(@Param("uid") Long uid, @Param("teamUid") Long teamUid, @Param("endTime") Date endTime);
-
- /**
- * 缁熻涓嬬骇涓婁釜鏈夋晥璁㈠崟
- * @param uid
- * @param teamUid 涓嬬骇id
- * @param endTime 缁撴潫鏃堕棿
- * @return
- */
- BigDecimal getOrderRewardByTeamUidTheMonth(@Param("uid") Long uid, @Param("teamUid") Long teamUid);
-
- /**
- * 缁熻宸插埌璐﹂噾棰�
- * @param uid
- * @param list 绫诲瀷
- * @return
- */
- BigDecimal getRewardMoneyByUid(@Param("uid") Long uid, @Param("list") List<Integer> list);
-
- /**
- * 娉細1.鏈夋晥涓�绾ч槦鍛樺畾涔夛細2019骞�1鏈�1鏃ヨ捣锛岃嚜璐垨鍒嗕韩1绗斾笖浠樻鎬婚噾棰濅笉灏忎簬 payment 鍏冿紙閫�娆句负澶辨晥
- * @param uid
- * @param list 绫诲瀷
- * @return
- */
- long countValidOrderTeamUserByUid(@Param("uid") Long uid, @Param("time") Long time,
- @Param("payment") BigDecimal payment);
-
-
- /**
- * 鏌ヨ鐢ㄦ埛涓被鍨嬮璁″閲�
- * @param uid
- * @param dateType 鏃ユ湡绫诲瀷
- * @param hbType 绾㈠寘绫诲瀷
- * @return
- */
- BigDecimal getRewardMoneyByDate(@Param("uid") Long uid, @Param("day")Integer dateType,
- @Param("type") Integer hbType, @Param("orderState") Integer orderState,
- @Param("orderNo") String orderNo, @Param("moneyState") Integer moneyState,
- @Param("source") Integer source,
- @Param("startTime") String startTime, @Param("endTime") String endTime);
+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.vo.order.HongBaoV2VO;
+
+public interface HongBaoV2CountMapper {
+
+ /**
+ * 缁熻鍘嗗彶鎬诲埌璐﹂噾棰�
+ *
+ * @param uid
+ * @param state
+ * @return
+ */
+ BigDecimal countMoneyByUidAndState(@Param("uid") Long uid, @Param("state") Integer state);
+
+ /**
+ * 缁熻鍘嗗彶绾㈠寘鏁伴噺
+ *
+ * @param uid
+ * @param state
+ * @return
+ */
+ Integer countNumberByUidAndState(@Param("uid") Long uid, @Param("state") Integer state);
+
+ /**
+ * 缁熻鐢ㄦ埛鎬荤殑绾㈠寘鏁伴噺
+ *
+ * @param uid
+ * @return
+ */
+ Long countNumberByUid(@Param("uid") Long uid);
+
+
+
+
+ // 绱鎻愭垚璁㈠崟鏁伴噺锛堝寘鍚棤鏁堣鍗曪級
+ int getTotalTiChengCount(Long uid);
+
+
+ // 绱鎻愭垚绾㈠寘鏁伴噺锛堝寘鍚棤鏁堬級
+ long getHongBaoCount(@Param("uid") Long uid, @Param("type") Integer type);
+
+ /**
+ * 缁熻鏈け鏁堣鍗曟暟閲�
+ *
+ * @param uid
+ * @param dateType
+ * @return
+ */
+ long countValidNumberByUid(@Param("uid") Long uid, @Param("dateType") Integer dateType);
+
+ /**
+ * 缁熻鏈埌璐�
+ *
+ * @param uid
+ * @return
+ */
+ BigDecimal countWillGetMoneyByUid(@Param("uid") Long uid);
+
+ Date getLastHongBaoTime(@Param("uid") Long uid);
+
+
+ List<HongBaoV2VO> listShareAndInviteMoney(@Param("start") long start, @Param("count") int count,
+ @Param("date") String date);
+
+ /**
+ * 缁熻濂栧姳鍒告�婚噾棰�
+ *
+ * @return
+ */
+ BigDecimal countRebateCouponMoney();
+
+ /**
+ * 缁熻鐢ㄦ埛宸插埌璐�
+ *
+ * @param uid
+ * @param typeList
+ * @param minGetTime
+ * @param maxGetTime
+ * @return
+ */
+ BigDecimal sumAlreadyGetMoneyByUid(@Param("uid") Long uid, @Param("typeList") List<Integer> typeList,
+ @Param("minGetTime") Date minGetTime, @Param("maxGetTime") Date maxGetTime);
+
+ long countAlreadyGetMoneyByUid(@Param("uid") Long uid, @Param("typeList") List<Integer> typeList,
+ @Param("minGetTime") Date minGetTime, @Param("maxGetTime") Date maxGetTime);
+
+
+ /**
+ * 缁熻杩斿埄璁㈠崟
+ * @param uid
+ * @return
+ */
+ long countRebateOrder(@Param("uid") Long uid);
+
+ /**
+ * 缁熻鍒嗕韩鍜岄個璇疯鍗�
+ * @param uid
+ * @return
+ */
+ long countShareOrInviteOrder(@Param("uid") Long uid);
+
+ /**
+ * 缁熻涓嬬骇浜х敓鏈夋晥鍒嗕韩濂栭噾
+ * @param uid
+ * @param teamUid 涓嬬骇id
+ * @param endTime 缁撴潫鏃堕棿
+ * @return
+ */
+
+ BigDecimal getOrderRewardByTeamUid(@Param("uid") Long uid, @Param("teamUid") Long teamUid, @Param("endTime") Date endTime);
+
+ /**
+ * 缁熻涓嬬骇涓婁釜鏈夋晥璁㈠崟
+ * @param uid
+ * @param teamUid 涓嬬骇id
+ * @param endTime 缁撴潫鏃堕棿
+ * @return
+ */
+ BigDecimal getOrderRewardByTeamUidTheMonth(@Param("uid") Long uid, @Param("teamUid") Long teamUid);
+
+ /**
+ * 缁熻宸插埌璐﹂噾棰�
+ * @param uid
+ * @param list 绫诲瀷
+ * @return
+ */
+ BigDecimal getRewardMoneyByUid(@Param("uid") Long uid, @Param("list") List<Integer> list);
+
+
+ /**
+ * 娉細1绗斾笖浠樻鎬婚噾棰濅笉灏忎簬 payment 鍏冿紙閫�娆句负澶辨晥
+ * @param uid
+ * @param payment
+ * @return
+ */
+ Long countMyDirectOrderByCashArrival(@Param("uid") Long uid, @Param("payment") BigDecimal payment,
+ @Param("type")Integer type);
+
+ /**
+ * 娉細1绗斾笖浠樻鎬婚噾棰濅笉灏忎簬 payment 鍏冿紙閫�娆句负澶辨晥
+ * @param uid
+ * @param payment
+ * @return
+ */
+ Long countMyDirectOrderByCashNotArrival(@Param("uid") Long uid, @Param("payment") BigDecimal payment,
+ @Param("type")Integer type);
+
+
+ /**
+ * 鏌ヨ鐢ㄦ埛涓被鍨嬮璁″閲�
+ * @param uid
+ * @param dateType 鏃ユ湡绫诲瀷
+ * @param hbType 绾㈠寘绫诲瀷
+ * @return
+ */
+ BigDecimal getRewardMoneyByDate(@Param("uid") Long uid, @Param("day")Integer dateType,
+ @Param("type") Integer hbType, @Param("orderState") Integer orderState,
+ @Param("orderNo") String orderNo, @Param("moneyState") Integer moneyState,
+ @Param("startTime") String startTime, @Param("endTime") String endTime,
+ @Param("listSource") List<Integer> listSource, @Param("notBackSuVip") boolean notBackSuVip);
+
+ /**
+ * 缁熻鍚勪釜璁㈠崟绫诲瀷 鏈夋晥涓暟
+ * @param orderType
+ * @param preDay
+ * @return
+ */
+ Long countOrderByTypeAndDate(@Param("orderType") Integer orderType, @Param("preDay") String preDay);
+
+
+ /**
+ * 缁熻杩戞棩鍒拌处鏀跺叆閲戦
+ * @param uid
+ * @param day
+ * @return
+ */
+ BigDecimal sumMoneyArrivalByUidAndNearDay(@Param("uid") Long uid, @Param("day") int day);
+
+
+ /**
+ * 缁熻缁撶畻閲戦
+ * @param uid
+ * @param minDate
+ * @param maxDate
+ * @return
+ */
+ BigDecimal sumMoneyBySettleTimeAndUid(@Param("uid") Long uid, @Param("minDate") Date minDate, @Param("maxDate") Date maxDate);
+
+ /**
+ * 180鍐呮湭鏀惰揣鐨勯噾棰�
+ * @param uid
+ * @return
+ */
+ BigDecimal sumMoneyByANotSettleAndUid(@Param("uid") Long uid);
+
+
}
\ No newline at end of file
--
Gitblit v1.8.0