From 9be8d4744aba93087c8ddb7202029047e9144bf8 Mon Sep 17 00:00:00 2001
From: lsh <lsh@163.com>
Date: 星期三, 09 四月 2025 13:52:27 +0800
Subject: [PATCH] *
---
src/main/java/com/zy/system/mapper/RoleResourceMapper.java | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/zy/system/mapper/RoleResourceMapper.java b/src/main/java/com/zy/system/mapper/RoleResourceMapper.java
index e77e262..1c9bd89 100644
--- a/src/main/java/com/zy/system/mapper/RoleResourceMapper.java
+++ b/src/main/java/com/zy/system/mapper/RoleResourceMapper.java
@@ -14,7 +14,7 @@
@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);
}
--
Gitblit v1.9.1