From 2f09efc660bf2cc94cbc5291ad25ca06fc9bdadf Mon Sep 17 00:00:00 2001
From: wlzboy <66905212@qq.com>
Date: 星期六, 24 一月 2026 22:03:09 +0800
Subject: [PATCH] feat: 增加OCR测试,车辆

---
 ruoyi-system/src/main/java/com/ruoyi/system/mapper/SysTaskMapper.java |   30 ++++++++++++++++++++++++++++++
 1 files changed, 30 insertions(+), 0 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 deeda59..cd4b187 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,5 +1,6 @@
 package com.ruoyi.system.mapper;
 
+import java.util.Date;
 import java.util.List;
 
 import com.ruoyi.common.annotation.DataSource;
@@ -7,6 +8,7 @@
 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鎺ュ彛
@@ -127,4 +129,32 @@
      * @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") String startTime,
+                                                      @Param("endTime") String endTime);
+    
+    /**
+     * 鏍规嵁鑱旂郴浜虹數璇濆拰鍒涘缓鏃ユ湡鏌ヨ浠诲姟鏁伴噺
+     * 
+     * @param phone 鑱旂郴浜虹數璇�
+     * @param createDate 浠诲姟鍒涘缓鏃ユ湡锛堟牸寮忥細YYYY-MM-DD锛�
+     * @return 浠诲姟鏁伴噺
+     */
+    public int countTaskByPhoneAndDate(@Param("phone") String phone, @Param("createDate") String createDate);
+    
+    /**
+     * 鏌ヨ杞﹁締鍦ㄦ寚瀹氭椂闂磋寖鍥村唴鐨勪换鍔″垪琛�
+     * 
+     * @param params 鍖呭惈vehicleId銆乻tartTime銆乪ndTime鐨勫弬鏁癕ap
+     * @return 浠诲姟鍒楄〃
+     */
+    public List<SysTask> selectVehicleTasksInTimeRange(java.util.Map<String, Object> params);
 }

--
Gitblit v1.9.1