package com.cyksj.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.cyksj.model.entity.OrderDon;
import com.cyksj.model.entity.OrderDonCustomerServiceRelate;
import com.cyksj.model.excel.ExcelOrderDonInfo;
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);

	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("exCode") String exCode, @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);

	OrderDonCustomerServiceRelate selectOrderRelate(Long orderId);

	String selectMaxRefundGoodsName(@Param("operator") String operator, @Param("startTime") String startTime, @Param("endTime") String endTime);

	BigDecimal getCouponUsedMoney(Long couponId);

	BrokenLineObjView selectDsPlatBrokenLineMoney(@Param("sharedId") Long sharedId, @Param("first") String first, @Param("end") String end);
}