yhlxj/netflix-dao/src/main/java/com/cyksj/mapper/OrderDonMapper.java

package com.cyksj.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.cyksj.model.entity.OrderDon;
import com.cyksj.model.entity.RealGoodsInterestUser;
import com.cyksj.model.excel.ExcelOrderDonInfo;
import com.cyksj.model.views.BackgroundDataView;
import com.cyksj.model.views.BrokenLineObjView;
import com.cyksj.model.views.ChannelPopularizeView;
import com.cyksj.model.views.ChannelStatisticsView;
import org.apache.ibatis.annotations.Param;

import java.math.BigDecimal;
import java.util.Date;
import java.util.List;
import java.util.Map;
import java.util.Set;

/**
 * @author chan
 * @date 2021/10/11 下午4:06
 */
public interface OrderDonMapper extends BaseMapper<OrderDon> {


    List<ExcelOrderDonInfo> exportOrderInfo(@Param("promotionId") Long promotionId, @Param("start") String start, @Param("end") String end);

	List<OrderDon> getAppleOneOrderDons(@Param("skuIds") List<Long> skuIds, @Param("noOrderStatus") List<String> noOrderStatus, @Param("yesZeroDate") Date yesZeroDate, @Param("thisZeroDate") Date thisZeroDate);

	List<RealGoodsInterestUser> selectNoPaymentRealGoods();

	Integer updateHasPaymentInterestRealGoods();

	void updateHasPaymentInterestRealGoodsPayTime();

	BrokenLineObjView selectPlatBrokenLineMoney(@Param("first") String first, @Param("end") String end);

	BrokenLineObjView selectPersonDistributeBrokenLine(@Param("userId") Long userId, @Param("first") String first, @Param("end") String end);

	ChannelStatisticsView selectChannelStatistics(@Param("first") String first, @Param("end") String end);

	Integer selectCouponCodeUserNum(@Param("dsPopularizeId") Long dsPopularizeId, @Param("noOrderAllStatus") List<String> noOrderAllStatus);

	ChannelPopularizeView countPopularizeOrderDetail(@Param("popularizeId") Long popularizeId, @Param("startTime") String startTime, @Param("endTime") String endTime);

	BigDecimal selectThisMonthAppleOneMoney(@Param("skuIds") Set<Long> skuIds, @Param("startDate") String startDate, @Param("endDate") String endDate);

	BigDecimal selectThisMonthDistributeOrderMoney(@Param("skuIds") Set<Long> skuIds, @Param("startDate") String startDate, @Param("endDate") String endDate);

	Map<String, Object> getOrderDetailByGoodsType(@Param("type") Integer type, @Param("noOrderStatus") List<String> noOrderStatus, @Param("startDate") Date startDate, @Param("endDate") Date endDate);

	BackgroundDataView getBackgroundDataView(@Param("startDate") Date startDate, @Param("endDate") Date endDate, @Param("noOrderStatus") List<String> noOrderStatus);

	BigDecimal statisticsUsedBalance(@Param("startDate") Date startDate, @Param("endDate") Date endDate, @Param("noOrderAllStatus") List<String> noOrderAllStatus);

	Map<String, Object> selectYhShopDistributeOrderDetail(@Param("startDate") Date startDate, @Param("endDate") Date endDate);

	Integer selectCountActiveCodeOrderByAcId(Long acId);

	Map<String, Object> selectActiveCodeOrderDetail(@Param("acId") Long acId, @Param("startTime") String startTime, @Param("endTime") String endTime);
}