| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235 | package org.jeecg.modules.system.service.impl;import com.alibaba.fastjson.JSONObject;import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;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.jeecg.common.constant.FillRuleConstant;import org.jeecg.common.exception.JeecgBootException;import org.jeecg.common.util.FillRuleUtil;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 java.util.ArrayList;import java.util.Arrays;import java.util.List;import java.util.Map;import java.util.stream.Collectors;/** * @Description: 分类字典 * @Author: jeecg-boot * @Date:   2019-05-29 * @Version: V1.0 */@Servicepublic class SysCategoryServiceImpl extends ServiceImpl<SysCategoryMapper, SysCategory> implements ISysCategoryService {	@Override	public void addSysCategory(SysCategory sysCategory) {		String categoryCode = "";		String categoryPid = ISysCategoryService.ROOT_PID_VALUE;		String parentCode = null;		if(oConvertUtils.isNotEmpty(sysCategory.getPid())){			categoryPid = sysCategory.getPid();			//PID 不是根节点 说明需要设置父节点 hasChild 为1			if(!ISysCategoryService.ROOT_PID_VALUE.equals(categoryPid)){				SysCategory parent = baseMapper.selectById(categoryPid);				parentCode = parent.getCode();				if(parent!=null && !"1".equals(parent.getHasChild())){					parent.setHasChild("1");					baseMapper.updateById(parent);				}			}		}		//update-begin--Author:baihailong  Date:20191209 for:分类字典编码规则生成器做成公用配置		JSONObject formData = new JSONObject();		formData.put("pid",categoryPid);		categoryCode = (String) FillRuleUtil.executeRule(FillRuleConstant.CATEGORY,formData);		//update-end--Author:baihailong  Date:20191209 for:分类字典编码规则生成器做成公用配置		sysCategory.setCode(categoryCode);		sysCategory.setPid(categoryPid);		baseMapper.insert(sysCategory);	}		@Override	public void updateSysCategory(SysCategory sysCategory) {		if(oConvertUtils.isEmpty(sysCategory.getPid())){			sysCategory.setPid(ISysCategoryService.ROOT_PID_VALUE);		}else{			//如果当前节点父ID不为空 则设置父节点的hasChild 为1			SysCategory parent = baseMapper.selectById(sysCategory.getPid());			if(parent!=null && !"1".equals(parent.getHasChild())){				parent.setHasChild("1");				baseMapper.updateById(parent);			}		}		baseMapper.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);				if((dataList == null || dataList.size()==0) && !Arrays.asList(idArr).contains(metaPid)						&& !sb.toString().contains(metaPid)){					//如果当前节点原本有子节点 现在木有了,更新状态					sb.append(metaPid).append(",");				}			}		}		if(sb.toString().endsWith(",")){			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;	}}
 |