| | |
| | | + "AND cmp.unit_no = #{comMngPopulationVO.unitNo} " + " </if> " |
| | | + "<if test='comMngPopulationVO.houseNo != null and comMngPopulationVO.houseNo != ""'>" |
| | | + "AND cmp.house_no = #{comMngPopulationVO.houseNo} " + " </if> " |
| | | + "<if test='comMngPopulationVO.isDeath != null'>" |
| | | + "AND cmp.death = #{comMngPopulationVO.isDeath} " + " </if> " |
| | | + "<if test='comMngPopulationVO.sex != null and comMngPopulationVO.sex != ""'>" |
| | | + "AND cmp.sex = #{comMngPopulationVO.sex} " + " </if> " |
| | | + "<if test='comMngPopulationVO.ageStartTime != null and comMngPopulationVO.ageStartTime != "" and comMngPopulationVO.ageEndTime == null'>" |
| | |
| | | */ |
| | | IPage<InputUserInfoVO> specialInputUser(Page page, @Param("pageInputUserDTO") PageInputUserDTO pageInputUserDTO); |
| | | |
| | | /** |
| | | * |
| | | * @param pageInputUserDTO |
| | | * @return |
| | | */ |
| | | List<InputUserInfoVO> specialInputUserExport(@Param("pageInputUserDTO") PageInputUserDTO pageInputUserDTO); |
| | | |
| | | @Select("<script> " |
| | | + "select id,tag_name,community_id,create_at,sys_flag from com_mng_user_tag <where> " |
| | | + "<if test='comMngUserTagDTO.tagName != null and comMngUserTagDTO.tagName != ""'>" |