From 0562ec1e83520d3a0fea4a61dca7e259a9c51da7 Mon Sep 17 00:00:00 2001
From: zengh <123456>
Date: Sun, 18 Jul 2021 10:11:27 +0800
Subject: [PATCH] 查询考试绑定的对应题目
---
src/main/java/org/springblade/modules/exam/controller/ExamSubjectChoicesController.java | 9 +++++++++
src/main/java/org/springblade/modules/exam/service/ExamSubjectChoicesService.java | 8 ++++++++
src/main/java/org/springblade/modules/exam/mapper/ExamSubjectChoicesMapper.java | 8 ++++++++
src/main/java/org/springblade/modules/exam/service/impl/ExamSubjectChoicesServiceImpl.java | 5 +++++
src/main/java/org/springblade/modules/exam/mapper/ExamSubjectChoicesMapper.xml | 14 ++++++++++++++
5 files changed, 44 insertions(+), 0 deletions(-)
diff --git a/src/main/java/org/springblade/modules/exam/controller/ExamSubjectChoicesController.java b/src/main/java/org/springblade/modules/exam/controller/ExamSubjectChoicesController.java
index 2d65f3a..3058883 100644
--- a/src/main/java/org/springblade/modules/exam/controller/ExamSubjectChoicesController.java
+++ b/src/main/java/org/springblade/modules/exam/controller/ExamSubjectChoicesController.java
@@ -137,4 +137,13 @@
return R.data(detail);
}
+ /**
+ * 查询试卷包含的题目
+ */
+ @GetMapping("/getEexPaperChoices")
+ public R<IPage<ExamSubjectChoicesVO>> getEexPaperChoices(ExamSubjectChoicesVO examSubjectChoices, Query query) {
+ IPage<ExamSubjectChoicesVO> pages = examSubjectChoicesService.getEexPaperChoices(Condition.getPage(query), examSubjectChoices);
+ return R.data(pages);
+ }
+
}
diff --git a/src/main/java/org/springblade/modules/exam/mapper/ExamSubjectChoicesMapper.java b/src/main/java/org/springblade/modules/exam/mapper/ExamSubjectChoicesMapper.java
index a96b848..74e8536 100644
--- a/src/main/java/org/springblade/modules/exam/mapper/ExamSubjectChoicesMapper.java
+++ b/src/main/java/org/springblade/modules/exam/mapper/ExamSubjectChoicesMapper.java
@@ -25,6 +25,14 @@
List<ExamSubjectChoicesVO> selectExamSubjectChoicesPage(IPage page, @Param("examSubjectChoices") ExamSubjectChoicesVO examSubjectChoices);
/**
+ * 查询试卷题目
+ * @param page
+ * @param examSubjectChoices
+ * @return
+ */
+ List<ExamSubjectChoicesVO> getEexPaperChoices(IPage page, ExamSubjectChoicesVO examSubjectChoices);
+
+ /**
* 详情
*
* @param examSubjectChoices 选择题信息对象
diff --git a/src/main/java/org/springblade/modules/exam/mapper/ExamSubjectChoicesMapper.xml b/src/main/java/org/springblade/modules/exam/mapper/ExamSubjectChoicesMapper.xml
index 949e72c..b3c76a0 100644
--- a/src/main/java/org/springblade/modules/exam/mapper/ExamSubjectChoicesMapper.xml
+++ b/src/main/java/org/springblade/modules/exam/mapper/ExamSubjectChoicesMapper.xml
@@ -18,6 +18,20 @@
</if>
</select>
+ <!--查询试卷绑定的题目-->
+ <select id="getEexPaperChoices" resultType="org.springblade.modules.exam.vo.ExamSubjectChoicesVO">
+ SELECT
+ esc.*
+ FROM
+ exam_subject_choices esc
+ LEFT JOIN exam_examination_subject exa ON esc.id = exa.subject_id
+ WHERE
+ 1=1
+ <if test="examSubjectChoices.id!=null and examSubjectChoices.id!=''">
+ and exa.examination_id = #{examSubjectChoices.id}
+ </if>
+ </select>
+
<!--ExamSubjectChoicesInfoMap 多表联查 一对多查询 -->
<resultMap id="ExamSubjectChoicesInfoMap" type="org.springblade.modules.exam.vo.ExamSubjectChoicesVO">
diff --git a/src/main/java/org/springblade/modules/exam/service/ExamSubjectChoicesService.java b/src/main/java/org/springblade/modules/exam/service/ExamSubjectChoicesService.java
index b132aa0..8cb5107 100644
--- a/src/main/java/org/springblade/modules/exam/service/ExamSubjectChoicesService.java
+++ b/src/main/java/org/springblade/modules/exam/service/ExamSubjectChoicesService.java
@@ -20,6 +20,14 @@
IPage<ExamSubjectChoicesVO> selectExamSubjectChoicesPage(IPage<ExamSubjectChoicesVO> page, ExamSubjectChoicesVO examSubjectChoices);
/**
+ * 查询试卷题目
+ * @param page
+ * @param examSubjectChoices
+ * @return
+ */
+ IPage<ExamSubjectChoicesVO> getEexPaperChoices(IPage<ExamSubjectChoicesVO> page, ExamSubjectChoicesVO examSubjectChoices);
+
+ /**
* 详情
* @param examSubjectChoices 选择题信息对象
*/
diff --git a/src/main/java/org/springblade/modules/exam/service/impl/ExamSubjectChoicesServiceImpl.java b/src/main/java/org/springblade/modules/exam/service/impl/ExamSubjectChoicesServiceImpl.java
index f9e1f4e..6f4a78b 100644
--- a/src/main/java/org/springblade/modules/exam/service/impl/ExamSubjectChoicesServiceImpl.java
+++ b/src/main/java/org/springblade/modules/exam/service/impl/ExamSubjectChoicesServiceImpl.java
@@ -21,6 +21,11 @@
return page.setRecords(baseMapper.selectExamSubjectChoicesPage(page, examSubjectChoices));
}
+ @Override
+ public IPage<ExamSubjectChoicesVO> getEexPaperChoices(IPage<ExamSubjectChoicesVO> page, ExamSubjectChoicesVO examSubjectChoices) {
+ return page.setRecords(baseMapper.getEexPaperChoices(page, examSubjectChoices));
+ }
+
/**
* 详情
* @param examSubjectChoices 选择题信息对象
--
Gitblit v1.9.3