Java QueryByCriteria.addOrderByAscending方法代码示例

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.kfs.module.bc.document.dataaccess.BudgetConstructionDao#getDocumentPBGLFringeLines(java.lang.String,
 *      java.util.List)
 */
public List getDocumentPBGLFringeLines(String documentNumber, List fringeObjects) {
    List documentPBGLfringeLines = new ArrayList();

    // we probably should just add a clearcache call at the end of all JDBC public methods that update the DB
    getPersistenceBrokerTemplate().clearCache();

    Criteria criteria = new Criteria();
    criteria.addEqualTo("documentNumber", documentNumber);
    criteria.addIn("financialObjectCode", fringeObjects);
    QueryByCriteria query = QueryFactory.newQuery(PendingBudgetConstructionGeneralLedger.class, criteria);
    query.addOrderByAscending("financialObjectCode");
    documentPBGLfringeLines = (List) getPersistenceBrokerTemplate().getCollectionByQuery(query);

    return documentPBGLfringeLines;
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
 * Returns an Iterator of all encumbrances that need to be closed for the fiscal year and specified charts
 *
 * @param fiscalYear a fiscal year to find encumbrances for
 * @param charts charts to find encumbrances for
 * @return an Iterator of encumbrances to close
 * @see org.kuali.kfs.gl.dataaccess.EncumbranceDao#getEncumbrancesToClose(java.lang.Integer, java.util.List)
 */
@Override
public Iterator getEncumbrancesToClose(Integer fiscalYear, List<String> charts) {

    Criteria criteria = new Criteria();
    criteria.addEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, fiscalYear);
    criteria.addIn(KFSPropertyConstants.CHART_OF_ACCOUNTS_CODE, charts);

    QueryByCriteria query = new QueryByCriteria(Encumbrance.class, criteria);
    query.addOrderByAscending(KFSPropertyConstants.CHART_OF_ACCOUNTS_CODE);
    query.addOrderByAscending(KFSPropertyConstants.ACCOUNT_NUMBER);
    query.addOrderByAscending(KFSPropertyConstants.SUB_ACCOUNT_NUMBER);
    query.addOrderByAscending(KFSPropertyConstants.OBJECT_CODE);
    query.addOrderByAscending(KFSPropertyConstants.SUB_OBJECT_CODE);
    query.addOrderByAscending(KFSPropertyConstants.BALANCE_TYPE_CODE);

    return getPersistenceBrokerTemplate().getIteratorByQuery(query);
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
public Collection<AssetPayment> getAssetPayments(List<Asset> assets) {
    List<Long> capitalAssetNumbers = new ArrayList<Long>();

    for(Asset asset : assets) {
        capitalAssetNumbers.add(asset.getCapitalAssetNumber());
    }

    Criteria criteria = new Criteria();
    criteria.addIn(CamsPropertyConstants.AssetPayment.CAPITAL_ASSET_NUMBER, capitalAssetNumbers);

    QueryByCriteria q = QueryFactory.newQuery(AssetPayment.class, criteria);
    q.addOrderByAscending(CamsPropertyConstants.AssetPayment.CAPITAL_ASSET_NUMBER);
    q.addOrderByAscending(CamsPropertyConstants.AssetPayment.PAYMENT_SEQ_NUMBER);
    Collection<AssetPayment> assetPayments = getPersistenceBrokerTemplate().getCollectionByQuery(q);
    return assetPayments;
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.kfs.gl.dataaccess.BalanceDao#findGeneralBalancesToForwardForFiscalYear(java.lang.Integer, java.util.List,
 *      java.lang.String[])
 */
@Override
public Iterator<Balance> findGeneralBalancesToForwardForFiscalYear(Integer year, Collection<String> generalForwardBalanceObjectTypes, Collection<String> generalBalanceForwardBalanceTypes) {

    Criteria c = new Criteria();
    c.addEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, year);
    c.addIn(KFSPropertyConstants.BALANCE_TYPE_CODE, generalBalanceForwardBalanceTypes);
    c.addIn(KFSPropertyConstants.OBJECT_TYPE_CODE, generalForwardBalanceObjectTypes);

    QueryByCriteria query = QueryFactory.newQuery(Balance.class, c);
    query.addOrderByAscending(KFSPropertyConstants.CHART_OF_ACCOUNTS_CODE);
    query.addOrderByAscending(KFSPropertyConstants.ACCOUNT_NUMBER);
    query.addOrderByAscending(KFSPropertyConstants.SUB_ACCOUNT_NUMBER);
    query.addOrderByAscending(KFSPropertyConstants.OBJECT_CODE);
    query.addOrderByAscending(KFSPropertyConstants.SUB_OBJECT_CODE);
    query.addOrderByAscending(KFSPropertyConstants.BALANCE_TYPE_CODE);
    query.addOrderByAscending(KFSPropertyConstants.OBJECT_TYPE_CODE);

    Iterator<Balance> balances = getPersistenceBrokerTemplate().getIteratorByQuery(query);

    return balances;
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
 * Find all matching account balances. The Sufficient funds code is used to determine the sort of the results.
 *
 * @param universityFiscalYear the university fiscal year of balances to return
 * @param chartOfAccountsCode the chart of accounts code of balances to return
 * @param accountNumber the account number of balances to return
 * @param sfCode the sufficient funds code, used to sort on
 * @return an Iterator of balances
 */
@Override
public Iterator<Balance> findAccountBalances(Integer universityFiscalYear, String chartOfAccountsCode, String accountNumber, String sfCode) {
    LOG.debug("findAccountBalances() started");

    Criteria crit = new Criteria();
    crit.addEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, universityFiscalYear);
    crit.addEqualTo(KFSPropertyConstants.CHART_OF_ACCOUNTS_CODE, chartOfAccountsCode);
    crit.addEqualTo(KFSPropertyConstants.ACCOUNT_NUMBER, accountNumber);

    QueryByCriteria qbc = QueryFactory.newQuery(Balance.class, crit);
    if (KFSConstants.SF_TYPE_OBJECT.equals(sfCode)) {
        qbc.addOrderByAscending(KFSPropertyConstants.OBJECT_CODE);
    }
    else if (KFSConstants.SF_TYPE_LEVEL.equals(sfCode)) {
        qbc.addOrderByAscending(GeneralLedgerConstants.BalanceInquiryDrillDowns.OBJECT_LEVEL_CODE);
    }
    else if (KFSConstants.SF_TYPE_CONSOLIDATION.equals(sfCode)) {
        qbc.addOrderByAscending(GeneralLedgerConstants.BalanceInquiryDrillDowns.CONSOLIDATION_OBJECT_CODE);
    }
    return getPersistenceBrokerTemplate().getIteratorByQuery(qbc);
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
 * Distinct Query
 */
public void testDistinct()
{

    Criteria crit = new Criteria();
    crit.addLike("allArticlesInGroup.articleName", "C%");
    QueryByCriteria q = QueryFactory.newQuery(ProductGroup.class, crit, true);
    q.addOrderByAscending("groupId");

    Collection results = broker.getCollectionByQuery(q);
    assertNotNull(results);
    assertEquals(5, results.size());

    // compare with count
    int count = broker.getCount(q);
    assertEquals(results.size(), count);
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
 * ReportQuery returning rows with some "Liquor" data ordered by productGroup.groupId
 */
public void testQueryOrderByNonSelectColumn()
{

    Criteria crit = new Criteria();
    Collection results = new Vector();
    crit.addEqualTo("productGroup.groupName", "Liquors");
    QueryByCriteria q = QueryFactory.newQuery(Article.class, crit);
    q.addOrderByAscending("productGroup.groupId");

    Iterator iter = broker.getIteratorByQuery(q);
    assertNotNull(iter);
    while(iter.hasNext())
    {
        results.add(iter.next());
    }
    assertTrue(results.size() > 0);

}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.kfs.module.bc.document.dataaccess.BudgetConstructionDao#getAccountOrgHierForAccount(java.lang.String,
 *      java.lang.String, java.lang.Integer)
 */
public List<BudgetConstructionAccountOrganizationHierarchy> getAccountOrgHierForAccount(String chartOfAccountsCode, String accountNumber, Integer universityFiscalYear) {
    List<BudgetConstructionAccountOrganizationHierarchy> accountOrgHier = new ArrayList();

    Criteria criteria = new Criteria();
    criteria.addEqualTo("universityFiscalYear", universityFiscalYear);
    criteria.addEqualTo("chartOfAccountsCode", chartOfAccountsCode);
    criteria.addEqualTo("accountNumber", accountNumber);

    QueryByCriteria query = QueryFactory.newQuery(BudgetConstructionAccountOrganizationHierarchy.class, criteria);
    query.addOrderByAscending("organizationLevelCode");

    accountOrgHier = (List) getPersistenceBrokerTemplate().getCollectionByQuery(query);


    return accountOrgHier;
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.kfs.module.ld.dataaccess.LaborLedgerBalanceDao#findBalancesForFiscalYear(Integer, Map, List, List)
 */
public Iterator<LedgerBalance> findBalancesForFiscalYear(Integer fiscalYear, Map<String, String> fieldValues, List<String> encumbranceBalanceTypes) {

    Criteria criteria = buildCriteriaFromMap(fieldValues, new LedgerBalance(), encumbranceBalanceTypes, false);
    criteria.addEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, fiscalYear);

    QueryByCriteria query = QueryFactory.newQuery(LedgerBalance.class, criteria);

    query.addOrderByAscending(KFSPropertyConstants.CHART_OF_ACCOUNTS_CODE);
    query.addOrderByAscending(KFSPropertyConstants.ACCOUNT_NUMBER);
    query.addOrderByAscending(KFSPropertyConstants.SUB_ACCOUNT_NUMBER);
    query.addOrderByAscending(KFSPropertyConstants.FINANCIAL_OBJECT_CODE);
    query.addOrderByAscending(KFSPropertyConstants.FINANCIAL_SUB_OBJECT_CODE);
    query.addOrderByAscending(KFSPropertyConstants.FINANCIAL_BALANCE_TYPE_CODE);
    query.addOrderByAscending(KFSPropertyConstants.FINANCIAL_OBJECT_TYPE_CODE);

    return getPersistenceBrokerTemplate().getIteratorByQuery(query);
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.kfs.module.cab.batch.dataaccess.ExtractDao#findPaymentRequestAccountHistory(org.kuali.kfs.module.cab.businessobject.BatchParameters)
 */
@Override
public Collection<PaymentRequestAccountRevision> findPaymentRequestAccountRevisions(BatchParameters batchParameters) {
    Criteria criteria = new Criteria();
    criteria.addGreaterThan(CabPropertyConstants.PaymentRequestAccountRevision.ACCOUNT_REVISION_TIMESTAMP, batchParameters.getLastRunTime());

    if (!batchParameters.getExcludedChartCodes().isEmpty()) {
        criteria.addNotIn(CabPropertyConstants.PaymentRequestAccountRevision.CHART_OF_ACCOUNTS_CODE, batchParameters.getExcludedChartCodes());
    }

    if (!batchParameters.getExcludedSubFundCodes().isEmpty()) {
        criteria.addNotIn(CabPropertyConstants.PaymentRequestAccountRevision.ACCOUNT_SUB_FUND_GROUP_CODE, batchParameters.getExcludedSubFundCodes());
    }

    if (!batchParameters.getIncludedFinancialObjectSubTypeCodes().isEmpty()) {
        criteria.addIn(CabPropertyConstants.PaymentRequestAccountRevision.FINANCIAL_OBJECT_FINANCIAL_OBJECT_SUB_TYPE_CODE, batchParameters.getIncludedFinancialObjectSubTypeCodes());
    }

    QueryByCriteria query = new QueryByCriteria(PaymentRequestAccountRevision.class, criteria);
    query.addOrderByAscending(CabPropertyConstants.PaymentRequestAccountRevision.ACCOUNT_REVISION_TIMESTAMP);
    Collection<PaymentRequestAccountRevision> historyRecs = getPersistenceBrokerTemplate().getCollectionByQuery(query);
    return historyRecs;
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
 * @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);
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
 * @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);
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
 * This is the default impl that comes with Kuali - uses OJB.
 *
 * @see org.kuali.rice.krad.dao.BusinessObjectDao#findMatching(java.lang.Class, java.util.Map)
 */
public <T extends BusinessObject> Collection<T> findMatchingOrderBy(Class<T> clazz, Map<String, ?> fieldValues, String sortField, boolean sortAscending) {
    Criteria criteria = buildCriteria(fieldValues);
    QueryByCriteria queryByCriteria = new QueryByCriteria(clazz, criteria);

    if (sortAscending) {
        queryByCriteria.addOrderByAscending(sortField);
    }
    else {
        queryByCriteria.addOrderByDescending(sortField);
    }

    return (Collection<T>)getPersistenceBrokerTemplate().getCollectionByQuery(queryByCriteria);
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
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);
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.kfs.module.cab.batch.dataaccess.ExtractDao#findMatchingGLEntries(org.kuali.kfs.module.cab.businessobject.BatchParameters)
 */
@Override
public Collection<Entry> findMatchingGLEntries(BatchParameters batchParameters) {
    Criteria criteria = new Criteria();
    criteria.addGreaterThan(CabPropertyConstants.Entry.TRANSACTION_DATE_TIME_STAMP, batchParameters.getLastRunTime());

    if (!batchParameters.getExcludedChartCodes().isEmpty()) {
        criteria.addNotIn(CabPropertyConstants.Entry.CHART_OF_ACCOUNTS_CODE, batchParameters.getExcludedChartCodes());
    }

    if (!batchParameters.getExcludedSubFundCodes().isEmpty()) {
        criteria.addNotIn(CabPropertyConstants.Entry.ACCOUNT_SUB_FUND_GROUP_CODE, batchParameters.getExcludedSubFundCodes());
    }

    if (!batchParameters.getIncludedFinancialBalanceTypeCodes().isEmpty()) {
        criteria.addIn(CabPropertyConstants.Entry.FINANCIAL_BALANCE_TYPE_CODE, batchParameters.getIncludedFinancialBalanceTypeCodes());
    }

    if (!batchParameters.getIncludedFinancialObjectSubTypeCodes().isEmpty()) {
        criteria.addIn(CabPropertyConstants.Entry.FINANCIAL_OBJECT_FINANCIAL_OBJECT_SUB_TYPE_CODE, batchParameters.getIncludedFinancialObjectSubTypeCodes());
    }

    if (!batchParameters.getExcludedFiscalPeriods().isEmpty()) {
        criteria.addNotIn(CabPropertyConstants.Entry.UNIVERSITY_FISCAL_PERIOD_CODE, batchParameters.getExcludedFiscalPeriods());
    }

    if (!batchParameters.getExcludedDocTypeCodes().isEmpty()) {
        criteria.addNotIn(CabPropertyConstants.Entry.FINANCIAL_DOCUMENT_TYPE_CODE, batchParameters.getExcludedDocTypeCodes());
    }

    QueryByCriteria query = new QueryByCriteria(Entry.class, criteria);
    query.addOrderByAscending(CabPropertyConstants.Entry.DOCUMENT_NUMBER);
    query.addOrderByAscending(CabPropertyConstants.Entry.TRANSACTION_DATE_TIME_STAMP);
    return getPersistenceBrokerTemplate().getCollectionByQuery(query);
}