@Override
protected void execute(CalloutInfo info) throws ServletException {
String strMultiGL = info.vars.getStringParameter("inpmultiGl");
if ("Y".equals(strMultiGL)) {
info.addResult("inpcAcctschemaId", null);
}
}
@Override
protected void execute(CalloutInfo info) throws ServletException {
final String ACCOUNTSIGN_CREDIT = "C";
final String ACCOUNTSIGN_DEBIT = "D";
final String ACCOUNTTYPE_ASSET = "A";
final String ACCOUNTTYPE_LIABILITY = "L";
final String ACCOUNTTYPE_EQUITY = "O";
final String ACCOUNTTYPE_REVENUE = "R";
final String ACCOUNTTYPE_EXPENSE = "E";
final String strAccountType = info.getStringParameter("inpaccounttype", null);
boolean centrallyMaintained = false;
final String strElementId = info.getStringParameter("inpcElementId", null);
Element element = OBDal.getInstance().get(Element.class, strElementId);
if (element.getFinancialMgmtAcctSchemaElementList().size() == 1) {
centrallyMaintained =
element
.getFinancialMgmtAcctSchemaElementList()
.get(0)
.getAccountingSchema()
.isCentralMaintenance();
}
if (!centrallyMaintained) {
if (strAccountType.equals(ACCOUNTTYPE_ASSET) || strAccountType.equals(ACCOUNTTYPE_EXPENSE)) {
info.addResult("inpaccountsign", ACCOUNTSIGN_DEBIT);
} else {
info.addResult("inpaccountsign", ACCOUNTSIGN_CREDIT);
}
} else {
AcctSchema as = element.getFinancialMgmtAcctSchemaElementList().get(0).getAccountingSchema();
if ((strAccountType.equals(ACCOUNTTYPE_ASSET) && as.isAssetPositive())
|| (strAccountType.equals(ACCOUNTTYPE_EXPENSE) && as.isExpensePositive())
|| (strAccountType.equals(ACCOUNTTYPE_LIABILITY) && !as.isLiabilityPositive())
|| (strAccountType.equals(ACCOUNTTYPE_EQUITY) && !as.isEquityPositive())
|| (strAccountType.equals(ACCOUNTTYPE_REVENUE) && !as.isRevenuePositive())) {
info.addResult("inpaccountsign", ACCOUNTSIGN_DEBIT);
} else {
info.addResult("inpaccountsign", ACCOUNTSIGN_CREDIT);
}
}
}
@Override
protected void execute(CalloutInfo info) throws ServletException {
VariablesSecureApp vars = info.vars;
String strfinPaymentmethodId = vars.getStringParameter("inpfinPaymentmethodId");
FIN_PaymentMethod paymentMethod =
OBDal.getInstance().get(FIN_PaymentMethod.class, strfinPaymentmethodId);
try {
// IN
info.addResult("inppayinAllow", paymentMethod.isPayinAllow() ? "Y" : "N");
info.addResult("inpautomaticReceipt", paymentMethod.isAutomaticReceipt() ? "Y" : "N");
info.addResult("inpautomaticDeposit", paymentMethod.isAutomaticDeposit() ? "Y" : "N");
info.addResult("inppayinExecutionType", paymentMethod.getPayinExecutionType());
info.addResult(
"inppayinExecutionProcessId",
paymentMethod.getPayinExecutionProcess() == null
? ""
: paymentMethod.getPayinExecutionProcess().getId());
info.addResult("inppayinDeferred", paymentMethod.isPayinDeferred() ? "Y" : "N");
info.addResult(
"inpuponreceiptuse",
paymentMethod.getUponReceiptUse() == null ? "" : paymentMethod.getUponReceiptUse());
info.addResult(
"inpupondeposituse",
paymentMethod.getUponDepositUse() == null ? "" : paymentMethod.getUponDepositUse());
info.addResult(
"inpinuponclearinguse",
paymentMethod.getINUponClearingUse() == null ? "" : paymentMethod.getINUponClearingUse());
info.addResult("inppayinIsmulticurrency", paymentMethod.isPayinIsMulticurrency() ? "Y" : "N");
// OUT
info.addResult("inppayoutAllow", paymentMethod.isPayoutAllow() ? "Y" : "N");
info.addResult("inpautomaticPayment", paymentMethod.isAutomaticPayment() ? "Y" : "N");
info.addResult("inpautomaticWithdrawn", paymentMethod.isAutomaticWithdrawn() ? "Y" : "N");
info.addResult("inppayoutExecutionType", paymentMethod.getPayoutExecutionType());
info.addResult(
"inppayoutExecutionProcessId",
paymentMethod.getPayoutExecutionProcess() == null
? ""
: paymentMethod.getPayoutExecutionProcess().getId());
info.addResult("inppayoutDeferred", paymentMethod.isPayoutDeferred() ? "Y" : "N");
info.addResult(
"inpuponpaymentuse",
paymentMethod.getUponPaymentUse() == null ? "" : paymentMethod.getUponPaymentUse());
info.addResult(
"inpuponwithdrawaluse",
paymentMethod.getUponWithdrawalUse() == null ? "" : paymentMethod.getUponWithdrawalUse());
info.addResult(
"inpoutuponclearinguse",
paymentMethod.getOUTUponClearingUse() == null
? ""
: paymentMethod.getOUTUponClearingUse());
info.addResult(
"inppayoutIsmulticurrency", paymentMethod.isPayoutIsMulticurrency() ? "Y" : "N");
} catch (Exception e) {
log4j.info("No default info for the selected payment method");
}
}
@Override
protected void execute(CalloutInfo info) throws ServletException {
try {
final String strPaymentId = info.getStringParameter("inpfinPaymentId", IsIDFilter.instance);
final String strcGlitemId = info.getStringParameter("inpcGlitemId", IsIDFilter.instance);
if ("".equals(strPaymentId) && "".equals(strcGlitemId)) {
info.addResult("inpdescription", "");
info.addResult("inpdepositamt", BigDecimal.ZERO);
info.addResult("inppaymentamt", BigDecimal.ZERO);
}
FIN_Payment payment = OBDal.getInstance().get(FIN_Payment.class, strPaymentId);
if ((payment.isReceipt() && payment.getAmount().compareTo(BigDecimal.ZERO) > 0)
|| (!payment.isReceipt() && payment.getAmount().compareTo(BigDecimal.ZERO) < 0)) {
info.addResult("inpdepositamt", payment.getFinancialTransactionAmount().abs());
info.addResult("inppaymentamt", BigDecimal.ZERO);
} else {
info.addResult("inpdepositamt", BigDecimal.ZERO);
info.addResult("inppaymentamt", payment.getFinancialTransactionAmount().abs());
}
String strWindowId = info.getStringParameter("inpwindowId", null);
if (payment.isReceipt()) {
info.vars.setSessionValue(strWindowId + "|IsSOTrx", "Y");
} else {
info.vars.setSessionValue(strWindowId + "|IsSOTrx", "N");
}
if (payment.getBusinessPartner() != null) {
info.addResult("inpcBpartnerId", payment.getBusinessPartner().getId());
}
if (payment.getDescription() != null) {
info.addResult("inpdescription", payment.getDescription());
}
} catch (Exception e) {
return;
}
}
@Override
protected void execute(CalloutInfo info) throws ServletException {
// General data
String strBPartner = info.vars.getStringParameter("inpcBpartnerId");
String strIsSOTrx = Utility.getContext(this, info.vars, "isSOTrx", info.getWindowId());
String strOrgId = info.vars.getStringParameter("inpadOrgId");
String strPriceList = "";
String strUserRep = "";
String strInvoiceRule = "";
String strFinPaymentMethodId = "";
String strPaymentrule = "";
String strDeliveryViaRule = "";
String strPaymentterm = "";
String strDeliveryRule = "";
String strDocTypeTarget = info.vars.getStringParameter("inpcDoctypetargetId");
String docSubTypeSO = "";
BpartnerMiscData[] data = BpartnerMiscData.select(this, strBPartner);
if (data != null && data.length > 0) {
strDeliveryRule =
data[0].deliveryrule.equals("")
? info.vars.getStringParameter("inpdeliveryrule")
: data[0].deliveryrule;
strUserRep = SEOrderBPartnerData.userIdSalesRep(this, data[0].salesrepId);
strUserRep =
strUserRep.equals("") ? info.vars.getStringParameter("inpsalesrepId") : strUserRep;
SLOrderDocTypeData[] docTypeData = SLOrderDocTypeData.select(this, strDocTypeTarget);
if (docTypeData != null && docTypeData.length > 0) {
docSubTypeSO = docTypeData[0].docsubtypeso;
}
strInvoiceRule =
(docSubTypeSO.equals("PR") || docSubTypeSO.equals("WI") || data[0].invoicerule.equals("")
? info.vars.getStringParameter("inpinvoicerule")
: data[0].invoicerule);
strPaymentrule = (strIsSOTrx.equals("Y") ? data[0].paymentrule : data[0].paymentrulepo);
strPaymentrule =
strPaymentrule.equals("")
? info.vars.getStringParameter("inppaymentrule")
: strPaymentrule;
strPaymentterm = (strIsSOTrx.equals("Y") ? data[0].cPaymenttermId : data[0].poPaymenttermId);
if (strPaymentterm.equalsIgnoreCase("")) {
BpartnerMiscData[] paymentTerm =
BpartnerMiscData.selectPaymentTerm(this, strOrgId, info.vars.getClient());
if (paymentTerm.length != 0) {
strPaymentterm =
strPaymentterm.equals("") ? paymentTerm[0].cPaymenttermId : strPaymentterm;
}
}
strPaymentterm =
strPaymentterm.equals("")
? info.vars.getStringParameter("inpcPaymenttermId")
: strPaymentterm;
strFinPaymentMethodId =
(strIsSOTrx.equals("Y") ? data[0].finPaymentmethodId : data[0].poPaymentmethodId);
strPriceList = (strIsSOTrx.equals("Y") ? data[0].mPricelistId : data[0].poPricelistId);
if (strPriceList.equalsIgnoreCase("")) {
strPriceList =
SEOrderBPartnerData.defaultPriceList(this, strIsSOTrx, info.vars.getClient());
}
strPriceList =
strPriceList.equals("") ? info.vars.getStringParameter("inpmPricelistId") : strPriceList;
strDeliveryViaRule =
data[0].deliveryviarule.equals("")
? info.vars.getStringParameter("inpdeliveryviarule")
: data[0].deliveryviarule;
}
// Price list
info.addResult(
"inpmPricelistId",
strPriceList.equals("")
? Utility.getContext(this, info.vars, "#M_PriceList_ID", info.getWindowId())
: strPriceList);
// BPartner Location
FieldProvider[] tdv = null;
String strLocation = info.vars.getStringParameter("inpcBpartnerId_LOC");
if (strLocation != null && !strLocation.isEmpty()) {
info.addResult("inpcBpartnerLocationId", strLocation);
}
// Warehouses
FieldProvider[] td = null;
try {
ComboTableData comboTableData =
new ComboTableData(
info.vars,
this,
"18",
"M_Warehouse_ID",
"197",
"",
Utility.getReferenceableOrg(info.vars, info.vars.getStringParameter("inpadOrgId")),
Utility.getContext(this, info.vars, "#User_Client", info.getWindowId()),
0);
Utility.fillSQLParameters(this, info.vars, null, comboTableData, info.getWindowId(), "");
td = comboTableData.select(false);
comboTableData = null;
} catch (Exception ex) {
throw new ServletException(ex);
}
if (td != null && td.length > 0) {
info.addSelect("inpmWarehouseId");
String strMwarehouse = SEOrderBPartnerData.mWarehouse(this, strBPartner);
if (strMwarehouse.equals("")) {
strMwarehouse = info.vars.getWarehouse();
}
for (int i = 0; i < td.length; i++) {
info.addSelectResult(
td[i].getField("id"),
td[i].getField("name"),
td[i].getField("id").equalsIgnoreCase(strMwarehouse));
}
info.endSelect();
} else {
info.addResult("inpmWarehouseId", null);
}
// Sales Representative
FieldProvider[] tld = null;
try {
ComboTableData comboTableData =
new ComboTableData(
info.vars,
this,
"TABLE",
"",
"AD_User SalesRep",
"",
Utility.getContext(this, info.vars, "#AccessibleOrgTree", "SEOrderBPartner"),
Utility.getContext(this, info.vars, "#User_Client", "SEOrderBPartner"),
0);
Utility.fillSQLParameters(this, info.vars, null, comboTableData, "SEOrderBPartner", "");
tld = comboTableData.select(false);
comboTableData = null;
} catch (Exception ex) {
throw new ServletException(ex);
}
if (tld != null && tld.length > 0) {
info.addSelect("inpsalesrepId");
for (int i = 0; i < tld.length; i++) {
info.addSelectResult(
tld[i].getField("id"),
tld[i].getField("name"),
tld[i].getField("id").equalsIgnoreCase(strUserRep));
}
info.endSelect();
} else {
info.addResult("inpsalesrepId", null);
}
// Invoice Rule
FieldProvider[] l = null;
try {
ComboTableData comboTableData = null;
if ("WR".equals(docSubTypeSO)) {
comboTableData =
new ComboTableData(
info.vars,
this,
"LIST",
"",
"C_Order InvoiceRule",
"Values for Invoice Rules for POS Sales orders",
Utility.getContext(this, info.vars, "#AccessibleOrgTree", "SEOrderBPartner"),
Utility.getContext(this, info.vars, "#User_Client", "SEOrderBPartner"),
0);
} else {
comboTableData =
new ComboTableData(
info.vars,
this,
"LIST",
"",
"C_Order InvoiceRule",
"",
Utility.getContext(this, info.vars, "#AccessibleOrgTree", "SEOrderBPartner"),
Utility.getContext(this, info.vars, "#User_Client", "SEOrderBPartner"),
0);
}
Utility.fillSQLParameters(this, info.vars, null, comboTableData, "SEOrderBPartner", "");
l = comboTableData.select(false);
comboTableData = null;
} catch (Exception ex) {
throw new ServletException(ex);
}
if (l != null && l.length > 0) {
info.addSelect("inpinvoicerule");
for (int i = 0; i < l.length; i++) {
info.addSelectResult(
l[i].getField("id"),
l[i].getField("name"),
l[i].getField("id").equalsIgnoreCase(strInvoiceRule));
}
info.endSelect();
} else {
info.addResult("inpinvoicerule", null);
}
// Project
info.addResult("inpcProjectId", "");
// Project R
info.addResult("inpcProjectId_R", "");
// Financial Payment
if (!"".equals(strFinPaymentMethodId)) {
info.addResult("inpfinPaymentmethodId", strFinPaymentMethodId);
}
// Bill to
if (strLocation != null && !strLocation.isEmpty()) {
info.addResult("inpbilltoId", strLocation);
}
// Payment rule
info.addResult("inppaymentrule", strPaymentrule);
// Delivery via rule
info.addResult("inpdeliveryviarule", strDeliveryViaRule);
// Discount printed
info.addResult(
"inpisdiscountprinted", SEOrderBPartnerData.getIsDicountPrinted(this, strBPartner));
// Payment term
info.addResult("inpcPaymenttermId", strPaymentterm);
// Delivery rule
try {
ComboTableData comboTableData =
new ComboTableData(
info.vars,
this,
"LIST",
"",
"C_Order DeliveryRule",
"",
Utility.getContext(this, info.vars, "#AccessibleOrgTree", "SEOrderBPartner"),
Utility.getContext(this, info.vars, "#User_Client", "SEOrderBPartner"),
0);
Utility.fillSQLParameters(this, info.vars, null, comboTableData, "SEOrderBPartner", "");
l = comboTableData.select(false);
comboTableData = null;
} catch (Exception ex) {
throw new ServletException(ex);
}
if (strIsSOTrx.equals("N")) {
info.addResult(
"inpdeliveryrule",
strDeliveryRule.equals("")
? ((l != null && l.length > 0) ? l[0].getField("id") : "null")
: strDeliveryRule);
} else {
if (l != null && l.length > 0) {
info.addSelect("inpdeliveryrule");
for (int i = 0; i < l.length; i++) {
info.addSelectResult(
l[i].getField("id"),
l[i].getField("name"),
l[i].getField("id").equalsIgnoreCase(strDeliveryRule));
}
info.endSelect();
} else {
info.addResult("inpdeliveryrule", null);
}
}
// Ad User
try {
ComboTableData comboTableData =
new ComboTableData(
info.vars,
this,
"TABLEDIR",
"AD_User_ID",
"",
"AD_User C_BPartner User/Contacts",
Utility.getContext(this, info.vars, "#AccessibleOrgTree", info.getWindowId()),
Utility.getContext(this, info.vars, "#User_Client", info.getWindowId()),
0);
Utility.fillSQLParameters(this, info.vars, null, comboTableData, info.getWindowId(), "");
tdv = comboTableData.select(false);
comboTableData = null;
} catch (Exception ex) {
throw new ServletException(ex);
}
if (tdv != null && tdv.length > 0) {
info.addSelect("inpadUserId");
String contactID = info.vars.getStringParameter("inpcBpartnerId_CON");
if (contactID.isEmpty()) {
// If a contactID has not been specified, the first one is selected
info.addSelectResult(tdv[0].getField("id"), tdv[0].getField("name"), true);
for (int i = 1; i < tdv.length; i++) {
info.addSelectResult(tdv[i].getField("id"), tdv[i].getField("name"), false);
}
} else {
for (int i = 0; i < tdv.length; i++) {
info.addSelectResult(
tdv[i].getField("id"),
tdv[i].getField("name"),
tdv[i]
.getField("id")
.equalsIgnoreCase(info.vars.getStringParameter("inpcBpartnerId_CON")));
}
}
info.endSelect();
} else {
info.addResult("inpadUserId", null);
}
// Message
StringBuilder message = new StringBuilder();
final String rtvendor = "C50A8AEE6F044825B5EF54FAAE76826F";
final String rfcustomer = "FF808081330213E60133021822E40007";
String strwindow = info.getStringParameter("inpwindowId", null);
if (!(strwindow.equals(rtvendor) || strwindow.equals(rfcustomer))) {
if ((!strBPartner.equals(""))
&& (FIN_Utility.isBlockedBusinessPartner(strBPartner, "Y".equals(strIsSOTrx), 1))) {
// If the Business Partner is blocked for this document, show an information message.
if (message.length() > 0) {
message.append("<br>");
}
BusinessPartner bPartner = OBDal.getInstance().get(BusinessPartner.class, strBPartner);
message.append(
OBMessageUtils.messageBD("ThebusinessPartner")
+ " "
+ bPartner.getIdentifier()
+ " "
+ OBMessageUtils.messageBD("BusinessPartnerBlocked"));
}
}
if (data != null
&& data.length > 0
&& new BigDecimal(data[0].creditavailable).compareTo(BigDecimal.ZERO) < 0
&& strIsSOTrx.equals("Y")) {
if (message.length() > 0) {
message.append("<br>");
}
String creditLimitExceed = "" + Double.parseDouble(data[0].creditavailable) * -1;
message.append(
Utility.messageBD(this, "CreditLimitOver", info.vars.getLanguage()) + creditLimitExceed);
}
info.addResult("MESSAGE", message.toString());
}
