/// <summary>
/// Generate Shipments
/// </summary>
/// <param name="idr">Order Query</param>
/// <returns>info</returns>
private String Generate(IDataReader idr)
{
DataTable dt = new DataTable();
MClient client = MClient.Get(GetCtx());
try
{
dt.Load(idr);
idr.Close();
//ResultSet dr = pstmt.executeQuery();
foreach (DataRow dr in dt.Rows)// while (dr.next ()) // Order
{
MOrder order = new MOrder(GetCtx(), dr, Get_TrxName());
// New Header different Shipper, Shipment Location
if (!_consolidateDocument ||
(_shipment != null &&
(_shipment.GetC_BPartner_Location_ID() != order.GetC_BPartner_Location_ID() ||
_shipment.GetM_Shipper_ID() != order.GetM_Shipper_ID())))
{
CompleteShipment();
}
log.Fine("check: " + order + " - DeliveryRule=" + order.GetDeliveryRule());
//
DateTime?minGuaranteeDate = _movementDate;
bool completeOrder = MOrder.DELIVERYRULE_CompleteOrder.Equals(order.GetDeliveryRule());
// OrderLine WHERE
String where = " AND M_Warehouse_ID=" + _M_Warehouse_ID;
if (_datePromised != null)
{
where += " AND (TRUNC(DatePromised,'DD')<=" + DB.TO_DATE((DateTime?)_datePromised, true)
+ " OR DatePromised IS NULL)";
//where += " AND (TRUNC(DatePromised,'DD')<='" + String.Format("{0:dd-MMM-yy}", _datePromised)
// + "' OR DatePromised IS NULL)";
}
// Exclude Auto Delivery if not Force
if (!MOrder.DELIVERYRULE_Force.Equals(order.GetDeliveryRule()))
{
where += " AND (C_OrderLine.M_Product_ID IS NULL"
+ " OR EXISTS (SELECT * FROM M_Product p "
+ "WHERE C_OrderLine.M_Product_ID=p.M_Product_ID"
+ " AND IsExcludeAutoDelivery='N'))";
}
// Exclude Unconfirmed
if (!_isUnconfirmedInOut)
{
where += " AND NOT EXISTS (SELECT * FROM M_InOutLine iol"
+ " INNER JOIN M_InOut io ON (iol.M_InOut_ID=io.M_InOut_ID) "
+ "WHERE iol.C_OrderLine_ID=C_OrderLine.C_OrderLine_ID AND io.DocStatus IN ('IP','WC'))";
}
// Deadlock Prevention - Order by M_Product_ID
MOrderLine[] lines = order.GetLines(where, "ORDER BY C_BPartner_Location_ID, M_Product_ID");
for (int i = 0; i < lines.Length; i++)
{
MOrderLine line = lines[i];
if (line.GetM_Warehouse_ID() != _M_Warehouse_ID)
{
continue;
}
log.Fine("check: " + line);
Decimal onHand = Env.ZERO;
Decimal toDeliver = Decimal.Subtract(line.GetQtyOrdered(),
line.GetQtyDelivered());
MProduct product = line.GetProduct();
// Nothing to Deliver
if (product != null && Env.Signum(toDeliver) == 0)
{
continue;
}
// Check / adjust for confirmations
Decimal unconfirmedShippedQty = Env.ZERO;
if (_isUnconfirmedInOut && product != null && Env.Signum(toDeliver) != 0)
{
String where2 = "EXISTS (SELECT * FROM M_InOut io WHERE io.M_InOut_ID=M_InOutLine.M_InOut_ID AND io.DocStatus IN ('IP','WC'))";
MInOutLine[] iols = MInOutLine.GetOfOrderLine(GetCtx(),
line.GetC_OrderLine_ID(), where2, null);
for (int j = 0; j < iols.Length; j++)
{
unconfirmedShippedQty = Decimal.Add(unconfirmedShippedQty, iols[j].GetMovementQty());
}
String logInfo = "Unconfirmed Qty=" + unconfirmedShippedQty
+ " - ToDeliver=" + toDeliver + "->";
toDeliver = Decimal.Subtract(toDeliver, unconfirmedShippedQty);
logInfo += toDeliver;
if (Env.Signum(toDeliver) < 0)
{
toDeliver = Env.ZERO;
logInfo += " (set to 0)";
}
// Adjust On Hand
onHand = Decimal.Subtract(onHand, unconfirmedShippedQty);
log.Fine(logInfo);
}
// Comments & lines w/o product & services
if ((product == null || !product.IsStocked()) &&
(Env.Signum(line.GetQtyOrdered()) == 0 || // comments
Env.Signum(toDeliver) != 0)) // lines w/o product
{
if (!MOrder.DELIVERYRULE_CompleteOrder.Equals(order.GetDeliveryRule())) // printed later
{
CreateLine(order, line, toDeliver, null, false);
}
continue;
}
// Stored Product
MProductCategory pc = MProductCategory.Get(order.GetCtx(), product.GetM_Product_Category_ID());
String MMPolicy = pc.GetMMPolicy();
if (MMPolicy == null || MMPolicy.Length == 0)
{
MMPolicy = client.GetMMPolicy();
}
//
MStorage[] storages = GetStorages(line.GetM_Warehouse_ID(),
line.GetM_Product_ID(), line.GetM_AttributeSetInstance_ID(),
product.GetM_AttributeSet_ID(),
line.GetM_AttributeSetInstance_ID() == 0,
(DateTime?)minGuaranteeDate,
MClient.MMPOLICY_FiFo.Equals(MMPolicy));
for (int j = 0; j < storages.Length; j++)
{
MStorage storage = storages[j];
onHand = Decimal.Add(onHand, storage.GetQtyOnHand());
}
bool fullLine = onHand.CompareTo(toDeliver) >= 0 ||
Env.Signum(toDeliver) < 0;
// Complete Order
if (completeOrder && !fullLine)
{
log.Fine("Failed CompleteOrder - OnHand=" + onHand
+ " (Unconfirmed=" + unconfirmedShippedQty
+ "), ToDeliver=" + toDeliver + " - " + line);
completeOrder = false;
break;
}
// Complete Line
else if (fullLine && MOrder.DELIVERYRULE_CompleteLine.Equals(order.GetDeliveryRule()))
{
log.Fine("CompleteLine - OnHand=" + onHand
+ " (Unconfirmed=" + unconfirmedShippedQty
+ ", ToDeliver=" + toDeliver + " - " + line);
//
CreateLine(order, line, toDeliver, storages, false);
}
// Availability
else if (MOrder.DELIVERYRULE_Availability.Equals(order.GetDeliveryRule()) &&
(Env.Signum(onHand) > 0 ||
Env.Signum(toDeliver) < 0))
{
Decimal deliver = toDeliver;
if (deliver.CompareTo(onHand) > 0)
{
deliver = onHand;
}
log.Fine("Available - OnHand=" + onHand
+ " (Unconfirmed=" + unconfirmedShippedQty
+ "), ToDeliver=" + toDeliver
+ ", Delivering=" + deliver + " - " + line);
//
CreateLine(order, line, deliver, storages, false);
}
// Force
else if (MOrder.DELIVERYRULE_Force.Equals(order.GetDeliveryRule()))
{
Decimal deliver = toDeliver;
log.Fine("Force - OnHand=" + onHand
+ " (Unconfirmed=" + unconfirmedShippedQty
+ "), ToDeliver=" + toDeliver
+ ", Delivering=" + deliver + " - " + line);
//
CreateLine(order, line, deliver, storages, true);
}
// Manual
else if (MOrder.DELIVERYRULE_Manual.Equals(order.GetDeliveryRule()))
{
log.Fine("Manual - OnHand=" + onHand
+ " (Unconfirmed=" + unconfirmedShippedQty
+ ") - " + line);
}
else
{
log.Fine("Failed: " + order.GetDeliveryRule() + " - OnHand=" + onHand
+ " (Unconfirmed=" + unconfirmedShippedQty
+ "), ToDeliver=" + toDeliver + " - " + line);
}
} // for all order lines
// Complete Order successful
if (completeOrder && MOrder.DELIVERYRULE_CompleteOrder.Equals(order.GetDeliveryRule()))
{
for (int i = 0; i < lines.Length; i++)
{
MOrderLine line = lines[i];
if (line.GetM_Warehouse_ID() != _M_Warehouse_ID)
{
continue;
}
MProduct product = line.GetProduct();
Decimal toDeliver = Decimal.Subtract(line.GetQtyOrdered(), line.GetQtyDelivered());
//
MStorage[] storages = null;
if (product != null && product.IsStocked())
{
MProductCategory pc = MProductCategory.Get(order.GetCtx(), product.GetM_Product_Category_ID());
String MMPolicy = pc.GetMMPolicy();
if (MMPolicy == null || MMPolicy.Length == 0)
{
MMPolicy = client.GetMMPolicy();
}
//
storages = GetStorages(line.GetM_Warehouse_ID(),
line.GetM_Product_ID(), line.GetM_AttributeSetInstance_ID(),
product.GetM_AttributeSet_ID(),
line.GetM_AttributeSetInstance_ID() == 0, (DateTime?)minGuaranteeDate,
MClient.MMPOLICY_FiFo.Equals(MMPolicy));
}
//
CreateLine(order, line, toDeliver, storages, false);
}
}
_line += 1000;
} // while order
}
catch (Exception e)
{
if (idr != null)
{
idr.Close();
}
log.Log(Level.SEVERE, _sql, e);
}
finally
{
if (idr != null)
{
idr.Close();
}
dt = null;
}
CompleteShipment();
return("@Created@ = " + _created);
}