| | |
| | | dept.setId(one.getId()); |
| | | flag = updateById(dept); |
| | | } else { |
| | | if (dept.getId() > 0) { |
| | | if (dept.getId() != null && dept.getId() > 0) { |
| | | flag = updateById(dept); |
| | | } else { |
| | | flag = save(dept); |
| | |
| | | public Object dataHandle() { |
| | | // 查询所有的社区 |
| | | QueryWrapper<Region> queryWrapper = new QueryWrapper<>(); |
| | | queryWrapper.eq("district_code","361102").eq("region_level",5); |
| | | queryWrapper.eq("district_code", "361102").eq("region_level", 5); |
| | | List<Region> list = regionService.list(queryWrapper); |
| | | // 遍历 |
| | | for (Region region : list) { |
| | |
| | | QueryWrapper<Dept> deptQueryWrapper = new QueryWrapper<>(); |
| | | deptQueryWrapper.eq("is_deleted", 0).eq("dept_name", region.getTownName()); |
| | | Dept parentDept = getOne(deptQueryWrapper); |
| | | if (null!=parentDept){ |
| | | if (null != parentDept) { |
| | | dept.setParentId(parentDept.getId()); |
| | | dept.setAncestors(parentDept.getAncestors() + "," + parentDept.getId()); |
| | | } |
| | |
| | | public Object dataHandleCommunity() { |
| | | // 查询所有的社区 |
| | | QueryWrapper<Region> queryWrapper = new QueryWrapper<>(); |
| | | queryWrapper.eq("district_code","361102").eq("region_level",5); |
| | | queryWrapper.eq("district_code", "361102").eq("region_level", 5); |
| | | List<Region> list = regionService.list(queryWrapper); |
| | | // 遍历 |
| | | for (Region region : list) { |
| | |
| | | |
| | | String deptIds = ""; |
| | | int count = 0; |
| | | for (String key:deptMap.keySet()){ |
| | | for (String key : deptMap.keySet()) { |
| | | count++; |
| | | deptIds += key; |
| | | if (count<deptMap.size()){ |
| | | deptIds +=","; |
| | | if (count < deptMap.size()) { |
| | | deptIds += ","; |
| | | } |
| | | } |
| | | |
| | |
| | | public Object dataHandleCommunityByPolice() { |
| | | // 查询所有的派出所 |
| | | QueryWrapper<Dept> wrapper = new QueryWrapper<>(); |
| | | wrapper.eq("is_deleted",0).like("dept_name","派出所"); |
| | | wrapper.eq("is_deleted", 0).like("dept_name", "派出所"); |
| | | List<Dept> list = list(wrapper); |
| | | // 遍历 |
| | | for (Dept dept : list) { |
| | | // 通过派出所名称查询对应的警务网格信息 |
| | | QueryWrapper<PoliceAffairsGridEntity> queryWrapper = new QueryWrapper<>(); |
| | | queryWrapper.eq("is_deleted",0).eq("pcs_name",dept.getDeptName()); |
| | | queryWrapper.eq("is_deleted", 0).eq("pcs_name", dept.getDeptName()); |
| | | List<PoliceAffairsGridEntity> policeAffairsGridEntityList |
| | | = SpringUtil.getBean(IPoliceAffairsGridService.class).list(queryWrapper); |
| | | // 遍历 |
| | |
| | | |
| | | /** |
| | | * 查询对应的派出所 |
| | | * |
| | | * @param deptId |
| | | * @return |
| | | */ |