Package org.openbravo.erpCommon.utility

Examples of org.openbravo.erpCommon.utility.ComboTableData


    xmlDocument.setParameter("cProjectStatus", strProjectstatus);
    xmlDocument.setParameter("cProjectPublic", strProjectpublic);
    xmlDocument.setParameter("salesRep", strSalesRep);

    try {
      ComboTableData comboTableData = new ComboTableData(this, "LIST", "", "Projectkind", "",
          Utility.getContext(this, vars, "#AccessibleOrgTree", "ReportInvoiceCustomerJR"), Utility
              .getContext(this, vars, "#User_Client", "ReportInvoiceCustomerJR"), 0);
      Utility.fillSQLParameters(this, vars, null, comboTableData, "ReportInvoiceCustomerJR",
          strProjectkind);
      xmlDocument.setData("reportC_PROJECTKIND", "liststructure", comboTableData.select(false));
      comboTableData = null;
    } catch (Exception ex) {
      throw new ServletException(ex);
    }

    try {
      ComboTableData comboTableData = new ComboTableData(this, "LIST", "", "Projectphase", "",
          Utility.getContext(this, vars, "#AccessibleOrgTree", "ReportInvoiceCustomerJR"), Utility
              .getContext(this, vars, "#User_Client", "ReportInvoiceCustomerJR"), 0);
      Utility.fillSQLParameters(this, vars, null, comboTableData, "ReportInvoiceCustomerJR",
          strProjectphase);
      xmlDocument.setData("reportC_PROJECTPHASE", "liststructure", comboTableData.select(false));
      comboTableData = null;
    } catch (Exception ex) {
      throw new ServletException(ex);
    }

    try {
      ComboTableData comboTableData = new ComboTableData(this, "LIST", "", "ProjectStatus", "",
          Utility.getContext(this, vars, "#AccessibleOrgTree", "ReportInvoiceCustomerJR"), Utility
              .getContext(this, vars, "#User_Client", "ReportInvoiceCustomerJR"), 0);
      Utility.fillSQLParameters(this, vars, null, comboTableData, "ReportInvoiceCustomerJR",
          strProjectstatus);
      xmlDocument.setData("reportC_PROJECTSTATUS", "liststructure", comboTableData.select(false));
      comboTableData = null;
    } catch (Exception ex) {
      throw new ServletException(ex);
    }

    try {
      ComboTableData comboTableData = new ComboTableData(this, "LIST", "", "PublicPrivate", "",
          Utility.getContext(this, vars, "#AccessibleOrgTree", "ReportInvoiceCustomerJR"), Utility
              .getContext(this, vars, "#User_Client", "ReportInvoiceCustomerJR"), 0);
      Utility.fillSQLParameters(this, vars, null, comboTableData, "ReportInvoiceCustomerJR",
          strProjectpublic);
      xmlDocument.setData("reportC_PROJECTPUBLIC", "liststructure", comboTableData.select(false));
      comboTableData = null;
    } catch (Exception ex) {
      throw new ServletException(ex);
    }

    try {
      ComboTableData comboTableData = new ComboTableData(vars, this, "TABLEDIR",
          "M_PRODUCT_CATEGORY_ID", "", "", Utility.getContext(this, vars, "#AccessibleOrgTree",
              "ReportInvoiceCustomerJR"), Utility.getContext(this, vars, "#User_Client",
              "ReportInvoiceCustomerJR"), 0);
      comboTableData.fillParameters(null, "ReportInvoiceCustomerJR", "");
      xmlDocument
          .setData("reportC_PRODUCTCATREGORY", "liststructure", comboTableData.select(false));
    } catch (Exception ex) {
      throw new ServletException(ex);
    }

    try {
      ComboTableData comboTableData = new ComboTableData(this, "TABLEDIR", "C_REGION_ID", "",
          "C_Region of Country", Utility.getContext(this, vars, "#AccessibleOrgTree",
              "ReportInvoiceCustomerJR"), Utility.getContext(this, vars, "#User_Client",
              "ReportInvoiceCustomerJR"), 0);
      Utility.fillSQLParameters(this, vars, null, comboTableData, "ReportInvoiceCustomerJR",
          strcRegionId);
      xmlDocument.setData("reportC_REGIONID", "liststructure", comboTableData.select(false));
      comboTableData = null;
    } catch (Exception ex) {
      throw new ServletException(ex);
    }

    try {
      ComboTableData comboTableData = new ComboTableData(this, "TABLE", "", "190",
          "AD_User SalesRep", Utility.getContext(this, vars, "#AccessibleOrgTree",
              "ReportInvoiceCustomerJR"), Utility.getContext(this, vars, "#User_Client",
              "ReportInvoiceCustomerJR"), 0);
      Utility.fillSQLParameters(this, vars, null, comboTableData, "ReportInvoiceCustomerJR",
          strSalesRep);
      xmlDocument.setData("reportSALESREP", "liststructure", comboTableData.select(false));
      comboTableData = null;
    } catch (Exception ex) {
      throw new ServletException(ex);
    }

    xmlDocument.setParameter("ccurrencyid", strCurrencyId);
    try {
      ComboTableData comboTableData = new ComboTableData(vars, this, "TABLEDIR", "C_Currency_ID",
          "", "", Utility.getContext(this, vars, "#AccessibleOrgTree", "ReportInvoiceCustomerJR"),
          Utility.getContext(this, vars, "#User_Client", "ReportInvoiceCustomerJR"), 0);
      Utility.fillSQLParameters(this, vars, null, comboTableData, "ReportInvoiceCustomerJR",
          strCurrencyId);
      xmlDocument.setData("reportC_Currency_ID", "liststructure", comboTableData.select(false));
      comboTableData = null;
    } catch (Exception ex) {
      throw new ServletException(ex);
    }
