From 52cfc32086a6bba091bd9f48a8b6f742d7f93b74 Mon Sep 17 00:00:00 2001
From: yujian <yujian@163.com>
Date: 星期四, 11 六月 2020 11:56:45 +0800
Subject: [PATCH] 收货资金为空 设置默认0
---
fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/CommonOrderCountMapper.java | 200 ++++++++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 192 insertions(+), 8 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 51927ec..c37afb4 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,28 +1,212 @@
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);
+
+ /**
+ * 缁熻鎵�鏈夎鍗�
+ *
+ * @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);
+
+
+ /**
+ * 缁熻杩� day澶╂湁鏁堣鍗曟暟閲�
+ * @param uid
+ * @param source
+ * @param day
+ * @return
+ */
+ Long countOrderBySourceAndNearDay(@Param("uid") Long uid, @Param("source") int source, @Param("day") int day);
+
+
+ /**
+ * 缁熻鍘嗗彶璁㈠崟鏁伴噺 -涓嶅尯鍒嗙姸鎬併�佹潵婧� 璁㈠崟鍙蜂负涓�
+ * @param uid
+ * @return
+ */
+ Long countHistoryOrderNum(@Param("uid") Long uid);
+
}
\ No newline at end of file
--
Gitblit v1.8.0