From 61c4c3f45e4257e2e7662f033e2719e62366c632 Mon Sep 17 00:00:00 2001
From: wlzboy <66905212@qq.com>
Date: 星期二, 31 三月 2026 23:02:22 +0800
Subject: [PATCH] feat: 优化申请发票，还可以修改发票信息
---
ruoyi-system/src/main/java/com/ruoyi/system/mapper/VehicleGpsMapper.java | 26 ++++++++++++++++++++------
1 files changed, 20 insertions(+), 6 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 4f7ba6b..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,15 +73,16 @@
* @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琛ㄤ腑鐨勮褰曪級
@@ -79,6 +93,6 @@
* @return 鏈璁＄畻鐨凣PS鍧愭爣鍒楄〃
*/
public List<VehicleGps> selectUncalculatedGps(@Param("vehicleId") Long vehicleId,
- @Param("startTime") Date startTime,
- @Param("endTime") Date endTime);
+ @Param("startTime") String startTime,
+ @Param("endTime") String endTime);
}
\ No newline at end of file
--
Gitblit v1.9.1