Hide catalog terms if it does not contain any products?

Try here http://www.waldbeek.com/blog/view-taxonomy-term-and-hide-empty-terms and here http://drupal.org/node/1067742

You may be better off moving or repeating this question in the Views issue queue, as this is not really specific to Ubercart - any solution would also apply to any taxonomy term listing in Views.

This issue is not Fixed. Comment #3 merely suggests seeking a solution elsewhere, even though this is in no way an Issue for the Views module.

After extensive research, and once it had become apparent that there was no simpler way to do it (eg. one which involved no additional Contributed Modules), I created my own solution based on discussion on this thread linked from Comment #1:

• Install and enable Views PHP.
• Edit the uc_catalog_terms view.
• Add a standard Filter (ie. under Filter criteria) of type Global: PHP, setting the Filter code to:
  

  $count = db_query("SELECT COUNT(*) FROM {taxonomy_term_hierarchy} WHERE parent = $row->tid")->fetchField();
  if ($count == 0){
    $count_2 = db_query("SELECT COUNT(*) FROM {taxonomy_index} AS ti INNER JOIN {node} AS n USING (nid) WHERE n.status = 1 AND ti.tid = $row->tid")->fetchField();
    if ($count_2 == 0){
      return TRUE;
    }
  }
  

This filter will remove all terms which both have no subterms and are associated with no publishedproducts (ie. which are truly "empty categories"). If terms associated with unpublished products are to be included, the INNER JOIN can be removed (ie. all the text from "AS ti" to "AND ti." inclusive, except the WHERE keyword).

Please don't delete the issue summary. If you want to comment on the issue, enter your comments in the "Comment" section.

Restored issue summary.

TezMan: Thanks for responding to my suggested fix (even though you inadvertently overwrote the issue). You've indicated an important problem with my suggested filter code (when you say "this filter doesn't remove categories under which subcategories exist under which no (active) nodes exist"), but your suggested change doesn't actually fix that problem, which can really only be addressed using recursive code (because we can't know how far down a hierarchy of productless categories we might have to search before we find a category with a product in it).

Here is my amended solution:

• Install and enable Views PHP.
• Edit the uc_catalog_terms view.
• Add a standard Filter (ie. under Filter criteria) of type Global: PHP, setting the Setup code to:
  

  function should_we_filter_this_term($term_id = 0) {
  
    // Are any published nodes tagged with this term?
    $count = db_query("SELECT COUNT(*) FROM {taxonomy_index} WHERE tid = $term_id")->fetchField();
  
    // If so, don't filter the term.
    if ($count > 0) {
  
      return FALSE;
    }
  
    // If not, does this term have child terms?
    else {
  
      // Collect the terms which have this term as their parent.
      $result = db_query("SELECT tid FROM {taxonomy_term_hierarchy} WHERE parent = $term_id");
  
      // If there aren't any, filter the term.
      if ($result->rowCount() == 0) {
  
        return TRUE;
      }
  
      // If there are, check each child term using the same critria.
      else {
  
        foreach($result AS $record) {
  
          // If a child term comes back not filterable, then don't filter the parent.
          if(!should_we_filter_this_term($record->tid)) {
  
            return FALSE;
          }
        }
  
        // If we've gone through the child terms without getting a "not filterable", filter the parent.
        return TRUE;
      }
    }
  }
  

  and setting the Filter code to:

  return should_we_filter_this_term($row->tid);
  

Also, after further research, it turns out that the {taxonomy_index} table does not include unpublished nodes, and the Drupal 7 catalog doesn't display unpublished nodes at all. As such, my comment above about adjusting the code to display unpublished nodes should be ignored.

#12 worked perfectly! many many thanks!!

If you want to adjust this to account for categories with published items, change the setup code to:

function should_we_filter_this_term($term_id = 0) {

  // Are any published nodes tagged with this term?
  $count = db_query("SELECT COUNT(*) FROM {taxonomy_index} ti JOIN {node} n ON ti.nid = n.nid WHERE ti.tid = $term_id AND n.status")->fetchField();

  // If so, don't filter the term.
  if ($count > 0) {

    return FALSE;
  }

  // If not, does this term have child terms?
  else {

    // Collect the terms which have this term as their parent.
    $result = db_query("SELECT tid FROM {taxonomy_term_hierarchy} WHERE parent = $term_id");

    // If there aren't any, filter the term.
    if ($result->rowCount() == 0) {

      return TRUE;
    }

    // If there are, check each child term using the same critria.
    else {

      foreach($result AS $record) {

        // If a child term comes back not filterable, then don't filter the parent.
        if(!should_we_filter_this_term($record->tid)) {

          return FALSE;
        }
      }

      // If we've gone through the child terms without getting a "not filterable", filter the parent.
      return TRUE;
    }
  }
}

Hi, IanBezanson.

I am posting to see if you can help me out.

I have a taxonomy called "Folder" and have nested terms inside and also an Entity Reference field "Assigned to" that takes care of what users have been assigned to a particular node.

I created a taxonomy View using the Views Tree module and also displaying this View in a separate tab belonging to the user profile along with a Views Field View field that shows the content inside the folders (terms).

The code provided previously has worked with showing terms that actually have something in them but now I am trying to show only folders (terms) that both have something AND have been assigned to the current user.

So, if I have "Folder 3" inside of "Folder 1" and "Folder 2", do not show them unless they have content assigned to the current user.

Do you have an idea of what code I could use to achieve this?