From d46dea27b6ec3e0fb32ec7d137699e9fc7d609b0 Mon Sep 17 00:00:00 2001 From: admin <weikou2014> Date: 星期四, 12 十二月 2019 14:18:11 +0800 Subject: [PATCH] 订单补贴消息修改 --- fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/CommonOrderCountMapper.java | 152 +++++++++++++++++++++++++++++++++++++------------- 1 files changed, 113 insertions(+), 39 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..e95123f 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,40 +1,114 @@ -package com.yeshi.fanli.dao.mybatis.order; - -import java.util.List; -import java.util.Map; - -import org.apache.ibatis.annotations.Param; - - -public interface CommonOrderCountMapper { - - - /** - * 褰撳墠鍚勪釜鐘舵�佽鍗曟暟 - * @param state 鐘舵�� - * @return - */ - 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); - - - /** - * 濂栭噾缁熻 - * - * @param uid - * @return - */ - Map<String, Object> countOrderNumberBySettleTime(@Param("uid")Long uid, @Param("state")Integer state, - @Param("day")Integer day); - - - +package com.yeshi.fanli.dao.mybatis.order; + +import java.math.BigDecimal; +import java.util.List; +import java.util.Map; + +import org.apache.ibatis.annotations.Param; + +import com.yeshi.fanli.dto.ChartTDO; + +public interface CommonOrderCountMapper { + + /** + * 褰撳墠鍚勪釜鐘舵�佽鍗曟暟 + * + * @param state + * 鐘舵�� + * @return + */ + Long countByState(@Param("state") Integer state); + + /** + * 缁熻鎵�鏈夎鍗� + * + * @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); } \ No newline at end of file -- Gitblit v1.8.0