| | |
|---|
| | | @Mapper |
|---|
| | | public interface MdmItemMapper extends BaseMapperX<MdmItemDO> { |
|---|
| | | |
|---|
| | | @org.apache.ibatis.annotations.Select("SELECT COALESCE(MAX(CAST(SUBSTRING(code, 5) AS UNSIGNED)), 0) FROM mdm_item WHERE deleted = 0 AND code LIKE CONCAT(#{prefix}, '%')") |
|---|
| | | Integer selectMaxSequenceByPrefix(@Param("prefix") String prefix); |
|---|
| | | |
|---|
| | | default PageResult<MdmItemDO> selectPage(MdmItemPageReqVO reqVO, Collection<Long> categoryIds) { |
|---|
| | | return selectPage(reqVO, new LambdaQueryWrapperX<MdmItemDO>() |
|---|
| | | .likeIfPresent(MdmItemDO::getCode, reqVO.getCode()) |
|---|
| | |
|---|
| | | .eqIfPresent(MdmItemDO::getBrandId, reqVO.getBrandId()) |
|---|
| | | .eqIfPresent(MdmItemDO::getStatus, reqVO.getStatus()) |
|---|
| | | .betweenIfPresent(MdmItemDO::getCreateTime, reqVO.getCreateTime()) |
|---|
| | | .orderByAsc(MdmItemDO::getCategoryId) |
|---|
| | | // 列表按物料编码排序（原来先按物料分类分组再按编码，同一分类的物料才排在一起，跨分类看编码是乱序的） |
|---|
| | | .orderByAsc(MdmItemDO::getCode)); |
|---|
| | | } |
|---|
| | | |
|---|
| | |
|---|
| | | |
|---|
| | | default MdmItemDO selectByCode(String code) { |
|---|
| | | return selectOne(MdmItemDO::getCode, code); |
|---|
| | | } |
|---|
| | | |
|---|
| | | default List<MdmItemDO> selectListByCode(String code) { |
|---|
| | | return selectList(MdmItemDO::getCode, code); |
|---|
| | | } |
|---|
| | | |
|---|
| | | /** |
|---|
| | |
|---|
| | | */ |
|---|
| | | List<Map<String, Object>> selectItemReferenceCount(@Param("itemId") Long itemId); |
|---|
| | | |
|---|
| | | } |
|---|
| | | } |
|---|
