Java Criteria.addIn方法代码示例

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * Retrieve a List of Document instances with the given ids
 *
 * @param clazz
 * @param idList
 * @return List
 */
@Override
public <T extends Document> List<T> findByDocumentHeaderIds(Class<T> clazz, List<String> idList) {
    Criteria criteria = new Criteria();
    criteria.addIn(KRADPropertyConstants.DOCUMENT_NUMBER, idList);

    QueryByCriteria query = QueryFactory.newQuery(clazz, criteria);
    
    // this cast is correct because OJB produces a collection which contains elements of the class defined on the query
    @SuppressWarnings("unchecked")
    List<T> tempList = new ArrayList<T>(this.getPersistenceBrokerTemplate().getCollectionByQuery(query));
    
    for (T doc : tempList) {
    	documentAdHocService.addAdHocs(doc);
    }
    return tempList;
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * This method will build out criteria in the key-value paradigm (attribute-value).
 *
 * @param fieldValues
 * @return
 */
private Criteria buildCriteria(Map<String, ?> fieldValues) {
    Criteria criteria = new Criteria();
    for (Iterator i = fieldValues.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.addIn(key, (Collection) value);
        } else {
            criteria.addEqualTo(key, value);
        }
    }

    return criteria;
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
@Override
@SuppressWarnings("rawtypes")
   public List<String> getUniquePayCalendars(List<String> principalIds) {
       List<String> payCalendars = new ArrayList<String>();
       
       Criteria root = new Criteria();
       root.addIn("principalId", principalIds);
       root.addEqualTo("active", true);
       
       ReportQueryByCriteria query = QueryFactory.newReportQuery(PrincipalHRAttributesBo.class, root, true);
       query.setDistinct(true);
       query.setAttributes(new String[] {"payCalendar"});
       Iterator iterator = getPersistenceBrokerTemplate().getReportQueryIteratorByQuery(query);
       while (iterator.hasNext()) {
           Object[] values = (Object[]) iterator.next();
           String leaveCalendar = (String) values[0];
           if (StringUtils.isNotBlank(leaveCalendar)) {
           	payCalendars.add(leaveCalendar);
           }
       }
       
       return payCalendars;
   }
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.ole.pdp.dataaccess.PaymentDetailDao#getUnprocessedCancelledDetails(java.lang.String, java.lang.String)
 */
public Iterator getUnprocessedCancelledDetails(String organization, List<String> subUnits) {
    LOG.debug("getUnprocessedCancelledDetails() started");

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

    Criteria criteria = new Criteria();
    criteria.addIn(PdpPropertyConstants.PaymentDetail.PAYMENT_SUBUNIT_CODE, subUnits);
    criteria.addEqualTo(PdpPropertyConstants.PaymentDetail.PAYMENT_UNIT_CODE, organization);
    criteria.addIn(PdpPropertyConstants.PaymentDetail.PAYMENT_STATUS_CODE, codes);
    criteria.addIsNull(PdpPropertyConstants.PaymentDetail.PAYMENT_EPIC_PAYMENT_CANCELLED_DATE);

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

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
public List<EdoCandidateDossier> getCurrentCandidateDossierList () {

        List<EdoCandidateDossier> dossierLists = new LinkedList<EdoCandidateDossier>();

        Criteria criteria = new Criteria();
        //added RECONSIDER and CLOSED to DOSSIER_STATUS_CURRENT structure
        //this accomodates super users and admins to see all the dossiers of the candidates.
        criteria.addIn("dossierStatus", EdoConstants.DOSSIER_STATUS_CURRENT);

        Query query = QueryFactory.newQuery(EdoCandidateDossier.class, criteria);
        Collection c = this.getPersistenceBrokerTemplate().getCollectionByQuery(query);

        if (c != null && c.size() != 0) {
            dossierLists.addAll(c);
        }
        return dossierLists;
    }
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
public List<EdoVoteRecordBo> getVoteRecords(String edoDossierID, List<String> edoReviewLayerDefinitionIDs) {
    List<EdoVoteRecordBo> voteRecords = new ArrayList<EdoVoteRecordBo>();

    if (ObjectUtils.isNotNull(edoDossierID) && CollectionUtils.isNotEmpty(edoReviewLayerDefinitionIDs)) {
        Criteria criteria = new Criteria();
        criteria.addEqualTo("edoDossierId", edoDossierID);
        criteria.addIn("edoReviewLayerDefinitionId", edoReviewLayerDefinitionIDs);

        QueryByCriteria query = QueryFactory.newQuery(EdoVoteRecordBo.class, criteria);
        // TODO: add sorting after reviewLayerDefinition is done
        //query.addOrderByAscending("reviewLayerDefinition.reviewLevel");
        query.addOrderByAscending("vote_round");
        query.addOrderByAscending("vote_subround");

        Collection c =  this.getPersistenceBrokerTemplate().getCollectionByQuery(query);
        
        if (c != null && c.size() != 0) {
        	voteRecords.addAll(c);
        }
        
        return voteRecords;
    }

    return voteRecords;
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * Adds fiscal year criteria based on the configuration (copy two years, lagging, or normal)
 * 
 * @param criteria OJB Criteria object
 * @param baseFiscalYear Fiscal year for critiera
 * @param createTwoYears indicates whether two years of fiscal year criteria should be added
 */
protected void addYearCriteria(Criteria criteria, Integer baseFiscalYear, boolean createTwoYears) {
    if (fiscalYearOneBehind) {
        baseFiscalYear = baseFiscalYear - 1;
    }
    else if (fiscalYearOneAhead) {
        baseFiscalYear = baseFiscalYear + 1;
    }

    if (createTwoYears) {
        List<Integer> copyYears = new ArrayList<Integer>();
        copyYears.add(baseFiscalYear);
        copyYears.add(baseFiscalYear + 1);

        criteria.addIn(OLEPropertyConstants.UNIVERSITY_FISCAL_YEAR, copyYears);
    }
    else {
        criteria.addEqualTo(OLEPropertyConstants.UNIVERSITY_FISCAL_YEAR, baseFiscalYear);
    }
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * Does a ReportQuery to summarize GL balance data
 * 
 * @param universityFiscalYear the fiscal year of balances to search for
 * @param balanceTypeCodes a list of balance type codes of balances to search for
 * @return iterator of reported on java.lang.Object arrays with the report data
 * @see org.kuali.ole.gl.dataaccess.BalanceDao#getGlSummary(int, java.util.List)
 */
public Iterator<Object[]> getGlSummary(int universityFiscalYear, Collection<String> balanceTypeCodes) {
    LOG.debug("getGlSummary() started");

    Criteria c = new Criteria();
    c.addEqualTo(OLEPropertyConstants.UNIVERSITY_FISCAL_YEAR, universityFiscalYear);
    c.addIn(OLEPropertyConstants.BALANCE_TYPE_CODE, balanceTypeCodes);

    String[] attributes = new String[] { "account.subFundGroup.fundGroupCode", "sum(accountLineAnnualBalanceAmount)", "sum(beginningBalanceLineAmount)", "sum(contractsGrantsBeginningBalanceAmount)", "sum(month1Amount)", "sum(month2Amount)", "sum(month3Amount)", "sum(month4Amount)", "sum(month5Amount)", "sum(month6Amount)", "sum(month7Amount)", "sum(month8Amount)", "sum(month9Amount)", "sum(month10Amount)", "sum(month11Amount)", "sum(month12Amount)", "sum(month13Amount)" };

    String[] groupby = new String[] { "account.subFundGroup.fundGroupCode" };

    ReportQueryByCriteria query = new ReportQueryByCriteria(Balance.class, c);

    query.setAttributes(attributes);
    query.addGroupBy(groupby);
    query.addOrderByAscending("account.subFundGroup.fundGroupCode");

    return getPersistenceBrokerTemplate().getReportQueryIteratorByQuery(query);
}
 

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

            }
        }
    }

}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * This method builds the query criteria based on the input field map
 *
 * @param fieldValues Map of keys to use for the query
 * @param balance this really usen't used in the method
 * @return a query criteria
 */
