workbench_access_handler_sort_section.inc in Workbench Access 7

Views integration for Workbench Access.

Provides a sort option for sections.

@TODO: Support multiple selections.

File

includes/workbench_access_handler_sort_section.inc

<?php

/**
 * @file
 *  Views integration for Workbench Access.
 *
 * Provides a sort option for sections.
 *
 * @TODO: Support multiple selections.
 */
class workbench_access_handler_sort_section extends views_handler_sort {
  function query() {
    $active = workbench_access_get_active_tree();
    if (empty($active['access_scheme']['sort'])) {
      return;
    }
    $order = $this->options['order'];
    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, 'node');
        if ($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']]);
        }
      }
    }
  }

}

Classes

Name	Description
workbench_access_handler_sort_section	@file Views integration for Workbench Access.