From c5ac97682e3b4ca748541ace97cb37a2295bd81e Mon Sep 17 00:00:00 2001
From: wlzboy <66905212@qq.com>
Date: 星期四, 19 三月 2026 22:46:29 +0800
Subject: [PATCH] feat: 增加GPS清理后台任务
---
ruoyi-system/src/main/java/com/ruoyi/system/mapper/VehicleGpsMapper.java | 34 ++++++++++++++++++++++++++++++----
1 files changed, 30 insertions(+), 4 deletions(-)
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/VehicleGpsMapper.java b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/VehicleGpsMapper.java
index b1cae08..7fab119 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/VehicleGpsMapper.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/VehicleGpsMapper.java
@@ -52,6 +52,19 @@
public int deleteVehicleGpsBeforeDate();
/**
+ * 鍒嗘壒鍒犻櫎鎸囧畾鏃ユ湡涔嬪墠鐨勮溅杈咷PS鏁版嵁锛堝甫 LIMIT锛�
+ *
+ * @param batchSize 姣忔壒鍒犻櫎鏉℃暟
+ * @return 鏈壒鍒犻櫎鐨勮褰曟暟
+ */
+ public int deleteVehicleGpsBeforeDateBatch(@Param("batchSize") int batchSize);
+
+ /**
+ * 浼樺寲琛紝鍥炴敹DELETE鍚庣殑纾佺洏纰庣墖绌洪棿
+ */
+ public void optimizeVehicleGpsTable();
+
+ /**
* 鏌ヨ杞﹁締鍦ㄦ寚瀹氭椂闂磋寖鍥村唴鐨凣PS鏁版嵁锛堟寜閲囬泦鏃堕棿鎺掑簭锛�
*
* @param vehicleId 杞﹁締ID
@@ -60,13 +73,26 @@
* @return GPS鍧愭爣鍒楄〃
*/
public List<VehicleGps> selectGpsDataByTimeRange(@Param("vehicleId") Long vehicleId,
- @Param("startTime") Date startTime,
- @Param("endTime") Date endTime);
+ @Param("startTime") String startTime,
+ @Param("endTime") String endTime);
/**
- * 鏌ヨ鎵�鏈夋椿璺冭溅杈咺D鍒楄〃
+ * 鏌ヨ娲昏穬杞﹁締ID鍒楄〃
*
+ * @param startTime 璧峰鏃堕棿
* @return 杞﹁締ID鍒楄〃
*/
- public List<Long> selectActiveVehicleIds();
+ public List<Long> selectActiveVehicleIds(@Param("startTime") String startTime);
+
+ /**
+ * 鏌ヨ鏈璁＄畻鐨凣PS鍧愭爣锛堜笉鍦╰b_vehicle_gps_calculated琛ㄤ腑鐨勮褰曪級
+ *
+ * @param vehicleId 杞﹁締ID
+ * @param startTime 寮�濮嬫椂闂�
+ * @param endTime 缁撴潫鏃堕棿
+ * @return 鏈璁＄畻鐨凣PS鍧愭爣鍒楄〃
+ */
+ public List<VehicleGps> selectUncalculatedGps(@Param("vehicleId") Long vehicleId,
+ @Param("startTime") String startTime,
+ @Param("endTime") String endTime);
}
\ No newline at end of file
--
Gitblit v1.9.1