package com.panzhihua.service_community.dao;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.panzhihua.common.model.vos.LoginUserInfoVO;
|
import com.panzhihua.service_community.model.dos.ComMngStructHouseUserDO;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.util.List;
|
|
/**
|
* @program: springcloud_k8s_panzhihuazhihuishequ
|
* @description: 房屋人员关系
|
* @author: huang.hongfa weixin hhf9596 qq 959656820
|
* @create: 2020-12-15 15:13
|
**/
|
@Mapper
|
public interface ComMngStructHouseUserDAO extends BaseMapper<ComMngStructHouseUserDO> {
|
@Select("select u.name,u.phone from com_mng_struct_house_user h left join sys_user u on h.user_id=u.user_id")
|
List<LoginUserInfoVO> selectListHouseUser(String houseCode1);
|
}
|
