From 8b375fe00a241b3a769b82fe3dac8d1c9dce8a02 Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Thu, 16 Jun 2022 14:36:07 +0800
Subject: [PATCH] 模拟考试修改
---
src/main/java/org/springblade/modules/exam/mapper/ExamScoreMapper.java | 30 ++++++++++++++++++++++++++++--
1 files changed, 28 insertions(+), 2 deletions(-)
diff --git a/src/main/java/org/springblade/modules/exam/mapper/ExamScoreMapper.java b/src/main/java/org/springblade/modules/exam/mapper/ExamScoreMapper.java
index b70c398..941227a 100644
--- a/src/main/java/org/springblade/modules/exam/mapper/ExamScoreMapper.java
+++ b/src/main/java/org/springblade/modules/exam/mapper/ExamScoreMapper.java
@@ -1,11 +1,16 @@
package org.springblade.modules.exam.mapper;
+import com.baomidou.mybatisplus.annotation.SqlParser;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Param;
import org.springblade.modules.exam.entity.ExamScore;
import org.springblade.modules.exam.excel.ExportExamScoreExcel;
import org.springblade.modules.exam.vo.ExamScoreVO;
+import org.springblade.modules.exam.vo.ExamSocreStatis;
+import org.springblade.modules.information.entity.Information;
+import org.springblade.modules.information.vo.InformationVO;
+import org.springblade.modules.system.vo.UserVO;
import org.springblade.modules.training.entity.TrainingRegistration;
import java.util.List;
@@ -34,6 +39,7 @@
* @param examScore 实体
* @return
*/
+ @SqlParser(filter = true)
List<ExamScoreVO> selectTrainExamScorePage(IPage page, @Param("examScore") ExamScoreVO examScore);
/**
@@ -48,7 +54,7 @@
* @param idCardNo 身份证号
* @return
*/
- ExamScore getExamScoreInfoByIdCardNo(@Param("idCardNo")String idCardNo,@Param("examId")Long examId);
+ List<ExamScore> getExamScoreInfoByIdCardNo(@Param("idCardNo")String idCardNo,@Param("startTime")String startTime);
List<Map<String,Object>> scoreStatistics(String deptid,String jurisdiction);
List<Map<String,Object>> scoreStatisticssc(String deptid,String jurisdiction);
@@ -66,7 +72,7 @@
* @param page 分页
* @return
*/
- List<ExamScoreVO> scorePage(IPage page,String deptid,String jurisdiction);
+ List<ExamScoreVO> scorePage(IPage page,@Param("examScore") ExamScoreVO examScore);
/**
* 查询所有考试不合格的数据
@@ -95,4 +101,24 @@
* @return
*/
List<ExportExamScoreExcel> getExamScoreList(@Param("examScore") ExamScoreVO examScoreVO);
+
+ /**
+ * 查询每个培训学校的考试信息
+ * @param information
+ * @return
+ */
+ List<ExamSocreStatis> getExamStatisInfo(@Param("information") InformationVO information);
+
+ /**
+ * 查询考试成绩
+ * @return
+ */
+ List<ExamScore> getExamScoreLists();
+
+ /**
+ * 查询考试成绩
+ * @param time
+ * @return
+ */
+ List<ExamScore> getExamScoreListByTime(@Param("time") String time);
}
--
Gitblit v1.9.3