org.kuali.kfs.module.ar.dataaccess.impl

Class CustomerAgingReportDaoOjb

java.lang.Object

org.springframework.dao.support.DaoSupport

org.springmodules.orm.ojb.support.PersistenceBrokerDaoSupport

org.kuali.rice.core.framework.persistence.ojb.dao.PlatformAwareDaoBaseOjb

org.kuali.kfs.module.ar.dataaccess.impl.CustomerAgingReportDaoOjb

All Implemented Interfaces:

CustomerAgingReportDao, org.kuali.rice.core.framework.persistence.dao.PlatformAwareDao, org.springframework.beans.factory.InitializingBean

public class CustomerAgingReportDaoOjb
extends org.kuali.rice.core.framework.persistence.ojb.dao.PlatformAwareDaoBaseOjb
implements CustomerAgingReportDao

This is Implementation class for CustomerAgingReportDao DAO Interface.

Field Summary

Fields inherited from class org.springframework.dao.support.DaoSupport

logger

Constructor Summary

Constructors

Constructor and Description
CustomerAgingReportDaoOjb()

Method Summary

Methods

Modifier and Type	Method and Description
HashMap<String,org.kuali.rice.core.api.util.type.KualiDecimal>	findAppliedAmountByAccount(String chart, String account, Date begin, Date end) This method generates a database query and retrieves the total applied amount of all open, approved invoices for the given chart and account, which have billing dates within the given date range.
HashMap<String,org.kuali.rice.core.api.util.type.KualiDecimal>	findAppliedAmountByBillingChartAndOrg(String chart, String org, Date begin, Date end) This method generates a database query and retrieves the total applied amount of all open, approved invoices for the given billing chart and org codes, which have billing dates within the given date range.
HashMap<String,org.kuali.rice.core.api.util.type.KualiDecimal>	findAppliedAmountByProcessingChartAndOrg(String chart, String org, Date begin, Date end) This method generates a database query and retrieves the total applied amount of all open, approved invoices for the given processing chart and org codes, which have billing dates within the given date range.
HashMap<String,org.kuali.rice.core.api.util.type.KualiDecimal>	findDiscountAmountByAccount(String chart, String account, Date begin, Date end) This method generates a database query and retrieves the total discount amount of all open, approved invoices for the given chart and account, which have billing dates within the given date range.
HashMap<String,org.kuali.rice.core.api.util.type.KualiDecimal>	findDiscountAmountByBillingChartAndOrg(String chart, String org, Date begin, Date end) This method generates a database query and retrieves the total discount amount of all open, approved invoices for the given billing chart and org codes, which have billing dates within the given date range.
HashMap<String,org.kuali.rice.core.api.util.type.KualiDecimal>	findDiscountAmountByProcessingChartAndOrg(String chart, String org, Date begin, Date end) This method generates a database query and retrieves the total discount amount of all open, approved invoices for the given processing chart and org codes, which have billing dates within the given date range.
HashMap<String,org.kuali.rice.core.api.util.type.KualiDecimal>	findInvoiceAmountByAccount(String chart, String account, Date begin, Date end) This method generates a database query and retrieves the total of all invoices for the given chart and account, which have billing dates within the given date range, for which there is an outstanding balance due.
HashMap<String,org.kuali.rice.core.api.util.type.KualiDecimal>	findInvoiceAmountByBillingChartAndOrg(String chart, String org, Date begin, Date end) This method generates a database query and retrieves the total of all invoices for the given billing chart and org codes, which have billing dates within the given date range, for which there is an outstanding balance due.
HashMap<String,org.kuali.rice.core.api.util.type.KualiDecimal>	findInvoiceAmountByProcessingChartAndOrg(String chart, String org, Date begin, Date end) This method generates a database query and retrieves the total of all invoices for the given processing chart and org codes, which have billing dates within the given date range, for which there is an outstanding balance due.
org.kuali.rice.core.api.util.type.KualiDecimal	findWriteOffAmountByCustomerNumber(String customerNumber) This method returns the total of writeoff amount for the particular customer

Methods inherited from class org.kuali.rice.core.framework.persistence.ojb.dao.PlatformAwareDaoBaseOjb

getDbPlatform, setDbPlatform

Methods inherited from class org.springmodules.orm.ojb.support.PersistenceBrokerDaoSupport

checkDaoConfig, convertOjbAccessException, createPersistenceBrokerTemplate, getJcdAlias, getPersistenceBroker, getPersistenceBrokerTemplate, releasePersistenceBroker, setJcdAlias, setPersistenceBrokerTemplate

Methods inherited from class org.springframework.dao.support.DaoSupport

afterPropertiesSet, initDao

