当前位置: 首页>>代码示例>>Java>>正文

Java Criteria.addNotIn方法代码示例

本文整理汇总了Java中org.apache.ojb.broker.query.Criteria.addNotIn方法的典型用法代码示例。如果您正苦于以下问题：Java Criteria.addNotIn方法的具体用法？Java Criteria.addNotIn怎么用？Java Criteria.addNotIn使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类org.apache.ojb.broker.query.Criteria的用法示例。


在下文中一共展示了Criteria.addNotIn方法的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Java代码示例。

示例1: buildNegativeCriteria

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * This method will build out criteria in the key-value paradigm (attribute-value).
 *
 * @param negativeFieldValues
 * @return
 */
private Criteria buildNegativeCriteria(Map<String, ?> negativeFieldValues) {
    Criteria criteria = new Criteria();
    for (Iterator i = negativeFieldValues.entrySet().iterator(); i.hasNext();) {
        Map.Entry<String, Object> e = (Map.Entry<String, Object>) i.next();

        String key = e.getKey();
        Object value = e.getValue();
        if (value instanceof Collection) {
            criteria.addNotIn(key, (Collection) value);
        }
        else {
            criteria.addNotEqualTo(key, value);
        }
    }

    return criteria;
}
开发者ID:kuali，项目名称:kc-rice，代码行数:24，代码来源:BusinessObjectDaoOjb.java

示例2: criteriaBuilderHelper

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * This method provides the implementation for the conveniences methods criteriaBuilder & negatedCriteriaBuilder
 * 
 * @param criteria - the criteria that might have a criterion appended
 * @param name - name of the attribute
 * @param collection - the collection to inspect
 * @param negate - the criterion will be negated (NOT EQUALS, NOT IN) when this is true
 */
protected void criteriaBuilderHelper(Criteria criteria, String name, Collection collection, boolean negate) {
    if (collection != null) {
        int size = collection.size();
        if (size == 1) {
            if (negate) {
                criteria.addNotEqualTo(name, collection.iterator().next());
            }
            else {
                criteria.addEqualTo(name, collection.iterator().next());
            }
        }
        if (size > 1) {
            if (negate) {
                criteria.addNotIn(name, collection);
            }
            else {
                criteria.addIn(name, collection);

            }
        }
    }

}
开发者ID:VU-libtech，项目名称:OLE-INST，代码行数:32，代码来源:BalanceDaoOjb.java

示例3: criteriaBuilderHelper

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * This method provides the implementation for the conveniences methods criteriaBuilder & negatedCriteriaBuilder
 *
 * @param criteria - the criteria that might have a criterion appended
 * @param name - name of the attribute
 * @param collection - the collection to inspect
 * @param negate - the criterion will be negated (NOT EQUALS, NOT IN) when this is true
 */
protected void criteriaBuilderHelper(Criteria criteria, String name, Collection collection, boolean negate) {
    if (collection != null) {
        int size = collection.size();
        if (size == 1) {
            if (negate) {
                criteria.addNotEqualTo(name, collection.iterator().next());
            }
            else {
                criteria.addEqualTo(name, collection.iterator().next());
            }
        }
        if (size > 1) {
            if (negate) {
                criteria.addNotIn(name, collection);
            }
            else {
                criteria.addIn(name, collection);

            }
        }
    }

}
开发者ID:kuali，项目名称:kfs，代码行数:32，代码来源:BalanceDaoOjb.java

示例4: findCreditMemoAccountRevisions

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

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

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

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

    QueryByCriteria query = new QueryByCriteria(CreditMemoAccountRevision.class, criteria);
    query.addOrderByAscending(CabPropertyConstants.CreditMemoAccountRevision.ACCOUNT_REVISION_TIMESTAMP);
    Collection<CreditMemoAccountRevision> historyRecs = getPersistenceBrokerTemplate().getCollectionByQuery(query);
    return historyRecs;
}
开发者ID:kuali，项目名称:kfs，代码行数:26，代码来源:ExtractDaoOjb.java

示例5: findPaymentRequestAccountRevisions

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的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;
}
开发者ID:kuali，项目名称:kfs，代码行数:26，代码来源:ExtractDaoOjb.java

