taxonomy_menu.database.inc in Taxonomy menu 7

Database functions

File

taxonomy_menu.database.inc

<?php

/**
 * @file
 * Database functions
 */

/**
 * Inserts a menu item.
 *
 * @param int $mlid
 *   Menu link ID.
 * @param int $tid
 *   Taxonomy term ID.
 * @param int $vid
 *   Vocabulary ID.
 */
function _taxonomy_menu_insert_menu_item($mlid, $tid, $vid) {
  $fields = array(
    'mlid' => $mlid,
    'tid' => $tid,
    'vid' => $vid,
  );
  db_insert('taxonomy_menu')
    ->fields($fields)
    ->execute();
}

/**
 * Returns the corresponding menu link id.
 *
 * @param int $tid
 *   Taxonomy term ID.
 * @param int $vid
 *   Vocabulary ID.
 * @return int
 *   Menu link ID for that taxonomy term.
 */
function _taxonomy_menu_get_mlid($tid, $vid) {
  $where = array(
    ':tid' => $tid,
    ':vid' => $vid,
  );
  return db_query('SELECT mlid FROM {taxonomy_menu} WHERE tid = :tid AND vid = :vid', $where)
    ->fetchField();
}

/**
 * Retrieves the term / menu relations for a vocab.
 *
 * @param $vid
 *   Vocabulary ID.
 *
 * @return array
 *   Relations to menu link ID as an array keyed by taxonomy term ID.
 *     array(tid => mlid)
 */
function _taxonomy_menu_get_menu_items($vid) {
  return db_query('SELECT tid, mlid FROM {taxonomy_menu} WHERE vid = :vid', array(
    ':vid' => $vid,
  ))
    ->fetchAllKeyed();
}

/**
 * Deletes all links associated with this vocab from both the taxonomy_menu
 * table and the menu_link table.
 *
 * @param int $vid
 *   Vocabulary ID.
 */
function _taxonomy_menu_delete_all($vid) {
  $menu_terms = _taxonomy_menu_get_menu_items($vid);
  if (!empty($menu_terms)) {
    foreach ($menu_terms as $tid => $mlid) {
      db_delete('menu_links')
        ->condition('mlid', $mlid)
        ->execute();
    }
    db_delete('taxonomy_menu')
      ->condition('vid', $vid)
      ->execute();
  }
}

/**
 * Gets an array of the tid's related to the node
 *
 * @param object $node
 *   Node object.
 *
 * @return array
 *   Array of taxonomy term IDs.
 */
function _taxonomy_menu_get_node_terms($node) {

  // Get the taxonomy fields.
  $tids = array();
  $result = db_query("SELECT field_name FROM {field_config} WHERE type = 'taxonomy_term_reference'");
  foreach ($result as $field) {
    $field_name = $field->field_name;
    if (isset($node->{$field_name})) {
      $tid_field = $node->{$field_name};

      // Loop through all the languages.
      foreach ($tid_field as $tid_field_languages) {

        // Loop through all the tids
        foreach ($tid_field_languages as $tid) {
          $tids[] = $tid['tid'];
        }
      }
    }
  }
  return $tids;
}

/**
 * Gets the parent tids for a taxonomy term.
 *
 * @param int $tid
 *   Taxonomy term ID.
 *
 * @return array
 *   Array of taxonomy term IDs.
 */
function _taxonomy_menu_get_parents($tid) {
  $output = array();
  $result = taxonomy_get_parents($tid);
  foreach ($result as $key => $item) {
    $output[] = $key;
  }
  return $output;
}

/**
 * Deletes all rows from {taxomony_menu} associated with this tid
 *
 * @param $vid
 * @param $tid
 * @param int $vid
 *   Vocabulary ID.
 * @param int $tid
 *   Taxonomy term ID.
 */
function _taxonomy_menu_delete_item($vid, $tid) {
  $and = db_and()
    ->condition('vid', $vid)
    ->condition('tid', $tid);
  db_delete('taxonomy_menu')
    ->condition($and)
    ->execute();
}

