From 008a607e1fcb46bdb180bc4e74304bc91239d2ad Mon Sep 17 00:00:00 2001
From: xiangpei <xiangpei@timesnew.cn>
Date: 星期三, 22 五月 2024 13:33:38 +0800
Subject: [PATCH] sql bug
---
src/main/java/com/mindskip/xzs/repository/ExamPaperAnswerMapper.java | 33 ++++++++++++++++++++++++++++++++-
1 files changed, 32 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/mindskip/xzs/repository/ExamPaperAnswerMapper.java b/src/main/java/com/mindskip/xzs/repository/ExamPaperAnswerMapper.java
index 62b874e..06e76c1 100644
--- a/src/main/java/com/mindskip/xzs/repository/ExamPaperAnswerMapper.java
+++ b/src/main/java/com/mindskip/xzs/repository/ExamPaperAnswerMapper.java
@@ -2,21 +2,28 @@
import com.mindskip.xzs.domain.ExamPaperAnswer;
import com.mindskip.xzs.domain.ExamTemplatesUserCount;
+import com.mindskip.xzs.domain.ScoreTemplatesUserCount;
import com.mindskip.xzs.domain.other.KeyValue;
+import com.mindskip.xzs.domain.vo.ExamPaperStatisticVO;
+import com.mindskip.xzs.domain.vo.ExamTemplatesVO;
+import com.mindskip.xzs.domain.vo.TeamplatesUserExcelVO;
+import com.mindskip.xzs.viewmodel.admin.exam.ExamPaperEditRequestVM;
import com.mindskip.xzs.viewmodel.admin.paper.ExamPaperGradePageRequestVM;
+import com.mindskip.xzs.viewmodel.admin.paper.ExamPaperGradeQuery;
import com.mindskip.xzs.viewmodel.student.exampaper.ExamPaperAnswerPageVM;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import java.util.Date;
import java.util.List;
+import java.util.Map;
@Mapper
public interface ExamPaperAnswerMapper extends BaseMapper<ExamPaperAnswer> {
List<ExamPaperAnswer> studentPage(ExamPaperAnswerPageVM requestVM);
- Integer selectAllCount();
+ Integer selectAllCount(List<Integer> deptIds);
List<KeyValue> selectCountByDate(@Param("startTime") Date startTime, @Param("endTime") Date endTime);
@@ -31,4 +38,28 @@
List<ExamPaperAnswer> getByExamPaperIdAndUserId(@Param("examTemplatesUserCount")List<ExamTemplatesUserCount> examTemplatesUserCount);
List<ExamPaperAnswer> adminPageByGrade(ExamPaperGradePageRequestVM grade);
+
+ List<ExamPaperAnswer> getByScorePaperIdAndUserId(@Param("scoreTemplatesUserCounts")List<ScoreTemplatesUserCount> scoreTemplatesUserCounts);
+
+ List<ExamPaperAnswer> getByCreatUser(@Param("query") ExamPaperGradeQuery query);
+
+ List<ExamPaperAnswer> getByExamPaperIds(@Param("ids")List<Integer> ids);
+
+ List<ExamPaperAnswer> getResult(@Param("list")List<Integer> list);
+
+ List<TeamplatesUserExcelVO> getByTimeOne();
+
+ void setMissExam(ExamPaperEditRequestVM model);
+
+ void setMissExam(ExamTemplatesVO model);
+
+ void setMissExamByTemplate(ExamTemplatesVO model);
+
+ void insertDefault(ExamPaperEditRequestVM model);
+
+ void insertDefaultByTemplate(ExamTemplatesVO model);
+
+ Map<String, Object> histogram(ExamPaperStatisticVO examPaperStatisticVO);
+
+ Map<String, Object> pieChart(ExamPaperStatisticVO examPaperStatisticVO);
}
--
Gitblit v1.8.0