8000 fix: SysMenuMapper oracle DISTINCT 错误 · cadecode/uni-boot-cloud@2f82bbd · GitHub
[go: up one dir, main page]
Skip to content

Commit 2f82bbd

Browse files
cadecodecadecode
committed
fix: SysMenuMapper oracle DISTINCT 错误
1 parent 5a165b5 commit 2f82bbd

File tree

1 file changed

+8
-1
lines changed

1 file changed

+8
-1
lines changed

‎framework/framework_svc/src/main/resources/mapper/oracle/SysMenuMapper.xml

Lines changed: 8 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -19,13 +19,20 @@
1919
<result column="r_code" property="roles" typeHandler="ObjToStrTypeHandler"/>
2020
</resultMap>
2121
<select id="selectByRoles" resultType="com.github.cadecode.uniboot.framework.svc.bean.po.SysMenu">
22-
SELECT DISTINCT sm.*
22+
SELECT sm.id, sm.parent_id, sm.route_name, TO_CHAR(sm.route_path) as route_path, TO_CHAR(sm.component_path) as
23+
component_path, sm.menu_name,
24+
sm.leaf_flag, TO_CHAR(sm.icon) as icon, sm.order_num, sm.enable_flag, sm.hidden_flag, sm.cache_flag,
25+
sm.create_time, sm.update_time,
26+
sm.update_user
2327
FROM sys_menu sm LEFT JOIN sys_role_menu srm ON sm.id = srm.menu_id
2428
LEFT JOIN sys_role sr ON srm.role_id = sr.id
2529
where sm.enable_flag = 1
2630
<foreach collection="roleCodes" item="roleCode" separator="," open="and sr.code IN (" close=")">
2731
#{roleCode}
2832
</foreach>
33+
GROUP BY sm.id, sm.parent_id, sm.route_name, TO_CHAR(sm.route_path), TO_CHAR(sm.component_path), sm.menu_name,
34+
sm.leaf_flag, TO_CHAR(sm.icon),
35+
sm.order_num, sm.enable_flag, sm.hidden_flag, sm.cache_flag, sm.create_time, sm.update_time, sm.update_user
2936
ORDER BY sm.order_num
3037
</select>
3138
<select id="selectRolesVo" resultMap="SysMenuRolesVoMap">

0 commit comments

Comments
 (0)
0