From 08480c7fbef16c9e04ed7c2de77cc6640bd98e7c Mon Sep 17 00:00:00 2001
From: xieb <vip_xiaobin810@163.com>
Date: Thu, 11 Jan 2024 16:44:48 +0800
Subject: [PATCH] 第一轮结果导出
---
src/main/java/org/springblade/modules/evaluate/controller/EvaluateTaskReferrerController.java | 24 ++++++++++++++++++++++++
1 files changed, 24 insertions(+), 0 deletions(-)
diff --git a/src/main/java/org/springblade/modules/evaluate/controller/EvaluateTaskReferrerController.java b/src/main/java/org/springblade/modules/evaluate/controller/EvaluateTaskReferrerController.java
index fd1bd7d..6bb32c5 100644
--- a/src/main/java/org/springblade/modules/evaluate/controller/EvaluateTaskReferrerController.java
+++ b/src/main/java/org/springblade/modules/evaluate/controller/EvaluateTaskReferrerController.java
@@ -18,6 +18,7 @@
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
@@ -34,6 +35,7 @@
import org.springblade.core.tool.utils.Func;
import org.springblade.modules.evaluate.entity.EvaluateTaskReferrerEntity;
import org.springblade.modules.evaluate.excel.EvaluateTaskReferrerExcel;
+import org.springblade.modules.evaluate.excel.ReferrerResultGroupExcel;
import org.springblade.modules.evaluate.service.IEvaluateTaskReferrerService;
import org.springblade.modules.evaluate.vo.EvaluateTaskReferrerVO;
import org.springblade.modules.evaluate.wrapper.EvaluateTaskReferrerWrapper;
@@ -96,6 +98,28 @@
return R.data(evaluateTaskReferrerService.pageMaps(Condition.getPage(query), queryWrapper));
}
+ /**
+ * 第一轮投票结果导出数据
+ */
+ @GetMapping("/export/{taskId}")
+ @ApiOperationSupport(order = 9)
+ @ApiOperation(value = "导出数据", notes = "传入evaluateTaskReferrer")
+ public void exportListByTaskId(@PathVariable("taskId") Long taskId, HttpServletResponse response) {
+ QueryWrapper queryWrapper = new QueryWrapper();
+// queryWrapper.select("*, count(*) as voteNum");
+ queryWrapper.eq("evaluate_task_id", taskId);
+ queryWrapper.orderByDesc("dept_name,count(*)");
+ queryWrapper.groupBy("user_id");
+ Page page = new Page();
+ page.setSize(1);
+ page.setCurrent(9999);
+
+ List<ReferrerResultGroupExcel> list = evaluateTaskReferrerService.exportListByTaskId(queryWrapper);
+
+
+ ExcelUtil.export(response, "第一轮投票结果数据数据" + DateUtil.time(), "投票结果数据", list, ReferrerResultGroupExcel.class);
+ }
+
@GetMapping("/listInfo/{taskId}/{userId}")
public R listInfo(@PathVariable("taskId") Long taskId,@PathVariable("userId") Long userId, Query query) {
QueryWrapper queryWrapper = new QueryWrapper();
--
Gitblit v1.9.3