org.compiere.model
Class MWarehousePrice

java.lang.Object
  org.compiere.framework.PO
      org.compiere.model.X_RV_WarehousePrice
          org.compiere.model.MWarehousePrice

All Implemented Interfaces:

Serializable, Cloneable, Comparator<PO>, 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.X_RV_WarehousePrice

accessLevel, Model, Table_ID, Table_Name, updatedMS

Fields inherited from class org.compiere.framework.PO

ACCESSLEVEL_ALL, ACCESSLEVEL_CLIENT, ACCESSLEVEL_CLIENTORG, ACCESSLEVEL_ORG, ACCESSLEVEL_SYSTEM, ACCESSLEVEL_SYSTEMCLIENT, ENTITYTYPE_Dictionary, ENTITYTYPE_UserMaintained, I_ZERO, log, p_changeVO, p_info, XML_ATTRIBUTE_AD_Table_ID, XML_ATTRIBUTE_Record_ID

Constructor Summary

MWarehousePrice(Ctx ctx, ResultSet rs, String trxName)
Load Constructor

Method Summary

static MWarehousePrice[]	find(Ctx 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_ID, getM_PriceList_Version_ID, getM_Product_ID, 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.framework.PO

addAttachment, addAttachment, addError, afterDelete, afterSave, beforeDelete, beforeSave, compare, convertToBigDecimal, convertToBoolean, convertToInt, convertToTimestamp, copy, copyValues, copyValues, createAttachment, delete_Accounting, delete, delete, dump, dump, equals, get_ChangeVO, get_ColumnCount, get_ColumnDescription, get_ColumnDisplayType, get_ColumnIndex, get_ColumnLabel, get_ColumnLookup, get_ColumnName, get_DisplayValue, get_EntityType, get_HashMap, get_ID, get_IDOld, get_Info, get_KeyColumns, get_Logger, get_Table_ID, get_Table_ID, get_TableName, get_Translation, get_TrxName, get_Value, get_Value, get_ValueAsInt, get_ValueAsInt, get_ValueAsString, get_ValueDifference, get_ValueDifference, get_ValueOfColumn, get_ValueOld, get_ValueOld, get_ValueOldAsInt, get_ValuesAsString, get_WhereClause, get_xmlDocument, get_xmlString, get_xmlString, getAD_Client_ID, getAD_Org_ID, getAllIDs, getAttachment, getAttachment, getAttachmentData, getCreated, getCreatedBy, getCtx, getFindParameter, getPdfAttachment, getUpdated, getUpdatedBy, getVO, hashCode, insert_Accounting, is_Changed, is_KeyColumn, is_new, is_ValueChanged, is_ValueChanged, isActive, isAttachment, isColumnMandatory, isColumnUpdateable, isMandatoryOK, isPdfAttachment, load, load, load, load, loadComplete, loadDefaults, loadSpecial, lock, save, save, saveNew_getID, saveNewInsertSQL, saveNewSpecial, saveUpdate, set_ChangeVO, set_ColumnUpdateable, set_CustomColumn, set_TrxName, set_Value, set_Value, set_ValueE, set_ValueNoCheck, set_ValueNoCheckE, set_ValueOfColumn, set_ValueString, setAD_Client_ID, setAD_Org_ID, setClientOrg, setClientOrg, setContext, setCtx, setDocWorkflowMgr, setIsActive, setStandardDefaults, setUpdateable, setUpdatedBy, toStringX, unlock, update

Methods inherited from class java.lang.Object

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

Constructor Detail

MWarehousePrice

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

Load Constructor

Parameters:

ctx - context

rs - result set

trxName - transaction

Method Detail

find

public static MWarehousePrice[] find(Ctx 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 full match upc

SKU - optional full match ski

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 ski

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

M_Warehouse_ID - wh

trxName - transaction

Returns:

warehouse price

isAvailable

public boolean isAvailable()

Is Product Available

Returns:

true if available qty > 0