taxonomy.module 49 KB
Newer Older
Dries's avatar
 
Dries committed
1
<?php
Kjartan's avatar
Kjartan committed
2
// $Id$
Dries's avatar
   
Dries committed
3

Dries's avatar
   
Dries committed
4
5
6
7
8
/**
 * @file
 * Enables the organization of content into categories.
 */

Dries's avatar
   
Dries committed
9
10
11
/**
 * Implementation of hook_perm().
 */
Kjartan's avatar
Kjartan committed
12
function taxonomy_perm() {
Dries's avatar
   
Dries committed
13
  return array('administer taxonomy');
Kjartan's avatar
Kjartan committed
14
}
Dries's avatar
 
Dries committed
15

Dries's avatar
   
Dries committed
16
17
18
19
20
21
22
23
24
25
26
/**
 * Implementation of hook_link().
 *
 * This hook is extended with $type = 'taxonomy terms' to allow themes to
 * print lists of terms associated with a node. Themes can print taxonomy
 * links with:
 *
 * if (module_exist('taxonomy')) {
 *   $this->links(taxonomy_link('taxonomy terms', $node));
 * }
 */
Dries's avatar
   
Dries committed
27
function taxonomy_link($type, $node = NULL) {
Dries's avatar
   
Dries committed
28
  if ($type == 'taxonomy terms' && $node != NULL) {
Kjartan's avatar
   
Kjartan committed
29
    $links = array();
Dries's avatar
   
Dries committed
30
    if (array_key_exists('taxonomy', $node)) {
31
      foreach ($node->taxonomy as $term) {
32
        $links[] = l($term->name, taxonomy_term_path($term), array('rel' => 'tag', 'title' => $term->description));
Dries's avatar
   
Dries committed
33
      }
Dries's avatar
   
Dries committed
34
35
36
    }
    return $links;
  }
Kjartan's avatar
Kjartan committed
37
38
}

39
40
41
42
43
44
45
46
function taxonomy_term_path($term) {
  $vocabulary = taxonomy_get_vocabulary($term->vid);
  if ($vocabulary->module != 'taxonomy' && $path = module_invoke($vocabulary->module, 'term_path', $term)) {
    return $path;
  }
  return 'taxonomy/term/'. $term->tid;
}

Dries's avatar
   
Dries committed
47
48
49
/**
 * Implementation of hook_menu().
 */
Dries's avatar
   
Dries committed
50
function taxonomy_menu($may_cache) {
Dries's avatar
   
Dries committed
51
  $items = array();
Dries's avatar
   
Dries committed
52

Dries's avatar
   
Dries committed
53
54
55
56
  if ($may_cache) {
    $items[] = array('path' => 'admin/taxonomy', 'title' => t('categories'),
      'callback' => 'taxonomy_admin',
      'access' => user_access('administer taxonomy'));
57

Dries's avatar
   
Dries committed
58
59
    $items[] = array('path' => 'admin/taxonomy/list', 'title' => t('list'),
      'type' => MENU_DEFAULT_LOCAL_TASK, 'weight' => -10);
60

Dries's avatar
   
Dries committed
61
62
63
64
65
    $items[] = array('path' => 'admin/taxonomy/add/vocabulary', 'title' => t('add vocabulary'),
      'callback' => 'taxonomy_admin',
      'access' => user_access('administer taxonomy'),
      'type' => MENU_LOCAL_TASK);

66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
    $items[] = array('path' => 'admin/taxonomy/edit/vocabulary', 'title' => t('edit vocabulary'),
      'callback' => 'taxonomy_admin',
      'access' => user_access('administer taxonomy'),
      'type' => MENU_CALLBACK);

    $items[] = array('path' => 'admin/taxonomy/add/term', 'title' => t('add term'),
      'callback' => 'taxonomy_admin',
      'access' => user_access('administer taxonomy'),
      'type' => MENU_CALLBACK);

    $items[] = array('path' => 'admin/taxonomy/edit/term', 'title' => t('edit term'),
      'callback' => 'taxonomy_admin',
      'access' => user_access('administer taxonomy'),
      'type' => MENU_CALLBACK);

Dries's avatar
   
Dries committed
81
82
83
84
    $items[] = array('path' => 'taxonomy/term', 'title' => t('taxonomy term'),
      'callback' => 'taxonomy_term_page',
      'access' => user_access('access content'),
      'type' => MENU_CALLBACK);
Steven Wittens's avatar
Steven Wittens committed
85
86
87
88
89

    $items[] = array('path' => 'taxonomy/autocomplete', 'title' => t('autocomplete taxonomy'),
      'callback' => 'taxonomy_autocomplete',
      'access' => user_access('access content'),
      'type' => MENU_CALLBACK);
Dries's avatar
   
Dries committed
90
  }
Dries's avatar
Dries committed
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
  else {
    if (is_numeric(arg(2))) {
      $items[] = array('path' => 'admin/taxonomy/' . arg(2), 'title' => t('add term'),
        'callback' => 'taxonomy_admin',
        'access' => user_access('administer taxonomy'),
        'type' => MENU_CALLBACK);

      $items[] = array('path' => 'admin/taxonomy/' . arg(2) . '/list', 'title' => t('list'),
        'type' => MENU_DEFAULT_LOCAL_TASK, 'weight' => -10);

      $items[] = array('path' => 'admin/taxonomy/' . arg(2) . '/add/term', 'title' => t('add term'),
        'callback' => 'taxonomy_admin',
        'access' => user_access('administer taxonomy'),
        'type' => MENU_LOCAL_TASK);
    }
  }
Dries's avatar
   
Dries committed
107

Dries's avatar
   
Dries committed
108
109
  return $items;
}
Dries's avatar
 
Dries committed
110

