From d28ba0adc6fcec6780c4ee500077aa46dd336957 Mon Sep 17 00:00:00 2001
From: luohairen <3399054449@qq.com>
Date: 星期五, 08 十一月 2024 09:54:28 +0800
Subject: [PATCH] 完成教师端，页面顶部展示
---
src/main/resources/mapper/ExamPaperScoreMapper.xml | 3 +++
src/main/java/com/ycl/jxkg/service/ExamPaperScoreService.java | 8 ++++++++
src/main/java/com/ycl/jxkg/service/impl/ExamPaperScoreServiceImpl.java | 21 +++++++++++++++++++++
src/main/java/com/ycl/jxkg/controller/admin/ExamPaperScoreController.java | 5 +++++
4 files changed, 37 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/ycl/jxkg/controller/admin/ExamPaperScoreController.java b/src/main/java/com/ycl/jxkg/controller/admin/ExamPaperScoreController.java
index 362370a..db45e61 100644
--- a/src/main/java/com/ycl/jxkg/controller/admin/ExamPaperScoreController.java
+++ b/src/main/java/com/ycl/jxkg/controller/admin/ExamPaperScoreController.java
@@ -71,4 +71,9 @@
return Result.ok(examPaperScoreVO);
}
+ @PostMapping("/queryMaxAndMinScore/{id}")
+ public Result queryMaxAndMinScore(@PathVariable Integer id) {
+ return examPaperScoreService.queryMaxAndMinScore(id);
+ }
+
}
diff --git a/src/main/java/com/ycl/jxkg/service/ExamPaperScoreService.java b/src/main/java/com/ycl/jxkg/service/ExamPaperScoreService.java
index 9ac0ec6..188f4d9 100644
--- a/src/main/java/com/ycl/jxkg/service/ExamPaperScoreService.java
+++ b/src/main/java/com/ycl/jxkg/service/ExamPaperScoreService.java
@@ -2,6 +2,7 @@
import com.baomidou.mybatisplus.extension.service.IService;
import com.github.pagehelper.PageInfo;
+import com.ycl.jxkg.base.Result;
import com.ycl.jxkg.domain.ExamPaperAnswerInfo;
import com.ycl.jxkg.domain.entity.ExamPaperScore;
import com.ycl.jxkg.domain.entity.User;
@@ -77,4 +78,11 @@
* @return 鏁版嵁
*/
PageInfo<UserAnswerPageResponseVO> pageUser(UserAnswerPageRequestVO model);
+
+ /**
+ * 鏈�楂樻渶浣庡垎
+ * @param id 鏌ヨ鏉′欢
+ * @return
+ */
+ Result queryMaxAndMinScore(Integer id);
}
diff --git a/src/main/java/com/ycl/jxkg/service/impl/ExamPaperScoreServiceImpl.java b/src/main/java/com/ycl/jxkg/service/impl/ExamPaperScoreServiceImpl.java
index 23ee969..06049e7 100644
--- a/src/main/java/com/ycl/jxkg/service/impl/ExamPaperScoreServiceImpl.java
+++ b/src/main/java/com/ycl/jxkg/service/impl/ExamPaperScoreServiceImpl.java
@@ -1,8 +1,10 @@
package com.ycl.jxkg.service.impl;
+import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
+import com.ycl.jxkg.base.Result;
import com.ycl.jxkg.domain.ExamPaperAnswerInfo;
import com.ycl.jxkg.domain.entity.*;
import com.ycl.jxkg.domain.other.KeyValue;
@@ -29,6 +31,7 @@
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
+import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.stream.Collectors;
@@ -292,4 +295,22 @@
return PageHelper.startPage(model.getPageIndex(), model.getPageSize()).doSelectPageInfo(() ->
examPaperScoreMapper.pageUser(model));
}
+
+ @Override
+ public Result queryMaxAndMinScore(Integer id) {
+ List<ExamPaperScore> list = new ArrayList<>();
+ ExamPaperScore max = examPaperScoreMapper.selectOne(new LambdaQueryWrapper<>(ExamPaperScore.class)
+ .eq(ExamPaperScore::getExamId, id)
+ .orderByDesc(ExamPaperScore::getTotalScore)
+ .last("limit 1"));
+ list.add(max);
+ if (null != max) {
+ ExamPaperScore min = examPaperScoreMapper.selectOne(new LambdaQueryWrapper<>(ExamPaperScore.class)
+ .eq(ExamPaperScore::getExamId, id)
+ .orderByAsc(ExamPaperScore::getTotalScore)
+ .last("limit 1"));
+ list.add(min);
+ }
+ return Result.ok(list);
+ }
}
diff --git a/src/main/resources/mapper/ExamPaperScoreMapper.xml b/src/main/resources/mapper/ExamPaperScoreMapper.xml
index 1221a14..aa5f665 100644
--- a/src/main/resources/mapper/ExamPaperScoreMapper.xml
+++ b/src/main/resources/mapper/ExamPaperScoreMapper.xml
@@ -149,6 +149,9 @@
<if test="examName != null and examName != ''">
AND INSTR(t.exam_name, #{examName})
</if>
+ <if test="examId != null and examId != ''">
+ AND t.id = #{examId}
+ </if>
</where>
GROUP BY t.id
ORDER BY t.id DESC
--
Gitblit v1.8.0