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;
|
import java.util.Map;
|
|
/**
|
* @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 join sys_user u on h.user_id=u.user_id and h.house_code=#{houseCode1}")
|
List<LoginUserInfoVO> selectListHouseUser(String houseCode1);
|
@Select("SELECT\n" +
|
"\tp.house_code ,\n" +
|
"\tp.is_rent\n" +
|
"FROM\n" +
|
"\tsys_user_input p \n" +
|
"WHERE\n" +
|
"\tp.id =#{userId}")
|
Map<String, Object> selectHouseCode(Long userId);
|
}
|
