Exemple #1
0
  /**
   * Creates a new Request.
   *
   * @param request
   * @param ctx
   * @return new Request ID
   */
  public static String createRequest(HttpServletRequest request, Properties ctx) {
    String l_szTrxName = null;
    String l_szReturn = null;

    boolean l_bSuccess = true;

    BigDecimal l_bdAmt = getParameterAsBD(request, "RequestAmt");

    int l_nOrgID = getParameterAsInt(request, "AD_Org_ID");
    // int l_nSalesRepID 	= getParameterAsInt(request, "SalesRep_ID");
    int l_nRoleID = getParameterAsInt(request, "AD_Role_ID");
    int l_nRReqTypeID = getParameterAsInt(request, "R_RequestType_ID");
    int l_nRGroupID = getParameterAsInt(request, "R_Group_ID");
    int l_nRCategoryID = getParameterAsInt(request, "R_Category_ID");
    int l_nRReqRelID = getParameterAsInt(request, "R_RequestRelated_ID");
    int l_nRStatusID = getParameterAsInt(request, "R_Status_ID");
    int l_nRResolID = getParameterAsInt(request, "R_Resolution_ID");

    int l_nBPartnerID = getParameterAsInt(request, "C_BPartner_ID");
    int l_nUserID = getParameterAsInt(request, "AD_User_ID");
    int l_nProjectID = getParameterAsInt(request, "C_Project_ID");
    int l_nAssetID = getParameterAsInt(request, "A_Asset_ID");
    int l_nOrderID = getParameterAsInt(request, "C_Order_ID");
    int l_nInvoiceID = getParameterAsInt(request, "C_Invoice_ID");
    int l_nProductID = getParameterAsInt(request, "M_Product_ID");
    int l_nPaymentID = getParameterAsInt(request, "C_Payment_ID");
    int l_nInOutID = getParameterAsInt(request, "M_InOut_ID");
    int l_nRMAID = getParameterAsInt(request, "M_RMA_ID");
    int l_nCampaignID = getParameterAsInt(request, "C_Campaign_ID");

    /*
     * Durchlauf der Parameter Werte. Dabei werden alle übergebenen Parameter
     * als Columns in der MColumn gesucht und bei einem Treffer diese Werte
     * dann über set_ValueOfColumn gesetzt
     */
    /*		MRequest l_newRequest = new MRequest(ctx, 0, l_szTrxName);
    		Enumeration l_eParameterNames = request.getParameterNames();
    		MColumn curColumn = null;

    		int l_nColumnID = 0;
    		int l_nRefID = 0;

    		while (l_eParameterNames.hasMoreElements()) {
    			String name = l_eParameterNames.nextElement().toString();

    			l_nColumnID = l_newRequest.get_ColumnIndex(name);
    			if (l_nColumnID > -1) {
    				curColumn = new MColumn(ctx, l_nColumnID, l_szTrxName);
    				l_nRefID = curColumn.getAD_Reference_ID();

    				if (l_nRefID == b_bool) {
    					l_newRequest.set_ValueOfColumn(l_nColumnID, getParameterAsBool(request, name));
    				} else if (l_nRefID == bd_amount || l_nRefID == bd_costsAndPrice || l_nRefID == bd_floatNumber || l_nRefID == bd_quantity) {
    					l_newRequest.set_ValueOfColumn(l_nColumnID, getParameterAsBD(request, name));
    				} else if (l_nRefID == d_date || l_nRefID == d_dateTime || l_nRefID == d_time) {
    					l_newRequest.set_ValueOfColumn(l_nColumnID, getParameterAsDate(request, name));
    				} else if (l_nRefID == i_id || l_nRefID == i_integer || l_nRefID == i_rowID || l_nRefID == i_searchField || l_nRefID == i_table || l_nRefID == i_table) {
    					l_newRequest.set_ValueOfColumn(l_nColumnID, getParameterAsInt(request, name));
    				} else {
    					l_newRequest.set_ValueOfColumn(l_nColumnID, getParameterAsString(request, name));
    				}
    			}
    		}
    		l_bSuccess &= l_newRequest.save();
    */

    MRequest newRequest = new MRequest(ctx, 0, l_szTrxName);

    // values for values no fieldgroup
    newRequest.setAD_Org_ID(l_nOrgID);
    newRequest.setDueType(getParameterAsString(request, "DueType"));
    newRequest.setR_RequestType_ID(l_nRReqTypeID);
    newRequest.setR_Group_ID(l_nRGroupID);
    newRequest.setR_Category_ID(l_nRCategoryID);
    newRequest.setR_RequestRelated_ID(l_nRReqRelID);
    newRequest.setR_Status_ID(l_nRStatusID);
    newRequest.setR_Resolution_ID(l_nRResolID);
    newRequest.setPriority(getParameterAsString(request, "Priority"));
    newRequest.setPriorityUser(getParameterAsString(request, "PriorityUser"));
    newRequest.setSummary(getParameterAsString(request, "Summary"));
    newRequest.setConfidentialType(getParameterAsString(request, "ConfidentialType"));
    newRequest.setIsInvoiced(getParameterAsBool(request, "IsInvoiced"));

    // Mandatory values for fieldgroup Action
    newRequest.setConfidentialTypeEntry(getParameterAsString(request, "ConfidentialTypeEntry"));
    newRequest.setAD_Role_ID(l_nRoleID);
    // newRequest.setSalesRep_ID(l_nSalesRepID);

    // values for fieldgroup Reference
    newRequest.setC_BPartner_ID(l_nBPartnerID);
    newRequest.setAD_User_ID(l_nUserID);
    newRequest.setC_Project_ID(l_nProjectID);
    newRequest.setA_Asset_ID(l_nAssetID);
    newRequest.setC_Order_ID(l_nOrderID);
    newRequest.setC_Invoice_ID(l_nInvoiceID);
    newRequest.setM_Product_ID(l_nProductID);
    newRequest.setC_Payment_ID(l_nPaymentID);
    newRequest.setM_InOut_ID(l_nInOutID);
    newRequest.setM_RMA_ID(l_nRMAID);
    newRequest.setRequestAmt(l_bdAmt);
    newRequest.setC_Campaign_ID(l_nCampaignID);

    l_bSuccess &= newRequest.save();

    if (l_bSuccess) {
      try {
        DB.commit(true, l_szTrxName);
        l_szReturn = "" + newRequest.get_ID();
      } catch (Exception e) {
        l_szReturn = e.getMessage();
      }
    }
    return l_szReturn;
  }
