本文整理汇总了Java中org.apache.ojb.broker.query.Criteria.addIn方法的典型用法代码示例。如果您正苦于以下问题:Java Criteria.addIn方法的具体用法?Java Criteria.addIn怎么用?Java Criteria.addIn使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类org.apache.ojb.broker.query.Criteria
的用法示例。
在下文中一共展示了Criteria.addIn方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: findByDocumentHeaderIds
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;
}
示例2: buildCriteria
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;
}
示例3: getUniquePayCalendars
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;
}
示例4: getUnprocessedCancelledDetails
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));
}
示例5: getCurrentCandidateDossierList
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;
}
示例6: getVoteRecords
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;
}
示例7: addYearCriteria
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);
}
}
示例8: getGlSummary
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);
}
示例9: 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);
}
}
}
}
示例10: buildCriteriaFromMap
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;
}
示例11: findNominalActivityBalancesForFiscalYear
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);
}
示例12: addYearCriteria
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);
}
}
示例13: getDocumentPBGLFringeLines
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;
}
示例14: 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;
}
示例15: 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);
}
}