From 09faa36132c8cbada5327649875534ef01c1a3b1 Mon Sep 17 00:00:00 2001
From: wlzboy <66905212@qq.com>
Date: 星期四, 11 十二月 2025 20:44:31 +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);
+
+ /**
+ * 瑙ｇ粦鐢ㄦ埛杞﹁締
+ *
+ * @param userId 鐢ㄦ埛ID
+ * @param vehicleId 杞﹁締ID
+ * @return 缁撴灉
+ */
+ public int unbindVehicleFromUser(@Param("userId") Long userId, @Param("vehicleId") Long vehicleId);
+
+ /**
+ * 瑙ｇ粦鐢ㄦ埛鐨勬墍鏈夎溅杈�
+ *
+ * @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