From bc7e7bcb9bdd1246e08e6d3318cf543e63a848ad Mon Sep 17 00:00:00 2001
From: linwe <872216996@qq.com>
Date: Fri, 17 Nov 2023 17:38:40 +0800
Subject: [PATCH] 统计代码
---
src/main/java/org/springblade/modules/doorplateAddress/service/impl/DoorplateAddressServiceImpl.java | 114 +++++++++++++++++++++++++++++++++++++++++++++++----------
1 files changed, 94 insertions(+), 20 deletions(-)
diff --git a/src/main/java/org/springblade/modules/doorplateAddress/service/impl/DoorplateAddressServiceImpl.java b/src/main/java/org/springblade/modules/doorplateAddress/service/impl/DoorplateAddressServiceImpl.java
index 7bcf2dd..32e3943 100644
--- a/src/main/java/org/springblade/modules/doorplateAddress/service/impl/DoorplateAddressServiceImpl.java
+++ b/src/main/java/org/springblade/modules/doorplateAddress/service/impl/DoorplateAddressServiceImpl.java
@@ -16,12 +16,14 @@
*/
package org.springblade.modules.doorplateAddress.service.impl;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import liquibase.repackaged.org.apache.commons.lang3.StringUtils;
import org.springblade.common.constant.DictConstant;
import org.springblade.common.node.TreeNode;
+import org.springblade.common.utils.NodeTreeUtil;
import org.springblade.core.secure.utils.AuthUtil;
import org.springblade.modules.doorplateAddress.entity.DoorplateAddressEntity;
import org.springblade.modules.doorplateAddress.mapper.DoorplateAddressMapper;
@@ -30,7 +32,9 @@
import org.springblade.modules.doorplateAddress.vo.DoorplateAddressVOTree;
import org.springblade.modules.doorplateAddress.vo.FuncNode;
import org.springblade.modules.grid.service.IGridService;
+import org.springblade.modules.house.entity.HouseEntity;
import org.springblade.modules.house.service.IHouseRentalService;
+import org.springblade.modules.house.service.IHouseService;
import org.springblade.modules.house.service.IHouseholdService;
import org.springblade.modules.house.vo.HouseParam;
import org.springblade.modules.house.vo.HouseRentalVO;
@@ -53,6 +57,9 @@
@Autowired
private IPlaceService placeService;
+
+ @Autowired
+ private IHouseService houseService;
@Autowired
private IHouseholdService householdService;
@@ -183,13 +190,7 @@
public Object getHousesList(HouseParam houseParam) {
List<TreeNode> list = new ArrayList<>();
Map<String, Object> map = new HashMap<>(2);
- List<String> stringList = new ArrayList<>();
- if (null!=houseParam.getRoleName() && !houseParam.getRoleName().equals("")){
- if (houseParam.getRoleName().equals("网格员")){
- // 查询对应的房屋地址code
- stringList = gridService.getAddressCodeListByUserId(AuthUtil.getUserId());
- }
- }
+ List<String> stringList = getHouseCodeList(houseParam);
// 查小区，场所
if (houseParam.getType()==1){
// 根据社区名称查询小区集合
@@ -213,12 +214,13 @@
* @return
*/
private Map<String, Object> getHouseLevelData(HouseParam houseParam, Map<String, Object> map) {
+ List<String> stringList = getHouseCodeList(houseParam);
// 判断地址类型
if (houseParam.getAddressType()==1) {
List<FuncNode> aoiList = new ArrayList<>();
List<FuncNode> shopList = new ArrayList<>();
// 查询户室及住户相关信息，单元中包含住户,或者和单元平级的 商铺
- List<FuncNode> householdList = getUnitHouseholdList(houseParam.getName(), houseParam.getCode());
+ List<FuncNode> householdList = getUnitHouseholdList(houseParam,stringList);
// 遍历
if (householdList.size()>0){
for (FuncNode funcNode : householdList) {
@@ -236,7 +238,7 @@
return map;
}else{
// 根据街路巷编号查询街路巷门牌名称集合
- List<FuncNode> doorplateNameList = baseMapper.getDoorplateNameList(houseParam.getName(), houseParam.getCode());
+ List<FuncNode> doorplateNameList = baseMapper.getDoorplateNameList(houseParam,stringList);
map.put("aoiList",new ArrayList<>());
map.put("shopList",doorplateNameList);
// 返回
@@ -251,13 +253,7 @@
* @return
*/
private Object getBuildLevelData(HouseParam houseParam,Map<String, Object> map) {
- List<String> stringList = new ArrayList<>();
- if (null!=houseParam.getRoleName() && !houseParam.getRoleName().equals("")){
- if (houseParam.getRoleName().equals("网格员")){
- // 查询对应的房屋地址code
- stringList = gridService.getAddressCodeListByUserId(AuthUtil.getUserId());
- }
- }
+ List<String> stringList = getHouseCodeList(houseParam);
// 判断 code 长度，如果 code 长度大于 12 则为小区查楼栋/商铺，否则则按社区查街路巷
if (houseParam.getCode().length()>12){
List<TreeNode> aoiList = new ArrayList<>();
@@ -293,14 +289,14 @@
/**
* 查询户室及住户相关信息，单元中包含住户
- * @param name
- * @param code
+ * @param houseParam
+ * @param stringList
* @return
*/
- private List<FuncNode> getUnitHouseholdList(String name, String code) {
+ private List<FuncNode> getUnitHouseholdList(HouseParam houseParam,List<String> stringList) {
List<FuncNode> list = new ArrayList<>();
// 查询户室及住户相关信息，单元中包含住户
- List<FuncNode> funcNodes = baseMapper.getUnitHouseholdList(name,code);
+ List<FuncNode> funcNodes = baseMapper.getUnitHouseholdList(houseParam,stringList);
// 遍历
List<FuncNode> aoiNodes = new ArrayList<>();
List<FuncNode> shopNodes = new ArrayList<>();
@@ -472,4 +468,82 @@
public List<DoorplateAddressEntity> getAllDoorplateAddress(String name) {
return baseMapper.getAllDoorplateAddress(name);
}
+
+ /**
+ * 获取房屋树
+ * @param houseParam
+ * @return
+ */
+ @Override
+ public List<DoorplateAddressVOTree> getHouseTree(HouseParam houseParam) {
+ List<String> stringList = getHouseCodeList(houseParam);
+ // 根据社区居委会编号获取对应的小区/楼栋/单元/户室
+ return NodeTreeUtil.getAddressNodeTree(baseMapper.getHouseTree(houseParam,stringList));
+ }
+
+ /**
+ * 根据角色获取地址编号集合
+ * @param houseParam
+ * @return
+ */
+ private List<String> getHouseCodeList(HouseParam houseParam) {
+ List<String> stringList = new ArrayList<>();
+ if (null != houseParam.getRoleName() && !houseParam.getRoleName().equals("")) {
+ if (houseParam.getRoleName().equals("网格员")) {
+ // 查询对应的房屋地址code
+ stringList = gridService.getAddressCodeListByUserId(AuthUtil.getUserId());
+ }
+ }
+ return stringList;
+ }
+
+ /**
+ * 数据处理
+ * @return
+ */
+ @Override
+ public Object dataHandle() {
+ // 处理户室数据
+ handleHouseData();
+
+ return null;
+ }
+
+ /**
+ * 处理房屋数据
+ */
+ private void handleHouseData() {
+ // 查询所有户室数据
+ List<DoorplateAddressEntity> list = baseMapper.getHouseList();
+ // 需要新增的房屋 list
+ List<HouseEntity> houseList = new ArrayList<>();
+ // 处理户室数据
+ for (DoorplateAddressEntity doorplateAddressEntity : list) {
+ // 查询是否已存在，存在就插入，不存在则插入
+ QueryWrapper<HouseEntity> wrapper = new QueryWrapper<>();
+ wrapper.eq("house_code",doorplateAddressEntity.getAddressCode())
+ .eq("is_deleted",0);
+ HouseEntity one = houseService.getOne(wrapper);
+ if (null==one){
+ HouseEntity houseEntity = new HouseEntity();
+ houseEntity.setHouseCode(doorplateAddressEntity.getAddressCode());
+ houseEntity.setDistrictCode(doorplateAddressEntity.getAoiCode());
+ houseEntity.setDistrictName(doorplateAddressEntity.getAoiName());
+ houseEntity.setHouseName(doorplateAddressEntity.getAddressName());
+ houseEntity.setFloor(Integer.parseInt(doorplateAddressEntity.getFloor()));
+ houseEntity.setBuilding(doorplateAddressEntity.getBuildingName());
+ houseEntity.setUnit(doorplateAddressEntity.getUnitName());
+ houseEntity.setRoom(doorplateAddressEntity.getHouseName());
+ houseEntity.setBuildingNo(doorplateAddressEntity.getBuildingCode());
+ houseEntity.setCreateUser(AuthUtil.getUserId().toString());
+ houseEntity.setCreateTime(new Date());
+ houseEntity.setUpdateUser(AuthUtil.getUserId().toString());
+ houseEntity.setUpdateTime(new Date());
+ // 加入集合
+ houseList.add(houseEntity);
+ }
+ }
+ // 批量插入
+ houseService.saveBatch(houseList);
+ }
}
--
Gitblit v1.9.3