/**
 * Gets all taxonomy terms for a given vocabulary.
 *
 * @param int $vid
 *   Vocabulary ID.
 *
 * @return array
 *   Array of taxonomy term IDs.
 */
function _taxonomy_menu_get_terms($vid) {
  $result = db_select('taxonomy_term_data', 'td')
    ->condition('vid', $vid)
    ->fields('td', array(
    'tid',
  ))
    ->execute();
  return $result
    ->fetchAll();
}

/**
 * Gets the count of nodes for each term (without children).
 *
 * @param int $tid
 *   Taxonomy term ID.
 *
 * @return int
 *   Count of nodes that reference the term.
 *
 * @todo Needs updating since terms are related via fields now.
 */
function _taxonomy_menu_term_count($tid) {

  // Construct a cache ID
  $cid = 'taxonomy_menu:term_count:' . $tid;

  // Try to get the count from the cache.
  $cache = cache_get($cid);
  if ($cache) {
    return $cache->data;
  }

  // It is not in the cache, so issue a query.
  $result = db_select('taxonomy_index', 'tn');
  $result
    ->condition('tid', $tid);
  $result
    ->join('node', 'n', 'n.nid = tn.nid AND n.status = 1');
  $result
    ->addExpression('COUNT(n.nid)', 'term_count');
  $temp = $result
    ->execute();
  $temp = $temp
    ->fetchObject();
  $data = $temp->term_count;

  // Store the count in the cache.
  cache_set($cid, $data, 'cache', REQUEST_TIME + 1215);

  // Return the result.
  return $data;
}

/**
 * Gets tid for a given mlid.
 *
 * @param int $mlid
 *   Menu link ID.
 *
 * @return int $tid
 *   Taxonomy term ID.
 */
function _taxonomy_menu_get_tid($mlid) {
  return db_query('SELECT tid FROM {taxonomy_menu} WHERE mlid = :mlid', array(
    ':mlid' => $mlid,
  ))
    ->fetchField();
}

/**
 * Gets the vocabulary ID and taxonomy term ID for a given menu link ID.
 *
 * @param int $mlid
 *   Menu link ID.
 *
 * @return array
 *   array(vid, tid)
 */
function _taxonomy_menu_get_item($mlid) {
  $result = db_select('taxonomy_menu', 'tm')
    ->condition('mlid', $mlid, '=')
    ->fields('tm', array(
    'tid',
    'vid',
  ))
    ->execute();
  return $result
    ->fetch();
}

/**
 * Gets the vocabulary for a taxonomy term ID.
 *
 * @param array $tids
 *   Taxonomy term IDs.
 *
 * @return $vid
 *   Vocabulary ID.
 */
function _taxonomy_menu_get_vid_by_tid($tids) {
  if ($tids) {
    $result = db_select('term_data')
      ->condition('tid', $tids, 'IN')
      ->fields('term_data', array(
      'vid',
    ))
      ->distinct()
      ->execute();
    return $result
      ->fetchAllAssoc('vid');
  }
}

Functions

Name	Description
_taxonomy_menu_delete_all	Deletes all links associated with this vocab from both the taxonomy_menu table and the menu_link table.
_taxonomy_menu_delete_item	Deletes all rows from {taxomony_menu} associated with this tid
_taxonomy_menu_get_item	Gets the vocabulary ID and taxonomy term ID for a given menu link ID.
_taxonomy_menu_get_menu_items	Retrieves the term / menu relations for a vocab.
_taxonomy_menu_get_mlid	Returns the corresponding menu link id.
_taxonomy_menu_get_node_terms	Gets an array of the tid's related to the node
_taxonomy_menu_get_parents	Gets the parent tids for a taxonomy term.
_taxonomy_menu_get_terms	Gets all taxonomy terms for a given vocabulary.
_taxonomy_menu_get_tid	Gets tid for a given mlid.
_taxonomy_menu_get_vid_by_tid	Gets the vocabulary for a taxonomy term ID.
_taxonomy_menu_insert_menu_item	Inserts a menu item.
_taxonomy_menu_term_count	Gets the count of nodes for each term (without children).