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