Magento

Hi all,

I need to be able to pull of a list of subcategories for a specified parent category id. For example I have two main categories setup (Departments & Flavours) on every page I want to show all of the subcategories for these main categories.

I see there is a getCurrentChildCategories function, which is kind of what I need but like this getChildCategories(4) - 4 being the parent id.

Hopefully that makes sense and what I’m asking is quite simple? I’ve searched the forum for a while and can’t find an answer.

Thanks in advance
Steve P. Sharpe

I guess you can just copy the function, rename it to getChildCategories($parentId), and replace $category = $layer->getCurrentCategory(); with $category = Mage::getModel(’catalog/category’)->load($parentId);

Hi there,

I tried that, but got an error. However it did point me in the right direction. So thank-you!

For those that are interested this is what I did which is based on the getStoreCategories function.

left.phtml - 6 is the id of the parent category

/Mage/Catalog/Model/Category.php

/Mage/Catalog/Helper/Category.php

Hopefully this helps someone?

Hi,

I put this function in navigation.php and it works.

Thanks for your code

It helped me a lot.  Thank you greatly my friend.

Hi,

Thank you for your code. It works like charm.
But, one question, how do I get the current parent category ID ?

Calviin

I’m trying to figure out how to apply this code to a left-nav example.. Where do I put put these code snippets to have a vertical nav display the child categories, or child products directly underneath the parent category when parent is selected ?

Hi, I am trying to implement Steve’s code and it is returning a PHP error:

Here’s what I have implemented for left.phtml

Is there any specific place in each of the Category.php files where I need to place the respective functions? Can anyone offer some advice?

Thanks very much

i get the same error as brad, any suggestions?

I tried this technique and it worked beautifully. Thanks for posting it.

Following the recommendation in the last post, I extended the core classes, and created directories for them in my /app/code/local directory

This resulted in the following files:
/app/code/local/[Foo]/Catalog/Block/Navigation.php
/app/code/local/[Foo]/Catalog/Helper/Category.php
/app/code/local/[Foo]/Catalog/Model/Category.php

With the following class names:
Foo_Catalog_Block_Navigation
Foo_Catalog_Helper_Category
Foo_Catalog_Model_Category

The extended classes are very simple, only containing the additional methods, like so:

To activate these classes add the following to your /app/etc/local.xml file, between the <global> tags:

Update: I added the other two classes to my code samples above, in case anyone wants to copy them. Remember “Foo” should be the namespace for your project, so the parent directory “Foo” should be renamed as well as the first part of each class name.

You may want to look at the Mage_Catalog_Block_Navigation::drawItem() method - and creating a new method based upon it - to render out an unordered list which highlights the current category by css class name.

See [theme folder]/template/catalog/navigation/top.phtml for usage.

That should provide you with enough HTML / CSS hooks to let jQuery expand or collapse the resulting menu.

This is excellent guys! Thanks for sharing this code. I had to write up the config.xml myself but that wasn’t so hard to figure out after following the examples here…

http://www.magentocommerce.com/wiki/groups/174/changing_and_customizing_magento_code

Also I think I remember reading in another thread that you can’t extend the same class twice with two different extensions. Without looking that up to see if I was 100% correct, and knowing that Rico’s VertNav extension already extends Mage_Catalog_Block_Navigation, I just added the new public function for the Block extension in his existing file. This would probably give me trouble after upgrading his extension but I am sure I can quickly add it again.

Unfortunately this is no longer working in 1.3.1.

It errors out in getSubCategories function at:
$tree->addCollectionData(null, $sorted, $parentId, $toLoad, true);

with an error of:

PHP Fatal error:  Call to undefined method Mage_Catalog_Model_Resource_Eav_Mysql4_Category_Flat_Collection::getAllIdsSql() in /Applications/MAMP/htdocs/magento/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Category/Tree.php on line 224

Does anybody have an idea what to do about it?

Thanks...martin

Hi ,

exactly the same result with 13.1

Fatal error: Call to undefined method Mage_Catalog_Model_Resource_Eav_Mysql4_Category_Flat_Collection::getAllIdsSql() in /var/clients/client7/web9/web/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Category/Tree.php on line 224

working in progress ...

Fatal error: Call to undefined method Mage_Catalog_Model_Resource_Eav_Mysql4_Category_Flat_Collection::getAllIdsSql() in /var/clients/client7/web9/web/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Category/Tree.php on line 224

in : /app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Category/Tree.php

protected function _getInactiveItemIds($collection, $storeId)
{
----->> line 224 ----->> $filter = $collection->getAllIdsSql(); <<----------- line 224 <<< --------

$attributeId = $this->_getIsActiveAttributeId();

$table = Mage::getSingleton(’core/resource’)->getTableName(’catalog/category’) . ‘_int’;
$select = $this->_conn->select()
->from(array(’d’=>$table), array(’d.entity_id’))
->where(’d.attribute_id = ?’, $attributeId)
->where(’d.store_id = ?’, 0)
->where(’d.entity_id IN (?)’, new Zend_Db_Expr($filter))
->joinLeft(array(’c’=>$table), “c.attribute_id = ‘{$attributeId}’ AND c.store_id = ‘{$storeId}’ AND c.entity_id = d.entity_id”, array())
->where(’IFNULL(c.value, d.value) = ?’, 0);

return $this->_conn->fetchCol($select);
}

anybody able to fix it ! ?
Me i can’t

Sorry i think is important to the diffence between magento 1.3.1 and previous ... ?

cya

just wanting to keep this thread alive.  I could really use this functionality myself.