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 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 queryListByCode(String pcode) throws JeecgBootException { String pid = ROOT_PID_VALUE; if (oConvertUtils.isNotEmpty(pcode)) { List list = baseMapper.selectList(new LambdaQueryWrapper().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 queryListByPid(String pid) { if (oConvertUtils.isEmpty(pid)) { pid = ROOT_PID_VALUE; } return baseMapper.queryListByPid(pid, null); } @Override public List queryListByPid(String pid, Map 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 updateWrapper = new UpdateWrapper() .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 queryWrapper = new LambdaQueryWrapper<>(); queryWrapper.eq(SysCategory::getPid, metaPid); queryWrapper.notIn(SysCategory::getId, Arrays.asList(idArr)); List 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 queryWrapper = new LambdaQueryWrapper<>(); queryWrapper.eq(SysCategory::getPid, pidVal); List 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 loadDictItem(String ids) { return this.loadDictItem(ids, true); } @Override public List loadDictItem(String ids, boolean delNotExist) { String[] idArray = ids.split(","); LambdaQueryWrapper query = new LambdaQueryWrapper<>(); query.in(SysCategory::getId, Arrays.asList(idArray)); // 查询数据 List list = super.list(query); // 取出name并返回 List 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 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 listByParams(SysCategory query) { QueryWrapper 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 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 queryWrapper = new LambdaQueryWrapper<>(); if (StringUtils.isNotBlank(rootCode)) { queryWrapper.eq(SysCategory::getRootCode, rootCode); } queryWrapper.eq(SysCategory::getCode, code); return sysCategoryMapper.selectOne(queryWrapper); } }