Methods inherited from class java.lang.Object

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

Constructor Detail

CustomerAgingReportDaoOjb

public CustomerAgingReportDaoOjb()

Method Detail

findInvoiceAmountByProcessingChartAndOrg

public HashMap<String,org.kuali.rice.core.api.util.type.KualiDecimal> findInvoiceAmountByProcessingChartAndOrg(String chart,
                                                                                                      String org,
                                                                                                      Date begin,
                                                                                                      Date end)

Description copied from interface: CustomerAgingReportDao

This method generates a database query and retrieves the total of all invoices for the given processing chart and org codes, which have billing dates within the given date range, for which there is an outstanding balance due.

Specified by:

findInvoiceAmountByProcessingChartAndOrg in interface CustomerAgingReportDao

Parameters:

chart - Processing chart code for the invoices being retrieved.

org - Processing org code for the invoices being retrieved.

begin - Beginning date of the date range used to find invoice balances due.

end - Ending date of the date range used to find invoice balances due.

Returns:

See Also:

CustomerAgingReportDao.findInvoiceAmountByProcessingChartAndOrg(java.lang.String, java.lang.String, java.sql.Date, java.sql.Date)

findAppliedAmountByProcessingChartAndOrg

public HashMap<String,org.kuali.rice.core.api.util.type.KualiDecimal> findAppliedAmountByProcessingChartAndOrg(String chart,
                                                                                                      String org,
                                                                                                      Date begin,
                                                                                                      Date end)

Description copied from interface: CustomerAgingReportDao

This method generates a database query and retrieves the total applied amount of all open, approved invoices for the given processing chart and org codes, which have billing dates within the given date range.

Specified by:

findAppliedAmountByProcessingChartAndOrg in interface CustomerAgingReportDao

Parameters:

chart - Processing chart code for the invoices being retrieved.

org - Processing org code for the invoices being retrieved.

begin - Beginning date of the date range used to find invoices.

end - Ending date of the date range used to find invoices.

Returns:

See Also:

CustomerAgingReportDao.findAppliedAmountByProcessingChartAndOrg(java.lang.String, java.lang.String, java.sql.Date, java.sql.Date)

findDiscountAmountByProcessingChartAndOrg

public HashMap<String,org.kuali.rice.core.api.util.type.KualiDecimal> findDiscountAmountByProcessingChartAndOrg(String chart,
                                                                                                       String org,
                                                                                                       Date begin,
                                                                                                       Date end)

Description copied from interface: CustomerAgingReportDao

This method generates a database query and retrieves the total discount amount of all open, approved invoices for the given processing chart and org codes, which have billing dates within the given date range.

Specified by:

findDiscountAmountByProcessingChartAndOrg in interface CustomerAgingReportDao

Parameters:

chart - Processing chart code for the invoices being retrieved.

org - Processing org code for the invoices being retrieved.

begin - Beginning date of the date range used to find invoices.

end - Ending date of the date range used to find invoices.

Returns:

See Also:

CustomerAgingReportDao.findDiscountAmountByProcessingChartAndOrg(java.lang.String, java.lang.String, java.sql.Date, java.sql.Date)

findInvoiceAmountByBillingChartAndOrg

public HashMap<String,org.kuali.rice.core.api.util.type.KualiDecimal> findInvoiceAmountByBillingChartAndOrg(String chart,
                                                                                                   String org,
                                                                                                   Date begin,
                                                                                                   Date end)

Description copied from interface: CustomerAgingReportDao

This method generates a database query and retrieves the total of all invoices for the given billing chart and org codes, which have billing dates within the given date range, for which there is an outstanding balance due.

Specified by:

findInvoiceAmountByBillingChartAndOrg in interface CustomerAgingReportDao

Parameters:

chart - Billing chart code for the invoices being retrieved.

org - Billing org code for the invoices being retrieved.

begin - Beginning date of the date range used to find invoice balances due.

end - Ending date of the date range used to find invoice balances due.

Returns:

See Also:

CustomerAgingReportDao.findInvoiceAmountByBillingChartAndOrg(java.lang.String, java.lang.String, java.sql.Date, java.sql.Date)

findAppliedAmountByBillingChartAndOrg

public HashMap<String,org.kuali.rice.core.api.util.type.KualiDecimal> findAppliedAmountByBillingChartAndOrg(String chart,
                                                                                                   String org,
                                                                                                   Date begin,
                                                                                                   Date end)

Description copied from interface: CustomerAgingReportDao

This method generates a database query and retrieves the total applied amount of all open, approved invoices for the given billing chart and org codes, which have billing dates within the given date range.

Specified by:

findAppliedAmountByBillingChartAndOrg in interface CustomerAgingReportDao

