Package org.compiere.model

Class MStorageReservation

java.lang.Object

org.compiere.model.PO

org.compiere.model.X_M_StorageReservation

org.compiere.model.MStorageReservation

All Implemented Interfaces:

Serializable, Cloneable, Comparator<Object>, I_M_StorageReservation, I_Persistent, Evaluatee

public class MStorageReservation
extends X_M_StorageReservation

Inventory reservation storage model

See Also:

• Serialized Form

Field Summary

Fields inherited from class org.compiere.model.PO

ACCESSLEVEL_ALL, ACCESSLEVEL_CLIENT, ACCESSLEVEL_CLIENTORG, ACCESSLEVEL_ORG, ACCESSLEVEL_SYSTEM, ACCESSLEVEL_SYSTEMCLIENT, ENTITYTYPE_Dictionary, ENTITYTYPE_UserMaintained, I_ZERO, LOCAL_TRX_PREFIX, log, p_ctx, p_info, UUID_NEW_RECORD, XML_ATTRIBUTE_AD_Table_ID, XML_ATTRIBUTE_Record_ID

Fields inherited from interface org.compiere.model.I_M_StorageReservation

accessLevel, COLUMNNAME_AD_Client_ID, COLUMNNAME_AD_Org_ID, COLUMNNAME_Created, COLUMNNAME_CreatedBy, COLUMNNAME_DateLastInventory, COLUMNNAME_IsActive, COLUMNNAME_IsSOTrx, COLUMNNAME_M_AttributeSetInstance_ID, COLUMNNAME_M_Product_ID, COLUMNNAME_M_StorageReservation_UU, COLUMNNAME_M_Warehouse_ID, COLUMNNAME_Qty, COLUMNNAME_Updated, COLUMNNAME_UpdatedBy, Model, Table_ID, Table_Name

Constructor Summary

Constructors

Constructor	Description
MStorageReservation(Properties ctx, int M_StorageReservation_ID, String trxName)
MStorageReservation(Properties ctx, String M_StorageReservation_UU, String trxName)	UUID based Constructor
MStorageReservation(Properties ctx, ResultSet rs, String trxName)

Method Summary

Modifier and Type	Method	Description
static boolean	add(Properties ctx, int M_Warehouse_ID, int M_Product_ID, int M_AttributeSetInstance_ID, int reservationAttributeSetInstance_ID, BigDecimal diffQty, boolean isSOTrx, String trxName)	Deprecated.
static boolean	add(Properties ctx, int M_Warehouse_ID, int M_Product_ID, int M_AttributeSetInstance_ID, BigDecimal diffQty, boolean isSOTrx, String trxName)	Deprecated.
static boolean	add(Properties ctx, int M_Warehouse_ID, int M_Product_ID, int M_AttributeSetInstance_ID, BigDecimal diffQty, boolean isSOTrx, String trxName, IReservationTracer tracer)	Add diffQty to quantity reserved/ordered
void	addQty(BigDecimal addition)	Deprecated.
void	addQty(BigDecimal addition, IReservationTracer tracer)	Add addition to Qty of this record using direct SQL - not using cached value - solving IDEMPIERE-2629
static MStorageReservation	get(Properties ctx, int M_Warehouse_ID, int M_Product_ID, int M_AttributeSetInstance_ID, boolean isSOTrx, String trxName)	Get Reservation Storage
static MStorageReservation[]	get(Properties ctx, int m_Warehouse_ID, int m_Product_ID, int i, String trxName)	Get Reservation Storage for Product on specified Warehouse
static MStorageReservation	getCreate(Properties ctx, int M_Warehouse_ID, int M_Product_ID, int M_AttributeSetInstance_ID, boolean isSOTrx, String trxName)	Create or Get Reservation Storage
static MStorageReservation[]	getOfProduct(Properties ctx, int M_Product_ID, String trxName)	Get Reservation Storage for Product across warehouses
static BigDecimal	getQty(int M_Product_ID, int M_Warehouse_ID, int M_AttributeSetInstance_ID, boolean isSOTrx, String trxName)	Get Quantity Reserved/Ordered of Warehouse
static BigDecimal	getQtyAvailable(int M_Warehouse_ID, int M_Product_ID, int M_AttributeSetInstance_ID, String trxName)	Get Available Qty (On Hand - Reserved)
String	toString()	String Representation

Methods inherited from class org.compiere.model.X_M_StorageReservation

get_AccessLevel, getDateLastInventory, getM_AttributeSetInstance, getM_AttributeSetInstance_ID, getM_Product, getM_Product_ID, getM_StorageReservation_UU, getM_Warehouse, getM_Warehouse_ID, getQty, initPO, isSOTrx, setDateLastInventory, setIsSOTrx, setM_AttributeSetInstance_ID, setM_Product_ID, setM_StorageReservation_UU, setM_Warehouse_ID, setQty

