From bdeb1fbd8a7933b8425bbed2b0093dfa1c2b4d3e Mon Sep 17 00:00:00 2001
From: zhongrj <646384940@qq.com>
Date: Mon, 15 May 2023 19:23:24 +0800
Subject: [PATCH] 菜单，角色查询调整排序
---
skjcmanager/skjcmanager-service/skjcmanager-system/src/main/java/cn/gistack/system/mapper/MenuMapper.xml | 9 ++-------
1 files changed, 2 insertions(+), 7 deletions(-)
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-system/src/main/java/cn/gistack/system/mapper/MenuMapper.xml b/skjcmanager/skjcmanager-service/skjcmanager-system/src/main/java/cn/gistack/system/mapper/MenuMapper.xml
index f07c1c3..252db7a 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-system/src/main/java/cn/gistack/system/mapper/MenuMapper.xml
+++ b/skjcmanager/skjcmanager-service/skjcmanager-system/src/main/java/cn/gistack/system/mapper/MenuMapper.xml
@@ -530,13 +530,8 @@
<!--查询菜单列表（排除 web,app 之外的菜单）-->
<select id="grantTreeNew" resultMap="treeNodeResultMap">
- select id, parent_id, name as title, id as "value", id as "key" from blade_menu
- where is_deleted = 0 start with name = 'web' CONNECT BY PRIOR id = parent_id
- union all
- (
- select id, parent_id, name as title, id as "value", id as "key" from blade_menu
- where is_deleted = 0 start with name = 'app' CONNECT BY PRIOR id = parent_id
- )
+ select id, parent_id, name as title, id as "value", id as "key" from YWXT.blade_menu
+ where is_deleted = 0 start with ( name = 'web' or name = 'app') CONNECT BY PRIOR id = parent_id order by sort asc
</select>
</mapper>
--
Gitblit v1.9.3