/**
* Prepare product collection
*
* @param Mage_Catalog_Model_Resource_Eav_Resource_Product_Collection $collection
* @return Mage_Catalog_Model_Layer
*/
public function prepareProductCollection($collection)
{
$collection->addAttributeToSelect(Mage::getSingleton('catalog/config')->getProductAttributes())->addSearchFilter(Mage::helper('catalogsearch')->getQuery()->getQueryText())->setStore(Mage::app()->getStore())->addMinimalPrice()->addFinalPrice()->addTaxPercents()->addStoreFilter()->addUrlRewrite();
Mage::getSingleton('catalog/product_status')->addVisibleFilterToCollection($collection);
Mage::getSingleton('catalog/product_visibility')->addVisibleInSearchFilterToCollection($collection);
return $this;
}
/**
* Prepare product collection
*
* @param Mage_Catalog_Model_Resource_Eav_Resource_Product_Collection $collection
* @return Mage_Catalog_Model_Layer
*/
public function prepareProductCollection($collection)
{
$collection->addAttributeToSelect(Mage::getSingleton('catalog/config')->getProductAttributes())->addSearchFilter(Mage::helper('catalogsearch')->getQuery()->getQueryText())->setStore(Mage::app()->getStore())->addMinimalPrice()->addFinalPrice()->addTaxPercents()->addStoreFilter()->addUrlRewrite();
Mage::getSingleton('catalog/product_status')->addVisibleFilterToCollection($collection);
Mage::getSingleton('catalog/product_visibility')->addVisibleInSearchFilterToCollection($collection);
$this->currentRate = $collection->getCurrencyRate();
$max = $this->getMaxPriceFilter();
$min = $this->getMinPriceFilter();
if ($min >= 0 && $max > 0) {
$collection->getSelect()->where(' final_price >= "' . $min . '" AND final_price <= "' . $max . '" ');
}
return $collection;
}
/**
* Prepare product collection
*
* @param Mage_Catalog_Model_Resource_Eav_Resource_Product_Collection $collection
* @return Mage_Catalog_Model_Layer
*/
public function prepareProductCollection($collection)
{
$collection->addAttributeToSelect(Mage::getSingleton('catalog/config')->getProductAttributes())->addSearchFilter(Mage::helper('catalogsearch')->getQuery()->getQueryText())->setStore(Mage::app()->getStore())->addMinimalPrice()->addFinalPrice()->addTaxPercents()->addStoreFilter()->addUrlRewrite();
Mage::getSingleton('catalog/product_status')->addVisibleFilterToCollection($collection);
Mage::getSingleton('catalog/product_visibility')->addVisibleInSearchFilterToCollection($collection);
$this->currentRate = $collection->getCurrencyRate();
$max = $this->getMaxPriceFilter();
$min = $this->getMinPriceFilter();
//print_r($collection->getData());
if ($min && $max) {
//$collection= $collection->addAttributeToFilter('price',array('from'=>$min, 'to'=>$max));
$collection->getSelect()->where(' final_price >= "' . $min . '" AND final_price <= "' . $max . '" ');
//echo $collection->getSelect();exit;
}
/*PRICE SLIDER FILTER*/
return $this;
}
/**
* Prepare product collection
*
* @param Mage_Catalog_Model_Resource_Eav_Resource_Product_Collection $collection
* @return Mage_Catalog_Model_Layer
*/
public function prepareProductCollection($collection)
{
$collection->addAttributeToSelect(Mage::getSingleton('Mage_Catalog_Model_Config')->getProductAttributes())->addSearchFilter(Mage::helper('Mage_CatalogSearch_Helper_Data')->getQuery()->getQueryText())->setStore(Mage::app()->getStore())->addMinimalPrice()->addFinalPrice()->addTaxPercents()->addStoreFilter()->addUrlRewrite()->setVisibility(Mage::getSingleton('Mage_Catalog_Model_Product_Visibility')->getVisibleInSearchIds());
return $this;
}
