package com.yuanchu.mom.controller; import com.alibaba.excel.EasyExcel; import com.alibaba.excel.write.style.HorizontalCellStyleStrategy; import com.alibaba.excel.write.style.column.LongestMatchColumnWidthStyleStrategy; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.yuanchu.mom.dto.PerformanceShiftAddDto; import com.yuanchu.mom.pojo.PerformanceShift; import com.yuanchu.mom.service.PerformanceShiftService; import com.yuanchu.mom.utils.StyleMonthUtils; import com.yuanchu.mom.utils.StyleYearUtils; import com.yuanchu.mom.vo.Result; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import javax.servlet.http.HttpServletResponse; import javax.validation.constraints.NotNull; import java.util.Collection; import java.util.List; import java.util.Map; /** *

* 绩效管理-班次 前端控制器 *

* * @author 江苏鵷雏网络科技有限公司 * @since 2024-05-08 09:12:04 */ @Api(tags = "绩效管理-班次") @RestController @RequestMapping("/performanceShift") public class PerformanceShiftController { @Autowired private PerformanceShiftService performanceShiftService; @ApiOperation(value = "绩效管理-班次-排班") @PostMapping("add") public Result performanceShiftAdd(@RequestBody PerformanceShiftAddDto performanceShiftAddDto) { performanceShiftService.performanceShiftAdd(performanceShiftAddDto); return Result.success(); } @ApiOperation(value = "绩效管理-班次-月份分页查询") @PostMapping("page") public Result performanceShiftPage(Integer size, Integer current, String time, String userName, String laboratory) { return Result.success(performanceShiftService.performanceShiftPage(new Page<>(current, size), time, userName, laboratory)); } @ApiOperation(value = "绩效管理-班次-年份分页查询") @PostMapping("pageYear") public Result performanceShiftPageYear(Integer size, Integer current, String time, String userName, String laboratory) { return Result.success(performanceShiftService.performanceShiftPageYear(new Page<>(current, size), time, userName, laboratory)); } @ApiOperation(value = "绩效管理-班次-班次状态修改") @PutMapping("update") public Result performanceShiftUpdate(@RequestBody PerformanceShift performanceShift) { performanceShiftService.performanceShiftUpdate(performanceShift); return Result.success(); } @ApiOperation(value = "绩效管理-班次-导出") @GetMapping("export") public void exportToExcel(@NotNull(message = "时间不能为空!") String time, String userName, String laboratory, Boolean isMonth, HttpServletResponse response) throws Exception { Map data; response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"); response.setHeader("requestType","excel"); response.setHeader("Access-Control-Expose-Headers", "requestType"); if (!isMonth) { data = performanceShiftService.exportToYearExcel(time, userName, laboratory); // 设置单元格样式 HorizontalCellStyleStrategy horizontalCellStyleStrategy = new HorizontalCellStyleStrategy(StyleYearUtils.getHeadStyle(), StyleYearUtils.getContentStyle()); // 保存到第一个sheet中 EasyExcel.write(response.getOutputStream()) .head((List>) data.get("header")) .registerWriteHandler(new LongestMatchColumnWidthStyleStrategy()) // 自适应列宽 .registerWriteHandler(horizontalCellStyleStrategy) .sheet("年度") .doWrite((Collection) data.get("data")); } else { data = performanceShiftService.exportToMonthExcel(time, userName, laboratory); // 设置单元格样式 HorizontalCellStyleStrategy horizontalCellStyleStrategy = new HorizontalCellStyleStrategy(StyleMonthUtils.getHeadStyle(), StyleMonthUtils.getContentStyle()); EasyExcel.write(response.getOutputStream()) .head((List>) data.get("header")) .registerWriteHandler(horizontalCellStyleStrategy) .sheet("月度") .doWrite((Collection) data.get("data")); } } }