A convient way to join a table to a query without duplicates.

Parameters

$query: The SelectQuery object.

$table: The table to join.

$alias: The table alias to use.

$condition: The join condition.

$type: The type of join: INNER, LEFT OUTER, or RIGHT OUTER.

File

tripal_chado/includes/TripalFields/ChadoField.inc, line 132

Class

ChadoField

Code

protected function queryJoinOnce($query, $table, $alias, $condition, $type = 'INNER') {
  $joins = $query->getTables();

  // If this join is already present then don't add it again.
  if (in_array($alias, array_keys($joins))) {
    return;
  }

  switch ($type) {
    case 'LEFT OUTER':
      $query->leftjoin($table, $alias, $condition);
      break;
    case 'RIGHT OUTER':
      $query->rightjoin($table, $alias, $condition);
      break;
    default:
      $query->innerjoin($table, $alias, $condition);
  }
}