-- 12.13  新增阶梯价格特需
CREATE TABLE `ecw_product_price_step_special` (
                                                  `id` bigint NOT NULL AUTO_INCREMENT,
                                                  `product_price_id` bigint DEFAULT NULL COMMENT '路线价格ID',
                                                  `product_price_step_id` bigint DEFAULT NULL COMMENT '阶梯价格ID',
                                                  `special_dict_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '特殊需求字典',
                                                  `transport_price` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '运费',
                                                  `transport_price_unit` bigint NOT NULL DEFAULT '1' COMMENT '运费金额单位',
                                                  `transport_volume_unit` bigint DEFAULT NULL COMMENT '运费体积单位',
                                                  `clearance_price` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '清关费用',
                                                  `clearance_price_unit` bigint NOT NULL DEFAULT '1' COMMENT '清关金额单位',
                                                  `clearance_volume_unit` bigint DEFAULT NULL COMMENT '清关体积单位',
                                                  `all_price` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '全包价格',
                                                  `all_price_unit` bigint NOT NULL DEFAULT '1' COMMENT '全包价格单位',
                                                  `all_volume_unit` bigint DEFAULT NULL COMMENT '全包价体积单位',
                                                  `status` tinyint(1) DEFAULT '0' COMMENT '是否展示 默认为展示',
                                                  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
                                                  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                                  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
                                                  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                                                  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
                                                  PRIMARY KEY (`id`) USING BTREE,
                                                  KEY `idx_special_price_id` (`product_price_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5393645 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='阶梯价格特殊需求';


--  阶梯表新增字段
alter table `ecw_product_price_step` add column `price_type` tinyint DEFAULT '0' COMMENT '0-运费,1-全包价, 2-清关费';


--  渠道管理新增国家设置
alter table `ecw_channel` add column `country_id` bigint DEFAULT 0 COMMENT '国家id(默认位为0,表示全部)' after `code`;

-- 路线重量上限
alter table `ecw_product_price` add column `weight_limit` decimal(8,2) DEFAULT '0.00' COMMENT '路线重量上限';
--  阶梯排序
alter table `ecw_product_price_step` add column `rank_num` int DEFAULT '1' COMMENT '阶梯排序';


-- 刷新阶梯排序
-- 1、创建临时表
create table ecw_product_price_step_bak like ecw_product_price_step;

-- 2、插入数据
INSERT INTO ecw_product_price_step_bak SELECT
t.id,
t.product_price_id,
t.start_num,
t.end_num,
t.weight_unit,
t.transport_price,
t.transport_price_unit,
t.transport_volume_unit,
t.clearance_price,
t.clearance_price_unit,
t.clearance_volume_unit,
t.all_price,
t.all_price_unit,
t.all_volume_unit,
t.creator,
t.create_time,
t.updater,
t.update_time,
t.deleted,
t.price_type,
Rank() over ( PARTITION BY product_price_id ORDER BY start_num ) AS rank_num
FROM
	ecw_product_price_step t;


-- 3、更新数据
update ecw_product_price_step t LEFT JOIN ecw_product_price_step_bak t1 on t.id=t1.id set t.rank_num=t1.rank_num;

-- 价格包装单位收费
CREATE TABLE `ecw_product_price_packaging` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `product_price_id` bigint NOT NULL COMMENT '产品价格ID',
  `packaging_types` varchar(255) COLLATE utf8mb4_general_ci NOT NULL COMMENT '包装类型,多个逗号连接',
  `packaging_price` decimal(8,2) DEFAULT NULL COMMENT '包装单位收费',
  `packaging_price_unit` bigint DEFAULT NULL COMMENT '包装单位收费金额单位',
  `packaging_volume_unit` bigint DEFAULT NULL COMMENT '包装单位收费体积单位',
  `rank_num` int DEFAULT '1',
  `price_type` tinyint DEFAULT '0' COMMENT '0-运费,1-全包价, 2-清关费',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='路线价格包装收费';

-- 阶梯价格包装单位收费
CREATE TABLE `ecw_product_price_step_packaging` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `product_price_id` bigint NOT NULL COMMENT '产品价格ID',
  `product_price_step_id` bigint DEFAULT NULL COMMENT '阶梯价格ID',
  `packaging_types` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '包装类型,多个逗号连接',
  `packaging_price` decimal(8,2) DEFAULT NULL COMMENT '包装单位收费',
  `packaging_price_unit` bigint DEFAULT NULL COMMENT '包装单位收费金额单位',
  `packaging_volume_unit` bigint DEFAULT NULL COMMENT '包装单位收费体积单位',
  `rank_num` int DEFAULT '1',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`)
VALUES (20, '路线重量超限异常', 'line_weight_exception', 'order_error_type', 0, 'default', '', NULL, '1', now(), '115', now(), b'0', 'line weight exception');

INSERT INTO `system_dict_type` (`name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES
( '路线重量超限异常处理结果', 'line_weight_exception_result', 0, NULL, '1', now(), '1', now(), b'0');

INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`)
VALUES (1, '允许超出上限', 'allow_over', 'line_weight_exception_result', 0, 'default', '', NULL, '1', now(), '1', now(), b'0', 'allow over');

INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`)
VALUES (2, '修改路线重量', 'change_line_weight', 'line_weight_exception_result', 0, 'default', '', NULL, '1', now(), '1', now(), b'0', 'change line weight');

INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`)
VALUES (3, '不许超出', 'not_allow_over', 'line_weight_exception_result', 0, 'default', '', NULL, '1', now(), '1', now(), b'0', 'not allow over');





-- 2023-12-20 yanghao 线路渠道清关费包装类型表
CREATE TABLE `ecw_line_channel_packaging`
(
    `id`               bigint   NOT NULL AUTO_INCREMENT COMMENT '主键',
    `channel_ids`      varchar(128)   NOT NULL COMMENT '渠道ID列表',
    `line_id`          bigint   NOT NULL COMMENT '线路ID',
    `packaging_types`  varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '包装类型 eg:1,2,3',
    `air_weight_limit` decimal(8, 2) NULL DEFAULT NULL COMMENT '空运重量上限',
    `clearance_price_unit`  bigint NULL DEFAULT NULL COMMENT '清关金额单位',
    `clearance_volume_unit` bigint NULL DEFAULT NULL COMMENT '清关体积单位',
    `creator`          varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
    `create_time`      datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `updater`          varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
    `update_time`      datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `deleted`          bit(1)   NOT NULL DEFAULT b'0' COMMENT '是否删除',
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `idx_line_id`(`line_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '线路渠道清关费包装类型表' ROW_FORMAT = Dynamic;


-- 2023-12-20 yanghao 线路渠道清关费阶梯价格
CREATE TABLE `ecw_line_channel_price_step_clearance`
(
    `id`                    bigint        NOT NULL AUTO_INCREMENT COMMENT '主键',
    `line_id`               bigint        NOT NULL COMMENT '线路ID',
    `packaging_id`          bigint        NOT NULL COMMENT '线路渠道包装表id',
    `start_num`             decimal(8, 2) NOT NULL COMMENT '起始数量',
    `end_num`               decimal(8, 2) NULL DEFAULT NULL COMMENT '结束数量',
    `clearance_price`       decimal(8, 2) NULL DEFAULT NULL COMMENT '清关费用',
    `creator`               varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
    `create_time`           datetime      NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `updater`               varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
    `update_time`           datetime      NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `deleted`               bit(1)        NOT NULL DEFAULT b'0' COMMENT '是否删除',
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `idx_line_id`(`line_id`) USING BTREE,
    INDEX `idx_packaging_id`(`packaging_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '线路渠道清关费阶梯价格' ROW_FORMAT = Dynamic;

-- 报价单和订单品名单价组成部分添加包装单价值
alter table ecw_offer_prod add column `packaging_clearance_fee_price` decimal(15,2) DEFAULT '0.00' COMMENT '包装清关费单价' after `brand_freight_price`;
alter table ecw_offer_prod add column `packaging_freight_price` decimal(15,2) DEFAULT '0.00' COMMENT '包装运费单价' after `packaging_clearance_fee_price`;
alter table ecw_order_item add column `packaging_clearance_fee_price` decimal(15,2) DEFAULT '0.00' COMMENT '包装清关费单价' after `brand_freight_price`;
alter table ecw_order_item add column `packaging_freight_price` decimal(15,2) DEFAULT '0.00' COMMENT '包装运费单价' after `packaging_clearance_fee_price`;



-- 修改字典表的字符集排序类型。 不修改会导致与其他字符集不一致而无法关联查询
ALTER TABLE system_dict_data MODIFY COLUMN `value` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;


-- 20240122 yanghao 添加订单表完成入仓时的总箱数和总数量
alter table ecw_order add column `sum_cartons_num_finished_warehouse_in` decimal(15,2) default 0 COMMENT '打包前入仓箱数';
alter table ecw_order add column `sum_quantity_all_finished_warehouse_in` decimal(15,2) default 0 COMMENT '打包前入仓总数量';

-- 20240125 yanghao 修改类型
alter table ecw_order modify column `sum_cartons_num_finished_warehouse_in` int default 0 COMMENT '打包前入仓箱数';
alter table ecw_order modify column `sum_quantity_all_finished_warehouse_in` int default NULL COMMENT '打包前入仓总数量';
-- 20240125 yanghao 添加订单表前一次打包的统计数据
alter table ecw_order add column `sum_cartons_num_prev_packed` int default 0 COMMENT '前一次打包箱数';
alter table ecw_order add column `sum_quantity_all_prev_packed` int default NULL COMMENT '前一次打包总数量';
alter table ecw_order add column `sum_weight_prev_packed` decimal(15,2) default 0 COMMENT '前一次打包重量';
alter table ecw_order add column `sum_volume_prev_packed` decimal(15,2) default 0 COMMENT '前一次打包体积';

alter table ecw_order add column `first_stocked_time` datetime default NULL COMMENT '首次完成备货时间';

-- 20240127 huyf 理货和合包装箱信息表
CREATE TABLE `ecw_box_order_check_info` (
                                            `id` bigint NOT NULL AUTO_INCREMENT,
                                            `shipment_id` bigint DEFAULT NULL COMMENT '出货单ID',
                                            `pkg_id` bigint DEFAULT NULL COMMENT '合包id',
                                            `order_id` bigint DEFAULT NULL COMMENT '订单ID',
                                            `order_num_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '编码',
                                            `type` tinyint DEFAULT NULL COMMENT '0-理货,1-合包',
                                            `creator` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建者',
                                            `create_time` datetime NOT NULL COMMENT '创建时间',
                                            `updater` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
                                            `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                                            `deleted` bit(1) DEFAULT b'0' COMMENT '是否删除',
                                            PRIMARY KEY (`id`),
                                            KEY `order_num_code` (`order_num_code`) USING BTREE,
                                            KEY `idx_order_id` (`order_id`),
                                            KEY `idx_shipment_order_id` (`shipment_id`,`order_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=42491 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='理货和合包标签表';

INSERT INTO `jiedao`.`system_dict_data`(`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`) VALUES (2751, 30, '业绩明细导出', '30', 'download_type', 0, 'default', '', '业绩明细导出', '115', '2024-01-28 09:43:42', '115', '2024-01-28 09:43:42', b'0', 'Performance Detail Export');



-- 添加菜单

SET FOREIGN_KEY_CHECKS = 0;

INSERT INTO `jiedao`.`system_menu` (`id`, `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 (2302, '全部路线列表', '', 2, 23, 1568, 'all-routes', 'row', 'ecw/offer/all-routes-list', 0, '115', '2023-12-25 21:11:55', '115', '2024-01-01 20:12:01', b'0', b'1', 'q', b'0', NULL, NULL);

INSERT INTO `jiedao`.`system_menu` (`id`, `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 (2303, '渠道列表详情', '', 2, 24, 1515, 'channel-route', '#', 'ecw/offer/channel-route', 0, '122', '2023-12-27 22:54:11', '122', '2023-12-31 17:35:26', b'0', b'0', 'Channel List Details', b'0', NULL, NULL);

INSERT INTO `jiedao`.`system_menu` (`id`, `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 (2304, '路线重量超限异常', 'ecw:exception:lineWeightException', 3, 29, 1629, '', '', '', 0, '115', '2023-12-29 11:30:46', '115', '2024-01-09 13:21:04', b'0', b'1', 'line weight exception', b'0', NULL, NULL);

INSERT INTO `jiedao`.`system_menu` (`id`, `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 (2305, '查看渠道详情', '', 2, 25, 1515, 'view_channel', '#', 'ecw/channel/edit', 0, '115', '2024-01-21 14:56:04', '115', '2024-01-21 14:57:10', b'0', b'0', 'View channel details', b'0', NULL, NULL);

INSERT INTO `jiedao`.`system_menu` (`id`, `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 (2306, '查看渠道详情', 'ecw:channel:view', 3, 3, 1887, '', '', '', 0, '115', '2024-01-21 15:08:38', '115', '2024-01-21 15:08:38', b'0', b'1', 'View channels', b'0', NULL, NULL);

UPDATE `jiedao`.`system_menu` SET `name` = '创建待分配客户', `permission` = 'ecw:customer:create', `menu_type` = 3, `sort` = 2, `parent_id` = 1425, `path` = '', `icon` = '', `component` = '', `status` = 0, `creator` = '', `create_time` = '2022-05-26 20:19:48', `updater` = '1', `update_time` = '2023-12-07 17:41:32', `deleted` = b'0', `is_show_in_menu_bar` = b'1', `name_en` = 'Customer Creation', `keepalive` = b'0', `redirect` = NULL, `badge_field` = NULL WHERE `id` = 1427;

UPDATE `jiedao`.`system_menu` SET `name` = '编辑渠道', `permission` = '', `menu_type` = 2, `sort` = 11, `parent_id` = 1515, `path` = 'edit_channel', `icon` = 'button', `component` = 'ecw/channel/edit', `status` = 0, `creator` = '119', `create_time` = '2022-06-11 22:57:55', `updater` = '115', `update_time` = '2024-01-21 14:56:49', `deleted` = b'0', `is_show_in_menu_bar` = b'0', `name_en` = 'Edit Channel', `keepalive` = b'0', `redirect` = NULL, `badge_field` = NULL WHERE `id` = 1466;

UPDATE `jiedao`.`system_menu` SET `name` = '部门业绩目标', `permission` = '', `menu_type` = 2, `sort` = 21, `parent_id` = 1515, `path` = 'dept-target', `icon` = 'druid', `component` = 'ecw/deptTarget/index', `status` = 0, `creator` = '', `create_time` = '2022-07-31 18:47:31', `updater` = '115', `update_time` = '2024-01-14 16:18:19', `deleted` = b'0', `is_show_in_menu_bar` = b'1', `name_en` = 'Department performance management', `keepalive` = b'0', `redirect` = NULL, `badge_field` = NULL WHERE `id` = 1648;

UPDATE `jiedao`.`system_menu` SET `name` = '导出所选', `permission` = 'ecw:order:stockingList:export_selected', `menu_type` = 3, `sort` = 1, `parent_id` = 2225, `path` = '', `icon` = '', `component` = '', `status` = 0, `creator` = '119', `create_time` = '2023-05-29 00:35:09', `updater` = '115', `update_time` = '2023-12-01 20:13:33', `deleted` = b'0', `is_show_in_menu_bar` = b'1', `name_en` = 'Export Selected', `keepalive` = b'0', `redirect` = NULL, `badge_field` = NULL WHERE `id` = 2226;

UPDATE `jiedao`.`system_menu` SET `name` = '导出搜索', `permission` = 'ecw:order:stockingList:export_search', `menu_type` = 3, `sort` = 1, `parent_id` = 2225, `path` = '', `icon` = '', `component` = '', `status` = 0, `creator` = '119', `create_time` = '2023-05-29 00:35:30', `updater` = '115', `update_time` = '2023-12-01 20:13:39', `deleted` = b'0', `is_show_in_menu_bar` = b'1', `name_en` = 'Export Search', `keepalive` = b'0', `redirect` = NULL, `badge_field` = NULL WHERE `id` = 2227;

UPDATE `jiedao`.`system_menu` SET `name` = '备货权限', `permission` = 'ecw:order:stockingList:stocking', `menu_type` = 3, `sort` = 1, `parent_id` = 2225, `path` = '', `icon` = '', `component` = '', `status` = 0, `creator` = '119', `create_time` = '2023-05-29 00:36:15', `updater` = '115', `update_time` = '2023-12-01 20:13:46', `deleted` = b'0', `is_show_in_menu_bar` = b'1', `name_en` = 'Stocking', `keepalive` = b'0', `redirect` = NULL, `badge_field` = NULL WHERE `id` = 2228;

UPDATE `jiedao`.`system_menu` SET `name` = '打印标签', `permission` = 'ecw:order:stockingList:print_tag', `menu_type` = 3, `sort` = 1, `parent_id` = 2225, `path` = '', `icon` = '', `component` = '', `status` = 0, `creator` = '119', `create_time` = '2023-05-29 00:37:00', `updater` = '115', `update_time` = '2023-12-01 20:13:51', `deleted` = b'0', `is_show_in_menu_bar` = b'1', `name_en` = 'Print Tag', `keepalive` = b'0', `redirect` = NULL, `badge_field` = NULL WHERE `id` = 2229;

UPDATE `jiedao`.`system_menu` SET `name` = '批量修改空运价格', `permission` = '', `menu_type` = 2, `sort` = 2, `parent_id` = 1568, `path` = 'batch-edit-air', `icon` = 'guide', `component` = 'ecw/productPrice/batchEditAir', `status` = 0, `creator` = '115', `create_time` = '2023-05-31 22:34:29', `updater` = '115', `update_time` = '2023-12-28 23:21:07', `deleted` = b'0', `is_show_in_menu_bar` = b'1', `name_en` = 'Batch Modify Air Route Price', `keepalive` = b'0', `redirect` = NULL, `badge_field` = NULL WHERE `id` = 2233;

UPDATE `jiedao`.`system_menu` SET `name` = '编辑空运价格', `permission` = '', `menu_type` = 2, `sort` = 3, `parent_id` = 1568, `path` = 'product-price/edit-air', `icon` = 'guide', `component` = 'ecw/productPrice/editAir', `status` = 0, `creator` = '115', `create_time` = '2023-06-01 10:52:55', `updater` = '115', `update_time` = '2023-12-27 22:27:36', `deleted` = b'0', `is_show_in_menu_bar` = b'1', `name_en` = 'Edit Air Route Price', `keepalive` = b'0', `redirect` = NULL, `badge_field` = NULL WHERE `id` = 2237;

UPDATE `jiedao`.`system_menu` SET `name` = '空运批量加价', `permission` = '', `menu_type` = 2, `sort` = 0, `parent_id` = 1568, `path` = 'batch-increase-air', `icon` = 'checkbox', `component` = 'ecw/productPrice/batchIncreaseAir', `status` = 0, `creator` = '115', `create_time` = '2023-09-26 23:31:01', `updater` = '115', `update_time` = '2023-12-30 15:34:50', `deleted` = b'0', `is_show_in_menu_bar` = b'1', `name_en` = 'Batch Increase', `keepalive` = b'0', `redirect` = NULL, `badge_field` = NULL WHERE `id` = 2275;

UPDATE `jiedao`.`system_menu` SET `name` = '回收客户', `permission` = 'ecw:customer:treat-recovery', `menu_type` = 3, `sort` = 17, `parent_id` = 1425, `path` = '', `icon` = '', `component` = '', `status` = 0, `creator` = '122', `create_time` = '2023-10-22 23:44:16', `updater` = '115', `update_time` = '2023-12-08 10:43:55', `deleted` = b'0', `is_show_in_menu_bar` = b'1', `name_en` = 'recovery', `keepalive` = b'0', `redirect` = NULL, `badge_field` = NULL WHERE `id` = 2283;

-- 字典类型修改

UPDATE `jiedao`.`system_dict_type` SET `name` = '清关费重量上限', `type` = 'custom _clearance', `status` = 0, `remark` = NULL, `creator` = '122', `create_time` = '2023-10-24 20:01:59', `updater` = '122', `update_time` = '2024-01-10 10:22:04', `deleted` = b'0' WHERE `id` = 420;

UPDATE `jiedao`.`system_dict_type` SET `name` = '路线重量超限异常处理结果', `type` = 'line_weight_exception_result', `status` = 0, `remark` = NULL, `creator` = '1', `create_time` = '2023-12-28 22:23:09', `updater` = '1', `update_time` = '2023-12-28 22:23:09', `deleted` = b'0' WHERE `id` = 426;


SET FOREIGN_KEY_CHECKS = 1;


-- 2024-01-29 zhengYi 未报价相关异常信息补充商品id值做唯一判断
alter table ecw_order_exception add column `prod_id` bigint DEFAULT NULL COMMENT '商品ID';

-- 2024-01-31 yanghao 订单项表快递单号长度修改为2048
alter table ecw_order_item modify column express_no varchar(2048) default null COMMENT '快递单号';

-- 2024-02-26 yanghao 更新客户操作日志类型
INSERT INTO `system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`)
VALUES (NULL, 16, '客户移交审批', '16', 'customer_operate_type', 0, 'default', '', NULL, '1', '2022-11-18 00:18:34', '1', '2023-01-15 18:09:43', b'0', 'customer transfer apply approve');
INSERT INTO `system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`)
VALUES (NULL, 20, '修改客户经理下成交客户的业绩类型', '20', 'customer_operate_type', 0, 'default', '', NULL, '1', '2022-11-18 00:18:34', '1', '2023-01-15 18:09:43', b'0', 'update deal customer to old by customer service');
INSERT INTO `system_dict_data` (`id`, `sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`)
VALUES (NULL, 21, '修改客户业绩类型', '21', 'customer_operate_type', 0, 'default', '', NULL, '1', '2022-11-18 00:18:34', '1', '2023-01-15 18:09:43', b'0', 'update customer new/old');





-- 线路补充模板标题字段设置 2024-03-23 zhengyi
alter table ecw_warehouse_line add column `temp_title_en` varchar(200) default NULL COMMENT '模版标题英文';
alter table ecw_warehouse_line add column `temp_title_zh` varchar(200) default NULL COMMENT '模版标题中文';