wuweihua
88 lines
2.9 KiB
SQL
88 lines
2.9 KiB
SQL
-- Move order source back under system monitor, add read-only order bill query under billing center
|
|
SET NAMES utf8mb4;
|
|
|
|
SET @monitorParent := (
|
|
SELECT menu_id FROM sys_menu
|
|
WHERE menu_type = 'M' AND (path = 'monitor' OR menu_name = '系统监控')
|
|
ORDER BY menu_id
|
|
LIMIT 1
|
|
);
|
|
|
|
UPDATE sys_menu
|
|
SET parent_id = @monitorParent,
|
|
menu_name = '订单数据源',
|
|
order_num = 9,
|
|
path = 'orderSource',
|
|
component = 'monitor/orderSource/index',
|
|
route_name = 'OrderSource',
|
|
visible = '0',
|
|
status = '0',
|
|
update_by = 'admin',
|
|
update_time = sysdate()
|
|
WHERE @monitorParent IS NOT NULL
|
|
AND menu_type = 'C'
|
|
AND (menu_id = 2325 OR perms = 'monitor:orderSource:list');
|
|
|
|
SET @billParent := (
|
|
SELECT parent_id FROM sys_menu
|
|
WHERE menu_type = 'C' AND component = 'price/billing/bill'
|
|
ORDER BY menu_id
|
|
LIMIT 1
|
|
);
|
|
|
|
SET @orderBillMenuExists := (
|
|
SELECT COUNT(*) FROM sys_menu WHERE menu_id = 2340 OR perms = 'price:orderBill:list'
|
|
);
|
|
|
|
UPDATE sys_menu
|
|
SET order_num = order_num + 1
|
|
WHERE @billParent IS NOT NULL
|
|
AND @orderBillMenuExists = 0
|
|
AND parent_id = @billParent
|
|
AND menu_type = 'C';
|
|
|
|
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, remark
|
|
)
|
|
SELECT 2340, '订单列表查询', @billParent, 1,
|
|
'orderBill', 'price/orderBill/index', '', 'OrderBillQuery',
|
|
1, 0, 'C', '0', '0', 'price:orderBill:list', 'list', 'admin', sysdate(),
|
|
'查询 prc_order_bill 全部订单，只读'
|
|
FROM DUAL
|
|
WHERE @billParent IS NOT NULL
|
|
AND NOT EXISTS (SELECT 1 FROM sys_menu WHERE menu_id = 2340 OR perms = 'price:orderBill:list');
|
|
|
|
INSERT INTO sys_menu (
|
|
menu_id, menu_name, parent_id, order_num, path, component,
|
|
is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time
|
|
)
|
|
SELECT 2341, '查询', 2340, 1, '', NULL,
|
|
1, 0, 'F', '0', '0', 'price:orderBill:list', '#', 'admin', sysdate()
|
|
FROM DUAL
|
|
WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE menu_id = 2341);
|
|
|
|
INSERT INTO sys_role_menu (role_id, menu_id)
|
|
SELECT 1, m.menu_id
|
|
FROM (SELECT 2340 AS menu_id UNION SELECT 2341) m
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM sys_role_menu rm WHERE rm.role_id = 1 AND rm.menu_id = m.menu_id
|
|
);
|
|
|
|
INSERT INTO sys_role_menu (role_id, menu_id)
|
|
SELECT DISTINCT rm.role_id, 2340
|
|
FROM sys_role_menu rm
|
|
JOIN sys_menu src ON src.menu_id = rm.menu_id
|
|
WHERE src.menu_type = 'C' AND src.component = 'price/billing/bill'
|
|
AND NOT EXISTS (
|
|
SELECT 1 FROM sys_role_menu x WHERE x.role_id = rm.role_id AND x.menu_id = 2340
|
|
);
|
|
|
|
INSERT INTO sys_role_menu (role_id, menu_id)
|
|
SELECT DISTINCT rm.role_id, 2341
|
|
FROM sys_role_menu rm
|
|
WHERE rm.menu_id = 2340
|
|
AND NOT EXISTS (
|
|
SELECT 1 FROM sys_role_menu x WHERE x.role_id = rm.role_id AND x.menu_id = 2341
|
|
);
|