package cn.iocoder.yudao.module.mes.dal.mysql.qc.oqc;
|
|
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.qc.oqc.vo.MesQcOqcPageReqVO;
|
import cn.iocoder.yudao.module.mes.dal.dataobject.qc.oqc.MesQcOqcDO;
|
import org.apache.ibatis.annotations.Mapper;
|
|
import java.util.List;
|
|
/**
|
* MES 出货检验单(OQC) Mapper
|
*
|
* @author 芋道源码
|
*/
|
@Mapper
|
public interface MesQcOqcMapper extends BaseMapperX<MesQcOqcDO> {
|
|
default PageResult<MesQcOqcDO> selectPage(MesQcOqcPageReqVO reqVO) {
|
return selectPage(reqVO, new LambdaQueryWrapperX<MesQcOqcDO>()
|
.likeIfPresent(MesQcOqcDO::getCode, reqVO.getCode())
|
.eqIfPresent(MesQcOqcDO::getClientId, reqVO.getClientId())
|
.likeIfPresent(MesQcOqcDO::getBatchCode, reqVO.getBatchCode())
|
.eqIfPresent(MesQcOqcDO::getItemId, reqVO.getItemId())
|
.eqIfPresent(MesQcOqcDO::getCheckResult, reqVO.getCheckResult())
|
.orderByDesc(MesQcOqcDO::getId));
|
}
|
|
/**
|
* 分页查询(带客户权限过滤)
|
*/
|
default PageResult<MesQcOqcDO> selectPage(MesQcOqcPageReqVO reqVO, List<Long> permittedClientIds) {
|
LambdaQueryWrapperX<MesQcOqcDO> wrapper = new LambdaQueryWrapperX<MesQcOqcDO>()
|
.likeIfPresent(MesQcOqcDO::getCode, reqVO.getCode())
|
.eqIfPresent(MesQcOqcDO::getClientId, reqVO.getClientId())
|
.likeIfPresent(MesQcOqcDO::getBatchCode, reqVO.getBatchCode())
|
.eqIfPresent(MesQcOqcDO::getItemId, reqVO.getItemId())
|
.eqIfPresent(MesQcOqcDO::getCheckResult, reqVO.getCheckResult())
|
.orderByDesc(MesQcOqcDO::getId);
|
if (permittedClientIds != null) {
|
if (CollUtil.isEmpty(permittedClientIds)) {
|
return PageResult.empty();
|
}
|
wrapper.in(MesQcOqcDO::getClientId, permittedClientIds);
|
}
|
return selectPage(reqVO, wrapper);
|
}
|
|
default MesQcOqcDO selectByCode(String code) {
|
return selectOne(MesQcOqcDO::getCode, code);
|
}
|
|
}
|