package art.servers.gost.access.reports;

import art.library.model.devices.gost.access.types.AccessEnforcement_Detection;
import art.library.model.devices.gost.access.types.AccessEnforcement_Detection_Image;
import art.library.model.devices.gost.access.types.AccessEnforcement_Detection_State;
import art.library.utils.resources.Resources;
import art.servers.ServerException;
import art.servers.Shared;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.List;
import java.util.Objects;
import java.util.Optional;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFClientAnchor;
import org.apache.poi.xssf.usermodel.XSSFDrawing;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;


public class ReportAccessZPR extends ReportAccess
{
    public ReportAccessZPR(String language, String format, AccessEnforcement_Detection detection) throws Exception
    {
        super(language, format, detection);
    }
    
    @Override
     public void loadTemplate(String language1) throws ServerException, IOException
    {
        String filename = "data/" + Shared.getApplicationName() + "/templates/" + language1 + "/art.library.model.devices.gost.access.AccessEnforcement-ZPR.xlsx";
        File file = new File(filename);
        if (file.exists() == false) file = Resources.getResourceFile(filename);
        if (file.exists() == false)
        {
            throw new ServerException(Shared.getMessage(language1, "Template not found"));
        }
        workbook = new XSSFWorkbook(new FileInputStream(new File(filename)));
    }
    
    @Override
    protected void fill() throws Exception
    {
        AccessEnforcement_Detection_State detectionState = detection.getLastState();
        SimpleDateFormat formato1 = new SimpleDateFormat("dd/MM/yyyy");
        SimpleDateFormat formato2 = new SimpleDateFormat(Shared.getMessage(language, "HH:mm:ss"));
        XSSFSheet xssfsheet = workbook.getSheetAt(0);

        // Records
        
        try
        {
            if (detection.zpr != null) 
            {
                if(detection.zpr.entryLocation != null)
                    getXSSFCell(xssfsheet, "B7").setCellValue(nonull(detection.zpr.entryLocation));
                if(detection.zpr.entryTimestamp != null )
                    getXSSFCell(xssfsheet, "B8").setCellValue(formato1.format(detection.zpr.entryTimestamp) + " " + formato2.format(detection.zpr.entryTimestamp));
                
                if(detection.zpr.exitLocation != null)
                    getXSSFCell(xssfsheet, "B9").setCellValue(nonull(detection.zpr.exitLocation));
                if(detection.zpr.exitTimestamp != null)
                    getXSSFCell(xssfsheet, "B10").setCellValue(formato1.format(detection.zpr.exitTimestamp) + " " + formato2.format(detection.zpr.exitTimestamp));
            }
            if(detectionState.violation != null)
            {
                try
                {
                    float amount = Float.parseFloat(detectionState.violation.amount);
                    float bonus = Float.parseFloat(detectionState.violation.bonus);
                    int points = Integer.parseInt(detectionState.violation.points);

                    getXSSFCell(xssfsheet, "E13").setCellValue(nonull(String.format("%.2f", amount)));
                    getXSSFCell(xssfsheet, "I13").setCellValue(nonull(String.format("%.2f", bonus)));
                    getXSSFCell(xssfsheet, "N13").setCellValue(nonull(String.valueOf(points)));
                }
                catch (Exception ex){}

                getXSSFCell(xssfsheet, "M2").setCellValue(nonull(detectionState.violation.record));
                getXSSFCell(xssfsheet, "A14").setCellValue(nonull(detectionState.violation.description));
                getXSSFCell(xssfsheet, "A13").setCellValue(nonull(detectionState.violation.LSV));
                getXSSFCell(xssfsheet, "C13").setCellValue(nonull(detectionState.violation.RGC));
                getXSSFCell(xssfsheet, "D13").setCellValue(nonull(detectionState.violation.type));
                getXSSFCell(xssfsheet, "O13").setCellValue(nonull(detectionState.violation.key));
            }
        }
        catch (Exception exception)
        {
            exception.printStackTrace();
        }
        
          // Location
        
        try
        {
            getXSSFCell(xssfsheet, "A5").setCellValue(formato1.format(detection.timestamp));
            getXSSFCell(xssfsheet, "F5").setCellValue(formato2.format(detection.timestamp));
            getXSSFCell(xssfsheet, "B18").setCellValue(nonull(detectionState.vehicle.getPlate()));
        }
        catch (Exception exception)
        {
        }
        
        // Signature
        
        // Pictures
        
        try
        {
            List<AccessEnforcement_Detection_Image> images = detection.images;
            
            Optional<byte[]> image1 = getImage(AccessEnforcement_Detection_Image.NAME_PLATE); 
            Optional<byte[]> image2 = getImage(AccessEnforcement_Detection_Image.NAME_OVERVIEW);
            
            if (image1.isPresent())
            {
                int pictureIndex = workbook.addPicture(image1.get(), Workbook.PICTURE_TYPE_PNG);

                XSSFDrawing drawing = (XSSFDrawing) xssfsheet.createDrawingPatriarch();

                XSSFClientAnchor anchor = new XSSFClientAnchor();
                anchor.setCol1(17);
                anchor.setRow1(6);
                anchor.setCol2(38);
                anchor.setRow2(14);

                drawing.createPicture(anchor, pictureIndex);
            }
        
            if (image2.isPresent())
            {
                int pictureIndex = workbook.addPicture(image2.get(), Workbook.PICTURE_TYPE_PNG);

                XSSFDrawing drawing = (XSSFDrawing) xssfsheet.createDrawingPatriarch();

                XSSFClientAnchor anchor = new XSSFClientAnchor();
                anchor.setCol1(17);
                anchor.setRow1(16);
                anchor.setCol2(38);
                anchor.setRow2(24);

                drawing.createPicture(anchor, pictureIndex);
            }

        }
        catch (Exception exception)
        {
        }
    }
    
    
    
    
    private Optional<byte[]> getImage(String imageName)
    {
        return detection.images.stream()
                .filter(Objects::nonNull)
                .filter(image -> image.name != null)
                .filter(image -> image.name.equals(imageName))
                .map(image -> image.data)
                .findAny();
    }
}