20241120lh.sql

alter table ecw_channel  add COLUMN  `bubble_exempt_weight`  decimal(15,2) DEFAULT NULL COMMENT '免泡重量';

SELECT @parentId := (SELECT id FROM system_menu WHERE name LIKE '订单');
INSERT INTO jiedao.system_menu
(name, permission, menu_type, sort, parent_id, `path`, icon, component, status, creator, create_time, updater, update_time, deleted, is_show_in_menu_bar, name_en, keepalive, redirect, badge_field)
VALUES('重泡货操作权限', '', 1, 1, @parentId, 'order pao buttons', '#', NULL, 0, '1', '2024-11-20 17:16:53', '1', '2024-11-20 17:16:53', 0, 0, 'Order PAO Buttons', 0, NULL, NULL);
SELECT @parentId := (SELECT id FROM system_menu WHERE name LIKE '重泡货操作权限');
INSERT INTO jiedao.system_menu
(name, permission, menu_type, sort, parent_id, `path`, icon, component, status, creator, create_time, updater, update_time, deleted, is_show_in_menu_bar, name_en, keepalive, redirect, badge_field)
VALUES('设为半泡', 'ecw:weight_deal:half_throw', 3, 1, @parentId, '', '', '', 0, '1', '2024-11-20 17:22:48', '1', '2024-11-20 17:34:50', 0, 1, 'semi Bubble', 0, NULL, NULL);
INSERT INTO jiedao.system_menu
(name, permission, menu_type, sort, parent_id, `path`, icon, component, status, creator, create_time, updater, update_time, deleted, is_show_in_menu_bar, name_en, keepalive, redirect, badge_field)
VALUES('设为全泡', 'ecw:weight_deal:process', 3, 1, @parentId, '', '', '', 0, '1', '2024-11-20 17:25:46', '1', '2024-11-20 17:35:04', 0, 1, 'full Bubble', 0, NULL, NULL);
INSERT INTO jiedao.system_menu
(name, permission, menu_type, sort, parent_id, `path`, icon, component, status, creator, create_time, updater, update_time, deleted, is_show_in_menu_bar, name_en, keepalive, redirect, badge_field)
VALUES('设为普货', 'ecw:weight_deal:general_cargo', 3, 1, @parentId, '', '', '', 0, '1', '2024-11-20 17:28:52', '1', '2024-11-20 17:35:26', 0, 1, 'normal Cargo', 0, NULL, NULL);