From da59bd81334e7b4ddeaaa401f27c5b93797fde46 Mon Sep 17 00:00:00 2001 From: zhuo <2089219845@qq.com> Date: 星期四, 20 二月 2025 10:36:18 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/dev' into dev --- cnas-manage/src/main/java/com/ruoyi/manage/controller/ManageRiskAssessmentResultsController.java | 132 ++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 132 insertions(+), 0 deletions(-) diff --git a/cnas-manage/src/main/java/com/ruoyi/manage/controller/ManageRiskAssessmentResultsController.java b/cnas-manage/src/main/java/com/ruoyi/manage/controller/ManageRiskAssessmentResultsController.java new file mode 100644 index 0000000..e71c7ec --- /dev/null +++ b/cnas-manage/src/main/java/com/ruoyi/manage/controller/ManageRiskAssessmentResultsController.java @@ -0,0 +1,132 @@ +package com.ruoyi.manage.controller; + +import com.alibaba.excel.EasyExcel; +import com.alibaba.excel.enums.CellExtraTypeEnum; +import com.alibaba.excel.read.listener.PageReadListener; +import com.baomidou.mybatisplus.core.metadata.IPage; +import com.baomidou.mybatisplus.core.toolkit.Wrappers; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.deepoove.poi.data.style.*; + + +import com.ruoyi.common.core.domain.Result; +import com.ruoyi.common.utils.SecurityUtils; +import com.ruoyi.framework.exception.ErrorException; +import com.ruoyi.manage.pojo.ManageRiskAssessmentResults; +import com.ruoyi.manage.service.ManageRiskAssessmentResultsService; +import com.ruoyi.manage.vo.ManageRiskAssessmentResultsVo; +import com.deepoove.poi.data.style.*; +import io.swagger.annotations.Api; +import io.swagger.annotations.ApiOperation; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.web.bind.annotation.*; +import org.springframework.web.multipart.MultipartFile; + +import javax.annotation.Resource; +import javax.servlet.http.HttpServletResponse; +import java.io.IOException; +import java.time.LocalDateTime; + +/** + * <p> + * 鍗遍櫓鍥犵礌杈ㄨ瘑涓庨闄╄瘎浠风粨鏋滀竴瑙堣〃 鍓嶇鎺у埗鍣� + * </p> + * + * @author 鑺杞欢锛堟睙鑻忥級鏈夐檺鍏徃 + * @since 2024-11-15 02:58:51 + */ +@Api(tags = "鍗遍櫓鍥犵礌杈ㄨ瘑涓庨闄╄瘎浠风粨鏋滀竴瑙堣〃") +@RestController +@RequestMapping("/manageRiskAssessmentResults") +public class ManageRiskAssessmentResultsController { + + @Autowired + + + @Resource + private ManageRiskAssessmentResultsService manageRiskAssessmentResultsService; + + @ApiOperation(value = "鍒嗛〉鏌ヨ") + @GetMapping("/getPageResults") + public Result<IPage<ManageRiskAssessmentResultsVo>> getPageResults(Page page) { + IPage<ManageRiskAssessmentResultsVo> ipage = manageRiskAssessmentResultsService.getPageResults(page); + return Result.success(ipage); + } + + @ApiOperation(value = "鎵瑰噯") + @GetMapping("/hazardIdentificationAndRiskApproval") + public Result<?> hazardIdentificationAndRiskApproval(Integer approve, Integer status) { + manageRiskAssessmentResultsService.update(Wrappers.<ManageRiskAssessmentResults>lambdaUpdate() + .set(ManageRiskAssessmentResults::getApprove, approve) + .set(ManageRiskAssessmentResults::getApproveStatus, status) + .set(ManageRiskAssessmentResults::getApproveDate, LocalDateTime.now())); + return Result.success(); + } + + @ApiOperation(value = "瀹℃壒") + @GetMapping("/dangerousRiskApproval") + public Result<?> dangerousRiskApproval(Integer approval, Integer status) { + manageRiskAssessmentResultsService.update(Wrappers.<ManageRiskAssessmentResults>lambdaUpdate() + .set(ManageRiskAssessmentResults::getApproval, approval) + .set(ManageRiskAssessmentResults::getApprovalStatus, status) + .set(ManageRiskAssessmentResults::getApprovalDate, LocalDateTime.now())); + return Result.success(); + } + + @ApiOperation(value = "瀵煎叆") + @PostMapping("/riskAssessmentImport") + public void riskAssessmentImport(MultipartFile file) throws IOException { + boolean excelFile = isExcelFile(file); + if (!excelFile) { + throw new ErrorException("璇峰鍏xcel鏂囦欢锛�"); + } + EasyExcel.read(file.getInputStream(), ManageRiskAssessmentResults.class, new PageReadListener<ManageRiskAssessmentResults>(dataList -> { + Integer userId = SecurityUtils.getUserId().intValue(); + dataList.forEach(i -> { + i.setEditor(userId); + i.setEditorDate(LocalDateTime.now()); + i.setApproveStatus(0); + i.setApprovalStatus(0); + }); + manageRiskAssessmentResultsService.saveOrUpdateBatch(dataList); + })).extraRead(CellExtraTypeEnum.MERGE).sheet().doRead(); + } + + @ApiOperation(value = "鏂板") + @PostMapping("/addNewRiskFactors") + public void addNewRiskFactors(@RequestBody ManageRiskAssessmentResults manageRiskAssessmentResults) { + Integer userId = SecurityUtils.getUserId().intValue(); + manageRiskAssessmentResults.setEditor(userId); + manageRiskAssessmentResults.setEditorDate(LocalDateTime.now()); + manageRiskAssessmentResultsService.saveOrUpdate(manageRiskAssessmentResults); + } + + @ApiOperation(value = "鍒犻櫎") + @GetMapping("/removeRiskFactors") + public void removeRiskFactors(Integer id) { + manageRiskAssessmentResultsService.removeById(id); + } + + + @ApiOperation(value = "瀵煎嚭鍗遍櫓鍥犵礌杈ㄨ瘑涓庨闄╄瘎浠风粨鏋滀竴瑙�") + @GetMapping("/exportHazardFactorIdentification") + public void exportPersonTraining(HttpServletResponse response){ + manageRiskAssessmentResultsService.exportPersonTraining(response); + } + + public static boolean isExcelFile(MultipartFile file) { + if (file.isEmpty()) { + return false; + } + String originalFilename = file.getOriginalFilename(); + if (originalFilename == null) { + return false; + } + String[] parts = originalFilename.split("\\."); + if (parts.length == 0) { + return false; + } + String fileExtension = parts[parts.length - 1].toLowerCase(); + return fileExtension.equals("xls") || fileExtension.equals("xlsx"); + } +} -- Gitblit v1.9.3