OrderMapper.java 6.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160
  1. package com.ydd.module.mapper;
  2. import com.baomidou.mybatisplus.core.metadata.IPage;
  3. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
  4. import com.ydd.common.core.domain.entity.SysUser;
  5. import com.ydd.module.domain.Order;
  6. import com.baomidou.mybatisplus.core.mapper.BaseMapper;
  7. import com.ydd.module.domain.ProfitsMerchant;
  8. import com.ydd.module.dto.*;
  9. import com.ydd.module.request.OrderListRequest;
  10. import org.apache.ibatis.annotations.Param;
  11. import java.math.BigDecimal;
  12. import java.util.Date;
  13. import java.util.List;
  14. /**
  15. * 配送订单Mapper接口
  16. *
  17. * @author douya
  18. * @date 2021-02-01
  19. */
  20. public interface OrderMapper extends BaseMapper<Order> {
  21. List<Order> queryPage(@Param("params") Order order, @Param("memberIds") List<Integer> memberIds);
  22. /**
  23. * 分页查询
  24. *
  25. * @param page
  26. * @param order
  27. * @return
  28. */
  29. List<SystemOrderDto> queryPageList(@Param("page") Page page, @Param("params") SystemOrderDto order, @Param("agentIds") List<Long> agentIds, @Param("aIds") List<Long> aIds);
  30. /**
  31. * 分页查询
  32. *
  33. * @param page
  34. * @param order
  35. * @return
  36. */
  37. List<SystemOrderDto> queryPageListNew(@Param("page") Page page, @Param("params") SystemOrderDto order);
  38. /**
  39. * 查询导出订单列表
  40. * @param order
  41. * @param agentIds
  42. * @param aIds
  43. * @return
  44. */
  45. List<OrderExportDto> selectExportOrder(@Param("params") SystemOrderDto order, @Param("agentIds") List<Long> agentIds, @Param("aIds") List<Long> aIds);
  46. // List<OrderDetailDto> findOneKeyList(@Param("memberId")Long loginId, @Param("status")Integer status,@Param("searchKey") String searchKey,@Param("waimaiId") Integer waimaiId, @Param("shopId")Integer shopId,@Param("spId")Integer spId);
  47. List<OrderDetailDto> findOneKeyList(@Param("memberId") Long loginId, @Param("status") Integer status, @Param("searchKey") String searchKey,
  48. @Param("waimaiId") Integer waimaiId, @Param("shopId") Integer shopId, @Param("shopIds") List<Long> shopIds,
  49. @Param("startDate") String startDate, @Param("endDate") String endDate,@Param("oldStatus") Integer oldStatus);
  50. List<Order> findList(@Param("memberId") List<Long> loginId, @Param("status") Integer status, @Param("searchKey") String searchKey,
  51. @Param("shopId") Integer shopId, @Param("startDate") String startDate, @Param("endDate") String endDate);
  52. Order getDetail(@Param("memberId") List<Long> loginId, @Param("orderId") Integer orderId);
  53. Order getDetailByShopId(@Param("shopIds") List<Integer> shopIds, @Param("orderId") Integer orderId);
  54. Integer getOrderNum(@Param("shopIds") List<Long> shopIds, @Param("startDate") String startDate);
  55. BigDecimal getOrderAmount(@Param("shopIds") List<Long> shopIds, @Param("startDate") String startDate);
  56. List<Order> queryTimeOutOrder(@Param("time")Integer time);
  57. /**
  58. * 配送统计
  59. *
  60. * @param status
  61. * @param deliveryId
  62. * @param shopIds
  63. * @param timeType
  64. * @param startTime
  65. * @param endTime
  66. * @return
  67. */
  68. // OrderSumDto sumOrder(@Param("loginId")Long loginId,@Param("status")Integer status, @Param("deliveryId")Integer deliveryId, @Param("shopId")Long shopId, @Param("timeType")Integer timeType, @Param("startTime")String startTime, @Param("endTime")String endTime);
  69. List<Order> sumOrder(@Param("loginId") Long loginId, @Param("status") Integer status, @Param("deliveryId") Integer deliveryId, @Param("shopIds") List<Integer> shopIds, @Param("timeType") Integer timeType, @Param("startTime") String startTime, @Param("endTime") String endTime);
  70. /**
  71. * 配送统计
  72. *
  73. * @param status
  74. * @param deliveryId
  75. * @param shopId
  76. * @param timeType
  77. * @param startTime
  78. * @param endTime
  79. * @return
  80. */
  81. OrderSumDto sumOrder1(@Param("loginId") Long loginId, @Param("status") Integer status, @Param("deliveryId") Integer deliveryId, @Param("shopId") Long shopId, @Param("timeType") Integer timeType, @Param("startTime") String startTime, @Param("endTime") String endTime);
  82. List<Order> getByStatus();
  83. /**
  84. * 统计数量通过订单
  85. *
  86. * @param order
  87. * @return 订单数量
  88. */
  89. List<SystemOrderDto> selectCountByStatusNew(@Param("params") SystemOrderDto order);
  90. void autofinish();
  91. BigDecimal totalConsume(@Param("shopIds") List<Long> shopIds, @Param("params")ProfitsMerchant profitsMerchant);
  92. BigDecimal totalConsumeByMemberId(@Param("memberId")Long memberId);
  93. String selectOriginalOrderSn1(@Param("waimaiOrderId") Long waimaiOrderId);
  94. Page<OrderListDto> getOrderList(@Param("params") OrderListRequest request, IPage<OrderListDto> pageArt);
  95. List<OrderListDto> getOrderListByShopIdsAndMemberIds(@Param("shopIds") List<Long> shopIds, @Param("memberId") Long memberId, @Param("memberType") Integer memberType, @Param("hasPersonalOrder") boolean hasPersonalOrder);
  96. ProfitsSystemOrderDto selectOrderData(@Param("orderId")Long orderId);
  97. /**
  98. * 根据订单号查找订单
  99. * @param orderSn
  100. * @return
  101. */
  102. Order getByOrderSn(String orderSn);
  103. /**
  104. * 根据订单号查找订单(包括异常单)
  105. * @param orderSn
  106. * @return
  107. */
  108. List<Order> getAllOrderByOrderSn(String orderSn);
  109. /**
  110. * 根据订单id查找订单(包括异常单)
  111. * @param orderId
  112. * @return
  113. */
  114. Order getAllOrderByOrderId(Long orderId);
  115. List<DadaOrderListDto> queryDadaPageList(@Param("page") Page page, @Param("params") DadaOrderListQuery orderQuery);
  116. List<SystemOrderDto> selectDadaCountByStatus(@Param("params") DadaOrderListQuery orderQuery);
  117. List<SystemOrderDto> selectCountByStatus(SystemOrderDto order, List<Integer> agentIds, List<Long> aIds);
  118. OrderInfoDto getOrderInfoByOrderId(@Param("orderId") Long orderId);
  119. List<SubsidyStatisticsDto> getSubsidyList(Page page, @Param("params") SubsidyStatisticsQuery query);
  120. Integer countPersonalOrder(@Param("lastDayTime") String lastDayTime, @Param("memberId") Long memberId);
  121. Order selectOrderBySn(@Param("orderSn") String orderSn, @Param("outOrderSn") String outOrderSn);
  122. }