抽取方法:生成二维码;下载excel文件

liuxm

2024-05-21 a816065c4c3bdbd353f5ad3020bb2848c6c55af0

抽取方法:生成二维码;下载excel文件

 pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/util/QrCodeUtil.java

New file
@@ -0,0 +1,63 @@
package com.dy.pmsGlobal.util;

import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.converters.Converter;
import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;
import com.dy.common.util.QrCodeGenerator;
import com.google.zxing.WriterException;
import jakarta.servlet.http.HttpServletResponse;
import lombok.extern.slf4j.Slf4j;
import org.springframework.core.io.ClassPathResource;

import java.awt.image.BufferedImage;
import java.io.File;
import java.io.IOException;
import java.net.URLEncoder;
import java.util.List;
import java.util.concurrent.ConcurrentHashMap;
@Slf4j
public class QrCodeUtil {
    private static final ConcurrentHashMap<String, File> logoCache = new ConcurrentHashMap<>();
    private static final String LOGO_PATH = "/images/logo.png";


    /**
     * 生成带Logo的二维码图片字节数组。
     * @param code 二维码内容
     * @return 二维码图片的字节数组
     * @throws IOException IO异常
     * @throws WriterException 二维码生成异常
     */
    public static byte[] genQrCode(String code) throws IOException, WriterException {
        File logoFile = logoCache.computeIfAbsent(LOGO_PATH, key -> {
            try {
                ClassPathResource resource = new ClassPathResource(key);
                return resource.getFile();
            } catch (IOException e) {
                throw new RuntimeException("加载Logo图片失败", e);
            }
        });

        BufferedImage qrCodeImage = QrCodeGenerator.toBufferedImage(QrCodeGenerator.createBitMatrix(code, QrCodeConstant.MarkQrCodeWidth, QrCodeConstant.MarkQrCodeHeight));
        if (logoFile != null) {
            qrCodeImage = QrCodeGenerator.addQrCodeLogo(qrCodeImage, logoFile);
        }
        return QrCodeGenerator.bufferedImageToByteArray(qrCodeImage, "JPEG");
    }

    public static void downloadExcel(HttpServletResponse response, String fileName, String sheetName, List<Converter> list){
        if(CollectionUtils.isEmpty(list)){
            return;
        }
        try{
            response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
            response.setCharacterEncoding("utf-8");
            fileName = URLEncoder.encode(fileName, "UTF-8").replaceAll("\\+", "%20");
            response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx");
            EasyExcel.write(response.getOutputStream(), list.get(0).getClass()).sheet(sheetName).doWrite(list);
            EasyExcel.write(response.getOutputStream(), Converter.class).sheet(sheetName).doWrite(list);
        }catch (Exception e){
            log.error("导出产品信息异常", e);
        }
    }
}

 pms-parent/pms-web-base/src/main/java/com/dy/pmsBase/MarkQrCode/MarkQrCodeCtrl.java

@@ -2,22 +2,17 @@


import cn.hutool.core.codec.Base64;
import com.alibaba.excel.EasyExcel;
import com.dy.common.util.QrCodeGenerator;
import com.alibaba.excel.converters.Converter;
import com.dy.common.webUtil.BaseResponse;
import com.dy.common.webUtil.BaseResponseUtils;
import com.dy.pmsGlobal.util.QrCodeConstant;
import com.dy.pmsGlobal.util.QrCodeUtil;
import jakarta.servlet.http.HttpServletResponse;
import lombok.extern.slf4j.Slf4j;
import org.springframework.core.io.ClassPathResource;
import org.springframework.core.io.Resource;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.awt.image.BufferedImage;
import java.io.File;
import java.net.URLEncoder;
import java.util.ArrayList;
import java.util.List;

@@ -41,20 +36,12 @@
    public BaseResponse<List<ResultVo>> show() {
        try{
            List<ResultVo> list = new ArrayList<>() ;
            Resource resource = new ClassPathResource("/images/logo.png");
            File logoPngFile = resource.getFile() ;
            String[][] marks = QrCodeConstant.Marks() ;
            for(String[] mark : marks){
                ResultVo vo = new ResultVo() ;
                vo.code = mark[0] ;
                vo.name = mark[1] ;
                //vo.code = "1234567890123456789012" ;
                //BufferedImage bufferedImage = QrCodeGenerator.toBufferedImage(QrCodeGenerator.createBitMatrix(vo.code, 30, 30));
                BufferedImage bufferedImage = QrCodeGenerator.toBufferedImage(QrCodeGenerator.createBitMatrix(vo.code, QrCodeConstant.MarkQrCodeWidth, QrCodeConstant.MarkQrCodeHeight));
                if(logoPngFile != null && logoPngFile.exists()){
                    bufferedImage = QrCodeGenerator.addQrCodeLogo(bufferedImage, logoPngFile);
                }
                byte[] codes = QrCodeGenerator.bufferedImageToByteArray(bufferedImage, "JPG");
                byte[] codes = QrCodeUtil.genQrCode(vo.code);
                vo.imgBase64 = "data:image/jpeg;base64," + Base64.encode(codes);
                list.add(vo) ;
            }
@@ -72,29 +59,16 @@
    @GetMapping(path = "download")
    public void download(HttpServletResponse response){
        try{
            // 这里注意 有同学反应使用swagger 会导致各种问题，请直接用浏览器或者用postman
            response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
            response.setCharacterEncoding("utf-8");
            // 这里URLEncoder.encode可以防止中文乱码 当然和easyexcel没有关系
            String fileName = URLEncoder.encode(MarkQrCodeCtrl.fileName, "UTF-8").replaceAll("\\+", "%20");
            response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx");

            List<ExcelVo> list = new ArrayList<>() ;
            Resource resource = new ClassPathResource("/images/logo.png");
            File logoPngFile = resource.getFile() ;
            List<Converter> list = new ArrayList<>() ;
            String[][] marks = QrCodeConstant.Marks() ;
            for(String[] mark : marks){
                ExcelVo vo = new ExcelVo() ;
                vo.code = mark[0] ;
                vo.name = mark[1] ;
                BufferedImage bufferedImage = QrCodeGenerator.toBufferedImage(QrCodeGenerator.createBitMatrix(vo.code, QrCodeConstant.MarkQrCodeWidth, QrCodeConstant.MarkQrCodeHeight));
                if(logoPngFile != null && logoPngFile.exists()){
                    bufferedImage = QrCodeGenerator.addQrCodeLogo(bufferedImage, logoPngFile);
                }
                vo.image = QrCodeGenerator.bufferedImageToByteArray(bufferedImage, "JPG");
                vo.image = QrCodeUtil.genQrCode(vo.code);
                list.add(vo) ;
            }
            EasyExcel.write(response.getOutputStream(), ExcelVo.class).sheet(MarkQrCodeCtrl.sheetName).doWrite(list);
            QrCodeUtil.downloadExcel(response, fileName, sheetName, list);
        }catch (Exception e){
            log.error("下载标识类二维码时异常", e);
        }