From 30f7705239334a3df2c7a296fb11abd1b28355cb Mon Sep 17 00:00:00 2001
From: zhongrj <646384940@qq.com>
Date: Fri, 02 Feb 2024 22:46:01 +0800
Subject: [PATCH] 机构新增字段,警务网格字段调整

---
 src/main/java/org/springblade/modules/system/service/impl/DeptServiceImpl.java |   37 +++++++++++++++++++++++++++++++++++++
 1 files changed, 37 insertions(+), 0 deletions(-)

diff --git a/src/main/java/org/springblade/modules/system/service/impl/DeptServiceImpl.java b/src/main/java/org/springblade/modules/system/service/impl/DeptServiceImpl.java
index 90bdf3c..9e51e45 100644
--- a/src/main/java/org/springblade/modules/system/service/impl/DeptServiceImpl.java
+++ b/src/main/java/org/springblade/modules/system/service/impl/DeptServiceImpl.java
@@ -36,6 +36,8 @@
 import org.springblade.modules.community.service.ICommunityService;
 import org.springblade.modules.grid.entity.GridEntity;
 import org.springblade.modules.grid.service.IGridService;
+import org.springblade.modules.police.entity.PoliceAffairsGridEntity;
+import org.springblade.modules.police.service.IPoliceAffairsGridService;
 import org.springblade.modules.property.entity.PropertyCompanyEntity;
 import org.springblade.modules.property.service.IPropertyCompanyService;
 import org.springblade.modules.system.entity.Dept;
@@ -413,4 +415,39 @@
 		// 处理并返回
 		return deptAndUserNodeTree;
 	}
+
+	/**
+	 * 数据处理(社区绑定)-- 处理社区(派出所下)
+	 */
+	@Override
+	@Transactional(rollbackFor = Exception.class)
+	public Object dataHandleCommunityByPolice() {
+		// 查询所有的派出所
+		QueryWrapper<Dept> wrapper = new QueryWrapper<>();
+		wrapper.eq("is_deleted",0).like("dept_name","派出所");
+		List<Dept> list = list(wrapper);
+		// 遍历
+		for (Dept dept : list) {
+			// 通过派出所名称查询对应的警务网格信息
+			QueryWrapper<PoliceAffairsGridEntity> queryWrapper = new QueryWrapper<>();
+			queryWrapper.eq("is_deleted",0).eq("pcs_name",dept.getDeptName());
+			List<PoliceAffairsGridEntity> policeAffairsGridEntityList
+				= SpringUtil.getBean(IPoliceAffairsGridService.class).list(queryWrapper);
+			// 遍历
+			for (PoliceAffairsGridEntity policeAffairsGridEntity : policeAffairsGridEntityList) {
+				Dept deptInfo = new Dept();
+				deptInfo.setTenantId("000000");
+				deptInfo.setDeptName(policeAffairsGridEntity.getCommunityName());
+				deptInfo.setFullName(policeAffairsGridEntity.getCommunityName());
+				deptInfo.setDeptCategory(1);
+				deptInfo.setDeptNature(1);
+				deptInfo.setParentId(dept.getId());
+				deptInfo.setAncestors(dept.getAncestors() + "," + dept.getId());
+				deptInfo.setRegionCode(policeAffairsGridEntity.getJwGridCode());
+				// 保存
+				save(deptInfo);
+			}
+		}
+		return null;
+	}
 }

--
Gitblit v1.9.3