public function views_handler_relationship_groupwise_max::options_form in Views (for Drupal 7) 7.3

Extends the relationship's basic options.

Allows the user to pick a sort and an order for it.

Overrides views_handler_relationship::options_form

File

handlers/views_handler_relationship_groupwise_max.inc, line 80

Definition of views_handler_relationship_groupwise_max.

Class

views_handler_relationship_groupwise_max

Relationship handler that allows a groupwise maximum of the linked in table.

Code

public function options_form(&$form, &$form_state) {
  parent::options_form($form, $form_state);

  // Get the sorts that apply to our base.
  $sorts = views_fetch_fields($this->definition['base'], 'sort');
  foreach ($sorts as $sort_id => $sort) {
    $sort_options[$sort_id] = "{$sort['group']}: {$sort['title']}";
  }
  $base_table_data = views_fetch_data($this->definition['base']);
  $form['subquery_sort'] = array(
    '#type' => 'select',
    '#title' => t('Representative sort criteria'),
    // Provide the base field as the default sort option.
    '#default_value' => !empty($this->options['subquery_sort']) ? $this->options['subquery_sort'] : $this->definition['base'] . '.' . $base_table_data['table']['base']['field'],
    '#options' => $sort_options,
    '#description' => theme('advanced_help_topic', array(
      'module' => 'views',
      'topic' => 'relationship-representative',
    )) . t("The sort criteria is applied to the data brought in by the relationship to determine how a representative item is obtained for each row. For example, to show the most recent node for each user, pick 'Content: Updated date'."),
  );
  $form['subquery_order'] = array(
    '#type' => 'radios',
    '#title' => t('Representative sort order'),
    '#description' => t("The ordering to use for the sort criteria selected above."),
    '#options' => array(
      'ASC' => t('Ascending'),
      'DESC' => t('Descending'),
    ),
    '#default_value' => $this->options['subquery_order'],
  );
  $form['subquery_namespace'] = array(
    '#type' => 'textfield',
    '#title' => t('Subquery namespace'),
    '#description' => t('Advanced. Enter a namespace for the subquery used by this relationship.'),
    '#default_value' => $this->options['subquery_namespace'],
  );

  // WIP: This stuff doesn't work yet: namespacing issues.
  // A list of suitable views to pick one as the subview.
  $views = array(
    '' => '<none>',
  );
  $all_views = views_get_all_views();
  foreach ($all_views as $view) {

    // Only get views that are suitable:
    // - base must the base that our relationship joins towards
    // - must have fields.
    if ($view->base_table == $this->definition['base'] && !empty($view->display['default']->display_options['fields'])) {

      // @todo check the field is the correct sort?
      // or let users hang themselves at this stage and check later?
      if ($view->type == 'Default') {
        $views[t('Default Views')][$view->name] = $view->name;
      }
      else {
        $views[t('Existing Views')][$view->name] = $view->name;
      }
    }
  }
  $form['subquery_view'] = array(
    '#type' => 'select',
    '#title' => t('Representative view'),
    '#default_value' => $this->options['subquery_view'],
    '#options' => $views,
    '#description' => t('Advanced. Use another view to generate the relationship subquery. This allows you to use filtering and more than one sort. If you pick a view here, the sort options above are ignored. Your view must have the ID of its base as its only field, and should have some kind of sorting.'),
  );
  $form['subquery_regenerate'] = array(
    '#type' => 'checkbox',
    '#title' => t('Generate subquery each time view is run.'),
    '#default_value' => $this->options['subquery_regenerate'],
    '#description' => t('Will re-generate the subquery for this relationship every time the view is run, instead of only when these options are saved. Use for testing if you are making changes elsewhere. WARNING: seriously impairs performance.'),
  );
}