From b3b566ebdfed4005aaa513da3d5d2fd3924903cc Mon Sep 17 00:00:00 2001
From: linwei <872216696@qq.com>
Date: Wed, 31 Jan 2024 16:17:54 +0800
Subject: [PATCH] 拿不到地址总表数据,不设置网格信息

---
 src/main/java/org/springblade/modules/house/service/impl/HouseholdServiceImpl.java |  178 +++++++++++++++++++++++++++++++++++++++++++++++++++++------
 1 files changed, 160 insertions(+), 18 deletions(-)

diff --git a/src/main/java/org/springblade/modules/house/service/impl/HouseholdServiceImpl.java b/src/main/java/org/springblade/modules/house/service/impl/HouseholdServiceImpl.java
index c4de6e3..90d0d88 100644
--- a/src/main/java/org/springblade/modules/house/service/impl/HouseholdServiceImpl.java
+++ b/src/main/java/org/springblade/modules/house/service/impl/HouseholdServiceImpl.java
@@ -19,13 +19,18 @@
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import liquibase.repackaged.org.apache.commons.lang3.StringUtils;
 import org.apache.logging.log4j.util.Strings;
+import org.springblade.common.cache.SysCache;
+import org.springblade.common.node.TreeIntegerNode;
 import org.springblade.common.node.TreeStringNode;
+import org.springblade.common.utils.NodeTreeUtil;
 import org.springblade.core.mp.support.Condition;
 import org.springblade.core.secure.utils.AuthUtil;
 import org.springblade.core.tool.utils.BeanUtil;
-import org.springblade.modules.grid.service.IGridService;
+import org.springblade.core.tool.utils.Func;
 import org.springblade.modules.house.entity.HouseholdEntity;
+import org.springblade.modules.house.entity.UserHouseLabelEntity;
 import org.springblade.modules.house.excel.HouseHoldExcel;
 import org.springblade.modules.house.mapper.HouseholdMapper;
 import org.springblade.modules.house.service.IHouseholdService;
@@ -33,6 +38,8 @@
 import org.springblade.modules.house.vo.HouseholdLabelVO;
 import org.springblade.modules.house.vo.HouseholdOtherVO;
 import org.springblade.modules.house.vo.HouseholdVO;
+import org.springblade.modules.place.entity.PlaceEntity;
+import org.springblade.modules.place.service.IPlaceService;
 import org.springblade.modules.system.entity.Dept;
 import org.springblade.modules.system.entity.DictBiz;
 import org.springblade.modules.system.entity.User;
@@ -45,6 +52,7 @@
 import org.springframework.util.StopWatch;
 
 import java.util.*;
