StructureServiceImpl.java 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469
  1. package cn.cslg.pas.service.impl;
  2. import cn.cslg.pas.common.model.PersonnelVO;
  3. import cn.cslg.pas.common.model.dto.*;
  4. import cn.cslg.pas.common.model.vo.PathStructureNameVO;
  5. import cn.cslg.pas.common.model.vo.StructurePictureVO;
  6. import cn.cslg.pas.common.model.vo.StructureVO;
  7. import cn.cslg.pas.common.utils.CacheUtils;
  8. import cn.cslg.pas.common.utils.FileUtils;
  9. import cn.cslg.pas.common.utils.SecurityUtils.LoginUtils;
  10. import cn.cslg.pas.common.utils.ThrowException;
  11. import cn.cslg.pas.domain.Project;
  12. import cn.cslg.pas.domain.Structure;
  13. import cn.cslg.pas.domain.asso.AssoStructurePicture;
  14. import cn.cslg.pas.exception.XiaoShiException;
  15. import cn.cslg.pas.mapper.asso.AssoStructurePatentMapper;
  16. import cn.cslg.pas.mapper.asso.AssoStructurePictureMapper;
  17. import cn.cslg.pas.mapper.StructureMapper;
  18. import cn.cslg.pas.service.IStructureService;
  19. import cn.cslg.pas.service.ProjectService;
  20. import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
  21. import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
  22. import lombok.RequiredArgsConstructor;
  23. import lombok.extern.slf4j.Slf4j;
  24. import org.springframework.beans.BeanUtils;
  25. import org.springframework.stereotype.Service;
  26. import org.springframework.web.multipart.MultipartFile;
  27. import java.util.ArrayList;
  28. import java.util.Arrays;
  29. import java.util.HashMap;
  30. import java.util.List;
  31. import java.util.stream.Collectors;
  32. /**
  33. * 架构的Service层接口实现类
  34. *
  35. * @Author chenyu
  36. * @Date 2023/3/10
  37. */
  38. @RequiredArgsConstructor
  39. @Slf4j
  40. @Service
  41. public class StructureServiceImpl extends ServiceImpl<StructureMapper, Structure> implements IStructureService {
  42. private final StructureMapper structureMapper;
  43. private final AssoStructurePictureMapper assoStructurePictureMapper;
  44. private final AssoStructurePatentMapper assoStructurePatentMapper;
  45. private final ProjectService projectService;
  46. private final CacheUtils cacheUtils;
  47. private final LoginUtils loginUtils;
  48. private final FileUtils fileUtils;
  49. /**
  50. * 新增架构
  51. *
  52. * @param structureAddNewDTO 新增架构DTO对象
  53. * @param files 架构图片
  54. */
  55. @Override
  56. public void addNew(StructureAddNewDTO structureAddNewDTO, List<MultipartFile> files) {
  57. log.info("开始处理【新增架构】的业务,参数为:{}, {}", structureAddNewDTO, files);
  58. Integer parentId = structureAddNewDTO.getParentId();
  59. String structureName = structureAddNewDTO.getStructureName();
  60. //检查名称是否被占用(检查当前架构父级下是否有同名架构)
  61. log.info("检查名称是否被占用(检查当前父级下是否有同名架构)");
  62. int count = structureMapper.countByparentIdAndStructureName(parentId, structureName, null);
  63. if (count > 0) {
  64. String message = "新增架构失败,当前父级下已存在【" + structureName + "】,请尝试更换名称";
  65. log.info("{}", message);
  66. throw new XiaoShiException(message);
  67. }
  68. //DTO对象赋值给实体类
  69. Structure structure = new Structure();
  70. BeanUtils.copyProperties(structureAddNewDTO, structure);
  71. PersonnelVO personnelVO = cacheUtils.getLoginUser(loginUtils.getId());
  72. structure
  73. .setCreatePersonId(personnelVO.getId())
  74. .setCreatePersonName(personnelVO.getName());
  75. //数据入架构表(此时数据暂不含路径path)
  76. log.info("数据入架构表");
  77. int rows = structureMapper.insert(structure);
  78. if (rows != 1) {
  79. String message = "新增架构失败,服务器忙请稍后再次尝试!";
  80. log.info("{}", message);
  81. throw new XiaoShiException(message);
  82. }
  83. //数据入架构表后,取出id
  84. Integer structureId = structure.getId();
  85. String parentPath = structureAddNewDTO.getParentPath();
  86. String path;
  87. if (parentPath != null) {
  88. path = parentPath + "," + structureId;
  89. } else {
  90. path = "0," + structureId;
  91. }
  92. structure.setPath(path);
  93. log.info("更新架构表");
  94. rows = structureMapper.update(structure);
  95. if (rows != 1) {
  96. String message = "新增架构失败,服务器忙请稍后再次尝试!";
  97. log.info("{}", message);
  98. throw new XiaoShiException(message);
  99. }
  100. //如果前端有传来架构图片,则图片上传服务器并获取图片信息,将图片信息入架构图片关联表
  101. if (files != null && files.size() > 0) {
  102. ArrayList<AssoStructurePicture> assoStructurePictures = new ArrayList<>();
  103. for (MultipartFile file : files) {
  104. UploadFileDTO fileDTO = fileUtils.uploadFile(file);
  105. AssoStructurePicture assoStructurePicture = new AssoStructurePicture()
  106. .setStructureId(structureId)
  107. .setName(fileDTO.getName())
  108. .setSuffix(fileDTO.getExtName())
  109. .setUrl(fileDTO.getPath());
  110. assoStructurePictures.add(assoStructurePicture);
  111. }
  112. rows = assoStructurePictureMapper.insertBatch(assoStructurePictures);
  113. if (rows != assoStructurePictures.size()) {
  114. String message = "新增架构失败,数据入架构图片关联表失败,服务器忙请稍后再次尝试!";
  115. log.info("{}", message);
  116. throw new XiaoShiException(message);
  117. }
  118. }
  119. log.info("新增架构完成");
  120. }
  121. /**
  122. * 修改架构
  123. *
  124. * @param structureUpdateDTO 修改架构DTO对象
  125. * @param files 架构图片
  126. */
  127. @Override
  128. public void update(StructureUpdateDTO structureUpdateDTO, List<MultipartFile> files) {
  129. log.info("开始处理【修改架构】的业务,参数为:{}, {}", structureUpdateDTO, files);
  130. //检查尝试修改的数据是否存在
  131. Integer structureId = structureUpdateDTO.getId();
  132. log.info("检查尝试修改的数据是否存在");
  133. Structure queryResult = structureMapper.getStandardById(structureId);
  134. if (queryResult == null) {
  135. String message = "修改架构失败,尝试访问的数据已不存在";
  136. log.info("{}", message);
  137. throw new XiaoShiException(message);
  138. }
  139. //获取该架构原名称、父级id和原路径
  140. Integer oldParentId = queryResult.getParentId();
  141. String oldPath = queryResult.getPath();
  142. //获取DTO中架构现名称、父级id和父路径
  143. Integer newParentId = structureUpdateDTO.getParentId();
  144. String newPath = structureUpdateDTO.getParentPath() + "," + structureId;
  145. //获取DTO中该架构当前名称
  146. String newStructureName = structureUpdateDTO.getStructureName();
  147. //检查名称是否被占用(检查当前尝试修改的架构父级下是否有同名架构)
  148. log.info("检查名称是否被占用(检查当前尝试修改的架构的新父级下是否有同名架构)");
  149. int count = structureMapper.countByparentIdAndStructureName(newParentId, newStructureName, structureId);
  150. if (count > 0) {
  151. String message = "修改架构失败,当前尝试修改的架构父级下已存在【" + newStructureName + "】,请尝试更换名称";
  152. log.info("{}", message);
  153. throw new XiaoShiException(message);
  154. }
  155. //DTO对象赋值给实体类
  156. Structure structure = new Structure();
  157. BeanUtils.copyProperties(structureUpdateDTO, structure);
  158. //如果新路径和原路径不一样,则表示架构更换了父级
  159. if (!oldParentId.equals(newParentId)) {
  160. structure.setParentId(newParentId);
  161. structure.setPath(newPath);
  162. //还要将当前架构下所有子级架构的路径也都更新
  163. //根据当前架构原来的路径查询所有子级架构
  164. log.info("根据当前架构原来的路径查询所有子级架构");
  165. List<StructureVO> structures = structureMapper.selectByFindInSetPath(structureId + "");
  166. for (StructureVO n : structures) {
  167. //如果是当前修改的架构则跳过当前遍历
  168. if (n.getId().equals(structureId)) {
  169. continue;
  170. }
  171. String path = n.getPath();
  172. //从它的父级架构路径(即当前修改的架构)的原来的路径的长度的位置处截取后面路径
  173. String behindString = path.substring(oldPath.length());
  174. path = newPath + behindString;
  175. n.setPath(path);
  176. Structure structure2 = new Structure();
  177. BeanUtils.copyProperties(n, structure2);
  178. log.info("修改当前已更换父级的架构的子级架构路径path");
  179. int rows = structureMapper.update(structure2);
  180. if (rows != 1) {
  181. String message = "修改架构失败,修改当前已更换父级的架构的子级架构路径path失败,服务器忙请稍后再次尝试!";
  182. log.info("{}", message);
  183. throw new XiaoShiException(message);
  184. }
  185. }
  186. }
  187. //架构表修改数据
  188. log.info("架构表修改数据");
  189. int rows = structureMapper.update(structure);
  190. if (rows != 1) {
  191. String message = "修改架构失败,服务器忙请稍后再次尝试!";
  192. log.info("{}", message);
  193. throw new XiaoShiException(message);
  194. }
  195. //架构图片关联表删除数据(若有原有图片被删除)
  196. //根据架构id查询出所有原有图片
  197. log.info("根据架构id查询出所有原有图片");
  198. List<StructurePictureVO> structurePictures = assoStructurePictureMapper.selectByStructureId(structureId);
  199. ArrayList<Integer> oldPictureIds = new ArrayList<>();
  200. for (StructurePictureVO structurePicture : structurePictures) {
  201. Integer oldPictureId = structurePicture.getId();
  202. oldPictureIds.add(oldPictureId);
  203. }
  204. //从DTO中获取传过来的原有图片
  205. List<StructurePictureUpdateDTO> pictures = structureUpdateDTO.getPictures();
  206. ArrayList<Integer> newOldPictureIds = new ArrayList<>();
  207. for (StructurePictureUpdateDTO picture : pictures) {
  208. Integer newOldPictureId = picture.getId();
  209. newOldPictureIds.add(newOldPictureId);
  210. }
  211. //图片id集合去重,保留下来的即被删除的图片id
  212. oldPictureIds.removeAll(newOldPictureIds);
  213. if (oldPictureIds.size() > 0) {
  214. log.info("架构图片关联表删除数据");
  215. rows = assoStructurePictureMapper.deleteByIds(oldPictureIds);
  216. if (rows != oldPictureIds.size()) {
  217. String message = "修改架构失败,架构图片关联表删除数据失败,服务器忙请稍后再次尝试!";
  218. log.info("{}", message);
  219. throw new XiaoShiException(message);
  220. }
  221. }
  222. //数据入架构图片关联表(若有新增新图片)
  223. if (files != null && files.size() != 0) {
  224. ArrayList<AssoStructurePicture> assoStructurePictures = new ArrayList<>();
  225. for (MultipartFile file : files) {
  226. UploadFileDTO fileDTO = fileUtils.uploadFile(file);
  227. AssoStructurePicture assoStructurePicture = new AssoStructurePicture()
  228. .setStructureId(structureId)
  229. .setName(fileDTO.getName())
  230. .setSuffix(fileDTO.getExtName())
  231. .setUrl(fileDTO.getPath());
  232. assoStructurePictures.add(assoStructurePicture);
  233. }
  234. log.info("数据入架构图片关联表");
  235. rows = assoStructurePictureMapper.insertBatch(assoStructurePictures);
  236. if (rows != files.size()) {
  237. String message = "修改架构失败,数据入架构图片关联表失败,服务器忙请稍后再次尝试!";
  238. log.info("{}", message);
  239. throw new XiaoShiException(message);
  240. }
  241. }
  242. log.info("修改架构完成");
  243. }
  244. /**
  245. * 分页查询架构树
  246. *
  247. * @param structureQueryPageDTO 分页信息
  248. * @return 返回查询到的数据
  249. */
  250. @Override
  251. public StructureVO query(StructureQueryPageDTO structureQueryPageDTO) {
  252. log.info("开始处理【查询架构树】的业务,参数为:{}", structureQueryPageDTO);
  253. //从DTO中取出产品id、架构id
  254. Integer productId = structureQueryPageDTO.getProductId();
  255. Integer structureId = structureQueryPageDTO.getStructureId();
  256. String structureName = structureQueryPageDTO.getStructureName();
  257. //查询出当前架构信息
  258. StructureVO structureVO;
  259. if (structureId == 0) {
  260. structureVO = new StructureVO();
  261. } else {
  262. structureVO = structureMapper.getStandardAndPictureById(structureId);
  263. List<StructurePictureVO> pictures = assoStructurePictureMapper.selectByStructureId(structureId);
  264. structureVO.setPictures(pictures);
  265. }
  266. //以下代码表示查询所有架构的路径和路径拼接成的架构名称并封装成map集合,从map集合中取值为后面给每一个架构的pathName中文路径赋值
  267. HashMap<String, String> map = getStructureIdAndStructureNameMap(productId);
  268. //以下代码表示若架构名称structureName有值则要根据架构名称模糊查询树,若架构名称structureName为null则表示查询了所有架构(不受影响)
  269. LambdaQueryWrapper<Structure> wrapper = new LambdaQueryWrapper<>();
  270. wrapper.in(Structure::getProductId, productId);
  271. if (structureName != null) {
  272. wrapper.like(Structure::getStructureName, structureName);
  273. }
  274. List<Structure> structures = this.list(wrapper);
  275. List<Integer> ids = structures.stream().map(Structure::getId).collect(Collectors.toList());
  276. List<String> paths = structures.stream().map(Structure::getPath).collect(Collectors.toList());
  277. paths.forEach(
  278. item -> {
  279. String[] pathStrs = item.split(",");
  280. List<String> pathStr = new ArrayList<>(Arrays.asList(pathStrs));
  281. pathStr.forEach(
  282. tem -> {
  283. Integer paId = Integer.parseInt(tem);
  284. if (!ids.contains(paId)) {
  285. ids.add(paId);
  286. }
  287. }
  288. );
  289. }
  290. );
  291. //若ids.size == 0,则表示根据名称模糊查询不到数据,则直接返回空structureVO
  292. //if (structureVO != null) {
  293. diGui(structureVO, map, structureId, productId, ids);
  294. //}
  295. return structureVO;
  296. }
  297. /**
  298. * 查询所有架构的路径和路径拼接成的架构名称
  299. *
  300. * @param queryPathStructureNameDTO 数据DTO对象
  301. * @return 返回查询到的数据
  302. */
  303. @Override
  304. public List<PathStructureNameVO> queryPathStructureName(QueryPathStructureNameDTO queryPathStructureNameDTO) {
  305. log.info("开始处理【查询所有架构路径和路径架构名称】的业务,参数为:{}", queryPathStructureNameDTO);
  306. Integer productId = queryPathStructureNameDTO.getProductId();
  307. Integer structureId = queryPathStructureNameDTO.getStructureId();
  308. ArrayList<PathStructureNameVO> pathStructureNames = new ArrayList<>();
  309. log.info("根据产品id查询所有架构数据");
  310. HashMap<String, String> map = getStructureIdAndStructureNameMap(productId);
  311. List<StructureVO> structures;
  312. //若有架构id则只查该架构底下的树,若没有架构id则查整棵产品的架构树
  313. if (structureId == null) {
  314. structures = structureMapper.selectAllByProductId(productId);
  315. } else {
  316. structures = structureMapper.selectAllByStructureId(structureId);
  317. }
  318. for (StructureVO structure : structures) {
  319. Integer id = structure.getId();
  320. String path = structure.getPath();
  321. String[] pathSplit = path.split(",");
  322. //String pathStructureName = "";
  323. StringBuilder builder = new StringBuilder();
  324. for (int i = 1; i < pathSplit.length; i++) {
  325. String structureName = map.get(pathSplit[i]);
  326. builder.append(structureName).append("/");
  327. }
  328. PathStructureNameVO pathStructureNameVO = new PathStructureNameVO()
  329. .setId(id)
  330. .setPath(path)
  331. .setPathStructureName(builder + "");
  332. pathStructureNames.add(pathStructureNameVO);
  333. }
  334. return pathStructureNames;
  335. }
  336. /**
  337. * 删除架构
  338. *
  339. * @param id 架构id
  340. */
  341. @Override
  342. public void delete(Integer id) {
  343. log.info("开始处理【删除架构】的业务,参数为:{}", id);
  344. //检查尝试删除的数据是否存在
  345. Structure queryResult = structureMapper.getStandardById(id);
  346. if (queryResult == null) {
  347. ThrowException.throwXiaoShiException("删除架构失败,尝试访问的数据已不存在");
  348. }
  349. ArrayList<Integer> structureIds = new ArrayList<>();
  350. //根据架构id查询其包括其所有子级架构
  351. log.info("根据架构id查询其包括其所有子级架构");
  352. List<StructureVO> structures = structureMapper.selectByFindInSetPath(id + "");
  353. for (StructureVO structure : structures) {
  354. Integer structureId = structure.getId();
  355. structureIds.add(structureId);
  356. }
  357. //检查专题库表中是否有该架构数据,若有则不允许删除
  358. LambdaQueryWrapper<Project> wrapper = new LambdaQueryWrapper<>();
  359. wrapper.in(Project::getStructureId, structureIds);
  360. long count = projectService.count(wrapper);
  361. if (count > 0) {
  362. ThrowException.throwXiaoShiException("删除架构失败,该架构或其子级架构正在被专题库使用,无法删除");
  363. }
  364. //架构专利产品专题库标引表删除数据
  365. log.info("架构专利产品专题库标引表删除数据");
  366. assoStructurePatentMapper.deleteByStructureIds(structureIds);
  367. //检查产品架构专利号专题库表是否有该架构和其所有子级架构数据,若有则不允许删除
  368. // log.info("检查产品架构专利号专题库表是否有该架构和其所有子级架构数据,若有则不允许删除");
  369. // int count = assoStructurePatentMapper.countByStructureIds(structureIds);
  370. // if (count > 0) {
  371. // String message = "删除架构失败,该架构或其子级架构正在被专题库标引使用,请尝试先删除其关联数据";
  372. // log.info("{}", message);
  373. // throw new XiaoShiException(message);
  374. // }
  375. //架构和专利关联表删除数据
  376. //log.info("架构和专利关联表删除数据");
  377. //assoStructurePatentMapper.deleteByStructureIds(structureIds);
  378. //架构和图片关联表删除数据
  379. log.info("架构和图片关联表删除数据");
  380. assoStructurePictureMapper.deleteByStructureIds(structureIds);
  381. //架构表删除数据
  382. log.info("架构表删除数据");
  383. structureMapper.deleteByIds(structureIds);
  384. log.info("删除架构完成");
  385. }
  386. //递归组装架构树集合
  387. private void diGui(StructureVO structureVO, HashMap<String, String> map, Integer structureId, Integer productId, List<Integer> ids) {
  388. // List<StructureVO> structureVOs = structureMapper.selectByParentIdAndProductId(structureId, productId, ids);
  389. List<StructureVO> structureVOs = structureMapper.selectTree(structureId, productId, ids);
  390. if (structureVOs != null) {
  391. structureVO.setChildren(structureVOs);
  392. //给架构的路径名称pathName进行拼接赋值
  393. String path = structureVO.getPath();
  394. if (path != null && !path.equals("")) {
  395. String[] pathSplit = path.split(",");
  396. StringBuilder builder = new StringBuilder();
  397. for (int i = 1; i < pathSplit.length; i++) {
  398. String structureName = map.get(pathSplit[i]);
  399. builder.append(structureName).append("/");
  400. }
  401. structureVO.setPathName(builder + "");
  402. }
  403. for (StructureVO n : structureVOs) {
  404. structureId = n.getId();
  405. List<StructurePictureVO> pictures = assoStructurePictureMapper.selectByStructureId(structureId);
  406. n.setPictures(pictures);
  407. diGui(n, map, structureId, productId, ids);
  408. }
  409. }
  410. }
  411. private HashMap<String, String> getStructureIdAndStructureNameMap(Integer productId) {
  412. List<StructureVO> structures = structureMapper.selectAllByProductId(productId);
  413. //map存储所有架构id(key)和架构名称(value)的键值对
  414. HashMap<String, String> map = new HashMap<>();
  415. for (StructureVO structure : structures) {
  416. String structureStrId = structure.getId() + "";
  417. String structureName = structure.getStructureName();
  418. map.put(structureStrId, structureName);
  419. }
  420. return map;
  421. }
  422. }