1 /*
2 * The Kuali Financial System, a comprehensive financial management system for higher education.
3 *
4 * Copyright 2005-2014 The Kuali Foundation
5 *
6 * This program is free software: you can redistribute it and/or modify
7 * it under the terms of the GNU Affero General Public License as
8 * published by the Free Software Foundation, either version 3 of the
9 * License, or (at your option) any later version.
10 *
11 * This program is distributed in the hope that it will be useful,
12 * but WITHOUT ANY WARRANTY; without even the implied warranty of
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14 * GNU Affero General Public License for more details.
15 *
16 * You should have received a copy of the GNU Affero General Public License
17 * along with this program. If not, see <http://www.gnu.org/licenses/>.
18 */
19 package org.kuali.kfs.gl.dataaccess;
20
21
22 /**
23 * DAO interface for the balancing process of ledger entries
24 */
25 public interface LedgerEntryBalancingDao {
26 /**
27 * Does a group by query on the parameters passed in and returns an object array with the count as first parameter and sum of TRANSACTION_LEDGER_ENTRY_AMOUNT of the second.
28 * @param universityFiscalYear the given university fiscal year
29 * @param chartOfAccountsCode the given chart of account code
30 * @param financialObjectCode the given object code
31 * @param financialBalanceTypeCode the given balance type code
32 * @param universityFiscalPeriodCode the given university fiscal period code
33 * @param transactionDebitCreditCode the given transaction debit or credit code
34 * @return object array with [0] being count(*) and [1] sum(TRANSACTION_LEDGER_ENTRY_AMOUNT). Returns null if data was not found
35 */
36 public Object[] findEntryByGroup(Integer universityFiscalYear, String chartOfAccountsCode, String financialObjectCode, String financialBalanceTypeCode, String universityFiscalPeriodCode, String transactionDebitCreditCode);
37
38 /**
39 * Finds the count of rows for >= fiscal year passed in.
40 * @param the given university fiscal year
41 * @return count
42 */
43 public Integer findCountGreaterOrEqualThan(Integer year);
44 }