package art.servers.rtzserver.reports;

import art.client.GUI.components.devices.window.colors.rtz.configuration.RTZ32_PanelConfiguration_Programs;
import art.client.GUI.components.devices.window.colors.rtz.configuration.RTZ32_PanelConfiguration_Programs_Program;
import art.client.GUI.components.devices.window.colors.rtz.configuration.components.Diagram_Distribution_Bars;
import art.client.GUI.components.devices.window.colors.rtz.configuration.components.Diagram_Distribution_Impulses;
import art.client.configuration.Configuration;
import art.library.gui.flat.FlatPanel;
import art.library.gui.flat.FlatSplitPane;
import art.library.model.devices.colors.controller.RTZ32.RTZ32_Controller;
import art.library.model.devices.colors.controller.RTZ32.types.RTZ32_Report_Information;
import art.library.utils.resources.Resources;
import art.servers.ServerException;
import art.servers.rtzserver.Shared;
import java.awt.BorderLayout;
import java.awt.Component;
import java.awt.Dimension;
import java.awt.image.BufferedImage;
import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.text.SimpleDateFormat;
import javax.imageio.ImageIO;
import javax.swing.JComponent;
import javax.swing.JWindow;
import org.apache.poi.ss.usermodel.ClientAnchor;
import org.apache.poi.xssf.usermodel.XSSFClientAnchor;
import org.apache.poi.xssf.usermodel.XSSFDrawing;
import org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class Report_CCT_Juzgados extends XLSX
{
    public Report_CCT_Juzgados(String language) throws Exception
    {
        this.language = language;
    }


    public byte[] generateCCT(String format, RTZ32_Report_Information reportInformation, RTZ32_Controller device) throws ServerException
    {
        byte[] data = null;

        try
        {
            SimpleDateFormat sdfh = new SimpleDateFormat(Shared.getMessage(language, "dd/MM/yyyy HH:mm:ss"));
            String filename = "data/" + Shared.getApplicationName() + "/templates/template_CCT." + language + ".xlsx";
            File file = new File(filename);
            if (file.exists() == false) file = Resources.getResourceFile(filename);
            if (file.exists() == false) throw new ServerException("Template not found");
            workbook = new XSSFWorkbook(new FileInputStream(new File(filename)));

            XSSFSheet sheet = workbook.getSheetAt(0);
            sheet.getRow(2).getCell(1).setCellValue(device.getDeviceInformation().name);
            sheet.getRow(3).getCell(1).setCellValue(device.getDeviceInformation().location);
            sheet.getRow(4).getCell(1).setCellValue(reportInformation.program.program);
            sheet.getRow(5).getCell(1).setCellValue(reportInformation.program.description);
            sheet.getRow(6).getCell(1).setCellValue(sdfh.format(reportInformation.program.creation));


            // Add images

            try
            {
                if (art.client.models.Shared.configuration == null)
                {
                    art.client.models.Shared.configuration = new Configuration();
                }
                art.client.models.Shared.configuration.general.language = language;
                art.client.models.Shared.configuration.lmessage = reportInformation.messages;

                RTZ32_PanelConfiguration_Programs panelConfiguration_Programs = new RTZ32_PanelConfiguration_Programs(reportInformation.program.configuration);
                RTZ32_PanelConfiguration_Programs_Program panelConfiguration_Programs_Program = (RTZ32_PanelConfiguration_Programs_Program)panelConfiguration_Programs.panelSelected;
                panelConfiguration_Programs_Program.reload();
                panelConfiguration_Programs_Program.panelConfiguration_Programs_Program_Distribution.reload();
                panelConfiguration_Programs_Program.panelConfiguration_Programs_Program_Distribution.reevaluate();
                Diagram_Distribution_Bars diagram_bars = panelConfiguration_Programs_Program.panelConfiguration_Programs_Program_Distribution.diagram_Distribution.diagram_Distribution_Bars;
                diagram_bars.setSize(new Dimension(1920, 1080));
                Diagram_Distribution_Impulses diagram_impulses = panelConfiguration_Programs_Program.panelConfiguration_Programs_Program_Distribution.diagram_Distribution.diagram_Distribution_Impulses;
                diagram_impulses.setSize(new Dimension(1920, 1080));
                FlatSplitPane splitPane = panelConfiguration_Programs_Program.panelConfiguration_Programs_Program_Distribution.diagram_Distribution.flatSplitPane1;
               
                // diagram_bars.reevaluate();
                diagram_bars.revalidate();

//                RTZ32_Distribution distribution = new RTZ32_Distribution(device.getDeviceConfiguration().rtz32, reportInformation.program.program);
//                Diagram_Distribution_Impulses diagram_Distribution_Impulses = new Diagram_Distribution_Impulses(device.getDeviceConfiguration().rtz32, reportInformation.program.program, distribution);

                BufferedImage image = getImage(diagram_bars, diagram_impulses, splitPane, diagram_bars.getWidth(), diagram_bars.getHeight(), 1000);
                ByteArrayOutputStream bos = new ByteArrayOutputStream();
                ImageIO.write(image, "png", bos);
                byte[] dataImage = bos.toByteArray();
                bos.close();
                image.flush();
                image = null;
                bos = null;

                XSSFDrawing drawing = sheet.createDrawingPatriarch();

                if (dataImage.length > 0)
                {
                    XSSFClientAnchor anchor = new XSSFClientAnchor(0, 0, 0, 0, 0, 10, 25, 90); 
                    anchor.setAnchorType(ClientAnchor.AnchorType.MOVE_AND_RESIZE); //0 = Move and size with Cells, 2 = Move but don't size with cells, 3 = Don't move or size with cells.
                    drawing.createPicture(anchor, workbook.addPicture(dataImage, workbook.PICTURE_TYPE_PNG));
                }
            }
            catch (Exception e)
            {
                Shared.printstack("Reports", e);
            }

            workbook.setForceFormulaRecalculation(true);
            XSSFFormulaEvaluator.evaluateAllFormulaCells(workbook);
            return saveAndClose(format);
        }
        catch (ServerException e)
        {
            throw e;
        }
        catch (Exception e)
        {
            throw new ServerException(e);
        }
    }


    public byte[] generateJuzgados(String format, RTZ32_Report_Information reportInformation, RTZ32_Controller device) throws ServerException
    {
        byte[] data = null;

        try
        {
            String filename = "data/" + Shared.getApplicationName() + "/templates/template_Juzgados." + language + ".xlsx";
            File file = new File(filename);
            if (file.exists() == false) file = Resources.getResourceFile(filename);
            if (file.exists() == false) throw new ServerException("Template not found");
            workbook = new XSSFWorkbook(new FileInputStream(new File(filename)));

            XSSFSheet sheet = workbook.getSheetAt(0);
            sheet.getRow(2).getCell(1).setCellValue(device.getDeviceInformation().name);
            sheet.getRow(3).getCell(1).setCellValue(device.getDeviceInformation().location);
            sheet.getRow(4).getCell(1).setCellValue(reportInformation.program.program);


            // Add images

            try
            {
                if (art.client.models.Shared.configuration == null)
                {
                    art.client.models.Shared.configuration = new Configuration();
                }
                art.client.models.Shared.configuration.general.language = language;
                art.client.models.Shared.configuration.lmessage = reportInformation.messages;

                RTZ32_PanelConfiguration_Programs panelConfiguration_Programs = new RTZ32_PanelConfiguration_Programs(reportInformation.program.configuration);
                RTZ32_PanelConfiguration_Programs_Program panelConfiguration_Programs_Program = (RTZ32_PanelConfiguration_Programs_Program)panelConfiguration_Programs.panelSelected;
                panelConfiguration_Programs_Program.reload();
                panelConfiguration_Programs_Program.panelConfiguration_Programs_Program_Distribution.reload();
                panelConfiguration_Programs_Program.panelConfiguration_Programs_Program_Distribution.reevaluate();
                Diagram_Distribution_Bars diagram_bars = panelConfiguration_Programs_Program.panelConfiguration_Programs_Program_Distribution.diagram_Distribution.diagram_Distribution_Bars;
                diagram_bars.setSize(new Dimension(1920, 1080));
                Diagram_Distribution_Impulses diagram_impulses = panelConfiguration_Programs_Program.panelConfiguration_Programs_Program_Distribution.diagram_Distribution.diagram_Distribution_Impulses;
                diagram_impulses.setSize(new Dimension(1920, 1080));
                FlatSplitPane splitPane = panelConfiguration_Programs_Program.panelConfiguration_Programs_Program_Distribution.diagram_Distribution.flatSplitPane1;
                // diagram_bars.reevaluate();
                diagram_bars.revalidate();

                BufferedImage image = getImage(diagram_bars, diagram_impulses,splitPane, diagram_bars.getWidth(), diagram_bars.getHeight(), 1000);
                ByteArrayOutputStream bos = new ByteArrayOutputStream();
                ImageIO.write(image, "png", bos);
                byte[] dataImage = bos.toByteArray();
                bos.close();
                image.flush();
                image = null;
                bos = null;

                XSSFDrawing drawing = sheet.createDrawingPatriarch();

                if (dataImage.length > 0)
                {
                    XSSFClientAnchor anchor = new XSSFClientAnchor(0, 0, 0, 0, 0, 8, 25, 88); 
                    anchor.setAnchorType(ClientAnchor.AnchorType.MOVE_AND_RESIZE); //0 = Move and size with Cells, 2 = Move but don't size with cells, 3 = Don't move or size with cells.
                    drawing.createPicture(anchor, workbook.addPicture(dataImage, workbook.PICTURE_TYPE_PNG));
                }
            }
            catch (Exception e)
            {
                Shared.printstack("Reports", e);
            }

            workbook.setForceFormulaRecalculation(true);
            XSSFFormulaEvaluator.evaluateAllFormulaCells(workbook);
            return saveAndClose(format);
        }
        catch (ServerException e)
        {
            throw e;
        }
        catch (Exception e)
        {
            throw new ServerException(e);
        }
    }


      private BufferedImage getImage(Diagram_Distribution_Bars componentDiagram, Diagram_Distribution_Impulses componentImpulses, FlatSplitPane splitPane, int width, int height, int sleep)
    {
        JWindow window = new JWindow();

        try
        {
            FlatPanel mainPanel = new FlatPanel();
            {
                
                FlatPanel panelCenter = new FlatPanel();
                {
                    panelCenter.setLayout(new BorderLayout());
                    panelCenter.add(componentDiagram,BorderLayout.CENTER);
                    
                    panelCenter.setRaisedBorder(0,0,0,1);
                }
                
                FlatPanel panelWest = new FlatPanel();
                {
                    FlatPanel panelSpacing = new FlatPanel();
                    {
                        panelSpacing.setPreferredSize(new Dimension(0,0));
                    }
                    
                    Component headerComponent = JComponent.class.cast(splitPane.getRightComponent()).getComponents()[0];
                    {
                        headerComponent
                                .setPreferredSize(new Dimension(headerComponent.getPreferredSize().width,headerComponent.getPreferredSize().height + 6));
                    }
                    
                    panelWest.setLayout(new BorderLayout());
                    panelWest.add(headerComponent,BorderLayout.NORTH);
                    panelWest.add(componentImpulses,BorderLayout.CENTER);
                    panelWest.setPreferredSize(new Dimension((int)(width * .2f),1080));
                    panelWest.setRaisedBorder(0,1,0,0);
                }

                mainPanel.setLayout(new BorderLayout());
                mainPanel.add(panelCenter, BorderLayout.CENTER);
                mainPanel.add(panelWest, BorderLayout.EAST);
            }
            componentImpulses.forceCalculatedHeight((double)componentDiagram.diagram_Distribution_Bars_Header_Groups.getCalculatedHeight());
            window.setContentPane(mainPanel);
            window.setSize(new Dimension(width,height));
            window.setLocation(-99999,-99999);
            BufferedImage image = new BufferedImage(width, height, BufferedImage.TYPE_INT_ARGB);
            window.setVisible(true);
            
            mainPanel.revalidate();
            mainPanel.repaint();
            if (sleep > 0) 
            {
                try
                {
                    Thread.sleep(sleep);
                }
                catch (Exception e)
                {
                }
            }
            mainPanel.paint(image.getGraphics());
            return image;
        }
        finally
        {
            window.setVisible(false);
            window.dispose();
        }
    }    


}