| | |
| | |
|
| | | import org.apache.ibatis.annotations.Param;
|
| | |
|
| | | import com.yeshi.fanli.dto.ChartTDO;
|
| | | import com.yeshi.fanli.vo.order.HongBaoV2VO;
|
| | |
|
| | | public interface HongBaoV2CountMapper {
|
| | |
| | | */
|
| | | Long countNumberByUid(@Param("uid") Long uid);
|
| | |
|
| | | /**
|
| | | * 统计总金额
|
| | | * |
| | | * @param channel
|
| | | * 渠道
|
| | | * @param type
|
| | | * @param state
|
| | | * @param years
|
| | | * @param startTime
|
| | | * @param endTime
|
| | | * @return
|
| | | */
|
| | | List<ChartTDO> countHongBaoMoney(@Param("channel") String channel, @Param("dateType") Integer dateType,
|
| | | @Param("state") Integer state, @Param("year") String year, @Param("startTime") String startTime,
|
| | | @Param("endTime") String endTime);
|
| | |
|
| | | /**
|
| | | * 统计总个数
|
| | | * |
| | | * @param channel
|
| | | * 渠道
|
| | | * @param type
|
| | | * @param state
|
| | | * @param years
|
| | | * @param startTime
|
| | | * @param endTime
|
| | | * @return
|
| | | */
|
| | | List<ChartTDO> countHongBaoNum(@Param("channel") String channel, @Param("dateType") Integer dateType,
|
| | | @Param("state") Integer state, @Param("year") String year, @Param("startTime") String startTime,
|
| | | @Param("endTime") String endTime);
|
| | |
|
| | | /**
|
| | | * 统计总个数
|
| | | * |
| | | * @param channel
|
| | | * 渠道
|
| | | * @param type
|
| | | * @param state
|
| | | * @param years
|
| | | * @param startTime
|
| | | * @param endTime
|
| | | * @return
|
| | | */
|
| | | List<ChartTDO> countHongBaoType(@Param("dateType") Integer dateType, @Param("type") Integer type,
|
| | | @Param("year") String year, @Param("startTime") String startTime, @Param("endTime") String endTime);
|
| | |
|
| | | /**
|
| | | * 统计总个数
|
| | | * |
| | | * @param channel
|
| | | * 渠道
|
| | | * @param type
|
| | | * @param state
|
| | | * @param years
|
| | | * @param startTime
|
| | | * @param endTime
|
| | | * @return
|
| | | */
|
| | | List<ChartTDO> countHongBaoTotalNum(@Param("dateType") Integer dateType, @Param("year") String year,
|
| | | @Param("startTime") String startTime, @Param("endTime") String endTime);
|
| | |
|
| | | // 累计提成订单数量(包含无效订单)
|
| | | int getTotalTiChengCount(Long uid);
|
| | |
| | |
|
| | | Date getLastHongBaoTime(@Param("uid") Long uid);
|
| | |
|
| | | /**
|
| | | * 根据渠道 统计新增用户24小时内产生的订单数量
|
| | | * |
| | | * @param channel
|
| | | * @return
|
| | | */
|
| | | List<ChartTDO> count24HOderByChannel(@Param("channel") String channel, @Param("type") Integer type,
|
| | | @Param("years") String years, @Param("startTime") String startTime, @Param("endTime") String endTime);
|
| | |
|
| | | List<HongBaoV2VO> listShareAndInviteMoney(@Param("start") long start, @Param("count") int count,
|
| | | @Param("date") String date);
|
| | |
| | | */
|
| | | BigDecimal getRewardMoneyByUid(@Param("uid") Long uid, @Param("list") List<Integer> list);
|
| | |
|
| | | |
| | | /**
|
| | | * 注:1.有效一级队员定义:2019年1月1日起,自购或分享1笔且付款总金额不小于 payment 元(退款为失效
|
| | | * 注:1笔且付款总金额不小于 payment 元(退款为失效
|
| | | * @param uid
|
| | | * @param list 类型
|
| | | * @param payment
|
| | | * @return
|
| | | */
|
| | | Long countValidOrderByUidAndTime(@Param("uid") Long uid, @Param("limitTime") long limitTime,
|
| | | @Param("payment") BigDecimal payment);
|
| | | Long countMyDirectOrderByCashArrival(@Param("uid") Long uid, @Param("payment") BigDecimal payment);
|
| | | |
| | |
|
| | |
|
| | | /**
|
| | |
| | | * @param preDay
|
| | | * @return
|
| | | */
|
| | | Integer countOrderByTypeAndDate(@Param("orderType") Integer orderType, @Param("preDay") String preDay);
|
| | | Long countOrderByTypeAndDate(@Param("orderType") Integer orderType, @Param("preDay") String preDay);
|
| | | |
| | | |
| | | /**
|
| | | * 统计近日到账收入金额
|
| | | * @param uid
|
| | | * @param day
|
| | | * @return
|
| | | */
|
| | | BigDecimal sumMoneyArrivalByUidAndNearDay(@Param("uid") Long uid, @Param("day") int day);
|
| | | |
| | | |
| | | /**
|
| | | * 统计结算金额
|
| | | * @param uid
|
| | | * @param minDate
|
| | | * @param maxDate
|
| | | * @return
|
| | | */
|
| | | BigDecimal sumMoneyBySettleTimeAndUid(@Param("uid") Long uid, @Param("minDate") Date minDate, @Param("maxDate") Date maxDate);
|
| | |
|
| | | /**
|
| | | * 180内未收货的金额
|
| | | * @param uid
|
| | | * @return
|
| | | */
|
| | | BigDecimal sumMoneyByANotSettleAndUid(@Param("uid") Long uid);
|
| | |
|
| | |
|
| | | } |