/** * Builds a Criteria object for active field set to true * @return Criteria */ private Criteria buildActiveCriteria(){ Criteria criteria = new Criteria(); criteria.addEqualTo(KRADPropertyConstants.ACTIVE, true); return criteria; }
/** * internal method to retrieve a annotations given an ID. <b>THIS METHOD ASSUMES THAT INITIALIZE() HAS * BEEN CALLED PREVIOUSLY AND WILL NOT CALL RELEASEBROKER()</B>. This is to keep the connection alive * should it be required for instantiation of proxy objects. it is the responsibility of the coder * to initialize and release the broker in any method that calls * internalGetTermById. */ private Collection<Annotation> internalGetTermAnnotations(String termPk) throws PersistenceException { //optimize processing of getting annotations Criteria criteria = new Criteria(); criteria.addEqualTo("parentTermPk", termPk); QueryByCriteria query = QueryFactory.newReportQuery(AnnotationBean.class, criteria); query.addOrderByAscending("annotationType"); return collectionQuery(query); }
/** * * @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); }
public Collection<NonAppliedHolding> getNonAppliedHoldingsForCustomer(String customerNumber) { Criteria criteria = new Criteria(); criteria.addEqualTo("customerNumber", customerNumber); criteria.addEqualTo("documentHeader.financialDocumentStatusCode", KFSConstants.DocumentStatusCodes.APPROVED); Query query = QueryFactory.newQuery(NonAppliedHolding.class, criteria); return getPersistenceBrokerTemplate().getCollectionByQuery(query); }
/** * @see org.kuali.kfs.gl.dataaccess.EncumbranceDao#findCountGreaterOrEqualThan(java.lang.Integer) */ public Integer findCountGreaterOrEqualThan(Integer year) { Criteria criteria = new Criteria(); criteria.addGreaterOrEqualThan(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, year); ReportQueryByCriteria query = QueryFactory.newReportQuery(Encumbrance.class, criteria); return getPersistenceBrokerTemplate().getCount(query); } }
/** * * @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.PersistedLookupMetadataDao#deleteOldLookupResults(java.sql.Timestamp) */ public void deleteOldLookupResults(Timestamp expirationDate) { Criteria criteria = new Criteria(); criteria.addLessThan(KRADPropertyConstants.LOOKUP_DATE, expirationDate); getPersistenceBrokerTemplate().deleteByQuery(QueryFactory.newQuery(LookupResults.class, criteria)); }
/** * fetch all encumbrance records from GL open encumbrance table * * @return an Iterator with all encumbrances currently in the database * @see org.kuali.kfs.gl.dataaccess.EncumbranceDao#getAllEncumbrances() */ public Iterator getAllEncumbrances() { Criteria criteria = new Criteria(); QueryByCriteria query = QueryFactory.newQuery(Encumbrance.class, criteria); return getPersistenceBrokerTemplate().getIteratorByQuery(query); }
/** * * @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.coa.dataaccess.ObjectLevelDao#getByPrimaryId(java.lang.String, java.lang.String) */ public ObjectLevel getByPrimaryId(String chartOfAccountsCode, String objectLevelCode) { Criteria criteria = new Criteria(); criteria.addEqualTo("chartOfAccountsCode", chartOfAccountsCode); criteria.addEqualTo("financialObjectLevelCode", objectLevelCode); return (ObjectLevel) getPersistenceBrokerTemplate().getObjectByQuery(QueryFactory.newQuery(ObjectLevel.class, criteria)); }
/** * internal method to retrieve xrefs given an ID. <b>THIS METHOD ASSUMES THAT INITIALIZE() HAS * BEEN CALLED PREVIOUSLY AND WILL NOT CALL RELEASEBROKER()</B>. This is to keep the connection alive * should it be required for instantiation of proxy objects. it is the responsibility of the coder * to initialize and release the broker in any method that calls * internalGetTermById. */ private Collection<DbXref> internalGetTermXrefs(String termPk) throws PersistenceException { //optimize processing of getting xrefs Criteria criteria = new Criteria(); criteria.addEqualTo("parentObjectPk", termPk); QueryByCriteria query = QueryFactory.newReportQuery(DbXrefBean.class, criteria); query.addOrderByAscending("xrefType"); return collectionQuery(query); }
/** * Builds a Criteria object for active field set to true * @return Criteria */ private Criteria buildInactiveCriteria(){ Criteria criteria = new Criteria(); criteria.addEqualTo(KRADPropertyConstants.ACTIVE, false); return criteria; }
/** * @see org.kuali.kfs.gl.dataaccess.AccountBalanceDao#findCountGreaterOrEqualThan(java.lang.Integer) */ public Integer findCountGreaterOrEqualThan(Integer year) { Criteria criteria = new Criteria(); criteria.addGreaterOrEqualThan(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, year); ReportQueryByCriteria query = QueryFactory.newReportQuery(AccountBalance.class, criteria); return getPersistenceBrokerTemplate().getCount(query); }
/** * * @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.coa.dataaccess.ChartDao#getByPrimaryId(java.lang.String) */ public Chart getByPrimaryId(String chartOfAccountsCode) { Criteria criteria = new Criteria(); criteria.addEqualTo("chartOfAccountsCode", chartOfAccountsCode); return (Chart) getPersistenceBrokerTemplate().getObjectByQuery(QueryFactory.newQuery(Chart.class, criteria)); }
/** * This method creates details for getting all of a certain cash detail, irregardless of cashiering record source * * @param documentNumber the document number to get cash details for * @return the criteria that will allow the retrieval of the right cash details */ protected Criteria getAllCashDetailCriteria(String documentNumber) { Criteria criteria = new Criteria(); criteria.addEqualTo("documentNumber", documentNumber); criteria.addEqualTo("financialDocumentTypeCode", CashieringTransaction.DETAIL_DOCUMENT_TYPE); return criteria; }
/** * @see org.kuali.kfs.gl.dataaccess.LedgerEntryBalancingDao#findCountGreaterOrEqualThan(java.lang.Integer) */ public Integer findCountGreaterOrEqualThan(Integer year) { Criteria criteria = new Criteria(); criteria.addGreaterOrEqualThan(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, year); ReportQueryByCriteria query = QueryFactory.newReportQuery(Entry.class, criteria); return getPersistenceBrokerTemplate().getCount(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); } }
/** * Retrieves project code business object by project name * * @param name - part of composite key * @return Project * @see ProjectCodeDao#getByName(String) */ public ProjectCode getByName(String name) { Criteria criteria = new Criteria(); criteria.addEqualTo("name", name); return (ProjectCode) getPersistenceBrokerTemplate().getObjectByQuery(QueryFactory.newQuery(ProjectCode.class, criteria)); }
/** * Builds a Criteria object for activeIndicator field set to true * @return Criteria */ protected Criteria buildActiveCriteria(){ Criteria criteria = new Criteria(); criteria.addEqualTo(KNSPropertyConstants.ACTIVE, true); return criteria; } }