From 2996980930ea678d56fde08e5515d3f1b6ab52bd Mon Sep 17 00:00:00 2001
From: 无关风月 <443237572@qq.com>
Date: 星期六, 14 二月 2026 09:26:47 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'
---
sql/xprt_maintenance.sql | 320 ++++++++++++++++++++++++++++++++++++++++-------------
1 files changed, 242 insertions(+), 78 deletions(-)
diff --git a/sql/xprt_maintenance.sql b/sql/xprt_maintenance.sql
index 6a6b38e..a87bfe2 100644
--- a/sql/xprt_maintenance.sql
+++ b/sql/xprt_maintenance.sql
@@ -11,7 +11,7 @@
Target Server Version : 80019 (8.0.19)
File Encoding : 65001
- Date: 12/02/2026 14:23:17
+ Date: 14/02/2026 00:59:51
*/
SET NAMES utf8mb4;
@@ -40,11 +40,12 @@
`update_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '修改人',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_vid`(`vehicle_id` ASC) USING BTREE COMMENT '车辆id索引'
-) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '车辆充电记录' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '车辆充电记录' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_charging_record
-- ----------------------------
+INSERT INTO `xp_charging_record` VALUES (1, 3, 2, 10, '{\"id\": \"349d63fd\", \"url\": null, \"name\": \"k5cJyYGcZ2sB6748b26737af63446e4c291367fbf19a.png\"}', '2026-02-13 17:49:42', 100, '{\"id\": \"349d63fd\", \"url\": null, \"name\": \"k5cJyYGcZ2sB6748b26737af63446e4c291367fbf19a.png\"}', '2026-02-13 19:49:49', 2, 2, 0, '2026-02-13 17:50:12', '2026-02-13 17:50:12', '', '');
-- ----------------------------
-- Table structure for xp_charging_record_0
@@ -69,7 +70,7 @@
`update_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '修改人',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_vid`(`vehicle_id` ASC) USING BTREE COMMENT '车辆id索引'
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '车辆充电记录' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '车辆充电记录' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_charging_record_0
@@ -643,11 +644,12 @@
`create_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建人',
`update_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '修改人',
PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '打卡地址管理' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '打卡地址管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_check_location
-- ----------------------------
+INSERT INTO `xp_check_location` VALUES (1, '天府新谷', 100.00, 11.00, 77.00, 1, 0, '2026-02-13 15:27:03', '2026-02-13 15:27:06', '', '');
-- ----------------------------
-- Table structure for xp_clock_in
@@ -949,18 +951,20 @@
`create_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建人',
`update_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '修改人',
PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '事故任务事故类型（目前作为临时表存储，后续可能会在后台手动配置或存入数据字典）' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '事故任务事故类型（目前作为临时表存储，后续可能会在后台手动配置或存入数据字典）' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_error_type
-- ----------------------------
+INSERT INTO `xp_error_type` VALUES (2, '车辆技术故障类', 0, 0, '2026-02-13 14:09:53', '2026-02-13 14:14:09', '', '');
+INSERT INTO `xp_error_type` VALUES (3, '自动驾驶系统失效', 2, 0, '2026-02-13 14:10:06', '2026-02-13 14:10:06', '', '');
-- ----------------------------
-- Table structure for xp_fleet
-- ----------------------------
DROP TABLE IF EXISTS `xp_fleet`;
CREATE TABLE `xp_fleet` (
- `id` bigint NOT NULL COMMENT '自增id',
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
`fleet_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '车队名称',
`province_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '省份名称',
`province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '省份code',
@@ -980,11 +984,13 @@
`update_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '修改人',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_name`(`fleet_name` ASC) USING BTREE COMMENT '名称'
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '车队管理' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '车队管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_fleet
-- ----------------------------
+INSERT INTO `xp_fleet` VALUES (1, '测试的编辑', '', '', '', '', '', '', '', '', 1, NULL, 1, 1, '2026-02-13 15:39:10', '2026-02-13 17:21:58', '开发', '开发');
+INSERT INTO `xp_fleet` VALUES (2, '44', '', '', '', '', '', '', '', '', 2, NULL, 1, 0, '2026-02-13 16:17:25', '2026-02-13 16:17:25', '开发', '开发');
-- ----------------------------
-- Table structure for xp_fleet_operations
@@ -999,6 +1005,7 @@
-- ----------------------------
-- Records of xp_fleet_operations
-- ----------------------------
+INSERT INTO `xp_fleet_operations` VALUES (2, 1);
-- ----------------------------
-- Table structure for xp_fleet_vehicle
@@ -1013,6 +1020,7 @@
-- ----------------------------
-- Records of xp_fleet_vehicle
-- ----------------------------
+INSERT INTO `xp_fleet_vehicle` VALUES (2, 4);
-- ----------------------------
-- Table structure for xp_policy_application
@@ -1164,11 +1172,16 @@
INDEX `idx_tid`(`task_type_id` ASC) USING BTREE COMMENT '类型id',
INDEX `idx_level`(`task_urgency_level` ASC) USING BTREE COMMENT '级别',
INDEX `idx_status`(`status` ASC) USING BTREE COMMENT '状态'
-) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_task
-- ----------------------------
+INSERT INTO `xp_task` VALUES (2, '1', 1, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:45:35', '', '');
+INSERT INTO `xp_task` VALUES (3, '2', 1, '2', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:48:58', '', '');
+INSERT INTO `xp_task` VALUES (4, '3', 1, '1', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:52:45', '', '');
+INSERT INTO `xp_task` VALUES (5, '4', 1, '5', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:58:11', '', '');
+INSERT INTO `xp_task` VALUES (6, '5', 2, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 18:00:52', '', '');
-- ----------------------------
-- Table structure for xp_task_0
@@ -1178,9 +1191,10 @@
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
`task_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务编号',
`task_category` int NOT NULL DEFAULT 1 COMMENT '任务类别1常规 2事故',
- `task_type_id` bigint NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
+ `task_type_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
`task_urgency_level` int NOT NULL COMMENT '任务紧急程度 0=P0 1=P1 2=P2 3=P3',
`task_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务描述',
+ `task_image` json NOT NULL COMMENT '任务图片',
`vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '车辆位置',
`vehicle_id` bigint NOT NULL COMMENT '车辆id',
`vehicle_lon` decimal(10, 2) NOT NULL COMMENT '车辆经度',
@@ -1191,7 +1205,8 @@
`assignee_time` datetime NULL DEFAULT NULL COMMENT '分配时间',
`report_user_id` bigint NOT NULL COMMENT '上报人id',
`report_time` datetime NOT NULL COMMENT '上报时间',
- `status` int NOT NULL DEFAULT 1 COMMENT '状态 1=待处理 2=已完成 3=已取消',
+ `status` int NOT NULL DEFAULT 1 COMMENT '状态0=待到达 1=待处理 2=已完成 3=已取消',
+ `end_time` datetime NOT NULL COMMENT '任务处理时限',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -1201,11 +1216,16 @@
INDEX `idx_tid`(`task_type_id` ASC) USING BTREE COMMENT '类型id',
INDEX `idx_level`(`task_urgency_level` ASC) USING BTREE COMMENT '级别',
INDEX `idx_status`(`status` ASC) USING BTREE COMMENT '状态'
-) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_task_0
-- ----------------------------
+INSERT INTO `xp_task_0` VALUES (2, '1', 1, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:45:35', '', '');
+INSERT INTO `xp_task_0` VALUES (3, '2', 1, '2', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:48:58', '', '');
+INSERT INTO `xp_task_0` VALUES (4, '3', 1, '1', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:52:45', '', '');
+INSERT INTO `xp_task_0` VALUES (5, '4', 1, '5', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:58:11', '', '');
+INSERT INTO `xp_task_0` VALUES (6, '5', 2, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 18:00:52', '', '');
-- ----------------------------
-- Table structure for xp_task_1
@@ -1215,9 +1235,10 @@
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
`task_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务编号',
`task_category` int NOT NULL DEFAULT 1 COMMENT '任务类别1常规 2事故',
- `task_type_id` bigint NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
+ `task_type_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
`task_urgency_level` int NOT NULL COMMENT '任务紧急程度 0=P0 1=P1 2=P2 3=P3',
`task_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务描述',
+ `task_image` json NOT NULL COMMENT '任务图片',
`vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '车辆位置',
`vehicle_id` bigint NOT NULL COMMENT '车辆id',
`vehicle_lon` decimal(10, 2) NOT NULL COMMENT '车辆经度',
@@ -1228,7 +1249,8 @@
`assignee_time` datetime NULL DEFAULT NULL COMMENT '分配时间',
`report_user_id` bigint NOT NULL COMMENT '上报人id',
`report_time` datetime NOT NULL COMMENT '上报时间',
- `status` int NOT NULL DEFAULT 1 COMMENT '状态 1=待处理 2=已完成 3=已取消',
+ `status` int NOT NULL DEFAULT 1 COMMENT '状态0=待到达 1=待处理 2=已完成 3=已取消',
+ `end_time` datetime NOT NULL COMMENT '任务处理时限',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -1238,11 +1260,16 @@
INDEX `idx_tid`(`task_type_id` ASC) USING BTREE COMMENT '类型id',
INDEX `idx_level`(`task_urgency_level` ASC) USING BTREE COMMENT '级别',
INDEX `idx_status`(`status` ASC) USING BTREE COMMENT '状态'
-) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_task_1
-- ----------------------------
+INSERT INTO `xp_task_1` VALUES (2, '1', 1, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:45:35', '', '');
+INSERT INTO `xp_task_1` VALUES (3, '2', 1, '2', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:48:58', '', '');
+INSERT INTO `xp_task_1` VALUES (4, '3', 1, '1', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:52:45', '', '');
+INSERT INTO `xp_task_1` VALUES (5, '4', 1, '5', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:58:11', '', '');
+INSERT INTO `xp_task_1` VALUES (6, '5', 2, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 18:00:52', '', '');
-- ----------------------------
-- Table structure for xp_task_10
@@ -1252,9 +1279,10 @@
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
`task_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务编号',
`task_category` int NOT NULL DEFAULT 1 COMMENT '任务类别1常规 2事故',
- `task_type_id` bigint NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
+ `task_type_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
`task_urgency_level` int NOT NULL COMMENT '任务紧急程度 0=P0 1=P1 2=P2 3=P3',
`task_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务描述',
+ `task_image` json NOT NULL COMMENT '任务图片',
`vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '车辆位置',
`vehicle_id` bigint NOT NULL COMMENT '车辆id',
`vehicle_lon` decimal(10, 2) NOT NULL COMMENT '车辆经度',
@@ -1265,7 +1293,8 @@
`assignee_time` datetime NULL DEFAULT NULL COMMENT '分配时间',
`report_user_id` bigint NOT NULL COMMENT '上报人id',
`report_time` datetime NOT NULL COMMENT '上报时间',
- `status` int NOT NULL DEFAULT 1 COMMENT '状态 1=待处理 2=已完成 3=已取消',
+ `status` int NOT NULL DEFAULT 1 COMMENT '状态0=待到达 1=待处理 2=已完成 3=已取消',
+ `end_time` datetime NOT NULL COMMENT '任务处理时限',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -1275,11 +1304,16 @@
INDEX `idx_tid`(`task_type_id` ASC) USING BTREE COMMENT '类型id',
INDEX `idx_level`(`task_urgency_level` ASC) USING BTREE COMMENT '级别',
INDEX `idx_status`(`status` ASC) USING BTREE COMMENT '状态'
-) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_task_10
-- ----------------------------
+INSERT INTO `xp_task_10` VALUES (2, '1', 1, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:45:35', '', '');
+INSERT INTO `xp_task_10` VALUES (3, '2', 1, '2', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:48:58', '', '');
+INSERT INTO `xp_task_10` VALUES (4, '3', 1, '1', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:52:45', '', '');
+INSERT INTO `xp_task_10` VALUES (5, '4', 1, '5', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:58:11', '', '');
+INSERT INTO `xp_task_10` VALUES (6, '5', 2, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 18:00:52', '', '');
-- ----------------------------
-- Table structure for xp_task_11
@@ -1289,9 +1323,10 @@
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
`task_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务编号',
`task_category` int NOT NULL DEFAULT 1 COMMENT '任务类别1常规 2事故',
- `task_type_id` bigint NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
+ `task_type_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
`task_urgency_level` int NOT NULL COMMENT '任务紧急程度 0=P0 1=P1 2=P2 3=P3',
`task_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务描述',
+ `task_image` json NOT NULL COMMENT '任务图片',
`vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '车辆位置',
`vehicle_id` bigint NOT NULL COMMENT '车辆id',
`vehicle_lon` decimal(10, 2) NOT NULL COMMENT '车辆经度',
@@ -1302,7 +1337,8 @@
`assignee_time` datetime NULL DEFAULT NULL COMMENT '分配时间',
`report_user_id` bigint NOT NULL COMMENT '上报人id',
`report_time` datetime NOT NULL COMMENT '上报时间',
- `status` int NOT NULL DEFAULT 1 COMMENT '状态 1=待处理 2=已完成 3=已取消',
+ `status` int NOT NULL DEFAULT 1 COMMENT '状态0=待到达 1=待处理 2=已完成 3=已取消',
+ `end_time` datetime NOT NULL COMMENT '任务处理时限',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -1312,11 +1348,16 @@
INDEX `idx_tid`(`task_type_id` ASC) USING BTREE COMMENT '类型id',
INDEX `idx_level`(`task_urgency_level` ASC) USING BTREE COMMENT '级别',
INDEX `idx_status`(`status` ASC) USING BTREE COMMENT '状态'
-) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_task_11
-- ----------------------------
+INSERT INTO `xp_task_11` VALUES (2, '1', 1, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:45:35', '', '');
+INSERT INTO `xp_task_11` VALUES (3, '2', 1, '2', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:48:58', '', '');
+INSERT INTO `xp_task_11` VALUES (4, '3', 1, '1', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:52:45', '', '');
+INSERT INTO `xp_task_11` VALUES (5, '4', 1, '5', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:58:11', '', '');
+INSERT INTO `xp_task_11` VALUES (6, '5', 2, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 18:00:52', '', '');
-- ----------------------------
-- Table structure for xp_task_12
@@ -1326,9 +1367,10 @@
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
`task_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务编号',
`task_category` int NOT NULL DEFAULT 1 COMMENT '任务类别1常规 2事故',
- `task_type_id` bigint NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
+ `task_type_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
`task_urgency_level` int NOT NULL COMMENT '任务紧急程度 0=P0 1=P1 2=P2 3=P3',
`task_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务描述',
+ `task_image` json NOT NULL COMMENT '任务图片',
`vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '车辆位置',
`vehicle_id` bigint NOT NULL COMMENT '车辆id',
`vehicle_lon` decimal(10, 2) NOT NULL COMMENT '车辆经度',
@@ -1339,7 +1381,8 @@
`assignee_time` datetime NULL DEFAULT NULL COMMENT '分配时间',
`report_user_id` bigint NOT NULL COMMENT '上报人id',
`report_time` datetime NOT NULL COMMENT '上报时间',
- `status` int NOT NULL DEFAULT 1 COMMENT '状态 1=待处理 2=已完成 3=已取消',
+ `status` int NOT NULL DEFAULT 1 COMMENT '状态0=待到达 1=待处理 2=已完成 3=已取消',
+ `end_time` datetime NOT NULL COMMENT '任务处理时限',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -1349,11 +1392,16 @@
INDEX `idx_tid`(`task_type_id` ASC) USING BTREE COMMENT '类型id',
INDEX `idx_level`(`task_urgency_level` ASC) USING BTREE COMMENT '级别',
INDEX `idx_status`(`status` ASC) USING BTREE COMMENT '状态'
-) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_task_12
-- ----------------------------
+INSERT INTO `xp_task_12` VALUES (2, '1', 1, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:45:35', '', '');
+INSERT INTO `xp_task_12` VALUES (3, '2', 1, '2', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:48:58', '', '');
+INSERT INTO `xp_task_12` VALUES (4, '3', 1, '1', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:52:45', '', '');
+INSERT INTO `xp_task_12` VALUES (5, '4', 1, '5', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:58:11', '', '');
+INSERT INTO `xp_task_12` VALUES (6, '5', 2, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 18:00:52', '', '');
-- ----------------------------
-- Table structure for xp_task_13
@@ -1363,9 +1411,10 @@
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
`task_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务编号',
`task_category` int NOT NULL DEFAULT 1 COMMENT '任务类别1常规 2事故',
- `task_type_id` bigint NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
+ `task_type_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
`task_urgency_level` int NOT NULL COMMENT '任务紧急程度 0=P0 1=P1 2=P2 3=P3',
`task_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务描述',
+ `task_image` json NOT NULL COMMENT '任务图片',
`vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '车辆位置',
`vehicle_id` bigint NOT NULL COMMENT '车辆id',
`vehicle_lon` decimal(10, 2) NOT NULL COMMENT '车辆经度',
@@ -1376,7 +1425,8 @@
`assignee_time` datetime NULL DEFAULT NULL COMMENT '分配时间',
`report_user_id` bigint NOT NULL COMMENT '上报人id',
`report_time` datetime NOT NULL COMMENT '上报时间',
- `status` int NOT NULL DEFAULT 1 COMMENT '状态 1=待处理 2=已完成 3=已取消',
+ `status` int NOT NULL DEFAULT 1 COMMENT '状态0=待到达 1=待处理 2=已完成 3=已取消',
+ `end_time` datetime NOT NULL COMMENT '任务处理时限',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -1386,11 +1436,16 @@
INDEX `idx_tid`(`task_type_id` ASC) USING BTREE COMMENT '类型id',
INDEX `idx_level`(`task_urgency_level` ASC) USING BTREE COMMENT '级别',
INDEX `idx_status`(`status` ASC) USING BTREE COMMENT '状态'
-) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_task_13
-- ----------------------------
+INSERT INTO `xp_task_13` VALUES (2, '1', 1, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:45:35', '', '');
+INSERT INTO `xp_task_13` VALUES (3, '2', 1, '2', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:48:58', '', '');
+INSERT INTO `xp_task_13` VALUES (4, '3', 1, '1', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:52:45', '', '');
+INSERT INTO `xp_task_13` VALUES (5, '4', 1, '5', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:58:11', '', '');
+INSERT INTO `xp_task_13` VALUES (6, '5', 2, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 18:00:52', '', '');
-- ----------------------------
-- Table structure for xp_task_14
@@ -1400,9 +1455,10 @@
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
`task_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务编号',
`task_category` int NOT NULL DEFAULT 1 COMMENT '任务类别1常规 2事故',
- `task_type_id` bigint NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
+ `task_type_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
`task_urgency_level` int NOT NULL COMMENT '任务紧急程度 0=P0 1=P1 2=P2 3=P3',
`task_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务描述',
+ `task_image` json NOT NULL COMMENT '任务图片',
`vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '车辆位置',
`vehicle_id` bigint NOT NULL COMMENT '车辆id',
`vehicle_lon` decimal(10, 2) NOT NULL COMMENT '车辆经度',
@@ -1413,7 +1469,8 @@
`assignee_time` datetime NULL DEFAULT NULL COMMENT '分配时间',
`report_user_id` bigint NOT NULL COMMENT '上报人id',
`report_time` datetime NOT NULL COMMENT '上报时间',
- `status` int NOT NULL DEFAULT 1 COMMENT '状态 1=待处理 2=已完成 3=已取消',
+ `status` int NOT NULL DEFAULT 1 COMMENT '状态0=待到达 1=待处理 2=已完成 3=已取消',
+ `end_time` datetime NOT NULL COMMENT '任务处理时限',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -1423,11 +1480,16 @@
INDEX `idx_tid`(`task_type_id` ASC) USING BTREE COMMENT '类型id',
INDEX `idx_level`(`task_urgency_level` ASC) USING BTREE COMMENT '级别',
INDEX `idx_status`(`status` ASC) USING BTREE COMMENT '状态'
-) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_task_14
-- ----------------------------
+INSERT INTO `xp_task_14` VALUES (2, '1', 1, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:45:35', '', '');
+INSERT INTO `xp_task_14` VALUES (3, '2', 1, '2', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:48:58', '', '');
+INSERT INTO `xp_task_14` VALUES (4, '3', 1, '1', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:52:45', '', '');
+INSERT INTO `xp_task_14` VALUES (5, '4', 1, '5', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:58:11', '', '');
+INSERT INTO `xp_task_14` VALUES (6, '5', 2, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 18:00:52', '', '');
-- ----------------------------
-- Table structure for xp_task_15
@@ -1437,9 +1499,10 @@
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
`task_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务编号',
`task_category` int NOT NULL DEFAULT 1 COMMENT '任务类别1常规 2事故',
- `task_type_id` bigint NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
+ `task_type_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
`task_urgency_level` int NOT NULL COMMENT '任务紧急程度 0=P0 1=P1 2=P2 3=P3',
`task_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务描述',
+ `task_image` json NOT NULL COMMENT '任务图片',
`vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '车辆位置',
`vehicle_id` bigint NOT NULL COMMENT '车辆id',
`vehicle_lon` decimal(10, 2) NOT NULL COMMENT '车辆经度',
@@ -1450,7 +1513,8 @@
`assignee_time` datetime NULL DEFAULT NULL COMMENT '分配时间',
`report_user_id` bigint NOT NULL COMMENT '上报人id',
`report_time` datetime NOT NULL COMMENT '上报时间',
- `status` int NOT NULL DEFAULT 1 COMMENT '状态 1=待处理 2=已完成 3=已取消',
+ `status` int NOT NULL DEFAULT 1 COMMENT '状态0=待到达 1=待处理 2=已完成 3=已取消',
+ `end_time` datetime NOT NULL COMMENT '任务处理时限',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -1460,11 +1524,16 @@
INDEX `idx_tid`(`task_type_id` ASC) USING BTREE COMMENT '类型id',
INDEX `idx_level`(`task_urgency_level` ASC) USING BTREE COMMENT '级别',
INDEX `idx_status`(`status` ASC) USING BTREE COMMENT '状态'
-) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_task_15
-- ----------------------------
+INSERT INTO `xp_task_15` VALUES (2, '1', 1, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:45:35', '', '');
+INSERT INTO `xp_task_15` VALUES (3, '2', 1, '2', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:48:58', '', '');
+INSERT INTO `xp_task_15` VALUES (4, '3', 1, '1', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:52:45', '', '');
+INSERT INTO `xp_task_15` VALUES (5, '4', 1, '5', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:58:11', '', '');
+INSERT INTO `xp_task_15` VALUES (6, '5', 2, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 18:00:52', '', '');
-- ----------------------------
-- Table structure for xp_task_16
@@ -1474,9 +1543,10 @@
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
`task_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务编号',
`task_category` int NOT NULL DEFAULT 1 COMMENT '任务类别1常规 2事故',
- `task_type_id` bigint NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
+ `task_type_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
`task_urgency_level` int NOT NULL COMMENT '任务紧急程度 0=P0 1=P1 2=P2 3=P3',
`task_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务描述',
+ `task_image` json NOT NULL COMMENT '任务图片',
`vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '车辆位置',
`vehicle_id` bigint NOT NULL COMMENT '车辆id',
`vehicle_lon` decimal(10, 2) NOT NULL COMMENT '车辆经度',
@@ -1487,7 +1557,8 @@
`assignee_time` datetime NULL DEFAULT NULL COMMENT '分配时间',
`report_user_id` bigint NOT NULL COMMENT '上报人id',
`report_time` datetime NOT NULL COMMENT '上报时间',
- `status` int NOT NULL DEFAULT 1 COMMENT '状态 1=待处理 2=已完成 3=已取消',
+ `status` int NOT NULL DEFAULT 1 COMMENT '状态0=待到达 1=待处理 2=已完成 3=已取消',
+ `end_time` datetime NOT NULL COMMENT '任务处理时限',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -1497,11 +1568,16 @@
INDEX `idx_tid`(`task_type_id` ASC) USING BTREE COMMENT '类型id',
INDEX `idx_level`(`task_urgency_level` ASC) USING BTREE COMMENT '级别',
INDEX `idx_status`(`status` ASC) USING BTREE COMMENT '状态'
-) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_task_16
-- ----------------------------
+INSERT INTO `xp_task_16` VALUES (2, '1', 1, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:45:35', '', '');
+INSERT INTO `xp_task_16` VALUES (3, '2', 1, '2', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:48:58', '', '');
+INSERT INTO `xp_task_16` VALUES (4, '3', 1, '1', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:52:45', '', '');
+INSERT INTO `xp_task_16` VALUES (5, '4', 1, '5', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:58:11', '', '');
+INSERT INTO `xp_task_16` VALUES (6, '5', 2, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 18:00:52', '', '');
-- ----------------------------
-- Table structure for xp_task_17
@@ -1511,9 +1587,10 @@
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
`task_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务编号',
`task_category` int NOT NULL DEFAULT 1 COMMENT '任务类别1常规 2事故',
- `task_type_id` bigint NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
+ `task_type_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
`task_urgency_level` int NOT NULL COMMENT '任务紧急程度 0=P0 1=P1 2=P2 3=P3',
`task_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务描述',
+ `task_image` json NOT NULL COMMENT '任务图片',
`vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '车辆位置',
`vehicle_id` bigint NOT NULL COMMENT '车辆id',
`vehicle_lon` decimal(10, 2) NOT NULL COMMENT '车辆经度',
@@ -1524,7 +1601,8 @@
`assignee_time` datetime NULL DEFAULT NULL COMMENT '分配时间',
`report_user_id` bigint NOT NULL COMMENT '上报人id',
`report_time` datetime NOT NULL COMMENT '上报时间',
- `status` int NOT NULL DEFAULT 1 COMMENT '状态 1=待处理 2=已完成 3=已取消',
+ `status` int NOT NULL DEFAULT 1 COMMENT '状态0=待到达 1=待处理 2=已完成 3=已取消',
+ `end_time` datetime NOT NULL COMMENT '任务处理时限',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -1534,11 +1612,16 @@
INDEX `idx_tid`(`task_type_id` ASC) USING BTREE COMMENT '类型id',
INDEX `idx_level`(`task_urgency_level` ASC) USING BTREE COMMENT '级别',
INDEX `idx_status`(`status` ASC) USING BTREE COMMENT '状态'
-) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_task_17
-- ----------------------------
+INSERT INTO `xp_task_17` VALUES (2, '1', 1, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:45:35', '', '');
+INSERT INTO `xp_task_17` VALUES (3, '2', 1, '2', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:48:58', '', '');
+INSERT INTO `xp_task_17` VALUES (4, '3', 1, '1', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:52:45', '', '');
+INSERT INTO `xp_task_17` VALUES (5, '4', 1, '5', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:58:11', '', '');
+INSERT INTO `xp_task_17` VALUES (6, '5', 2, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 18:00:52', '', '');
-- ----------------------------
-- Table structure for xp_task_18
@@ -1548,9 +1631,10 @@
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
`task_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务编号',
`task_category` int NOT NULL DEFAULT 1 COMMENT '任务类别1常规 2事故',
- `task_type_id` bigint NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
+ `task_type_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
`task_urgency_level` int NOT NULL COMMENT '任务紧急程度 0=P0 1=P1 2=P2 3=P3',
`task_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务描述',
+ `task_image` json NOT NULL COMMENT '任务图片',
`vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '车辆位置',
`vehicle_id` bigint NOT NULL COMMENT '车辆id',
`vehicle_lon` decimal(10, 2) NOT NULL COMMENT '车辆经度',
@@ -1561,7 +1645,8 @@
`assignee_time` datetime NULL DEFAULT NULL COMMENT '分配时间',
`report_user_id` bigint NOT NULL COMMENT '上报人id',
`report_time` datetime NOT NULL COMMENT '上报时间',
- `status` int NOT NULL DEFAULT 1 COMMENT '状态 1=待处理 2=已完成 3=已取消',
+ `status` int NOT NULL DEFAULT 1 COMMENT '状态0=待到达 1=待处理 2=已完成 3=已取消',
+ `end_time` datetime NOT NULL COMMENT '任务处理时限',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -1571,11 +1656,16 @@
INDEX `idx_tid`(`task_type_id` ASC) USING BTREE COMMENT '类型id',
INDEX `idx_level`(`task_urgency_level` ASC) USING BTREE COMMENT '级别',
INDEX `idx_status`(`status` ASC) USING BTREE COMMENT '状态'
-) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_task_18
-- ----------------------------
+INSERT INTO `xp_task_18` VALUES (2, '1', 1, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:45:35', '', '');
+INSERT INTO `xp_task_18` VALUES (3, '2', 1, '2', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:48:58', '', '');
+INSERT INTO `xp_task_18` VALUES (4, '3', 1, '1', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:52:45', '', '');
+INSERT INTO `xp_task_18` VALUES (5, '4', 1, '5', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:58:11', '', '');
+INSERT INTO `xp_task_18` VALUES (6, '5', 2, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 18:00:52', '', '');
-- ----------------------------
-- Table structure for xp_task_19
@@ -1585,9 +1675,10 @@
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
`task_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务编号',
`task_category` int NOT NULL DEFAULT 1 COMMENT '任务类别1常规 2事故',
- `task_type_id` bigint NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
+ `task_type_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
`task_urgency_level` int NOT NULL COMMENT '任务紧急程度 0=P0 1=P1 2=P2 3=P3',
`task_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务描述',
+ `task_image` json NOT NULL COMMENT '任务图片',
`vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '车辆位置',
`vehicle_id` bigint NOT NULL COMMENT '车辆id',
`vehicle_lon` decimal(10, 2) NOT NULL COMMENT '车辆经度',
@@ -1598,7 +1689,8 @@
`assignee_time` datetime NULL DEFAULT NULL COMMENT '分配时间',
`report_user_id` bigint NOT NULL COMMENT '上报人id',
`report_time` datetime NOT NULL COMMENT '上报时间',
- `status` int NOT NULL DEFAULT 1 COMMENT '状态 1=待处理 2=已完成 3=已取消',
+ `status` int NOT NULL DEFAULT 1 COMMENT '状态0=待到达 1=待处理 2=已完成 3=已取消',
+ `end_time` datetime NOT NULL COMMENT '任务处理时限',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -1608,11 +1700,16 @@
INDEX `idx_tid`(`task_type_id` ASC) USING BTREE COMMENT '类型id',
INDEX `idx_level`(`task_urgency_level` ASC) USING BTREE COMMENT '级别',
INDEX `idx_status`(`status` ASC) USING BTREE COMMENT '状态'
-) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_task_19
-- ----------------------------
+INSERT INTO `xp_task_19` VALUES (2, '1', 1, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:45:35', '', '');
+INSERT INTO `xp_task_19` VALUES (3, '2', 1, '2', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:48:58', '', '');
+INSERT INTO `xp_task_19` VALUES (4, '3', 1, '1', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:52:45', '', '');
+INSERT INTO `xp_task_19` VALUES (5, '4', 1, '5', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:58:11', '', '');
+INSERT INTO `xp_task_19` VALUES (6, '5', 2, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 18:00:52', '', '');
-- ----------------------------
-- Table structure for xp_task_2
@@ -1622,9 +1719,10 @@
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
`task_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务编号',
`task_category` int NOT NULL DEFAULT 1 COMMENT '任务类别1常规 2事故',
- `task_type_id` bigint NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
+ `task_type_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
`task_urgency_level` int NOT NULL COMMENT '任务紧急程度 0=P0 1=P1 2=P2 3=P3',
`task_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务描述',
+ `task_image` json NOT NULL COMMENT '任务图片',
`vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '车辆位置',
`vehicle_id` bigint NOT NULL COMMENT '车辆id',
`vehicle_lon` decimal(10, 2) NOT NULL COMMENT '车辆经度',
@@ -1635,7 +1733,8 @@
`assignee_time` datetime NULL DEFAULT NULL COMMENT '分配时间',
`report_user_id` bigint NOT NULL COMMENT '上报人id',
`report_time` datetime NOT NULL COMMENT '上报时间',
- `status` int NOT NULL DEFAULT 1 COMMENT '状态 1=待处理 2=已完成 3=已取消',
+ `status` int NOT NULL DEFAULT 1 COMMENT '状态0=待到达 1=待处理 2=已完成 3=已取消',
+ `end_time` datetime NOT NULL COMMENT '任务处理时限',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -1645,11 +1744,16 @@
INDEX `idx_tid`(`task_type_id` ASC) USING BTREE COMMENT '类型id',
INDEX `idx_level`(`task_urgency_level` ASC) USING BTREE COMMENT '级别',
INDEX `idx_status`(`status` ASC) USING BTREE COMMENT '状态'
-) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_task_2
-- ----------------------------
+INSERT INTO `xp_task_2` VALUES (2, '1', 1, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:45:35', '', '');
+INSERT INTO `xp_task_2` VALUES (3, '2', 1, '2', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:48:58', '', '');
+INSERT INTO `xp_task_2` VALUES (4, '3', 1, '1', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:52:45', '', '');
+INSERT INTO `xp_task_2` VALUES (5, '4', 1, '5', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:58:11', '', '');
+INSERT INTO `xp_task_2` VALUES (6, '5', 2, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 18:00:52', '', '');
-- ----------------------------
-- Table structure for xp_task_3
@@ -1659,9 +1763,10 @@
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
`task_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务编号',
`task_category` int NOT NULL DEFAULT 1 COMMENT '任务类别1常规 2事故',
- `task_type_id` bigint NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
+ `task_type_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
`task_urgency_level` int NOT NULL COMMENT '任务紧急程度 0=P0 1=P1 2=P2 3=P3',
`task_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务描述',
+ `task_image` json NOT NULL COMMENT '任务图片',
`vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '车辆位置',
`vehicle_id` bigint NOT NULL COMMENT '车辆id',
`vehicle_lon` decimal(10, 2) NOT NULL COMMENT '车辆经度',
@@ -1672,7 +1777,8 @@
`assignee_time` datetime NULL DEFAULT NULL COMMENT '分配时间',
`report_user_id` bigint NOT NULL COMMENT '上报人id',
`report_time` datetime NOT NULL COMMENT '上报时间',
- `status` int NOT NULL DEFAULT 1 COMMENT '状态 1=待处理 2=已完成 3=已取消',
+ `status` int NOT NULL DEFAULT 1 COMMENT '状态0=待到达 1=待处理 2=已完成 3=已取消',
+ `end_time` datetime NOT NULL COMMENT '任务处理时限',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -1682,11 +1788,16 @@
INDEX `idx_tid`(`task_type_id` ASC) USING BTREE COMMENT '类型id',
INDEX `idx_level`(`task_urgency_level` ASC) USING BTREE COMMENT '级别',
INDEX `idx_status`(`status` ASC) USING BTREE COMMENT '状态'
-) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_task_3
-- ----------------------------
+INSERT INTO `xp_task_3` VALUES (2, '1', 1, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:45:35', '', '');
+INSERT INTO `xp_task_3` VALUES (3, '2', 1, '2', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:48:58', '', '');
+INSERT INTO `xp_task_3` VALUES (4, '3', 1, '1', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:52:45', '', '');
+INSERT INTO `xp_task_3` VALUES (5, '4', 1, '5', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:58:11', '', '');
+INSERT INTO `xp_task_3` VALUES (6, '5', 2, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 18:00:52', '', '');
-- ----------------------------
-- Table structure for xp_task_4
@@ -1696,9 +1807,10 @@
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
`task_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务编号',
`task_category` int NOT NULL DEFAULT 1 COMMENT '任务类别1常规 2事故',
- `task_type_id` bigint NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
+ `task_type_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
`task_urgency_level` int NOT NULL COMMENT '任务紧急程度 0=P0 1=P1 2=P2 3=P3',
`task_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务描述',
+ `task_image` json NOT NULL COMMENT '任务图片',
`vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '车辆位置',
`vehicle_id` bigint NOT NULL COMMENT '车辆id',
`vehicle_lon` decimal(10, 2) NOT NULL COMMENT '车辆经度',
@@ -1709,7 +1821,8 @@
`assignee_time` datetime NULL DEFAULT NULL COMMENT '分配时间',
`report_user_id` bigint NOT NULL COMMENT '上报人id',
`report_time` datetime NOT NULL COMMENT '上报时间',
- `status` int NOT NULL DEFAULT 1 COMMENT '状态 1=待处理 2=已完成 3=已取消',
+ `status` int NOT NULL DEFAULT 1 COMMENT '状态0=待到达 1=待处理 2=已完成 3=已取消',
+ `end_time` datetime NOT NULL COMMENT '任务处理时限',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -1719,11 +1832,16 @@
INDEX `idx_tid`(`task_type_id` ASC) USING BTREE COMMENT '类型id',
INDEX `idx_level`(`task_urgency_level` ASC) USING BTREE COMMENT '级别',
INDEX `idx_status`(`status` ASC) USING BTREE COMMENT '状态'
-) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_task_4
-- ----------------------------
+INSERT INTO `xp_task_4` VALUES (2, '1', 1, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:45:35', '', '');
+INSERT INTO `xp_task_4` VALUES (3, '2', 1, '2', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:48:58', '', '');
+INSERT INTO `xp_task_4` VALUES (4, '3', 1, '1', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:52:45', '', '');
+INSERT INTO `xp_task_4` VALUES (5, '4', 1, '5', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:58:11', '', '');
+INSERT INTO `xp_task_4` VALUES (6, '5', 2, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 18:00:52', '', '');
-- ----------------------------
-- Table structure for xp_task_5
@@ -1733,9 +1851,10 @@
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
`task_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务编号',
`task_category` int NOT NULL DEFAULT 1 COMMENT '任务类别1常规 2事故',
- `task_type_id` bigint NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
+ `task_type_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
`task_urgency_level` int NOT NULL COMMENT '任务紧急程度 0=P0 1=P1 2=P2 3=P3',
`task_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务描述',
+ `task_image` json NOT NULL COMMENT '任务图片',
`vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '车辆位置',
`vehicle_id` bigint NOT NULL COMMENT '车辆id',
`vehicle_lon` decimal(10, 2) NOT NULL COMMENT '车辆经度',
@@ -1746,7 +1865,8 @@
`assignee_time` datetime NULL DEFAULT NULL COMMENT '分配时间',
`report_user_id` bigint NOT NULL COMMENT '上报人id',
`report_time` datetime NOT NULL COMMENT '上报时间',
- `status` int NOT NULL DEFAULT 1 COMMENT '状态 1=待处理 2=已完成 3=已取消',
+ `status` int NOT NULL DEFAULT 1 COMMENT '状态0=待到达 1=待处理 2=已完成 3=已取消',
+ `end_time` datetime NOT NULL COMMENT '任务处理时限',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -1756,11 +1876,16 @@
INDEX `idx_tid`(`task_type_id` ASC) USING BTREE COMMENT '类型id',
INDEX `idx_level`(`task_urgency_level` ASC) USING BTREE COMMENT '级别',
INDEX `idx_status`(`status` ASC) USING BTREE COMMENT '状态'
-) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_task_5
-- ----------------------------
+INSERT INTO `xp_task_5` VALUES (2, '1', 1, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:45:35', '', '');
+INSERT INTO `xp_task_5` VALUES (3, '2', 1, '2', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:48:58', '', '');
+INSERT INTO `xp_task_5` VALUES (4, '3', 1, '1', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:52:45', '', '');
+INSERT INTO `xp_task_5` VALUES (5, '4', 1, '5', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:58:11', '', '');
+INSERT INTO `xp_task_5` VALUES (6, '5', 2, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 18:00:52', '', '');
-- ----------------------------
-- Table structure for xp_task_6
@@ -1770,9 +1895,10 @@
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
`task_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务编号',
`task_category` int NOT NULL DEFAULT 1 COMMENT '任务类别1常规 2事故',
- `task_type_id` bigint NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
+ `task_type_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
`task_urgency_level` int NOT NULL COMMENT '任务紧急程度 0=P0 1=P1 2=P2 3=P3',
`task_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务描述',
+ `task_image` json NOT NULL COMMENT '任务图片',
`vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '车辆位置',
`vehicle_id` bigint NOT NULL COMMENT '车辆id',
`vehicle_lon` decimal(10, 2) NOT NULL COMMENT '车辆经度',
@@ -1783,7 +1909,8 @@
`assignee_time` datetime NULL DEFAULT NULL COMMENT '分配时间',
`report_user_id` bigint NOT NULL COMMENT '上报人id',
`report_time` datetime NOT NULL COMMENT '上报时间',
- `status` int NOT NULL DEFAULT 1 COMMENT '状态 1=待处理 2=已完成 3=已取消',
+ `status` int NOT NULL DEFAULT 1 COMMENT '状态0=待到达 1=待处理 2=已完成 3=已取消',
+ `end_time` datetime NOT NULL COMMENT '任务处理时限',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -1793,11 +1920,16 @@
INDEX `idx_tid`(`task_type_id` ASC) USING BTREE COMMENT '类型id',
INDEX `idx_level`(`task_urgency_level` ASC) USING BTREE COMMENT '级别',
INDEX `idx_status`(`status` ASC) USING BTREE COMMENT '状态'
-) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_task_6
-- ----------------------------
+INSERT INTO `xp_task_6` VALUES (2, '1', 1, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:45:35', '', '');
+INSERT INTO `xp_task_6` VALUES (3, '2', 1, '2', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:48:58', '', '');
+INSERT INTO `xp_task_6` VALUES (4, '3', 1, '1', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:52:45', '', '');
+INSERT INTO `xp_task_6` VALUES (5, '4', 1, '5', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:58:11', '', '');
+INSERT INTO `xp_task_6` VALUES (6, '5', 2, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 18:00:52', '', '');
-- ----------------------------
-- Table structure for xp_task_7
@@ -1807,9 +1939,10 @@
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
`task_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务编号',
`task_category` int NOT NULL DEFAULT 1 COMMENT '任务类别1常规 2事故',
- `task_type_id` bigint NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
+ `task_type_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
`task_urgency_level` int NOT NULL COMMENT '任务紧急程度 0=P0 1=P1 2=P2 3=P3',
`task_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务描述',
+ `task_image` json NOT NULL COMMENT '任务图片',
`vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '车辆位置',
`vehicle_id` bigint NOT NULL COMMENT '车辆id',
`vehicle_lon` decimal(10, 2) NOT NULL COMMENT '车辆经度',
@@ -1820,7 +1953,8 @@
`assignee_time` datetime NULL DEFAULT NULL COMMENT '分配时间',
`report_user_id` bigint NOT NULL COMMENT '上报人id',
`report_time` datetime NOT NULL COMMENT '上报时间',
- `status` int NOT NULL DEFAULT 1 COMMENT '状态 1=待处理 2=已完成 3=已取消',
+ `status` int NOT NULL DEFAULT 1 COMMENT '状态0=待到达 1=待处理 2=已完成 3=已取消',
+ `end_time` datetime NOT NULL COMMENT '任务处理时限',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -1830,11 +1964,16 @@
INDEX `idx_tid`(`task_type_id` ASC) USING BTREE COMMENT '类型id',
INDEX `idx_level`(`task_urgency_level` ASC) USING BTREE COMMENT '级别',
INDEX `idx_status`(`status` ASC) USING BTREE COMMENT '状态'
-) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_task_7
-- ----------------------------
+INSERT INTO `xp_task_7` VALUES (2, '1', 1, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:45:35', '', '');
+INSERT INTO `xp_task_7` VALUES (3, '2', 1, '2', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:48:58', '', '');
+INSERT INTO `xp_task_7` VALUES (4, '3', 1, '1', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:52:45', '', '');
+INSERT INTO `xp_task_7` VALUES (5, '4', 1, '5', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:58:11', '', '');
+INSERT INTO `xp_task_7` VALUES (6, '5', 2, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 18:00:52', '', '');
-- ----------------------------
-- Table structure for xp_task_8
@@ -1844,9 +1983,10 @@
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
`task_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务编号',
`task_category` int NOT NULL DEFAULT 1 COMMENT '任务类别1常规 2事故',
- `task_type_id` bigint NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
+ `task_type_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
`task_urgency_level` int NOT NULL COMMENT '任务紧急程度 0=P0 1=P1 2=P2 3=P3',
`task_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务描述',
+ `task_image` json NOT NULL COMMENT '任务图片',
`vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '车辆位置',
`vehicle_id` bigint NOT NULL COMMENT '车辆id',
`vehicle_lon` decimal(10, 2) NOT NULL COMMENT '车辆经度',
@@ -1857,7 +1997,8 @@
`assignee_time` datetime NULL DEFAULT NULL COMMENT '分配时间',
`report_user_id` bigint NOT NULL COMMENT '上报人id',
`report_time` datetime NOT NULL COMMENT '上报时间',
- `status` int NOT NULL DEFAULT 1 COMMENT '状态 1=待处理 2=已完成 3=已取消',
+ `status` int NOT NULL DEFAULT 1 COMMENT '状态0=待到达 1=待处理 2=已完成 3=已取消',
+ `end_time` datetime NOT NULL COMMENT '任务处理时限',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -1867,11 +2008,16 @@
INDEX `idx_tid`(`task_type_id` ASC) USING BTREE COMMENT '类型id',
INDEX `idx_level`(`task_urgency_level` ASC) USING BTREE COMMENT '级别',
INDEX `idx_status`(`status` ASC) USING BTREE COMMENT '状态'
-) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_task_8
-- ----------------------------
+INSERT INTO `xp_task_8` VALUES (2, '1', 1, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:45:35', '', '');
+INSERT INTO `xp_task_8` VALUES (3, '2', 1, '2', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:48:58', '', '');
+INSERT INTO `xp_task_8` VALUES (4, '3', 1, '1', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:52:45', '', '');
+INSERT INTO `xp_task_8` VALUES (5, '4', 1, '5', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:58:11', '', '');
+INSERT INTO `xp_task_8` VALUES (6, '5', 2, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 18:00:52', '', '');
-- ----------------------------
-- Table structure for xp_task_9
@@ -1881,9 +2027,10 @@
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
`task_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务编号',
`task_category` int NOT NULL DEFAULT 1 COMMENT '任务类别1常规 2事故',
- `task_type_id` bigint NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
+ `task_type_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务类型id 任务类别为2时对应数据字典，为1的时候 枚举1车辆检查 2车辆充电 3车辆整备 4整备洗车 5车辆维修 6车辆保养 7车辆保险到期 8车辆年检到期 9车辆运营资质到期',
`task_urgency_level` int NOT NULL COMMENT '任务紧急程度 0=P0 1=P1 2=P2 3=P3',
`task_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务描述',
+ `task_image` json NOT NULL COMMENT '任务图片',
`vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '车辆位置',
`vehicle_id` bigint NOT NULL COMMENT '车辆id',
`vehicle_lon` decimal(10, 2) NOT NULL COMMENT '车辆经度',
@@ -1894,7 +2041,8 @@
`assignee_time` datetime NULL DEFAULT NULL COMMENT '分配时间',
`report_user_id` bigint NOT NULL COMMENT '上报人id',
`report_time` datetime NOT NULL COMMENT '上报时间',
- `status` int NOT NULL DEFAULT 1 COMMENT '状态 1=待处理 2=已完成 3=已取消',
+ `status` int NOT NULL DEFAULT 1 COMMENT '状态0=待到达 1=待处理 2=已完成 3=已取消',
+ `end_time` datetime NOT NULL COMMENT '任务处理时限',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
@@ -1904,11 +2052,16 @@
INDEX `idx_tid`(`task_type_id` ASC) USING BTREE COMMENT '类型id',
INDEX `idx_level`(`task_urgency_level` ASC) USING BTREE COMMENT '级别',
INDEX `idx_status`(`status` ASC) USING BTREE COMMENT '状态'
-) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_task_9
-- ----------------------------
+INSERT INTO `xp_task_9` VALUES (2, '1', 1, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:45:35', '', '');
+INSERT INTO `xp_task_9` VALUES (3, '2', 1, '2', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:48:58', '', '');
+INSERT INTO `xp_task_9` VALUES (4, '3', 1, '1', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:52:45', '', '');
+INSERT INTO `xp_task_9` VALUES (5, '4', 1, '5', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 17:58:11', '', '');
+INSERT INTO `xp_task_9` VALUES (6, '5', 2, '3', 3, '描述', '{}', '位置', 2, 89.00, 98.00, 2, '2026-02-13 17:45:01', 2, '2026-02-13 17:45:11', 2, '2026-02-13 17:45:16', 2, '2026-02-13 17:45:16', 0, '2026-02-13 17:45:35', '2026-02-13 18:00:52', '', '');
-- ----------------------------
-- Table structure for xp_task_handle_detail
@@ -3137,6 +3290,7 @@
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
`vehicle_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '车辆编码',
`vehicle_vin` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '车辆vin码',
+ `xpu_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'XPUID',
`plate_number` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '车牌号',
`vehicle_model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '型号',
`vehicle_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '车辆颜色',
@@ -3157,8 +3311,8 @@
`operating_status` int NOT NULL DEFAULT 1 COMMENT '运营状态 1运营中 2维修中 3已收车 4车辆异常',
`warehousing_time` datetime NULL DEFAULT NULL COMMENT '入库时间',
`vehicle_type` int NOT NULL DEFAULT 1 COMMENT '车辆类型 1=在库 2=运营',
- `accept_or_test` int NOT NULL DEFAULT 3 COMMENT '当前模式 1接单 2测试',
- `accept_or_test_status` int NOT NULL COMMENT '模式状态 1开始接单/开始测试 2停止接单/停止测试',
+ `accept_or_test` int NULL DEFAULT 1 COMMENT '当前模式 1接单 2测试',
+ `accept_or_test_status` int NULL DEFAULT NULL COMMENT '模式状态 1开始接单/开始测试 2停止接单/停止测试',
`current_electricity` int NOT NULL DEFAULT 100 COMMENT '当前电量',
`is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
@@ -3173,11 +3327,15 @@
INDEX `idx_ostatus`(`operating_status` ASC) USING BTREE COMMENT '运营状态',
INDEX `idx_wtime`(`warehousing_time` ASC) USING BTREE COMMENT '入库时间',
INDEX `idx_aidate`(`annual_inspection_date` ASC) USING BTREE COMMENT '年检日期'
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '车辆管理' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '车辆管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_vehicle
-- ----------------------------
+INSERT INTO `xp_vehicle` VALUES (1, '03', '12312312312312312', '1', '粤PXV7029', '阿斯蒂芬', '白色', '{\"id\": \"926c50a3\", \"url\": \"https://q3.itc.cn/images01/20240319/ebdf9d93de4a498bbb819a0bce143cb7.jpeg\", \"name\": \"6lvylsNkTqdn86fe4fc2e7832b2ecd08d28bb4bc3c8c.png\"}', '采购', '备注', '2026-02-14 00:00:00', '宝相寺', '18224358736', '2026-02-21 00:00:00', '[{\"id\": \"6514c2ab\", \"url\": \"https://zos.alipayobjects.com/rmsportal/jkjgkEfvpUPVyRjUImniVslZfWPnJuuZ.png\", \"name\": \"90.jpg\"}]', '[{\"id\": \"ae9cb5ff\", \"url\": \"https://zos.alipayobjects.com/rmsportal/jkjgkEfvpUPVyRjUImniVslZfWPnJuuZ.png\", \"name\": \"90.jpg\"}]', 23, '[{\"id\": \"35bd87e9\", \"url\": \"https://zos.alipayobjects.com/rmsportal/jkjgkEfvpUPVyRjUImniVslZfWPnJuuZ.png\", \"name\": \"52852962eb8be041576show.jpg\"}]', '2026-02-28 00:00:00', 0, 2, 1, '2026-02-13 16:05:40', 1, 1, NULL, 100, 0, '2026-02-13 16:05:40', '2026-02-13 21:17:14', '', '');
+INSERT INTO `xp_vehicle` VALUES (2, '1', 'CDTEST005', '1', '1', '1', '1', '{\"id\": \"926c50a3\", \"url\": \"https://q3.itc.cn/images01/20240319/ebdf9d93de4a498bbb819a0bce143cb7.jpeg\", \"name\": \"6lvylsNkTqdn86fe4fc2e7832b2ecd08d28bb4bc3c8c.png\"}', '1', '1', '2026-02-13 10:19:47', '1', '1', '2026-02-13 10:19:51', '1', '1', 22, '1', '2026-02-13 10:20:03', 0, 2, 1, '2026-02-13 10:20:21', 2, 1, 1, 10, 0, '2026-02-13 10:19:31', '2026-02-13 21:17:15', '1', '1');
+INSERT INTO `xp_vehicle` VALUES (4, '0001', '21312323333333312', '1', '川X00001', '型号001', '白色', '{\"id\": \"926c50a3\", \"url\": \"https://q3.itc.cn/images01/20240319/ebdf9d93de4a498bbb819a0bce143cb7.jpeg\", \"name\": \"6lvylsNkTqdn86fe4fc2e7832b2ecd08d28bb4bc3c8c.png\"}', '采购', '这是备注001', '2026-02-26 00:00:00', '宝相寺', '18224358736', '2026-02-27 00:00:00', '[{\"id\": \"6ad5adb7\", \"url\": null, \"name\": \"5c7915bf-bb79-4450-924b-73c5b523055f.jpg\"}]', '[{\"id\": \"f203241c\", \"url\": null, \"name\": \"6c49230287fa2bfb9d5ee9783a14584c.jpg\"}]', 15, '[{\"id\": \"e4d966a2\", \"url\": null, \"name\": \"602e0742de3b93bc391d71641e4a904c.jpg\"}]', '2026-02-28 00:00:00', 0, 2, 1, '2026-02-13 14:50:59', 2, 1, NULL, 100, 0, '2026-02-13 14:50:59', '2026-02-13 21:17:15', '', '');
+INSERT INTO `xp_vehicle` VALUES (6, '1', 'TEST004', '1', '粤PXV7029', '1', '1', '{\"id\": \"926c50a3\", \"url\": \"https://q3.itc.cn/images01/20240319/ebdf9d93de4a498bbb819a0bce143cb7.jpeg\", \"name\": \"6lvylsNkTqdn86fe4fc2e7832b2ecd08d28bb4bc3c8c.png\"}', '1', '1', '2026-02-13 10:19:47', '1', '1', '2026-02-13 10:19:51', '1', '1', 23, '1', '2026-02-13 10:20:03', 0, 2, 1, '2026-02-13 10:20:21', 1, 1, 1, 1, 0, '2026-02-13 10:19:31', '2026-02-13 21:17:15', '1', '1');
-- ----------------------------
-- Table structure for xp_vehicle_annual_record
@@ -3202,11 +3360,14 @@
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_code`(`vehicle_id` ASC) USING BTREE COMMENT '编码',
INDEX `idx_aidate`(`annual_inspection_date` ASC) USING BTREE COMMENT '年检日期'
-) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '车辆年检信息修改记录' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '车辆年检信息修改记录' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_vehicle_annual_record
-- ----------------------------
+INSERT INTO `xp_vehicle_annual_record` VALUES (1, 4, '2026-02-26 00:00:00', '宝相寺', '18224358736', '2026-02-27 00:00:00', '[{\"id\": \"6ad5adb7\", \"url\": null, \"name\": \"5c7915bf-bb79-4450-924b-73c5b523055f.jpg\"}]', '[{\"id\": \"f203241c\", \"url\": null, \"name\": \"6c49230287fa2bfb9d5ee9783a14584c.jpg\"}]', '[{\"id\": \"e4d966a2\", \"url\": null, \"name\": \"602e0742de3b93bc391d71641e4a904c.jpg\"}]', '2026-02-28 00:00:00', 0, '2026-02-13 15:01:39', '2026-02-13 17:41:07', '', '');
+INSERT INTO `xp_vehicle_annual_record` VALUES (2, 4, '2026-02-26 00:00:00', '宝相寺', '18224358736', '2026-02-27 00:00:00', '[{\"id\": \"6ad5adb7\", \"url\": null, \"name\": \"5c7915bf-bb79-4450-924b-73c5b523055f.jpg\"}]', '[{\"id\": \"f203241c\", \"url\": null, \"name\": \"6c49230287fa2bfb9d5ee9783a14584c.jpg\"}]', '[{\"id\": \"e4d966a2\", \"url\": null, \"name\": \"602e0742de3b93bc391d71641e4a904c.jpg\"}]', '2026-02-28 00:00:00', 0, '2026-02-13 15:02:46', '2026-02-13 17:41:07', '', '');
+INSERT INTO `xp_vehicle_annual_record` VALUES (3, 2, '2026-02-26 00:00:00', '宝相寺', '18224358736', '2026-02-27 00:00:00', '[{\"id\": \"6ad5adb7\", \"url\": null, \"name\": \"5c7915bf-bb79-4450-924b-73c5b523055f.jpg\"}]', '[{\"id\": \"f203241c\", \"url\": null, \"name\": \"6c49230287fa2bfb9d5ee9783a14584c.jpg\"}]', '[{\"id\": \"e4d966a2\", \"url\": null, \"name\": \"602e0742de3b93bc391d71641e4a904c.jpg\"}]', '2026-02-28 00:00:00', 0, '2026-02-13 15:02:46', '2026-02-13 17:41:07', '', '');
-- ----------------------------
-- Table structure for xp_vehicle_clean
@@ -3285,11 +3446,12 @@
INDEX `idx_vid`(`vehicle_id` ASC) USING BTREE COMMENT '车辆id',
INDEX `idx_uid`(`operations_user_id` ASC) USING BTREE COMMENT '检查人id',
INDEX `idx_ctime`(`check_time` ASC) USING BTREE COMMENT '检查时间'
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '车辆检测' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '车辆检测' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_vehicle_detection
-- ----------------------------
+INSERT INTO `xp_vehicle_detection` VALUES (1, 4, 2, 1, 1, 1, 1, 1, 1, 1, '{\"id\": \"349d63fd\", \"url\": null, \"name\": \"k5cJyYGcZ2sB6748b26737af63446e4c291367fbf19a.png\"}', 1, '[{\"id\": \"e4d966a2\", \"url\": null, \"name\": \"602e0742de3b93bc391d71641e4a904c.jpg\"}]', 1, '[{\"id\": \"e4d966a2\", \"url\": null, \"name\": \"602e0742de3b93bc391d71641e4a904c.jpg\"}]', 1, '[{\"id\": \"e4d966a2\", \"url\": null, \"name\": \"602e0742de3b93bc391d71641e4a904c.jpg\"}]', 1, '[{\"id\": \"e4d966a2\", \"url\": null, \"name\": \"602e0742de3b93bc391d71641e4a904c.jpg\"}]', 2, '2026-02-13 17:56:22', 0, '2026-02-13 17:57:08', '2026-02-13 17:57:08', '', '');
-- ----------------------------
-- Table structure for xp_vehicle_detection_0
@@ -3326,7 +3488,7 @@
INDEX `idx_vid`(`vehicle_id` ASC) USING BTREE COMMENT '车辆id',
INDEX `idx_uid`(`operations_user_id` ASC) USING BTREE COMMENT '检查人id',
INDEX `idx_ctime`(`check_time` ASC) USING BTREE COMMENT '检查时间'
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '车辆检测' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '车辆检测' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_vehicle_detection_0
@@ -3731,11 +3893,12 @@
INDEX `idx_vid`(`vehicle_id` ASC) USING BTREE COMMENT '车辆id',
INDEX `idx_uid`(`operations_user_id` ASC) USING BTREE COMMENT '检查人id',
INDEX `idx_ctime`(`create_time` ASC) USING BTREE COMMENT '整备时间'
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '车辆整备' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '车辆整备' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_vehicle_preparation
-- ----------------------------
+INSERT INTO `xp_vehicle_preparation` VALUES (1, 2, 2, '120', '120', '120', '120', '{\"id\": \"349d63fd\", \"url\": null, \"name\": \"k5cJyYGcZ2sB6748b26737af63446e4c291367fbf19a.png\"}', '{\"id\": \"349d63fd\", \"url\": null, \"name\": \"k5cJyYGcZ2sB6748b26737af63446e4c291367fbf19a.png\"}', '{\"id\": \"349d63fd\", \"url\": null, \"name\": \"k5cJyYGcZ2sB6748b26737af63446e4c291367fbf19a.png\"}', '{\"id\": \"349d63fd\", \"url\": null, \"name\": \"k5cJyYGcZ2sB6748b26737af63446e4c291367fbf19a.png\"}', '{\"id\": \"349d63fd\", \"url\": null, \"name\": \"k5cJyYGcZ2sB6748b26737af63446e4c291367fbf19a.png\"}', '{\"id\": \"349d63fd\", \"url\": null, \"name\": \"k5cJyYGcZ2sB6748b26737af63446e4c291367fbf19a.png\"}', '{\"id\": \"349d63fd\", \"url\": null, \"name\": \"k5cJyYGcZ2sB6748b26737af63446e4c291367fbf19a.png\"}', '被准', 2, 0, '2026-02-13 17:47:36', '2026-02-13 17:47:36', '', '');
-- ----------------------------
-- Table structure for xp_vehicle_preparation_0
@@ -3767,7 +3930,7 @@
INDEX `idx_vid`(`vehicle_id` ASC) USING BTREE COMMENT '车辆id',
INDEX `idx_uid`(`operations_user_id` ASC) USING BTREE COMMENT '检查人id',
INDEX `idx_ctime`(`create_time` ASC) USING BTREE COMMENT '整备时间'
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '车辆整备' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '车辆整备' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_vehicle_preparation_0
@@ -4125,11 +4288,12 @@
INDEX `idx_sid`(`send_user_id` ASC) USING BTREE COMMENT '送修人id',
INDEX `idx_ctime`(`create_time` ASC) USING BTREE COMMENT '维修时间',
INDEX `idx_rid`(`return_user_id` ASC) USING BTREE COMMENT '取回人id'
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '车辆维修' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '车辆维修' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_vehicle_repair
-- ----------------------------
+INSERT INTO `xp_vehicle_repair` VALUES (1, 5, 2, '2026-02-13 17:58:30', '2026-02-14 17:58:33', '原因', '[{\"id\": \"e4d966a2\", \"url\": null, \"name\": \"602e0742de3b93bc391d71641e4a904c.jpg\"}]', 100.00, '{}', 2, '2026-02-13 17:59:21', 2, '2026-02-14 17:59:28', 0, '2026-02-13 17:59:51', '2026-02-13 17:59:51', '', '');
-- ----------------------------
-- Table structure for xp_vehicle_repair_0
@@ -4159,7 +4323,7 @@
INDEX `idx_sid`(`send_user_id` ASC) USING BTREE COMMENT '送修人id',
INDEX `idx_ctime`(`create_time` ASC) USING BTREE COMMENT '维修时间',
INDEX `idx_rid`(`return_user_id` ASC) USING BTREE COMMENT '取回人id'
-) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '车辆维修' ROW_FORMAT = Dynamic;
+) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '车辆维修' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xp_vehicle_repair_0
--
Gitblit v1.7.1