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