lims项目框架修改优化--后端
blame | 历史 | 补丁 | 提交 | 提交对比 | 忽略空白
zhuo
2025-04-23 234b0ac195934b34c06045b2d2ef0f10e239dd8e 
 inspect-server/src/main/java/com/ruoyi/inspect/service/impl/InsReportServiceImpl.java


@@ -1,11 +1,17 @@


package com.ruoyi.inspect.service.impl;




import cn.hutool.core.collection.CollUtil;


import cn.hutool.core.util.StrUtil;


import cn.hutool.json.JSONUtil;


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.aspose.words.License;


import com.aspose.words.SaveFormat;


import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;


import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;


import com.baomidou.mybatisplus.core.metadata.IPage;


import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;


import com.baomidou.mybatisplus.core.toolkit.ObjectUtils;


import com.baomidou.mybatisplus.core.toolkit.StringUtils;


@@ -19,15 +25,18 @@


import com.itextpdf.text.pdf.PdfContentByte;


import com.itextpdf.text.pdf.PdfReader;


import com.itextpdf.text.pdf.PdfStamper;


import com.ruoyi.basic.dto.IfsInventoryQuantitySupplierDto;


import com.ruoyi.basic.mapper.IfsInventoryQuantityMapper;


import com.ruoyi.basic.pojo.IfsInventoryQuantity;


import com.ruoyi.common.constant.InsOrderTypeConstants;


import com.ruoyi.common.constant.MenuJumpPathConstants;


import com.ruoyi.common.core.domain.Result;


import com.ruoyi.common.core.domain.entity.InformationNotification;


import com.ruoyi.common.core.domain.entity.User;


import com.ruoyi.common.properties.WechatProperty;


import com.ruoyi.common.config.WechatProperty;


import com.ruoyi.common.utils.*;


import com.ruoyi.common.utils.api.IfsApiUtils;


import com.ruoyi.framework.exception.ErrorException;


import com.ruoyi.inspect.dto.InsReportExport;


import com.ruoyi.inspect.dto.ReportPageDto;


import com.ruoyi.inspect.mapper.*;


import com.ruoyi.inspect.pojo.*;


@@ -39,6 +48,7 @@


import lombok.extern.slf4j.Slf4j;


import org.apache.poi.xwpf.usermodel.*;


import org.springframework.beans.factory.annotation.Value;


import org.springframework.core.io.ClassPathResource;


import org.springframework.scheduling.concurrent.ThreadPoolTaskExecutor;


import org.springframework.stereotype.Service;


import org.springframework.transaction.annotation.Transactional;


@@ -46,8 +56,10 @@




import javax.annotation.Resource;


import javax.imageio.ImageIO;


import javax.servlet.http.HttpServletResponse;


import java.awt.image.BufferedImage;


import java.io.*;


import java.net.URLEncoder;


import java.nio.file.Files;


import java.nio.file.Path;


import java.nio.file.Paths;


@@ -83,8 +95,7 @@


    private String wordUrl;


    @Value("${file.path}")


    private String imgUrl;


    @Value("${file.licenseUrl}")


    private String licenseUrl;




    @Resource


    private InsOrderMapper insOrderMapper;


    @Resource


