package com.mindskip.xzs.repository;

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(List<Integer> deptIds);

    List<KeyValue> selectCountByDate(@Param("startTime") Date startTime, @Param("endTime") Date endTime);

    ExamPaperAnswer getByPidUid(@Param("pid") Integer paperId, @Param("uid") Integer uid);

    List<ExamPaperAnswer> adminPage(com.mindskip.xzs.viewmodel.admin.paper.ExamPaperAnswerPageRequestVM requestVM);

    ExamPaperAnswer getById(Integer id);

    List<ExamPaperAnswer> selectByPaperName(@Param("paperName") String paperName);

    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);


    /**
     * 根据答卷试卷id获取最高成绩答卷
     * @param examPaperAnswer 答卷
     * @return 最高成绩答卷
     */
    ExamPaperAnswer getTemplateOtherExamAnswer(@Param("examPaperAnswer") ExamPaperAnswer examPaperAnswer, @Param("templateId") Integer templateId);

    /**
     * 根据试卷id获取最高成绩答卷
     * @param examPaperAnswer 答卷
     * @return 最高成绩答卷
     */
    ExamPaperAnswer getPaperOtherExamAnswer(ExamPaperAnswer examPaperAnswer);
}