| | |
|---|
| | | + "cmp.special_situation, " + "cmp.phone, " + "cmp.remark, " + "cmp.native_place, " + "cmp.nation, " |
|---|
| | | + "cmpct.label, " + "cmp.marriage, " + "cmp.culture_level, " + "cmp.profession, " + "cmp.out_or_local, " |
|---|
| | | + "cmp.census_register, " + "cmp.healthy, " + "cmp.birthday, " + "cmp.update_at, " + "cmp.address, " |
|---|
| | | + "cmp.is_rent " + "FROM " + "com_mng_population AS cmp " |
|---|
| | | + "cmp.is_rent,cmp.death " + "FROM " + "com_mng_population AS cmp " |
|---|
| | | + " LEFT JOIN com_mng_population_community_tags AS cmpct ON cmp.id = cmpct.population_id " + "<where>" |
|---|
| | | + "<if test='comMngPopulationVO.name != null and comMngPopulationVO.name != ""'>" |
|---|
| | | + "AND cmp.`name` LIKE concat(#{comMngPopulationVO.name},'%') " + " </if> " |
|---|
