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