| | |
| | | "cmp.relation, \n" + |
| | | "cmp.marriage, \n" + |
| | | "cmp.culture_level, \n" + |
| | | "cmp.out_or_local, \n" + |
| | | "cmp.census_register, \n" + |
| | | "cmp.healthy, \n" + |
| | | "cmp.is_rent \n" + |
| | | "FROM \n" + |
| | | "com_mng_population AS cmp " + |
| | |
| | | "<if test='comMngPopulationVO.sex != null and comMngPopulationVO.sex != ""'>" + |
| | | "AND cmp.sex = #{comMngPopulationVO.sex} " + |
| | | " </if> " + |
| | | "<if test='comMngPopulationVO.ageStart != null'>" + |
| | | "<if test='comMngPopulationVO.ageStart != null and comMngPopulationVO.ageStart != ""'>" + |
| | | "AND cmp.age <![CDATA[ >= ]]> #{comMngPopulationVO.ageStart} " + |
| | | " </if> " + |
| | | "<if test='comMngPopulationVO.ageEnd != null'>" + |
| | | "<if test='comMngPopulationVO.ageEnd != null and comMngPopulationVO.ageStart != ""'>" + |
| | | "AND cmp.age <![CDATA[ <= ]]> #{comMngPopulationVO.ageEnd} " + |
| | | " </if> " + |
| | | "<if test='comMngPopulationVO.nativePlace != null and comMngPopulationVO.nativePlace != ""'>" + |