Kjartan's avatar
Kjartan committed
111
function taxonomy_form_vocabulary($edit = array()) {
112
  $form['name'] = array('#type' => 'textfield', '#title' => t('Vocabulary name'), '#default_value' => $edit['name'], '#maxlength' => 64, '#description' => t('The name for this vocabulary.  Example: "Topic".'), '#required' => TRUE);
113

114
115
  $form['description'] = array('#type' => 'textarea', '#title' => t('Description'), '#default_value' => $edit['description'], '#description' => t('Description of the vocabulary; can be used by modules.'));
  $form['help'] = array('#type' => 'textfield', '#title' => t('Help text'), '#default_value' => $edit['help'], '#maxlength' => 255, '#description' => t('Instructions to present to the user when choosing a term.'));
116
117
  $form['nodes'] = array('#type' => 'checkboxes', '#title' => t('Types'), '#default_value' => $edit['nodes'], '#options' => node_get_types(), '#description' => t('A list of node types you want to associate with this vocabulary.'), '#required' => TRUE);
  $form['hierarchy'] = array('#type' => 'radios', '#title' => t('Hierarchy'), '#default_value' => $edit['hierarchy'], '#options' => array(t('Disabled'), t('Single'), t('Multiple')), '#description' => t('Allows <a href="%help-url">a tree-like hierarchy</a> between terms of this vocabulary.', array('%help-url' => url('admin/help/taxonomy', NULL, NULL, 'hierarchy'))));
118
119
120
121
122
  $form['relations'] = array('#type' => 'checkbox', '#title' => t('Related terms'), '#default_value' => $edit['relations'], '#description' => t('Allows <a href="%help-url">related terms</a> in this vocabulary.', array('%help-url' => url('admin/help/taxonomy', NULL, NULL, 'related-terms'))));
  $form['tags'] = array('#type' => 'checkbox', '#title' => t('Free tagging'), '#default_value' => $edit['tags'], '#description' => t('Content is categorized by typing terms instead of choosing from a list.'));
  $form['multiple'] = array('#type' => 'checkbox', '#title' => t('Multiple select'), '#default_value' => $edit['multiple'], '#description' => t('Allows nodes to have more than one term from this vocabulary (always true for free tagging).'));
  $form['required'] = array('#type' => 'checkbox', '#title' => t('Required'), '#default_value' => $edit['required'], '#description' => t('If enabled, every node <strong>must</strong> have at least one term in this vocabulary.'));
  $form['weight'] = array('#type' => 'weight', '#title' => t('Weight'), '#default_value' => $edit['weight'], '#description' => t('In listings, the heavier vocabularies will sink and the lighter vocabularies will be positioned nearer the top.'));
123

124
125
126
127
  // Add extra vocabulary form elements.
  $extra = module_invoke_all('taxonomy', 'form', 'vocabulary');
  if (is_array($extra)) {
    foreach ($extra as $key => $element) {
128
      $extra[$key]['#weight'] = isset($extra[$key]['#weight']) ? $extra[$key]['#weight'] : -18;
129
130
131
    }
    $form = array_merge($form, $extra);
  }
Dries's avatar
 
Dries committed
132

133
  $form['submit'] = array('#type' => 'submit', '#value' => t('Submit'));
Dries's avatar
   
Dries committed
134
  if ($edit['vid']) {
135
136
    $form['delete'] = array('#type' => 'submit', '#value' => t('Delete'));
    $form['vid'] = array('#type' => 'hidden', '#value' => $edit['vid']);
Dries's avatar
 
Dries committed
137
  }
138
  return drupal_get_form('taxonomy_form_vocabulary', $form);
Kjartan's avatar
Kjartan committed
139
}
Kjartan's avatar
Kjartan committed
140

141
function taxonomy_save_vocabulary(&$edit) {
142
  $edit['nodes'] = empty($edit['nodes']) ? array() : $edit['nodes'];
Dries's avatar
   
Dries committed
143

Dries's avatar
   
Dries committed
144
  if ($edit['vid'] && $edit['name']) {
145
    db_query("UPDATE {vocabulary} SET name = '%s', description = '%s', help = '%s', multiple = %d, required = %d, hierarchy = %d, relations = %d, tags = %d, weight = %d, module = '%s' WHERE vid = %d", $edit['name'], $edit['description'], $edit['help'], $edit['multiple'], $edit['required'], $edit['hierarchy'], $edit['relations'], $edit['tags'], $edit['weight'], isset($edit['module']) ? $edit['module'] : 'taxonomy', $edit['vid']);
Dries's avatar
   
Dries committed
146
    db_query("DELETE FROM {vocabulary_node_types} WHERE vid = %d", $edit['vid']);
147
    foreach ($edit['nodes'] as $type => $selected) {
Dries's avatar
   
Dries committed
148
149
      db_query("INSERT INTO {vocabulary_node_types} (vid, type) VALUES (%d, '%s')", $edit['vid'], $type);
    }
Dries's avatar
   
Dries committed
150
    module_invoke_all('taxonomy', 'update', 'vocabulary', $edit);
151
    $status = SAVED_UPDATED;
Dries's avatar
 
Dries committed
152
  }
Dries's avatar
   
Dries committed
153
  else if ($edit['vid']) {
154
    $status = taxonomy_del_vocabulary($edit['vid']);
Kjartan's avatar
Kjartan committed
155
156
  }
  else {
157
158
    $edit['vid'] = db_next_id('{vocabulary}_vid');
    db_query("INSERT INTO {vocabulary} (vid, name, description, help, multiple, required, hierarchy, relations, tags, weight, module) VALUES (%d, '%s', '%s', '%s', %d, %d, %d, %d, %d, %d, '%s')", $edit['vid'], $edit['name'], $edit['description'], $edit['help'], $edit['multiple'], $edit['required'], $edit['hierarchy'], $edit['relations'], $edit['tags'], $edit['weight'], isset($edit['module']) ? $edit['module'] : 'taxonomy');
159
    foreach ($edit['nodes'] as $type => $selected) {
Dries's avatar
   
Dries committed
160
161
      db_query("INSERT INTO {vocabulary_node_types} (vid, type) VALUES (%d, '%s')", $edit['vid'], $type);
    }
Dries's avatar
   
Dries committed
162
    module_invoke_all('taxonomy', 'insert', 'vocabulary', $edit);
163
    $status = SAVED_NEW;
Kjartan's avatar
Kjartan committed
164
  }
Dries's avatar
   
Dries committed
165
166

  cache_clear_all();
Dries's avatar
   
Dries committed
167

168
  return $status;
Kjartan's avatar
Kjartan committed
169
}
Dries's avatar
 
Dries committed
170

Kjartan's avatar
Kjartan committed
171
function taxonomy_del_vocabulary($vid) {
172
  $vocabulary = (array) taxonomy_get_vocabulary($vid);
Dries's avatar
   
Dries committed
173

Dries's avatar
   
Dries committed
174
  db_query('DELETE FROM {vocabulary} WHERE vid = %d', $vid);
Dries's avatar
   
Dries committed
175
  db_query('DELETE FROM {vocabulary_node_types} WHERE vid = %d', $vid);
Dries's avatar
   
Dries committed
176
  $result = db_query('SELECT tid FROM {term_data} WHERE vid = %d', $vid);
Kjartan's avatar
Kjartan committed
177
178
  while ($term = db_fetch_object($result)) {
    taxonomy_del_term($term->tid);
Dries's avatar
 
Dries committed
179
  }
Dries's avatar
   
Dries committed
180

Dries's avatar
   
Dries committed
181
  module_invoke_all('taxonomy', 'delete', 'vocabulary', $vocabulary);
Dries's avatar
   
Dries committed
182

Dries's avatar
   
Dries committed
183
184
  cache_clear_all();

185
  return SAVED_DELETED;
Dries's avatar
   
Dries committed
186
187
188
189
190
}

