/[drupal]/contributions/modules/taxonomy_browser/taxonomy_browser.module
ViewVC logotype

Contents of /contributions/modules/taxonomy_browser/taxonomy_browser.module

Parent Directory Parent Directory | Revision Log Revision Log | View Revision Graph Revision Graph


Revision 1.19.2.28 - (hide annotations) (download) (as text)
Fri Jun 20 04:08:03 2008 UTC (17 months ago) by nancyw
Branch: DRUPAL-5
Changes since 1.19.2.27: +3 -3 lines
File MIME type: text/x-php
#268382 by NancyDru for Junyor - changed htmlspecialchars_decode to decode_entities.
1 jaza 1.17 <?php
2 nancyw 1.19.2.28 // $Id: taxonomy_browser.module,v 1.19.2.27 2008/06/16 19:09:14 nancyw Exp $
3 jaza 1.17 // Original by Moshe Weitzman (weitzmna@tejasa.com)
4    
5     /**
6     * @file
7 nancyw 1.19.2.19 * Enables users to construct their own view of content from terms across
8     * multiple vocabularies.
9 jaza 1.17 */
10    
11 nancyw 1.19.2.13 //*******************************************************************
12 nancyw 1.19.2.21 //* Drupal Hooks : General Overview
13 nancyw 1.19.2.13 //*******************************************************************
14 jaza 1.17
15     /**
16     * Implementation of hook_menu().
17     */
18     function taxonomy_browser_menu($may_cache) {
19     $items = array();
20    
21     if ($may_cache) {
22 nancyw 1.19.2.14 $items[] = array(
23 nancyw 1.19.2.5 'path' => 'admin/settings/taxonomy-browser',
24     'title' => t('Taxonomy Browser'),
25     'description' => t('Set usage guidelines and included vocabularies.'),
26     'callback' => 'drupal_get_form',
27     'callback arguments' => 'taxonomy_browser_admin_settings',
28     'access' => user_access('administer site configuration'),
29     );
30     }
31     else {
32 nancyw 1.19.2.15 $items[] = array(
33     'path' => 'taxonomy_browser',
34     'title' => t('Category Browser'),
35     'access' => user_access(variable_get('taxonomy_browser_need_perm', false) ? 'access taxonomy browser' : 'access content'),
36     'callback' => 'taxonomy_browser_page',
37     'description' => t('Find content on your own terms.'),
38 nancyw 1.19.2.20 'type' => MENU_NORMAL_ITEM,
39     );
40    
41 nancyw 1.19.2.5 drupal_add_css(drupal_get_path('module', 'taxonomy_browser') .'/taxonomy_browser.css');
42 jaza 1.17 }
43    
44     return $items;
45     }
46    
47     /**
48     * Implementation of hook_help().
49     */
50     function taxonomy_browser_help($section = '') {
51     switch ($section) {
52     case 'admin/modules#description':
53     return t('An interface for viewing content grouped by arbitrary taxonomy terms.');
54     case 'taxonomy_browser':
55 nancyw 1.19.2.15 $output = check_markup(variable_get('taxonomy_browser_guidelines', _taxonomy_browser_guidelines_default()));
56     if (user_access('administer site configuration')) {
57 nancyw 1.19.2.23 $output .= '<p class="links">'. l(t('Go to Taxonomy Browser settings'), 'admin/settings/taxonomy-browser', array(), drupal_get_destination()) .'</p>';
58 nancyw 1.19.2.15 }
59     return $output;
60     }
61     }
62    
63     /**
64     * Implementation of hook_perm().
65     */
66     function taxonomy_browser_perm() {
67     if (variable_get('taxonomy_browser_need_perm', false)) {
68     return array('access taxonomy browser');
69     }
70     else {
71     return array();
72 jaza 1.17 }
73     }
74    
75 nancyw 1.19.2.13 //********************************************************************
76 nancyw 1.19.2.15 //* Drupal Hooks : Core
77 nancyw 1.19.2.13 //********************************************************************
78 jaza 1.17
79     /**
80 nancyw 1.19.2.21 * Implementation of hook_block().
81     */
82     function taxonomy_browser_block($op = 'list', $delta = 0, $edit = array()) {
83     $block = array();
84     switch ($op) {
85     case 'list':
86     $block[0]['info'] = t('Category browser');
87     return $block;
88    
89     case 'view':
90 nancyw 1.19.2.23 switch ($delta) {
91 nancyw 1.19.2.21 case 0:
92     $block = _taxonomy_browser_block_view($delta);
93     break;
94     }
95     return $block;
96     //
97     // case 'configure':
98     // return _taxonomy_browser_block_configure($delta);
99     //
100     // case 'save':
101     // _taxonomy_browser_block_save($delta, $edit);
102     }
103     }
104    
105     /**
106 nancyw 1.19.2.15 * Implementation of hook_form().
107 jaza 1.17 */
108 nancyw 1.19.2.1 function taxonomy_browser_admin_settings() {
109     if (!module_exists('node_type_filter') && !drupal_set_message()) {
110 nancyw 1.19.2.13 drupal_set_message(t('You do not have the node_type_filter module installed. This means that the "restrict search by content type" option will not be available on the category browser page.'), 'status');
111 jaza 1.17 }
112 nancyw 1.19.2.27
113     drupal_add_js(drupal_get_path('module', 'taxonomy_browser') .'/taxonomy_browser.js', 'module');
114 jaza 1.17
115     $form['taxonomy_browser_guidelines'] = array(
116     '#title' => t('Guidelines'),
117     '#type' => 'textarea',
118     '#default_value' => variable_get('taxonomy_browser_guidelines', _taxonomy_browser_guidelines_default()),
119 nancyw 1.19.2.15 '#rows' => 2,
120 jaza 1.17 '#description' => t('Instructions which should appear at top of the category browser main page'),
121 nancyw 1.19.2.13 );
122 jaza 1.17
123 nancyw 1.19.2.5 $form['taxonomy_browser_select_type'] = array(
124     '#title' => t('Selection type'),
125     '#type' => 'radios',
126 nancyw 1.19.2.23 '#default_value' => variable_get('taxonomy_browser_select_type', 1),
127 nancyw 1.19.2.7 '#options' => array(t('Selection box'), t('Check boxes')),
128 nancyw 1.19.2.9 '#description' => t('This option determines whether the user will see a selection list or check boxes.'),
129 nancyw 1.19.2.23 '#prefix' => '<div class="taxonomy_browser_radios">',
130     '#suffix' => '</div>',
131 nancyw 1.19.2.13 );
132 nancyw 1.19.2.16
133     $form['taxonomy_browser_default_op'] = array(
134     '#title' => t('"Items containing" default'),
135     '#type' => 'radios',
136     '#default_value' => variable_get('taxonomy_browser_default_op', 0),
137     '#options' => array(t('All'), t('Any')),
138     '#description' => t('This option determines which "Items containing" choice is the default.'),
139     '#prefix' => '<div class="taxonomy_browser_radios">',
140     '#suffix' => '</div>',
141     );
142 nancyw 1.19.2.10
143     $form['taxonomy_browser_count_nodes'] = array(
144     '#title' => t('Show node count'),
145     '#type' => 'checkbox',
146     '#default_value' => variable_get('taxonomy_browser_count_nodes', false),
147     '#description' => t('Do you want to display the count of nodes tagged with each term? This can be SQL-intensive.'),
148 nancyw 1.19.2.13 );
149 nancyw 1.19.2.10
150     $form['taxonomy_browser_show_unused'] = array(
151     '#title' => t('Show unused terms'),
152     '#type' => 'checkbox',
153     '#default_value' => variable_get('taxonomy_browser_show_unused', false),
154 nancyw 1.19.2.23 '#description' => t('Do you want to display the term if no nodes are tagged with that term? This requires "Show node count" to be selected; if it is not seleted, all terms will be shown.'),
155 nancyw 1.19.2.13 );
156    
157     $form['taxonomy_browser_allow_children'] = array(
158     '#title' => t('Allow child terms to be included'),
159     '#type' => 'checkbox',
160     '#default_value' => variable_get('taxonomy_browser_allow_children', false),
161     '#description' => t('Do you want the user to see a check box to include child terms (sub-terms)?'),
162     );
163 nancyw 1.19.2.5
164 nancyw 1.19.2.15 $form['taxonomy_browser_need_perm'] = array(
165     '#title' => t('Requires permission'),
166     '#type' => 'checkbox',
167     '#default_value' => variable_get('taxonomy_browser_need_perm', false),
168     '#description' => t('Do you want to require permission to see the browser page?'),
169     );
170    
171 nancyw 1.19.2.23 $select = array();
172 jaza 1.17 $vocabularies = taxonomy_get_vocabularies();
173     foreach ($vocabularies as $vocabulary) {
174     $select[$vocabulary->vid] = $vocabulary->name;
175     }
176 nancyw 1.19.2.13
177 jaza 1.17 $form['taxonomy_browser_vocabularies'] = array(
178     '#title' => t('Included Vocabularies'),
179 nancyw 1.19.2.23 '#type' => 'checkboxes',
180 jaza 1.17 '#default_value' => variable_get('taxonomy_browser_vocabularies', array()),
181     '#options' => $select,
182 nancyw 1.19.2.8 '#description' => t('Select the vocabularies the user can select from on the category browser page.'),
183 nancyw 1.19.2.23 '#prefix' => '<div class="taxonomy_browser_checkboxes">',
184     '#suffix' => '</div>',
185 nancyw 1.19.2.13 );
186 nancyw 1.19.2.18
187 nancyw 1.19.2.8 if (module_exists('node_type_filter')) {
188 nancyw 1.19.2.23 $filter_options = node_get_types('names');
189 nancyw 1.19.2.8 $form['taxonomy_browser_omit'] = array(
190 nancyw 1.19.2.23 '#type' => 'checkboxes',
191 nancyw 1.19.2.8 '#title' => t('Omit content types'),
192     '#options' => $filter_options,
193 nancyw 1.19.2.13 '#default_value' => variable_get('taxonomy_browser_omit', array('')),
194 nancyw 1.19.2.8 '#description' => t('If any of these types is selected, it will be omitted from the list on the "Category Browser" page.'),
195 nancyw 1.19.2.23 '#prefix' => '<div class="taxonomy_browser_checkboxes">',
196     '#suffix' => '</div>',
197 nancyw 1.19.2.13 );
198 nancyw 1.19.2.8 }
199 jaza 1.17
200 nancyw 1.19.2.12 return system_settings_form($form);
201 jaza 1.17 }
202    
203 nancyw 1.19.2.13 function taxonomy_browser_admin_settings_validate($form_id, &$form_values) {
204     if ($form_values['taxonomy_browser_count_nodes'] == false
205     && $form_values['taxonomy_browser_show_unused'] == true) {
206     form_set_error('taxonomy_browser_show_unused', t('"Show unused" requires "count nodes."'));
207     }
208     }
209    
210     //********************************************************************
211     //* Module Functions : Public
212     //********************************************************************
213 jaza 1.17
214     /**
215     * Menu callback: the query building interface for nodes selected based on
216     * taxonomy terms.
217     */
218     function taxonomy_browser_page() {
219 nancyw 1.19.2.1 $output .= drupal_get_form('taxonomy_browser_form');
220     return $output;
221     }
222    
223     function taxonomy_browser_form() {
224 jaza 1.17 $form = array();
225 nancyw 1.19.2.15 $selection_types = array('select', 'checkboxes');
226 nancyw 1.19.2.23 $select_type = $selection_types[variable_get('taxonomy_browser_select_type', 1)];
227 nancyw 1.19.2.10 $count_nodes = variable_get('taxonomy_browser_count_nodes', false);
228     $show_unused = variable_get('taxonomy_browser_show_unused', false);
229 nancyw 1.19.2.13 $allow_children = variable_get('taxonomy_browser_allow_children', false);
230 nancyw 1.19.2.14 $node_types = node_get_types('names');
231 jaza 1.17
232     $form['scope'] = array(
233     '#type' => 'fieldset',
234     '#title' => t('Scope'),
235 nancyw 1.19.2.14 '#collapsible' => true,
236     '#collapsed' => false,
237 nancyw 1.19.2.15 '#attributes' => array('class' => 'taxonomy_browser_scope'),
238     );
239 nancyw 1.19.2.13
240 nancyw 1.19.2.1 if (module_exists('node_type_filter')) {
241 nancyw 1.19.2.11 if ($count_nodes) {
242     $total_count = 0;
243 nancyw 1.19.2.20 $result = db_query('SELECT DISTINCT(type), COUNT(nid) AS count FROM {node} WHERE status=1 GROUP BY type ORDER BY type');
244 nancyw 1.19.2.11 while ($counter = db_fetch_array($result)) {
245 nancyw 1.19.2.14 // Check if we know about this type - a disabled module could have orphans.
246 nancyw 1.19.2.20 if (isset($node_types[$counter['type']])) {
247     $node_types[$counter['type']] .= ' ('. $counter['count'] .')';
248 nancyw 1.19.2.14 }
249     else {
250 nancyw 1.19.2.20 $node_types['unknown'] .= '<em>'. $counter['type'];
251     $node_types['unknown'] .= '</em>??? ('. $counter['count'] .') ';
252     watchdog('Taxonomy Browser', 'Unknown content type found: @type', array('@type' => $counter['type']), WATCHDOG_WARNING);
253 nancyw 1.19.2.14 }
254 nancyw 1.19.2.11 $total_count += $counter['count'];
255     }
256     }
257 nancyw 1.19.2.20
258 nancyw 1.19.2.24 $omit = array_filter(variable_get('taxonomy_browser_omit', array()));
259 nancyw 1.19.2.10 if (!empty($omit)) {
260 nancyw 1.19.2.13 foreach ($omit as $omit_type) {
261 nancyw 1.19.2.20 unset($node_types[$omit_type]);
262 nancyw 1.19.2.10 }
263     }
264 nancyw 1.19.2.22 $desc = t('Not selecting any type is the same as selecting all types.');
265     if ($count_nodes) {
266     $desc .= ' '. t('The total count of all types is !count.', array('!count' => $total_count));
267     }
268 jaza 1.17 $form['scope']['node_filter'] = array(
269 nancyw 1.19.2.6 // '#type' => 'checkboxes',
270 nancyw 1.19.2.15 '#type' => $select_type,
271 jaza 1.17 '#title' => t('Restrict search by content type'),
272 nancyw 1.19.2.15 '#options' => $node_types,
273     '#multiple' => true,
274     '#prefix' => '<div class="taxonomy_browser_checkboxes">',
275     '#suffix' => '</div>',
276 nancyw 1.19.2.22 '#description' => $desc,
277 nancyw 1.19.2.14 );
278 jaza 1.17 }
279 nancyw 1.19.2.17 else {
280     $form['scope']['node_filter'] = array(
281     '#type' => value,
282     '#value' => array(),
283     );
284     }
285    
286 jaza 1.17 $form['scope']['operator'] = array(
287     '#type' => 'radios',
288     '#title' => t('Items containing'),
289     '#options' => array(t('<strong>all</strong> terms'), t('<strong>any</strong> terms')),
290 nancyw 1.19.2.16 '#default_value' => variable_get('taxonomy_browser_default_op', 0),
291 nancyw 1.19.2.14 '#prefix' => '<div class="taxonomy_browser_radios">',
292 nancyw 1.19.2.15 '#suffix' => '</div>',
293 nancyw 1.19.2.14 );
294 jaza 1.17
295 nancyw 1.19.2.23 $vocabularies = array_filter(variable_get('taxonomy_browser_vocabularies', array()));
296     // drupal_set_message('variable: '. print_r($vocabularies, true));
297 nancyw 1.19.2.18 // Has the admin selected any vocabs?
298     if (count($vocabularies) == 0) {
299 nancyw 1.19.2.23 $vocabs = taxonomy_get_vocabularies();
300     foreach ($vocabs as $vocabulary) {
301     $vocabularies[$vocabulary->vid] = 1;
302     }
303     // drupal_set_message('all: '. print_r($vocabularies, true));
304 nancyw 1.19.2.18 }
305 nancyw 1.19.2.17
306 nancyw 1.19.2.13 if ($allow_children) {
307     $form['children'] = array(
308     '#type' => 'fieldset',
309     '#title' => t('Include Children'),
310 nancyw 1.19.2.14 '#collapsible' => true,
311     '#collapsed' => false,
312 nancyw 1.19.2.13 );
313     $form['children']['include_children'] = array(
314     '#type' => 'checkbox',
315     '#title' => t('Automatically include children (sub-terms)'),
316     '#description' => t('If you select a term with children (sub-terms), do you want those child terms automatically included in the search? This requires that "Items containing" be "any."'),
317     );
318     }
319     else {
320 nancyw 1.19.2.14 $form['include_children'] = array(
321 nancyw 1.19.2.13 '#type' => 'value',
322     '#value' => false,
323     );
324     }
325 jaza 1.17
326     $form['taxonomy'] = array(
327     '#type' => 'fieldset',
328     '#title' => t('Categories'),
329 nancyw 1.19.2.5 '#collapsible' => true,
330     '#collapsed' => false,
331 jaza 1.17 '#tree' => TRUE,
332     );
333 weitzman 1.19
334 nancyw 1.19.2.13 $selection_types = array('select', 'checkboxes');
335 weitzman 1.19 $i = 0;
336 nancyw 1.19.2.23 foreach ($vocabularies as $v => $sel) {
337 nancyw 1.19.2.10 $voc = taxonomy_get_vocabulary($v);
338 nancyw 1.19.2.14
339     $voc_node_types = array();
340     foreach ($voc->nodes as $key => $type) {
341     $voc_node_types[] = $node_types[$type];
342     }
343     $count_types = count($voc_node_types);
344     if (count($voc_node_types) == 1) {
345     $node_type_list = $voc_node_types[0];
346     }
347     else {
348     $node_type_list = implode(', ', $voc_node_types);
349     }
350    
351 nancyw 1.19.2.5 $tree = taxonomy_get_tree($v);
352     $term_opts = array();
353    
354     if ($tree) {
355     foreach ($tree as $term) {
356 nancyw 1.19.2.13 $opt_string = null;
357 nancyw 1.19.2.10 if ($count_nodes) {
358 nancyw 1.19.2.25 // $count = db_result(db_query('SELECT COUNT(nid) FROM {term_node} WHERE tid=%d', $term->tid));
359     $count = taxonomy_term_count_nodes($term->tid);
360 nancyw 1.19.2.10 if ($count > 0 || $show_unused) {
361 nancyw 1.19.2.28 $opt_string = decode_entities(check_plain($term->name)) .' ('. $count .')';
362 nancyw 1.19.2.10 }
363     }
364     else {
365 nancyw 1.19.2.28 $opt_string = decode_entities(check_plain($term->name));
366 nancyw 1.19.2.13 }
367     if ($opt_string) {
368     $term_opts[$term->tid] = str_repeat('-', $term->depth) . $opt_string;
369 nancyw 1.19.2.10 }
370 nancyw 1.19.2.5 }
371     }
372    
373 nancyw 1.19.2.21 $vocname = filter_xss($voc->name);
374 nancyw 1.19.2.10 if (!empty($term_opts)) {
375 nancyw 1.19.2.13 $form['taxonomy'][$v] = array(
376     '#type' => $select_type,
377 nancyw 1.19.2.21 '#title' => $vocname,
378 nancyw 1.19.2.10 '#options' => $term_opts,
379     '#multiple' => true,
380 nancyw 1.19.2.15 '#description' => $voc->description
381 nancyw 1.19.2.21 .' &nbsp;'. t('"!name" is used for: !types.', array('!name' => '<strong>'. $vocname .'</strong>', '!types' => $node_type_list)),
382 nancyw 1.19.2.10 '#size' => min(10, count($term_opts)),
383 nancyw 1.19.2.13 '#prefix' => '<div class="taxonomy_browser_'. $select_type .'">',
384 nancyw 1.19.2.15 '#suffix' => '</div>',
385 nancyw 1.19.2.14 '#field_suffix' => $node_type_list,
386 nancyw 1.19.2.10 '#weight' => $i,
387     );
388 nancyw 1.19.2.14 ++$i;
389 nancyw 1.19.2.10 }
390 jaza 1.17 }
391    
392     $form['submit'] = array(
393     '#type' => 'submit',
394     '#value' => t('Search'),
395 nancyw 1.19.2.5 '#submit' => TRUE,
396 nancyw 1.19.2.14 );
397 nancyw 1.19.2.1
398     return $form;
399 jaza 1.17 }
400    
401     /**
402     * Themable form output for the category browser page.
403     */
404     function theme_taxonomy_browser_page($form) {
405     $output = '';
406    
407     $vocabularies = variable_get('taxonomy_browser_vocabularies', array());
408     if (empty($vocabularies)) {
409 nancyw 1.19.2.2 form_set_error('taxonomy_browser_page', t('You must select the vocabularies to display from the <a href="%link">taxonomy browser settings page</a>.', array('%link' => url('admin/settings/taxonomy_browser'))));
410 jaza 1.17 return ' ';
411     }
412    
413 nancyw 1.19.2.2 $output .= drupal_render($form);
414 jaza 1.17 return $output;
415     }
416    
417     /**
418     * Implementation of hook_form_validate().
419     */
420 nancyw 1.19.2.13 function taxonomy_browser_form_validate($form_id, &$form_values) {
421    
422     $include_children = $form_values['include_children'];
423     $tids = _taxonomy_browser_get_tid_list($form_values['taxonomy'], $include_children);
424    
425     $operator = $form_values['operator'] ? 'or' : 'and';
426    
427     if ($operator == 'and' && $include_children == true) {
428     form_set_error('operator', t('You must use "Items containing <strong>any</strong>" to include child terms.'));
429     }
430    
431 jaza 1.17 if (empty($tids)) {
432     form_set_error('taxonomy', t('You must select at least one category in your search.'));
433     }
434     else {
435 nancyw 1.19.2.15 // $node_type = (isset($form_values['node_filter']) && $form_values['node_filter'] != 'all') ? $form_values['node_filter'] : NULL;
436     $node_type = str_replace(',0', '', implode(',', $form_values['node_filter']));
437 nancyw 1.19.2.18
438 jaza 1.17 if (!taxonomy_browser_count_nodes($tids, $operator, 0, $node_type)) {
439     form_set_error('taxonomy', t('No posts match your criteria.'));
440     }
441     }
442     }
443    
444     /**
445     * Implementation of hook_form_submit().
446     */
447 nancyw 1.19.2.13 function taxonomy_browser_form_submit($form_id, &$form_values) {
448 jaza 1.17 $tids = _taxonomy_browser_get_tid_list();
449 nancyw 1.19.2.1
450 jaza 1.17 $operator = $form_values['operator'] ? 'or' : 'and';
451     $str_tids = ($operator == 'and') ? implode(',', $tids) : implode('+', $tids);
452    
453 nancyw 1.19.2.15 $types = array_filter($form_values['node_filter']);
454     $node_type = str_replace(',0', '', implode(',', $types));
455    
456     if ($types) {
457     return array('taxonomy/term/'. $str_tids, 'type='. $node_type);
458     }
459     else {
460     return 'taxonomy/term/'. $str_tids;
461     }
462    
463 jaza 1.17 }
464    
465 nancyw 1.19.2.13 //********************************************************************
466 nancyw 1.19.2.21 //* Module Functions : Private
467 nancyw 1.19.2.13 //********************************************************************
468 jaza 1.17
469     /**
470 nancyw 1.19.2.21 * Get the output to be displayed by the block.
471     *
472     * @param
473     * $delta - integer for the block number.
474     *
475     * @return
476     * array containing the title ("subject") and content of the block.
477     */
478     function _taxonomy_browser_block_view($delta) {
479     $block = array();
480     switch ($delta) {
481     case 0:
482     $block = array(
483     'content' => drupal_get_form('taxonomy_browser_form'),
484     );
485     break;
486     }
487     return $block;
488     }
489    
490     /**
491 jaza 1.17 * Private function to count the number of nodes found by the user's query.
492     */
493     function taxonomy_browser_count_nodes($tids = array(), $operator = 'or', $depth = 0, $nodetype = NULL) {
494     if (count($tids) > 0) {
495     // For each term ID, generate an array of descendant term IDs to the right depth.
496     $descendant_tids = array();
497     if ($depth === 'all') {
498     $depth = NULL;
499     }
500     foreach ($tids as $index => $tid) {
501     $term = taxonomy_get_term($tid);
502     $tree = taxonomy_get_tree($term->vid, $tid, -1, $depth);
503     $descendant_tids[] = array_merge(array($tid), array_map('_taxonomy_get_tid_from_term', $tree));
504     }
505    
506 nancyw 1.19.2.3 $type_where = null;
507     if ($nodetype) {
508 nancyw 1.19.2.15 // $type_where = "n.type = '". db_escape_string($nodetype) ."'";
509     $type_where = "n.type IN ('". implode("', '", explode(',', db_escape_string($nodetype))) ."')";
510 nancyw 1.19.2.3 }
511 nancyw 1.19.2.15
512 jaza 1.17 if ($operator == 'or') {
513     $str_tids = implode(',', call_user_func_array('array_merge', $descendant_tids));
514 nancyw 1.19.2.3 $sql_count = 'SELECT COUNT(n.nid) FROM {node} n INNER JOIN {term_node} tn USING(nid) WHERE '. ($type_where ? $type_where .' AND ' : null) ."tn.tid IN ($str_tids) ORDER BY n.sticky DESC, n.title ASC";
515 jaza 1.17 }
516     else {
517     $joins = '';
518     $wheres = array();
519 nancyw 1.19.2.3 if ($type_where) {
520     $wheres[] = $type_where;
521     }
522 jaza 1.17 foreach ($descendant_tids as $index => $tids) {
523 nancyw 1.19.2.13 $joins .= 'INNER JOIN {term_node} tn'. $index .' ON n.nid = tn'. $index .'.nid ';
524 jaza 1.17 $wheres[] = 'tn'. $index .'.tid IN ('. implode(',', $tids) .')';
525     }
526 nancyw 1.19.2.13 $sql_count = 'SELECT COUNT(n.nid) FROM {node} n '. $joins .' WHERE '. implode(' AND ', $wheres);
527 jaza 1.17 }
528    
529 nancyw 1.19.2.15 // drupal_set_message('Count query: '. $sql_count);
530 jaza 1.17 return db_result(db_query(db_rewrite_sql($sql_count)));
531     }
532    
533     return 0;
534     }
535    
536     /**
537     * Transforms an unpredictably and irregularly nested set of tids (as returned
538     * from a taxonomy form) into a linear array of tids.
539     */
540 nancyw 1.19.2.13 function _taxonomy_browser_get_tid_list($tids = null, $include_children = false) {
541 jaza 1.17 static $tid_list;
542 nancyw 1.19.2.13
543 jaza 1.17 if (isset($tids) && is_array($tids)) {
544     $tid_list = array();
545     foreach ($tids as $key => $tid) {
546     if (!empty($tid)) {
547     if (is_array($tid)) {
548     foreach ($tid as $key2 => $tid2) {
549     if (!empty($tid2)) {
550 nancyw 1.19.2.13 $tid_list[$tid2] = $tid2;
551 jaza 1.17 }
552     }
553     }
554     else {
555 nancyw 1.19.2.13 $tid_list[$tid] = $tid;
556 jaza 1.17 }
557 nancyw 1.19.2.13 } /* end !empty */
558     } /* end foreach */
559 jaza 1.17 }
560    
561 nancyw 1.19.2.13 if ($include_children) {
562     foreach ($tid_list as $tid) {
563     _taxonomy_browser_get_kids($tid_list, $tid);
564     }
565     }
566    
567 jaza 1.17 return $tid_list;
568     }
569    
570 nancyw 1.19.2.13 function _taxonomy_browser_get_kids(&$tid_list, $tid) {
571     $children = taxonomy_get_children($tid);
572     if ($children) {
573     foreach ($children as $child_tid => $child_term) {
574     _taxonomy_browser_get_kids($tid_list, $child_tid);
575     }
576     }
577     else {
578     $tid_list[$tid] = $tid;
579     }
580     }
581    
582 jaza 1.17 /**
583     * Provides default guideline text.
584     */
585     function _taxonomy_browser_guidelines_default() {
586     return t('<p>You may select multiple items from each list by holding down the <code>Ctrl</code> (Mac: <code>command</code>) key while left-clicking each item.</p>');
587     }

  ViewVC Help
Powered by ViewVC 1.1.2