How to get selected percentage discount all products

Question

I want to get specific percentage (i.e 5%) discount all products. how can I get the products?

I am using Magento 1.7.0.2 and trying with below code for all selected products:

    $_pro_collection = Mage::getModel('catalog/product')->getCollection();
    $_pro_collection->getSelect()->order('(price_index.final_price / price_index.price)', 'DESC');

Your help will be appreciated. Thanks in advanced.

Answer 1

You can use below code:

$collection = Mage::getResourceModel('catalog/product_collection');
$collection->addAttributeToFilter('special_price', array('gt' => 0));
$collection->addAttributeToFilter('price', array('gt' => 0));
$collection->addAttributeToFilter('special_price', array('eq' => new Zend_Db_Expr('`at_price`.`value`*0.95')));

/** for FLAT CATALOG use this line
$collection->addAttributeToFilter('special_price', array('eq' => new Zend_Db_Expr('e.price*0.95')));
**/

/**
ADD EXTRA FILTER HERE
**/

Adding From and To Date Filters

$date = strtotime(date('Y-m-d')); 
$current_date = date("Y-m-d hh:mm:ss",$date);
$collection= $specialcollection->addAttributeToFilter(array(
    array('attribute'=>'special_from_date','lteq'=>$current_date),
    array('attribute'=>'special_from_date','eq'=>''),
    array('attribute'=>'special_from_date','null'=>true)
),'','left')
->addAttributeToFilter(array(
    array('attribute'=>'special_to_date','gteq'=>$current_date),
    array('attribute'=>'special_to_date','eq'=>''),
    array('attribute'=>'special_to_date','null'=>true)
),'','left');