Exemple #2
0
  /**
   * Updates a Request.
   *
   * @param request
   * @param ctx
   * @return
   */
  public static String changeRequest(HttpServletRequest request, Properties ctx) {
    String l_szTrxName = null;
    String l_szReturn = null;

    boolean l_bSuccess = true;

    BigDecimal l_bdAmt = getParameterAsBD(request, "RequestAmt");

    int l_nReqID = getParameterAsInt(request, "R_Request_ID");
    int l_nOrgID = getParameterAsInt(request, "AD_Org_ID");
    // int l_nSalesRepID 	= getParameterAsInt(request, "SalesRep_ID");
    int l_nRReqTypeID = getParameterAsInt(request, "R_RequestType_ID");
    int l_nRGroupID = getParameterAsInt(request, "R_Group_ID");
    int l_nRCategoryID = getParameterAsInt(request, "R_Category_ID");
    int l_nRReqRelID = getParameterAsInt(request, "R_RequestRelated_ID");
    int l_nRStatusID = getParameterAsInt(request, "R_Status_ID");
    int l_nRResolID = getParameterAsInt(request, "R_Resolution_ID");

    int l_nBPartnerID = getParameterAsInt(request, "C_BPartner_ID");
    int l_nUserID = getParameterAsInt(request, "AD_User_ID");
    int l_nProjectID = getParameterAsInt(request, "C_Project_ID");
    int l_nAssetID = getParameterAsInt(request, "A_Asset_ID");
    int l_nOrderID = getParameterAsInt(request, "C_Order_ID");
    int l_nInvoiceID = getParameterAsInt(request, "C_Invoice_ID");
    int l_nProductID = getParameterAsInt(request, "M_Product_ID");
    int l_nPaymentID = getParameterAsInt(request, "C_Payment_ID");
    int l_nInOutID = getParameterAsInt(request, "M_InOut_ID");
    int l_nRMAID = getParameterAsInt(request, "M_RMA_ID");
    int l_nCampaignID = getParameterAsInt(request, "C_Campaign_ID");

    int l_nResponseID = getParameterAsInt(request, "R_StandardResponse_ID");
    int l_nMailTextID = getParameterAsInt(request, "R_MailText_ID");
    int l_nActivityID = getParameterAsInt(request, "C_Activity_ID");
    int l_nProdSpentID = getParameterAsInt(request, "M_ProductSpent_ID");

    BigDecimal l_QtySpent = getParameterAsBD(request, "QtySpent");
    BigDecimal l_QtyInvoiced = getParameterAsBD(request, "QtyInvoiced");
    BigDecimal l_QtyPlan = getParameterAsBD(request, "QtyPlan");

    Timestamp l_tsDateNextAction = getParameterAsDate(request, "DateNextAction");
    Timestamp l_tsDateStartPlan = getParameterAsDate(request, "DateStartPlan");
    Timestamp l_tsDateCompletePlan = getParameterAsDate(request, "DateCompletePlan");
    Timestamp l_tsStartDate = getParameterAsDate(request, "StartDate");
    Timestamp l_tsCloseDate = getParameterAsDate(request, "CloseDate");

    MRequest newRequest = new MRequest(ctx, l_nReqID, l_szTrxName);

    // values for values no fieldgroup
    newRequest.setAD_Org_ID(l_nOrgID);
    newRequest.setDueType(getParameterAsString(request, "DueType"));
    newRequest.setR_RequestType_ID(l_nRReqTypeID);
    newRequest.setR_Group_ID(l_nRGroupID);
    newRequest.setR_Category_ID(l_nRCategoryID);
    newRequest.setR_RequestRelated_ID(l_nRReqRelID);
    newRequest.setR_Status_ID(l_nRStatusID);
    newRequest.setR_Resolution_ID(l_nRResolID);
    newRequest.setPriority(getParameterAsString(request, "Priority"));
    newRequest.setPriorityUser(getParameterAsString(request, "PriorityUser"));
    newRequest.setSummary(getParameterAsString(request, "Summary"));
    newRequest.setConfidentialType(getParameterAsString(request, "ConfidentialType"));
    newRequest.setIsInvoiced(getParameterAsBool(request, "IsInvoiced"));

    // values for fieldgroup Action
    newRequest.setDateNextAction(l_tsDateNextAction);
    newRequest.setConfidentialTypeEntry(getParameterAsString(request, "ConfidentialTypeEntry"));
    newRequest.setR_StandardResponse_ID(l_nResponseID);
    newRequest.setR_MailText_ID(l_nMailTextID);
    newRequest.setResult(getParameterAsString(request, "Result"));
    newRequest.setC_Activity_ID(l_nActivityID);
    newRequest.setQtyPlan(l_QtyPlan);
    newRequest.setQtySpent(l_QtySpent);
    newRequest.setM_ProductSpent_ID(l_nProdSpentID);
    newRequest.setQtyInvoiced(l_QtyInvoiced);
    newRequest.setDateStartPlan(l_tsDateStartPlan);
    newRequest.setDateCompletePlan(l_tsDateCompletePlan);
    newRequest.setStartDate(l_tsStartDate);
    newRequest.setCloseDate(l_tsCloseDate);

    // values for fieldgroup Reference
    newRequest.setC_BPartner_ID(l_nBPartnerID);
    newRequest.setAD_User_ID(l_nUserID);
    newRequest.setC_Project_ID(l_nProjectID);
    newRequest.setA_Asset_ID(l_nAssetID);
    newRequest.setC_Order_ID(l_nOrderID);
    newRequest.setC_Invoice_ID(l_nInvoiceID);
    newRequest.setM_Product_ID(l_nProductID);
    newRequest.setC_Payment_ID(l_nPaymentID);
    newRequest.setM_InOut_ID(l_nInOutID);
    newRequest.setM_RMA_ID(l_nRMAID);
    newRequest.setRequestAmt(l_bdAmt);
    newRequest.setC_Campaign_ID(l_nCampaignID);

    l_bSuccess &= newRequest.save();

    if (l_bSuccess) {
      try {
        DB.commit(true, l_szTrxName);
        l_szReturn = "" + newRequest.get_ID();
      } catch (Exception e) {
        l_szReturn = e.getMessage();
      }
    }
    return l_szReturn;
  }