| | |
|---|
| | | 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; |
|---|
| | |
|---|
| | | public interface MesWmReturnIssueMapper extends BaseMapperX<MesWmReturnIssueDO> { |
|---|
| | | |
|---|
| | | default PageResult<MesWmReturnIssueDO> selectPage(MesWmReturnIssuePageReqVO reqVO) { |
|---|
| | | return selectPage(reqVO, new LambdaQueryWrapperX<MesWmReturnIssueDO>() |
|---|
| | | 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()) |
|---|
| | | .orderByDesc(MesWmReturnIssueDO::getId)); |
|---|
| | | .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) { |
|---|
