package com.ruoyi.project.pssr.controller; import com.ruoyi.common.utils.DateUtils; import com.ruoyi.common.utils.StringUtils; import com.ruoyi.common.utils.file.ExcelUtils; import com.ruoyi.common.utils.poi.ExcelUtil; import com.ruoyi.framework.aspectj.lang.annotation.Log; import com.ruoyi.framework.aspectj.lang.enums.BusinessType; import com.ruoyi.framework.web.controller.BaseController; import com.ruoyi.framework.web.domain.AjaxResult; import com.ruoyi.framework.web.page.TableDataInfo; import com.ruoyi.project.pssr.domain.*; import com.ruoyi.project.pssr.mapper.TPssrMeasureMapper; import com.ruoyi.project.pssr.service.ITPssrApproveService; import com.ruoyi.project.pssr.service.ITPssrMeasureService; import com.ruoyi.project.pssr.service.ITPssrProtectionService; import com.ruoyi.project.pssr.service.ITPssrSubcontentService; import com.ruoyi.project.system.domain.SysUser; import com.ruoyi.project.system.service.ISysUserService; import org.activiti.engine.HistoryService; import org.activiti.engine.RuntimeService; import org.activiti.engine.impl.identity.Authentication; import org.activiti.engine.runtime.ProcessInstance; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.CellStyle; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.xssf.usermodel.XSSFSheet; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.security.access.prepost.PreAuthorize; import org.springframework.web.bind.annotation.*; import javax.annotation.Resource; import java.io.FileOutputStream; import java.io.IOException; import java.io.InputStream; import java.io.OutputStream; import java.util.*; /** * 人身防护Controller * * @author ssy * @date 2024-11-04 */ @RestController @RequestMapping("/pssr/measure") public class TPssrMeasureController extends BaseController { @Autowired private ITPssrMeasureService tPssrMeasureService; @Autowired private ITPssrProtectionService tPssrProtectionService; @Autowired private ITPssrApproveService tPssrApproveService; @Autowired private ITPssrSubcontentService tPssrSubcontentService; @Autowired private RuntimeService runtimeService; @Autowired private HistoryService historyService; @Resource private TPssrMeasureMapper tPssrMeasureMapper; @Autowired private ISysUserService sysUserService; /** * 查询人身防护列表 */ @PreAuthorize("@ss.hasPermi('pssr:measure:list')") @GetMapping("/list") public TableDataInfo list(TPssrMeasure tPssrMeasure) { startPage(); List list = tPssrMeasureService.selectTPssrMeasureList(tPssrMeasure); return getDataTable(list); } /** * 导出人身防护列表 */ @PreAuthorize("@ss.hasPermi('pssr:measure:export')") @Log(title = "人身防护", businessType = BusinessType.EXPORT) @GetMapping("/export") public AjaxResult export(TPssrMeasure tPssrMeasure) { List list = tPssrMeasureService.selectTPssrMeasureList(tPssrMeasure); return AjaxResult.success(exportTmpl(list)); } public String exportTmpl(List list) { OutputStream out = null; String filename = null; try { String tempUrl = "static/word/pssr/rsfh2.xlsx"; // 模板文件 InputStream is = null; is = Thread.currentThread().getContextClassLoader().getResourceAsStream(tempUrl); XSSFWorkbook wb = null; wb = new XSSFWorkbook(is); XSSFSheet sheet = wb.getSheetAt(0); //填充数据 int rowIndex = 4; int num = 1; Row originalRow = sheet.getRow(4); Cell originalcell = originalRow.getCell(0); // 获取单元格样式 CellStyle originalStyle = originalcell.getCellStyle(); for (TPssrMeasure t : list) { Row row = sheet.createRow(rowIndex); row.setHeight((short) 800); row.createCell(0).setCellValue(num); row.createCell(1).setCellValue(t.getDevNo()); row.createCell(2).setCellValue(t.getDevName()); row.createCell(3).setCellValue(t.getProMeasure()); row.createCell(4).setCellValue(t.getNoDamage()); row.createCell(5).setCellValue(t.getLocked()); row.createCell(6).setCellValue(t.getNoWorn()); row.createCell(7); row.createCell(8); try { SysUser sysUser1 = sysUserService.selectUserById(Long.valueOf(t.getConfirm1())); SysUser sysUser2 = sysUserService.selectUserById(Long.valueOf(t.getConfirm2())); String confirm1 = sysUser1.getSignUrl(); String confirm2 = sysUser2.getSignUrl(); ExcelUtils.insertPicture(wb, sheet, confirm1, row.getRowNum(), 7, 1, 1); ExcelUtils.insertPicture(wb, sheet, confirm2, row.getRowNum(), 8, 1, 1); } catch (NumberFormatException e) { throw new RuntimeException(e); } row.createCell(9).setCellValue(DateUtils.dateTime(t.getConfirmationDate())); row.createCell(10).setCellValue(t.getRemarks()); //渲染样式 for (int i = 0; i < 11; i++) { row.getCell(i).setCellStyle(originalStyle); } num++; rowIndex++; } filename = ExcelUtil.encodingFilename("Measure"); out = new FileOutputStream(ExcelUtil.getAbsoluteFile(filename)); wb.write(out); wb.close(); } catch (IOException e) { e.printStackTrace(); } return filename; } /** * 获取人身防护详细信息 */ @PreAuthorize("@ss.hasPermi('pssr:measure:query')") @GetMapping(value = "/{id}") public AjaxResult getInfo(@PathVariable("id") Long id) { return AjaxResult.success(tPssrMeasureService.selectTPssrMeasureById(id)); } /** * 新增人身防护 */ @PreAuthorize("@ss.hasPermi('pssr:measure:add')") @Log(title = "人身防护", businessType = BusinessType.INSERT) @PostMapping public AjaxResult add(@RequestBody TPssrMeasure tPssrMeasure) { tPssrMeasure.setApproveStatus(0L); tPssrMeasure.setCreaterCode(String.valueOf(getUserId())); tPssrMeasure.setCreatedate(new Date()); return toAjax(tPssrMeasureService.insertTPssrMeasure(tPssrMeasure)); } /** * 修改人身防护 */ @PreAuthorize("@ss.hasPermi('pssr:measure:edit')") @Log(title = "人身防护", businessType = BusinessType.UPDATE) @PutMapping public AjaxResult edit(@RequestBody TPssrMeasure tPssrMeasure) { return toAjax(tPssrMeasureService.updateTPssrMeasure(tPssrMeasure)); } /** * 修改人身防护 */ @PreAuthorize("@ss.hasPermi('pssr:measure:edit')") @Log(title = "人身防护", businessType = BusinessType.UPDATE) @PutMapping("editBatch") public AjaxResult editBatch(@RequestBody TPssrMeasure tPssrMeasure) { return toAjax(tPssrMeasureMapper.updateTPssrMeasureByIds(tPssrMeasure)); } /** * 删除人身防护 */ @PreAuthorize("@ss.hasPermi('pssr:measure:remove')") @Log(title = "人身防护", businessType = BusinessType.DELETE) @DeleteMapping("/{ids}") public AjaxResult remove(@PathVariable Long[] ids) { return toAjax(tPssrMeasureService.deleteTPssrMeasureByIds(ids)); } /** * 确认人身防护 */ @PreAuthorize("@ss.hasPermi('pssr:measure:edit')") @Log(title = "人身防护", businessType = BusinessType.UPDATE) @PutMapping("/confirmMeasure") public AjaxResult confirmMeasure(@RequestBody TPssrMeasure tPssrMeasure) { long queryStatus = 0; long approveStatus = 0; Date date = null; TPssrMeasure measure = new TPssrMeasure(); if (tPssrMeasure.getTaskType() == 4) { //确认人1确认 queryStatus = 1; approveStatus = 3; measure.setConfirm1(getUserId().toString()); date = new Date(); } else if (tPssrMeasure.getTaskType() == 5) { //确认人2确认 queryStatus = 3; approveStatus = 2; measure.setConfirm2(getUserId().toString()); date = new Date(); } if (tPssrMeasure.getIds() != null && tPssrMeasure.getIds().length > 0) { for (Long id : tPssrMeasure.getIds()) { measure = tPssrMeasureService.selectTPssrMeasureById(id); if (measure.getConfirmationDate() == null && tPssrMeasure.getTaskType() == 5) { measure.setConfirmationDate(new Date()); } measure.setApproveStatus(approveStatus); measure.setUpdatedate(new Date()); measure.setUpdaterCode(String.valueOf(getUserId())); tPssrMeasureService.updateTPssrMeasure(measure); } } else { measure.setSubId(tPssrMeasure.getSubId()); measure.setApproveStatus(queryStatus); for (TPssrMeasure item : tPssrMeasureService.selectTPssrMeasureList(measure)) { if (item.getConfirmationDate() == null && tPssrMeasure.getTaskType() == 5) { item.setConfirmationDate(new Date()); } item.setApproveStatus(approveStatus); item.setUpdatedate(new Date()); item.setUpdaterCode(String.valueOf(getUserId())); tPssrMeasureService.updateTPssrMeasure(item); } } //查询当前待审批的确认人 TPssrProtection entity = new TPssrProtection(); entity.setSubId(tPssrMeasure.getSubId()); entity.setApproveStatus(queryStatus); TPssrProtection Protection = tPssrProtectionService.selectAllConfirmedPersonBySubId(entity); if (Protection != null) { //如果当前用户还有待审批任务 if (tPssrMeasure.getTaskType() == 4 && StringUtils.isNotEmpty(Protection.getConfirm1())) { if (Protection.getConfirm1().contains(getUserId().toString())) { return AjaxResult.success(); } } if (tPssrMeasure.getTaskType() == 5 && StringUtils.isNotEmpty(Protection.getConfirm2())) { if (Protection.getConfirm2().contains(getUserId().toString())) { return AjaxResult.success(); } } } //无待审批任务结束当前用户流程 // 因为流程关系所以approve一定会有且只有一条数据 TPssrApprove tPssrApprove = tPssrApproveService.selectTPssrApproveBySubId(tPssrMeasure.getSubId()); TPssrApproveController.handleConfirmApprove(tPssrApprove, getUserId().toString()); return AjaxResult.success(); } /** * 驳回人身防护 */ @PutMapping("/turnDownMeasure") public AjaxResult turnDownMeasure(@RequestBody TPssrMeasure tPssrMeasure) { if (tPssrMeasure.getIds() != null) { String userId = getUserId().toString(); // 修改已选择数据的状态 for (Long id : tPssrMeasure.getIds()) { TPssrMeasure blind = new TPssrMeasure(); blind.setId(id); blind.setApproveStatus(1L); blind.setUpdatedate(new Date()); blind.setUpdaterCode(getUserId().toString()); tPssrMeasureService.updateTPssrMeasure(blind); } // 查询当前流程 TPssrApprove approve = tPssrApproveService.selectTPssrApproveBySubId(tPssrMeasure.getSubId()); try { runtimeService.deleteProcessInstance(approve.getProcessId(), "pssr2confirm"); historyService.deleteHistoricProcessInstance(approve.getProcessId()); } catch (Exception e) { logger.info("无运行时流程"); } // 驳回 查询所有待审批的人员 // 查询确认人 TPssrProtection entity = new TPssrProtection(); entity.setSubId(tPssrMeasure.getSubId()); entity.setApproveStatus(1L); TPssrProtection tPssrProtection = tPssrProtectionService.selectAllConfirmedPersonBySubId(entity); String confirmer1s = null; String confirmer2s = null; if (tPssrProtection != null) { confirmer1s = tPssrProtection.getConfirm1(); confirmer2s = tPssrProtection.getConfirm2(); } logger.info("=======================confirmer1s:{}", confirmer1s); logger.info("=======================confirmer2s:{}", confirmer2s); Set confirmerUsers1 = new HashSet<>(); Set confirmerUsers2 = new HashSet<>(); if (StringUtils.isNotEmpty(confirmer1s)) { confirmerUsers1.addAll(Arrays.asList(confirmer1s.split(","))); } if (StringUtils.isNotEmpty(confirmer2s)) { confirmerUsers2.addAll(Arrays.asList(confirmer2s.split(","))); } // 开始申请流程 long businessKey = approve.getApproveId(); //开始工作流、监听 Authentication.setAuthenticatedUserId(userId);//设置当前申请人 Map variables = new HashMap<>(); variables.put("applyUser", userId); variables.put("confirmUsers1", new ArrayList<>(confirmerUsers1)); variables.put("confirmUsers2", new ArrayList<>(confirmerUsers2)); variables.put("chargePerson", approve.getSubCharge()); //采用key来启动流程定义并设置流程变量,返回流程实例 ProcessInstance pi = runtimeService.startProcessInstanceByKey("pssr2confirm", String.valueOf(businessKey), variables); // 修改审批表和sub表 approve.setProcessId(pi.getProcessInstanceId()); approve.setApproveStatus(1L); approve.setUpdatedate(new Date()); approve.setUpdaterCode(getUserId().toString()); tPssrApproveService.updateTPssrApprove(approve); TPssrSubcontent subcontent = new TPssrSubcontent(); subcontent.setId(approve.getSubId()); subcontent.setApproveStatus(1L); subcontent.setUpdatedate(new Date()); subcontent.setUpdaterCode(getUserId().toString()); tPssrSubcontentService.updateTPssrSubcontent(subcontent); return AjaxResult.success(); } return AjaxResult.error(); } }