70 lines
3.6 KiB
SQL
70 lines
3.6 KiB
SQL
-- 虚拟道具管理菜单（可重复执行）
|
|
-- 默认与“虚拟支付订单”或“支付订单”同级；均未找到时作为一级菜单显示。
|
|
|
|
SET @virtual_product_parent_id := COALESCE(
|
|
(SELECT parent_id FROM sys_menu WHERE perms = 'app:virtualOrder:list' LIMIT 1),
|
|
(SELECT parent_id FROM sys_menu WHERE perms = 'app:order:list' LIMIT 1),
|
|
0
|
|
);
|
|
|
|
SET @virtual_product_order_num := COALESCE(
|
|
(SELECT MAX(order_num) + 1 FROM sys_menu WHERE parent_id = @virtual_product_parent_id),
|
|
1
|
|
);
|
|
|
|
INSERT INTO sys_menu
|
|
(menu_name, parent_id, order_num, path, component, query, is_frame, is_cache,
|
|
menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
|
SELECT
|
|
'虚拟道具管理', @virtual_product_parent_id, @virtual_product_order_num,
|
|
'virtualProduct', 'app/virtualProduct/index', '', 1, 0,
|
|
'C', '0', '0', 'app:virtualProduct:list', 'shopping', 'admin', NOW(), '', NULL,
|
|
'微信虚拟支付价格档位与道具映射管理'
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM sys_menu WHERE perms = 'app:virtualProduct:list'
|
|
);
|
|
|
|
SET @virtual_product_menu_id := (
|
|
SELECT menu_id FROM sys_menu WHERE perms = 'app:virtualProduct:list' LIMIT 1
|
|
);
|
|
|
|
INSERT INTO sys_menu
|
|
(menu_name, parent_id, order_num, path, component, query, is_frame, is_cache,
|
|
menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
|
SELECT '虚拟道具查询', @virtual_product_menu_id, 1, '', '', '', 1, 0,
|
|
'F', '0', '0', 'app:virtualProduct:query', '#', 'admin', NOW(), '', NULL, ''
|
|
WHERE @virtual_product_menu_id IS NOT NULL
|
|
AND NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'app:virtualProduct:query');
|
|
|
|
INSERT INTO sys_menu
|
|
(menu_name, parent_id, order_num, path, component, query, is_frame, is_cache,
|
|
menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
|
SELECT '虚拟道具新增', @virtual_product_menu_id, 2, '', '', '', 1, 0,
|
|
'F', '0', '0', 'app:virtualProduct:add', '#', 'admin', NOW(), '', NULL, ''
|
|
WHERE @virtual_product_menu_id IS NOT NULL
|
|
AND NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'app:virtualProduct:add');
|
|
|
|
INSERT INTO sys_menu
|
|
(menu_name, parent_id, order_num, path, component, query, is_frame, is_cache,
|
|
menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
|
SELECT '虚拟道具修改', @virtual_product_menu_id, 3, '', '', '', 1, 0,
|
|
'F', '0', '0', 'app:virtualProduct:edit', '#', 'admin', NOW(), '', NULL, ''
|
|
WHERE @virtual_product_menu_id IS NOT NULL
|
|
AND NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'app:virtualProduct:edit');
|
|
|
|
INSERT INTO sys_menu
|
|
(menu_name, parent_id, order_num, path, component, query, is_frame, is_cache,
|
|
menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
|
SELECT '虚拟道具删除', @virtual_product_menu_id, 4, '', '', '', 1, 0,
|
|
'F', '0', '0', 'app:virtualProduct:remove', '#', 'admin', NOW(), '', NULL, ''
|
|
WHERE @virtual_product_menu_id IS NOT NULL
|
|
AND NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'app:virtualProduct:remove');
|
|
|
|
INSERT INTO sys_menu
|
|
(menu_name, parent_id, order_num, path, component, query, is_frame, is_cache,
|
|
menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
|
SELECT '虚拟道具导出', @virtual_product_menu_id, 5, '', '', '', 1, 0,
|
|
'F', '0', '0', 'app:virtualProduct:export', '#', 'admin', NOW(), '', NULL, ''
|
|
WHERE @virtual_product_menu_id IS NOT NULL
|
|
AND NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'app:virtualProduct:export');
|