function _taxonomy_confirm_del_vocabulary($vid) {
  $vocabulary = taxonomy_get_vocabulary($vid);

191
192
193
  $form['type'] = array('#type' => 'hidden', '#value' => 'vocabulary');
  $form['vid'] = array('#type' => 'hidden', '#value' => $vid);
  $form['name'] = array('#type' => 'hidden', '#value' => $vocabulary->name);
194
195
196
197
  return confirm_form('vocabulary_confirm_delete', $form,
                  t('Are you sure you want to delete the vocabulary %title?',
                  array('%title' => theme('placeholder', $vocabulary->name))),
                  'admin/taxonomy', t('Deleting a vocabulary will delete all the terms in it. This action cannot be undone.'),
198
                  t('Delete'),
199
                  t('Cancel'));
Kjartan's avatar
Kjartan committed
200
}
Dries's avatar
 
Dries committed
201

Kjartan's avatar
Kjartan committed
202
function taxonomy_form_term($edit = array()) {
Dries's avatar
   
Dries committed
203
  $vocabulary_id = isset($edit['vid']) ? $edit['vid'] : arg(4);
Kjartan's avatar
Kjartan committed
204
  $vocabulary = taxonomy_get_vocabulary($vocabulary_id);
Dries's avatar
   
Dries committed
205

206
  $form['name'] = array('#type' => 'textfield', '#title' => t('Term name'), '#default_value' => $edit['name'], '#maxlength' => 64, '#description' => t('The name for this term.  Example: "Linux".'), '#required' => TRUE);
207

208
  $form['description'] = array('#type' => 'textarea', '#title' => t('Description'), '#default_value' => $edit['description'], '#description' => t('A description of the term.'));
Dries's avatar
 
Dries committed
209

Kjartan's avatar
Kjartan committed
210
  if ($vocabulary->hierarchy) {
Dries's avatar
   
Dries committed
211
212
    $parent = array_keys(taxonomy_get_parents($edit['tid']));
    $children = taxonomy_get_tree($vocabulary_id, $edit['tid']);
Dries's avatar
   
Dries committed
213

Dries's avatar
   
Dries committed
214
    // A term can't be the child of itself, nor of its children.
Dries's avatar
   
Dries committed
215
216
217
    foreach ($children as $child) {
      $exclude[] = $child->tid;
    }
Dries's avatar
   
Dries committed
218
    $exclude[] = $edit['tid'];
Dries's avatar
   
Dries committed
219

Kjartan's avatar
Kjartan committed
220
    if ($vocabulary->hierarchy == 1) {
221
      $form['parent'] = _taxonomy_term_select(t('Parent'), 'parent', $parent, $vocabulary_id, l(t('Parent term'), 'admin/help/taxonomy', NULL, NULL, 'parent') .'.', 0, '<'. t('root') .'>', $exclude);
Dries's avatar
 
Dries committed
222
    }
Kjartan's avatar
Kjartan committed
223
    elseif ($vocabulary->hierarchy == 2) {
224
      $form['parent'] = _taxonomy_term_select(t('Parents'), 'parent', $parent, $vocabulary_id, l(t('Parent terms'), 'admin/help/taxonomy', NULL, NULL, 'parent') .'.', 1, '<'. t('root') .'>', $exclude);
Dries's avatar
 
Dries committed
225
    }
Kjartan's avatar
Kjartan committed
226
  }
Dries's avatar
 
Dries committed
227

228
  if ($vocabulary->relations) {
229
    $form['relations'] = _taxonomy_term_select(t('Related terms'), 'relations', array_keys(taxonomy_get_related($edit['tid'])), $vocabulary_id, NULL, 1, '<'. t('none') .'>', array($edit['tid']));
230
231
  }

232
233
  $form['synonyms'] = array('#type' => 'textarea', '#title' => t('Synonyms'), '#default_value' => implode("\n", taxonomy_get_synonyms($edit['tid'])), '#description' => t('<a href="%help-url">Synonyms</a> of this term, one synonym per line.', array('%help-url' => url('admin/help/taxonomy', NULL, NULL, 'synonyms'))));
  $form['weight'] = array('#type' => 'weight', '#title' => t('Weight'), '#default_value' => $edit['weight'], '#description' => t('In listings, the heavier terms will sink and the lighter terms will be positioned nearer the top.'));
234
235
236
237
238

  // Add extra term form elements.
  $extra = module_invoke_all('taxonomy', 'term', 'vocabulary');
  if (is_array($extra)) {
    foreach ($extra as $key => $element) {
239
      $extra[$key]['#weight'] = isset($extra[$key]['#weight']) ? $extra[$key]['#weight'] : -18;
240
241
242
243
244
    }
    $form = array_merge($form, $extra);
  }


245
246
  $form['vid'] = array('#type' => 'hidden', '#value' => $vocabulary->vid);
  $form['submit'] = array('#type' => 'submit', '#value' => t('Submit'));
Kjartan's avatar
Kjartan committed
247

Dries's avatar
   
Dries committed
248
  if ($edit['tid']) {
249
250
    $form['delete'] = array('#type' => 'submit', '#value' => t('Delete'));
    $form['tid'] = array('#type' => 'hidden', '#value' => $edit['tid']);
Dries's avatar
 
Dries committed
251
  }
252
  else {
253
    $form['destination'] = array('#type' => 'hidden', '#value' => $_GET['q']);
254
  }
Dries's avatar
 
Dries committed
255

256
  return drupal_get_form('taxonomy_form_term', $form);
Kjartan's avatar
Kjartan committed
257
}
Dries's avatar
 
Dries committed
258

