From 4bd7323a48505f15ab34b7900c871be7ca0312c6 Mon Sep 17 00:00:00 2001
From: zhangjianrock@163.com <zhangjianrock@163.com>
Date: 星期日, 28 四月 2024 14:46:27 +0800
Subject: [PATCH] 按任务id和开始时间查询
---
ard-work/src/main/java/com/ruoyi/inspect/controller/ArdVideoInspectRecordController.java | 1 -
ard-work/src/main/resources/mapper/inspect/ArdVideoInspectRecordMapper.xml | 4 ++--
2 files changed, 2 insertions(+), 3 deletions(-)
diff --git a/ard-work/src/main/java/com/ruoyi/inspect/controller/ArdVideoInspectRecordController.java b/ard-work/src/main/java/com/ruoyi/inspect/controller/ArdVideoInspectRecordController.java
index b9fe59f..3296b11 100644
--- a/ard-work/src/main/java/com/ruoyi/inspect/controller/ArdVideoInspectRecordController.java
+++ b/ard-work/src/main/java/com/ruoyi/inspect/controller/ArdVideoInspectRecordController.java
@@ -50,7 +50,6 @@
//涓嶆牎楠屾潈闄�
@GetMapping("/listByStartTime/noPerm")
public TableDataInfo listByStartTimeNoPerm(@RequestParam("taskId") String taskId,@RequestParam("startTime") String startTime) {
- startPage();
List<HashMap> list = ardVideoInspectRecordService.selectTaskRecordByStartTime(taskId,startTime);
return getDataTable(list);
}
diff --git a/ard-work/src/main/resources/mapper/inspect/ArdVideoInspectRecordMapper.xml b/ard-work/src/main/resources/mapper/inspect/ArdVideoInspectRecordMapper.xml
index f65265d..5d15653 100644
--- a/ard-work/src/main/resources/mapper/inspect/ArdVideoInspectRecordMapper.xml
+++ b/ard-work/src/main/resources/mapper/inspect/ArdVideoInspectRecordMapper.xml
@@ -43,8 +43,8 @@
select r.*, s.task_id
from ard_video_inspect_record r
LEFT JOIN ard_video_inspect_task_step s on r.step_id = s.id
- where s.task_id = '#{taskId}'
- and r.start_time like '#{startTime}%'
+ where s.task_id = '${taskId}'
+ and r.start_time like '${startTime}%'
order by r.start_time asc
</select>
<!--鎸夋湀浠界粺璁℃枃浠舵暟閲�-->
--
Gitblit v1.9.3