| | |
|---|
| | | |
|---|
| | | @Select("<script> " + |
|---|
| | | "select cmp.id,cmv.`alley` as areaName,cmp.`name`,cmp.phone,cmp.label as tags,cmp.create_at from com_mng_population as cmp " + |
|---|
| | | "left join com_mng_village as cmv on cmv.village_id = cmp.village_id where cmp.act_id = #{pageInputUserDTO.communityId} " + |
|---|
| | | "left join com_mng_village as cmv on cmv.village_id = cmp.village_id where cmp.act_id = #{pageInputUserDTO.communityId} and cmp.label is not null " + |
|---|
| | | "<if test='pageInputUserDTO.name != null and pageInputUserDTO.name != ""'>" + |
|---|
| | | " AND cmp.`name` LIKE concat(#{pageInputUserDTO.name},'%') " + |
|---|
| | | " </if> " + |
|---|
