| | |
| | | import cn.iocoder.yudao.module.mes.controller.admin.md.item.vo.MesMdItemPageReqVO; |
| | | import cn.iocoder.yudao.module.mes.dal.dataobject.md.item.MesMdItemDO; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | import org.apache.ibatis.annotations.Select; |
| | | import org.apache.ibatis.annotations.Update; |
| | | |
| | | import java.util.Collection; |
| | | import java.util.Collections; |
| | |
| | | /** |
| | | * MES 物料产品 Mapper |
| | | * |
| | | * @author 芋道源码 |
| | | * @author 超级管理员 |
| | | */ |
| | | @Mapper |
| | | public interface MesMdItemMapper extends BaseMapperX<MesMdItemDO> { |
| | | |
| | | default PageResult<MesMdItemDO> selectPage(MesMdItemPageReqVO reqVO, Collection<Long> itemTypeIds) { |
| | | return selectPage(reqVO, new LambdaQueryWrapperX<MesMdItemDO>() |
| | | .inIfPresent(MesMdItemDO::getId, reqVO.getIds()) |
| | | .likeIfPresent(MesMdItemDO::getCode, reqVO.getCode()) |
| | | .likeIfPresent(MesMdItemDO::getName, reqVO.getName()) |
| | | .inIfPresent(MesMdItemDO::getItemTypeId, itemTypeIds) |
| | | .eqIfPresent(MesMdItemDO::getStatus, reqVO.getStatus()) |
| | | .betweenIfPresent(MesMdItemDO::getCreateTime, reqVO.getCreateTime()) |
| | | .orderByAsc(MesMdItemDO::getSort) |
| | | .orderByDesc(MesMdItemDO::getId)); |
| | | } |
| | | |
| | | default MesMdItemDO selectByCode(String code) { |
| | | return selectOne(MesMdItemDO::getCode, code); |
| | | } |
| | | |
| | | default MesMdItemDO selectByName(String name) { |
| | | return selectOne(MesMdItemDO::getName, name); |
| | | } |
| | | |
| | | default Long selectCountByItemTypeId(Long itemTypeId) { |
| | |
| | | } |
| | | |
| | | /** |
| | | * 按 ID 查询记录(不过滤逻辑删除,含已删除行) |
| | | * 用于"取消同步(逻辑删除)后重新同步"时判断主键是否被占用 |
| | | */ |
| | | @Select("SELECT * FROM mes_md_item WHERE id = #{id} LIMIT 1") |
| | | MesMdItemDO selectAnyById(Long id); |
| | | |
| | | /** |
| | | * 恢复逻辑删除的记录(deleted 置 0) |
| | | */ |
| | | @Update("UPDATE mes_md_item SET deleted = 0, update_time = NOW() WHERE id = #{id}") |
| | | int restoreById(Long id); |
| | | |
| | | /** |
| | | * 批量查询已存在的 MDM 物料 ID 集合 |
| | | * |
| | | * @param mdmItemIds MDM 物料 ID 列表 |