modules/taxonomy_browser/taxonomy_browser.module

<?php
// $Id: taxonomy_browser.module,v 1.19.2.28 2008/06/20 04:08:03 nancyw Exp $
// Original by Moshe Weitzman (weitzmna@tejasa.com)

/**
 * @file
 *   Enables users to construct their own view of content from terms across 
 *   multiple vocabularies.
 */

//*******************************************************************
//* Drupal Hooks : General Overview
//*******************************************************************

/**
 * Implementation of hook_menu().
 */
function taxonomy_browser_menu($may_cache) {
  $items = array();

  if ($may_cache) {
    $items[] = array(
      'path' => 'admin/settings/taxonomy-browser',
      'title' => t('Taxonomy Browser'),
      'description' => t('Set usage guidelines and included vocabularies.'),
      'callback' => 'drupal_get_form',
      'callback arguments' => 'taxonomy_browser_admin_settings',
      'access' => user_access('administer site configuration'),    
      );
  }
  else {
    $items[] = array(
      'path' => 'taxonomy_browser',
      'title' => t('Category Browser'),
      'access' => user_access(variable_get('taxonomy_browser_need_perm', false) ? 'access taxonomy browser' : 'access content'),
      'callback' => 'taxonomy_browser_page',
      'description' => t('Find content on your own terms.'),
      'type' => MENU_NORMAL_ITEM,
      );

    drupal_add_css(drupal_get_path('module', 'taxonomy_browser') .'/taxonomy_browser.css');
  }

  return $items;
}

/**
 * Implementation of hook_help().
 */
function taxonomy_browser_help($section = '') {
  switch ($section) {
    case 'admin/modules#description':
      return t('An interface for viewing content grouped by arbitrary taxonomy terms.');
    case 'taxonomy_browser':
      $output = check_markup(variable_get('taxonomy_browser_guidelines', _taxonomy_browser_guidelines_default()));
      if (user_access('administer site configuration')) {
        $output .= '<p class="links">'. l(t('Go to Taxonomy Browser settings'), 'admin/settings/taxonomy-browser', array(), drupal_get_destination()) .'</p>';
      }
      return $output;
  }
}

/**
 * Implementation of hook_perm().
 */
function taxonomy_browser_perm() {
  if (variable_get('taxonomy_browser_need_perm', false)) {
    return array('access taxonomy browser');
  }
  else {
    return array();
  }
}

//********************************************************************
//* Drupal Hooks : Core
//********************************************************************

/**
 * Implementation of hook_block().
 */
function taxonomy_browser_block($op = 'list', $delta = 0, $edit = array()) {
  $block = array();
  switch ($op) {
    case 'list':
      $block[0]['info'] = t('Category browser');
      return $block;

    case 'view':
      switch ($delta) {
        case 0:
          $block = _taxonomy_browser_block_view($delta);
          break;
      }
      return $block;
//
//    case 'configure':
//      return _taxonomy_browser_block_configure($delta);
//
//    case 'save':
//      _taxonomy_browser_block_save($delta, $edit);
  }
}

/**
 * Implementation of hook_form().
 */
