| | |
|---|
| | | @Repository |
|---|
| | | public interface RoleResourceMapper extends BaseMapper<RoleResource> { |
|---|
| | | |
|---|
| | | @Select("select sr.* from sys_resource sr left join sys_role_resource srr on srr.resource_id = sr.id left join sys_user su on su.role_id = srr.role_id where 1 = 1 and su.id = #{userId} and sr. level = 3 and sr.resource_id = #{fatherResourceId} and sr. status = 1 order by sr.sort") |
|---|
| | | @Select("select sr.* from \"SOURCE\".\"sys_resource\" sr left join \"SOURCE\".\"sys_role_resource\" srr on srr.RESOURCE_ID = sr.ID left join \"SOURCE\".\"sys_user\" su on su.ROLE_ID = srr.ROLE_ID where 1 = 1 and su.ID = #{userId} and sr. LEVEL = 3 and sr.RESOURCE_ID = #{fatherResourceId} and sr. STATUS = 1 order by sr.SORT") |
|---|
| | | List<Resource> getMenuButtomResource(@Param("fatherResourceId") Long fatherResourceId, @Param("userId") Long userId); |
|---|
| | | |
|---|
| | | } |
|---|