Methods inherited from class org.compiere.model.PO

afterDelete, afterSave, beforeDelete, beforeSave, buildInsertSQL, checkImmutable, clearCrossTenantSafe, clone, columnExists, columnExists, compare, copyPO, copyValues, copyValues, createAttachment, delete, delete, delete_Accounting, delete_Tree, deleteEx, deleteEx, dump, dump, equals, get_Attribute, get_Attributes, get_ColumnCount, get_ColumnDescription, get_ColumnDisplayType, get_ColumnIndex, get_ColumnLabel, get_ColumnLookup, get_ColumnName, get_DisplayValue, get_HashMap, get_ID, get_IDOld, get_KeyColumns, get_Logger, get_OptimisticLockingColumns, get_Table_ID, get_TableAttribute, get_TableAttributeAsBoolean, get_TableAttributeAsInt, get_TableAttributes, get_TableName, get_Translation, get_Translation, get_Translation, get_Translation, get_Translation, get_TrxName, get_UUID, get_Value, get_Value, get_ValueAsBoolean, get_ValueAsInt, get_ValueAsInt, get_ValueAsString, get_ValueAsString, get_ValueDifference, get_ValueDifference, get_ValueE, get_ValueOfColumn, get_ValueOld, get_ValueOld, get_ValueOldAsInt, get_WhereClause, get_WhereClause, get_xmlDocument, get_xmlString, getAD_Client_ID, getAD_Org_ID, getAllIDs, getAttachment, getAttachment, getAttachmentData, getCreated, getCreatedBy, getCtx, getDoc, getFindParameter, getPdfAttachment, getUpdated, getUpdatedBy, getUUIDColumnName, getUUIDColumnName, hashCode, insert_Accounting, insert_Tree, insert_Tree, is_Changed, is_Immutable, is_new, is_UseOptimisticLocking, is_ValueChanged, is_ValueChanged, isActive, isAttachment, isColumnMandatory, isColumnUpdateable, isMandatoryOK, isPdfAttachment, isReplication, load, load, load, load, loadByUU, loadComplete, loadDefaults, loadPO, loadSpecial, lock, makeImmutable, postDelete, retrieveIdOfParentValue, retrieveIdOfParentValue, save, save, saveCrossTenantSafe, saveCrossTenantSafeEx, saveCrossTenantSafeEx, saveEx, saveEx, saveNew_afterSetID, saveNew_getID, saveNewSpecial, saveReplica, saveUpdate, set_Attribute, set_ColumnUpdateable, set_CustomColumn, set_CustomColumnReturningBoolean, set_OptimisticLockingColumns, set_TrxName, set_TrxName, set_UseOptimisticLocking, set_Value, set_Value, set_Value, set_Value, set_ValueE, set_ValueNoCheck, set_ValueNoCheckE, set_ValueOfColumn, set_ValueOfColumn, set_ValueOfColumnReturningBoolean, set_ValueOfColumnReturningBoolean, setAD_Client_ID, setAD_Org_ID, setClientOrg, setClientOrg, setCrossTenantSafe, setDoc, setDocWorkflowMgr, setIsActive, setProcessedOn, setReplication, setStandardDefaults, setUpdateable, setUpdatedBy, toInsertSQL, unlock, update_Tree, validForeignKeys, validForeignKeysEx

Methods inherited from class java.lang.Object

finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface java.util.Comparator

reversed, thenComparing, thenComparing, thenComparing, thenComparingDouble, thenComparingInt, thenComparingLong

Methods inherited from interface org.compiere.model.I_M_StorageReservation

getAD_Client_ID, getAD_Org_ID, getCreated, getCreatedBy, getUpdated, getUpdatedBy, isActive, setAD_Org_ID, setIsActive

Methods inherited from interface org.compiere.model.I_Persistent

save

Constructor Details

MStorageReservation

public MStorageReservation(Properties ctx,
 String M_StorageReservation_UU,
 String trxName)

UUID based Constructor

Parameters:

ctx - Context

M_StorageReservation_UU - UUID key

trxName - Transaction

MStorageReservation

public MStorageReservation(Properties ctx,
 int M_StorageReservation_ID,
 String trxName)

Parameters:

ctx -

M_StorageReservation_ID -

trxName -

MStorageReservation

public MStorageReservation(Properties ctx,
 ResultSet rs,
 String trxName)

Parameters:

ctx -

rs -

trxName -

Method Details

get

