1
0

OrderDao.java 4.0 KB

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