Examples of JDBInterface

com.commander4j.db.JDBInterface

Examples of com.commander4j.db.JDBInterface

    buildSQL();
    populateList();
  }


  private void excel() {
    JDBInterface interfaceConfig = new JDBInterface(Common.selectedHostID, Common.sessionID);
    JExcel export = new JExcel();
    buildSQL();
    export.saveAs("interface.xls", interfaceConfig.getInterfaceDataResultSet(listStatement), Common.mainForm);
  }

View Full Code Here

Examples of com.commander4j.db.JDBInterface


        if (ldirection != null)
        {
          if (ldirection.equals("") == false)
          {
            JDBInterface matbat = new JDBInterface(Common.selectedHostID, Common.sessionID);
            if (matbat.isValidInterface(ltype, ldirection) == false)
            {
              JLaunchMenu.runForm("FRM_ADMIN_INTERFACE_EDIT", ltype, ldirection);
            }
            else
            {

View Full Code Here

Examples of com.commander4j.db.JDBInterface

      ltype = jTable1.getValueAt(row, 0).toString();
      ldirection = jTable1.getValueAt(row, 1).toString();
      int n = JOptionPane.showConfirmDialog(Common.mainForm, "Delete Interface Config [" + ltype + "] [" + ldirection + "] ?", "Confirm", JOptionPane.YES_NO_OPTION, 0, Common.icon_confirm);
      if (n == 0)
      {
        JDBInterface l = new JDBInterface(Common.selectedHostID, Common.sessionID);
        l.setInterfaceType(ltype);
        l.setInterfaceDirection(ldirection);
        boolean result = l.delete();
        if (result == false)
        {
          JUtility.errorBeep();
          JOptionPane.showMessageDialog(Common.mainForm, l.getErrorMessage(), "Delete error [" + ltype + "] [" + ldirection + "]", JOptionPane.WARNING_MESSAGE, Common.icon_confirm);
        }
        else
        {
          buildSQL();
          populateList();

View Full Code Here

Examples of com.commander4j.db.JDBInterface

    query.bindParams();
    listStatement = query.getPreparedStatement();
  }


  private void populateList() {
    JDBInterface interfaceConfig = new JDBInterface(Common.selectedHostID, Common.sessionID);
    JDBInterfaceTableModel interfaceConfigTable = new JDBInterfaceTableModel(interfaceConfig.getInterfaceDataResultSet(listStatement));
    TableRowSorter<JDBInterfaceTableModel> sorter = new TableRowSorter<JDBInterfaceTableModel>(interfaceConfigTable);


    jTable1.setRowSorter(sorter);
    jTable1.setModel(interfaceConfigTable);

View Full Code Here

Examples of com.commander4j.db.JDBInterface

  {
    Boolean result = false;
    String path = "";
    JDBInterfaceLog il = new JDBInterfaceLog(getHostID(), getSessionID());
    GenericMessageHeader gmh = new GenericMessageHeader();
    JDBInterface inter = new JDBInterface(getHostID(), getSessionID());
    JDBMaterial mat = new JDBMaterial(getHostID(), getSessionID());
    JDBCustomer cust = new JDBCustomer(getHostID(), getSessionID());
    inter.getInterfaceProperties("Label Data", "Output");
    String device = inter.getDevice();
    String format = inter.getFormat();
    JDBLabelData labdata = new JDBLabelData(getHostID(), getSessionID());


    if (labdata.getProperties(unique))
    {


      try
      {
        if (format.equals("CSV"))
        {


          if (device.equals("Disk"))
          {
            String heading[] = labdata.getDataArray(unique, "heading");
            String data[] = labdata.getDataArray(unique, "data");


            path = inter.getRealPath();


            path = path.replace("\\", java.io.File.separator);
            path = path.replace("/", java.io.File.separator);


            if (path.length() > 0)
            {
              if (path.substring(path.length() - 1).equals(java.io.File.separator) == false)
              {
                path = path + java.io.File.separator;
              }
            }
            String filename = path + "LabelData_"+labdata.getLine() + "_" + unique + ".csv";


            CSVWriter writer = new CSVWriter(new FileWriter(filename), ',');
            writer.writeNext(heading);
            writer.writeNext(data);
            writer.close();
            result = true;
            il.write(gmh, GenericMessageHeader.msgStatusSuccess, "Processed OK", "File Write", filename);
            setErrorMessage("");
          }
        }


        if (format.equals("XML"))
        {


          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", unique);
          message.appendChild(messageRef);


          Element messageType = addElement(document, "interfaceType", "Label Data");
          message.appendChild(messageType);


          Element messageInformation = addElement(document, "messageInformation", "UniqueID=" + unique);
          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 labelData = (Element) document.createElement("labelData");


          Element unq = addElement(document, "uniqueID", unique);
          labelData.appendChild(unq);


          Element lt = addElement(document, "labelType", labdata.getLabelType());
          labelData.appendChild(lt);


          Element line = addElement(document, "line", labdata.getLine());
          labelData.appendChild(line);


          Element printDate = addElement(document, "printDate", JUtility.getISOTimeStampStringFormat(labdata.getPrintDate()));
          labelData.appendChild(printDate);


          Element user = addElement(document, "userID", labdata.getUserID());
          labelData.appendChild(user);


          Element workstation = addElement(document, "workstation", labdata.getWorkstationID());
          labelData.appendChild(workstation);


          Element material = addElement(document, "material", labdata.getMaterial());
          labelData.appendChild(material);


          if (mat.getMaterialProperties(labdata.getMaterial()))
          {
            Element materialDesc = addElement(document, "materialDescription", mat.getDescription());
            labelData.appendChild(materialDesc);
          }


          Element materialType = addElement(document, "materialType", labdata.getMaterialType());
          labelData.appendChild(materialType);


          Element po = addElement(document, "processOrder", labdata.getProcessOrder());
          labelData.appendChild(po);


          Element rr = addElement(document, "requiredResource", labdata.getRequiredResource());
          labelData.appendChild(rr);


          Element location = addElement(document, "location", labdata.getLocationID());
          labelData.appendChild(location);


          Element batch = addElement(document, "batch", labdata.getBatchNumber());
          labelData.appendChild(batch);


          Element batchPrefix = addElement(document, "batchPrefix", labdata.getBatchPrefix());
          labelData.appendChild(batchPrefix);


          Element ovbatchPrefix = addElement(document, "overrideBatchPrefix", labdata.getOverrideBatchPrefix());
          labelData.appendChild(ovbatchPrefix);


          Element batchSuffix = addElement(document, "batchSuffix", labdata.getBatchSuffix());
          labelData.appendChild(batchSuffix);


          Element prodquantity = addElement(document, "prodQuantity", labdata.getProdQuantity().toString());
          labelData.appendChild(prodquantity);


          Element produom = addElement(document, "prodUom", labdata.getProdUom());
          labelData.appendChild(produom);


          Element prodEAN = addElement(document, "prodEAN", labdata.getProdEAN());
          labelData.appendChild(prodEAN);


          Element prodVar = addElement(document, "prodVariant", labdata.getProdVariant());
          labelData.appendChild(prodVar);


          Element basequantity = addElement(document, "baseQuantity", labdata.getBaseQuantity().toString());
          labelData.appendChild(basequantity);


          Element baseuom = addElement(document, "baseUom", labdata.getBaseUom());
          labelData.appendChild(baseuom);


          Element baseEAN = addElement(document, "baseEAN", labdata.getBaseEAN());
          labelData.appendChild(baseEAN);


          Element baseVar = addElement(document, "baseVariant", labdata.getBaseVariant());
          labelData.appendChild(baseVar);


          Element dom = addElement(document, "dateOfManufacture", JUtility.getISOTimeStampStringFormat(labdata.getDateofManufacture()));
          labelData.appendChild(dom);


          Element ovdom = addElement(document, "overrideDateofManufacture", labdata.getOverrideDateofManufacture());
          labelData.appendChild(ovdom);


          Element expiry = addElement(document, "expiryDate", JUtility.getISOTimeStampStringFormat(labdata.getExpirtDate()));
          labelData.appendChild(expiry);


          Element ovexpiry = addElement(document, "overrideExpiryDate", labdata.getOverrideExpiryDate());
          labelData.appendChild(ovexpiry);


          Element expiryMode = addElement(document, "expiryMode", labdata.getExpiryMode());
          labelData.appendChild(expiryMode);


          Element custid = addElement(document, "customer", labdata.getCustomer());
          labelData.appendChild(custid);


          if (cust.getCustomerProperties(labdata.getCustomer()))
          {
            Element custName = addElement(document, "customerName", cust.getName());
            labelData.appendChild(custName);
          }


          Element copies = addElement(document, "copies", labdata.getPrintCopies().toString());
          labelData.appendChild(copies);


          Element queueName = addElement(document, "queueName", labdata.getPrintQueue());
          labelData.appendChild(queueName);


          Element module = addElement(document, "moduleID", labdata.getModuleID());
          labelData.appendChild(module);


          Element messageData = (Element) document.createElement("messageData");
          messageData.appendChild(labelData);


          message.appendChild(messageData);


          document.appendChild(message);


          JXMLDocument xmld = new JXMLDocument();
          xmld.setDocument(document);
          gmh.decodeHeader(xmld);


          if (device.equals("Disk") | device.equals("Email"))
          {


            path = inter.getRealPath();
            if (fio.writeToDisk(path, document, -1, labdata.getLine() + "_" + unique + "_LabelData.xml") == true)
            {
              result = true;
              il.write(gmh, GenericMessageHeader.msgStatusSuccess, "Processed OK", "File Write", fio.getFilename());
              setErrorMessage("");

View Full Code Here

Examples of com.commander4j.db.JDBInterface

    sessionID = session;
  }


  public void submit(String unique)
  {
    JDBInterface inter = new JDBInterface(getHostID(), getSessionID());
    inter.getInterfaceProperties("Label Data", "Output");
    if (inter.isEnabled() == true)
    {
      JDBInterfaceRequest ir = new JDBInterfaceRequest(getHostID(), getSessionID());
      ir.write(unique, "Label Data");
    } else
    {

View Full Code Here

Examples of com.commander4j.db.JDBInterface

    JDBQMInspection qmInspection = new JDBQMInspection(getHostID(), getSessionID());
    JDBQMExtension qmExtension = new JDBQMExtension(getHostID(), getSessionID());
    JDBQMActivity qmActivity = new JDBQMActivity(getHostID(), getSessionID());
    JDBQMTest qmTest = new JDBQMTest(getHostID(), getSessionID());
    JDBQMDictionary qmDictionary = new JDBQMDictionary(getHostID(), getSessionID());
    JDBInterface inter = new JDBInterface(getHostID(), getSessionID());
    JDBProcessOrder po = new JDBProcessOrder(getHostID(),getSessionID());


    inter.getInterfaceProperties("QM Inspection Request", "Input");


    // INSPECTION //
    // Decode the Inspection Top Level ID //
    
    inspectionID = gmh.getXMLDocument().findXPath("//message/messageData/inspectionDefinition/ID").trim();

View Full Code Here

Examples of com.commander4j.db.JDBInterface

    try
    {
      if (cache.containsKey(row)==false)
      {
        mResultSet.absolute(row + 1);
        final JDBInterface prow = new JDBInterface(Common.selectedHostID, Common.sessionID);
        prow.getPropertiesfromResultSet(mResultSet);
        cache.put(row, prow);
      }
      switch (col)
      {
      case interfaceType_Col:

View Full Code Here

Examples of com.commander4j.db.JDBInterface

    outboundThread.setName("C4J Outbound Interface");
    outboundThread.start();


    com.commander4j.util.JWait.milliSec(100);
    LinkedList<String> test1 = new LinkedList<String>();
    JDBInterface interfaces = new JDBInterface(getHostID(), getSessionID());
    test1 = interfaces.getInputPaths();


    logger.debug("Starting File Collection Thread.....");
    fileCollectThread = new InboundMessageCollectionThread(test1, Common.interface_recovery_path);
    fileCollectThread.setName("C4J Recovery Thread");
    fileCollectThread.start();

View Full Code Here

Examples of com.commander4j.db.JDBInterface

    Boolean result = false;


    JDBProcessOrder po = new JDBProcessOrder(getHostID(), getSessionID());
    JDBCustomer cst = new JDBCustomer(getHostID(), getSessionID());
    JDBUom uomdb = new JDBUom(getHostID(), getSessionID());
    JDBInterface inter = new JDBInterface(getHostID(), getSessionID());


    inter.getInterfaceProperties("Process Order", "Input");


    orderNo = gmh.getXMLDocument().findXPath("//message/messageData/processOrder/orderNo").trim();
    material = gmh.getXMLDocument().findXPath("//message/messageData/processOrder/material").trim();
    description = gmh.getXMLDocument().findXPath("//message/messageData/processOrder/description").trim();
    status = gmh.getXMLDocument().findXPath("//message/messageData/processOrder/status").trim();
    location = gmh.getXMLDocument().findXPath("//message/messageData/processOrder/location").trim();
    dueDate = gmh.getXMLDocument().findXPath("//message/messageData/processOrder/dueDate").trim();
    receipeId = gmh.getXMLDocument().findXPath("//message/messageData/processOrder/receipeId").trim();
    requiredQuantity = gmh.getXMLDocument().findXPath("//message/messageData/processOrder/requiredQuantity").trim();


    requiredUom = gmh.getXMLDocument().findXPath("//message/messageData/processOrder/requiredUom").trim();
    requiredUom = uomdb.convertUom(inter.getUOMConversion(), requiredUom);


    defaultPalletStatus = gmh.getXMLDocument().findXPath("//message/messageData/processOrder/defaultPalletStatus").trim();
    requiredResource = gmh.getXMLDocument().findXPath("//message/messageData/processOrder/requiredResource").trim();
    
    inspectionID = JUtility.replaceNullStringwithBlank(gmh.getXMLDocument().findXPath("//message/messageData/processOrder/inspectionID").trim());

View Full Code Here

0 1 2 3

TOP

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.