From 8d8c7da4e91028fc877f101dcd244bef3e18c197 Mon Sep 17 00:00:00 2001
From: linwe <872216996@qq.com>
Date: Sun, 12 Nov 2023 07:34:21 +0800
Subject: [PATCH] 标签报事+通知公告

---
 src/main/java/org/springblade/modules/place/service/impl/PlaceServiceImpl.java |  223 +++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 221 insertions(+), 2 deletions(-)

diff --git a/src/main/java/org/springblade/modules/place/service/impl/PlaceServiceImpl.java b/src/main/java/org/springblade/modules/place/service/impl/PlaceServiceImpl.java
index 7cf684a..ea3f411 100644
--- a/src/main/java/org/springblade/modules/place/service/impl/PlaceServiceImpl.java
+++ b/src/main/java/org/springblade/modules/place/service/impl/PlaceServiceImpl.java
@@ -16,16 +16,33 @@
  */
 package org.springblade.modules.place.service.impl;
 
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import lombok.AllArgsConstructor;
 import org.springblade.common.node.TreeNode;
+import org.springblade.core.mp.support.Condition;
+import org.springblade.core.secure.utils.AuthUtil;
+import org.springblade.modules.doorplateAddress.entity.DoorplateAddressEntity;
+import org.springblade.modules.doorplateAddress.service.IDoorplateAddressService;
+import org.springblade.modules.grid.service.IGridService;
 import org.springblade.modules.place.entity.PlaceEntity;
+import org.springblade.modules.place.entity.PlaceExtEntity;
+import org.springblade.modules.place.entity.PlacePoiLabel;
+import org.springblade.modules.place.service.IPlaceExtService;
+import org.springblade.modules.place.service.IPlacePoiLabelService;
 import org.springblade.modules.place.vo.PlaceVO;
 import org.springblade.modules.place.mapper.PlaceMapper;
 import org.springblade.modules.place.service.IPlaceService;
-import org.springblade.core.mp.base.BaseServiceImpl;
+import org.springblade.modules.system.entity.User;
+import org.springblade.modules.system.service.IUserService;
+import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
 import com.baomidou.mybatisplus.core.metadata.IPage;
+import org.springframework.transaction.annotation.Transactional;
 