function taxonomy_browser_admin_settings() {
  if (!module_exists('node_type_filter') && !drupal_set_message()) {
    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');
  }

  drupal_add_js(drupal_get_path('module', 'taxonomy_browser') .'/taxonomy_browser.js', 'module');
  
  $form['taxonomy_browser_guidelines'] = array(
    '#title' => t('Guidelines'),
    '#type' => 'textarea',
    '#default_value' => variable_get('taxonomy_browser_guidelines', _taxonomy_browser_guidelines_default()),
    '#rows' => 2,
    '#description' => t('Instructions which should appear at top of the category browser main page'),
    );
  
  $form['taxonomy_browser_select_type'] = array(
    '#title' => t('Selection type'),
    '#type' => 'radios',
    '#default_value' => variable_get('taxonomy_browser_select_type', 1),
    '#options' => array(t('Selection box'), t('Check boxes')),
    '#description' => t('This option determines whether the user will see a selection list or check boxes.'),
    '#prefix' => '<div class="taxonomy_browser_radios">',
    '#suffix' => '</div>',
    );

  $form['taxonomy_browser_default_op'] = array(
    '#title' => t('"Items containing" default'),
    '#type' => 'radios',
    '#default_value' => variable_get('taxonomy_browser_default_op', 0),
    '#options' => array(t('All'), t('Any')),
    '#description' => t('This option determines which "Items containing" choice is the default.'),
    '#prefix' => '<div class="taxonomy_browser_radios">',
    '#suffix' => '</div>',
    );
  
  $form['taxonomy_browser_count_nodes'] = array(
    '#title' => t('Show node count'),
    '#type' => 'checkbox',
    '#default_value' => variable_get('taxonomy_browser_count_nodes', false),
    '#description' => t('Do you want to display the count of nodes tagged with each term? This can be SQL-intensive.'),
    );
  
  $form['taxonomy_browser_show_unused'] = array(
    '#title' => t('Show unused terms'),
    '#type' => 'checkbox',
    '#default_value' => variable_get('taxonomy_browser_show_unused', false),
    '#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.'),
    );
  
  $form['taxonomy_browser_allow_children'] = array(
    '#title' => t('Allow child terms to be included'),
    '#type' => 'checkbox',
    '#default_value' => variable_get('taxonomy_browser_allow_children', false),
    '#description' => t('Do you want the user to see a check box to include child terms (sub-terms)?'),
    );

  $form['taxonomy_browser_need_perm'] = array(
    '#title' => t('Requires permission'),
    '#type' => 'checkbox',
    '#default_value' => variable_get('taxonomy_browser_need_perm', false),
    '#description' => t('Do you want to require permission to see the browser page?'),
    );

  $select = array();
  $vocabularies = taxonomy_get_vocabularies();
  foreach ($vocabularies as $vocabulary) {
    $select[$vocabulary->vid] = $vocabulary->name;
  }

  $current_vocabs = variable_get('taxonomy_browser_vocabularies', array());
  // Occasionally we get a 0 vid in the array.
  unset($current_vocabs[0]);

  $form['taxonomy_browser_vocabularies'] = array(
    '#title' => t('Included Vocabularies'),
    '#type' => 'checkboxes',
    '#default_value' => $current_vocabs,
    '#options' => $select,
    '#description' => t('Select the vocabularies the user can select from on the category browser page.'),
    '#prefix' => '<div class="taxonomy_browser_checkboxes">',
    '#suffix' => '</div>',
    );

  if (module_exists('node_type_filter')) {
    $filter_options = node_get_types('names'); 
    $form['taxonomy_browser_omit'] = array(
      '#type' => 'checkboxes',
      '#title' => t('Omit content types'),
      '#options' => $filter_options,
      '#default_value' => variable_get('taxonomy_browser_omit', array('')),
      '#description' => t('If any of these types is selected, it will be omitted from the list on the "Category Browser" page.'),
      '#prefix' => '<div class="taxonomy_browser_checkboxes">',
      '#suffix' => '</div>',
      );
  }

  return system_settings_form($form);
}

function taxonomy_browser_admin_settings_validate($form_id, &$form_values) {
  if ($form_values['taxonomy_browser_count_nodes'] == false
    && $form_values['taxonomy_browser_show_unused'] == true) {
    form_set_error('taxonomy_browser_show_unused', t('"Show unused" requires "count nodes."'));
  }
}

//********************************************************************
//* Module Functions : Public
//********************************************************************

/**
 * Menu callback: the query building interface for nodes selected based on 
 * taxonomy terms.
 */
function taxonomy_browser_page() {
  $output .= drupal_get_form('taxonomy_browser_form');
  return $output;
}

