public JsonObject formatColumnSort(ColumnSort columnSort) throws JsonException { if (columnSort == null) { return null; } JsonObject columnSortJson = Json.createObject(); columnSortJson.put(COLUMN, columnSort.getColumnId() != null ? columnSort.getColumnId() : null); columnSortJson.put(SORTORDER, columnSort.getOrder() != null ? columnSort.getOrder().toString() : null); return columnSortJson; }
public JsonObject formatColumnSort(ColumnSort columnSort) throws JsonException { if (columnSort == null) { return null; } JsonObject columnSortJson = Json.createObject(); columnSortJson.put(COLUMN, columnSort.getColumnId() != null ? columnSort.getColumnId() : null); columnSortJson.put(SORTORDER, columnSort.getOrder() != null ? columnSort.getOrder().toString() : null); return columnSortJson; }
public List<Integer> sort(DataSet dataSet, List<Integer> rowNumbers, List<ColumnSort> columnSortList) { // Create the comparator. DataSetRowComparator comparator = new DataSetRowComparator(); for (ColumnSort columnSort : columnSortList) { DataColumn column = dataSet.getColumnById(columnSort.getColumnId()); if (column == null) throw new IllegalArgumentException("Sort column not found: " + columnSort.getColumnId()); comparator.criteria(column, columnSort.getOrder()); } // Create the row number list to sort. List<Integer> rows = new ArrayList<Integer>(); if (rowNumbers != null) { rows.addAll(rowNumbers); } else { for (int i=0; i<dataSet.getRowCount(); i++) { rows.add(i); } } // Sort the row numbers. Collections.sort(rows, comparator); return rows; } }
protected void _appendOrderBy(DataSetSort sortOp) { List<SortColumn> _columns = new ArrayList<>(); List<ColumnSort> sortList = sortOp.getColumnSortList(); for (ColumnSort columnSort : sortList) { String dbColumnId = _columnFromMetadata(metadata, columnSort.getColumnId()); if (SortOrder.DESCENDING.equals(columnSort.getOrder())) { _columns.add(SQLFactory.column(dbColumnId).desc()); } else { _columns.add(SQLFactory.column(dbColumnId).asc()); } } _query.orderBy(_columns); }
protected void _appendOrderBy(DataSetSort sortOp) { List<SortColumn> _columns = new ArrayList<>(); List<ColumnSort> sortList = sortOp.getColumnSortList(); for (ColumnSort columnSort : sortList) { String dbColumnId = _columnFromMetadata(metadata, columnSort.getColumnId()); if (SortOrder.DESCENDING.equals(columnSort.getOrder())) { _columns.add(SQLFactory.column(dbColumnId).desc()); } else { _columns.add(SQLFactory.column(dbColumnId).asc()); } } _query.orderBy(_columns); }
/** * Invert the sort order if this sort operation. */ public DataSetSort invertOrder() { for (ColumnSort columnSort : getColumnSortList()) { SortOrder order = columnSort.getOrder(); if (SortOrder.ASCENDING.equals(order)) columnSort.setOrder(SortOrder.DESCENDING); else if (SortOrder.DESCENDING.equals(order)) columnSort.setOrder(SortOrder.ASCENDING); } return this; }
/** * Invert the sort order if this sort operation. */ public DataSetSort invertOrder() { for (ColumnSort columnSort : getColumnSortList()) { SortOrder order = columnSort.getOrder(); if (SortOrder.ASCENDING.equals(order)) columnSort.setOrder(SortOrder.DESCENDING); else if (SortOrder.DESCENDING.equals(order)) columnSort.setOrder(SortOrder.ASCENDING); } return this; }
for (ColumnSort cSort : sort.getColumnSortList()) { orderBy.append(cSort.getColumnId()).append(","); sortOrder = cSort.getOrder();
for (ColumnSort cSort : sort.getColumnSortList()) { orderBy.append(cSort.getColumnId()).append(","); sortOrder = cSort.getOrder();