springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/community/CommunityService.java
@@ -3150,4 +3150,15 @@ */ @PostMapping("/population/grid/list") R getGridPopulationList(@RequestBody ComMngPopulationListDTO populationListDTO); /** * 综治后台-删除居民 * @param ids 居民id集合 * @return 删除结果 */ @PostMapping("/population/grid/del") R delGridPopulation(@RequestBody List<Long> ids); @GetMapping("/population/grid/get") R getGridPopulationDetail(@RequestParam("populationId")Long populationId); } springcloud_k8s_panzhihuazhihuishequ/grid_backstage/src/main/java/com/panzhihua/grid_backstage/api/PopulationApi.java
@@ -4,6 +4,7 @@ import com.panzhihua.common.model.dtos.grid.admin.ComMngPopulationListDTO; import com.panzhihua.common.model.vos.LoginUserInfoVO; import com.panzhihua.common.model.vos.R; import com.panzhihua.common.model.vos.grid.PopulationDetailVO; import com.panzhihua.common.model.vos.grid.admin.ComMngPopulationListVO; import com.panzhihua.common.model.vos.screen.ComActPopulationScreenVO; import com.panzhihua.common.service.community.CommunityService; @@ -14,6 +15,7 @@ import org.springframework.web.bind.annotation.*; import javax.annotation.Resource; import java.util.List; @Slf4j @Api(tags = {"居民模块"}) @@ -23,8 +25,6 @@ @Resource private CommunityService communityService; @Resource private GridService gridService; @ApiOperation(value = "居民列表@lyq",response = ComMngPopulationListVO.class) @PostMapping("/list") @@ -34,4 +34,15 @@ return communityService.getGridPopulationList(populationListDTO); } @ApiOperation(value = "居民删除@lyq") @PostMapping("/del") public R del(@RequestBody List<Long> ids){ return communityService.delGridPopulation(ids); } @ApiOperation(value = "居民查看@lyq",response = PopulationDetailVO.class) @GetMapping("/get") public R get(@RequestParam("populationId")Long populationId){ return communityService.getGridPopulationDetail(populationId); } } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/api/PopulationApi.java
@@ -9,6 +9,7 @@ import org.springframework.web.bind.annotation.*; import javax.annotation.Resource; import java.util.List; @Slf4j @RestController @@ -43,6 +44,15 @@ return comMngPopulationService.getGridPopulationAdminList(populationListDTO); } @PostMapping("/grid/del") public R delGridPopulationAdmin(@RequestBody List<Long> ids) { return comMngPopulationService.delGridPopulationAdmin(ids); } @GetMapping("/grid/get") public R getGridPopulationAdminDetail(@RequestParam("populationId")Long populationId) { return comMngPopulationService.getPopulationDetailApp(populationId); } } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationDAO.java
@@ -950,7 +950,7 @@ "AND cmp.house_id is null " + " </if> " + "<if test='populationListDTO.communityId != null'>" + "AND cmp.community_id = #{populationListDTO.communityId} " + "AND cmp.act_id = #{populationListDTO.communityId} " + " </if> " + "<if test='populationListDTO.politicalOutlook != null'>" + "AND cmp.political_outlook = #{populationListDTO.politicalOutlook} " + @@ -965,4 +965,12 @@ @Select("select relation from com_mng_population_house_user where house_id = #{houseId} and popul_id = #{populationId}") Integer getPopulationRelationByHouseId(@Param("houseId") Long houseId, @Param("populationId") Long populationId); @Select("<script>" + " select count(id) from event_visiting_tasks as evt where visiter_id in " + "<foreach collection='ids' item='id' index='index' open='(' close=')' separator=',' >" + "#{id}" + "</foreach>" + " </script>") Integer getPopulationVisitingCount(@Param("ids") List<Long> ids); } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/ComMngPopulationService.java
@@ -217,4 +217,6 @@ R getPopulationRepairByApp(); R getGridPopulationAdminList(ComMngPopulationListDTO populationListDTO); R delGridPopulationAdmin(List<Long> ids); } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComMngPopulationServiceImpl.java
@@ -1528,5 +1528,14 @@ return R.ok(populationListIPage); } @Override public R delGridPopulationAdmin(List<Long> ids){ Integer count = this.baseMapper.getPopulationVisitingCount(ids); if(count > 0){ return R.ok("您选择的数据中存在被引用的,无法删除"); } this.baseMapper.deleteBatchIds(ids); return R.ok(); } }