From 8cb5d3440208a3be3e772e65f1bd0ec63031ba62 Mon Sep 17 00:00:00 2001
From: wlzboy <66905212@qq.com>
Date: 星期三, 17 十二月 2025 08:37:14 +0800
Subject: [PATCH] feat: 增加服务单派发通知
---
ruoyi-system/src/main/java/com/ruoyi/system/mapper/VehicleGpsMapper.java | 41 +++++++++++++++++++++++++++++++++++++++++
1 files changed, 41 insertions(+), 0 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 fb1310c..d8afe11 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
@@ -1,6 +1,8 @@
package com.ruoyi.system.mapper;
+import java.util.Date;
import java.util.List;
+import org.apache.ibatis.annotations.Param;
import com.ruoyi.system.domain.VehicleGps;
/**
@@ -41,4 +43,43 @@
* 鏍规嵁杞︾墝鍙疯幏鍙栬溅杈咺D
*/
public Long getVehicleIdByNo(String vehicleNo);
+
+ /**
+ * 鍒犻櫎鎸囧畾鏃ユ湡涔嬪墠鐨勮溅杈咷PS鏁版嵁
+ *
+ * @return 鍒犻櫎鐨勮褰曟暟
+ */
+ public int deleteVehicleGpsBeforeDate();
+
+ /**
+ * 鏌ヨ杞﹁締鍦ㄦ寚瀹氭椂闂磋寖鍥村唴鐨凣PS鏁版嵁锛堟寜閲囬泦鏃堕棿鎺掑簭锛�
+ *
+ * @param vehicleId 杞﹁締ID
+ * @param startTime 寮�濮嬫椂闂�
+ * @param endTime 缁撴潫鏃堕棿
+ * @return GPS鍧愭爣鍒楄〃
+ */
+ public List<VehicleGps> selectGpsDataByTimeRange(@Param("vehicleId") Long vehicleId,
+ @Param("startTime") String startTime,
+ @Param("endTime") String endTime);
+
+ /**
+ * 鏌ヨ娲昏穬杞﹁締ID鍒楄〃
+ *
+ * @param startTime 璧峰鏃堕棿
+ * @return 杞﹁締ID鍒楄〃
+ */
+ 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