How to display product associated categories & filter product grid by categories in admin panel
Step 1.
Copy file from "app/code/core/Mage/Adminhtml/Block/Catalog/Product/Grid.php" to "app/code/local/Mage/Adminhtml/Block/Catalog/Product/Grid.php"
Step 2 : Add Column for category.
protected function _prepareColumns() {
......
......
......
$this->addColumn(
'category_id',
array(
'header' => Mage::helper('jaydip_kansagra')->__('Category'),
'width' => '100px',
'index' => 'category_ids',
'type' => 'options',
'options' => $this->getCategoriesOptions(),
'filter_condition_callback' => array($this, '_callbackCategoryFilter'),
'renderer' => 'Jaydip_Kansagra_Block_Adminhtml_Renderer_Categories'
)
);
......
......
......
}
Step 3 : Create new functions in this grid file.
protected function getCategoriesOptions() {
$categoriesOptions = array();
$this->prepareCategoriesOptions($this->_getCategories()->getNodes(), $categoriesOptions);
return $categoriesOptions;
}
protected function _getCategories() {
$storeId = (int) $this->getRequest()->getParam('store');
if ($storeId) {
$store = Mage::app()->getStore($storeId);
$parent = $store->getRootCategoryId();
} else {
$parent = Mage_Catalog_Model_Category::TREE_ROOT_ID;
}
$tree = Mage::getResourceModel('catalog/category_tree');
/* @var $tree Mage_Catalog_Model_Resource_Category_Tree */
$nodes = $tree->loadNode($parent)
->loadChildren(0)
->getChildren();
$tree->addCollectionData(null, true, $parent, true, false);
return $nodes;
}
protected function prepareCategoriesOptions($nodes, &$options) {
/** @var $node Varien_Data_Tree_Node */
foreach ($nodes as $node) {
if ($node->getName()) {
$options[$node->getId()] = str_repeat(' ', $node->getLevel() - 1) . $node->getName();
}
if ($node->hasChildren()) {
$this->prepareCategoriesOptions($node->getAllChildNodes(), $options);
}
}
return $options;
}
*********Or For without category tree view**********
protected function getCategoriesOptions() {
$categoriesOptions = array();
$this->prepareCategoriesOptions($this->_getCategories()->getNodes(), $categoriesOptions);
return $categoriesOptions;
}
Step 4 : Create new function for filter in this file protected method _callbackCategoryFilter
protected function _callbackCategoryFilter($collection, $column)
{
if (!$value = $column->getFilter()->getValue()) {
return null;
}
$collection->joinField(
'category_id',
'catalog/category_product',
'category_id',
'product_id = entity_id',
'{{table}}.category_id=' . $column->getFilter()->getValue(),
'inner'
);
}
Step 5 : Create renderer file in any extension
class Jaydip_Kansagra_Block_Adminhtml_Renderer_Categories extends Mage_Adminhtml_Block_Widget_Grid_Column_Renderer_Abstract {
public function render(Varien_Object $row) {
$productCategories = array();
$product = Mage::getModel('catalog/product')->load($row->getData('entity_id'));
$categories = $product->getCategoryCollection()->addAttributeToSelect('name');
foreach ($categories as $category) {
array_push($productCategories, $category->getName());
}
return implode(',', $productCategories);
}
}
No comments:
Post a Comment