OrderMapper.java 2.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748
  1. package com.hys.app.mapper.erp;
  2. import com.hys.app.framework.database.WebPage;
  3. import com.hys.app.framework.database.mybatisplus.base.BaseMapperX;
  4. import com.hys.app.framework.util.StringUtil;
  5. import com.hys.app.model.erp.dos.OrderDO;
  6. import com.hys.app.model.erp.dto.OrderQueryParams;
  7. import org.apache.ibatis.annotations.Mapper;
  8. /**
  9. * 订单 Mapper
  10. *
  11. * @author 张崧
  12. * 2024-01-24 15:58:31
  13. */
  14. @Mapper
  15. public interface OrderMapper extends BaseMapperX<OrderDO> {
  16. default WebPage<OrderDO> selectPage(OrderQueryParams params) {
  17. return lambdaQuery()
  18. .andX(StringUtil.notEmpty(params.getKeywords()),
  19. w -> w.like(OrderDO::getSn, params.getKeywords()))
  20. .likeIfPresent(OrderDO::getSn, params.getSn())
  21. .eqIfPresent(OrderDO::getStatus, params.getStatus())
  22. .eqIfPresent(OrderDO::getMemberId, params.getMemberId())
  23. .betweenIfPresent(OrderDO::getOrderTime, params.getOrderTime())
  24. .eqIfPresent(OrderDO::getWarehouseId, params.getWarehouseId())
  25. .likeIfPresent(OrderDO::getWarehouseName, params.getWarehouseName())
  26. .eqIfPresent(OrderDO::getMarketingId, params.getMarketingId())
  27. .likeIfPresent(OrderDO::getMarketingName, params.getMarketingName())
  28. .likeIfPresent(OrderDO::getRemark, params.getRemark())
  29. // .eqIfPresent(OrderDO::getDeliveryType, params.getDeliveryType())
  30. .eqIfPresent(OrderDO::getStoreId, params.getStoreId())
  31. .likeIfPresent(OrderDO::getStoreName, params.getStoreName())
  32. .eqIfPresent(OrderDO::getWarehouseOutFlag, params.getWarehouseOutFlag())
  33. .eqIfPresent(OrderDO::getWarehouseOutId, params.getWarehouseOutId())
  34. .eqIfPresent(OrderDO::getShipFlag, params.getShipFlag())
  35. .betweenIfPresent(OrderDO::getShipTime, params.getShipTime())
  36. .eqIfPresent(OrderDO::getLogisticsCompanyId, params.getLogisticsCompanyId())
  37. .likeIfPresent(OrderDO::getLogisticsCompanyName, params.getLogisticsCompanyName())
  38. .likeIfPresent(OrderDO::getLogisticsTrackingNumber, params.getLogisticsTrackingNumber())
  39. .eqIfPresent(OrderDO::getType, params.getType())
  40. .orderByDesc(OrderDO::getCreateTime)
  41. .page(params);
  42. }
  43. }