protected Criteria buildCriteriaFromMap(Map fieldValues, Balance balance, Collection<String> encumbranceBalanceTypes) {
    Map localFieldValues = new HashMap();
    localFieldValues.putAll(fieldValues);

    Criteria criteria = new Criteria();

    // handle encumbrance balance type
    String propertyName = KFSPropertyConstants.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.BALANCE_TYPE_CODE);

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

    criteria.addAndCriteria(OJBUtility.buildCriteriaFromMap(localFieldValues, balance));
    return criteria;
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.kfs.gl.dataaccess.BalanceDao#findNominalActivityBalancesForFiscalYear(java.lang.Integer, java.util.Collection, org.kuali.kfs.sys.businessobject.SystemOptions, java.util.List)
 */
@Override
public Iterator<Balance> findNominalActivityBalancesForFiscalYear(Integer year, Collection<String> nominalActivityObjectTypeCodes, SystemOptions currentYearOptions, List<String> charts) {
    LOG.debug("findNominalActivityBalancesForFiscalYear(year, charts) started");

    Criteria c = new Criteria();
    c.addEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, year);
    c.addEqualTo(KFSPropertyConstants.BALANCE_TYPE_CODE, currentYearOptions.getActualFinancialBalanceTypeCd());
    c.addIn(KFSPropertyConstants.OBJECT_TYPE_CODE, nominalActivityObjectTypeCodes);
    c.addIn(KFSPropertyConstants.CHART_OF_ACCOUNTS_CODE, charts);
    c.addNotEqualTo(KFSPropertyConstants.ACCOUNT_LINE_ANNUAL_BALANCE_AMOUNT, KualiDecimal.ZERO);

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

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * Adds fiscal year criteria based on the configuration (copy two years, lagging, or normal)
 *
 * @param criteria OJB Criteria object
 * @param baseFiscalYear Fiscal year for critiera
 * @param createTwoYears indicates whether two years of fiscal year criteria should be added
 */
protected void addYearCriteria(Criteria criteria, Integer baseFiscalYear, boolean createTwoYears) {
    if (fiscalYearOneBehind) {
        baseFiscalYear = baseFiscalYear - 1;
    }
    else if (fiscalYearOneAhead) {
        baseFiscalYear = baseFiscalYear + 1;
    }

    if (createTwoYears) {
        List<Integer> copyYears = new ArrayList<Integer>();
        copyYears.add(baseFiscalYear);
        copyYears.add(baseFiscalYear + 1);

        criteria.addIn(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, copyYears);
    }
    else {
        criteria.addEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, baseFiscalYear);
    }
}
 

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

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