消防检查优化

linwei

2024-02-03 b7df6735bcb2d447cae7fcfba2d12accf3dd2fcc

 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);
            }
         }
      }