function taxonomy_browser_form() {
  $form = array();
  $selection_types = array('select', 'checkboxes');
  $select_type = $selection_types[variable_get('taxonomy_browser_select_type', 1)];
  $count_nodes = variable_get('taxonomy_browser_count_nodes', false);
  $show_unused = variable_get('taxonomy_browser_show_unused', false);
  $allow_children = variable_get('taxonomy_browser_allow_children', false);
  $node_types = node_get_types('names');
  
  $form['scope'] = array(
    '#type' => 'fieldset',
    '#title' => t('Scope'),
    '#collapsible' => true,
    '#collapsed' => false,
    '#attributes' => array('class' => 'taxonomy_browser_scope'),
    );

  if (module_exists('node_type_filter')) {
    if ($count_nodes) {
      $total_count = 0;
      $result = db_query('SELECT DISTINCT(type), COUNT(nid) AS count FROM {node} WHERE status=1 GROUP BY type ORDER BY type');
      while ($counter = db_fetch_array($result)) {
        // Check if we know about this type - a disabled module could have orphans.
        if (isset($node_types[$counter['type']])) {
          $node_types[$counter['type']] .= ' ('. $counter['count'] .')';
        }
        else {
          $node_types['unknown'] .= '<em>'. $counter['type'];
          $node_types['unknown'] .= '</em>??? ('. $counter['count'] .') ';
          watchdog('Taxonomy Browser', 'Unknown content type found: @type', array('@type' => $counter['type']), WATCHDOG_WARNING);
        }
        $total_count += $counter['count'];
      }
    }

    $omit = array_filter(variable_get('taxonomy_browser_omit', array()));
    if (!empty($omit)) {
      foreach ($omit as $omit_type) {
        unset($node_types[$omit_type]);
      }
    }
    $desc = t('Not selecting any type is the same as selecting all types.');
    if ($count_nodes) {
      $desc .= ' '. t('The total count of all types is !count.', array('!count' => $total_count));
    }
    $form['scope']['node_filter'] = array(
//      '#type' => 'checkboxes',
      '#type' => $select_type,
      '#title' => t('Restrict search by content type'),
      '#options' => $node_types,
      '#multiple' => true,
      '#prefix' => '<div class="taxonomy_browser_checkboxes">',
      '#suffix' => '</div>',
      '#description' => $desc,
      );
  }
  else {
    $form['scope']['node_filter'] = array(
      '#type' => value,
      '#value' => array(),
      );
  }

  $form['scope']['operator'] = array(
    '#type' => 'radios',
    '#title' => t('Items containing'),
    '#options' => array(t('<strong>all</strong> terms'), t('<strong>any</strong> terms')),
    '#default_value' => variable_get('taxonomy_browser_default_op', 0),
    '#prefix' => '<div class="taxonomy_browser_radios">',
    '#suffix' => '</div>',
    );

  $vocabularies = array_filter(variable_get('taxonomy_browser_vocabularies', array()));
  // Occasionally we get a 0 vid in the array.
  unset($vocabularies[0]);

  // Has the admin selected any vocabs?
  if (count($vocabularies) == 0) {
    $vocabs = taxonomy_get_vocabularies();
    foreach ($vocabs as $vocabulary) {
      $vocabularies[$vocabulary->vid] = 1;
    }
  }

  if ($allow_children) {
    $form['children'] = array(
      '#type' => 'fieldset',
      '#title' => t('Include Children'),
      '#collapsible' => true,
      '#collapsed' => false,
      );
    $form['children']['include_children'] = array(
      '#type' => 'checkbox',
      '#title' => t('Automatically include children (sub-terms)'),
      '#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."'),
      );
  }
  else {
    $form['include_children'] = array(
      '#type' => 'value',
      '#value' => false,
      );
  }

  $form['taxonomy'] = array(
    '#type' => 'fieldset',
    '#title' => t('Categories'),
    '#collapsible' => true,
    '#collapsed' => false,
    '#tree' => TRUE,
  );

  $selection_types = array('select', 'checkboxes');
  $i = 0;
  foreach ($vocabularies as $v => $sel) {
    $voc = taxonomy_get_vocabulary($v);

    $voc_node_types = array();
    foreach ($voc->nodes as $key => $type) {
      $voc_node_types[] = $node_types[$type];
    }
    $count_types = count($voc_node_types);
    if (count($voc_node_types) == 1) {
      $node_type_list = $voc_node_types[0];
    }
    else {
      $node_type_list = implode(', ', $voc_node_types);
    }

    $tree = taxonomy_get_tree($v);
    $term_opts = array();

    if ($tree) {
      foreach ($tree as $term) {
        $opt_string = null;
        if ($count_nodes) {
//          $count = db_result(db_query('SELECT COUNT(nid) FROM {term_node} WHERE tid=%d', $term->tid));
          $count = taxonomy_term_count_nodes($term->tid);
          if ($count > 0 || $show_unused) {
            $opt_string = decode_entities(check_plain($term->name)) .' ('. $count .')';
          }
        }
        else {
          $opt_string = decode_entities(check_plain($term->name));
        }
        if ($opt_string) {
          $term_opts[$term->tid] = str_repeat('-', $term->depth) . $opt_string;
        }
      }
    }

    $vocname = filter_xss($voc->name);
    if (!empty($term_opts)) {
      $form['taxonomy'][$v] = array(
        '#type' => $select_type,
        '#title' => $vocname,
        '#options' => $term_opts,
        '#multiple' => true,
        '#description' => $voc->description
           .' &nbsp;'. t('"!name" is used for: !types.', array('!name' => '<strong>'. $vocname .'</strong>', '!types' => $node_type_list)),
        '#size' => min(10, count($term_opts)),
        '#prefix' => '<div class="taxonomy_browser_'. $select_type .'">',
        '#suffix' => '</div>',
        '#field_suffix' => $node_type_list,
        '#weight' => $i,
        );
      ++$i;
    }
  }
  
  $form['submit'] = array(
    '#type' => 'submit',
    '#value' => t('Search'),
    '#submit' => TRUE,
    );
  
  return $form;
}

