From cb5122e5aca5ec5eaa4349a7ead7b73f8b4cd7aa Mon Sep 17 00:00:00 2001
From: xieb <vip_xiaobin810@163.com>
Date: Fri, 15 Dec 2023 16:01:29 +0800
Subject: [PATCH] 后台管理评分列表
---
src/main/java/org/springblade/modules/assessment/controller/AssessmentScoreController.java | 13 +++++++++++++
1 files changed, 13 insertions(+), 0 deletions(-)
diff --git a/src/main/java/org/springblade/modules/assessment/controller/AssessmentScoreController.java b/src/main/java/org/springblade/modules/assessment/controller/AssessmentScoreController.java
index f29f1cf..7bf8318 100644
--- a/src/main/java/org/springblade/modules/assessment/controller/AssessmentScoreController.java
+++ b/src/main/java/org/springblade/modules/assessment/controller/AssessmentScoreController.java
@@ -92,6 +92,19 @@
return R.data(AssessmentScoreWrapper.build().pageVO(pages));
}
+ @GetMapping("/listGroupByTask/{type}/{taskId}")
+ @ApiOperation(value = "评分列表", notes = "传入要查询的用户id")
+ public R listGroupByTask(@ApiIgnore @PathVariable Integer type,@PathVariable Long taskId, Query query) {
+ QueryWrapper<AssessmentScoreEntity> setEntityQueryWrapper = new QueryWrapper<>();
+ setEntityQueryWrapper.select("id,assessment_task_id,be_id,score_user_id,SUM(weight*score_val*0.01) as score_val,type");
+ setEntityQueryWrapper.eq("type", type);
+ setEntityQueryWrapper.eq("assessment_task_id",taskId);
+ setEntityQueryWrapper.groupBy("be_id");
+ IPage<AssessmentScoreEntity> pages = assessmentScoreService.page(Condition.getPage(query),setEntityQueryWrapper);
+
+ return R.data(AssessmentScoreWrapper.build().pageVO(pages));
+ }
+
@GetMapping("/listMyScore/{userId}")
@ApiOperation(value = "我的得分列表", notes = "传入要查询的用户id")
public R listMyScore(@ApiIgnore @PathVariable Long userId) {
--
Gitblit v1.9.3