1 14 package org.compiere.acct; 15 16 import java.math.*; 17 import java.sql.*; 18 19 import org.compiere.util.*; 20 import org.compiere.model.*; 21 22 28 public final class DocTax 29 { 30 38 public DocTax (int C_Tax_ID, String name, BigDecimal rate, BigDecimal taxBaseAmt, BigDecimal amount) 39 { 40 m_C_Tax_ID = C_Tax_ID; 41 m_name = name; 42 m_rate = rate; 43 m_amount = amount; 44 } 46 47 private int m_C_Tax_ID = 0; 48 49 private BigDecimal m_amount = null; 50 51 private BigDecimal m_rate = null; 52 53 private String m_name = null; 54 55 private BigDecimal m_taxBaseAmt = null; 56 57 58 59 public static final int ACCTTYPE_TaxDue = 0; 60 61 public static final int ACCTTYPE_TaxLiability = 1; 62 63 public static final int ACCTTYPE_TaxCredit = 2; 64 65 public static final int ACCTTYPE_TaxReceivables = 3; 66 67 public static final int ACCTTYPE_TaxExpense = 4; 68 69 75 public Account getAccount (int AcctType, AcctSchema as) 76 { 77 if (AcctType < 0 || AcctType > 4) 78 return null; 79 String sql = "SELECT T_Due_Acct, T_Liability_Acct, T_Credit_Acct, T_Receivables_Acct, T_Expense_Acct " 81 + "FROM C_Tax_Acct WHERE C_Tax_ID=? AND C_AcctSchema_ID=?"; 82 int validCombination_ID = 0; 83 try 84 { 85 PreparedStatement pstmt = DB.prepareStatement(sql); 86 pstmt.setInt(1, m_C_Tax_ID); 87 pstmt.setInt(2, as.getC_AcctSchema_ID()); 88 ResultSet rs = pstmt.executeQuery(); 89 if (rs.next()) 90 validCombination_ID = rs.getInt(AcctType+1); rs.close(); 92 pstmt.close(); 93 } 94 catch (SQLException e) 95 { 96 Log.error ("Tax.getAccount", e); 97 } 98 if (validCombination_ID == 0) 99 return null; 100 return Account.getAccount(validCombination_ID); 101 } 103 107 public BigDecimal getAmount() 108 { 109 return m_amount; 110 } 111 112 116 public BigDecimal getTaxBaseAmt() 117 { 118 return m_taxBaseAmt; 119 } 120 121 125 public BigDecimal getRate() 126 { 127 return m_rate; 128 } 129 130 134 public String getName() 135 { 136 return m_name; 137 } 138 139 143 public String getDescription() 144 { 145 return m_name + " " + m_taxBaseAmt.toString(); 146 } 148 152 public String toString() 153 { 154 StringBuffer sb = new StringBuffer ("Tax=("); 155 sb.append(m_name); 156 sb.append(" Amt=").append(m_amount); 157 sb.append(")"); 158 return sb.toString(); 159 } 161 } | Popular Tags |