private static StringBuilder buildOrderBy(StringBuilder query, OrderingField... orderByFields) { boolean first = true; for (OrderingField orderingField : orderByFields) { if (first) { // TODO GH: We could see if there already is an order by clause and contribute or override it query.append(" ORDER BY "); first = false; } else { query.append(", "); } query.append(orderingField.getField()).append(" ").append(orderingField.getOrdering()); } return query; }
private static String getOrderByFragment(OrderingField... orderByFields) { boolean first = true; StringBuilder builder = new StringBuilder(); for (OrderingField orderingField : orderByFields) { if (first) { builder.append(" ORDER BY "); first = false; } else { builder.append(", "); } builder.append(orderingField.getField()).append(" ").append(orderingField.getOrdering()); } return builder.toString(); }
private void fixOrder(List<OrderingField> orderingFields) { Collections.reverse(orderingFields); if (this.currentOrderingFields != null && orderingFields.size() > 1 && orderingFields.size() == this.currentOrderingFields.size()) { for (int i = 1, sortFieldsSize = orderingFields.size(); i < sortFieldsSize; i++) { OrderingField orderingField = orderingFields.get(i); OrderingField currentOrderingField = this.currentOrderingFields.get(i); if (orderingField.getField().equals(currentOrderingField.getField()) && orderingField.getOrdering() != currentOrderingField.getOrdering()) { orderingFields.remove(i); orderingFields.add(0, orderingField); } } } } }
@Override public String toString() { StringBuilder buf = new StringBuilder("PageControl["); if (firstRecord != null) { buf.append("firstRow=").append(firstRecord); } else { buf.append("page=").append(pageNumber); } buf.append(", size=").append(pageSize); int i = 0; if (orderingFields.size() > 0) { buf.append(", sort["); for (OrderingField orderingField : orderingFields) { if (i++ != 0) { buf.append(", "); } buf.append(orderingField.getField()).append(" ").append(orderingField.getOrdering()); } buf.append("]"); } buf.append("]"); return buf.toString(); }
public PageOrdering getPrimarySortOrder() { OrderingField primaryOrderingField = getPrimaryOrderingField(); if (primaryOrderingField == null) { return null; } return getPrimaryOrderingField().getOrdering(); }
private Query buildQuery(String queryString, PageControl pageControl) { boolean first = true; StringBuilder queryBuilder = new StringBuilder(queryString); for (OrderingField orderingField : pageControl.getOrderingFieldsAsArray()) { if (first) { // TODO GH: We could see if there already is an order by clause and contribute or override it queryBuilder.append(" ORDER BY "); first = false; } else { queryBuilder.append(", "); } queryBuilder.append(orderingField.getField()).append(" ").append(orderingField.getOrdering()); } Query query = entityManager.createQuery(queryBuilder.toString()); if (pageControl.getPageSize() > 0) { query.setFirstResult(pageControl.getStartRow()); query.setMaxResults(pageControl.getPageSize()); } return query; }
PageOrdering ordering = orderingField.getOrdering(); String fieldName = orderingField.getField(); String override = criteria.getJPQLSortOverride(fieldName);
String prefix = field.substring(0, field.length() - 5); String secondaryField = prefix + "Count"; pc.addDefaultOrderingField(secondaryField, primary.getOrdering());
writer.startElement("img", component); String imageFileName = null; switch (field.getOrdering()) { case ASC: imageFileName = (i == 0) ? "tb_sortup.gif" : "tb_sortup_inactive.gif";