function nodequeue_handler_sort_by_position_and_other::query in Nodequeue 7.2

Same name and namespace in other branches

1. 7.3 includes/views/nodequeue_handler_sort_by_position_and_other.inc \nodequeue_handler_sort_by_position_and_other::query()

Called to add the sort to a query.

Overrides views_handler_sort::query

File

includes/views/nodequeue_handler_sort_by_position_and_other.inc, line 16

Views handler for sorting nodes by position in nodequeue and some other parameter.

Class

nodequeue_handler_sort_by_position_and_other

Allows combining the nodequeue position with another (random) parameter (created date for example). This handler is useful only if the nodequeue relationship is NOT required.

Code

function query() {
  $table = $this
    ->ensure_my_table();
  $field = 'position';
  $as = $table . '_' . $field;
  if ($field) {
    $this->query
      ->add_field($table, $field, $as);
  }

  // If we sort ASC items with NULL should be last, so set 99999999,
  // if DESC set 0.
  $order = strtoupper($this->options['order']);
  $stub = $order == 'DESC' ? '0' : '999999999';

  // Use COALESCE instead of IFNULL, and avoid using the field alias to support MS SQL Server.
  $this->query->orderby[] = array(
    'field' => "COALESCE({$table}.{$field}, {$stub}) ",
    'direction' => $order,
  );
}