Java Criteria.addIsNull方法代码示例

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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