@@ -113,9 +124,11 @@


        // todo: 仅看自己


        //获取当前人所属实验室id


        String laboratory = null;


        Integer createOrderUser = null;




        Integer createOrderUser = reportPageDto.getCreateOrderUser();


        String queryStatus = reportPageDto.getQueryStatus();


        reportPageDto.setQueryStatus(null);


        reportPageDto.setCreateOrderUser(null);




        map.put("body", insReportMapper.pageInsReport(page,


                QueryWrappers.queryWrappers(reportPageDto),


@@ -187,7 +200,7 @@


        info.setSenderId(submitUserId);    //发送人


        info.setConsigneeId(userId);     //收件人


        info.setViewStatus(false);


        info.setJumpPath("b1-report-preparation");


        info.setJumpPath(MenuJumpPathConstants.REPORT_PREPARATION);


        informationNotificationService.addInformationNotification(info);


        //系统生成报告地址


        String url = insReport.getUrl();


@@ -259,7 +272,7 @@


                IfsInventoryQuantity ifsInventoryQuantity = ifsInventoryQuantityMapper.selectById(order.getIfsInventoryId());




                String message = "";


                message += "报告编制审核退回通知";


                message += "耐丝系统报告编制审核退回通知";


                message += "\n审核人: " + checkUserName;


                message += "\n委托编号: " + order.getEntrustCode();


                message += "\n样品名称: " + insSample.getModel();


@@ -308,7 +321,7 @@


        info.setSenderId(checkUserId);    //发送人


        info.setConsigneeId(userId);     //收件人


        info.setViewStatus(false);


        info.setJumpPath("b1-report-preparation");


        info.setJumpPath(MenuJumpPathConstants.REPORT_PREPARATION);


        informationNotificationService.addInformationNotification(info);


        //系统生成报告地址


        String url = insReport.getUrl();


@@ -334,7 +347,7 @@


            IfsInventoryQuantity ifsInventoryQuantity = ifsInventoryQuantityMapper.selectById(order.getIfsInventoryId());




            String message = "";


            message += "报告编制批准通知";


            message += "耐丝系统报告编制批准通知";


            message += "\n检验人: " + userName;


            message += "\n复核人: " + checkUserName;


            message += "\n委托编号: " + order.getEntrustCode();


@@ -396,7 +409,7 @@


                IfsInventoryQuantity ifsInventoryQuantity = ifsInventoryQuantityMapper.selectById(order.getIfsInventoryId());




                String message = "";


                message += "报告编制批准退回通知";


                message += "耐丝系统报告编制批准退回通知";


                message += "\n批准人: " + ratifyUserName;


                message += "\n委托编号: " + order.getEntrustCode();


                message += "\n样品名称: " + insSample.getModel();


@@ -537,6 +550,11 @@


            }


            // 压缩临时文件夹


            zipFilePath = wordUrl + "/zip/output.zip";


            // 判断zip路径是否存在


            File zipDir = new File(wordUrl + "/zip");


            if(!zipDir.isDirectory()){


                zipDir.mkdirs();


            }


            zipDirectory(tempFolderPath, zipFilePath);




            // 清理临时文件夹


@@ -676,7 +694,7 @@


        FileOutputStream os = null;


        try {


            //凭证 不然切换后有水印


            InputStream is = Files.newInputStream(new File(licenseUrl).toPath());


            InputStream is = new ClassPathResource("/lib/license.xml").getInputStream();


            License license = new License();


            license.setLicense(is);


            if (!license.getIsLicensed()) {


@@ -980,6 +998,46 @@


        return false;


    }




    /**


     * 报告报表导出


     * @param dto


     * @param response


     */


    @Override


    public void reportAllExport(ReportPageDto dto, HttpServletResponse response) throws UnsupportedEncodingException {




        Integer createOrderUser = dto.getCreateOrderUser();


        String queryStatus = dto.getQueryStatus();


        dto.setQueryStatus(null);


        dto.setCreateOrderUser(null);




        List<InsReportExport> insReportExports = insReportMapper.reportAllExport(QueryWrappers.queryWrappers(dto),


                SecurityUtils.getUserId().intValue(),


                queryStatus,


                createOrderUser);




        response.setContentType("application/vnd.ms-excel");


        response.setCharacterEncoding("UTF-8");


        // 这里URLEncoder.encode可以防止中文乱码 当然和easyexcel没有关系


        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();


            //获取sheet0对象


            WriteSheet mainSheet = EasyExcel.writerSheet(0, "报告报表导出").head(InsReportExport.class).build();




            //向sheet0写入数据 传入空list这样只导出表头


            excelWriter.write(insReportExports, mainSheet);


            //关闭流


            excelWriter.finish();


        } catch (IOException e) {


            throw new RuntimeException("导出失败");


        }






    }






    /**


     * 先修改采购订单批次号, 后进行移库操作


@@ -1115,7 +1173,7 @@


        FileOutputStream os = null;


        try {


            //凭证 不然切换后有水印


            InputStream is = Files.newInputStream(new File(licenseUrl).toPath());


            InputStream is = new ClassPathResource("/lib/license.xml").getInputStream();


            License license = new License();


            license.setLicense(is);


            if (!license.getIsLicensed()) {