linwei
2024-02-20 e0cd68972b507e31bb4ea30ceb6f792b8601b8ee
src/main/java/org/springblade/modules/grid/service/impl/GridServiceImpl.java
@@ -148,19 +148,20 @@
    */
   @Override
   @Transactional(rollbackFor = Exception.class)
   public Object spatialAnalysis() {
   public Object spatialAnalysis(DoorplateAddressEntity addressEntity) {
      // 按社区
      String name = null;
//      String name = "茶山路社区居民委员会";
      //查询社区信息
      List<DoorplateAddressEntity> doorplateAddressEntities = doorplateAddressService.getAllDoorplateAddress(name);
      List<DoorplateAddressEntity> doorplateAddressEntities = doorplateAddressService.getAllDoorplateAddress(addressEntity);
      //遍历
      for (DoorplateAddressEntity doorplateAddressEntity : doorplateAddressEntities) {
         //点坐标解析
         String point = "'POINT(" + doorplateAddressEntity.getX84() + " " + doorplateAddressEntity.getY84() +")'";
         String point = "'POINT(" + doorplateAddressEntity.getX() + " " + doorplateAddressEntity.getY() +")'";
//         String point = "'POINT(" + villageInfoExcel.getLatitude() + " " + villageInfoExcel.getLongitude() +")'";
         GridEntity gridEntity = baseMapper.spatialAnalysis(point);
         if (null!=gridEntity){
         List<GridEntity> gridEntityList = baseMapper.spatialAnalysis(point);
         if (gridEntityList.size()>0) {
            GridEntity gridEntity = gridEntityList.get(0);
            QueryWrapper<GridRangeEntity> queryWrapper = new QueryWrapper<>();
            queryWrapper.eq("grid_id",gridEntity.getId()).eq("house_code",doorplateAddressEntity.getAddressCode());
            GridRangeEntity one = gridRangeService.getOne(queryWrapper);
@@ -172,6 +173,10 @@
               gridRangeEntity.setDistrictName(doorplateAddressEntity.getAoiName());
               // 保存
               gridRangeService.save(gridRangeEntity);
            }else {
               one.setGridId(gridEntity.getId());
               // 更新
               gridRangeService.updateById(one);
            }
         }
      }
@@ -331,4 +336,14 @@
   public GridEntity getGridByNames(String gridName, String communityName) {
      return baseMapper.getGridByNames(gridName,communityName);
   }
   /**
    * 查询用户对应的网格
    * @param userId
    * @return
    */
   @Override
   public List<String> getGridListByUserId(Long userId) {
      return baseMapper.getGridListByUserId(userId.toString());
   }
}