+import java.util.ArrayList;
+import java.util.Arrays;
+import java.util.Date;
 import java.util.List;
 
 /**
@@ -36,10 +53,38 @@
  */
 @Service
 public class PlaceServiceImpl extends ServiceImpl<PlaceMapper, PlaceEntity> implements IPlaceService {
+	@Autowired
+	private IUserService userService;
 
+	@Autowired
+	private IPlacePoiLabelService placePoiLabelService;
+
+	@Autowired
+	private IPlaceExtService placeExtService;
+
+	@Autowired
+	private IDoorplateAddressService doorplateAddressService;
+
+	@Autowired
+	private IGridService gridService;
+
+	/**
+	 * 自定义列表查询
+	 * @param page
+	 * @param place
+	 * @return
+	 */
 	@Override
 	public IPage<PlaceVO> selectPlacePage(IPage<PlaceVO> page, PlaceVO place) {
-		return page.setRecords(baseMapper.selectPlacePage(page, place));
+		List<String> list = new ArrayList<>();
+		if (null!=place.getRoleName() && !place.getRoleName().equals("")){
+			if (place.getRoleName().equals("网格员")){
+				// 查询对应的房屋地址code
+				list = gridService.getAddressCodeListByUserId(AuthUtil.getUserId());
+			}
+		}
+		place.setCreateUser(AuthUtil.getUserId());
+		return page.setRecords(baseMapper.selectPlacePage(page, place,list));
 	}
 
 	/**
@@ -51,4 +96,178 @@
 	public List<TreeNode> selectPlaceNodeList(Long userId) {
 		return baseMapper.selectPlaceNodeList(userId.toString());
 	}
+
+	/**
+	 * 场所信息自定义新增
+	 * @param placeVO
+	 * @return
+	 */
+	@Override
+	@Transactional(rollbackFor = Exception.class)
+	public Boolean addVO(PlaceVO placeVO) {
+		// 设置基础数据
+		placeVO.setCreateUser(AuthUtil.getUserId());
+		placeVO.setCreateTime(new Date());
+		placeVO.setUpdateUser(AuthUtil.getUserId());
+		placeVO.setUpdateTime(new Date());
+		// 绑定用户信息
+		bindUserHandle(placeVO);
+		// 新增场所信息
+		boolean save = save(placeVO);
+		// 保存场所详情及任务信息
+		savePlaceExtAndTaskInfo(placeVO);
+		// 场所标签信息绑定
+		placeLabelBind(placeVO);
+		// 返回结果
+		return save;
+	}
+
+	/**
+	 * 场所标签信息绑定入库
+	 * @param placeVO
+	 */
+	@Transactional(rollbackFor = Exception.class)
+	public void placeLabelBind(PlaceVO placeVO) {
+		List<String> labelList = Arrays.asList(placeVO.getLabel().split(","));
+		// 遍历
+		labelList.forEach(labelId->{
+			PlacePoiLabel placePoiLabel = new PlacePoiLabel();
+			placePoiLabel.setPlaceId(placeVO.getId());
+			placePoiLabel.setPoiCode(Integer.parseInt(labelId));
+			placePoiLabelService.save(placePoiLabel);
+		});
+	}
+
+	/**
+	 * 场所负责人和用户绑定
+	 * @param placeVO
+	 */
+	@Transactional(rollbackFor = Exception.class)
+	public User bindUserHandle(PlaceVO placeVO) {
+		User newUser = new User();
+		if (null!=placeVO.getPhone() && !placeVO.getPhone().equals("")) {
+			//根据手机号查询库里的数据
+			User userParams = new User();
+			userParams.setPhone(placeVO.getPhone());
+			User user = userService.getOne(Condition.getQueryWrapper(userParams));
+
+			if (user != null) {
+				//如果用户存在,则该用户id绑定场所
+				placeVO.setPrincipalUserId(user.getId());
+			} else {
+				//如果用户不存在,则新增一个用户
+				newUser.setAccount(placeVO.getPhone());
+				newUser.setPhone(placeVO.getPhone());
+				newUser.setName(placeVO.getUsername());
+				newUser.setRealName(placeVO.getUsername());
+				// 目前暂定居民角色,默认密码为 123456
+				newUser.setRoleId("1717429059648606209");
+				newUser.setPassword("123456");
+				// 用户新增
+				boolean submit = userService.submit(newUser);
+				//绑定id
+				placeVO.setPrincipalUserId(newUser.getId());
+				//给人员打上场所负责人的标签
+				baseMapper.saveUserLabel(newUser.getId(),1002);
+			}
+		}
+		return newUser;
+	}
+
+	/**
+	 * 保存场所详情及任务信息
+	 * @param placeVO
+	 */
+	@Transactional(rollbackFor = Exception.class)
+	public void savePlaceExtAndTaskInfo(PlaceVO placeVO) {
+		PlaceExtEntity placeExtEntity = new PlaceExtEntity();
+		placeExtEntity.setPlaceId(placeVO.getId());
+		// 判断是否已存在,已存在则不新增
+		QueryWrapper<PlaceExtEntity> wrapper = new QueryWrapper<>();
+		wrapper.eq("is_deleted",0)
+			.eq("place_id",placeVO.getId());
+		PlaceExtEntity one = placeExtService.getOne(wrapper);
+		if (null == one) {
+			placeExtEntity.setPlaceId(placeVO.getId());
+			//新增
+			placeExtService.savePlaceExt(placeExtEntity);
+		}
+	}
+
+	/**
+	 * 历史场所挂接处理-临时
+	 * @param place
+	 * @return
+	 */
+	@Override
+	public Object historyPlaceHandle(PlaceVO place) {
+		// 查询所有的场所(手机号不为空)
+		List<PlaceVO> list = baseMapper.getPlaceNotNullPhone();
+		// 遍历
+		for (PlaceVO placeVO : list) {
+			User user = bindUserHandle(placeVO);
+			if (null!=user){
+				placeVO.setPrincipalUserId(user.getId());
+				//更新场所用户id绑定
+				baseMapper.updatePlaceEntity(placeVO);
+			}
+		}
+		return null;
+	}
+
+	/**
+	 * 历史场所标签挂接处理-临时
+	 * @param place
+	 * @return
+	 */
+	@Override
+	@Transactional
+	public Object historyPlaceLabelHandle(PlaceVO place) {
+		// 查询所有的场所
+		List<PlaceVO> list = baseMapper.getAllHistoryPlace();
+		// 遍历
+		for (PlaceVO placeVO : list) {
+			if (null!=placeVO.getLabel()){
+				String[] split = placeVO.getLabel().split(",");
+				for (String s : split) {
+					PlacePoiLabel placePoiLabel = new PlacePoiLabel();
+					placePoiLabel.setPlaceId(placeVO.getId());
+					placePoiLabel.setPoiCode(Integer.parseInt(s));
+					placePoiLabelService.save(placePoiLabel);
+				}
+			}
+		}
+		return null;
+	}
+
+	/**
+	 * 场所表 自定义详情查询
+	 * @param place
+	 * @return
+	 */
+	@Override
+	public PlaceVO getDetail(PlaceEntity place) {
+		// 查询场所信息
+		PlaceVO placeVO = baseMapper.getDetail(place);
+		if (null!= placeVO) {
+			if (null != placeVO.getHouseCode() && !placeVO.getHouseCode().equals("")){
+				place.setHouseCode(placeVO.getHouseCode());
+			}
+			// 查询门牌地址信息
+			if (null != place.getHouseCode() && !place.getHouseCode().equals("")) {
+				QueryWrapper<DoorplateAddressEntity> wrapper = new QueryWrapper<>();
+				wrapper.eq("address_code", place.getHouseCode());
+				List<DoorplateAddressEntity> list = doorplateAddressService.list(wrapper);
+				if (list.size() > 0) {
+					placeVO.setDoorplateAddressEntity(list.get(0));
+				}
+				// 查询网格数据
+				placeVO.setGrid(gridService.getGridDetailByHouseCode(place.getHouseCode()));
+			}else {
+				// 通过定位点落面分析网格位置,反向推出社区派出所相关数据
+			}
+		}
+		// 返回
+		return placeVO;
+	}
 }

--
Gitblit v1.9.3