Package org.compiere.model

Class MWarehousePrice

java.lang.Object

org.compiere.model.PO

org.compiere.model.X_RV_WarehousePrice

org.compiere.model.MWarehousePrice

All Implemented Interfaces:

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

public class MWarehousePrice
extends X_RV_WarehousePrice

Product Warehouse Availability and Price Model.
The Ownership (Client, Org) is determined by the Warehouse.
Active is determined if the product is discontinued (the product/price/warehouse need to be active).
Created.. is determined by the price list version.

Version:

$Id: MWarehousePrice.java,v 1.3 2006/07/30 00:51:02 jjanke Exp $

Author:

Jorg Janke

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_RV_WarehousePrice

accessLevel, COLUMNNAME_AD_Client_ID, COLUMNNAME_AD_Org_ID, COLUMNNAME_C_UOM_ID, COLUMNNAME_Created, COLUMNNAME_CreatedBy, COLUMNNAME_IsActive, COLUMNNAME_IsInstanceAttribute, COLUMNNAME_M_PriceList_Version_ID, COLUMNNAME_M_Product_ID, COLUMNNAME_M_Warehouse_ID, COLUMNNAME_Margin, COLUMNNAME_Name, COLUMNNAME_PriceLimit, COLUMNNAME_PriceList, COLUMNNAME_PriceStd, COLUMNNAME_QtyAvailable, COLUMNNAME_QtyOnHand, COLUMNNAME_QtyOrdered, COLUMNNAME_QtyReserved, COLUMNNAME_SKU, COLUMNNAME_UOMSymbol, COLUMNNAME_UPC, COLUMNNAME_Updated, COLUMNNAME_UpdatedBy, COLUMNNAME_Value, COLUMNNAME_WarehouseName, Model, Table_ID, Table_Name

Constructor Summary

Constructors

Constructor	Description
MWarehousePrice(Properties ctx, String RV_WarehousePrice_UU, String trxName)	UUID based Constructor
MWarehousePrice(Properties ctx, ResultSet rs, String trxName)	Load Constructor

Method Summary

Modifier and Type	Method	Description
static MWarehousePrice[]	find(Properties ctx, int M_PriceList_Version_ID, int M_Warehouse_ID, String Value, String Name, String UPC, String SKU, String trxName)	Find Products in Warehouse with Price
static MWarehousePrice[]	find(MBPartner bPartner, boolean IsSOTrx, Timestamp valid, int M_Warehouse_ID, String Value, String Name, String UPC, String SKU, String trxName)	Find Products in Warehouse with Price for customer
static MWarehousePrice	get(MProduct product, int M_PriceList_Version_ID, int M_Warehouse_ID, String trxName)	Get MWarehouse Price
boolean	isAvailable()	Is Product Available

Methods inherited from class org.compiere.model.X_RV_WarehousePrice

get_AccessLevel, getC_UOM, getC_UOM_ID, getM_PriceList_Version, getM_PriceList_Version_ID, getM_Product, getM_Product_ID, getM_Warehouse, getM_Warehouse_ID, getMargin, getName, getPriceLimit, getPriceList, getPriceStd, getQtyAvailable, getQtyOnHand, getQtyOrdered, getQtyReserved, getSKU, getUOMSymbol, getUPC, getValue, getWarehouseName, initPO, isInstanceAttribute, setC_UOM_ID, setIsInstanceAttribute, setM_PriceList_Version_ID, setM_Product_ID, setM_Warehouse_ID, setMargin, setName, setPriceLimit, setPriceList, setPriceStd, setQtyAvailable, setQtyOnHand, setQtyOrdered, setQtyReserved, setSKU, setUOMSymbol, setUPC, setValue, setWarehouseName, toString

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_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

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_Persistent

save

Methods inherited from interface org.compiere.model.I_RV_WarehousePrice

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

Constructor Details

MWarehousePrice

public MWarehousePrice(Properties ctx,
 String RV_WarehousePrice_UU,
 String trxName)

UUID based Constructor

Parameters:

ctx - Context

RV_WarehousePrice_UU - UUID key

trxName - Transaction

MWarehousePrice

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

Load Constructor

Parameters:

ctx - context

rs - result set

trxName - transaction

Method Details

find

public static MWarehousePrice[] find(Properties ctx,
 int M_PriceList_Version_ID,
 int M_Warehouse_ID,
 String Value,
 String Name,
 String UPC,
 String SKU,
 String trxName)

Find Products in Warehouse with Price

Parameters:

ctx - context

M_PriceList_Version_ID - mandatory price list

M_Warehouse_ID - mandatory warehouse

Value - optional value

Name - optional name

UPC - optional fully match upc

SKU - optional full match sku

trxName - transaction

Returns:

array of product prices and warehouse availability

find

public static MWarehousePrice[] find(MBPartner bPartner,
 boolean IsSOTrx,
 Timestamp valid,
 int M_Warehouse_ID,
 String Value,
 String Name,
 String UPC,
 String SKU,
 String trxName)

Find Products in Warehouse with Price for customer

Parameters:

bPartner - business partner

IsSOTrx - if true SO

valid - the date the price must be valid

M_Warehouse_ID - mandatory warehouse

Value - optional value

Name - optional name

UPC - optional upc

SKU - optional sku

trxName - transaction

Returns:

array of product prices and warehouse availability or null

get

public static MWarehousePrice get(MProduct product,
 int M_PriceList_Version_ID,
 int M_Warehouse_ID,
 String trxName)

Get MWarehouse Price

Parameters:

product - product

M_PriceList_Version_ID -

M_Warehouse_ID -

trxName - transaction

Returns:

warehouse price

isAvailable

public boolean isAvailable()

Is Product Available

Returns:

true if available qty > 0