| | |
| | | List<ComMngFamilyInfoVO> listFamilyByUserId(Long userId); |
| | | |
| | | @Select("select id,`name`,phone,relation from com_mng_population where road = #{comMngPopulationDO.road} and door_no = #{comMngPopulationDO.doorNo} and floor = #{comMngPopulationDO.floor} and unit_no = #{comMngPopulationDO.unitNo} and house_no = #{comMngPopulationDO.houseNo} and id != #{comMngPopulationDO.id}") |
| | | List<ComHouseMemberVo> listHouseMermberByUserId(ComMngPopulationDO comMngPopulationDO); |
| | | List<ComHouseMemberVo> listHouseMermberByUserId(@Param("comMngPopulationDO") ComMngPopulationDO comMngPopulationDO); |
| | | |
| | | @Select("<script> " + |
| | | "SELECT\n" + |
| | |
| | | "<if test='comMngPopulationVO.name != null and comMngPopulationVO.name != ""'>" + |
| | | "AND cmp.`name` LIKE concat(#{comMngPopulationVO.name},'%') " + |
| | | " </if> " + |
| | | "<if test='comMngPopulationVO.actId != null'>" + |
| | | " and cmp.act_id = #{comMngPopulationVO.actId} " + |
| | | " </if> " + |
| | | "<if test='comMngPopulationVO.road != null and comMngPopulationVO.road != ""'>" + |
| | | "AND cmp.road LIKE concat(#{comMngPopulationVO.road},'%') " + |
| | | " </if> " + |