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