| | |
| | | "AND cmp.sex = #{comMngPopulationVO.sex} " + |
| | | " </if> " + |
| | | "<if test='comMngPopulationVO.ageStartTime != null and comMngPopulationVO.ageStartTime != ""'>" + |
| | | "AND date_format(cmp.birthday,'%Y-%m-%d') <![CDATA[ >= ]]> #{comMngPopulationVO.ageStartTime} " + |
| | | "AND date_format(cmp.birthday,'%Y-%m-%d') <![CDATA[ <= ]]> #{comMngPopulationVO.ageStartTime} " + |
| | | " </if> " + |
| | | "<if test='comMngPopulationVO.ageEndTime != null and comMngPopulationVO.ageEndTime != ""'>" + |
| | | "AND date_format(cmp.birthday,'%Y-%m-%d') <![CDATA[ <= ]]> #{comMngPopulationVO.ageEndTime} " + |
| | | "AND date_format(cmp.birthday,'%Y-%m-%d') <![CDATA[ >= ]]> #{comMngPopulationVO.ageEndTime} " + |
| | | " </if> " + |
| | | "<if test='comMngPopulationVO.nativePlace != null and comMngPopulationVO.nativePlace != ""'>" + |
| | | "AND cmp.native_place LIKE concat(#{comMngPopulationVO.nativePlace},'%') " + |