/**
* Join request_path column from url rewrite table
*
* @return Mage_Catalog_Model_Resource_Category_Flat_Collection
*/
public function addUrlRewriteToResult()
{
/** @var $urlRewrite Mage_Catalog_Helper_Category_Url_Rewrite_Interface */
$urlRewrite = $this->_factory->getCategoryUrlRewriteHelper();
$urlRewrite->joinTableToCollection($this, $this->_getCurrentStoreId());
return $this;
}
/**
* Joins url rewrite rules to collection
*
* @return Mage_Catalog_Model_Resource_Category_Collection
*/
public function joinUrlRewrite()
{
$this->_factory->getCategoryUrlRewriteHelper()->joinTableToEavCollection($this, $this->_getCurrentStoreId());
return $this;
}
/**
* Return parent categories of category
*
* @param Mage_Catalog_Model_Category $category
* @param bool $isActive
* @return array
*/
public function getParentCategories($category, $isActive = true)
{
$categories = array();
$select = $this->_getReadAdapter()->select()->from(array('main_table' => $this->getMainStoreTable($category->getStoreId())), array('main_table.entity_id', 'main_table.name'))->where('main_table.entity_id IN (?)', array_reverse(explode(',', $category->getPathInStore())));
if ($isActive) {
$select->where('main_table.is_active = ?', '1');
}
$select->order('main_table.path ASC');
$urlRewrite = $this->_factory->getCategoryUrlRewriteHelper();
$urlRewrite->joinTableToSelect($select, $category->getStoreId());
$result = $this->_getReadAdapter()->fetchAll($select);
foreach ($result as $row) {
$row['id'] = $row['entity_id'];
$categories[$row['entity_id']] = Mage::getModel('catalog/category')->setData($row);
}
return $categories;
}
