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/java/com/ycl/jxkg/service/impl/ExamPaperScoreServiceImpl.java | 21 +++++++++++++++++++++
1 files changed, 21 insertions(+), 0 deletions(-)
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);
+ }
}
--
Gitblit v1.8.0