private Set<Integer> getAllBPartnerIds() {
final List<I_C_BPartner> bpartnersList =
pmmbPartnerDAO.retrieveAllPartnersWithProcurementUsers();
for (final I_C_BPartner bpartner : bpartnersList) {
bpartners.put(bpartner.getC_BPartner_ID(), bpartner);
}
return ImmutableSet.copyOf(bpartners.keySet());
}
public I_M_Shipper createShipper(final I_C_BPartner bpartner) {
final I_M_Shipper shipper =
InterfaceWrapperHelper.newInstance(I_M_Shipper.class, contextProvider);
shipper.setName(bpartner.getName());
shipper.setC_BPartner_ID(bpartner.getC_BPartner_ID());
InterfaceWrapperHelper.save(shipper);
return shipper;
}
public I_C_BPartner_Location createBPLocation(final I_C_BPartner bpartner) {
final I_C_BPartner_Location bpLocation =
InterfaceWrapperHelper.newInstance(I_C_BPartner_Location.class, bpartner);
bpLocation.setC_BPartner_ID(bpartner.getC_BPartner_ID());
bpLocation.setIsBillToDefault(true);
bpLocation.setIsBillTo(true);
bpLocation.setIsShipToDefault(true);
bpLocation.setIsShipTo(true);
InterfaceWrapperHelper.save(bpLocation);
return bpLocation;
}
public void findPaymentSchedule(I_C_BPartner student) {
List<MTimeExpenseLine> changes =
new Query(
ctx,
MTimeExpenseLine.Table_Name,
I_S_TimeExpenseLine.COLUMNNAME_C_BPartner_ID + "=?",
null)
.setParameters(student.getC_BPartner_ID())
.list();
if (paymentSchedules != null) {
paymentSchedules.addAll(changes);
}
}
public void calculateItems(String childValue) {
singleMonth = Env.ZERO;
;
singleYear = Env.ZERO;
;
singleTotal = Env.ZERO;
consolidatedMonth = Env.ZERO;
consolidatedYear = Env.ZERO;
consolidatedTotal = Env.ZERO;
paymentValue = Env.ZERO;
I_C_BPartner student = studentList.get(childValue);
for (MTimeExpenseLine paymentSchedule : paymentSchedules) {
if (paymentSchedule.getC_BPartner_ID() == student.getC_BPartner_ID()) {
if (!(paymentSchedule.get_ValueAsBoolean("IsPaid"))) {
I_M_Product concept = paymentSchedule.getM_Product();
MExpenseType conceptType = (MExpenseType) concept.getS_ExpenseType();
String type = conceptType.get_ValueAsString(MInvoiceSchedule.COLUMNNAME_InvoiceFrequency);
if (MInvoiceSchedule.INVOICEFREQUENCY_Monthly.equals(type))
singleMonth = singleMonth.add(paymentSchedule.getApprovalAmt());
else if ("Y".equals(type)) singleYear = singleYear.add(paymentSchedule.getApprovalAmt());
singleTotal = singleTotal.add(paymentSchedule.getApprovalAmt());
}
}
if (!(paymentSchedule.get_ValueAsBoolean("IsPaid"))) {
MProduct concept = (MProduct) paymentSchedule.getM_Product();
MExpenseType conceptType = (MExpenseType) concept.getS_ExpenseType();
String type = conceptType.get_ValueAsString(MInvoiceSchedule.COLUMNNAME_InvoiceFrequency);
if (MInvoiceSchedule.INVOICEFREQUENCY_Monthly.equals(type))
consolidatedMonth = consolidatedMonth.add(paymentSchedule.getApprovalAmt());
else if ("Y".equals(type))
consolidatedYear = consolidatedYear.add(paymentSchedule.getApprovalAmt());
consolidatedTotal = consolidatedTotal.add(paymentSchedule.getApprovalAmt());
}
}
}
public boolean completePayments(int docType_ID, String documentNo, Timestamp trxDate) {
boolean success = false;
message_error = "No se pudo completar los pagos";
try {
success = validatePayments();
// create header
caPayment = new X_CA_Payment(ctx, 0, null);
caPayment.setC_BPartner_ID(m_bpartner.get_ID());
caPayment.setDocumentNo(documentNo);
caPayment.setC_DocType_ID(docType_ID);
caPayment.setDateTrx(trxDate);
caPayment.saveEx();
// save lines
// buscar tabla de prioridades
// List<X_CA_PaymentPreference> priorities = new Query(ctx, X_CA_PaymentPreference.Table_Name,
// "", null)
// .setOnlyActiveRecords(true).setOrderBy("SeqNo").list();
for (int tableRow = 0; tableRow <= paymentTable.getRowCount() - 1; tableRow++) {
String type = getComboValue(tableRow, 0);
if (!"AN".equals(type) && !"ME".equals(type))
throw new AdempiereException("Indicar tipo de pago (Anual/Mensual)");
String paymentType = getComboValue(tableRow, 1);
String card = getComboValue(tableRow, 2);
java.lang.Number quote = (java.lang.Number) paymentTable.getValueAt(tableRow, 3);
Boolean hasinteres = (Boolean) paymentTable.getValueAt(tableRow, 4);
String account = getComboValue(tableRow, 5);
String reference = (String) paymentTable.getValueAt(tableRow, 6);
java.lang.Number amount = (java.lang.Number) paymentTable.getValueAt(tableRow, 7);
for (int studentRow = 0; studentRow <= studentTable.getRowCount() - 1; studentRow++) {
String value = (String) studentTable.getValueAt(studentRow, INDEX_VALUE);
I_C_BPartner student = studentList.get(value);
Boolean doPay = (Boolean) studentTable.getValueAt(studentRow, 5);
if (doPay) {
MTimeExpenseLine currentSchedule = null;
for (MTimeExpenseLine schedule : paymentSchedules) {
if (schedule.getC_BPartner_ID() == student.getC_BPartner_ID()) {
currentSchedule = schedule;
}
}
if (currentSchedule == null) throw new AdempiereException("No existe programa de Pago");
// generar nuevo pago
MPayment payment = new MPayment(ctx, 0, null);
payment.set_ValueOfColumn("CA_Payment_ID", caPayment.get_ID());
payment.setC_DocType_ID(1000008); // pago, que siempre no, que es cobro
payment.setC_BankAccount_ID(Integer.parseInt(account));
payment.set_ValueOfColumn("SalesRep_ID", Env.getContextAsInt(ctx, "#AD_User_ID"));
payment.setTenderType(paymentType);
if ("K".equals(paymentType)
|| "Q".equals(paymentType)) // cheque nacional - internacional
{
payment.setCheckNo(reference);
} else if ("A".equals(paymentType)) // Depósito directo
{
payment.setAccountNo(reference);
} else if ("C".equals(paymentType)) // Tarjeta de Crédito
{
payment.setCreditCardType(card);
payment.setCreditCardNumber(reference);
payment.set_ValueOfColumn("NumberOfShares", new BigDecimal(String.valueOf(quote)));
payment.set_ValueOfColumn("HasInterests", hasinteres);
}
payment.setC_BPartner_ID(student.getC_BPartner_ID());
payment.setPayAmt(new BigDecimal(String.valueOf(getAmount(currentSchedule, type))));
payment.setC_Order_ID(currentSchedule.get_ID());
payment.setC_Currency_ID(100); // USD
if (payment.getPayAmt().compareTo(new BigDecimal("0")) > 0) {
payment.saveEx();
payment.processIt(DocAction.ACTION_Complete);
}
}
}
}
success = true;
} catch (Exception e) {
success = false;
e.printStackTrace();
message_error = e.getMessage();
}
return success;
}
public SyncBPartner createSyncBPartnerWithoutContracts(final I_C_BPartner bpartner) {
Check.assumeNotNull(bpartner, "bpartner not null");
return createSyncBPartnerWithoutContracts(bpartner.getC_BPartner_ID());
}
@Override
public void createSupply(final IMRPCreateSupplyRequest request) {
final IMRPContext mrpContext = request.getMRPContext();
final IMRPExecutor executor = request.getMRPExecutor();
final Properties ctx = mrpContext.getCtx();
final I_PP_Product_Planning productPlanningData = mrpContext.getProductPlanning();
final I_AD_Org org = mrpContext.getAD_Org();
final I_S_Resource plant = mrpContext.getPlant();
final Timestamp supplyDateFinishSchedule = TimeUtil.asTimestamp(request.getDemandDate());
// QtyToSupply: qty for which we need to produce the supply
final BigDecimal qtyToSupply = request.getQtyToSupply();
// TODO vpj-cd I need to create logic for DRP-040 Shipment Due Action Notice
// Indicates that a shipment for a Order Distribution is due.
// Action should be taken at the source warehouse to ensure that the order is received on time.
// TODO vpj-cd I need to create logic for DRP-050 Shipment Pas Due Action Notice
// Indicates that a shipment for a Order Distribution is past due. You should either delay the
// orders created the requirement for the product
// or expedite them when the product does arrive.
if (productPlanningData.getDD_NetworkDistribution_ID() <= 0) {
// Indicates that the Product Planning Data for this product does not specify a valid network
// distribution.
executor.newMRPNote(mrpContext, ERR_DRP_060_NoSourceOfSupply).collect();
//
return;
}
final I_DD_NetworkDistribution network = productPlanningData.getDD_NetworkDistribution();
final List<I_DD_NetworkDistributionLine> networkLines =
Services.get(IDistributionNetworkDAO.class)
.retrieveNetworkLinesByTargetWarehouse(
network, productPlanningData.getM_Warehouse_ID());
if (networkLines.isEmpty()) {
// No network lines were found for our target warehouse
final I_M_Warehouse warehouseTo = productPlanningData.getM_Warehouse();
executor
.newMRPNote(mrpContext, ERR_DRP_060_NoSourceOfSupply)
.setComment("@NotFound@ @DD_NetworkDistributionLine_ID@")
.addParameter(
I_DD_NetworkDistribution.COLUMNNAME_DD_NetworkDistribution_ID,
network == null ? "?" : network.getName())
.addParameter("M_Warehouse_Dest_ID", warehouseTo == null ? "?" : warehouseTo.getName())
.collect();
//
return;
}
int M_Shipper_ID = -1;
I_DD_Order order = null;
BigDecimal qtyToSupplyRemaining = qtyToSupply;
for (final I_DD_NetworkDistributionLine networkLine : networkLines) {
//
// Check: if we created DD Orders for all qty that needed to be supplied, stop here
if (qtyToSupplyRemaining.signum() <= 0) {
break;
}
// get supply source warehouse and locator
final I_M_Warehouse warehouseFrom = networkLine.getM_WarehouseSource();
final I_M_Locator locatorFrom =
Services.get(IWarehouseBL.class).getDefaultLocator(warehouseFrom);
// get supply target warehouse and locator
final I_M_Warehouse warehouseTo = networkLine.getM_Warehouse();
final I_M_Locator locatorTo = Services.get(IWarehouseBL.class).getDefaultLocator(warehouseTo);
if (locatorFrom == null || locatorTo == null) {
executor
.newMRPNote(mrpContext, "DRP-001") // FIXME: DRP-001 error code does not exist
.addParameter(
I_DD_NetworkDistribution.COLUMNNAME_DD_NetworkDistribution_ID,
network == null ? "?" : network.getName())
.addParameter(
I_DD_NetworkDistributionLine.COLUMNNAME_M_WarehouseSource_ID,
warehouseFrom.getName())
.addParameter(
I_DD_NetworkDistributionLine.COLUMNNAME_M_Warehouse_ID, warehouseTo.getName())
.setComment("No locators found for source or target warehouse")
.collect();
//
continue;
}
//
// Get the warehouse in transit
final I_M_Warehouse warehouseInTrasit =
retrieveInTransitWarehouse(ctx, warehouseFrom.getAD_Org_ID());
if (warehouseInTrasit == null) {
// DRP-010: Do not exist Transit Warehouse to this Organization
executor
.newMRPNote(mrpContext, ERR_DRP_010_InTransitWarehouseNotFound)
.addParameter(I_AD_Org.COLUMNNAME_AD_Org_ID, org.getName())
.collect();
//
continue;
}
//
// DRP-030: Do not exist Shipper for Create Distribution Order
if (networkLine.getM_Shipper_ID() <= 0) {
executor
.newMRPNote(mrpContext, "DRP-030")
.addParameter(
I_DD_NetworkDistribution.COLUMNNAME_DD_NetworkDistribution_ID,
network == null ? "?" : network.getName())
.addParameter(
I_DD_NetworkDistributionLine.COLUMNNAME_DD_NetworkDistributionLine_ID, networkLine)
.collect();
//
continue;
}
if (M_Shipper_ID != networkLine.getM_Shipper_ID()) {
// Org Must be linked to BPartner
final I_AD_Org locatorToOrg = locatorTo.getAD_Org();
final IBPartnerOrgBL bpartnerOrgBL = Services.get(IBPartnerOrgBL.class);
final I_C_BPartner orgBPartner = bpartnerOrgBL.retrieveLinkedBPartner(locatorToOrg);
if (orgBPartner == null) {
// DRP-020: Target Org has no BP linked to it
executor
.newMRPNote(mrpContext, "DRP-020")
.addParameter(I_AD_Org.COLUMNNAME_AD_Org_ID, locatorToOrg.getName())
.collect();
//
continue;
}
final I_C_BPartner_Location orgBPLocation =
bpartnerOrgBL.retrieveOrgBPLocation(
mrpContext.getCtx(), locatorToOrg.getAD_Org_ID(), ITrx.TRXNAME_None);
//
// Try found some DD_Order with Shipper , Business Partner and Doc Status = Draft
// Consolidate the demand in a single order for each Shipper , Business Partner ,
// DemandDateStartSchedule
order =
getDDOrderFromCache(
org,
plant,
warehouseInTrasit,
networkLine.getM_Shipper_ID(),
orgBPartner.getC_BPartner_ID(),
supplyDateFinishSchedule);
if (order == null) {
order = InterfaceWrapperHelper.newInstance(I_DD_Order.class, mrpContext);
order.setMRP_Generated(true);
order.setMRP_AllowCleanup(true);
order.setAD_Org_ID(warehouseTo.getAD_Org_ID());
order.setPP_Plant(plant);
order.setC_BPartner(orgBPartner);
order.setC_BPartner_Location(orgBPLocation);
// order.setAD_User_ID(productPlanningData.getPlanner_ID()); // FIXME: improve
// performances/cache and retrive Primary BP's User
order.setSalesRep_ID(productPlanningData.getPlanner_ID());
final int docTypeDO_ID =
getC_DocType_ID(mrpContext, X_C_DocType.DOCBASETYPE_DistributionOrder);
order.setC_DocType_ID(docTypeDO_ID);
order.setM_Warehouse(warehouseInTrasit);
order.setDocStatus(X_DD_Order.DOCSTATUS_Drafted);
order.setDocAction(X_DD_Order.DOCACTION_Complete);
order.setDateOrdered(mrpContext.getDateAsTimestamp());
order.setDatePromised(supplyDateFinishSchedule);
order.setM_Shipper_ID(networkLine.getM_Shipper_ID());
order.setIsInDispute(false);
order.setIsInTransit(false);
InterfaceWrapperHelper.save(order);
executor.addGeneratedSupplyDocument(order);
addToCache(order);
}
M_Shipper_ID = networkLine.getM_Shipper_ID();
}
//
// Crate DD order line
final BigDecimal qtyToMove =
calculateQtyToMove(qtyToSupplyRemaining, networkLine.getPercent());
createDD_OrderLine(
mrpContext,
order,
networkLine,
locatorFrom,
locatorTo,
qtyToMove,
supplyDateFinishSchedule,
request);
qtyToSupplyRemaining = qtyToSupplyRemaining.subtract(qtyToMove);
}
//
// Check: remaining qtyToSupply shall be ZERO
if (qtyToSupplyRemaining.signum() != 0) {
// TODO: introduce DRP-XXX notice
throw new LiberoException(
"Cannot create DD Order for required Qty To Supply."
+ "\nQtyToSupply: "
+ qtyToSupply
+ "\nQtyToSupply (remaining): "
+ qtyToSupplyRemaining
+ "\n@DD_NetworkDistribution_ID@: "
+ network
+ "\n@DD_NetworkDistributionLine_ID@: "
+ networkLines
+ "\nMRPContext: "
+ mrpContext);
}
}
