From f67945d53b20f6a45ae50b27d74c966eb1355bb4 Mon Sep 17 00:00:00 2001 From: wlzboy <66905212@qq.com> Date: 星期日, 16 十一月 2025 22:53:54 +0800 Subject: [PATCH] feat: 增加分段GPS计算行程距离 --- sql/vehicle_mileage_stats.sql | 23 ++--------------------- 1 files changed, 2 insertions(+), 21 deletions(-) diff --git a/sql/vehicle_mileage_stats.sql b/sql/vehicle_mileage_stats.sql index 25d9667..eb5db0b 100644 --- a/sql/vehicle_mileage_stats.sql +++ b/sql/vehicle_mileage_stats.sql @@ -10,6 +10,8 @@ `task_ratio` decimal(5,4) DEFAULT 0.0000 COMMENT '浠诲姟閲岀▼鍗犳瘮(0-1)', `gps_point_count` int(11) DEFAULT 0 COMMENT 'GPS鐐规暟閲�', `task_count` int(11) DEFAULT 0 COMMENT '浠诲姟鏁伴噺', + `segment_count` int(11) DEFAULT 0 COMMENT '鍏宠仈鐨勫垎娈垫暟閲�', + `data_source` varchar(20) DEFAULT 'gps' COMMENT '鏁版嵁鏉ユ簮(segment-浠庡垎娈垫眹鎬�,gps-鐩存帴璁＄畻)', `create_time` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿', `update_time` datetime DEFAULT NULL COMMENT '鏇存柊鏃堕棿', PRIMARY KEY (`stats_id`), @@ -17,24 +19,3 @@ KEY `idx_vehicle_id` (`vehicle_id`), KEY `idx_stat_date` (`stat_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='杞﹁締閲岀▼缁熻琛�'; - --- 杞﹁締閲岀▼缁熻鏄庣粏琛紙鍙�夛紝鐢ㄤ簬璋冭瘯鍜岃拷婧級 -CREATE TABLE `tb_vehicle_mileage_detail` ( - `detail_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '鏄庣粏ID', - `stats_id` bigint(20) NOT NULL COMMENT '缁熻ID', - `vehicle_id` bigint(20) NOT NULL COMMENT '杞﹁締ID', - `segment_start_time` datetime NOT NULL COMMENT '娈佃捣濮嬫椂闂�', - `segment_end_time` datetime NOT NULL COMMENT '娈电粨鏉熸椂闂�', - `start_longitude` decimal(10,7) DEFAULT NULL COMMENT '璧风偣缁忓害', - `start_latitude` decimal(10,7) DEFAULT NULL COMMENT '璧风偣绾害', - `end_longitude` decimal(10,7) DEFAULT NULL COMMENT '缁堢偣缁忓害', - `end_latitude` decimal(10,7) DEFAULT NULL COMMENT '缁堢偣绾害', - `segment_distance` decimal(10,3) DEFAULT 0.000 COMMENT '娈佃窛绂�(鍏噷)', - `task_distance` decimal(10,3) DEFAULT 0.000 COMMENT '浠诲姟鍐呰窛绂�(鍏噷)', - `non_task_distance` decimal(10,3) DEFAULT 0.000 COMMENT '浠诲姟澶栬窛绂�(鍏噷)', - `is_in_task` tinyint(1) DEFAULT 0 COMMENT '鏄惁瀹屽叏鍦ㄤ换鍔℃椂娈靛唴(0-鍚�,1-鏄�,2-閮ㄥ垎)', - `create_time` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿', - PRIMARY KEY (`detail_id`), - KEY `idx_stats_id` (`stats_id`), - KEY `idx_vehicle_id` (`vehicle_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='杞﹁締閲岀▼缁熻鏄庣粏琛�'; -- Gitblit v1.9.1