From 3ec909b27b3eba956aa9d00cc7a94c179bd04bbf Mon Sep 17 00:00:00 2001
From: 龚焕茏 <2842157468@qq.com>
Date: 星期三, 03 七月 2024 18:29:31 +0800
Subject: [PATCH] feat:新增随机时间题目配置

---
 src/main/java/com/mindskip/xzs/repository/QuestionSubjectMapper.java |   32 +++++++++++++++++++++++++++++++-
 1 files changed, 31 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 dd19177..9813192 100644
--- a/src/main/java/com/mindskip/xzs/repository/QuestionSubjectMapper.java
+++ b/src/main/java/com/mindskip/xzs/repository/QuestionSubjectMapper.java
@@ -1,7 +1,9 @@
 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;
 
 import java.util.List;
 
@@ -13,7 +15,7 @@
      * @param ids
      * @return
      */
-    Integer removes(Integer[] ids);
+    Integer removes(@Param("ids") Integer[] ids);
 
     /**
      *
@@ -24,4 +26,32 @@
     Integer saves(List<QuestionSubject> list);
 
     Integer removeQuestionId(Integer questionId);
+
+    Integer removeSubjectId(Integer subjectId);
+
+    List<QuestionSubject> getSubject(Integer id);
+
+    /** 缁熻璇剧洰鐨勯鐩暟 */
+    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);
+
+    /** 鏍规嵁绉戠洰鏌ヨ棰樼洰 **/
+    List<QuestionSubject> getSubjectBySubjectIds(Integer[] subjectIds);
 }

--
Gitblit v1.8.0