Magento – Excluding category by entity_id from the collection of categories

categorycollection;

I need to exclude a single category from a collection of categories. The code I use to get the collection:

$layer = Mage::getSingleton('catalog/layer');
$_category = $layer->getCurrentCategory();
$_parent_category = $_category->parent_category;
$_grandparent_cat = $_parent_category->getParentCategory(); 
$eid = $_parent_category->entity_id;

and now the code I use to filter the categories

$_new_categories = $_grandparent_cat
    ->getChildrenCategories()
    ->addAttributeToSelect("*")
    ->addAttributeToFilter('entity_id', array('neq'=>$eid));

This should take all child categories of the grandpared_cat and return them, excluding the current cat(the one
with $eid) but it returns all subcategories.
How can I solve this? Thanks :)!

Best Answer

Mage_Catalog_Model_Resource_Category::getChildrenCategories returns a loaded collection, so your filter does not get applied.

public function getChildrenCategories($category)
{
    $collection = $this->_getChildrenCategoriesBase($category);
    $collection->addAttributeToFilter('is_active', 1)
        ->addIdFilter($category->getChildren())
        ->load();

    return $collection;
}

protected function _getChildrenCategoriesBase($category)
{
    $collection = $category->getCollection();
    $collection->addAttributeToSelect('url_key')
        ->addAttributeToSelect('name')
        ->addAttributeToSelect('all_children')
        ->addAttributeToSelect('is_anchor')
        ->setOrder('position', Varien_Db_Select::SQL_ASC)
        ->joinUrlRewrite();
    return $collection;
}

I'm not sure the best way to proceed as _getChildrenCategoriesBase is a protected method. This might be the type of collection you could create if it was not a protected method

    //base methods
    $_new_categories = Mage::getResourceModel('catalog/category_collection');
    $_new_categories->addAttributeToSelect('url_key')
        ->addAttributeToSelect('name')
        ->addAttributeToSelect('all_children')
        ->addAttributeToSelect('is_anchor')
        ->setOrder('position', Varien_Db_Select::SQL_ASC)
        ->joinUrlRewrite();

    //children methods
    $_new_categories->addAttributeToFilter('is_active', 1)
        ->addIdFilter($_grandparent_cat->getChildren());

    //your methods
    $_new_categories
        ->addAttributeToSelect('*')
        ->addAttributeToFilter('entity_id', array('neq' => $eid));

Related Solutions

Magento – getChildrenCategories Only Includes Categories with Include in Navigation Set to Yes

You have two options: rewrite or observer.

Rewrite:

The rewrite DOM structure for this is a bit tricky because it is a resource model:

<global>
    <models>
        <catalog_resource>
            <rewrite>
                <flat>Your_Module_Model_Resource_Flat</flat><!-- for example -->
            </rewrite>
        </catalog_resource>
    </models>
</global>

Then in the class file for Your_Module_Model_Resource_Flat you would extend from the core flat category resource model and override this method, changing what you need to change.

Observer:

Register an observer in the frontend for the catalog_category_flat_loadnodes_before event in the frontend, which you can see is dispatched just below the code you referenced. In fact it is preceded by a note stating, "Allow extensions to modify select (e.g. add custom category attributes to select)". In your observing method, you will need to manipulate the select object which is passed in; I have untested peudo-y code here:

public function allowExcludedCategories($o)
{
    $select = $o->getSelect();
    $oWhere  = $select->getPart(Varien_Db_Select::WHERE);
    $select->setPart(Varien_Db_Select::WHERE,array_shift($oWhere));
}

Magento – Products from a category plus any children and get category ID for conditions from collection

Okay, so I'm actually getting somewhere by building a completely different collection...

$category_id = 3;
$collection = Mage::getModel('catalog/category')->load($category_id)
    ->getProductCollection()
    ->addAttributeToSelect('*') // add all attributes - optional
    ->addAttributeToFilter('type_id', array('eq' => 'configurable'))
    ->addAttributeToFilter('visibility', array('in' => array(Mage_Catalog_Model_Product_Visibility::VISIBILITY_BOTH, Mage_Catalog_Model_Product_Visibility::VISIBILITY_IN_SEARCH, Mage_Catalog_Model_Product_Visibility::VISIBILITY_IN_CATALOG)))
    ->addAttributeToFilter('status', array('eq' => Mage_Catalog_Model_Product_Status::STATUS_ENABLED))
    ->addStoreFilter($storeId);

And then fetch the category ID's from the loaded products:-

$cats = $product->getCategoryIds();

And loop through (as @paj suggested in the comments) to get the category data for each:-

foreach ($cats as $category_id) {
        $category = Mage::getModel('catalog/category')->setStoreId(Mage::app()->getStore()->getId())->load($category_id);             
    }

I'm then able to get what I want for each product like:-

$category->getId()
$category->getName()

Meaning my required mapping works well:-

if ($category->getId()==10) {
    $cmap = 'Clothing > Trousers';
}

Best Answer

Related Solutions

Magento – getChildrenCategories Only Includes Categories with Include in Navigation Set to Yes

Magento – Products from a category plus any children and get category ID for conditions from collection

Related Topic