| | |
| | | + "<if test='comMngPopulationVO.ageStartTime != null and comMngPopulationVO.ageEndTime != null and comMngPopulationVO.ageStartTime != comMngPopulationVO.ageEndTime'>" |
| | | + "AND cmp.birthday BETWEEN #{comMngPopulationVO.ageEndTimeEnd} and #{comMngPopulationVO.ageStartTime}" |
| | | + " </if> " |
| | | + "<if test='comMngPopulationVO.keyWord != null and comMngPopulationVO.keyWord != '' '>" |
| | | + "AND (cmp.name like concat('%',#{comMngPopulationVO.keyWord},'%') or cmp.card_no_str like concat('%',#{comMngPopulationVO.keyWord},'%') or cmp.phone like concat('%',#{comMngPopulationVO.keyWord},'%') " |
| | | + "<if test='comMngPopulationVO.searchKey != null and comMngPopulationVO.searchKey != '' '>" |
| | | + "AND (cmp.name like concat('%',#{comMngPopulationVO.searchKey},'%') or cmp.card_no_str like concat('%',#{comMngPopulationVO.searchKey},'%') or cmp.phone like concat('%',#{comMngPopulationVO.searchKey},'%') " |
| | | + " </if> " |
| | | + "<if test='comMngPopulationVO.nativePlace != null and comMngPopulationVO.nativePlace != ""'>" |
| | | + "AND cmp.native_place LIKE concat(#{comMngPopulationVO.nativePlace},'%') " + " </if> " |