| | |
| | | "cmp.census_register, \n" + |
| | | "cmp.healthy, \n" + |
| | | "cmp.birthday, \n" + |
| | | "cmp.update_at, \n" + |
| | | "cmp.is_rent \n" + |
| | | "FROM \n" + |
| | | "com_mng_population AS cmp " + |
| | |
| | | " </if> " + |
| | | "<if test='comMngPopulationVO.actId != null'>" + |
| | | " and cmp.act_id = #{comMngPopulationVO.actId} " + |
| | | " </if> " + |
| | | "<if test='comMngPopulationVO.outOrLocal != null'>" + |
| | | " and cmp.out_or_local = #{comMngPopulationVO.outOrLocal} " + |
| | | " </if> " + |
| | | "<if test='comMngPopulationVO.villageId != null'>" + |
| | | " and cmp.village_id = #{comMngPopulationVO.villageId} " + |
| | |
| | | "<if test='comMngPopulationVO.sex != null and comMngPopulationVO.sex != ""'>" + |
| | | "AND cmp.sex = #{comMngPopulationVO.sex} " + |
| | | " </if> " + |
| | | "<if test='comMngPopulationVO.ageStart != null and comMngPopulationVO.ageStart != ""'>" + |
| | | "AND cmp.age <![CDATA[ >= ]]> #{comMngPopulationVO.ageStart} " + |
| | | "<if test='comMngPopulationVO.ageStartTime != null and comMngPopulationVO.ageStartTime != ""'>" + |
| | | "AND date_format(cmp.birthday,'%Y-%m-%d') <![CDATA[ <= ]]> #{comMngPopulationVO.ageStartTime} " + |
| | | " </if> " + |
| | | "<if test='comMngPopulationVO.ageEnd != null and comMngPopulationVO.ageEnd != ""'>" + |
| | | "AND cmp.age <![CDATA[ <= ]]> #{comMngPopulationVO.ageEnd} " + |
| | | "<if test='comMngPopulationVO.ageEndTime != null and 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},'%') " + |