Java Criteria.addOrCriteria方法代码示例

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * Builds a sub criteria object joined with an 'AND' or 'OR' (depending on splitValue) using the split values of propertyValue. Then joins back the
 * sub criteria to the main criteria using an 'AND'.
 */
private void addLogicalOperatorCriteria(String propertyName, String propertyValue, Class propertyType, boolean caseInsensitive, Criteria criteria, String splitValue) {
    String[] splitPropVal = StringUtils.split(propertyValue, splitValue);

    Criteria subCriteria = new Criteria();
    for (int i = 0; i < splitPropVal.length; i++) {
    	Criteria predicate = new Criteria();

        addCriteria(propertyName, splitPropVal[i], propertyType, caseInsensitive, false, predicate);
        if (splitValue.equals(SearchOperator.OR.op())) {
        	subCriteria.addOrCriteria(predicate);
        }
        if (splitValue.equals(SearchOperator.AND.op())) {
        	subCriteria.addAndCriteria(predicate);
        }
    }

    criteria.addAndCriteria(subCriteria);
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
Query queryRole(Actor actor, Movie movie)
{
    Criteria c = new Criteria();
    if(actor != null) c.addEqualTo("actorId", actor.getId());
    if(movie != null && actor != null)
    {
        Criteria c2 = new Criteria();
        c2.addEqualTo("movieIntId", movie.getIdInt());
        c2.addEqualTo("movieStrId", movie.getIdStr());
        c.addOrCriteria(c2);
    }
    else if(movie != null)
    {
        c.addEqualTo("movieIntId", movie.getIdInt());
        c.addEqualTo("movieStrId", movie.getIdStr());
    }
    return QueryFactory.newQuery(Role.class, c);
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.ole.module.purap.document.dataaccess.InvoiceDao#getInvoicesToExtractForVendor(String,
 *      org.kuali.ole.module.purap.util.VendorGroupingHelper, Date)
 */
public Collection<InvoiceDocument> getInvoicesToExtractForVendor(String campusCode, VendorGroupingHelper vendor, Date onOrBeforeInvoicePayDate) {
    LOG.debug("getInvoicesToExtract() started");

    Criteria criteria = new Criteria();
    criteria.addEqualTo("processingCampusCode", campusCode);
    //criteria.addIn(PurapPropertyConstants.STATUS_CODE, statuses);
    criteria.addIsNull("extractedTimestamp");
    criteria.addEqualTo("holdIndicator", Boolean.FALSE);

    Criteria c1 = new Criteria();
    c1.addLessOrEqualThan("invoicePayDate", onOrBeforeInvoicePayDate);

    Criteria c2 = new Criteria();
    c2.addEqualTo("immediatePaymentIndicator", Boolean.TRUE);

    c1.addOrCriteria(c2);
    criteria.addAndCriteria(c1);

    criteria.addEqualTo("vendorHeaderGeneratedIdentifier", vendor.getVendorHeaderGeneratedIdentifier());
    criteria.addEqualTo("vendorDetailAssignedIdentifier", vendor.getVendorDetailAssignedIdentifier());
    criteria.addEqualTo("vendorCountryCode", vendor.getVendorCountry());
    criteria.addLike("vendorPostalCode", vendor.getVendorPostalCode() + "%");

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

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
public void testComplexCriteriaWithPathClasses_1()
{
    Criteria criteria         = new Criteria();
    Criteria categoryCriteria = new Criteria();
    Criteria topicCriteria    = new Criteria();

    topicCriteria.addEqualTo("qualifiers.importance", "important");
    topicCriteria.addPathClass("qualifiers", Topic.class);
    criteria.addOrCriteria(topicCriteria);
    categoryCriteria.addNotNull("qualifiers.description");
    categoryCriteria.addPathClass("qualifiers", Category.class);
    criteria.addOrCriteria(categoryCriteria);

    QueryByCriteria query   = QueryFactory.newQuery(BaseContentImpl.class, criteria, true);
    List            content = (List)broker.getCollectionByQuery(query);

    assertEquals(1, content.size());
    assertEquals(2, ((News)content.get(0)).getId());
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/** adds a composite predicate to a Criteria. */
private void addCompositePredicate(final CompositePredicate p, final Criteria parent,  LookupCustomizer.Transform<Predicate, Predicate> transform) {
    for (Predicate ip : p.getPredicates()) {
        final Criteria inner = new Criteria();
        addPredicate(ip, inner, transform);
        if (p instanceof AndPredicate) {
            parent.addAndCriteria(inner);
        } else if (p instanceof OrPredicate) {
            parent.addOrCriteria(inner);
        } else {
            throw new UnsupportedPredicateException(p);
        }
    }
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * Builds a criteria to find non-expired accounts
 * 
 * @return a Criteria for non-expired accounts
 */
protected Criteria getAccountNotExpiredCriteria(Date currentSqlDate) {
    Criteria criteria = new Criteria();
    criteria.addIsNull("accountExpirationDate");

    Criteria notYetExpiredCriteria = new Criteria();
    notYetExpiredCriteria.addGreaterThan("accountExpirationDate", currentSqlDate);

    criteria.addOrCriteria(notYetExpiredCriteria);
    return criteria;
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.ole.pdp.dataaccess.PendingTransactionDao#getUnextractedTransactions()
 */
public Iterator<GlPendingTransaction> getUnextractedTransactions() {
    LOG.debug("save() started");

    Criteria criteria = new Criteria();
    criteria.addEqualTo(PdpPropertyConstants.PROCESS_IND, false);
    
    Criteria criteria2 = new Criteria();
    criteria2.addIsNull(PdpPropertyConstants.PROCESS_IND);
    
    criteria.addOrCriteria(criteria2);
    return getPersistenceBrokerTemplate().getIteratorByQuery(new QueryByCriteria(GlPendingTransaction.class, criteria));
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
protected Criteria buildPayTypeCriteria(Map<Integer, Set<String>> payPeriods, List<String> balanceTypes, Map<String, Set<String>> earnCodePayGroupMap) {
    Criteria criteria = new Criteria();

    Criteria criteriaForPayPeriods = new Criteria();
    for (Integer fiscalYear : payPeriods.keySet()) {
        Criteria criteriaForFiscalYear = new Criteria();

        criteriaForFiscalYear.addEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, fiscalYear);
        criteriaForFiscalYear.addIn(KFSPropertyConstants.UNIVERSITY_FISCAL_PERIOD_CODE, payPeriods.get(fiscalYear));

        criteriaForPayPeriods.addOrCriteria(criteriaForFiscalYear);
    }

    Criteria criteriaForBalanceTypes = new Criteria();
    criteriaForBalanceTypes.addIn(KFSPropertyConstants.FINANCIAL_BALANCE_TYPE_CODE, balanceTypes);

    Criteria criteriaForEarnCodePayGroup = new Criteria();
    for (String payGroup : earnCodePayGroupMap.keySet()) {
        Criteria criteriaForEarnPay = new Criteria();

        criteriaForEarnPay.addEqualTo(KFSPropertyConstants.PAY_GROUP, payGroup);
        criteriaForEarnPay.addIn(KFSPropertyConstants.EARN_CODE, earnCodePayGroupMap.get(payGroup));

        criteriaForEarnCodePayGroup.addOrCriteria(criteriaForEarnPay);
    }

    criteria.addAndCriteria(criteriaForPayPeriods);
    criteria.addAndCriteria(criteriaForBalanceTypes);
    criteria.addAndCriteria(criteriaForEarnCodePayGroup);

    return criteria;
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.module.gl.dao.GeneralLedgerPendingEntryDao#findPendingLedgerEntries(org.kuali.ole.gl.businessobject.Encumbrance,
 *      boolean)
 */
@Override
public Iterator findPendingLedgerEntries(Encumbrance encumbrance, boolean isApproved) {
    LOG.debug("findPendingLedgerEntries(Encumbrance, boolean) started");

    // find pending ledger entry by the primary key fields of encumbrance
    Criteria criteria = new Criteria();
    criteria.addEqualTo(OLEPropertyConstants.UNIVERSITY_FISCAL_YEAR, encumbrance.getUniversityFiscalYear());
    criteria.addEqualTo(OLEPropertyConstants.CHART_OF_ACCOUNTS_CODE, encumbrance.getChartOfAccountsCode());
    criteria.addEqualTo(OLEPropertyConstants.ACCOUNT_NUMBER, encumbrance.getAccountNumber());
    criteria.addEqualTo(OLEPropertyConstants.SUB_ACCOUNT_NUMBER, encumbrance.getSubAccountNumber());
    criteria.addEqualTo(OLEPropertyConstants.FINANCIAL_OBJECT_CODE, encumbrance.getObjectCode());
    criteria.addEqualTo(OLEPropertyConstants.FINANCIAL_SUB_OBJECT_CODE, encumbrance.getSubObjectCode());
    criteria.addEqualTo(OLEPropertyConstants.FINANCIAL_BALANCE_TYPE_CODE, encumbrance.getBalanceTypeCode());
    criteria.addEqualTo(OLEPropertyConstants.FINANCIAL_DOCUMENT_TYPE_CODE, encumbrance.getDocumentTypeCode());
    criteria.addEqualTo(OLEPropertyConstants.ORGANIZATION_DOCUMENT_NUMBER, encumbrance.getDocumentNumber());

    // add the status codes into the criteria
    this.addStatusCode(criteria, isApproved);

    // Criteria: (originCode=originationCode OR originCode=originationReferenceCode)
    Criteria criteria1 = new Criteria();
    Criteria criteria2 = new Criteria();
    criteria1.addEqualTo(OLEPropertyConstants.FINANCIAL_SYSTEM_ORIGINATION_CODE, encumbrance.getOriginCode());
    criteria2.addEqualTo(OLEPropertyConstants.REFERENCE_FINANCIAL_SYSTEM_ORIGINATION_CODE, encumbrance.getOriginCode());
    criteria1.addOrCriteria(criteria2);

    // combine all criteria together
    criteria.addAndCriteria(criteria1);

    QueryByCriteria query = QueryFactory.newQuery(this.getEntryClass(), criteria);
    return getPersistenceBrokerTemplate().getIteratorByQuery(query);
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
@Override
public List<LeaveBlockHistory> getLeaveBlockHistoriesForLeaveDisplay(String principalId,
		LocalDate beginDate, LocalDate endDate, boolean considerModifiedUser) {
	
	List<LeaveBlockHistory> leaveBlockHistories = new ArrayList<LeaveBlockHistory>();
	
	Criteria root = new Criteria();
	root.addEqualTo("principalId", principalId);
	root.addGreaterOrEqualThan("leaveDate", beginDate.toDate());
	root.addLessOrEqualThan("leaveDate", endDate.toDate());
	root.addEqualTo("action",HrConstants.ACTION.MODIFIED);
	if(considerModifiedUser) {
		root.addNotEqualTo("principalIdModified", principalId);
	} 
	
	Criteria root1 = new Criteria();
	root1.addEqualTo("principalId", principalId);
	root1.addGreaterOrEqualThan("leaveDate", beginDate.toDate());
	root1.addLessOrEqualThan("leaveDate", endDate.toDate());
	root1.addEqualTo("action",HrConstants.ACTION.DELETE);
	if(considerModifiedUser) {
		root1.addNotEqualTo("principalIdDeleted", principalId);
	} 
	
	root.addOrCriteria(root1);
	
	Query query = QueryFactory.newQuery(LeaveBlockHistory.class, root);
	Collection c = this.getPersistenceBrokerTemplate()
			.getCollectionByQuery(query);

	if (c != null) {
		leaveBlockHistories.addAll(c);
	}
	return leaveBlockHistories;
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.kfs.coa.batch.dataaccess.impl.FiscalYearMakerHelperImpl#createSelectionCriteria(java.lang.Integer)
 */
@Override
public Criteria createSelectionCriteria(Integer baseFiscalYear) {
    // get default criteria equal to base year and active
    Criteria criteria = super.createSelectionCriteria(baseFiscalYear);

    // or with criteria to pick up budget dummy object for base year (active or inactive)
    Criteria criteriaBdg = new Criteria();
    criteriaBdg.addEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, baseFiscalYear);
    // REMOVE: THIS IS REALLY, REALLY BAD!  We should not be hard-coding object code values ANYWHERE!
    criteriaBdg.addEqualTo(KFSPropertyConstants.FINANCIAL_OBJECT_CODE, KFSConstants.BudgetConstructionConstants.OBJECT_CODE_2PLG);
    criteria.addOrCriteria(criteriaBdg);

    return criteria;
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
private Criteria getPkCriteriaForAllElements(PersistenceBroker broker)
{
    try
    {
        Criteria crit = null;
        for (int i = 0; i < elements.size(); i++)
        {
            DListEntry entry = (DListEntry) elements.get(i);
            Object obj = entry.getRealSubject();
            ClassDescriptor cld = broker.getClassDescriptor(obj.getClass());

            FieldDescriptor[] pkFields = cld.getPkFields();
            ValueContainer[] pkValues = broker.serviceBrokerHelper().getKeyValues(cld, obj);

            Criteria criteria = new Criteria();
            for (int j = 0; j < pkFields.length; j++)
            {
                FieldDescriptor fld = pkFields[j];
                criteria.addEqualTo(fld.getPersistentField().getName(), pkValues[j].getValue());
            }

            if (crit == null)
                crit = criteria;
            else
                crit.addOrCriteria(criteria);
        }
        return crit;
    }
    catch (PersistenceBrokerException e)
    {
        log.error(e);
        return null;
    }
}
 

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)
 */
@Override @Deprecated
public Collection<PurchaseOrderAccount> findPreTaggablePOAccounts(BatchParameters batchParameters) {
    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);

    List<String> docNumbersAwaitingPurchaseOrderStatus = new ArrayList<String>();
    Collection<PurchaseOrderAccount> purchaseOrderAcctsAwaitingPOOpenStatus = new ArrayList<PurchaseOrderAccount>();
    for (PurchaseOrderAccount purchaseOrderAccount : purchaseOrderAccounts) {
        if (docNumbersAwaitingPurchaseOrderStatus.contains(purchaseOrderAccount.getDocumentNumber())) {
            purchaseOrderAcctsAwaitingPOOpenStatus.add(purchaseOrderAccount);
        }
    }
    return purchaseOrderAcctsAwaitingPOOpenStatus;
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
public final void orExpr(
	Criteria criteria
) throws RecognitionException, TokenStreamException {
	
	
	try {      // for error handling
		andExpr(criteria);
		{
		_loop97:
		do {
			if ((LA(1)==LITERAL_or) && (_tokenSet_8.member(LA(2))) && (_tokenSet_9.member(LA(3)))) {
				match(LITERAL_or);
				Criteria orCriteria = new Criteria();
				andExpr(orCriteria);
				criteria.addOrCriteria(orCriteria);
			}
			else {
				break _loop97;
			}
			
		} while (true);
		}
	}
	catch (RecognitionException ex) {
		reportError(ex);
		recover(ex,_tokenSet_7);
	}
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * Build the prefetch criteria
 *
 * @param ids Collection of identities of M side
 * @param fkCols indirection table fks to this class
 * @param itemFkCols indirection table fks to item class
 * @param itemPkFields
 * @return the Criteria
 */
private Criteria buildPrefetchCriteriaMultipleKeys(Collection ids, String[] fkCols, String[] itemFkCols,
        FieldDescriptor[] itemPkFields)
{
    Criteria crit = new Criteria();
    Criteria critValue = new Criteria();
    Iterator iter = ids.iterator();

    for (int i = 0; i < itemPkFields.length; i++)
    {
        crit.addEqualToField(itemPkFields[i].getAttributeName(), itemFkCols[i]);
    }
    
    while (iter.hasNext())
    {
        Criteria c = new Criteria();
        Identity id = (Identity) iter.next();
        Object[] val = id.getPrimaryKeyValues();

        for (int i = 0; i < val.length; i++)
        {

            if (val[i] == null)
            {
                c.addIsNull(fkCols[i]);
            }
            else
            {
                c.addEqualTo(fkCols[i], val[i]);
            }

        }
      
        critValue.addOrCriteria(c);
    }

    crit.addAndCriteria(critValue);
    return crit;
}