/**
* Join url rewrite table to eav collection
*
* @param Mage_Eav_Model_Entity_Collection_Abstract $collection
* @param int $storeId
* @return Mage_Catalog_Helper_Category_Url_Rewrite
*/
public function joinTableToEavCollection(Mage_Eav_Model_Entity_Collection_Abstract $collection, $storeId)
{
if ($this->_helper()->OptimizeCategoriesLeftJoin($storeId)) {
$collection->joinTable('urlindexer/url_rewrite', 'category_id=entity_id', array('request_path'), "{{table}}.is_system=1 AND " . "{{table}}.store_id='{$storeId}' AND " . "{{table}}.id_path LIKE 'category/%'", 'left');
return $this;
}
return parent::joinTableToEavCollection($collection, $storeId);
}
/**
* Join url rewrite table to eav collection
*
* @param Mage_Eav_Model_Entity_Collection_Abstract $collection
* @param int $storeId
*
* @return Mage_Catalog_Helper_Category_Url_Rewrite
*/
public function joinTableToEavCollection(Mage_Eav_Model_Entity_Collection_Abstract $collection, $storeId)
{
if (false === Mage::helper('schumacherfm_fastindexer')->optimizeUrlRewriteFlatCategory()) {
parent::joinTableToEavCollection($collection, $storeId);
} else {
$collection->getSelect()->columns('main_table.url_path as request_path');
}
return $this;
}
