Simple Category Tree

[HeathenMagic]

Hello yellow1912

I would be interested in this new version please. I am trying to achieve a flyout header (which I managed with your over version). And also a sidebox which gets the cpath and display the subcategories under that cpath / master category. I struggled on that, but I know it was my PHP knowledge that failed. lol.

Thanks,

Heathenmagic

[yellow1912]

Hello yellow1912

I would be interested in this new version please. I am trying to achieve a flyout header (which I managed with your over version). And also a sidebox which gets the cpath and display the subcategories under that cpath / master category. I struggled on that, but I know it was my PHP knowledge that failed. lol.

Thanks,

Heathenmagic

Here you go. Warning: I have changed class function/method names a bit, so peek into the class for more info.

[limelites]

Just writing to say a big thank you for the "all_sub_cats_products" mod. I just installed it and it worked an absolute treat, first time around with zero glitches. PERFECTO!!

Why isn't this available to download in the main downloads area?! It's too useful not to be!!

[ryska]

Hi yellow1912, nice module. But in center column not showing navigation (name sub-category or image) for others subcategories. Is possibility their display?

[neboztik]

Hi yellow1912, nice module. But in center column not showing navigation (name sub-category or image) for others subcategories. Is possibility their display?

In file "/includes/templates/YOURTEMPLATE/templates/tpl_index_product_list.php" find this line:
<?php } // categories_description ?>
BELOW this line, paste the following code :

<!-- BOF: Display grid of available sub-categories, if any -->
<?php
  if (PRODUCT_LIST_CATEGORY_ROW_STATUS == 0) {
    // do nothing
  } else {
    // display subcategories
/**
 * require the code to display the sub-categories-grid, if any exist
 */
   require($template->get_template_dir('tpl_modules_category_row.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_category_row.php');
  }
?>
<!-- EOF: Display grid of available sub-categories -->

In file "/includes/modules/pages/index/main_template_vars.php" find this line:
$tpl_page_body = 'tpl_index_product_list.php';
ABOVE this line, paste the following code :

    /* ---------------- BOF - THIS MAKES SUB-CATS WORK -------------------- */
      $sql = "SELECT cd.categories_name, c.categories_image
              FROM   " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
              WHERE      c.categories_id = :categoriesID
              AND        cd.categories_id = :categoriesID
              AND        cd.language_id = :languagesID
              AND        c.categories_status= '1'";
    
      $sql = $db->bindVars($sql, ':categoriesID', $current_category_id, 'integer'); 
      $sql = $db->bindVars($sql, ':languagesID', $_SESSION['languages_id'], 'integer'); 
      $category = $db->Execute($sql);
    
      if (isset($cPath) && strpos($cPath, '_'))
      {
        // check to see if there are deeper categories within the current category
        $category_links = array_reverse($cPath_array);
        for($i=0, $n=sizeof($category_links); $i<$n; $i++)
        {
          $sql = "SELECT count(*) AS total
                  FROM   " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
                  WHERE      c.parent_id = :parentID 
                  AND        c.categories_id = cd.categories_id
                  AND        cd.language_id = :languagesID
                  AND        c.categories_status= '1'";
    
          $sql = $db->bindVars($sql, ':parentID', $category_links[$i], 'integer'); 
          $sql = $db->bindVars($sql, ':languagesID', $_SESSION['languages_id'], 'integer'); 
          $categories = $db->Execute($sql);
    
          if ($categories->fields['total'] < 1)
          {
            // do nothing, go through the loop
          } else {
            $categories_query = "SELECT c.categories_id, cd.categories_name, c.categories_image, c.parent_id
                                 FROM   " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
                                 WHERE      c.parent_id = :parentID
                                 AND        c.categories_id = cd.categories_id 
                                 AND        cd.language_id = :languagesID 
                                 AND        c.categories_status= '1' 
                                 ORDER BY   sort_order, cd.categories_name";
    
            $categories_query = $db->bindVars($categories_query, ':parentID', $category_links[$i], 'integer');
            $categories_query = $db->bindVars($categories_query, ':languagesID', $_SESSION['languages_id'], 'integer'); 
            break; // we've found the deepest category the customer is in
          }
        }
      } else {
        $categories_query = "SELECT c.categories_id, cd.categories_name, c.categories_image, c.parent_id
                             FROM   " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
                             WHERE      c.parent_id = :parentID
                             AND        c.categories_id = cd.categories_id
                             AND        cd.language_id = :languagesID
                             AND        c.categories_status= '1'
                             ORDER BY   sort_order, cd.categories_name";
    
        $categories_query = $db->bindVars($categories_query, ':parentID', $current_category_id, 'integer');
        $categories_query = $db->bindVars($categories_query, ':languagesID', $_SESSION['languages_id'], 'integer'); 
      }
      $categories = $db->Execute($categories_query);
      $number_of_categories = $categories->RecordCount();
      $new_products_category_id = $current_category_id;  
      
    /* ---------------- EOF - THIS MAKES SUB-CATS WORK -------------------- */ 

This modification was based on bodyjewelrystores code. I haven´t had problems with displaying names of sub-category or image. I hope it will solve your problem.

[ryska]

to neboztik: Thanx, I have a look in it.

[neboztik]

Hi, I used my code listed above and I have one big problem. When I click on manufacture link it brings me on the main page instead of products manufacture listing. Can smb help?

[mkonchalski]

So I ran into an interesting problem. I have installed the "all_sub_cats_products" mod, and it works wonderfully. However I noticed one little problem...

I added two new sub categories today, and the products don't show up as they are supposed to. I am not sure what to do. The site is also on local host, which is another issue so I can't post a link .

I'd appreciate if anyone can guide me in the right direction on how to get my new products to show up.

[hey_you]

Does anyone else get this error after uploading the autoloader?

[28-Oct-2009 00:40:35] PHP Fatal error: Call to a member function init() on a non-object in /home/xyz.com/zen/includes/autoload_func.php on line 90

[vandiermen]

Hello,
I and 5 other people I have seen in the forum are looking for a way to list sub category products in the main category.

I added the simple_categories_tree.php and config.simple_categories_tree.php from yellow1912's list zip file
http://www.zen-cart.com/forum/showpo...&postcount=204

Can anyone tell me what else I have to do to list all products of each subcategory when click main category ?

P.s. I did not get an error when I added these files, but that is all I did(add these files).