| | |
| | | |
| | | private String regionCode; |
| | | |
| | | private List<Map<String, Integer>> nineTypeStatistics; |
| | | private List<Map<String, Object>> nineTypeStatistics; |
| | | } |
| | |
| | | /** |
| | | * 民警审核 |
| | | */ |
| | | @PostMapping("/rectificationStatistics") |
| | | @GetMapping("/rectificationStatistics") |
| | | @ApiOperationSupport(order = 5) |
| | | @ApiOperation(value = "九小场所类型隐患数量统计", notes = "传入taskPlaceRectification") |
| | | public R rectificationStatistics() { |
| | |
| | | @Param("regionChildCodesList") List<String> regionChildCodesList, |
| | | @Param("isAdministrator") Integer isAdministrator); |
| | | |
| | | List<Map<String, Integer>> getNineTypeStatistics(List<String> regionChildCodesList, Integer isAdministrator); |
| | | List<Map<String, Object>> getNineTypeStatistics(List<String> regionChildCodesList, Integer isAdministrator); |
| | | } |
| | |
| | | br.village_name, |
| | | bu.`name`, |
| | | jpe.legal_tel, |
| | | jpe.legal_person |
| | | jpe.legal_person, |
| | | jt.remark reasonFailure |
| | | FROM |
| | | jczz_task_place_rectification jtpr |
| | | LEFT JOIN jczz_task jt on jt.id = jtpr.task_id |
| | | LEFT JOIN jczz_place jp ON jtpr.house_code = jp.house_code |
| | | LEFT JOIN jczz_grid jg ON jg.grid_code = jp.grid_code |
| | | LEFT JOIN blade_region br ON br.`code` = jg.community_code |
| | |
| | | bd.code = 'nineType' |
| | | AND bd.is_sealed = 0 |
| | | AND bd.dict_key > 0 |
| | | order by bd.sort desc |
| | | |
| | | </select> |
| | | |
| | |
| | | .eq(Region::getRegionLevel, 4)); |
| | | List<RegionVO> copy = BeanUtil.copy(list, RegionVO.class); |
| | | for (RegionVO regionVO : copy) { |
| | | List<Map<String, Integer>> nineTypeStatistics = baseMapper.getNineTypeStatistics(regionChildCodesList, isAdministrator); |
| | | List<Map<String, Object>> nineTypeStatistics = baseMapper.getNineTypeStatistics(regionChildCodesList, isAdministrator); |
| | | regionVO.setNineTypeStatistics(nineTypeStatistics); |
| | | } |
| | | return copy; |