/** * 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; }
/** * This method creates a criteria to find the cashiering checks associated with a given deposit * * @param documentNumber the document number the deposit is associated with * @param depositLineNumber the line number of the deposit * @return a criteria to find those checks */ protected Criteria createDepositedCashieringCheckCriteria(String documentNumber, Integer depositLineNumber) { Criteria criteria = getCashDetailCriteria(documentNumber, CashieringTransaction.DETAIL_DOCUMENT_TYPE, KFSConstants.CheckSources.CASH_MANAGEMENT); criteria.addEqualTo("financialDocumentDepositLineNumber", depositLineNumber); return 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 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; }
/** * @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)); } }
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)); }
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)); }
/** * @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.module.ld.dataaccess.LaborLedgerBalanceDao#deleteLedgerBalancesPriorToYear(java.lang.Integer, java.lang.String) */ public void deleteLedgerBalancesPriorToYear(Integer fiscalYear, String chartOfAccountsCode) { LOG.debug("deleteLedgerBalancesPriorToYear() started"); Criteria criteria = new Criteria(); criteria.addLessThan(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, fiscalYear); criteria.addEqualTo(KFSPropertyConstants.CHART_OF_ACCOUNTS_CODE, chartOfAccountsCode); QueryByCriteria query = new QueryByCriteria(LedgerBalance.class, criteria); getPersistenceBrokerTemplate().deleteByQuery(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.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 <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; }