导出修改

xieb

2024-01-24 24e01e7f50bbfccf880b062a9a2a91efd61055b8

 src/main/java/org/springblade/modules/evaluate/controller/EvaluateTaskReferrerController.java

@@ -18,7 +18,6 @@

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;
@@ -83,6 +82,20 @@
   }

   /**
    * 第一轮投票详情集合 分页
    * @param evaluateTaskReferrer
    * @param query
    * @return
    */
   @GetMapping("/referrerList")
   @ApiOperationSupport(order = 2)
   @ApiOperation(value = "分页", notes = "传入evaluateTaskReferrer")
   public R<IPage<EvaluateTaskReferrerVO>> referrerList(EvaluateTaskReferrerVO evaluateTaskReferrer, Query query) {
      IPage<EvaluateTaskReferrerVO> pages = evaluateTaskReferrerService.selectReferrerInfoPage(Condition.getPage(query), evaluateTaskReferrer);
      return R.data(pages);
   }

   /**
    * 第一轮投票结果
    * @param taskId
    * @param query
@@ -90,12 +103,29 @@
    */
   @GetMapping("/list/{taskId}")
   public R listByTaskId(@PathVariable("taskId") Long taskId, Query query) {
      QueryWrapper queryWrapper = new QueryWrapper();
      queryWrapper.select("*, count(*) as voteNum");
      queryWrapper.eq("evaluate_task_id", taskId);
      queryWrapper.orderByDesc("dept_name,count(*)");
      queryWrapper.groupBy("user_id");
      return R.data(evaluateTaskReferrerService.pageMaps(Condition.getPage(query), queryWrapper));
//      QueryWrapper queryWrapper = new QueryWrapper();
//      queryWrapper.select("*, count(*) as voteNum");
//      queryWrapper.eq("evaluate_task_id", taskId);
//      queryWrapper.orderByDesc("dept_name,count(*)");
//      queryWrapper.groupBy("user_id");
//      return R.data(evaluateTaskReferrerService.pageMaps(Condition.getPage(query), queryWrapper));
      EvaluateTaskReferrerVO evaluateTaskReferrerVO = new EvaluateTaskReferrerVO();
      evaluateTaskReferrerVO.setEvaluateTaskId(taskId);
      return R.data(evaluateTaskReferrerService.selectEvaluateTaskReferrerMapPage(Condition.getPage(query), evaluateTaskReferrerVO));
   }

   @GetMapping("/list/{taskId}/{evaluateTaskCategoryId}")
   public R listByTaskIdAndCategoryId(@PathVariable("taskId") Long taskId, @PathVariable("evaluateTaskCategoryId") Long evaluateTaskCategoryId, Query query) {
//      QueryWrapper queryWrapper = new QueryWrapper();
//      queryWrapper.select("*, count(*) as voteNum");
//      queryWrapper.eq("evaluate_task_id", taskId);
//      queryWrapper.orderByDesc("dept_name,count(*)");
//      queryWrapper.groupBy("user_id");
//      return R.data(evaluateTaskReferrerService.pageMaps(Condition.getPage(query), queryWrapper));
      EvaluateTaskReferrerVO evaluateTaskReferrerVO = new EvaluateTaskReferrerVO();
      evaluateTaskReferrerVO.setEvaluateTaskId(taskId);
      evaluateTaskReferrerVO.setEvaluateTaskCategoryId(evaluateTaskCategoryId);
      return R.data(evaluateTaskReferrerService.selectEvaluateTaskReferrerMapPage(Condition.getPage(query), evaluateTaskReferrerVO));
   }

   /**
@@ -106,13 +136,10 @@
   @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);
      queryWrapper.eq("a.evaluate_task_id", taskId);
      queryWrapper.eq("a.is_deleted", 0);
      queryWrapper.orderByDesc("a.evaluate_task_category_id,a.dept_id,voteNum");
      queryWrapper.groupBy("a.user_id,a.evaluate_task_category_id");

      List<ReferrerResultGroupExcel> list = evaluateTaskReferrerService.exportListByTaskId(queryWrapper);

@@ -130,6 +157,24 @@
   }

   /**
    * 根据分类获取候选人的投票详情
    * @param taskId
    * @param evaluateTaskCategoryId
    * @param userId
    * @param query
    * @return
    */
   @GetMapping("/listInfo/{taskId}/{evaluateTaskCategoryId}/{userId}")
   public R listInfoByCategoryId(@PathVariable("taskId") Long taskId, @PathVariable("evaluateTaskCategoryId") Long evaluateTaskCategoryId, @PathVariable("userId") Long userId, Query query) {
      QueryWrapper queryWrapper = new QueryWrapper();
      queryWrapper.eq("evaluate_task_id", taskId);
      queryWrapper.eq("user_id", userId);
      queryWrapper.eq("evaluate_task_category_id", evaluateTaskCategoryId);
      IPage<EvaluateTaskReferrerEntity> evaluateTaskReferrerEntityIPage = evaluateTaskReferrerService.page(Condition.getPage(query), queryWrapper);
      return R.data(EvaluateTaskReferrerWrapper.build().listInfoVO(evaluateTaskReferrerEntityIPage));
   }

   /**
    * 评优任务推荐人员表 自定义分页
    */
   @GetMapping("/page")