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 ReportAccessVPV extends ReportAccess
|
{
|
public ReportAccessVPV(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-VPV.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.vpv != null)
|
{
|
// getXSSFCell(xssfsheet, "M2").setCellValue(nonull(detection.vpv.record)); //TODO RECORD WHERE?
|
getXSSFCell(xssfsheet, "A12").setCellValue(nonull(detection.vpv.description));
|
getXSSFCell(xssfsheet, "A11").setCellValue(nonull(detection.vpv.LSV));
|
getXSSFCell(xssfsheet, "C11").setCellValue(nonull(detection.vpv.RGC));
|
getXSSFCell(xssfsheet, "D11").setCellValue(nonull(detection.vpv.type));
|
getXSSFCell(xssfsheet, "E11").setCellValue(nonull(detection.vpv.amount));
|
getXSSFCell(xssfsheet, "I11").setCellValue(nonull(detection.vpv.bonus));
|
getXSSFCell(xssfsheet, "N11").setCellValue(nonull(detection.vpv.points));
|
getXSSFCell(xssfsheet, "O11").setCellValue(nonull(detection.vpv.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, "B7").setCellValue(nonull(detection.device.location));
|
getXSSFCell(xssfsheet, "B8").setCellValue(nonull(detection.device.direction));
|
getXSSFCell(xssfsheet, "B16").setCellValue(nonull(detectionState.vehicle.getPlate()));
|
}
|
catch (Exception exception)
|
{
|
}
|
|
// Signature
|
|
try
|
{
|
|
String policeLicense = getPoliceLicense();
|
|
getXSSFCell(xssfsheet, "D22").setCellValue(nonull(policeLicense));
|
|
//TODO SIGNATURE?
|
//
|
// byte[] data = Files.readAllBytes(new File("data/" + Shared.getApplicationName() + "/templates/" + language + "/" + getPoliceLicense() + ".png").toPath());
|
// XSSFDrawing drawing = xssfsheet.createDrawingPatriarch();
|
// XSSFClientAnchor anchor = new XSSFClientAnchor(Units.EMU_PER_PIXEL,Units.EMU_PER_PIXEL, -Units.EMU_PER_PIXEL, -Units.EMU_PER_PIXEL, 1, 33, 5, 35);
|
// 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(data, Workbook.PICTURE_TYPE_JPEG));
|
}
|
catch (Exception exception)
|
{
|
}
|
|
// Pictures
|
|
try
|
{
|
List<AccessEnforcement_Detection_Image> images = detection.images;
|
|
Optional<byte[]> image1 = getImage(AccessEnforcement_Detection_Image.NAME_PLATE); //TODO GET IMAGE NAMES
|
Optional<byte[]> image2 = getImage(AccessEnforcement_Detection_Image.NAME_PLATE); //TODO GET IMAGE NAMES
|
|
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(1);
|
anchor.setCol2(39);
|
anchor.setRow2(11);
|
|
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(12);
|
anchor.setCol2(39);
|
anchor.setRow2(22);
|
|
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();
|
}
|
}
|