259
function taxonomy_save_term(&$edit) {
Dries's avatar
   
Dries committed
260
  if ($edit['tid'] && $edit['name']) {
261
    db_query("UPDATE {term_data} SET name = '%s', description = '%s', weight = %d WHERE tid = %d", $edit['name'], $edit['description'], $edit['weight'], $edit['tid']);
Dries's avatar
   
Dries committed
262
    module_invoke_all('taxonomy', 'update', 'term', $edit);
263
    $status = SAVED_UPDATED;
Kjartan's avatar
Kjartan committed
264
  }
Dries's avatar
   
Dries committed
265
266
  else if ($edit['tid']) {
    return taxonomy_del_term($edit['tid']);
Kjartan's avatar
Kjartan committed
267
268
  }
  else {
Dries's avatar
   
Dries committed
269
    $edit['tid'] = db_next_id('{term_data}_tid');
270
    db_query("INSERT INTO {term_data} (tid, name, description, vid, weight) VALUES (%d, '%s', '%s', %d, %d)", $edit['tid'], $edit['name'], $edit['description'], $edit['vid'], $edit['weight']);
Dries's avatar
   
Dries committed
271
    module_invoke_all('taxonomy', 'insert', 'term', $edit);
272
    $status = SAVED_NEW;
Kjartan's avatar
Kjartan committed
273
  }
Dries's avatar
 
Dries committed
274

Dries's avatar
   
Dries committed
275
276
277
  db_query('DELETE FROM {term_relation} WHERE tid1 = %d OR tid2 = %d', $edit['tid'], $edit['tid']);
  if ($edit['relations']) {
    foreach ($edit['relations'] as $related_id) {
Kjartan's avatar
Kjartan committed
278
      if ($related_id != 0) {
Dries's avatar
   
Dries committed
279
        db_query('INSERT INTO {term_relation} (tid1, tid2) VALUES (%d, %d)', $edit['tid'], $related_id);
Dries's avatar
 
Dries committed
280
      }
Kjartan's avatar
Kjartan committed
281
    }
Kjartan's avatar
Kjartan committed
282
  }
Dries's avatar
 
Dries committed
283

Dries's avatar
   
Dries committed
284
285
  db_query('DELETE FROM {term_hierarchy} WHERE tid = %d', $edit['tid']);
  if (!isset($edit['parent'])) {
286
    $edit['parent'] = array(0);
Kjartan's avatar
Kjartan committed
287
  }
Dries's avatar
   
Dries committed
288
289
  if (is_array($edit['parent'])) {
    foreach ($edit['parent'] as $parent) {
290
291
292
293
294
295
296
297
      if (is_array($parent)) {
        foreach ($parent as $tid) {
          db_query('INSERT INTO {term_hierarchy} (tid, parent) VALUES (%d, %d)', $edit['tid'], $tid);
        }
      }
      else {
        db_query('INSERT INTO {term_hierarchy} (tid, parent) VALUES (%d, %d)', $edit['tid'], $parent);
      }
Dries's avatar
 
Dries committed
298
    }
Kjartan's avatar
Kjartan committed
299
  }
300
301
302
  else {
    db_query('INSERT INTO {term_hierarchy} (tid, parent) VALUES (%d, %d)', $edit['tid'], $edit['parent']);
  }
Dries's avatar
 
Dries committed
303

Dries's avatar
   
Dries committed
304
305
306
  db_query('DELETE FROM {term_synonym} WHERE tid = %d', $edit['tid']);
  if ($edit['synonyms']) {
    foreach (explode ("\n", str_replace("\r", '', $edit['synonyms'])) as $synonym) {
Dries's avatar
   
Dries committed
307
      if ($synonym) {
Dries's avatar
   
Dries committed
308
        db_query("INSERT INTO {term_synonym} (tid, name) VALUES (%d, '%s')", $edit['tid'], chop($synonym));
Dries's avatar
   
Dries committed
309
      }
Kjartan's avatar
Kjartan committed
310
    }
Dries's avatar
 
Dries committed
311
  }
Dries's avatar
   
Dries committed
312

Dries's avatar
   
Dries committed
313
314
  cache_clear_all();

315
  return $status;
Kjartan's avatar
Kjartan committed
316
}
Dries's avatar
 
Dries committed
317

Kjartan's avatar
Kjartan committed
318
function taxonomy_del_term($tid) {
319
320
321
322
323
324
325
326
327
328
329
330
331
332
  $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;
          }
        }
      }
Dries's avatar
   
Dries committed
333

334
      $term = (array) taxonomy_get_term($tid);
Dries's avatar
   
Dries committed
335

336
337
338
339
340
      db_query('DELETE FROM {term_data} WHERE tid = %d', $tid);
      db_query('DELETE FROM {term_hierarchy} WHERE tid = %d', $tid);
      db_query('DELETE FROM {term_relation} WHERE tid1 = %d OR tid2 = %d', $tid, $tid);
      db_query('DELETE FROM {term_synonym} WHERE tid = %d', $tid);
      db_query('DELETE FROM {term_node} WHERE tid = %d', $tid);
Dries's avatar
   
Dries committed
341

342
      module_invoke_all('taxonomy', 'delete', 'term', $term);
343
      drupal_set_message(t('Deleted term %name.', array('%name' => theme('placeholder', $term['name']))));
344
    }
Dries's avatar
   
Dries committed
345

346
347
    $tids = $orphans;
  }
Dries's avatar
   
Dries committed
348

Dries's avatar
   
Dries committed
349
  cache_clear_all();
Dries's avatar
   
Dries committed
350
351
352
353
354
}

function _taxonomy_confirm_del_term($tid) {
  $term = taxonomy_get_term($tid);

355
356
  $form['type'] = array('#type' => 'hidden', '#value' => 'term');
  $form['tid'] = array('#type' => 'hidden', '#value' => $tid);
357
358
359
  return confirm_form('term_confirm_delete', $form,
                  t('Are you sure you want to delete the term %title?',
                  array('%title' => theme('placeholder', $term->name))),
360
361
362
                  'admin/taxonomy',
                  t('Deleting a term will delete all its children if there are any. This action cannot be undone.'),
                  t('Delete'),
363
                  t('Cancel'));
Kjartan's avatar
Kjartan committed
364
}
Dries's avatar
 
Dries committed
365

Dries's avatar
   
Dries committed
366
367
368
/**
 * Generate a tabular listing of administrative functions for vocabularies.
 */
Kjartan's avatar
Kjartan committed
369
function taxonomy_overview() {
Dries's avatar
Dries committed
370
371
  $vid = arg(2);

372
  // Show all vocabularies, and a "view terms" link to the pagers.
Dries's avatar
Dries committed
373
  if (!$vid) {
374
    $header = array(t('Name'), t('Type'), array('data' => t('Operations'), 'colspan' => '2'));
Dries's avatar
Dries committed
375
376
    $vocabularies = taxonomy_get_vocabularies();
    foreach ($vocabularies as $vocabulary) {
377
378
      $types = array();
      foreach ($vocabulary->nodes as $type) {
379
        $node_type = node_get_name($type);
380
381
        $types[] = $node_type ? $node_type : $type;
      }
Dries's avatar
Dries committed
382
      $rows[] = array(check_plain($vocabulary->name), implode(', ', $types), l(t('edit vocabulary'), "admin/taxonomy/edit/vocabulary/$vocabulary->vid"), l(t('edit terms'), "admin/taxonomy/$vocabulary->vid"));
Dries's avatar
Dries committed
383
384
385
    }

    if (!$rows) {
386
      $rows[] = array(array('data' => t('No categories available.'), 'colspan' => '4', 'class' => 'message'));
Dries's avatar
Dries committed
387
388
    }
  }
Dries's avatar
   
Dries committed
389

390
  // Show the vocabulary's terms with a pager.
Dries's avatar
Dries committed
391
  else {
392
393
394
    $destination = drupal_get_destination();

    $header = array(t('Name'), t('Operations'));
Dries's avatar
Dries committed
395
    $vocabulary = taxonomy_get_vocabulary($vid);
396

Dries's avatar
Dries committed
397
398
399
400
401
402
403
404
405
406
    drupal_set_title(check_plain($vocabulary->name));
    $start_from      = $_GET['page'] ? $_GET['page'] : 0;
    $total_entries   = 0;  // total count for pager
    $page_increment  = 25; // number of tids per page
    $displayed_count = 0;  // number of tids shown

    $tree = taxonomy_get_tree($vocabulary->vid);
    foreach ($tree as $term) {
      $total_entries++; // we're counting all-totals, not displayed
      if (($start_from && ($start_from * $page_increment) >= $total_entries) || ($displayed_count == $page_increment)) { continue; }
407
      $rows[] = array(_taxonomy_depth($term->depth) . ' ' . l($term->name, "taxonomy/term/$term->tid"), l(t('edit'), "admin/taxonomy/edit/term/$term->tid", array(), $destination));
Dries's avatar
Dries committed
408
409
410
411
412
413
      $displayed_count++; // we're counting tids displayed
    }

    if (!$rows) {
      $rows[] = array(array('data' => t('No terms available.'), 'colspan' => '2'));
    }
Dries's avatar
 
Dries committed
414

Dries's avatar
Dries committed
415
416
    $GLOBALS['pager_page_array'][] = $start_from;  // FIXME
    $GLOBALS['pager_total'][] = intval($total_entries / $page_increment) + 1; // FIXME
417

Dries's avatar
Dries committed
418
419
    if ($total_entries >= $page_increment) {
      $rows[] = array(array('data' => theme('pager', NULL, $page_increment), 'colspan' => '2'));
Dries's avatar
Dries committed
420
    }
Dries's avatar
   
Dries committed
421
422
  }

Dries's avatar
Dries committed
423
  return theme('table', $header, $rows, array('id' => 'taxonomy'));
Kjartan's avatar
Kjartan committed
424
425
}

