/*
|
* 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.controller;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport;
|
import io.swagger.annotations.Api;
|
import io.swagger.annotations.ApiOperation;
|
import io.swagger.annotations.ApiParam;
|
import lombok.AllArgsConstructor;
|
import org.springblade.core.boot.ctrl.BladeController;
|
import org.springblade.core.excel.util.ExcelUtil;
|
import org.springblade.core.mp.support.Condition;
|
import org.springblade.core.mp.support.Query;
|
import org.springblade.core.secure.BladeUser;
|
import org.springblade.core.tool.api.R;
|
import org.springblade.core.tool.constant.BladeConstant;
|
import org.springblade.core.tool.utils.DateUtil;
|
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;
|
import org.springblade.modules.evaluate.vo.EvaluateCandidateResultVO;
|
import org.springblade.modules.evaluate.wrapper.EvaluateCandidateResultWrapper;
|
import org.springframework.web.bind.annotation.*;
|
import springfox.documentation.annotations.ApiIgnore;
|
|
import javax.servlet.http.HttpServletResponse;
|
import javax.validation.Valid;
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* 评优任务候选人投票结果表 控制器
|
*
|
* @author aix
|
* @since 2024-01-09
|
*/
|
@RestController
|
@AllArgsConstructor
|
@RequestMapping("evaluate/evaluateCandidateResult")
|
@Api(value = "评优任务候选人投票结果表", tags = "评优任务候选人投票结果表接口")
|
public class EvaluateCandidateResultController extends BladeController {
|
|
private final IEvaluateCandidateResultService evaluateCandidateResultService;
|
|
private final IEvaluateTaskService evaluateTaskService;
|
|
/**
|
* 评优任务候选人投票结果表 详情
|
*/
|
@GetMapping("/detail")
|
@ApiOperationSupport(order = 1)
|
@ApiOperation(value = "详情", notes = "传入evaluateCandidateResult")
|
public R<EvaluateCandidateResultVO> detail(EvaluateCandidateResultEntity evaluateCandidateResult) {
|
EvaluateCandidateResultEntity detail = evaluateCandidateResultService.getOne(Condition.getQueryWrapper(evaluateCandidateResult));
|
return R.data(EvaluateCandidateResultWrapper.build().entityVO(detail));
|
}
|
/**
|
* 评优任务候选人投票结果表 分页
|
*/
|
@GetMapping("/list")
|
@ApiOperationSupport(order = 2)
|
@ApiOperation(value = "分页", notes = "传入evaluateCandidateResult")
|
public R<IPage<EvaluateCandidateResultVO>> list(@ApiIgnore @RequestParam Map<String, Object> evaluateCandidateResult, Query query) {
|
IPage<EvaluateCandidateResultEntity> pages = evaluateCandidateResultService.page(Condition.getPage(query), Condition.getQueryWrapper(evaluateCandidateResult, EvaluateCandidateResultEntity.class));
|
return R.data(EvaluateCandidateResultWrapper.build().pageVO(pages));
|
}
|
|
/**
|
* 公司投票和部门投票根据用户或者部门汇总
|
* @param evaluateCandidateResult
|
* @param query
|
* @return
|
*/
|
@GetMapping("/listByCategoryId")
|
@ApiOperationSupport(order = 2)
|
@ApiOperation(value = "分页", notes = "传入evaluateCandidateResult")
|
public R listByCategoryId(EvaluateCandidateResultEntity evaluateCandidateResult,Query query) {
|
QueryWrapper queryWrapper = new QueryWrapper();
|
|
EvaluateTaskEntity taskEntity = evaluateTaskService.getById(evaluateCandidateResult.getEvaluateTaskId());
|
if (taskEntity.getType() == 0) {
|
queryWrapper.eq("evaluate_task_category_id", evaluateCandidateResult.getEvaluateTaskCategoryId());
|
queryWrapper.groupBy("user_id");
|
} else {
|
queryWrapper.groupBy("dept_id");
|
}
|
|
if (null != evaluateCandidateResult.getEvaluateTaskId())
|
queryWrapper.eq("evaluate_task_id", evaluateCandidateResult.getEvaluateTaskId());
|
|
queryWrapper.select("*,count(*) voteNum");
|
|
queryWrapper.orderByDesc("count(*)");
|
|
return R.data(evaluateCandidateResultService.pageMaps(Condition.getPage(query), queryWrapper));
|
}
|
|
/**
|
* 评优任务候选人投票结果表 自定义分页
|
*/
|
@GetMapping("/page")
|
@ApiOperationSupport(order = 3)
|
@ApiOperation(value = "分页", notes = "传入evaluateCandidateResult")
|
public R<IPage<EvaluateCandidateResultVO>> page(EvaluateCandidateResultVO evaluateCandidateResult, Query query) {
|
IPage<EvaluateCandidateResultVO> pages = evaluateCandidateResultService.selectEvaluateCandidateResultPage(Condition.getPage(query), evaluateCandidateResult);
|
return R.data(pages);
|
}
|
|
/**
|
* 公司投票详情集合 分页
|
* @param evaluateTaskReferrer
|
* @param query
|
* @return
|
*/
|
@GetMapping("/resultList")
|
@ApiOperationSupport(order = 2)
|
@ApiOperation(value = "分页", notes = "传入evaluateTaskReferrer")
|
public R<IPage<EvaluateCandidateResultVO>> resultList(EvaluateCandidateResultVO evaluateTaskReferrer, Query query) {
|
IPage<EvaluateCandidateResultVO> pages = evaluateCandidateResultService.selectCandidateResultInfoPage(Condition.getPage(query), evaluateTaskReferrer);
|
return R.data(pages);
|
}
|
|
/**
|
* 评优任务候选人投票结果表 新增
|
*/
|
@PostMapping("/save")
|
@ApiOperationSupport(order = 4)
|
@ApiOperation(value = "新增", notes = "传入evaluateCandidateResult")
|
public R save(@Valid @RequestBody EvaluateCandidateResultEntity evaluateCandidateResult) {
|
return R.status(evaluateCandidateResultService.save(evaluateCandidateResult));
|
}
|
|
@PostMapping("/saveBatch")
|
@ApiOperationSupport(order = 4)
|
@ApiOperation(value = "新增", notes = "传入evaluateTaskCategory")
|
public R saveBatch(@Valid @RequestBody List<EvaluateCandidateResultEntity> evaluateTaskCategorys) {
|
return R.status(evaluateCandidateResultService.saveBatch(evaluateTaskCategorys));
|
}
|
|
/**
|
* 评优任务候选人投票结果表 修改
|
*/
|
@PostMapping("/update")
|
@ApiOperationSupport(order = 5)
|
@ApiOperation(value = "修改", notes = "传入evaluateCandidateResult")
|
public R update(@Valid @RequestBody EvaluateCandidateResultEntity evaluateCandidateResult) {
|
return R.status(evaluateCandidateResultService.updateById(evaluateCandidateResult));
|
}
|
|
/**
|
* 评优任务候选人投票结果表 新增或修改
|
*/
|
@PostMapping("/submit")
|
@ApiOperationSupport(order = 6)
|
@ApiOperation(value = "新增或修改", notes = "传入evaluateCandidateResult")
|
public R submit(@Valid @RequestBody EvaluateCandidateResultEntity evaluateCandidateResult) {
|
return R.status(evaluateCandidateResultService.saveOrUpdate(evaluateCandidateResult));
|
}
|
|
/**
|
* 评优任务候选人投票结果表 删除
|
*/
|
@PostMapping("/remove")
|
@ApiOperationSupport(order = 7)
|
@ApiOperation(value = "逻辑删除", notes = "传入ids")
|
public R remove(@ApiParam(value = "主键集合", required = true) @RequestParam String ids) {
|
return R.status(evaluateCandidateResultService.deleteLogic(Func.toLongList(ids)));
|
}
|
|
|
/**
|
* 导出数据
|
*/
|
@GetMapping("/export-evaluateCandidateResult")
|
@ApiOperationSupport(order = 9)
|
@ApiOperation(value = "导出数据", notes = "传入evaluateCandidateResult")
|
public void exportEvaluateCandidateResult(@ApiIgnore @RequestParam Map<String, Object> evaluateCandidateResult, BladeUser bladeUser, HttpServletResponse response) {
|
QueryWrapper<EvaluateCandidateResultEntity> queryWrapper = Condition.getQueryWrapper(evaluateCandidateResult, EvaluateCandidateResultEntity.class);
|
//if (!AuthUtil.isAdministrator()) {
|
// queryWrapper.lambda().eq(EvaluateCandidateResult::getTenantId, bladeUser.getTenantId());
|
//}
|
queryWrapper.lambda().eq(EvaluateCandidateResultEntity::getIsDeleted, BladeConstant.DB_NOT_DELETED);
|
List<EvaluateCandidateResultExcel> list = evaluateCandidateResultService.exportEvaluateCandidateResult(queryWrapper);
|
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.id,voteNUm");
|
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("evaluate_task_id", taskId);
|
queryWrapper.isNull("user_id");
|
queryWrapper.orderByDesc("voteNum");
|
queryWrapper.groupBy("dept_id");
|
List<DeptResultGroupExcel> list = evaluateCandidateResultService.exportDeptResultGroupExcel(queryWrapper);
|
ExcelUtil.export(response, "最终评优结果" + DateUtil.time(), "投票结果数据", list, DeptResultGroupExcel.class);
|
}
|
|
}
|
