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