From 53dea0ef5fc8b035397b73b10f7a819ebf381b1c Mon Sep 17 00:00:00 2001
From: xiangpei <xiangpei@timesnew.cn>
Date: 星期二, 09 七月 2024 09:39:11 +0800
Subject: [PATCH] 分页优化
---
src/main/java/com/mindskip/xzs/repository/ExamPaperAnswerMapper.java | 41 ++++++++++++++++++++++++++++++++++++++++-
1 files changed, 40 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..8fe8d1a 100644
--- a/src/main/java/com/mindskip/xzs/repository/ExamPaperAnswerMapper.java
+++ b/src/main/java/com/mindskip/xzs/repository/ExamPaperAnswerMapper.java
@@ -2,21 +2,26 @@
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.*;
+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 +36,38 @@
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);
+
+ Map<String, Object> histogram(ExamPaperStatisticVO examPaperStatisticVO);
+
+ Map<String, Object> histogramByTemplate(ExamPaperStatisticVO examPaperStatisticVO);
+
+ Map<String, Object> pieChart(ExamPaperStatisticVO examPaperStatisticVO);
+
+ List<ExamPaperDataExportVO> dataByTemplate(ExamPaperDataVO examPaperDataVO);
+
+ ExamPaperDataExportVO totalByTemplate(ExamPaperDataVO examPaperDataVO);
+
+ List<ExamPaperDataExportVO> dataByPaper(ExamPaperDataVO examPaperDataVO);
+
+ ExamPaperDataExportVO totalByPaper(ExamPaperDataVO examPaperDataVO);
+
+ Integer getExamTotal(ExamPaperStatisticVO examPaperStatisticVO);
}
--
Gitblit v1.8.0