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