String defaultBatchStatus = "";
JDBInterfaceLog il = new JDBInterfaceLog(getHostID(), getSessionID());
GenericMessageHeader gmh = new GenericMessageHeader();
JDBInterface inter = new JDBInterface(getHostID(), getSessionID());
JDBUom uoml = new JDBUom(getHostID(), getSessionID());
inter.getInterfaceProperties("Despatch Confirmation", "Output");
String device = inter.getDevice();
JDBDespatch desp = new JDBDespatch(getHostID(), getSessionID());
desp.setTransactionRef(transactionRef);
desp.getDespatchPropertiesFromTransactionRef();
String sourceGLN = JUtility.replaceNullStringwithBlank(desp.getLocationDBFrom().getGLN());
String destinationGLN = JUtility.replaceNullStringwithBlank(desp.getLocationDBTo().getGLN());
Boolean suppressMessage = false;
gmh.setMessageRef(desp.getTransactionRef().toString());
gmh.setInterfaceType(inter.getInterfaceType());
gmh.setMessageInformation("Despatch=" + desp.getDespatchNo());
gmh.setInterfaceDirection(inter.getInterfaceDirection());
gmh.setMessageDate(JUtility.getISOTimeStampStringFormat(JUtility.getSQLDateTime()));
if (sourceGLN.length() == 0)
{
setErrorMessage("Message Suppressed - No GLN Source (From) GLN for Location [" + desp.getLocationIDFrom() + "]");
suppressMessage = true;
}
if (destinationGLN.length() == 0)
{
setErrorMessage("Message Suppressed - No GLN Destination (To) GLN for Location [" + desp.getLocationIDTo() + "]");
suppressMessage = true;
}
if (suppressMessage == true)
{
result = true;
il.write(gmh, GenericMessageHeader.msgStatusWarning, getErrorMessage(), "File Write", "");
}
else
{
if (inter.getFormat().equals("EANCOM"))
{
if (sourceGLN.endsWith(""))
{
}
int segments = 0;
int optional = 0;
String document = "";
String despdateShort = new java.text.SimpleDateFormat("yyMMdd:HHmm").format(desp.getDespatchDate());
String despdateLong = new java.text.SimpleDateFormat("yyyyMMddHHmm").format(desp.getDespatchDate());
document = document + "UNA:+.? 'UNB+UNOA:3+" + desp.getLocationDBFrom().getGLN() + ":14+" + desp.getLocationDBTo().getGLN() + ":14+";
document = document + despdateShort + "+" + desp.getDespatchNo() + "'";
document = document + "UNH+" + desp.getDespatchNo() + "+DESADV:D:96A:EN:EAN005'";
document = document + "BGM+351+" + desp.getDespatchNo() + "+9'";
document = document + "DTM+11:" + despdateLong + ":203'";
document = document + "RFF+LO:" + desp.getDespatchNo() + "'";
document = document + "RFF+ZCO:'";
document = document + "RFF+ZAF:'";
document = document + "RFF+ZPI:1'";
document = document + "RFF+ZCH:'";
document = document + "NAD+SF+" + desp.getLocationDBFrom().getGLN() + "::9'";
if (desp.getLocationDBFrom().getStorageLocation().equals("") == false)
{
if (desp.getLocationDBTo().getStorageLocation().equals("") == false)
{
document = document + "LOC+198+" + desp.getLocationDBFrom().getStorageLocation() + "::91'";
optional++;
}
}
document = document + "NAD+ST+" + desp.getLocationDBTo().getGLN() + "::9'";
if (desp.getLocationDBFrom().getStorageLocation().equals("") == false)
{
if (desp.getLocationDBTo().getStorageLocation().equals("") == false)
{
document = document + "LOC+195+" + desp.getLocationDBTo().getStorageLocation() + "::91'";
optional++;
}
}
document = document + "TDT+20++30+31+::9:" + JUtility.stripEANCOMSpecialCharacters(JUtility.replaceNullStringwithBlank(desp.getHaulier())) + "+++:::" + JUtility.stripEANCOMSpecialCharacters(JUtility.replaceNullStringwithBlank(desp.getTrailer())) + "'";
document = document + "EQD+CN+123'";
document = document + "SEL+123+CA'";
segments = 13 + optional;
JDBPalletHistory palhist = new JDBPalletHistory(getHostID(), getSessionID());
ResultSet rs = palhist.getInterfacingData(transactionRef, "DESPATCH", "TO", Long.valueOf(0), "SSCC", "asc");
int x = 1;
try
{
rs.beforeFirst();
while (rs.next())
{
palhist.getPropertiesfromResultSet(rs);
document = document + "CPS+" + JUtility.padString(String.valueOf(x).trim(), false, 4, "0") + "'";
document = document + "PAC+1++202'";
document = document + "PCI+33E'";
document = document + "GIN+BJ+" + palhist.getPallet().getSSCC() + "'";
document = document + "LIN+1++" + palhist.getPallet().getEAN() + ":EN'";
document = document + "PIA+1+" + palhist.getPallet().getVariant() + ":PV+" + palhist.getPallet().getMaterial() + ":SA'";
NumberFormat formatter = new DecimalFormat("#.#");
String outqty = formatter.format(palhist.getPallet().getQuantity()); // -1234.567000
document = document + "QTY+12:" + outqty + ":" + palhist.getPallet().getUom() + "'";
document = document + "DLM+++0::9'";
String batchExpiryLong = new java.text.SimpleDateFormat("yyyyMMdd").format(palhist.getPallet().getMaterialBatchExpiryDate());
String dateOfManufactureLong = new java.text.SimpleDateFormat("yyyyMMdd").format(palhist.getPallet().getDateOfManufacture());
document = document + "DTM+361:" + batchExpiryLong + ":102'";
document = document + "DTM+94:" + dateOfManufactureLong + ":102'";
document = document + "RFF+AAJ:" + palhist.getPallet().getDespatchNo() + ":1'";
defaultBatchStatus = palhist.getPallet().getMaterialBatchStatus();
if (defaultBatchStatus.equals("Unrestricted"))
{
document = document + "RFF+ZBR:'";
}
else
{
document = document + "RFF+ZBR:B'";
}
document = document + "RFF+ZRB:'";
document = document + "RFF+ZSR:'";
document = document + "RFF+ZRC:'";
document = document + "RFF+ZRT:'";
document = document + "PCI+36E'";
document = document + "GIN+BX+" + palhist.getPallet().getBatchNumber() + "'";
segments = segments + 18;
x++;
}
rs.close();
segments = segments + 1;
document = document + "UNT+" + String.valueOf(segments).trim() + "+" + desp.getDespatchNo() + "'";
document = document + "UNZ+1+" + desp.getDespatchNo() + "'";
if (device.equals("Disk") | device.equals("Email"))
{
path = inter.getRealPath();
if (fio.writeToDisk(path, document, transactionRef, "_"+desp.getLocationIDTo().replace(" ", "_")+"_DespatchConfirmation.txt") == true)
{
result = true;
il.write(gmh, GenericMessageHeader.msgStatusSuccess, "Processed OK", "File Write", fio.getFilename());
setErrorMessage("");
if (device.equals("Email"))
{
ogm = new JeMailOutGoingMessage(inter,transactionRef,fio);
ogm.sendEmail();
}
}
else
{
result = false;
il.write(gmh, GenericMessageHeader.msgStatusError, fio.getErrorMessage(), "File Write", fio.getFilename());
setErrorMessage(fio.getErrorMessage());
}
}
}
catch (SQLException e)
{
}
}
if (inter.getFormat().equals("XML"))
{
try
{
DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();
DocumentBuilder builder = factory.newDocumentBuilder();
Document document = builder.newDocument();
Element message = (Element) document.createElement("message");
Element hostUniqueID = addElement(document, "hostRef", Common.hostList.getHost(getHostID()).getUniqueID());
message.appendChild(hostUniqueID);
Element messageRef = addElement(document, "messageRef", String.valueOf(transactionRef));
message.appendChild(messageRef);
Element messageType = addElement(document, "interfaceType", "Despatch Confirmation");
message.appendChild(messageType);
Element messageInformation = addElement(document, "messageInformation", "Despatch=" + desp.getDespatchNo());
message.appendChild(messageInformation);
Element messageDirection = addElement(document, "interfaceDirection", "Output");
message.appendChild(messageDirection);
Element messageDate = addElement(document, "messageDate", JUtility.getISOTimeStampStringFormat(JUtility.getSQLDateTime()));
message.appendChild(messageDate);
Element despatchConfirmation = (Element) document.createElement("despatchConfirmation");
Element noofpallets = addElement(document, "numberOfPallets", String.valueOf(desp.getTotalPallets()));
despatchConfirmation.appendChild(noofpallets);
Element haulier = addElement(document, "haulier", String.valueOf(JUtility.replaceNullStringwithBlank(desp.getHaulier())));
despatchConfirmation.appendChild(haulier);
Element trailer = addElement(document, "trailer", String.valueOf(JUtility.replaceNullStringwithBlank(desp.getTrailer())));
despatchConfirmation.appendChild(trailer);
Element despatch = addElement(document, "despatchNo", desp.getDespatchNo());
despatchConfirmation.appendChild(despatch);
Element despatchDate = addElement(document, "despatchDate", JUtility.getISOTimeStampStringFormat(desp.getDespatchDate()));
despatchConfirmation.appendChild(despatchDate);
Element locationFrom = addElement(document, "fromLocation", desp.getLocationIDFrom());
despatchConfirmation.appendChild(locationFrom);
Element locationFromPlant = addElement(document, "fromPlant", desp.getLocationDBFrom().getPlant());
despatchConfirmation.appendChild(locationFromPlant);
Element locationFromWarehouse = addElement(document, "fromWarehouse", desp.getLocationDBFrom().getWarehouse());
despatchConfirmation.appendChild(locationFromWarehouse);
Element locationFromStorageSection = addElement(document, "fromStorageSection", desp.getLocationDBFrom().getStorageSection());
despatchConfirmation.appendChild(locationFromStorageSection);
Element locationFromStorageType = addElement(document, "fromStorageType", desp.getLocationDBFrom().getStorageType());
despatchConfirmation.appendChild(locationFromStorageType);
Element locationFromStorageBin = addElement(document, "fromStorageBin", desp.getLocationDBFrom().getStorageBin());
despatchConfirmation.appendChild(locationFromStorageBin);
Element locationFromGLN = addElement(document, "fromGLN", desp.getLocationDBFrom().getGLN());
despatchConfirmation.appendChild(locationFromGLN);
Element locationFromStorageLocation = addElement(document, "fromStorageLocation", desp.getLocationDBFrom().getStorageLocation());
despatchConfirmation.appendChild(locationFromStorageLocation);
Element locationTo = addElement(document, "toLocation", desp.getLocationIDTo());
despatchConfirmation.appendChild(locationTo);
Element locationToPlant = addElement(document, "toPlant", desp.getLocationDBTo().getPlant());
despatchConfirmation.appendChild(locationToPlant);
Element locationToWarehouse = addElement(document, "toWarehouse", desp.getLocationDBTo().getWarehouse());
despatchConfirmation.appendChild(locationToWarehouse);
Element locationToStorageSection = addElement(document, "toStorageSection", desp.getLocationDBTo().getStorageSection());
despatchConfirmation.appendChild(locationToStorageSection);
Element locationToStorageType = addElement(document, "toStorageType", desp.getLocationDBTo().getStorageType());
despatchConfirmation.appendChild(locationToStorageType);
Element locationToStorageBin = addElement(document, "toStorageBin", desp.getLocationDBTo().getStorageBin());
despatchConfirmation.appendChild(locationToStorageBin);
Element locationToGLN = addElement(document, "toGLN", desp.getLocationDBTo().getGLN());
despatchConfirmation.appendChild(locationToGLN);
Element locationToStorageLocation = addElement(document, "toStorageLocation", desp.getLocationDBTo().getStorageLocation());
despatchConfirmation.appendChild(locationToStorageLocation);
Element contents = (Element) document.createElement("contents");
despatchConfirmation.appendChild(contents);
JDBPalletHistory palhist = new JDBPalletHistory(getHostID(), getSessionID());
ResultSet rs = palhist.getInterfacingData(transactionRef, "DESPATCH", "TO", Long.valueOf(0), "SSCC", "asc");
int x = 1;
try
{
rs.beforeFirst();
while (rs.next())
{
palhist.getPropertiesfromResultSet(rs);
Element pallet = (Element) document.createElement("pallet");
Element item = addElement(document, "item", String.valueOf(x));
pallet.appendChild(item);
x++;
Element sscc = addElement(document, "SSCC", palhist.getPallet().getSSCC());
pallet.appendChild(sscc);
Element processOrder = addElement(document, "processOrder", palhist.getPallet().getProcessOrder());
pallet.appendChild(processOrder);
Element material = addElement(document, "material", palhist.getPallet().getMaterial());
pallet.appendChild(material);
Element ean = addElement(document, "ean", palhist.getPallet().getEAN());
pallet.appendChild(ean);
Element variant = addElement(document, "variant", palhist.getPallet().getVariant());
pallet.appendChild(variant);
Element qty = addElement(document, "quantity", palhist.getPallet().getQuantity().toString());
pallet.appendChild(qty);
String paluom = palhist.getPallet().getUom();
paluom = uoml.convertUom(inter.getUOMConversion(), paluom);
Element uom = addElement(document, "UOM", paluom);
pallet.appendChild(uom);
Element status = addElement(document, "status", palhist.getPallet().getStatus());