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 | 38 +++++++++++++++++++++++++++++++++++--- 1 files changed, 35 insertions(+), 3 deletions(-) diff --git a/src/main/java/com/mindskip/xzs/repository/ExamPaperAnswerMapper.java b/src/main/java/com/mindskip/xzs/repository/ExamPaperAnswerMapper.java index 3e32178..8fe8d1a 100644 --- a/src/main/java/com/mindskip/xzs/repository/ExamPaperAnswerMapper.java +++ b/src/main/java/com/mindskip/xzs/repository/ExamPaperAnswerMapper.java @@ -4,21 +4,24 @@ 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.ScoreTemplatesCountVO; +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); @@ -36,6 +39,35 @@ List<ExamPaperAnswer> getByScorePaperIdAndUserId(@Param("scoreTemplatesUserCounts")List<ScoreTemplatesUserCount> scoreTemplatesUserCounts); - List<ExamPaperAnswer> getByCreatUser(ScoreTemplatesCountVO scoreTemplatesCountVO); + 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