From 1c20c8231980a8d4b91688ff8641a06d3b2f68ab Mon Sep 17 00:00:00 2001
From: MrShi <1878285526@qq.com>
Date: 星期二, 14 十月 2025 16:34:22 +0800
Subject: [PATCH] 改bug

---
 server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CategoryServiceImpl.java |  162 +++++++++++++++++++++++++++++++++++-------------------
 1 files changed, 105 insertions(+), 57 deletions(-)

diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CategoryServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CategoryServiceImpl.java
index e0601bc..e357e36 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CategoryServiceImpl.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CategoryServiceImpl.java
@@ -2,9 +2,9 @@
 
 import com.doumee.core.constants.ResponseStatus;
 import com.doumee.core.exception.BusinessException;
-import com.doumee.core.model.LoginUserInfo;
-import com.doumee.core.model.PageData;
-import com.doumee.core.model.PageWrap;
+import com.doumee.service.business.third.model.LoginUserInfo;
+import com.doumee.service.business.third.model.PageData;
+import com.doumee.service.business.third.model.PageWrap;
 import com.doumee.core.utils.Constants;
 import com.doumee.core.utils.Utils;
 import com.doumee.dao.business.CategoryMapper;
@@ -14,13 +14,20 @@
 import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import org.apache.commons.lang3.StringUtils;
 import org.apache.shiro.SecurityUtils;
+import org.checkerframework.checker.units.qual.C;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
 import org.springframework.util.CollectionUtils;
+import org.springframework.validation.BindException;
 
+import java.util.ArrayList;
 import java.util.Date;
 import java.util.List;
