| | |
| | | "cmp.remark, " + |
| | | "cmp.native_place, " + |
| | | "cmp.nation, " + |
| | | "cmp.label, " + |
| | | "cmpct.label, " + |
| | | "cmp.marriage, " + |
| | | "cmp.culture_level, " + |
| | | "cmp.profession, " + |
| | |
| | | "cmp.is_rent " + |
| | | "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> " + |
| | | "<if test='comMngPopulationVO.label != null and comMngPopulationVO.label != ""'>" + |
| | | "AND cmp.label LIKE concat('%',#{comMngPopulationVO.label},'%') " + |
| | | "AND cmpct.label LIKE concat('%',#{comMngPopulationVO.label},'%') " + |
| | | " </if> " + |
| | | "<if test='comMngPopulationVO.actId != null'>" + |
| | | " and cmp.act_id = #{comMngPopulationVO.actId} " + |