CartMapper.java 3.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137
  1. package com.iamberry.wechat.service.mapper;
  2. import java.util.List;
  3. import com.iamberry.wechat.core.entity.PaperBean;
  4. import com.iamberry.wechat.core.entity.cart.CartDto;
  5. import com.iamberry.wechat.core.entity.cart.ShopOrderAndItemDto;
  6. import com.iamberry.wechat.core.entity.cart.ShopOrderItemDto;
  7. import com.iamberry.wechat.core.entity.cart.ShopSalesOrderDto;
  8. import com.iamberry.wechat.core.entity.coupon.CouponItem;
  9. import com.iamberry.wechat.core.entity.coupon.CouponType;
  10. import com.iamberry.wechat.core.entity.order.Order;
  11. import com.iamberry.wechat.core.entity.product.SalesUserGift;
  12. public interface CartMapper {
  13. //根据用户id查询购物车
  14. public List<CartDto> selectCartByOpenId(String openId);
  15. //根据用户id查询购物车数量
  16. public Integer getCartNumByCartOpenId(String openId);
  17. //修改购物车数量
  18. public Integer updateCartByOpenId(CartDto cartDto);
  19. //根据购物车id和openid查询购物车数量
  20. public Integer getCartNumByOpenId(CartDto cartDto);
  21. //根据商品id和用户openid查询购物车是否有该商品
  22. public CartDto getCartByCartProductId(CartDto cartDto);
  23. //添加商品到购物车
  24. public Integer addProductToCart(CartDto cartDto);
  25. //根据cartid删除购物车信息
  26. public Integer deleteCartByCartId(CartDto cartDto);
  27. //分页查询订单信息
  28. public List<ShopOrderAndItemDto> selectShopOrder(PaperBean paperBean);
  29. //根据openid查询订单数量
  30. public Integer getOrderNumByOpenId(PaperBean paperBean);
  31. //根据订单id查询订单项
  32. public List<ShopOrderItemDto> selectShopOrderItem(String itemSalesOrderid);
  33. //根据订单号查询订单信息
  34. public ShopSalesOrderDto getShopOrderByOrderId(String salesOrderId, String salesOpenId);
  35. /**
  36. * 根据购物车ID,获取购物项
  37. * @param carts
  38. * @return
  39. */
  40. public List<CartDto> selectCartItemByListId(Integer[] carts);
  41. /**
  42. * 批量获取购物车集合
  43. * @param carts
  44. * @return
  45. */
  46. List<CartDto> listCartByIds(Integer[] carts);
  47. /**
  48. * 查询购物车产品颜色信息
  49. * @param cartDto
  50. * @return
  51. */
  52. CartDto selectCartProductColor(CartDto cartDto);
  53. /**
  54. * 查询购物车产品配件信息
  55. * @param cartDto
  56. * @return
  57. */
  58. CartDto getCartProductFitting(CartDto cartDto);
  59. //根据orderid查询用户openid和订单状态
  60. public ShopSalesOrderDto getOpenIdAndStatus(String salesOrderid);
  61. //修改订单状态和添加备注
  62. public Integer updateOrderByOrderId(Order order);
  63. /**
  64. * 根据ID,批量删除购物车ID
  65. */
  66. public Integer deleteBatchCartListById(List<Integer> cartIds);
  67. /**
  68. * 根据优惠券id获取优惠券优惠价格
  69. * @param couponId
  70. * @return
  71. * @author liuzhiwei
  72. */
  73. public CouponType getCouponReduceByItemId(CouponItem couponItem);
  74. /**
  75. * 根据openid查看订单列表,不分页
  76. * @param shopSalesOrderDto
  77. * @return
  78. */
  79. public List<ShopSalesOrderDto> getOrderList(ShopSalesOrderDto shopSalesOrderDto);
  80. /**
  81. * 查询购买产品的赠品信息
  82. * @param cartColorId
  83. * @return
  84. */
  85. List<SalesUserGift> listGift(Integer cartColorId);
  86. /**
  87. * 查询赠品集合
  88. * @param gift
  89. * @return
  90. */
  91. List<SalesUserGift> listSelectGift(SalesUserGift gift);
  92. /**
  93. * 修改发货提醒次数
  94. * @param order
  95. * @return
  96. */
  97. Integer updateSendWarnNum(Order order);
  98. /**
  99. * 根据商品id和openid查询购物车数量和ID
  100. * **/
  101. CartDto getCartByOpenId(CartDto cartDto);
  102. /**
  103. * 修改订单状态和备注信息
  104. * @param order
  105. * @return
  106. */
  107. Integer updateOrderByOrder(Order order);
  108. }