package com.doumee.core.utils;//package com.doumee.core.utils;
//
//import java.awt.image.BufferedImage;
//import java.io.ByteArrayOutputStream;
//import java.io.File;
//import java.io.FileOutputStream;
//import java.io.IOException;
//import java.net.URL;
//import java.util.stream.IntStream;
//import javax.imageio.ImageIO;
//import org.apache.poi.ss.usermodel.Cell;
//import org.apache.poi.ss.usermodel.Row;
//import org.apache.poi.ss.usermodel.Sheet;
//import org.apache.poi.ss.usermodel.Workbook;
//import org.apache.poi.ss.usermodel.WorkbookFactory;
//import org.apache.poi.xssf.usermodel.XSSFClientAnchor;
//import org.apache.poi.xssf.usermodel.XSSFDrawing;
//import org.apache.poi.xssf.usermodel.XSSFGraphicFrame;
//import org.apache.poi.xssf.usermodel.XSSFShape;
//import org.apache.poi.xssf.usermodel.XSSFSheet;
//import org.apache.poi.xssf.usermodel.XSSFWorkbook;
//import com.itextpdf.text.BaseColor;
//import com.itextpdf.text.Document;
//import com.itextpdf.text.DocumentException;
//import com.itextpdf.text.Element;
//import com.itextpdf.text.Font;
//import com.itextpdf.text.Image;
//import com.itextpdf.text.PageSize;
//import com.itextpdf.text.Paragraph;
//import com.itextpdf.text.pdf.PdfPCell;
//import com.itextpdf.text.pdf.PdfPTable;
//import com.itextpdf.text.pdf.PdfWriter;
//
//public class TestUtil {
//    public static void main(String[] args) {
//        try (Workbook workbook = WorkbookFactory.create(new File("example.xlsx"));
//            FileOutputStream fos = new FileOutputStream("example.pdf")) {
//            Document document = new Document(PageSize.A4, 50, 50, 50, 50);
//            PdfWriter writer = PdfWriter.getInstance(document, fos);
//            document.open();
//            for (Sheet sheet : workbook) {
//                PdfPTable table = new PdfPTable(sheet.getRow(0).getLastCellNum());
//                table.setHeaderRows(1);
//                table.setWidths(IntStream.range(0, sheet.getRow(0).getLastCellNum()).mapToDouble(i -> 1).toArray());
//                table.setWidthPercentage(100);
//                Paragraph title = new Paragraph(sheet.getSheetName(), new Font(BaseFont.createFont("STSong-Light", "UniGB-UCS2-H", BaseFont.NOT_EMBEDDED), 16, Font.BOLD));
//                title.setAlignment(Element.ALIGN_CENTER);
//                document.add(title);
//                sheet.forEach(row -> {
//                    IntStream.range(0, row.getLastCellNum()).forEach(i -> {
//                        Cell cell = row.getCell(i);
//                        PdfPCell pdfCell = null;
//                        try {
//                            pdfCell = new PdfPCell(new Paragraph(cell.getStringCellValue(), new Font(BaseFont.createFont("STSong-Light", "UniGB-UCS2-H", BaseFont.NOT_EMBEDDED), 12)));
//                        } catch (DocumentException e) {
//                            throw new RuntimeException(e);
//                        } catch (IOException e) {
//                            throw new RuntimeException(e);
//                        }
//                        pdfCell.setBorderWidth(1f);
//                        pdfCell.setBorderColor(BaseColor.BLACK);
//                        pdfCell.setPadding(5f);
//                        if (row.getRowNum() == 0) {
//                            pdfCell.setBackgroundColor(BaseColor.LIGHT_GRAY);
//                        }
//                        table.addCell(pdfCell);
//                        if (cell.getCellType() == CellType.BLANK || cell.getCellType() == CellType.FORMULA || cell.getCellType() == CellType.ERROR || cell.getCellType() == CellType.STRING && cell.getStringCellValue().trim().isEmpty() || cell.getCellType() == CellType.NUMERIC && cell.getNumericCellValue() == 0 || cell.getCellType() == CellType.BOOLEAN && !cell.getBooleanCellValue() || cell.getCellType() == CellType.STRING && cell.getStringCellValue().startsWith("#") || cell.getCellType() == CellType.FORMULA && cell.getCellFormula().startsWith("#") || cell.getCellType() == CellType.STRING && cell.getStringCellValue().startsWith("=") || cell.getCellType() == CellType.FORMULA && cell.getCellFormula().startsWith("=") || cell.getCellType() == CellType.STRING && cell.getStringCellValue().startsWith("@") || cell.getCellType() == CellType.FORMULA && cell.getCellFormula().startsWith("@") || cell.getCellType() == CellType.STRING && cell.getStringCellValue().startsWith("'") || cell.getCellType() == CellType.FORMULA && cell.getCellFormula().startsWith("'")) {
//                            return;
//                        }
//                        if (cell.getCellType() == CellType.STRING && cell.getStringCellValue().startsWith("http")) {
//                            try {
//                                BufferedImage image = ImageIO.read(new URL(cell.getStringCellValue()));
//                                if (image != null) {
//                                    addImageToTable(table, image);
//                                }
//                            } catch (Exception e) {
//                                e.printStackTrace();
//                            }
//                        } else {
//                            if (sheet instanceof XSSFSheet) {
//                                XSSFSheet xssfSheet = (XSSFSheet) sheet;
//                                XSSFDrawing drawing = xssfSheet.createDrawingPatriarch();
//                                for (XSSFShape shape : drawing.getShapes()) {
//                                    if (shape instanceof XSSFClientAnchor) {
//                                        XSSFClientAnchor anchor = (XSSFClientAnchor) shape.getAnchor();
//                                        if (anchor.getRow1() == cell.getRowIndex() && anchor.getCol1() == cell.getColumnIndex()) {
//                                            if (shape instanceof XSSFGraphicFrame) {
//                                                XSSFGraphicFrame frame = (XSSFGraphicFrame) shape;
//                                                BufferedImage image = frame.getGraphic().getBufferedImage();
//                                                try {
//                                                    addImageToTable(table, image);
//                                                } catch (Exception e) {
//                                                    throw new RuntimeException(e);
//                                                }
//                                            }
//                                        }
//                                    }
//                                }
//                            }
//                        }
//                    });
//                });
//                table.setSpacingBefore(20f);
//                table.setSpacingAfter(20f);
//                table.setKeepTogether(true);
//                document.add(table);
//            }
//            document.close();
//        } catch (Exception e) {
//            e.printStackTrace();
//        }
//    }
//
//    private static void addImageToTable(PdfPTable table, BufferedImage image) throws Exception {
//        ByteArrayOutputStream baos = new ByteArrayOutputStream();
//        ImageIO.write(image, "png", baos);
//        baos.flush();
//        byte[] imageData = baos.toByteArray();
//        baos.close();
//        Image pdfImage = Image.getInstance(imageData);
//        pdfImage.scaleToFit(100f, 100f);
//        PdfPCell imageCell = new PdfPCell(pdfImage, true);
//        imageCell.setBorderWidth(1f);
//        imageCell.setBorderColor(BaseColor.BLACK);
//        imageCell.setPadding(5f);
//        table.addCell(imageCell);
//    }
//}