| | |
|---|
| | | QueryWrapper<Region> regionWrapper = new QueryWrapper<>(); |
|---|
| | | regionWrapper.eq("code",grid.getCommunityCode()); |
|---|
| | | Region region = regionService.getOne(regionWrapper); |
|---|
| | | // 查询父机构 |
|---|
| | | // 查询父机构（社区机构） |
|---|
| | | System.out.println("社区名称 = " + region.getName()); |
|---|
| | | QueryWrapper<Dept> wrapper = new QueryWrapper<>(); |
|---|
| | | wrapper.eq("dept_name",region.getName()) |
|---|
| | | .eq("is_deleted",0); |
|---|
| | |
|---|
| | | QueryWrapper<Dept> wrapperChild = new QueryWrapper<>(); |
|---|
| | | wrapperChild.eq("dept_name",grid.getGridName()) |
|---|
| | | .eq("is_deleted",0) |
|---|
| | | .eq("id",dept.getId()); |
|---|
| | | Dept deptChild = deptService.getOne(wrapperChild); |
|---|
| | | if (null==deptChild){ |
|---|
| | | .eq("parent_id",dept.getId()); |
|---|
| | | List<Dept> deptChild = deptService.list(wrapperChild); |
|---|
| | | if (deptChild.size()==0){ |
|---|
| | | Dept deptInfo = new Dept(); |
|---|
| | | deptInfo.setParentId(dept.getId()); |
|---|
| | | deptInfo.setFullName(grid.getGridName()); |
|---|
| | | deptInfo.setDeptName(grid.getGridName()); |
|---|
| | | deptInfo.setDeptCategory(1); |
|---|
| | | deptInfo.setTenantId("000000"); |
|---|
| | | deptInfo.setRegionCode(grid.getGridCode()); |
|---|
| | | deptInfo.setAncestors(dept.getAncestors() + "," +dept.getId()); |
|---|
| | | // 新增 |
|---|
| | | deptService.save(deptInfo); |
|---|
| | | // 查询网格是否已存在（社区编号-网格名称），已存在更新，不存在插入新的 |
|---|
| | | QueryWrapper<GridEntity> queryWrapper = new QueryWrapper<>(); |
|---|
| | | queryWrapper.eq("grid_name",grid.getGridName()) |
|---|
| | | .eq("is_deleted",0) |
|---|
| | | .eq("community_code",grid.getCommunityCode()); |
|---|
| | | queryWrapper.eq("grid_code",grid.getGridCode()) |
|---|
| | | .eq("is_deleted",0); |
|---|
| | | System.out.println("网格编号 = " + grid.getGridCode()); |
|---|
| | | GridEntity one = getOne(queryWrapper); |
|---|
| | | if (null!=one){ |
|---|
| | | grid.setId(one.getId()); |
|---|