Dries's avatar
   
Dries committed
426
427
428
/**
 * Generate a form element for selecting terms from a vocabulary.
 */
Dries's avatar
   
Dries committed
429
function taxonomy_form($vid, $value = 0, $help = NULL, $name = 'taxonomy') {
Dries's avatar
   
Dries committed
430
  $vocabulary = taxonomy_get_vocabulary($vid);
431
  $help = ($help) ? $help : $vocabulary->help;
Kjartan's avatar
Kjartan committed
432
433
434
435
  if ($vocabulary->required) {
    $blank = 0;
  }
  else {
Dries's avatar
   
Dries committed
436
    $blank = '<'. t('none') .'>';
Kjartan's avatar
Kjartan committed
437
  }
Dries's avatar
   
Dries committed
438

439
  return _taxonomy_term_select(check_plain($vocabulary->name), $name, $value, $vid, $help, intval($vocabulary->multiple), $blank);
Kjartan's avatar
Kjartan committed
440
}
Dries's avatar
 
Dries committed
441

Dries's avatar
Dries committed
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
/**
 * Generate a set of options for selecting a term from all vocabularies. Can be
 * passed to form_select.
 */
function taxonomy_form_all($free_tags = 0) {
  $vocabularies = taxonomy_get_vocabularies();
  $options = array();
  foreach ($vocabularies as $vid => $vocabulary) {
    if ($vocabulary->tags && !$free_tags) { continue; }
    $tree = taxonomy_get_tree($vid);
    $options[$vocabulary->name] = array();
    if ($tree) {
      foreach ($tree as $term) {
        $options[$vocabulary->name][$term->tid] = _taxonomy_depth($term->depth, '-') . $term->name;
      }
    }
  }
  return $options;
}

Dries's avatar
   
Dries committed
462
463
464
465
466
467
/**
 * Return an array of all vocabulary objects.
 *
 * @param $type
 *   If set, return only those vocabularies associated with this node type.
 */
Dries's avatar
   
Dries committed
468
function taxonomy_get_vocabularies($type = NULL) {
Kjartan's avatar
Kjartan committed
469
  if ($type) {
470
    $result = db_query(db_rewrite_sql("SELECT v.vid, v.*, n.type FROM {vocabulary} v LEFT JOIN {vocabulary_node_types} n ON v.vid = n.vid WHERE n.type = '%s' ORDER BY v.weight, v.name", 'v', 'vid'), $type);
Kjartan's avatar
Kjartan committed
471
472
  }
  else {
473
    $result = db_query(db_rewrite_sql('SELECT v.*, n.type FROM {vocabulary} v LEFT JOIN {vocabulary_node_types} n ON v.vid = n.vid ORDER BY v.weight, v.name', 'v', 'vid'));
Kjartan's avatar
Kjartan committed
474
  }
Dries's avatar
   
Dries committed
475

Kjartan's avatar
Kjartan committed
476
  $vocabularies = array();
Dries's avatar
   
Dries committed
477
  $node_types = array();
Kjartan's avatar
Kjartan committed
478
  while ($voc = db_fetch_object($result)) {
Dries's avatar
   
Dries committed
479
480
481
482
    $node_types[$voc->vid][] = $voc->type;
    unset($voc->type);
    $voc->nodes = $node_types[$voc->vid];
    $vocabularies[$voc->vid] = $voc;
Dries's avatar
 
Dries committed
483
  }
Dries's avatar
   
Dries committed
484

Kjartan's avatar
Kjartan committed
485
486
  return $vocabularies;
}
Dries's avatar
 
Dries committed
487

Dries's avatar
   
Dries committed
488
489
490
/**
 * Generate a form for selecting terms to associate with a node.
 */
491
492
493
494
function taxonomy_form_alter($form_id, &$form) {
  if (isset($form['type']) && $form['type']['#value'] .'_node_form' == $form_id) {
    $node = $form['#node'];

495
    if (!isset($node->taxonomy)) {
496
497
498
499
500
501
      if ($node->nid) {
        $terms = taxonomy_node_get_terms($node->nid);
      }
      else {
        $terms = array();
      }
Kjartan's avatar
Kjartan committed
502
503
    }
    else {
504
      $terms = $node->taxonomy;
Dries's avatar
 
Dries committed
505
506
    }

507
    $c = db_query(db_rewrite_sql("SELECT v.* FROM {vocabulary} v INNER JOIN {vocabulary_node_types} n ON v.vid = n.vid WHERE n.type = '%s' ORDER BY v.weight, v.name", 'v', 'vid'), $node->type);
Dries's avatar
Dries committed
508

509
510
511
512
513
    while ($vocabulary = db_fetch_object($c)) {
      if ($vocabulary->tags) {
        $typed_terms = array();
        foreach ($terms as $term) {
          if ($term->vid == $vocabulary->vid) {
Dries's avatar
Dries committed
514

515
516
517
518
519
520
521
            // Commas and quotes in terms are special cases, so encode 'em.
            if (preg_match('/,/', $term->name) || preg_match('/"/', $term->name)) {
              $term->name = '"'.preg_replace('/"/', '""', $term->name).'"';
            }

            $typed_terms[] = $term->name;
          }
Dries's avatar
Dries committed
522
        }
523
        $typed_string = implode(', ', $typed_terms) . (array_key_exists('tags', $terms) ? $terms['tags'][$vocabulary->vid] : NULL);
524

525
526
527
528
529
530
531
        if ($vocabulary->help) {
          $help = $vocabulary->help;
        }
        else {
          $help = t('A comma-separated list of terms describing this content.  Example: funny, bungie jumping, "Company, Inc.".');
        }
        $form['taxonomy']['tags'][$vocabulary->vid] = array('#type' => 'textfield', '#default_value' => $typed_string, '#maxlength' => 100, '#autocomplete_path' => 'taxonomy/autocomplete/'. $vocabulary->vid, '#required' => $vocabulary->required, '#title' => $vocabulary->name, '#description' => $help);
532
533
      }
      else {
534
        $form['taxonomy'][$vocabulary->vid] = taxonomy_form($vocabulary->vid, array_keys($terms), $help);
535
        $form['taxonomy'][$vocabulary->vid]['#weight'] = $vocabulary->weight;
536
      }
Dries's avatar
Dries committed
537
    }
538
    if (isset($form['taxonomy'])) {
539
      $form['taxonomy'] = array_merge($form['taxonomy'], array('#type' => 'fieldset', '#title' => t('Categories'), '#collapsible' => TRUE, '#collapsed' => FALSE, '#tree' => TRUE, '#weight' => -3));
Dries's avatar
Dries committed
540
    }
Dries's avatar
 
Dries committed
541
  }
Kjartan's avatar
Kjartan committed
542
}
Dries's avatar
 
