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);
|
}
|
