function taxonomy_csv_term_load_multiple in Taxonomy CSV import/export 6.5

Same name and namespace in other branches

1. 6.2 taxonomy_csv.term.api.inc \taxonomy_csv_term_load_multiple()
2. 6.3 taxonomy_csv.term.api.inc \taxonomy_csv_term_load_multiple()
3. 6.4 taxonomy_csv.term.api.inc \taxonomy_csv_term_load_multiple()

Load multiple full terms.

This function can be used whenever to get more than one term from the database is needed. Terms have their links (parents, relations and synonyms).

Parameters

$tids: (Optional) An array of taxonomy term IDs.

$conditions: An array of conditions to add to the query. Currently managed conditions: vid and ascendant order.

Return value

An array of term objects eventually ordered.

2 calls to taxonomy_csv_term_load_multiple()

_taxonomy_csv_info_terms in import/taxonomy_csv.import.result.inc

Display stats and eventually lists of terms about imported terms.

_taxonomy_csv_vocabulary_export_process in export/taxonomy_csv.export.api.inc

Batch process of vocabulary export.

File

./taxonomy_csv.term.api.inc, line 46

Find, get and set full or detail term items.

Code

function taxonomy_csv_term_load_multiple($tids = array(), $conditions = array()) {
  $terms = array();

  // Flag use to determine if select query has already conditions.
  $flag = FALSE;

  // Prepare query for terms to be loaded.
  $sql = '
    SELECT t.*
    FROM {term_data} t
  ';
  $args = array();
  if ($tids) {
    if (!is_array($tids)) {
      $tids = array(
        $tids,
      );
    }
    if ($tids != array(
      0,
    ) && $tids != array(
      '0',
    )) {
      $sql .= ' WHERE t.tid IN (' . implode(',', $tids) . ')';
      $flag = TRUE;
    }
  }
  if (isset($conditions['vid']) && $conditions['vid']) {
    if (is_array($conditions['vid'])) {
      if ($conditions['vid'] != array(
        0,
      )) {
        $sql .= $flag ? ' AND ' : ' WHERE ';
        $sql .= 'vid IN (' . implode(',', $conditions['vid']) . ') ';
        $flag = TRUE;
      }
    }
    else {
      $sql .= $flag ? ' AND ' : ' WHERE ';
      $sql .= '(t.vid = %d)';
      $args[] = $conditions['vid'];
      $flag = TRUE;
    }
  }
  if (isset($conditions['order']) && $conditions['order']) {
    $sql .= ' ORDER BY %s ASC';
    $args[] = $conditions['order'];
  }
  $result = db_query($sql, $args);
  while ($term = db_fetch_object($result)) {
    $term = taxonomy_csv_term_get_full($term);
    $terms[$term->tid] = $term;
  }
  return $terms;
}