/** * This is the default impl that comes with Kuali - uses OJB. * * @see org.kuali.rice.krad.dao.BusinessObjectDao#countMatching(java.lang.Class, java.util.Map) */ public int countMatching(Class clazz, Map<String, ?> fieldValues) { Criteria criteria = buildCriteria(fieldValues); return getPersistenceBrokerTemplate().getCount(QueryFactory.newQuery(clazz, 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.cg.dataaccess.AwardDao#deleteAll() */ public void deleteAll() { getPersistenceBrokerTemplate().deleteByQuery(QueryFactory.newQuery(Award.class, new Criteria())); }
/** * @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)); }
public Collection<NonAppliedHolding> getNonAppliedHoldingsByListOfDocumentNumbers(List<String> docNumbers) { Criteria criteria = new Criteria(); criteria.addIn("referenceFinancialDocumentNumber", docNumbers); QueryByCriteria query = QueryFactory.newQuery(NonAppliedHolding.class, criteria); return new ArrayList<NonAppliedHolding>(this.getPersistenceBrokerTemplate().getCollectionByQuery(query)); }
/** * @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); } }
/** * @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.module.ar.document.dataaccess.CashControlDetailDao#getCashControlDetailByRefDocNumber(java.lang.String) */ public CashControlDetail getCashControlDetailByRefDocNumber(String referenceDocumentNumber) { Criteria criteria = new Criteria(); criteria.addEqualTo(ArPropertyConstants.CashControlDetailFields.REFERENCE_FINANCIAL_DOC_NBR, referenceDocumentNumber); Query query = QueryFactory.newQuery(CashControlDetail.class, criteria); return (CashControlDetail) getPersistenceBrokerTemplate().getObjectByQuery(query); }
public Collection getARDocumentHeadersByCustomerNumber(String customerNumber){ Criteria criteria = new Criteria(); criteria.addEqualTo(KFSConstants.CustomerOpenItemReport.CUSTOMER_NUMBER,customerNumber); return getPersistenceBrokerTemplate().getCollectionByQuery(QueryFactory.newQuery(AccountsReceivableDocumentHeader.class, criteria)); }
/** * @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)); }
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 <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)); }
/** * @see org.kuali.module.gl.dao.GeneralLedgerPendingEntryDao#findPendingLedgerEntriesForEntry(java.util.Map, boolean) */ public Iterator findPendingLedgerEntriesForEntry(Map fieldValues, boolean isApproved) { LOG.debug("findPendingLedgerEntriesForEntry started"); Criteria criteria = buildCriteriaFromMap(fieldValues, new GeneralLedgerPendingEntry()); // add the status codes into the criteria this.addStatusCode(criteria, isApproved); LookupUtils.applySearchResultsLimit(criteria, getDbPlatform()); QueryByCriteria query = QueryFactory.newQuery(this.getEntryClass(), criteria); return getPersistenceBrokerTemplate().getIteratorByQuery(query); }
/** * @see org.kuali.kfs.module.cg.dataaccess.ProposalDao#getProposalsToClose(org.kuali.kfs.module.cg.businessobject.Close) */ public Collection<Proposal> getProposalsToClose(ProposalAwardCloseDocument close) { Criteria criteria = new Criteria(); criteria.addIsNull("proposalClosingDate"); criteria.addLessOrEqualThan("proposalSubmissionDate", close.getCloseOnOrBeforeDate()); return (Collection<Proposal>) getPersistenceBrokerTemplate().getCollectionByQuery(QueryFactory.newQuery(Proposal.class, criteria)); }
public List<PendingBudgetConstructionAppointmentFunding> getFundingRecords(BudgetConstructionPayRateHolding holdingRecord, Integer budgetYear, List objectCodeValues) { Criteria criteria = new Criteria(); criteria.addEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, budgetYear); criteria.addIn(KFSPropertyConstants.FINANCIAL_OBJECT_CODE, objectCodeValues); criteria.addEqualTo(KFSPropertyConstants.EMPLID, holdingRecord.getEmplid()); criteria.addEqualTo(KFSPropertyConstants.POSITION_NUMBER, holdingRecord.getPositionNumber()); criteria.addEqualTo(KFSPropertyConstants.ACTIVE, "Y"); List<PendingBudgetConstructionAppointmentFunding> records = (List<PendingBudgetConstructionAppointmentFunding>)getPersistenceBrokerTemplate().getCollectionByQuery(QueryFactory.newQuery(PendingBudgetConstructionAppointmentFunding.class, criteria)); return records; }
public BudgetConstructionHeader getHeaderRecord(BudgetConstructionRequestMove record, Integer budgetYear) { Criteria criteria = new Criteria(); criteria.addEqualTo(KFSPropertyConstants.CHART_OF_ACCOUNTS_CODE, record.getChartOfAccountsCode()); criteria.addEqualTo(KFSPropertyConstants.ACCOUNT_NUMBER, record.getAccountNumber()); criteria.addEqualTo(KFSPropertyConstants.SUB_ACCOUNT_NUMBER, record.getSubAccountNumber()); criteria.addEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, budgetYear); BudgetConstructionHeader header = (BudgetConstructionHeader)getPersistenceBrokerTemplate().getObjectByQuery(QueryFactory.newQuery(BudgetConstructionHeader.class, criteria)); return header; }