1
2
3
4
5
6
7
8
9
10
11
12
| -- 采购入库单 / 销售出库单 导入权限菜单
| SET @now = NOW();
| INSERT INTO system_menu (name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
| VALUES ('采购入库单导入', 'mes:wm-item-receipt:import', 3, 7, 5798, '', '', '', '', 0, b'1', b'1', 0, '1', @now, '1', @now, b'0');
| SET @m1 = LAST_INSERT_ID();
| INSERT INTO system_menu (name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
| VALUES ('导入销售出库', 'mes:wm-product-sales:import', 3, 11, 5970, '', '', '', '', 0, b'1', b'1', 0, '1', @now, '1', @now, b'0');
| SET @m2 = LAST_INSERT_ID();
| INSERT INTO system_role_menu (role_id, menu_id, tenant_id, creator, create_time, updater, update_time, deleted)
| SELECT r.id, @m1, 0, '1', @now, '1', @now, b'0' FROM system_role r WHERE r.deleted=0 AND r.code IN ('super_admin','common');
| INSERT INTO system_role_menu (role_id, menu_id, tenant_id, creator, create_time, updater, update_time, deleted)
| SELECT r.id, @m2, 0, '1', @now, '1', @now, b'0' FROM system_role r WHERE r.deleted=0 AND r.code IN ('super_admin','common');
|
|