| | |
|---|
| | | import com.panzhihua.common.model.vos.community.ComActMessageVO; |
|---|
| | | import com.panzhihua.common.model.vos.community.ComMngPopulationVO; |
|---|
| | | import com.panzhihua.common.model.vos.community.PageComActMessageVO; |
|---|
| | | import com.panzhihua.common.model.vos.user.ComHouseMemberVo; |
|---|
| | | import com.panzhihua.common.model.vos.user.ComMngFamilyInfoVO; |
|---|
| | | import com.panzhihua.service_community.model.dos.ComMngPopulationDO; |
|---|
| | | import org.apache.ibatis.annotations.Mapper; |
|---|
| | |
|---|
| | | @Select("select id,user_id,relationship,`name`,id_card,phone,age,health,job,create_at,update_at from com_mng_family_info where user_id=#{userId}") |
|---|
| | | 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); |
|---|
| | | |
|---|
| | | @Select("<script> " + |
|---|
| | | "SELECT\n" + |
|---|
| | | "cmp.`name`,\n" + |
|---|
