minvoice.java

Java写的ERP系统

	{
		if (GrandTotal == null)
			throw new IllegalArgumentException ("GrandTotal is mandatory");
		setValueNoCheck ("GrandTotal", GrandTotal);
	}

	public BigDecimal getGrandTotal ()
	{
		BigDecimal bd = (BigDecimal)getValue ("GrandTotal");
		if (bd == null)
			return Env.ZERO;
		return bd;
	}

	public void setDescription (String Description)
	{
		setValue ("Description", Description);
	}

	public String getDescription ()
	{
		return (String)getValue ("Description");
	}

	public void setC_Project_ID (int C_Project_ID)
	{
		setValue ("C_Project_ID", new Integer (C_Project_ID));
	}

	public int getC_Project_ID ()
	{
		Integer ii = (Integer)getValue ("C_Project_ID");
		if (ii == null)
			return 0;
		return ii.intValue ();
	}

	void setIsPrinted (boolean IsPrinted)
	{
		setValueNoCheck ("IsPrinted", new Boolean(IsPrinted));
	}

	public boolean isPrinted ()
	{
		Boolean bb = (Boolean)getValue ("IsPrinted");
		if (bb != null)
			return bb.booleanValue ();
		return false;
	}

	void setIsSOTrx (boolean IsSOTrx)
	{
		setValueNoCheck ("IsSOTrx", new Boolean(IsSOTrx));
	}

	public boolean isSOTrx ()
	{
		Boolean bb = (Boolean)getValue ("IsSOTrx");
		if (bb != null)
			return bb.booleanValue ();
		return false;
	}

	public void setSalesRep_ID (int SalesRep_ID)
	{
		setValue ("SalesRep_ID", new Integer (SalesRep_ID));
	}

	public int getSalesRep_ID ()
	{
		Integer ii = (Integer)getValue ("SalesRep_ID");
		if (ii == null)
			return 0;
		return ii.intValue ();
	}

	public void setDateInvoiced (Timestamp DateInvoiced)
	{
		if (DateInvoiced == null)
			throw new IllegalArgumentException ("DateInvoiced is mandatory");
		setValue ("DateInvoiced", DateInvoiced);
	}

	public Timestamp getDateInvoiced ()
	{
		return (Timestamp)getValue ("DateInvoiced");
	}

	public void setDatePrinted (Timestamp DatePrinted)
	{
		setValue ("DatePrinted", DatePrinted);
	}

	public Timestamp getDatePrinted ()
	{
		return (Timestamp)getValue ("DatePrinted");
	}

	public void setC_Charge_ID (int C_Charge_ID)
	{
		setValue ("C_Charge_ID", new Integer (C_Charge_ID));
	}

	public int getC_Charge_ID ()
	{
		Integer ii = (Integer)getValue ("C_Charge_ID");
		if (ii == null)
			return 0;
		return ii.intValue ();
	}

	void setProcessed (boolean Processed)
	{
		setValueNoCheck ("Processed", new Boolean(Processed));
	}

	public boolean isProcessed ()
	{
		Boolean bb = (Boolean)getValue ("Processed");
		if (bb != null)
			return bb.booleanValue ();
		return false;
	}

	void setPosted (boolean Posted)
	{
		setValueNoCheck ("Posted", new Boolean(Posted));
	}

	public boolean isPosted ()
	{
		Boolean bb = (Boolean)getValue ("Posted");
		if (bb != null)
			return bb.booleanValue ();
		return false;
	}

	public void setC_Payment_ID (int C_Payment_ID)
	{
		setValue ("C_Payment_ID", new Integer (C_Payment_ID));
	}

	public int getC_Payment_ID ()
	{
		Integer ii = (Integer)getValue ("C_Payment_ID");
		if (ii == null)
			return 0;
		return ii.intValue ();
	}

	public void setChargeAmt (BigDecimal ChargeAmt)
	{
		setValue ("ChargeAmt", ChargeAmt);
	}

	public BigDecimal getChargeAmt ()
	{
		BigDecimal bd = (BigDecimal)getValue ("ChargeAmt");
		if (bd == null)
			return Env.ZERO;
		return bd;
	}

	public void setC_DocTypeTarget_ID (int C_DocTypeTarget_ID)
	{
		setValue ("C_DocTypeTarget_ID", new Integer (C_DocTypeTarget_ID));
	}

	public int getC_DocTypeTarget_ID ()
	{
		Integer ii = (Integer)getValue ("C_DocTypeTarget_ID");
		if (ii == null)
			return 0;
		return ii.intValue ();
	}

	void setTotalLines (BigDecimal TotalLines)
	{
		if (TotalLines == null)
			throw new IllegalArgumentException ("TotalLines is mandatory");
		setValueNoCheck ("TotalLines", TotalLines);
	}

	public BigDecimal getTotalLines ()
	{
		BigDecimal bd = (BigDecimal)getValue ("TotalLines");
		if (bd == null)
			return Env.ZERO;
		return bd;
	}

	public void setIsPaid (boolean IsPaid)
	{
		setValue ("IsPaid", new Boolean(IsPaid));
	}

	public boolean isPaid ()
	{
		Boolean bb = (Boolean)getValue ("IsPaid");
		if (bb != null)
			return bb.booleanValue ();
		return false;
	}

	/**
	 * 	Get Open Amount
	 * 	@return Open Amt
	 */
	public BigDecimal getOpenAmt ()
	{
		if (isPaid())
			return Env.ZERO;
		if (m_openAmt != null)
			return m_openAmt;
		//
		String sql = "SELECT C_Invoice_Open(?) FROM DUAL";
		PreparedStatement pstmt = null;
		try
		{
			pstmt = DB.prepareStatement(sql);
			pstmt.setInt(1, getC_Invoice_ID());
			ResultSet rs = pstmt.executeQuery();
			if (rs.next())
				m_openAmt = rs.getBigDecimal(1);
			rs.close();
			pstmt.close();
			pstmt = null;
		}
		catch (Exception e)
		{
			log.error("getOpenAmt", e);
		}
		finally
		{
			try
			{
				if (pstmt != null)
					pstmt.close ();
			}
			catch (Exception e)
			{}
			pstmt = null;
		}
		//
		return m_openAmt;
	}	//	getOpenAmt

	public void setSendEMail (boolean SendEMail)
	{
		setValue ("SendEMail", new Boolean(SendEMail));
	}

	public boolean isSendEMail ()
	{
		Boolean bb = (Boolean)getValue ("SendEMail");
		if (bb != null)
			return bb.booleanValue ();
		return false;
	}

	public void setC_CashLine_ID (int C_CashLine_ID)
	{
		setValue ("C_CashLine_ID", new Integer (C_CashLine_ID));
	}

	public int getC_CashLine_ID ()
	{
		Integer ii = (Integer)getValue ("C_CashLine_ID");
		if (ii == null)
			return 0;
		return ii.intValue ();
	}

	public void setIsDiscountPrinted (boolean IsDiscountPrinted)
	{
		setValue ("IsDiscountPrinted", new Boolean(IsDiscountPrinted));
	}

	public boolean isDiscountPrinted ()
	{
		Boolean bb = (Boolean)getValue ("IsDiscountPrinted");
		if (bb != null)
			return bb.booleanValue ();
		return false;
	}

	public void setIsTaxIncluded (boolean IsTaxIncluded)
	{
		setValue ("IsTaxIncluded", new Boolean(IsTaxIncluded));
	}

	public boolean isTaxIncluded ()
	{
		Boolean bb = (Boolean)getValue ("IsTaxIncluded");
		if (bb != null)
			return bb.booleanValue ();
		return false;
	}

	void setIsApproved (boolean IsApproved)
	{
		setValueNoCheck ("IsApproved", new Boolean(IsApproved));
	}

	public boolean isApproved ()
	{
		Boolean bb = (Boolean)getValue ("IsApproved");
		if (bb != null)
			return bb.booleanValue ();
		return false;
	}

	public void setC_BPartner_ID (int C_BPartner_ID)
	{
		setValue ("C_BPartner_ID", new Integer (C_BPartner_ID));
	}

	public int getC_BPartner_ID ()
	{
		Integer ii = (Integer)getValue ("C_BPartner_ID");
		if (ii == null)
			return 0;
		return ii.intValue ();
	}

	public void setC_PaymentTerm_ID (int C_PaymentTerm_ID)
	{
		setValue ("C_PaymentTerm_ID", new Integer (C_PaymentTerm_ID));
	}

	public int getC_PaymentTerm_ID ()
	{
		Integer ii = (Integer)getValue ("C_PaymentTerm_ID");
		if (ii == null)
			return 0;
		return ii.intValue ();
	}

	public void setDocumentNo (String DocumentNo)
	{
		if (DocumentNo == null)
			throw new IllegalArgumentException ("DocumentNo is mandatory");
		setValueNoCheck ("DocumentNo", DocumentNo);
	}

	public String getDocumentNo ()
	{
		return (String)getValue ("DocumentNo");
	}

	void setC_DocType_ID (int C_DocType_ID)
	{
		setValueNoCheck ("C_DocType_ID", new Integer (C_DocType_ID));
	}

	public int getC_DocType_ID ()
	{
		Integer ii = (Integer)getValue ("C_DocType_ID");
		if (ii == null)
			return 0;
		return ii.intValue ();
	}

	void setIsTransferred (boolean IsTransferred)
	{
		setValueNoCheck ("IsTransferred", new Boolean(IsTransferred));
	}

	public boolean isTransferred ()
	{
		Boolean bb = (Boolean)getValue ("IsTransferred");
		if (bb != null)
			return bb.booleanValue ();
		return false;
	}

	public void setC_Currency_ID (int C_Currency_ID)
	{
		setValue ("C_Currency_ID", new Integer (C_Currency_ID));
	}

	public int getC_Currency_ID ()
	{
		Integer ii = (Integer)getValue ("C_Currency_ID");
		if (ii == null)
			return 0;
		return ii.intValue ();
	}

	public void setPOReference (String POReference)
	{
		setValue ("POReference", POReference);
	}

	public String getPOReference ()
	{
		return (String)getValue ("POReference");
	}

	public void setPaymentRule (String PaymentRule)
	{
		if (PaymentRule.equals ("B") || PaymentRule.equals ("K")
		  || PaymentRule.equals ("P") || PaymentRule.equals ("S")
		  || PaymentRule.equals ("T"))
			;
		else
			throw new IllegalArgumentException (
			  "PaymentRule Invalid value - Reference_ID=195 - B - K - P - S - T");
		setValue ("PaymentRule", PaymentRule);
	}

	public String getPaymentRule ()
	{
		return (String)getValue ("PaymentRule");
	}

	/*************************************************************************/

	/**
	 * 	Create PDF
	 *	@return true if success
	 */
	public File getPDF ()
	{
		return getPDF(null);
	}	//	getPDF

	/**
	 * 	Create PDF file
	 *	@param file output file
	 *	@return true if success
	 */
	public File getPDF (File file)
	{
		int AD_PrintFormat_ID = 0;
		Language language = Language.getLanguage();		//	Base Language;

		String sql = "SELECT bp.AD_Language, c.IsMultiLingualDocument,"
			+ " pf.Invoice_PrintFormat_ID, c.DocumentDir "
			+ "FROM C_Invoice i"
			+ " INNER JOIN C_BPartner bp ON (i.C_BPartner_ID=bp.C_BPartner_ID)"
			+ " INNER JOIN AD_Client c ON (i.AD_Client_ID=c.AD_Client_ID)"
			+ " INNER JOIN AD_PrintForm pf ON (c.AD_Client_ID=pf.AD_Client_ID) "
			+ "WHERE i.C_Invoice_ID=?";
		PreparedStatement pstmt = null;
		try
		{
			pstmt = DB.prepareStatement(sql);
			pstmt.setInt(1, getC_Invoice_ID());
			ResultSet rs = pstmt.executeQuery();
			if (rs.next())
			{
				String AD_Language = rs.getString(1);
				if (AD_Language != null && "Y".equals(rs.getString(2)))
					language = Language.getLanguage(AD_Language);
				//
				AD_PrintFormat_ID = rs.getInt(3);
				//
				if (file == null)
					file = new File (getPDFFileName(rs.getString(4)));
			}
			rs.close();
			pstmt.close();
			pstmt = null;
		}
		catch (Exception e)
		{
			Log.error("getPDF", e);
		}
		finally
		{
			try
			{
				if (pstmt != null)
					pstmt.close ();
			}
			catch (Exception e)
			{}
			pstmt = null;
		}
		if (AD_PrintFormat_ID == 0)
		{
			log.error("getPDF - No PrintFormat found");
			return null;
		}

		//	Format
		MPrintFormat format = MPrintFormat.get (AD_PrintFormat_ID, false);
		format.setLanguage(language);
		format.setTranslationLanguage(language);

		//	Query
		MQuery query = new MQuery("C_Invoice_Header_v");
		query.addRestriction("C_Invoice_ID", MQuery.EQUAL, new Integer(getC_Invoice_ID()));

		//	Engine
		ReportEngine re = new ReportEngine(getCtx(), format, query);
		return re.getPDF(file);
	}	//	getPDF

	/**
	 * 	Get PDF File Name
	 *	@param documentDir directory
	 *	@return file name
	 */
	public String getPDFFileName (String documentDir)
	{
		return getPDFFileName(documentDir, getC_Invoice_ID());
	}	//	getPDFFileName

	/**
	 * 	Get PDF File Name
	 *	@param documentDir directory
	 * 	@param C_Invoice_ID invoice
	 *	@return file name
	 */
	public static String getPDFFileName (String documentDir, int C_Invoice_ID)
	{
		StringBuffer sb = new StringBuffer (documentDir);
		if (sb.length() == 0)
			sb.append(".");
		if (!sb.toString().endsWith(File.separator))
			sb.append(File.separator);
		sb.append("C_Invoice_ID_")
			.append(C_Invoice_ID)
			.append(".pdf");
		return sb.toString();
	}	//	getPDFFileName

}	//	MInvoice