From 00fe3336b89c3c24ffe2826f45419d8e7dbb17fc Mon Sep 17 00:00:00 2001 From: 龚焕茏 <2842157468@qq.com> Date: 星期四, 23 五月 2024 15:46:57 +0800 Subject: [PATCH] feat:统计新需求 --- src/main/java/com/mindskip/xzs/repository/ExamPaperAnswerMapper.java | 27 ++++++++++++++++++++++++--- 1 files changed, 24 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 6a7e2f5..36252a9 100644 --- a/src/main/java/com/mindskip/xzs/repository/ExamPaperAnswerMapper.java +++ b/src/main/java/com/mindskip/xzs/repository/ExamPaperAnswerMapper.java @@ -4,22 +4,27 @@ 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.ExamPaperDataVO; +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); @@ -37,7 +42,7 @@ 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); @@ -45,7 +50,23 @@ 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> pieChart(ExamPaperStatisticVO examPaperStatisticVO); + + List<Map<String, Object>> dataByTemplate(ExamPaperDataVO examPaperDataVO); + + Map<String, Object> totalByTemplate(ExamPaperDataVO examPaperDataVO); + + List<Map<String, Object>> dataByPaper(ExamPaperDataVO examPaperDataVO); + + Map<String, Object> totalByPaper(ExamPaperDataVO examPaperDataVO); } -- Gitblit v1.8.0