Mage_SalesRule_Model_Mysql4_Rule_Collection Class Reference

Inheritance diagram for Mage_SalesRule_Model_Mysql4_Rule_Collection:

List of all members.

Public Member Functions
	setValidationFilter ($websiteId, $customerGroupId, $couponCode='', $now=null)
	addWebsiteFilter ($websiteIds)
Protected Member Functions
	_construct ()

---

Detailed Description

Definition at line 28 of file Collection.php.

---

Member Function Documentation

_construct

(

)

[protected]

Initialization here

Reimplemented from Mage_Core_Model_Mysql4_Collection_Abstract.

Definition at line 30 of file Collection.php.

    {
        parent::_construct();
        $this->_init('salesrule/rule');
    }

addWebsiteFilter

(

$

websiteIds

)

Filter collection by specified website IDs

Parameters:

int|array

$websiteIds

Returns:

Mage_CatalogRule_Model_Mysql4_Rule_Collection

Definition at line 65 of file Collection.php.

    {
        if (!is_array($websiteIds)) {
            $websiteIds = array($websiteIds);
        }
        $parts = array();
        foreach ($websiteIds as $websiteId) {
            $parts[] = $this->getConnection()->quoteInto('FIND_IN_SET(?, main_table.website_ids)', $websiteId);
        }
        if ($parts) {
            $this->getSelect()->where(new Zend_Db_Expr(implode(' OR ', $parts)));
        }
        return $this;
    }

setValidationFilter	(	$	websiteId,
		$	customerGroupId,
		$	couponCode = '',
		$	now = null
	)

Definition at line 36 of file Collection.php.

    {
        if (is_null($now)) {
            $now = Mage::getModel('core/date')->date('Y-m-d');
        }

        $this->addBindParam('coupon_code', $couponCode);
        $this->getSelect()->where('is_active=1');
        $this->getSelect()->where('find_in_set(?, website_ids)', (int)$websiteId);
        $this->getSelect()->where('find_in_set(?, customer_group_ids)', (int)$customerGroupId);
        if (empty($couponCode)) {
            $this->getSelect()->where("coupon_code is null or coupon_code=''");
        }
        else {
            $this->getSelect()->where("coupon_code is null or coupon_code='' or coupon_code=:coupon_code");
        }
        $this->getSelect()->where('from_date is null or from_date<=?', $now);
        $this->getSelect()->where('to_date is null or to_date>=?', $now);
        $this->getSelect()->order('sort_order');

        return $this;
    }

---

The documentation for this class was generated from the following file:

• app/code/core/Mage/SalesRule/Model/Mysql4/Rule/Collection.php