/** * 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; }
/** * 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; }
/** * 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); }
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); }
/** * @see org.kuali.kfs.module.ar.dataaccess.CustomerDao#getByPrimaryId(java.lang.String) */ public Customer getByPrimaryId(String customerNumber) { Criteria criteria = new Criteria(); criteria.addEqualTo("customerNumber", customerNumber==null?customerNumber:customerNumber.toUpperCase()); return (Customer) getPersistenceBrokerTemplate().getObjectByQuery(QueryFactory.newQuery(Customer.class, criteria)); }
/** * @see org.kuali.kfs.coa.dataaccess.IndirectCostRecoveryTypeDao#getByPrimaryKey(java.lang.String) */ public IndirectCostRecoveryType getByPrimaryKey(String code) { LOG.debug("getByPrimaryKey() started"); Criteria crit = new Criteria(); crit.addEqualTo(KFSPropertyConstants.CODE, code); QueryByCriteria qbc = QueryFactory.newQuery(IndirectCostRecoveryType.class, crit); return (IndirectCostRecoveryType) getPersistenceBrokerTemplate().getObjectByQuery(qbc); } }
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.fp.dataaccess.DisbursementVoucherDao#getDocumentsByHeaderStatus(java.lang.String) */ public Collection getDocumentsByHeaderStatus(String statusCode) { LOG.debug("getDocumentsByHeaderStatus() started"); Criteria criteria = new Criteria(); criteria.addEqualTo("documentHeader.financialDocumentStatusCode", statusCode); criteria.addEqualTo("disbVchrPaymentMethodCode", DisbursementVoucherConstants.PAYMENT_METHOD_CHECK); return getPersistenceBrokerTemplate().getCollectionByQuery(new QueryByCriteria(DisbursementVoucherDocument.class, criteria)); } }
/** * @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.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)); }
/** * @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.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.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)); }
/** * 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)); }
/** * @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); } }
public GeneralLedgerPendingEntry getByPrimaryId(String documentHeaderId, Integer transactionLedgerEntrySequenceNumber) { LOG.debug("getByPrimaryId() started"); Criteria criteria = new Criteria(); criteria.addEqualTo(KFSPropertyConstants.DOCUMENT_NUMBER, documentHeaderId); criteria.addEqualTo(TRANSACTION_LEDGER_ENTRY_SEQUENCE_NUMBER, transactionLedgerEntrySequenceNumber); return (GeneralLedgerPendingEntry) getPersistenceBrokerTemplate().getObjectByQuery(QueryFactory.newQuery(this.getEntryClass(), criteria)); }
public ElectronicInvoiceItemMapping getByUniqueKeys(Integer headerId, Integer detailId, String invoiceTypeCode) { LOG.debug("getByUniqueKeys() started"); Criteria criteria = new Criteria(); criteria.addEqualTo("vendorHeaderGeneratedId", headerId); criteria.addEqualTo("vendorDetailAssignedId", detailId); criteria.addEqualTo("electronicInvoiceItemTypeCode", invoiceTypeCode); QueryByCriteria qbc = new QueryByCriteria(ElectronicInvoiceItemMapping.class,criteria); return (ElectronicInvoiceItemMapping)getPersistenceBrokerTemplate().getObjectByQuery(qbc); }
public <T extends Document> Collection<T> findByDocumentHeaderStatusCode(Class<T> clazz, String statusCode) { Criteria criteria = new Criteria(); criteria.addEqualTo(KNSPropertyConstants.DOCUMENT_HEADER + "." + KFSPropertyConstants.FINANCIAL_DOCUMENT_STATUS_CODE, statusCode); QueryByCriteria query = QueryFactory.newQuery(clazz, criteria); ArrayList<T> tempList = new ArrayList<T>(this.getPersistenceBrokerTemplate().getCollectionByQuery(query)); for (Document doc : tempList) getDocumentAdHocService().addAdHocs(doc); return tempList; }
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.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)); }