示例6: addInactivateableFromToCurrentCriteria

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
    * Translates criteria for current status to criteria on the active from field
    * 
    * @param example - business object being queried on
    * @param currentSearchValue - value for the current search field, should convert to boolean
    * @param criteria - Criteria object being built
    */
protected void addInactivateableFromToCurrentCriteria(Object example, String currentSearchValue, Criteria criteria, Map searchValues) {
	Criteria maxBeginDateCriteria = new Criteria();
	
	Timestamp activeTimestamp = LookupUtils.getActiveDateTimestampForCriteria(searchValues);
	
	maxBeginDateCriteria.addLessOrEqualThan(KRADPropertyConstants.ACTIVE_FROM_DATE, activeTimestamp);

	List<String> groupByFieldList = dataDictionaryService.getGroupByAttributesForEffectiveDating(example
			.getClass());
	if (groupByFieldList == null) {
		return;
	}

	// join back to main query with the group by fields
	String[] groupBy = new String[groupByFieldList.size()];
	for (int i = 0; i < groupByFieldList.size(); i++) {
		String groupByField = groupByFieldList.get(i);
		groupBy[i] = groupByField;

		maxBeginDateCriteria.addEqualToField(groupByField, Criteria.PARENT_QUERY_PREFIX + groupByField);
	}

	String[] columns = new String[1];
	columns[0] = "max(" + KRADPropertyConstants.ACTIVE_FROM_DATE + ")";

	QueryByCriteria query = QueryFactory.newReportQuery(example.getClass(), columns, maxBeginDateCriteria, true);
	query.addGroupBy(groupBy);

	String currentBooleanStr = (String) (new OjbCharBooleanConversion()).javaToSql(currentSearchValue);
	if (OjbCharBooleanConversion.DATABASE_BOOLEAN_TRUE_STRING_REPRESENTATION.equals(currentBooleanStr)) {
		criteria.addIn(KRADPropertyConstants.ACTIVE_FROM_DATE, query);
	} else if (OjbCharBooleanConversion.DATABASE_BOOLEAN_FALSE_STRING_REPRESENTATION.equals(currentBooleanStr)) {
		criteria.addNotIn(KRADPropertyConstants.ACTIVE_FROM_DATE, query);
	}
}
开发者ID:kuali，项目名称:kc-rice，代码行数:43，代码来源:LookupDaoOjb.java

示例7: testSubQuery2

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * test Subquery get all product groups without articles
 * <p/>
 * test may fail if db does not support sub queries
 */
public void testSubQuery2()
{
    Collection results = null;
    String stamp = "" + System.currentTimeMillis();
    int loops = 10;
    // create ProductGroups without article
    broker.beginTransaction();
    for(int i = 0; i < loops; i++)
    {
        ProductGroup pg = new ProductGroup();
        pg.setGroupName("test group " + stamp);
        pg.setDescription("build by QueryTest#testSubQuery2");
        broker.store(pg);
    }
    broker.commitTransaction();

    ReportQueryByCriteria subQuery;
    Criteria subCrit = new Criteria();
    Criteria crit = new Criteria();

    subQuery = QueryFactory.newReportQuery(Article.class, subCrit);
    subQuery.setAttributes(new String[]{"productGroupId"});
    subQuery.setDistinct(true);

    crit.addEqualTo("groupName", "test group " + stamp);
    crit.addNotIn("groupId", subQuery);
    Query q = QueryFactory.newQuery(ProductGroup.class, crit);

    results = broker.getCollectionByQuery(q);
    assertNotNull(results);
    assertEquals("Result of the query with sub-query does not match", loops, results.size());
}
开发者ID:KualiCo，项目名称:ojb，代码行数:38，代码来源:QueryTest.java

示例8: findTravelAuthorizationByTraveler

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
@Override
public List<TravelAuthorizationDocument> findTravelAuthorizationByTraveler(Integer temProfileId) {

    final Criteria criteria = new Criteria();
    criteria.addEqualTo(TemPropertyConstants.TEM_PROFILE_ID, temProfileId);
    criteria.addNotIn(KFSPropertyConstants.DOCUMENT_HEADER+"."+KFSPropertyConstants.FINANCIAL_DOCUMENT_STATUS_CODE, Arrays.asList(DocumentStatusCodes.INITIATED));
    return  (List<TravelAuthorizationDocument>) getPersistenceBrokerTemplate().getCollectionByQuery(new QueryByCriteria(TravelAuthorizationDocument.class, criteria));

}
开发者ID:kuali，项目名称:kfs，代码行数:10，代码来源:TravelAuthorizationDaoOjb.java

