Merge branch 'mdc_hyjs_master'

zhangherong

2025-06-25 23855599412c4d61b38d78f0f3abd3430a48b5b1

 lxzn-module-system/lxzn-system-biz/src/main/java/org/jeecg/modules/system/service/impl/SysCategoryServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,344 @@
package org.jeecg.modules.system.service.impl;

import cn.hutool.core.collection.CollectionUtil;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.apache.commons.lang3.StringUtils;
import org.jeecg.common.constant.SymbolConstant;
import org.jeecg.common.exception.JeecgBootException;
import org.jeecg.common.util.oConvertUtils;
import org.jeecg.modules.system.entity.SysCategory;
import org.jeecg.modules.system.mapper.SysCategoryMapper;
import org.jeecg.modules.system.model.TreeSelectModel;
import org.jeecg.modules.system.service.ISysCategoryService;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import javax.annotation.Resource;
import java.util.*;
import java.util.stream.Collectors;

/**
 * @Description: åˆ†ç±»å­—å…¸
 * @Author: jeecg-boot
 * @Date: 2019-05-29
 * @Version: V1.0
 */
@Service
public class SysCategoryServiceImpl extends ServiceImpl<SysCategoryMapper, SysCategory> implements ISysCategoryService {

    @Resource
    private SysCategoryMapper sysCategoryMapper;

    @Override
    @Transactional(rollbackFor = Exception.class)
    public void addSysCategory(SysCategory sysCategory) {
        //修改字典分类  ç¼–码为手动输入
        if (StringUtils.isNotBlank(sysCategory.getPid())) {
            SysCategory parent = sysCategoryMapper.selectById(sysCategory.getPid());
            if (parent == null) {
                //父节点不存在 é»˜è®¤ä¸ºæ ¹èŠ‚点
                throw new JeecgBootException("父节点不存在，请重新添加！");
            } else {
                //校验编码唯一
                SysCategory original = getByCodeAndRootCode(sysCategory.getCode(), parent.getRootCode());
                if (original != null) {
                    throw new JeecgBootException("分类编码已存在，请修改后重试！");
                }
                if (ISysCategoryService.HAS_CHILD.equals(parent.getHasChild())) {
                    parent.setHasChild(ISysCategoryService.HAS_CHILD);
                    sysCategoryMapper.updateById(parent);
                }
                sysCategory.setRootCode(parent.getRootCode());
                String parentIds = parent.getParentIds() == null ? parent.getId() : (parent.getParentIds() + "," + parent.getId());
                sysCategory.setParentIds(parentIds);
            }
        } else {
            //校验编码唯一
            SysCategory original = getByCodeAndRootCode(sysCategory.getCode(), null);
            if (original != null) {
                throw new JeecgBootException("分类编码已存在，请修改后重试！");
            }
            //父节点不存在 é»˜è®¤ä¸ºæ ¹èŠ‚点
            sysCategory.setPid(ISysCategoryService.ROOT_PID_VALUE);
            sysCategory.setRootCode(sysCategory.getCode());
            sysCategory.setParentIds(null);
        }
        sysCategoryMapper.insert(sysCategory);
    }

    @Override
    @Transactional(rollbackFor = Exception.class)
    public void updateSysCategory(SysCategory sysCategory) {
        SysCategory entity = sysCategoryMapper.selectById(sysCategory.getId());
        if (entity == null) {
            throw new JeecgBootException("编辑的数据不存在，请刷新重试！");
        }
        if (oConvertUtils.isEmpty(sysCategory.getPid())) {
            sysCategory.setPid(ISysCategoryService.ROOT_PID_VALUE);
        } else {
            //如果当前节点父ID不为空 åˆ™è®¾ç½®çˆ¶èŠ‚点的hasChild ä¸º1
            SysCategory parent = sysCategoryMapper.selectById(sysCategory.getPid());
            if (parent != null && !ISysCategoryService.HAS_CHILD.equals(parent.getHasChild())) {
                parent.setHasChild(ISysCategoryService.HAS_CHILD);
                sysCategoryMapper.updateById(parent);
            } else {
                sysCategory.setPid(ISysCategoryService.ROOT_PID_VALUE);
            }
        }
        sysCategoryMapper.updateById(sysCategory);
    }

    @Override
    public List<TreeSelectModel> queryListByCode(String pcode) throws JeecgBootException {
        String pid = ROOT_PID_VALUE;
        if (oConvertUtils.isNotEmpty(pcode)) {
            List<SysCategory> list = baseMapper.selectList(new LambdaQueryWrapper<SysCategory>().eq(SysCategory::getCode, pcode));
            if (list == null || list.size() == 0) {
                throw new JeecgBootException("该编码【" + pcode + "】不存在，请核实!");
            }
            if (list.size() > 1) {
                throw new JeecgBootException("该编码【" + pcode + "】存在多个，请核实!");
            }
            pid = list.get(0).getId();
        }
        return baseMapper.queryListByPid(pid, null);
    }

