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, Comparator, 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, 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_C_AcctSchema_ID, COLUMNNAME_CurrentCostPrice, COLUMNNAME_CurrentQty, COLUMNNAME_M_AttributeSetInstance_ID, COLUMNNAME_M_CostElement_ID, COLUMNNAME_M_CostQueue_ID, COLUMNNAME_M_CostType_ID, COLUMNNAME_M_Product_ID, Model, Table_ID, Table_Name

Constructor Summary

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

MCostQueue(Properties ctx, int ignored, String trxName)
Standard Constructor

MCostQueue(Properties ctx, ResultSet rs, String trxName)
Load Cosntructor

Method Summary

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_ID, getC_AcctSchema, getCurrentCostPrice, getCurrentQty, getM_AttributeSetInstance_ID, getM_CostElement_ID, getM_CostElement, getM_CostQueue_ID, getM_CostType_ID, getM_CostType, getM_Product_ID, getM_Product, initPO, setC_AcctSchema_ID, setCurrentCostPrice, setCurrentQty, setM_AttributeSetInstance_ID, setM_CostElement_ID, setM_CostQueue_ID, setM_CostType_ID, setM_Product_ID, toString

Methods inherited from class org.compiere.model.PO

afterDelete, afterSave, beforeDelete, beforeSave, compare, copyValues, copyValues, createAttachment, delete_Accounting, delete_Tree, delete, delete, deleteEx, deleteEx, dump, dump, equals, 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_Table_ID, get_TableName, get_Translation, get_TrxName, get_Value, get_Value, get_ValueAsInt, get_ValueAsString, get_ValueDifference, get_ValueDifference, get_ValueE, get_ValueOfColumn, get_ValueOld, get_ValueOld, get_ValueOldAsInt, get_WhereClause, get_xmlDocument, get_xmlString, getAD_Client_ID, getAD_Org_ID, getAllIDs, getAttachment, getAttachment, getAttachmentData, getCreated, getCreatedBy, getCtx, getDoc, getFindParameter, getPdfAttachment, getUpdated, getUpdatedBy, insert_Accounting, insert_Tree, insert_Tree, is_Changed, is_new, is_ValueChanged, is_ValueChanged, isActive, isAttachment, isColumnMandatory, isColumnUpdateable, isMandatoryOK, isPdfAttachment, isReplication, load, load, load, load, loadComplete, loadDefaults, loadSpecial, lock, save, save, saveEx, saveEx, saveNew_getID, saveNewSpecial, saveReplica, saveUpdate, set_ColumnUpdateable, set_CustomColumn, set_TrxName, set_TrxName, set_Value, set_Value, set_ValueE, set_ValueNoCheck, set_ValueNoCheckE, set_ValueOfColumn, set_ValueOfColumn, setAD_Client_ID, setAD_Org_ID, setClientOrg, setClientOrg, setDoc, setDocWorkflowMgr, setIsActive, setReplication, setStandardDefaults, setUpdateable, setUpdatedBy, unlock

Methods inherited from class java.lang.Object

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

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 Cosntructor

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