/* * 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 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> list(@ApiIgnore @RequestParam Map evaluateCandidateResult, Query query) { IPage 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> page(EvaluateCandidateResultVO evaluateCandidateResult, Query query) { IPage 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> resultList(EvaluateCandidateResultVO evaluateTaskReferrer, Query query) { IPage 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 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 evaluateCandidateResult, BladeUser bladeUser, HttpServletResponse response) { QueryWrapper 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 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.eq("a.is_deleted", 0); queryWrapper.orderByDesc("a.evaluate_task_category_id,a.dept_id,voteNum"); queryWrapper.groupBy("user_id"); List 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 list = evaluateCandidateResultService.exportDeptResultGroupExcel(queryWrapper); ExcelUtil.export(response, "最终评优结果" + DateUtil.time(), "投票结果数据", list, DeptResultGroupExcel.class); } }