From ee86e280395eac2863cb7d9e7eb812bf192988f2 Mon Sep 17 00:00:00 2001
From: 龚焕茏 <2842157468@qq.com>
Date: 星期三, 26 六月 2024 18:05:37 +0800
Subject: [PATCH] feat:考试监控

---
 src/main/resources/mapper/ExamSubmitTempMapper.xml           |    4 ++--
 src/main/java/com/ycl/jxkg/service/impl/ExamServiceImpl.java |    2 +-
 2 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/src/main/java/com/ycl/jxkg/service/impl/ExamServiceImpl.java b/src/main/java/com/ycl/jxkg/service/impl/ExamServiceImpl.java
index cb54732..104c02f 100644
--- a/src/main/java/com/ycl/jxkg/service/impl/ExamServiceImpl.java
+++ b/src/main/java/com/ycl/jxkg/service/impl/ExamServiceImpl.java
@@ -436,7 +436,7 @@
     @Override
     public Result monitorList(ExamQuery query) {
         IPage<ExamSubmitTempVO> page = PageUtil.getPage(query, ExamSubmitTempVO.class);
-        return Result.ok().data(examSubmitTempMapper.monitorList(page, query));
+        return Result.ok((examSubmitTempMapper.monitorList(page, query)));
     }
 
     @Override
diff --git a/src/main/resources/mapper/ExamSubmitTempMapper.xml b/src/main/resources/mapper/ExamSubmitTempMapper.xml
index 4bbf61e..0f4a357 100644
--- a/src/main/resources/mapper/ExamSubmitTempMapper.xml
+++ b/src/main/resources/mapper/ExamSubmitTempMapper.xml
@@ -52,7 +52,7 @@
             TEST.status,
             TEST.id,
             TE.exam_name,
-            TU.real_name
+            TU.real_name as userName
         FROM
             t_exam_submit_temp TEST
         INNER JOIN t_user TU ON TU.id = TEST.user_id AND TU.deleted = 0
@@ -63,7 +63,7 @@
             AND TEST.exam_id = #{query.examId}
         </if>
         <if test="query.keyword != null and query.keyword != ''">
-            AND (INSTR(TU.real_name, #{query.keyword})) OR (INSTR(TE.exam_name, #{query.keyword})
+            AND (INSTR(TU.real_name, #{query.keyword}) OR INSTR(TE.exam_name, #{query.keyword}))
         </if>
     </select>
 

--
Gitblit v1.8.0