本文整理汇总了Java中org.apache.ojb.broker.query.Criteria.addIsNull方法的典型用法代码示例。如果您正苦于以下问题:Java Criteria.addIsNull方法的具体用法?Java Criteria.addIsNull怎么用?Java Criteria.addIsNull使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类org.apache.ojb.broker.query.Criteria
的用法示例。
在下文中一共展示了Criteria.addIsNull方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: addPredicate
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/** adds a predicate to a Criteria.*/
private void addPredicate(Predicate p, Criteria parent, LookupCustomizer.Transform<Predicate, Predicate> transform) {
p = transform.apply(p);
if (p instanceof PropertyPathPredicate) {
final String pp = ((PropertyPathPredicate) p).getPropertyPath();
if (p instanceof NotNullPredicate) {
parent.addNotNull(pp);
} else if (p instanceof NullPredicate) {
parent.addIsNull(pp);
} else if (p instanceof SingleValuedPredicate) {
addSingleValuePredicate((SingleValuedPredicate) p, parent);
} else if (p instanceof MultiValuedPredicate) {
addMultiValuePredicate((MultiValuedPredicate) p, parent);
} else {
throw new UnsupportedPredicateException(p);
}
} else if (p instanceof CompositePredicate) {
addCompositePredicate((CompositePredicate) p, parent, transform);
} else {
throw new UnsupportedPredicateException(p);
}
}
示例2: countActiveByChartOrg
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
* @see org.kuali.ole.module.purap.document.dataaccess.ReceivingAddressDao#countActiveByChartOrg(java.lang.String, java.lang.String)
*/
public int countActiveByChartOrg(String chartCode, String orgCode) {
LOG.debug("Entering countActiveByChartOrg(String,String)");
Criteria criteria = new Criteria();
criteria.addEqualTo(OLEPropertyConstants.CHART_OF_ACCOUNTS_CODE, chartCode);
if (orgCode == null)
criteria.addIsNull(OLEPropertyConstants.ORGANIZATION_CODE);
else
criteria.addEqualTo(OLEPropertyConstants.ORGANIZATION_CODE, orgCode);
criteria.addEqualTo(PurapPropertyConstants.BO_ACTIVE, true);
Query query = new QueryByCriteria(ReceivingAddress.class, criteria);
LOG.debug("Leaving countActiveByChartOrg(String,String)");
return getPersistenceBrokerTemplate().getCount(query);
}
示例3: getAllAgingInvoiceDocumentsByBilling
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
* @see org.kuali.kfs.module.ar.document.dataaccess.CustomerInvoiceDocumentDao#getAllAgingInvoiceDocumentsByBilling(java.util.List, java.util.List, java.sql.Date, java.sql.Date)
*/
@Override
public Collection<CustomerInvoiceDocument> getAllAgingInvoiceDocumentsByBilling(List<String> charts, List<String> organizations, Date invoiceBillingDateFrom, Date invoiceBillingDateTo) {
Criteria criteria = this.getAllAgingInvoiceDocumentsCriteria(StringUtils.EMPTY, invoiceBillingDateFrom, invoiceBillingDateTo);
if(ObjectUtils.isNotNull(charts)){
criteria.addIn(ArPropertyConstants.CustomerInvoiceDocumentFields.BILL_BY_CHART_OF_ACCOUNT_CODE, charts);
}
if(ObjectUtils.isNotNull(organizations)){
criteria.addIn(ArPropertyConstants.CustomerInvoiceDocumentFields.BILLED_BY_ORGANIZATION_CODE, organizations);
}
criteria.addIsNull(ArPropertyConstants.AGING_REPORT_SENT_TIME);
Query query = QueryFactory.newQuery(CustomerInvoiceDocument.class, criteria);
return getPersistenceBrokerTemplate().getCollectionByQuery(query);
}
示例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: getThresholdEnum
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
protected Collection<ReceivingThreshold> getThresholdEnum(Map criteriaFields) {
if (criteriaFields == null || criteriaFields.size() == 0) {
return null;
}
Criteria criteria = new Criteria();
List<ThresholdField> allFields = ThresholdField.getEnumList();
for (int i = 0; i < allFields.size(); i++) {
if (allFields.get(i).isPersistedField()) {
Object criteriaValue = criteriaFields.get(allFields.get(i));
if (criteriaValue != null) {
criteria.addEqualTo(allFields.get(i).getName(), criteriaValue);
} else {
criteria.addIsNull(allFields.get(i).getName());
}
}
}
Query query = new QueryByCriteria(ReceivingThreshold.class, criteria);
Collection c = getPersistenceBrokerTemplate().getCollectionByQuery(query);
return c;
}
示例6: findDefaultByChartOrg
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
* @see org.kuali.ole.module.purap.document.dataaccess.ReceivingAddressDao#findDefaultByChartOrg(java.lang.String, java.lang.String)
*/
public Collection<ReceivingAddress> findDefaultByChartOrg(String chartCode, String orgCode) {
LOG.debug("Entering findDefaultByChartOrg(String,String)");
Criteria criteria = new Criteria();
criteria.addEqualTo(OLEPropertyConstants.CHART_OF_ACCOUNTS_CODE, chartCode);
if (orgCode == null)
criteria.addIsNull(OLEPropertyConstants.ORGANIZATION_CODE);
else
criteria.addEqualTo(OLEPropertyConstants.ORGANIZATION_CODE, orgCode);
criteria.addEqualTo(PurapPropertyConstants.RECEIVING_ADDRESS_DEFAULT_INDICATOR, true);
criteria.addEqualTo(PurapPropertyConstants.BO_ACTIVE, true);
Query query = new QueryByCriteria(ReceivingAddress.class, criteria);
LOG.debug("Leaving findDefaultByChartOrg(String,String)");
return getPersistenceBrokerTemplate().getCollectionByQuery(query);
}
示例7: getThresholdEnum
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
protected Collection<ReceivingThreshold> getThresholdEnum(Map criteriaFields){
if (criteriaFields == null || criteriaFields.size() == 0){
return null;
}
Criteria criteria = new Criteria();
List<ThresholdField> allFields = ThresholdField.getEnumList();
for (int i = 0; i < allFields.size(); i++) {
if (allFields.get(i).isPersistedField()){
Object criteriaValue = criteriaFields.get(allFields.get(i));
if (criteriaValue != null){
criteria.addEqualTo(allFields.get(i).getName(), criteriaValue);
}else{
criteria.addIsNull(allFields.get(i).getName());
}
}
}
Query query = new QueryByCriteria(ReceivingThreshold.class, criteria);
Collection c = getPersistenceBrokerTemplate().getCollectionByQuery(query);
return c;
}
示例8: getAccountNotExpiredCriteria
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
* Builds a criteria to find non-expired accounts
*
* @return a Criteria for non-expired accounts
*/
protected Criteria getAccountNotExpiredCriteria(Date currentSqlDate) {
Criteria criteria = new Criteria();
criteria.addIsNull("accountExpirationDate");
Criteria notYetExpiredCriteria = new Criteria();
notYetExpiredCriteria.addGreaterThan("accountExpirationDate", currentSqlDate);
criteria.addOrCriteria(notYetExpiredCriteria);
return criteria;
}
示例9: getCanceledChecks
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));
}
示例10: findPreTaggablePOAccounts
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
* @see org.kuali.kfs.module.cab.batch.dataaccess.ExtractDao#findPreTaggablePOAccounts(org.kuali.kfs.module.cab.businessobject.BatchParameters, java.util.List)
*/
@Override
public Collection<PurchaseOrderAccount> findPreTaggablePOAccounts(BatchParameters batchParameters, List<String> docNumbersAwaitingPurchaseOrderStatus) {
Criteria statusCodeCond1 = new Criteria();
statusCodeCond1.addEqualTo(CabPropertyConstants.PreTagExtract.PURAP_CAPITAL_ASSET_SYSTEM_STATE_CODE, CabConstants.CAPITAL_ASSET_SYSTEM_STATE_CODE_NEW);
Criteria statusCodeOrCond = new Criteria();
statusCodeOrCond.addIsNull(CabPropertyConstants.PreTagExtract.PURAP_CAPITAL_ASSET_SYSTEM_STATE_CODE);
statusCodeOrCond.addOrCriteria(statusCodeCond1);
Criteria criteria = new Criteria();
Timestamp lastRunTimestamp = new Timestamp(((java.util.Date) batchParameters.getLastRunDate()).getTime());
criteria.addGreaterThan(CabPropertyConstants.PreTagExtract.PO_INITIAL_OPEN_TIMESTAMP, lastRunTimestamp);
criteria.addAndCriteria(statusCodeOrCond);
criteria.addGreaterOrEqualThan(CabPropertyConstants.PreTagExtract.PURAP_ITEM_UNIT_PRICE, batchParameters.getCapitalizationLimitAmount());
if (!batchParameters.getExcludedChartCodes().isEmpty()) {
criteria.addNotIn(CabPropertyConstants.PreTagExtract.CHART_OF_ACCOUNTS_CODE, batchParameters.getExcludedChartCodes());
}
if (!batchParameters.getExcludedSubFundCodes().isEmpty()) {
criteria.addNotIn(CabPropertyConstants.PreTagExtract.ACCOUNT_SUB_FUND_GROUP_CODE, batchParameters.getExcludedSubFundCodes());
}
if (!batchParameters.getIncludedFinancialObjectSubTypeCodes().isEmpty()) {
criteria.addIn(CabPropertyConstants.PreTagExtract.FINANCIAL_OBJECT_SUB_TYPE_CODE, batchParameters.getIncludedFinancialObjectSubTypeCodes());
}
QueryByCriteria query = new QueryByCriteria(PurchaseOrderAccount.class, criteria);
Collection<PurchaseOrderAccount> purchaseOrderAccounts = getPersistenceBrokerTemplate().getCollectionByQuery(query);
Collection<PurchaseOrderAccount> purchaseOrderAcctsAwaitingPOOpenStatus = new ArrayList<PurchaseOrderAccount>();
for (PurchaseOrderAccount purchaseOrderAccount : purchaseOrderAccounts) {
if (docNumbersAwaitingPurchaseOrderStatus.contains(purchaseOrderAccount.getDocumentNumber())) {
purchaseOrderAcctsAwaitingPOOpenStatus.add(purchaseOrderAccount);
}
}
return purchaseOrderAcctsAwaitingPOOpenStatus;
}
示例11: getPrintableCustomerInvoiceDocumentNumbersByProcessingChartAndOrg
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
@Override
public List<String> getPrintableCustomerInvoiceDocumentNumbersByProcessingChartAndOrg(String chartOfAccountsCode, String organizationCode) {
if (StringUtils.isBlank(chartOfAccountsCode)) {
throw new IllegalArgumentException("The method was called with a Null or Blank chartOfAccountsCode parameter.");
}
if (StringUtils.isBlank(organizationCode)) {
throw new IllegalArgumentException("The method was called with a Null or Blank organizationCode parameter.");
}
// Why use the OJB reports approach here, rather than a list of CustomerInvoiceDocuments?
//
// This was done because even if we had the invoice documents, we then need to do a proper document load
// via the documentService, which loads up the workflow information as well and properly prepares the document.
//
// Therefore, at this stage, there's no reason to load entire documents, all we need are document numbers. And with
// OJB, this is how you get just a collection of a single column's value out. Given the performance issues associated
// with live reporting like this, the attempt was made to minimize the resource usage.
// select i.fdoc_nbr
// from ar_doc_hdr_t h inner join ar_inv_doc_t i
// on h.fdoc_nbr = i.fdoc_nbr
// where h.prcs_fin_coa_cd = ? and h.prcs_org_cd = ?
Criteria criteria = new Criteria();
criteria.addEqualTo("accountsReceivableDocumentHeader.processingChartOfAccountCode", chartOfAccountsCode);
criteria.addEqualTo("accountsReceivableDocumentHeader.processingOrganizationCode", organizationCode);
criteria.addEqualTo("printInvoiceIndicator", ArConstants.PrintInvoiceOptions.PRINT_BY_PROCESSING_ORG);
criteria.addIsNull("printDate");
criteria.addEqualTo("documentHeader.financialDocumentStatusCode", KFSConstants.DocumentStatusCodes.APPROVED);
ReportQueryByCriteria rqbc = QueryFactory.newReportQuery(CustomerInvoiceDocument.class, new String[] { "documentNumber" }, criteria, false);
Iterator<Object[]> iter = getPersistenceBrokerTemplate().getReportQueryIteratorByQuery(rqbc);
List<String> invoiceNumbers = new ArrayList<String>();
while (iter.hasNext()) {
invoiceNumbers.add((String)iter.next()[0]);
}
return new ArrayList<String>(invoiceNumbers);
}
示例12: getProposalsToClose
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
* @see org.kuali.kfs.module.cg.dataaccess.ProposalDao#getProposalsToClose(org.kuali.kfs.module.cg.businessobject.Close)
*/
@Override
public Collection<Proposal> getProposalsToClose(ProposalAwardCloseDocument close) {
Criteria criteria = new Criteria();
criteria.addIsNull("proposalClosingDate");
criteria.addLessOrEqualThan("proposalSubmissionDate", close.getCloseOnOrBeforeDate());
return getPersistenceBrokerTemplate().getCollectionByQuery(QueryFactory.newQuery(Proposal.class, criteria));
}
示例13: getAwardsToClose
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
* @see org.kuali.ole.module.cg.dataaccess.AwardDao#getAwardsToClose(org.kuali.ole.module.cg.businessobject.Close)
*/
public Collection<Award> getAwardsToClose(ProposalAwardCloseDocument close) {
Criteria criteria = new Criteria();
criteria.addIsNull("awardClosingDate");
criteria.addLessOrEqualThan("awardEntryDate", close.getCloseOnOrBeforeDate());
criteria.addNotEqualTo("awardStatusCode", "U");
return (Collection<Award>) getPersistenceBrokerTemplate().getCollectionByQuery(QueryFactory.newQuery(Award.class, criteria));
}
示例14: getDefaultItemMappingMap
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
public Map getDefaultItemMappingMap() {
LOG.debug("getDefaultItemMappingMap() started");
Criteria criteria = new Criteria();
criteria.addIsNull("vendorHeaderGeneratedIdentifier");
criteria.addIsNull("vendorDetailAssignedIdentifier");
criteria.addEqualTo("active", true);
return this.getItemMappingMap(criteria);
}
示例15: buildPrefetchCriteriaMultipleKeys
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
* Build the prefetch criteria
*
* @param ids Collection of identities of M side
* @param fkCols indirection table fks to this class
* @param itemFkCols indirection table fks to item class
* @param itemPkFields
* @return the Criteria
*/
private Criteria buildPrefetchCriteriaMultipleKeys(Collection ids, String[] fkCols, String[] itemFkCols,
FieldDescriptor[] itemPkFields)
{
Criteria crit = new Criteria();
Criteria critValue = new Criteria();
Iterator iter = ids.iterator();
for (int i = 0; i < itemPkFields.length; i++)
{
crit.addEqualToField(itemPkFields[i].getAttributeName(), itemFkCols[i]);
}
while (iter.hasNext())
{
Criteria c = new Criteria();
Identity id = (Identity) iter.next();
Object[] val = id.getPrimaryKeyValues();
for (int i = 0; i < val.length; i++)
{
if (val[i] == null)
{
c.addIsNull(fkCols[i]);
}
else
{
c.addEqualTo(fkCols[i], val[i]);
}
}
critValue.addOrCriteria(c);
}
crit.addAndCriteria(critValue);
return crit;
}