From a5722617fcb4fec61551785e55d58a2be45dcc84 Mon Sep 17 00:00:00 2001
From: xiangpei <xiangpei@timesnew.cn>
Date: 星期五, 21 六月 2024 11:31:57 +0800
Subject: [PATCH] 问题优化

---
 src/main/java/com/ycl/jxkg/domain/query/ClassesUserQuery.java |    3 +++
 src/main/resources/mapper/ExamMapper.xml                      |    2 ++
 src/main/resources/mapper/ClassesUserMapper.xml               |    2 +-
 3 files changed, 6 insertions(+), 1 deletions(-)

diff --git a/src/main/java/com/ycl/jxkg/domain/query/ClassesUserQuery.java b/src/main/java/com/ycl/jxkg/domain/query/ClassesUserQuery.java
index 776b5ed..1f6cc1a 100644
--- a/src/main/java/com/ycl/jxkg/domain/query/ClassesUserQuery.java
+++ b/src/main/java/com/ycl/jxkg/domain/query/ClassesUserQuery.java
@@ -22,5 +22,8 @@
     /** 瀛﹀憳濮撳悕 */
     private String studentName;
 
+    /** 鐝骇 */
+    private Integer classesId;
+
 }
 
diff --git a/src/main/resources/mapper/ClassesUserMapper.xml b/src/main/resources/mapper/ClassesUserMapper.xml
index 3d1df1e..50f6152 100644
--- a/src/main/resources/mapper/ClassesUserMapper.xml
+++ b/src/main/resources/mapper/ClassesUserMapper.xml
@@ -46,7 +46,7 @@
         TU.phone
         FROM t_classes_user TCU
         LEFT JOIN t_user TU ON TU.id = TCU.user_id
-        WHERE TCU.deleted = 0
+        WHERE TCU.deleted = 0 AND TCU.classes_id = #{query.classesId}
         <if test="query.studentName != null and query.studentName != ''">AND TU.real_name like concat('%',
             #{query.studentName}, '%')
         </if>
diff --git a/src/main/resources/mapper/ExamMapper.xml b/src/main/resources/mapper/ExamMapper.xml
index 9c67ad9..a644554 100644
--- a/src/main/resources/mapper/ExamMapper.xml
+++ b/src/main/resources/mapper/ExamMapper.xml
@@ -72,6 +72,8 @@
             <if test="query.classesId != null">
                 AND TE.classes_id = #{query.classesId}
             </if>
+        ORDER BY
+            TE.create_time DESC
     </select>
 
 

--
Gitblit v1.8.0