Java Criteria.addEqualToField方法代码示例

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
@Override
public CalendarEntryBo getPreviousCalendarEntryByCalendarId(String hrCalendarId, CalendarEntryContract calendarEntry) {
    Criteria root = new Criteria();
    Criteria beginDate = new Criteria();
    Criteria endDate = new Criteria();

    beginDate.addEqualToField("hrCalendarId", Criteria.PARENT_QUERY_PREFIX + "hrCalendarId");
    beginDate.addLessThan("beginPeriodDateTime", calendarEntry.getBeginPeriodFullDateTime().toDate());
    ReportQueryByCriteria beginDateSubQuery = QueryFactory.newReportQuery(CalendarEntryBo.class, beginDate);
    beginDateSubQuery.setAttributes(new String[]{"max(beginPeriodDateTime)"});

    endDate.addEqualToField("hrCalendarId", Criteria.PARENT_QUERY_PREFIX + "hrCalendarId");
    endDate.addLessThan("endPeriodDateTime", calendarEntry.getEndPeriodFullDateTime().toDate());
    ReportQueryByCriteria endDateSubQuery = QueryFactory.newReportQuery(CalendarEntryBo.class, endDate);
    endDateSubQuery.setAttributes(new String[]{"max(endPeriodDateTime)"});

    root.addEqualTo("hrCalendarId", hrCalendarId);
    root.addEqualTo("beginPeriodDateTime", beginDateSubQuery);
    root.addEqualTo("endPeriodDateTime", endDateSubQuery);

    Query query = QueryFactory.newQuery(CalendarEntryBo.class, root);

    CalendarEntryBo pce = (CalendarEntryBo) this.getPersistenceBrokerTemplate().getObjectByQuery(query);
    return pce;
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
@Override
// KPME-1011
   public List<AccrualCategoryBo> getActiveAccrualCategories(LocalDate asOfDate) {
	List<AccrualCategoryBo> accrualCategories = new ArrayList<AccrualCategoryBo>();
	Criteria root = new Criteria();
	Criteria timestampSubCrit = new Criteria();
	
	timestampSubCrit.addEqualToField("accrualCategory", Criteria.PARENT_QUERY_PREFIX + "accrualCategory");
	ReportQueryByCriteria timestampSubQuery = QueryFactory.newReportQuery(AccrualCategoryBo.class, timestampSubCrit);
	timestampSubQuery.setAttributes(new String[]{ "max(timestamp)" });
	
	root.addLessOrEqualThan("effectiveDate", asOfDate.toDate());
	root.addEqualTo("timestamp", timestampSubQuery);
	root.addEqualTo("active",true);
	
	Query query = QueryFactory.newQuery(AccrualCategoryBo.class, root);
	
	Collection c = this.getPersistenceBrokerTemplate().getCollectionByQuery(query);
	
	if (c != null) {
		accrualCategories.addAll(c);
	}

	return accrualCategories;
   }
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
public static ReportQueryByCriteria getEffectiveDateSubQueryWithFilter(Class clazz, Criteria effectiveDateFilter, List<String> equalToField, boolean checkActive) {
    Criteria effdt = new Criteria();
    if (effectiveDateFilter != null) {
        effdt.addAndCriteria(effectiveDateFilter);
    }
    if (CollectionUtils.isNotEmpty(equalToField)) {
        for (String field : equalToField) {
            Criteria keyField = new Criteria();
            keyField.addEqualToField(field, Criteria.PARENT_QUERY_PREFIX+field);
            Criteria orNull = new Criteria();
            orNull.addIsNull(field);
            orNull.addIsNull(Criteria.PARENT_QUERY_PREFIX+field);
            keyField.addOrCriteria(orNull);
            effdt.addAndCriteria(keyField);
        }
    }
    if (checkActive) {
        effdt.addEqualTo("active", true);
    }
    ReportQueryByCriteria effdtSubQuery = QueryFactory.newReportQuery(clazz, effdt);
    effdtSubQuery.setAttributes(new String[]{"max(effdt)"});

    return effdtSubQuery;
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * test Subquery get all product groups with more than 10 articles, uses
 * attribute as value ! see testSubQuery4 for a better way
 * <p/>
 * test may fail if db does not support sub queries
 */
public void testSubQuery3()
{

    ReportQueryByCriteria subQuery;
    Criteria subCrit = new Criteria();
    Criteria crit = new Criteria();

    subCrit.addEqualToField("productGroupId", Criteria.PARENT_QUERY_PREFIX + "groupId");
    subQuery = QueryFactory.newReportQuery(Article.class, subCrit);
    subQuery.setAttributes(new String[]{"count(productGroupId)"});

    crit.addLessThan("10", subQuery); // MORE than 10 articles, uses
    // attribute as value !
    crit.addLessThan("groupId", PGROUP_ID_HI_WATERMARK);
    Query q = QueryFactory.newQuery(ProductGroup.class, crit);

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

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
@Override
public List<EarnCodeGroupBo> getEarnCodeGroupsForEarnCode(String earnCode, LocalDate asOfDate) {
	
	Criteria root = new Criteria();
	Criteria earnCodeJoin = new Criteria();

	earnCodeJoin.addEqualToField("hrEarnCodeGroupId", Criteria.PARENT_QUERY_PREFIX + "hrEarnCodeGroupId");
	earnCodeJoin.addEqualTo("UPPER(earnCode)", earnCode.toUpperCase());
	ReportQueryByCriteria earnCodeSubQuery = QueryFactory.newReportQuery(EarnCodeGroupDefinitionBo.class, earnCodeJoin);
	earnCodeSubQuery.setAttributes(new String[]{"hr_earn_code_group_id"});
	
	root.addEqualTo("hrEarnCodeGroupId",earnCodeSubQuery);
       root.addEqualTo("effectiveDate", OjbSubQueryUtil.getEffectiveDateSubQuery(EarnCodeGroupBo.class, asOfDate, EarnCodeGroupBo.BUSINESS_KEYS, false));
       root.addEqualTo("timestamp", OjbSubQueryUtil.getTimestampSubQuery(EarnCodeGroupBo.class, EarnCodeGroupBo.BUSINESS_KEYS, false));

	Criteria activeFilter = new Criteria(); // Inner Join For Activity
	activeFilter.addEqualTo("active", true);
	root.addAndCriteria(activeFilter);
	
	Query query = QueryFactory.newQuery(EarnCodeGroupBo.class, root);
      
    List<EarnCodeGroupBo> results = new ArrayList<EarnCodeGroupBo>();
    results.addAll(getPersistenceBrokerTemplate().getCollectionByQuery(query));
    
    return results;
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
@Override
	public EarnCodeGroupBo getEarnCodeGroupForEarnCode(String earnCode, LocalDate asOfDate) {
		Criteria root = new Criteria();
		Criteria earnCodeJoin = new Criteria();

		earnCodeJoin.addEqualToField("hrEarnCodeGroupId", Criteria.PARENT_QUERY_PREFIX + "hrEarnCodeGroupId");
		earnCodeJoin.addEqualTo("UPPER(earnCode)", earnCode.toUpperCase());
		ReportQueryByCriteria earnCodeSubQuery = QueryFactory.newReportQuery(EarnCodeGroupDefinitionBo.class, earnCodeJoin);
		earnCodeSubQuery.setAttributes(new String[]{"hr_earn_code_group_id"});
		
		root.addEqualTo("hrEarnCodeGroupId",earnCodeSubQuery);
        root.addEqualTo("effectiveDate", OjbSubQueryUtil.getEffectiveDateSubQuery(EarnCodeGroupBo.class, asOfDate, EarnCodeGroupBo.BUSINESS_KEYS, false));
        root.addEqualTo("timestamp", OjbSubQueryUtil.getTimestampSubQuery(EarnCodeGroupBo.class, EarnCodeGroupBo.BUSINESS_KEYS, false));
//		root.addEqualTo("active", true);

		Criteria activeFilter = new Criteria(); // Inner Join For Activity
		activeFilter.addEqualTo("active", true);
		root.addAndCriteria(activeFilter);
		
		Query query = QueryFactory.newQuery(EarnCodeGroupBo.class, root);
		EarnCodeGroupBo earnGroupObj  = (EarnCodeGroupBo)this.getPersistenceBrokerTemplate().getObjectByQuery(query);
		return earnGroupObj;
	}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
public ClockLogBo getLastClockLog(String principalId){
      Criteria currentRecordCriteria = new Criteria();
      currentRecordCriteria.addEqualTo("principalId", principalId);

      Criteria clockTimeJoinCriteria = new Criteria();
      clockTimeJoinCriteria.addEqualToField("principalId",Criteria.PARENT_QUERY_PREFIX +"principalId");

      ReportQueryByCriteria clockTimeSubQuery = QueryFactory.newReportQuery(ClockLogBo.class, clockTimeJoinCriteria);
      clockTimeSubQuery.setAttributes(new String[]{"max(clockTimestamp)"});

      currentRecordCriteria.addEqualTo("clockTimestamp", clockTimeSubQuery);

      Criteria timestampJoinCriteria = new Criteria();
      timestampJoinCriteria.addEqualToField("principalId", Criteria.PARENT_QUERY_PREFIX + "principalId");
      timestampJoinCriteria.addEqualToField("clockTimestamp", Criteria.PARENT_QUERY_PREFIX + "clockTimestamp");
	
ReportQueryByCriteria timeStampSubQuery = QueryFactory.newReportQuery(ClockLogBo.class, timestampJoinCriteria);
timeStampSubQuery.setAttributes(new String[]{"max(timestamp)"});
	
currentRecordCriteria.addEqualTo("timestamp", timeStampSubQuery);
	
return (ClockLogBo)this.getPersistenceBrokerTemplate().getObjectByQuery(QueryFactory.newQuery(ClockLogBo.class,currentRecordCriteria));
  }
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
public static ReportQueryByCriteria getTimestampSubQuery(Class clazz, List<String> equalToField, boolean checkActive) {
    Criteria timestamp = new Criteria();
    //need to check the effective date, always
    timestamp.addEqualToField("effectiveDate", Criteria.PARENT_QUERY_PREFIX + "effectiveDate");

    if (CollectionUtils.isNotEmpty(equalToField)) {
        for (String field : equalToField) {
            Criteria keyField = new Criteria();
            keyField.addEqualToField(field, Criteria.PARENT_QUERY_PREFIX+field);
            Criteria orNull = new Criteria();
            orNull.addIsNull(field);
            orNull.addIsNull(Criteria.PARENT_QUERY_PREFIX+field);
            keyField.addOrCriteria(orNull);
            timestamp.addAndCriteria(keyField);
        }
    }
    if (checkActive) {
        timestamp.addEqualTo("active", true);
    }
    ReportQueryByCriteria timestampSubQuery = QueryFactory.newReportQuery(clazz, timestamp);
    timestampSubQuery.setAttributes(new String[]{"max(timestamp)"});

    return timestampSubQuery;
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * Builds a query for cash balances, based on the given field values
 *
 * @param fieldValues a map of keys to use when building the query
 * @return an OJB ReportQuery to use as the query
 */
protected ReportQueryByCriteria getCashBalanceCountQuery(Map fieldValues, Collection<String> encumbranceBalanceTypes) {
    Criteria criteria = buildCriteriaFromMap(fieldValues, new CashBalance(), encumbranceBalanceTypes);
    criteria.addEqualTo(KFSPropertyConstants.BALANCE_TYPE_CODE, KFSConstants.BALANCE_TYPE_ACTUAL);
    criteria.addEqualToField("chart.financialCashObjectCode", KFSPropertyConstants.OBJECT_CODE);

    ReportQueryByCriteria query = QueryFactory.newReportQuery(CashBalance.class, criteria);

    List groupByList = buildGroupByList();
    groupByList.remove(KFSPropertyConstants.SUB_ACCOUNT_NUMBER);
    groupByList.remove(KFSPropertyConstants.SUB_OBJECT_CODE);
    groupByList.remove(KFSPropertyConstants.OBJECT_TYPE_CODE);

    // add the group criteria into the selection statement
    String[] groupBy = (String[]) groupByList.toArray(new String[groupByList.size()]);
    query.addGroupBy(groupBy);

    return query;
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.kfs.vnd.batch.dataaccess.DebarredVendorMatchDao.getDebarredVendorsUnmatched()
 */
@Override
public List<VendorDetail> getDebarredVendorsUnmatched() {

    Criteria subcr = new Criteria();
    subcr.addEqualToField("vendorHeaderGeneratedIdentifier", Criteria.PARENT_QUERY_PREFIX + "vendorHeaderGeneratedIdentifier");
    subcr.addEqualToField("vendorDetailAssignedIdentifier", Criteria.PARENT_QUERY_PREFIX + "vendorDetailAssignedIdentifier");
    Criteria orcr = new Criteria();
    orcr.addEqualTo("confirmStatusCode", "C");
    Criteria orcr2 = new Criteria();
    orcr2.addEqualTo("confirmStatusCode", "U");
    orcr.addOrCriteria(orcr2);
    subcr.addAndCriteria(orcr);
    QueryByCriteria subqr = QueryFactory.newQuery(DebarredVendorMatch.class, subcr);

    Criteria criteria = new Criteria();
    criteria.addEqualTo("vendorHeader.vendorDebarredIndicator", "Y");
    criteria.addNotExists(subqr);
    QueryByCriteria query = QueryFactory.newQuery(VendorDetail.class, criteria);
    List<VendorDetail> vendors = (List<VendorDetail>) getPersistenceBrokerTemplate().getCollectionByQuery(query);

    return vendors;
  }
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.kfs.module.bc.document.dataaccess.BudgetConstructionDao#getBcPullupChildOrgs(java.lang.String,
 *      java.lang.String, java.lang.String)
 */
public List<BudgetConstructionPullup> getBudgetConstructionPullupChildOrgs(String principalId, String chartOfAccountsCode, String organizationCode) {
    List<BudgetConstructionPullup> orgs = new ArrayList<BudgetConstructionPullup>();

    Criteria cycleCheckCriteria = new Criteria();
    cycleCheckCriteria.addEqualToField("chartOfAccountsCode", "reportsToChartOfAccountsCode");
    cycleCheckCriteria.addEqualToField("organizationCode", "reportsToOrganizationCode");
    cycleCheckCriteria.setEmbraced(true);
    cycleCheckCriteria.setNegative(true);

    Criteria criteria = new Criteria();
    criteria.addEqualTo("reportsToChartOfAccountsCode", chartOfAccountsCode);
    criteria.addEqualTo("reportsToOrganizationCode", organizationCode);
    criteria.addEqualTo("principalId", principalId);
    criteria.addAndCriteria(cycleCheckCriteria);

    QueryByCriteria query = QueryFactory.newQuery(BudgetConstructionPullup.class, criteria);
    query.addOrderByAscending("organization.organizationName");

    orgs = (List<BudgetConstructionPullup>) getPersistenceBrokerTemplate().getCollectionByQuery(query);

    if (orgs.isEmpty() || orgs.size() == 0) {
        return Collections.EMPTY_LIST;
    }
    return orgs;
}
 

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.kfs.module.bc.document.dataaccess.BudgetConstructionOrganizationReportsDao#getActiveChildOrgs(java.lang.String,
 *      java.lang.String)
 */
public List getActiveChildOrgs(String chartOfAccountsCode, String organizationCode) {
    List orgs = new ArrayList();
    Criteria cycleCheckCriteria = new Criteria();
    cycleCheckCriteria.addEqualToField("chartOfAccountsCode", "reportsToChartOfAccountsCode");
    cycleCheckCriteria.addEqualToField("organizationCode", "reportsToOrganizationCode");
    cycleCheckCriteria.setEmbraced(true);
    cycleCheckCriteria.setNegative(true);

    Criteria criteria = new Criteria();
    criteria.addEqualTo("reportsToChartOfAccountsCode", chartOfAccountsCode);
    criteria.addEqualTo("reportsToOrganizationCode", organizationCode);
    criteria.addAndCriteria(cycleCheckCriteria);
    criteria.addEqualTo("organization.active", Boolean.TRUE);
    orgs = (List) getPersistenceBrokerTemplate().getCollectionByQuery(QueryFactory.newQuery(BudgetConstructionOrganizationReports.class, criteria));

    if (orgs.isEmpty() || orgs.size() == 0) {
        return Collections.EMPTY_LIST;
    }
    return orgs;
}
 

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

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.ole.sys.dataaccess.GeneralLedgerPendingEntryDao#findPendingLedgerEntriesForCashBalance(java.util.Map, boolean,
 *      java.lang.String, int)
 */
@Override
public Iterator findPendingLedgerEntriesForCashBalance(Map fieldValues, boolean isApproved, String currentFiscalPeriodCode, int currentFiscalYear, List<String> encumbranceBalanceType) {
    LOG.debug("findPendingLedgerEntriesForCashBalance started");

    Criteria criteria = buildCriteriaFromMap(fieldValues, this.getEntryClassInstance(), currentFiscalPeriodCode, currentFiscalYear, encumbranceBalanceType);
    criteria.addEqualTo(OLEPropertyConstants.FINANCIAL_BALANCE_TYPE_CODE, "AC");
    criteria.addEqualToField(OLEPropertyConstants.FINANCIAL_OBJECT_CODE, CHART_FINANCIAL_CASH_OBJECT_CODE);

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

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

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
public Map<String, LeaveBlockBo> getLastCarryOverBlocks(String principalId, String leaveBlockType, LocalDate asOfDate) {
    Map<String, LeaveBlockBo> carryOver = new HashMap<String, LeaveBlockBo>();
    Criteria root = new Criteria();
    root.addEqualTo("principalId", principalId);
    root.addEqualTo("leaveBlockType", leaveBlockType);

    Criteria dateSubquery = new Criteria();
    dateSubquery.addEqualToField("principalId", Criteria.PARENT_QUERY_PREFIX + "principalId");
    dateSubquery.addEqualToField("leaveBlockType", Criteria.PARENT_QUERY_PREFIX + "leaveBlockType");
    dateSubquery.addEqualToField("accrualCategory", Criteria.PARENT_QUERY_PREFIX + "accrualCategory");
    if (asOfDate != null) {
        dateSubquery.addLessThan("leaveDate", asOfDate.toDate());
    }

    ReportQueryByCriteria subQuery = QueryFactory.newReportQuery(LeaveBlockBo.class, dateSubquery);
    String[] attributes = new String[] { "max(leaveDate)" };
    subQuery.setAttributes(attributes);

    root.addEqualTo("leaveDate", subQuery);

    Query query = QueryFactory.newQuery(LeaveBlockBo.class, root);
    Collection<LeaveBlockBo> c = (Collection<LeaveBlockBo>)this.getPersistenceBrokerTemplate().getCollectionByQuery(query);
    //Collection c = this.getPersistenceBrokerTemplate().getCollectionByQuery(query);
    for (LeaveBlockBo lb : c) {
        carryOver.put(lb.getAccrualCategory(), lb);
    }

    return carryOver;

}