Add Affected Products in catalog price rule code example
Example: Add “Affected Products” in catalog price rule
public function getSpecialPriceProducts()
{
$categoryID = $this->getCategoryId();
if($categoryID)
{
$category = new Mage_Catalog_Model_Category();
$category->load($categoryID);
$collection = $category->getProductCollection();
} else
{
$collection = Mage::getResourceModel('catalog/product_collection');
}
$todayDate = date('m/d/y');
$tomorrow = mktime(0, 0, 0, date('m'), date('d'), date('y'));
$tomorrowDate = date('m/d/y', $tomorrow);
Mage::getModel('catalog/layer')->prepareProductCollection($collection);
$collection->addAttributeToSort('created_at', 'desc');
$collection->addStoreFilter()
->addAttributeToSelect(array('name', 'price', 'short_description','image','small_image','url_key'), 'inner');
$collection->addAttributeToFilter('special_price', array('gt' => 0));
$collection->addAttributeToFilter('special_to_date', array('date' => true, 'to' => $todayDate))
->addAttributeToFilter('special_from_date', array('or'=> array(
0 => array('date' => true, 'from' => $tomorrowDate),
1 => array('is' => new Zend_Db_Expr('null')))
), 'left');
$rules = Mage::getResourceModel('catalogrule/rule_collection')->load();
if($rules->getData()) {
$rule_ids = array();
$productIds[] = array();
foreach($rules as $rule) {
$rule_ids[] = $rule->getId();
$productIds = $rule->getMatchingProductIds();
}
$arr = $collection->getAllIds();
if($productIds) {
$arr = array_merge($arr,$productIds);
}
$collection = Mage::getModel('catalog/product')->getCollection()
->addAttributeToSelect(array('name', 'price', 'short_description','image','small_image','url_key'), 'inner')
->addAttributeToFilter('entity_id',array('in'=>$arr))
->load();
}
return $collection;
}