| | |
| | | "com_mng_population AS cmp " + |
| | | "LEFT JOIN com_mng_village AS cmv ON cmv.village_id = cmp.village_id " + |
| | | "<where>" + |
| | | "<if test='comMngPopulationVO.name != null and comMngPopulationVO.name.trim() != ""'>" + |
| | | "<if test='comMngPopulationVO.name != null and comMngPopulationVO.name != ""'>" + |
| | | "AND cmp.`name` LIKE concat(#{comMngPopulationVO.name},'%') " + |
| | | " </if> " + |
| | | "<if test='comMngPopulationVO.road != null and comMngPopulationVO.road.trim() != ""'>" + |
| | | "<if test='comMngPopulationVO.road != null and comMngPopulationVO.road != ""'>" + |
| | | "AND cmp.road LIKE concat(#{comMngPopulationVO.road},'%') " + |
| | | " </if> " + |
| | | "<if test='comMngPopulationVO.doorNo != null and comMngPopulationVO.doorNo.trim() != ""'>" + |
| | | "<if test='comMngPopulationVO.doorNo != null and comMngPopulationVO.doorNo != ""'>" + |
| | | "AND cmp.door_no = #{comMngPopulationVO.doorNo} " + |
| | | " </if> " + |
| | | "<if test='comMngPopulationVO.alley != null and comMngPopulationVO.alley.trim() != ""'>" + |
| | | "<if test='comMngPopulationVO.alley != null and comMngPopulationVO.alley != ""'>" + |
| | | "AND cmv.alley LIKE concat(#{comMngPopulationVO.alley},'%') " + |
| | | " </if> " + |
| | | "<if test='comMngPopulationVO.sex != null and comMngPopulationVO.sex.trim() != ""'>" + |
| | | "<if test='comMngPopulationVO.sex != null and comMngPopulationVO.sex != ""'>" + |
| | | "AND cmp.sex = #{comMngPopulationVO.sex} " + |
| | | " </if> " + |
| | | "<if test='comMngPopulationVO.ageStart != null'>" + |
| | |
| | | "<if test='comMngPopulationVO.ageEnd != null'>" + |
| | | "AND cmp.age <![CDATA[ <= ]]> #{comMngPopulationVO.ageEnd} " + |
| | | " </if> " + |
| | | "<if test='comMngPopulationVO.nativePlace != null and comMngPopulationVO.nativePlace.trim() != ""'>" + |
| | | "<if test='comMngPopulationVO.nativePlace != null and comMngPopulationVO.nativePlace != ""'>" + |
| | | "AND cmp.native_place LIKE concat(#{comMngPopulationVO.nativePlace},'%') " + |
| | | " </if> " + |
| | | "<if test='comMngPopulationVO.nation != null and comMngPopulationVO.nation.trim() != ""'>" + |
| | | "<if test='comMngPopulationVO.nation != null and comMngPopulationVO.nation != ""'>" + |
| | | "AND cmp.nation = #{comMngPopulationVO.nation} " + |
| | | " </if> " + |
| | | "<if test='comMngPopulationVO.politicalOutlook != null and comMngPopulationVO.politicalOutlook.trim() != ""'>" + |
| | | "<if test='comMngPopulationVO.politicalOutlook != null and comMngPopulationVO.politicalOutlook != ""'>" + |
| | | "AND cmp.political_outlook = #{comMngPopulationVO.politicalOutlook} " + |
| | | " </if> " + |
| | | "<if test='comMngPopulationVO.cardNo != null and comMngPopulationVO.cardNo.trim() != ""'>" + |
| | | "<if test='comMngPopulationVO.cardNo != null and comMngPopulationVO.cardNo != ""'>" + |
| | | "AND cmp.card_no = #{comMngPopulationVO.cardNo} " + |
| | | " </if> " + |
| | | "<if test='comMngPopulationVO.remark != null and comMngPopulationVO.remark.trim() != ""'>" + |
| | | "<if test='comMngPopulationVO.remark != null and comMngPopulationVO.remark != ""'>" + |
| | | "AND cmp.remark = #{comMngPopulationVO.remark} " + |
| | | " </if> " + |
| | | " </where>" + |