Java Criteria.addAndCriteria方法代码示例

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包/类
protected void setUpCSFOverrideKeys(Integer BaseYear) {
    //  these are rows in CSF Override--they should take precedence over what is in CSF
    //  the idea is this:
    //  (1) we build BCSF from CSF Override first.  so, when we read CSF, we will not create a new BCSF entry if the override already has created one.
    //  (2) the override will create an entry with the same key as CSF unless (a) the override has a deleted row or (b) the override has a vacant row so that the EMPLID is changed to the vacant EMPLID in BCSF.
    //   So, we create a list of override keys possibly missing in BCSF which can be used to eliminate CSF candidates for BCSF.    
    Criteria criteriaID = new Criteria();
    criteriaID.addEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, BaseYear);
    criteriaID.addEqualTo(KFSPropertyConstants.ACTIVE, true);
    Criteria deleteCriteria = new Criteria();
    deleteCriteria.addNotEqualTo(KFSPropertyConstants.CSF_DELETE_CODE, BCConstants.ACTIVE_CSF_DELETE_CODE);
    Criteria vacantCriteria = new Criteria();
    vacantCriteria.addEqualTo(KFSPropertyConstants.CSF_FUNDING_STATUS_CODE, BCConstants.csfFundingStatusFlag.VACANT.getFlagValue());
    deleteCriteria.addOrCriteria(vacantCriteria);
    criteriaID.addAndCriteria(deleteCriteria);
    csfOverrideKeys = new HashSet<String>(hashObjectSize(CalculatedSalaryFoundationTrackerOverride.class, criteriaID));
    // now we want to build the hash set
    QueryByCriteria qry = new QueryByCriteria(CalculatedSalaryFoundationTrackerOverride.class, criteriaID);
    Iterator<CalculatedSalaryFoundationTrackerOverride> csfOvrd = getPersistenceBrokerTemplate().getIteratorByQuery(qry);
    while (csfOvrd.hasNext()) {
        CalculatedSalaryFoundationTrackerOverride csfOvrdRow = csfOvrd.next();
        csfOverrideKeys.add(buildCSFKey(csfOvrdRow));
        CSFOverrideDeletesRead = CSFOverrideDeletesRead + ((csfOvrdRow.getCsfDeleteCode().equals(BCConstants.ACTIVE_CSF_DELETE_CODE)? 0 : 1));
    }
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
@Override
public List<WorkAreaBo> getWorkAreas(List<Long> workAreas, LocalDate asOfDate) {
    Criteria root = new Criteria();

    root.addIn("workArea", workAreas);
    root.addEqualTo("effectiveDate", OjbSubQueryUtil.getEffectiveDateSubQuery(WorkAreaBo.class, asOfDate, WorkAreaBo.BUSINESS_KEYS, false));
    root.addEqualTo("timestamp", OjbSubQueryUtil.getTimestampSubQuery(WorkAreaBo.class, WorkAreaBo.BUSINESS_KEYS, false));

    Criteria activeFilter = new Criteria(); // Inner Join For Activity
    activeFilter.addEqualTo("active", true);
    root.addAndCriteria(activeFilter);

    Query query = QueryFactory.newQuery(WorkAreaBo.class, root);
    Collection c = this.getPersistenceBrokerTemplate().getCollectionByQuery(query);
    List<WorkAreaBo> wal = new ArrayList<WorkAreaBo>(c.size());
    wal.addAll(c);
    return wal;
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * add the status code into the given criteria. The status code can be categorized into approved and all.
 *
 * @param criteria the given criteria
 * @param isApproved the flag that indictates if only approved status code can be added into the given searach criteria
 */
protected void addStatusCode(Criteria criteria, boolean isOnlyApproved) {
    // add criteria for the approved pending entries
    if (isOnlyApproved) {
        criteria.addIn("documentHeader.financialDocumentStatusCode", this.buildApprovalCodeList());
        criteria.addNotEqualTo(OLEPropertyConstants.FINANCIAL_DOCUMENT_APPROVED_CODE, OLEConstants.PENDING_ENTRY_APPROVED_STATUS_CODE.PROCESSED);
    }
    else {
        Criteria subCriteria1 = new Criteria();
        subCriteria1.addNotEqualTo(OLEPropertyConstants.FINANCIAL_DOCUMENT_APPROVED_CODE, OLEConstants.PENDING_ENTRY_APPROVED_STATUS_CODE.PROCESSED);

        Criteria subCriteria2 = new Criteria();
        subCriteria2.addIsNull(OLEPropertyConstants.FINANCIAL_DOCUMENT_APPROVED_CODE);

        subCriteria1.addOrCriteria(subCriteria2);
        criteria.addAndCriteria(subCriteria1);
    }
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * test Null Criteria
 */
public void testNullCriteria()
{
    String name = "testNullCriteria_" + System.currentTimeMillis();
    Person p = new Person();
    p.setLastname(name);
    broker.beginTransaction();
    broker.store(p);
    broker.commitTransaction();

    Criteria crit = new Criteria();
    crit.addIsNull("firstname");
    Criteria crit2 = new Criteria();
    crit2.addLike("lastname", name);
    crit.addAndCriteria(crit2);
    
    Query q = QueryFactory.newQuery(Person.class, crit);

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

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.kfs.module.tem.dataaccess.TravelDocumentDao#findPerDiem(int, java.sql.Date, java.sql.Date)
 */
@Override
   public List<PerDiem> findEffectivePerDiems(int primaryDestinationId, java.sql.Date effectiveDate){
    Criteria criteria = new Criteria();
    criteria.addEqualTo(TemPropertyConstants.PRIMARY_DESTINATION_ID, new Integer(primaryDestinationId));

    //Add date criteria so the date falls in a specific range
    //or their is no "To" date.  (Open-ended)
       Criteria dateBetweenCriteria = new Criteria();
       Criteria dateNullCriteria = new Criteria();

       dateBetweenCriteria.addGreaterOrEqualThan(TemPropertyConstants.PER_DIEM_EFFECTIVE_TO_DATE, effectiveDate);
       dateBetweenCriteria.addLessOrEqualThan(TemPropertyConstants.PER_DIEM_EFFECTIVE_FROM_DATE, effectiveDate);

       dateNullCriteria.addIsNull(TemPropertyConstants.PER_DIEM_EFFECTIVE_TO_DATE);

       dateBetweenCriteria.addOrCriteria(dateNullCriteria);
       criteria.addAndCriteria(dateBetweenCriteria);
    QueryByCriteria query = QueryFactory.newQuery(PerDiem.class, criteria);

    List<PerDiem> possiblePerDiems = new ArrayList<PerDiem>();
    possiblePerDiems.addAll(getPersistenceBrokerTemplate().getCollectionByQuery(query));
    return possiblePerDiems;
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.kfs.pdp.dataaccess.PaymentDetailDao#getUnprocessedCancelledDetails(java.util.List)
 */
@Override
public Iterator getUnprocessedCancelledDetails(List<ExtractionUnit> extractionUnits) {
    LOG.debug("getUnprocessedCancelledDetails() started");

    Collection codes = new ArrayList();
    codes.add(PdpConstants.PaymentStatusCodes.CANCEL_DISBURSEMENT);
    codes.add(PdpConstants.PaymentStatusCodes.CANCEL_PAYMENT);

    Criteria subUnitsCriteria = buildExtractionUnitsCriteria(extractionUnits);

    Criteria criteria = new Criteria();
    criteria.addIn(PdpPropertyConstants.PaymentDetail.PAYMENT_STATUS_CODE, codes);
    criteria.addIsNull(PdpPropertyConstants.PaymentDetail.PAYMENT_EPIC_PAYMENT_CANCELLED_DATE);
    criteria.addAndCriteria(subUnitsCriteria);

    return getPersistenceBrokerTemplate().getIteratorByQuery(new QueryByCriteria(PaymentDetail.class, criteria));
}
 

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包/类
/**
 * @see org.kuali.rice.krad.dao.BusinessObjectDao#findMatchingActive(java.lang.Class, java.util.Map)
 */
public <T extends BusinessObject> Collection<T> findMatchingActive(Class<T> clazz, Map<String, ?> fieldValues) {
    Criteria criteria = buildCriteria(fieldValues);
    criteria.addAndCriteria(buildActiveCriteria());

    return (Collection<T>)getPersistenceBrokerTemplate().getCollectionByQuery(QueryFactory.newQuery(clazz, criteria));
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * 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, java.util.Map)
 */
public int countMatching(Class clazz, Map<String, ?> positiveFieldValues, Map<String, ?> negativeFieldValues) {
    Criteria criteria = buildCriteria(positiveFieldValues);
    Criteria negativeCriteria = buildNegativeCriteria(negativeFieldValues);
    criteria.addAndCriteria(negativeCriteria);
    return getPersistenceBrokerTemplate().getCount(QueryFactory.newQuery(clazz, criteria));
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * calculate part of the actual total
 * 
 * @param universityFiscalYear the university fiscal year of sufficient funds balances to summarize
 * @param chartOfAccountsCode the chart of accounts code of sufficient funds balances to summarize
 * @param accountNumber the account number of sufficient fund balances to summarize
 * @return thsi part of the actual total
 */
protected KualiDecimal calculateM113PendActual1(boolean financialBeginBalanceLoadInd, Integer universityFiscalYear, String chartOfAccountsCode, String accountNumber, boolean isEqualDebitCode, String financialObjectCodeForCashInBank) {
    Criteria criteria = new Criteria();
    criteria.addEqualTo(OLEConstants.FINANCIAL_BALANCE_TYPE_CODE_PROPERTY_NAME, OLEConstants.BALANCE_TYPE_ACTUAL);

    if (financialBeginBalanceLoadInd) {
        criteria.addEqualTo(OLEConstants.UNIVERSITY_FISCAL_YEAR_PROPERTY_NAME, universityFiscalYear);
    }
    else {
        Criteria sub1 = new Criteria();
        sub1.addEqualTo(OLEConstants.UNIVERSITY_FISCAL_YEAR_PROPERTY_NAME, universityFiscalYear);
        Criteria sub1_1 = new Criteria();
        sub1_1.addEqualTo(OLEConstants.UNIVERSITY_FISCAL_YEAR_PROPERTY_NAME, new Integer(universityFiscalYear.intValue() - 1));
        sub1.addOrCriteria(sub1_1);
        criteria.addAndCriteria(sub1);
    }

    criteria.addEqualTo(OLEConstants.CHART_OF_ACCOUNTS_CODE_PROPERTY_NAME, chartOfAccountsCode);
    criteria.addEqualTo(OLEConstants.ACCOUNT_NUMBER_PROPERTY_NAME, accountNumber);
    criteria.addEqualTo(OLEConstants.FINANCIAL_OBJECT_CODE_PROPERTY_NAME, financialObjectCodeForCashInBank);

    if (isEqualDebitCode) {
        criteria.addEqualTo(OLEConstants.TRANSACTION_DEBIT_CREDIT_CODE, OLEConstants.GL_DEBIT_CODE);
    }
    else {
        criteria.addNotEqualTo(OLEConstants.TRANSACTION_DEBIT_CREDIT_CODE, OLEConstants.GL_DEBIT_CODE);
    }

    criteria.addNotEqualTo(OLEConstants.DOCUMENT_HEADER_PROPERTY_NAME + "." + OLEConstants.DOCUMENT_HEADER_DOCUMENT_STATUS_CODE_PROPERTY_NAME, OLEConstants.DocumentStatusCodes.CANCELLED);

    ReportQueryByCriteria reportQuery = QueryFactory.newReportQuery(GeneralLedgerPendingEntry.class, criteria);
    reportQuery.setAttributes(new String[] { "sum(" + OLEConstants.TRANSACTION_LEDGER_ENTRY_AMOUNT + ")" });

    return executeReportQuery(reportQuery);
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.kfs.module.ar.dataaccess.CostCategoryDao#getBalancesForCostCategory(java.lang.Integer, java.lang.String, java.lang.String, java.lang.String, java.lang.String, org.kuali.kfs.module.ar.businessobject.CostCategory)
 */
@Override
public List<Balance> getBalancesForCostCategory(Integer fiscalYear, String chartOfAccountsCode, String accountNumber, String balanceType, Collection<String> objectTypeCodes, CostCategory costCategory) {
    if (!costCategory.isActive()) {
        return new ArrayList<Balance>(); // cost category isn't active?  then dont' find any matching balances
    }

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

    crit.addIn(KFSPropertyConstants.OBJECT_TYPE_CODE, objectTypeCodes);

    Criteria objectCodesCollectiveCriteria = new Criteria();

    Criteria objectCodeCriteria = new Criteria();
    objectCodeCriteria.addIn(KFSPropertyConstants.OBJECT_CODE, buildObjectCodesOfCostCategorySubQuery(costCategory, chartOfAccountsCode));
    objectCodesCollectiveCriteria.addOrCriteria(objectCodeCriteria);

    Criteria objectLevelCriteria = new Criteria();
    objectLevelCriteria.addIn(KFSPropertyConstants.FINANCIAL_OBJECT+"."+KFSPropertyConstants.FINANCIAL_OBJECT_LEVEL_CODE,buildObjectLevelsOfCostCategorySubQuery(costCategory, chartOfAccountsCode));
    objectCodesCollectiveCriteria.addOrCriteria(objectLevelCriteria);

    Criteria consolidationCriteria = new Criteria();
    consolidationCriteria.addIn(KFSPropertyConstants.FINANCIAL_OBJECT+"."+KFSPropertyConstants.FINANCIAL_OBJECT_LEVEL+"."+KFSPropertyConstants.FINANCIAL_CONSOLIDATION_OBJECT_CODE, buildObjectConsolidationsOfCostCategorySubQuery(costCategory, chartOfAccountsCode));
    objectCodesCollectiveCriteria.addOrCriteria(consolidationCriteria);

    crit.addAndCriteria(objectCodesCollectiveCriteria);
    Query q = new QueryByCriteria(Balance.class, crit);
    return (List<Balance>)getPersistenceBrokerTemplate().getCollectionByQuery(q);
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.kfs.module.purap.document.dataaccess.PaymentRequestDao#getPaymentRequestsToExtract(java.lang.String,
 *      java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.Integer)
 */
@Override
@Deprecated
public List<PaymentRequestDocument> getPaymentRequestsToExtract(String campusCode, Integer paymentRequestIdentifier, Integer purchaseOrderIdentifier, Integer vendorHeaderGeneratedIdentifier, Integer vendorDetailAssignedIdentifier, Date currentSqlDateMidnight) {
    LOG.debug("getPaymentRequestsToExtract() 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("paymentRequestPayDate", currentSqlDateMidnight);

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

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

    if (paymentRequestIdentifier != null) {
        criteria.addEqualTo("purapDocumentIdentifier", paymentRequestIdentifier);
    }
    if (purchaseOrderIdentifier != null) {
        criteria.addEqualTo("purchaseOrderIdentifier", purchaseOrderIdentifier);
    }
    criteria.addEqualTo("vendorHeaderGeneratedIdentifier", vendorHeaderGeneratedIdentifier);
    criteria.addEqualTo("vendorDetailAssignedIdentifier", vendorDetailAssignedIdentifier);

    return (List<PaymentRequestDocument>) getPersistenceBrokerTemplate().getIteratorByQuery(new QueryByCriteria(PaymentRequestDocument.class, criteria));
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * This method builds the query criteria based on the input field map
 * 
 * @param fieldValues
 * @param balance
 * @param encumbranceBalanceTypes
 * @param noZeroAmounts makes sure at least one of the 13 monthly buckets has an amount not equals to zero
 * @return a query criteria
 */
protected Criteria buildCriteriaFromMap(Map fieldValues, LedgerBalance balance, List<String> encumbranceBalanceTypes, boolean noZeroAmounts) {
    Map localFieldValues = new HashMap();
    localFieldValues.putAll(fieldValues);

    Criteria criteria = new Criteria();

    // handle encumbrance balance type
    String propertyName = KFSPropertyConstants.FINANCIAL_BALANCE_TYPE_CODE;
    if (localFieldValues.containsKey(propertyName)) {
        String propertyValue = (String) localFieldValues.get(propertyName);
        if (KFSConstants.AGGREGATE_ENCUMBRANCE_BALANCE_TYPE_CODE.equals(propertyValue)) {
            localFieldValues.remove(KFSPropertyConstants.FINANCIAL_BALANCE_TYPE_CODE);

            criteria.addIn(KFSPropertyConstants.FINANCIAL_BALANCE_TYPE_CODE, encumbranceBalanceTypes);
        }
    }

    criteria.addAndCriteria(OJBUtility.buildCriteriaFromMap(localFieldValues, new LedgerBalance()));
    if (noZeroAmounts) {
        Criteria noZeroAmountsCriteria = new Criteria();
        noZeroAmountsCriteria.addEqualTo(KFSPropertyConstants.MONTH1_AMOUNT, 0);
        noZeroAmountsCriteria.addEqualTo(KFSPropertyConstants.MONTH2_AMOUNT, 0);
        noZeroAmountsCriteria.addEqualTo(KFSPropertyConstants.MONTH3_AMOUNT, 0);
        noZeroAmountsCriteria.addEqualTo(KFSPropertyConstants.MONTH4_AMOUNT, 0);
        noZeroAmountsCriteria.addEqualTo(KFSPropertyConstants.MONTH5_AMOUNT, 0);
        noZeroAmountsCriteria.addEqualTo(KFSPropertyConstants.MONTH6_AMOUNT, 0);
        noZeroAmountsCriteria.addEqualTo(KFSPropertyConstants.MONTH7_AMOUNT, 0);
        noZeroAmountsCriteria.addEqualTo(KFSPropertyConstants.MONTH8_AMOUNT, 0);
        noZeroAmountsCriteria.addEqualTo(KFSPropertyConstants.MONTH9_AMOUNT, 0);
        noZeroAmountsCriteria.addEqualTo(KFSPropertyConstants.MONTH10_AMOUNT, 0);
        noZeroAmountsCriteria.addEqualTo(KFSPropertyConstants.MONTH11_AMOUNT, 0);
        noZeroAmountsCriteria.addEqualTo(KFSPropertyConstants.MONTH12_AMOUNT, 0);
        noZeroAmountsCriteria.addEqualTo(KFSPropertyConstants.MONTH13_AMOUNT, 0);
        noZeroAmountsCriteria.setNegative(true);
        criteria.addAndCriteria(noZeroAmountsCriteria);
    }
    return criteria;
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.ole.module.purap.document.dataaccess.NegativeInvoiceApprovalLimitDao#findByChartAndAccount(String,
 *      String)
 */
public Collection<NegativeInvoiceApprovalLimit> findByChartAndAccount(String chartCode, String accountNumber) {
    LOG.debug("Entering findByChartAndAccount(String, String)");
    Criteria criteria = new Criteria();
    criteria.addEqualTo(OLEPropertyConstants.CHART_OF_ACCOUNTS_CODE, chartCode);
    criteria.addEqualTo(OLEPropertyConstants.ACCOUNT_NUMBER, accountNumber);
    criteria.addIsNull(OLEPropertyConstants.ORGANIZATION_CODE);
    criteria.addAndCriteria(buildActiveCriteria());
    Query query = new QueryByCriteria(NegativeInvoiceApprovalLimit.class, criteria);
    LOG.debug("Leaving findByChartAndAccount(String, String)");

    return getPersistenceBrokerTemplate().getCollectionByQuery(query);
}