'Taxonomy Block', 'description' => 'Show taxonomy in a block with i18n support', 'access arguments' => array('administer taxonomy_block'), 'page callback' => 'drupal_get_form', 'page arguments' => array('taxonomy_block_admin_settings'), 'type' => MENU_NORMAL_ITEM, 'file' => 'taxonomy_block.settings.inc', ); return $items; } /** * Implements hook_block_info(). */ function taxonomy_block_block_info(){ $blocks[0] = array( 'info' => t('Taxonomy Block'), 'cache' => DRUPAL_NO_CACHE, ); return $blocks; } /** * Implements hook_block_view(). */ function taxonomy_block_block_view($delta){ switch($delta){ case 0: $block['subject'] = t('Taxonomy Block'); $block['content'] = _taxonomy_block_content(); break; } return $block; } /** * Get the taxonomy block content */ function _taxonomy_block_content(){ $vid = variable_get('taxonomy_block_settings_vid',1); $node_count = variable_get('taxonomy_block_settings_node_count',1); $num_term = variable_get('taxonomy_block_settings_max_term',0); $order_by = variable_get('taxonomy_block_settings_order_by', 0)==0 ? 'name' : 'weight'; $order_type = variable_get('taxonomy_block_settings_order_type', 0)==0 ? 'ASC' : 'DESC'; $output = ''; $sql = "SELECT td.tid, td.name, th.parent FROM taxonomy_term_data AS td LEFT JOIN taxonomy_term_hierarchy AS th ON td.tid = th.tid WHERE td.vid = :vid AND th.parent = 0"; $term_parents = db_query($sql, array(':vid' => $vid)); $output .= '

'; foreach($term_parents as $term_parent){ $tid_parent = $term_parent->tid; $name_parent= $term_parent->name; $output .= '
• '; $term_parent = taxonomy_term_load($tid_parent); $term_parent_path = taxonomy_term_uri($term_parent); if(module_exists("i18n")){ $output .= l(tt("taxonomy:term:$tid_parent:name", $name_parent), $term_parent_path['path']); }else{ $output .= l(t($name_parent), $term_parent_path['path']); } if($node_count){ $sql_count_parents = "SELECT count(*) FROM taxonomy_index AS ti LEFT JOIN node AS n ON ti.nid = n.nid WHERE ti.tid = :tid AND n.status = 1"; $total_parent = db_query($sql_count_parents, array(':tid' => $tid_parent))->fetchField(); $output .= " ($total_parent)"; } $sql_count_child = "SELECT * FROM taxonomy_term_data AS td LEFT JOIN taxonomy_term_hierarchy AS th ON td.tid = th.tid LEFT JOIN taxonomy_index AS ti ON td.tid = ti.tid LEFT JOIN node AS n ON ti.nid = n.nid WHERE n.status = 1 AND td.vid = :vid AND th.parent = :parent"; $count_child = db_query($sql_count_child, array(':vid' => $vid, ':parent' => $tid_parent))->fetchField(); if($count_child){ $sql_term_childs = "SELECT * FROM taxonomy_term_data AS td LEFT JOIN taxonomy_term_hierarchy AS th ON td.tid = th.tid WHERE td.vid = :vid AND th.parent = :parent"; $term_childs = db_query($sql_term_childs, array(':vid' => $vid, ':parent' => $tid_parent)); $output .= '
  '; foreach($term_childs as $term_child){ $tid_child = $term_child->tid; $name_child = $term_child->name; $output .= '
  • '; $term_child = taxonomy_term_load($tid_child); $term_child_path = taxonomy_term_uri($term_child); if(module_exists("i18n")){ $output .= l(tt("taxonomy:term:$tid_child:name", $name_child), $term_child_path['path']); }else{ $output .= l(t($name_child), $term_child_path['path']); } if($node_count){ $sql_total_child = "SELECT count(*) FROM taxonomy_index AS ti LEFT JOIN node AS n ON ti.nid = n.nid WHERE ti.tid = :tid AND n.status = 1"; $total_child = db_query($sql_total_child, array(':tid' => $tid_child))->fetchField(); $output .= " ($total_child)"; } $output .= "
  "; } $output .= "
  "; $output .= "
"; } } $output .= "

"; return $output; } ?>