+import java.util.stream.Collectors;
 
 /**
  * 住户 服务实现类
@@ -65,28 +73,15 @@
 	private IUserService userService;
 
 	@Autowired
-	private IDeptService deptService;
+	private IPlaceService placeService;
 
 	@Override
 	public IPage<HouseholdVO> selectHouseholdPage(IPage<HouseholdVO> page, HouseholdVO household) {
 		StopWatch stopWatch = new StopWatch();
 		stopWatch.start();
-// doInsert();
-// 执行业务等
-		Dept dept = deptService.getById(AuthUtil.getDeptId());
-		if (null!=dept){
-			household.setRegionCode(dept.getRegionCode());
-		}
-		List<HouseholdVO> householdVOS = baseMapper.selectHouseholdPage(page, household);
-		// 遍历
-		// for (HouseholdVO householdVO : householdVOS) {
-		// 	// 设置对应的网格名称
-		// 	GridVO gridVO = gridService.getGridDetailByHouseCode(householdVO.getHouseCode());
-		// 	if (null!= gridVO){
-		// 		householdVO.setGridName(gridVO.getGridName());
-		// 	}
-		// }
-		// 返回
+		List<String> regionChildCodesList = SysCache.getRegionChildCodesByDeptId(AuthUtil.getDeptId());
+		Integer isAdministrator = AuthUtil.isAdministrator()==true?1:2;
+		List<HouseholdVO> householdVOS = baseMapper.selectHouseholdPage(page, household,regionChildCodesList,isAdministrator);
 		stopWatch.stop();
 		System.out.println("selectHouseholdPage:" + stopWatch.getTotalTimeMillis());
 		return page.setRecords(householdVOS);
@@ -151,6 +146,10 @@
 		boolean flag = false;
 		household.setUpdateTime(new Date());
 		household.setUpdateUser(AuthUtil.getUserId());
+		if (!Strings.isBlank(household.getRoleName()) && household.getRoleName().equals("居民")){
+			// 待审核
+			household.setConfirmFlag(0);
+		}
 		if (null != household.getId()) {
 			// 更新
 			flag = updateById(household);
@@ -378,4 +377,147 @@
 		}
 		return null;
 	}
+
+	/**
+	 * 住户 删除
+	 */
+	@Override
+	@Transactional(rollbackFor = Exception.class)
+	public boolean removeHousehold(String ids) {
+		List<Long> idList = Func.toLongList(ids);
+		// 同时删除当前住户对应的标签
+		removeHouseholdLabel(idList);
+		// 同时删除对应的用户信息
+		removeHouseholdUser(idList);
+		// 删除住户信息
+		boolean removeByIds = removeByIds(idList);
+		// 返回
+		return removeByIds;
+	}
+
+
+	/**
+	 * 同时删除对应的用户信息
+	 * @param idList
+	 */
+	public void removeHouseholdUser(List<Long> idList) {
+		for (Long id : idList) {
+			HouseholdEntity householdEntity = getById(id);
+			// 如果是业主
+			if (householdEntity.getRelationship()==1){
+				// 查询对应的用户
+				User user = userService.getById(householdEntity.getAssociatedUserId());
+				// 判断是否还绑定其他的房屋,如果有,则不操作用户
+				QueryWrapper<HouseholdEntity> wrapper = new QueryWrapper<>();
+				wrapper.eq("is_deleted",0).eq("associated_user_id",user.getId());
+				List<HouseholdEntity> householdEntityList = list(wrapper);
+				if (householdEntityList.size()==1){
+					// 判断角色
+					if (!Strings.isBlank(user.getRoleId())){
+						List<String> stringList = Arrays.asList(user.getRoleId().split(","));
+						// 查询场所
+						QueryWrapper<PlaceEntity> queryWrapper = new QueryWrapper<>();
+						queryWrapper.eq("is_deleted",0).eq("principal_user_id",user.getId());
+						List<PlaceEntity> placeEntityList = placeService.list(queryWrapper);
+						// 即没有房屋和场所了就删除对应的居民角色
+						if (placeEntityList.size()==0) {
+							// 查看当前用户的角色是否只有一个
+							if (stringList.size() > 1) {
+								// 查询是否对应有场所负责人,如果有则不删除,如果没有则删除对应的角色
+								List<String> arrayList = new ArrayList<>();
+								for (String roleId : stringList) {
+									if (!roleId.equals("1717429059648606209")) {
+										arrayList.add(roleId);
+									}
+								}
+								user.setRoleId(StringUtils.join(arrayList, ","));
+								// 更新用户
+								userService.updateById(user);
+							} else {
+								// 删除当前用户
+								userService.removeById(user.getId());
+							}
+						}
+					}
+				}
+			}
+		}
+	}
+
+	/**
+	 * 删除住户标签信息
+	 * @param idList
+	 */
+	public void removeHouseholdLabel(List<Long> idList) {
+		for (Long id : idList) {
+			QueryWrapper<UserHouseLabelEntity> wrapper = new QueryWrapper<>();
+			wrapper.eq("household_id",id);
+			userHouseLabelService.remove(wrapper);
+		}
+	}
+
+	@Override
+	public List<HouseholdVO> getAllHouseHold(HouseholdVO household) {
+		return  baseMapper.getAllHouseHold(household);
+	}
+
+	/**
+	 * 住户列表查询
+	 * @param household
+	 * @return
+	 */
+	@Override
+	public List<HouseholdVO> selectHouseholdList(HouseholdVO household) {
+		List<HouseholdVO> householdVOS = baseMapper.selectHouseholdList(household);
+		// 遍历
+		for (HouseholdVO householdVO : householdVOS) {
+			if (householdVO.getHouseholdLabelList().size() > 0) {
+				List<String> labelNameList = householdVO.getHouseholdLabelList().stream().map(householdLabelVO -> householdLabelVO.getLabelName())
+					.collect(Collectors.toList());
+				householdVO.setLabelName(String.join(",", labelNameList));
+			}
+		}
+		// 返回
+		return householdVOS;
+	}
+
+	@Override
+	public IPage<HouseholdVO> getKeynotePersonnelPage(IPage<HouseholdVO> page, HouseholdVO household) {
+		// StopWatch stopWatch = new StopWatch();
+		// stopWatch.start();
+		// Dept dept = deptService.getById(AuthUtil.getDeptId());
+		// if (null!=dept){
+		// 	household.setRegionCode(dept.getRegionCode());
+		// }
+		List<HouseholdVO> householdVOS = baseMapper.getKeynotePersonnelPage(page, household);
+		// stopWatch.stop();
+		// System.out.println("selectHouseholdPage:" + stopWatch.getTotalTimeMillis());
+		return page.setRecords(householdVOS);
+	}
+
+	/**
+	 * 根据人员标签编号集合查询对应的住户(按颜色区分近多少天没有发过任务的住户)
+	 * @param list
+	 * @return
+	 */
+	@Override
+	public List<HouseholdVO> getHouseholdListByParam(List<Integer> list) {
+		return baseMapper.getHouseholdListByParam(list);
+	}
+
+	@Override
+	public List<TreeIntegerNode> getlabelStatistics(HouseholdVO household) {
+		Map<Integer, TreeIntegerNode> labelTreeList = baseMapper.getlabelStatistics(household);
+		List<TreeIntegerNode> nodeTree = NodeTreeUtil.getNodeTree(labelTreeList);
+		nodeTree.forEach(node -> recursion(node));
+		return nodeTree;
+	}
+
+	private void recursion(TreeIntegerNode node) {
+		if (node.getChildren() != null && node.getChildren().size() > 0) {
+			node.getChildren().forEach(node2 -> recursion(node2));
+		} else {
+			node.setChildren(null);
+		}
+	}
 }

--
Gitblit v1.9.3