/**
* 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;
}
/**
* 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;
}