Java QueryByCriteria.addOrderBy方法代码示例

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.ole.pdp.dataaccess.PaymentDetailDao#getDisbursementNumberRanges(java.lang.String)
 */
public List<DisbursementNumberRange> getDisbursementNumberRanges(String campus) {
    LOG.debug("getDisbursementNumberRanges() started");

    java.util.Date now = new java.util.Date();
    Timestamp nowTs = new Timestamp(now.getTime());

    Criteria criteria = new Criteria();
    criteria.addLessOrEqualThan(PdpPropertyConstants.DISBURSEMENT_NUMBER_RANGE_START_DATE, nowTs);
    criteria.addEqualTo(PdpPropertyConstants.PHYS_CAMPUS_PROC_CODE, campus);
    criteria.addEqualTo(OLEPropertyConstants.ACTIVE, true);

    QueryByCriteria qbc = new QueryByCriteria(DisbursementNumberRange.class, criteria);
    qbc.addOrderBy(OLEPropertyConstants.BANK_CODE, true);

    return (List<DisbursementNumberRange>) getPersistenceBrokerTemplate().getCollectionByQuery(qbc);
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
public Collection<Object> getDeliverNotices(String noticeType) {
    Criteria criteria = new Criteria();
    Date fromDate = DateUtil.addDays(new Timestamp(System.currentTimeMillis()), -1);
    Date toDate = DateUtil.addDays(new Timestamp(System.currentTimeMillis()), 1);
    if (noticeType.equals(OLEConstants.NOTICE_OVERDUE)) {
        List<String> noticeTypes = new ArrayList<>();
        noticeTypes.add(noticeType);
        noticeTypes.add(OLEConstants.NOTICE_LOST);
        criteria.addIn("noticeType", noticeTypes);
        criteria.addLessOrEqualThan("noticeToBeSendDate", new Timestamp(new Date().getTime()));
    } else {
        criteria.addEqualTo("noticeType", noticeType);
        criteria.addBetween("noticeToBeSendDate", fromDate, toDate);
    }
    QueryByCriteria query = QueryFactory.newQuery(OLEDeliverNotice.class, criteria);
    query.addOrderBy("patronId");
    Collection results = getPersistenceBrokerTemplate().getCollectionByQuery(query);
    return results;
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
public List<OleLoanDocument> getLoanDocumentsForNoticeGeneration(String noticeType, Collection<Object> deliverNotices) {
    List<OleLoanDocument> oleDeliverLoanDocuments = new ArrayList<>();
    List<String> loanIds = getLoanIds(deliverNotices);
    if (loanIds.size() > 0) {
        Criteria criteria = new Criteria();
        criteria.addColumnIn("LOAN_TRAN_ID", loanIds);
        if (noticeType.equals(OLEConstants.NOTICE_OVERDUE) || noticeType.equals(OLEConstants.NOTICE_LOST)) {
            criteria.addLessOrEqualThan("loanDueDate", new Timestamp(System.currentTimeMillis()));
        } else if (noticeType.equals(OLEConstants.NOTICE_COURTESY)) {
            criteria.addGreaterOrEqualThan("loanDueDate", new Timestamp(System.currentTimeMillis()));
        }
        QueryByCriteria query = QueryFactory.newQuery(OleLoanDocument.class, criteria);
        query.addOrderBy("patronId");
        Collection results = getPersistenceBrokerTemplate().getCollectionByQuery(query);
        for (Object oleLoanDocument : results) {
            oleDeliverLoanDocuments.add((OleLoanDocument) oleLoanDocument);
        }
    }
    return oleDeliverLoanDocuments;
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
 * Build the query to perform a batched read get orderBy settings from CollectionDescriptor
 *
 * @param ids Collection containing all identities of objects of the ONE side
 */
protected Query buildPrefetchQuery(Collection ids)
{
    CollectionDescriptor cds = getCollectionDescriptor();
    QueryByCriteria query = buildPrefetchQuery(ids, cds.getForeignKeyFieldDescriptors(getItemClassDescriptor()));

    // check if collection must be ordered
    if (!cds.getOrderBy().isEmpty())
    {
        Iterator iter = cds.getOrderBy().iterator();
        while (iter.hasNext())
        {
            query.addOrderBy((FieldHelper) iter.next());
        }
    }

    return query;
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.kfs.pdp.dataaccess.PaymentDetailDao#getDisbursementNumberRanges(java.lang.String)
 */
@Override
public List<DisbursementNumberRange> getDisbursementNumberRanges(String campus) {
    LOG.debug("getDisbursementNumberRanges() started");

    java.util.Date now = new java.util.Date();
    Timestamp nowTs = new Timestamp(now.getTime());

    Criteria criteria = new Criteria();
    criteria.addLessOrEqualThan(PdpPropertyConstants.DISBURSEMENT_NUMBER_RANGE_START_DATE, nowTs);
    criteria.addEqualTo(PdpPropertyConstants.PHYS_CAMPUS_PROC_CODE, campus);
    criteria.addEqualTo(KFSPropertyConstants.ACTIVE, true);

    QueryByCriteria qbc = new QueryByCriteria(DisbursementNumberRange.class, criteria);
    qbc.addOrderBy(KFSPropertyConstants.BANK_CODE, true);

    return (List<DisbursementNumberRange>) getPersistenceBrokerTemplate().getCollectionByQuery(qbc);
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
 * Get list of all ElectronicInvoiceItemMappings
 */
public List getAll() {
    LOG.debug("getAll() started");
    QueryByCriteria qbc = new QueryByCriteria(ElectronicInvoiceItemMapping.class);
    qbc.addOrderBy("id", true);
    List l = (List) getPersistenceBrokerTemplate().getCollectionByQuery(qbc);
    return l;
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
 * In addition to what the referenced method does, this also fixes a mysql order by issue (see class comments)
 *
 * @see org.apache.ojb.broker.accesslayer.QueryCustomizerDefaultImpl#customizeQuery(java.lang.Object,
 *      org.apache.ojb.broker.PersistenceBroker, org.apache.ojb.broker.metadata.CollectionDescriptor,
 *      org.apache.ojb.broker.query.QueryByCriteria)
 */
@Override
public Query customizeQuery(Object anObject, PersistenceBroker broker, CollectionDescriptor cod, QueryByCriteria query) {
    boolean platformMySQL = broker.serviceSqlGenerator().getPlatform() instanceof PlatformMySQLImpl;

    Map<String, String> attributes = getAttributes();
    for (String attributeName : attributes.keySet()) {
        if (!attributeName.startsWith(ORDER_BY_FIELD)) {
            continue;
        }

        String fieldName = attributeName.substring(ORDER_BY_FIELD.length());
        ClassDescriptor itemClassDescriptor = broker.getClassDescriptor(cod.getItemClass());
        FieldDescriptor orderByFieldDescriptior = itemClassDescriptor.getFieldDescriptorByName(fieldName);

        // the column to sort on derived from the property name
        String orderByColumnName = orderByFieldDescriptior.getColumnName();

        // ascending or descending
        String fieldValue = attributes.get(attributeName);
        boolean ascending = (StringUtils.equals(fieldValue, ASCENDING));
        // throw an error if not ascending or descending
        if (!ascending && StringUtils.equals(fieldValue, DESCENDING)) {
            throw new RuntimeException("neither ASC nor DESC was specified in ojb file for " + fieldName);
        }

        if (platformMySQL) {
            // by negating the column name in MySQL we can get nulls last (ascending or descending)
            String mysqlPrefix = (ascending) ? MYSQL_NEGATION : "";
            query.addOrderBy(mysqlPrefix + orderByColumnName, false);
        } else {
            query.addOrderBy(orderByColumnName, ascending);
        }
    }
    return query;
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
 * This method should only be used in unit tests. It loads all the gl_sf_balances_t rows in memory into a collection. This won't
 * sace for production.
 * 
 * @return a Collection of all sufficient funds records in the database
 */
public Collection testingGetAllEntries() {
    LOG.debug("testingGetAllEntries() started");

    Criteria criteria = new Criteria();
    QueryByCriteria qbc = QueryFactory.newQuery(SufficientFundBalances.class, criteria);
    qbc.addOrderBy(OLEPropertyConstants.UNIVERSITY_FISCAL_YEAR, true);
    qbc.addOrderBy(OLEPropertyConstants.CHART_OF_ACCOUNTS_CODE, true);
    qbc.addOrderBy(OLEPropertyConstants.ACCOUNT_NUMBER, true);
    qbc.addOrderBy(OLEPropertyConstants.FINANCIAL_OBJECT_CODE, true);

    return getPersistenceBrokerTemplate().getCollectionByQuery(qbc);
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
public Collection<Object> getOverdueLoanDocument() {
    Criteria criteria = new Criteria();
    criteria.addLessThan("loanDueDate", new Timestamp(System.currentTimeMillis()));
    QueryByCriteria query = QueryFactory.newQuery(OleLoanDocument.class, criteria);
    criteria.addColumnIsNull("REPMNT_FEE_PTRN_BILL_ID");
    query.addOrderBy("patronId");
    Collection results = getPersistenceBrokerTemplate().getCollectionByQuery(query);
    return results;

}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
public Collection<Object> getCourtesyLoanDocument(Integer interval) {
    Criteria criteria = new Criteria();
    criteria.addEqualTo("courtesyNoticeFlag", "N");
    Date formDate = DateUtil.addDays(new Timestamp(System.currentTimeMillis()), interval - 1);
    Date toDate = DateUtil.addDays(new Timestamp(System.currentTimeMillis()), interval + 1);
    criteria.addBetween("loanDueDate", new Timestamp(formDate.getTime()), new Timestamp(toDate.getTime()));
    QueryByCriteria query = QueryFactory.newQuery(OleLoanDocument.class, criteria);
    query.addOrderBy("patronId");
    Collection results = getPersistenceBrokerTemplate().getCollectionByQuery(query);
    return results;
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
public Collection<Object> getHoldRequests(List<String> requestTypeIds) {
    Criteria criteria = new Criteria();
    criteria.addIn("requestTypeId", requestTypeIds);
    criteria.addEqualTo("borrowerQueuePosition", "1");
    criteria.addColumnIsNull("ONHLD_NTC_SNT_DT");
    String pickupLocation = getPickUpLocation();
    if (pickupLocation != null && !pickupLocation.trim().isEmpty()) {
        criteria.addEqualTo("PCKUP_LOC_ID", pickupLocation);
    }
    QueryByCriteria query = QueryFactory.newQuery(OleDeliverRequestBo.class, criteria);
    query.addOrderBy("borrowerId");
    Collection results = getPersistenceBrokerTemplate().getCollectionByQuery(query);
    return results;
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
public Collection<Object> getHoldRequestsByPickupLocation(List<String> requestTypeIds, String pickupLocationId) {
    Criteria criteria = new Criteria();
    criteria.addIn("requestTypeId", requestTypeIds);
    criteria.addEqualTo("borrowerQueuePosition", "1");
    criteria.addColumnIsNull("ONHLD_NTC_SNT_DT");
    if (pickupLocationId != null && !pickupLocationId.trim().isEmpty()) {
        criteria.addEqualTo("PCKUP_LOC_ID", pickupLocationId);
    }
    QueryByCriteria query = QueryFactory.newQuery(OleDeliverRequestBo.class, criteria);
    query.addOrderBy("borrowerId");
    Collection results = getPersistenceBrokerTemplate().getCollectionByQuery(query);
    return results;
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
public Collection<Object> getExpiredRequests() {
    Criteria criteria = new Criteria();
    criteria.addLessOrEqualThan("requestExpiryDate", new Timestamp(System.currentTimeMillis()));
    QueryByCriteria query = QueryFactory.newQuery(OleDeliverRequestBo.class, criteria);
    query.addOrderBy("borrowerId");
    Collection results = getPersistenceBrokerTemplate().getCollectionByQuery(query);
    return results;
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
 * Answer the foreign key query to retrieve the collection
 * defined by CollectionDescriptor
 */
private Query getFKQuery(Object obj, ClassDescriptor cld, CollectionDescriptor cds)
{
    Query fkQuery;
    QueryByCriteria fkQueryCrit;

    if (cds.isMtoNRelation())
    {
        fkQueryCrit = getFKQueryMtoN(obj, cld, cds);
    }
    else
    {
        fkQueryCrit = getFKQuery1toN(obj, cld, cds);
    }

    // check if collection must be ordered
    if (!cds.getOrderBy().isEmpty())
    {
        Iterator iter = cds.getOrderBy().iterator();
        while (iter.hasNext())
        {
            fkQueryCrit.addOrderBy((FieldHelper)iter.next());
        }
    }

    // BRJ: customize the query
    if (cds.getQueryCustomizer() != null)
    {
        fkQuery = cds.getQueryCustomizer().customizeQuery(obj, pb, cds, fkQueryCrit);
    }
    else
    {
        fkQuery = fkQueryCrit;
    }

    return fkQuery;
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
   * Get list of all ElectronicInvoiceItemMappings
   */
  @Override
public List getAll() {
    LOG.debug("getAll() started");
    QueryByCriteria qbc = new QueryByCriteria(ElectronicInvoiceItemMapping.class);
    qbc.addOrderBy("id", true);
    List l = (List) getPersistenceBrokerTemplate().getCollectionByQuery(qbc);
    return l;
  }