package cn.iocoder.yudao.module.mes.dal.mysql.wm.productissue; 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.productissue.vo.MesWmProductIssuePageReqVO; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.productissue.MesWmProductIssueDO; import org.apache.ibatis.annotations.Mapper; import java.util.List; /** * MES 领料出库单 Mapper */ @Mapper public interface MesWmProductIssueMapper extends BaseMapperX { default PageResult selectPage(MesWmProductIssuePageReqVO reqVO) { LambdaQueryWrapperX wrapper = new LambdaQueryWrapperX() .likeIfPresent(MesWmProductIssueDO::getCode, reqVO.getCode()) .likeIfPresent(MesWmProductIssueDO::getName, reqVO.getName()) .eqIfPresent(MesWmProductIssueDO::getWorkstationId, reqVO.getWorkstationId()) .eqIfPresent(MesWmProductIssueDO::getWorkOrderId, reqVO.getWorkOrderId()) .eqIfPresent(MesWmProductIssueDO::getIssueType, reqVO.getIssueType()) .eqIfPresent(MesWmProductIssueDO::getTaskId, reqVO.getTaskId()) .eqIfPresent(MesWmProductIssueDO::getStatus, reqVO.getStatus()) .betweenIfPresent(MesWmProductIssueDO::getIssueDate, reqVO.getIssueDate()) .orderByDesc(MesWmProductIssueDO::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 MesWmProductIssueDO selectByCode(String code) { return selectOne(MesWmProductIssueDO::getCode, code); } default List selectListByWorkOrderIdAndStatus(Long workOrderId, Integer status) { return selectList(new LambdaQueryWrapperX() .eq(MesWmProductIssueDO::getWorkOrderId, workOrderId) .eq(MesWmProductIssueDO::getStatus, status)); } default List selectListByWorkOrderId(Long workOrderId) { return selectList(new LambdaQueryWrapperX() .eq(MesWmProductIssueDO::getWorkOrderId, workOrderId)); } }