From 4d2b88284dae05b7acb2134b4ddbbd11b1586952 Mon Sep 17 00:00:00 2001
From: luohairen <3399054449@qq.com>
Date: 星期四, 31 十月 2024 15:09:22 +0800
Subject: [PATCH] 优化题目查询

---
 src/main/resources/mapper/QuestionMapper.xml                                   |    3 +++
 src/main/java/com/ycl/jxkg/domain/vo/admin/question/QuestionPageRequestVO.java |    2 ++
 src/main/java/com/ycl/jxkg/controller/admin/QuestionController.java            |    2 ++
 3 files changed, 7 insertions(+), 0 deletions(-)

diff --git a/src/main/java/com/ycl/jxkg/controller/admin/QuestionController.java b/src/main/java/com/ycl/jxkg/controller/admin/QuestionController.java
index 06e0450..e05f891 100644
--- a/src/main/java/com/ycl/jxkg/controller/admin/QuestionController.java
+++ b/src/main/java/com/ycl/jxkg/controller/admin/QuestionController.java
@@ -32,6 +32,8 @@
 
     @RequestMapping(value = "/page", method = RequestMethod.POST)
     public Result<PageInfo<QuestionResponseVO>> pageList(@RequestBody QuestionPageRequestVO model) {
+        model.setTitle(model.getContent());
+        model.setContent(null);
         PageInfo<QuestionResponseVO> pageInfo = questionService.page(model);
         PageInfo<QuestionResponseVO> page = PageInfoHelper.copyMap(pageInfo, q -> {
             QuestionResponseVO vo = new QuestionResponseVO();
diff --git a/src/main/java/com/ycl/jxkg/domain/vo/admin/question/QuestionPageRequestVO.java b/src/main/java/com/ycl/jxkg/domain/vo/admin/question/QuestionPageRequestVO.java
index 7a3eefe..fc34d2c 100644
--- a/src/main/java/com/ycl/jxkg/domain/vo/admin/question/QuestionPageRequestVO.java
+++ b/src/main/java/com/ycl/jxkg/domain/vo/admin/question/QuestionPageRequestVO.java
@@ -19,4 +19,6 @@
 
     private String content;
 
+    private String title;
+
 }
diff --git a/src/main/resources/mapper/QuestionMapper.xml b/src/main/resources/mapper/QuestionMapper.xml
index 59076e6..69b64af 100644
--- a/src/main/resources/mapper/QuestionMapper.xml
+++ b/src/main/resources/mapper/QuestionMapper.xml
@@ -56,6 +56,9 @@
             <if test="content != null and content != ''">
                 and instr(tq.content, #{content})
             </if>
+            <if test="title != null and title != ''">
+                and title like CONCAT('%', #{title}, '%')
+            </if>
         </where>
     </select>
 

--
Gitblit v1.8.0