| | |
| | | .likeIfPresent(MdmItemDO::getCode, reqVO.getCode()) |
| | | .likeIfPresent(MdmItemDO::getName, reqVO.getName()) |
| | | .likeIfPresent(MdmItemDO::getBarCode, reqVO.getBarCode()) |
| | | .likeIfPresent(MdmItemDO::getColor, reqVO.getColor()) |
| | | .inIfPresent(MdmItemDO::getCategoryId, categoryIds) |
| | | .eqIfPresent(MdmItemDO::getItemType, reqVO.getItemType()) |
| | | .eqIfPresent(MdmItemDO::getBrandId, reqVO.getBrandId()) |
| | | .eqIfPresent(MdmItemDO::getStatus, reqVO.getStatus()) |
| | | .betweenIfPresent(MdmItemDO::getCreateTime, reqVO.getCreateTime()) |
| | | .orderByDesc(MdmItemDO::getId)); |
| | | // 列表按物料编码排序(原来先按物料分类分组再按编码,同一分类的物料才排在一起,跨分类看编码是乱序的) |
| | | .orderByAsc(MdmItemDO::getCode)); |
| | | } |
| | | |
| | | default List<MdmItemDO> selectList(MdmItemPageReqVO reqVO, Collection<Long> categoryIds) { |
| | | return selectList(new LambdaQueryWrapperX<MdmItemDO>() |
| | | .likeIfPresent(MdmItemDO::getCode, reqVO.getCode()) |
| | | .likeIfPresent(MdmItemDO::getName, reqVO.getName()) |
| | | .likeIfPresent(MdmItemDO::getColor, reqVO.getColor()) |
| | | .inIfPresent(MdmItemDO::getCategoryId, categoryIds) |
| | | .eqIfPresent(MdmItemDO::getItemType, reqVO.getItemType()) |
| | | .eqIfPresent(MdmItemDO::getStatus, reqVO.getStatus()) |