From f4a0f2acc63d7785eab108419a4e16f5f688cb95 Mon Sep 17 00:00:00 2001 From: yujian <yujian@163.com> Date: 星期六, 18 一月 2020 12:06:27 +0800 Subject: [PATCH] 用户注册信息 --- fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/CommonOrderCountMapper.java | 202 ++++++++++++++++++++++++++++++++++++++++--------- 1 files changed, 163 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..8ee73c5 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,164 @@ -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.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); } \ No newline at end of file -- Gitblit v1.8.0