From 207dc8655711cddac2653e18b51e58a88dba2084 Mon Sep 17 00:00:00 2001
From: yj <Administrator@192>
Date: 星期五, 06 三月 2020 18:14:36 +0800
Subject: [PATCH] 发圈处理
---
fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/CommonOrderCountMapper.java | 152 +++++++++++++++++++++++++++++++++++++++++++++++---
1 files changed, 142 insertions(+), 10 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 0eca0bf..99e8150 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,30 +1,36 @@
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 鐘舵��
+ *
+ * @param state
+ * 鐘舵��
* @return
*/
- Long countByState(@Param("state")Integer state);
-
+ Long countByState(@Param("state") Integer state);
+
/**
- * 缁熻鎵�鏈夎鍗�
+ * 缁熻鎵�鏈夎鍗�
+ *
* @param channel
* @return
*/
- List<Map<String, Object>> countOrderNumber( @Param("dateType") Integer dateType, @Param("year") String year,
- @Param("startTime")String startTime, @Param("endTime")String endTime);
+ Long countOrderBySourceTypeAndDay(@Param("preDay") String preDay, @Param("sourceType") int sourceType);
+
/**
* 濂栭噾缁熻
@@ -32,9 +38,135 @@
* @param uid
* @return
*/
- Map<String, Object> countOrderNumberBySettleTime(@Param("uid")Long uid, @Param("state")Integer state,
- @Param("day")Integer day);
+ 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);
+
+
+ /**
+ * 鏌ヨ鏈�杩�50灏忎簬10鐨勮鍗曟暟閲�
+ * @param uid
+ * @return
+ */
+ Integer countOderByUidAndLess10(@Param("uid") Long uid);
}
\ No newline at end of file
--
Gitblit v1.8.0