Java Criteria.addNotEqualTo方法代码示例

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;
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.rice.krad.dao.MaintenanceDocumentDao#getLockingDocumentNumber(java.lang.String, java.lang.String)
 */
public String getLockingDocumentNumber(String lockingRepresentation, String documentNumber) {

    String lockingDocNumber = "";

    // build the query criteria
    Criteria criteria = new Criteria();
    criteria.addEqualTo("lockingRepresentation", lockingRepresentation);

    // if a docHeaderId is specified, then it will be excluded from the
    // locking representation test.
    if (StringUtils.isNotBlank(documentNumber)) {
        criteria.addNotEqualTo(KRADPropertyConstants.DOCUMENT_NUMBER, documentNumber);
    }

    // attempt to retrieve a document based off this criteria
    MaintenanceLock maintenanceLock = (MaintenanceLock) getPersistenceBrokerTemplate().getObjectByQuery(QueryFactory.newQuery(MaintenanceLock.class, criteria));

    // if a document was found, then there's already one out there pending, and
    // we consider it 'locked' and we return the docnumber.
    if (maintenanceLock != null) {
        lockingDocNumber = maintenanceLock.getDocumentNumber();
    }
    return lockingDocNumber;
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.ole.coa.dataaccess.AccountDelegateDao#getLockingDocumentNumber(java.lang.String, java.lang.String)
 */

public String getLockingDocumentNumber(String lockingRepresentation, String documentNumber) {
    String lockingDocNumber = "";

    // build the query criteria
    Criteria criteria = new Criteria();
    criteria.addEqualTo("lockingRepresentation", lockingRepresentation);

    // if a docHeaderId is specified, then it will be excluded from the
    // locking representation test.
    if (StringUtils.isNotBlank(documentNumber)) {
        criteria.addNotEqualTo(KRADPropertyConstants.DOCUMENT_NUMBER, documentNumber);
    }

    // attempt to retrieve a document based off this criteria
    MaintenanceLock maintenanceLock = (MaintenanceLock) getPersistenceBrokerTemplate().getObjectByQuery(QueryFactory.newQuery(MaintenanceLock.class, criteria));

    // if a document was found, then there's already one out there pending, and
    // we consider it 'locked' and we return the docnumber.
    if (maintenanceLock != null) {
        lockingDocNumber = maintenanceLock.getDocumentNumber();
    }
    return lockingDocNumber;
}
 

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(KFSPropertyConstants.FINANCIAL_DOCUMENT_APPROVED_CODE, KFSConstants.PENDING_ENTRY_APPROVED_STATUS_CODE.PROCESSED);
    }
    else {
        Criteria subCriteria1 = new Criteria();
        subCriteria1.addNotEqualTo(KFSPropertyConstants.FINANCIAL_DOCUMENT_APPROVED_CODE, KFSConstants.PENDING_ENTRY_APPROVED_STATUS_CODE.PROCESSED);

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

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

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 <AccrualCategoryBo> getInActiveLeaveAccrualCategoriesForLeavePlan(String leavePlan, LocalDate asOfDate) {
	Criteria root = new Criteria();
	root.addEqualTo("leavePlan", leavePlan);
	root.addNotEqualTo("accrualEarnInterval", "N");
	root.addLessOrEqualThan("effectiveDate", asOfDate.toDate());
	root.addEqualTo("active", false);
	Query query = QueryFactory.newQuery(AccrualCategoryBo.class, root);
	Collection c = this.getPersistenceBrokerTemplate().getCollectionByQuery(query);
	List<AccrualCategoryBo> accrualCategories = new ArrayList<AccrualCategoryBo>();

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

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.kfs.module.ld.dataaccess.LaborLedgerPendingEntryDao#hasPendingLaborLedgerEntry(java.util.Map,
 *      java.lang.Object)
 */
public Collection<LaborLedgerPendingEntry> hasPendingLaborLedgerEntry(Map fieldValues, Object businessObject) {
    LOG.debug("hasPendingLaborLedgerEntry() started");

    Criteria criteria = new Criteria();
    for (Iterator iter = fieldValues.keySet().iterator(); iter.hasNext();) {
        String element = (String) iter.next();
        if (element.equals("documentNumber")) {
            criteria.addNotEqualTo(element, fieldValues.get(element));
        }
        else {
            criteria.addEqualTo(element, fieldValues.get(element));
        }
    }

    QueryByCriteria qbc = QueryFactory.newQuery(getEntryClass(), criteria);

    return getPersistenceBrokerTemplate().getCollectionByQuery(qbc);
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * this method makes sure all accounting periods inn the target fiscal year are open
 * 
 * @param request fiscal year (or other fiscal period) which is the TARGET of the load
 */
protected void openAllAccountingPeriods(Integer requestYear) {
    Criteria criteriaID = new Criteria();
    criteriaID.addEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, requestYear);
    criteriaID.addNotEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_PERIOD_STATUS_CODE, "Y");
    QueryByCriteria queryID = new QueryByCriteria(AccountingPeriod.class, criteriaID);
    Iterator<AccountingPeriod> unopenPeriods = getPersistenceBrokerTemplate().getIteratorByQuery(queryID);
    int periodsOpened = 0;
    while (unopenPeriods.hasNext()) {
        AccountingPeriod periodToOpen = unopenPeriods.next();
        periodToOpen.setActive(true);
        getPersistenceBrokerTemplate().store(periodToOpen);
        periodsOpened = periodsOpened + 1;
    }
    LOG.warn(String.format("\n\naccounting periods for %d changed to open status: %d", requestYear, new Integer(periodsOpened)));
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.kfs.coa.dataaccess.AccountDelegateDao#getLockingDocumentNumber(java.lang.String, java.lang.String)
 */

public String getLockingDocumentNumber(String lockingRepresentation, String documentNumber) {
    String lockingDocNumber = "";

    // build the query criteria
    Criteria criteria = new Criteria();
    criteria.addEqualTo("lockingRepresentation", lockingRepresentation);

    // if a docHeaderId is specified, then it will be excluded from the
    // locking representation test.
    if (StringUtils.isNotBlank(documentNumber)) {
        criteria.addNotEqualTo(KRADPropertyConstants.DOCUMENT_NUMBER, documentNumber);
    }

    // attempt to retrieve a document based off this criteria
    MaintenanceLock maintenanceLock = (MaintenanceLock) getPersistenceBrokerTemplate().getObjectByQuery(QueryFactory.newQuery(MaintenanceLock.class, criteria));

    // if a document was found, then there's already one out there pending, and
    // we consider it 'locked' and we return the docnumber.
    if (maintenanceLock != null) {
        lockingDocNumber = maintenanceLock.getDocumentNumber();
    }
    return lockingDocNumber;
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/** adds a single valued predicate to a Criteria. */
private void addSingleValuePredicate(SingleValuedPredicate p, Criteria parent) {
    final Object value = getVal(p.getValue());
    final String pp = p.getPropertyPath();
    if (p instanceof EqualPredicate) {
        parent.addEqualTo(pp, value);
    } else if (p instanceof EqualIgnoreCasePredicate) {
        parent.addEqualTo(genUpperFunc(pp), ((String) value).toUpperCase());
    } else if (p instanceof GreaterThanOrEqualPredicate) {
        parent.addGreaterOrEqualThan(pp, value);
    } else if (p instanceof GreaterThanPredicate) {
        parent.addGreaterThan(pp, value);
    } else if (p instanceof LessThanOrEqualPredicate) {
        parent.addLessOrEqualThan(pp, value);
    } else if (p instanceof LessThanPredicate) {
        parent.addLessThan(pp, value);
    } else if (p instanceof LikePredicate) {
        //no need to convert * or ? since ojb handles the conversion/escaping
        parent.addLike(genUpperFunc(pp), ((String) value).toUpperCase());
    } else if (p instanceof NotEqualPredicate) {
        parent.addNotEqualTo(pp, value);
    } else if (p instanceof NotEqualIgnoreCasePredicate) {
        parent.addNotEqualTo(genUpperFunc(pp), ((String) value).toUpperCase());
    } else if (p instanceof NotLikePredicate) {
        parent.addNotLike(pp, value);
    } else {
        throw new UnsupportedPredicateException(p);
    }
}
 

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

    Collection codes = new ArrayList();
    codes.add(PdpConstants.PaymentChangeCodes.CANCEL_DISBURSEMENT);
    codes.add(PdpConstants.PaymentChangeCodes.CANCEL_REISSUE_DISBURSEMENT);
    codes.add(PdpConstants.PaymentChangeCodes.REISSUE_DISBURSEMENT);

    Criteria crit = new Criteria();
    crit.addIn(PdpPropertyConstants.PAYMENT_CHANGE_CODE, codes);
    crit.addIsNull(PdpPropertyConstants.PaymentGroupHistory.PMT_CANCEL_EXTRACT_DATE);

    Criteria o1 = new Criteria();
    o1.addNotEqualTo(PdpPropertyConstants.DISBURSEMENT_TYPE_CODE, PdpConstants.DisbursementTypeCodes.ACH);
    Criteria o1a = new Criteria();
    o1a.addIsNull(PdpPropertyConstants.DISBURSEMENT_TYPE_CODE);
    o1.addOrCriteria(o1a);

    Criteria o2 = new Criteria();
    o2.addEqualTo(PdpPropertyConstants.DISBURSEMENT_TYPE_CODE, PdpConstants.DisbursementTypeCodes.CHECK);
    Criteria o2a = new Criteria();
    o2a.addEqualTo(PdpPropertyConstants.PAYMENT_GROUP + "." + PdpPropertyConstants.DISBURSEMENT_TYPE_CODE, PdpConstants.DisbursementTypeCodes.CHECK);
    o2.addOrCriteria(o2a);

    crit.addAndCriteria(o1);
    crit.addAndCriteria(o2);

    return getPersistenceBrokerTemplate().getIteratorByQuery(new QueryByCriteria(PaymentGroupHistory.class, crit));
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.kfs.module.ec.dataaccess.EffortCertificationReportDefinitionDao#getOverlappingReportDefinitions(org.kuali.kfs.module.ec.businessobject.EffortCertificationReportDefinition)
 */
public List<EffortCertificationReportDefinition> getAllOtherActiveByType(EffortCertificationReportDefinition effortCertificationReportDefinition) {
    Criteria criteria = new Criteria();
    criteria.addEqualTo(EffortPropertyConstants.EFFORT_CERTIFICATION_REPORT_TYPE_CODE, effortCertificationReportDefinition.getEffortCertificationReportTypeCode());
    criteria.addEqualTo(KFSPropertyConstants.ACTIVE, true);
    
    Criteria subCriteria = new Criteria();
    Criteria subCriteriaReportNumber = new Criteria();
    
    subCriteria.addNotEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, effortCertificationReportDefinition.getUniversityFiscalYear());
    subCriteriaReportNumber.addNotEqualTo(EffortPropertyConstants.EFFORT_CERTIFICATION_REPORT_NUMBER, effortCertificationReportDefinition.getEffortCertificationReportNumber());
    
    subCriteria.addOrCriteria(subCriteriaReportNumber);
    criteria.addAndCriteria(subCriteria);
    
    Collection col = getPersistenceBrokerTemplate().getCollectionByQuery(QueryFactory.newQuery(EffortCertificationReportDefinition.class, criteria));

    Iterator i = col.iterator();
    List<EffortCertificationReportDefinition> overlappingReportDefinitions = new ArrayList();

    while (i.hasNext()) {
        EffortCertificationReportDefinition temp = (EffortCertificationReportDefinition) i.next();
        overlappingReportDefinitions.add(temp);
    }

    return overlappingReportDefinitions;
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.ole.module.purap.document.dataaccess.PaymentRequestDao#getEligibleForAutoApproval()
 */
public List<String> getEligibleForAutoApproval() {

    Criteria criteria = new Criteria();
    criteria.addNotEqualTo("holdIndicator", "Y");
    criteria.addNotEqualTo("paymentRequestedCancelIndicator", "Y");

    List<String> returnList = getDocumentNumbersOfPaymentRequestByCriteria(criteria, false);

    return returnList;
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
public List<String> getPaymentRequestInReceivingStatus() {
    Criteria criteria = new Criteria();
    criteria.addNotEqualTo("holdIndicator", "Y");
    criteria.addNotEqualTo("paymentRequestedCancelIndicator", "Y");

    List<String> returnList = new ArrayList<String>();
    returnList = getDocumentNumbersOfPaymentRequestByCriteria(criteria, false);

    return returnList;

}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
public List<String> getInvoiceInReceivingStatus() {
    Criteria criteria = new Criteria();
    criteria.addNotEqualTo("holdIndicator", "Y");
    criteria.addNotEqualTo("invoiceCancelIndicator", "Y");

    List<String> returnList = new ArrayList<String>();
    returnList = getDocumentNumbersOfInvoiceByCriteria(criteria, false);

    return returnList;

}