From f5c900c58513bad824381e69750ac7667ef35de0 Mon Sep 17 00:00:00 2001
From: wlzboy <66905212@qq.com>
Date: 星期四, 26 二月 2026 22:29:46 +0800
Subject: [PATCH] feat: 修改增另任务单查询，使用单号查询
---
ruoyi-system/src/main/java/com/ruoyi/system/mapper/SysTaskMapper.java | 38 ++++++++++++++++++++++++++++++++++++++
1 files changed, 38 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..77d0170 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,40 @@
* @return 姝ｅ湪杩涜涓殑浠诲姟鍒楄〃
*/
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);
+
+ /**
+ * 浼樺寲鐨勫鐮佹煡璇㈡柟娉曪紝鍏宠仈sys_task_emergency琛ㄥ苟璁＄畻dispatchCode鍜宻erviceCode
+ *
+ * @param queryVO 浠诲姟鏌ヨ瀵硅薄
+ * @return 浠诲姟绠＄悊闆嗗悎
+ */
+ public List<SysTask> selectSysTaskListByMultiCodeOptimized(TaskQueryVO queryVO);
}
--
Gitblit v1.9.1