22 lines
1.0 KiB
SQL
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
|
|
);
|