Package org.openbravo.advpaymentmngt.dao

Class MatchTransactionDao

java.lang.Object

org.openbravo.advpaymentmngt.dao.MatchTransactionDao

public class MatchTransactionDao
extends Object

Constructor Summary

Constructors

Constructor	Description
MatchTransactionDao()

Method Summary

Modifier and Type	Method	Description
static boolean	checkAllLinesCleared(String strFinancialAccountId)
static Date	getBankStatementLineMaxDate(FIN_FinancialAccount financialAccount)
static BigDecimal	getClearedLinesAmount(String strReconciliationId)
static BigDecimal	getEndingBalance(FIN_Reconciliation reconciliation)
static BigDecimal	getLastReconciliationUnmatchedBalance(FIN_Reconciliation lastReconciliation)	Calculates the balance of unmatched bank statements for the given reconciliation
static List<FIN_FinaccTransaction>	getMatchingFinancialTransaction(String strFinancialAccountId, String strReference, BigDecimal amount, String strBpartner, List<FIN_FinaccTransaction> excluded)
static List<FIN_FinaccTransaction>	getMatchingFinancialTransaction(String strFinancialAccountId, BigDecimal amount)
static List<FIN_FinaccTransaction>	getMatchingFinancialTransaction(String strFinancialAccountId, BigDecimal amount, List<FIN_FinaccTransaction> excluded)
static List<FIN_FinaccTransaction>	getMatchingFinancialTransaction(String strFinancialAccountId, Date transactionDate, String strReference, BigDecimal amount, String strBpartner, List<FIN_FinaccTransaction> excluded)
static List<FIN_FinaccTransaction>	getMatchingFinancialTransaction(String strFinancialAccountId, Date transactionDate, String strReference, BigDecimal amount, List<FIN_FinaccTransaction> excluded)
static List<FIN_FinaccTransaction>	getMatchingFinancialTransaction(String strFinancialAccountId, Date transactionDate, BigDecimal amount, List<FIN_FinaccTransaction> excluded)
static List<FIN_FinaccTransaction>	getMatchingGLItemTransaction(String strFinancialAccountId, GLItem glItem, Date transactionDate, BigDecimal amount, List<FIN_FinaccTransaction> excluded)
static <T extends BaseOBObject> T	getObject(Class<T> t, String strId)
static BigDecimal	getReconciliationLastAmount(FIN_FinancialAccount financialAccount)
static List<FIN_Reconciliation>	getReconciliationListAfterDate(FIN_Reconciliation reconciliation)
static BigDecimal	getStartingBalance(FIN_Reconciliation reconciliation)
static List<FIN_BankStatementLine>	getUnMatchedBankStatementLines(FIN_FinancialAccount account)
static boolean	islastreconciliation(FIN_Reconciliation reconciliation)

Methods inherited from class java.lang.Object

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

Constructor Detail

MatchTransactionDao

public MatchTransactionDao()

Method Detail

getObject

public static <T extends BaseOBObject> T getObject(Class<T> t,
                                                   String strId)

getClearedLinesAmount

public static BigDecimal getClearedLinesAmount(String strReconciliationId)

checkAllLinesCleared

public static boolean checkAllLinesCleared(String strFinancialAccountId)

islastreconciliation

public static boolean islastreconciliation(FIN_Reconciliation reconciliation)

getUnMatchedBankStatementLines

public static List<FIN_BankStatementLine> getUnMatchedBankStatementLines(FIN_FinancialAccount account)

getMatchingFinancialTransaction

public static List<FIN_FinaccTransaction> getMatchingFinancialTransaction(String strFinancialAccountId,
                                                                          Date transactionDate,
                                                                          String strReference,
                                                                          BigDecimal amount,
                                                                          String strBpartner,
                                                                          List<FIN_FinaccTransaction> excluded)

getMatchingFinancialTransaction

public static List<FIN_FinaccTransaction> getMatchingFinancialTransaction(String strFinancialAccountId,
                                                                          Date transactionDate,
                                                                          String strReference,
                                                                          BigDecimal amount,
                                                                          List<FIN_FinaccTransaction> excluded)

getMatchingFinancialTransaction

public static List<FIN_FinaccTransaction> getMatchingFinancialTransaction(String strFinancialAccountId,
                                                                          String strReference,
                                                                          BigDecimal amount,
                                                                          String strBpartner,
                                                                          List<FIN_FinaccTransaction> excluded)

getMatchingFinancialTransaction

public static List<FIN_FinaccTransaction> getMatchingFinancialTransaction(String strFinancialAccountId,
                                                                          Date transactionDate,
                                                                          BigDecimal amount,
                                                                          List<FIN_FinaccTransaction> excluded)

getMatchingGLItemTransaction

public static List<FIN_FinaccTransaction> getMatchingGLItemTransaction(String strFinancialAccountId,
                                                                       GLItem glItem,
                                                                       Date transactionDate,
                                                                       BigDecimal amount,
                                                                       List<FIN_FinaccTransaction> excluded)

getMatchingFinancialTransaction

public static List<FIN_FinaccTransaction> getMatchingFinancialTransaction(String strFinancialAccountId,
                                                                          BigDecimal amount,
                                                                          List<FIN_FinaccTransaction> excluded)

getMatchingFinancialTransaction

public static List<FIN_FinaccTransaction> getMatchingFinancialTransaction(String strFinancialAccountId,
                                                                          BigDecimal amount)

getBankStatementLineMaxDate

public static Date getBankStatementLineMaxDate(FIN_FinancialAccount financialAccount)

getReconciliationLastAmount

public static BigDecimal getReconciliationLastAmount(FIN_FinancialAccount financialAccount)

getLastReconciliationUnmatchedBalance

public static BigDecimal getLastReconciliationUnmatchedBalance(FIN_Reconciliation lastReconciliation)

Calculates the balance of unmatched bank statements for the given reconciliation

Parameters:

lastReconciliation - Reconciliation.

Returns:

Last reconciliation UnMatched balance

getReconciliationListAfterDate

public static List<FIN_Reconciliation> getReconciliationListAfterDate(FIN_Reconciliation reconciliation)

Parameters:

reconciliation -

Returns:

List of later reconciliations that given one for the same financial account

getEndingBalance

public static BigDecimal getEndingBalance(FIN_Reconciliation reconciliation)

getStartingBalance

public static BigDecimal getStartingBalance(FIN_Reconciliation reconciliation)