View Full Code Here


    xmlDocument.setParameter("ratioMayor", strRatioMayor);
    xmlDocument.setParameter("ratioMenor", strRatioMenor);
    xmlDocument.setParameter("comparative", strComparative);
    xmlDocument.setParameter("command", strCommand);
    try {
      ComboTableData comboTableData = new ComboTableData(vars, this, "TABLEDIR", "C_BP_Group_ID",
          "", "", Utility.getContext(this, vars, "#AccessibleOrgTree",
              "ReportRefundInvoiceCustomerDimensionalAnalyses"), Utility.getContext(this, vars,
              "#User_Client", "ReportRefundInvoiceCustomerDimensionalAnalyses"), 0);
      Utility.fillSQLParameters(this, vars, null, comboTableData,
          "ReportRefundInvoiceCustomerDimensionalAnalyses", strPartnerGroup);
      xmlDocument.setData("reportC_BP_GROUPID", "liststructure", comboTableData.select(false));
      comboTableData = null;
    } catch (Exception ex) {
      throw new ServletException(ex);
    }

    try {
      ComboTableData comboTableData = new ComboTableData(vars, this, "TABLEDIR",
          "M_Product_Category_ID", "", "", Utility.getContext(this, vars, "#AccessibleOrgTree",
              "ReportRefundInvoiceCustomerDimensionalAnalyses"), Utility.getContext(this, vars,
              "#User_Client", "ReportRefundInvoiceCustomerDimensionalAnalyses"), 0);
      Utility.fillSQLParameters(this, vars, null, comboTableData,
          "ReportRefundInvoiceCustomerDimensionalAnalyses", strProductCategory);
      xmlDocument.setData("reportM_PRODUCT_CATEGORYID", "liststructure", comboTableData
          .select(false));
      comboTableData = null;
    } catch (Exception ex) {
      throw new ServletException(ex);
    }

    xmlDocument.setData("reportAD_ORGID", "liststructure", OrganizationComboData.selectCombo(this,
        vars.getRole()));
    try {
      ComboTableData comboTableData = new ComboTableData(vars, this, "TABLE", "SalesRep_ID",
          "AD_User SalesRep", "", Utility.getContext(this, vars, "#AccessibleOrgTree",
              "ReportRefundInvoiceCustomerDimensionalAnalyses"), Utility.getContext(this, vars,
              "#User_Client", "ReportRefundInvoiceCustomerDimensionalAnalyses"), 0);
      Utility.fillSQLParameters(this, vars, null, comboTableData,
          "ReportRefundInvoiceCustomerDimensionalAnalyses", strsalesrepId);
      xmlDocument.setData("reportSalesRep_ID", "liststructure", comboTableData.select(false));
      comboTableData = null;
    } catch (Exception ex) {
      throw new ServletException(ex);
    }
