/****************************************************************************** * 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.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.Timestamp; import java.util.ArrayList; import java.util.Properties; import java.util.logging.Level; import org.compiere.util.DB; import org.compiere.util.Env; import org.compiere.util.TimeUtil; import org.compiere.util.Util; /** * RfQ Model * * @author Jorg Janke * @version $Id: MRfQ.java,v 1.3 2006/07/30 00:51:05 jjanke Exp $ */ public class MRfQ extends X_C_RfQ { /** * generated serial id */ private static final long serialVersionUID = 5332116213254863257L; /** * Get MRfQ from DB * @param C_RfQ_ID id * @return MRfQ */ public static MRfQ get (int C_RfQ_ID) { return get(C_RfQ_ID, (String)null); } /** * Get MRfQ from DB * @param C_RfQ_ID id * @param trxName transaction * @return MRfQ */ public static MRfQ get (int C_RfQ_ID, String trxName) { return get(Env.getCtx(), C_RfQ_ID, trxName); } /** * Get MRfQ from DB * @param ctx context * @param C_RfQ_ID id * @param trxName transaction * @return MRfQ */ public static MRfQ get (Properties ctx, int C_RfQ_ID, String trxName) { MRfQ retValue = new MRfQ (ctx, C_RfQ_ID, trxName); if (retValue.get_ID () == C_RfQ_ID) { return retValue; } return null; } // get /** * UUID based Constructor * @param ctx Context * @param C_RfQ_UU UUID key * @param trxName Transaction */ public MRfQ(Properties ctx, String C_RfQ_UU, String trxName) { super(ctx, C_RfQ_UU, trxName); if (Util.isEmpty(C_RfQ_UU)) setInitialDefaults(); } /** * Standard Constructor * @param ctx context * @param C_RfQ_ID id * @param trxName transaction */ public MRfQ (Properties ctx, int C_RfQ_ID, String trxName) { super (ctx, C_RfQ_ID, trxName); if (C_RfQ_ID == 0) setInitialDefaults(); } // MRfQ /** * Set the initial defaults for a new record */ private void setInitialDefaults() { setDateResponse (new Timestamp(System.currentTimeMillis())); setDateWorkStart (new Timestamp(System.currentTimeMillis())); setIsInvitedVendorsOnly (false); setQuoteType (QUOTETYPE_QuoteSelectedLines); setIsQuoteAllQty (false); setIsQuoteTotalAmt (false); setIsRfQResponseAccepted (true); setIsSelfService (true); setProcessed (false); } /** * Load Constructor * @param ctx context * @param rs result set * @param trxName transaction */ public MRfQ (Properties ctx, ResultSet rs, String trxName) { super(ctx, rs, trxName); } // MRfQ /** * Copy constructor * @param copy */ public MRfQ(MRfQ copy) { this(Env.getCtx(), copy); } /** * Copy constructor * @param ctx * @param copy */ public MRfQ(Properties ctx, MRfQ copy) { this(ctx, copy, (String) null); } /** * Copy constructor * @param ctx * @param copy * @param trxName */ public MRfQ(Properties ctx, MRfQ copy, String trxName) { this(ctx, 0, trxName); copyPO(copy); } /** * Get active RFQ Lines * @return array of RFQ lines */ public MRfQLine[] getLines() { ArrayList list = new ArrayList(); String sql = "SELECT * FROM C_RfQLine " + "WHERE C_RfQ_ID=? AND IsActive='Y' " + "ORDER BY Line,C_RfQLine_ID "; PreparedStatement pstmt = null; ResultSet rs = null; try { pstmt = DB.prepareStatement (sql, get_TrxName()); pstmt.setInt (1, getC_RfQ_ID()); rs = pstmt.executeQuery (); while (rs.next ()) list.add (new MRfQLine (getCtx(), rs, get_TrxName())); } catch (Exception e) { log.log(Level.SEVERE, sql, e); } finally { DB.close(rs, pstmt); rs = null; pstmt = null; } MRfQLine[] retValue = new MRfQLine[list.size ()]; list.toArray (retValue); return retValue; } // getLines /** * Get RfQ Responses * @param activeOnly active responses only * @param completedOnly completed responses only * @return array of RFQ response */ public MRfQResponse[] getResponses (boolean activeOnly, boolean completedOnly) { ArrayList list = new ArrayList(); String sql = "SELECT * FROM C_RfQResponse " + "WHERE C_RfQ_ID=?"; if (activeOnly) sql += " AND IsActive='Y'"; if (completedOnly) sql += " AND IsComplete='Y'"; sql += " ORDER BY Price"; PreparedStatement pstmt = null; ResultSet rs = null; try { pstmt = DB.prepareStatement (sql, get_TrxName()); pstmt.setInt (1, getC_RfQ_ID()); rs = pstmt.executeQuery (); while (rs.next ()) list.add (new MRfQResponse (getCtx(), rs, get_TrxName())); } catch (Exception e) { log.log(Level.SEVERE, sql, e); } finally { DB.close(rs, pstmt); rs = null; pstmt = null; } MRfQResponse[] retValue = new MRfQResponse[list.size ()]; list.toArray (retValue); return retValue; } // getResponses /** * String Representation * @return info */ @Override public String toString () { StringBuilder sb = new StringBuilder ("MRfQ["); sb.append(get_ID()).append(",Name=").append(getName()) .append(",QuoteType=").append(getQuoteType()) .append("]"); return sb.toString (); } // toString /** * Is Quote Total Amt Only * @return true if quote total amount only (QUOTETYPE_QuoteTotalOnly) */ public boolean isQuoteTotalAmtOnly() { return QUOTETYPE_QuoteTotalOnly.equals(getQuoteType()); } // isQuoteTotalAmtOnly /** * Is Quote Selected Lines * @return true if quote selected lines (QUOTETYPE_QuoteSelectedLines) */ public boolean isQuoteSelectedLines() { return QUOTETYPE_QuoteSelectedLines.equals(getQuoteType()); } // isQuoteSelectedLines /** * Is Quote All Lines * @return true if quote all lines (QUOTETYPE_QuoteAllLines) */ public boolean isQuoteAllLines() { return QUOTETYPE_QuoteAllLines.equals(getQuoteType()); } // isQuoteAllLines /** * Is "Quote Total Amt Only" Valid * @return null or error message */ public String checkQuoteTotalAmtOnly() { if (!isQuoteTotalAmtOnly()) return null; // Need to check Line Qty MRfQLine[] lines = getLines(); for (int i = 0; i < lines.length; i++) { MRfQLine line = lines[i]; MRfQLineQty[] qtys = line.getQtys(); if (qtys.length > 1) { log.warning("isQuoteTotalAmtOnlyValid - #" + qtys.length + " - " + line); String msg = "@Line@ " + line.getLine() + ": #@C_RfQLineQty@=" + qtys.length + " - @IsQuoteTotalAmt@"; return msg; } } return null; } // checkQuoteTotalAmtOnly @Override protected boolean beforeSave (boolean newRecord) { // Calculate Complete Date (also used to verify) if (getDateWorkStart() != null && getDeliveryDays() != 0) setDateWorkComplete (TimeUtil.addDays(getDateWorkStart(), getDeliveryDays())); // Calculate Delivery Days else if (getDateWorkStart() != null && getDeliveryDays() == 0 && getDateWorkComplete() != null) setDeliveryDays (TimeUtil.getDaysBetween(getDateWorkStart(), getDateWorkComplete())); // Calculate Start Date else if (getDateWorkStart() == null && getDeliveryDays() != 0 && getDateWorkComplete() != null) setDateWorkStart (TimeUtil.addDays(getDateWorkComplete(), getDeliveryDays() * -1)); return true; } // beforeSave } // MRfQ