' . t('About') . ''; $output .= '

' . t('The Taxonomy module allows you to classify the content of your website. To classify content, you define vocabularies that contain related terms, and then assign the vocabularies to content types. For more information, see the online handbook entry for the Taxonomy module.', array('@taxonomy' => 'http://drupal.org/handbook/modules/taxonomy/')) . '

'; $output .= '

' . t('Uses') . '

'; $output .= '
'; $output .= '
' . t('Creating vocabularies') . '
'; $output .= '
' . t('Users with sufficient permissions can create vocabularies and terms through the Taxonomy page. The page listing the terms provides a drag-and-drop interface for controlling the order of the terms and sub-terms within a vocabulary, in a hierarchical fashion. A controlled vocabulary classifying music by genre with terms and sub-terms could look as follows:', array('@taxo' => url('admin/structure/taxonomy'), '@perm' => url('admin/people/permissions', array('fragment'=>'module-taxonomy')))); $output .= ''; $output .= t('You can assign a sub-term to multiple parent terms. For example, fusion can be assigned to both rock and jazz.') . '
'; $output .= '
' . t('Terms in a free-tagging vocabulary can be built gradually as you create or edit content. This is often done used for blogs or photo management applications.') . '
'; $output .= '
' . t('Assigning vocabularies to content types') . '
'; $output .= '
' . t('Before you can use a new vocabulary to classify your content, a new Taxonomy term field must be added to a content type on its manage fields page. When adding a taxonomy field, you choose a widget to use to enter the taxonomy information on the content editing page: a select list, checkboxes, radio buttons, or an auto-complete field (to build a free-tagging vocabulary). After choosing the field type and widget, on the subsequent field settings page you can choose the desired vocabulary, whether one or multiple terms can be chosen from the vocabulary, and other settings. The same vocabulary can be added to multiple content types, by using the "Add existing field" section on the manage fields page.', array('@ctedit' => url('admin/structure/types'))) . '
'; $output .= '
' . t('Classifying content') . '
'; $output .= '
' . t('After the vocabulary is assigned to the content type, you can start classifying content. The field with terms will appear on the content editing screen when you edit or add new content.', array('@addnode' => url('node/add'))) . '
'; $output .= '
' . t('Viewing listings and RSS feeds by term') . '
'; $output .= '
' . t("Each taxonomy term automatically provides a page listing content that has its classification, and a corresponding RSS feed. For example, if the taxonomy term country rock has the ID 123 (you can see this by looking at the URL when hovering on the linked term, which you can click to navigate to the listing page), then you will find this list at the path taxonomy/term/123. The RSS feed will use the path taxonomy/term/123/feed (the RSS icon for this term's listing will automatically display in your browser's address bar when viewing the listing page).") . '
'; $output .= '
' . t('Extending Taxonomy module') . '
'; $output .= '
' . t('There are many contributed modules that extend the behavior of the Taxonomy module for both display and organization of terms.', array('@taxcontrib' => 'http://drupal.org/project/modules?filters=tid:71&solrsort=sis_project_release_usage%20desc')); $output .= '
'; return $output; case 'admin/structure/taxonomy': $output = '

' . t('Taxonomy is for categorizing content. Terms are grouped into vocabularies. For example, a vocabulary called "Fruit" would contain the terms "Apple" and "Banana".') . '

'; return $output; case 'admin/structure/taxonomy/%': $vocabulary = taxonomy_vocabulary_machine_name_load($arg[3]); switch ($vocabulary->hierarchy) { case 0: return '

' . t('You can reorganize the terms in %capital_name using their drag-and-drop handles, and group terms under a parent term by sliding them under and to the right of the parent.', array('%capital_name' => drupal_ucfirst($vocabulary->name), '%name' => $vocabulary->name)) . '

'; case 1: return '

' . t('%capital_name contains terms grouped under parent terms. You can reorganize the terms in %capital_name using their drag-and-drop handles.', array('%capital_name' => drupal_ucfirst($vocabulary->name), '%name' => $vocabulary->name)) . '

'; case 2: return '

' . t('%capital_name contains terms with multiple parents. Drag and drop of terms with multiple parents is not supported, but you can re-enable drag-and-drop support by editing each term to include only a single parent.', array('%capital_name' => drupal_ucfirst($vocabulary->name))) . '

