package cn.iocoder.yudao.module.mes.dal.mysql.wm.returnissue;
|
|
import cn.hutool.core.util.StrUtil;
|
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.returnissue.vo.MesWmReturnIssuePageReqVO;
|
import cn.iocoder.yudao.module.mes.dal.dataobject.wm.returnissue.MesWmReturnIssueDO;
|
import org.apache.ibatis.annotations.Mapper;
|
|
/**
|
* MES 生产退料单 Mapper
|
*/
|
@Mapper
|
public interface MesWmReturnIssueMapper extends BaseMapperX<MesWmReturnIssueDO> {
|
|
default PageResult<MesWmReturnIssueDO> selectPage(MesWmReturnIssuePageReqVO reqVO) {
|
LambdaQueryWrapperX<MesWmReturnIssueDO> wrapper = new LambdaQueryWrapperX<MesWmReturnIssueDO>()
|
.likeIfPresent(MesWmReturnIssueDO::getCode, reqVO.getCode())
|
.likeIfPresent(MesWmReturnIssueDO::getName, reqVO.getName())
|
.eqIfPresent(MesWmReturnIssueDO::getWorkstationId, reqVO.getWorkstationId())
|
.eqIfPresent(MesWmReturnIssueDO::getWorkOrderId, reqVO.getWorkOrderId())
|
.eqIfPresent(MesWmReturnIssueDO::getTaskId, reqVO.getTaskId())
|
.eqIfPresent(MesWmReturnIssueDO::getType, reqVO.getType())
|
.eqIfPresent(MesWmReturnIssueDO::getStatus, reqVO.getStatus())
|
.orderByDesc(MesWmReturnIssueDO::getId);
|
// 按工单编号检索：走子查询，避免与工单表联表影响分页总数
|
if (StrUtil.isNotBlank(reqVO.getWorkOrderCode())) {
|
wrapper.apply("work_order_id IN (SELECT id FROM mes_pro_work_order"
|
+ " WHERE deleted = 0 AND code LIKE CONCAT('%', {0}, '%'))",
|
reqVO.getWorkOrderCode());
|
}
|
return selectPage(reqVO, wrapper);
|
}
|
|
default MesWmReturnIssueDO selectByCode(String code) {
|
return selectOne(MesWmReturnIssueDO::getCode, code);
|
}
|
|
}
|