/**
 * Themable form output for the category browser page.
 */
function theme_taxonomy_browser_page($form) {
  $output = '';
  
  $vocabularies = variable_get('taxonomy_browser_vocabularies', array());
  if (empty($vocabularies)) {
    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'))));
    return ' ';
  }
  
  $output .= drupal_render($form);
  return $output;
}

/**
 * Implementation of hook_form_validate().
 */
function taxonomy_browser_form_validate($form_id, &$form_values) {

  $include_children = $form_values['include_children'];
  $tids = _taxonomy_browser_get_tid_list($form_values['taxonomy'], $include_children);

  $operator = $form_values['operator'] ? 'or' : 'and';

  if ($operator == 'and' && $include_children == true) {
    form_set_error('operator', t('You must use "Items containing <strong>any</strong>" to include child terms.'));
  }

  if (empty($tids)) {
    form_set_error('taxonomy', t('You must select at least one category in your search.'));
  }
  else {
//    $node_type = (isset($form_values['node_filter']) && $form_values['node_filter'] != 'all') ? $form_values['node_filter'] : NULL;
    $node_type = str_replace(',0', '', implode(',', $form_values['node_filter']));

    if (!taxonomy_browser_count_nodes($tids, $operator, 0, $node_type)) {
      form_set_error('taxonomy', t('No posts match your criteria.'));
    }
  }
}

/**
 * Implementation of hook_form_submit().
 */
function taxonomy_browser_form_submit($form_id, &$form_values) {
  $tids = _taxonomy_browser_get_tid_list();

  $operator = $form_values['operator'] ? 'or' : 'and';
  $str_tids = ($operator == 'and') ? implode(',', $tids) : implode('+', $tids);
  
  $types = array_filter($form_values['node_filter']);
  $node_type = str_replace(',0', '', implode(',', $types));
  
  if ($types) {
    return array('taxonomy/term/'. $str_tids, 'type='. $node_type);
  }
  else {
    return 'taxonomy/term/'. $str_tids;
  }
  
}

//********************************************************************
//* Module Functions : Private
//********************************************************************

/**
 * Get the output to be displayed by the block.
 *
 * @param
 *   $delta - integer for the block number.
 *
 * @return
 *   array containing the title ("subject") and content of the block.
 */
function _taxonomy_browser_block_view($delta) {
  $block = array();
  switch ($delta) {
    case 0:
      $block = array(
        'content' => drupal_get_form('taxonomy_browser_form'),
        );
      break;
  }
  return $block;
}

/**
 * Private function to count the number of nodes found by the user's query.
 */
function taxonomy_browser_count_nodes($tids = array(), $operator = 'or', $depth = 0, $nodetype = NULL) {
  if (count($tids) > 0) {
    // For each term ID, generate an array of descendant term IDs to the right depth.
    $descendant_tids = array();
    if ($depth === 'all') {
      $depth = NULL;
    }
    foreach ($tids as $index => $tid) {
      $term = taxonomy_get_term($tid);
      $tree = taxonomy_get_tree($term->vid, $tid, -1, $depth);
      $descendant_tids[] = array_merge(array($tid), array_map('_taxonomy_get_tid_from_term', $tree));
    }

    $type_where = null;
    if ($nodetype) {
//      $type_where = "n.type = '". db_escape_string($nodetype) ."'";
      $type_where = "n.type IN ('". implode("', '", explode(',', db_escape_string($nodetype))) ."')";
    }

    if ($operator == 'or') {
      $str_tids = implode(',', call_user_func_array('array_merge', $descendant_tids));
      $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";
    }
    else {
      $joins = '';
      $wheres = array();
      if ($type_where) {
        $wheres[] = $type_where;
      }
      foreach ($descendant_tids as $index => $tids) {
        $joins .= 'INNER JOIN {term_node} tn'. $index .' ON n.nid = tn'. $index .'.nid ';
        $wheres[] = 'tn'. $index .'.tid IN ('. implode(',', $tids) .')';
      }
      $sql_count = 'SELECT COUNT(n.nid) FROM {node} n '. $joins .' WHERE '. implode(' AND ', $wheres);
    }

//    drupal_set_message('Count query: '. $sql_count);
    return db_result(db_query(db_rewrite_sql($sql_count)));
  }

  return 0;
}

/**
 * Transforms an unpredictably and irregularly nested set of tids (as returned 
 * from a taxonomy form) into a linear array of tids.
 */
