From 5f2ee03958a1a16dc27195c76ea7cffb422c95d1 Mon Sep 17 00:00:00 2001
From: wlzboy <66905212@qq.com>
Date: 星期五, 19 十二月 2025 22:40:34 +0800
Subject: [PATCH] feat: 任务修改接口,删除一些不要的字段同步

---
 ruoyi-system/src/main/java/com/ruoyi/system/mapper/VehicleInfoMapper.java |  121 ++++++++++++++++++++++++++++++++++++++++
 1 files changed, 121 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 8af5386..ec09157 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,39 +1,160 @@
 package com.ruoyi.system.mapper;
 
 import java.util.List;
+import java.util.Map;
+
+import org.apache.ibatis.annotations.Param;
 import com.ruoyi.system.domain.VehicleInfo;
+import com.ruoyi.system.domain.VehicleDept;
 
 /**
  * 杞﹁締淇℃伅Mapper鎺ュ彛
  */
 public interface VehicleInfoMapper {
     /**
+     * 鏌ヨ杞﹁締淇℃伅锛堝寘鍚鍒嗗叕鍙稿叧鑱旓級
+     * 
+     * @param vehicleId 杞﹁締淇℃伅涓婚敭
+     * @return 杞﹁締淇℃伅锛堝寘鍚玠eptIds鍜宒eptNames锛�
+     */
+    public VehicleInfo selectVehicleInfoWithDeptsById(Long vehicleId);
+
+    /**
+     * 鏌ヨ杞﹁締淇℃伅鍒楄〃锛堝寘鍚鍒嗗叕鍙稿叧鑱旓級
+     * 
+     * @param vehicleInfo 杞﹁締淇℃伅
+     * @return 杞﹁締淇℃伅闆嗗悎锛堝寘鍚玠eptIds鍜宒eptNames锛�
+     */
+    public List<VehicleInfo> selectVehicleInfoListWithDepts(VehicleInfo vehicleInfo);
+
+    /**
      * 鏌ヨ杞﹁締淇℃伅
+     * 
+     * @param vehicleId 杞﹁締淇℃伅涓婚敭
+     * @return 杞﹁締淇℃伅
      */
     public VehicleInfo selectVehicleInfoById(Long vehicleId);
 
     /**
+     * 閫氳繃杞︾墝鍙锋煡璇㈣溅杈嗕俊鎭�
+     * 
+     * @param plateNumber 杞︾墝鍙�
+     * @return 杞﹁締淇℃伅
+     */
+    public VehicleInfo selectVehicleInfoByPlateNumber(String plateNumber);
+
+    /**
+     * 閫氳繃杞︾墝鍙锋煡璇㈣溅杈嗕俊鎭�
+     * 
+     * @param vehicleNo 杞︾墝鍙�
+     * @return 杞﹁締淇℃伅
+     */
+    public VehicleInfo selectVehicleInfoByVehicleNo(String vehicleNo);
+    
+    /**
+     * 鏍规嵁鏃х郴缁熻溅杈咺D(CarID)鏌ヨ杞﹁締淇℃伅
+     * 
+     * @param carId 鏃х郴缁熻溅杈咺D
+     * @return 杞﹁締淇℃伅
+     */
+    public VehicleInfo selectVehicleInfoByCarId(@Param("carId") Integer carId);
+    
+    /**
+     * 鏍规嵁鏃х郴缁熻溅杈咺D鏌ヨ杞﹁締淇℃伅
+     * 
+     * @param carID 鏃х郴缁熻溅杈咺D
+     * @return 杞﹁締淇℃伅锛坴ehicle_id, car_id, vehicle_no锛�
+     */
+    public Map<String, Object> selectVehicleInfoByCarID(@Param("carID") String carID);
+
+    /**
      * 鏌ヨ杞﹁締淇℃伅鍒楄〃
+     * 
+     * @param vehicleInfo 杞﹁締淇℃伅
+     * @return 杞﹁締淇℃伅闆嗗悎
      */
     public List<VehicleInfo> selectVehicleInfoList(VehicleInfo vehicleInfo);
 
     /**
      * 鏂板杞﹁締淇℃伅
+     * 
+     * @param vehicleInfo 杞﹁締淇℃伅
+     * @return 缁撴灉
      */
     public int insertVehicleInfo(VehicleInfo vehicleInfo);
 
     /**
      * 淇敼杞﹁締淇℃伅
+     * 
+     * @param vehicleInfo 杞﹁締淇℃伅
+     * @return 缁撴灉
      */
     public int updateVehicleInfo(VehicleInfo vehicleInfo);
 
     /**
      * 鍒犻櫎杞﹁締淇℃伅
+     * 
+     * @param vehicleId 杞﹁締淇℃伅涓婚敭
+     * @return 缁撴灉
      */
     public int deleteVehicleInfoById(Long vehicleId);
 
     /**
      * 鎵归噺鍒犻櫎杞﹁締淇℃伅
+     * 
+     * @param vehicleIds 闇�瑕佸垹闄ょ殑鏁版嵁涓婚敭闆嗗悎
+     * @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