From 6be421331eb1b9b9e6c55d97ebdeeb942fc391e0 Mon Sep 17 00:00:00 2001
From: xieb <vip_xiaobin810@163.com>
Date: Thu, 11 Jan 2024 17:55:11 +0800
Subject: [PATCH] 公司评优结果和部门评优结果导出
---
src/main/java/org/springblade/modules/evaluate/excel/DeptResultGroupExcel.java | 58 ++++++++++++++
src/main/java/org/springblade/modules/evaluate/controller/EvaluateCandidateResultController.java | 26 ++++++
src/main/java/org/springblade/modules/evaluate/mapper/EvaluateCandidateResultMapper.java | 5 +
src/main/java/org/springblade/modules/evaluate/mapper/EvaluateCandidateResultMapper.xml | 10 ++
src/main/java/org/springblade/modules/evaluate/excel/EmployeeResultGroupExcel.java | 85 +++++++++++++++++++++
src/main/java/org/springblade/modules/evaluate/excel/ReferrerResultGroupExcel.java | 2
src/main/java/org/springblade/modules/evaluate/service/IEvaluateCandidateResultService.java | 13 ++
src/main/java/org/springblade/modules/evaluate/service/impl/EvaluateCandidateResultServiceImpl.java | 19 ++++
8 files changed, 214 insertions(+), 4 deletions(-)
diff --git a/src/main/java/org/springblade/modules/evaluate/controller/EvaluateCandidateResultController.java b/src/main/java/org/springblade/modules/evaluate/controller/EvaluateCandidateResultController.java
index 2c37e90..aaf01e5 100644
--- a/src/main/java/org/springblade/modules/evaluate/controller/EvaluateCandidateResultController.java
+++ b/src/main/java/org/springblade/modules/evaluate/controller/EvaluateCandidateResultController.java
@@ -34,6 +34,8 @@
import org.springblade.core.tool.utils.Func;
import org.springblade.modules.evaluate.entity.EvaluateCandidateResultEntity;
import org.springblade.modules.evaluate.entity.EvaluateTaskEntity;
+import org.springblade.modules.evaluate.excel.DeptResultGroupExcel;
+import org.springblade.modules.evaluate.excel.EmployeeResultGroupExcel;
import org.springblade.modules.evaluate.excel.EvaluateCandidateResultExcel;
import org.springblade.modules.evaluate.service.IEvaluateCandidateResultService;
import org.springblade.modules.evaluate.service.IEvaluateTaskService;
@@ -189,4 +191,28 @@
ExcelUtil.export(response, "评优任务候选人投票结果表数据" + DateUtil.time(), "评优任务候选人投票结果表数据表", list, EvaluateCandidateResultExcel.class);
}
+ @GetMapping("/exportEmp/{taskId}")
+ @ApiOperationSupport(order = 9)
+ @ApiOperation(value = "公司评优结果导出数据", notes = "传入evaluateTaskReferrer")
+ public void exprotEmployeeResultGroupExcel(@PathVariable("taskId") Long taskId, HttpServletResponse response) {
+ QueryWrapper queryWrapper = new QueryWrapper();
+ queryWrapper.eq("a.evaluate_task_id", taskId);
+ queryWrapper.orderByDesc("b.category_name,a.dept_name,a.count(*)");
+ queryWrapper.groupBy("user_id");
+ List<EmployeeResultGroupExcel> list = evaluateCandidateResultService.exportEmployeeResultGroupExcel(queryWrapper);
+ ExcelUtil.export(response, "最终评优结果" + DateUtil.time(), "投票结果数据", list, EmployeeResultGroupExcel.class);
+ }
+
+ @GetMapping("/exportDept/{taskId}")
+ @ApiOperationSupport(order = 9)
+ @ApiOperation(value = "公司评优结果导出数据", notes = "传入evaluateTaskReferrer")
+ public void exprotDeptResultGroupExcel(@PathVariable("taskId") Long taskId, HttpServletResponse response) {
+ QueryWrapper queryWrapper = new QueryWrapper();
+ queryWrapper.eq("a.evaluate_task_id", taskId);
+ queryWrapper.orderByDesc("a.count(*)");
+ queryWrapper.groupBy("dept_id");
+ List<DeptResultGroupExcel> list = evaluateCandidateResultService.exportDeptResultGroupExcel(queryWrapper);
+ ExcelUtil.export(response, "最终评优结果" + DateUtil.time(), "投票结果数据", list, DeptResultGroupExcel.class);
+ }
+
}
diff --git a/src/main/java/org/springblade/modules/evaluate/excel/DeptResultGroupExcel.java b/src/main/java/org/springblade/modules/evaluate/excel/DeptResultGroupExcel.java
new file mode 100644
index 0000000..b15a966
--- /dev/null
+++ b/src/main/java/org/springblade/modules/evaluate/excel/DeptResultGroupExcel.java
@@ -0,0 +1,58 @@
+/*
+ * Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions are met:
+ *
+ * Redistributions of source code must retain the above copyright notice,
+ * this list of conditions and the following disclaimer.
+ * Redistributions in binary form must reproduce the above copyright
+ * notice, this list of conditions and the following disclaimer in the
+ * documentation and/or other materials provided with the distribution.
+ * Neither the name of the dreamlu.net developer nor the names of its
+ * contributors may be used to endorse or promote products derived from
+ * this software without specific prior written permission.
+ * Author: Chill 庄骞 (smallchill@163.com)
+ */
+package org.springblade.modules.evaluate.excel;
+
+
+import com.alibaba.excel.annotation.ExcelProperty;
+import com.alibaba.excel.annotation.write.style.ColumnWidth;
+import com.alibaba.excel.annotation.write.style.ContentRowHeight;
+import com.alibaba.excel.annotation.write.style.HeadRowHeight;
+import lombok.Data;
+
+import java.io.Serializable;
+
+
+/**
+ * 公司评选第二轮结果 Excel实体类
+ *
+ * @author aix
+ * @since 2024-01-05
+ */
+@Data
+@ColumnWidth(25)
+@HeadRowHeight(20)
+@ContentRowHeight(18)
+public class DeptResultGroupExcel implements Serializable {
+
+ private static final long serialVersionUID = 1L;
+
+ /**
+ * 部门
+ */
+ @ColumnWidth(20)
+ @ExcelProperty("部门")
+ private String deptName;
+
+ /**
+ * 票数
+ */
+ @ColumnWidth(20)
+ @ExcelProperty("票数")
+ private String voteNum;
+
+
+}
diff --git a/src/main/java/org/springblade/modules/evaluate/excel/EmployeeResultGroupExcel.java b/src/main/java/org/springblade/modules/evaluate/excel/EmployeeResultGroupExcel.java
new file mode 100644
index 0000000..42f5be6
--- /dev/null
+++ b/src/main/java/org/springblade/modules/evaluate/excel/EmployeeResultGroupExcel.java
@@ -0,0 +1,85 @@
+/*
+ * Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions are met:
+ *
+ * Redistributions of source code must retain the above copyright notice,
+ * this list of conditions and the following disclaimer.
+ * Redistributions in binary form must reproduce the above copyright
+ * notice, this list of conditions and the following disclaimer in the
+ * documentation and/or other materials provided with the distribution.
+ * Neither the name of the dreamlu.net developer nor the names of its
+ * contributors may be used to endorse or promote products derived from
+ * this software without specific prior written permission.
+ * Author: Chill 庄骞 (smallchill@163.com)
+ */
+package org.springblade.modules.evaluate.excel;
+
+
+import com.alibaba.excel.annotation.ExcelProperty;
+import com.alibaba.excel.annotation.write.style.ColumnWidth;
+import com.alibaba.excel.annotation.write.style.ContentRowHeight;
+import com.alibaba.excel.annotation.write.style.HeadRowHeight;
+import lombok.Data;
+
+import java.io.Serializable;
+
+
+/**
+ * 公司评选第二轮结果 Excel实体类
+ *
+ * @author aix
+ * @since 2024-01-05
+ */
+@Data
+@ColumnWidth(25)
+@HeadRowHeight(20)
+@ContentRowHeight(18)
+public class EmployeeResultGroupExcel implements Serializable {
+
+ private static final long serialVersionUID = 1L;
+
+ /**
+ * 姓名
+ */
+ @ColumnWidth(20)
+ @ExcelProperty("类别名称")
+ private String categoryName;
+
+ /**
+ * 认定标准
+ */
+ @ColumnWidth(100)
+ @ExcelProperty("认定标准")
+ private String standard;
+
+ /**
+ * 姓名
+ */
+ @ColumnWidth(20)
+ @ExcelProperty("姓名")
+ private String userName;
+
+ /**
+ * 部门
+ */
+ @ColumnWidth(20)
+ @ExcelProperty("部门")
+ private String deptName;
+ /**
+ * 职位
+ */
+ @ColumnWidth(20)
+ @ExcelProperty("职位")
+ private String postName;
+
+ /**
+ * 票数
+ */
+ @ColumnWidth(20)
+ @ExcelProperty("票数")
+ private String voteNum;
+
+
+}
diff --git a/src/main/java/org/springblade/modules/evaluate/excel/ReferrerResultGroupExcel.java b/src/main/java/org/springblade/modules/evaluate/excel/ReferrerResultGroupExcel.java
index 0672d7a..a82ca16 100644
--- a/src/main/java/org/springblade/modules/evaluate/excel/ReferrerResultGroupExcel.java
+++ b/src/main/java/org/springblade/modules/evaluate/excel/ReferrerResultGroupExcel.java
@@ -27,7 +27,7 @@
/**
- * 评优任务推荐人员表 Excel实体类
+ * 第一轮投票结果 Excel实体类
*
* @author aix
* @since 2024-01-05
diff --git a/src/main/java/org/springblade/modules/evaluate/mapper/EvaluateCandidateResultMapper.java b/src/main/java/org/springblade/modules/evaluate/mapper/EvaluateCandidateResultMapper.java
index 114b2bf..6ce10d6 100644
--- a/src/main/java/org/springblade/modules/evaluate/mapper/EvaluateCandidateResultMapper.java
+++ b/src/main/java/org/springblade/modules/evaluate/mapper/EvaluateCandidateResultMapper.java
@@ -17,6 +17,8 @@
package org.springblade.modules.evaluate.mapper;
import org.springblade.modules.evaluate.entity.EvaluateCandidateResultEntity;
+import org.springblade.modules.evaluate.excel.DeptResultGroupExcel;
+import org.springblade.modules.evaluate.excel.EmployeeResultGroupExcel;
import org.springblade.modules.evaluate.vo.EvaluateCandidateResultVO;
import org.springblade.modules.evaluate.excel.EvaluateCandidateResultExcel;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
@@ -51,4 +53,7 @@
*/
List<EvaluateCandidateResultExcel> exportEvaluateCandidateResult(@Param("ew") Wrapper<EvaluateCandidateResultEntity> queryWrapper);
+ List<DeptResultGroupExcel> exportDeptResultGroupExcel(@Param("ew") Wrapper<EvaluateCandidateResultEntity> queryWrapper);
+ List<EmployeeResultGroupExcel> exportEmployeeResultGroupExcel(@Param("ew") Wrapper<EvaluateCandidateResultEntity> queryWrapper);
+
}
diff --git a/src/main/java/org/springblade/modules/evaluate/mapper/EvaluateCandidateResultMapper.xml b/src/main/java/org/springblade/modules/evaluate/mapper/EvaluateCandidateResultMapper.xml
index c116fcb..a4db7f9 100644
--- a/src/main/java/org/springblade/modules/evaluate/mapper/EvaluateCandidateResultMapper.xml
+++ b/src/main/java/org/springblade/modules/evaluate/mapper/EvaluateCandidateResultMapper.xml
@@ -33,4 +33,14 @@
SELECT * FROM yw_evaluate_candidate_result ${ew.customSqlSegment}
</select>
+ <select id="exportDeptResultGroupExcel" resultType="org.springblade.modules.evaluate.excel.DeptResultGroupExcel">
+ SELECT *,count(*) voteNum FROM yw_evaluate_candidate_result ${ew.customSqlSegment}
+ </select>
+
+ <select id="exportEmployeeResultGroupExcel" resultType="org.springblade.modules.evaluate.excel.EmployeeResultGroupExcel">
+ select b.category_name,b.standard,a.user_name,a.dept_name,a.post_name,count(*) voteNum from yw_evaluate_candidate_result a
+ LEFT JOIN yw_evaluate_task_category b ON (a.evaluate_task_category_id = b.id)
+ ${ew.customSqlSegment}
+ </select>
+
</mapper>
diff --git a/src/main/java/org/springblade/modules/evaluate/service/IEvaluateCandidateResultService.java b/src/main/java/org/springblade/modules/evaluate/service/IEvaluateCandidateResultService.java
index 335b97b..f84cfa5 100644
--- a/src/main/java/org/springblade/modules/evaluate/service/IEvaluateCandidateResultService.java
+++ b/src/main/java/org/springblade/modules/evaluate/service/IEvaluateCandidateResultService.java
@@ -17,11 +17,14 @@
package org.springblade.modules.evaluate.service;
import com.baomidou.mybatisplus.core.conditions.Wrapper;
-import org.springblade.modules.evaluate.entity.EvaluateCandidateResultEntity;
-import org.springblade.modules.evaluate.vo.EvaluateCandidateResultVO;
-import org.springblade.modules.evaluate.excel.EvaluateCandidateResultExcel;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.springblade.core.mp.base.BaseService;
+import org.springblade.modules.evaluate.entity.EvaluateCandidateResultEntity;
+import org.springblade.modules.evaluate.excel.DeptResultGroupExcel;
+import org.springblade.modules.evaluate.excel.EmployeeResultGroupExcel;
+import org.springblade.modules.evaluate.excel.EvaluateCandidateResultExcel;
+import org.springblade.modules.evaluate.vo.EvaluateCandidateResultVO;
+
import java.util.List;
/**
@@ -49,4 +52,8 @@
*/
List<EvaluateCandidateResultExcel> exportEvaluateCandidateResult(Wrapper<EvaluateCandidateResultEntity> queryWrapper);
+ List<DeptResultGroupExcel> exportDeptResultGroupExcel(Wrapper<EvaluateCandidateResultEntity> queryWrapper);
+
+ List<EmployeeResultGroupExcel> exportEmployeeResultGroupExcel(Wrapper<EvaluateCandidateResultEntity> queryWrapper);
+
}
diff --git a/src/main/java/org/springblade/modules/evaluate/service/impl/EvaluateCandidateResultServiceImpl.java b/src/main/java/org/springblade/modules/evaluate/service/impl/EvaluateCandidateResultServiceImpl.java
index ec85470..e096d42 100644
--- a/src/main/java/org/springblade/modules/evaluate/service/impl/EvaluateCandidateResultServiceImpl.java
+++ b/src/main/java/org/springblade/modules/evaluate/service/impl/EvaluateCandidateResultServiceImpl.java
@@ -17,6 +17,8 @@
package org.springblade.modules.evaluate.service.impl;
import org.springblade.modules.evaluate.entity.EvaluateCandidateResultEntity;
+import org.springblade.modules.evaluate.excel.DeptResultGroupExcel;
+import org.springblade.modules.evaluate.excel.EmployeeResultGroupExcel;
import org.springblade.modules.evaluate.vo.EvaluateCandidateResultVO;
import org.springblade.modules.evaluate.excel.EvaluateCandidateResultExcel;
import org.springblade.modules.evaluate.mapper.EvaluateCandidateResultMapper;
@@ -51,4 +53,21 @@
return evaluateCandidateResultList;
}
+ @Override
+ public List<DeptResultGroupExcel> exportDeptResultGroupExcel(Wrapper<EvaluateCandidateResultEntity> queryWrapper) {
+ List<DeptResultGroupExcel> deptResultGroupExcels = baseMapper.exportDeptResultGroupExcel(queryWrapper);
+ //evaluateCandidateResultList.forEach(evaluateCandidateResult -> {
+ // evaluateCandidateResult.setTypeName(DictCache.getValue(DictEnum.YES_NO, EvaluateCandidateResult.getType()));
+ //});
+ return deptResultGroupExcels;
+ }
+
+ @Override
+ public List<EmployeeResultGroupExcel> exportEmployeeResultGroupExcel(Wrapper<EvaluateCandidateResultEntity> queryWrapper) {
+ List<EmployeeResultGroupExcel> employeeResultGroupExcels = baseMapper.exportEmployeeResultGroupExcel(queryWrapper);
+ //evaluateCandidateResultList.forEach(evaluateCandidateResult -> {
+ // evaluateCandidateResult.setTypeName(DictCache.getValue(DictEnum.YES_NO, EvaluateCandidateResult.getType()));
+ //});
+ return employeeResultGroupExcels;
+ }
}
--
Gitblit v1.9.3