/* Navicat Premium Data Transfer Source Server : jd-prod Source Server Type : MySQL Source Server Version : 80031 Source Host : 119.23.224.152:3306 Source Schema : jiedao Target Server Type : MySQL Target Server Version : 80031 File Encoding : 65001 Date: 11/12/2022 20:33:20 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for system_dict_data -- ---------------------------- DROP TABLE IF EXISTS `system_dict_data`; CREATE TABLE `system_dict_data` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '字典编码', `sort` int NOT NULL DEFAULT '0' COMMENT '字典排序', `label` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '字典标签', `value` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '字典键值', `dict_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '字典类型', `status` tinyint NOT NULL DEFAULT '0' COMMENT '状态（0正常 1停用）', `color_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '颜色类型', `css_class` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'css 样式', `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_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 '是否删除', `label_en` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '字典标签英文', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=2042 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='字典数据表'; -- ---------------------------- -- Records of system_dict_data -- ---------------------------- BEGIN; INSERT INTO `system_dict_data` VALUES (1, 1, '男', '1', 'system_user_sex', 0, 'default', 'A', '性别男', 'admin', '2021-01-05 17:03:48', '115', '2022-05-24 22:52:11', b'0', 'male'); INSERT INTO `system_dict_data` VALUES (2, 2, '女', '2', 'system_user_sex', 0, 'success', '', '性别女', 'admin', '2021-01-05 17:03:48', '133', '2022-09-25 23:11:13', b'0', 'female'); INSERT INTO `system_dict_data` VALUES (8, 1, '正常', '1', 'infra_job_status', 0, 'success', '', '正常状态', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 19:33:38', b'0', NULL); INSERT INTO `system_dict_data` VALUES (9, 2, '暂停', '2', 'infra_job_status', 0, 'danger', '', '停用状态', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 19:33:45', b'0', NULL); INSERT INTO `system_dict_data` VALUES (12, 1, '系统内置', '1', 'infra_config_type', 0, 'danger', '', '参数类型 - 系统内置', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 19:06:02', b'0', NULL); INSERT INTO `system_dict_data` VALUES (13, 2, '自定义', '2', 'infra_config_type', 0, 'primary', '', '参数类型 - 自定义', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 19:06:07', b'0', NULL); INSERT INTO `system_dict_data` VALUES (14, 1, '通知', '1', 'system_notice_type', 0, 'success', '', '通知', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 13:05:57', b'0', NULL); INSERT INTO `system_dict_data` VALUES (15, 2, '公告', '2', 'system_notice_type', 0, 'info', '', '公告', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 13:06:01', b'0', NULL); INSERT INTO `system_dict_data` VALUES (16, 0, '其它', '0', 'system_operate_type', 0, 'default', '', '其它操作', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 09:32:46', b'0', NULL); INSERT INTO `system_dict_data` VALUES (17, 1, '查询', '1', 'system_operate_type', 0, 'info', '', '查询操作', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 09:33:16', b'0', NULL); INSERT INTO `system_dict_data` VALUES (18, 2, '新增', '2', 'system_operate_type', 0, 'primary', '', '新增操作', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 09:33:13', b'0', NULL); INSERT INTO `system_dict_data` VALUES (19, 3, '修改', '3', 'system_operate_type', 0, 'warning', '', '修改操作', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 09:33:22', b'0', NULL); INSERT INTO `system_dict_data` VALUES (20, 4, '删除', '4', 'system_operate_type', 0, 'danger', '', '删除操作', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 09:33:27', b'0', NULL); INSERT INTO `system_dict_data` VALUES (22, 5, '导出', '5', 'system_operate_type', 0, 'default', '', '导出操作', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 09:33:32', b'0', NULL); INSERT INTO `system_dict_data` VALUES (23, 6, '导入', '6', 'system_operate_type', 0, 'default', '', '导入操作', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 09:33:35', b'0', NULL); INSERT INTO `system_dict_data` VALUES (27, 1, '开启', '0', 'common_status', 0, 'primary', '', '开启状态', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 08:00:39', b'0', NULL); INSERT INTO `system_dict_data` VALUES (28, 2, '关闭', '1', 'common_status', 0, 'info', '', '关闭状态', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 08:00:44', b'0', NULL); INSERT INTO `system_dict_data` VALUES (29, 1, '目录', '1', 'system_menu_type', 0, '', '', '目录', 'admin', '2021-01-05 17:03:48', '', '2022-02-01 16:43:45', b'0', NULL); INSERT INTO `system_dict_data` VALUES (30, 2, '菜单', '2', 'system_menu_type', 0, '', '', '菜单', 'admin', '2021-01-05 17:03:48', '', '2022-02-01 16:43:41', b'0', NULL); INSERT INTO `system_dict_data` VALUES (31, 3, '按钮', '3', 'system_menu_type', 0, '', '', '按钮', 'admin', '2021-01-05 17:03:48', '', '2022-02-01 16:43:39', b'0', NULL); INSERT INTO `system_dict_data` VALUES (32, 1, '内置', '1', 'system_role_type', 0, 'danger', '', '内置角色', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 13:02:08', b'0', NULL); INSERT INTO `system_dict_data` VALUES (33, 2, '自定义', '2', 'system_role_type', 0, 'primary', '', '自定义角色', 'admin', '2021-01-05 17:03:48', '1', '2022-02-16 13:02:12', b'0', NULL); INSERT INTO `system_dict_data` VALUES (34, 1, '全部数据权限', '1', 'system_data_scope', 0, '', '', '全部数据权限', 'admin', '2021-01-05 17:03:48', '', '2022-02-01 16:47:17', b'0', NULL); INSERT INTO `system_dict_data` VALUES (35, 2, '指定部门数据权限', '2', 'system_data_scope', 0, '', '', '指定部门数据权限', 'admin', '2021-01-05 17:03:48', '', '2022-02-01 16:47:18', b'0', NULL); INSERT INTO `system_dict_data` VALUES (36, 3, '本部门数据权限', '3', 'system_data_scope', 0, '', '', '本部门数据权限', 'admin', '2021-01-05 17:03:48', '', '2022-02-01 16:47:16', b'0', NULL); INSERT INTO `system_dict_data` VALUES (37, 4, '本部门及以下数据权限', '4', 'system_data_scope', 0, '', '', '本部门及以下数据权限', 'admin', '2021-01-05 17:03:48', '', '2022-02-01 16:47:21', b'0', NULL); INSERT INTO `system_dict_data` VALUES (38, 5, '仅本人数据权限', '5', 'system_data_scope', 0, '', '', '仅本人数据权限', 'admin', '2021-01-05 17:03:48', '', '2022-02-01 16:47:23', b'0', NULL); INSERT INTO `system_dict_data` VALUES (39, 0, '成功', '0', 'system_login_result', 0, 'success', '', '登陆结果 - 成功', '', '2021-01-18 06:17:36', '1', '2022-02-16 13:23:49', b'0', NULL); INSERT INTO `system_dict_data` VALUES (40, 10, '账号或密码不正确', '10', 'system_login_result', 0, 'primary', '', '登陆结果 - 账号或密码不正确', '', '2021-01-18 06:17:54', '1', '2022-02-16 13:24:27', b'0', NULL); INSERT INTO `system_dict_data` VALUES (41, 20, '用户被禁用', '20', 'system_login_result', 0, 'warning', '', '登陆结果 - 用户被禁用', '', '2021-01-18 06:17:54', '1', '2022-02-16 13:23:57', b'0', NULL); INSERT INTO `system_dict_data` VALUES (42, 30, '验证码不存在', '30', 'system_login_result', 0, 'info', '', '登陆结果 - 验证码不存在', '', '2021-01-18 06:17:54', '1', '2022-02-16 13:24:07', b'0', NULL); INSERT INTO `system_dict_data` VALUES (43, 31, '验证码不正确', '31', 'system_login_result', 0, 'info', '', '登陆结果 - 验证码不正确', '', '2021-01-18 06:17:54', '1', '2022-02-16 13:24:11', b'0', NULL); INSERT INTO `system_dict_data` VALUES (44, 100, '未知异常', '100', 'system_login_result', 0, 'danger', '', '登陆结果 - 未知异常', '', '2021-01-18 06:17:54', '1', '2022-02-16 13:24:23', b'0', NULL); INSERT INTO `system_dict_data` VALUES (45, 1, '是', 'true', 'infra_boolean_string', 0, 'danger', '', 'Boolean 是否类型 - 是', '', '2021-01-19 03:20:55', '1', '2022-03-15 23:01:45', b'0', NULL); INSERT INTO `system_dict_data` VALUES (46, 1, '否', 'false', 'infra_boolean_string', 0, 'info', '', 'Boolean 是否类型 - 否', '', '2021-01-19 03:20:55', '1', '2022-03-15 23:09:45', b'0', NULL); INSERT INTO `system_dict_data` VALUES (47, 1, '永不超时', '1', 'infra_redis_timeout_type', 0, 'primary', '', 'Redis 未设置超时的情况', '', '2021-01-26 00:53:17', '1', '2022-02-16 19:03:35', b'0', NULL); INSERT INTO `system_dict_data` VALUES (48, 1, '动态超时', '2', 'infra_redis_timeout_type', 0, 'info', '', '程序里动态传入超时时间，无法固定', '', '2021-01-26 00:55:00', '1', '2022-02-16 19:03:41', b'0', NULL); INSERT INTO `system_dict_data` VALUES (49, 3, '固定超时', '3', 'infra_redis_timeout_type', 0, 'success', '', 'Redis 设置了过期时间', '', '2021-01-26 00:55:26', '1', '2022-02-16 19:03:45', b'0', NULL); INSERT INTO `system_dict_data` VALUES (50, 1, '单表（增删改查）', '1', 'infra_codegen_template_type', 0, '', '', NULL, '', '2021-02-05 07:09:06', '', '2022-03-10 16:33:15', b'0', NULL); INSERT INTO `system_dict_data` VALUES (51, 2, '树表（增删改查）', '2', 'infra_codegen_template_type', 0, '', '', NULL, '', '2021-02-05 07:14:46', '', '2022-03-10 16:33:19', b'0', NULL); INSERT INTO `system_dict_data` VALUES (52, 3, '主子表（增删改查）', '3', 'infra_codegen_template_type', 0, '', '', NULL, '', '2021-02-05 07:21:45', '', '2022-03-10 16:33:09', b'1', NULL); INSERT INTO `system_dict_data` VALUES (53, 0, '初始化中', '0', 'infra_job_status', 0, 'primary', '', NULL, '', '2021-02-07 07:46:49', '1', '2022-02-16 19:33:29', b'0', NULL); INSERT INTO `system_dict_data` VALUES (57, 0, '运行中', '0', 'infra_job_log_status', 0, 'primary', '', 'RUNNING', '', '2021-02-08 10:04:24', '1', '2022-02-16 19:07:48', b'0', NULL); INSERT INTO `system_dict_data` VALUES (58, 1, '成功', '1', 'infra_job_log_status', 0, 'success', '', NULL, '', '2021-02-08 10:06:57', '1', '2022-02-16 19:07:52', b'0', NULL); INSERT INTO `system_dict_data` VALUES (59, 2, '失败', '2', 'infra_job_log_status', 0, 'warning', '', '失败', '', '2021-02-08 10:07:38', '1', '2022-02-16 19:07:56', b'0', NULL); INSERT INTO `system_dict_data` VALUES (60, 1, '会员', '1', 'user_type', 0, 'primary', '', NULL, '', '2021-02-26 00:16:27', '1', '2022-02-16 10:22:19', b'0', NULL); INSERT INTO `system_dict_data` VALUES (61, 2, '管理员', '2', 'user_type', 0, 'success', '', NULL, '', '2021-02-26 00:16:34', '1', '2022-02-16 10:22:22', b'0', NULL); INSERT INTO `system_dict_data` VALUES (62, 0, '未处理', '0', 'infra_api_error_log_process_status', 0, 'primary', '', NULL, '', '2021-02-26 07:07:19', '1', '2022-02-16 20:14:17', b'0', NULL); INSERT INTO `system_dict_data` VALUES (63, 1, '已处理', '1', 'infra_api_error_log_process_status', 0, 'success', '', NULL, '', '2021-02-26 07:07:26', '1', '2022-02-16 20:14:08', b'0', NULL); INSERT INTO `system_dict_data` VALUES (64, 2, '已忽略', '2', 'infra_api_error_log_process_status', 0, 'danger', '', NULL, '', '2021-02-26 07:07:34', '1', '2022-02-16 20:14:14', b'0', NULL); INSERT INTO `system_dict_data` VALUES (65, 1, '云片', 'YUN_PIAN', 'system_sms_channel_code', 0, 'success', '', NULL, '1', '2021-04-05 01:05:14', '1', '2022-02-16 10:09:55', b'0', NULL); INSERT INTO `system_dict_data` VALUES (66, 2, '阿里云', 'ALIYUN', 'system_sms_channel_code', 0, 'primary', '', NULL, '1', '2021-04-05 01:05:26', '1', '2022-02-16 10:09:52', b'0', NULL); INSERT INTO `system_dict_data` VALUES (67, 1, '验证码', '1', 'system_sms_template_type', 0, 'warning', '', NULL, '1', '2021-04-05 21:50:57', '1', '2022-02-16 12:48:30', b'0', NULL); INSERT INTO `system_dict_data` VALUES (68, 2, '通知', '2', 'system_sms_template_type', 0, 'primary', '', NULL, '1', '2021-04-05 21:51:08', '1', '2022-02-16 12:48:27', b'0', NULL); INSERT INTO `system_dict_data` VALUES (69, 0, '营销', '3', 'system_sms_template_type', 0, 'danger', '', NULL, '1', '2021-04-05 21:51:15', '1', '2022-02-16 12:48:22', b'0', NULL); INSERT INTO `system_dict_data` VALUES (70, 0, '初始化', '0', 'system_sms_send_status', 0, 'primary', '', NULL, '1', '2021-04-11 20:18:33', '1', '2022-02-16 10:26:07', b'0', NULL); INSERT INTO `system_dict_data` VALUES (71, 1, '发送成功', '10', 'system_sms_send_status', 0, 'success', '', NULL, '1', '2021-04-11 20:18:43', '1', '2022-02-16 10:25:56', b'0', NULL); INSERT INTO `system_dict_data` VALUES (72, 2, '发送失败', '20', 'system_sms_send_status', 0, 'danger', '', NULL, '1', '2021-04-11 20:18:49', '1', '2022-02-16 10:26:03', b'0', NULL); INSERT INTO `system_dict_data` VALUES (73, 3, '不发送', '30', 'system_sms_send_status', 0, 'info', '', NULL, '1', '2021-04-11 20:19:44', '1', '2022-02-16 10:26:10', b'0', NULL); INSERT INTO `system_dict_data` VALUES (74, 0, '等待结果', '0', 'system_sms_receive_status', 0, 'primary', '', NULL, '1', '2021-04-11 20:27:43', '1', '2022-02-16 10:28:24', b'0', NULL); INSERT INTO `system_dict_data` VALUES (75, 1, '接收成功', '10', 'system_sms_receive_status', 0, 'success', '', NULL, '1', '2021-04-11 20:29:25', '1', '2022-02-16 10:28:28', b'0', NULL); INSERT INTO `system_dict_data` VALUES (76, 2, '接收失败', '20', 'system_sms_receive_status', 0, 'danger', '', NULL, '1', '2021-04-11 20:29:31', '1', '2022-02-16 10:28:32', b'0', NULL); INSERT INTO `system_dict_data` VALUES (77, 0, '调试(钉钉)', 'DEBUG_DING_TALK', 'system_sms_channel_code', 0, 'info', '', NULL, '1', '2021-04-13 00:20:37', '1', '2022-02-16 10:10:00', b'0', NULL); INSERT INTO `system_dict_data` VALUES (78, 1, '自动生成', '1', 'system_error_code_type', 0, 'warning', '', NULL, '1', '2021-04-21 00:06:48', '1', '2022-02-16 13:57:20', b'0', NULL); INSERT INTO `system_dict_data` VALUES (79, 2, '手动编辑', '2', 'system_error_code_type', 0, 'primary', '', NULL, '1', '2021-04-21 00:07:14', '1', '2022-02-16 13:57:24', b'0', NULL); INSERT INTO `system_dict_data` VALUES (80, 100, '账号登录', '100', 'system_login_type', 0, 'primary', '', '账号登录', '1', '2021-10-06 00:52:02', '1', '2022-02-16 13:11:34', b'0', NULL); INSERT INTO `system_dict_data` VALUES (81, 101, '社交登录', '101', 'system_login_type', 0, 'info', '', '社交登录', '1', '2021-10-06 00:52:17', '1', '2022-02-16 13:11:40', b'0', NULL); INSERT INTO `system_dict_data` VALUES (82, 102, 'Mock 登录', '102', 'system_login_type', 0, 'danger', '', 'Mock 登录', '1', '2021-10-06 00:52:32', '1', '2022-02-16 13:11:44', b'0', NULL); INSERT INTO `system_dict_data` VALUES (83, 200, '主动登出', '200', 'system_login_type', 0, 'primary', '', '主动登出', '1', '2021-10-06 00:52:58', '1', '2022-02-16 13:11:49', b'0', NULL); INSERT INTO `system_dict_data` VALUES (84, 201, '超时登出', '201', 'system_login_type', 0, 'info', '', '超时登出', '1', '2021-10-06 00:53:17', '1', '2022-02-16 13:11:53', b'0', NULL); INSERT INTO `system_dict_data` VALUES (85, 202, '强制登出', '202', 'system_login_type', 0, 'danger', '', '强制退出', '1', '2021-10-06 00:53:41', '1', '2022-02-16 13:11:57', b'0', NULL); INSERT INTO `system_dict_data` VALUES (86, 0, '病假', '1', 'bpm_oa_leave_type', 0, 'primary', '', NULL, '1', '2021-09-21 22:35:28', '1', '2022-02-16 10:00:41', b'0', NULL); INSERT INTO `system_dict_data` VALUES (87, 1, '事假', '2', 'bpm_oa_leave_type', 0, 'info', '', NULL, '1', '2021-09-21 22:36:11', '1', '2022-02-16 10:00:49', b'0', NULL); INSERT INTO `system_dict_data` VALUES (88, 2, '婚假', '3', 'bpm_oa_leave_type', 0, 'warning', '', NULL, '1', '2021-09-21 22:36:38', '1', '2022-02-16 10:00:53', b'0', NULL); INSERT INTO `system_dict_data` VALUES (98, 1, 'v2', 'v2', 'pay_channel_wechat_version', 0, '', '', 'v2版本', '1', '2021-11-08 17:00:58', '1', '2021-11-08 17:00:58', b'0', NULL); INSERT INTO `system_dict_data` VALUES (99, 2, 'v3', 'v3', 'pay_channel_wechat_version', 0, '', '', 'v3版本', '1', '2021-11-08 17:01:07', '1', '2021-11-08 17:01:07', b'0', NULL); INSERT INTO `system_dict_data` VALUES (108, 1, 'RSA2', 'RSA2', 'pay_channel_alipay_sign_type', 0, '', '', 'RSA2', '1', '2021-11-18 15:39:29', '1', '2021-11-18 15:39:29', b'0', NULL); INSERT INTO `system_dict_data` VALUES (109, 1, '公钥模式', '1', 'pay_channel_alipay_mode', 0, '', '', '公钥模式：privateKey + alipayPublicKey', '1', '2021-11-18 15:45:23', '1', '2021-11-18 15:45:23', b'0', NULL); INSERT INTO `system_dict_data` VALUES (110, 2, '证书模式', '2', 'pay_channel_alipay_mode', 0, '', '', '证书模式：appCertContent + alipayPublicCertContent + rootCertContent', '1', '2021-11-18 15:45:40', '1', '2021-11-18 15:45:40', b'0', NULL); INSERT INTO `system_dict_data` VALUES (111, 1, '线上', 'https://openapi.alipay.com/gateway.do', 'pay_channel_alipay_server_type', 0, '', '', '网关地址 - 线上', '1', '2021-11-18 16:59:32', '1', '2021-11-21 17:37:29', b'0', NULL); INSERT INTO `system_dict_data` VALUES (112, 2, '沙箱', 'https://openapi.alipaydev.com/gateway.do', 'pay_channel_alipay_server_type', 0, '', '', '网关地址 - 沙箱', '1', '2021-11-18 16:59:48', '1', '2021-11-21 17:37:39', b'0', NULL); INSERT INTO `system_dict_data` VALUES (113, 1, '微信 JSAPI 支付', 'wx_pub', 'pay_channel_code_type', 0, '', '', '微信 JSAPI（公众号） 支付', '1', '2021-12-03 10:40:24', '1', '2021-12-04 16:41:00', b'0', NULL); INSERT INTO `system_dict_data` VALUES (114, 2, '微信小程序支付', 'wx_lite', 'pay_channel_code_type', 0, '', '', '微信小程序支付', '1', '2021-12-03 10:41:06', '1', '2021-12-03 10:41:06', b'0', NULL); INSERT INTO `system_dict_data` VALUES (115, 3, '微信 App 支付', 'wx_app', 'pay_channel_code_type', 0, '', '', '微信 App 支付', '1', '2021-12-03 10:41:20', '1', '2021-12-03 10:41:20', b'0', NULL); INSERT INTO `system_dict_data` VALUES (116, 4, '支付宝 PC 网站支付', 'alipay_pc', 'pay_channel_code_type', 0, '', '', '支付宝 PC 网站支付', '1', '2021-12-03 10:42:09', '1', '2021-12-03 10:42:09', b'0', NULL); INSERT INTO `system_dict_data` VALUES (117, 5, '支付宝 Wap 网站支付', 'alipay_wap', 'pay_channel_code_type', 0, '', '', '支付宝 Wap 网站支付', '1', '2021-12-03 10:42:26', '1', '2021-12-03 10:42:26', b'0', NULL); INSERT INTO `system_dict_data` VALUES (118, 6, '支付宝App 支付', 'alipay_app', 'pay_channel_code_type', 0, '', '', '支付宝App 支付', '1', '2021-12-03 10:42:55', '1', '2021-12-03 10:42:55', b'0', NULL); INSERT INTO `system_dict_data` VALUES (119, 7, '支付宝扫码支付', 'alipay_qr', 'pay_channel_code_type', 0, '', '', '支付宝扫码支付', '1', '2021-12-03 10:43:10', '1', '2021-12-03 10:43:10', b'0', NULL); INSERT INTO `system_dict_data` VALUES (120, 1, '通知成功', '10', 'pay_order_notify_status', 0, 'success', '', '通知成功', '1', '2021-12-03 11:02:41', '1', '2022-02-16 13:59:13', b'0', NULL); INSERT INTO `system_dict_data` VALUES (121, 2, '通知失败', '20', 'pay_order_notify_status', 0, 'danger', '', '通知失败', '1', '2021-12-03 11:02:59', '1', '2022-02-16 13:59:17', b'0', NULL); INSERT INTO `system_dict_data` VALUES (122, 3, '未通知', '0', 'pay_order_notify_status', 0, 'info', '', '未通知', '1', '2021-12-03 11:03:10', '1', '2022-02-16 13:59:23', b'0', NULL); INSERT INTO `system_dict_data` VALUES (123, 1, '支付成功', '10', 'pay_order_status', 0, 'success', '', '支付成功', '1', '2021-12-03 11:18:29', '1', '2022-02-16 15:24:25', b'0', NULL); INSERT INTO `system_dict_data` VALUES (124, 2, '支付关闭', '20', 'pay_order_status', 0, 'danger', '', '支付关闭', '1', '2021-12-03 11:18:42', '1', '2022-02-16 15:24:31', b'0', NULL); INSERT INTO `system_dict_data` VALUES (125, 3, '未支付', '0', 'pay_order_status', 0, 'info', '', '未支付', '1', '2021-12-03 11:18:18', '1', '2022-02-16 15:24:35', b'0', NULL); INSERT INTO `system_dict_data` VALUES (126, 1, '未退款', '0', 'pay_order_refund_status', 0, '', '', '未退款', '1', '2021-12-03 11:30:35', '1', '2021-12-03 11:34:05', b'0', NULL); INSERT INTO `system_dict_data` VALUES (127, 2, '部分退款', '10', 'pay_order_refund_status', 0, '', '', '部分退款', '1', '2021-12-03 11:30:44', '1', '2021-12-03 11:34:10', b'0', NULL); INSERT INTO `system_dict_data` VALUES (128, 3, '全部退款', '20', 'pay_order_refund_status', 0, '', '', '全部退款', '1', '2021-12-03 11:30:52', '1', '2021-12-03 11:34:14', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1117, 1, '退款订单生成', '0', 'pay_refund_order_status', 0, 'primary', '', '退款订单生成', '1', '2021-12-10 16:44:44', '1', '2022-02-16 14:05:24', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1118, 2, '退款成功', '1', 'pay_refund_order_status', 0, 'success', '', '退款成功', '1', '2021-12-10 16:44:59', '1', '2022-02-16 14:05:28', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1119, 3, '退款失败', '2', 'pay_refund_order_status', 0, 'danger', '', '退款失败', '1', '2021-12-10 16:45:10', '1', '2022-02-16 14:05:34', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1120, 4, '退款中, 渠道通知结果', '3', 'pay_refund_order_status', 0, '', '', '退款中, 渠道通知结果', '1', '2021-12-10 16:45:32', '1', '2022-02-16 06:05:16', b'1', NULL); INSERT INTO `system_dict_data` VALUES (1121, 5, '退款中, 系统查询结果', '4', 'pay_refund_order_status', 0, '', '', '退款中, 系统查询结果', '1', '2021-12-10 16:45:48', '1', '2022-02-16 06:05:12', b'1', NULL); INSERT INTO `system_dict_data` VALUES (1122, 6, '状态未知，需要重试', '5', 'pay_refund_order_status', 0, '', '', '状态未知，需要重试', '1', '2021-12-10 16:46:03', '1', '2022-02-16 06:05:09', b'1', NULL); INSERT INTO `system_dict_data` VALUES (1123, 7, '状态未知，系统查询结果', '6', 'pay_refund_order_status', 0, '', '', '状态未知，系统查询结果', '1', '2021-12-10 16:46:13', '1', '2022-02-16 06:05:08', b'1', NULL); INSERT INTO `system_dict_data` VALUES (1124, 8, '退款关闭', '99', 'pay_refund_order_status', 0, 'info', '', '退款关闭', '1', '2021-12-10 16:46:26', '1', '2022-02-16 14:05:40', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1125, 0, '默认', '1', 'bpm_model_category', 1, 'primary', '', '流程分类 - 默认', '1', '2022-01-02 08:41:11', '115', '2022-10-04 18:39:01', b'0', 'defalut'); INSERT INTO `system_dict_data` VALUES (1126, 0, 'OA', '2', 'bpm_model_category', 1, 'success', '', '流程分类 - OA', '1', '2022-01-02 08:41:22', '115', '2022-10-04 18:38:36', b'0', 'oa'); INSERT INTO `system_dict_data` VALUES (1127, 0, '进行中', '1', 'bpm_process_instance_status', 0, 'primary', '', '流程实例的状态 - 进行中', '1', '2022-01-07 23:47:22', '1', '2022-02-16 20:07:49', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1128, 2, '已完成', '2', 'bpm_process_instance_status', 0, 'success', '', '流程实例的状态 - 已完成', '1', '2022-01-07 23:47:49', '1', '2022-02-16 20:07:54', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1129, 1, '处理中', '1', 'bpm_process_instance_result', 0, 'primary', '', '流程实例的结果 - 处理中', '1', '2022-01-07 23:48:32', '1', '2022-02-16 09:53:26', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1130, 2, '通过', '2', 'bpm_process_instance_result', 0, 'success', '', '流程实例的结果 - 通过', '1', '2022-01-07 23:48:45', '1', '2022-02-16 09:53:31', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1131, 3, '不通过', '3', 'bpm_process_instance_result', 0, 'danger', '', '流程实例的结果 - 不通过', '1', '2022-01-07 23:48:55', '1', '2022-02-16 09:53:38', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1132, 4, '已取消', '4', 'bpm_process_instance_result', 0, 'info', '', '流程实例的结果 - 撤销', '1', '2022-01-07 23:49:06', '1', '2022-02-16 09:53:42', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1133, 10, '流程表单', '10', 'bpm_model_form_type', 0, '', '', '流程的表单类型 - 流程表单', '103', '2022-01-11 23:51:30', '103', '2022-01-11 23:51:30', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1134, 20, '业务表单', '20', 'bpm_model_form_type', 0, '', '', '流程的表单类型 - 业务表单', '103', '2022-01-11 23:51:47', '103', '2022-01-11 23:51:47', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1135, 10, '角色', '10', 'bpm_task_assign_rule_type', 0, 'info', '', '任务分配规则的类型 - 角色', '103', '2022-01-12 23:21:22', '1', '2022-02-16 20:06:14', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1136, 20, '部门的成员', '20', 'bpm_task_assign_rule_type', 0, 'primary', '', '任务分配规则的类型 - 部门的成员', '103', '2022-01-12 23:21:47', '1', '2022-02-16 20:05:28', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1137, 21, '部门的负责人', '21', 'bpm_task_assign_rule_type', 0, 'primary', '', '任务分配规则的类型 - 部门的负责人', '103', '2022-01-12 23:33:36', '1', '2022-02-16 20:05:31', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1138, 30, '用户', '30', 'bpm_task_assign_rule_type', 0, 'info', '', '任务分配规则的类型 - 用户', '103', '2022-01-12 23:34:02', '1', '2022-02-16 20:05:50', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1139, 40, '用户组', '40', 'bpm_task_assign_rule_type', 0, 'warning', '', '任务分配规则的类型 - 用户组', '103', '2022-01-12 23:34:21', '1', '2022-02-16 20:05:57', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1140, 50, '自定义脚本', '50', 'bpm_task_assign_rule_type', 0, 'danger', '', '任务分配规则的类型 - 自定义脚本', '103', '2022-01-12 23:34:43', '1', '2022-02-16 20:06:01', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1141, 22, '岗位', '22', 'bpm_task_assign_rule_type', 0, 'success', '', '任务分配规则的类型 - 岗位', '103', '2022-01-14 18:41:55', '1', '2022-02-16 20:05:39', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1142, 10, '流程发起人', '10', 'bpm_task_assign_script', 0, '', '', '任务分配自定义脚本 - 流程发起人', '103', '2022-01-15 00:10:57', '103', '2022-01-15 21:24:10', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1143, 20, '流程发起人的一级领导', '20', 'bpm_task_assign_script', 0, '', '', '任务分配自定义脚本 - 流程发起人的一级领导', '103', '2022-01-15 21:24:31', '103', '2022-01-15 21:24:31', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1144, 21, '流程发起人的二级领导', '21', 'bpm_task_assign_script', 0, '', '', '任务分配自定义脚本 - 流程发起人的二级领导', '103', '2022-01-15 21:24:46', '103', '2022-01-15 21:24:57', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1145, 1, '管理后台', '1', 'infra_codegen_scene', 0, '', '', '代码生成的场景枚举 - 管理后台', '1', '2022-02-02 13:15:06', '1', '2022-03-10 16:32:59', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1146, 2, '用户 APP', '2', 'infra_codegen_scene', 0, '', '', '代码生成的场景枚举 - 用户 APP', '1', '2022-02-02 13:15:19', '1', '2022-03-10 16:33:03', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1147, 0, '未退款', '0', 'pay_refund_order_type', 0, 'info', '', '退款类型 - 未退款', '1', '2022-02-16 14:09:01', '1', '2022-02-16 14:09:01', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1148, 10, '部分退款', '10', 'pay_refund_order_type', 0, 'success', '', '退款类型 - 部分退款', '1', '2022-02-16 14:09:25', '1', '2022-02-16 14:11:38', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1149, 20, '全部退款', '20', 'pay_refund_order_type', 0, 'warning', '', '退款类型 - 全部退款', '1', '2022-02-16 14:11:33', '1', '2022-02-16 14:11:33', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1150, 1, '数据库', '1', 'infra_file_storage', 0, 'default', '', NULL, '1', '2022-03-15 00:25:28', '1', '2022-03-15 00:25:28', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1151, 10, '本地磁盘', '10', 'infra_file_storage', 0, 'default', '', NULL, '1', '2022-03-15 00:25:41', '1', '2022-03-15 00:25:56', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1152, 11, 'FTP 服务器', '11', 'infra_file_storage', 0, 'default', '', NULL, '1', '2022-03-15 00:26:06', '1', '2022-03-15 00:26:10', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1153, 12, 'SFTP 服务器', '12', 'infra_file_storage', 0, 'default', '', NULL, '1', '2022-03-15 00:26:22', '1', '2022-03-15 00:26:22', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1154, 20, 'S3 对象存储', '20', 'infra_file_storage', 0, 'default', '', NULL, '1', '2022-03-15 00:26:31', '1', '2022-03-15 00:26:45', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1155, 1, '对私打款', '2', 'bank_type', 0, 'default', '', '对私打款', '1', '2022-05-09 13:14:12', '1', '2022-05-09 13:16:04', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1156, 0, '对公打款', '1', 'bank_type', 0, 'default', '', '对公打款', '1', '2022-05-09 13:15:16', '1', '2022-05-09 13:16:10', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1157, 0, '管理后台', 'adm', 'data_source', 0, 'default', '', NULL, '1', '2022-05-09 13:17:33', '1', '2022-05-09 13:17:33', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1158, 0, '官网WEB', 'web', 'data_source', 0, 'default', '', NULL, '1', '2022-05-09 13:17:51', '1', '2022-05-09 13:17:51', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1159, 0, '客户端ANDROID', 'userAndroid', 'data_source', 0, 'default', '', NULL, '1', '2022-05-09 13:18:20', '1', '2022-05-09 13:19:07', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1160, 0, '客户端ios', 'userIos', 'data_source', 0, 'default', '', NULL, '1', '2022-05-09 13:18:29', '1', '2022-05-09 13:19:15', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1161, 0, '仓管android', 'pdaAndroid', 'data_source', 0, 'default', '', NULL, '1', '2022-05-09 13:18:44', '1', '2022-05-09 13:18:44', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1162, 0, '仓管ios', 'pdaIos', 'data_source', 0, 'default', '', NULL, '1', '2022-05-09 13:18:56', '1', '2022-05-09 13:18:56', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1163, 0, '客户端APP', 'userApp', 'data_source', 0, 'default', '', '包含android、ios的跨平台', '1', '2022-05-09 13:20:04', '1', '2022-05-09 13:20:04', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1164, 0, '仓管APP', 'pdaApp', 'data_source', 0, 'default', '', '包含android、ios的混合App', '1', '2022-05-09 13:20:26', '1', '2022-05-09 13:20:26', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1165, 0, '进口', '1', 'region_trade_type', 0, 'default', '', NULL, '1', '2022-05-10 15:45:30', '1', '2022-05-10 15:46:50', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1166, 0, '出口', '2', 'region_trade_type', 0, 'default', '', NULL, '1', '2022-05-10 15:46:10', '1', '2022-05-10 15:46:52', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1167, 0, '进出口', '3', 'region_trade_type', 0, 'default', '', NULL, '1', '2022-05-10 15:46:29', '1', '2022-05-10 15:46:56', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1168, 0, '箱', 'package', 'packageType', 0, 'default', '', NULL, '1', '2022-05-10 16:54:24', '1', '2022-11-03 22:47:02', b'1', 'package'); INSERT INTO `system_dict_data` VALUES (1169, 0, '袋', 'bag', 'packageType', 0, 'default', '', NULL, '1', '2022-05-10 16:54:35', '1', '2022-11-03 22:47:04', b'1', 'bag'); INSERT INTO `system_dict_data` VALUES (1170, 0, '托', 'care', 'packageType', 0, 'default', '', NULL, '1', '2022-05-10 16:54:49', '1', '2022-11-03 22:47:06', b'1', 'care'); INSERT INTO `system_dict_data` VALUES (1171, 0, '木', 'wood', 'packageType', 0, 'default', '', NULL, '1', '2022-05-10 16:55:10', '1', '2022-11-03 22:47:07', b'1', 'wood'); INSERT INTO `system_dict_data` VALUES (1172, 0, '普货', 'ng', 'cargoType', 0, 'default', '', NULL, '1', '2022-05-10 17:18:11', '1', '2022-05-10 17:19:49', b'0', 'normal goods'); INSERT INTO `system_dict_data` VALUES (1173, 0, '轻泡货', 'lf', 'cargoType', 0, 'default', '', NULL, '1', '2022-05-10 17:18:56', '1', '2022-05-10 17:18:56', b'0', 'light foam'); INSERT INTO `system_dict_data` VALUES (1174, 0, '重泡货', 'rb', 'cargoType', 0, 'default', '', NULL, '1', '2022-05-10 17:19:12', '1', '2022-05-10 17:19:12', b'0', 'Re-bubble'); INSERT INTO `system_dict_data` VALUES (1175, 0, '重货', 'hc', 'cargoType', 0, 'default', '', NULL, '1', '2022-05-10 17:19:25', '1', '2022-05-10 17:19:25', b'0', 'Heavy cargo'); INSERT INTO `system_dict_data` VALUES (1176, 1, '初始化', '0', 'mail_send_status', 0, 'default', '', NULL, '1', '2022-05-11 11:21:22', '1', '2022-05-11 11:21:22', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1177, 2, '发送成功', '10', 'mail_send_status', 0, 'success', '', NULL, '1', '2022-05-11 11:21:54', '1', '2022-05-12 10:35:08', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1178, 3, '发送失败', '20', 'mail_send_status', 0, 'danger', '', NULL, '1', '2022-05-11 11:22:29', '1', '2022-05-12 10:27:43', b'1', NULL); INSERT INTO `system_dict_data` VALUES (1179, 4, '不发送', '30', 'mail_send_status', 0, 'default', '', NULL, '1', '2022-05-11 11:23:07', '1', '2022-05-11 11:23:07', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1180, 3, '发送失败', '20', 'mail_send_status', 0, 'danger', '', NULL, '1', '2022-05-12 10:35:50', '1', '2022-05-12 10:35:57', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1181, 1, '海运拼柜', '1', 'transport_type', 0, 'default', '', NULL, '1', '2022-05-12 16:01:32', '115', '2022-09-21 15:45:29', b'0', 'LCL by sea'); INSERT INTO `system_dict_data` VALUES (1182, 2, '海运整柜', '2', 'transport_type', 1, 'default', '', NULL, '1', '2022-05-12 16:02:01', '115', '2022-09-21 15:45:46', b'0', 'FCL by sea'); INSERT INTO `system_dict_data` VALUES (1183, 3, '专线空运', '3', 'transport_type', 1, 'default', 'channel', '根据cssClass是否显示”channel“来判断，是否显示出货渠道，为空不显示', '1', '2022-05-12 16:02:48', '115', '2022-09-21 15:45:43', b'0', 'Air Cargo'); INSERT INTO `system_dict_data` VALUES (1184, 11, '专线双清', '11', 'transport_type', 1, 'default', '', '从提供服务字典中取', '1', '2022-05-12 16:03:08', '115', '2022-05-17 11:19:35', b'1', NULL); INSERT INTO `system_dict_data` VALUES (1185, 12, '全境派送', '12', 'transport_type', 1, 'default', '', '从提供服务字典中取', '1', '2022-05-12 16:03:31', '115', '2022-05-17 11:19:36', b'1', NULL); INSERT INTO `system_dict_data` VALUES (1186, 13, '仓储服务', '13', 'transport_type', 1, 'default', '', '从提供服务字典中取', '1', '2022-05-12 16:03:56', '115', '2022-05-17 11:19:40', b'1', NULL); INSERT INTO `system_dict_data` VALUES (1187, 4, '海空联运', '4', 'transport_type', 0, 'default', 'channel', '根据cssClass是否显示”channel“来判断，是否显示出货渠道，为空不显示', '1', '2022-05-12 16:04:23', '115', '2022-09-21 15:45:39', b'0', 'Sea and air transport'); INSERT INTO `system_dict_data` VALUES (1188, 0, '海运拼柜', 'HAIYUN_PINGGUI', 'zhong_service_content', 0, 'default', '', NULL, '1', '2022-05-17 00:31:05', '1', '2022-05-17 11:13:30', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1189, 1, '全境派送', 'QUANJING_PAISONG', 'zhong_service_content', 0, 'default', '', NULL, '1', '2022-05-17 00:31:40', '1', '2022-05-17 09:06:07', b'1', NULL); INSERT INTO `system_dict_data` VALUES (1190, 0, '专线空运', 'ZHUANXIAN_KONGYUN', 'pao_service_content', 0, 'default', '', NULL, '1', '2022-05-17 00:32:11', '1', '2022-05-17 09:06:29', b'1', NULL); INSERT INTO `system_dict_data` VALUES (1191, 1, '专业双清', 'ZHUANYE_SHUANGQING', 'pao_service_content', 0, 'default', '', NULL, '1', '2022-05-17 00:32:24', '1', '2022-05-17 09:06:27', b'1', NULL); INSERT INTO `system_dict_data` VALUES (1192, 1, '专线双清', '11', 'provide_services', 0, 'default', '', NULL, '115', '2022-05-17 11:15:11', '115', '2022-05-17 11:16:20', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1193, 2, '全境派送', '12', 'provide_services', 0, 'default', '', NULL, '115', '2022-05-17 11:15:28', '115', '2022-05-17 11:16:32', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1194, 3, '仓储服务', '13', 'provide_services', 0, 'default', '', NULL, '115', '2022-05-17 11:15:36', '115', '2022-05-17 11:16:37', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1195, 0, '订单前缀', 'EC', 'order_number_prefix', 0, 'default', '', NULL, '115', '2022-05-17 20:28:37', '115', '2022-05-17 20:28:37', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1196, 0, '集装箱出货前缀', 'CN', 'order_number_prefix', 0, 'default', '', NULL, '115', '2022-05-17 20:29:12', '115', '2022-05-17 20:29:21', b'0', NULL); INSERT INTO `system_dict_data` VALUES (1197, 1, '海运货代', '1', 'company_type', 0, 'default', '', NULL, '1', '2022-05-18 10:50:49', '1', '2022-05-18 10:50:49', b'0', 'hyhd'); INSERT INTO `system_dict_data` VALUES (1198, 2, '海运报关行', '2', 'company_type', 0, 'default', '', NULL, '1', '2022-05-18 10:51:19', '1', '2022-05-18 10:51:19', b'0', 'hybgh'); INSERT INTO `system_dict_data` VALUES (1199, 3, '证书机构', '3', 'company_type', 0, 'default', '', NULL, '1', '2022-05-18 10:51:40', '1', '2022-05-18 10:51:40', b'0', 'zsjg'); INSERT INTO `system_dict_data` VALUES (1200, 4, '海运拖车', '4', 'company_type', 0, 'default', '', NULL, '1', '2022-05-18 10:51:58', '1', '2022-05-18 10:51:58', b'0', 'hytc'); INSERT INTO `system_dict_data` VALUES (1201, 5, '空运货代', '5', 'company_type', 0, 'default', '', NULL, '1', '2022-05-18 10:52:19', '1', '2022-05-18 10:52:19', b'0', 'kyhd'); INSERT INTO `system_dict_data` VALUES (1202, 6, '清关代理', '6', 'company_type', 0, 'default', '', NULL, '1', '2022-05-18 10:52:56', '1', '2022-05-18 10:52:56', b'0', 'qgdl'); INSERT INTO `system_dict_data` VALUES (1203, 7, '空运报关行', '7', 'company_type', 0, 'default', '', NULL, '1', '2022-05-18 10:53:23', '1', '2022-05-18 10:53:23', b'0', 'kybgh'); INSERT INTO `system_dict_data` VALUES (1204, 8, '快递公司', '8', 'company_type', 0, 'default', '', NULL, '1', '2022-05-18 10:53:52', '1', '2022-05-18 10:53:52', b'0', 'kdgs'); INSERT INTO `system_dict_data` VALUES (1205, 9, '船公司', '9', 'company_type', 0, 'default', '', NULL, '1', '2022-05-18 10:54:07', '1', '2022-05-18 10:54:07', b'0', 'cgs'); INSERT INTO `system_dict_data` VALUES (1206, 1, '黑名单', '1', 'cooperation_type', 0, 'default', '', NULL, '1', '2022-05-18 10:56:56', '1', '2022-05-18 10:56:56', b'0', 'mhd'); INSERT INTO `system_dict_data` VALUES (1207, 2, '合作中', '2', 'cooperation_type', 0, 'default', '', NULL, '1', '2022-05-18 10:57:14', '1', '2022-05-18 10:57:14', b'0', 'hzz'); INSERT INTO `system_dict_data` VALUES (1208, 3, 'VIP', '3', 'cooperation_type', 0, 'default', '', NULL, '1', '2022-05-18 10:57:22', '1', '2022-05-18 10:57:22', b'0', 'vip'); INSERT INTO `system_dict_data` VALUES (1209, 0, '票审批（海运）', '3', 'bpm_model_category', 1, 'default', '', NULL, '115', '2022-05-19 09:41:14', '115', '2022-10-04 18:38:42', b'0', 'Ticket Approval (Ocean Sea)'); INSERT INTO `system_dict_data` VALUES (1210, 0, '订单审批', '4', 'bpm_model_category', 0, 'default', '', NULL, '115', '2022-05-19 09:41:56', '115', '2022-05-19 09:41:56', b'0', 'order approval'); INSERT INTO `system_dict_data` VALUES (1211, 1, '按公斤收费', '1', 'warehouse_charge_type', 0, 'default', '', NULL, '1', '2022-05-19 11:50:30', '1', '2022-05-19 11:51:01', b'0', 'by_kg'); INSERT INTO `system_dict_data` VALUES (1212, 2, '按天收费', '2', 'warehouse_charge_type', 0, 'default', '', NULL, '1', '2022-05-19 11:50:51', '1', '2022-05-19 11:50:51', b'0', 'by_day'); INSERT INTO `system_dict_data` VALUES (1213, 2, '审核通过', '2', 'audit_status', 0, 'default', '', NULL, '1', '2022-05-23 20:44:11', '1', '2022-06-23 22:28:21', b'0', 'audit success'); INSERT INTO `system_dict_data` VALUES (1214, 3, '审核不通过', '3', 'audit_status', 0, 'default', '', NULL, '1', '2022-05-23 20:44:25', '1', '2022-06-23 22:29:50', b'0', 'audit fail'); INSERT INTO `system_dict_data` VALUES (1215, 0, '普通', '1', 'customer_level', 0, 'default', '', NULL, '1', '2022-05-23 23:26:08', '1', '2022-05-23 23:26:08', b'0', 'common'); INSERT INTO `system_dict_data` VALUES (1216, 0, 'VIP', '2', 'customer_level', 0, 'default', '', NULL, '1', '2022-05-23 23:26:33', '1', '2022-05-23 23:26:33', b'0', 'VIP'); INSERT INTO `system_dict_data` VALUES (1217, 0, '黑名单', '3', 'customer_level', 0, 'default', '', NULL, '1', '2022-05-23 23:26:50', '1', '2022-10-27 16:19:50', b'1', 'blacklist'); INSERT INTO `system_dict_data` VALUES (1218, 0, '意向', '4', 'customer_level', 0, 'default', '', NULL, '1', '2022-05-23 23:27:47', '1', '2022-10-27 16:19:46', b'1', 'intention'); INSERT INTO `system_dict_data` VALUES (1219, 0, '潜在', '5', 'customer_level', 0, 'default', '', NULL, '1', '2022-05-23 23:28:07', '1', '2022-10-27 16:19:44', b'1', 'potential'); INSERT INTO `system_dict_data` VALUES (1220, 0, '发货人', '0', 'customer_type', 0, 'default', '', NULL, '1', '2022-05-23 23:35:25', '1', '2022-10-15 23:02:07', b'0', 'sender'); INSERT INTO `system_dict_data` VALUES (1221, 0, '收货人', '1', 'customer_type', 0, 'default', '', NULL, '1', '2022-05-23 23:36:26', '1', '2022-10-15 23:02:14', b'0', 'receiver'); INSERT INTO `system_dict_data` VALUES (1222, 0, '代理', '2', 'customer_type', 0, 'default', '', NULL, '1', '2022-05-23 23:37:33', '1', '2022-10-15 23:02:18', b'0', 'agent'); INSERT INTO `system_dict_data` VALUES (1223, 0, '同行', '3', 'customer_type', 0, 'default', '', NULL, '1', '2022-05-23 23:38:20', '1', '2022-10-15 23:02:25', b'0', 'peer'); INSERT INTO `system_dict_data` VALUES (1224, 0, '票结', '1', 'customer_balance', 0, 'default', '', NULL, '1', '2022-05-23 23:39:05', '1', '2022-05-23 23:39:05', b'0', 'ticket'); INSERT INTO `system_dict_data` VALUES (1225, 0, '月结', '2', 'customer_balance', 0, 'default', '', NULL, '1', '2022-05-23 23:39:14', '1', '2022-05-23 23:39:14', b'0', 'month'); INSERT INTO `system_dict_data` VALUES (1226, 0, '账期', '3', 'customer_balance', 0, 'default', '', NULL, '1', '2022-05-23 23:40:05', '1', '2022-05-23 23:40:05', b'0', 'bill'); INSERT INTO `system_dict_data` VALUES (1227, 2, '百度推广', '2', 'customer_source', 0, 'default', '', NULL, '1', '2022-05-23 23:41:22', '1', '2022-10-15 22:31:50', b'0', 'Baidu'); INSERT INTO `system_dict_data` VALUES (1228, 5, '老客户', '5', 'customer_source', 0, 'default', '', NULL, '1', '2022-05-23 23:42:04', '1', '2022-10-15 22:31:40', b'0', 'Regular'); INSERT INTO `system_dict_data` VALUES (1229, 6, '谷歌推广', '6', 'customer_source', 0, 'default', '', NULL, '1', '2022-05-23 23:42:27', '1', '2022-10-15 22:30:59', b'0', 'Google'); INSERT INTO `system_dict_data` VALUES (1230, 12, '发货人推荐', '12', 'customer_source', 0, 'default', '', NULL, '1', '2022-05-23 23:42:52', '1', '2022-10-15 22:32:14', b'0', 'from consigner'); INSERT INTO `system_dict_data` VALUES (1231, 11, '个人Facebook', '11', 'customer_source', 0, 'default', '', NULL, '1', '2022-05-23 23:43:02', '1', '2022-10-15 22:30:39', b'0', 'Facebook'); INSERT INTO `system_dict_data` VALUES (1232, 9, '电商网', '9', 'customer_source', 0, 'default', '', NULL, '1', '2022-05-23 23:43:11', '1', '2022-10-15 22:30:20', b'0', 'E-commerce network'); INSERT INTO `system_dict_data` VALUES (1233, 10, '国内地推', '10', 'customer_source', 0, 'default', '', NULL, '1', '2022-05-23 23:43:52', '1', '2022-10-15 22:29:38', b'0', 'Promotion'); INSERT INTO `system_dict_data` VALUES (1234, 0, '线索', '1', 'customer_status', 0, 'default', '', NULL, '1', '2022-05-23 23:45:14', '1', '2022-05-23 23:45:14', b'0', 'clue'); INSERT INTO `system_dict_data` VALUES (1235, 0, '意向', '2', 'customer_status', 0, 'default', '', NULL, '1', '2022-05-23 23:45:34', '1', '2022-05-23 23:45:34', b'0', 'intention'); INSERT INTO `system_dict_data` VALUES (1236, 0, '成交', '3', 'customer_status', 0, 'default', '', NULL, '1', '2022-05-23 23:46:12', '1', '2022-05-23 23:46:12', b'0', 'deal'); INSERT INTO `system_dict_data` VALUES (1237, 0, 'QQ', '1', 'customer_social_tools', 0, 'default', '', NULL, '1', '2022-05-24 17:30:45', '1', '2022-05-24 17:30:45', b'0', 'QQ'); INSERT INTO `system_dict_data` VALUES (1238, 0, '微信', '2', 'customer_social_tools', 0, 'default', '', NULL, '1', '2022-05-24 17:30:56', '1', '2022-05-24 17:30:56', b'0', 'WeChat'); INSERT INTO `system_dict_data` VALUES (1239, 0, 'Facebook', '3', 'customer_social_tools', 0, 'default', '', NULL, '1', '2022-05-24 17:31:04', '1', '2022-05-24 17:31:04', b'0', 'Facebook'); INSERT INTO `system_dict_data` VALUES (1240, 0, 'WhatsApp', '4', 'customer_social_tools', 0, 'default', '', NULL, '1', '2022-05-24 17:31:12', '1', '2022-05-24 17:31:12', b'0', 'WhatsApp'); INSERT INTO `system_dict_data` VALUES (1241, 0, '手动', '0', 'customer_create_type', 0, 'default', '', NULL, '1', '2022-05-25 13:55:28', '1', '2022-05-25 13:55:28', b'0', 'manual'); INSERT INTO `system_dict_data` VALUES (1242, 0, '注册时系统创建', '1', 'customer_create_type', 0, 'default', '', NULL, '1', '2022-05-25 13:57:25', '1', '2022-05-25 13:57:25', b'0', 'regist'); INSERT INTO `system_dict_data` VALUES (1243, 0, '下单时系统创建', '2', 'customer_create_type', 0, 'default', '', NULL, '1', '2022-05-25 13:58:03', '1', '2022-05-25 13:58:03', b'0', 'create with order'); INSERT INTO `system_dict_data` VALUES (1244, 1, '均可', '1', 'advance_status', 0, 'default', '', NULL, '1', '2022-05-28 21:46:43', '1', '2022-07-01 23:14:22', b'1', 'all'); INSERT INTO `system_dict_data` VALUES (1245, 1, '是', '1', 'advance_status', 0, 'default', '', '预付', '1', '2022-05-28 21:47:22', '1', '2022-07-02 10:17:42', b'0', 'pay first'); INSERT INTO `system_dict_data` VALUES (1246, 2, '否', '2', 'advance_status', 0, 'default', '', '到付', '1', '2022-05-28 21:47:47', '1', '2022-07-02 10:18:05', b'0', 'arrive pay'); INSERT INTO `system_dict_data` VALUES (1247, 1, '小货架', '1', 'shelf_type', 0, 'default', '', NULL, '1', '2022-05-30 14:35:43', '1', '2022-05-30 14:35:43', b'0', 'litter_shelf'); INSERT INTO `system_dict_data` VALUES (1248, 2, '大货架', '2', 'shelf_type', 0, 'default', '', NULL, '1', '2022-05-30 14:36:01', '1', '2022-05-30 14:36:01', b'0', 'big_shelf'); INSERT INTO `system_dict_data` VALUES (1249, 0, '未及时放货', '1', 'customer_complaint_type', 0, 'default', '', NULL, '1', '2022-05-31 11:39:22', '1', '2022-05-31 11:39:22', b'0', '1'); INSERT INTO `system_dict_data` VALUES (1250, 0, '提货点异常', '2', 'customer_complaint_type', 0, 'default', '', NULL, '1', '2022-05-31 11:39:54', '1', '2022-05-31 11:39:54', b'0', '2'); INSERT INTO `system_dict_data` VALUES (1251, 0, '控货失败', '3', 'customer_complaint_type', 0, 'default', '', NULL, '1', '2022-05-31 11:39:58', '1', '2022-05-31 11:39:58', b'0', '3'); INSERT INTO `system_dict_data` VALUES (1252, 0, '仓库误装/漏装', '4', 'customer_complaint_type', 0, 'default', '', NULL, '1', '2022-05-31 11:40:06', '1', '2022-05-31 11:40:06', b'0', '4'); INSERT INTO `system_dict_data` VALUES (1253, 0, '收不到提货单', '5', 'customer_complaint_type', 0, 'default', '', NULL, '1', '2022-05-31 11:40:18', '1', '2022-05-31 11:40:18', b'0', '5'); INSERT INTO `system_dict_data` VALUES (1254, 0, '客服服务', '6', 'customer_complaint_type', 0, 'default', '', NULL, '1', '2022-05-31 11:40:23', '1', '2022-05-31 11:40:23', b'0', '6'); INSERT INTO `system_dict_data` VALUES (1255, 0, '货物浸水', '7', 'customer_complaint_type', 0, 'default', '', NULL, '1', '2022-05-31 11:40:31', '1', '2022-05-31 11:40:31', b'0', '7'); INSERT INTO `system_dict_data` VALUES (1256, 0, '空运时效', '8', 'customer_complaint_type', 0, 'default', '', NULL, '1', '2022-05-31 11:40:42', '1', '2022-05-31 11:40:42', b'0', '8'); INSERT INTO `system_dict_data` VALUES (1257, 0, '海运时效-到港慢', '9', 'customer_complaint_type', 0, 'default', '', NULL, '1', '2022-05-31 11:40:51', '1', '2022-05-31 11:40:51', b'0', '9'); INSERT INTO `system_dict_data` VALUES (1258, 0, '海运时效-清关慢', '10', 'customer_complaint_type', 0, 'default', '', NULL, '1', '2022-05-31 11:41:03', '1', '2022-05-31 11:41:03', b'0', '10'); INSERT INTO `system_dict_data` VALUES (1259, 0, '货物破损', '11', 'customer_complaint_type', 0, 'default', '', NULL, '1', '2022-05-31 11:41:09', '1', '2022-05-31 11:41:09', b'0', '11'); INSERT INTO `system_dict_data` VALUES (1260, 0, '货物丢失', '12', 'customer_complaint_type', 0, 'default', '', NULL, '1', '2022-05-31 11:41:14', '1', '2022-05-31 11:41:14', b'0', '12'); INSERT INTO `system_dict_data` VALUES (1261, 0, '空运价格', '13', 'customer_complaint_type', 0, 'default', '', NULL, '1', '2022-05-31 11:41:21', '1', '2022-05-31 11:41:21', b'0', '13'); INSERT INTO `system_dict_data` VALUES (1262, 0, '海运价格', '14', 'customer_complaint_type', 0, 'default', '', NULL, '1', '2022-05-31 11:41:27', '1', '2022-05-31 11:41:27', b'0', '14'); INSERT INTO `system_dict_data` VALUES (1263, 0, '货运方式异常', '15', 'customer_complaint_type', 0, 'default', '', NULL, '1', '2022-05-31 11:41:33', '1', '2022-05-31 11:41:33', b'0', '15'); INSERT INTO `system_dict_data` VALUES (1264, 0, '方数异常', '16', 'customer_complaint_type', 0, 'default', '', NULL, '1', '2022-05-31 11:41:41', '1', '2022-05-31 11:41:41', b'0', '16'); INSERT INTO `system_dict_data` VALUES (1265, 0, '重量异常', '17', 'customer_complaint_type', 0, 'default', '', NULL, '1', '2022-05-31 11:41:48', '1', '2022-05-31 11:41:48', b'0', '17'); INSERT INTO `system_dict_data` VALUES (1266, 0, '待处理', '1', 'customer_complaint_status', 0, 'default', '', NULL, '1', '2022-05-31 13:52:38', '1', '2022-05-31 13:52:38', b'0', '1'); INSERT INTO `system_dict_data` VALUES (1267, 0, '处理中', '2', 'customer_complaint_status', 0, 'default', '', NULL, '1', '2022-05-31 13:52:46', '1', '2022-05-31 13:52:46', b'0', '2'); INSERT INTO `system_dict_data` VALUES (1268, 0, '已处理', '3', 'customer_complaint_status', 0, 'default', '', NULL, '1', '2022-05-31 13:52:55', '1', '2022-05-31 13:52:55', b'0', '3'); INSERT INTO `system_dict_data` VALUES (1269, 0, '已取消', '4', 'customer_complaint_status', 0, 'default', '', NULL, '1', '2022-05-31 13:53:05', '1', '2022-05-31 13:53:05', b'0', '4'); INSERT INTO `system_dict_data` VALUES (1270, 0, '回访', '1', 'customer_follow_type', 0, 'default', '', NULL, '1', '2022-05-31 14:31:45', '118', '2022-11-24 23:52:33', b'0', 'return visit'); INSERT INTO `system_dict_data` VALUES (1271, 0, '不良记录', '2', 'customer_follow_type', 0, 'default', '', NULL, '1', '2022-05-31 14:31:54', '118', '2022-11-24 23:52:41', b'0', 'bad behavior'); INSERT INTO `system_dict_data` VALUES (1272, 0, '投诉回访', '3', 'customer_follow_type', 0, 'default', '', NULL, '1', '2022-05-31 14:32:08', '118', '2022-11-24 23:52:49', b'0', 'complaint return visit'); INSERT INTO `system_dict_data` VALUES (1273, 0, '电话', '1', 'customer_follow_method', 0, 'default', '', NULL, '1', '2022-05-31 14:45:52', '118', '2022-11-24 23:53:44', b'0', 'phone call'); INSERT INTO `system_dict_data` VALUES (1274, 0, '面谈', '2', 'customer_follow_method', 0, 'default', '', NULL, '1', '2022-05-31 14:45:58', '118', '2022-11-24 23:53:55', b'0', 'interview'); INSERT INTO `system_dict_data` VALUES (1275, 0, '网络聊天', '3', 'customer_follow_method', 0, 'default', '', NULL, '1', '2022-05-31 14:46:07', '118', '2022-11-24 23:54:21', b'0', 'internet chat'); INSERT INTO `system_dict_data` VALUES (1276, 3, '人民币', '3', 'commission_currency_type', 0, 'default', '', NULL, '1', '2022-06-04 14:27:51', '1', '2022-11-27 23:35:19', b'1', 'CNY'); INSERT INTO `system_dict_data` VALUES (1277, 1, '美元', '1', 'commission_currency_type', 0, 'default', '', NULL, '1', '2022-06-04 14:28:06', '1', '2022-11-27 23:35:51', b'1', 'USD'); INSERT INTO `system_dict_data` VALUES (1278, 2, '奈拉', '2', 'commission_currency_type', 0, 'default', '', NULL, '1', '2022-06-04 14:28:43', '1', '2022-11-27 23:35:21', b'1', 'NGN'); INSERT INTO `system_dict_data` VALUES (1279, 0, '小压包', '1', 'commission_unit', 1, 'default', '', NULL, '1', '2022-06-04 14:32:00', '115', '2022-07-05 23:31:21', b'1', '1'); INSERT INTO `system_dict_data` VALUES (1280, 0, '千克', '2', 'commission_unit', 0, 'default', '', NULL, '1', '2022-06-04 14:32:15', '1', '2022-07-05 23:31:24', b'1', 'Kg'); INSERT INTO `system_dict_data` VALUES (1281, 0, '立方米', '3', 'commission_unit', 0, 'default', '', NULL, '1', '2022-06-04 14:33:37', '1', '2022-07-05 23:31:26', b'1', '3'); INSERT INTO `system_dict_data` VALUES (1282, 0, '大压包', '4', 'commission_unit', 1, 'default', '', NULL, '1', '2022-06-04 14:33:47', '115', '2022-07-05 23:31:27', b'1', '4'); INSERT INTO `system_dict_data` VALUES (1283, 0, '体积', '1', 'commission_amount_type', 0, 'default', '', NULL, '1', '2022-06-04 14:36:57', '1', '2022-06-04 14:36:57', b'0', 'Volume'); INSERT INTO `system_dict_data` VALUES (1284, 0, '重量', '2', 'commission_amount_type', 0, 'default', '', NULL, '1', '2022-06-04 14:37:09', '1', '2022-06-04 14:37:09', b'0', 'Weight'); INSERT INTO `system_dict_data` VALUES (1285, 0, '金额', '3', 'commission_amount_type', 0, 'default', '', NULL, '1', '2022-06-04 14:37:22', '1', '2022-06-04 14:37:22', b'0', 'Money'); INSERT INTO `system_dict_data` VALUES (1286, 0, '产品', '1', 'commission_type', 0, 'default', '', NULL, '1', '2022-06-04 15:01:25', '1', '2022-06-11 15:15:39', b'1', 'Product'); INSERT INTO `system_dict_data` VALUES (1287, 0, '达标返佣', '2', 'commission_type', 0, 'default', '', NULL, '1', '2022-06-04 15:02:04', '1', '2022-06-11 15:15:36', b'1', 'FullReturn'); INSERT INTO `system_dict_data` VALUES (1288, 0, '运输&线路', '3', 'commission_type', 0, 'default', '', NULL, '1', '2022-06-04 15:02:49', '1', '2022-06-11 15:11:50', b'1', 'Transport'); INSERT INTO `system_dict_data` VALUES (1289, 0, '未跟进客户-公海池', '90', 'customer_time', 0, 'default', '', '90天', '117', '2022-06-05 17:05:14', '117', '2022-06-05 17:05:14', b'0', 'open_sea_pool'); INSERT INTO `system_dict_data` VALUES (1290, 1, '待分配客户', '1', 'customer_time', 0, 'default', '', '1天', '117', '2022-06-05 17:05:38', '1', '2022-11-15 00:27:32', b'0', 'customers_to_be_assigned'); INSERT INTO `system_dict_data` VALUES (1291, 0, '待回复', '1', 'ecw_message_leave_status', 0, 'default', '', NULL, '1', '2022-06-07 07:28:59', '1', '2022-06-07 07:28:59', b'0', 'No Reply'); INSERT INTO `system_dict_data` VALUES (1292, 0, '已回复', '2', 'ecw_message_leave_status', 0, 'default', '', NULL, '1', '2022-06-07 07:29:32', '1', '2022-06-07 07:29:32', b'0', 'Replied'); INSERT INTO `system_dict_data` VALUES (1293, 0, '咨询', '1', 'ecw_message_leave_type', 0, 'default', '', NULL, '1', '2022-06-07 07:31:37', '1', '2022-06-07 07:31:37', b'0', 'Question'); INSERT INTO `system_dict_data` VALUES (1294, 0, '建议', '2', 'ecw_message_leave_type', 0, 'default', '', NULL, '1', '2022-06-07 07:32:01', '1', '2022-06-07 07:32:01', b'0', 'Suggestion'); INSERT INTO `system_dict_data` VALUES (1295, 1, '塑料', '1', 'product_material', 0, 'default', '', NULL, '1', '2022-06-07 17:35:14', '1', '2022-06-07 17:36:16', b'0', 'plastic'); INSERT INTO `system_dict_data` VALUES (1296, 2, '铁', '2', 'product_material', 0, 'default', '', NULL, '1', '2022-06-07 17:35:54', '1', '2022-06-07 17:35:54', b'0', 'iron'); INSERT INTO `system_dict_data` VALUES (1297, 3, '塑料/铁', '3', 'product_material', 0, 'default', '', NULL, '1', '2022-06-07 17:36:50', '1', '2022-06-07 17:36:50', b'0', 'plastic/iron'); INSERT INTO `system_dict_data` VALUES (1298, 4, '橡胶', '4', 'product_material', 0, 'default', '', NULL, '1', '2022-06-07 17:37:10', '1', '2022-06-07 17:37:10', b'0', 'rubber'); INSERT INTO `system_dict_data` VALUES (1299, 1, '箱', '1', 'packaging_type', 0, 'default', '', NULL, '1', '2022-06-07 18:59:53', '115', '2022-10-04 17:47:36', b'0', 'carton'); INSERT INTO `system_dict_data` VALUES (1300, 2, '编织袋', '2', 'packaging_type', 0, 'default', '', NULL, '1', '2022-06-07 19:00:40', '115', '2022-10-04 17:49:47', b'0', 'bag'); INSERT INTO `system_dict_data` VALUES (1301, 3, '木架', '3', 'packaging_type', 0, 'default', '', NULL, '1', '2022-06-07 19:01:12', '1', '2022-06-07 19:01:12', b'0', 'wooden frame'); INSERT INTO `system_dict_data` VALUES (1302, 4, '木箱', '4', 'packaging_type', 0, 'default', '', NULL, '1', '2022-06-07 19:01:54', '1', '2022-06-07 19:01:54', b'0', 'wooden box'); INSERT INTO `system_dict_data` VALUES (1303, 5, '托', '5', 'packaging_type', 0, 'default', '', NULL, '1', '2022-06-07 19:02:46', '117', '2022-06-11 23:08:18', b'0', 'care'); INSERT INTO `system_dict_data` VALUES (1304, 6, '航空箱', '6', 'packaging_type', 0, 'default', '', NULL, '1', '2022-06-07 19:03:21', '1', '2022-06-07 19:03:21', b'0', 'air box'); INSERT INTO `system_dict_data` VALUES (1305, 4, '封柜货', '4', 'container_location', 0, 'default', '', NULL, '1', '2022-06-07 19:10:35', '115', '2022-10-27 22:47:27', b'0', 'Closed container cargo'); INSERT INTO `system_dict_data` VALUES (1306, 3, '次封货柜', '3', 'container_location', 0, 'default', '', NULL, '1', '2022-06-07 19:11:05', '115', '2022-06-11 22:58:12', b'0', 'secondary container'); INSERT INTO `system_dict_data` VALUES (1307, 1, '柜里货（敏感货）', '1', 'container_location', 0, 'default', '', NULL, '1', '2022-06-07 19:12:20', '115', '2022-06-11 22:57:07', b'0', 'In the cabinet (sensitive goods)'); INSERT INTO `system_dict_data` VALUES (1308, 2, '柜内货', '2', 'container_location', 0, 'default', '', NULL, '1', '2022-06-07 19:12:52', '115', '2022-06-11 22:57:55', b'0', 'goods in the cabinet'); INSERT INTO `system_dict_data` VALUES (1309, 1, '多箱异常', 'order_superfluous_box_exception', 'order_error_type', 0, 'default', '', NULL, '1', '2022-06-10 17:16:53', '1', '2022-07-17 18:48:03', b'0', 'multibox exception'); INSERT INTO `system_dict_data` VALUES (1310, 2, '少箱异常', 'order_lack_box_exception', 'order_error_type', 0, 'default', '', NULL, '1', '2022-06-10 17:17:08', '1', '2022-07-17 18:48:15', b'0', 'less box exception'); INSERT INTO `system_dict_data` VALUES (1311, 3, '产品需要预付异常', 'order_pay_exception', 'order_error_type', 0, 'default', '', NULL, '1', '2022-06-10 17:17:32', '1', '2022-07-17 18:48:27', b'0', 'Product requires prepayment exception'); INSERT INTO `system_dict_data` VALUES (1312, 4, '货物丢失异常', 'order_miss_exception', 'order_error_type', 0, 'default', '', NULL, '1', '2022-06-10 17:17:44', '1', '2022-07-17 18:48:35', b'0', 'abnormal loss of goods'); INSERT INTO `system_dict_data` VALUES (1313, 5, '货物增多异常', 'order_superfluous_goods_exception', 'order_error_type', 0, 'default', '', NULL, '1', '2022-06-10 17:17:59', '1', '2022-07-17 18:48:49', b'0', 'abnormal increase in cargo'); INSERT INTO `system_dict_data` VALUES (1314, 6, '货物浸水异常', 'order_in_water_exception', 'order_error_type', 0, 'default', '', NULL, '1', '2022-06-10 17:18:15', '1', '2022-07-17 18:48:59', b'0', 'The cargo is abnormally soaked in water'); INSERT INTO `system_dict_data` VALUES (1315, 7, '货物破损异常', 'order_damage_exception', 'order_error_type', 0, 'default', '', NULL, '1', '2022-06-10 17:18:29', '1', '2022-07-17 18:49:06', b'0', 'abnormal cargo damage'); INSERT INTO `system_dict_data` VALUES (1316, 8, '重货异常', 'order_heavy_cargo_exception', 'order_error_type', 0, 'default', '', NULL, '1', '2022-06-10 17:18:45', '1', '2022-07-17 18:49:17', b'0', 'Heavy cargo exception'); INSERT INTO `system_dict_data` VALUES (1317, 9, '单证异常', 'order_doc_exception', 'order_error_type', 0, 'default', '', NULL, '1', '2022-06-10 17:19:26', '1', '2022-07-17 18:49:25', b'0', 'Document exception'); INSERT INTO `system_dict_data` VALUES (1318, 10, '发货人异常', 'order_consignor_exception', 'order_error_type', 0, 'default', '', NULL, '1', '2022-06-10 17:19:44', '1', '2022-07-17 18:49:33', b'0', 'Shipper exception'); INSERT INTO `system_dict_data` VALUES (1319, 11, '其他异常', 'order_other_exception', 'order_error_type', 0, 'default', '', NULL, '1', '2022-06-10 17:19:57', '1', '2022-07-17 18:49:58', b'0', 'Other exceptions'); INSERT INTO `system_dict_data` VALUES (1320, 12, '代收货款异常', 'order_cod_exception', 'order_error_type', 0, 'default', '', NULL, '1', '2022-06-10 17:20:07', '1', '2022-07-17 18:50:06', b'0', 'Abnormal payment collection'); INSERT INTO `system_dict_data` VALUES (1321, 1, '批量输入密码', '1', 'pwd_type', 0, 'default', '', NULL, '1', '2022-06-10 21:42:11', '115', '2022-09-22 14:19:48', b'0', 'Enter passwords in bulk'); INSERT INTO `system_dict_data` VALUES (1322, 2, '申请封柜密码', '2', 'pwd_type', 0, 'default', '', NULL, '1', '2022-06-10 21:42:24', '1', '2022-06-10 21:42:24', b'0', 'Apply for a locker password'); INSERT INTO `system_dict_data` VALUES (1323, 3, '客户重泡货标准密码', '3', 'pwd_type', 0, 'default', '', NULL, '1', '2022-06-10 21:42:43', '1', '2022-06-10 21:42:43', b'0', 'Customer re-buying standard password'); INSERT INTO `system_dict_data` VALUES (1324, 0, '产品', '1', 'commission_dark_type', 0, 'default', '', NULL, '1', '2022-06-11 15:15:03', '1', '2022-06-11 15:15:03', b'0', 'product'); INSERT INTO `system_dict_data` VALUES (1325, 0, '达标返佣', '2', 'commission_dark_type', 0, 'default', '', NULL, '1', '2022-06-11 15:15:24', '1', '2022-06-11 15:15:24', b'0', 'fullReturn'); INSERT INTO `system_dict_data` VALUES (1326, 1, '明佣', '1', 'commission_type', 0, 'default', '', NULL, '1', '2022-06-11 15:16:07', '1', '2022-09-13 22:30:24', b'0', 'LightCommission'); INSERT INTO `system_dict_data` VALUES (1327, 2, '暗佣', '2', 'commission_type', 0, 'default', '', NULL, '1', '2022-06-11 15:16:24', '1', '2022-09-13 22:30:35', b'0', 'DarkCommission'); INSERT INTO `system_dict_data` VALUES (1328, 3, '暗佣+明佣', '3', 'commission_type', 0, 'default', '', NULL, '1', '2022-06-11 15:17:58', '119', '2022-06-26 18:12:51', b'0', 'DarkWithLightCommission'); INSERT INTO `system_dict_data` VALUES (1329, 0, '我司全代', '1', 'customs_type', 0, 'default', '', NULL, '1', '2022-06-11 15:47:22', '1', '2022-06-11 15:48:00', b'0', 'all_proxy'); INSERT INTO `system_dict_data` VALUES (1330, 0, '自单代报', '2', 'customs_type', 0, 'default', '', NULL, '1', '2022-06-11 15:48:34', '1', '2022-06-11 15:48:34', b'0', 'single_proxy'); INSERT INTO `system_dict_data` VALUES (1331, 0, '混合报关', '3', 'customs_type', 0, 'default', '', NULL, '1', '2022-06-11 15:49:11', '1', '2022-06-11 15:49:11', b'0', 'mix'); INSERT INTO `system_dict_data` VALUES (1332, 0, '非进出口', '0', 'region_trade_type', 0, 'default', '', NULL, '115', '2022-06-11 16:42:34', '115', '2022-06-11 16:42:43', b'0', 'default'); INSERT INTO `system_dict_data` VALUES (1333, 1, '有', '1', 'commission_product_approval', 0, 'default', '', NULL, '1', '2022-06-11 21:15:02', '118', '2022-11-07 11:47:46', b'0', 'yes'); INSERT INTO `system_dict_data` VALUES (1334, 0, '无', '0', 'commission_product_approval', 0, 'default', '', NULL, '1', '2022-06-11 21:15:35', '118', '2022-11-07 14:06:04', b'0', 'no'); INSERT INTO `system_dict_data` VALUES (1335, 2, '中性', '2', 'commission_product_approval', 0, 'default', '', NULL, '1', '2022-06-11 21:16:57', '118', '2022-11-07 11:49:12', b'0', 'middle'); INSERT INTO `system_dict_data` VALUES (1336, 0, '有牌价格', 'licensed_price', 'special_req_for_line_products', 0, 'default', '', NULL, '115', '2022-06-11 22:50:14', '115', '2022-06-11 22:50:14', b'0', 'licensed price'); INSERT INTO `system_dict_data` VALUES (1337, 0, '中性品牌价格', 'neutral_brand_prices', 'special_req_for_line_products', 0, 'default', '', NULL, '115', '2022-06-11 22:50:42', '115', '2022-06-11 22:50:42', b'0', 'Neutral brand prices'); INSERT INTO `system_dict_data` VALUES (1338, 0, '液体价格', 'liquid_price', 'special_req_for_line_products', 0, 'default', '', NULL, '115', '2022-06-11 22:51:20', '115', '2022-06-11 22:51:20', b'0', 'liquid price'); INSERT INTO `system_dict_data` VALUES (1339, 0, '带电价格', 'live_price', 'special_req_for_line_products', 0, 'default', '', NULL, '115', '2022-06-11 22:51:38', '115', '2022-06-11 22:51:38', b'0', 'live price'); INSERT INTO `system_dict_data` VALUES (1340, 0, '均可', '1', 'line_product_prepaid', 0, 'default', '', NULL, '115', '2022-06-11 22:53:19', '115', '2022-07-01 23:11:31', b'1', 'can be'); INSERT INTO `system_dict_data` VALUES (1341, 0, '到付', '2', 'line_product_prepaid', 0, 'default', '', NULL, '115', '2022-06-11 22:53:29', '115', '2022-07-01 23:11:33', b'1', 'collect'); INSERT INTO `system_dict_data` VALUES (1342, 0, '预付', '3', 'line_product_prepaid', 0, 'default', '', NULL, '115', '2022-06-11 22:53:45', '115', '2022-07-01 23:11:35', b'1', 'prepaid'); INSERT INTO `system_dict_data` VALUES (1343, 1, '买单报关', '1', 'shipping_declaration_type', 0, 'default', '', NULL, '117', '2022-06-11 23:11:55', '117', '2022-06-11 23:12:24', b'0', 'pay customs declaration'); INSERT INTO `system_dict_data` VALUES (1344, 2, '正常报关', '2', 'shipping_declaration_type', 0, 'default', '', NULL, '117', '2022-06-11 23:12:17', '117', '2022-06-11 23:12:31', b'0', 'normal customs declaration'); INSERT INTO `system_dict_data` VALUES (1345, 3, '买单报关+正常报关', '3', 'shipping_declaration_type', 0, 'default', '', NULL, '117', '2022-06-11 23:12:48', '117', '2022-06-11 23:12:48', b'0', 'Pay customs declaration + normal customs declaration'); INSERT INTO `system_dict_data` VALUES (1346, 1, '特殊物品', '1', 'cargo_characteristics', 0, 'default', '', NULL, '117', '2022-06-11 23:19:18', '117', '2022-06-12 00:52:39', b'1', 'special items'); INSERT INTO `system_dict_data` VALUES (1347, 2, '普货', '2', 'cargo_characteristics', 0, 'default', '', NULL, '117', '2022-06-11 23:19:36', '117', '2022-06-12 00:52:53', b'1', 'General merchandise'); INSERT INTO `system_dict_data` VALUES (1348, 3, '不接受货物', '3', 'cargo_characteristics', 0, 'default', '', NULL, '117', '2022-06-11 23:19:49', '117', '2022-06-12 00:52:56', b'1', 'Goods not accepted'); INSERT INTO `system_dict_data` VALUES (1349, 4, '预付类', '4', 'cargo_characteristics', 0, 'default', '', NULL, '117', '2022-06-11 23:20:04', '117', '2022-06-12 00:52:58', b'1', 'prepaid'); INSERT INTO `system_dict_data` VALUES (1350, 5, '全包类', '5', 'cargo_characteristics', 0, 'default', '', NULL, '117', '2022-06-11 23:20:17', '117', '2022-06-12 00:53:01', b'1', 'All-inclusive'); INSERT INTO `system_dict_data` VALUES (1351, 6, '包装类', '6', 'cargo_characteristics', 0, 'default', '', NULL, '117', '2022-06-11 23:20:32', '117', '2022-06-12 00:53:03', b'1', 'Packaging class'); INSERT INTO `system_dict_data` VALUES (1352, 7, '带电', '7', 'cargo_characteristics', 0, 'default', '', NULL, '117', '2022-06-11 23:20:50', '117', '2022-06-12 00:53:05', b'1', 'charged'); INSERT INTO `system_dict_data` VALUES (1353, 8, '液体', '8', 'cargo_characteristics', 0, 'default', '', NULL, '117', '2022-06-11 23:21:08', '117', '2022-06-12 00:53:07', b'1', 'liquid'); INSERT INTO `system_dict_data` VALUES (1354, 9, '易碎', '9', 'cargo_characteristics', 0, 'default', '', NULL, '117', '2022-06-11 23:21:25', '117', '2022-06-12 00:53:09', b'1', 'fragile'); INSERT INTO `system_dict_data` VALUES (1355, 10, '粉末', '10', 'cargo_characteristics', 0, 'default', '', NULL, '117', '2022-06-11 23:21:36', '117', '2022-06-12 00:53:11', b'1', 'powder'); INSERT INTO `system_dict_data` VALUES (1356, 11, '带磁', '11', 'cargo_characteristics', 0, 'default', '', NULL, '117', '2022-06-11 23:21:55', '117', '2022-06-12 00:53:13', b'1', 'Magnetic'); INSERT INTO `system_dict_data` VALUES (1357, 2, '已备案', '1', 'brand_registry_type', 0, 'default', '', NULL, '115', '2022-06-12 01:26:29', '115', '2022-06-12 01:27:21', b'0', 'has been filed'); INSERT INTO `system_dict_data` VALUES (1358, 1, '未备案', '0', 'brand_registry_type', 0, 'default', '', NULL, '115', '2022-06-12 01:26:43', '115', '2022-06-12 01:27:15', b'0', 'Not filed'); INSERT INTO `system_dict_data` VALUES (1359, 3, '中性', '2', 'brand_registry_type', 0, 'default', '', NULL, '115', '2022-06-12 01:26:59', '115', '2022-07-28 23:14:59', b'1', 'neutral'); INSERT INTO `system_dict_data` VALUES (1360, 0, '无牌价', '0', 'customer_charging_model', 0, 'default', '', NULL, '115', '2022-06-12 12:29:03', '115', '2022-07-29 17:59:43', b'0', 'N'); INSERT INTO `system_dict_data` VALUES (1361, 1, '有牌价', '1', 'customer_charging_model', 0, 'default', '', NULL, '115', '2022-06-12 12:29:15', '115', '2022-07-29 17:59:47', b'0', 'Y'); INSERT INTO `system_dict_data` VALUES (1362, 1, '未授权', '0', 'brand_authorization_status', 0, 'default', '', NULL, '115', '2022-06-12 12:49:53', '115', '2022-06-12 12:49:53', b'0', '未授权'); INSERT INTO `system_dict_data` VALUES (1363, 2, '已授权', '1', 'brand_authorization_status', 0, 'default', '', NULL, '115', '2022-06-12 12:50:03', '115', '2022-06-12 12:50:03', b'0', '已授权'); INSERT INTO `system_dict_data` VALUES (1364, 0, '中国大陆', '1', 'country', 0, 'default', '', NULL, '1', '2022-06-14 22:52:21', '1', '2022-07-17 16:24:37', b'1', 'Chinese Mainland'); INSERT INTO `system_dict_data` VALUES (1365, 0, '027', '1', 'area_code', 0, 'default', '', NULL, '1', '2022-06-15 17:27:18', '1', '2022-06-15 17:27:18', b'0', '027'); INSERT INTO `system_dict_data` VALUES (1366, 0, '是', '1', 'is_default', 0, 'default', '', NULL, '1', '2022-06-15 17:58:35', '1', '2022-06-15 17:58:35', b'0', 'true'); INSERT INTO `system_dict_data` VALUES (1367, 1, '否', '0', 'is_default', 0, 'default', '', NULL, '1', '2022-06-15 17:58:53', '122', '2022-07-23 10:33:04', b'0', 'false'); INSERT INTO `system_dict_data` VALUES (1368, 4, '取消预订舱计划密码', '4', 'pwd_type', 0, 'default', '', NULL, '115', '2022-06-18 11:54:18', '115', '2022-06-18 11:54:18', b'0', 'cancel_booking_class_plan_password'); INSERT INTO `system_dict_data` VALUES (1369, 8, '优惠券', '1', 'coupon_type', 0, 'default', '', NULL, '119', '2022-06-18 15:49:57', '115', '2022-10-13 11:18:39', b'0', 'youhuiquan'); INSERT INTO `system_dict_data` VALUES (1370, 1, '满减', '2', 'coupon_type', 0, 'default', '', NULL, '119', '2022-06-18 15:50:11', '115', '2022-10-13 11:18:43', b'0', '满减'); INSERT INTO `system_dict_data` VALUES (1371, 0, '方数-满减', '3', 'coupon_type', 1, 'default', '', NULL, '119', '2022-06-18 15:50:19', '119', '2022-09-13 15:42:19', b'1', '方数-满减'); INSERT INTO `system_dict_data` VALUES (1372, 2, '折扣', '4', 'coupon_type', 0, 'default', '', NULL, '119', '2022-06-18 15:50:26', '115', '2022-10-13 11:18:47', b'0', '折扣'); INSERT INTO `system_dict_data` VALUES (1373, 3, '优惠', '5', 'coupon_type', 0, 'default', '', NULL, '119', '2022-06-18 15:50:33', '115', '2022-10-13 11:18:50', b'0', '优惠'); INSERT INTO `system_dict_data` VALUES (1374, 4, '特价', '6', 'coupon_type', 0, 'default', '', NULL, '119', '2022-06-18 15:50:40', '115', '2022-10-13 11:18:54', b'0', '特价'); INSERT INTO `system_dict_data` VALUES (1375, 5, '区间价', '7', 'coupon_type', 0, 'default', '', NULL, '119', '2022-06-18 15:50:46', '115', '2022-10-13 11:18:57', b'0', '区间价'); INSERT INTO `system_dict_data` VALUES (1376, 0, '运输费', '1', 'coupon_cost_type', 0, 'default', '', NULL, '119', '2022-06-18 15:55:38', '119', '2022-06-18 15:55:38', b'0', '运输费'); INSERT INTO `system_dict_data` VALUES (1377, 0, '清关费', '2', 'coupon_cost_type', 0, 'default', '', NULL, '119', '2022-06-18 15:55:45', '119', '2022-06-18 15:55:45', b'0', '清关费'); INSERT INTO `system_dict_data` VALUES (1378, 0, '总费用', '3', 'coupon_cost_type', 0, 'default', '', NULL, '119', '2022-06-18 15:55:54', '119', '2022-06-23 20:32:38', b'0', '总费用'); INSERT INTO `system_dict_data` VALUES (1379, 0, '草稿', '0', 'coupon_status', 0, 'default', '', NULL, '119', '2022-06-18 15:59:26', '119', '2022-06-18 16:06:55', b'0', '草稿'); INSERT INTO `system_dict_data` VALUES (1380, 0, '发布', '1', 'coupon_status', 0, 'default', '', NULL, '119', '2022-06-18 15:59:32', '119', '2022-06-18 16:07:01', b'0', '发布'); INSERT INTO `system_dict_data` VALUES (1381, 0, '取消投放', '-1', 'coupon_puton_status', 0, 'default', '', NULL, '119', '2022-06-18 16:00:40', '119', '2022-06-18 16:00:40', b'0', '取消投放'); INSERT INTO `system_dict_data` VALUES (1382, 0, '等待投放', '0', 'coupon_puton_status', 0, 'default', '', NULL, '119', '2022-06-18 16:00:46', '119', '2022-06-18 16:00:46', b'0', '等待投放'); INSERT INTO `system_dict_data` VALUES (1383, 0, '投放', '1', 'coupon_puton_status', 0, 'default', '', NULL, '119', '2022-06-18 16:00:52', '119', '2022-06-18 16:00:52', b'0', '投放'); INSERT INTO `system_dict_data` VALUES (1384, 0, '违规下架', '2', 'coupon_puton_status', 0, 'default', '', NULL, '119', '2022-06-18 16:01:01', '119', '2022-06-18 16:01:01', b'0', '违规下架'); INSERT INTO `system_dict_data` VALUES (1385, 0, '等待审核', '3', 'coupon_puton_status', 0, 'default', '', NULL, '119', '2022-06-18 16:01:08', '119', '2022-06-18 16:01:08', b'0', '等待审核'); INSERT INTO `system_dict_data` VALUES (1386, 0, '过期', '0', 'coupon_overdue_status', 0, 'default', '', NULL, '119', '2022-06-18 16:07:51', '119', '2022-06-18 16:07:51', b'0', '过期'); INSERT INTO `system_dict_data` VALUES (1387, 0, '未过期', '1', 'coupon_overdue_status', 0, 'default', '', NULL, '119', '2022-06-18 16:07:57', '119', '2022-06-18 16:07:57', b'0', '未过期'); INSERT INTO `system_dict_data` VALUES (1388, 0, '重货', '1', 'zhong_pao_type', 0, 'default', '', NULL, '1', '2022-06-18 16:18:37', '1', '2022-06-18 16:18:37', b'0', 'weight'); INSERT INTO `system_dict_data` VALUES (1389, 0, '泡货', '2', 'zhong_pao_type', 0, 'default', '', NULL, '1', '2022-06-18 16:18:47', '1', '2022-06-18 16:18:47', b'0', 'light'); INSERT INTO `system_dict_data` VALUES (1390, 0, '全部用户', '0', 'suitable_user_type', 0, 'default', '', '', '119', '2022-06-18 21:50:22', '119', '2022-06-19 00:28:47', b'1', '全部用户'); INSERT INTO `system_dict_data` VALUES (1391, 0, '部分用户', '1', 'suitable_user_type', 0, 'default', 'show-selector', 'show-selector 表示需要显示客户选择组件', '119', '2022-06-18 21:50:45', '119', '2022-06-19 00:28:49', b'1', '部分用户'); INSERT INTO `system_dict_data` VALUES (1392, 0, '指定用户不参与', '2', 'suitable_user_type', 0, 'default', 'show-selector', 'show-selector 表示需要显示客户选择组件', '119', '2022-06-18 21:50:57', '119', '2022-06-19 00:28:53', b'1', '指定用户不参与'); INSERT INTO `system_dict_data` VALUES (1393, 0, '指定线路参与', '1', 'suitable_line_type', 0, 'default', 'show-selector', '', '119', '2022-06-18 23:58:30', '119', '2022-06-19 00:01:59', b'0', '指定线路参与'); INSERT INTO `system_dict_data` VALUES (1394, 0, '指定线路不参与', '2', 'suitable_line_type', 0, 'default', 'show-selector', '', '119', '2022-06-18 23:58:36', '119', '2022-06-19 00:02:02', b'0', '指定线路不参与'); INSERT INTO `system_dict_data` VALUES (1395, 0, '全部线路参与', '0', 'suitable_line_type', 0, 'default', '', NULL, '119', '2022-06-18 23:58:45', '119', '2022-06-18 23:58:45', b'0', '全部线路参与'); INSERT INTO `system_dict_data` VALUES (1396, 0, '全部用户', '0', 'suitable_user_type', 0, 'default', '', NULL, NULL, '2022-06-19 00:34:36', NULL, '2022-06-19 00:34:36', b'0', '全部用户'); INSERT INTO `system_dict_data` VALUES (1397, 0, '部分用户', '1', 'suitable_user_type', 0, 'danger', 'show-selector', '类型danger用来标识优惠券显示', NULL, '2022-06-19 00:34:48', '119', '2022-07-23 14:02:26', b'0', '部分用户'); INSERT INTO `system_dict_data` VALUES (1398, 0, '指定用户不参与', '2', 'suitable_user_type', 0, 'default', 'show-selector', NULL, NULL, '2022-06-19 00:35:09', NULL, '2022-06-19 00:35:09', b'0', '指定用户不参与'); INSERT INTO `system_dict_data` VALUES (1399, 0, '全部产品参与', '0', 'suitable_prod_type', 0, 'default', '', NULL, '119', '2022-06-19 14:23:42', '119', '2022-06-19 14:23:42', b'0', '全部产品参与'); INSERT INTO `system_dict_data` VALUES (1400, 0, '指定产品参与', '1', 'suitable_prod_type', 0, 'default', 'show-selector', NULL, '119', '2022-06-19 14:23:52', '119', '2022-06-19 14:23:52', b'0', '指定产品参与'); INSERT INTO `system_dict_data` VALUES (1401, 0, '指定产品不参与', '2', 'suitable_prod_type', 0, 'default', 'show-selector', NULL, '119', '2022-06-19 14:23:59', '119', '2022-06-19 14:23:59', b'0', '指定产品不参与'); INSERT INTO `system_dict_data` VALUES (1402, 0, '普货', '1', 'order_attr', 0, 'default', '', NULL, '119', '2022-06-19 15:38:58', '119', '2022-06-19 15:38:58', b'0', '普货'); INSERT INTO `system_dict_data` VALUES (1403, 0, '重货', '2', 'order_attr', 0, 'default', '', NULL, '119', '2022-06-19 15:39:07', '119', '2022-06-19 15:39:07', b'0', '重货'); INSERT INTO `system_dict_data` VALUES (1404, 0, '泡货', '3', 'order_attr', 0, 'default', '', NULL, '119', '2022-06-19 15:39:17', '119', '2022-06-19 15:39:17', b'0', '泡货'); INSERT INTO `system_dict_data` VALUES (1405, 0, '否', '0', 'yesno', 0, 'default', '', NULL, '119', '2022-06-19 17:11:54', '119', '2022-06-19 17:11:54', b'0', '否'); INSERT INTO `system_dict_data` VALUES (1406, 0, '是', '1', 'yesno', 0, 'default', '', NULL, '119', '2022-06-19 17:12:00', '119', '2022-06-19 17:12:00', b'0', '是'); INSERT INTO `system_dict_data` VALUES (1407, 1, '空运', '1', 'port_type', 0, 'default', '', NULL, '1', '2022-06-20 10:36:40', '1', '2022-06-20 10:36:40', b'0', 'air transport'); INSERT INTO `system_dict_data` VALUES (1408, 2, '海运', '2', 'port_type', 0, 'default', '', NULL, '1', '2022-06-20 10:37:09', '1', '2022-06-20 10:37:09', b'0', 'ocean shipping'); INSERT INTO `system_dict_data` VALUES (1409, 3, '海空运', '3', 'port_type', 0, 'default', '', NULL, '1', '2022-06-20 10:37:46', '1', '2022-06-20 10:37:46', b'0', 'air and sea transportation'); INSERT INTO `system_dict_data` VALUES (1410, 1, '套编织袋', '1', 'combined_value_added_fee', 0, 'default', '1', 'CSS为默认价格', '115', '2022-06-22 22:23:39', '115', '2022-07-24 12:16:36', b'1', 'Set of woven bags'); INSERT INTO `system_dict_data` VALUES (1411, 2, '木架包装费', '2', 'combined_value_added_fee', 0, 'default', '2', 'CSS为默认价格\n', '115', '2022-06-22 22:25:22', '115', '2022-07-24 12:16:39', b'1', 'Wooden frame packing fee'); INSERT INTO `system_dict_data` VALUES (1412, 3, '纸箱包装费', '3', 'combined_value_added_fee', 0, 'default', '3', 'CSS为默认价格\n', '115', '2022-06-22 22:26:11', '115', '2022-07-24 12:16:42', b'1', 'carton packing fee'); INSERT INTO `system_dict_data` VALUES (1413, 4, '代付快递费', '4', 'combined_value_added_fee', 0, 'default', '4', 'CSS为默认价格\n', '115', '2022-06-22 22:26:48', '115', '2022-07-24 12:16:44', b'1', 'Pay the courier fee'); INSERT INTO `system_dict_data` VALUES (1414, 5, '打包费', '5', 'combined_value_added_fee', 0, 'default', '5', 'CSS为默认价格\n', '115', '2022-06-22 22:27:11', '115', '2022-07-24 12:16:46', b'1', 'packing fee'); INSERT INTO `system_dict_data` VALUES (1415, 6, '易碎标签', '6', 'combined_value_added_fee', 0, 'default', '6', 'CSS为默认价格\n', '115', '2022-06-22 22:27:28', '115', '2022-07-24 12:16:50', b'1', 'Fragile labels'); INSERT INTO `system_dict_data` VALUES (1416, 7, '其他费用', '7', 'combined_value_added_fee', 0, 'default', '7', 'CSS为默认价格', '115', '2022-06-22 22:27:47', '115', '2022-07-24 12:16:52', b'1', 'other fee'); INSERT INTO `system_dict_data` VALUES (1417, 1, '审核中', '1', 'audit_status', 0, 'default', '', NULL, '1', '2022-06-23 21:59:05', '1', '2022-06-23 22:28:17', b'0', 'auditing'); INSERT INTO `system_dict_data` VALUES (1418, 0, '未提交审核', '0', 'audit_status', 0, 'default', '', NULL, '1', '2022-06-23 22:00:24', '115', '2022-08-13 10:06:08', b'0', 'unaudit'); INSERT INTO `system_dict_data` VALUES (1419, 0, '身份证', '1', 'customer_credit_rule_type', 0, 'default', '', NULL, '1', '2022-06-24 16:16:21', '1', '2022-06-24 16:16:21', b'0', 'ID Card'); INSERT INTO `system_dict_data` VALUES (1420, 0, '贷款', '2', 'customer_credit_rule_type', 0, 'default', '', NULL, '1', '2022-06-24 16:18:08', '1', '2022-06-24 16:18:08', b'0', 'Loan'); INSERT INTO `system_dict_data` VALUES (1421, 0, '提货率', '3', 'customer_credit_rule_type', 0, 'default', '', NULL, '1', '2022-06-24 16:18:43', '1', '2022-09-20 11:41:17', b'0', 'Pickup Ratio'); INSERT INTO `system_dict_data` VALUES (1422, 0, '发货', '4', 'customer_credit_rule_type', 0, 'default', '', NULL, '1', '2022-06-24 16:19:44', '1', '2022-06-24 16:19:44', b'0', 'Delivery'); INSERT INTO `system_dict_data` VALUES (1423, 0, '货量', '1', 'customer_level_rule_type', 0, 'default', '', NULL, '1', '2022-06-24 16:21:41', '1', '2022-06-24 16:22:14', b'0', 'Quantity'); INSERT INTO `system_dict_data` VALUES (1424, 0, '提货率', '2', 'customer_level_rule_type', 0, 'default', '', NULL, '1', '2022-06-24 16:22:10', '1', '2022-06-24 16:22:10', b'0', 'Pickup Ratio'); INSERT INTO `system_dict_data` VALUES (1425, 0, '利润率', '3', 'customer_level_rule_type', 0, 'default', '', NULL, '1', '2022-06-24 16:22:50', '1', '2022-06-24 16:24:17', b'0', 'Profit Ratio'); INSERT INTO `system_dict_data` VALUES (1426, 0, '新客介绍', '4', 'customer_level_rule_type', 0, 'default', '', NULL, '1', '2022-06-24 16:24:11', '1', '2022-06-24 16:24:11', b'0', 'New Customer'); INSERT INTO `system_dict_data` VALUES (1427, 1, '身份证', '1', 'certificate_type', 0, 'default', '', NULL, '122', '2022-06-25 14:20:05', '122', '2022-06-25 14:20:05', b'0', 'ID'); INSERT INTO `system_dict_data` VALUES (1428, 2, '护照', '2', 'certificate_type', 0, 'default', '', NULL, '122', '2022-06-25 14:20:54', '122', '2022-06-25 14:20:54', b'0', 'passport'); INSERT INTO `system_dict_data` VALUES (1429, 0, '登录', '1', 'user_operation_type', 0, 'default', '', NULL, '1', '2022-06-26 01:00:34', '1', '2022-06-26 01:00:34', b'0', 'login'); INSERT INTO `system_dict_data` VALUES (1430, 0, '实名认证', '2', 'user_operation_type', 0, 'default', '', NULL, '1', '2022-06-26 01:05:37', '1', '2022-06-26 01:09:41', b'0', 'authentification'); INSERT INTO `system_dict_data` VALUES (1431, 0, '审核', '3', 'user_operation_type', 0, 'default', '', NULL, '1', '2022-06-26 01:10:13', '1', '2022-06-26 01:10:13', b'0', 'audit'); INSERT INTO `system_dict_data` VALUES (1432, 0, '注册', '4', 'user_operation_type', 0, 'default', '', NULL, '1', '2022-06-26 01:10:58', '1', '2022-06-26 01:10:58', b'0', 'regist'); INSERT INTO `system_dict_data` VALUES (1433, 0, '订单消息', '1', 'internal_message_type', 0, 'default', '', NULL, '123', '2022-06-26 13:32:40', '123', '2022-06-26 13:33:37', b'0', 'Order Message'); INSERT INTO `system_dict_data` VALUES (1434, 1, '出货消息', '2', 'internal_message_type', 0, 'default', '', NULL, '123', '2022-06-26 13:34:45', '123', '2022-06-26 13:35:52', b'0', 'Shipment Message'); INSERT INTO `system_dict_data` VALUES (1435, 2, '提醒消息', '3', 'internal_message_type', 0, 'default', '', NULL, '123', '2022-06-26 13:35:38', '123', '2022-06-26 13:36:04', b'0', 'Remind Message'); INSERT INTO `system_dict_data` VALUES (1436, 1, '未读', '0', 'internal_message_read_status', 0, 'default', '', NULL, '123', '2022-06-26 14:23:47', '123', '2022-06-26 14:23:47', b'0', 'No Read'); INSERT INTO `system_dict_data` VALUES (1437, 2, '已读', '1', 'internal_message_read_status', 0, 'default', '', NULL, '123', '2022-06-26 14:24:36', '123', '2022-06-26 14:24:36', b'0', 'Read'); INSERT INTO `system_dict_data` VALUES (1438, 0, '客户自清', '1', 'double_clear', 0, 'default', '', NULL, '119', '2022-06-26 14:47:04', '119', '2022-06-26 14:47:04', b'0', '客户自清'); INSERT INTO `system_dict_data` VALUES (1439, 0, '我司双清', '2', 'double_clear', 0, 'default', '', NULL, '119', '2022-06-26 14:47:15', '119', '2022-06-26 14:47:15', b'0', '我司双清'); INSERT INTO `system_dict_data` VALUES (1440, 0, '待处理', '0', 'order_exception_status', 0, 'default', '', NULL, '1', '2022-06-26 16:06:11', '1', '2022-06-26 16:09:23', b'0', 'Pending'); INSERT INTO `system_dict_data` VALUES (1441, 0, '处理中', '1', 'order_exception_status', 0, 'default', '', NULL, '1', '2022-06-26 16:06:48', '1', '2022-06-26 16:09:06', b'0', 'Processing'); INSERT INTO `system_dict_data` VALUES (1442, 0, '已处理', '2', 'order_exception_status', 0, 'default', '', NULL, '1', '2022-06-26 16:08:15', '1', '2022-06-26 16:09:40', b'0', 'Solved'); INSERT INTO `system_dict_data` VALUES (1443, 0, 'FOB(离岸价)', '1', 'trade_type', 0, 'default', '', NULL, '119', '2022-06-26 18:07:24', '119', '2022-06-26 18:07:24', b'0', 'FOB(离岸价)'); INSERT INTO `system_dict_data` VALUES (1444, 0, 'CIF(到岸价)', '2', 'trade_type', 0, 'default', '', NULL, '119', '2022-06-26 18:07:31', '119', '2022-06-26 18:07:31', b'0', 'CIF(到岸价)'); INSERT INTO `system_dict_data` VALUES (1445, 0, 'CNF(成本加运费)', '3', 'trade_type', 0, 'default', '', NULL, '119', '2022-06-26 18:07:37', '119', '2022-06-26 18:07:37', b'0', 'CNF(成本加运费)'); INSERT INTO `system_dict_data` VALUES (1446, 0, 'EXW(出厂价)', '4', 'trade_type', 0, 'default', '', NULL, '119', '2022-06-26 18:07:45', '119', '2022-06-26 18:07:45', b'0', 'EXW(出厂价)'); INSERT INTO `system_dict_data` VALUES (1447, 0, '无佣金', '0', 'commission_type', 0, 'default', '', NULL, '119', '2022-06-26 18:12:00', '1', '2022-09-13 22:30:46', b'0', '无佣金'); INSERT INTO `system_dict_data` VALUES (1448, 0, '正常', '0', 'help_doc_status', 0, 'default', '', NULL, '123', '2022-06-27 20:24:44', '123', '2022-06-27 20:24:44', b'0', 'enable'); INSERT INTO `system_dict_data` VALUES (1449, 1, '停用', '1', 'help_doc_status', 0, 'default', '', NULL, '123', '2022-06-27 20:25:02', '123', '2022-06-27 20:25:02', b'0', 'disable'); INSERT INTO `system_dict_data` VALUES (1450, 4, '打木架', '4', 'order_special_needs', 0, 'default', '', NULL, '115', '2022-06-28 13:12:42', '1', '2022-10-27 14:54:25', b'0', 'Play wooden frame'); INSERT INTO `system_dict_data` VALUES (1451, 8, '内陆运输费垫付 ', '8', 'order_special_needs', 0, 'default', '', NULL, '115', '2022-06-28 13:13:07', '1', '2022-10-27 14:52:07', b'0', 'Advance payment of inland transportation fee'); INSERT INTO `system_dict_data` VALUES (1452, 3, '纸箱打包', '3', 'order_special_needs', 0, 'default', '', NULL, '115', '2022-06-28 13:13:31', '1', '2022-10-27 14:53:47', b'0', 'Carton packing'); INSERT INTO `system_dict_data` VALUES (1453, 1, '其他', '1', 'manual_exception_type', 0, 'default', '', NULL, '115', '2022-06-28 13:39:29', '115', '2022-06-28 13:39:29', b'0', 'other'); INSERT INTO `system_dict_data` VALUES (1454, 2, '货损', '2', 'manual_exception_type', 0, 'default', '', NULL, '115', '2022-06-28 13:39:58', '115', '2022-06-28 13:39:58', b'0', 'cargo damage'); INSERT INTO `system_dict_data` VALUES (1455, 0, '赢单', '1', 'offer_result', 0, 'default', '', NULL, '1', '2022-06-30 14:27:37', '1', '2022-06-30 14:28:26', b'0', 'win'); INSERT INTO `system_dict_data` VALUES (1456, 1, '输单', '0', 'offer_result', 0, 'default', '', NULL, '1', '2022-06-30 14:28:44', '1', '2022-06-30 14:28:44', b'0', 'lose'); INSERT INTO `system_dict_data` VALUES (1457, 1, '一次入仓', '1', 'warehousing_type', 0, 'default', '', NULL, '1', '2022-06-30 14:38:31', '1', '2022-09-30 23:59:01', b'0', 'once'); INSERT INTO `system_dict_data` VALUES (1458, 2, '分批入仓', '2', 'warehousing_type', 0, 'default', '', NULL, '1', '2022-06-30 14:39:13', '1', '2022-09-30 23:59:06', b'0', 'batche'); INSERT INTO `system_dict_data` VALUES (1459, 0, '取消报价', '0', 'offer_status', 0, 'default', '', NULL, '119', '2022-06-30 22:32:55', '119', '2022-06-30 22:32:55', b'0', '取消报价'); INSERT INTO `system_dict_data` VALUES (1460, 1, '特价审批中', '1', 'offer_status', 0, 'default', '', NULL, '119', '2022-06-30 22:33:03', '1', '2022-10-04 18:47:23', b'0', '特价审批中'); INSERT INTO `system_dict_data` VALUES (1461, 2, '草稿', '2', 'offer_status', 0, 'default', '', '草稿', '119', '2022-06-30 22:33:10', '1', '2022-10-04 18:47:45', b'0', 'draft'); INSERT INTO `system_dict_data` VALUES (1462, 3, '需求确认', '3', 'offer_status', 0, 'default', '', '需求确认', '119', '2022-06-30 22:33:20', '1', '2022-10-04 18:47:49', b'0', 'Demand confirm'); INSERT INTO `system_dict_data` VALUES (1463, 4, '赢单', '4', 'offer_status', 0, 'default', '', NULL, '119', '2022-06-30 22:33:28', '1', '2022-10-04 18:47:30', b'0', '赢单'); INSERT INTO `system_dict_data` VALUES (1464, 5, '输单', '5', 'offer_status', 0, 'default', '', NULL, '119', '2022-06-30 22:33:36', '1', '2022-10-04 18:47:53', b'0', '输单'); INSERT INTO `system_dict_data` VALUES (1465, 6, '报价完成', '6', 'offer_status', 0, 'default', '', NULL, '119', '2022-06-30 22:33:44', '1', '2022-10-04 18:47:57', b'0', '报价完成'); INSERT INTO `system_dict_data` VALUES (1466, 0, '审批通过', '7', 'offer_status', 0, 'default', '', NULL, '119', '2022-06-30 22:33:55', '119', '2022-09-20 15:59:38', b'1', '审批通过'); INSERT INTO `system_dict_data` VALUES (1467, 0, '审批拒绝', '8', 'offer_status', 0, 'default', '', NULL, '119', '2022-06-30 22:34:03', '119', '2022-09-20 15:59:36', b'1', '审批拒绝'); INSERT INTO `system_dict_data` VALUES (1468, 0, '无品牌', '0', 'is_brand', 0, 'default', '', NULL, '119', '2022-07-01 17:59:32', '119', '2022-07-01 17:59:32', b'0', '无品牌'); INSERT INTO `system_dict_data` VALUES (1469, 0, '有品牌', '1', 'is_brand', 0, 'default', '', NULL, '119', '2022-07-01 17:59:55', '119', '2022-07-01 17:59:55', b'0', '有品牌'); INSERT INTO `system_dict_data` VALUES (1470, 2, '线索客户没有报价的-公海池', '30', 'customer_time', 0, 'default', '', '30天', '1', '2022-07-02 11:33:33', '1', '2022-11-15 00:27:28', b'0', 'clue_unoffer_to_see_pool'); INSERT INTO `system_dict_data` VALUES (1471, 3, '意向客户x月未成交的-公海池', '3', 'customer_time', 0, 'default', '', '3月', '1', '2022-07-02 11:36:18', '1', '2022-11-15 00:27:24', b'0', 'intention_no_order_to_see_pool'); INSERT INTO `system_dict_data` VALUES (1472, 4, '成交客户x月未复购-公海池', '6', 'customer_time', 0, 'default', '', '6月', '1', '2022-07-02 11:39:50', '1', '2022-11-15 00:27:20', b'0', 'deal_no_redeal_to_see_pool'); INSERT INTO `system_dict_data` VALUES (1473, 1, '操作日志', '1', 'offer_type', 0, 'default', '', NULL, '1', '2022-07-02 11:47:33', '1', '2022-07-03 11:16:37', b'0', 'operation log'); INSERT INTO `system_dict_data` VALUES (1474, 2, '商务洽谈', '2', 'offer_type', 0, 'default', '', NULL, '1', '2022-07-02 11:56:05', '1', '2022-07-03 11:16:28', b'0', 'Business negotiation'); INSERT INTO `system_dict_data` VALUES (1475, 1, '新建报价', '1', 'offer_method', 0, 'default', '', NULL, '1', '2022-07-02 12:08:53', '1', '2022-07-03 11:17:17', b'0', 'new offer'); INSERT INTO `system_dict_data` VALUES (1476, 2, '修改报价', '2', 'offer_method', 0, 'default', '', NULL, '1', '2022-07-02 12:09:29', '1', '2022-07-03 11:17:23', b'0', 'edit offer'); INSERT INTO `system_dict_data` VALUES (1477, 3, '特价申请', '3', 'offer_method', 0, 'default', '', NULL, '1', '2022-07-02 12:11:17', '1', '2022-07-03 11:17:31', b'0', 'apply offer'); INSERT INTO `system_dict_data` VALUES (1478, 4, '电话', '4', 'offer_method', 0, 'default', '', NULL, '1', '2022-07-02 12:11:49', '1', '2022-07-02 12:11:49', b'0', 'mobile'); INSERT INTO `system_dict_data` VALUES (1479, 5, '网络', '5', 'offer_method', 0, 'default', '', NULL, '1', '2022-07-02 12:12:30', '1', '2022-07-02 12:12:30', b'0', 'network'); INSERT INTO `system_dict_data` VALUES (1480, 6, '报价结束', '6', 'offer_method', 0, 'default', '', NULL, '1', '2022-07-02 12:13:01', '1', '2022-07-03 11:17:38', b'0', 'offer over'); INSERT INTO `system_dict_data` VALUES (1481, 5, '出货审核', '5', 'bpm_model_category', 0, 'default', '', NULL, '1', '2022-07-03 14:48:54', '1', '2022-07-03 14:52:30', b'0', 'shipment approval'); INSERT INTO `system_dict_data` VALUES (1482, 6, '报价审核', '6', 'bpm_model_category', 0, 'default', '', NULL, '1', '2022-07-03 14:52:05', '1', '2022-07-03 14:52:05', b'0', 'quote approval'); INSERT INTO `system_dict_data` VALUES (1483, 11, '袋装', '11', 'order_special_needs', 0, 'default', '', NULL, '115', '2022-07-03 16:26:23', '1', '2022-10-27 14:53:57', b'0', 'bagged'); INSERT INTO `system_dict_data` VALUES (1484, 9, '打木托', '9', 'order_special_needs', 0, 'default', '', NULL, '115', '2022-07-03 16:27:02', '1', '2022-10-27 14:53:08', b'0', 'beat wooden pallets'); INSERT INTO `system_dict_data` VALUES (1485, 10, '木箱', '10', 'order_special_needs', 0, 'default', '', NULL, '115', '2022-07-03 16:27:56', '1', '2022-10-27 14:52:53', b'0', 'box'); INSERT INTO `system_dict_data` VALUES (1486, 12, '航空箱', '12', 'order_special_needs', 0, 'default', '', NULL, '115', '2022-07-03 16:28:29', '1', '2022-10-27 14:54:08', b'0', 'Flight Case'); INSERT INTO `system_dict_data` VALUES (1487, 5, '确定接收时间', '24', 'customer_time', 0, 'default', '', '24小时', '1', '2022-07-04 21:17:57', '1', '2022-11-15 00:27:16', b'0', 'confirm_time'); INSERT INTO `system_dict_data` VALUES (1488, 0, '有牌', '1', 'product_record_attribute', 0, 'default', '', NULL, '1', '2022-07-05 15:30:45', '1', '2022-07-05 15:30:45', b'0', 'have_card'); INSERT INTO `system_dict_data` VALUES (1489, 0, '无牌', '2', 'product_record_attribute', 0, 'default', '', NULL, '1', '2022-07-05 15:31:15', '1', '2022-07-05 15:31:15', b'0', 'no_card'); INSERT INTO `system_dict_data` VALUES (1490, 0, '中性', '3', 'product_record_attribute', 0, 'default', '', NULL, '1', '2022-07-05 15:32:01', '1', '2022-07-05 15:32:01', b'0', 'neutral_card'); INSERT INTO `system_dict_data` VALUES (1491, 0, '混牌', '4', 'product_record_attribute', 0, 'default', '', NULL, '1', '2022-07-05 15:32:34', '1', '2022-07-05 15:32:34', b'0', 'mixture_card'); INSERT INTO `system_dict_data` VALUES (1492, 0, '控货中', '0', 'control_goods_status', 0, 'default', '', NULL, '1', '2022-07-05 15:35:25', '1', '2022-07-05 15:36:25', b'0', 'control_goods_having'); INSERT INTO `system_dict_data` VALUES (1493, 0, '已放完货', '1', 'control_goods_status', 0, 'default', '', NULL, '1', '2022-07-05 15:36:11', '1', '2022-07-05 15:36:11', b'0', 'control_goods_haved'); INSERT INTO `system_dict_data` VALUES (1494, 0, '部分控货', '2', 'control_goods_status', 0, 'default', '', NULL, '1', '2022-07-05 15:37:04', '1', '2022-07-05 15:37:13', b'0', 'control_goods_part'); INSERT INTO `system_dict_data` VALUES (1495, 0, '内陆运输费', '10', 'disbursement_type', 0, 'default', '', NULL, '1', '2022-07-05 16:00:08', '1', '2022-07-05 16:00:08', b'0', 'inland_transport'); INSERT INTO `system_dict_data` VALUES (1496, 0, '打木架/托', '20', 'disbursement_type', 0, 'default', '', NULL, '1', '2022-07-05 16:01:12', '1', '2022-07-05 16:01:12', b'0', 'pack_support'); INSERT INTO `system_dict_data` VALUES (1497, 0, '纸箱打包', '30', 'disbursement_type', 0, 'default', '', NULL, '1', '2022-07-05 16:01:40', '1', '2022-07-05 16:01:40', b'0', 'carton_packaging'); INSERT INTO `system_dict_data` VALUES (1498, 0, '草稿', '0', 'order_status', 0, 'default', '', '草稿', '1', '2022-07-05 20:49:38', '125', '2022-07-09 17:14:58', b'0', 'draft'); INSERT INTO `system_dict_data` VALUES (1499, 1, '未设置产品价格', '1', 'order_status', 0, 'default', '', NULL, '1', '2022-07-05 20:59:47', '1', '2022-07-09 16:34:49', b'1', 'not_set_price'); INSERT INTO `system_dict_data` VALUES (1500, 2, '待入仓', '2', 'order_status', 0, 'default', '', '已下单，待入仓', '1', '2022-07-05 21:00:29', '125', '2022-07-11 18:28:56', b'0', 'to_be_warehoused'); INSERT INTO `system_dict_data` VALUES (1501, 1, '发货人', '1', 'drawee', 0, 'default', '', '自定义配置中一样使用', '1', '2022-07-05 23:18:08', '1', '2022-07-05 23:20:13', b'0', 'consignor'); INSERT INTO `system_dict_data` VALUES (1502, 0, '收货人', '2', 'drawee', 0, 'default', '', '自定义配置中一样使用', '1', '2022-07-05 23:18:44', '1', '2022-10-11 22:32:04', b'0', 'consignee'); INSERT INTO `system_dict_data` VALUES (1503, 3, '自定义', '3', 'drawee', 0, 'default', '', NULL, '1', '2022-07-05 23:19:12', '1', '2022-07-05 23:19:12', b'0', 'custom'); INSERT INTO `system_dict_data` VALUES (1504, 0, '运费', 'freight', 'custom_drawee', 0, 'default', '', '1发货人 2收货人', '125', '2022-07-08 21:03:56', '125', '2022-07-08 21:05:07', b'0', 'freight'); INSERT INTO `system_dict_data` VALUES (1505, 1, '清关费', 'clearanceFee', 'custom_drawee', 0, 'default', '', '1发货人 2收货人', '125', '2022-07-08 21:07:17', '125', '2022-07-08 21:07:17', b'0', 'clearanceFee'); INSERT INTO `system_dict_data` VALUES (1506, 2, '其他费用', 'otherFee', 'custom_drawee', 0, 'default', '', '1发货人 2收货人', '125', '2022-07-08 21:13:36', '125', '2022-07-08 21:15:03', b'0', 'otherFee'); INSERT INTO `system_dict_data` VALUES (1507, 3, '报关费', 'customsDeclarationFee', 'custom_drawee', 0, 'default', '', '1发货人 2收货人', '125', '2022-07-08 21:14:47', '125', '2022-07-08 21:14:47', b'0', 'customsDeclarationFee'); INSERT INTO `system_dict_data` VALUES (1508, 4, '保价费', 'premium', 'custom_drawee', 0, 'default', '', '1发货人 2收货人', '125', '2022-07-08 21:16:10', '125', '2022-07-08 21:16:10', b'0', 'premium'); INSERT INTO `system_dict_data` VALUES (1509, 5, '单证报关费', 'documentDeclarationFee', 'custom_drawee', 0, 'default', '', '1发货人 2收货人', '125', '2022-07-08 21:17:28', '125', '2022-07-08 21:17:28', b'0', 'documentDeclarationFee'); INSERT INTO `system_dict_data` VALUES (1510, 6, '仓租费', 'warehouseRent', 'custom_drawee', 0, 'default', '', '1发货人 2收货人', '125', '2022-07-08 21:18:49', '125', '2022-07-08 21:18:58', b'0', 'warehouseRent'); INSERT INTO `system_dict_data` VALUES (1511, 7, '纸箱打包费', 'cartonPackingFee', 'custom_drawee', 0, 'default', '', '1发货人 2收货人', '125', '2022-07-08 21:19:49', '125', '2022-07-08 21:19:49', b'0', 'cartonPackingFee'); INSERT INTO `system_dict_data` VALUES (1512, 8, '内陆运输费', 'inlandTransportationFee', 'custom_drawee', 0, 'default', '', '1发货人 2收货人', '125', '2022-07-08 21:20:52', '125', '2022-07-08 21:20:52', b'0', 'inlandTransportationFee'); INSERT INTO `system_dict_data` VALUES (1513, 9, '卸货费', 'unloadingFee', 'custom_drawee', 0, 'default', '', '1发货人 2收货人', '125', '2022-07-08 21:21:27', '125', '2022-07-08 21:21:27', b'0', 'unloadingFee'); INSERT INTO `system_dict_data` VALUES (1514, 10, '叉车费', 'forkliftFee', 'custom_drawee', 0, 'default', '', '1发货人 2收货人', '125', '2022-07-08 21:22:17', '125', '2022-07-08 21:22:17', b'0', 'forkliftFee'); INSERT INTO `system_dict_data` VALUES (1515, 0, '未设置产品价格', '-1', 'order_item_status', 0, 'default', '', '未设置产品价格', '125', '2022-07-09 16:45:34', '125', '2022-07-11 18:27:13', b'0', 'not_set_price'); INSERT INTO `system_dict_data` VALUES (1516, 1, '待入仓', '0', 'order_item_status', 0, 'default', '', '正常', '125', '2022-07-09 16:46:41', '1', '2022-08-30 23:45:21', b'0', 'normal'); INSERT INTO `system_dict_data` VALUES (1517, 2, '审批中', '1', 'order_item_status', 0, 'default', '', '优惠审核中', '125', '2022-07-09 16:47:39', '125', '2022-07-29 20:56:45', b'0', 'under_review'); INSERT INTO `system_dict_data` VALUES (1518, 3, '佣金审核中', '2', 'order_item_status', 0, 'default', '', '佣金审核中', '125', '2022-07-09 16:49:01', '125', '2022-07-21 22:56:24', b'1', 'commission_review'); INSERT INTO `system_dict_data` VALUES (1519, 4, '管理折扣审核', '3', 'order_item_status', 0, 'default', '', '管理折扣申请', '125', '2022-07-09 17:08:13', '125', '2022-07-21 22:55:32', b'1', 'manage_discount_review'); INSERT INTO `system_dict_data` VALUES (1520, 5, '重货优惠审核', '4', 'order_item_status', 0, 'default', '', '重货优惠审核', '125', '2022-07-09 17:10:02', '125', '2022-07-21 22:55:28', b'1', 'heavy_cargo_discount_review'); INSERT INTO `system_dict_data` VALUES (1521, 6, '泡货优惠审核', '5', 'order_item_status', 0, 'default', '', '泡货优惠审核', '125', '2022-07-09 17:11:36', '125', '2022-07-21 22:55:26', b'1', 'buy_goods_discount_review'); INSERT INTO `system_dict_data` VALUES (1522, 1, '未报价', '1', 'order_status', 1, 'default', '', '未设置产品价格', '125', '2022-07-09 17:14:31', '125', '2022-08-28 00:31:24', b'1', 'not_set_price'); INSERT INTO `system_dict_data` VALUES (1523, 0, '20GP', '1', 'box_type', 0, 'default', '', NULL, '126', '2022-07-10 15:13:01', '126', '2022-07-11 14:41:18', b'1', '20GP'); INSERT INTO `system_dict_data` VALUES (1524, 1, '40HQ', '2', 'box_type', 0, 'default', '', NULL, '126', '2022-07-10 15:14:12', '126', '2022-07-11 14:41:20', b'1', '40HQ'); INSERT INTO `system_dict_data` VALUES (1525, 0, '等待入库', '1', 'order_warehouse_in_status', 0, 'default', '', NULL, '1', '2022-07-11 17:29:42', '1', '2022-09-28 10:15:09', b'1', 'wait_to_in'); INSERT INTO `system_dict_data` VALUES (1526, 0, '多了', '2', 'order_warehouse_in_status', 0, 'default', '', NULL, '1', '2022-07-11 17:30:58', '1', '2022-09-28 10:15:11', b'1', 'more_than'); INSERT INTO `system_dict_data` VALUES (1527, 0, '少了', '3', 'order_warehouse_in_status', 0, 'default', '', NULL, '1', '2022-07-11 17:31:10', '1', '2022-09-28 10:15:13', b'1', 'less_than'); INSERT INTO `system_dict_data` VALUES (1528, 0, '准确到齐', '4', 'order_warehouse_in_status', 0, 'default', '', NULL, '1', '2022-07-11 17:32:02', '1', '2022-09-28 10:15:16', b'1', 'correct'); INSERT INTO `system_dict_data` VALUES (1529, 3, '入仓中', '3', 'order_status', 0, 'default', '', '入仓中', '125', '2022-07-11 18:30:33', '125', '2022-08-26 01:17:18', b'0', 'Warehousing'); INSERT INTO `system_dict_data` VALUES (1530, 4, '费用申请', '4', 'order_status', 1, 'default', '', '费用申请', '125', '2022-07-11 18:31:35', '125', '2022-08-28 00:38:24', b'1', 'cost_apply'); INSERT INTO `system_dict_data` VALUES (1531, 5, '已入仓', '5', 'order_status', 0, 'default', '', '订单入仓状态(字典 order_warehouse_in_status)', '125', '2022-07-11 18:33:02', '125', '2022-07-11 18:56:55', b'0', 'in_warehouse'); INSERT INTO `system_dict_data` VALUES (1532, 6, '已出货', '6', 'order_status', 0, 'default', '', '订单出货状态(字典 order_shipment_state)', '125', '2022-07-11 18:33:47', '125', '2022-08-26 01:24:59', b'1', 'shipment'); INSERT INTO `system_dict_data` VALUES (1533, 99, '订单异常', '99', 'order_status', 0, 'default', '', '订单异常状态(字典 order_abnormal_state)', '125', '2022-07-11 18:36:41', '125', '2022-08-26 01:33:56', b'1', 'abnormal'); INSERT INTO `system_dict_data` VALUES (1534, 7, '已退仓', '7', 'order_status', 0, 'default', '', '已退仓', '125', '2022-07-11 18:38:05', '125', '2022-08-26 01:38:40', b'0', 'Withdrawn'); INSERT INTO `system_dict_data` VALUES (1535, 88, '取消订单', '88', 'order_status', 0, 'default', '', '取消订单', '125', '2022-07-11 18:43:30', '125', '2022-07-11 18:43:37', b'0', 'cancel'); INSERT INTO `system_dict_data` VALUES (1536, 17, '未收款', '17', 'order_status', 0, 'default', '', '未收款', '125', '2022-07-11 18:50:23', '125', '2022-08-28 00:40:30', b'0', 'uncollected'); INSERT INTO `system_dict_data` VALUES (1537, 9, '已付款', '9', 'order_status', 1, 'default', '', '已付款', '125', '2022-07-11 18:51:10', '125', '2022-08-28 00:32:01', b'1', 'paid'); INSERT INTO `system_dict_data` VALUES (1538, 20, '已提货', '20', 'order_status', 0, 'default', '', '已提货', '125', '2022-07-11 18:52:14', '125', '2022-08-28 00:41:20', b'0', 'picked_up'); INSERT INTO `system_dict_data` VALUES (1539, 8, '调仓中', '8', 'order_status', 0, 'default', '', '调仓中', '125', '2022-07-11 18:52:52', '125', '2022-08-28 00:34:55', b'0', 'Warehouse adjustment'); INSERT INTO `system_dict_data` VALUES (1540, 0, '正常', '0', 'order_abnormal_state', 0, 'default', '', '正常', '125', '2022-07-11 19:01:55', '125', '2022-07-11 19:01:55', b'0', 'normal'); INSERT INTO `system_dict_data` VALUES (1541, 1, '待收款', '1', 'receipt_state', 0, 'default', '', NULL, '1', '2022-07-11 21:22:18', '1', '2022-08-31 10:25:10', b'0', '待收款'); INSERT INTO `system_dict_data` VALUES (1542, 2, '待核销', '2', 'receipt_state', 0, 'default', '', NULL, '1', '2022-07-11 21:22:41', '1', '2022-08-31 10:25:04', b'0', '待核销'); INSERT INTO `system_dict_data` VALUES (1543, 3, '已部分核销', '3', 'receipt_state', 0, 'default', '', NULL, '1', '2022-07-11 21:23:30', '1', '2022-08-31 10:24:58', b'0', '已部分核销'); INSERT INTO `system_dict_data` VALUES (1544, 4, '已核销', '4', 'receipt_state', 0, 'default', '', NULL, '1', '2022-07-11 21:23:54', '1', '2022-08-31 10:24:47', b'0', '已核销'); INSERT INTO `system_dict_data` VALUES (1545, 1, '待订舱', '1', 'box_shipment_status', 0, 'default', '', NULL, '1', '2022-07-12 15:47:40', '1', '2022-07-12 15:47:40', b'0', 'to be booked'); INSERT INTO `system_dict_data` VALUES (1546, 2, '已订舱-待预装', '2', 'box_shipment_status', 0, 'default', '', NULL, '1', '2022-07-12 15:48:11', '1', '2022-07-14 15:34:59', b'0', 'booked space'); INSERT INTO `system_dict_data` VALUES (1547, 3, '待预装', '3', 'box_shipment_status', 0, 'default', '', NULL, '1', '2022-07-12 15:48:36', '1', '2022-07-14 15:34:48', b'1', 'to be pre installed'); INSERT INTO `system_dict_data` VALUES (1548, 0, '中文', 'zh_CN', 'system_locale', 0, 'default', '', NULL, '1', '2022-07-12 18:31:53', '1', '2022-07-12 21:26:59', b'0', 'Chinese'); INSERT INTO `system_dict_data` VALUES (1549, 0, 'English', 'en_US', 'system_locale', 0, 'default', '', NULL, '1', '2022-07-12 18:32:17', '1', '2022-07-12 21:25:47', b'0', 'English'); INSERT INTO `system_dict_data` VALUES (1550, 0, '入仓修改', '1', 'order_warehouse_approval_type', 0, 'default', '', NULL, '1', '2022-07-13 16:37:00', '1', '2022-07-13 16:37:00', b'0', 'warehouse_in_update'); INSERT INTO `system_dict_data` VALUES (1551, 0, '调仓', '2', 'order_warehouse_approval_type', 0, 'default', '', NULL, '1', '2022-07-13 16:38:24', '1', '2022-07-13 16:38:24', b'0', 'warehouse_in_transfer'); INSERT INTO `system_dict_data` VALUES (1552, 0, '退仓', '3', 'order_warehouse_approval_type', 0, 'default', '', NULL, '1', '2022-07-13 16:39:02', '1', '2022-07-13 16:39:37', b'0', 'warehouse_in_to_return'); INSERT INTO `system_dict_data` VALUES (1553, 0, '创建时间', 'CreateTime', 'begintime_type_endtime', 0, 'default', '', NULL, '1', '2022-07-15 15:20:22', '119', '2022-07-23 22:42:40', b'0', 'CreateTime'); INSERT INTO `system_dict_data` VALUES (1554, 0, '到港时间', 'DaogangTime', 'begintime_type_endtime', 0, 'default', '', NULL, '1', '2022-07-15 15:43:21', '119', '2022-07-25 01:03:18', b'0', 'DaogangTime'); INSERT INTO `system_dict_data` VALUES (1555, 0, '已装柜时间', 'LoadTime', 'begintime_type_endtime', 0, 'default', '', NULL, '1', '2022-07-15 15:43:55', '119', '2022-07-25 01:03:26', b'0', 'LoadTime'); INSERT INTO `system_dict_data` VALUES (1556, 0, '已预装时间', 'PreloadTime', 'begintime_type_endtime', 0, 'default', '', NULL, '1', '2022-07-15 15:44:25', '119', '2022-07-25 01:03:36', b'0', 'PreloadTime'); INSERT INTO `system_dict_data` VALUES (1557, 0, '清关时间', 'QingguanTime', 'begintime_type_endtime', 0, 'default', '', NULL, '1', '2022-07-15 15:44:49', '119', '2022-07-25 01:04:14', b'0', 'QingguanTime'); INSERT INTO `system_dict_data` VALUES (1558, 0, '入仓时间', 'RucangTime', 'begintime_type_endtime', 0, 'default', '', NULL, '1', '2022-07-15 15:45:16', '119', '2022-07-25 01:04:23', b'0', 'RucangTime'); INSERT INTO `system_dict_data` VALUES (1559, 0, '拆单时间', 'SplitTime', 'begintime_type_endtime', 0, 'default', '', NULL, '1', '2022-07-15 15:45:41', '119', '2022-07-25 01:04:32', b'0', 'SplitTime'); INSERT INTO `system_dict_data` VALUES (1560, 0, '提货时间', 'TakeTime', 'begintime_type_endtime', 0, 'default', '', NULL, '1', '2022-07-15 15:46:00', '119', '2022-07-25 01:04:40', b'0', 'TakeTime'); INSERT INTO `system_dict_data` VALUES (1561, 0, '已卸柜时间', 'UploadTime', 'begintime_type_endtime', 0, 'default', '', NULL, '1', '2022-07-15 15:46:21', '119', '2022-07-25 01:04:49', b'0', 'UploadTime'); INSERT INTO `system_dict_data` VALUES (1562, 0, '2022-07-17 00:00:00', '1', 'ecash_init', 0, 'default', '', NULL, '1', '2022-07-17 09:09:34', '1', '2022-07-17 09:09:34', b'0', '2022-07-17 00:00:00'); INSERT INTO `system_dict_data` VALUES (1563, 0, '2022-07-30 00:00:00', '2', 'ecash_init', 0, 'default', '', NULL, '1', '2022-07-17 09:10:41', '1', '2022-07-17 09:10:41', b'0', '2022-07-30 00:00:00'); INSERT INTO `system_dict_data` VALUES (1564, 0, '2022-08-17 00:00:00', '3', 'ecash_init', 0, 'default', '', NULL, '1', '2022-07-17 09:11:02', '1', '2022-07-17 09:11:02', b'0', '2022-08-17 00:00:00'); INSERT INTO `system_dict_data` VALUES (1565, 0, '2022-08-30 00:00:00', '4', 'ecash_init', 0, 'default', '', NULL, '1', '2022-07-17 09:11:30', '1', '2022-07-17 09:11:30', b'0', '2022-08-30 00:00:00'); INSERT INTO `system_dict_data` VALUES (1566, 0, '汇率已过期！请联系管理员！', '5', 'ecash_init', 0, 'default', '', NULL, '1', '2022-07-17 09:12:18', '1', '2022-07-17 09:12:18', b'0', '汇率已过期！请联系管理员！'); INSERT INTO `system_dict_data` VALUES (1567, 0, '电放', '1', 'suing_method', 0, 'default', '', NULL, '119', '2022-07-17 14:18:33', '119', '2022-07-17 14:18:33', b'0', '电放'); INSERT INTO `system_dict_data` VALUES (1568, 0, '正本', '2', 'suing_method', 0, 'default', '', NULL, '119', '2022-07-17 14:18:49', '119', '2022-07-17 14:18:49', b'0', '正本'); INSERT INTO `system_dict_data` VALUES (1569, 13, '未报价', 'order_no_quote_exception', 'order_error_type', 0, 'default', '', NULL, '1', '2022-07-17 18:50:59', '1', '2022-07-17 18:50:59', b'0', 'no quote'); INSERT INTO `system_dict_data` VALUES (1570, 0, '待处理', 'pending', 'order_no_quote_exception_result', 0, 'default', '', NULL, '123', '2022-07-17 22:45:40', '123', '2022-07-17 22:45:40', b'0', 'pending'); INSERT INTO `system_dict_data` VALUES (1571, 0, '待处理', 'pending', 'order_superfluous_box_exception_result', 0, 'default', '', NULL, '123', '2022-07-17 22:46:18', '123', '2022-07-17 22:46:18', b'0', 'pending'); INSERT INTO `system_dict_data` VALUES (1572, 1, '确认送错', 'confirm_send_error', 'order_superfluous_box_exception_result', 0, 'default', '', NULL, '123', '2022-07-17 22:46:41', '123', '2022-07-17 22:46:41', b'0', 'send error'); INSERT INTO `system_dict_data` VALUES (1573, 2, '已通过客户来/去电确认', 'confirm_phone', 'order_superfluous_box_exception_result', 0, 'default', '', NULL, '123', '2022-07-17 22:46:59', '123', '2022-07-17 22:46:59', b'0', 'phone'); INSERT INTO `system_dict_data` VALUES (1574, 0, '待处理', 'pending', 'order_lack_box_exception_result', 0, 'default', '', NULL, '123', '2022-07-17 22:47:22', '123', '2022-07-17 22:47:22', b'0', 'pending'); INSERT INTO `system_dict_data` VALUES (1575, 1, '确认为已齐', 'confirm_complete', 'order_lack_box_exception_result', 0, 'default', '', NULL, '123', '2022-07-17 22:47:41', '123', '2022-07-17 22:47:41', b'0', 'complete'); INSERT INTO `system_dict_data` VALUES (1576, 2, '确认为未齐', 'confirm_no_complete', 'order_lack_box_exception_result', 0, 'default', '', NULL, '123', '2022-07-17 22:48:01', '123', '2022-07-17 22:48:01', b'0', 'no complete'); INSERT INTO `system_dict_data` VALUES (1577, 0, '待处理', 'pending', 'order_pay_exception_result', 0, 'default', '', NULL, '123', '2022-07-17 22:48:34', '123', '2022-07-17 22:48:34', b'0', 'pending'); INSERT INTO `system_dict_data` VALUES (1578, 1, '不需要预付', 'no_pay', 'order_pay_exception_result', 0, 'default', '', NULL, '123', '2022-07-17 22:48:57', '123', '2022-07-17 22:48:57', b'0', 'no pay'); INSERT INTO `system_dict_data` VALUES (1579, 2, '已核销预付商品应收明细，超过订单总运费的80%', 'pay_total_amount', 'order_pay_exception_result', 0, 'default', '', NULL, '123', '2022-07-17 22:49:10', '1', '2022-08-30 22:19:28', b'0', 'pay_total_amount'); INSERT INTO `system_dict_data` VALUES (1580, 0, '海关查验扣货', 'customs', 'order_miss_exception_result', 0, 'default', '', NULL, '123', '2022-07-17 22:49:43', '123', '2022-07-17 22:49:43', b'0', 'customs check'); INSERT INTO `system_dict_data` VALUES (1581, 1, '仓库清点失误', 'warehouse_error', 'order_miss_exception_result', 0, 'default', '', NULL, '123', '2022-07-17 22:49:58', '123', '2022-07-17 22:49:58', b'0', 'warehouse error'); INSERT INTO `system_dict_data` VALUES (1582, 2, '中国仓库漏装', 'warehouse_miss', 'order_miss_exception_result', 0, 'default', '', NULL, '123', '2022-07-17 22:50:13', '123', '2022-07-17 22:50:13', b'0', 'warehouse miss'); INSERT INTO `system_dict_data` VALUES (1583, 3, 'manifest核对错误', 'mainfest_error', 'order_miss_exception_result', 0, 'default', '', NULL, '123', '2022-07-17 22:50:28', '123', '2022-07-17 22:50:28', b'0', 'mainfest_error'); INSERT INTO `system_dict_data` VALUES (1584, 0, '封柜图与卸柜图不一致', 'image_diff', 'order_miss_exception_result', 0, 'default', '', NULL, '123', '2022-07-17 22:50:48', '123', '2022-07-17 22:50:48', b'0', 'image different'); INSERT INTO `system_dict_data` VALUES (1585, 0, '海关查验扣货', 'customs', 'order_superfluous_goods_exception_result', 0, 'default', '', NULL, '123', '2022-07-17 22:51:14', '1', '2022-09-08 17:50:45', b'0', 'customs'); INSERT INTO `system_dict_data` VALUES (1586, 0, '海关查验扣货', 'customs', 'order_damage_exception_result', 0, 'default', '', NULL, '123', '2022-07-17 22:51:46', '1', '2022-09-08 17:47:25', b'0', 'customs'); INSERT INTO `system_dict_data` VALUES (1587, 0, '海关查验扣货', 'customs', 'order_in_water_exception_result', 0, 'default', '', NULL, '123', '2022-07-17 22:52:28', '1', '2022-09-08 17:43:15', b'0', 'customs'); INSERT INTO `system_dict_data` VALUES (1588, 0, '设为普货', 'general_cargo', 'order_heavy_cargo_exception_result', 0, 'default', '', NULL, '123', '2022-07-17 22:53:13', '123', '2022-07-17 22:53:13', b'0', 'general cargo'); INSERT INTO `system_dict_data` VALUES (1589, 1, '设为已处理', 'process', 'order_heavy_cargo_exception_result', 0, 'default', '', NULL, '123', '2022-07-17 22:53:27', '123', '2022-07-17 22:53:27', b'0', 'process'); INSERT INTO `system_dict_data` VALUES (1590, 0, '已通过', 'pass', 'order_doc_exception_result', 0, 'default', '', NULL, '123', '2022-07-17 22:53:49', '123', '2022-07-17 22:53:49', b'0', 'pass'); INSERT INTO `system_dict_data` VALUES (1591, 1, '不符合重新上传', 'inconformity', 'order_doc_exception_result', 0, 'default', '', NULL, '123', '2022-07-17 22:54:00', '123', '2022-07-17 22:54:00', b'0', 'inconformity'); INSERT INTO `system_dict_data` VALUES (1592, 0, '已和发货人核对', 'confirm_check', 'order_consignor_exception_result', 0, 'default', '', NULL, '123', '2022-07-17 22:54:20', '123', '2022-07-17 22:54:20', b'0', 'confirm_check'); INSERT INTO `system_dict_data` VALUES (1593, 0, '代收货款', 'cod', 'order_cod_exception_result', 0, 'default', '', NULL, '123', '2022-07-17 22:54:41', '123', '2022-07-17 22:54:41', b'0', 'cod'); INSERT INTO `system_dict_data` VALUES (1594, 1, '不需要代收货款', 'not_cod', 'order_cod_exception_result', 0, 'default', '', NULL, '123', '2022-07-17 22:54:53', '123', '2022-07-17 22:54:53', b'0', 'not_cod'); INSERT INTO `system_dict_data` VALUES (1595, 0, '已跟客户确认可发', 'confirm_yes', 'order_other_exception_result', 0, 'default', '', NULL, '123', '2022-07-17 22:55:20', '123', '2022-07-17 22:55:20', b'0', 'confirm yes'); INSERT INTO `system_dict_data` VALUES (1596, 1, '已跟客户确认该货品不可发(退仓)', 'confirm_no', 'order_other_exception_result', 0, 'default', '', NULL, '123', '2022-07-17 22:55:40', '123', '2022-07-17 22:55:40', b'0', 'confirm no'); INSERT INTO `system_dict_data` VALUES (1597, 1, '运费', '1', 'fee_type', 0, 'default', '', NULL, '122', '2022-07-18 22:40:23', '115', '2022-07-25 20:51:39', b'1', 'freight'); INSERT INTO `system_dict_data` VALUES (1598, 0, '到付', '0', 'pay_advance', 0, 'default', '', NULL, '119', '2022-07-19 14:52:20', '119', '2022-07-19 14:52:20', b'0', '到付'); INSERT INTO `system_dict_data` VALUES (1599, 0, '预付', '1', 'pay_advance', 0, 'default', '', NULL, '119', '2022-07-19 14:52:31', '119', '2022-07-19 14:52:31', b'0', '预付'); INSERT INTO `system_dict_data` VALUES (1600, 1, '中国预付', '1', 'pay_type', 0, 'default', '', NULL, '122', '2022-07-19 20:03:41', '115', '2022-07-24 18:12:57', b'1', 'China Prepaid'); INSERT INTO `system_dict_data` VALUES (1601, 0, '是', '1', 'receive_flag', 0, 'default', '', NULL, '122', '2022-07-19 20:25:17', '122', '2022-07-19 20:25:17', b'0', 'yes'); INSERT INTO `system_dict_data` VALUES (1602, 0, '否', '0', 'receive_flag', 0, 'default', '', NULL, '122', '2022-07-19 20:25:31', '122', '2022-07-19 20:25:31', b'0', 'No'); INSERT INTO `system_dict_data` VALUES (1603, 1, 'PIL', 'PIL', 'shipment_shipping_company_type', 0, 'default', '', NULL, '1', '2022-07-20 19:47:24', '1', '2022-07-21 16:52:37', b'1', 'PIL'); INSERT INTO `system_dict_data` VALUES (1604, 2, 'MSK', 'MSK', 'shipment_shipping_company_type', 0, 'default', '', NULL, '1', '2022-07-20 19:47:51', '1', '2022-07-21 16:53:15', b'1', 'MSK'); INSERT INTO `system_dict_data` VALUES (1605, 3, 'CMA', 'CMA', 'shipment_shipping_company_type', 0, 'default', '', NULL, '1', '2022-07-20 19:48:07', '1', '2022-07-21 16:53:40', b'1', 'CMA'); INSERT INTO `system_dict_data` VALUES (1606, 4, 'COSCO', 'COSCO', 'shipment_shipping_company_type', 0, 'default', '', NULL, '1', '2022-07-20 19:48:17', '1', '2022-07-21 16:54:16', b'1', 'COSCO'); INSERT INTO `system_dict_data` VALUES (1607, 5, 'ZIM', 'ZIM', 'shipment_shipping_company_type', 0, 'default', '', NULL, '1', '2022-07-20 19:48:25', '1', '2022-07-21 17:01:10', b'1', 'ZIM'); INSERT INTO `system_dict_data` VALUES (1608, 6, 'ONE', 'ONE', 'shipment_shipping_company_type', 0, 'default', '', NULL, '1', '2022-07-20 19:48:33', '1', '2022-07-21 17:01:38', b'1', 'ONE'); INSERT INTO `system_dict_data` VALUES (1609, 7, 'OOCL', 'OOCL', 'shipment_shipping_company_type', 0, 'default', '', NULL, '1', '2022-07-20 19:48:42', '1', '2022-07-21 17:02:06', b'1', 'OOCL'); INSERT INTO `system_dict_data` VALUES (1610, 8, 'MSC', 'MSC', 'shipment_shipping_company_type', 0, 'default', '', NULL, '1', '2022-07-20 19:48:57', '1', '2022-07-21 17:02:34', b'1', 'MSC'); INSERT INTO `system_dict_data` VALUES (1611, 9, 'HPL', 'HPL', 'shipment_shipping_company_type', 0, 'default', '', NULL, '1', '2022-07-20 19:49:10', '1', '2022-07-21 17:03:12', b'1', 'HPL'); INSERT INTO `system_dict_data` VALUES (1612, 1, '已派车，待提柜', '1', 'shipment_trailer_status', 0, 'default', '', NULL, '1', '2022-07-20 22:52:28', '1', '2022-07-20 22:52:28', b'0', '已派车，待提柜'); INSERT INTO `system_dict_data` VALUES (1613, 1, '已提柜，待还柜', '2', 'shipment_trailer_status', 0, 'default', '', NULL, '1', '2022-07-20 22:52:38', '1', '2022-07-20 22:52:38', b'0', '已提柜，待还柜'); INSERT INTO `system_dict_data` VALUES (1614, 3, '已还柜', '3', 'shipment_trailer_status', 0, 'default', '', NULL, '1', '2022-07-20 22:52:57', '1', '2022-07-20 22:52:57', b'0', '已还柜'); INSERT INTO `system_dict_data` VALUES (1615, 99, '已取消', '-1', 'order_status', 0, 'default', '', '已取消', '125', '2022-07-20 23:59:21', '125', '2022-07-20 23:59:50', b'1', 'cancel'); INSERT INTO `system_dict_data` VALUES (1616, 1, '中国预付', '1', 'payment_type', 0, 'default', '', NULL, '1', '2022-07-21 13:04:35', '115', '2022-07-24 18:10:59', b'0', 'China Prepaid'); INSERT INTO `system_dict_data` VALUES (1617, 3, '加纳预付', '3', 'payment_type', 0, 'default', '', NULL, '1', '2022-07-21 13:05:46', '115', '2022-07-24 18:11:37', b'0', 'Ghana Prepaid'); INSERT INTO `system_dict_data` VALUES (1618, 2, '尼日利亚预付', '2', 'payment_type', 0, 'default', '', NULL, '1', '2022-07-21 13:06:26', '115', '2022-07-24 18:11:55', b'0', 'Nigeria Prepaid'); INSERT INTO `system_dict_data` VALUES (1619, 4, '到付', '4', 'payment_type', 0, 'default', '', NULL, '1', '2022-07-21 13:10:14', '115', '2022-07-24 18:11:48', b'0', 'Cash on delivery'); INSERT INTO `system_dict_data` VALUES (1620, 15, '调仓申请中', '15', 'order_status', 0, 'default', '', '调仓申请中', '1', '2022-07-21 15:37:40', '1', '2022-07-21 15:38:38', b'1', 'warehouse_adjust_apply'); INSERT INTO `system_dict_data` VALUES (1621, 16, '航空公司', '10', 'company_type', 0, 'default', '', NULL, '115', '2022-07-21 16:46:15', '115', '2022-07-21 16:46:27', b'0', 'hkgs'); INSERT INTO `system_dict_data` VALUES (1622, 1, '优惠申请', '1', 'order_approval_type', 0, 'default', '', '优惠申请', '125', '2022-07-21 23:20:36', '125', '2022-07-21 23:20:36', b'0', 'discount_apply'); INSERT INTO `system_dict_data` VALUES (1623, 2, '管理优惠', '2', 'order_approval_type', 0, 'default', '', '管理优惠', '125', '2022-07-21 23:22:27', '125', '2022-08-27 11:56:01', b'0', 'admin_discount'); INSERT INTO `system_dict_data` VALUES (1624, 3, '佣金设置', '3', 'order_approval_type', 0, 'default', '', '佣金设置', '125', '2022-07-21 23:23:12', '125', '2022-07-21 23:23:12', b'0', 'commission_set'); INSERT INTO `system_dict_data` VALUES (1625, 4, '重货优惠', '4', 'order_approval_type', 0, 'default', '', '重货优惠', '125', '2022-07-21 23:23:59', '125', '2022-07-21 23:23:59', b'0', 'weight_discount'); INSERT INTO `system_dict_data` VALUES (1626, 5, '泡货优惠', '5', 'order_approval_type', 0, 'default', '', '泡货优惠', '125', '2022-07-21 23:24:51', '125', '2022-07-21 23:24:51', b'0', 'bubble_discount'); INSERT INTO `system_dict_data` VALUES (1627, 1, '审核中', 'discount_pending', 'order_discount_apply', 0, 'default', '', '审核中discount_pending', '125', '2022-07-21 23:28:12', '125', '2022-07-21 23:29:21', b'0', 'pending'); INSERT INTO `system_dict_data` VALUES (1628, 2, '审核成功', 'discount_success', 'order_discount_apply', 0, 'default', '', '审核成功discount_success', '125', '2022-07-21 23:29:02', '125', '2022-07-21 23:29:15', b'0', 'success'); INSERT INTO `system_dict_data` VALUES (1629, 0, '审核失败', 'discount_fail', 'order_discount_apply', 0, 'default', '', '审核失败discount_fail', '125', '2022-07-21 23:30:24', '125', '2022-07-21 23:30:24', b'0', 'fail'); INSERT INTO `system_dict_data` VALUES (1630, 18, '部分核销', '18', 'order_status', 0, 'default', '', '部分核销', '125', '2022-07-22 22:19:24', '125', '2022-08-28 00:40:47', b'0', 'partial_write'); INSERT INTO `system_dict_data` VALUES (1631, 19, '已核销', '19', 'order_status', 0, 'default', '', '已核销', '125', '2022-07-22 22:20:07', '125', '2022-08-28 00:41:05', b'0', 'written_off'); INSERT INTO `system_dict_data` VALUES (1632, 0, '注册就送', '3', 'suitable_user_type', 0, 'danger', '', '类型danger用来标识优惠券显示', '119', '2022-07-23 13:58:27', '119', '2022-07-23 14:02:36', b'0', '注册就送'); INSERT INTO `system_dict_data` VALUES (1633, 0, '审核中', '1', 'order_warehouse_adjust_status', 0, 'default', '', NULL, '1', '2022-07-23 16:14:36', '1', '2022-07-23 16:14:36', b'0', 'applying'); INSERT INTO `system_dict_data` VALUES (1634, 0, '审核已通过', '2', 'order_warehouse_adjust_status', 0, 'default', '', NULL, '1', '2022-07-23 16:15:02', '1', '2022-07-23 16:15:35', b'0', 'passed'); INSERT INTO `system_dict_data` VALUES (1635, 0, '审核已拒绝', '3', 'order_warehouse_adjust_status', 0, 'default', '', NULL, '1', '2022-07-23 16:15:25', '1', '2022-07-23 16:15:25', b'0', 'rejected'); INSERT INTO `system_dict_data` VALUES (1636, 0, '已出仓', '4', 'order_warehouse_adjust_status', 0, 'default', '', NULL, '1', '2022-07-23 16:16:39', '1', '2022-07-23 16:18:21', b'0', 'deliveries'); INSERT INTO `system_dict_data` VALUES (1637, 0, '已到仓', '5', 'order_warehouse_adjust_status', 0, 'default', '', NULL, '1', '2022-07-23 16:19:19', '1', '2022-07-23 16:19:19', b'0', 'arrivals'); INSERT INTO `system_dict_data` VALUES (1638, 0, '自提', '1', 'pick_type', 0, 'default', '', NULL, '1', '2022-07-23 16:51:27', '1', '2022-07-23 16:51:27', b'0', '自提'); INSERT INTO `system_dict_data` VALUES (1639, 1, '送货上门', '2', 'pick_type', 0, 'default', '', NULL, '1', '2022-07-23 16:51:51', '1', '2022-07-23 16:52:01', b'0', '送货上门'); INSERT INTO `system_dict_data` VALUES (1640, 2, '尼日利亚预付', '2', 'pay_type', 0, 'default', '', NULL, '115', '2022-07-24 18:03:42', '115', '2022-07-24 18:12:59', b'1', 'Nigeria Prepaid'); INSERT INTO `system_dict_data` VALUES (1641, 3, '加纳预付', '3', 'pay_type', 0, 'default', '', NULL, '115', '2022-07-24 18:04:04', '115', '2022-07-24 18:13:01', b'1', 'Ghana Prepaid'); INSERT INTO `system_dict_data` VALUES (1642, 4, '到付', '4', 'pay_type', 0, 'default', '', NULL, '115', '2022-07-24 18:04:26', '115', '2022-07-24 18:13:03', b'1', 'cash on delivery'); INSERT INTO `system_dict_data` VALUES (1643, 15, '泡货异常', 'order_bulky_cargo_exception', 'order_error_type', 0, 'default', '', NULL, '1', '2022-07-24 20:00:42', '1', '2022-07-24 20:00:42', b'0', 'bulky exception'); INSERT INTO `system_dict_data` VALUES (1644, 0, '设为普货', 'general_cargo', 'order_bulky_cargo_exception_result', 0, 'default', '', NULL, '1', '2022-07-24 20:02:00', '1', '2022-07-24 20:02:00', b'0', 'general cargo'); INSERT INTO `system_dict_data` VALUES (1645, 1, '设为已处理', 'process', 'order_bulky_cargo_exception_result', 0, 'default', '', NULL, '1', '2022-07-24 20:02:12', '1', '2022-07-24 20:02:12', b'0', 'process'); INSERT INTO `system_dict_data` VALUES (1646, 1, '运费', '1', 'receivable_fee_type', 0, 'default', '', '运费', '125', '2022-07-24 20:20:45', '125', '2022-07-24 20:20:45', b'0', 'freight'); INSERT INTO `system_dict_data` VALUES (1647, 2, '清关费', '2', 'receivable_fee_type', 0, 'default', '', '清关费', '125', '2022-07-24 20:21:22', '125', '2022-07-24 20:21:22', b'0', 'clearanceFee'); INSERT INTO `system_dict_data` VALUES (1648, 3, '纸箱打包费', '3', 'receivable_fee_type', 0, 'default', '', '纸箱打包费', '125', '2022-07-24 20:21:57', '125', '2022-07-24 20:29:35', b'0', 'cartonPackingFee'); INSERT INTO `system_dict_data` VALUES (1649, 4, '木架打包费', '4', 'receivable_fee_type', 0, 'default', '', '木架打包费', '125', '2022-07-24 20:23:44', '125', '2022-07-24 20:23:44', b'0', 'woodenFramePackingeFee'); INSERT INTO `system_dict_data` VALUES (1650, 5, '报关费', '5', 'receivable_fee_type', 0, 'default', '', '报关费', '125', '2022-07-24 21:09:35', '125', '2022-07-24 21:09:35', b'0', 'declarationFee'); INSERT INTO `system_dict_data` VALUES (1651, 6, '保价费', '6', 'receivable_fee_type', 0, 'default', '', '保价费', '125', '2022-07-24 21:10:35', '125', '2022-07-24 21:10:35', b'0', 'premium'); INSERT INTO `system_dict_data` VALUES (1652, 7, '叉车费', '7', 'receivable_fee_type', 0, 'default', '', '叉车费', '125', '2022-07-24 21:12:23', '125', '2022-07-24 21:12:23', b'0', 'forkliftFee'); INSERT INTO `system_dict_data` VALUES (1653, 31, '部分提货', '31', 'order_status', 1, 'default', '', '部分提货', '1', '2022-07-27 10:28:04', '125', '2022-08-28 00:41:08', b'1', 'part_picked_up'); INSERT INTO `system_dict_data` VALUES (1654, 0, '自提', '1', 'harvest_method', 0, 'default', '', NULL, '119', '2022-07-27 18:32:18', '119', '2022-07-27 18:32:18', b'0', '自提'); INSERT INTO `system_dict_data` VALUES (1655, 0, '送货上门', '2', 'harvest_method', 0, 'default', '', NULL, '119', '2022-07-27 18:32:26', '119', '2022-07-27 18:32:26', b'0', '送货上门'); INSERT INTO `system_dict_data` VALUES (1656, 2, '中性价', '2', 'customer_charging_model', 0, 'default', '', NULL, '115', '2022-07-28 23:39:30', '115', '2022-07-29 17:59:51', b'0', 'M'); INSERT INTO `system_dict_data` VALUES (1657, 20, '调仓申请中', '20', 'order_status', 0, 'default', '', NULL, '1', '2022-07-30 16:20:33', '1', '2022-07-30 22:39:06', b'1', 'warehouse_adjust_applying'); INSERT INTO `system_dict_data` VALUES (1658, 1, '有牌价', '1', 'customer_charging_model_by_unauth', 0, 'default', '', NULL, '115', '2022-07-31 11:54:47', '115', '2022-07-31 11:54:47', b'0', 'Y'); INSERT INTO `system_dict_data` VALUES (1659, 2, '中性价', '2', 'customer_charging_model_by_unauth', 0, 'default', '', NULL, '115', '2022-07-31 11:54:55', '115', '2022-07-31 11:54:55', b'0', 'M'); INSERT INTO `system_dict_data` VALUES (1660, 0, '月度目标', '1', 'target_type', 0, 'default', '', '月度目标', '1', '2022-07-31 18:13:18', '1', '2022-07-31 18:14:45', b'0', 'month_target'); INSERT INTO `system_dict_data` VALUES (1661, 0, '季度目标', '2', 'target_type', 0, 'default', '', '季度目标', '1', '2022-07-31 18:14:13', '1', '2022-07-31 18:14:41', b'0', 'quarter_target'); INSERT INTO `system_dict_data` VALUES (1662, 0, '年度目标', '3', 'target_type', 0, 'default', '', '年度目标', '1', '2022-07-31 18:14:36', '1', '2022-07-31 18:14:36', b'0', 'year_target'); INSERT INTO `system_dict_data` VALUES (1663, 0, '整柜买单报关', '1', 'shipping_sea_customs_type', 0, 'default', '', NULL, '1', '2022-07-31 21:50:54', '1', '2022-07-31 21:50:54', b'0', '整柜买单报关'); INSERT INTO `system_dict_data` VALUES (1664, 1, '整柜正常报关', '2', 'shipping_sea_customs_type', 0, 'default', '', NULL, '1', '2022-07-31 21:51:04', '1', '2022-07-31 21:51:04', b'0', '整柜正常报关'); INSERT INTO `system_dict_data` VALUES (1665, 2, '买单报关+正常报关', '3', 'shipping_sea_customs_type', 0, 'default', '', NULL, '1', '2022-07-31 21:51:15', '1', '2022-07-31 21:51:15', b'0', '买单报关+正常报关'); INSERT INTO `system_dict_data` VALUES (1666, 0, '报关中', '1', 'shipping_dcCustoms_status', 0, 'default', '', '', '1', '2022-07-31 22:43:58', '1', '2022-07-31 22:44:05', b'0', '报关中'); INSERT INTO `system_dict_data` VALUES (1667, 1, '放行', '2', 'shipping_dcCustoms_status', 0, 'default', '', '', '1', '2022-07-31 22:44:14', '1', '2022-07-31 22:44:14', b'0', '放行'); INSERT INTO `system_dict_data` VALUES (1668, 2, '查验', '3', 'shipping_dcCustoms_status', 0, 'default', '', '', '1', '2022-07-31 22:44:30', '1', '2022-07-31 22:44:30', b'0', '查验'); INSERT INTO `system_dict_data` VALUES (1669, 0, '退场', '1', 'shipping_check_status', 0, 'default', '', NULL, '1', '2022-07-31 22:47:32', '1', '2022-07-31 22:47:32', b'0', '退场'); INSERT INTO `system_dict_data` VALUES (1670, 1, '部分退场', '2', 'shipping_check_status', 0, 'default', '', NULL, '1', '2022-07-31 22:47:43', '1', '2022-07-31 22:47:43', b'0', '部分退场'); INSERT INTO `system_dict_data` VALUES (1671, 2, '查验后放行', '3', 'shipping_check_status', 0, 'default', '', NULL, '1', '2022-07-31 22:47:55', '1', '2022-07-31 22:47:55', b'0', '查验后放行'); INSERT INTO `system_dict_data` VALUES (1672, 0, '已派车，待提柜', '1', 'shipping_trailer_status', 0, 'default', '', NULL, '1', '2022-07-31 22:58:24', '1', '2022-07-31 22:58:24', b'0', '已派车，待提柜'); INSERT INTO `system_dict_data` VALUES (1673, 1, '已提柜，待还柜', '2', 'shipping_trailer_status', 0, 'default', '', NULL, '1', '2022-07-31 22:58:37', '1', '2022-07-31 22:58:37', b'0', '已提柜，待还柜'); INSERT INTO `system_dict_data` VALUES (1674, 2, '已还柜', '3', 'shipping_trailer_status', 0, 'default', '', NULL, '1', '2022-07-31 22:58:51', '1', '2022-07-31 22:58:51', b'0', '已还柜'); INSERT INTO `system_dict_data` VALUES (1675, 0, '整柜买单报关', '1', 'shipping_customs_type', 0, 'default', '', NULL, '1', '2022-07-31 23:00:34', '1', '2022-07-31 23:00:34', b'0', '整柜买单报关'); INSERT INTO `system_dict_data` VALUES (1676, 1, '整柜正常报关', '2', 'shipping_customs_type', 0, 'default', '', NULL, '1', '2022-07-31 23:00:59', '1', '2022-07-31 23:00:59', b'0', '整柜正常报关'); INSERT INTO `system_dict_data` VALUES (1677, 2, '买单报关+正常报关', '3', 'shipping_customs_type', 0, 'default', '', NULL, '1', '2022-07-31 23:01:11', '1', '2022-07-31 23:01:11', b'0', '买单报关+正常报关'); INSERT INTO `system_dict_data` VALUES (1678, 0, '商品ID', 'prodId', 'order_warehouse_in_update_order_item', 0, 'default', '', NULL, '1', '2022-08-02 14:16:44', '1', '2022-08-02 14:23:13', b'0', 'prodId'); INSERT INTO `system_dict_data` VALUES (1679, 0, '产品类型', 'prodType', 'order_warehouse_in_update_order_item', 0, 'default', '', NULL, '1', '2022-08-02 14:17:05', '1', '2022-08-02 14:23:14', b'0', 'prodType'); INSERT INTO `system_dict_data` VALUES (1680, 0, '产品中文标题', 'prodTitleZh', 'order_warehouse_in_update_order_item', 0, 'default', '', NULL, '1', '2022-08-02 14:17:13', '1', '2022-08-02 14:23:14', b'0', 'prodTitleZh'); INSERT INTO `system_dict_data` VALUES (1681, 0, '产品英文标题', 'prodTitleEn', 'order_warehouse_in_update_order_item', 0, 'default', '', NULL, '1', '2022-08-02 14:17:20', '1', '2022-08-02 14:23:14', b'0', 'prodTitleEn'); INSERT INTO `system_dict_data` VALUES (1682, 0, '品牌', 'brand', 'order_warehouse_in_update_order_item', 0, 'default', '', NULL, '1', '2022-08-02 14:17:29', '1', '2022-08-02 14:23:14', b'0', 'brand'); INSERT INTO `system_dict_data` VALUES (1683, 0, '有无备案', 'brandType', 'order_warehouse_in_update_order_item', 0, 'default', '', NULL, '1', '2022-08-02 14:17:50', '1', '2022-08-02 14:23:15', b'0', 'brandType'); INSERT INTO `system_dict_data` VALUES (1684, 0, '费用模式', 'feeType', 'order_warehouse_in_update_order_item', 0, 'default', '', NULL, '1', '2022-08-02 14:18:04', '1', '2022-08-02 14:23:15', b'0', 'feeType'); INSERT INTO `system_dict_data` VALUES (1685, 0, '填单数量', 'num', 'order_warehouse_in_update_order_item', 0, 'default', '', NULL, '1', '2022-08-02 14:18:19', '1', '2022-08-02 14:23:15', b'0', 'num'); INSERT INTO `system_dict_data` VALUES (1686, 0, '填单体积', 'volume', 'order_warehouse_in_update_order_item', 0, 'default', '', NULL, '1', '2022-08-02 14:18:26', '1', '2022-08-02 14:23:15', b'0', 'volume'); INSERT INTO `system_dict_data` VALUES (1687, 0, '填单重量', 'weight', 'order_warehouse_in_update_order_item', 0, 'default', '', NULL, '1', '2022-08-02 14:18:34', '1', '2022-08-02 14:23:15', b'0', 'weight'); INSERT INTO `system_dict_data` VALUES (1688, 0, '材质', 'material', 'order_warehouse_in_update_order_item', 0, 'default', '', NULL, '1', '2022-08-02 14:18:57', '1', '2022-08-02 14:23:16', b'0', 'material'); INSERT INTO `system_dict_data` VALUES (1689, 0, '箱数', 'cartonsNum', 'order_warehouse_in_update_item', 0, 'default', '', NULL, '1', '2022-08-02 14:24:14', '1', '2022-08-02 14:24:14', b'0', 'cartonsNum'); INSERT INTO `system_dict_data` VALUES (1690, 0, '数量', 'quantityAll', 'order_warehouse_in_update_item', 0, 'default', '', NULL, '1', '2022-08-02 14:24:33', '1', '2022-08-02 14:24:33', b'0', 'quantityAll'); INSERT INTO `system_dict_data` VALUES (1691, 0, '单位', 'unit', 'order_warehouse_in_update_item', 0, 'default', '', NULL, '1', '2022-08-02 14:24:43', '1', '2022-08-02 14:24:43', b'0', 'unit'); INSERT INTO `system_dict_data` VALUES (1692, 0, '箱规', 'boxGauge', 'order_warehouse_in_update_item', 0, 'default', '', NULL, '1', '2022-08-02 14:24:51', '1', '2022-08-02 14:24:51', b'0', 'boxGauge'); INSERT INTO `system_dict_data` VALUES (1693, 0, '体积', 'volume', 'order_warehouse_in_update_item', 0, 'default', '', NULL, '1', '2022-08-02 14:25:12', '1', '2022-08-02 14:25:12', b'0', 'volume'); INSERT INTO `system_dict_data` VALUES (1694, 0, '重量', 'weight', 'order_warehouse_in_update_item', 0, 'default', '', NULL, '1', '2022-08-02 14:25:21', '1', '2022-08-02 14:25:21', b'0', 'weight'); INSERT INTO `system_dict_data` VALUES (1695, 0, '快递单号', 'expressNo', 'order_warehouse_in_update_item', 0, 'default', '', NULL, '1', '2022-08-02 14:25:27', '1', '2022-08-02 14:25:27', b'0', 'expressNo'); INSERT INTO `system_dict_data` VALUES (1696, 0, '草稿', '0', 'is_draft', 0, 'default', '', NULL, '119', '2022-08-04 14:56:38', '119', '2022-08-04 14:56:38', b'0', '草稿'); INSERT INTO `system_dict_data` VALUES (1697, 0, '已发布', '1', 'is_draft', 0, 'default', '', NULL, '119', '2022-08-04 14:56:44', '119', '2022-08-04 14:56:44', b'0', '已发布'); INSERT INTO `system_dict_data` VALUES (1698, 9, '已合单', '9', 'order_status', 0, 'default', '', '已合单', '1', '2022-08-08 17:32:32', '125', '2022-08-28 00:35:03', b'0', 'merged'); INSERT INTO `system_dict_data` VALUES (1699, 1, '货物丢失', '1', 'shipping_unloading_error', 0, 'default', '', NULL, '1', '2022-08-08 22:43:29', '1', '2022-08-08 23:13:01', b'0', 'abnormal loss of goods'); INSERT INTO `system_dict_data` VALUES (1700, 2, '货物增多', '2', 'shipping_unloading_error', 0, 'default', '', NULL, '1', '2022-08-08 22:44:49', '1', '2022-08-08 23:13:05', b'0', 'abnormal increase in cargo'); INSERT INTO `system_dict_data` VALUES (1701, 2, '货物破损', '3', 'shipping_unloading_error', 0, 'default', '', NULL, '1', '2022-08-08 22:45:34', '1', '2022-08-08 23:13:10', b'0', 'abnormal cargo damage'); INSERT INTO `system_dict_data` VALUES (1702, 4, '货物浸水', '4', 'shipping_unloading_error', 0, 'default', '', NULL, '1', '2022-08-08 22:45:55', '1', '2022-08-08 23:13:13', b'0', 'The cargo is abnormally soaked in water'); INSERT INTO `system_dict_data` VALUES (1703, 16, '合单申请中', '16', 'order_status', 0, 'default', '', '合单申请中', '1', '2022-08-10 14:18:21', '1', '2022-08-26 01:25:47', b'1', 'merging'); INSERT INTO `system_dict_data` VALUES (1704, 17, '合单申请未通过', '17', 'order_status', 0, 'default', '', '合单申请未通过', '1', '2022-08-10 15:41:55', '1', '2022-08-26 01:25:41', b'1', 'merge_failed'); INSERT INTO `system_dict_data` VALUES (1705, 1, '美元$', '1', 'shipping_price_unit', 0, 'default', '', NULL, '1', '2022-08-10 23:17:59', '1', '2022-11-27 23:37:37', b'1', 'dollar'); INSERT INTO `system_dict_data` VALUES (1706, 3, '人民币￥', '3', 'shipping_price_unit', 0, 'default', '', NULL, '1', '2022-08-10 23:18:28', '1', '2022-11-27 23:37:41', b'1', 'RMB'); INSERT INTO `system_dict_data` VALUES (1707, 2, '奈拉N', '2', 'shipping_price_unit', 0, 'default', '', NULL, '1', '2022-08-10 23:18:59', '1', '2022-11-27 23:37:39', b'1', 'naira'); INSERT INTO `system_dict_data` VALUES (1708, 6, '拆单申请', '6', 'order_approval_type', 0, 'default', '', NULL, '1', '2022-08-11 17:53:54', '1', '2022-08-11 17:54:00', b'0', 'order_split'); INSERT INTO `system_dict_data` VALUES (1709, 10, '已拆单', '10', 'order_status', 0, 'default', '', NULL, '1', '2022-08-11 17:58:01', '125', '2022-08-28 00:35:10', b'0', 'splitted'); INSERT INTO `system_dict_data` VALUES (1710, 19, '拆单申请中', '19', 'order_status', 0, 'default', '', NULL, '1', '2022-08-11 17:58:14', '1', '2022-08-26 01:25:34', b'1', 'splitting'); INSERT INTO `system_dict_data` VALUES (1711, 20, '拆单申请未通过', '20', 'order_status', 0, 'default', '', NULL, '1', '2022-08-11 17:58:28', '1', '2022-08-26 01:25:28', b'1', 'split_failed'); INSERT INTO `system_dict_data` VALUES (1712, 1, '罢工', '1', 'shipping_ticket_exception', 0, 'default', '', NULL, '1', '2022-08-11 23:04:46', '1', '2022-08-11 23:04:46', b'0', '罢工'); INSERT INTO `system_dict_data` VALUES (1713, 2, '查验', '2', 'shipping_ticket_exception', 0, 'default', '', NULL, '1', '2022-08-11 23:04:59', '1', '2022-08-11 23:04:59', b'0', '查验'); INSERT INTO `system_dict_data` VALUES (1714, 3, '节假日', '3', 'shipping_ticket_exception', 0, 'default', '', NULL, '1', '2022-08-11 23:05:11', '1', '2022-08-11 23:05:11', b'0', '节假日'); INSERT INTO `system_dict_data` VALUES (1715, 4, '塞港', '4', 'shipping_ticket_exception', 0, 'default', '', NULL, '1', '2022-08-11 23:05:22', '1', '2022-08-11 23:05:22', b'0', '塞港'); INSERT INTO `system_dict_data` VALUES (1716, 5, '中转', '5', 'shipping_ticket_exception', 0, 'default', '', NULL, '1', '2022-08-11 23:05:36', '1', '2022-08-11 23:05:36', b'0', '中转'); INSERT INTO `system_dict_data` VALUES (1717, 10, '订舱', '1', 'shipping_process', 0, 'default', '', NULL, '1', '2022-08-11 23:11:47', '1', '2022-08-26 15:14:06', b'0', 'booking'); INSERT INTO `system_dict_data` VALUES (1718, 20, '排单', '2', 'shipping_process', 0, 'default', '', NULL, '1', '2022-08-11 23:12:12', '1', '2022-08-26 15:14:32', b'0', 'preinstall'); INSERT INTO `system_dict_data` VALUES (1719, 30, '拖车', '3', 'shipping_process', 0, 'default', '', NULL, '1', '2022-08-11 23:12:44', '1', '2022-08-26 15:15:29', b'0', 'trailer'); INSERT INTO `system_dict_data` VALUES (1720, 40, '装柜', '4', 'shipping_process', 0, 'default', '', NULL, '1', '2022-08-11 23:14:07', '1', '2022-08-26 15:15:33', b'0', 'cabinet'); INSERT INTO `system_dict_data` VALUES (1721, 50, '报关', '5', 'shipping_process', 0, 'default', '', NULL, '1', '2022-08-11 23:14:48', '1', '2022-08-26 15:15:36', b'0', 'cusDeclaration'); INSERT INTO `system_dict_data` VALUES (1722, 60, '配船', '6', 'shipping_process', 0, 'default', '', NULL, '1', '2022-08-11 23:15:10', '1', '2022-08-26 15:15:42', b'0', 'ship'); INSERT INTO `system_dict_data` VALUES (1723, 70, '提单补料', '7', 'shipping_process', 0, 'default', '', NULL, '1', '2022-08-11 23:15:39', '1', '2022-08-26 15:15:46', b'0', 'subMaterial'); INSERT INTO `system_dict_data` VALUES (1724, 80, '驳船', '8', 'shipping_process', 0, 'default', '', NULL, '1', '2022-08-11 23:16:11', '1', '2022-08-26 15:15:51', b'0', 'barge'); INSERT INTO `system_dict_data` VALUES (1725, 90, '起运', '9', 'shipping_process', 0, 'default', '', NULL, '1', '2022-08-11 23:16:37', '1', '2022-08-26 15:15:55', b'0', 'departure'); INSERT INTO `system_dict_data` VALUES (1726, 100, '提单Copy', '10', 'shipping_process', 0, 'default', '', NULL, '1', '2022-08-11 23:17:00', '1', '2022-08-26 15:16:01', b'0', 'blCopy'); INSERT INTO `system_dict_data` VALUES (1727, 110, '清关文件', '11', 'shipping_process', 0, 'default', '', NULL, '1', '2022-08-11 23:17:28', '1', '2022-08-26 15:16:06', b'0', 'clrDocument'); INSERT INTO `system_dict_data` VALUES (1728, 120, '到港', '12', 'shipping_process', 0, 'default', '', NULL, '1', '2022-08-11 23:17:49', '1', '2022-08-26 15:16:14', b'0', 'arrival'); INSERT INTO `system_dict_data` VALUES (1729, 130, '清关', '13', 'shipping_process', 0, 'default', '', NULL, '1', '2022-08-11 23:18:05', '1', '2022-08-26 15:16:18', b'0', 'cusClearance'); INSERT INTO `system_dict_data` VALUES (1730, 150, '卸柜', '15', 'shipping_process', 0, 'default', '', NULL, '1', '2022-08-11 23:18:24', '1', '2022-08-26 15:16:26', b'0', 'unloading'); INSERT INTO `system_dict_data` VALUES (1731, 140, '结算', '14', 'shipping_process', 0, 'default', '', NULL, '1', '2022-08-11 23:18:40', '1', '2022-08-26 15:16:22', b'0', 'settlement'); INSERT INTO `system_dict_data` VALUES (1732, 21, '拆单申请已取消', '21', 'order_status', 0, 'default', '', NULL, '1', '2022-08-12 23:24:56', '1', '2022-08-26 01:25:31', b'1', 'split_canceled'); INSERT INTO `system_dict_data` VALUES (1733, 1, '无牌', '0', 'shipping_brand_type', 0, 'default', '', NULL, '1', '2022-08-15 21:05:45', '1', '2022-08-15 21:05:45', b'0', '无牌'); INSERT INTO `system_dict_data` VALUES (1734, 2, '有牌', '1', 'shipping_brand_type', 0, 'default', '', NULL, '1', '2022-08-15 21:05:57', '1', '2022-08-15 21:05:57', b'0', '有牌'); INSERT INTO `system_dict_data` VALUES (1735, 3, '中性', '2', 'shipping_brand_type', 0, 'default', '', NULL, '1', '2022-08-15 21:06:19', '1', '2022-08-15 21:06:25', b'0', '中性'); INSERT INTO `system_dict_data` VALUES (1736, 0, '运费+清关费', '0', 'price_type', 0, 'default', '', NULL, '119', '2022-08-16 22:41:48', '119', '2022-08-16 22:41:48', b'0', '运费+清关费'); INSERT INTO `system_dict_data` VALUES (1737, 0, '全包价', '1', 'price_type', 0, 'default', '', NULL, '119', '2022-08-16 22:41:59', '119', '2022-08-16 22:41:59', b'0', '全包价'); INSERT INTO `system_dict_data` VALUES (1738, 7, '控货订单放货修改', '7', 'order_approval_type', 0, 'default', '', '控货订单放货修改', '125', '2022-08-17 00:38:11', '125', '2022-08-17 00:38:11', b'0', 'order_cargo_control_pick_update'); INSERT INTO `system_dict_data` VALUES (1739, 0, '入仓须知', 'warehousing', 'need_know_type', 0, 'default', '', NULL, '1', '2022-08-17 17:55:05', '115', '2022-09-18 22:35:32', b'0', 'warehousing need to know'); INSERT INTO `system_dict_data` VALUES (1740, 1, '控货须知', 'control', 'need_know_type', 0, 'default', '', NULL, '1', '2022-08-17 17:55:55', '115', '2022-09-18 22:35:38', b'0', 'control goods need to know'); INSERT INTO `system_dict_data` VALUES (1741, 2, '控货转移须知', 'controltransfer', 'need_know_type', 0, 'default', '', NULL, '1', '2022-08-17 17:57:15', '115', '2022-09-18 22:35:44', b'0', 'control transfer need to know'); INSERT INTO `system_dict_data` VALUES (1742, 3, '价格查询温馨提示', 'pricequery', 'need_know_type', 0, 'default', '', NULL, '1', '2022-08-17 17:58:46', '1', '2022-08-17 18:33:40', b'0', 'price query'); INSERT INTO `system_dict_data` VALUES (1743, 0, '启用', '0', 'need_know_status', 0, 'default', '', NULL, '1', '2022-08-17 18:14:08', '1', '2022-08-17 18:14:08', b'0', 'enable'); INSERT INTO `system_dict_data` VALUES (1744, 0, '停用', '1', 'need_know_status', 0, 'default', '', NULL, '1', '2022-08-17 18:14:18', '1', '2022-08-17 18:14:18', b'0', 'disable'); INSERT INTO `system_dict_data` VALUES (1745, 1, '待审核', '1', 'payment_state', 0, 'default', '', NULL, '1', '2022-08-18 10:11:57', '1', '2022-08-18 10:12:35', b'0', '待审核'); INSERT INTO `system_dict_data` VALUES (1746, 2, '已审核待核销', '2', 'payment_state', 0, 'default', '', NULL, '1', '2022-08-18 10:12:25', '1', '2022-08-18 10:12:25', b'0', '已审核待核销'); INSERT INTO `system_dict_data` VALUES (1747, 3, '审核驳回', '3', 'payment_state', 0, 'default', '', NULL, '1', '2022-08-18 10:12:49', '1', '2022-08-18 10:12:49', b'0', '审核驳回'); INSERT INTO `system_dict_data` VALUES (1748, 4, '已核销', '4', 'payment_state', 0, 'default', '', NULL, '1', '2022-08-18 10:13:02', '1', '2022-08-18 10:13:02', b'0', '已核销'); INSERT INTO `system_dict_data` VALUES (1749, 1, '增值税普通发票', '1', 'invoicing_type', 0, 'default', '', NULL, '1', '2022-08-19 17:04:53', '1', '2022-08-19 17:06:18', b'0', '1'); INSERT INTO `system_dict_data` VALUES (1750, 2, '增值税专用发票', '2', 'invoicing_type', 0, 'default', '', NULL, '1', '2022-08-19 17:05:15', '1', '2022-08-19 17:06:30', b'0', '1'); INSERT INTO `system_dict_data` VALUES (1751, 3, '增值税普通电子发票', '3', 'invoicing_type', 0, 'default', '', NULL, '1', '2022-08-19 17:05:49', '1', '2022-08-19 17:06:34', b'0', '1'); INSERT INTO `system_dict_data` VALUES (1752, 8, '控货订单反复核', '8', 'order_approval_type', 0, 'default', '', '控货订单反复核', '125', '2022-08-20 23:14:07', '125', '2022-08-20 23:14:07', b'0', 'order_cargo_control_pick_anti-checking'); INSERT INTO `system_dict_data` VALUES (1753, 1, '放货人信息错误', '1', 'PICK_RECURRENT_NUCLEAR_TYPE', 0, 'default', '', '放货人信息错误', '125', '2022-08-20 23:29:21', '125', '2022-08-20 23:30:57', b'0', 'Wrong information of consignor'); INSERT INTO `system_dict_data` VALUES (1754, 2, '放货箱数错误', '2', 'PICK_RECURRENT_NUCLEAR_TYPE', 0, 'default', '', '放货箱数错误', '125', '2022-08-20 23:29:38', '125', '2022-08-20 23:31:15', b'0', 'Wrong number of containers'); INSERT INTO `system_dict_data` VALUES (1755, 3, '展缓放货', '3', 'PICK_RECURRENT_NUCLEAR_TYPE', 0, 'default', '', '展缓放货', '125', '2022-08-20 23:29:54', '125', '2022-08-20 23:31:37', b'0', 'Slow release'); INSERT INTO `system_dict_data` VALUES (1756, 4, '其他', '4', 'PICK_RECURRENT_NUCLEAR_TYPE', 0, 'default', '', '其他', '125', '2022-08-20 23:30:13', '125', '2022-08-20 23:30:13', b'0', 'other'); INSERT INTO `system_dict_data` VALUES (1757, 11, '已预装', '11', 'order_status', 0, 'default', '', '已预装', '125', '2022-08-22 23:15:49', '125', '2022-08-28 00:38:09', b'0', 'Pre installed'); INSERT INTO `system_dict_data` VALUES (1758, 12, '已装柜', '12', 'order_status', 0, 'default', '', '已装柜', '125', '2022-08-22 23:17:14', '125', '2022-08-28 00:38:33', b'0', 'Installed cabinet'); INSERT INTO `system_dict_data` VALUES (1759, 13, '航运中', '13', 'order_status', 0, 'default', '', '航运中', '125', '2022-08-22 23:18:00', '125', '2022-08-28 00:38:51', b'0', 'In shipping'); INSERT INTO `system_dict_data` VALUES (1760, 14, '已到港', '14', 'order_status', 0, 'default', '', '已到港', '125', '2022-08-22 23:18:26', '125', '2022-08-28 00:39:09', b'0', 'Arrived'); INSERT INTO `system_dict_data` VALUES (1761, 15, '已清关', '15', 'order_status', 0, 'default', '', '已清关', '125', '2022-08-22 23:19:15', '125', '2022-08-28 00:40:06', b'0', 'Cleared'); INSERT INTO `system_dict_data` VALUES (1762, 16, '已卸柜', '16', 'order_status', 0, 'default', '', '已卸柜', '125', '2022-08-22 23:20:15', '125', '2022-08-28 00:40:24', b'0', 'Unloaded cabinet'); INSERT INTO `system_dict_data` VALUES (1763, 28, '已卸柜', '28', 'order_status', 0, 'default', '', '已卸柜', '125', '2022-08-22 23:27:52', '125', '2022-08-22 23:27:57', b'1', 'Unloaded cabinet'); INSERT INTO `system_dict_data` VALUES (1764, 14, '二程起飞', '14', 'shipping_process', 1, 'default', '', NULL, '1', '2022-08-23 22:59:46', '1', '2022-08-26 15:06:11', b'1', 'takeOff'); INSERT INTO `system_dict_data` VALUES (1765, 15, '二程到港', '15', 'shipping_process', 1, 'default', '', NULL, '1', '2022-08-23 23:00:23', '1', '2022-08-26 15:06:15', b'1', 'airArrival'); INSERT INTO `system_dict_data` VALUES (1766, 28, '已清关', '28', 'order_status', 0, 'default', '', '已清关', '125', '2022-08-26 01:30:53', '125', '2022-08-26 01:31:45', b'1', 'Cleared'); INSERT INTO `system_dict_data` VALUES (1767, 21, '理货', '16', 'shipping_process', 0, 'default', '', NULL, '1', '2022-08-26 15:11:36', '1', '2022-08-26 15:15:23', b'0', 'tally'); INSERT INTO `system_dict_data` VALUES (1768, 6, '已退仓-费用未清', '6', 'order_status', 0, 'default', '', '已退仓-费用未清', '125', '2022-08-28 00:43:40', '125', '2022-08-28 00:43:52', b'0', 'Withdrawn expenses not cleared'); INSERT INTO `system_dict_data` VALUES (1769, 5, '用户服务协议', '5', 'need_know_type', 0, 'default', '', NULL, '115', '2022-08-28 11:50:50', '115', '2022-08-28 11:50:50', b'0', 'User Services Agreement'); INSERT INTO `system_dict_data` VALUES (1770, 0, '多了', '2', 'order_warehouse_in_diff_status', 0, 'default', '', NULL, '1', '2022-08-29 20:39:16', '1', '2022-08-29 20:39:16', b'0', 'more_than'); INSERT INTO `system_dict_data` VALUES (1771, 0, '少了', '3', 'order_warehouse_in_diff_status', 0, 'default', '', NULL, '1', '2022-08-29 20:39:33', '1', '2022-08-29 20:39:33', b'0', 'less_than'); INSERT INTO `system_dict_data` VALUES (1772, 0, '准确到齐', '4', 'order_warehouse_in_diff_status', 0, 'default', '', NULL, '1', '2022-08-29 20:39:44', '1', '2022-08-29 20:39:44', b'0', 'correct'); INSERT INTO `system_dict_data` VALUES (1773, 13, '调仓申请', '13', 'order_approval_type', 0, 'default', '', NULL, '1', '2022-08-29 22:58:55', '1', '2022-08-29 23:38:30', b'0', 'warehouse_adjust'); INSERT INTO `system_dict_data` VALUES (1774, 22, '入仓修改', '22', 'order_approval_type', 0, 'default', '', NULL, '1', '2022-08-29 22:59:29', '1', '2022-08-29 22:59:29', b'0', 'warehouse_update'); INSERT INTO `system_dict_data` VALUES (1775, 23, '退仓', '23', 'order_approval_type', 0, 'default', '', NULL, '1', '2022-08-29 23:35:55', '1', '2022-08-29 23:35:55', b'0', 'warehouse_rollback'); INSERT INTO `system_dict_data` VALUES (1776, 3, '预付商品货值大于订单总运费+清关费用33%', 'pay_total_fee', 'order_pay_exception_result', 0, 'default', '', NULL, '1', '2022-08-30 22:20:23', '115', '2022-12-07 21:27:33', b'0', 'pay_total_fee'); INSERT INTO `system_dict_data` VALUES (1777, 4, '预付商品总入仓方数小于订单所有商品总方数33%', 'pay_volume_scale', 'order_pay_exception_result', 0, 'default', '', NULL, '1', '2022-08-30 22:21:17', '1', '2022-08-30 22:21:17', b'0', 'pay_volume_scale'); INSERT INTO `system_dict_data` VALUES (1778, 5, '订单下预付商品总方数小于0.5cbm', 'pay_total_min', 'order_pay_exception_result', 0, 'default', '', NULL, '1', '2022-08-30 22:21:32', '1', '2022-08-30 22:21:32', b'0', 'pay_total_min'); INSERT INTO `system_dict_data` VALUES (1779, 2, '多了', '2', 'order_item_status', 0, 'default', '', NULL, '1', '2022-08-30 23:46:08', '1', '2022-08-30 23:46:08', b'0', 'more_than'); INSERT INTO `system_dict_data` VALUES (1780, 3, '少了', '3', 'order_item_status', 0, 'default', '', NULL, '1', '2022-08-30 23:46:32', '1', '2022-08-30 23:46:32', b'0', 'less_than'); INSERT INTO `system_dict_data` VALUES (1781, 4, '准确到齐', '4', 'order_item_status', 0, 'default', '', NULL, '1', '2022-08-30 23:46:45', '1', '2022-08-30 23:46:45', b'0', 'correct'); INSERT INTO `system_dict_data` VALUES (1782, 0, '管理端审批通用ID', '132', 'CUSTOMER_USER_ID', 0, 'default', '', '管理端审批通用ID', '1', '2022-08-31 10:05:08', '1', '2022-08-31 10:37:54', b'1', 'CUSTOMER_USER_APPROVAL_ID'); INSERT INTO `system_dict_data` VALUES (1783, 0, '草稿', '0', 'receipt_state', 0, 'default', '', NULL, '1', '2022-08-31 10:23:17', '1', '2022-08-31 10:23:17', b'0', 'new'); INSERT INTO `system_dict_data` VALUES (1784, 5, '已核销待开票', '5', 'receipt_state', 0, 'default', '', NULL, '1', '2022-08-31 10:24:26', '1', '2022-08-31 10:24:26', b'0', '已核销待开票'); INSERT INTO `system_dict_data` VALUES (1785, 6, '已开票', '6', 'receipt_state', 0, 'default', '', NULL, '1', '2022-08-31 10:24:39', '1', '2022-08-31 10:24:39', b'0', '已开票'); INSERT INTO `system_dict_data` VALUES (1786, 0, 'CUSTOMER_USER_APPROVAL_ID', '132', 'CUSTOMER_USER_TO_ADMIN', 0, 'default', '', '管理端审批通用ID', '1', '2022-08-31 10:37:38', '1', '2022-08-31 10:38:31', b'0', 'CUSTOMER_USER_APPROVAL_ID'); INSERT INTO `system_dict_data` VALUES (1787, 1, '放货中', '1', 'release_status', 0, 'default', '', '', '1', '2022-08-31 19:21:31', '1', '2022-09-26 22:12:49', b'0', '放货中'); INSERT INTO `system_dict_data` VALUES (1788, 2, '修改审核中 ', '2', 'release_status', 0, 'default', '', '', '1', '2022-08-31 19:21:39', '1', '2022-09-26 22:12:45', b'0', '修改审核中 '); INSERT INTO `system_dict_data` VALUES (1789, 3, '已放货', '3', 'release_status', 0, 'default', '', '', '1', '2022-08-31 19:21:46', '1', '2022-09-26 22:12:40', b'0', '已放货'); INSERT INTO `system_dict_data` VALUES (1790, 0, '已取消', '0', 'release_status', 0, 'default', '', NULL, '1', '2022-08-31 21:19:04', '1', '2022-08-31 21:19:04', b'0', '已取消'); INSERT INTO `system_dict_data` VALUES (1791, 4, '反复核审核中', '4', 'release_status', 0, 'default', '', NULL, '1', '2022-08-31 21:19:40', '1', '2022-09-26 22:12:32', b'0', '反复核审核中'); INSERT INTO `system_dict_data` VALUES (1792, 9, '控货订单已放货记录调货审批', '9', 'order_approval_type', 0, 'default', '', '控货订单已放货记录调货审批', '125', '2022-09-02 23:49:48', '125', '2022-09-02 23:49:48', b'0', 'seasoning_condiments'); INSERT INTO `system_dict_data` VALUES (1793, 8, '内陆运输费', '8', 'receivable_fee_type', 0, 'default', '', '内陆运输费', '1', '2022-09-05 17:21:35', '1', '2022-09-05 17:21:56', b'0', 'innerTransFee'); INSERT INTO `system_dict_data` VALUES (1794, 1, '仓库清点失误', 'warehouse_error', 'order_in_water_exception_result', 0, 'default', '', NULL, '1', '2022-09-08 17:43:37', '1', '2022-09-08 17:43:37', b'0', 'warehouse error'); INSERT INTO `system_dict_data` VALUES (1795, 2, '中国仓库漏装', 'warehouse_miss', 'order_in_water_exception_result', 0, 'default', '', NULL, '1', '2022-09-08 17:44:05', '1', '2022-09-08 17:44:05', b'0', 'warehouse_miss'); INSERT INTO `system_dict_data` VALUES (1796, 3, 'manifest核对错误', 'mainfest_error', 'order_in_water_exception_result', 0, 'default', '', NULL, '1', '2022-09-08 17:44:24', '1', '2022-09-08 17:44:24', b'0', 'mainfest error'); INSERT INTO `system_dict_data` VALUES (1797, 4, '封柜图与卸柜图不一致', 'image_diff', 'order_in_water_exception_result', 0, 'default', '', NULL, '1', '2022-09-08 17:44:45', '1', '2022-09-08 17:44:45', b'0', 'image diff'); INSERT INTO `system_dict_data` VALUES (1798, 1, '仓库清点失误', 'warehouse_error', 'order_damage_exception_result', 0, 'default', '', NULL, '1', '2022-09-08 17:47:40', '1', '2022-09-08 17:47:40', b'0', 'warehouse error'); INSERT INTO `system_dict_data` VALUES (1799, 2, '中国仓库漏装', 'warehouse_miss', 'order_damage_exception_result', 0, 'default', '', NULL, '1', '2022-09-08 17:47:55', '1', '2022-09-08 17:47:55', b'0', 'warehouse miss'); INSERT INTO `system_dict_data` VALUES (1800, 3, 'manifest核对错误', 'mainfest_error', 'order_damage_exception_result', 0, 'default', '', NULL, '1', '2022-09-08 17:48:12', '1', '2022-09-08 17:48:12', b'0', 'mainfest error'); INSERT INTO `system_dict_data` VALUES (1801, 4, '封柜图与卸柜图不一致', 'image_diff', 'order_damage_exception_result', 0, 'default', '', NULL, '1', '2022-09-08 17:48:26', '1', '2022-09-08 17:48:26', b'0', 'image diff'); INSERT INTO `system_dict_data` VALUES (1802, 1, '仓库清点失误', 'warehouse_error', 'order_superfluous_goods_exception_result', 0, 'default', '', NULL, '1', '2022-09-08 17:51:01', '1', '2022-09-08 17:51:01', b'0', 'warehouse error'); INSERT INTO `system_dict_data` VALUES (1803, 2, '中国仓库漏装', 'warehouse_miss', 'order_superfluous_goods_exception_result', 0, 'default', '', NULL, '1', '2022-09-08 17:51:16', '1', '2022-09-08 17:51:16', b'0', 'warehouse miss'); INSERT INTO `system_dict_data` VALUES (1804, 3, 'manifest核对错误', 'mainfest_error', 'order_superfluous_goods_exception_result', 0, 'default', '', NULL, '1', '2022-09-08 17:51:37', '1', '2022-09-08 17:51:37', b'0', 'mainfest error'); INSERT INTO `system_dict_data` VALUES (1805, 4, '封柜图与卸柜图不一致', 'image_diff', 'order_superfluous_goods_exception_result', 0, 'default', '', NULL, '1', '2022-09-08 17:51:53', '1', '2022-09-08 17:51:53', b'0', 'image diff'); INSERT INTO `system_dict_data` VALUES (1806, 0, '免费送货上门', 'free', 'order_pick_up_exception_result', 0, 'default', '', NULL, '1', '2022-09-08 19:06:27', '1', '2022-09-08 19:06:27', b'0', 'free'); INSERT INTO `system_dict_data` VALUES (1807, 1, '需要收费', 'cost_required', 'order_pick_up_exception_result', 0, 'default', '', NULL, '1', '2022-09-08 19:06:44', '1', '2022-09-08 19:06:49', b'0', 'cost required'); INSERT INTO `system_dict_data` VALUES (1808, 16, '提货异常', 'order_pick_up_exception', 'order_error_type', 0, 'default', '', NULL, '1', '2022-09-08 20:40:21', '1', '2022-09-08 20:40:21', b'0', 'pick up exception'); INSERT INTO `system_dict_data` VALUES (1809, 1, '运费', '1', 'cost_fee_type', 0, 'default', '', '运费', '125', '2022-09-09 16:32:04', '125', '2022-09-09 16:33:51', b'0', 'freight'); INSERT INTO `system_dict_data` VALUES (1810, 2, '清关费', '2', 'cost_fee_type', 0, 'default', '', '清关费', '125', '2022-09-09 16:33:07', '125', '2022-09-09 16:33:44', b'0', 'clearance_fee'); INSERT INTO `system_dict_data` VALUES (1811, 3, '其他费用', '3', 'cost_fee_type', 0, 'default', '', '其他费用', '125', '2022-09-09 16:33:27', '125', '2022-09-09 16:33:37', b'0', 'other_fee'); INSERT INTO `system_dict_data` VALUES (1812, 4, '货值', '4', 'cost_fee_type', 0, 'default', '', '货值', '125', '2022-09-09 16:34:16', '125', '2022-09-09 16:34:16', b'0', 'worth'); INSERT INTO `system_dict_data` VALUES (1813, 5, '保价费', '5', 'cost_fee_type', 0, 'default', '', '保价费', '125', '2022-09-09 16:34:59', '125', '2022-09-09 16:34:59', b'0', 'insurance_fee'); INSERT INTO `system_dict_data` VALUES (1814, 6, '原运费', '6', 'cost_fee_type', 0, 'default', '', '原运费', '125', '2022-09-09 17:14:35', '125', '2022-09-09 17:14:35', b'0', 'original_freight'); INSERT INTO `system_dict_data` VALUES (1815, 7, '原清关费', '7', 'cost_fee_type', 0, 'default', '', '原清关费', '125', '2022-09-09 17:15:05', '125', '2022-09-09 17:15:05', b'0', 'original_clearance_fee'); INSERT INTO `system_dict_data` VALUES (1816, 8, '优惠金额', '8', 'cost_fee_type', 0, 'default', '', '优惠金额', '125', '2022-09-09 17:15:38', '125', '2022-09-09 17:15:38', b'0', 'discount_fee'); INSERT INTO `system_dict_data` VALUES (1817, 1, ' 处理中', '1', 'apply_status', 0, 'default', '', NULL, '1', '2022-09-10 21:28:05', '1', '2022-09-10 21:28:05', b'0', 'being processed'); INSERT INTO `system_dict_data` VALUES (1818, 2, '通过', '2', 'apply_status', 0, 'default', '', NULL, '1', '2022-09-10 21:29:19', '1', '2022-09-10 21:29:19', b'0', 'pass'); INSERT INTO `system_dict_data` VALUES (1819, 3, '不通过', '3', 'apply_status', 0, 'default', '', NULL, '1', '2022-09-10 21:29:40', '1', '2022-09-10 21:29:40', b'0', 'no pass'); INSERT INTO `system_dict_data` VALUES (1820, 4, '已取消', '4', 'apply_status', 0, 'default', '', NULL, '1', '2022-09-10 21:30:20', '1', '2022-09-10 21:30:20', b'0', 'Has been cancelled'); INSERT INTO `system_dict_data` VALUES (1821, 0, '未提交', '0', 'apply_status', 0, 'default', '', NULL, '1', '2022-09-10 21:40:40', '1', '2022-09-10 21:40:40', b'0', 'uncommitted'); INSERT INTO `system_dict_data` VALUES (1822, 5, '删除供应商银行账号密码', '5', 'pwd_type', 0, 'default', '', NULL, '119', '2022-09-16 16:57:25', '115', '2022-09-22 14:19:44', b'0', 'Delete password'); INSERT INTO `system_dict_data` VALUES (1823, 8, '公司FB', '8', 'customer_source', 0, 'default', '', NULL, '1', '2022-09-18 21:52:01', '1', '2022-10-15 22:29:13', b'0', 'Facebook'); INSERT INTO `system_dict_data` VALUES (1824, 21, '部分提货', '21', 'order_status', 0, 'default', '', '部分提货', '1', '2022-09-20 23:31:55', '1', '2022-09-20 23:32:13', b'0', 'part_pick_up'); INSERT INTO `system_dict_data` VALUES (1825, 9, '木托打包费', '9', 'receivable_fee_type', 0, 'default', '', NULL, '1', '2022-09-21 09:03:02', '1', '2022-09-21 09:05:16', b'0', 'beat wooden pallets'); INSERT INTO `system_dict_data` VALUES (1826, 10, '打木托费', '10', 'receivable_fee_type', 0, 'default', '', NULL, '1', '2022-09-21 09:03:40', '1', '2022-09-21 09:04:49', b'1', 'beat wooden pallets'); INSERT INTO `system_dict_data` VALUES (1827, 10, '木箱打包费', '10', 'receivable_fee_type', 0, 'default', '', NULL, '1', '2022-09-21 09:05:40', '1', '2022-09-21 09:05:40', b'0', 'box'); INSERT INTO `system_dict_data` VALUES (1828, 11, '袋装打包费', '11', 'receivable_fee_type', 0, 'default', '', NULL, '1', '2022-09-21 09:06:10', '1', '2022-09-21 09:06:28', b'0', 'bagged'); INSERT INTO `system_dict_data` VALUES (1829, 12, '航空箱费用', '12', 'receivable_fee_type', 0, 'default', '', NULL, '1', '2022-09-21 09:07:13', '1', '2022-09-21 09:07:13', b'0', 'Flight Case'); INSERT INTO `system_dict_data` VALUES (1830, 1, '未报价', '1', 'order_abnormal_state', 0, 'default', '', '未报价', '125', '2022-09-21 23:03:06', '125', '2022-09-21 23:03:06', b'0', 'no quote'); INSERT INTO `system_dict_data` VALUES (1831, 2, '多箱', '2', 'order_abnormal_state', 0, 'default', '', NULL, '125', '2022-09-21 23:03:25', '125', '2022-09-21 23:03:25', b'0', 'superfluous box'); INSERT INTO `system_dict_data` VALUES (1832, 3, '少箱', '3', 'order_abnormal_state', 0, 'default', '', NULL, '125', '2022-09-21 23:03:42', '125', '2022-09-21 23:03:42', b'0', 'lack box'); INSERT INTO `system_dict_data` VALUES (1833, 4, '产品需要预付运费', '4', 'order_abnormal_state', 0, 'default', '', NULL, '125', '2022-09-21 23:11:27', '125', '2022-09-21 23:11:27', b'0', 'pay'); INSERT INTO `system_dict_data` VALUES (1834, 5, '货物丢失', '5', 'order_abnormal_state', 0, 'default', '', NULL, '125', '2022-09-21 23:11:51', '125', '2022-09-21 23:11:51', b'0', 'miss goods'); INSERT INTO `system_dict_data` VALUES (1835, 6, '货物增多', '6', 'order_abnormal_state', 0, 'default', '', NULL, '125', '2022-09-21 23:12:07', '125', '2022-09-21 23:12:07', b'0', 'superfluous goods'); INSERT INTO `system_dict_data` VALUES (1836, 7, '货物破损', '7', 'order_abnormal_state', 0, 'default', '', NULL, '125', '2022-09-21 23:12:33', '125', '2022-09-21 23:12:33', b'0', 'damage exception'); INSERT INTO `system_dict_data` VALUES (1837, 8, '货物浸水', '8', 'order_abnormal_state', 0, 'default', '', NULL, '125', '2022-09-21 23:12:50', '125', '2022-09-21 23:12:50', b'0', 'in water'); INSERT INTO `system_dict_data` VALUES (1838, 9, '重货异常', '9', 'order_abnormal_state', 0, 'default', '', NULL, '125', '2022-09-21 23:13:06', '125', '2022-09-21 23:13:06', b'0', 'heavy cargo'); INSERT INTO `system_dict_data` VALUES (1839, 10, '泡货异常', '10', 'order_abnormal_state', 0, 'default', '', NULL, '125', '2022-09-21 23:13:23', '125', '2022-09-21 23:13:23', b'0', 'bulky cargo'); INSERT INTO `system_dict_data` VALUES (1840, 11, '单证异常', '11', 'order_abnormal_state', 0, 'default', '', NULL, '125', '2022-09-21 23:13:47', '125', '2022-09-21 23:13:47', b'0', 'doc exception'); INSERT INTO `system_dict_data` VALUES (1841, 12, '发货人异常', '12', 'order_abnormal_state', 0, 'default', '', NULL, '125', '2022-09-21 23:14:03', '125', '2022-09-21 23:14:03', b'0', 'consignor exception'); INSERT INTO `system_dict_data` VALUES (1842, 13, '代收货款', '13', 'order_abnormal_state', 0, 'default', '', NULL, '125', '2022-09-21 23:14:17', '125', '2022-09-21 23:14:17', b'0', 'cod'); INSERT INTO `system_dict_data` VALUES (1843, 14, '其它异常', '14', 'order_abnormal_state', 0, 'default', '', NULL, '125', '2022-09-21 23:14:35', '125', '2022-09-21 23:14:35', b'0', 'other exception'); INSERT INTO `system_dict_data` VALUES (1844, 15, '提货异常', '15', 'order_abnormal_state', 0, 'default', '', NULL, '125', '2022-09-21 23:14:47', '125', '2022-09-21 23:14:47', b'0', 'pick up exception'); INSERT INTO `system_dict_data` VALUES (1845, 0, '已审核', '0', 'price_audit_status', 0, 'default', '', NULL, '115', '2022-09-22 00:38:21', '115', '2022-09-22 00:38:21', b'0', 'approve'); INSERT INTO `system_dict_data` VALUES (1846, 0, '未审核', '1', 'price_audit_status', 0, 'default', '', NULL, '115', '2022-09-22 00:38:29', '115', '2022-09-22 00:38:29', b'0', 'todo'); INSERT INTO `system_dict_data` VALUES (1847, 7, '跟进中', '7', 'offer_status', 0, 'default', '', '跟进中', '125', '2022-09-22 01:02:21', '125', '2022-09-22 01:02:21', b'0', '跟进中'); INSERT INTO `system_dict_data` VALUES (1848, 1, '订舱', '1', 'shipping_process_sea_air', 0, 'default', '', NULL, '1', '2022-09-22 11:31:53', '1', '2022-09-22 11:31:53', b'0', 'booking'); INSERT INTO `system_dict_data` VALUES (1849, 2, '排单', '2', 'shipping_process_sea_air', 0, 'default', '', NULL, '1', '2022-09-22 11:32:17', '1', '2022-09-22 11:32:17', b'0', 'preinstall'); INSERT INTO `system_dict_data` VALUES (1850, 3, '理货', '16', 'shipping_process_sea_air', 0, 'default', '', NULL, '1', '2022-09-22 11:32:54', '1', '2022-09-22 11:36:46', b'0', 'tally'); INSERT INTO `system_dict_data` VALUES (1851, 3, '拖车', '3', 'shipping_process_sea_air', 0, 'default', '', NULL, '1', '2022-09-22 11:33:38', '1', '2022-09-22 11:33:38', b'0', 'trailer'); INSERT INTO `system_dict_data` VALUES (1852, 4, '装柜', '4', 'shipping_process_sea_air', 0, 'default', '', NULL, '1', '2022-09-22 11:34:21', '1', '2022-09-22 11:34:21', b'0', 'cabinet'); INSERT INTO `system_dict_data` VALUES (1853, 5, '报关', '5', 'shipping_process_sea_air', 0, 'default', '', NULL, '1', '2022-09-22 11:35:40', '1', '2022-09-22 11:35:40', b'0', 'cusDeclaration'); INSERT INTO `system_dict_data` VALUES (1854, 6, '配船', '6', 'shipping_process_sea_air', 0, 'default', '', NULL, '1', '2022-09-22 11:35:54', '1', '2022-09-22 11:35:54', b'0', 'ship'); INSERT INTO `system_dict_data` VALUES (1855, 7, '提单补料', '7', 'shipping_process_sea_air', 0, 'default', '', NULL, '1', '2022-09-22 11:36:14', '1', '2022-09-22 11:36:14', b'0', 'subMaterial'); INSERT INTO `system_dict_data` VALUES (1856, 8, '驳船', '8', 'shipping_process_sea_air', 0, 'default', '', NULL, '1', '2022-09-22 11:36:33', '1', '2022-09-22 11:36:33', b'0', 'barge'); INSERT INTO `system_dict_data` VALUES (1857, 9, '起运', '9', 'shipping_process_sea_air', 0, 'default', '', NULL, '1', '2022-09-22 11:41:43', '1', '2022-09-22 11:41:43', b'0', 'departure'); INSERT INTO `system_dict_data` VALUES (1858, 10, '提单COPY', '10', 'shipping_process_sea_air', 0, 'default', '', NULL, '1', '2022-09-22 11:42:20', '1', '2022-09-22 11:42:20', b'0', '提单Copy'); INSERT INTO `system_dict_data` VALUES (1859, 11, '清关文件', '11', 'shipping_process_sea_air', 0, 'default', '', NULL, '1', '2022-09-22 11:43:05', '1', '2022-09-22 11:43:05', b'0', 'clrDocument'); INSERT INTO `system_dict_data` VALUES (1860, 12, '到港', '12', 'shipping_process_sea_air', 0, 'default', '', NULL, '1', '2022-09-22 11:43:24', '1', '2022-09-22 11:43:24', b'0', 'arrival'); INSERT INTO `system_dict_data` VALUES (1861, 13, '清关', '13', 'shipping_process_sea_air', 0, 'default', '', NULL, '1', '2022-09-22 11:43:47', '1', '2022-09-22 11:43:47', b'0', 'cusClearance'); INSERT INTO `system_dict_data` VALUES (1862, 14, '二程起飞', '14', 'shipping_process_sea_air', 0, 'default', '', NULL, '1', '2022-09-22 11:45:41', '1', '2022-09-22 11:45:41', b'0', 'Two way takeoff'); INSERT INTO `system_dict_data` VALUES (1863, 15, '二程到港', '15', 'shipping_process_sea_air', 0, 'default', '', NULL, '1', '2022-09-22 11:47:02', '1', '2022-09-22 11:47:02', b'0', 'Two way arrival'); INSERT INTO `system_dict_data` VALUES (1864, 17, '卸柜', '17', 'shipping_process_sea_air', 0, 'default', '', NULL, '1', '2022-09-22 11:47:27', '1', '2022-09-22 11:47:27', b'0', 'unloading'); INSERT INTO `system_dict_data` VALUES (1865, 18, '结算', '18', 'shipping_process_sea_air', 0, 'default', '', NULL, '1', '2022-09-22 11:48:08', '1', '2022-09-22 11:48:08', b'0', 'settlement'); INSERT INTO `system_dict_data` VALUES (1866, 6, '装柜补单密码', '6', 'pwd_type', 0, 'default', '', NULL, '115', '2022-09-22 14:19:34', '115', '2022-09-22 14:19:34', b'0', 'Password for filling order'); INSERT INTO `system_dict_data` VALUES (1867, 10, '控货订单取消放货', '10', 'order_approval_type', 0, 'default', '', '控货订单取消放货', '125', '2022-09-23 23:17:34', '125', '2022-09-23 23:18:00', b'0', 'order_cargo_cotrol_cancel_pick'); INSERT INTO `system_dict_data` VALUES (1868, 11, '合单申请', '11', 'order_approval_type', 0, 'default', '', '合单申请', '1', '2022-09-25 18:04:53', '1', '2022-09-25 18:04:53', b'0', 'merge_order'); INSERT INTO `system_dict_data` VALUES (1869, 12, '费用申请', '12', 'order_approval_type', 0, 'default', '', '费用申请', '1', '2022-09-25 18:07:00', '1', '2022-09-25 18:07:00', b'0', 'expense_apply'); INSERT INTO `system_dict_data` VALUES (1870, 18, '预装审核', '18', 'order_approval_type', 0, 'default', '', '预装审核', '1', '2022-09-25 18:11:36', '1', '2022-09-25 18:11:36', b'0', 'pre_install'); INSERT INTO `system_dict_data` VALUES (1871, 19, '封柜审核', '19', 'order_approval_type', 0, 'default', '', '封柜审核', '1', '2022-09-25 18:13:11', '1', '2022-09-25 18:13:11', b'0', 'closure'); INSERT INTO `system_dict_data` VALUES (1872, 5, '调货审核中', '5', 'release_status', 0, 'default', '', '调货审核中', '1', '2022-09-26 22:12:26', '1', '2022-09-26 22:12:26', b'0', '调货审核中'); INSERT INTO `system_dict_data` VALUES (1873, 6, '取消放货审核中', '6', 'release_status', 0, 'default', '', '取消放货审核中', '1', '2022-09-26 22:13:21', '1', '2022-09-26 22:13:21', b'0', '取消放货审核中'); INSERT INTO `system_dict_data` VALUES (1874, 0, '修改放货人信息', '1', 'cancel_pick_type', 0, 'default', '', '', '115', '2022-09-27 15:55:31', '115', '2022-09-27 15:55:31', b'0', '修改放货人信息'); INSERT INTO `system_dict_data` VALUES (1875, 0, '展缓放货', '2', 'cancel_pick_type', 0, 'default', '', NULL, '115', '2022-09-27 15:55:36', '115', '2022-09-27 15:55:36', b'0', '展缓放货'); INSERT INTO `system_dict_data` VALUES (1876, 4, '特价申请中', '4', 'order_status', 0, 'default', '', '特价申请中', '1', '2022-09-28 00:06:56', '1', '2022-09-28 00:06:56', b'0', 'Special apply in progress'); INSERT INTO `system_dict_data` VALUES (1877, 99, '多个异常', '99', 'order_abnormal_state', 0, 'default', '', '多个异常', '1', '2022-09-28 00:10:44', '1', '2022-09-28 00:10:44', b'0', 'multiple_exception'); INSERT INTO `system_dict_data` VALUES (1878, 201, '入仓中', '201', 'order_warehouse_in_status', 0, 'default', '', NULL, '1', '2022-09-28 10:15:35', '1', '2022-09-28 10:15:35', b'0', 'warehousing'); INSERT INTO `system_dict_data` VALUES (1879, 202, '已入仓', '202', 'order_warehouse_in_status', 0, 'default', '', NULL, '1', '2022-09-28 10:15:53', '1', '2022-09-28 10:15:53', b'0', 'warehouse_finished'); INSERT INTO `system_dict_data` VALUES (1880, 203, '入仓修改审核中', '203', 'order_warehouse_in_status', 0, 'default', '', NULL, '1', '2022-09-28 10:16:02', '1', '2022-09-28 10:16:02', b'0', 'update_applying'); INSERT INTO `system_dict_data` VALUES (1881, 204, '退仓申请中', '204', 'order_warehouse_in_status', 0, 'default', '', NULL, '1', '2022-09-28 10:16:13', '1', '2022-09-28 10:16:13', b'0', 'rollback_applying'); INSERT INTO `system_dict_data` VALUES (1882, 205, '退仓通过，费用待清缴', '205', 'order_warehouse_in_status', 0, 'default', '', NULL, '1', '2022-09-28 10:16:24', '1', '2022-09-28 10:16:24', b'0', 'rollback_passed_wait_pay'); INSERT INTO `system_dict_data` VALUES (1883, 206, '已退仓', '206', 'order_warehouse_in_status', 0, 'default', '', NULL, '1', '2022-09-28 10:16:33', '1', '2022-09-28 10:16:33', b'0', 'rollback_finished'); INSERT INTO `system_dict_data` VALUES (1884, 207, '拆单申请中', '207', 'order_warehouse_in_status', 0, 'default', '', NULL, '1', '2022-09-28 10:16:45', '1', '2022-09-28 10:16:45', b'0', 'order_split_applying'); INSERT INTO `system_dict_data` VALUES (1885, 208, '已拆单', '208', 'order_warehouse_in_status', 0, 'default', '', NULL, '1', '2022-09-28 10:16:54', '1', '2022-09-28 10:16:54', b'0', 'order_split_finished'); INSERT INTO `system_dict_data` VALUES (1886, 209, '合单申请中', '209', 'order_warehouse_in_status', 0, 'default', '', NULL, '1', '2022-09-28 10:17:04', '1', '2022-09-28 10:17:04', b'0', 'order_merge_applying'); INSERT INTO `system_dict_data` VALUES (1887, 210, '已合单', '210', 'order_warehouse_in_status', 0, 'default', '', NULL, '1', '2022-09-28 10:17:40', '1', '2022-09-28 10:17:40', b'0', 'order_merge_apply_pass'); INSERT INTO `system_dict_data` VALUES (1888, 211, '已合单归档', '211', 'order_warehouse_in_status', 0, 'default', '', NULL, '1', '2022-09-28 10:17:49', '1', '2022-09-28 10:17:49', b'0', 'order_merge_apply_finish'); INSERT INTO `system_dict_data` VALUES (1889, 212, '调仓审核中', '212', 'order_warehouse_in_status', 0, 'default', '', NULL, '1', '2022-09-28 10:17:59', '1', '2022-09-28 10:17:59', b'0', 'adjust_applying'); INSERT INTO `system_dict_data` VALUES (1890, 213, '调仓待出仓', '213', 'order_warehouse_in_status', 0, 'default', '', NULL, '1', '2022-09-28 10:18:08', '1', '2022-09-28 10:18:08', b'0', 'adjust_wait_out'); INSERT INTO `system_dict_data` VALUES (1891, 214, '调仓待入仓', '214', 'order_warehouse_in_status', 0, 'default', '', NULL, '1', '2022-09-28 10:18:18', '1', '2022-09-28 10:18:18', b'0', 'adjust_wait_in'); INSERT INTO `system_dict_data` VALUES (1892, 215, '调仓已到仓', '215', 'order_warehouse_in_status', 0, 'default', '', NULL, '1', '2022-09-28 10:18:27', '1', '2022-09-28 10:18:27', b'0', 'adjust_finished'); INSERT INTO `system_dict_data` VALUES (1893, 1, '待订舱', '301', 'order_shipment_state', 0, 'default', '', NULL, '1', '2022-09-28 11:43:14', '1', '2022-09-28 11:43:14', b'0', 'WAIT_FOR_BOOKING'); INSERT INTO `system_dict_data` VALUES (1894, 3, '已订舱，待预装', '303', 'order_shipment_state', 0, 'default', '', NULL, '1', '2022-09-28 11:43:35', '1', '2022-09-28 11:43:35', b'0', 'BOOKING_FOR_PREINSTALL'); INSERT INTO `system_dict_data` VALUES (1895, 5, '预装审核中', '305', 'order_shipment_state', 0, 'default', '', NULL, '1', '2022-09-28 11:43:52', '1', '2022-09-28 11:43:52', b'0', 'PREINSTALL_EXAMINE'); INSERT INTO `system_dict_data` VALUES (1896, 6, '预装失败', '306', 'order_shipment_state', 0, 'default', '', NULL, '1', '2022-09-28 11:44:08', '1', '2022-09-28 11:44:08', b'0', 'PREINSTALL_EXAMINE_FAIL'); INSERT INTO `system_dict_data` VALUES (1897, 7, '预装通过，待装柜', '307', 'order_shipment_state', 0, 'default', '', NULL, '1', '2022-09-28 11:44:23', '1', '2022-09-28 11:44:23', b'0', 'PREINSTALL_EXAMINE_SUCCESS'); INSERT INTO `system_dict_data` VALUES (1898, 9, '已派车，待提柜', '309', 'order_shipment_state', 0, 'default', '', NULL, '1', '2022-09-28 11:44:41', '1', '2022-09-28 11:44:41', b'0', 'DISPATCHED_WAIT_CABINETS'); INSERT INTO `system_dict_data` VALUES (1899, 10, '已提柜，待还柜', '310', 'order_shipment_state', 0, 'default', '', NULL, '1', '2022-09-28 11:44:59', '1', '2022-09-28 11:44:59', b'0', 'LIFTED_WAIT_RETURN'); INSERT INTO `system_dict_data` VALUES (1900, 11, '已还柜', '311', 'order_shipment_state', 0, 'default', '', NULL, '1', '2022-09-28 11:45:14', '1', '2022-09-28 11:45:14', b'0', 'CABINETS_RETURNED'); INSERT INTO `system_dict_data` VALUES (1901, 13, '装柜中', '313', 'order_shipment_state', 0, 'default', '', NULL, '1', '2022-09-28 11:45:30', '1', '2022-09-28 11:45:30', b'0', 'IN_THE_CABINETS'); INSERT INTO `system_dict_data` VALUES (1902, 14, '已装柜，待封柜', '314', 'order_shipment_state', 0, 'default', '', NULL, '1', '2022-09-28 11:45:45', '1', '2022-09-28 11:45:45', b'0', 'INSTALLED_WAIT_SEALED'); INSERT INTO `system_dict_data` VALUES (1903, 15, '装柜审核中', '315', 'order_shipment_state', 0, 'default', '', NULL, '1', '2022-09-28 11:46:00', '1', '2022-09-28 11:46:00', b'0', 'SEAL_EXAMINE'); INSERT INTO `system_dict_data` VALUES (1904, 16, '装柜审核驳回，装柜中', '316', 'order_shipment_state', 0, 'default', '', NULL, '1', '2022-09-28 11:46:18', '1', '2022-09-28 11:46:18', b'0', 'SEAL_EXAMINE_FAIL'); INSERT INTO `system_dict_data` VALUES (1905, 17, '装柜审核通过，待封柜', '317', 'order_shipment_state', 0, 'default', '', NULL, '1', '2022-09-28 11:46:36', '1', '2022-09-28 11:46:36', b'0', 'SEAL_EXAMINE_SUCCESS'); INSERT INTO `system_dict_data` VALUES (1906, 18, '已封柜', '318', 'order_shipment_state', 0, 'default', '', NULL, '1', '2022-09-28 11:46:50', '1', '2022-09-28 11:46:50', b'0', 'SEALED'); INSERT INTO `system_dict_data` VALUES (1907, 20, '报关中', '320', 'order_shipment_state', 0, 'default', '', NULL, '1', '2022-09-28 11:47:06', '1', '2022-09-28 11:47:06', b'0', 'CUSTOMSING'); INSERT INTO `system_dict_data` VALUES (1908, 22, '报关-查验失败-部分退场', '322', 'order_shipment_state', 0, 'default', '', NULL, '1', '2022-09-28 11:47:24', '1', '2022-09-28 11:47:24', b'0', 'CUSTOMS_PART_EXIT'); INSERT INTO `system_dict_data` VALUES (1909, 23, '报关-查验失败-全部退场', '323', 'order_shipment_state', 0, 'default', '', NULL, '1', '2022-09-28 11:47:47', '1', '2022-09-28 11:47:47', b'0', 'CUSTOMS_FULL_EXIT'); INSERT INTO `system_dict_data` VALUES (1910, 24, '报关-查验后放行', '324', 'order_shipment_state', 0, 'default', '', NULL, '1', '2022-09-28 11:48:01', '1', '2022-09-28 11:48:01', b'0', 'CUSTOMS_CHECK_PASS'); INSERT INTO `system_dict_data` VALUES (1911, 25, '报关-放行', '325', 'order_shipment_state', 0, 'default', '', NULL, '1', '2022-09-28 11:48:18', '1', '2022-09-28 11:48:18', b'0', 'CUSTOMS_PASS'); INSERT INTO `system_dict_data` VALUES (1912, 26, '起运-航运中', '326', 'order_shipment_state', 0, 'default', '', NULL, '1', '2022-09-28 11:48:37', '1', '2022-09-28 11:48:37', b'0', 'SHIPPING'); INSERT INTO `system_dict_data` VALUES (1913, 28, '已到港，待卸港', '328', 'order_shipment_state', 0, 'default', '', NULL, '1', '2022-09-28 11:48:56', '1', '2022-09-28 11:48:56', b'0', 'ARRIVAL_WAIT_DISCHARGE'); INSERT INTO `system_dict_data` VALUES (1914, 29, '已卸港，待清关', '329', 'order_shipment_state', 0, 'default', '', NULL, '1', '2022-09-28 11:49:14', '1', '2022-09-28 11:49:14', b'0', 'DISCHARGE_WAIT_CLEARANCE'); INSERT INTO `system_dict_data` VALUES (1915, 30, '已清关', '330', 'order_shipment_state', 0, 'default', '', NULL, '1', '2022-09-28 11:49:30', '115', '2022-10-21 10:39:24', b'0', 'CLEARANCE_WAIT_UNLOAD'); INSERT INTO `system_dict_data` VALUES (1916, 32, '卸柜审核中', '332', 'order_shipment_state', 0, 'default', '', NULL, '1', '2022-09-28 11:49:41', '1', '2022-09-28 11:49:41', b'0', 'UNLOAD_EXAMINE'); INSERT INTO `system_dict_data` VALUES (1917, 33, '卸柜审批失败', '333', 'order_shipment_state', 0, 'default', '', NULL, '1', '2022-09-28 11:49:55', '1', '2022-09-28 11:49:55', b'0', 'UNLOAD_EXAMINE_FAIL'); INSERT INTO `system_dict_data` VALUES (1918, 34, '卸柜审批成功', '334', 'order_shipment_state', 0, 'default', '', NULL, '1', '2022-09-28 11:50:09', '1', '2022-09-28 11:50:09', b'0', 'UNLOAD_EXAMINE_SUCCESS'); INSERT INTO `system_dict_data` VALUES (1919, 35, '已卸柜', '335', 'order_shipment_state', 0, 'default', '', NULL, '1', '2022-09-28 11:50:23', '1', '2022-09-28 11:50:23', b'0', 'UNLOADED'); INSERT INTO `system_dict_data` VALUES (1920, 36, '货柜待结算', '336', 'order_shipment_state', 0, 'default', '', NULL, '1', '2022-09-28 11:50:36', '1', '2022-09-28 11:50:36', b'0', 'WAIT_SETTLEMENT'); INSERT INTO `system_dict_data` VALUES (1921, 37, '货柜结算中', '337', 'order_shipment_state', 0, 'default', '', NULL, '1', '2022-09-28 11:50:50', '1', '2022-09-28 11:50:50', b'0', 'SETTLEMENTING'); INSERT INTO `system_dict_data` VALUES (1922, 38, '货柜已结算', '338', 'order_shipment_state', 0, 'default', '', NULL, '1', '2022-09-28 11:51:04', '1', '2022-09-28 11:51:04', b'0', 'SETTLEMENTED'); INSERT INTO `system_dict_data` VALUES (1923, 14, '订单修改', '14', 'order_approval_type', 0, 'default', '', '订单修改', '1', '2022-09-30 11:36:07', '1', '2022-09-30 11:36:07', b'0', 'order_update'); INSERT INTO `system_dict_data` VALUES (1924, 7, '桶', '7', 'packaging_type', 0, 'default', '', NULL, '115', '2022-10-04 17:49:10', '115', '2022-10-04 17:49:10', b'0', 'bucket'); INSERT INTO `system_dict_data` VALUES (1925, 8, '压缩包', '8', 'packaging_type', 0, 'default', '', NULL, '115', '2022-10-04 17:50:05', '115', '2022-10-04 17:50:05', b'0', 'Compressed package'); INSERT INTO `system_dict_data` VALUES (1926, 5, '预付', '5', 'payment_type', 0, 'default', '', '预付', '1', '2022-10-05 20:11:39', '1', '2022-10-05 20:11:39', b'0', 'Pay Advance'); INSERT INTO `system_dict_data` VALUES (1927, 0, '预计报关时间', '1', 'shipping_noticeType', 0, 'default', '', NULL, '1', '2022-10-05 22:28:50', '1', '2022-10-05 22:28:50', b'0', '预计报关时间'); INSERT INTO `system_dict_data` VALUES (1928, 1, '预计截补料时间', '2', 'shipping_noticeType', 0, 'default', '', NULL, '1', '2022-10-05 22:29:11', '1', '2022-10-05 22:29:11', b'0', '预计截补料时间'); INSERT INTO `system_dict_data` VALUES (1929, 2, '预计开船时间', '3', 'shipping_noticeType', 0, 'default', '', NULL, '1', '2022-10-05 22:29:26', '1', '2022-10-05 22:29:26', b'0', '预计开船时间'); INSERT INTO `system_dict_data` VALUES (1930, 3, '预计截关时间', '4', 'shipping_noticeType', 0, 'default', '', NULL, '1', '2022-10-05 22:29:36', '1', '2022-10-05 22:29:36', b'0', '预计截关时间'); INSERT INTO `system_dict_data` VALUES (1931, 1, '预计报关时间', '1', 'shipping_notice_type', 0, 'default', '', NULL, '1', '2022-10-05 22:32:24', '1', '2022-10-05 22:32:24', b'0', '预计报关时间'); INSERT INTO `system_dict_data` VALUES (1932, 2, '预计截补料时间', '2', 'shipping_notice_type', 0, 'default', '', NULL, '1', '2022-10-05 22:32:31', '1', '2022-10-05 22:32:31', b'0', '预计截补料时间'); INSERT INTO `system_dict_data` VALUES (1933, 3, '预计开船时间', '3', 'shipping_notice_type', 0, 'default', '', NULL, '1', '2022-10-05 22:32:41', '1', '2022-10-05 22:32:41', b'0', '预计开船时间'); INSERT INTO `system_dict_data` VALUES (1934, 4, '预计截关时间', '4', 'shipping_notice_type', 0, 'default', '', NULL, '1', '2022-10-05 22:32:48', '1', '2022-10-05 22:32:48', b'0', '预计截关时间'); INSERT INTO `system_dict_data` VALUES (1935, 1, '已确认无误', 'confirmed', 'order_miss_exception_don_result', 0, 'default', '', NULL, '1', '2022-10-06 22:31:52', '1', '2022-10-06 22:31:52', b'0', 'confirmed'); INSERT INTO `system_dict_data` VALUES (1936, 2, '仓库已找回', 'warehouse_retrieved', 'order_miss_exception_don_result', 0, 'default', '', NULL, '1', '2022-10-06 22:32:06', '1', '2022-10-06 22:32:06', b'0', 'warehouse_retrieved'); INSERT INTO `system_dict_data` VALUES (1937, 3, '已确认丢失,协商赔偿', 'confirm_loss', 'order_miss_exception_don_result', 0, 'default', '', NULL, '1', '2022-10-06 22:32:20', '1', '2022-10-06 22:32:30', b'0', 'confirm_loss'); INSERT INTO `system_dict_data` VALUES (1938, 1, '已确认无误', 'confirmed', 'order_superfluous_goods_exception_don_result', 0, 'default', '', NULL, '1', '2022-10-06 22:32:58', '1', '2022-10-06 22:32:58', b'0', 'confirmed'); INSERT INTO `system_dict_data` VALUES (1939, 2, '仓库已找回', 'warehouse_retrieved', 'order_superfluous_goods_exception_don_result', 0, 'default', '', NULL, '1', '2022-10-06 22:33:09', '1', '2022-10-06 22:33:09', b'0', 'warehouse_retrieved'); INSERT INTO `system_dict_data` VALUES (1940, 3, '已确认丢失,协商赔偿', 'confirm_loss', 'order_superfluous_goods_exception_don_result', 0, 'default', '', NULL, '1', '2022-10-06 22:33:21', '1', '2022-10-06 22:33:21', b'0', 'confirm_loss'); INSERT INTO `system_dict_data` VALUES (1941, 1, '已确认无误', 'confirmed', 'order_damage_exception_don_result', 0, 'default', '', NULL, '1', '2022-10-06 22:33:43', '1', '2022-10-06 22:33:43', b'0', 'confirmed'); INSERT INTO `system_dict_data` VALUES (1942, 2, '仓库已找回', 'warehouse_retrieved', 'order_damage_exception_don_result', 0, 'default', '', NULL, '1', '2022-10-06 22:33:53', '1', '2022-10-06 22:33:53', b'0', 'warehouse_retrieved'); INSERT INTO `system_dict_data` VALUES (1943, 3, '已确认丢失,协商赔偿', 'confirm_loss', 'order_damage_exception_don_result', 0, 'default', '', NULL, '1', '2022-10-06 22:34:09', '1', '2022-10-06 22:34:09', b'0', 'confirm_loss'); INSERT INTO `system_dict_data` VALUES (1944, 1, '已确认无误', 'confirmed', 'order_in_water_exception_don_result', 0, 'default', '', NULL, '1', '2022-10-06 22:34:30', '1', '2022-10-06 22:34:30', b'0', 'confirmed'); INSERT INTO `system_dict_data` VALUES (1945, 2, '仓库已找回', 'warehouse_retrieved', 'order_in_water_exception_don_result', 0, 'default', '', NULL, '1', '2022-10-06 22:34:40', '1', '2022-10-06 22:34:40', b'0', 'warehouse_retrieved'); INSERT INTO `system_dict_data` VALUES (1946, 3, '已确认丢失,协商赔偿', 'confirm_loss', 'order_in_water_exception_don_result', 0, 'default', '', NULL, '1', '2022-10-06 22:34:51', '1', '2022-10-06 22:34:51', b'0', 'confirm_loss'); INSERT INTO `system_dict_data` VALUES (1947, 13, '收货人推荐', '13', 'customer_source', 0, 'default', '', NULL, '1', '2022-10-15 22:32:57', '1', '2022-10-15 22:32:57', b'0', 'from consignee'); INSERT INTO `system_dict_data` VALUES (1948, 14, '目的港业务', '14', 'customer_source', 0, 'default', '', NULL, '1', '2022-10-15 22:33:16', '1', '2022-10-15 22:33:16', b'0', 'Foreign business'); INSERT INTO `system_dict_data` VALUES (1949, 15, '同行/经纪推荐', '15', 'customer_source', 0, 'default', '', NULL, '1', '2022-10-15 22:33:37', '1', '2022-10-15 22:33:37', b'0', 'Peer/broker recommendation'); INSERT INTO `system_dict_data` VALUES (1950, 16, '客户指定', '16', 'customer_source', 0, 'default', '', NULL, '1', '2022-10-15 22:33:55', '1', '2022-10-15 22:33:55', b'0', 'customer specified'); INSERT INTO `system_dict_data` VALUES (1951, 17, '国内引荐', '17', 'customer_source', 0, 'default', '', NULL, '1', '2022-10-15 22:34:13', '1', '2022-10-15 22:34:13', b'0', 'Domestic referral'); INSERT INTO `system_dict_data` VALUES (1952, 18, '抖音开发', '18', 'customer_source', 0, 'default', '', NULL, '1', '2022-10-15 22:34:31', '1', '2022-10-15 22:34:31', b'0', 'tick tock'); INSERT INTO `system_dict_data` VALUES (1953, 19, '微信公众号', '19', 'customer_source', 0, 'default', '', NULL, '1', '2022-10-15 22:34:49', '1', '2022-10-15 22:34:49', b'0', 'WeChat public account'); INSERT INTO `system_dict_data` VALUES (1954, 20, '公司内部客户', '20', 'customer_source', 0, 'default', '', NULL, '1', '2022-10-15 22:35:06', '1', '2022-10-15 22:35:06', b'0', 'Internal customers'); INSERT INTO `system_dict_data` VALUES (1955, 21, 'Ins', '21', 'customer_source', 0, 'default', '', NULL, '1', '2022-10-15 22:35:16', '1', '2022-10-15 22:35:16', b'0', 'Ins'); INSERT INTO `system_dict_data` VALUES (1956, 22, '市场部渠道', '22', 'customer_source', 0, 'default', '', NULL, '1', '2022-10-15 22:35:31', '1', '2022-10-15 22:35:31', b'0', 'Marketing department channel'); INSERT INTO `system_dict_data` VALUES (1957, 0, '1', '5', 'write_off_diff', 0, 'default', '', NULL, '1', '2022-10-15 23:43:40', '1', '2022-10-15 23:56:14', b'0', '1'); INSERT INTO `system_dict_data` VALUES (1958, 0, '2', '30', 'write_off_diff', 0, 'default', '', NULL, '1', '2022-10-15 23:44:17', '1', '2022-10-15 23:56:25', b'0', '2'); INSERT INTO `system_dict_data` VALUES (1959, 0, '3', '1', 'write_off_diff', 0, 'default', '', NULL, '1', '2022-10-15 23:44:44', '1', '2022-10-15 23:56:33', b'0', '3'); INSERT INTO `system_dict_data` VALUES (1960, 100, '注册会员', '100', 'customer_source', 0, 'default', '', NULL, '1', '2022-10-18 23:30:54', '1', '2022-10-18 23:30:54', b'0', 'Register'); INSERT INTO `system_dict_data` VALUES (1961, 1, '待订舱', '301', 'shipment_sea_air_state', 0, 'default', '', NULL, '1', '2022-09-28 11:43:14', '1', '2022-09-28 11:43:14', b'0', 'WAIT_FOR_BOOKING'); INSERT INTO `system_dict_data` VALUES (1962, 3, '已订舱，待预装', '303', 'shipment_sea_air_state', 0, 'default', '', NULL, '1', '2022-09-28 11:43:35', '1', '2022-09-28 11:43:35', b'0', 'BOOKING_FOR_PREINSTALL'); INSERT INTO `system_dict_data` VALUES (1963, 5, '预装审核中', '305', 'shipment_sea_air_state', 0, 'default', '', NULL, '1', '2022-09-28 11:43:52', '1', '2022-09-28 11:43:52', b'0', 'PREINSTALL_EXAMINE'); INSERT INTO `system_dict_data` VALUES (1964, 6, '预装失败', '306', 'shipment_sea_air_state', 0, 'default', '', NULL, '1', '2022-09-28 11:44:08', '1', '2022-09-28 11:44:08', b'0', 'PREINSTALL_EXAMINE_FAIL'); INSERT INTO `system_dict_data` VALUES (1965, 7, '预装通过，待装柜', '307', 'shipment_sea_air_state', 0, 'default', '', NULL, '1', '2022-09-28 11:44:23', '1', '2022-09-28 11:44:23', b'0', 'PREINSTALL_EXAMINE_SUCCESS'); INSERT INTO `system_dict_data` VALUES (1966, 9, '已派车，待提柜', '309', 'shipment_sea_air_state', 0, 'default', '', NULL, '1', '2022-09-28 11:44:41', '1', '2022-09-28 11:44:41', b'0', 'DISPATCHED_WAIT_CABINETS'); INSERT INTO `system_dict_data` VALUES (1967, 10, '已提柜，待还柜', '310', 'shipment_sea_air_state', 0, 'default', '', NULL, '1', '2022-09-28 11:44:59', '1', '2022-09-28 11:44:59', b'0', 'LIFTED_WAIT_RETURN'); INSERT INTO `system_dict_data` VALUES (1968, 11, '已还柜', '311', 'shipment_sea_air_state', 0, 'default', '', NULL, '1', '2022-09-28 11:45:14', '1', '2022-09-28 11:45:14', b'0', 'CABINETS_RETURNED'); INSERT INTO `system_dict_data` VALUES (1969, 13, '装柜中', '313', 'shipment_sea_air_state', 0, 'default', '', NULL, '1', '2022-09-28 11:45:30', '1', '2022-09-28 11:45:30', b'0', 'IN_THE_CABINETS'); INSERT INTO `system_dict_data` VALUES (1970, 14, '已装柜，待封柜', '314', 'shipment_sea_air_state', 0, 'default', '', NULL, '1', '2022-09-28 11:45:45', '1', '2022-09-28 11:45:45', b'0', 'INSTALLED_WAIT_SEALED'); INSERT INTO `system_dict_data` VALUES (1971, 15, '装柜审核中', '315', 'shipment_sea_air_state', 0, 'default', '', NULL, '1', '2022-09-28 11:46:00', '1', '2022-09-28 11:46:00', b'0', 'SEAL_EXAMINE'); INSERT INTO `system_dict_data` VALUES (1972, 16, '装柜审核驳回，装柜中', '316', 'shipment_sea_air_state', 0, 'default', '', NULL, '1', '2022-09-28 11:46:18', '1', '2022-09-28 11:46:18', b'0', 'SEAL_EXAMINE_FAIL'); INSERT INTO `system_dict_data` VALUES (1973, 17, '装柜审核通过，待封柜', '317', 'shipment_sea_air_state', 0, 'default', '', NULL, '1', '2022-09-28 11:46:36', '1', '2022-09-28 11:46:36', b'0', 'SEAL_EXAMINE_SUCCESS'); INSERT INTO `system_dict_data` VALUES (1974, 18, '已封柜', '318', 'shipment_sea_air_state', 0, 'default', '', NULL, '1', '2022-09-28 11:46:50', '1', '2022-09-28 11:46:50', b'0', 'SEALED'); INSERT INTO `system_dict_data` VALUES (1975, 20, '报关中', '320', 'shipment_sea_air_state', 0, 'default', '', NULL, '1', '2022-09-28 11:47:06', '1', '2022-09-28 11:47:06', b'0', 'CUSTOMSING'); INSERT INTO `system_dict_data` VALUES (1976, 22, '报关-查验失败-部分退场', '322', 'shipment_sea_air_state', 0, 'default', '', NULL, '1', '2022-09-28 11:47:24', '1', '2022-09-28 11:47:24', b'0', 'CUSTOMS_PART_EXIT'); INSERT INTO `system_dict_data` VALUES (1977, 23, '报关-查验失败-全部退场', '323', 'shipment_sea_air_state', 0, 'default', '', NULL, '1', '2022-09-28 11:47:47', '1', '2022-09-28 11:47:47', b'0', 'CUSTOMS_FULL_EXIT'); INSERT INTO `system_dict_data` VALUES (1978, 24, '报关-查验后放行', '324', 'shipment_sea_air_state', 0, 'default', '', NULL, '1', '2022-09-28 11:48:01', '1', '2022-09-28 11:48:01', b'0', 'CUSTOMS_CHECK_PASS'); INSERT INTO `system_dict_data` VALUES (1979, 25, '报关-放行', '325', 'shipment_sea_air_state', 0, 'default', '', NULL, '1', '2022-09-28 11:48:18', '1', '2022-09-28 11:48:18', b'0', 'CUSTOMS_PASS'); INSERT INTO `system_dict_data` VALUES (1980, 26, '起运-航运中', '326', 'shipment_sea_air_state', 0, 'default', '', NULL, '1', '2022-09-28 11:48:37', '1', '2022-09-28 11:48:37', b'0', 'SHIPPING'); INSERT INTO `system_dict_data` VALUES (1981, 28, '已到港，待卸港', '328', 'shipment_sea_air_state', 0, 'default', '', NULL, '1', '2022-09-28 11:48:56', '1', '2022-09-28 11:48:56', b'0', 'ARRIVAL_WAIT_DISCHARGE'); INSERT INTO `system_dict_data` VALUES (1982, 29, '已卸港，待清关', '329', 'shipment_sea_air_state', 0, 'default', '', NULL, '1', '2022-09-28 11:49:14', '1', '2022-09-28 11:49:14', b'0', 'DISCHARGE_WAIT_CLEARANCE'); INSERT INTO `system_dict_data` VALUES (1983, 30, '已清关', '330', 'shipment_sea_air_state', 0, 'default', '', NULL, '1', '2022-09-28 11:49:30', '115', '2022-10-21 10:39:24', b'0', 'CLEARANCE_WAIT_UNLOAD'); INSERT INTO `system_dict_data` VALUES (1984, 32, '卸柜审核中', '332', 'shipment_sea_air_state', 0, 'default', '', NULL, '1', '2022-09-28 11:49:41', '1', '2022-09-28 11:49:41', b'0', 'UNLOAD_EXAMINE'); INSERT INTO `system_dict_data` VALUES (1985, 33, '卸柜审批失败', '333', 'shipment_sea_air_state', 0, 'default', '', NULL, '1', '2022-09-28 11:49:55', '1', '2022-09-28 11:49:55', b'0', 'UNLOAD_EXAMINE_FAIL'); INSERT INTO `system_dict_data` VALUES (1986, 34, '卸柜审批成功', '334', 'shipment_sea_air_state', 0, 'default', '', NULL, '1', '2022-09-28 11:50:09', '1', '2022-09-28 11:50:09', b'0', 'UNLOAD_EXAMINE_SUCCESS'); INSERT INTO `system_dict_data` VALUES (1987, 35, '已卸柜', '335', 'shipment_sea_air_state', 0, 'default', '', NULL, '1', '2022-09-28 11:50:23', '1', '2022-09-28 11:50:23', b'0', 'UNLOADED'); INSERT INTO `system_dict_data` VALUES (1988, 36, '货柜待结算', '336', 'shipment_sea_air_state', 0, 'default', '', NULL, '1', '2022-09-28 11:50:36', '1', '2022-09-28 11:50:36', b'0', 'WAIT_SETTLEMENT'); INSERT INTO `system_dict_data` VALUES (1989, 37, '货柜结算中', '337', 'shipment_sea_air_state', 0, 'default', '', NULL, '1', '2022-09-28 11:50:50', '1', '2022-09-28 11:50:50', b'0', 'SETTLEMENTING'); INSERT INTO `system_dict_data` VALUES (1990, 38, '货柜已结算', '338', 'shipment_sea_air_state', 0, 'default', '', NULL, '1', '2022-09-28 11:51:04', '1', '2022-09-28 11:51:04', b'0', 'SETTLEMENTED'); INSERT INTO `system_dict_data` VALUES (1991, 30, '二程起飞', '391', 'shipment_sea_air_state', 0, 'default', '', NULL, '115', '2022-10-21 14:47:02', '115', '2022-10-21 14:47:25', b'0', 'TWO_WAY_TAKEOFF'); INSERT INTO `system_dict_data` VALUES (1992, 31, '二程到港', '392', 'shipment_sea_air_state', 0, 'default', '', NULL, '115', '2022-10-21 14:48:10', '115', '2022-10-21 14:48:10', b'0', 'TWO_WAY_ARRIVAL'); INSERT INTO `system_dict_data` VALUES (1993, 4, '预装中', '304', 'order_shipment_state', 0, 'default', '', NULL, '1', '2022-10-26 20:19:56', '1', '2022-10-26 20:19:56', b'0', 'PREINSTALLING'); INSERT INTO `system_dict_data` VALUES (1994, 4, '预装中', '304', 'shipment_sea_air_state', 0, 'default', '', NULL, '1', '2022-10-26 20:20:34', '1', '2022-10-26 20:20:34', b'0', 'PREINSTALLING'); INSERT INTO `system_dict_data` VALUES (1995, 3, 'vvip', '3', 'customer_level', 0, 'default', '', NULL, '1', '2022-10-27 16:20:03', '1', '2022-10-27 16:20:03', b'0', 'vvip'); INSERT INTO `system_dict_data` VALUES (1996, 4, '特殊客户', '4', 'customer_level', 0, 'default', '', NULL, '1', '2022-10-27 16:20:13', '1', '2022-10-27 16:20:13', b'0', 'special customer'); INSERT INTO `system_dict_data` VALUES (1997, 0, '未收款', '0', 'receivable_state', 0, 'default', '', '未收款', '115', '2022-10-29 17:49:23', '115', '2022-10-29 17:49:23', b'0', 'not_receivale'); INSERT INTO `system_dict_data` VALUES (1998, 1, '收款中', '1', 'receivable_state', 0, 'default', '', '收款中', '115', '2022-10-29 17:50:39', '115', '2022-10-29 17:50:39', b'0', 'receivableing'); INSERT INTO `system_dict_data` VALUES (1999, 2, '已收款', '2', 'receivable_state', 0, 'default', '', '已收款', '115', '2022-10-29 17:51:25', '115', '2022-10-29 17:51:25', b'0', 'receivabled'); INSERT INTO `system_dict_data` VALUES (2000, 1, '箱', '1', 'warehousing_specification_type', 0, 'default', '', NULL, '118', '2022-11-04 23:35:13', '118', '2022-11-04 23:35:35', b'0', 'pacakge'); INSERT INTO `system_dict_data` VALUES (2001, 2, '整板', '2', 'warehousing_specification_type', 0, 'default', '', NULL, '118', '2022-11-04 23:35:31', '118', '2022-11-04 23:35:31', b'0', 'board'); INSERT INTO `system_dict_data` VALUES (2002, 0, '长期', '0', 'auth_type', 0, 'default', '', NULL, '1', '2022-11-05 21:27:08', '1', '2022-11-05 21:27:08', b'0', 'long-term'); INSERT INTO `system_dict_data` VALUES (2003, 1, '短期', '1', 'auth_type', 0, 'default', '', NULL, '1', '2022-11-05 21:27:42', '1', '2022-11-05 21:27:42', b'0', 'short_term'); INSERT INTO `system_dict_data` VALUES (2004, 1, '海运', '1', 'customer_transport_type', 0, 'default', '', '海运', '115', '2022-11-13 23:33:45', '115', '2022-11-14 22:01:00', b'1', 'sea'); INSERT INTO `system_dict_data` VALUES (2005, 2, '空运', '2', 'customer_transport_type', 0, 'default', '', '空运', '115', '2022-11-13 23:33:45', '115', '2022-11-14 22:00:58', b'1', 'air'); INSERT INTO `system_dict_data` VALUES (2006, 1, '开发客户', '1', 'customer_resource_type', 0, 'default', '', '', '115', '2022-11-13 23:33:45', '118', '2022-11-13 22:13:03', b'0', 'develop'); INSERT INTO `system_dict_data` VALUES (2007, 2, '公司客户', '2', 'customer_resource_type', 0, 'default', '', '', '115', '2022-11-13 23:33:45', '118', '2022-11-13 22:13:08', b'0', 'company'); INSERT INTO `system_dict_data` VALUES (2008, 1, '海运拼柜', '1', 'customer_transport_type', 0, 'default', '', NULL, '115', '2022-11-13 23:33:45', '115', '2022-11-13 23:33:45', b'0', 'sea joint'); INSERT INTO `system_dict_data` VALUES (2009, 2, '海空联运', '2', 'customer_transport_type', 0, 'default', '', NULL, '115', '2022-11-13 23:33:45', '115', '2022-11-26 23:46:30', b'0', 'sea connect'); INSERT INTO `system_dict_data` VALUES (2010, 3, '海运整柜', '3', 'customer_transport_type', 0, 'default', '', NULL, '115', '2022-11-13 23:33:45', '115', '2022-11-13 23:33:45', b'0', 'sea total'); INSERT INTO `system_dict_data` VALUES (2011, 4, '空运专线', '4', 'customer_transport_type', 0, 'default', '', NULL, '115', '2022-11-13 23:33:45', '115', '2022-11-26 23:46:35', b'0', 'air'); INSERT INTO `system_dict_data` VALUES (2012, 6, '客户延迟进入公海池时间', '31', 'customer_time', 0, 'default', '', '客户延迟进入公海池最大申请时间', '1', '2022-11-15 00:26:49', '1', '2022-11-15 00:27:06', b'0', 'customer_delay_to_sea_pool'); INSERT INTO `system_dict_data` VALUES (2013, 0, '报关-起运', '7', 'inspection_time', 0, 'default', '', NULL, '1', '2022-11-15 09:37:06', '1', '2022-11-15 09:40:09', b'0', 'customs-shipping'); INSERT INTO `system_dict_data` VALUES (2014, 1, '到港', '5', 'inspection_time', 0, 'default', '', NULL, '1', '2022-11-15 09:40:34', '1', '2022-11-15 09:40:34', b'0', 'arrival'); INSERT INTO `system_dict_data` VALUES (2015, 0, '数据值', '7', 'inspection_time_customs', 0, 'default', '', NULL, '1', '2022-11-15 16:39:22', '1', '2022-11-23 16:23:17', b'0', 'value'); INSERT INTO `system_dict_data` VALUES (2016, 0, '数据值', '7', 'inspection_time_shipping', 0, 'default', '', NULL, '1', '2022-11-15 16:41:43', '1', '2022-11-15 16:41:43', b'0', 'value'); INSERT INTO `system_dict_data` VALUES (2017, 0, '数据值', '5', 'inspection_time_arrival', 0, 'default', '', NULL, '1', '2022-11-15 16:42:54', '1', '2022-11-15 16:42:54', b'0', 'value'); INSERT INTO `system_dict_data` VALUES (2018, 0, '更新状态', '1', 'shipping_update_type', 0, 'default', '', NULL, '1', '2022-11-16 22:05:36', '1', '2022-11-16 22:05:36', b'0', 'update status'); INSERT INTO `system_dict_data` VALUES (2019, 1, '不更新状态', '2', 'shipping_update_type', 0, 'default', '', NULL, '1', '2022-11-16 22:05:59', '1', '2022-11-16 22:06:03', b'0', 'not update status'); INSERT INTO `system_dict_data` VALUES (2020, 0, '查验延误', '1', 'customs_error_type', 0, 'default', '', NULL, '1', '2022-11-16 22:13:06', '1', '2022-11-16 22:13:06', b'0', 'Inspection delay'); INSERT INTO `system_dict_data` VALUES (2021, 1, '节假日延误', '2', 'customs_error_type', 0, 'default', '', NULL, '1', '2022-11-16 22:13:22', '1', '2022-11-16 22:13:22', b'0', 'holiday delay'); INSERT INTO `system_dict_data` VALUES (2022, 0, '查验延误', '1', 'shipping_error_type', 0, 'default', '', NULL, '1', '2022-11-16 22:13:51', '1', '2022-11-16 22:13:51', b'0', 'Inspection delay'); INSERT INTO `system_dict_data` VALUES (2023, 1, '甩柜', '2', 'shipping_error_type', 0, 'default', '', NULL, '1', '2022-11-16 22:14:14', '1', '2022-11-16 22:14:14', b'0', 'Dump cabinet'); INSERT INTO `system_dict_data` VALUES (2024, 2, '满载', '3', 'shipping_error_type', 0, 'default', '', NULL, '1', '2022-11-16 22:14:46', '1', '2022-11-16 22:14:46', b'0', 'full of load'); INSERT INTO `system_dict_data` VALUES (2025, 0, '查验延误', '1', 'arrival_error_type', 0, 'default', '', NULL, '1', '2022-11-16 22:16:18', '1', '2022-11-16 22:16:18', b'0', 'Inspection delay'); INSERT INTO `system_dict_data` VALUES (2026, 1, '节假日延误', '2', 'arrival_error_type', 0, 'default', '', NULL, '1', '2022-11-16 22:16:28', '1', '2022-11-16 22:16:28', b'0', 'holiday delay'); INSERT INTO `system_dict_data` VALUES (2027, 2, '自定义', '0', 'customs_error_type', 0, 'default', '', NULL, '1', '2022-11-16 22:35:35', '1', '2022-11-16 22:36:16', b'0', 'customize'); INSERT INTO `system_dict_data` VALUES (2028, 3, '自定义', '0', 'shipping_error_type', 0, 'default', '', NULL, '1', '2022-11-16 22:35:53', '1', '2022-11-16 22:36:03', b'0', 'customize'); INSERT INTO `system_dict_data` VALUES (2029, 2, '自定义', '0', 'arrival_error_type', 0, 'default', '', NULL, '1', '2022-11-16 22:36:36', '1', '2022-11-16 22:36:36', b'0', 'customize'); INSERT INTO `system_dict_data` VALUES (2030, 0, '海运客户', '4', 'customer_type', 0, 'default', '', '', '1', '2022-11-18 00:18:29', '1', '2022-11-21 14:47:14', b'1', '海运客户'); INSERT INTO `system_dict_data` VALUES (2031, 0, '空运客户', '5', 'customer_type', 0, 'default', '', NULL, '1', '2022-11-18 00:18:34', '1', '2022-11-21 14:47:16', b'1', '空运客户'); INSERT INTO `system_dict_data` VALUES (2032, 0, '客户经理', '120', 'sys_user_role_final_customer_service', 0, 'default', '', '客户经理角色ID', '1', '2022-11-18 23:44:09', '1', '2022-11-18 23:47:44', b'0', 'account_manager'); INSERT INTO `system_dict_data` VALUES (2033, 5, '报关异常', '5', 'shipping_notice_type', 0, 'default', '', NULL, '1', '2022-11-20 17:43:14', '1', '2022-11-20 17:43:18', b'0', '报关异常'); INSERT INTO `system_dict_data` VALUES (2034, 6, '起运异常', '6', 'shipping_notice_type', 0, 'default', '', NULL, '1', '2022-11-20 17:43:32', '1', '2022-11-20 17:43:32', b'0', '起运异常'); INSERT INTO `system_dict_data` VALUES (2035, 7, '到港异常', '7', 'shipping_notice_type', 0, 'default', '', NULL, '1', '2022-11-20 17:43:43', '1', '2022-11-20 17:43:43', b'0', '到港异常'); INSERT INTO `system_dict_data` VALUES (2036, 8, 'AGENT设置', '8', 'shipping_notice_type', 0, 'default', '', NULL, '1', '2022-11-20 17:43:59', '1', '2022-11-20 17:43:59', b'0', 'AGENT设置'); INSERT INTO `system_dict_data` VALUES (2037, 4, '商务洽谈', '4', 'customer_follow_type', 0, 'default', '', NULL, '118', '2022-11-24 23:44:19', '118', '2022-11-24 23:44:19', b'0', 'business negotiations'); INSERT INTO `system_dict_data` VALUES (2038, 4, '新建报价', '4', 'customer_follow_method', 0, 'default', '', NULL, '118', '2022-11-24 23:57:23', '118', '2022-11-25 00:01:03', b'1', 'create offer'); INSERT INTO `system_dict_data` VALUES (2039, 5, '修改报价', '5', 'customer_follow_method', 0, 'default', '', NULL, '118', '2022-11-24 23:57:44', '118', '2022-11-25 00:01:06', b'1', 'update offer'); INSERT INTO `system_dict_data` VALUES (2040, 6, '特价申请', '6', 'customer_follow_method', 0, 'default', '', NULL, '118', '2022-11-24 23:58:33', '118', '2022-11-25 00:01:08', b'1', 'speical discount apply'); INSERT INTO `system_dict_data` VALUES (2041, 7, '报价结束', '7', 'customer_follow_method', 0, 'default', '', NULL, '118', '2022-11-24 23:59:39', '118', '2022-11-25 00:01:10', b'1', 'offer finished'); COMMIT; SET FOREIGN_KEY_CHECKS = 1;