| ¶Ô±ÈÐÂÎļþ |
| | |
| | | package cn.iocoder.yudao.module.erp.dal.mysql.purchase; |
| | | |
| | | import cn.iocoder.yudao.framework.common.pojo.PageResult; |
| | | import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX; |
| | | import cn.iocoder.yudao.framework.mybatis.core.query.MPJLambdaWrapperX; |
| | | import cn.iocoder.yudao.module.erp.controller.admin.purchase.vo.returns.ErpPurchaseReturnPageReqVO; |
| | | import cn.iocoder.yudao.module.erp.dal.dataobject.purchase.ErpPurchaseInDO; |
| | | import cn.iocoder.yudao.module.erp.dal.dataobject.purchase.ErpPurchaseReturnDO; |
| | | import cn.iocoder.yudao.module.erp.dal.dataobject.purchase.ErpPurchaseReturnItemDO; |
| | | import cn.iocoder.yudao.module.erp.enums.ErpAuditStatus; |
| | | import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | |
| | | import java.util.List; |
| | | import java.util.Objects; |
| | | |
| | | /** |
| | | * ERP éè´éè´§ Mapper |
| | | * |
| | | * @author èéæºç |
| | | */ |
| | | @Mapper |
| | | public interface ErpPurchaseReturnMapper extends BaseMapperX<ErpPurchaseReturnDO> { |
| | | |
| | | default PageResult<ErpPurchaseReturnDO> selectPage(ErpPurchaseReturnPageReqVO reqVO) { |
| | | MPJLambdaWrapperX<ErpPurchaseReturnDO> query = new MPJLambdaWrapperX<ErpPurchaseReturnDO>() |
| | | .likeIfPresent(ErpPurchaseReturnDO::getNo, reqVO.getNo()) |
| | | .eqIfPresent(ErpPurchaseReturnDO::getSupplierId, reqVO.getSupplierId()) |
| | | .betweenIfPresent(ErpPurchaseReturnDO::getReturnTime, reqVO.getReturnTime()) |
| | | .eqIfPresent(ErpPurchaseReturnDO::getStatus, reqVO.getStatus()) |
| | | .likeIfPresent(ErpPurchaseReturnDO::getRemark, reqVO.getRemark()) |
| | | .eqIfPresent(ErpPurchaseReturnDO::getCreator, reqVO.getCreator()) |
| | | .eqIfPresent(ErpPurchaseReturnDO::getAccountId, reqVO.getAccountId()) |
| | | .likeIfPresent(ErpPurchaseReturnDO::getOrderNo, reqVO.getOrderNo()) |
| | | .orderByDesc(ErpPurchaseReturnDO::getId); |
| | | // 鿬¾ç¶æã为ä»ä¹éè¦ t. çåå ï¼æ¯å 为è表æ¥è¯¢æ¶ï¼éè¦æå®è¡¨åï¼ä¸ç¶ä¼æ¥å段ä¸åå¨çé误 |
| | | if (Objects.equals(reqVO.getRefundStatus(), ErpPurchaseReturnPageReqVO.REFUND_STATUS_NONE)) { |
| | | query.eq(ErpPurchaseReturnDO::getRefundPrice, 0); |
| | | } else if (Objects.equals(reqVO.getRefundStatus(), ErpPurchaseReturnPageReqVO.REFUND_STATUS_PART)) { |
| | | query.gt(ErpPurchaseReturnDO::getRefundPrice, 0).apply("t.refund_price < t.total_price"); |
| | | } else if (Objects.equals(reqVO.getRefundStatus(), ErpPurchaseReturnPageReqVO.REFUND_STATUS_ALL)) { |
| | | query.apply("t.refund_price = t.total_price"); |
| | | } |
| | | if (Boolean.TRUE.equals(reqVO.getRefundEnable())) { |
| | | query.eq(ErpPurchaseInDO::getStatus, ErpAuditStatus.APPROVE.getStatus()) |
| | | .apply("t.refund_price < t.total_price"); |
| | | } |
| | | if (reqVO.getWarehouseId() != null || reqVO.getProductId() != null) { |
| | | query.leftJoin(ErpPurchaseReturnItemDO.class, ErpPurchaseReturnItemDO::getReturnId, ErpPurchaseReturnDO::getId) |
| | | .eq(reqVO.getWarehouseId() != null, ErpPurchaseReturnItemDO::getWarehouseId, reqVO.getWarehouseId()) |
| | | .eq(reqVO.getProductId() != null, ErpPurchaseReturnItemDO::getProductId, reqVO.getProductId()) |
| | | .groupBy(ErpPurchaseReturnDO::getId); // é¿å
1 坹夿¥è¯¢ï¼äº§çç¸åç 1 |
| | | } |
| | | return selectJoinPage(reqVO, ErpPurchaseReturnDO.class, query); |
| | | } |
| | | |
| | | default int updateByIdAndStatus(Long id, Integer status, ErpPurchaseReturnDO updateObj) { |
| | | return update(updateObj, new LambdaUpdateWrapper<ErpPurchaseReturnDO>() |
| | | .eq(ErpPurchaseReturnDO::getId, id).eq(ErpPurchaseReturnDO::getStatus, status)); |
| | | } |
| | | |
| | | default ErpPurchaseReturnDO selectByNo(String no) { |
| | | return selectOne(ErpPurchaseReturnDO::getNo, no); |
| | | } |
| | | |
| | | default List<ErpPurchaseReturnDO> selectListByOrderId(Long orderId) { |
| | | return selectList(ErpPurchaseReturnDO::getOrderId, orderId); |
| | | } |
| | | |
| | | } |