Dries committed
543

Dries's avatar
   
Dries committed
544
545
546
547
/**
 * Find all terms associated to the given node, within one vocabulary.
 */
function taxonomy_node_get_terms_by_vocabulary($nid, $vid, $key = 'tid') {
548
  $result = db_query(db_rewrite_sql('SELECT t.tid, t.* FROM {term_data} t, {term_node} r WHERE t.tid = r.tid AND t.vid = %d AND r.nid = %d ORDER BY weight', 't', 'tid'), $vid, $nid);
Kjartan's avatar
Kjartan committed
549
550
551
  $terms = array();
  while ($term = db_fetch_object($result)) {
    $terms[$term->$key] = $term;
Dries's avatar
 
Dries committed
552
  }
Kjartan's avatar
Kjartan committed
553
554
555
  return $terms;
}

Dries's avatar
   
Dries committed
556
/**
557
 * Find all terms associated to the given node, ordered by vocabulary and term weight.
Dries's avatar
   
Dries committed
558
559
 */
function taxonomy_node_get_terms($nid, $key = 'tid') {
Kjartan's avatar
Kjartan committed
560
  static $terms;
Dries's avatar
 
Dries committed
561

Dries's avatar
   
Dries committed
562
  if (!isset($terms[$nid])) {
563
    $result = db_query(db_rewrite_sql('SELECT t.* FROM {term_node} r INNER JOIN {term_data} t ON r.tid = t.tid INNER JOIN {vocabulary} v ON t.vid = v.vid WHERE r.nid = %d ORDER BY v.weight, t.weight, t.name', 't', 'tid'), $nid);
Kjartan's avatar
Kjartan committed
564
    $terms[$nid] = array();
Dries's avatar
 
Dries committed
565
    while ($term = db_fetch_object($result)) {
Kjartan's avatar
Kjartan committed
566
      $terms[$nid][$term->$key] = $term;
Dries's avatar
 
Dries committed
567
568
    }
  }
Kjartan's avatar
Kjartan committed
569
570
  return $terms[$nid];
}
Dries's avatar
 
Dries committed
571

Dries's avatar
Dries committed
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
/**
 * Make sure incoming vids are free tagging enabled.
 */
function taxonomy_node_validate(&$node) {
  if ($node->taxonomy) {
    $terms = $node->taxonomy;
    if ($terms['tags']) {
      foreach ($terms['tags'] as $vid => $vid_value) {
        $vocabulary = taxonomy_get_vocabulary($vid);
        if (!$vocabulary->tags) {
          form_set_error("taxonomy[tags][$vid", t('The %name vocabulary can not be modified in this way.', array('%name' => theme('placeholder', $vocabulary->name))));
        }
      }
    }
  }
}

Dries's avatar
   
Dries committed
589
590
591
/**
 * Save term associations for a given node.
 */
Kjartan's avatar
Kjartan committed
592
function taxonomy_node_save($nid, $terms) {
593
  taxonomy_node_delete($nid);
Dries's avatar
Dries committed
594
595
596

  // Free tagging vocabularies do not send their tids in the form,
  // so we'll detect them here and process them independently.
597
  if (isset($terms['tags'])) {
Dries's avatar
Dries committed
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
    $typed_input = $terms['tags'];
    unset($terms['tags']);

    foreach ($typed_input as $vid => $vid_value) {
      // This regexp allows the following types of user input:
      // this, "somecmpany, llc", "and ""this"" w,o.rks", foo bar
      $regexp = '%(?:^|,\ *)("(?>[^"]*)(?>""[^"]* )*"|(?: [^",]*))%x';
      preg_match_all($regexp, $vid_value, $matches);
      $typed_terms = $matches[1];

      foreach ($typed_terms as $typed_term) {
        // If a user has escaped a term (to demonstrate that it is a group,
        // or includes a comma or quote character), we remove the escape
        // formatting so to save the term into the DB as the user intends.
        $typed_term = str_replace('""', '"', preg_replace('/^"(.*)"$/', '\1', $typed_term));
        $typed_term = trim($typed_term);
        if ($typed_term == "") { continue; }

        // See if the term exists in the chosen vocabulary
        // and return the tid, otherwise, add a new record.
        $possibilities = taxonomy_get_term_by_name($typed_term);
        $typed_term_tid = NULL; // tid match if any.
        foreach ($possibilities as $possibility) {
          if ($possibility->vid == $vid) {
            $typed_term_tid = $possibility->tid;
          }
        }

        if (!$typed_term_tid) {
627
628
629
          $edit = array('vid' => $vid, 'name' => $typed_term);
          $status = taxonomy_save_term($edit);
          $typed_term_tid = $edit['tid'];
Dries's avatar
Dries committed
630
631
632
633
634
635
        }

        db_query('INSERT INTO {term_node} (nid, tid) VALUES (%d, %d)', $nid, $typed_term_tid);
      }
    }
  }
Dries's avatar
 
Dries committed
636

637
  if (is_array($terms)) {
Dries's avatar
   
Dries committed
638
    foreach ($terms as $term) {
639
640
641
642
643
644
645
      if (is_array($term)) {
        foreach ($term as $tid) {
          if ($tid) {
            db_query('INSERT INTO {term_node} (nid, tid) VALUES (%d, %d)', $nid, $tid);
          }
        }
      }
646
      else if ($term) {
Dries's avatar
   
Dries committed
647
        db_query('INSERT INTO {term_node} (nid, tid) VALUES (%d, %d)', $nid, $term);
648
      }
Dries's avatar
 
Dries committed
649
650
    }
  }
Kjartan's avatar
Kjartan committed
651
}
Dries's avatar
 
Dries committed
652

Dries's avatar
   
Dries committed
653
654
655
/**
 * Remove associations of a node to its terms.
 */
Kjartan's avatar
Kjartan committed
656
function taxonomy_node_delete($nid) {
Dries's avatar
   
Dries committed
657
  db_query('DELETE FROM {term_node} WHERE nid = %d', $nid);
Kjartan's avatar
Kjartan committed
658
}
Dries's avatar
 
Dries committed
659

Dries's avatar
   
