标签报事+通知公告

linwe

2023-11-12 8d8c7da4e91028fc877f101dcd244bef3e18c197

 src/main/java/org/springblade/modules/grid/service/impl/GridServiceImpl.java

@@ -16,18 +16,25 @@
 */
package org.springblade.modules.grid.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springblade.core.secure.utils.AuthUtil;
import org.springblade.core.tool.utils.BeanUtil;
import org.springblade.modules.doorplateAddress.entity.DoorplateAddressEntity;
import org.springblade.modules.doorplateAddress.service.IDoorplateAddressService;
import org.springblade.modules.grid.entity.GridEntity;
import org.springblade.modules.grid.entity.GridRangeEntity;
import org.springblade.modules.grid.excel.GridExcel;
import org.springblade.modules.grid.service.IGridRangeService;
import org.springblade.modules.grid.vo.GridVO;
import org.springblade.modules.grid.mapper.GridMapper;
import org.springblade.modules.grid.service.IGridService;
import org.springblade.core.mp.base.BaseServiceImpl;
import org.springblade.modules.system.entity.User;
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.Date;
@@ -42,6 +49,12 @@
 */
@Service
public class GridServiceImpl extends ServiceImpl<GridMapper, GridEntity> implements IGridService {

   @Autowired
   private IDoorplateAddressService doorplateAddressService;

   @Autowired
   private IGridRangeService gridRangeService;

   @Override
   public IPage<GridVO> selectGridPage(IPage<GridVO> page, GridVO grid) {
@@ -58,7 +71,12 @@
      List<GridEntity> list = new ArrayList<>();
      // 遍历
      for (GridExcel gridExcel : data) {
         GridEntity gridEntity = Objects.requireNonNull(BeanUtil.copy(gridExcel, GridEntity.class));
         // 取出名称分隔
         String[] split = gridExcel.getGridName().split("居民委员会");
         GridEntity gridEntity = new GridEntity();
         gridEntity.setCommunityName(split[0] + "居民委员会");
         gridEntity.setGridName(split[1]);
         gridEntity.setGeom(gridExcel.getGeom());
         gridEntity.setCreateUser(AuthUtil.getUserId());
         gridEntity.setCreateTime(new Date());
         gridEntity.setUpdateUser(AuthUtil.getUserId());
@@ -68,4 +86,59 @@
      // 批量导入
      saveBatch(list);
   }

   /**
    * 根据地址编号查询网格数据
    * @param houseCode
    * @return
    */
   @Override
   public GridVO getGridDetailByHouseCode(String houseCode) {
      return baseMapper.getGridDetailByHouseCode(houseCode);
   }

   /**
    * 根据用户id(网格员)查询对应的房屋地址code
    * @param userId
    * @return
    */
   @Override
   public List<String> getAddressCodeListByUserId(Long userId) {
      return baseMapper.getAddressCodeListByUserId(userId);
   }

   /**
    * 空间分析 mysql 5.7
    */
   @Override
   @Transactional(rollbackFor = Exception.class)
   public Object spatialAnalysis() {
      // 按社区
//      String name = "万达社区居民委员会";
      String name = "茶山路社区居民委员会";
      //查询社区信息
      List<DoorplateAddressEntity> doorplateAddressEntities = doorplateAddressService.getAllDoorplateAddress(name);
      //遍历
      for (DoorplateAddressEntity doorplateAddressEntity : doorplateAddressEntities) {
         //点坐标解析
         String point = "'POINT(" + doorplateAddressEntity.getX84() + " " + doorplateAddressEntity.getY84() +")'";
//         String point = "'POINT(" + villageInfoExcel.getLatitude() + " " + villageInfoExcel.getLongitude() +")'";
         GridEntity gridEntity = baseMapper.spatialAnalysis(point);
         if (null!=gridEntity){
            QueryWrapper<GridRangeEntity> queryWrapper = new QueryWrapper<>();
            queryWrapper.eq("grid_id",gridEntity.getId()).eq("house_code",doorplateAddressEntity.getAddressCode());
            GridRangeEntity one = gridRangeService.getOne(queryWrapper);
            if (null==one) {
               GridRangeEntity gridRangeEntity = new GridRangeEntity();
               gridRangeEntity.setGridId(gridEntity.getId());
               gridRangeEntity.setHouseCode(doorplateAddressEntity.getAddressCode());
               gridRangeEntity.setDistrictCode(doorplateAddressEntity.getAoiCode());
               gridRangeEntity.setDistrictName(doorplateAddressEntity.getAoiName());
               // 保存
               gridRangeService.save(gridRangeEntity);
            }
         }
      }
      return null;
   }
}