居民接口开发

huanghongfa

2021-06-23 c45d5cbd3dc0aafa19f03500c0c26331f56175e3

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngPopulationDAO.java

@@ -15,6 +15,7 @@
import com.panzhihua.common.model.vos.community.screen.event.*;
import com.panzhihua.common.model.vos.community.screen.index.*;
import com.panzhihua.common.model.vos.grid.EventGridDataVO;
import com.panzhihua.common.model.vos.grid.PopulationDetailVO;
import com.panzhihua.common.model.vos.grid.PopulationListVO;
import com.panzhihua.common.model.vos.user.*;
import com.panzhihua.common.model.vos.community.PageComActMessageVO;
@@ -878,4 +879,35 @@
            " </script>")
    IPage<PopulationListVO> pagePopulationListApp(Page page, @Param("populationListDTO") PagePopulationListDTO populationListDTO);

    @Select("SELECT " +
            " cmp.id, " +
            " cmp.`name`, " +
            " cmp.phone, " +
            " cmp.card_no, " +
            " cmp.label, " +
            " cmp.address, " +
            " cmp.nation, " +
            " cmp.political_outlook, " +
            " cmp.sex, " +
            " cmp.birthday, " +
            " cmp.native_place, " +
            " cmp.healthy, " +
            " cmp.is_rent, " +
            " cmv.alley AS road, " +
            " cmv.house_num AS doorNo, " +
            " cmp.floor, " +
            " cmp.unit_no, " +
            " cmp.house_no, " +
            " cmp.work_company, " +
            " cmp.census_register, " +
            " cmp.out_or_local, " +
            " cmp.remark, " +
            " cmp.marriage " +
            "FROM " +
            " com_mng_population AS cmp " +
            " LEFT JOIN com_mng_village AS cmv ON cmv.village_id = cmp.village_id  " +
            "WHERE " +
            " id = #{populationId}")
    PopulationDetailVO getPopulationDetailApp(@Param("populationId") Long populationId);

}