public Iterator<Lockbox> getAllLockboxes() { LOG.debug("getAllLockboxes() started"); Criteria criteria = new Criteria(); QueryByCriteria query = new QueryByCriteria(Lockbox.class, criteria); query.addOrderByAscending("processedInvoiceDate"); query.addOrderByAscending("batchSequenceNumber"); return (Iterator<Lockbox>)getPersistenceBrokerTemplate().getIteratorByQuery(query); }
/** * @see org.kuali.module.ar.dao.OrganizationOptionsDao#getByPrimaryId(java.lang.String, java.lang.String) */ public Lockbox getByPrimaryId(Long invoiceSequenceNumber) { LOG.debug("getByPrimaryId() started"); Criteria criteria = new Criteria(); criteria.addEqualTo("invoiceSequenceNumber", invoiceSequenceNumber); QueryByCriteria query = new QueryByCriteria(Lockbox.class, criteria); query.addOrderByAscending("processedInvoiceDate"); query.addOrderByAscending("batchSequenceNumber"); return (Lockbox) getPersistenceBrokerTemplate().getObjectByQuery(query); }
public Iterator<Lockbox> getByLockboxNumber(String lockboxNumber) { LOG.debug("getbyLockboxNumber() started"); Criteria criteria = new Criteria(); criteria.addEqualTo("lockboxNumber", lockboxNumber); QueryByCriteria query = new QueryByCriteria(Lockbox.class, criteria); query.addOrderByAscending("processedInvoiceDate"); query.addOrderByAscending("batchSequenceNumber"); return (Iterator<Lockbox>)getPersistenceBrokerTemplate().getIteratorByQuery(query); }
/** * @see org.kuali.kfs.coa.dataaccess.ChartDao#getAll() */ public Collection getAll() { QueryByCriteria qbc = QueryFactory.newQuery(Chart.class, (Criteria) null); qbc.addOrderByAscending("chartOfAccountsCode"); Collection charts = getPersistenceBrokerTemplate().getCollectionByQuery(qbc); List chartList = new ArrayList(charts); return chartList; }
/** * @see org.kuali.kfs.module.ld.dataaccess.impl.LaborOriginEntryDaoOjb#getMatchingEntriesByCollection(java.util.Map) */ @Override public Collection getMatchingEntriesByCollection(Map searchCriteria) { LOG.debug("getMatchingEntries() started"); Criteria criteria = new Criteria(); for (Iterator iter = searchCriteria.keySet().iterator(); iter.hasNext();) { String element = (String) iter.next(); criteria.addEqualTo(element, searchCriteria.get(element)); } QueryByCriteria qbc = QueryFactory.newQuery(this.getEntryClass(), criteria); qbc.addOrderByAscending("entryGroupId"); return getPersistenceBrokerTemplate().getCollectionByQuery(qbc); }
public Iterator<InvoiceRecurrence> getAllInvoiceRecurrences() { LOG.debug("getAllInvoiceRecurrencees() started"); Criteria criteria = new Criteria(); QueryByCriteria query = new QueryByCriteria(InvoiceRecurrence.class, criteria); query.addOrderByAscending("invoiceNumber"); return (Iterator<InvoiceRecurrence>)getPersistenceBrokerTemplate().getIteratorByQuery(query); }
public Iterator<InvoiceRecurrence> getAllActiveInvoiceRecurrences() { LOG.debug("getAllActiveInvoiceRecurrences() started"); Criteria criteria = new Criteria(); criteria.addEqualTo("active", true); QueryByCriteria query = new QueryByCriteria(InvoiceRecurrence.class, criteria); query.addOrderByAscending("invoiceNumber"); return (Iterator<InvoiceRecurrence>)getPersistenceBrokerTemplate().getIteratorByQuery(query); }
/** * @see org.kuali.kfs.coa.dataaccess.OrganizationReversionDao#getCategories() */ public List<OrganizationReversionCategory> getCategories() { LOG.debug("getCategories() started"); Criteria criteria = new Criteria(); criteria.addEqualTo("active", true); QueryByCriteria q = QueryFactory.newQuery(OrganizationReversionCategory.class, criteria); q.addOrderByAscending("organizationReversionSortCode"); return (List) getPersistenceBrokerTemplate().getCollectionByQuery(q); } }
/** * @see org.kuali.kfs.module.ld.dataaccess.LaborOriginEntryDao#testingLaborGetAllEntries() */ public Collection<LaborOriginEntry> testingLaborGetAllEntries() { LOG.debug("testingGetAllEntries() started"); Criteria criteria = new Criteria(); QueryByCriteria qbc = QueryFactory.newQuery(getEntryClass(), criteria); qbc.addOrderByAscending("entryGroupId"); return getPersistenceBrokerTemplate().getCollectionByQuery(qbc); }
public List getAllItemTypes() { LOG.debug("getAllItemTypes() started"); Criteria criteria = new Criteria(); criteria.addEqualTo("active",Boolean.TRUE); QueryByCriteria qbc = new QueryByCriteria(ItemType.class,criteria); qbc.addOrderByAscending("code"); return (List)getPersistenceBrokerTemplate().getCollectionByQuery(qbc); }
/** * @see org.kuali.module.ar.dao.OrganizationOptionsDao#getByPrimaryId(java.lang.String, java.lang.String) */ public InvoiceRecurrence getByPrimaryId(String invoiceNumber) { LOG.debug("getByPrimaryId() started"); Criteria criteria = new Criteria(); criteria.addEqualTo("invoiceNumber", invoiceNumber); QueryByCriteria query = new QueryByCriteria(InvoiceRecurrence.class, criteria); query.addOrderByAscending("invoiceNumber"); return (InvoiceRecurrence) getPersistenceBrokerTemplate().getObjectByQuery(query); }
/** * @@see {@link org.kuali.kfs.module.endow.dataaccess.EndowmentAccountingLineBaseDao#getAllEndowmentAccountingLines(String) */ public Collection<EndowmentAccountingLineBase> getAllEndowmentAccountingLines(String documentNumber) { Collection<EndowmentAccountingLineBase> endowmentAccountingLines = new ArrayList(); Criteria criteria = new Criteria(); criteria.addEqualTo(EndowPropertyConstants.DOCUMENT_NUMBER, documentNumber); //sort the data on these columns.... QueryByCriteria qbc = QueryFactory.newQuery(EndowmentAccountingLineBase.class, criteria); qbc.addOrderByAscending(EndowPropertyConstants.ColumnNames.GlInterfaceBatchProcessLine.TRANSACTION_ARCHIVE_FDOC_LN_TYP_CD); endowmentAccountingLines = getPersistenceBrokerTemplate().getCollectionByQuery(qbc); return endowmentAccountingLines; }
/** * @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); }
public List<HoldingHistory> getHoldingHistoryByKemidIdAndMonthEndIdAndIpInd(String kemid, KualiInteger monthEndId, String ipInd) { Criteria criteria = new Criteria(); criteria.addEqualTo(EndowPropertyConstants.HOLDING_HISTORY_KEMID, kemid); criteria.addEqualTo(EndowPropertyConstants.HOLDING_HISTORY_MONTH_END_DATE_ID, monthEndId); criteria.addGreaterThan(EndowPropertyConstants.HOLDING_TAX_LOT_UNITS, BigDecimal.ZERO); if (ipInd.equalsIgnoreCase(IncomePrincipalIndicator.INCOME) || ipInd.equalsIgnoreCase(IncomePrincipalIndicator.PRINCIPAL)) { criteria.addEqualTo(EndowPropertyConstants.HOLDING_HISTORY_INCOME_PRINCIPAL_INDICATOR, ipInd); } QueryByCriteria qbc = QueryFactory.newQuery(HoldingHistory.class, criteria); qbc.addOrderByAscending(EndowPropertyConstants.KEMID); return (List<HoldingHistory>) getPersistenceBrokerTemplate().getCollectionByQuery(qbc); }
/** * @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.module.endow.dataaccess.HoldingHistoryDao#getHoldingHistoryByKemid(java.lang.String) */ public List<HoldingHistory> getHoldingHistoryByKemid(String kemid) { Criteria criteria = new Criteria(); criteria.addEqualTo(EndowPropertyConstants.HOLDING_TAX_LOT_KEMID, kemid); QueryByCriteria qbc = QueryFactory.newQuery(HoldingHistory.class, criteria); qbc.addOrderByAscending(EndowPropertyConstants.HOLDING_TAX_LOT_KEMID); return (List<HoldingHistory>) getPersistenceBrokerTemplate().getCollectionByQuery(qbc); }
/** * * @see org.kuali.kfs.module.endow.dataaccess.HoldingHistoryDao#getHoldingHistory(java.lang.String, java.lang.String) */ public List<HoldingHistory> getHoldingHistory(String kemid, KualiInteger medId) { Criteria criteria = new Criteria(); criteria.addEqualTo(EndowPropertyConstants.HOLDING_TAX_LOT_KEMID, kemid); criteria.addEqualTo(EndowPropertyConstants.HOLDING_HISTORY_MONTH_END_DATE_ID, medId); QueryByCriteria qbc = QueryFactory.newQuery(HoldingHistory.class, criteria); qbc.addOrderByAscending(EndowPropertyConstants.HOLDING_TAX_LOT_KEMID); return (List<HoldingHistory>) getPersistenceBrokerTemplate().getCollectionByQuery(qbc); }
/** * * @see org.kuali.kfs.module.endow.dataaccess.KemidHistoricalCashDao#getHistoricalCashRecords(java.util.List, org.kuali.rice.kns.util.KualiInteger) */ public List<KemidHistoricalCash> getHistoricalCashRecords(List<String> kemids, KualiInteger medId) { Criteria criteria = new Criteria(); criteria.addIn(EndowPropertyConstants.ENDOWMENT_HIST_CASH_KEMID, kemids); criteria.addEqualTo(EndowPropertyConstants.ENDOWMENT_HIST_CASH_MED_ID, medId); QueryByCriteria qbc = QueryFactory.newQuery(KemidHistoricalCash.class, criteria); qbc.addOrderByAscending(EndowPropertyConstants.ENDOWMENT_HIST_CASH_KEMID); return (List<KemidHistoricalCash>) 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); }
/** * @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); }