package com.cloud.user.dao;


import com.cloud.model.sys.SysOrganization;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.Set;

@Mapper
public interface UserOrgDao {

    @Select("SELECT r.* FROM sys_org_user ru INNER JOIN sys_organization r ON r.id = ru.organizationId WHERE ru.userId = #{userId} AND r.orgId= #{orgId}")
    Set<SysOrganization> findUserOrgs(@Param("userId")Long userId, @Param("orgId")Long orgId);

    @Select("SELECT id,orgId,type,name,address,master,phone FROM sys_organization where id = #{orgId}")
    Set<SysOrganization> findUserOrgsName(Long orgId);
}