第一轮结果导出

xieb

2024-01-11 567775c8ef9761b5fe5d04073ca329b7ef30e22d

 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,25 @@
      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);
      IPage pages = evaluateTaskReferrerService.pageMaps(page, queryWrapper);
      ExcelUtil.export(response, "第一轮投票结果数据数据" + DateUtil.time(), "投票结果数据", page.getRecords(), ReferrerResultGroupExcel.class);
   }

   @GetMapping("/listInfo/{taskId}/{userId}")
   public R listInfo(@PathVariable("taskId") Long taskId,@PathVariable("userId") Long userId, Query query) {
      QueryWrapper queryWrapper = new QueryWrapper();