function content_taxonomy_et_autocomplete in Content Taxonomy 7

Replacement for taxonomy_autocomplete().

Adds an additional left join to the translatable title field.

1 string reference to 'content_taxonomy_et_autocomplete'

content_taxonomy_et_menu_alter in ./content_taxonomy_et.module

Implements hook_menu_alter().

File

./content_taxonomy_et.module, line 207

Entity Translation integration for taxonomy terms.

Code

function content_taxonomy_et_autocomplete($field_name = '', $tags_typed = '') {
  global $language;

  // If the request has a '/' in the search text, then the menu system will have
  // split it into multiple arguments, recover the intended $tags_typed.
  $args = func_get_args();

  // Shift off the $field_name argument.
  array_shift($args);
  $tags_typed = implode('/', $args);

  // Make sure the field exists and is a taxonomy field.
  if (!($field = field_info_field($field_name)) || $field['type'] !== 'taxonomy_term_reference') {

    // Error string. The JavaScript handler will realize this is not JSON and
    // will display it as debugging information.
    print t('Taxonomy field @field_name not found.', array(
      '@field_name' => $field_name,
    ));
    exit;
  }

  // The user enters a comma-separated list of tags. We only autocomplete the last tag.
  $tags_typed = drupal_explode_tags($tags_typed);
  $tag_last = drupal_strtolower(array_pop($tags_typed));
  $term_matches = array();
  if ($tag_last != '') {

    // Part of the criteria for the query come from the field's own settings.
    $vids = array();
    $vocabularies = taxonomy_vocabulary_get_names();
    foreach ($field['settings']['allowed_values'] as $tree) {
      $vids[] = $vocabularies[$tree['vocabulary']]->vid;
    }
    $query = db_select('taxonomy_term_data', 't');
    $query
      ->addTag('translatable');
    $query
      ->addTag('term_access');
    $query
      ->leftJoin('field_data_name_field', 'fd', 'fd.entity_id = t.tid AND fd.entity_type = :type AND fd.language = :language', array(
      ':type' => 'taxonomy_term',
      ':language' => $language->language,
    ));

    // Do not select already entered terms.
    if (!empty($tags_typed)) {
      $query
        ->condition('t.name', $tags_typed, 'NOT IN');
    }

    // Select rows that match by term name.
    $tags_return = $query
      ->fields('t', array(
      'tid',
      'name',
    ))
      ->fields('fd', array(
      'name_field_value',
    ))
      ->condition('t.vid', $vids)
      ->condition(db_or()
      ->condition('t.name', '%' . db_like($tag_last) . '%', 'LIKE')
      ->condition('fd.name_field_value', '%' . db_like($tag_last) . '%', 'LIKE'))
      ->range(0, 10)
      ->execute();
    $prefix = count($tags_typed) ? drupal_implode_tags($tags_typed) . ', ' : '';
    foreach ($tags_return as $record) {
      $name = !empty($record->name_field_value) ? $record->name_field_value : $record->name;
      $n = $name;

      // Term names containing commas or quotes must be wrapped in quotes.
      if (strpos($name, ',') !== FALSE || strpos($name, '"') !== FALSE) {
        $n = '"' . str_replace('"', '""', $name) . '"';
      }
      $term_matches[$prefix . $n] = check_plain($name);
    }
  }
  drupal_json_output($term_matches);
}