| | |
| | | if (null!=region){ |
| | | gridEntity.setCommunityCode(region.getCode()); |
| | | } |
| | | gridEntity.setGridName(split[1]); |
| | | gridEntity.setGeom(gridExcel.getGeom()); |
| | | gridEntity.setCreateUser(AuthUtil.getUserId()); |
| | | gridEntity.setCreateTime(new Date()); |
| | | gridEntity.setUpdateUser(AuthUtil.getUserId()); |
| | | gridEntity.setUpdateTime(new Date()); |
| | | list.add(gridEntity); |
| | | // 比对网格是否存在,如果已存在则更新,否则则新增 |
| | | QueryWrapper<GridEntity> queryWrapper = new QueryWrapper<>(); |
| | | queryWrapper.eq("is_deleted",0) |
| | | .eq("grid_name",split[1]) |
| | | .eq("community_code",region.getCode()); |
| | | GridEntity one = getOne(queryWrapper); |
| | | if (null!=one){ |
| | | one.setGridCode(gridExcel.getGridCode()); |
| | | one.setGridName(split[1]); |
| | | one.setGeom(gridExcel.getGeom()); |
| | | one.setUpdateUser(AuthUtil.getUserId()); |
| | | one.setUpdateTime(new Date()); |
| | | // 更新 |
| | | updateById(one); |
| | | }else { |
| | | // 设置网格数据 |
| | | gridEntity.setGridCode(gridExcel.getGridCode()); |
| | | gridEntity.setGridName(split[1]); |
| | | gridEntity.setGeom(gridExcel.getGeom()); |
| | | gridEntity.setCreateUser(AuthUtil.getUserId()); |
| | | gridEntity.setCreateTime(new Date()); |
| | | gridEntity.setUpdateUser(AuthUtil.getUserId()); |
| | | gridEntity.setUpdateTime(new Date()); |
| | | list.add(gridEntity); |
| | | } |
| | | } |
| | | // 批量导入 |
| | | saveBatch(list); |
| | |
| | | @Transactional(rollbackFor = Exception.class) |
| | | public Object spatialAnalysis() { |
| | | // 按社区 |
| | | String name = "万达社区居民委员会"; |
| | | String name = null; |
| | | // String name = "茶山路社区居民委员会"; |
| | | //查询社区信息 |
| | | List<DoorplateAddressEntity> doorplateAddressEntities = doorplateAddressService.getAllDoorplateAddress(name); |