示例9: buildFinancialSystemDocumentHeaderCriteria

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * @return the criteria which will be used to variously find all remaining-to-be-processed FinancialSystemDocumentHeader records
 */
protected Criteria buildFinancialSystemDocumentHeaderCriteria() {
    Criteria c = new Criteria();
    c.addIsNull(KFSPropertyConstants.INITIATOR_PRINCIPAL_ID);
    c.addNotIn(KFSPropertyConstants.DOCUMENT_NUMBER, buildFinancialSystemDocumentHeadersWithNoWorkflowHeadersSubQuery());
    return c;
}
开发者ID:kuali，项目名称:kfs，代码行数:10，代码来源:FinancialSystemDocumentHeaderPopulationDaoOjb.java

示例10: findMatchingGLEntries

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的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);
}
开发者ID:kuali，项目名称:kfs，代码行数:38，代码来源:ExtractDaoOjb.java

示例11: findPreTaggablePOAccounts

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.kfs.module.cab.batch.dataaccess.ExtractDao#findPreTaggablePOAccounts(org.kuali.kfs.module.cab.businessobject.BatchParameters, java.util.List)
 */
@Override
public Collection<PurchaseOrderAccount> findPreTaggablePOAccounts(BatchParameters batchParameters, List<String> docNumbersAwaitingPurchaseOrderStatus) {
    Criteria statusCodeCond1 = new Criteria();
    statusCodeCond1.addEqualTo(CabPropertyConstants.PreTagExtract.PURAP_CAPITAL_ASSET_SYSTEM_STATE_CODE, CabConstants.CAPITAL_ASSET_SYSTEM_STATE_CODE_NEW);

    Criteria statusCodeOrCond = new Criteria();
    statusCodeOrCond.addIsNull(CabPropertyConstants.PreTagExtract.PURAP_CAPITAL_ASSET_SYSTEM_STATE_CODE);
    statusCodeOrCond.addOrCriteria(statusCodeCond1);

    Criteria criteria = new Criteria();
    Timestamp lastRunTimestamp = new Timestamp(((java.util.Date) batchParameters.getLastRunDate()).getTime());
    criteria.addGreaterThan(CabPropertyConstants.PreTagExtract.PO_INITIAL_OPEN_TIMESTAMP, lastRunTimestamp);
    criteria.addAndCriteria(statusCodeOrCond);
    criteria.addGreaterOrEqualThan(CabPropertyConstants.PreTagExtract.PURAP_ITEM_UNIT_PRICE, batchParameters.getCapitalizationLimitAmount());

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

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

    if (!batchParameters.getIncludedFinancialObjectSubTypeCodes().isEmpty()) {
        criteria.addIn(CabPropertyConstants.PreTagExtract.FINANCIAL_OBJECT_SUB_TYPE_CODE, batchParameters.getIncludedFinancialObjectSubTypeCodes());
    }

    QueryByCriteria query = new QueryByCriteria(PurchaseOrderAccount.class, criteria);
    Collection<PurchaseOrderAccount> purchaseOrderAccounts = getPersistenceBrokerTemplate().getCollectionByQuery(query);

    Collection<PurchaseOrderAccount> purchaseOrderAcctsAwaitingPOOpenStatus = new ArrayList<PurchaseOrderAccount>();
    for (PurchaseOrderAccount purchaseOrderAccount : purchaseOrderAccounts) {
        if (docNumbersAwaitingPurchaseOrderStatus.contains(purchaseOrderAccount.getDocumentNumber())) {
            purchaseOrderAcctsAwaitingPOOpenStatus.add(purchaseOrderAccount);
        }
    }
    return purchaseOrderAcctsAwaitingPOOpenStatus;
}
开发者ID:kuali，项目名称:kfs，代码行数:42，代码来源:ExtractDaoOjb.java

