Examples of com.commander4j.db.JDBUom

com.commander4j.db.JDBUom
@author David @version $Revision: 1.0 $

  public JInternalFramePalletAdmin()
  {
    super();
    getContentPane().setBackground(Color.WHITE);


    uomList.add(new JDBUom(Common.selectedHostID, Common.sessionID));
    uomList.addAll(u.getInternalUoms());


    decisionList.add(new JDBMHNDecisions(Common.selectedHostID, Common.sessionID));
    decisionList.addAll(d.getDecisions());

View Full Code Here

  {
    super();
    setIconifiable(true);
    getContentPane().setLayout(null);


    uomList.add(new JDBUom(Common.selectedHostID, Common.sessionID));
    uomList.addAll(u.getInternalUoms());


    typeList.add(new JDBMaterialType(Common.selectedHostID, Common.sessionID));
    typeList.addAll(t.getMaterialTypes());

View Full Code Here

  private JScrollPane jScrollPane1;
  private String luomid;
  private JDBLanguage lang = new JDBLanguage(Common.selectedHostID, Common.sessionID);


  private void add() {
    JDBUom u = new JDBUom(Common.selectedHostID, Common.sessionID);
    luomid = JOptionPane.showInputDialog(Common.mainForm, lang.get("dlg_UOM_Add"));
    if (luomid != null)
    {
      if (luomid.equals("") == false)
      {
        luomid = luomid.toUpperCase();
        if (u.create(luomid, "", "", "") == false)
        {
          JUtility.errorBeep();
          JOptionPane.showMessageDialog(Common.mainForm, u.getErrorMessage(), lang.get("dlg_Error"), JOptionPane.ERROR_MESSAGE);
        }
        else
        {
          JLaunchMenu.runForm("FRM_ADMIN_UOM_EDIT", luomid);
        }

View Full Code Here


  private void populateList(String defaultitem) {


    DefaultComboBoxModel DefComboBoxMod = new DefaultComboBoxModel();


    JDBUom tempUom = new JDBUom(Common.selectedHostID, Common.sessionID);


    LinkedList<JDBUom> tempUomList = tempUom.getInternalUoms();
    int sel = -1;
    for (int j = 0; j < tempUomList.size(); j++)
    {
      JDBUom t = (JDBUom) tempUomList.get(j);
      DefComboBoxMod.addElement(t);
      if (t.getInternalUom().equals(defaultitem))
      {
        sel = j;
      }
    }

View Full Code Here

    {
      luomid = ((JDBUom) jListUoms.getSelectedValue()).getInternalUom();
      int question = JOptionPane.showConfirmDialog(Common.mainForm, lang.get("dlg_UOM_Delete") + " " + luomid + " ?", lang.get("dlg_Confirm"), JOptionPane.YES_NO_OPTION);
      if (question == 0)
      {
        JDBUom u = new JDBUom(Common.selectedHostID, Common.sessionID);
        u.setInternalUom(luomid);
        u.delete();
        populateList("");
      }
    }
  }

View Full Code Here

      if (luom_to != null)
      {
        if (luom_to.equals("") == false)
        {
          luom_to = luom_to.toUpperCase();
          JDBUom u = new JDBUom(Common.selectedHostID, Common.sessionID);
          u.setInternalUom(luom_from);
          if (u.renameInternalUomTo(luom_to) == false)
          {
            JUtility.errorBeep();
            JOptionPane.showMessageDialog(Common.mainForm, u.getErrorMessage(), lang.get("dlg_Error"), JOptionPane.ERROR_MESSAGE);
          }
          populateList(luom_to);
        }
      }
    }

View Full Code Here

      }
    }
  }


  private void excel() {
    JDBUom uom = new JDBUom(Common.selectedHostID, Common.sessionID);
    JExcel export = new JExcel();
    export.saveAs("uoms.xls", uom.getUomDataResultSet(), Common.mainForm);
  }

View Full Code Here

    super();
    setIconifiable(true);


    lang = new JDBLanguage(Common.selectedHostID, Common.sessionID);


    uomList.add(new JDBUom(Common.selectedHostID, Common.sessionID));
    uomList.addAll(uom.getInternalUoms());
    typeList.add(new JDBMaterialType(Common.selectedHostID, Common.sessionID));
    typeList.addAll(materialType.getMaterialTypes());


    initGUI();

View Full Code Here

    super();


    this.mhnnumber = mhnnumber;
    this.callingForm = callingForm;


    uomList.add(new JDBUom(Common.selectedHostID, Common.sessionID));
    uomList.addAll(u.getInternalUoms());
    typeList.add(new JDBMaterialType(Common.selectedHostID, Common.sessionID));
    typeList.addAll(t.getMaterialTypes());


    initGUI();

View Full Code Here

    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());

View Full Code Here

0 1 2 3

TOP

Related Classes of com.commander4j.db.JDBUom

com.commander4j.app.JInternalFrameMaterialAdmin

com.commander4j.app.JInternalFrameMaterialProperties

com.commander4j.app.JInternalFrameMaterialUomAdmin

com.commander4j.app.JInternalFrameMHNAssign

com.commander4j.app.JInternalFramePalletAdmin

com.commander4j.app.JInternalFramePalletHistoryAdmin

com.commander4j.app.JInternalFramePalletProperties

com.commander4j.app.JInternalFrameProcessOrderAdmin

com.commander4j.app.JInternalFrameUomAdmin

com.commander4j.messages.IncommingMaterialDefinition

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.