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/SysTaskMapper.java |   19 ++++++++++++++++++-
 1 files changed, 18 insertions(+), 1 deletions(-)

diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/SysTaskMapper.java b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/SysTaskMapper.java
index a356c6a..c918380 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/SysTaskMapper.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/SysTaskMapper.java
@@ -1,9 +1,14 @@
 package com.ruoyi.system.mapper;
 
+import java.util.Date;
 import java.util.List;
+
+import com.ruoyi.common.annotation.DataSource;
+import com.ruoyi.common.enums.DataSourceType;
 import com.ruoyi.system.domain.SysTask;
 import com.ruoyi.system.domain.vo.TaskQueryVO;
 import com.ruoyi.system.domain.vo.TaskStatisticsVO;
+import org.apache.ibatis.annotations.Param;
 
 /**
  * 浠诲姟绠$悊Mapper鎺ュ彛
@@ -11,6 +16,7 @@
  * @author ruoyi
  * @date 2024-01-15
  */
+@DataSource(DataSourceType.MASTER)
 public interface SysTaskMapper {
     
     /**
@@ -24,7 +30,7 @@
     /**
      * 鏌ヨ浠诲姟绠$悊鍒楄〃
      * 
-     * @param sysTask 浠诲姟绠$悊
+     * @param queryVO 浠诲姟绠$悊
      * @return 浠诲姟绠$悊闆嗗悎
      */
     public List<SysTask> selectSysTaskList(TaskQueryVO queryVO);
@@ -123,4 +129,15 @@
      * @return 姝e湪杩涜涓殑浠诲姟鍒楄〃
      */
     public List<SysTask> selectActiveTasksByVehicleId(Long vehicleId);
+
+    /**
+     * 鏍规嵁鏃堕棿鍜岃溅杈嗘潵鏌ヨ璇ヨ溅杈嗘槸鍚︽鍦ㄤ换鍔′腑
+     * @param vehicleId
+     * @param startTime
+     * @param endTime
+     * @return
+     */
+    public List<SysTask> selectTaskByVehicleIdAndDate(@Param("vehicleId") Long vehicleId,
+                                                      @Param("startTime") Date startTime,
+                                                      @Param("endTime") Date endTime);
 }

--
Gitblit v1.9.1