| | |
| | | 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 {
|
| | |
|
| | |
| | | */
|
| | | 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);
|
| | | Long countOrderBySourceTypeAndDay(@Param("preDay") String preDay, @Param("sourceType") int sourceType);
|
| | |
|
| | | |
| | |
|
| | | /**
|
| | | * 奖金统计
|
| | |
| | | */
|
| | | 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);
|
| | | |
| | | /**
|
| | | * 统计订单产生佣金
|
| | | * @param preDay
|
| | | * @param list
|
| | | * @return
|
| | | */
|
| | | List<CountOrderDTO> countCommissionByDay(@Param("preDay") String preDay);
|
| | | |
| | | /**
|
| | | * 通过uid 日期筛选 下单数量
|
| | | * @param preDay
|
| | | * @return
|
| | | */
|
| | | Integer countOderByDate(@Param("preDay") String preDay);
|
| | | |
| | | /**
|
| | | * 统计订单产生佣金
|
| | | * @param preDay
|
| | | * @return
|
| | | */
|
| | | BigDecimal countCommissionByDate(@Param("preDay") String preDay);
|
| | | } |