| | |
|---|
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
|---|
| | | import com.panzhihua.common.model.dtos.community.PageComActDTO; |
|---|
| | | import com.panzhihua.common.model.vos.community.ComActVO; |
|---|
| | | import com.panzhihua.common.model.vos.community.ComPopulationActVO; |
|---|
| | | import com.panzhihua.common.model.vos.grid.EventGridCommunityAdminVO; |
|---|
| | | import com.panzhihua.service_community.model.dos.ComActDO; |
|---|
| | | import org.apache.ibatis.annotations.Mapper; |
|---|
| | |
|---|
| | | |
|---|
| | | @Select("select community_id,`name` from com_act where state = 0") |
|---|
| | | List<EventGridCommunityAdminVO> getCommunityLists(); |
|---|
| | | |
|---|
| | | @Select("select ca.`name`,cmsap.province_name,cmsac.city_name,cmsad.district_name,ca.street_id,ca.community_id,cs.`name` as streetName from com_act as ca \n" + |
|---|
| | | "left join com_mng_struct_area_province as cmsap on cmsap.province_adcode = ca.province_code\n" + |
|---|
| | | "left join com_mng_struct_area_city as cmsac on cmsac.city_adcode = ca.city_code\n" + |
|---|
| | | "left join com_mng_struct_area_district as cmsad on cmsad.district_adcode = ca.area_code\n" + |
|---|
| | | "left join com_street as cs on cs.street_id = ca.street_id\n" + |
|---|
| | | "where ca.community_id = #{communityId}") |
|---|
| | | ComPopulationActVO getPopulationActById(@Param("communityId")Long communityId); |
|---|
| | | } |
|---|
