From c5c10c1bb95f5bb7fdc8b714c5c998e78c26e0f7 Mon Sep 17 00:00:00 2001
From: 龚焕茏 <2842157468@qq.com>
Date: 星期二, 09 七月 2024 09:47:43 +0800
Subject: [PATCH] feat：标签新增、下拉增加部门id
---
src/main/java/com/mindskip/xzs/repository/QuestionSubjectMapper.java | 21 ++++++++++++++++++++-
1 files changed, 20 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/mindskip/xzs/repository/QuestionSubjectMapper.java b/src/main/java/com/mindskip/xzs/repository/QuestionSubjectMapper.java
index a4f3b25..e7bde69 100644
--- a/src/main/java/com/mindskip/xzs/repository/QuestionSubjectMapper.java
+++ b/src/main/java/com/mindskip/xzs/repository/QuestionSubjectMapper.java
@@ -1,6 +1,7 @@
package com.mindskip.xzs.repository;
import com.mindskip.xzs.domain.QuestionSubject;
+import com.mindskip.xzs.domain.vo.QuestionVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
@@ -31,5 +32,23 @@
List<QuestionSubject> getSubject(Integer id);
/** 缁熻璇剧洰鐨勯鐩暟 */
- Integer countQuestionNum(@Param("subjects") List<Integer> subjects);
+ Integer countQuestionNum(@Param("subjects") List<Integer> subjects, @Param("questionType") Integer questionType);
+
+ /** 闅忔満棰樼洰 */
+ List<QuestionVO> getRandomQuestionId(@Param("subjectIds") List<Integer> subjectIds, @Param("questionType") Integer questionType, @Param("questionNum") Integer questionNum);
+
+ /** 鏌ヨ棰樼洰ID锛屾牴鎹鐩甶ds */
+ List<Integer> questionsBySubjectIds(@Param("subjectIds") List<Integer> subjectIds);
+
+ /** 鏌ヨ棰樼洰ID鏍规嵁璇剧洰id */
+ List<Integer> questionsBySubjectId(Integer subjectId);
+
+ /** 鏍规嵁璇剧洰鍜岄鍨嬫煡璇㈤鐩甀D */
+ List<Integer> questionsBySubjectIdAndQuestionType(@Param("subjectId") Integer subjectId, @Param("questionType") Integer questionType);
+
+ /** 鏍规嵁璇剧洰ID鏌ヨ棰樼洰璇︽儏 */
+ List<QuestionVO> bySubjectId(@Param("subjectId") Integer subjectId);
+
+ /** 鏍规嵁璇剧洰鍜岄鍨嬫煡鎵鹃鐩暟鎹� */
+ List<QuestionVO> bySubjectIdAndQuestionType(Integer subjectId, Integer dataBaseValueByValue);
}
--
Gitblit v1.8.0