public static MStorageReservation get(Properties ctx,
 int M_Warehouse_ID,
 int M_Product_ID,
 int M_AttributeSetInstance_ID,
 boolean isSOTrx,
 String trxName)

Get Reservation Storage

Parameters:

ctx - context

M_Warehouse_ID - warehouse

M_Product_ID - product

M_AttributeSetInstance_ID - instance

isSOTrx -

trxName - transaction

Returns:

existing MStorageReservation or null

get

public static MStorageReservation[] get(Properties ctx,
 int m_Warehouse_ID,
 int m_Product_ID,
 int i,
 String trxName)

Get Reservation Storage for Product on specified Warehouse

Parameters:

ctx -

m_Warehouse_ID -

m_Product_ID -

i - not use

trxName -

Returns:

array of MStorageReservation

getOfProduct

public static MStorageReservation[] getOfProduct(Properties ctx,
 int M_Product_ID,
 String trxName)

Get Reservation Storage for Product across warehouses

Parameters:

ctx - context

M_Product_ID - product

trxName - transaction

Returns:

array of MStorageReservation

getQty

public static BigDecimal getQty(int M_Product_ID,
 int M_Warehouse_ID,
 int M_AttributeSetInstance_ID,
 boolean isSOTrx,
 String trxName)

Get Quantity Reserved/Ordered of Warehouse

Parameters:

M_Product_ID -

M_Warehouse_ID -

M_AttributeSetInstance_ID - M_AttributeSetInstance_ID filter if > 0

isSOTrx - - true to get reserved, false to get ordered

trxName -

Returns:

quantity reserved/ordered

getQtyAvailable

public static BigDecimal getQtyAvailable(int M_Warehouse_ID,
 int M_Product_ID,
 int M_AttributeSetInstance_ID,
 String trxName)

Get Available Qty (On Hand - Reserved)

Parameters:

M_Warehouse_ID - wh

M_Product_ID - product

M_AttributeSetInstance_ID - masi

trxName - transaction

Returns:

qty available (QtyOnHand-QtyReserved)

add

@Deprecated
public static boolean add(Properties ctx,
 int M_Warehouse_ID,
 int M_Product_ID,
 int M_AttributeSetInstance_ID,
 BigDecimal diffQty,
 boolean isSOTrx,
 String trxName)

Deprecated.

Parameters:

ctx -

M_Warehouse_ID -

M_Product_ID -

M_AttributeSetInstance_ID -

diffQty -

isSOTrx -

trxName -

Returns:

true if ok

add

public static boolean add(Properties ctx,
 int M_Warehouse_ID,
 int M_Product_ID,
 int M_AttributeSetInstance_ID,
 BigDecimal diffQty,
 boolean isSOTrx,
 String trxName,
 IReservationTracer tracer)

Add diffQty to quantity reserved/ordered

Parameters:

ctx -

M_Warehouse_ID -

M_Product_ID -

M_AttributeSetInstance_ID -

diffQty - difference to add to quantity reserved/ordered

isSOTrx - true for quantity reserved, false for quantity ordered

trxName -

tracer -

Returns:

true if ok

addQty

@Deprecated
public void addQty(BigDecimal addition)

Deprecated.

Add quantity on hand directly - not using cached value - solving IDEMPIERE-2629

Parameters:

addition -

addQty

public void addQty(BigDecimal addition,
 IReservationTracer tracer)

Add addition to Qty of this record using direct SQL - not using cached value - solving IDEMPIERE-2629

Parameters:

addition -

add

@Deprecated
public static boolean add(Properties ctx,
 int M_Warehouse_ID,
 int M_Product_ID,
 int M_AttributeSetInstance_ID,
 int reservationAttributeSetInstance_ID,
 BigDecimal diffQty,
 boolean isSOTrx,
 String trxName)

Deprecated.

Update Reservation Storage Called from MProjectIssue

Parameters:

ctx - context

M_Warehouse_ID - warehouse

M_Product_ID - product

M_AttributeSetInstance_ID - AS Instance

reservationAttributeSetInstance_ID - reservation AS Instance

diffQty - add

isSOTrx -

trxName - transaction

Returns:

true if updated

getCreate

public static MStorageReservation getCreate(Properties ctx,
 int M_Warehouse_ID,
 int M_Product_ID,
 int M_AttributeSetInstance_ID,
 boolean isSOTrx,
 String trxName)

Create or Get Reservation Storage

Parameters:

ctx - context

M_Warehouse_ID -

M_Product_ID - product

M_AttributeSetInstance_ID - instance

isSOTrx - true for quantity reserved, false for quantity ordered

trxName - transaction

Returns:

existing or new MStorageReservation

toString

public String toString()

String Representation

Overrides:

toString in class X_M_StorageReservation

Returns:

info