From ad2ec97fe0c60eee4bb7c8cdacff7c876f280ea7 Mon Sep 17 00:00:00 2001
From: linwei <872216696@qq.com>
Date: Mon, 08 Jan 2024 11:30:18 +0800
Subject: [PATCH] 公安安全监管

---
 src/main/java/org/springblade/modules/house/service/impl/HouseholdServiceImpl.java |  229 +++++++++++++++++++++++++++++++++++++++++++++++---------
 1 files changed, 191 insertions(+), 38 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 1c02b88..91130ae 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,17 +19,25 @@
 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.node.TreeStringNode;
 import org.springblade.core.mp.support.Condition;
 import org.springblade.core.secure.utils.AuthUtil;
 import org.springblade.core.tool.utils.BeanUtil;
+import org.springblade.core.tool.utils.Func;
 import org.springblade.modules.grid.service.IGridService;
 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;
+import org.springblade.modules.house.service.IUserHouseLabelService;
+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;
@@ -42,6 +50,7 @@
 import org.springframework.util.StopWatch;
 
 import java.util.*;
+import java.util.stream.Collectors;
 
 /**
  * 住户 服务实现类
@@ -53,7 +62,7 @@
 public class HouseholdServiceImpl extends ServiceImpl<HouseholdMapper, HouseholdEntity> implements IHouseholdService {
 
 	@Autowired
-	private IGridService gridService;
+	private IUserHouseLabelService userHouseLabelService;
 
 	@Autowired
 	private IDictBizService dictBizService;
@@ -64,26 +73,18 @@
 	@Autowired
 	private IDeptService deptService;
 
+	@Autowired
+	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());
-		// 	}
-		// }
-		// 返回
 		stopWatch.stop();
 		System.out.println("selectHouseholdPage:" + stopWatch.getTotalTimeMillis());
 		return page.setRecords(householdVOS);
@@ -143,15 +144,8 @@
 	 * @return
 	 */
 	@Override
-	public boolean saveOrUpdateHousehold(HouseholdEntity household) {
-		// 判断添加人是否房屋业主
-//		Long count = count(Wrappers.<HouseholdEntity>lambdaQuery()
-//			.eq(HouseholdEntity::getHouseCode, household.getHouseCode())
-//			.eq(HouseholdEntity::getAssociatedUserId, AuthUtil.getUserId())
-//			.eq(HouseholdEntity::getRelationship, 1));
-//		if (count == 0) {
-//			return false;
-//		}
+	@Transactional(rollbackFor = Exception.class)
+	public boolean saveOrUpdateHousehold(HouseholdVO household) {
 		boolean flag = false;
 		household.setUpdateTime(new Date());
 		household.setUpdateUser(AuthUtil.getUserId());
@@ -160,6 +154,8 @@
 			flag = updateById(household);
 			// 更新用户信息
 			updateUserInfo(household);
+			// 更新标签信息
+			updateUserLabelInfo(household);
 		} else {
 			// 新增
 			household.setCreateTime(new Date());
@@ -167,8 +163,28 @@
 			flag = save(household);
 			// 更新用户信息
 			updateUserInfo(household);
+			// 更新标签信息
+			updateUserLabelInfo(household);
 		}
 		return flag;
+	}
+
+	/**
+	 * 更新用户标签信息
+	 * @param household
+	 */
+	public void updateUserLabelInfo(HouseholdVO household) {
+		if (household.getHouseholdLabelList().size()>0){
+			List<HouseholdLabelVO> householdLabelList = household.getHouseholdLabelList();
+			for (HouseholdLabelVO householdLabelVO : householdLabelList) {
+				if (!Strings.isBlank(household.getHouseCode())) {
+					householdLabelVO.setHouseCode(household.getHouseCode());
+				}
+				householdLabelVO.setHouseholdId(household.getId());
+				// 先删除对应绑定的信息
+				userHouseLabelService.saveOrUpdateHouseholdLabel(householdLabelVO);
+			}
+		}
 	}
 
 	/**
@@ -176,25 +192,11 @@
 	 * @param household
 	 */
 	public void updateUserInfo(HouseholdEntity household) {
-		// 判断用户是否为业主,如果是业主,判断该房屋是否已有业主,如果有则提示已有业主,无法设置为业主,不是业主则不操作
+		// 判断用户是否为业主,如果是业主,则新增
 		if (null!=household.getRelationship() && household.getRelationship()==1){
 			// 如果为业主
-			// 查询当前房屋是否已有业主
-			QueryWrapper<HouseholdEntity> queryWrapper = new QueryWrapper<>();
-			queryWrapper.eq("is_deleted",0)
-				.eq("house_code",household.getHouseCode())
-				.eq("relationship",1);
-			List<HouseholdEntity> list = list(queryWrapper);
-			if (list.size()==0){
-				// 新增用户
-				bindUserHandle(household);
-			}else {
-				HouseholdEntity householdEntity = list.get(0);
-				if (null == householdEntity.getAssociatedUserId()){
-					// 新增用户
-					bindUserHandle(household);
-				}
-			}
+			// 新增用户
+			bindUserHandle(household);
 		}
 	}
 