function _taxonomy_browser_get_tid_list($tids = null, $include_children = false) {
  static $tid_list;

  if (isset($tids) && is_array($tids)) {
    $tid_list = array();
    foreach ($tids as $key => $tid) {
      if (!empty($tid)) {
        if (is_array($tid)) {
          foreach ($tid as $key2 => $tid2) {
            if (!empty($tid2)) {
              $tid_list[$tid2] = $tid2;
            }
          }
        }
        else {
          $tid_list[$tid] = $tid;
        }
      } /* end !empty */
    } /* end foreach */
  }
  
  if ($include_children) {
    foreach ($tid_list as $tid) {
      _taxonomy_browser_get_kids($tid_list, $tid);
    }
  }

  return $tid_list;
}

function _taxonomy_browser_get_kids(&$tid_list, $tid) {
  $children = taxonomy_get_children($tid);
  if ($children) {
    foreach ($children as $child_tid => $child_term) {
      _taxonomy_browser_get_kids($tid_list, $child_tid);
    }
  }
  else {
    $tid_list[$tid] = $tid;
  }
}

/**
 * Provides default guideline text.
 */
function _taxonomy_browser_guidelines_default() {
  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>');
}
1	<?php
2	// $Id: taxonomy_browser.module,v 1.19.2.28 2008/06/20 04:08:03 nancyw Exp $
3	// Original by Moshe Weitzman (weitzmna@tejasa.com)
4
5	/**
6	* @file
7	* Enables users to construct their own view of content from terms across
8	* multiple vocabularies.
9	*/
10
11	//*******************************************************************
12	//* Drupal Hooks : General Overview
13	//*******************************************************************
14
15	/**
16	* Implementation of hook_menu().
17	*/
18	function taxonomy_browser_menu($may_cache) {
19	$items = array();
20
21	if ($may_cache) {
22	$items[] = array(
23	'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	$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	'type' => MENU_NORMAL_ITEM,
39	);
40
41	drupal_add_css(drupal_get_path('module', 'taxonomy_browser') .'/taxonomy_browser.css');
42	}
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	$output = check_markup(variable_get('taxonomy_browser_guidelines', _taxonomy_browser_guidelines_default()));
56	if (user_access('administer site configuration')) {
57	$output .= '<p class="links">'. l(t('Go to Taxonomy Browser settings'), 'admin/settings/taxonomy-browser', array(), drupal_get_destination()) .'</p>';
58	}
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	}
73	}
74
75	//********************************************************************
76	//* Drupal Hooks : Core
77	//********************************************************************
78
79	/**
80	* 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	switch ($delta) {
91	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	* Implementation of hook_form().
107	*/
108	function taxonomy_browser_admin_settings() {
109	if (!module_exists('node_type_filter') && !drupal_set_message()) {
110	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	}
112
113	drupal_add_js(drupal_get_path('module', 'taxonomy_browser') .'/taxonomy_browser.js', 'module');
114
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	'#rows' => 2,
120	'#description' => t('Instructions which should appear at top of the category browser main page'),
121	);
122
123	$form['taxonomy_browser_select_type'] = array(
124	'#title' => t('Selection type'),
125	'#type' => 'radios',
126	'#default_value' => variable_get('taxonomy_browser_select_type', 1),
127	'#options' => array(t('Selection box'), t('Check boxes')),
128	'#description' => t('This option determines whether the user will see a selection list or check boxes.'),
129	'#prefix' => '<div class="taxonomy_browser_radios">',
130	'#suffix' => '</div>',
131	);
132
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
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	);
149
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	'#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	);
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
164	$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	$select = array();
172	$vocabularies = taxonomy_get_vocabularies();
173	foreach ($vocabularies as $vocabulary) {
174	$select[$vocabulary->vid] = $vocabulary->name;
175	}
176
177	$current_vocabs = variable_get('taxonomy_browser_vocabularies', array());
178	// Occasionally we get a 0 vid in the array.
179	unset($current_vocabs[0]);
180
181	$form['taxonomy_browser_vocabularies'] = array(
182	'#title' => t('Included Vocabularies'),
183	'#type' => 'checkboxes',
184	'#default_value' => $current_vocabs,
185	'#options' => $select,
186	'#description' => t('Select the vocabularies the user can select from on the category browser page.'),
187	'#prefix' => '<div class="taxonomy_browser_checkboxes">',
188	'#suffix' => '</div>',
189	);
190
191	if (module_exists('node_type_filter')) {
192	$filter_options = node_get_types('names');
193	$form['taxonomy_browser_omit'] = array(
194	'#type' => 'checkboxes',
195	'#title' => t('Omit content types'),
196	'#options' => $filter_options,
197	'#default_value' => variable_get('taxonomy_browser_omit', array('')),
198	'#description' => t('If any of these types is selected, it will be omitted from the list on the "Category Browser" page.'),
199	'#prefix' => '<div class="taxonomy_browser_checkboxes">',
200	'#suffix' => '</div>',
201	);
202	}
203
204	return system_settings_form($form);
205	}
206
207	function taxonomy_browser_admin_settings_validate($form_id, &$form_values) {
208	if ($form_values['taxonomy_browser_count_nodes'] == false
209	&& $form_values['taxonomy_browser_show_unused'] == true) {
210	form_set_error('taxonomy_browser_show_unused', t('"Show unused" requires "count nodes."'));
211	}
212	}
213
214	//********************************************************************
215	//* Module Functions : Public
216	//********************************************************************
217
218	/**
219	* Menu callback: the query building interface for nodes selected based on
220	* taxonomy terms.
221	*/
222	function taxonomy_browser_page() {
223	$output .= drupal_get_form('taxonomy_browser_form');
224	return $output;
225	}
226
227	function taxonomy_browser_form() {
228	$form = array();
229	$selection_types = array('select', 'checkboxes');
230	$select_type = $selection_types[variable_get('taxonomy_browser_select_type', 1)];
231	$count_nodes = variable_get('taxonomy_browser_count_nodes', false);
232	$show_unused = variable_get('taxonomy_browser_show_unused', false);
233	$allow_children = variable_get('taxonomy_browser_allow_children', false);
234	$node_types = node_get_types('names');
235
236	$form['scope'] = array(
237	'#type' => 'fieldset',
238	'#title' => t('Scope'),
239	'#collapsible' => true,
240	'#collapsed' => false,
241	'#attributes' => array('class' => 'taxonomy_browser_scope'),
242	);
243
244	if (module_exists('node_type_filter')) {
245	if ($count_nodes) {
246	$total_count = 0;
247	$result = db_query('SELECT DISTINCT(type), COUNT(nid) AS count FROM {node} WHERE status=1 GROUP BY type ORDER BY type');
248	while ($counter = db_fetch_array($result)) {
249	// Check if we know about this type - a disabled module could have orphans.
250	if (isset($node_types[$counter['type']])) {
251	$node_types[$counter['type']] .= ' ('. $counter['count'] .')';
252	}
253	else {
254	$node_types['unknown'] .= '<em>'. $counter['type'];
255	$node_types['unknown'] .= '</em>??? ('. $counter['count'] .') ';
256	watchdog('Taxonomy Browser', 'Unknown content type found: @type', array('@type' => $counter['type']), WATCHDOG_WARNING);
257	}
258	$total_count += $counter['count'];
259	}
260	}
261
262	$omit = array_filter(variable_get('taxonomy_browser_omit', array()));
263	if (!empty($omit)) {
264	foreach ($omit as $omit_type) {
265	unset($node_types[$omit_type]);
266	}
267	}
268	$desc = t('Not selecting any type is the same as selecting all types.');
269	if ($count_nodes) {
270	$desc .= ' '. t('The total count of all types is !count.', array('!count' => $total_count));
271	}
272	$form['scope']['node_filter'] = array(
273	// '#type' => 'checkboxes',
274	'#type' => $select_type,
275	'#title' => t('Restrict search by content type'),
276	'#options' => $node_types,
277	'#multiple' => true,
278	'#prefix' => '<div class="taxonomy_browser_checkboxes">',
279	'#suffix' => '</div>',
280	'#description' => $desc,
281	);
282	}
283	else {
284	$form['scope']['node_filter'] = array(
285	'#type' => value,
286	'#value' => array(),
287	);
288	}
289
290	$form['scope']['operator'] = array(
291	'#type' => 'radios',
292	'#title' => t('Items containing'),
293	'#options' => array(t('<strong>all</strong> terms'), t('<strong>any</strong> terms')),
294	'#default_value' => variable_get('taxonomy_browser_default_op', 0),
295	'#prefix' => '<div class="taxonomy_browser_radios">',
296	'#suffix' => '</div>',
297	);
298
299	$vocabularies = array_filter(variable_get('taxonomy_browser_vocabularies', array()));
300	// Occasionally we get a 0 vid in the array.
301	unset($vocabularies[0]);
302
303	// Has the admin selected any vocabs?
304	if (count($vocabularies) == 0) {
305	$vocabs = taxonomy_get_vocabularies();
306	foreach ($vocabs as $vocabulary) {
307	$vocabularies[$vocabulary->vid] = 1;
308	}
309	}
310
311	if ($allow_children) {
312	$form['children'] = array(
313	'#type' => 'fieldset',
314	'#title' => t('Include Children'),
315	'#collapsible' => true,
316	'#collapsed' => false,
317	);
318	$form['children']['include_children'] = array(
319	'#type' => 'checkbox',
320	'#title' => t('Automatically include children (sub-terms)'),
321	'#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."'),
322	);
323	}
324	else {
325	$form['include_children'] = array(
326	'#type' => 'value',
327	'#value' => false,
328	);
329	}
330
331	$form['taxonomy'] = array(
332	'#type' => 'fieldset',
333	'#title' => t('Categories'),
334	'#collapsible' => true,
335	'#collapsed' => false,
336	'#tree' => TRUE,
337	);
338
339	$selection_types = array('select', 'checkboxes');
340	$i = 0;
341	foreach ($vocabularies as $v => $sel) {
342	$voc = taxonomy_get_vocabulary($v);
343
344	$voc_node_types = array();
345	foreach ($voc->nodes as $key => $type) {
346	$voc_node_types[] = $node_types[$type];
347	}
348	$count_types = count($voc_node_types);
349	if (count($voc_node_types) == 1) {
350	$node_type_list = $voc_node_types[0];
351	}
352	else {
353	$node_type_list = implode(', ', $voc_node_types);
354	}
355
356	$tree = taxonomy_get_tree($v);
357	$term_opts = array();
358
359	if ($tree) {
360	foreach ($tree as $term) {
361	$opt_string = null;
362	if ($count_nodes) {
363	// $count = db_result(db_query('SELECT COUNT(nid) FROM {term_node} WHERE tid=%d', $term->tid));
364	$count = taxonomy_term_count_nodes($term->tid);
365	if ($count > 0 \|\| $show_unused) {
366	$opt_string = decode_entities(check_plain($term->name)) .' ('. $count .')';
367	}
368	}
369	else {
370	$opt_string = decode_entities(check_plain($term->name));
371	}
372	if ($opt_string) {
373	$term_opts[$term->tid] = str_repeat('-', $term->depth) . $opt_string;
374	}
375	}
376	}
377
378	$vocname = filter_xss($voc->name);
379	if (!empty($term_opts)) {
380	$form['taxonomy'][$v] = array(
381	'#type' => $select_type,
382	'#title' => $vocname,
383	'#options' => $term_opts,
384	'#multiple' => true,
385	'#description' => $voc->description
386	.'  '. t('"!name" is used for: !types.', array('!name' => '<strong>'. $vocname .'</strong>', '!types' => $node_type_list)),
387	'#size' => min(10, count($term_opts)),
388	'#prefix' => '<div class="taxonomy_browser_'. $select_type .'">',
389	'#suffix' => '</div>',
390	'#field_suffix' => $node_type_list,
391	'#weight' => $i,
392	);
393	++$i;
394	}
395	}
396
397	$form['submit'] = array(
398	'#type' => 'submit',
399	'#value' => t('Search'),
400	'#submit' => TRUE,
401	);
402
403	return $form;
404	}
405
406	/**
407	* Themable form output for the category browser page.
408	*/
409	function theme_taxonomy_browser_page($form) {
410	$output = '';
411
412	$vocabularies = variable_get('taxonomy_browser_vocabularies', array());
413	if (empty($vocabularies)) {
414	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'))));
415	return ' ';
416	}
417
418	$output .= drupal_render($form);
419	return $output;
420	}
421
422	/**
423	* Implementation of hook_form_validate().
424	*/
425	function taxonomy_browser_form_validate($form_id, &$form_values) {
426
427	$include_children = $form_values['include_children'];
428	$tids = _taxonomy_browser_get_tid_list($form_values['taxonomy'], $include_children);
429
430	$operator = $form_values['operator'] ? 'or' : 'and';
431
432	if ($operator == 'and' && $include_children == true) {
433	form_set_error('operator', t('You must use "Items containing <strong>any</strong>" to include child terms.'));
434	}
435
436	if (empty($tids)) {
437	form_set_error('taxonomy', t('You must select at least one category in your search.'));
438	}
439	else {
440	// $node_type = (isset($form_values['node_filter']) && $form_values['node_filter'] != 'all') ? $form_values['node_filter'] : NULL;
441	$node_type = str_replace(',0', '', implode(',', $form_values['node_filter']));
442
443	if (!taxonomy_browser_count_nodes($tids, $operator, 0, $node_type)) {
444	form_set_error('taxonomy', t('No posts match your criteria.'));
445	}
446	}
447	}
448
449	/**
450	* Implementation of hook_form_submit().
451	*/
452	function taxonomy_browser_form_submit($form_id, &$form_values) {
453	$tids = _taxonomy_browser_get_tid_list();
454
455	$operator = $form_values['operator'] ? 'or' : 'and';
456	$str_tids = ($operator == 'and') ? implode(',', $tids) : implode('+', $tids);
457
458	$types = array_filter($form_values['node_filter']);
459	$node_type = str_replace(',0', '', implode(',', $types));
460
461	if ($types) {
462	return array('taxonomy/term/'. $str_tids, 'type='. $node_type);
463	}
464	else {
465	return 'taxonomy/term/'. $str_tids;
466	}
467
468	}
469
470	//********************************************************************
471	//* Module Functions : Private
472	//********************************************************************
473
474	/**
475	* Get the output to be displayed by the block.
476	*
477	* @param
478	* $delta - integer for the block number.
479	*
480	* @return
481	* array containing the title ("subject") and content of the block.
482	*/
483	function _taxonomy_browser_block_view($delta) {
484	$block = array();
485	switch ($delta) {
486	case 0:
487	$block = array(
488	'content' => drupal_get_form('taxonomy_browser_form'),
489	);
490	break;
491	}
492	return $block;
493	}
494
495	/**
496	* Private function to count the number of nodes found by the user's query.
497	*/
498	function taxonomy_browser_count_nodes($tids = array(), $operator = 'or', $depth = 0, $nodetype = NULL) {
499	if (count($tids) > 0) {
500	// For each term ID, generate an array of descendant term IDs to the right depth.
501	$descendant_tids = array();
502	if ($depth === 'all') {
503	$depth = NULL;
504	}
505	foreach ($tids as $index => $tid) {
506	$term = taxonomy_get_term($tid);
507	$tree = taxonomy_get_tree($term->vid, $tid, -1, $depth);
508	$descendant_tids[] = array_merge(array($tid), array_map('_taxonomy_get_tid_from_term', $tree));
509	}
510
511	$type_where = null;
512	if ($nodetype) {
513	// $type_where = "n.type = '". db_escape_string($nodetype) ."'";
514	$type_where = "n.type IN ('". implode("', '", explode(',', db_escape_string($nodetype))) ."')";
515	}
516
517	if ($operator == 'or') {
518	$str_tids = implode(',', call_user_func_array('array_merge', $descendant_tids));
519	$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";
520	}
521	else {
522	$joins = '';
523	$wheres = array();
524	if ($type_where) {
525	$wheres[] = $type_where;
526	}
527	foreach ($descendant_tids as $index => $tids) {
528	$joins .= 'INNER JOIN {term_node} tn'. $index .' ON n.nid = tn'. $index .'.nid ';
529	$wheres[] = 'tn'. $index .'.tid IN ('. implode(',', $tids) .')';
530	}
531	$sql_count = 'SELECT COUNT(n.nid) FROM {node} n '. $joins .' WHERE '. implode(' AND ', $wheres);
532	}
533
534	// drupal_set_message('Count query: '. $sql_count);
535	return db_result(db_query(db_rewrite_sql($sql_count)));
536	}
537
538	return 0;
539	}
540
541	/**
542	* Transforms an unpredictably and irregularly nested set of tids (as returned
543	* from a taxonomy form) into a linear array of tids.
544	*/
545	function _taxonomy_browser_get_tid_list($tids = null, $include_children = false) {
546	static $tid_list;
547
548	if (isset($tids) && is_array($tids)) {
549	$tid_list = array();
550	foreach ($tids as $key => $tid) {
551	if (!empty($tid)) {
552	if (is_array($tid)) {
553	foreach ($tid as $key2 => $tid2) {
554	if (!empty($tid2)) {
555	$tid_list[$tid2] = $tid2;
556	}
557	}
558	}
559	else {
560	$tid_list[$tid] = $tid;
561	}
562	} /* end !empty */
563	} /* end foreach */
564	}
565
566	if ($include_children) {
567	foreach ($tid_list as $tid) {
568	_taxonomy_browser_get_kids($tid_list, $tid);
569	}
570	}
571
572	return $tid_list;
573	}
574
575	function _taxonomy_browser_get_kids(&$tid_list, $tid) {
576	$children = taxonomy_get_children($tid);
577	if ($children) {
578	foreach ($children as $child_tid => $child_term) {
579	_taxonomy_browser_get_kids($tid_list, $child_tid);
580	}
581	}
582	else {
583	$tid_list[$tid] = $tid;
584	}
585	}
586
587	/**
588	* Provides default guideline text.
589	*/
590	function _taxonomy_browser_guidelines_default() {
591	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>');
592	}