示例12: findOrganizationReversionBalancesForFiscalYear

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * Returns a list of balances to return for the Organization Reversion year end job to process
 * 
 * @param the university fiscal year to find balances for
 * @param endOfYear if true, use current year accounts, otherwise use prior year accounts
 * @return an Iterator of Balances to process
 * @see org.kuali.ole.gl.dataaccess.BalanceDao#findOrganizationReversionBalancesForFiscalYear(Integer, boolean, SystemOptions)
 */
public Iterator<Balance> findOrganizationReversionBalancesForFiscalYear(Integer year, boolean endOfYear, SystemOptions options, List<ParameterEvaluator> parameterEvaluators) {
    LOG.debug("findOrganizationReversionBalancesForFiscalYear() started");
    Criteria c = new Criteria();
    c.addEqualTo(OLEPropertyConstants.UNIVERSITY_FISCAL_YEAR, year);

    for (ParameterEvaluator parameterEvaluator : parameterEvaluators) {

        String currentRule = parameterEvaluator.getValue();
        if (endOfYear) {
            currentRule = currentRule.replaceAll("account\\.", "priorYearAccount.");
        }
        if (StringUtils.isNotBlank(currentRule)) {
            String propertyName = StringUtils.substringBefore(currentRule, "=");
            List<String> ruleValues = Arrays.asList(StringUtils.substringAfter(currentRule, "=").split(";"));
            if (propertyName != null && propertyName.length() > 0 && ruleValues.size() > 0 && !StringUtils.isBlank(ruleValues.get(0))) {
                if (parameterEvaluator.constraintIsAllow()) {
                    c.addIn(propertyName, ruleValues);
                }
                else {
                    c.addNotIn(propertyName, ruleValues);
                }
            }
        }
    }
    // we only ever calculate on CB, AC, and encumbrance types, so let's only select those
    List organizationReversionBalancesToSelect = new ArrayList();
    organizationReversionBalancesToSelect.add(options.getActualFinancialBalanceTypeCd());
    organizationReversionBalancesToSelect.add(options.getFinObjTypeExpenditureexpCd());
    organizationReversionBalancesToSelect.add(options.getCostShareEncumbranceBalanceTypeCd());
    organizationReversionBalancesToSelect.add(options.getIntrnlEncumFinBalanceTypCd());
    organizationReversionBalancesToSelect.add(OLEConstants.BALANCE_TYPE_CURRENT_BUDGET);
    c.addIn(OLEPropertyConstants.BALANCE_TYPE_CODE, organizationReversionBalancesToSelect);
    QueryByCriteria query = QueryFactory.newQuery(Balance.class, c);
    query.addOrderByAscending(OLEPropertyConstants.CHART_OF_ACCOUNTS_CODE);
    query.addOrderByAscending(OLEPropertyConstants.ACCOUNT_NUMBER);
    query.addOrderByAscending(OLEPropertyConstants.SUB_ACCOUNT_NUMBER);
    query.addOrderByAscending(OLEPropertyConstants.OBJECT_CODE);
    query.addOrderByAscending(OLEPropertyConstants.SUB_OBJECT_CODE);
    query.addOrderByAscending(OLEPropertyConstants.BALANCE_TYPE_CODE);
    query.addOrderByAscending(OLEPropertyConstants.OBJECT_TYPE_CODE);

    return getPersistenceBrokerTemplate().getIteratorByQuery(query);
}
开发者ID:VU-libtech，项目名称:OLE-INST，代码行数:52，代码来源:BalanceDaoOjb.java

示例13: inExpr

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
public final void inExpr(
	Criteria criteria
) throws RecognitionException, TokenStreamException {
	
	Token  id = null;
	
	try {      // for error handling
		
			 boolean negative = false;
			 Collection coll;
		
		id = LT(1);
		match(Identifier);
		{
		if ((LA(1)==LITERAL_not)) {
			match(LITERAL_not);
			negative = true;
		}
		else if ((LA(1)==LITERAL_in)) {
		}
		else {
			throw new NoViableAltException(LT(1), getFilename());
		}
		
		}
		match(LITERAL_in);
		{
		if ((LA(1)==LITERAL_list)) {
			match(LITERAL_list);
		}
		else if ((LA(1)==TOK_LPAREN)) {
		}
		else {
			throw new NoViableAltException(LT(1), getFilename());
		}
		
		}
		coll=argList();
		
		if (negative) {
		criteria.addNotIn(id.getText(), coll);
		} else {
		criteria.addIn(id.getText(), coll);
		}
		
	}
	catch (RecognitionException ex) {
		reportError(ex);
		recover(ex,_tokenSet_7);
	}
}
开发者ID:KualiCo，项目名称:ojb，代码行数:52，代码来源:OQLParser.java

