OrderDonMapper.java 2.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657
  1. package com.cyksj.mapper;
  2. import com.baomidou.mybatisplus.core.mapper.BaseMapper;
  3. import com.cyksj.model.entity.OrderDon;
  4. import com.cyksj.model.entity.RealGoodsInterestUser;
  5. import com.cyksj.model.excel.ExcelOrderDonInfo;
  6. import com.cyksj.model.views.BackgroundDataView;
  7. import com.cyksj.model.views.BrokenLineObjView;
  8. import com.cyksj.model.views.ChannelPopularizeView;
  9. import com.cyksj.model.views.ChannelStatisticsView;
  10. import org.apache.ibatis.annotations.Param;
  11. import java.math.BigDecimal;
  12. import java.util.Date;
  13. import java.util.List;
  14. import java.util.Map;
  15. import java.util.Set;
  16. /**
  17. * @author chan
  18. * @date 2021/10/11 下午4:06
  19. */
  20. public interface OrderDonMapper extends BaseMapper<OrderDon> {
  21. List<ExcelOrderDonInfo> exportOrderInfo(@Param("promotionId") Long promotionId, @Param("start") String start, @Param("end") String end);
  22. List<OrderDon> getAppleOneOrderDons(@Param("skuIds") List<Long> skuIds, @Param("noOrderStatus") List<String> noOrderStatus, @Param("yesZeroDate") Date yesZeroDate, @Param("thisZeroDate") Date thisZeroDate);
  23. List<RealGoodsInterestUser> selectNoPaymentRealGoods();
  24. Integer updateHasPaymentInterestRealGoods();
  25. void updateHasPaymentInterestRealGoodsPayTime();
  26. BrokenLineObjView selectPlatBrokenLineMoney(@Param("first") String first, @Param("end") String end);
  27. BrokenLineObjView selectPersonDistributeBrokenLine(@Param("userId") Long userId, @Param("first") String first, @Param("end") String end);
  28. ChannelStatisticsView selectChannelStatistics(@Param("first") String first, @Param("end") String end);
  29. Integer selectCouponCodeUserNum(@Param("dsPopularizeId") Long dsPopularizeId, @Param("noOrderAllStatus") List<String> noOrderAllStatus);
  30. ChannelPopularizeView countPopularizeOrderDetail(@Param("popularizeId") Long popularizeId, @Param("startTime") String startTime, @Param("endTime") String endTime);
  31. BigDecimal selectThisMonthAppleOneMoney(@Param("skuIds") Set<Long> skuIds, @Param("startDate") String startDate, @Param("endDate") String endDate);
  32. BigDecimal selectThisMonthDistributeOrderMoney(@Param("skuIds") Set<Long> skuIds, @Param("startDate") String startDate, @Param("endDate") String endDate);
  33. Map<String, Object> getOrderDetailByGoodsType(@Param("type") Integer type, @Param("noOrderStatus") List<String> noOrderStatus, @Param("startDate") Date startDate, @Param("endDate") Date endDate);
  34. BackgroundDataView getBackgroundDataView(@Param("startDate") Date startDate, @Param("endDate") Date endDate, @Param("noOrderStatus") List<String> noOrderStatus);
  35. BigDecimal statisticsUsedBalance(@Param("startDate") Date startDate, @Param("endDate") Date endDate, @Param("noOrderAllStatus") List<String> noOrderAllStatus);
  36. Map<String, Object> selectYhShopDistributeOrderDetail(@Param("startDate") Date startDate, @Param("endDate") Date endDate);
  37. }