| | |
|---|
| | | 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; |
|---|
| | |
|---|
| | | public interface MesWmProductIssueMapper extends BaseMapperX<MesWmProductIssueDO> { |
|---|
| | | |
|---|
| | | default PageResult<MesWmProductIssueDO> selectPage(MesWmProductIssuePageReqVO reqVO) { |
|---|
| | | return selectPage(reqVO, new LambdaQueryWrapperX<MesWmProductIssueDO>() |
|---|
| | | LambdaQueryWrapperX<MesWmProductIssueDO> wrapper = new LambdaQueryWrapperX<MesWmProductIssueDO>() |
|---|
| | | .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)); |
|---|
| | | .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) { |
|---|
| | |
|---|
| | | .eq(MesWmProductIssueDO::getStatus, status)); |
|---|
| | | } |
|---|
| | | |
|---|
| | | default List<MesWmProductIssueDO> selectListByWorkOrderId(Long workOrderId) { |
|---|
| | | return selectList(new LambdaQueryWrapperX<MesWmProductIssueDO>() |
|---|
| | | .eq(MesWmProductIssueDO::getWorkOrderId, workOrderId)); |
|---|
| | | } |
|---|
| | | |
|---|
| | | } |
|---|
