/****************************************************************************** * Product: Adempiere ERP & CRM Smart Business Solution * * Copyright (C) 1999-2006 ComPiere, Inc. All Rights Reserved. * * This program is free software; you can redistribute it and/or modify it * * under the terms version 2 of the GNU General Public License as published * * by the Free Software Foundation. This program is distributed in the hope * * that it will be useful, but WITHOUT ANY WARRANTY; without even the implied * * warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. * * See the GNU General Public License for more details. * * You should have received a copy of the GNU General Public License along * * with this program; if not, write to the Free Software Foundation, Inc., * * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA. * * For the text or an alternative of this public license, you may reach us * * ComPiere, Inc., 2620 Augustine Dr. #245, Santa Clara, CA 95054, USA * * or via info@compiere.org or http://www.compiere.org/license.html * *****************************************************************************/ package org.compiere.model; import java.math.BigDecimal; import java.math.RoundingMode; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; import java.util.Properties; import java.util.logging.Level; import org.compiere.util.CLogger; import org.compiere.util.DB; import org.compiere.util.Env; import org.compiere.util.Util; /** * Landed Cost Allocation Model * @author Jorg Janke * @version $Id: MLandedCostAllocation.java,v 1.3 2006/07/30 00:51:05 jjanke Exp $ */ public class MLandedCostAllocation extends X_C_LandedCostAllocation { /** * generated serial id */ private static final long serialVersionUID = -8645283018475474574L; /** * Get Landed Cost Allocations for invoice Line * @param ctx context * @param C_InvoiceLine_ID invoice line * @param trxName trx * @return landed cost alloc */ public static MLandedCostAllocation[] getOfInvoiceLine (Properties ctx, int C_InvoiceLine_ID, String trxName) { ArrayList list = new ArrayList(); String sql = "SELECT * FROM C_LandedCostAllocation WHERE C_InvoiceLine_ID=?"; PreparedStatement pstmt = null; ResultSet rs = null; try { pstmt = DB.prepareStatement (sql, trxName); pstmt.setInt (1, C_InvoiceLine_ID); rs = pstmt.executeQuery (); while (rs.next ()) list.add (new MLandedCostAllocation (ctx, rs, trxName)); } catch (Exception e) { s_log.log (Level.SEVERE, sql, e); } finally { DB.close(rs, pstmt); rs = null; pstmt = null; } MLandedCostAllocation[] retValue = new MLandedCostAllocation[list.size ()]; list.toArray (retValue); return retValue; } // getOfInvliceLine /** Logger */ private static CLogger s_log = CLogger.getCLogger (MLandedCostAllocation.class); /** * UUID based Constructor * @param ctx Context * @param C_LandedCostAllocation_UU UUID key * @param trxName Transaction */ public MLandedCostAllocation(Properties ctx, String C_LandedCostAllocation_UU, String trxName) { super(ctx, C_LandedCostAllocation_UU, trxName); if (Util.isEmpty(C_LandedCostAllocation_UU)) setInitialDefaults(); } /** * Standard Constructor * @param ctx context * @param C_LandedCostAllocation_ID id * @param trxName trx */ public MLandedCostAllocation (Properties ctx, int C_LandedCostAllocation_ID, String trxName) { super (ctx, C_LandedCostAllocation_ID, trxName); if (C_LandedCostAllocation_ID == 0) setInitialDefaults(); } // MLandedCostAllocation /** * Set the initial defaults for a new record */ private void setInitialDefaults() { setAmt (Env.ZERO); setQty (Env.ZERO); setBase (Env.ZERO); } /** * Load Constructor * @param ctx context * @param rs result name * @param trxName trx */ public MLandedCostAllocation (Properties ctx, ResultSet rs, String trxName) { super (ctx, rs, trxName); } // MLandedCostAllocation /** * Parent Constructor * @param parent parent * @param M_CostElement_ID cost element */ public MLandedCostAllocation (MInvoiceLine parent, int M_CostElement_ID) { this (parent.getCtx(), 0, parent.get_TrxName()); setClientOrg(parent); setC_InvoiceLine_ID(parent.getC_InvoiceLine_ID()); setM_CostElement_ID(M_CostElement_ID); } // MLandedCostAllocation /** * Set Amt * @param Amt amount * @param precision precision */ public void setAmt (double Amt, int precision) { BigDecimal bd = BigDecimal.valueOf(Amt); if (bd.scale() > precision) bd = bd.setScale(precision, RoundingMode.HALF_UP); super.setAmt(bd); } // setAmt /** * Set Allocation Qty (e.g. free products) * @param Qty */ @Override public void setQty (BigDecimal Qty) { super.setQty (Qty); } // setQty } // MLandedCostAllocation