-- 补充跟进字典
INSERT INTO `system_dict_type`(`name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES ( '销售阶段', 'sale_stage', 0, '销售阶段', '2702', '2024-11-26 18:32:06', '2702', '2024-11-26 18:32:06', 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 (14, '达到承诺（协议客户适用）', '14', 'sale_stage', 0, 'default', '', '达到承诺（协议客户适用）', '2702', '2024-11-26 18:51:41', '2702', '2024-11-26 18:51:41', b'0', 'Fulfill commitments (applicable to agreement clients)');
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 (13, '未来机会（三个月）', '13', 'sale_stage', 0, 'default', '', '未来机会（三个月）', '2702', '2024-11-26 18:51:10', '2702', '2024-11-26 18:51:10', b'0', 'Future Opportunities (Three Months)');
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 (12, '输单', '12', 'sale_stage', 0, 'default', '', '输单', '2702', '2024-11-26 18:50:47', '2702', '2024-11-26 18:50:47', b'0', 'Single loss');
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 (11, '赢单', '11', 'sale_stage', 0, 'default', '', '赢单', '2702', '2024-11-26 18:50:22', '2702', '2024-11-26 18:50:22', b'0', 'Winning orders');
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 (10, '跟进货物入仓', '10', 'sale_stage', 0, 'default', '', '跟进货物入仓', '2702', '2024-11-26 18:50:00', '2702', '2024-11-26 18:50:00', b'0', 'Follow up on the goods entering the warehouse');
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 (9, '同意发货', '9', 'sale_stage', 0, 'default', '', '同意发货', '2702', '2024-11-26 18:49:14', '2702', '2024-11-26 18:49:14', b'0', 'Agree to ship');
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 (8, '维护拜访', '8', 'sale_stage', 0, 'default', '', '维护拜访', '2702', '2024-11-26 18:46:25', '2702', '2024-11-26 18:46:25', b'0', 'Maintenance visits');
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 (7, '特殊申请（优惠、服务）', '7', 'sale_stage', 0, 'default', '', '特殊申请（优惠、服务）', '2702', '2024-11-26 18:45:45', '2702', '2024-11-26 18:46:45', b'0', 'Special applications (discounts, services)');
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 (6, '潜力挖潜', '6', 'sale_stage', 0, 'default', '', '潜力挖潜', '2702', '2024-11-26 18:36:25', '2702', '2024-11-26 18:46:59', b'0', 'Potential tapping');
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 (5, '报价（给方案）', '5', 'sale_stage', 0, 'default', '', '报价（给方案）', '2702', '2024-11-26 18:36:02', '2702', '2024-11-26 18:47:15', b'0', 'Quotation (for proposal)');
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 (4, '复购跟进', '4', 'sale_stage', 0, 'default', '', '复购跟进', '2702', '2024-11-26 18:35:28', '2702', '2024-11-26 18:47:35', b'0', 'Follow up on repeat purchases');
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, '需求确认', '3', 'sale_stage', 0, 'default', '', '需求确认', '2702', '2024-11-26 18:35:13', '2702', '2024-11-26 18:48:09', b'0', 'Requirement Validate');
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, '新业务开发', '2', 'sale_stage', 0, 'default', '', '新业务开发', '2702', '2024-11-26 18:34:51', '2702', '2024-11-26 18:48:25', b'0', 'new business development');
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, '新询盘', '1', 'sale_stage', 0, 'default', '', '新询盘', '2702', '2024-11-26 18:34:26', '2702', '2024-11-26 18:48:39', b'0', 'New inquiry');

-- 补充跟进记录的销售阶段字段值
alter table ecw_customer_followup
    add COLUMN  `sale_stage` int DEFAULT NULL COMMENT '跟进销售阶段：详情看字典类型sale_stage' after `follow_type`;