Parameters:

chart - Billing chart code for the invoices being retrieved.

org - Billing org code for the invoices being retrieved.

begin - Beginning date of the date range used to find invoices.

end - Ending date of the date range used to find invoices.

Returns:

See Also:

CustomerAgingReportDao.findAppliedAmountByBillingChartAndOrg(java.lang.String, java.lang.String, java.sql.Date, java.sql.Date)

findDiscountAmountByBillingChartAndOrg

public HashMap<String,org.kuali.rice.core.api.util.type.KualiDecimal> findDiscountAmountByBillingChartAndOrg(String chart,
                                                                                                    String org,
                                                                                                    Date begin,
                                                                                                    Date end)

Description copied from interface: CustomerAgingReportDao

This method generates a database query and retrieves the total discount amount of all open, approved invoices for the given billing chart and org codes, which have billing dates within the given date range.

Specified by:

findDiscountAmountByBillingChartAndOrg in interface CustomerAgingReportDao

Parameters:

chart - Billing chart code for the invoices being retrieved.

org - Billing org code for the invoices being retrieved.

begin - Beginning date of the date range used to find invoices.

end - Ending date of the date range used to find invoices.

Returns:

See Also:

CustomerAgingReportDao.findDiscountAmountByBillingChartAndOrg(java.lang.String, java.lang.String, java.sql.Date, java.sql.Date)

findInvoiceAmountByAccount

public HashMap<String,org.kuali.rice.core.api.util.type.KualiDecimal> findInvoiceAmountByAccount(String chart,
                                                                                        String account,
                                                                                        Date begin,
                                                                                        Date end)

Description copied from interface: CustomerAgingReportDao

This method generates a database query and retrieves the total of all invoices for the given chart and account, which have billing dates within the given date range, for which there is an outstanding balance due.

Specified by:

findInvoiceAmountByAccount in interface CustomerAgingReportDao

Parameters:

chart - chart code for the invoices being retrieved.

account - account number for the invoices being retrieved.

begin - Beginning date of the date range used to find invoice balances due.

end - Ending date of the date range used to find invoice balances due.

Returns:

See Also:

CustomerAgingReportDao.findInvoiceAmountByAccount(java.lang.String, java.lang.String, java.sql.Date, java.sql.Date)

findAppliedAmountByAccount

public HashMap<String,org.kuali.rice.core.api.util.type.KualiDecimal> findAppliedAmountByAccount(String chart,
                                                                                        String account,
                                                                                        Date begin,
                                                                                        Date end)

Description copied from interface: CustomerAgingReportDao

This method generates a database query and retrieves the total applied amount of all open, approved invoices for the given chart and account, which have billing dates within the given date range.

Specified by:

findAppliedAmountByAccount in interface CustomerAgingReportDao

Parameters:

chart - chart code for the invoices being retrieved.

account - account number for the invoices being retrieved.

begin - Beginning date of the date range used to find invoice balances due.

end - Ending date of the date range used to find invoice balances due.

Returns:

See Also:

CustomerAgingReportDao.findAppliedAmountByAccount(java.lang.String, java.lang.String, java.sql.Date, java.sql.Date)

findDiscountAmountByAccount

public HashMap<String,org.kuali.rice.core.api.util.type.KualiDecimal> findDiscountAmountByAccount(String chart,
                                                                                         String account,
                                                                                         Date begin,
                                                                                         Date end)

Description copied from interface: CustomerAgingReportDao

This method generates a database query and retrieves the total discount amount of all open, approved invoices for the given chart and account, which have billing dates within the given date range.

Specified by:

findDiscountAmountByAccount in interface CustomerAgingReportDao

Parameters:

chart - chart code for the invoices being retrieved.

account - account number for the invoices being retrieved.

begin - Beginning date of the date range used to find invoice balances due.

end - Ending date of the date range used to find invoice balances due.

Returns:

See Also:

CustomerAgingReportDao.findDiscountAmountByAccount(java.lang.String, java.lang.String, java.sql.Date, java.sql.Date)

findWriteOffAmountByCustomerNumber

public org.kuali.rice.core.api.util.type.KualiDecimal findWriteOffAmountByCustomerNumber(String customerNumber)

Description copied from interface: CustomerAgingReportDao

This method returns the total of writeoff amount for the particular customer

Specified by:

findWriteOffAmountByCustomerNumber in interface CustomerAgingReportDao

Parameters:

customerNumber - customerNumber for which writeoff amount should be fetched

Returns:

Returns total of writeoff amount for the Customer.

See Also:

CustomerAgingReportDao.findWriteOffAmountByCustomerNumber(java.lang.String)