chado_views_handler_relationship_to_node Class Reference

List of all members.

Public Member Functions
	query ()

---

Detailed Description

Relationship handler that links a chado table to it's nodes by creating 2 joins.

NOTE: This handler assumes if you are linking TABLEA to it's nodes that there is a table named chado_TABLEA in the drupal schema with at least the following two fields: nid and TABLEA_id.

Definition items:

• base: The new base table this relationship will be adding. This does not have to be a declared base table, but if there are no tables that utilize this base table, it won't be very effective.
• base field: The field to use in the relationship; if left out this will be assumed to be the primary field.
• label: The default label to provide for this relationship, which is shown in parentheses next to any field/sort/filter/argument that uses the relationship.

Definition at line 23 of file chado_views_handler_relationship_to_node.inc.

---

Member Function Documentation

chado_views_handler_relationship_to_node::query

(

)

Definition at line 25 of file chado_views_handler_relationship_to_node.inc.

                   {

    $this->ensure_my_table();

    // The base table in chado
    $base_table = $this->definition['base table'];
    $base_field = $this->definition['base field'];

    // The drupal linking table
    $chado_table = 'chado_' . $base_table;

    // Need to remove the incorrectly added node & chado_table join
    unset($this->query->table_queue['node'],
      $this->query->tables['stock']['node'],
      $this->query->table_queue[$chado_table],
      $this->query->tables['stock'][$chado_table]);

    // First add base => chado_base join
    $def = array();
    $def['table'] = $chado_table;
    $def['field'] = $base_field;
    $def['left_table'] = $base_table;
    $def['left_field'] = $base_field;
    //$def['handler'] = 'views_handler_join_chado_aggregator';

    $join = new views_join();

    $join->definition = $def;
    $join->construct();
    $join->adjusted = TRUE;

    $alias = $base_table . '_' . $chado_table;
    $this->linker_alias = $this->query->add_relationship($alias, $join, $this->table);

    // Now add chado_base => node join
    $def = array();
    $def['table'] = 'node';
    $def['field'] = 'nid';
    $def['left_table'] = $this->linker_alias;
    $def['left_field'] = 'nid';
    //$def['handler'] = 'views_handler_join_chado_aggregator';

    $join = new views_join();

    $join->definition = $def;
    $join->construct();
    $join->adjusted = TRUE;

    if ($base_table == $this->view->base_table) {
      $alias = 'node';
    }
    else {
      $alias = $chado_table . '_node';
    }
    $this->alias = $this->query->add_relationship($alias, $join, 'node');
  }

---

The documentation for this class was generated from the following file:

• tripal_views/views/handlers/chado_views_handler_relationship_to_node.inc