From 4f3a98f19143865cdc1de4791e8a95d96bd40c65 Mon Sep 17 00:00:00 2001 From: maven <2163098428@qq.com> Date: 星期五, 01 八月 2025 13:27:59 +0800 Subject: [PATCH] yys 密码已重置 --- cnas-manage/src/main/java/com/ruoyi/manage/service/impl/ManageDocumentCancelServiceImpl.java | 146 ++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 146 insertions(+), 0 deletions(-) diff --git a/cnas-manage/src/main/java/com/ruoyi/manage/service/impl/ManageDocumentCancelServiceImpl.java b/cnas-manage/src/main/java/com/ruoyi/manage/service/impl/ManageDocumentCancelServiceImpl.java new file mode 100644 index 0000000..a357293 --- /dev/null +++ b/cnas-manage/src/main/java/com/ruoyi/manage/service/impl/ManageDocumentCancelServiceImpl.java @@ -0,0 +1,146 @@ +package com.ruoyi.manage.service.impl; + +import com.alibaba.excel.EasyExcel; +import com.alibaba.excel.ExcelWriter; +import com.alibaba.excel.write.metadata.WriteSheet; +import com.alibaba.excel.write.style.column.LongestMatchColumnWidthStyleStrategy; +import com.baomidou.mybatisplus.core.metadata.IPage; +import com.baomidou.mybatisplus.core.toolkit.Wrappers; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import com.ruoyi.common.utils.QueryWrappers; +import com.ruoyi.system.mapper.UserMapper; + + +import com.ruoyi.manage.mapper.ManageDocumentCancelMapper; +import com.ruoyi.manage.mapper.ManageDocumentListMapper; +import com.ruoyi.manage.mapper.ManageRecordAuditMapper; +import com.ruoyi.manage.mapper.ManageRecordCheckMapper; +import com.ruoyi.manage.pojo.ManageDocumentCancel; +import com.ruoyi.manage.pojo.ManageDocumentList; +import com.ruoyi.manage.pojo.ManageRecordAudit; +import com.ruoyi.manage.pojo.ManageRecordCheck; +import com.ruoyi.manage.service.ManageDocumentCancelService; + +import org.springframework.stereotype.Service; +import org.springframework.transaction.annotation.Transactional; + +import javax.annotation.Resource; +import javax.servlet.http.HttpServletResponse; +import java.io.IOException; +import java.net.URLEncoder; +import java.util.HashMap; +import java.util.List; +import java.util.Map; + +/** + * <p> + * 鏂囦欢浣滃簾 鏈嶅姟瀹炵幇绫� + * </p> + * + * @author + * @since 2024-11-09 02:37:35 + */ +@Service +@Transactional(rollbackFor = Exception.class) +public class ManageDocumentCancelServiceImpl extends ServiceImpl<ManageDocumentCancelMapper, ManageDocumentCancel> implements ManageDocumentCancelService { + + @Resource + private ManageDocumentCancelMapper manageDocumentCancelMapper; + + @Resource + private ManageRecordCheckMapper manageRecordCheckMapper; + + @Resource + private ManageRecordAuditMapper manageRecordAuditMapper; + + + + @Resource + private ManageDocumentListMapper manageDocumentListMapper; + + @Resource + private UserMapper userMapper; + + @Override + public IPage<ManageDocumentCancel> pageManageDocumentCancel(Page page, ManageDocumentCancel manageDocumentCancel) { + return manageDocumentCancelMapper.pageManageDocumentCancel(page, QueryWrappers.queryWrappers(manageDocumentCancel)); + } + + @Override + public int addManageDocumentCancel(ManageDocumentCancel manageDocumentCancel) { + manageDocumentCancel.setState("寰呭鏍�"); + /*鏂板8.4鐨勬枃浠朵慨璁㈢敵璇峰鎵硅褰�*/ + ManageRecordAudit manageRecordAudit = new ManageRecordAudit(); + manageRecordAudit.setDocumentCode(manageDocumentCancel.getDocumentCode()); + manageRecordAudit.setDocumentName(manageDocumentCancel.getName()); + manageRecordAudit.setAlterThing("浣滃簾"); + manageRecordAudit.setMethod("浣滃簾"); + manageRecordAuditMapper.insert(manageRecordAudit); + return manageDocumentCancelMapper.insert(manageDocumentCancel); + } + + @Override + public int checkManageDocumentCancel(Integer id, String state) { + ManageDocumentCancel manageDocumentCancel = manageDocumentCancelMapper.selectById(id); + if (state.equals("閫氳繃")){ + //鍒犻櫎鏂囦欢娓呭崟瀵瑰簲鏁版嵁 + manageDocumentListMapper.delete(Wrappers.<ManageDocumentList>lambdaQuery().eq(ManageDocumentList::getDocumentCode,manageDocumentCancel.getDocumentCode())); + } + manageDocumentCancel.setState(state); + /*鏂板8.4鐨勬枃浠跺鎵硅褰�*/ + ManageRecordCheck manageRecordCheck = new ManageRecordCheck(); + manageRecordCheck.setDocumentCode(manageDocumentCancel.getDocumentCode()); + manageRecordCheck.setDocumentName(manageDocumentCancel.getName()); + manageRecordCheck.setDocumentVersion(manageDocumentCancel.getVersion()); + manageRecordCheck.setWriteUser(manageDocumentCancel.getCreateUser()); + manageRecordCheck.setCheckUser(manageDocumentCancel.getCheckUser()); + manageRecordCheck.setCheckState(manageDocumentCancel.getState()); + manageRecordCheck.setRemark(manageDocumentCancel.getCancelNote()); + manageRecordCheckMapper.insert(manageRecordCheck); + return manageDocumentCancelMapper.updateById(manageDocumentCancel); + } + + @Override + public ManageDocumentCancel getManageDocumentCancel(Integer id) { + ManageDocumentCancel manageDocumentCancel = manageDocumentCancelMapper.getManageDocumentCancel(id); + String limsName = userMapper.selectUserDepartmentLimsName(manageDocumentCancel.getCreateUser()); + manageDocumentCancel.setCreateUserDepartLims(limsName); + return manageDocumentCancel; + } + + @Override + public void exportManageDocumentCancel(ManageDocumentCancel manageDocumentCancel, HttpServletResponse response) throws Exception{ + List<ManageDocumentCancel> data = manageDocumentCancelMapper.pageManageDocumentCancel(new Page(-1, -1), QueryWrappers.queryWrappers(manageDocumentCancel)).getRecords(); + response.setContentType("application/vnd.ms-excel"); + response.setCharacterEncoding("UTF-8"); + String fileName = URLEncoder.encode("鏂囦欢浣滃簾鍒楄〃瀵煎嚭", "UTF-8"); + response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx"); + try { + // 鏂板缓ExcelWriter + ExcelWriter excelWriter = EasyExcel.write(response.getOutputStream()).registerWriteHandler(new LongestMatchColumnWidthStyleStrategy()).build(); + WriteSheet mainSheet = EasyExcel.writerSheet(0, "鏂囦欢浣滃簾鍒楄〃瀵煎嚭").head(ManageDocumentCancel.class).build(); + excelWriter.write(data, mainSheet); + // 鍏抽棴娴� + excelWriter.finish(); + } catch (IOException e) { + throw new RuntimeException("瀵煎嚭澶辫触"); + } + } + + @Override + public int delManageDocumentCancel(Integer id) { + ManageDocumentCancel manageDocumentCancel = manageDocumentCancelMapper.selectById(id); + /*鍒犻櫎8.4鐨勬枃浠朵慨璁㈢敵璇峰鎵硅褰�*/ + manageRecordAuditMapper.delete(Wrappers.<ManageRecordAudit>lambdaQuery() + .eq(ManageRecordAudit::getDocumentCode,manageDocumentCancel.getDocumentCode()) + .eq(ManageRecordAudit::getDocumentName,manageDocumentCancel.getName()) + .eq(ManageRecordAudit::getMethod,"浣滃簾")); + return manageDocumentCancelMapper.deleteById(id); + } + + @Override + public int doManageDocumentCancel(ManageDocumentCancel manageDocumentCancel) { + return manageDocumentCancelMapper.updateById(manageDocumentCancel); + } +} -- Gitblit v1.9.3