/**
* Creates a dummy MRP firm demand.
*
* <p>NOTE:
*
* <ul>
* <li>DocStatus will be Completed
* <li>OrderType will be SalesOrder
* </ul>
*
* @param product
* @param qty
* @param date
* @param plant
* @param warehouse
* @return demand MRP record
*/
public I_PP_MRP createMRPDemand(
final I_M_Product product,
final BigDecimal qty,
final Date date,
final I_S_Resource plant,
final I_M_Warehouse warehouse,
final I_C_BPartner bpartner) {
final I_PP_MRP mrp = InterfaceWrapperHelper.newInstance(I_PP_MRP.class, contextProvider);
mrp.setAD_Org_ID(warehouse.getAD_Org_ID());
mrp.setS_Resource(plant);
mrp.setM_Warehouse(warehouse);
mrp.setC_BPartner(bpartner);
//
final Timestamp dateTS = TimeUtil.asTimestamp(date);
mrp.setDatePromised(dateTS);
mrp.setDateStartSchedule(dateTS);
mrp.setDateFinishSchedule(dateTS);
//
mrp.setTypeMRP(X_PP_MRP.TYPEMRP_Demand);
mrp.setDocStatus(X_PP_MRP.DOCSTATUS_Completed); // Firm Demand
mrp.setOrderType(X_PP_MRP.ORDERTYPE_SalesOrder); // Sales Order
mrp.setIsAvailable(true);
//
mrp.setM_Product(product);
Services.get(IMRPBL.class).setQty(mrp, qty, qty, product.getC_UOM());
//
// mrp.setC_BPartner(C_BPartner);
InterfaceWrapperHelper.save(mrp);
return mrp;
}
@Override
public void setParameterValue(
final I_C_Queue_WorkPackage_Param workpackageParam, final Object parameterValue) {
// NOTE to developer: when changing this, make sure you are also changing the counterpart method
// createProcessInfoParameter()
if (parameterValue == null) {
workpackageParam.setAD_Reference_ID(DisplayType.String);
resetParameterValue(workpackageParam);
} else if (parameterValue instanceof String) {
workpackageParam.setAD_Reference_ID(DisplayType.String);
resetParameterValue(workpackageParam);
workpackageParam.setP_String(parameterValue.toString());
} else if (parameterValue instanceof Date) {
final Date date = (Date) parameterValue;
workpackageParam.setAD_Reference_ID(DisplayType.DateTime);
resetParameterValue(workpackageParam);
workpackageParam.setP_Date(TimeUtil.asTimestamp(date));
} else if (parameterValue instanceof BigDecimal) {
final BigDecimal valueBD = (BigDecimal) parameterValue;
workpackageParam.setAD_Reference_ID(DisplayType.Number);
resetParameterValue(workpackageParam);
workpackageParam.setP_Number(valueBD);
} else if (parameterValue instanceof Number) {
final int valueInt = ((Number) parameterValue).intValue();
workpackageParam.setAD_Reference_ID(DisplayType.Integer);
resetParameterValue(workpackageParam);
workpackageParam.setP_Number(BigDecimal.valueOf(valueInt));
} else if (parameterValue instanceof Boolean) {
final boolean valueBoolean = (boolean) parameterValue;
workpackageParam.setAD_Reference_ID(DisplayType.YesNo);
resetParameterValue(workpackageParam);
workpackageParam.setP_String(DisplayType.toBooleanString(valueBoolean));
} else {
throw new IllegalArgumentException(
"Unsupported parameter value: "
+ parameterValue
+ " ("
+ parameterValue.getClass()
+ ")");
}
}
@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);
}
}