View Full Code Here

      xmlDocument.setParameter("all", strShipperReport);
      xmlDocument.setParameter("paramDetalle", strDetail);

      xmlDocument.setParameter("paramShipper", strShipper);
      try {
        ComboTableData comboTableData = new ComboTableData(vars, this, "TABLEDIR", "M_Shipper_ID",
            "", "", Utility.getContext(this, vars, "#AccessibleOrgTree", "ReportShipper"), Utility
                .getContext(this, vars, "#User_Client", "ReportShipper"), 0);
        Utility.fillSQLParameters(this, vars, null, comboTableData, "ReportShipper", strShipper);
        xmlDocument.setData("reportShipper", "liststructure", comboTableData.select(false));
        comboTableData = null;
      } catch (Exception ex) {
        throw new ServletException(ex);
      }

      xmlDocument.setParameter("ccurrencyid", strCurrencyId);
      try {
        ComboTableData comboTableData = new ComboTableData(vars, this, "TABLEDIR", "C_Currency_ID",
            "", "", Utility.getContext(this, vars, "#AccessibleOrgTree", "ReportShipper"), Utility
                .getContext(this, vars, "#User_Client", "ReportShipper"), 0);
        Utility.fillSQLParameters(this, vars, null, comboTableData, "ReportShipper", strCurrencyId);
        xmlDocument.setData("reportC_Currency_ID", "liststructure", comboTableData.select(false));
        comboTableData = null;
      } catch (Exception ex) {
        throw new ServletException(ex);
      }
View Full Code Here

    xmlDocument.setParameter("mWarehouseId", strvmvehicleinfoId);
  xmlDocument.setParameter("vmVehicleId", strvmvehicleinfoId);
    //xmlDocument.setParameter("bPartnerDescription", ReportVehicleAvailabilityData.selectBpartner(this, strcBpartnerId));
    xmlDocument.setParameter("paramMessage", (strMessage.equals("") ? "" : "alert('" + strMessage+ "');"));
  try {
      ComboTableData comboTableData = new ComboTableData(vars, this, "TABLE", "","Vehicle List", "", Utility.getContext(this, vars, "#AccessibleOrgTree", "ReportVehicleAvailability"),Utility.getContext(this, vars, "#User_Client", "ReportVehicleAvailability"), 0);
      Utility.fillSQLParameters(this, vars, null, comboTableData, "ReportVehicleAvailability",strvmvehicleinfoId);
      xmlDocument.setData("reportM_WAREHOUSEID", "liststructure", comboTableData.select(false));
      comboTableData = null;
    } catch (Exception ex) {
      throw new ServletException(ex);
    }
 
      try {
      ComboTableData comboTableData = new ComboTableData(vars, this, "TABLEDIR", "VM_VEHICLE_ID", "", "", Utility.getContext(this, vars, "#AccessibleOrgTree", "ReportVehicleAvailability"),
          Utility.getContext(this, vars, "#User_Client", "ReportVehicleAvailability"), 0);
      Utility.fillSQLParameters(this, vars, null, comboTableData, "ReportVehicleAvailability",
          strvmvehicleinfoId);
      xmlDocument.setData("reportVM_VEHICLEID", "liststructure", comboTableData.select(false));
      comboTableData = null;
    } catch (Exception ex) {
      throw new ServletException(ex);
    }
     
View Full Code Here

    xmlDocument.setParameter("paramBPartnerId", "");
    xmlDocument.setParameter("mWarehouseId", "");
    xmlDocument.setParameter("cProjectId", "");
    xmlDocument.setParameter("projectName", "");
    try {
      ComboTableData comboTableData = new ComboTableData(vars, this, "TABLEDIR", "M_Warehouse_ID",
          "", "", Utility.getContext(this, vars, "#AccessibleOrgTree", "ShipmentFilter"), Utility
              .getContext(this, vars, "#User_Client", "ShipmentFilter"), 0);
      Utility.fillSQLParameters(this, vars, null, comboTableData, "ShipmentFilter", "");
      xmlDocument.setData("reportM_WAREHOUSEID", "liststructure", comboTableData.select(false));
      comboTableData = null;
    } catch (Exception ex) {
      throw new ServletException(ex);
    }
