按任务id和开始时间查询

zhangjianrock@163.com

2024-04-28 4bd7323a48505f15ab34b7900c871be7ca0312c6

按任务id和开始时间查询

 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);
    }

 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>
    <!--按月份统计文件数量-->