From 6d30a1ef0014acd773f23e0a7dc968d6608f4666 Mon Sep 17 00:00:00 2001 From: jiangping <jp@doumee.com> Date: 星期二, 15 四月 2025 08:34:20 +0800 Subject: [PATCH] 代码初始化 --- server/src/main/java/com/doumee/service/business/impl/CategoryServiceImpl.java | 7 +++++-- 1 files changed, 5 insertions(+), 2 deletions(-) diff --git a/server/src/main/java/com/doumee/service/business/impl/CategoryServiceImpl.java b/server/src/main/java/com/doumee/service/business/impl/CategoryServiceImpl.java index e32f0ef..928e60e 100644 --- a/server/src/main/java/com/doumee/service/business/impl/CategoryServiceImpl.java +++ b/server/src/main/java/com/doumee/service/business/impl/CategoryServiceImpl.java @@ -199,6 +199,7 @@ .eq(category.getType() != null, Category::getType, category.getType()) .eq(category.getParentId() != null, Category::getParentId, category.getParentId()) .eq(category.getNamePath() != null, Category::getNamePath, category.getNamePath()) + .isNull(category.getIsRoot() != null &&category.getIsRoot().equals(Constants.ONE), Category::getParentId) .eq(category.getIdPath() != null, Category::getIdPath, category.getIdPath()) .orderByAsc( Category::getSortnum); return categoryMapper.selectJoinList(Category.class,queryWrapper); @@ -267,10 +268,11 @@ @Override - public List<CategoryVO> getCategoryVOTree(String categoryType){ + public List<CategoryVO> getCategoryVOTree(String categoryType,Integer categoryId){ List<Category> categoryList = categoryMapper.selectList(new QueryWrapper<Category>().lambda() .eq(Category::getIsdeleted, Constants.ZERO) .in(Objects.nonNull(categoryType),Category::getType,categoryType.split(",")) + .apply(Objects.nonNull(categoryId)," find_in_set("+categoryId+", REPLACE(ID_PATH,'/',',') ) ") .orderByAsc(Category::getSortnum,Category::getId) ); List<CategoryVO> categoryVOList = new ArrayList<>(); @@ -290,10 +292,11 @@ @Override - public List<CategoryVO> getCategoryVOList(Integer categoryType){ + public List<CategoryVO> getCategoryVOList(Integer categoryType,Integer isRoot){ List<Category> categoryList = categoryMapper.selectList(new QueryWrapper<Category>().lambda() .eq(Category::getIsdeleted, Constants.ZERO) .eq(Objects.nonNull(categoryType),Category::getType,categoryType) + .isNull(Constants.equalsInteger(isRoot,Constants.ONE),Category::getParentId) .orderByAsc(Category::getSortnum,Category::getId) ); List<CategoryVO> categoryVOList = new ArrayList<>(); -- Gitblit v1.9.3