Files
ruoyi-java/sql/xianyu_copy_template_menu.sql
2026-11-05 15:30:55 +08:00

22 lines
1.0 KiB
SQL

-- 闲鱼目录下增加「品类模板」。menu_id 若冲突请改大号后执行。
-- 超级管理员登录后重新进入系统即可看到;已授权「发品」的角色一并授权本菜单。
INSERT INTO sys_menu (
menu_id, menu_name, parent_id, order_num, path, component, query, route_name,
is_frame, is_cache, menu_type, visible, status, perms, icon,
create_by, create_time, update_by, update_time, remark
)
SELECT
2130, '品类模板', 2097, 1, 'xianyu-template', 'system/social-media/xianyu-template', '', '',
1, 0, 'C', '0', '0', '', 'edit',
'admin', sysdate(), '', NULL, '维护闲鱼代下单的发货说明、品类装箱清单和型号覆盖'
FROM DUAL
WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE menu_id = 2130 OR (parent_id = 2097 AND path = 'xianyu-template'));
INSERT INTO sys_role_menu (role_id, menu_id)
SELECT rm.role_id, 2130
FROM sys_role_menu rm
WHERE rm.menu_id = 2034
AND NOT EXISTS (
SELECT 1 FROM sys_role_menu x WHERE x.role_id = rm.role_id AND x.menu_id = 2130
);