Dries committed
660
661
662
663
/**
 * Find all term objects related to a given term ID.
 */
function taxonomy_get_related($tid, $key = 'tid') {
Kjartan's avatar
Kjartan committed
664
  if ($tid) {
Dries's avatar
   
Dries committed
665
    $result = db_query('SELECT t.*, tid1, tid2 FROM {term_relation}, {term_data} t WHERE (t.tid = tid1 OR t.tid = tid2) AND (tid1 = %d OR tid2 = %d) AND t.tid != %d ORDER BY weight, name', $tid, $tid, $tid);
Kjartan's avatar
Kjartan committed
666
667
668
    $related = array();
    while ($term = db_fetch_object($result)) {
      $related[$term->$key] = $term;
Dries's avatar
 
Dries committed
669
    }
Kjartan's avatar
Kjartan committed
670
    return $related;
Dries's avatar
 
Dries committed
671
  }
Kjartan's avatar
Kjartan committed
672
673
  else {
    return array();
Dries's avatar
 
Dries committed
674
  }
Kjartan's avatar
Kjartan committed
675
}
Dries's avatar
 
Dries committed
676

Dries's avatar
   
Dries committed
677
678
679
680
/**
 * Find all parents of a given term ID.
 */
function taxonomy_get_parents($tid, $key = 'tid') {
Kjartan's avatar
Kjartan committed
681
  if ($tid) {
682
    $result = db_query(db_rewrite_sql('SELECT t.tid, t.* FROM {term_hierarchy} h, {term_data} t WHERE h.parent = t.tid AND h.tid = %d ORDER BY weight, name', 't', 'tid'), $tid);
Kjartan's avatar
Kjartan committed
683
684
685
    $parents = array();
    while ($parent = db_fetch_object($result)) {
      $parents[$parent->$key] = $parent;
Dries's avatar
   
Dries committed
686
    }
Kjartan's avatar
Kjartan committed
687
    return $parents;
Dries's avatar
 
Dries committed
688
  }
Kjartan's avatar
Kjartan committed
689
690
691
692
  else {
    return array();
  }
}
Dries's avatar
 
Dries committed
693

Dries's avatar
   
Dries committed
694
695
696
697
/**
 * Find all ancestors of a given term ID.
 */
function taxonomy_get_parents_all($tid) {
Dries's avatar
   
Dries committed
698
699
700
701
702
703
704
705
706
707
708
709
  $parents = array();
  if ($tid) {
    $parents[] = taxonomy_get_term($tid);
    $n = 0;
    while ($parent = taxonomy_get_parents($parents[$n]->tid)) {
      $parents = array_merge($parents, $parent);
      $n++;
    }
  }
  return $parents;
}

Dries's avatar
   
Dries committed
710
711
712
713
/**
 * Find all children of a term ID.
 */
function taxonomy_get_children($tid, $vid = 0, $key = 'tid') {
Kjartan's avatar
Kjartan committed
714
  if ($vid) {
715
    $result = db_query(db_rewrite_sql('SELECT t.* FROM {term_hierarchy} h, {term_data} t WHERE t.vid = %d AND h.tid = t.tid AND h.parent = %d ORDER BY weight, name', 't', 'tid'), $vid, $tid);
Dries's avatar
 
Dries committed
716
  }
Kjartan's avatar
Kjartan committed
717
  else {
718
    $result = db_query(db_rewrite_sql('SELECT t.* FROM {term_hierarchy} h, {term_data} t WHERE h.tid = t.tid AND parent = %d ORDER BY weight, name', 't', 'tid'), $tid);
Kjartan's avatar
Kjartan committed
719
720
721
722
723
724
725
  }
  $children = array();
  while ($term = db_fetch_object($result)) {
    $children[$term->$key] = $term;
  }
  return $children;
}
Dries's avatar
 
Dries committed
726

Dries's avatar
   
Dries committed
727
728
729
730
731
732
733
734
735
736
737
738
739
/**
 * 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 $depth
 *   Internal use only.
 *
Dries's avatar
   
Dries committed
740
741
742
 * @param $max_depth
 *   The number of levels of the tree to return. Leave NULL to return all levels.
 *
Dries's avatar
   
Dries committed
743
744
745
746
747
 * @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.
 */
function taxonomy_get_tree($vid, $parent = 0, $depth = -1, $max_depth = NULL) {
Dries's avatar
   
Dries committed
748
  static $children, $parents, $terms;
Dries's avatar
   
Dries committed
749

Kjartan's avatar
Kjartan committed
750
  $depth++;
Dries's avatar
   
Dries committed
751

Dries's avatar
   
Dries committed
752
753
754
755
  // 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();
Dries's avatar
   
Dries committed
756

757
    $result = db_query(db_rewrite_sql('SELECT t.tid, t.*, parent FROM {term_data} t, {term_hierarchy} h WHERE t.tid = h.tid AND t.vid = %d ORDER BY weight, name', 't', 'tid'), $vid);
Dries's avatar
   
Dries committed
758
    while ($term = db_fetch_object($result)) {
Dries's avatar
   
Dries committed
759
760
761
      $children[$vid][$term->parent][] = $term->tid;
      $parents[$vid][$term->tid][] = $term->parent;
      $terms[$vid][$term->tid] = $term;
Dries's avatar
 
Dries committed
762
763
    }
  }
Dries's avatar
   
Dries committed
764

Dries's avatar
   
Dries committed
765
  $max_depth = (is_null($max_depth)) ? count($children[$vid]) : $max_depth;
Dries's avatar
Dries committed
766
767
768
769
770
771
772
773
774
775
776
777
  if ($children[$vid][$parent]) {
    foreach ($children[$vid][$parent] as $child) {
      if ($max_depth > $depth) {
        $terms[$vid][$child]->depth = $depth;
        // The "parent" attribute is not useful, as it would show one parent only.
        unset($terms[$vid][$child]->parent);
        $terms[$vid][$child]->parents = $parents[$vid][$child];
        $tree[] = $terms[$vid][$child];

        if ($children[$vid][$child]) {
          $tree = array_merge($tree, taxonomy_get_tree($vid, $child, $depth, $max_depth));
        }
Dries's avatar
   
Dries committed
778
      }
Dries's avatar
   
Dries committed
779
    }
Kjartan's avatar
Kjartan committed
780
  }
Dries's avatar
   
Dries committed
781

Dries's avatar
   
Dries committed
782
  return $tree ? $tree : array();
Kjartan's avatar
Kjartan committed
783
}
Dries's avatar
 
Dries committed
784

Dries's avatar
   
Dries committed
785
786
787
/**
 * Return an array of synonyms of the given term ID.
 */
