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);
|
|
/**
|
* 查询用户购买相同商品超过一定的订单数量的商品id
|
* @param typeList
|
* @param uid
|
* @param minSameGoodsOrderCount
|
* @return
|
*/
|
List<Long> getSameGoodsOrderByUidAndHongBaoType(@Param("typeList") List<Integer> typeList, @Param("uid") Long uid,
|
@Param("minSameGoodsOrderCount") int minSameGoodsOrderCount);
|
}
|
