OrderDao.java 3.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143
  1. package com.kmall.admin.dao;
  2. import com.kmall.admin.dto.OrderRecognitionDto;
  3. import com.kmall.admin.dto.SendTempDto;
  4. import com.kmall.admin.entity.OrderEntity;
  5. import com.kmall.admin.entity.PurchaseSalesInStockDetail;
  6. import com.kmall.admin.entity.RealtimeSalesDetection;
  7. import com.kmall.api.entity.OrderVo;
  8. import com.kmall.common.utils.Query;
  9. import org.apache.ibatis.annotations.Param;
  10. import com.kmall.manager.dao.BaseDao;
  11. import java.math.BigDecimal;
  12. import java.util.List;
  13. import java.util.Map;
  14. /**
  15. * @author Scott
  16. * @email
  17. * @date 2017-08-13 10:41:09
  18. */
  19. public interface OrderDao extends BaseDao<OrderEntity> {
  20. void riderOrderUpdate(OrderEntity orderVo);
  21. /**
  22. * 获取活动Id
  23. *
  24. * @param activityId
  25. */
  26. List<OrderEntity> queryObjectByActivityId(@Param("activityId") Integer activityId);
  27. OrderEntity queryObjectBySysUser(Long id);
  28. /**
  29. * 已付款订单会员数
  30. *
  31. * @return
  32. */
  33. int getYfkOrderUserSum(Map<String, Object> map);
  34. /**
  35. * 有订单会员数
  36. *
  37. * @return
  38. */
  39. int getOderUserSum(Map<String, Object> map);
  40. /**
  41. * 今日订单数
  42. *
  43. * @return
  44. */
  45. int getTodayUserOrder(Map<String, Object> map);
  46. /**
  47. * 今日会员购物总额
  48. *
  49. * @return
  50. */
  51. int getTodayUserSales(Map<String, Object> map);
  52. /**
  53. * 总收入
  54. *
  55. * @return
  56. */
  57. int getIncomeSum(Map<String, Object> map);
  58. /**
  59. * 已支付订单数
  60. *
  61. * @return
  62. */
  63. int getPayedOrderCount(Map<String, Object> map);
  64. Double getTotalActualPrice(@Param("merchOrderSn")String merchOrderSn);
  65. List<OrderEntity> queryOffilineOrderList(Map<String, Object> map);
  66. List<OrderEntity> queryObjectByMerchOrderSn(@Param("merchOrderSn")String merchOrderSn);
  67. List<OrderEntity> queryExportList(Map<String, Object> map);
  68. OrderEntity queryObjectByOrderSn(@Param("orderSn")String orderSn);
  69. List<OrderEntity> promOrderList(Map<String, Object> map);
  70. int queryPromOrderTotal(Map<String, Object> map);
  71. List<OrderEntity> promOrderListExport(Map<String, Object> map);
  72. /**
  73. * 获取已排除不是推广订单的且已支付的实收金额
  74. * @param map
  75. * @return
  76. */
  77. Double getActualPriceByOutProm(Map<String, Object> map);
  78. List<OrderEntity> storeTopicOrderList(Map<String, Object> map);
  79. int queryStoreTopicOrderTotal(Map<String, Object> map);
  80. //查询与人脸识别认证表相关联的保税展示跨境商品订单
  81. List<OrderRecognitionDto> queryOrderListByRecognition(Map<String, Object> map);
  82. //根据订单id查询发送微信模板需要的订单信息
  83. SendTempDto queryOrderByRecogTemp(long orderId);
  84. int queryOrderListByRecognitionTotal(Map<String, Object> map);
  85. int saveOrderVo(OrderVo orderVo);
  86. //实时销售监测
  87. RealtimeSalesDetection queryRealtimeSales(Map realtimeSalesDetection);
  88. int queryOffilineOrderTotal(Query query);
  89. List<PurchaseSalesInStockDetail> purchaseSalesInStockDetailList(Query query);
  90. int purchaseSalesInStockDetailTotal(Query query);
  91. BigDecimal queryTopicPriceByOrderSnAndSku(@Param("orderSn") String orderSn,@Param("sku") String sku);
  92. /**
  93. * 线下订单导出
  94. * @param params
  95. * @return
  96. */
  97. List<OrderEntity> queryExportOffilineOrderList(Map<String, Object> params);
  98. /**
  99. * 线下订单明细导出
  100. * @param params
  101. * @return
  102. */
  103. List<OrderEntity> queryMasterExportOffilineOrderList(Map<String, Object> params);
  104. /**
  105. * 线上订单导出
  106. * @param params
  107. * @return
  108. */
  109. List<OrderEntity> queryMasterExportList(Map<String, Object> params);
  110. }