| | |
| | | R getSecondHouseAddress(@RequestBody CascadeHouseDTO cascadeHouseDTO); |
| | | |
| | | /** |
| | | * 查询房屋二级级联菜单后台 |
| | | * |
| | | * @param cascadeHouseDTO |
| | | * 请求参数 |
| | | * @return 菜单列表 |
| | | */ |
| | | @PostMapping("/common/data/population/second/listBack") |
| | | public R getSecondHouse(@RequestBody CascadeHouseDTO cascadeHouseDTO); |
| | | |
| | | /** |
| | | * 微心愿处理人列表 |
| | | * @param communityId 社区id |
| | | * @param type 处理人类型(1.后台用户 2.党员 3.志愿者) |
| | |
| | | return communityService.getSecondHouseAddress(cascadeHouseDTO); |
| | | } |
| | | |
| | | /** |
| | | * 查询房屋二级级联菜单后台 |
| | | * |
| | | * @param cascadeHouseDTO |
| | | * 请求参数 |
| | | * @return 菜单列表 |
| | | */ |
| | | @ApiOperation(value = "房屋级联菜单查询") |
| | | @PostMapping("/second/listBack") |
| | | public R getSecondHouse(@RequestBody CascadeHouseDTO cascadeHouseDTO) { |
| | | cascadeHouseDTO.setCommunityId(this.getCommunityId()); |
| | | return communityService.getSecondHouse(cascadeHouseDTO); |
| | | } |
| | | |
| | | @ApiOperation(value = "分页查询实有房屋列表", response = ComMngPopulationHouseAdminVO.class) |
| | | @PostMapping("/pageHouse") |
| | | public R pageHouse(@RequestBody ComMngPopulationHouseAdminDTO populationHouseAdminDTO) { |
| | |
| | | } |
| | | |
| | | /** |
| | | * 查询房屋二级级联菜单后台 |
| | | * |
| | | * @param cascadeHouseDTO |
| | | * 请求参数 |
| | | * @return 菜单列表 |
| | | */ |
| | | @PostMapping("/population/second/listBack") |
| | | public R getSecondHouse(@RequestBody CascadeHouseDTO cascadeHouseDTO) { |
| | | return comMngPopulationHouseService.getSecondHouse(cascadeHouseDTO); |
| | | } |
| | | |
| | | /** |
| | | * 分页查询房屋列表 |
| | | * |
| | | * @param populationHouseAdminDTO |
| | |
| | | */ |
| | | IPage<ComActFourMemberVO> pageList(Page page, @Param("commonPage")CommonPage commonPage); |
| | | ComActFourMemberVO getById(Integer id); |
| | | ComActFourMemberVO getByIdVillage(Integer id); |
| | | } |
| | |
| | | |
| | | List<String> find(String ids); |
| | | |
| | | List<String> findByVillage(String ids); |
| | | |
| | | List<VillageVO> select(Long id); |
| | | } |
| | |
| | | List<VillageVO> getSecondHouseAddress(Long communityId); |
| | | |
| | | /** |
| | | * 房屋二级联动后台 |
| | | * @param communityId |
| | | * @return |
| | | */ |
| | | List<VillageVO> getSecondHouse(Long communityId); |
| | | |
| | | /** |
| | | * 四长四员分页查询 |
| | | * @param page |
| | | * @param commonPage |
| | |
| | | R getSecondHouseAddress(CascadeHouseDTO cascadeHouseDTO); |
| | | |
| | | /** |
| | | * 查询二级房屋级联菜单后台 |
| | | * |
| | | * @param cascadeHouseDTO |
| | | * 请求参数 |
| | | * @return 菜单列表 |
| | | */ |
| | | R getSecondHouse(CascadeHouseDTO cascadeHouseDTO); |
| | | |
| | | /** |
| | | * 分页查询房屋列表 |
| | | * |
| | | * @param populationHouseAdminDTO |
| | |
| | | import org.springframework.util.ObjectUtils; |
| | | |
| | | import javax.annotation.Resource; |
| | | import java.util.ArrayList; |
| | | import java.util.List; |
| | | import java.util.stream.Collectors; |
| | | |
| | |
| | | public R insert(ComActFourMemberVO comActFourMemberVO) { |
| | | if(comActFourMemberVO!=null&&comActFourMemberVO.getJurisdiction()!=null){ |
| | | ComActFourMember comActFourMember=new ComActFourMember(); |
| | | List<String> jurisdictionList=comMngBuildingDAO.find(comActFourMemberVO.getJurisdiction()); |
| | | List<String> jurisdictionList=new ArrayList<>(); |
| | | List<String> jurisdictionList1=comMngBuildingDAO.find(comActFourMemberVO.getJurisdiction()); |
| | | List<String> jurisdictionList2=comMngBuildingDAO.findByVillage(comActFourMemberVO.getJurisdiction()); |
| | | if(!jurisdictionList1.isEmpty()){ |
| | | jurisdictionList.addAll(jurisdictionList1); |
| | | } |
| | | if(!jurisdictionList2.isEmpty()){ |
| | | jurisdictionList.addAll(jurisdictionList2); |
| | | } |
| | | if(!jurisdictionList.isEmpty()&&jurisdictionList.size()==jurisdictionList.stream().distinct().collect(Collectors.toList()).size()){ |
| | | comActFourMember.setJurisdictionContent(JSON.toJSONString(jurisdictionList)); |
| | | AdministratorsUserVO administratorsUserVO=new AdministratorsUserVO(); |
| | |
| | | return R.ok(this.comMngPopulationDAO.getSecondHouseAddress(cascadeHouseDTO.getCommunityId())); |
| | | } |
| | | |
| | | @Override |
| | | public R getSecondHouse(CascadeHouseDTO cascadeHouseDTO) { |
| | | return R.ok(this.comMngPopulationDAO.getSecondHouse(cascadeHouseDTO.getCommunityId())); |
| | | } |
| | | |
| | | /** |
| | | * 分页查询房屋列表 |
| | | * |
| | |
| | | select distinct concat(alley,house_num,'号',IFNULL(floor,0),'栋') from com_mng_population_house where id in (${id}) |
| | | </select> |
| | | |
| | | <select id="findByVillage" resultType="String"> |
| | | select distinct concat(alley,house_num,'号',IFNULL(floor,0),'栋') from com_mng_village where village_id in (${id}) |
| | | </select> |
| | | |
| | | <resultMap id="selectMap" type="com.panzhihua.common.model.vos.community.VillageVO"> |
| | | <result property="value" column="villageId"/> |
| | | <result property="label" column="villageName"/> |
| | |
| | | </resultMap> |
| | | |
| | | <select id="getSecondHouseAddress" resultMap="selectMap"> |
| | | select t.village_id as villageId,concat(t.alley,t.house_num,'号') as villageName,t1.id,concat(t1.unit_no,'栋',t1.floor,'单元',t1.code,'号') as name from com_mng_village t left join com_mng_population_house t1 on t.village_id = t1.village_id where t.community_id=#{communityId} and t1.id is not null |
| | | select t.village_id as villageId,concat(t.alley,t.house_num,'号') as villageName,t1.id,concat(t1.unit_no,'栋',t1.floor,'单元',t1.code,'号') as name from com_mng_village t left join com_mng_population_house t1 on t.village_id = t1.village_id where t.community_id=#{communityId} |
| | | </select> |
| | | |
| | | <select id="getSecondHouse" resultMap="selectMap"> |
| | | select t.village_id as villageId,concat(t.alley,t.house_num,'号') as villageName,t1.id,concat(t1.unit_no,'栋') as name from com_mng_village t left join com_mng_population_house t1 on t.village_id = t1.village_id where t.community_id=#{communityId} |
| | | </select> |
| | | |
| | | |