|  |  | 
 |  |  | package com.dy.pmsGlobal.util; | 
 |  |  |  | 
 |  |  | import cn.hutool.core.codec.Base64; | 
 |  |  | import com.alibaba.excel.EasyExcel; | 
 |  |  | import com.alibaba.excel.converters.Converter; | 
 |  |  | import com.baomidou.mybatisplus.core.toolkit.CollectionUtils; | 
 |  |  | 
 |  |  |         return QrCodeGenerator.bufferedImageToByteArray(qrCodeImage, "JPEG"); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     public static String genQrCodeString(String code){ | 
 |  |  |         try { | 
 |  |  |             byte[] codes = QrCodeUtil.genQrCode(code); | 
 |  |  |             return "data:image/jpeg;base64," + Base64.encode(codes); | 
 |  |  |         } catch (IOException e) { | 
 |  |  |             e.printStackTrace(); | 
 |  |  |         } catch (WriterException e) { | 
 |  |  |             e.printStackTrace(); | 
 |  |  |         } | 
 |  |  |         return ""; | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |     public static void downloadExcel(HttpServletResponse response, String fileName, String sheetName, List<Converter> list){ | 
 |  |  |         if(CollectionUtils.isEmpty(list)){ | 
 |  |  |             return; | 
 |  |  | 
 |  |  |             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); | 
 |  |  |         } |