package cn.iocoder.yudao.module.mes.dal.mysql.wm.returnsales;
|
|
import cn.hutool.core.collection.CollUtil;
|
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.LambdaQueryWrapperX;
|
import cn.iocoder.yudao.module.mes.controller.admin.wm.returnsales.vo.MesWmReturnSalesPageReqVO;
|
import cn.iocoder.yudao.module.mes.dal.dataobject.wm.returnsales.MesWmReturnSalesDO;
|
import org.apache.ibatis.annotations.Mapper;
|
|
import java.util.List;
|
|
/**
|
* MES 销售退货单 Mapper
|
*
|
* @author 芋道源码
|
*/
|
@Mapper
|
public interface MesWmReturnSalesMapper extends BaseMapperX<MesWmReturnSalesDO> {
|
|
default PageResult<MesWmReturnSalesDO> selectPage(MesWmReturnSalesPageReqVO reqVO) {
|
return selectPage(reqVO, new LambdaQueryWrapperX<MesWmReturnSalesDO>()
|
.likeIfPresent(MesWmReturnSalesDO::getCode, reqVO.getCode())
|
.likeIfPresent(MesWmReturnSalesDO::getName, reqVO.getName())
|
.likeIfPresent(MesWmReturnSalesDO::getSalesOrderCode, reqVO.getSalesOrderCode())
|
.eqIfPresent(MesWmReturnSalesDO::getClientId, reqVO.getClientId())
|
.eqIfPresent(MesWmReturnSalesDO::getStatus, reqVO.getStatus())
|
.betweenIfPresent(MesWmReturnSalesDO::getReturnDate, reqVO.getReturnDate())
|
.orderByDesc(MesWmReturnSalesDO::getId));
|
}
|
|
/**
|
* 分页查询(带客户权限过滤)
|
*/
|
default PageResult<MesWmReturnSalesDO> selectPage(MesWmReturnSalesPageReqVO reqVO, List<Long> permittedClientIds) {
|
LambdaQueryWrapperX<MesWmReturnSalesDO> wrapper = new LambdaQueryWrapperX<MesWmReturnSalesDO>()
|
.likeIfPresent(MesWmReturnSalesDO::getCode, reqVO.getCode())
|
.likeIfPresent(MesWmReturnSalesDO::getName, reqVO.getName())
|
.likeIfPresent(MesWmReturnSalesDO::getSalesOrderCode, reqVO.getSalesOrderCode())
|
.eqIfPresent(MesWmReturnSalesDO::getClientId, reqVO.getClientId())
|
.eqIfPresent(MesWmReturnSalesDO::getStatus, reqVO.getStatus())
|
.betweenIfPresent(MesWmReturnSalesDO::getReturnDate, reqVO.getReturnDate())
|
.orderByDesc(MesWmReturnSalesDO::getId);
|
if (permittedClientIds != null) {
|
if (CollUtil.isEmpty(permittedClientIds)) {
|
return PageResult.empty();
|
}
|
wrapper.in(MesWmReturnSalesDO::getClientId, permittedClientIds);
|
}
|
return selectPage(reqVO, wrapper);
|
}
|
|
default MesWmReturnSalesDO selectByCode(String code) {
|
return selectOne(new LambdaQueryWrapperX<MesWmReturnSalesDO>()
|
.eq(MesWmReturnSalesDO::getCode, code));
|
}
|
|
}
|