View Full Code Here

      xmlDocument.setParameter("startDateTo", strToDate);
      xmlDocument.setParameter("dateTodisplayFormatStart", vars.getSessionValue("#AD_SqlDateFormat"));
      xmlDocument.setParameter("dateTosaveFormatStart", vars.getSessionValue("#AD_SqlDateFormat"));
      //xmlDocument.setParameter("categoryProduct", strCategoryProduct);
      try {
        ComboTableData comboTableData = new ComboTableData(vars, this, "TABLEDIR", "C_BPARTNER_ID","", "", Utility.getContext(this, vars, "#AccessibleOrgTree", ""),Utility.getContext(this, vars, "#User_Client", ""), 0);
        Utility.fillSQLParameters(this, vars, null, comboTableData, "", strWarehouse);
        xmlDocument.setData("reportM_WAREHOUSEID", "liststructure", comboTableData.select(false));
        comboTableData = null;
      } catch (Exception ex) {
        throw new ServletException(ex);
      }
      /*try {
View Full Code Here

        xmlDocument.setParameter("messageTitle", myMessage.getTitle());
        xmlDocument.setParameter("messageMessage", myMessage.getMessage());
      }
    }

    ComboTableData comboTableData = null;
    try {
      comboTableData = new ComboTableData(vars, this, "LIST", "Theme", "800102", "", Utility
          .getContext(this, vars, "#AccessibleOrgTree", "ShowSessionPreferences"), Utility
          .getContext(this, vars, "#User_Client", "ShowSessionPreferences"), 0);
      Utility.fillSQLParameters(this, vars, null, comboTableData, "ShowSessionPreferences", "");
      xmlDocument.setData("reportTheme", "liststructure", comboTableData.select(true));
    } catch (Exception ex) {
    }
    comboTableData = null;

    response.setContentType("text/html; charset=UTF-8");
View Full Code Here

    xmlDocument.setParameter("directory", "var baseDirectory = \"" + strReplaceWith + "/\";\n");
    xmlDocument.setParameter("language", "defaultLang=\"" + vars.getLanguage() + "\";");
    xmlDocument.setParameter("theme", vars.getTheme());
    xmlDocument.setParameter("name", strNameValue);
    try {
      ComboTableData comboTableData = new ComboTableData(vars, this, "TABLEDIR",
          "M_Product_Category_ID", "", "", Utility.getContext(this, vars, "#AccessibleOrgTree",
              "ProductMultiple"),
          Utility.getContext(this, vars, "#User_Client", "ProductMultiple"), 0);
      Utility.fillSQLParameters(this, vars, null, comboTableData, "ProductMultiple", vars
          .getSessionValue("ProductMultiple.productCategory", ""));
      xmlDocument.setData("reportM_Product_Category_ID", "liststructure", comboTableData
          .select(false));
      comboTableData = null;
    } catch (Exception ex) {
      throw new ServletException(ex);
    }
View Full Code Here

    xmlDocument.setParameter("documentNo", strDocumentNo);

    xmlDocument.setParameter("paymentRule", strPaymentRule);

    try {
      ComboTableData comboTableData = new ComboTableData(vars, this, "LIST", "",
          "All_Payment Rule", "", Utility
              .getContext(this, vars, "#AccessibleOrgTree", "CreateFrom"), Utility.getContext(this,
              vars, "#User_Client", "CreateFrom"), 0);
      Utility.fillSQLParameters(this, vars, null, comboTableData, "CreateFrom", strPaymentRule);
      xmlDocument.setData("reportPaymentRule", "liststructure", comboTableData.select(false));
      comboTableData = null;
    } catch (final Exception ex) {
      throw new ServletException(ex);
    }
    xmlDocument.setParameter("cbpartnerId", strcBPartner);

    xmlDocument.setParameter("cbpartnerId_DES", CreateFromBankData.bpartner(this, strcBPartner));
    xmlDocument.setParameter("plannedDateFrom", strPlannedDateFrom);
    xmlDocument.setParameter("plannedDateFromdisplayFormat", vars
        .getSessionValue("#AD_SqlDateFormat"));
    xmlDocument
        .setParameter("plannedDateFromsaveFormat", vars.getSessionValue("#AD_SqlDateFormat"));
    xmlDocument.setParameter("plannedDateTo", strPlannedDateTo);
    xmlDocument.setParameter("plannedDateTodisplayFormat", vars
        .getSessionValue("#AD_SqlDateFormat"));
    xmlDocument.setParameter("plannedDateTosaveFormat", vars.getSessionValue("#AD_SqlDateFormat"));
    xmlDocument.setParameter("amountFrom", strAmountFrom);
    {
      final OBError myMessage = vars.getMessage("CreateFrom");
      vars.removeMessage("CreateFrom");
      if (myMessage != null) {
        xmlDocument.setParameter("messageType", myMessage.getType());
        xmlDocument.setParameter("messageTitle", myMessage.getTitle());
        xmlDocument.setParameter("messageMessage", myMessage.getMessage());
      }
    }
    xmlDocument.setParameter("amountTo", strAmountTo);
    xmlDocument.setParameter("isreceiptPago", strIsReceipt);
    xmlDocument.setParameter("isreceiptCobro", strIsReceipt);
    xmlDocument.setParameter("adOrgId", strOrg);
    xmlDocument.setParameter("charge", strCharge);

    try {
      ComboTableData comboTableData = new ComboTableData(vars, this, "TABLEDIR",
          "C_BankAccount_ID", "", "", Utility.getContext(this, vars, "#AccessibleOrgTree",
              strWindowId), Utility.getContext(this, vars, "#User_Client", strWindowId), 0);
      Utility.fillSQLParameters(this, vars, null, comboTableData, strWindowId, strBank);
      xmlDocument.setData("reportC_BankAccount_ID", "liststructure", comboTableData.select(false));
      comboTableData = null;
    } catch (final Exception ex) {
      throw new ServletException(ex);
    }

    try {
      ComboTableData comboTableData = new ComboTableData(vars, this, "TABLEDIR", "AD_Org_ID", "",
          "", Utility.getContext(this, vars, "#AccessibleOrgTree", strWindowId), Utility
              .getContext(this, vars, "#User_Client", strWindowId), 0);
      Utility.fillSQLParameters(this, vars, null, comboTableData, strWindowId, strOrg);
      xmlDocument.setData("reportAD_Org_ID", "liststructure", comboTableData.select(false));
      comboTableData = null;
    } catch (final Exception ex) {
      throw new ServletException(ex);
    }
View Full Code Here

    xmlDocument.setParameter("marcarTodos", strMarcarTodos);

    xmlDocument.setParameter("paymentRule", strPaymentRule);

    try {
      ComboTableData comboTableData = new ComboTableData(vars, this, "LIST", "",
          "All_Payment Rule", "",
          Utility.getContext(this, vars, "#AccessibleOrgTree", strWindowId), Utility.getContext(
              this, vars, "#User_Client", strWindowId), 0);
      Utility.fillSQLParameters(this, vars, null, comboTableData, strWindowId, strPaymentRule);
      xmlDocument.setData("reportPaymentRule", "liststructure", comboTableData.select(false));
      comboTableData = null;
    } catch (final Exception ex) {
      throw new ServletException(ex);
    }

    try {
      ComboTableData comboTableData = new ComboTableData(vars, this, "TABLEDIR", "AD_Org_ID", "",
          "", Utility.getContext(this, vars, "#AccessibleOrgTree", strWindowId), Utility
              .getContext(this, vars, "#User_Client", strWindowId), 0);
      Utility.fillSQLParameters(this, vars, null, comboTableData, strWindowId, strOrg);
      xmlDocument.setData("reportAD_Org_ID", "liststructure", comboTableData.select(false));
      comboTableData = null;
    } catch (final Exception ex) {
      throw new ServletException(ex);
    }
View Full Code Here

TOP

Related Classes of org.openbravo.erpCommon.utility.ComboTableData

Copyright © 2018 www.massapicom. All rights reserved.
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.