From 6dc4345f9c84d829566ae1632477f11c22fac2f5 Mon Sep 17 00:00:00 2001
From: xiangpei <xiangpei@timesnew.cn>
Date: 星期一, 27 五月 2024 11:48:02 +0800
Subject: [PATCH] 题目查询增加题干搜索
---
src/main/resources/mapper/QuestionMapper.xml | 3 +++
src/main/java/com/mindskip/xzs/service/impl/ExamPaperServiceImpl.java | 2 +-
src/main/java/com/mindskip/xzs/viewmodel/admin/question/QuestionPageRequestVM.java | 50 +++-----------------------------------------------
3 files changed, 7 insertions(+), 48 deletions(-)
diff --git a/src/main/java/com/mindskip/xzs/service/impl/ExamPaperServiceImpl.java b/src/main/java/com/mindskip/xzs/service/impl/ExamPaperServiceImpl.java
index 7ea5cbd..88c8287 100644
--- a/src/main/java/com/mindskip/xzs/service/impl/ExamPaperServiceImpl.java
+++ b/src/main/java/com/mindskip/xzs/service/impl/ExamPaperServiceImpl.java
@@ -217,7 +217,7 @@
userNames.add(user.getRealName());
}
}
- vm.setUserId(userIds);
+ vm.setUserIds(userIds);
vm.setUserNames(userNames);
return vm;
}
diff --git a/src/main/java/com/mindskip/xzs/viewmodel/admin/question/QuestionPageRequestVM.java b/src/main/java/com/mindskip/xzs/viewmodel/admin/question/QuestionPageRequestVM.java
index 86f31d7..5eff112 100644
--- a/src/main/java/com/mindskip/xzs/viewmodel/admin/question/QuestionPageRequestVM.java
+++ b/src/main/java/com/mindskip/xzs/viewmodel/admin/question/QuestionPageRequestVM.java
@@ -1,9 +1,10 @@
package com.mindskip.xzs.viewmodel.admin.question;
import com.mindskip.xzs.base.BasePage;
+import lombok.Data;
-
+@Data
public class QuestionPageRequestVM extends BasePage {
private Integer id;
@@ -13,52 +14,7 @@
private String content;
private String questionName;
+ private String titleContent;
- public Integer getId() {
- return id;
- }
- public void setId(Integer id) {
- this.id = id;
- }
-
- public Integer getLevel() {
- return level;
- }
-
- public void setLevel(Integer level) {
- this.level = level;
- }
-
- public Integer[] getSubjectId() {
- return subjectId;
- }
-
- public void setSubjectId(Integer[] subjectId) {
- this.subjectId = subjectId;
- }
-
- public Integer getQuestionType() {
- return questionType;
- }
-
- public void setQuestionType(Integer questionType) {
- this.questionType = questionType;
- }
-
- public String getContent() {
- return content;
- }
-
- public void setContent(String content) {
- this.content = content;
- }
-
- public String getQuestionName() {
- return questionName;
- }
-
- public void setQuestionName(String questionName) {
- this.questionName = questionName;
- }
}
diff --git a/src/main/resources/mapper/QuestionMapper.xml b/src/main/resources/mapper/QuestionMapper.xml
index 4e1b47a..6fe00b0 100644
--- a/src/main/resources/mapper/QuestionMapper.xml
+++ b/src/main/resources/mapper/QuestionMapper.xml
@@ -186,6 +186,9 @@
LEFT JOIN t_text_content t on q.info_text_content_id = t.id
<where>
and q.deleted=0 and qs.deleted = 0
+ <if test="titleContent != null and titleContent != ''">
+ and JSON_VALUE(t.content, '$.titleContent') like concat('%', #{titleContent}, '%')
+ </if>
<if test="id != null ">
and q.id= #{id}
</if>
--
Gitblit v1.8.0