| | |
|---|
| | | @Select("select count(id) from com_elders_auth_elderly WHERE community_id = #{communityId}") |
|---|
| | | Integer getStatisticsCount(@Param("communityId") Long communityId); |
|---|
| | | |
|---|
| | | @Select("<script> " |
|---|
| | | + "select cmp.id,cmp.`name`,cmp.phone,cmp.card_no,cmpct.label,cmp.address,cmp.nation,cmp.political_outlook,cmv.lng,cmv.lat" |
|---|
| | | + ",cmp.sex from com_mng_population as cmp left join com_mng_village as cmv on cmv.village_id = cmp.village_id " |
|---|
| | | + " left join com_mng_population_community_tags as cmpct on cmp.id = cmpct.population_id " |
|---|
| | | + " where cmpct.community_id = #{populationListDTO.communityId}" |
|---|
| | | + "<if test='populationListDTO.keyWord != null and populationListDTO.keyWord != ""'>" |
|---|
| | | + "AND (cmp.`name` like concat (#{populationListDTO.keyWord},'%') or cmp.card_no_str like concat (#{populationListDTO.keyWord},'%')) " |
|---|
| | | + " </if> " + "<if test='populationListDTO.label != null and populationListDTO.label != ""'>" |
|---|
| | | + "AND cmpct.label like concat ('%',#{populationListDTO.label},'%') " + " </if> " + " </script>") |
|---|
| | | IPage<PopulationListVO> pagePopulationListApp(Page page, |
|---|
| | | @Param("populationListDTO") PagePopulationListDTO populationListDTO); |
|---|
| | | |
|---|
