From fb6eb1e6b9df772d243b5ade8b9e3dd08028e935 Mon Sep 17 00:00:00 2001 From: Administrator <Administrator@MS-20170306HGUF> Date: 星期二, 25 二月 2020 20:05:56 +0800 Subject: [PATCH] 刷单标识 --- fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/CommonOrderCountMapper.java | 334 ++++++++++++++++++++++++++++--------------------------- 1 files changed, 171 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..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,164 +1,172 @@ -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); - - /** - * 缁熻璁㈠崟浜х敓浣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); +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); + + /** + * 缁熻璁㈠崟浜х敓浣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); } \ No newline at end of file -- Gitblit v1.8.0