场所新增警务网格

zhongrj

2024-02-02 7ecbb9875d55c5323b2eba09e987a815171335c8

 src/main/java/org/springblade/modules/place/service/impl/PlaceServiceImpl.java

@@ -26,6 +26,7 @@
import org.springblade.common.utils.IdUtils;
import org.springblade.core.mp.support.Condition;
import org.springblade.core.secure.utils.AuthUtil;
import org.springblade.core.tool.utils.SpringUtil;
import org.springblade.modules.doorplateAddress.entity.DoorplateAddressEntity;
import org.springblade.modules.doorplateAddress.service.IDoorplateAddressService;
import org.springblade.modules.grid.entity.GridEntity;
@@ -49,6 +50,8 @@
import org.springblade.modules.place.vo.PlaceVO;
import org.springblade.modules.place.mapper.PlaceMapper;
import org.springblade.modules.place.service.IPlaceService;
import org.springblade.modules.police.entity.PoliceAffairsGridEntity;
import org.springblade.modules.police.service.IPoliceAffairsGridService;
import org.springblade.modules.system.entity.Dept;
import org.springblade.modules.system.entity.User;
import org.springblade.modules.system.service.IDeptService;
@@ -1152,4 +1155,31 @@
      List<NinePlaceExcel> aa = baseMapper.export(place, list, regionChildCodesList, isAdministrator);
      return aa;
   }

   /**
    * 场所警务网格处理
    */
   @Override
   public Object placeJwGridCodeHandle() {
      // 查询 警务网格为空的数据
      List<PlaceEntity> list = baseMapper.getPlaceNotJwGridCode();
      // 遍历
      for (PlaceEntity placeEntity : list) {
         if (!Strings.isBlank(placeEntity.getLng())){
            // 空间分析
            //点坐标解析
            String point = "'POINT(" + placeEntity.getLng() + " " + placeEntity.getLat() +")'";
            //String point = "'POINT(" + villageInfoExcel.getLatitude() + " " + villageInfoExcel.getLongitude() +")'";
            List<PoliceAffairsGridEntity> policeAffairsGridEntities
               = SpringUtil.getBean(IPoliceAffairsGridService.class).spatialAnalysis(point);
            if (policeAffairsGridEntities.size()>0){
               PoliceAffairsGridEntity policeAffairsGridEntity = policeAffairsGridEntities.get(0);
               placeEntity.setJwGridCode(policeAffairsGridEntity.getJwGridCode());
               // 更新
               updateById(placeEntity);
            }
         }
      }
      return null;
   }
}