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.nio.file.Files;
|
import java.text.SimpleDateFormat;
|
import java.util.List;
|
import org.apache.poi.ss.usermodel.ClientAnchor;
|
import org.apache.poi.ss.usermodel.Workbook;
|
import org.apache.poi.util.Units;
|
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 ReportAccess extends XLSX
|
{
|
private String language = null;
|
private AccessEnforcement_Detection detection = null;
|
private String format = null;
|
|
public ReportAccess(String language, String format, AccessEnforcement_Detection detection) throws Exception
|
{
|
this.language = language;
|
this.detection = detection;
|
this.format = format;
|
|
String filename = "data/" + Shared.getApplicationName() + "/templates/" + language + "/art.library.model.devices.gost.access.AccessEnforcement.xlsx";
|
File file = new File(filename);
|
if (file.exists() == false) file = Resources.getResourceFile(filename);
|
if (file.exists() == false) throw new ServerException(Shared.getMessage(language, "Template not found"));
|
workbook = new XSSFWorkbook(new FileInputStream(new File(filename)));
|
}
|
|
|
public byte[] generate() throws Exception
|
{
|
fill();
|
workbook.setForceFormulaRecalculation(true);
|
XSSFFormulaEvaluator.evaluateAllFormulaCells(workbook);
|
workbook.setActiveSheet(0);
|
workbook.setSelectedTab(0);
|
return saveAndClose(format);
|
}
|
|
|
private void fill() throws Exception
|
{
|
AccessEnforcement_Detection_State detectionState = detection.getLastState();
|
SimpleDateFormat formato1 = new SimpleDateFormat(Shared.getMessage(language, "dd/MM/yyyy"));
|
SimpleDateFormat formato2 = new SimpleDateFormat(Shared.getMessage(language, "HH:mm:ss"));
|
XSSFSheet xssfsheet = workbook.getSheetAt(0);
|
|
|
// Records
|
|
try
|
{
|
if (detectionState.processed != null)
|
{
|
getXSSFCell(xssfsheet, "I2").setCellValue(nonull(detectionState.processed.record));
|
getXSSFCell(xssfsheet, "B37").setCellValue(nonull(detectionState.processed.record));
|
getXSSFCell(xssfsheet, "J6").setCellValue(nonull(detectionState.processed.amount));
|
getXSSFCell(xssfsheet, "L6").setCellValue(nonull(detectionState.processed.points));
|
getXSSFCell(xssfsheet, "B13").setCellValue(nonull(detectionState.processed.description));
|
}
|
else if (detectionState.violation != null)
|
{
|
getXSSFCell(xssfsheet, "I2").setCellValue(nonull(detectionState.violation.record));
|
getXSSFCell(xssfsheet, "B37").setCellValue(nonull(detectionState.violation.record));
|
getXSSFCell(xssfsheet, "J6").setCellValue(nonull(detectionState.violation.amount));
|
getXSSFCell(xssfsheet, "L6").setCellValue(nonull(detectionState.violation.points));
|
getXSSFCell(xssfsheet, "B13").setCellValue(nonull(detectionState.violation.description));
|
}
|
}
|
catch (Exception exception)
|
{
|
exception.printStackTrace();
|
}
|
|
|
// Location
|
|
try
|
{
|
getXSSFCell(xssfsheet, "I3").setCellValue(formato1.format(detection.timestamp));
|
getXSSFCell(xssfsheet, "K3").setCellValue(formato2.format(detection.timestamp));
|
getXSSFCell(xssfsheet, "B10").setCellValue(nonull(detection.device.location));
|
getXSSFCell(xssfsheet, "H10").setCellValue(nonull(detection.device.kilometricPoint));
|
getXSSFCell(xssfsheet, "I10").setCellValue(nonull(detection.device.direction));
|
getXSSFCell(xssfsheet, "B17").setCellValue(nonull(detectionState.vehicle.getPlate()));
|
}
|
catch (Exception exception)
|
{
|
}
|
|
|
// ATEX5
|
|
try
|
{
|
getXSSFCell(xssfsheet, "H17").setCellValue(nonull(detectionState.vehicle.atex5.datosGenerales.descripcionVehiculo.tipoVehiculo.descripcion));
|
getXSSFCell(xssfsheet, "I17").setCellValue(nonull(detectionState.vehicle.atex5.datosGenerales.descripcionVehiculo.marca.descripcion + " " + detectionState.vehicle.atex5.datosGenerales.descripcionVehiculo.modelo));
|
|
if (detectionState.vehicle.atex5.datosGenerales.titular.datosPersona.personaFisica.idDocumento != null)
|
{
|
getXSSFCell(xssfsheet, "B21").setCellValue(nonull(detectionState.vehicle.atex5.datosGenerales.titular.datosPersona.personaFisica.idDocumento));
|
|
String nombre = detectionState.vehicle.atex5.datosGenerales.titular.datosPersona.personaFisica.nombre;
|
nombre = nombre + " " + detectionState.vehicle.atex5.datosGenerales.titular.datosPersona.personaFisica.apellido1;
|
nombre = nombre + " " + detectionState.vehicle.atex5.datosGenerales.titular.datosPersona.personaFisica.apellido2;
|
getXSSFCell(xssfsheet, "F21").setCellValue(nonull(nombre));
|
}
|
else if (detectionState.vehicle.atex5.datosGenerales.titular.datosPersona.personaJuridica.cif != null)
|
{
|
getXSSFCell(xssfsheet, "B21").setCellValue(nonull(detectionState.vehicle.atex5.datosGenerales.titular.datosPersona.personaJuridica.cif));
|
getXSSFCell(xssfsheet, "F21").setCellValue(nonull(detectionState.vehicle.atex5.datosGenerales.titular.datosPersona.personaJuridica.razonSocial));
|
}
|
|
getXSSFCell(xssfsheet, "D24").setCellValue(nonull(detectionState.vehicle.atex5.datosGenerales.titular.domicilio.municipio));
|
|
int codigoPostal = (int)detectionState.vehicle.atex5.datosGenerales.titular.domicilio.codPostal;
|
if (codigoPostal < 0) codigoPostal = codigoPostal & 0xFFFF;
|
String direccion = detectionState.vehicle.atex5.datosGenerales.titular.domicilio.calle.replaceAll("\\s{2,}", " ").replaceAll(" ,", ",").trim();
|
getXSSFCell(xssfsheet, "B23").setCellValue(nonull(direccion));
|
getXSSFCell(xssfsheet, "I24").setCellValue(nonull(String.format("%05d", codigoPostal)));
|
getXSSFCell(xssfsheet, "K24").setCellValue(nonull(detectionState.vehicle.atex5.datosGenerales.titular.domicilio.provincia.descripcion));
|
}
|
catch (Exception exception)
|
{
|
}
|
|
|
// Signature
|
|
try
|
{
|
|
String policeLicense = getPoliceLicense();
|
|
getXSSFCell(xssfsheet, "D33").setCellValue(nonull(policeLicense));
|
|
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;
|
|
int pictureNumber = 0;
|
|
for (int i=0; i<images.size(); i++)
|
{
|
if (images.get(i).name.indexOf(AccessEnforcement_Detection_Image.NAME_OVERVIEW) == 0)
|
{
|
XSSFDrawing drawing = xssfsheet.createDrawingPatriarch();
|
XSSFClientAnchor anchor = getAnchour(pictureNumber, images.size());
|
if (anchor != null)
|
{
|
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(images.get(i).data, Workbook.PICTURE_TYPE_JPEG));
|
pictureNumber = pictureNumber + 1;
|
}
|
}
|
}
|
|
for (int i=0; i<images.size(); i++)
|
{
|
if (images.get(i).name.indexOf(AccessEnforcement_Detection_Image.NAME_PLATE) == 0)
|
{
|
XSSFDrawing drawing = xssfsheet.createDrawingPatriarch();
|
XSSFClientAnchor anchor = getAnchour(pictureNumber, images.size());
|
if (anchor != null)
|
{
|
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(images.get(i).data, Workbook.PICTURE_TYPE_JPEG));
|
pictureNumber = pictureNumber + 1;
|
}
|
}
|
}
|
}
|
catch (Exception exception)
|
{
|
}
|
}
|
|
|
|
|
|
private XSSFClientAnchor getAnchour(int number, int total)
|
{
|
if (total == 1)
|
{
|
return new XSSFClientAnchor(0, 0, 0, 0, 1, 37, 19, 73);
|
}
|
else if (total <= 4)
|
{
|
switch (number)
|
{
|
case 0 : return new XSSFClientAnchor(0, 0, 0, 0, 1, 37, 12, 55);
|
case 1 : return new XSSFClientAnchor(0, 0, 0, 0, 12, 37, 19, 55);
|
case 2 : return new XSSFClientAnchor(0, 0, 0, 0, 1, 55, 12, 73);
|
case 3: return new XSSFClientAnchor(0, 0, 0, 0, 12, 55, 19, 73);
|
}
|
}
|
else
|
{
|
switch (number)
|
{
|
case 0 : return new XSSFClientAnchor(0, 0, 0, 0, 1, 37, 9, 49);
|
case 1 : return new XSSFClientAnchor(0, 0, 0, 0, 9, 37, 15, 49);
|
case 2 : return new XSSFClientAnchor(0, 0, 0, 0, 15, 37, 19, 49);
|
|
case 3 : return new XSSFClientAnchor(0, 0, 0, 0, 1, 49, 9, 61);
|
case 4 : return new XSSFClientAnchor(0, 0, 0, 0, 9, 49, 15, 61);
|
case 5 : return new XSSFClientAnchor(0, 0, 0, 0, 15, 49, 19, 61);
|
|
case 6 : return new XSSFClientAnchor(0, 0, 0, 0, 1, 61, 9, 73);
|
case 7 : return new XSSFClientAnchor(0, 0, 0, 0, 9, 61, 15, 73);
|
case 8 : return new XSSFClientAnchor(0, 0, 0, 0, 15, 61, 19, 73);
|
}
|
}
|
|
|
|
return null;
|
}
|
|
|
|
|
private String getPoliceLicense()
|
{
|
try
|
{
|
for (int i=detection.states.size()-1; i>=0; i--)
|
{
|
if ((detection.states.get(i).validation != null) && (detection.states.get(i).validation.policeLicense != null))
|
{
|
return detection.states.get(i).validation.policeLicense;
|
}
|
}
|
}
|
catch (Exception exception)
|
{
|
}
|
|
return null;
|
}
|
|
|
|
private String nonull(String value)
|
{
|
if (value == null) return "";
|
return value;
|
}
|
|
|
}
|