示例14: findMatchingTrips

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
@Override
public Collection<? extends TEMReimbursementDocument> findMatchingTrips (Integer temProfileId ,Timestamp tripBegin, Timestamp tripEnd)  {


    final Criteria criteria = new Criteria();
    final Criteria orEndDateCriteria = new Criteria();
    criteria.addEqualTo(TemPropertyConstants.TEM_PROFILE_ID, temProfileId);
    criteria.addEqualTo(TemPropertyConstants.TRIP_BEGIN_DT, tripBegin);
    orEndDateCriteria.addEqualTo(TemPropertyConstants.TRIP_END_DT, tripEnd);
    criteria.addOrCriteria(orEndDateCriteria);
    criteria.addNotIn("documentHeader.financialDocumentStatusCode", Arrays.asList(DocumentStatusCodes.INITIATED));

    return  getPersistenceBrokerTemplate().getCollectionByQuery(new QueryByCriteria(TravelReimbursementDocument.class, criteria));


}
开发者ID:kuali，项目名称:kfs，代码行数:17，代码来源:TravelDocumentDaoOjb.java

示例15: findOrganizationReversionBalancesForFiscalYear

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * Returns a list of balances to return for the Organization Reversion year end job to process
 *
 * @param the university fiscal year to find balances for
 * @param endOfYear if true, use current year accounts, otherwise use prior year accounts
 * @return an Iterator of Balances to process
 * @see org.kuali.kfs.gl.dataaccess.BalanceDao#findOrganizationReversionBalancesForFiscalYear(Integer, boolean, SystemOptions)
 */
@Override
public Iterator<Balance> findOrganizationReversionBalancesForFiscalYear(Integer year, boolean endOfYear, SystemOptions options, List<ParameterEvaluator> parameterEvaluators) {
    LOG.debug("findOrganizationReversionBalancesForFiscalYear() started");
    Criteria c = new Criteria();
    c.addEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, year);

    for (ParameterEvaluator parameterEvaluator : parameterEvaluators) {

        String currentRule = parameterEvaluator.getValue();
        if (endOfYear) {
            currentRule = currentRule.replaceAll("account\\.", "priorYearAccount.");
        }
        if (StringUtils.isNotBlank(currentRule)) {
            String propertyName = StringUtils.substringBefore(currentRule, "=");
            List<String> ruleValues = Arrays.asList(StringUtils.substringAfter(currentRule, "=").split(";"));
            if (propertyName != null && propertyName.length() > 0 && ruleValues.size() > 0 && !StringUtils.isBlank(ruleValues.get(0))) {
                if (parameterEvaluator.constraintIsAllow()) {
                    c.addIn(propertyName, ruleValues);
                }
                else {
                    c.addNotIn(propertyName, ruleValues);
                }
            }
        }
    }
    // we only ever calculate on CB, AC, and encumbrance types, so let's only select those
    List organizationReversionBalancesToSelect = new ArrayList();
    organizationReversionBalancesToSelect.add(options.getActualFinancialBalanceTypeCd());
    organizationReversionBalancesToSelect.add(options.getFinObjTypeExpenditureexpCd());
    organizationReversionBalancesToSelect.add(options.getCostShareEncumbranceBalanceTypeCd());
    organizationReversionBalancesToSelect.add(options.getIntrnlEncumFinBalanceTypCd());
    organizationReversionBalancesToSelect.add(KFSConstants.BALANCE_TYPE_CURRENT_BUDGET);
    c.addIn(KFSPropertyConstants.BALANCE_TYPE_CODE, organizationReversionBalancesToSelect);
    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);

    return getPersistenceBrokerTemplate().getIteratorByQuery(query);
}
开发者ID:kuali，项目名称:kfs，代码行数:53，代码来源:BalanceDaoOjb.java


注：本文中的org.apache.ojb.broker.query.Criteria.addNotIn方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。