+import java.util.Objects;
+import java.util.stream.Collectors;
 
 /**
  * 鍒嗙被淇℃伅琛⊿ervice瀹炵幇
@@ -34,7 +41,8 @@
     private CategoryMapper categoryMapper;
 
     @Override
-    public Integer create(Category category) {
+    @Transactional(rollbackFor = {Exception.class, BindException.class})
+    public Integer create(Category category){
         checkUnique(category);
         LoginUserInfo loginUserInfo = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
         if(loginUserInfo ==null){
@@ -50,16 +58,27 @@
         insert.setRemark(category.getRemark());
         insert.setStatus(Constants.ZERO);
         insert.setSortnum(category.getSortnum());
+        insert.setBizType(category.getBizType());
         insert.setImgurl(category.getImgurl());
-        insert.setType(Constants.ZERO);
+        insert.setType(category.getType());
         insert.setParentId(category.getParentId());
         categoryMapper.insert(insert);
+        if(insert.getBizType()!=null){
+            //娓呯┖鍏朵粬bizType,鍙繚鐣欏綋鍓嶆柊澧炶褰曞敮涓�鏈夋晥
+            categoryMapper.update(null,new UpdateWrapper<Category>().lambda()
+                    .set(Category::getBizType,null)
+                    .eq(Category::getBizType,insert.getType())
+                    .ne(Category::getId,insert.getId())
+            );
+        }
         return insert.getId();
     }
 
     @Override
     public void deleteById(Integer id) {
-        categoryMapper.deleteById(id);
+        categoryMapper.update(null,new UpdateWrapper<Category>().lambda().set(Category::getIsdeleted,Constants.ONE)
+                .eq(Category::getId,id)
+        );
     }
 
     @Override
@@ -73,13 +92,24 @@
         if (CollectionUtils.isEmpty(ids)) {
             return;
         }
-        categoryMapper.deleteBatchIds(ids);
+        categoryMapper.update(null,new UpdateWrapper<Category>().lambda().set(Category::getIsdeleted,Constants.ONE)
+                .in(Category::getId,ids)
+        );
     }
 
     @Override
+    @Transactional(rollbackFor = {Exception.class, BindException.class})
     public void updateById(Category category) {
         checkUnique(category);
         categoryMapper.updateById(category);
+        if(category.getBizType()!=null){
+            //娓呯┖鍏朵粬璇izType灞炴��,鍙繚鐣欏綋鍓嶈褰曞敮涓�鏈夋晥
+            categoryMapper.update(null,new UpdateWrapper<Category>().lambda()
+                    .set(Category::getBizType,null)
+                    .eq(Category::getBizType,category.getBizType())
+                    .ne(Category::getId,category.getId())
+            );
+        }
     }
 
     @Override
@@ -110,59 +140,40 @@
     }
 
     @Override
+    public List<Category> queryList(Category category) {
+        List<Category> categoryList = categoryMapper.selectList(new QueryWrapper<Category>().lambda()
+                .eq(Objects.nonNull(category)&&Objects.nonNull(category.getType()),Category::getType,category.getType())
+                .isNull(Objects.nonNull(category)&&Objects.isNull(category.getParentId()),Category::getParentId)
+                .eq(Objects.nonNull(category)&&Objects.nonNull(category.getParentId()),Category::getParentId,category.getParentId())
+                .eq(Category::getIsdeleted,Constants.ZERO)
+        );
+        return categoryList;
+    }
+
+    @Override
     public PageData<Category> findPage(PageWrap<Category> pageWrap) {
         IPage<Category> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
         QueryWrapper<Category> queryWrapper = new QueryWrapper<>();
         Utils.MP.blankToNull(pageWrap.getModel());
-        if (pageWrap.getModel().getId() != null) {
-            queryWrapper.lambda().eq(Category::getId, pageWrap.getModel().getId());
+        queryWrapper.lambda().eq(Category::getIsdeleted,Constants.ZERO)
+                .eq(Objects.nonNull(pageWrap.getModel().getType()),Category::getType,pageWrap.getModel().getType())
+                .like(StringUtils.isNotBlank(pageWrap.getModel().getName()),Category::getName,pageWrap.getModel().getName())
+                .isNull(Category::getParentId)
+                .orderByDesc(Category::getSortnum);
+        PageData<Category> categoryPageData = PageData.from(categoryMapper.selectPage(page, queryWrapper));
+        //鏌ヨ鎵�鏈変簩绾ф暟鎹�
+        List<Category> categoryList = categoryMapper.selectList(
+                new QueryWrapper<Category>().lambda()
+                        .eq(Objects.nonNull(pageWrap.getModel().getType()),Category::getType,pageWrap.getModel().getType())
+                        .eq(Category::getIsdeleted,Constants.ZERO).isNotNull(Category::getParentId).orderByDesc(Category::getSortnum));
+
+        for (Category category:categoryPageData.getRecords()) {
+            category.setChildCategoryList(
+                    categoryList.stream().filter(i->Constants.equalsInteger(i.getParentId(),category.getId())).collect(Collectors.toList())
+            );
         }
-        if (pageWrap.getModel().getCreator() != null) {
-            queryWrapper.lambda().eq(Category::getCreator, pageWrap.getModel().getCreator());
-        }
-        if (pageWrap.getModel().getCreateDate() != null) {
-            queryWrapper.lambda().ge(Category::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate()));
-            queryWrapper.lambda().le(Category::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate()));
-        }
-        if (pageWrap.getModel().getEditor() != null) {
-            queryWrapper.lambda().eq(Category::getEditor, pageWrap.getModel().getEditor());
-        }
-        if (pageWrap.getModel().getEditDate() != null) {
-            queryWrapper.lambda().ge(Category::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate()));
-            queryWrapper.lambda().le(Category::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate()));
-        }
-        if (pageWrap.getModel().getIsdeleted() != null) {
-            queryWrapper.lambda().eq(Category::getIsdeleted, pageWrap.getModel().getIsdeleted());
-        }
-        if (pageWrap.getModel().getName() != null) {
-            queryWrapper.lambda().eq(Category::getName, pageWrap.getModel().getName());
-        }
-        if (pageWrap.getModel().getRemark() != null) {
-            queryWrapper.lambda().eq(Category::getRemark, pageWrap.getModel().getRemark());
-        }
-        if (pageWrap.getModel().getStatus() != null) {
-            queryWrapper.lambda().eq(Category::getStatus, pageWrap.getModel().getStatus());
-        }
-        if (pageWrap.getModel().getSortnum() != null) {
-            queryWrapper.lambda().eq(Category::getSortnum, pageWrap.getModel().getSortnum());
-        }
-        if (pageWrap.getModel().getImgurl() != null) {
-            queryWrapper.lambda().eq(Category::getImgurl, pageWrap.getModel().getImgurl());
-        }
-        if (pageWrap.getModel().getType() != null) {
-            queryWrapper.lambda().eq(Category::getType, pageWrap.getModel().getType());
-        }
-        if (pageWrap.getModel().getParentId() != null) {
-            queryWrapper.lambda().eq(Category::getParentId, pageWrap.getModel().getParentId());
-        }
-        for(PageWrap.SortData sortData: pageWrap.getSorts()) {
-            if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) {
-                queryWrapper.orderByDesc(sortData.getProperty());
-            } else {
-                queryWrapper.orderByAsc(sortData.getProperty());
-            }
-        }
-        return PageData.from(categoryMapper.selectPage(page, queryWrapper));
+
+        return categoryPageData;
     }
 
     @Override
@@ -170,16 +181,53 @@
         QueryWrapper<Category> wrapper = new QueryWrapper<>(category);
         return categoryMapper.selectCount(wrapper);
     }
+    @Override
+    public  List<Category> findChileList(Category model) {
+        if(Objects.isNull(model)){
+            model = new Category();
+        }
+        model.setIsdeleted(Constants.ZERO);
+        List<Category> list =findList(model);
+        List<Category> data = new ArrayList<>();
+        if(list!=null){
+            for(Category category : list){
+                if(category.getParentId()!=null){
+                    Category pcate = getParentById(category.getParentId(),list);
+                    if(pcate!=null){
+                        category.setParentName(StringUtils.defaultString(pcate.getName(),""));
+                        category.setName(StringUtils.defaultString(category.getName(),""));
+                        category.setGroupName( category.getParentName()+"/"+category.getName());
+                        data.add(category);
+                    }
+                }else{
+                    data.add(category);
+                }
+            }
+        }
+        return  data;
+    }
+
+    private Category getParentById(Integer parentId, List<Category> list) {
+        if(list!=null){
+            for(Category category : list){
+                if(Constants.equalsInteger(parentId,category.getId())){
+                   return  category;
+                }
+            }
+        }
+        return  null;
+    }
 
     private void checkUnique(Category category){
         QueryWrapper<Category> wrapper = new QueryWrapper<>();
         wrapper.lambda()
                 .eq(Category::getIsdeleted,Constants.ZERO)
                 .eq(Category::getType,category.getType())
-                .eq(Category::getName,category.getName());
+                .eq(Category::getName,category.getName())
+                .ne(category.getId()!=null, Category::getId,category.getId())
+        ;
 
         List<Category> categories = categoryMapper.selectList(wrapper);
-
         if (org.apache.commons.collections.CollectionUtils.isNotEmpty(categories)){
             throw new BusinessException(ResponseStatus.DATA_EXISTS.getCode(),"鍒嗙被淇℃伅宸插瓨鍦�");
         }

--
Gitblit v1.9.3