From 8ac34cbae4ea8cc47194f51389a4e2dddebcc7d5 Mon Sep 17 00:00:00 2001
From: linwei <872216696@qq.com>
Date: Thu, 02 Apr 2026 13:55:20 +0800
Subject: [PATCH] opt: sql改造其他模块改造7

---
 drone-service/drone-system/src/main/java/org/sxkj/system/service/impl/DeptServiceImpl.java |   49 +++++++++++++++++++++++++++++++++++++++++--------
 1 files changed, 41 insertions(+), 8 deletions(-)

diff --git a/drone-service/drone-system/src/main/java/org/sxkj/system/service/impl/DeptServiceImpl.java b/drone-service/drone-system/src/main/java/org/sxkj/system/service/impl/DeptServiceImpl.java
index d14059a..ebe8893 100644
--- a/drone-service/drone-system/src/main/java/org/sxkj/system/service/impl/DeptServiceImpl.java
+++ b/drone-service/drone-system/src/main/java/org/sxkj/system/service/impl/DeptServiceImpl.java
@@ -32,12 +32,15 @@
 import org.springblade.core.tool.utils.Func;
 import org.springblade.core.tool.utils.StringPool;
 import org.springframework.stereotype.Service;
+import org.sxkj.common.constant.WordOrderConstant;
 import org.sxkj.common.func.Streams;
 import org.sxkj.common.node.TreeStringNode;
 import org.sxkj.common.utils.NodeTreeUtil;
+import org.sxkj.common.utils.OrderNumUtils;
 import org.sxkj.system.cache.SysCache;
 import org.sxkj.system.entity.Dept;
 import org.sxkj.system.excel.DeptExcel;
+import org.sxkj.system.excel.DeptImportExcel;
 import org.sxkj.system.mapper.DeptMapper;
 import org.sxkj.system.param.DeptExportParam;
 import org.sxkj.system.param.DeptPageParam;
@@ -45,10 +48,7 @@
 import org.sxkj.system.vo.DeptVO;
 import org.sxkj.system.wrapper.DeptWrapper;
 
-import java.util.ArrayList;
-import java.util.Collections;
-import java.util.List;
-import java.util.Map;
+import java.util.*;
 import java.util.stream.Collectors;
 
 /**
@@ -93,8 +93,8 @@
 
 
 	@Override
-	public List<DeptVO> tree(String tenantId) {
-		return ForestNodeMerger.merge(baseMapper.tree(tenantId));
+	public List<DeptVO> tree(String tenantId, String sysType) {
+		return ForestNodeMerger.merge(baseMapper.tree(tenantId, sysType));
 	}
 
 	@Override
@@ -301,6 +301,7 @@
 
 	/**
 	 * 分页查询
+	 *
 	 * @param page
 	 * @param deptPageParam
 	 * @return
@@ -312,25 +313,57 @@
 
 	/**
 	 * 导入部门
+	 *
 	 * @param data
 	 * @param isCovered
 	 */
 	@Override
-	public void importDept(List<DeptExcel> data, Boolean isCovered) {
+	public void importDept(List<DeptImportExcel> data, Boolean isCovered) {
 		List<Dept> list = new ArrayList<>();
 		data.forEach(deptExcel -> {
+			// 校验必填字段
+			if (deptExcel.getDeptName() == null || deptExcel.getDeptName().trim().isEmpty()) {
+				throw new RuntimeException("机构名称不能为空");
+			}
+			if (deptExcel.getAreaCode() == null || deptExcel.getAreaCode().trim().isEmpty()) {
+				throw new RuntimeException("所属区划编码不能为空");
+			}
+			if (deptExcel.getRemark() == null || deptExcel.getRemark().trim().isEmpty()) {
+				throw new RuntimeException("机构描述不能为空");
+			}
+			if (deptExcel.getStatus() == null || deptExcel.getStatus().trim().isEmpty()) {
+				throw new RuntimeException("机构状态不能为空");
+			}
+			// 转换数据
 			Dept dept = BeanUtil.copy(deptExcel, Dept.class);
+			dept.setStatus(1);
+			dept.setIsDeleted(0);
+			dept.setCreateTime(new Date());
+			dept.setUpdateTime(new Date());
+			dept.setDeptNature(2);
+			dept.setDeptCategory(2);
+			dept.setSysType(String.valueOf(6));
 			list.add(dept);
 		});
 		if (isCovered) {
 			this.saveOrUpdateBatch(list);
 		} else {
+			list.forEach(item -> {
+				String times = OrderNumUtils.initOrderNum2(WordOrderConstant.ORG_CODE);
+				String deptCode = WordOrderConstant.ORG_PREFIX + times;
+				item.setDeptCode(deptCode);
+			});
 			this.saveBatch(list);
 		}
 	}
 
 	@Override
 	public List<DeptExcel> exportDept(DeptExportParam dept) {
-		  return baseMapper.exportDept(dept);
+		return baseMapper.exportDept(dept);
+	}
+
+	@Override
+	public DeptVO getDetailWithAreaName(Dept dept) {
+		return baseMapper.getDetailWithAreaName(dept);
 	}
 }

--
Gitblit v1.9.3