public Object doInPersistenceBroker(PersistenceBroker pb) throws PersistenceBrokerException { return pb.getReportQueryIteratorByQuery(query); } });
public Object doInPersistenceBroker(PersistenceBroker pb) throws PersistenceBrokerException { return pb.getReportQueryIteratorByQuery(query); } });
public Object doInPersistenceBroker(PersistenceBroker pb) throws PersistenceBrokerException { return pb.getReportQueryIteratorByQuery(query); } });
/** * Performs a report query and returns an iterator on the report * * @param query A fully constructed ReportQuery object * @return An iterator on the report query * @throws PersistenceException If the query object is null or the broker is not initialized */ protected Iterator<Object[]> reportQuery(Query query) throws PersistenceException { if (query != null) { if (broker != null) { try { return broker.getReportQueryIteratorByQuery(query); } catch (PersistenceBrokerException e) { throw new PersistenceException("reportQuery caught a low-level PB exception: " + e.getMessage(), e); } } else { throw new PersistenceException("Query called on uninitialized PersistenceBroker"); } } else { throw new PersistenceException("No query specified!"); } }
/** * @see org.kuali.kfs.module.bc.document.dataaccess.BudgetConstructionDao#getPositionAssociatedWithFundingLock(org.kuali.kfs.module.bc.businessobject.BudgetConstructionFundingLock) */ public String getPositionAssociatedWithFundingLock(BudgetConstructionFundingLock budgetConstructionFundingLock) { String positionNumber = BCConstants.POSITION_NUMBER_NOT_FOUND; // default if there is no associated position that is locked // (orphaned) Criteria criteria = new Criteria(); criteria.addEqualTo("pendingBudgetConstructionAppointmentFunding.chartOfAccountsCode", budgetConstructionFundingLock.getChartOfAccountsCode()); criteria.addEqualTo("pendingBudgetConstructionAppointmentFunding.accountNumber", budgetConstructionFundingLock.getAccountNumber()); criteria.addEqualTo("pendingBudgetConstructionAppointmentFunding.subAccountNumber", budgetConstructionFundingLock.getSubAccountNumber()); criteria.addEqualTo("pendingBudgetConstructionAppointmentFunding.universityFiscalYear", budgetConstructionFundingLock.getUniversityFiscalYear()); criteria.addEqualTo("positionLockUserIdentifier", budgetConstructionFundingLock.getAppointmentFundingLockUserId()); String[] columns = new String[] { "positionNumber" }; ReportQueryByCriteria q = QueryFactory.newReportQuery(BudgetConstructionPosition.class, columns, criteria, true); PersistenceBroker pb = getPersistenceBroker(true); Iterator<Object[]> iter = pb.getReportQueryIteratorByQuery(q); if (iter.hasNext()) { Object[] objs = (Object[]) TransactionalServiceUtils.retrieveFirstAndExhaustIterator(iter); if (objs[0] != null) { positionNumber = (String) objs[0]; } } return positionNumber; }
/** * @see org.kuali.kfs.module.bc.document.dataaccess.BudgetConstructionDao#getPendingBudgetConstructionAppointmentFundingRequestSum(org.kuali.kfs.module.bc.businessobject.PendingBudgetConstructionGeneralLedger) */ public KualiInteger getPendingBudgetConstructionAppointmentFundingRequestSum(PendingBudgetConstructionGeneralLedger salaryDetailLine) { KualiInteger salarySum = KualiInteger.ZERO; Criteria criteria = new Criteria(); criteria.addEqualTo("universityFiscalYear", salaryDetailLine.getUniversityFiscalYear()); criteria.addEqualTo("chartOfAccountsCode", salaryDetailLine.getChartOfAccountsCode()); criteria.addEqualTo("accountNumber", salaryDetailLine.getAccountNumber()); criteria.addEqualTo("subAccountNumber", salaryDetailLine.getSubAccountNumber()); criteria.addEqualTo("financialObjectCode", salaryDetailLine.getFinancialObjectCode()); criteria.addEqualTo("financialSubObjectCode", salaryDetailLine.getFinancialSubObjectCode()); String[] columns = new String[] { "financialObjectCode", "financialSubObjectCode", "sum(appointmentRequestedAmount)" }; ReportQueryByCriteria q = QueryFactory.newReportQuery(PendingBudgetConstructionAppointmentFunding.class, columns, criteria, true); q.addGroupBy(new String[] { "financialObjectCode", "financialSubObjectCode" }); PersistenceBroker pb = getPersistenceBroker(true); Iterator<Object[]> iter = pb.getReportQueryIteratorByQuery(q); if (iter.hasNext()) { Object[] objs = (Object[]) TransactionalServiceUtils.retrieveFirstAndExhaustIterator(iter); if (objs[2] != null) { salarySum = new KualiInteger((BigDecimal) objs[2]); } } return salarySum; }