From cd0cc8910180826a92451c44a55c2799d7cdca81 Mon Sep 17 00:00:00 2001
From: linwe <872216996@qq.com>
Date: Fri, 10 Nov 2023 17:28:48 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'

---
 src/main/java/org/springblade/modules/place/service/impl/PlaceServiceImpl.java |  104 +++++++++++++++++++++++++++++++++++++++++++++++++--
 1 files changed, 99 insertions(+), 5 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 944da7e..4197cd7 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,11 +16,15 @@
  */
 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;
@@ -56,6 +60,12 @@
 
 	@Autowired
 	private IPlaceExtService placeExtService;
+
+	@Autowired
+	private IDoorplateAddressService doorplateAddressService;
+
+	@Autowired
+	private IGridService gridService;
 
 	@Override
 	public IPage<PlaceVO> selectPlacePage(IPage<PlaceVO> page, PlaceVO place) {
@@ -116,7 +126,8 @@
 	 * @param placeVO
 	 */
 	@Transactional(rollbackFor = Exception.class)
-	public void bindUserHandle(PlaceVO placeVO) {
+	public User bindUserHandle(PlaceVO placeVO) {
+		User newUser = new User();
 		if (null!=placeVO.getPhone() && !placeVO.getPhone().equals("")) {
 			//根据手机号查询库里的数据
 			User userParams = new User();
@@ -126,9 +137,9 @@
 			if (user != null) {
 				//如果用户存在,则该用户id绑定场所
 				placeVO.setPrincipalUserId(user.getId());
+				return user;
 			} else {
 				//如果用户不存在,则新增一个用户
-				User newUser = new User();
 				newUser.setAccount(placeVO.getPhone());
 				newUser.setPhone(placeVO.getPhone());
 				newUser.setName(placeVO.getUsername());
@@ -141,17 +152,100 @@
 				//绑定id
 				placeVO.setPrincipalUserId(newUser.getId());
 				//给人员打上场所负责人的标签
-
+				baseMapper.saveUserLabel(newUser.getId(),1002);
 				// 用户插入后同时给场所详情表插入一条该场所信息
 				if (submit){
 					PlaceExtEntity placeExtEntity = new PlaceExtEntity();
 					placeExtEntity.setPlaceId(placeVO.getId());
-					//新增
-					placeExtService.savePlaceExt(placeExtEntity);
+					// 判断是否已存在,已存在则不新增
+					QueryWrapper<PlaceExtEntity> wrapper = new QueryWrapper<>();
+					wrapper.eq("is_deleted",0)
+						.eq("place_id",placeVO.getId());
+					PlaceExtEntity one = placeExtService.getOne(wrapper);
+					if (null == one) {
+						//新增
+						placeExtService.savePlaceExt(placeExtEntity);
+					}
 				}
 			}
 		}
+		return newUser;
 	}
 
+	/**
+	 * 历史场所挂接处理-临时
+	 * @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