-- 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 '模版标题中文';