@@ -209,6 +211,12 @@
 			User userParams = new User();
 			userParams.setPhone(householdEntity.getPhoneNumber());
 			User user = userService.getOne(Condition.getQueryWrapper(userParams));
+			if (null==user) {
+				User userParams1 = new User();
+				userParams1.setAccount(householdEntity.getPhoneNumber());
+				userParams1.setIsDeleted(0);
+				user = userService.getOne(Condition.getQueryWrapper(userParams1));
+			}
 			if (null!=user) {
 				//如果用户存在,则该用户id绑定场所
 				householdEntity.setAssociatedUserId(user.getId());
@@ -320,4 +328,149 @@
 		}
 
 	}
+
+	/**
+	 * 住户业主信息处理,将业主人员插入到用户表
+	 * @return
+	 */
+	@Override
+	public Object userHandle() {
+		// 查询所有未入库的业主信息
+		List<HouseholdEntity> householdEntityList = baseMapper.getNotInsertUserHousehold();
+		// 批量入用户库
+		for (HouseholdEntity householdEntity : householdEntityList) {
+			// 根据手机号查询对应账号和手机号的用户信息
+			List<User> userList = userService.getUserListByPhoneOrAccount(householdEntity.getPhoneNumber());
+			if (userList.size()>0){
+				User user = userList.get(0);
+				householdEntity.setAssociatedUserId(user.getId());
+				// 更新
+				updateById(householdEntity);
+				// 判断用户是否包含了居民角色,不包含则需更新
+				if (!user.getRoleId().contains("1717429059648606209")){
+					user.setRoleId(user.getRoleId() + ",1717429059648606209");
+					//更新
+					userService.updateById(user);
+				}
+			}else {
+				// 插入用户信息
+				//如果用户不存在,则新增一个用户
+				User newUser = new User();
+				newUser.setAccount(householdEntity.getPhoneNumber());
+				newUser.setPhone(householdEntity.getPhoneNumber());
+				newUser.setName(householdEntity.getName());
+				newUser.setRealName(householdEntity.getName());
+				// 社区群众部门
+				newUser.setDeptId("1727979636479037441");
+				// 目前暂定居民角色,
+				newUser.setRoleId("1717429059648606209");
+				//默认密码为 123456
+				newUser.setPassword("123456");
+				// 用户新增
+				boolean submit = userService.submit(newUser);
+				// 更新绑定用户信息
+				householdEntity.setAssociatedUserId(newUser.getId());
+				// 更新
+				updateById(householdEntity);
+			}
+		}
+		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());
+				// 判断角色
+				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 (stringList.size()>1){
+						// 查询是否对应有场所负责人,如果有则不删除,如果没有则删除对应的角色
+						List<String> arrayList = new ArrayList<>();
+						if (placeEntityList.size()==0){
+							for (String roleId : stringList) {
+								if (!roleId.equals("1717429059648606209")){
+									arrayList.add(roleId);
+								}
+							}
+						}
+						user.setRoleId(StringUtils.join(arrayList, ","));
+						// 更新用户
+						userService.updateById(user);
+					}else {
+						// 查询是否对应有场所负责人,如果有则不删除,如果没有则删除对应的用户
+						if (placeEntityList.size()==0){
+							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;
+	}
 }

--
Gitblit v1.9.3