    @Override
    public List<TreeSelectModel> queryListByPid(String pid) {
        if (oConvertUtils.isEmpty(pid)) {
            pid = ROOT_PID_VALUE;
        }
        return baseMapper.queryListByPid(pid, null);
    }

    @Override
    public List<TreeSelectModel> queryListByPid(String pid, Map<String, String> condition) {
        if (oConvertUtils.isEmpty(pid)) {
            pid = ROOT_PID_VALUE;
        }
        return baseMapper.queryListByPid(pid, condition);
    }

    @Override
    public String queryIdByCode(String code) {
        return baseMapper.queryIdByCode(code);
    }

    @Override
    @Transactional(rollbackFor = Exception.class)
    public void deleteSysCategory(String ids) {
        String allIds = this.queryTreeChildIds(ids);
        String pids = this.queryTreePids(ids);
        //1.删除时将节点下所有子节点一并删除
        this.baseMapper.deleteBatchIds(Arrays.asList(allIds.split(",")));
        //2.将父节点中已经没有下级的节点，修改为没有子节点
        if (oConvertUtils.isNotEmpty(pids)) {
            LambdaUpdateWrapper<SysCategory> updateWrapper = new UpdateWrapper<SysCategory>()
                    .lambda()
                    .in(SysCategory::getId, Arrays.asList(pids.split(",")))
                    .set(SysCategory::getHasChild, "0");
            this.update(updateWrapper);
        }
    }

    /**
     * æŸ¥è¯¢èŠ‚点下所有子节点
     *
     * @param ids
     * @return
     */
    private String queryTreeChildIds(String ids) {
        //获取id数组
        String[] idArr = ids.split(",");
        StringBuffer sb = new StringBuffer();
        for (String pidVal : idArr) {
            if (pidVal != null) {
                if (!sb.toString().contains(pidVal)) {
                    if (sb.toString().length() > 0) {
                        sb.append(",");
                    }
                    sb.append(pidVal);
                    this.getTreeChildIds(pidVal, sb);
                }
            }
        }
        return sb.toString();
    }

    /**
     * æŸ¥è¯¢éœ€ä¿®æ”¹æ ‡è¯†çš„父节点ids
     *
     * @param ids
     * @return
     */
    private String queryTreePids(String ids) {
        StringBuffer sb = new StringBuffer();
        //获取id数组
        String[] idArr = ids.split(",");
        for (String id : idArr) {
            if (id != null) {
                SysCategory category = this.baseMapper.selectById(id);
                //根据id查询pid值
                String metaPid = category.getPid();
                //查询此节点上一级是否还有其他子节点
                LambdaQueryWrapper<SysCategory> queryWrapper = new LambdaQueryWrapper<>();
                queryWrapper.eq(SysCategory::getPid, metaPid);
                queryWrapper.notIn(SysCategory::getId, Arrays.asList(idArr));
                List<SysCategory> dataList = this.baseMapper.selectList(queryWrapper);
                boolean flag = (dataList == null || dataList.size() == 0) && !Arrays.asList(idArr).contains(metaPid)
                        && !sb.toString().contains(metaPid);
                if (flag) {
                    //如果当前节点原本有子节点 çŽ°åœ¨æœ¨æœ‰äº†ï¼Œæ›´æ–°çŠ¶æ€
                    sb.append(metaPid).append(",");
                }
            }
        }
        if (sb.toString().endsWith(SymbolConstant.COMMA)) {
            sb = sb.deleteCharAt(sb.length() - 1);
        }
        return sb.toString();
    }

    /**
     * é€’å½’ æ ¹æ®çˆ¶id获取子节点id
     *
     * @param pidVal
     * @param sb
     * @return
     */
    private StringBuffer getTreeChildIds(String pidVal, StringBuffer sb) {
        LambdaQueryWrapper<SysCategory> queryWrapper = new LambdaQueryWrapper<>();
        queryWrapper.eq(SysCategory::getPid, pidVal);
        List<SysCategory> dataList = baseMapper.selectList(queryWrapper);
        if (dataList != null && dataList.size() > 0) {
            for (SysCategory category : dataList) {
                if (!sb.toString().contains(category.getId())) {
                    sb.append(",").append(category.getId());
                }
                this.getTreeChildIds(category.getId(), sb);
            }
        }
        return sb;
    }

    @Override
    public List<String> loadDictItem(String ids) {
        return this.loadDictItem(ids, true);
    }

