function workbench_access_handler_field_section::click_sort in Workbench Access 7

Called to determine what to tell the clicksorter.

Overrides views_handler_field::click_sort

File

includes/workbench_access_handler_field_section.inc, line 27

Views integration for Workbench Access.

Class

workbench_access_handler_field_section

@file Views integration for Workbench Access.

Code

function click_sort($order) {
  $active = workbench_access_get_active_tree();
  if (empty($active['access_scheme']['sort'])) {
    return;
  }
  foreach ($active['access_scheme']['sort'] as $sort) {
    $table = $this->query
      ->ensure_table($sort['table']);
    if (!empty($table)) {
      $this->query
        ->add_orderby($table, $sort['field'], isset($sort['order']) ? $sort['order'] : $order);
    }
  }

  // Logic to remove JOIN to the default table, which can cause duplicate results.
  $base_table = $this->view->base_table;
  if ($base_table == 'node' && isset($active['access_scheme']['adjust_join'])) {
    foreach ($active['access_scheme']['adjust_join'] as $table => $replace) {
      $join = $this->query
        ->get_join_data($table, $base_table);
      if (isset($join->left_table) && $join->left_table == $replace['original_table']) {
        $this->query->table_queue[$table]['join']->left_table = $replace['new_table'];
        $this->query->table_queue[$table]['join']->left_field = $replace['new_field'];
        unset($this->query->tables['node'][$replace['original_table']]);
        unset($this->query->table_queue[$replace['original_table']]);
      }
    }
  }
}