Kjartan's avatar
Kjartan committed
788
789
function taxonomy_get_synonyms($tid) {
  if ($tid) {
Dries's avatar
   
Dries committed
790
    $result = db_query('SELECT name FROM {term_synonym} WHERE tid = %d', $tid);
Kjartan's avatar
Kjartan committed
791
    while ($synonym = db_fetch_array($result)) {
Dries's avatar
   
Dries committed
792
      $synonyms[] = $synonym['name'];
Dries's avatar
 
Dries committed
793
    }
Kjartan's avatar
Kjartan committed
794
    return $synonyms ? $synonyms : array();
Dries's avatar
 
Dries committed
795
  }
Kjartan's avatar
Kjartan committed
796
797
  else {
    return array();
Dries's avatar
   
Dries committed
798
  }
Kjartan's avatar
Kjartan committed
799
}
Dries's avatar
   
Dries committed
800

Dries's avatar
   
Dries committed
801
802
803
804
805
/**
 * Return the term object that has the given string as a synonym.
 */
function taxonomy_get_synonym_root($synonym) {
  return db_fetch_object(db_query("SELECT * FROM {term_synonym} s, {term_data} t WHERE t.tid = s.tid AND s.name = '%s'", $synonym));
Kjartan's avatar
Kjartan committed
806
}
Dries's avatar
   
Dries committed
807

Dries's avatar
   
Dries committed
808
809
810
/**
 * Given a term id, count the number of published nodes in it.
 */
Dries's avatar
   
Dries committed
811
function taxonomy_term_count_nodes($tid, $type = 0) {
Kjartan's avatar
Kjartan committed
812
  static $count;
Dries's avatar
   
Dries committed
813

Dries's avatar
   
Dries committed
814
815
816
  if (!isset($count[$type])) {
    // $type == 0 always evaluates true is $type is a string
    if (is_numeric($type)) {
817
      $result = db_query(db_rewrite_sql('SELECT t.tid, COUNT(n.nid) AS c FROM {term_node} t INNER JOIN {node} n ON t.nid = n.nid WHERE n.status = 1 GROUP BY t.tid'));
Dries's avatar
   
Dries committed
818
819
    }
    else {
820
      $result = db_query(db_rewrite_sql("SELECT t.tid, COUNT(n.nid) AS c FROM {term_node} t, {node} n WHERE t.nid = n.nid AND n.status = 1 AND n.type = '%s' GROUP BY t.tid"), $type);
Dries's avatar
   
Dries committed
821
    }
Kjartan's avatar
Kjartan committed
822
    while ($term = db_fetch_object($result)) {
Dries's avatar
   
Dries committed
823
      $count[$type][$term->tid] = $term->c;
Dries's avatar
   
Dries committed
824
825
826
    }
  }

Kjartan's avatar
Kjartan committed
827
  foreach (_taxonomy_term_children($tid) as $c) {
Dries's avatar
   
Dries committed
828
    $children_count += taxonomy_term_count_nodes($c, $type);
Kjartan's avatar
Kjartan committed
829
  }
Dries's avatar
   
Dries committed
830
  return $count[$type][$tid] + $children_count;
Kjartan's avatar
Kjartan committed
831
832
}

Dries's avatar
   
Dries committed
833
834
835
/**
 * Helper for taxonomy_term_count_nodes().
 */
Kjartan's avatar
Kjartan committed
836
837
function _taxonomy_term_children($tid) {
  static $children;
Dries's avatar
   
Dries committed
838

Dries's avatar
   
Dries committed
839
  if (!isset($children)) {
Dries's avatar
   
Dries committed
840
    $result = db_query('SELECT tid, parent FROM {term_hierarchy}');
Kjartan's avatar
Kjartan committed
841
842
    while ($term = db_fetch_object($result)) {
      $children[$term->parent][] = $term->tid;
Dries's avatar
   
Dries committed
843
    }
Dries's avatar
 
Dries committed
844
  }
Kjartan's avatar
Kjartan committed
845
846
  return $children[$tid] ? $children[$tid] : array();
}
Dries's avatar
 
Dries committed
847

Dries's avatar
   
Dries committed
848
/**
Dries's avatar
   
Dries committed
849
 * Try to map a string to an existing term, as for glossary use.
Dries's avatar
   
Dries committed
850
 *
Dries's avatar
   
Dries committed
851
852
853
854
855
856
857
858
 * 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.
Dries's avatar
   
Dries committed
859
860
 */
function taxonomy_get_term_by_name($name) {
861
  $db_result = db_query(db_rewrite_sql("SELECT t.tid, t.* FROM {term_data} t WHERE LOWER('%s') LIKE LOWER(name)", 't', 'tid'), trim($name));
Dries's avatar
   
Dries committed
862
863
864
865
866
867
868
869
  $result = array();
  while ($term = db_fetch_object($db_result)) {
    $result[] = $term;
  }

  return $result;
}

Dries's avatar
   
Dries committed
870
871
872
/**
 * Return the vocabulary object matching a vocabulary ID.
 */
Kjartan's avatar
Kjartan committed
873
function taxonomy_get_vocabulary($vid) {
874
875
876
877
878
879
880
881
882
883
884
  static $vocabularies = array();

  if (!array_key_exists($vid, $vocabularies)) {
    $result = db_query('SELECT v.*, n.type FROM {vocabulary} v LEFT JOIN {vocabulary_node_types} n ON v.vid = n.vid WHERE v.vid = %d ORDER BY v.weight, v.name', $vid);
    $node_types = array();
    while ($voc = db_fetch_object($result)) {
      $node_types[] = $voc->type;
      unset($voc->type);
      $voc->nodes = $node_types;
      $vocabularies[$vid] = $voc;
    }
Dries's avatar
   
Dries committed
885
886
  }

887
  return $vocabularies[$vid];
Kjartan's avatar
Kjartan committed
888
}
Dries's avatar
 
Dries committed
889

Dries's avatar
   
Dries committed
890
891
892
/**
 * Return the term object matching a term ID.
 */
Kjartan's avatar
Kjartan committed
893
894
function taxonomy_get_term($tid) {
  // simple cache using a static var?
Dries's avatar
   
Dries committed
895
  return db_fetch_object(db_query('SELECT * FROM {term_data} WHERE tid = %d', $tid));
Kjartan's avatar
Kjartan committed
896
}
Dries's avatar
 
Dries committed
897

Kjartan's avatar
Kjartan committed
898
function _taxonomy_term_select($title, $name, $value, $vocabulary_id, $description, $multiple, $blank, $exclude = array()) {
Dries's avatar
   
Dries committed
899
  $tree = taxonomy_get_tree($vocabulary_id);
900
901
  $options = array();

Dries's avatar
Dries committed
902
  if ($blank) {
903
    $options[0] = $blank;
Dries's avatar
Dries committed
904
  }
Kjartan's avatar
Kjartan committed
905
906
907
  if ($tree) {
    foreach ($tree as $term) {
      if (!in_array($term->tid, $exclude)) {
908
        $options[$term->tid] = _taxonomy_depth($term->depth, '-') . $term->name;
Dries's avatar
 
Dries committed
909
910
      }
    }
Kjartan's avatar
Kjartan committed
911
912
913
914
915
    if (!$blank && !$value) {
      // required but without a predefined value, so set first as predefined
      $value = $tree[0]->tid;
    }
  }