/** * Generate Query object for GeneralLedgerEntry search. * * @param fieldValues * @return */ protected ReportQueryByCriteria getGeneralLedgerReportQuery(Map fieldValues) { Collection docTypeCodes = getDocumentType(fieldValues); Collection activityStatusCodes = getActivityStatusCode(fieldValues); Criteria criteria = OJBUtility.buildCriteriaFromMap(fieldValues, new GeneralLedgerEntry()); // set document type code criteria if (!docTypeCodes.isEmpty()) { criteria.addIn( CabPropertyConstants.GeneralLedgerEntry.FINANCIAL_DOCUMENT_TYPE_CODE, docTypeCodes); } // set activity status code criteria if (!activityStatusCodes.isEmpty()) { criteria.addIn( CabPropertyConstants.GeneralLedgerEntry.ACTIVITY_STATUS_CODE, activityStatusCodes); } ReportQueryByCriteria query = QueryFactory.newReportQuery(GeneralLedgerEntry.class, criteria); List attributeList = buildAttributeList(false); // set the selection attributes String[] attributes = (String[]) attributeList.toArray(new String[attributeList.size()]); query.setAttributes(attributes); return query; }
/** * Find the maximum transactionLedgerEntrySequenceNumber in the entry table for a specific * transaction. This is used to make sure that rows added have a unique primary key. * * @param t the transaction to check * @return the max sequence number */ public int getMaxSequenceNumber(Transaction t) { LOG.debug("getSequenceNumber() "); Criteria crit = new Criteria(); crit.addEqualTo(UNIVERISITY_FISCAL_YEAR, t.getUniversityFiscalYear()); crit.addEqualTo(CHART_OF_ACCOUNTS_CODE, t.getChartOfAccountsCode()); crit.addEqualTo(ACCOUNT_NUMBER, t.getAccountNumber()); crit.addEqualTo(SUB_ACCOUNT_NUMBER, t.getSubAccountNumber()); crit.addEqualTo(FINANCIAL_OBJECT_CODE, t.getFinancialObjectCode()); crit.addEqualTo(FINANCIAL_SUB_OBJECT_CODE, t.getFinancialSubObjectCode()); crit.addEqualTo(FINANCIAL_BALANCE_TYPE_CODE, t.getFinancialBalanceTypeCode()); crit.addEqualTo(FINANCIAL_OBJECT_TYPE_CODE, t.getFinancialObjectTypeCode()); crit.addEqualTo(UNIVERISTY_FISCAL_PERIOD_CODE, t.getUniversityFiscalPeriodCode()); crit.addEqualTo(FINANCIAL_DOCUMENT_TYPE_CODE, t.getFinancialDocumentTypeCode()); crit.addEqualTo(FINANCIAL_SYSTEM_ORIGINATION_CODE, t.getFinancialSystemOriginationCode()); crit.addEqualTo(KFSPropertyConstants.DOCUMENT_NUMBER, t.getDocumentNumber()); ReportQueryByCriteria q = QueryFactory.newReportQuery(Entry.class, crit); q.setAttributes(new String[] {"max(transactionLedgerEntrySequenceNumber)"}); Iterator iter = getPersistenceBrokerTemplate().getReportQueryIteratorByQuery(q); // would this work better? max = (BigDecimal) // getPersistenceBrokerTemplate().getObjectByQuery(q); BigDecimal max = null; while (iter.hasNext()) { Object[] data = (Object[]) iter.next(); max = (BigDecimal) data[0]; // Don't know why OJB returns a BigDecimal, but it does } if (max == null) { return 0; } else { return max.intValue(); } }
/** * @see * org.kuali.kfs.pdp.dataaccess.PaymentGroupDao#getDisbursementNumbersByDisbursementType(java.lang.Integer, * java.lang.String, java.lang.String) */ public List<Integer> getDisbursementNumbersByDisbursementTypeAndBankCode( Integer pid, String disbursementType, String bankCode) { if (LOG.isDebugEnabled()) { LOG.debug("getDisbursementNumbersByDisbursementType() started"); } List<Integer> results = new ArrayList<Integer>(); Criteria criteria = new Criteria(); criteria.addEqualTo(PdpPropertyConstants.PaymentGroup.PAYMENT_GROUP_PROCESS_ID, pid); criteria.addEqualTo( PdpPropertyConstants.PaymentGroup.PAYMENT_GROUP_DISBURSEMENT_TYPE_CODE, disbursementType); criteria.addEqualTo(PdpPropertyConstants.PaymentGroup.PAYMENT_GROUP_BANK_CODE, bankCode); String[] fields = new String[] {PdpPropertyConstants.PaymentGroup.PAYMENT_GROUP_DISBURSEMENT_NBR}; ReportQueryByCriteria rq = QueryFactory.newReportQuery(PaymentGroup.class, fields, criteria, true); rq.addOrderBy(PdpPropertyConstants.PaymentGroup.PAYMENT_GROUP_DISBURSEMENT_NBR, true); Iterator i = getPersistenceBrokerTemplate().getReportQueryIteratorByQuery(rq); while (i.hasNext()) { Object[] data = (Object[]) i.next(); BigDecimal d = (BigDecimal) data[0]; results.add(new Integer(d.intValue())); } return results; }
/** * @see org.kuali.kfs.gl.dataaccess.LedgerEntryBalancingDao#findEntryByGroup(java.lang.Integer, * java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String) */ public Object[] findEntryByGroup( Integer universityFiscalYear, String chartOfAccountsCode, String financialObjectCode, String financialBalanceTypeCode, String universityFiscalPeriodCode, String transactionDebitCreditCode) { Criteria criteria = new Criteria(); criteria.addEqualTo(KFSConstants.UNIVERSITY_FISCAL_YEAR_PROPERTY_NAME, universityFiscalYear); criteria.addEqualTo(KFSConstants.CHART_OF_ACCOUNTS_CODE_PROPERTY_NAME, chartOfAccountsCode); criteria.addEqualTo(KFSConstants.FINANCIAL_OBJECT_CODE_PROPERTY_NAME, financialObjectCode); criteria.addEqualTo( KFSConstants.FINANCIAL_BALANCE_TYPE_CODE_PROPERTY_NAME, financialBalanceTypeCode); criteria.addEqualTo( KFSConstants.UNIVERSITY_FISCAL_PERIOD_CODE_PROPERTY_NAME, universityFiscalPeriodCode); criteria.addEqualTo(KFSConstants.TRANSACTION_DEBIT_CREDIT_CODE, transactionDebitCreditCode); ReportQueryByCriteria reportQuery = QueryFactory.newReportQuery(Entry.class, criteria); reportQuery.setAttributes( new String[] {"count(*)", "sum(" + KFSConstants.TRANSACTION_LEDGER_ENTRY_AMOUNT + ")"}); reportQuery.addGroupBy( new String[] { KFSConstants.UNIVERSITY_FISCAL_YEAR_PROPERTY_NAME, KFSConstants.CHART_OF_ACCOUNTS_CODE_PROPERTY_NAME, KFSConstants.FINANCIAL_OBJECT_CODE_PROPERTY_NAME, KFSConstants.FINANCIAL_BALANCE_TYPE_CODE_PROPERTY_NAME, KFSConstants.UNIVERSITY_FISCAL_PERIOD_CODE_PROPERTY_NAME, KFSConstants.TRANSACTION_DEBIT_CREDIT_CODE }); Iterator<Object[]> iterator = getPersistenceBrokerTemplate().getReportQueryIteratorByQuery(reportQuery); Object[] returnResult = TransactionalServiceUtils.retrieveFirstAndExhaustIterator(iterator); if (ObjectUtils.isNull(returnResult)) { // Do nothing, we'll return null. Data wasn't found. } else if (returnResult[0] instanceof BigDecimal) { returnResult[0] = ((BigDecimal) returnResult[0]).intValue(); } else { returnResult[0] = ((Long) returnResult[0]).intValue(); } return returnResult; }
/** * Given a process id and a disbursement type, finds a distinct list of bank codes used by payment * groups within that payment process * * @param pid payment process to query payment groups of * @param disbursementType the type of disbursements to query * @return a sorted List of bank codes */ public List<String> getDistinctBankCodesForProcessAndType(Integer pid, String disbursementType) { List<String> results = new ArrayList<String>(); Criteria criteria = new Criteria(); criteria.addEqualTo(PdpPropertyConstants.PaymentGroup.PAYMENT_GROUP_PROCESS_ID, pid); criteria.addEqualTo( PdpPropertyConstants.PaymentGroup.PAYMENT_GROUP_DISBURSEMENT_TYPE_CODE, disbursementType); String[] fields = new String[] {PdpPropertyConstants.PaymentGroup.PAYMENT_GROUP_BANK_CODE}; ReportQueryByCriteria rq = QueryFactory.newReportQuery(PaymentGroup.class, fields, criteria, true); rq.addOrderBy(PdpPropertyConstants.PaymentGroup.PAYMENT_GROUP_BANK_CODE, true); Iterator iter = getPersistenceBrokerTemplate().getReportQueryIteratorByQuery(rq); while (iter.hasNext()) { final Object[] row = (Object[]) iter.next(); final String bankCode = (String) row[0]; results.add(bankCode); } return results; }