| | |
| | | "cmp.remark, " + |
| | | "cmv.alley, " + |
| | | "cmp.native_place, " + |
| | | "cmphu.relation, " + |
| | | "cmp.nation " + |
| | | "FROM " + |
| | | "com_mng_population AS cmp " + |
| | | "LEFT JOIN com_mng_village AS cmv ON cmv.village_id = cmp.village_id " + |
| | | "LEFT JOIN com_mng_population_house_user AS cmphu ON cmphu.popul_id = cmp.id " + |
| | | "<where>" + |
| | | "<if test='comMngPopulationVO.name != null and comMngPopulationVO.name.trim() != ""'>" + |
| | | "AND cmp.`name` LIKE concat(#{comMngPopulationVO.name},'%') " + |
| | |
| | | "cmp.birthday, " + |
| | | "cmp.update_at, " + |
| | | "cmp.address, " + |
| | | "cmp.is_rent " + |
| | | "cmp.is_rent, " + |
| | | "cmphu.relation " + |
| | | "FROM " + |
| | | "com_mng_population AS cmp " + |
| | | "LEFT JOIN com_mng_village AS cmv ON cmv.village_id = cmp.village_id " + |
| | | "LEFT JOIN com_mng_population_house_user AS cmphu ON cmphu.popul_id = cmp.id " + |
| | | "<where>" + |
| | | "<if test='comMngPopulationVO.name != null and comMngPopulationVO.name != ""'>" + |
| | | "AND cmp.`name` LIKE concat(#{comMngPopulationVO.name},'%') " + |