Package org.compiere.model

Class MCostQueue

java.lang.Object

org.compiere.model.PO

org.compiere.model.X_M_CostQueue

org.compiere.model.MCostQueue

All Implemented Interfaces:

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

public class MCostQueue
extends X_M_CostQueue

Cost Queue Model

Version:

$Id: MCostQueue.java,v 1.3 2006/07/30 00:51:05 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, XML_ATTRIBUTE_AD_Table_ID, XML_ATTRIBUTE_Record_ID

Fields inherited from interface org.compiere.model.I_M_CostQueue

accessLevel, COLUMNNAME_AD_Client_ID, COLUMNNAME_AD_Org_ID, COLUMNNAME_C_AcctSchema_ID, COLUMNNAME_Created, COLUMNNAME_CreatedBy, COLUMNNAME_CurrentCostPrice, COLUMNNAME_CurrentQty, COLUMNNAME_IsActive, COLUMNNAME_M_AttributeSetInstance_ID, COLUMNNAME_M_CostElement_ID, COLUMNNAME_M_CostQueue_ID, COLUMNNAME_M_CostQueue_UU, COLUMNNAME_M_CostType_ID, COLUMNNAME_M_Product_ID, COLUMNNAME_Updated, COLUMNNAME_UpdatedBy, Model, Table_ID, Table_Name

Constructor Summary

Constructors

Constructor	Description
MCostQueue(Properties ctx, int ignored, String trxName)	Standard Constructor
MCostQueue(Properties ctx, ResultSet rs, String trxName)	Load Constructor
MCostQueue(MProduct product, int M_AttributeSetInstance_ID, MAcctSchema as, int AD_Org_ID, int M_CostElement_ID, String trxName)	Parent Constructor

Method Summary

Modifier and Type	Method	Description
static BigDecimal	adjustQty(MProduct product, int M_ASI_ID, MAcctSchema as, int Org_ID, MCostElement ce, BigDecimal Qty, String trxName)	Adjust Qty based on in Lifo/Fifo order
static MCostQueue	get(MProduct product, int M_AttributeSetInstance_ID, MAcctSchema as, int AD_Org_ID, int M_CostElement_ID, String trxName)	Get/Create Cost Queue Record.
static BigDecimal	getCosts(MProduct product, int M_ASI_ID, MAcctSchema as, int Org_ID, MCostElement ce, BigDecimal Qty, String trxName)	Calculate Cost based on Qty based on in Lifo/Fifo order
static MCostQueue[]	getQueue(MProduct product, int M_ASI_ID, MAcctSchema as, int Org_ID, MCostElement ce, String trxName)	Get Cost Queue Records in Lifo/Fifo order
void	setCosts(BigDecimal amt, BigDecimal qty, int precision)	Update Record.

Methods inherited from class org.compiere.model.X_M_CostQueue

get_AccessLevel, getC_AcctSchema, getC_AcctSchema_ID, getCurrentCostPrice, getCurrentQty, getM_AttributeSetInstance, getM_AttributeSetInstance_ID, getM_CostElement, getM_CostElement_ID, getM_CostQueue_ID, getM_CostQueue_UU, getM_CostType, getM_CostType_ID, getM_Product, getM_Product_ID, initPO, setC_AcctSchema_ID, setCurrentCostPrice, setCurrentQty, setM_AttributeSetInstance_ID, setM_CostElement_ID, setM_CostQueue_ID, setM_CostQueue_UU, setM_CostType_ID, setM_Product_ID, toString

Methods inherited from class org.compiere.model.PO

afterDelete, afterSave, beforeDelete, beforeSave, 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_Value, get_Value, get_ValueAsBoolean, get_ValueAsInt, get_ValueAsInt, 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, load, loadByUU, loadComplete, loadDefaults, loadSpecial, lock, makeImmutable, postDelete, retrieveIdOfParentValue, retrieveIdOfParentValue, save, save, 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, 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_M_CostQueue

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 Detail

MCostQueue

public MCostQueue(Properties ctx,
                  int ignored,
                  String trxName)

Standard Constructor

Parameters:

ctx - context

ignored - multi-key

trxName - trx

MCostQueue

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

Load Constructor

Parameters:

ctx - context

rs - result set

trxName - trx

MCostQueue

public MCostQueue(MProduct product,
                  int M_AttributeSetInstance_ID,
                  MAcctSchema as,
                  int AD_Org_ID,
                  int M_CostElement_ID,
                  String trxName)

Parent Constructor

Parameters:

product - Product

M_AttributeSetInstance_ID - asi

as - Acct Schema

AD_Org_ID - org

M_CostElement_ID - cost element

trxName - transaction

Method Detail

get

public static MCostQueue get(MProduct product,
                             int M_AttributeSetInstance_ID,
                             MAcctSchema as,
                             int AD_Org_ID,
                             int M_CostElement_ID,
                             String trxName)

Get/Create Cost Queue Record. CostingLevel is not validated

Parameters:

product - product

M_AttributeSetInstance_ID - real asi

as - accounting schema

AD_Org_ID - real org

M_CostElement_ID - element

trxName - transaction

Returns:

cost queue or null

getQueue

public static MCostQueue[] getQueue(MProduct product,
                                    int M_ASI_ID,
                                    MAcctSchema as,
                                    int Org_ID,
                                    MCostElement ce,
                                    String trxName)

Get Cost Queue Records in Lifo/Fifo order

Parameters:

product - product

M_ASI_ID - costing level ASI

as - accounting schema

Org_ID - costing level org

ce - Cost Element

trxName - transaction

Returns:

cost queue or null

adjustQty

public static BigDecimal adjustQty(MProduct product,
                                   int M_ASI_ID,
                                   MAcctSchema as,
                                   int Org_ID,
                                   MCostElement ce,
                                   BigDecimal Qty,
                                   String trxName)

Adjust Qty based on in Lifo/Fifo order

Parameters:

product - product

M_ASI_ID - costing level ASI

as - accounting schema

Org_ID - costing level org

ce - Cost Element

Qty - quantity to be reduced

trxName - transaction

Returns:

cost price reduced or null of error

getCosts

public static BigDecimal getCosts(MProduct product,
                                  int M_ASI_ID,
                                  MAcctSchema as,
                                  int Org_ID,
                                  MCostElement ce,
                                  BigDecimal Qty,
                                  String trxName)

Calculate Cost based on Qty based on in Lifo/Fifo order

Parameters:

product - product

M_ASI_ID - costing level ASI

as - accounting schema

Org_ID - costing level org

ce - Cost Element

Qty - quantity to be reduced

trxName - transaction

Returns:

cost for qty or null of error

setCosts

public void setCosts(BigDecimal amt,
                     BigDecimal qty,
                     int precision)

Update Record. ((OldAvg*OldQty)+(Price*Qty)) / (OldQty+Qty)

Parameters:

amt - total Amount

qty - quantity

precision - costing precision