    @Override
    public List<String> loadDictItem(String ids, boolean delNotExist) {
        String[] idArray = ids.split(",");
        LambdaQueryWrapper<SysCategory> query = new LambdaQueryWrapper<>();
        query.in(SysCategory::getId, Arrays.asList(idArray));
        // æŸ¥è¯¢æ•°æ®
        List<SysCategory> list = super.list(query);
        // å–出name并返回
        List<String> textList;
        // update-begin--author:sunjianlei--date:20210514--for：新增delNotExist参数，设为false不删除数据库里不存在的key ----
        if (delNotExist) {
            textList = list.stream().map(SysCategory::getName).collect(Collectors.toList());
        } else {
            textList = new ArrayList<>();
            for (String id : idArray) {
                List<SysCategory> res = list.stream().filter(i -> id.equals(i.getId())).collect(Collectors.toList());
                textList.add(res.size() > 0 ? res.get(0).getName() : id);
            }
        }
        // update-end--author:sunjianlei--date:20210514--for：新增delNotExist参数，设为false不删除数据库里不存在的key ----
        return textList;
    }

    @Override
    public List<SysCategory> listByParams(SysCategory query) {
        QueryWrapper<SysCategory> queryWrapper = new QueryWrapper<>(query);
        if (query != null) {
            if (StringUtils.isNotBlank(query.getName())) {
                queryWrapper.like("t.name", query.getName());
            }
            if (StringUtils.isNotBlank(query.getCode())) {
                queryWrapper.like("t.code", query.getCode());
            }
        }
        queryWrapper.orderByDesc("t.id");
        return sysCategoryMapper.listByParams(queryWrapper);
    }

    @Override
    @Transactional(rollbackFor = Exception.class)
    public void deepAdd(SysCategory sysCategory, List<String> errorMessage) {
        String parenCode = (StringUtils.isBlank(sysCategory.getParentCode()) ? "0" : sysCategory.getParentCode());
        if (ROOT_PID_VALUE.equals(parenCode)) {
            sysCategory.setPid(ROOT_PID_VALUE);
            sysCategory.setRootCode(sysCategory.getCode());
            sysCategory.setParentIds(null);
            //根节点
            SysCategory entity = this.getByCodeAndRootCode(sysCategory.getCode(), null);
            if (entity != null) {
                sysCategory.setId(entity.getId());
                sysCategoryMapper.updateById(sysCategory);
            } else {
                sysCategoryMapper.insert(sysCategory);
            }
        } else {
            //获取上级节点
            String pid = sysCategory.getPid();
            SysCategory parent = this.getById(pid);
            if (parent == null) {
                String rootCode = sysCategory.getRootCode();
                parent = this.getByCodeAndRootCode(parenCode, rootCode);
            }
            if (parent != null) {
                sysCategory.setPid(parent.getId());
                sysCategory.setRootCode(parent.getRootCode());
                String parentIds = (parent.getParentIds() == null ? parent.getId() : (parent.getParentIds() + "," + parent.getId()));
                sysCategory.setParentIds(parentIds);
                if (!ISysCategoryService.HAS_CHILD.equals(parent.getHasChild())) {
                    //更新根节点
                    parent.setHasChild(HAS_CHILD);
                    sysCategoryMapper.updateById(parent);
                }
                SysCategory entity = this.getByCodeAndRootCode(sysCategory.getCode(), parent.getRootCode());
                if (entity != null) {
                    sysCategory.setId(entity.getId());
                    sysCategoryMapper.updateById(sysCategory);
                } else {
                    sysCategoryMapper.insert(sysCategory);
                }
            } else {
                errorMessage.add(String.format("编码[%s]的父节点没有找到,", sysCategory.getCode()));
                return;
            }
        }
        if (CollectionUtil.isNotEmpty(sysCategory.getChildren())) {
            sysCategory.getChildren().forEach(child -> {
                child.setPid(sysCategory.getId());
                this.deepAdd(child, errorMessage);
            });
        }

    }

    /**
     * æŸ¥è¯¢ç¼–码是否已存在
     *
     * @param code     åˆ†ç±»ç¼–码
     * @param rootCode æ ¹èŠ‚点编码 ä¸ºç©ºï¼Œæ·»åŠ æ ¹èŠ‚点， ä¸ä¸ºç©ºï¼Œæ·»åŠ å­èŠ‚点
     * @return
     */
    @Override
    public SysCategory getByCodeAndRootCode(String code, String rootCode) {
        LambdaQueryWrapper<SysCategory> queryWrapper = new LambdaQueryWrapper<>();
        if (StringUtils.isNotBlank(rootCode)) {
            queryWrapper.eq(SysCategory::getRootCode, rootCode);
        }
        queryWrapper.eq(SysCategory::getCode, code);
        return sysCategoryMapper.selectOne(queryWrapper);
    }

}