'; } } } /** * Implements hook_permission(). */ function taxonomy_permission() { $permissions = array( 'administer taxonomy' => array( 'title' => t('Administer vocabularies and terms'), ), ); foreach (taxonomy_get_vocabularies() as $vocabulary) { $permissions += array( 'edit terms in ' . $vocabulary->vid => array( 'title' => t('Edit terms in %vocabulary', array('%vocabulary' => $vocabulary->name)), ), ); $permissions += array( 'delete terms in ' . $vocabulary->vid => array( 'title' => t('Delete terms from %vocabulary', array('%vocabulary' => $vocabulary->name)), ), ); } return $permissions; } /** * Implements hook_entity_info(). */ function taxonomy_entity_info() { $return = array( 'taxonomy_term' => array( 'label' => t('Taxonomy term'), 'controller class' => 'TaxonomyTermController', 'base table' => 'taxonomy_term_data', 'uri callback' => 'taxonomy_term_uri', 'fieldable' => TRUE, 'entity keys' => array( 'id' => 'tid', 'bundle' => 'vocabulary_machine_name', 'label' => 'name', ), 'bundle keys' => array( 'bundle' => 'machine_name', ), 'bundles' => array(), 'view modes' => array( // @todo View mode for display as a field (when attached to nodes etc). 'full' => array( 'label' => t('Taxonomy term page'), 'custom settings' => FALSE, ), ), ), ); foreach (taxonomy_vocabulary_get_names() as $machine_name => $vocabulary) { $return['taxonomy_term']['bundles'][$machine_name] = array( 'label' => $vocabulary->name, 'admin' => array( 'path' => 'admin/structure/taxonomy/%taxonomy_vocabulary_machine_name', 'real path' => 'admin/structure/taxonomy/' . $machine_name, 'bundle argument' => 3, 'access arguments' => array('administer taxonomy'), ), ); } $return['taxonomy_vocabulary'] = array( 'label' => t('Taxonomy vocabulary'), 'controller class' => 'TaxonomyVocabularyController', 'base table' => 'taxonomy_vocabulary', 'entity keys' => array( 'id' => 'vid', 'label' => 'name', ), 'fieldable' => FALSE, ); return $return; } /** * Entity uri callback. */ function taxonomy_term_uri($term) { return array( 'path' => 'taxonomy/term/' . $term->tid, ); } /** * Implements hook_field_extra_fields(). */ function taxonomy_field_extra_fields() { $return = array(); $info = entity_get_info('taxonomy_term'); foreach (array_keys($info['bundles']) as $bundle) { $return['taxonomy_term'][$bundle] = array( 'form' => array( 'name' => array( 'label' => t('Name'), 'description' => t('Term name textfield'), 'weight' => -5, ), 'description' => array( 'label' => t('Description'), 'description' => t('Term description textarea'), 'weight' => 0, ), ), 'display' => array( 'description' => array( 'label' => t('Description'), 'description' => t('Term description'), 'weight' => 0, ), ), ); } return $return; } /** * Return nodes attached to a term across all field instances. * * This function requires taxonomy module to be maintaining its own tables, * and will return an empty array if it is not. If using other field storage * methods alternatives methods for listing terms will need to be used. * * @param $tid * The term ID. * @param $pager * Boolean to indicate whether a pager should be used. * @param $limit * Integer. The maximum number of nodes to find. * Set to FALSE for no limit. * @order * An array of fields and directions. * * @return * An array of nids matching the query. */ function taxonomy_select_nodes($tid, $pager = TRUE, $limit = FALSE, $order = array('t.sticky' => 'DESC', 't.created' => 'DESC')) { if (!variable_get('taxonomy_maintain_index_table', TRUE)) { return array(); } $query = db_select('taxonomy_index', 't'); $query->addTag('node_access'); $query->condition('tid', $tid); if ($pager) { $count_query = clone $query; $count_query->addExpression('COUNT(t.nid)'); $query = $query->extend('PagerDefault'); if ($limit !== FALSE) { $query = $query->limit($limit); } $query->setCountQuery($count_query); } else { if ($limit !== FALSE) { $query->range(0, $limit); } } $query->addField('t', 'nid'); $query->addField('t', 'tid'); foreach ($order as $field => $direction) { $query->orderBy($field, $direction); // ORDER BY fields need to be loaded too, assume they are in the form // table_alias.name list($table_alias, $name) = explode('.', $field); $query->addField($table_alias, $name); } return $query->execute()->fetchCol(); } /** * Implements hook_theme(). */ function taxonomy_theme() { return array( 'taxonomy_overview_vocabularies' => array( 'render element' => 'form', ), 'taxonomy_overview_terms' => array( 'render element' => 'form', ), 'taxonomy_term' => array( 'render element' => 'elements', 'template' => 'taxonomy-term', ), ); } /** * Implements hook_menu(). */ function taxonomy_menu() { $items['admin/structure/taxonomy'] = array( 'title' => 'Taxonomy', 'description' => 'Manage tagging, categorization, and classification of your content.', 'page callback' => 'drupal_get_form', 'page arguments' => array('taxonomy_overview_vocabularies'), 'access arguments' => array('administer taxonomy'), 'file' => 'taxonomy.admin.inc', ); $items['admin/structure/taxonomy/list'] = array( 'title' => 'List', 'type' => MENU_DEFAULT_LOCAL_TASK, 'weight' => -10, ); $items['admin/structure/taxonomy/add'] = array( 'title' => 'Add vocabulary', 'page callback' => 'drupal_get_form', 'page arguments' => array('taxonomy_form_vocabulary'), 'access arguments' => array('administer taxonomy'), 'type' => MENU_LOCAL_ACTION, 'file' => 'taxonomy.admin.inc', ); $items['taxonomy/term/%taxonomy_term'] = array( 'title' => 'Taxonomy term', 'title callback' => 'taxonomy_term_title', 'title arguments' => array(2), 'page callback' => 'taxonomy_term_page', 'page arguments' => array(2), 'access arguments' => array('access content'), 'file' => 'taxonomy.pages.inc', ); $items['taxonomy/term/%taxonomy_term/view'] = array( 'title' => 'View', 'type' => MENU_DEFAULT_LOCAL_TASK, ); $items['taxonomy/term/%taxonomy_term/edit'] = array( 'title' => 'Edit', 'page callback' => 'drupal_get_form', 'page arguments' => array('taxonomy_form_term', 2), 'access callback' => 'taxonomy_term_edit_access', 'access arguments' => array(2), 'type' => MENU_LOCAL_TASK, 'weight' => 10, 'file' => 'taxonomy.admin.inc', ); $items['taxonomy/term/%taxonomy_term/feed'] = array( 'title' => 'Taxonomy term', 'title callback' => 'taxonomy_term_title', 'title arguments' => array(2), 'page callback' => 'taxonomy_term_feed', 'page arguments' => array(2), 'access arguments' => array('access content'), 'type' => MENU_CALLBACK, 'file' => 'taxonomy.pages.inc', ); $items['taxonomy/autocomplete'] = array( 'title' => 'Autocomplete taxonomy', 'page callback' => 'taxonomy_autocomplete', 'access arguments' => array('access content'), 'type' => MENU_CALLBACK, 'file' => 'taxonomy.pages.inc', ); $items['admin/structure/taxonomy/%taxonomy_vocabulary_machine_name'] = array( 'title callback' => 'taxonomy_admin_vocabulary_title_callback', 'title arguments' => array(3), 'page callback' => 'drupal_get_form', 'page arguments' => array('taxonomy_overview_terms', 3), 'access arguments' => array('administer taxonomy'), 'file' => 'taxonomy.admin.inc', ); $items['admin/structure/taxonomy/%taxonomy_vocabulary_machine_name/list'] = array( 'title' => 'List', 'type' => MENU_DEFAULT_LOCAL_TASK, 'weight' => -20, ); $items['admin/structure/taxonomy/%taxonomy_vocabulary_machine_name/edit'] = array( 'title' => 'Edit', 'page callback' => 'drupal_get_form', 'page arguments' => array('taxonomy_form_vocabulary', 3), 'access arguments' => array('administer taxonomy'), 'type' => MENU_LOCAL_TASK, 'weight' => -10, 'file' => 'taxonomy.admin.inc', ); $items['admin/structure/taxonomy/%taxonomy_vocabulary_machine_name/add'] = array( 'title' => 'Add term', 'page callback' => 'drupal_get_form', 'page arguments' => array('taxonomy_form_term', array(), 3), 'access arguments' => array('administer taxonomy'), 'type' => MENU_LOCAL_ACTION, 'file' => 'taxonomy.admin.inc', ); return $items; } /** * Implements hook_admin_paths(). */ function taxonomy_admin_paths() { $paths = array( 'taxonomy/term/*/edit' => TRUE, ); return $paths; } /** * Return edit access for a given term. */ function taxonomy_term_edit_access($term) { return user_access("edit terms in $term->vid") || user_access('administer taxonomy'); } /** * Return the vocabulary name given the vocabulary object. */ function taxonomy_admin_vocabulary_title_callback($vocabulary) { return check_plain($vocabulary->name); } /** * Save a vocabulary given a vocabulary object. */ function taxonomy_vocabulary_save($vocabulary) { // Prevent leading and trailing spaces in vocabulary names. if (!empty($vocabulary->name)) { $vocabulary->name = trim($vocabulary->name); } // Load the stored entity, if any. if (!empty($vocabulary->vid)) { if (!isset($vocabulary->original)) { $vocabulary->original = entity_load_unchanged('taxonomy_vocabulary', $vocabulary->vid); } // Make sure machine name changes are easily detected. // @todo: Remove in Drupal 8, as it is deprecated by directly reading from // $vocabulary->original. $vocabulary->old_machine_name = $vocabulary->original->machine_name; } if (!isset($vocabulary->module)) { $vocabulary->module = 'taxonomy'; } module_invoke_all('taxonomy_vocabulary_presave', $vocabulary); module_invoke_all('entity_presave', $vocabulary, 'taxonomy_vocabulary'); if (!empty($vocabulary->vid) && !empty($vocabulary->name)) { $status = drupal_write_record('taxonomy_vocabulary', $vocabulary, 'vid'); if ($vocabulary->old_machine_name != $vocabulary->machine_name) { field_attach_rename_bundle('taxonomy_term', $vocabulary->old_machine_name, $vocabulary->machine_name); } module_invoke_all('taxonomy_vocabulary_update', $vocabulary); module_invoke_all('entity_update', $vocabulary, 'taxonomy_vocabulary'); } elseif (empty($vocabulary->vid)) { $status = drupal_write_record('taxonomy_vocabulary', $vocabulary); field_attach_create_bundle('taxonomy_term', $vocabulary->machine_name); module_invoke_all('taxonomy_vocabulary_insert', $vocabulary); module_invoke_all('entity_insert', $vocabulary, 'taxonomy_vocabulary'); } unset($vocabulary->original); cache_clear_all(); entity_get_controller('taxonomy_vocabulary')->resetCache(array($vocabulary->vid)); return $status; } /** * Delete a vocabulary. * * @param $vid * A vocabulary ID. * @return * Constant indicating items were deleted. */ function taxonomy_vocabulary_delete($vid) { $vocabulary = taxonomy_vocabulary_load($vid); $transaction = db_transaction(); try { // Only load terms without a parent, child terms will get deleted too. $result = db_query('SELECT t.tid FROM {taxonomy_term_data} t INNER JOIN {taxonomy_term_hierarchy} th ON th.tid = t.tid WHERE t.vid = :vid AND th.parent = 0', array(':vid' => $vid))->fetchCol(); foreach ($result as $tid) { taxonomy_term_delete($tid); } db_delete('taxonomy_vocabulary') ->condition('vid', $vid) ->execute(); field_attach_delete_bundle('taxonomy_term', $vocabulary->machine_name); module_invoke_all('taxonomy_vocabulary_delete', $vocabulary); module_invoke_all('entity_delete', $vocabulary, 'taxonomy_vocabulary'); cache_clear_all(); entity_get_controller('taxonomy_vocabulary')->resetCache(); return SAVED_DELETED; } catch (Exception $e) { $transaction->rollback(); watchdog_exception('taxonomy', $e); throw $e; } } /** * Implements hook_taxonomy_vocabulary_update(). */ function taxonomy_taxonomy_vocabulary_update($vocabulary) { // Reflect machine name changes in the definitions of existing 'taxonomy' // fields. if (!empty($vocabulary->old_machine_name) && $vocabulary->old_machine_name != $vocabulary->machine_name) { $fields = field_read_fields(); foreach ($fields as $field_name => $field) { $update = FALSE; if ($field['type'] == 'taxonomy_term_reference') { foreach ($field['settings']['allowed_values'] as $key => &$value) { if ($value['vocabulary'] == $vocabulary->old_machine_name) { $value['vocabulary'] = $vocabulary->machine_name; $update = TRUE; } } if ($update) { field_update_field($field); } } } } } /** * Dynamically check and update the hierarchy flag of a vocabulary. * * Checks the current parents of all terms in a vocabulary and updates the * vocabularies hierarchy setting to the lowest possible level. A hierarchy with * no parents in any of its terms will be given a hierarchy of 0. If terms * contain at most a single parent, the vocabulary will be given a hierarchy of * 1. If any term contain multiple parents, the vocabulary will be given a * hierarchy of 2. * * @param $vocabulary * A vocabulary object. * @param $changed_term * An array of the term structure that was updated. */ function taxonomy_check_vocabulary_hierarchy($vocabulary, $changed_term) { $tree = taxonomy_get_tree($vocabulary->vid); $hierarchy = 0; foreach ($tree as $term) { // Update the changed term with the new parent value before comparison. if ($term->tid == $changed_term['tid']) { $term = (object) $changed_term; $term->parents = $term->parent; } // Check this term's parent count. if (count($term->parents) > 1) { $hierarchy = 2; break; } elseif (count($term->parents) == 1 && 0 !== array_shift($term->parents)) { $hierarchy = 1; } } if ($hierarchy != $vocabulary->hierarchy) { $vocabulary->hierarchy = $hierarchy; taxonomy_vocabulary_save($vocabulary); } return $hierarchy; } /** * Save a term object to the database. * * @param $term * A term object. * @return * Status constant indicating if term was inserted or updated. */ function taxonomy_term_save($term) { // Prevent leading and trailing spaces in term names. $term->name = trim($term->name); if (!isset($term->vocabulary_machine_name)) { $vocabulary = taxonomy_vocabulary_load($term->vid); $term->vocabulary_machine_name = $vocabulary->machine_name; } // Load the stored entity, if any. if (!empty($term->tid) && !isset($term->original)) { $term->original = entity_load_unchanged('taxonomy_term', $term->tid); } field_attach_presave('taxonomy_term', $term); module_invoke_all('taxonomy_term_presave', $term); module_invoke_all('entity_presave', $term, 'taxonomy_term'); if (empty($term->tid)) { $op = 'insert'; $status = drupal_write_record('taxonomy_term_data', $term); field_attach_insert('taxonomy_term', $term); if (!isset($term->parent)) { $term->parent = array(0); } } else { $op = 'update'; $status = drupal_write_record('taxonomy_term_data', $term, 'tid'); field_attach_update('taxonomy_term', $term); if (isset($term->parent)) { db_delete('taxonomy_term_hierarchy') ->condition('tid', $term->tid) ->execute(); } } if (isset($term->parent)) { if (!is_array($term->parent)) { $term->parent = array($term->parent); } $query = db_insert('taxonomy_term_hierarchy') ->fields(array('tid', 'parent')); foreach ($term->parent as $parent) { if (is_array($parent)) { foreach ($parent as $tid) { $query->values(array( 'tid' => $term->tid, 'parent' => $tid )); } } else { $query->values(array( 'tid' => $term->tid, 'parent' => $parent )); } } $query->execute(); } // Reset the taxonomy term static variables. taxonomy_terms_static_reset(); // Invoke the taxonomy hooks. module_invoke_all("taxonomy_term_$op", $term); module_invoke_all("entity_$op", $term, 'taxonomy_term'); unset($term->original); return $status; } /** * Delete a term. * * @param $tid * The term ID. * @return * Status constant indicating deletion. */ function taxonomy_term_delete($tid) { $transaction = db_transaction(); try { $tids = array($tid); while ($tids) { $children_tids = $orphans = array(); foreach ($tids as $tid) { // See if any of the term's children are about to be become orphans: if ($children = taxonomy_get_children($tid)) { foreach ($children as $child) { // If the term has multiple parents, we don't delete it. $parents = taxonomy_get_parents($child->tid); if (count($parents) == 1) { $orphans[] = $child->tid; } } } if ($term = taxonomy_term_load($tid)) { db_delete('taxonomy_term_data') ->condition('tid', $tid) ->execute(); db_delete('taxonomy_term_hierarchy') ->condition('tid', $tid) ->execute(); field_attach_delete('taxonomy_term', $term); module_invoke_all('taxonomy_term_delete', $term); module_invoke_all('entity_delete', $term, 'taxonomy_term'); taxonomy_terms_static_reset(); } } $tids = $orphans; } return SAVED_DELETED; } catch (Exception $e) { $transaction->rollback(); watchdog_exception('taxonomy', $e); throw $e; } } /** * Generate an array for rendering the given term. * * @param $term * A term object. * @param $view_mode * View mode, e.g. 'full', 'teaser'... * @param $langcode * (optional) A language code to use for rendering. Defaults to the global * content language of the current request. * * @return * An array as expected by drupal_render(). */ function taxonomy_term_view($term, $view_mode = 'full', $langcode = NULL) { if (!isset($langcode)) { $langcode = $GLOBALS['language_content']->language; } field_attach_prepare_view('taxonomy_term', array($term->tid => $term), $view_mode); entity_prepare_view('taxonomy_term', array($term->tid => $term)); $build = array( '#theme' => 'taxonomy_term', '#term' => $term, '#view_mode' => $view_mode, '#language' => $langcode, ); $build += field_attach_view('taxonomy_term', $term, $view_mode, $langcode); $build['description'] = array( '#markup' => check_markup($term->description, $term->format, '', TRUE), '#weight' => 0, '#prefix' => '
', '#suffix' => '
', ); $build['#attached']['css'][] = drupal_get_path('module', 'taxonomy') . '/taxonomy.css'; // Allow modules to modify the structured term. $type = 'taxonomy_term'; drupal_alter(array('taxonomy_term_view', 'entity_view'), $build, $type); return $build; } /** * Process variables for taxonomy-term.tpl.php. */ function template_preprocess_taxonomy_term(&$variables) { $variables['view_mode'] = $variables['elements']['#view_mode']; $variables['term'] = $variables['elements']['#term']; $term = $variables['term']; $uri = entity_uri('taxonomy_term', $term); $variables['term_url'] = url($uri['path'], $uri['options']); $variables['term_name'] = check_plain($term->name); $variables['page'] = $variables['view_mode'] == 'full' && taxonomy_term_is_page($term); // Flatten the term object's member fields. $variables = array_merge((array) $term, $variables); // Helpful $content variable for templates. foreach (element_children($variables['elements']) as $key) { $variables['content'][$key] = $variables['elements'][$key]; } // field_attach_preprocess() overwrites the $[field_name] variables with the // values of the field in the language that was selected for display, instead // of the raw values in $term->[field_name], which contain all values in all // languages. field_attach_preprocess('taxonomy_term', $term, $variables['content'], $variables); // Gather classes, and clean up name so there are no underscores. $vocabulary_name_css = str_replace('_', '-', $term->vocabulary_machine_name); $variables['classes_array'][] = 'vocabulary-' . $vocabulary_name_css; $variables['theme_hook_suggestions'][] = 'taxonomy_term__' . $term->vocabulary_machine_name; $variables['theme_hook_suggestions'][] = 'taxonomy_term__' . $term->tid; } /** * Returns whether the current page is the page of the passed in term. * * @param $term * A term object. */ function taxonomy_term_is_page($term) { $page_term = menu_get_object('taxonomy_term', 2); return (!empty($page_term) ? $page_term->tid == $term->tid : FALSE); } /** * Clear all static cache variables for terms.. */ function taxonomy_terms_static_reset() { drupal_static_reset('taxonomy_term_count_nodes'); drupal_static_reset('taxonomy_get_tree'); drupal_static_reset('taxonomy_get_tree:parents'); drupal_static_reset('taxonomy_get_tree:terms'); drupal_static_reset('taxonomy_get_parents'); drupal_static_reset('taxonomy_get_parents_all'); drupal_static_reset('taxonomy_get_children'); entity_get_controller('taxonomy_term')->resetCache(); } /** * Return an array of all vocabulary objects. * * @return * An array of all vocabulary objects, indexed by vid. */ function taxonomy_get_vocabularies() { return taxonomy_vocabulary_load_multiple(FALSE, array()); } /** * Get names for all taxonomy vocabularies. * * @return * An array of vocabulary ids, names, machine names, keyed by machine name. */ function taxonomy_vocabulary_get_names() { $names = db_query('SELECT name, machine_name, vid FROM {taxonomy_vocabulary}')->fetchAllAssoc('machine_name'); return $names; } /** * Finds all parents of a given term ID. * * @param $tid * A taxonomy term ID. * * @return * An array of term objects which are the parents of the term $tid. */ function taxonomy_get_parents($tid) { $parents = &drupal_static(__FUNCTION__, array()); if ($tid && !isset($parents[$tid])) { $query = db_select('taxonomy_term_data', 't'); $query->join('taxonomy_term_hierarchy', 'h', 'h.parent = t.tid'); $query->addField('t', 'tid'); $query->condition('h.tid', $tid); $query->addTag('term_access'); $query->orderBy('t.weight'); $query->orderBy('t.name'); $tids = $query->execute()->fetchCol(); $parents[$tid] = taxonomy_term_load_multiple($tids); } return isset($parents[$tid]) ? $parents[$tid] : array(); } /** * Find all ancestors of a given term ID. */ function taxonomy_get_parents_all($tid) { $cache = &drupal_static(__FUNCTION__, array()); if (isset($cache[$tid])) { return $cache[$tid]; } $parents = array(); if ($term = taxonomy_term_load($tid)) { $parents[] = $term; $n = 0; while ($parent = taxonomy_get_parents($parents[$n]->tid)) { $parents = array_merge($parents, $parent); $n++; } } $cache[$tid] = $parents; return $parents; } /** * Finds all children of a term ID. * * @param $tid * A taxonomy term ID. * @param $vid * An optional vocabulary ID to restrict the child search. * * @return * An array of term objects which are the children of the term $tid. */ function taxonomy_get_children($tid, $vid = 0) { $children = &drupal_static(__FUNCTION__, array()); if ($tid && !isset($children[$tid])) { $query = db_select('taxonomy_term_data', 't'); $query->join('taxonomy_term_hierarchy', 'h', 'h.tid = t.tid'); $query->addField('t', 'tid'); $query->condition('h.parent', $tid); if ($vid) { $query->condition('t.vid', $vid); } $query->addTag('term_access'); $query->orderBy('t.weight'); $query->orderBy('t.name'); $tids = $query->execute()->fetchCol(); $children[$tid] = taxonomy_term_load_multiple($tids); } return isset($children[$tid]) ? $children[$tid] : array(); } /** * Create a hierarchical representation of a vocabulary. * * @param $vid * Which vocabulary to generate the tree for. * @param $parent * The term ID under which to generate the tree. If 0, generate the tree * for the entire vocabulary. * @param $max_depth * The number of levels of the tree to return. Leave NULL to return all levels. * @param $load_entities * If TRUE, a full entity load will occur on the term objects. Otherwise they * are partial objects queried directly from the {taxonomy_term_data} table to * save execution time and memory consumption when listing large numbers of * terms. Defaults to FALSE. * * @return * An array of all term objects in the tree. Each term object is extended * to have "depth" and "parents" attributes in addition to its normal ones. * Results are statically cached. Term objects will be partial or complete * depending on the $load_entities parameter. */ function taxonomy_get_tree($vid, $parent = 0, $max_depth = NULL, $load_entities = FALSE) { $children = &drupal_static(__FUNCTION__, array()); $parents = &drupal_static(__FUNCTION__ . ':parents', array()); $terms = &drupal_static(__FUNCTION__ . ':terms', array()); // We cache trees, so it's not CPU-intensive to call get_tree() on a term // and its children, too. if (!isset($children[$vid])) { $children[$vid] = array(); $parents[$vid] = array(); $terms[$vid] = array(); $query = db_select('taxonomy_term_data', 't'); $query->join('taxonomy_term_hierarchy', 'h', 'h.tid = t.tid'); $result = $query ->addTag('translatable') ->addTag('term_access') ->fields('t') ->fields('h', array('parent')) ->condition('t.vid', $vid) ->orderBy('t.weight') ->orderBy('t.name') ->execute(); foreach ($result as $term) { $children[$vid][$term->parent][] = $term->tid; $parents[$vid][$term->tid][] = $term->parent; $terms[$vid][$term->tid] = $term; } } // Load full entities, if necessary. The entity controller statically // caches the results. if ($load_entities) { $term_entities = taxonomy_term_load_multiple(array_keys($terms[$vid])); } $max_depth = (!isset($max_depth)) ? count($children[$vid]) : $max_depth; $tree = array(); // Keeps track of the parents we have to process, the last entry is used // for the next processing step. $process_parents = array(); $process_parents[] = $parent; // Loops over the parent terms and adds its children to the tree array. // Uses a loop instead of a recursion, because it's more efficient. while (count($process_parents)) { $parent = array_pop($process_parents); // The number of parents determines the current depth. $depth = count($process_parents); if ($max_depth > $depth && !empty($children[$vid][$parent])) { $has_children = FALSE; $child = current($children[$vid][$parent]); do { if (empty($child)) { break; } $term = $load_entities ? $term_entities[$child] : $terms[$vid][$child]; if (count($parents[$vid][$term->tid]) > 1) { // We have a term with multi parents here. Clone the term, // so that the depth attribute remains correct. $term = clone $term; } $term->depth = $depth; unset($term->parent); $term->parents = $parents[$vid][$term->tid]; $tree[] = $term; if (!empty($children[$vid][$term->tid])) { $has_children = TRUE; // We have to continue with this parent later. $process_parents[] = $parent; // Use the current term as parent for the next iteration. $process_parents[] = $term->tid; // Reset pointers for child lists because we step in there more often // with multi parents. reset($children[$vid][$term->tid]); // Move pointer so that we get the correct term the next time. next($children[$vid][$parent]); break; } } while ($child = next($children[$vid][$parent])); if (!$has_children) { // We processed all terms in this hierarchy-level, reset pointer // so that this function works the next time it gets called. reset($children[$vid][$parent]); } } } return $tree; } /** * Try to map a string to an existing term, as for glossary use. * * Provides a case-insensitive and trimmed mapping, to maximize the * likelihood of a successful match. * * @param name * Name of the term to search for. * * @return * An array of matching term objects. */ function taxonomy_get_term_by_name($name) { return taxonomy_term_load_multiple(array(), array('name' => trim($name))); } /** * Controller class for taxonomy terms. * * This extends the DrupalDefaultEntityController class. Only alteration is * that we match the condition on term name case-independently. */ class TaxonomyTermController extends DrupalDefaultEntityController { protected function buildQuery($ids, $conditions = array(), $revision_id = FALSE) { $query = parent::buildQuery($ids, $conditions, $revision_id); $query->addTag('translatable'); $query->addTag('term_access'); // When name is passed as a condition use LIKE. if (isset($conditions['name'])) { $query_conditions = &$query->conditions(); foreach ($query_conditions as $key => $condition) { if ($condition['field'] == 'base.name') { $query_conditions[$key]['operator'] = 'LIKE'; $query_conditions[$key]['value'] = db_like($query_conditions[$key]['value']); } } } // Add the machine name field from the {taxonomy_vocabulary} table. $query->innerJoin('taxonomy_vocabulary', 'v', 'base.vid = v.vid'); $query->addField('v', 'machine_name', 'vocabulary_machine_name'); return $query; } protected function cacheGet($ids, $conditions = array()) { $terms = parent::cacheGet($ids, $conditions); // Name matching is case insensitive, note that with some collations // LOWER() and drupal_strtolower() may return different results. foreach ($terms as $term) { $term_values = (array) $term; if (isset($conditions['name']) && drupal_strtolower($conditions['name'] != drupal_strtolower($term_values['name']))) { unset($terms[$term->tid]); } } return $terms; } } /** * Controller class for taxonomy vocabularies. * * This extends the DrupalDefaultEntityController class, adding required * special handling for taxonomy vocabulary objects. */ class TaxonomyVocabularyController extends DrupalDefaultEntityController { protected function buildQuery($ids, $conditions = array(), $revision_id = FALSE) { $query = parent::buildQuery($ids, $conditions, $revision_id); $query->addTag('translatable'); $query->orderBy('base.weight'); $query->orderBy('base.name'); return $query; } } /** * Load multiple taxonomy terms based on certain conditions. * * This function should be used whenever you need to load more than one term * from the database. Terms are loaded into memory and will not require * database access if loaded again during the same page request. * * @see entity_load() * @see EntityFieldQuery * * @param $tids * An array of taxonomy term IDs. * @param $conditions * (deprecated) An associative array of conditions on the {taxonomy_term} * table, where the keys are the database fields and the values are the * values those fields must have. Instead, it is preferable to use * EntityFieldQuery to retrieve a list of entity IDs loadable by * this function. * * @return * An array of term objects, indexed by tid. * * @todo Remove $conditions in Drupal 8. */ function taxonomy_term_load_multiple($tids = array(), $conditions = array()) { return entity_load('taxonomy_term', $tids, $conditions); } /** * Load multiple taxonomy vocabularies based on certain conditions. * * This function should be used whenever you need to load more than one * vocabulary from the database. Terms are loaded into memory and will not * require database access if loaded again during the same page request. * * @see entity_load() * * @param $vids * An array of taxonomy vocabulary IDs, or FALSE to load all vocabularies. * @param $conditions * An array of conditions to add to the query. * * @return * An array of vocabulary objects, indexed by vid. */ function taxonomy_vocabulary_load_multiple($vids = array(), $conditions = array()) { return entity_load('taxonomy_vocabulary', $vids, $conditions); } /** * Return the vocabulary object matching a vocabulary ID. * * @param $vid * The vocabulary's ID. * * @return * The vocabulary object with all of its metadata, if exists, FALSE otherwise. * Results are statically cached. */ function taxonomy_vocabulary_load($vid) { $vocabularies = taxonomy_vocabulary_load_multiple(array($vid)); return reset($vocabularies); } /** * Return the vocabulary object matching a vocabulary machine name. * * @param $name * The vocabulary's machine name. * * @return * The vocabulary object with all of its metadata, if exists, FALSE otherwise. * Results are statically cached. */ function taxonomy_vocabulary_machine_name_load($name) { $vocabularies = taxonomy_vocabulary_load_multiple(NULL, array('machine_name' => $name)); return reset($vocabularies); } /** * Return the term object matching a term ID. * * @param $tid * A term's ID * * @return * A term object. Results are statically cached. */ function taxonomy_term_load($tid) { if (!is_numeric($tid)) { return FALSE; } $term = taxonomy_term_load_multiple(array($tid), array()); return $term ? $term[$tid] : FALSE; } /** * Helper function for array_map purposes. */ function _taxonomy_get_tid_from_term($term) { return $term->tid; } /** * Implodes a list of tags of a certain vocabulary into a string. * * @see drupal_explode_tags() */ function taxonomy_implode_tags($tags, $vid = NULL) { $typed_tags = array(); foreach ($tags as $tag) { // Extract terms belonging to the vocabulary in question. if (!isset($vid) || $tag->vid == $vid) { // Make sure we have a completed loaded taxonomy term. if (isset($tag->name)) { // Commas and quotes in tag names are special cases, so encode 'em. if (strpos($tag->name, ',') !== FALSE || strpos($tag->name, '"') !== FALSE) { $tag->name = '"' . str_replace('"', '""', $tag->name) . '"'; } $typed_tags[] = $tag->name; } } } return implode(', ', $typed_tags); } /** * Implements hook_field_info(). * * Field settings: * - allowed_values: a list array of one or more vocabulary trees: * - vocabulary: a vocabulary machine name. * - parent: a term ID of a term whose children are allowed. This should be * '0' if all terms in a vocabulary are allowed. The allowed values do not * include the parent term. * */ function taxonomy_field_info() { return array( 'taxonomy_term_reference' => array( 'label' => t('Term reference'), 'description' => t('This field stores a reference to a taxonomy term.'), 'default_widget' => 'options_select', 'default_formatter' => 'taxonomy_term_reference_link', 'settings' => array( 'allowed_values' => array( array( 'vocabulary' => '', 'parent' => '0', ), ), ), ), ); } /** * Implements hook_field_widget_info(). */ function taxonomy_field_widget_info() { return array( 'taxonomy_autocomplete' => array( 'label' => t('Autocomplete term widget (tagging)'), 'field types' => array('taxonomy_term_reference'), 'settings' => array( 'size' => 60, 'autocomplete_path' => 'taxonomy/autocomplete', ), 'behaviors' => array( 'multiple values' => FIELD_BEHAVIOR_CUSTOM, ), ), ); } /** * Implements hook_field_widget_info_alter(). */ function taxonomy_field_widget_info_alter(&$info) { $info['options_select']['field types'][] = 'taxonomy_term_reference'; $info['options_buttons']['field types'][] = 'taxonomy_term_reference'; } /** * Implements hook_options_list(). */ function taxonomy_options_list($field) { $function = !empty($field['settings']['options_list_callback']) ? $field['settings']['options_list_callback'] : 'taxonomy_allowed_values'; return $function($field); } /** * Implements hook_field_validate(). * * Taxonomy field settings allow for either a single vocabulary ID, multiple * vocabulary IDs, or sub-trees of a vocabulary to be specified as allowed * values, although only the first of these is supported via the field UI. * Confirm that terms entered as values meet at least one of these conditions. * * Possible error codes: * - 'taxonomy_term_illegal_value': The value is not part of the list of allowed values. */ function taxonomy_field_validate($entity_type, $entity, $field, $instance, $langcode, $items, &$errors) { // Build an array of existing term IDs so they can be loaded with // taxonomy_term_load_multiple(); foreach ($items as $delta => $item) { if (!empty($item['tid']) && $item['tid'] != 'autocreate') { $tids[] = $item['tid']; } } if (!empty($tids)) { $terms = taxonomy_term_load_multiple($tids); // Check each existing item to ensure it can be found in the // allowed values for this field. foreach ($items as $delta => $item) { $validate = TRUE; if (!empty($item['tid']) && $item['tid'] != 'autocreate') { $validate = FALSE; foreach ($field['settings']['allowed_values'] as $settings) { // If no parent is specified, check if the term is in the vocabulary. if (isset($settings['vocabulary']) && empty($settings['parent'])) { if ($settings['vocabulary'] == $terms[$item['tid']]->vocabulary_machine_name) { $validate = TRUE; break; } } // If a parent is specified, then to validate it must appear in the // array returned by taxonomy_get_parents_all(). elseif (!empty($settings['parent'])) { $ancestors = taxonomy_get_parents_all($item['tid']); foreach ($ancestors as $ancestor) { if ($ancestor->tid == $settings['parent']) { $validate = TRUE; break 2; } } } } } if (!$validate) { $errors[$field['field_name']][$langcode][$delta][] = array( 'error' => 'taxonomy_term_reference_illegal_value', 'message' => t('%name: illegal value.', array('%name' => t($instance['label']))), ); } } } } /** * Implements hook_field_is_empty(). */ function taxonomy_field_is_empty($item, $field) { if (!is_array($item) || (empty($item['tid']) && (string) $item['tid'] !== '0')) { return TRUE; } return FALSE; } /** * Implements hook_field_formatter_info(). */ function taxonomy_field_formatter_info() { return array( 'taxonomy_term_reference_link' => array( 'label' => t('Link'), 'field types' => array('taxonomy_term_reference'), ), 'taxonomy_term_reference_plain' => array( 'label' => t('Plain text'), 'field types' => array('taxonomy_term_reference'), ), ); } /** * Implements hook_field_formatter_view(). */ function taxonomy_field_formatter_view($entity_type, $entity, $field, $instance, $langcode, $items, $display) { $element = array(); // Terms whose tid is 'autocreate' do not exist // yet and $item['taxonomy_term'] is not set. Theme such terms as // just their name. switch ($display['type']) { case 'taxonomy_term_reference_link': foreach ($items as $delta => $item) { if ($item['tid'] == 'autocreate') { $element[$delta] = array( '#markup' => check_plain($item['name']), ); } else { $term = $item['taxonomy_term']; $uri = entity_uri('taxonomy_term', $term); $element[$delta] = array( '#type' => 'link', '#title' => $term->name, '#href' => $uri['path'], '#options' => $uri['options'], ); } } break; case 'taxonomy_term_reference_plain': foreach ($items as $delta => $item) { $name = ($item['tid'] != 'autocreate' ? $item['taxonomy_term']->name : $item['name']); $element[$delta] = array( '#markup' => check_plain($name), ); } break; } return $element; } /** * Returns the set of valid terms for a taxonomy field. * * @param $field * The field definition. * @return * The array of valid terms for this field, keyed by term id. */ function taxonomy_allowed_values($field) { $options = array(); foreach ($field['settings']['allowed_values'] as $tree) { if ($vocabulary = taxonomy_vocabulary_machine_name_load($tree['vocabulary'])) { if ($terms = taxonomy_get_tree($vocabulary->vid, $tree['parent'])) { foreach ($terms as $term) { $options[$term->tid] = str_repeat('-', $term->depth) . $term->name; } } } } return $options; } /** * Implements hook_field_formatter_prepare_view(). * * This preloads all taxonomy terms for multiple loaded objects at once and * unsets values for invalid terms that do not exist. */ function taxonomy_field_formatter_prepare_view($entity_type, $entities, $field, $instances, $langcode, &$items, $displays) { $tids = array(); // Collect every possible term attached to any of the fieldable entities. foreach ($entities as $id => $entity) { foreach ($items[$id] as $delta => $item) { // Force the array key to prevent duplicates. if ($item['tid'] != 'autocreate') { $tids[$item['tid']] = $item['tid']; } } } if ($tids) { $terms = taxonomy_term_load_multiple($tids); // Iterate through the fieldable entities again to attach the loaded term data. foreach ($entities as $id => $entity) { $rekey = FALSE; foreach ($items[$id] as $delta => $item) { // Check whether the taxonomy term field instance value could be loaded. if (isset($terms[$item['tid']])) { // Replace the instance value with the term data. $items[$id][$delta]['taxonomy_term'] = $terms[$item['tid']]; } // Terms to be created are not in $terms, but are still legitimate. else if ($item['tid'] == 'autocreate') { // Leave the item in place. } // Otherwise, unset the instance value, since the term does not exist. else { unset($items[$id][$delta]); $rekey = TRUE; } } if ($rekey) { // Rekey the items array. $items[$id] = array_values($items[$id]); } } } } /** * Title callback for term pages. * * @param $term * A term object. * * @return * The term name to be used as the page title. */ function taxonomy_term_title($term) { return $term->name; } /** * Implements hook_field_widget_form(). */ function taxonomy_field_widget_form(&$form, &$form_state, $field, $instance, $langcode, $items, $delta, $element) { $tags = array(); foreach ($items as $item) { $tags[$item['tid']] = isset($item['taxonomy_term']) ? $item['taxonomy_term'] : taxonomy_term_load($item['tid']); } $element += array( '#type' => 'textfield', '#default_value' => taxonomy_implode_tags($tags), '#autocomplete_path' => $instance['widget']['settings']['autocomplete_path'] . '/' . $field['field_name'], '#size' => $instance['widget']['settings']['size'], '#maxlength' => 1024, '#element_validate' => array('taxonomy_autocomplete_validate'), ); return $element; } /** * Form element validate handler for taxonomy term autocomplete element. */ function taxonomy_autocomplete_validate($element, &$form_state) { // Autocomplete widgets do not send their tids in the form, so we must detect // them here and process them independently. $value = array(); if ($tags = $element['#value']) { // Collect candidate vocabularies. $field = field_widget_field($element, $form_state); $vocabularies = array(); foreach ($field['settings']['allowed_values'] as $tree) { if ($vocabulary = taxonomy_vocabulary_machine_name_load($tree['vocabulary'])) { $vocabularies[$vocabulary->vid] = $vocabulary; } } // Translate term names into actual terms. $typed_terms = drupal_explode_tags($tags); foreach ($typed_terms as $typed_term) { // See if the term exists in the chosen vocabulary and return the tid; // otherwise, create a new 'autocreate' term for insert/update. if ($possibilities = taxonomy_term_load_multiple(array(), array('name' => trim($typed_term), 'vid' => array_keys($vocabularies)))) { $term = array_pop($possibilities); } else { $vocabulary = reset($vocabularies); $term = array( 'tid' => 'autocreate', 'vid' => $vocabulary->vid, 'name' => $typed_term, 'vocabulary_machine_name' => $vocabulary->machine_name, ); } $value[] = (array)$term; } } form_set_value($element, $value, $form_state); } /** * Implements hook_field_widget_error(). */ function taxonomy_field_widget_error($element, $error, $form, &$form_state) { form_error($element, $error['message']); } /** * Implements hook_field_settings_form(). */ function taxonomy_field_settings_form($field, $instance, $has_data) { // Get proper values for 'allowed_values_function', which is a core setting. $vocabularies = taxonomy_get_vocabularies(); $options = array(); foreach ($vocabularies as $vocabulary) { $options[$vocabulary->machine_name] = $vocabulary->name; } $form['allowed_values'] = array( '#tree' => TRUE, ); foreach ($field['settings']['allowed_values'] as $delta => $tree) { $form['allowed_values'][$delta]['vocabulary'] = array( '#type' => 'select', '#title' => t('Vocabulary'), '#default_value' => $tree['vocabulary'], '#options' => $options, '#required' => TRUE, '#description' => t('The vocabulary which supplies the options for this field.'), '#disabled' => $has_data, ); $form['allowed_values'][$delta]['parent'] = array( '#type' => 'value', '#value' => $tree['parent'], ); } return $form; } /** * Implements hook_rdf_mapping(). * * @return array * The rdf mapping for vocabularies and terms. */ function taxonomy_rdf_mapping() { return array( array( 'type' => 'taxonomy_term', 'bundle' => RDF_DEFAULT_BUNDLE, 'mapping' => array( 'rdftype' => array('skos:Concept'), 'name' => array( 'predicates' => array('rdfs:label', 'skos:prefLabel'), ), 'description' => array( 'predicates' => array('skos:definition'), ), 'vid' => array( 'predicates' => array('skos:inScheme'), 'type' => 'rel', ), 'parent' => array( 'predicates' => array('skos:broader'), 'type' => 'rel', ), ), ), array( 'type' => 'taxonomy_vocabulary', 'bundle' => RDF_DEFAULT_BUNDLE, 'mapping' => array( 'rdftype' => array('skos:ConceptScheme'), 'name' => array( 'predicates' => array('dc:title'), ), 'description' => array( 'predicates' => array('rdfs:comment'), ), ), ), ); } /** * @defgroup taxonomy_index Taxonomy indexing * @{ * Functions to maintain taxonomy indexing. * * Taxonomy uses default field storage to store canonical relationships * between terms and fieldable entities. However its most common use case * requires listing all content associated with a term or group of terms * sorted by creation date. To avoid slow queries due to joining across * multiple node and field tables with various conditions and order by criteria, * we maintain a denormalized table with all relationships between terms, * published nodes and common sort criteria such as sticky and created. * This is used as a lookup table by taxonomy_select_nodes(). When using other * field storage engines or alternative methods of denormalizing this data * you should set the variable 'taxonomy_maintain_index_table' to FALSE * to avoid unnecessary writes in SQL. */ /** * Implements hook_field_presave(). * * Create any new terms defined in a freetagging vocabulary. */ function taxonomy_field_presave($entity_type, $entity, $field, $instance, $langcode, &$items) { foreach ($items as $delta => $item) { if ($item['tid'] == 'autocreate') { $term = (object) $item; unset($term->tid); taxonomy_term_save($term); $items[$delta]['tid'] = $term->tid; } } } /** * Implements hook_field_insert(). */ function taxonomy_field_insert($entity_type, $entity, $field, $instance, $langcode, &$items) { // We maintain a denormalized table of term/node relationships, containing // only data for current, published nodes. if (variable_get('taxonomy_maintain_index_table', TRUE) && $field['storage']['type'] == 'field_sql_storage' && $entity_type == 'node' && $entity->status) { $query = db_insert('taxonomy_index')->fields(array('nid', 'tid', 'sticky', 'created', )); foreach ($items as $item) { $query->values(array( 'nid' => $entity->nid, 'tid' => $item['tid'], 'sticky' => $entity->sticky, 'created' => $entity->created, )); } $query->execute(); } } /** * Implements hook_field_update(). */ function taxonomy_field_update($entity_type, $entity, $field, $instance, $langcode, &$items) { if (variable_get('taxonomy_maintain_index_table', TRUE) && $field['storage']['type'] == 'field_sql_storage' && $entity_type == 'node') { $first_call = &drupal_static(__FUNCTION__, array()); // We don't maintain data for old revisions, so clear all previous values // from the table. Since this hook runs once per field, per object, make // sure we only wipe values once. if (!isset($first_call[$entity->nid])) { $first_call[$entity->nid] = FALSE; db_delete('taxonomy_index')->condition('nid', $entity->nid)->execute(); } // Only save data to the table if the node is published. if ($entity->status) { $query = db_insert('taxonomy_index')->fields(array('nid', 'tid', 'sticky', 'created')); foreach ($items as $item) { $query->values(array( 'nid' => $entity->nid, 'tid' => $item['tid'], 'sticky' => $entity->sticky, 'created' => $entity->created, )); } $query->execute(); } } } /** * Implements hook_node_delete(). */ function taxonomy_node_delete($node) { if (variable_get('taxonomy_maintain_index_table', TRUE)) { // Clean up the {taxonomy_index} table when nodes are deleted. db_delete('taxonomy_index')->condition('nid', $node->nid)->execute(); } } /** * Implements hook_taxonomy_term_delete(). */ function taxonomy_taxonomy_term_delete($term) { if (variable_get('taxonomy_maintain_index_table', TRUE)) { // Clean up the {taxonomy_index} table when terms are deleted. db_delete('taxonomy_index')->condition('tid', $term->tid)->execute(); } } /** * @} End of "defgroup taxonomy_index" */