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/order/CommonOrderCountMapper.java | 119 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 119 insertions(+), 0 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 c7b8e55..20ddbaa 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,12 +1,14 @@ 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 { @@ -19,6 +21,16 @@ */ Long countByState(@Param("state") Integer state); + + /** + * 缁熻鎵�鏈夎鍗� + * + * @param channel + * @return + */ + Long countOrderBySourceTypeAndDay(@Param("preDay") String preDay, @Param("sourceType") int sourceType); + + /** * 缁熻鎵�鏈夎鍗� * @@ -29,6 +41,8 @@ @Param("startTime") String startTime, @Param("endTime") String endTime, @Param("sourceType") int sourceType); + + /** * 濂栭噾缁熻 * @@ -86,4 +100,109 @@ */ 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); + + /** + * 缁熻璁㈠崟浜х敓浣i噾 + * @param preDay + * @param list + * @return + */ + List<CountOrderDTO> countCommissionByDay(@Param("preDay") String preDay); + + /** + * 閫氳繃uid 鏃ユ湡绛涢�� 涓嬪崟鏁伴噺 + * @param preDay + * @return + */ + Integer countOderByDate(@Param("preDay") String preDay); + + /** + * 缁熻璁㈠崟浜х敓浣i噾 + * @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); + + + + + } \ No newline at end of file -- Gitblit v1.8.0