From 9529220c815bfe6e43c992fde2f392be823450eb Mon Sep 17 00:00:00 2001
From: wlzboy <66905212@qq.com>
Date: 星期二, 11 十一月 2025 20:27:33 +0800
Subject: [PATCH] feat:增加天地图接口,并增加车辆GPS统计

---
 ruoyi-system/src/main/java/com/ruoyi/system/mapper/VehicleInfoMapper.java |   53 +++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 53 insertions(+), 0 deletions(-)

diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/VehicleInfoMapper.java b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/VehicleInfoMapper.java
index 594f0eb..1a5f016 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/VehicleInfoMapper.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/VehicleInfoMapper.java
@@ -1,7 +1,9 @@
 package com.ruoyi.system.mapper;
 
 import java.util.List;
+import org.apache.ibatis.annotations.Param;
 import com.ruoyi.system.domain.VehicleInfo;
+import com.ruoyi.system.domain.VehicleDept;
 
 /**
  * 杞﹁締淇℃伅Mapper鎺ュ彛
@@ -70,4 +72,55 @@
      * @return 缁撴灉
      */
     public int deleteVehicleInfoByIds(Long[] vehicleIds);
+    
+    /**
+     * 缁戝畾杞﹁締鍒扮敤鎴�
+     * 
+     * @param userId 鐢ㄦ埛ID
+     * @param vehicleId 杞﹁締ID
+     * @param bindBy 缁戝畾鎿嶄綔浜�
+     * @return 缁撴灉
+     */
+    public int bindVehicleToUser(@Param("userId") Long userId, @Param("vehicleId") Long vehicleId, @Param("bindBy") String bindBy);
+    
+    /**
+     * 瑙g粦鐢ㄦ埛杞﹁締
+     * 
+     * @param userId 鐢ㄦ埛ID
+     * @param vehicleId 杞﹁締ID
+     * @return 缁撴灉
+     */
+    public int unbindVehicleFromUser(@Param("userId") Long userId, @Param("vehicleId") Long vehicleId);
+    
+    /**
+     * 瑙g粦鐢ㄦ埛鐨勬墍鏈夎溅杈�
+     * 
+     * @param userId 鐢ㄦ埛ID
+     * @return 缁撴灉
+     */
+    public int unbindAllVehiclesFromUser(@Param("userId") Long userId);
+    
+    /**
+     * 鑾峰彇鐢ㄦ埛褰撳墠缁戝畾鐨勮溅杈�
+     * 
+     * @param userId 鐢ㄦ埛ID
+     * @return 杞﹁締淇℃伅
+     */
+    public VehicleInfo getUserBoundVehicle(@Param("userId") Long userId);
+    
+    /**
+     * 鎵归噺鎻掑叆杞﹁締-鍒嗗叕鍙稿叧鑱�
+     * 
+     * @param list 杞﹁締-鍒嗗叕鍙稿叧鑱斿垪琛�
+     * @return 缁撴灉
+     */
+    public int batchInsertVehicleDept(@Param("list") List<VehicleDept> list);
+    
+    /**
+     * 鍒犻櫎杞﹁締鐨勬墍鏈夊垎鍏徃鍏宠仈
+     * 
+     * @param vehicleId 杞﹁締ID
+     * @return 缁撴灉
+     */
+    public int deleteVehicleDeptByVehicleId(@Param("vehicleId") Long vehicleId);
 } 
\ No newline at end of file

--
Gitblit v1.9.1