/** * @see org.kuali.kfs.fp.document.dataaccess.TravelMileageRateDao#retrieveMostEffectiveMileageRates(java.sql.Timestamp) */ public Collection retrieveMostEffectiveMileageRates(Date effectiveDate) { Criteria criteria = new Criteria(); criteria.addLessOrEqualThan("disbursementVoucherMileageEffectiveDate", effectiveDate); QueryByCriteria queryByCriteria = new QueryByCriteria(TravelMileageRate.class, criteria); queryByCriteria.addOrderByDescending("disbursementVoucherMileageEffectiveDate"); queryByCriteria.addOrderByDescending("mileageLimitAmount"); Collection mostEffectiveRates = new ArrayList(); Collection rates = getPersistenceBrokerTemplate().getCollectionByQuery(queryByCriteria); Date mostEffectiveDate = ((TravelMileageRate) rates.iterator().next()).getDisbursementVoucherMileageEffectiveDate(); for (Iterator iter = rates.iterator(); iter.hasNext();) { TravelMileageRate rate = (TravelMileageRate) iter.next(); if (rate.getDisbursementVoucherMileageEffectiveDate().compareTo(mostEffectiveDate) == 0) { mostEffectiveRates.add(rate); } } return mostEffectiveRates; }
/** * * @see org.kuali.kfs.module.endow.dataaccess.MonthEndDateDao#getAllMonthEndDates() */ public List<MonthEndDate> getAllMonthEndDatesOrderByDescending() { Criteria criteria = new Criteria(); QueryByCriteria qbc = QueryFactory.newQuery(MonthEndDate.class, criteria); qbc.addOrderByDescending(EndowPropertyConstants.MONTH_END_DATE); return (List<MonthEndDate>) getPersistenceBrokerTemplate().getCollectionByQuery(qbc); } }
/** * @see org.kuali.rice.krad.dao.BusinessObjectDao#findAllOrderBy(java.lang.Class, java.lang.String, boolean) */ public <T extends BusinessObject> Collection<T> findAllOrderBy(Class<T> clazz, String sortField, boolean sortAscending) { QueryByCriteria queryByCriteria = new QueryByCriteria(clazz, (Criteria) null); if (sortAscending) { queryByCriteria.addOrderByAscending(sortField); } else { queryByCriteria.addOrderByDescending(sortField); } return (Collection<T>)getPersistenceBrokerTemplate().getCollectionByQuery(queryByCriteria); }
criteria.addEqualTo("documentHeader.financialDocumentStatusCode", KFSConstants.DocumentStatusCodes.APPROVED); QueryByCriteria query = QueryFactory.newQuery(ProposalAwardCloseDocument.class, criteria); query.addOrderByDescending("documentNumber");
/** * @see org.kuali.rice.krad.dao.BusinessObjectDao#findAllActiveOrderBy(java.lang.Class, java.lang.String, boolean) */ public <T extends BusinessObject> Collection<T> findAllActiveOrderBy(Class<T> clazz, String sortField, boolean sortAscending) { QueryByCriteria queryByCriteria = new QueryByCriteria(clazz, buildActiveCriteria()); if (sortAscending) { queryByCriteria.addOrderByAscending(sortField); } else { queryByCriteria.addOrderByDescending(sortField); } return (Collection<T>)getPersistenceBrokerTemplate().getCollectionByQuery(queryByCriteria); }
/** * @see org.kuali.kfs.fp.document.dataaccess.CashManagementDao#selectNextAvailableCheckLineNumber(java.lang.String) */ public Integer selectNextAvailableCheckLineNumber(String documentNumber) { if (documentNumber != null) { // select all cashiering checks associated with document Criteria criteria = new Criteria(); criteria.addEqualTo("documentNumber", documentNumber); criteria.addEqualTo("cashieringRecordSource", KFSConstants.CheckSources.CASH_MANAGEMENT); criteria.addEqualTo("financialDocumentTypeCode", CashieringTransaction.DETAIL_DOCUMENT_TYPE); QueryByCriteria cmChecksQuery = QueryFactory.newQuery(CheckBase.class, criteria); cmChecksQuery.addOrderByDescending("sequenceId"); Iterator allChecksIter = getPersistenceBrokerTemplate().getIteratorByQuery(cmChecksQuery); if (allChecksIter.hasNext()) { return new Integer((((Check) TransactionalServiceUtils.retrieveFirstAndExhaustIterator(allChecksIter)).getSequenceId()).intValue() + 1); } else { return new Integer(1); } } else { return null; } }
criteria.addEqualTo("documentHeader.financialDocumentStatusCode", KFSConstants.DocumentStatusCodes.ENROUTE); QueryByCriteria query = QueryFactory.newQuery(ProposalAwardCloseDocument.class, criteria); query.addOrderByDescending("documentNumber");
/** * This is the default impl that comes with Kuali - uses OJB. * * @see org.kuali.rice.krad.dao.BusinessObjectDao#findMatching(java.lang.Class, java.util.Map) */ public <T extends BusinessObject> Collection<T> findMatchingOrderBy(Class<T> clazz, Map<String, ?> fieldValues, String sortField, boolean sortAscending) { Criteria criteria = buildCriteria(fieldValues); QueryByCriteria queryByCriteria = new QueryByCriteria(clazz, criteria); if (sortAscending) { queryByCriteria.addOrderByAscending(sortField); } else { queryByCriteria.addOrderByDescending(sortField); } return (Collection<T>)getPersistenceBrokerTemplate().getCollectionByQuery(queryByCriteria); }
/** * Document header IDs are ordered, so an ID less than the current will * always be previous to current. */ public TimesheetDocumentHeader getPreviousDocumentHeader(String principalId, DateTime payBeginDate) { Criteria crit = new Criteria(); crit.addEqualTo("principalId", principalId); // the pay begin date is the end date of the previous pay period crit.addEqualTo("endDate", payBeginDate.toDate()); QueryByCriteria query = new QueryByCriteria(TimesheetDocumentHeader.class, crit); query.addOrderByDescending("documentId"); query.setStartAtIndex(0); query.setEndAtIndex(1); return (TimesheetDocumentHeader) this.getPersistenceBrokerTemplate().getObjectByQuery(query); }
/** * Document header IDs are ordered, so an ID less than the current will * always be previous to current. */ public LeaveCalendarDocumentHeader getPreviousDocumentHeader(String principalId, DateTime beginDate) { Criteria crit = new Criteria(); crit.addEqualTo("principalId", principalId); // the pay begin date is the end date of the previous pay period crit.addEqualTo("endDate", beginDate.toDate()); QueryByCriteria query = new QueryByCriteria(LeaveCalendarDocumentHeader.class, crit); query.addOrderByDescending("documentId"); query.setStartAtIndex(0); query.setEndAtIndex(1); return (LeaveCalendarDocumentHeader) this.getPersistenceBrokerTemplate().getObjectByQuery(query); }
q.addOrderByDescending(PdpPropertyConstants.PaymentDetail.PAYMENT_PROCESS_IMEDIATE); q.addOrderByDescending(PdpPropertyConstants.PaymentDetail.PAYMENT_SPECIAL_HANDLING); q.addOrderByDescending(PdpPropertyConstants.PaymentDetail.PAYMENT_ATTACHMENT); q.addOrderByAscending(PdpPropertyConstants.PaymentDetail.PAYMENT_CHART_CODE); q.addOrderByAscending(PdpPropertyConstants.PaymentDetail.PAYMENT_UNIT_CODE);
/** * @see org.kuali.kfs.module.endow.dataaccess.PooledFundValueDao#getPooledFundValueWhereSTProcessOnDateIsCurrentDate() */ public List<PooledFundValue> getPooledFundValueWhereSTProcessOnDateIsCurrentDate() { Criteria criteria = new Criteria(); criteria.addEqualTo(EndowPropertyConstants.DISTRIBUTE_SHORT_TERM_GAIN_LOSS_ON_DATE, kemService.getCurrentDate()); criteria.addEqualTo(EndowPropertyConstants.ST_GAIN_LOSS_DISTR_COMPL, false); QueryByCriteria qbc = QueryFactory.newQuery(PooledFundValue.class, criteria); qbc.addOrderByAscending(EndowPropertyConstants.POOL_SECURITY_ID); qbc.addOrderByDescending(EndowPropertyConstants.VALUE_EFFECTIVE_DATE); return (List<PooledFundValue>) getPersistenceBrokerTemplate().getCollectionByQuery(qbc); }
/** * @see org.kuali.kfs.module.endow.dataaccess.PooledFundValueDao#getPooledFundValueWhereLTProcessOnDateIsCurrentDate() */ public List<PooledFundValue> getPooledFundValueWhereLTProcessOnDateIsCurrentDate() { Criteria criteria = new Criteria(); criteria.addEqualTo(EndowPropertyConstants.DISTRIBUTE_LONG_TERM_GAIN_LOSS_ON_DATE, kemService.getCurrentDate()); criteria.addEqualTo(EndowPropertyConstants.LT_GAIN_LOSS_DISTR_COMPL, false); QueryByCriteria qbc = QueryFactory.newQuery(PooledFundValue.class, criteria); qbc.addOrderByAscending(EndowPropertyConstants.POOL_SECURITY_ID); qbc.addOrderByDescending(EndowPropertyConstants.VALUE_EFFECTIVE_DATE); return (List<PooledFundValue>) getPersistenceBrokerTemplate().getCollectionByQuery(qbc); }