From 27c1fd58461e2fd15be392b3c308b4343af8d973 Mon Sep 17 00:00:00 2001
From: yujian <yujian@163.com>
Date: 星期三, 01 四月 2020 14:53:50 +0800
Subject: [PATCH] 发圈统计
---
fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/CommonOrderCountMapper.java | 356 ++++++++++++++++++++++++++++++++---------------------------
1 files changed, 193 insertions(+), 163 deletions(-)
diff --git a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/CommonOrderCountMapper.java b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/CommonOrderCountMapper.java
index 8ee73c5..94f8cd8 100644
--- a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/CommonOrderCountMapper.java
+++ b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/CommonOrderCountMapper.java
@@ -1,164 +1,194 @@
-package com.yeshi.fanli.dao.mybatis.order;
-
-import java.math.BigDecimal;
-import java.util.Date;
-import java.util.List;
-import java.util.Map;
-
-import org.apache.ibatis.annotations.Param;
-
-import com.yeshi.fanli.dto.ChartTDO;
-import com.yeshi.fanli.dto.order.CountOrderDTO;
-
-public interface CommonOrderCountMapper {
-
- /**
- * 褰撳墠鍚勪釜鐘舵�佽鍗曟暟
- *
- * @param state
- * 鐘舵��
- * @return
- */
- Long countByState(@Param("state") Integer state);
-
-
- /**
- * 缁熻鎵�鏈夎鍗�
- *
- * @param channel
- * @return
- */
- Long countOrderBySourceTypeAndDay(@Param("preDay") String preDay, @Param("sourceType") int sourceType);
-
-
-
- /**
- * 濂栭噾缁熻
- *
- * @param uid
- * @return
- */
- Map<String, Object> countOrderNumberBySettleTime(@Param("uid") Long uid, @Param("state") Integer state,
- @Param("day") Integer day);
-
- /**
- * 缁熻鑷喘銆佸垎浜湁鏁堣鍗曟暟閲�
- *
- * @param uid
- * @return
- */
- long countValidOrder(@Param("uid") Long uid);
-
- /**
- * 鏍规嵁璁㈠崟鍙� 鏌ヨ閲戦
- *
- * @param orderNo
- * @return
- */
- BigDecimal getMoneyByOrderNo(@Param("orderNo") String orderNo);
-
- /**
- * 缁熻宸插埌璐﹁繑鍒╄鍗�
- *
- * @param uid
- * @param dateTime
- * @return
- */
- long countValidOrderByDate(@Param("uid") Long uid, @Param("dateTime") String dateTime);
-
- /**
- * 鏌ヨ鐢ㄦ埛鍦ㄥ悓涓�搴楅摵璐拱瓒呰繃涓�瀹氭暟閲忓晢鍝佺殑搴楅摵鏁伴噺
- *
- * @param typeList
- * -绾㈠寘绫诲瀷
- * @param uid
- * -鐢ㄦ埛ID
- * @param minSameShopGoodsCount
- * -鍚屼竴搴楅摵涔扮殑鏈�灏忚鍗曟暟
- * @return
- */
- long countSameShopOrderByUidAndHongBaoType(@Param("typeList") List<Integer> typeList, @Param("uid") Long uid,
- @Param("minSameShopGoodsCount") int minSameShopGoodsCount);
-
- /**
- * 鏌ヨ鐢ㄦ埛璐拱鐩稿悓鍟嗗搧瓒呰繃涓�瀹氱殑璁㈠崟鏁伴噺鐨勫晢鍝佹暟閲�
- * @param typeList
- * @param uid
- * @param minSameGoodsOrderCount
- * @return
- */
- long countSameGoodsOrderByUidAndHongBaoType(@Param("typeList") List<Integer> typeList, @Param("uid") Long uid,
- @Param("minSameGoodsOrderCount") int minSameGoodsOrderCount);
-
-
- /**
- * 鏌ヨ鐢ㄦ埛鍦ㄥ悓涓�搴楅摵璐拱瓒呰繃涓�瀹氭暟閲忓晢鍝佺殑搴楅摵id
- *
- * @param typeList
- * -绾㈠寘绫诲瀷
- * @param uid
- * -鐢ㄦ埛ID
- * @param minSameShopGoodsCount
- * -鍚屼竴搴楅摵涔扮殑鏈�灏忚鍗曟暟
- * @return
- */
- List<Long> getSameShopOrderByUidAndHongBaoType(@Param("typeList") List<Integer> typeList, @Param("uid") Long uid,
- @Param("minSameShopGoodsCount") int minSameShopGoodsCount);
-
- /**
- * 鏌ヨ鐢ㄦ埛璐拱鐩稿悓鍟嗗搧瓒呰繃涓�瀹氱殑璁㈠崟鏁伴噺鐨勫晢鍝乮d
- * @param typeList
- * @param uid
- * @param minSameGoodsOrderCount
- * @return
- */
- List<Long> getSameGoodsOrderByUidAndHongBaoType(@Param("typeList") List<Integer> typeList, @Param("uid") Long uid,
- @Param("minSameGoodsOrderCount") int minSameGoodsOrderCount);
-
-
- /**
- * 閫氳繃uid 鏃ユ湡绛涢�� 涓嬪崟鏁伴噺
- * @param preDay
- * @param uid
- * @return
- */
- Integer countOderByUidAndDate(@Param("preDay") Date preDay,@Param("uid") Long uid);
-
- /**
- * 鏃ユ湡绛涢�� 姣忎釜鐢ㄦ埛涓嬪崟鏁伴噺
- * @param preDay
- * @param uid
- * @return
- */
- List<CountOrderDTO> countValidOrderByDay(@Param("preDay") String preDay);
-
- /**
- * 閫氳繃澶氫釜uid 鏃ユ湡绛涢�� 涓嬪崟鐢ㄦ埛鏁伴噺
- * @param preDay
- * @param uid
- * @return
- */
- Integer countDownOrderUserByUidAndDate(@Param("preDay") Date preDay,@Param("list") List<Long> list);
-
- /**
- * 缁熻璁㈠崟浜х敓浣ｉ噾
- * @param preDay
- * @param list
- * @return
- */
- List<CountOrderDTO> countCommissionByDay(@Param("preDay") String preDay);
-
- /**
- * 閫氳繃uid 鏃ユ湡绛涢�� 涓嬪崟鏁伴噺
- * @param preDay
- * @return
- */
- Integer countOderByDate(@Param("preDay") String preDay);
-
- /**
- * 缁熻璁㈠崟浜х敓浣ｉ噾
- * @param preDay
- * @return
- */
- BigDecimal countCommissionByDate(@Param("preDay") String preDay);
+package com.yeshi.fanli.dao.mybatis.order;
+
+import java.math.BigDecimal;
+import java.util.Date;
+import java.util.List;
+import java.util.Map;
+
+import org.apache.ibatis.annotations.Param;
+
+import com.yeshi.fanli.dto.ChartTDO;
+import com.yeshi.fanli.dto.order.CountOrderDTO;
+
+public interface CommonOrderCountMapper {
+
+ /**
+ * 褰撳墠鍚勪釜鐘舵�佽鍗曟暟
+ *
+ * @param state
+ * 鐘舵��
+ * @return
+ */
+ Long countByState(@Param("state") Integer state);
+
+
+ /**
+ * 缁熻鎵�鏈夎鍗�
+ *
+ * @param channel
+ * @return
+ */
+ Long countOrderBySourceTypeAndDay(@Param("preDay") String preDay, @Param("sourceType") int sourceType);
+
+
+ /**
+ * 缁熻鎵�鏈夎鍗�
+ *
+ * @param channel
+ * @return
+ */
+ List<ChartTDO> countOrderNumber(@Param("dateType") Integer dateType, @Param("year") String year,
+ @Param("startTime") String startTime, @Param("endTime") String endTime,
+ @Param("sourceType") int sourceType);
+
+
+
+ /**
+ * 濂栭噾缁熻
+ *
+ * @param uid
+ * @return
+ */
+ Map<String, Object> countOrderNumberBySettleTime(@Param("uid") Long uid, @Param("state") Integer state,
+ @Param("day") Integer day);
+
+ /**
+ * 缁熻鑷喘銆佸垎浜湁鏁堣鍗曟暟閲�
+ *
+ * @param uid
+ * @return
+ */
+ long countValidOrder(@Param("uid") Long uid);
+
+ /**
+ * 鏍规嵁璁㈠崟鍙� 鏌ヨ閲戦
+ *
+ * @param orderNo
+ * @return
+ */
+ BigDecimal getMoneyByOrderNo(@Param("orderNo") String orderNo);
+
+ /**
+ * 缁熻宸插埌璐﹁繑鍒╄鍗�
+ *
+ * @param uid
+ * @param dateTime
+ * @return
+ */
+ long countValidOrderByDate(@Param("uid") Long uid, @Param("dateTime") String dateTime);
+
+ /**
+ * 鏌ヨ鐢ㄦ埛鍦ㄥ悓涓�搴楅摵璐拱瓒呰繃涓�瀹氭暟閲忓晢鍝佺殑搴楅摵鏁伴噺
+ *
+ * @param typeList
+ * -绾㈠寘绫诲瀷
+ * @param uid
+ * -鐢ㄦ埛ID
+ * @param minSameShopGoodsCount
+ * -鍚屼竴搴楅摵涔扮殑鏈�灏忚鍗曟暟
+ * @return
+ */
+ long countSameShopOrderByUidAndHongBaoType(@Param("typeList") List<Integer> typeList, @Param("uid") Long uid,
+ @Param("minSameShopGoodsCount") int minSameShopGoodsCount);
+
+ /**
+ * 鏌ヨ鐢ㄦ埛璐拱鐩稿悓鍟嗗搧瓒呰繃涓�瀹氱殑璁㈠崟鏁伴噺鐨勫晢鍝佹暟閲�
+ * @param typeList
+ * @param uid
+ * @param minSameGoodsOrderCount
+ * @return
+ */
+ long countSameGoodsOrderByUidAndHongBaoType(@Param("typeList") List<Integer> typeList, @Param("uid") Long uid,
+ @Param("minSameGoodsOrderCount") int minSameGoodsOrderCount);
+
+
+ /**
+ * 鏌ヨ鐢ㄦ埛鍦ㄥ悓涓�搴楅摵璐拱瓒呰繃涓�瀹氭暟閲忓晢鍝佺殑搴楅摵id
+ *
+ * @param typeList
+ * -绾㈠寘绫诲瀷
+ * @param uid
+ * -鐢ㄦ埛ID
+ * @param minSameShopGoodsCount
+ * -鍚屼竴搴楅摵涔扮殑鏈�灏忚鍗曟暟
+ * @return
+ */
+ List<Long> getSameShopOrderByUidAndHongBaoType(@Param("typeList") List<Integer> typeList, @Param("uid") Long uid,
+ @Param("minSameShopGoodsCount") int minSameShopGoodsCount);
+
+ /**
+ * 鏌ヨ鐢ㄦ埛璐拱鐩稿悓鍟嗗搧瓒呰繃涓�瀹氱殑璁㈠崟鏁伴噺鐨勫晢鍝乮d
+ * @param typeList
+ * @param uid
+ * @param minSameGoodsOrderCount
+ * @return
+ */
+ List<Long> getSameGoodsOrderByUidAndHongBaoType(@Param("typeList") List<Integer> typeList, @Param("uid") Long uid,
+ @Param("minSameGoodsOrderCount") int minSameGoodsOrderCount);
+
+
+ /**
+ * 閫氳繃uid 鏃ユ湡绛涢�� 涓嬪崟鏁伴噺
+ * @param preDay
+ * @param uid
+ * @return
+ */
+ Integer countOderByUidAndDate(@Param("preDay") Date preDay,@Param("uid") Long uid);
+
+ /**
+ * 鏃ユ湡绛涢�� 姣忎釜鐢ㄦ埛涓嬪崟鏁伴噺
+ * @param preDay
+ * @param uid
+ * @return
+ */
+ List<CountOrderDTO> countValidOrderByDay(@Param("preDay") String preDay);
+
+ /**
+ * 鏌ヨ褰撴棩涓嬪崟鐢ㄦ埛
+ * @param preDay
+ * @return
+ */
+ List<Long> getUidByValidOrderByDay(@Param("preDay") String preDay);
+
+ /**
+ * 閫氳繃澶氫釜uid 鏃ユ湡绛涢�� 涓嬪崟鐢ㄦ埛鏁伴噺
+ * @param preDay
+ * @param uid
+ * @return
+ */
+ Integer countDownOrderUserByUidAndDate(@Param("preDay") Date preDay,@Param("list") List<Long> list);
+
+ /**
+ * 缁熻璁㈠崟浜х敓浣ｉ噾
+ * @param preDay
+ * @param list
+ * @return
+ */
+ List<CountOrderDTO> countCommissionByDay(@Param("preDay") String preDay);
+
+ /**
+ * 閫氳繃uid 鏃ユ湡绛涢�� 涓嬪崟鏁伴噺
+ * @param preDay
+ * @return
+ */
+ Integer countOderByDate(@Param("preDay") String preDay);
+
+ /**
+ * 缁熻璁㈠崟浜х敓浣ｉ噾
+ * @param preDay
+ * @return
+ */
+ BigDecimal countCommissionByDate(@Param("preDay") String preDay);
+
+
+ /**
+ * 鏌ヨ鏈�杩�50灏忎簬10鐨勮鍗曟暟閲�
+ * @param uid
+ * @return
+ */
+ Integer countOderByUidAndLess10(@Param("uid") Long uid);
+
+
+ List<Long> getDownOrderUserByListUidAndDate(@Param("preDay") Date preDay,@Param("list") List<Long> list);
+
}
\ No newline at end of file
--
Gitblit v1.8.0