Mage_Weee_Model_Mysql4_Tax Class Reference

Inheritance diagram for Mage_Weee_Model_Mysql4_Tax:

List of all members.

Public Member Functions
	fetchOne ($select)
	fetchCol ($select)
	updateDiscountPercents ()
	getProductDiscountPercent ($product, $website, $group)
Protected Member Functions
	_construct ()

---

Detailed Description

Definition at line 2 of file Tax.php.

---

Member Function Documentation

_construct

(

)

[protected]

Resource initialization

Reimplemented from Mage_Core_Model_Resource_Abstract.

Definition at line 3 of file Tax.php.

    {
        $this->_init('weee/tax', 'value_id');
    }

fetchCol

(

$

select

)

Definition at line 13 of file Tax.php.

    {
        return $this->_getReadAdapter()->fetchCol($select);
    }

fetchOne

(

$

select

)

Definition at line 8 of file Tax.php.

    {
        return $this->_getReadAdapter()->fetchOne($select);
    }

getProductDiscountPercent	(	$	product,
		$	website,
		$	group
	)

Definition at line 61 of file Tax.php.

    {
        $select = $this->_getReadAdapter()->select();
        $select->from($this->getTable('weee/discount'), 'value')
            ->where('website_id = ?', $website)
            ->where('entity_id = ?', $product)
            ->where('customer_group_id = ?', $group);

        return $this->_getReadAdapter()->fetchOne($select);
    }

updateDiscountPercents

(

)

Definition at line 18 of file Tax.php.

    {
        $this->_getWriteAdapter()->delete($this->getTable('weee/discount'));
        $now = strtotime(now());

        $select = $this->_getReadAdapter()->select();
        $select->from(array('data'=>$this->getTable('catalogrule/rule_product')))
            ->where('(from_time <= ? OR from_time = 0)', $now)
            ->where('(to_time >= ? OR to_time = 0)', $now)
            ->order(array('data.website_id', 'data.customer_group_id', 'data.product_id', 'data.sort_order'));

        $data = $this->_getReadAdapter()->fetchAll($select);
        $productData = array();
        $stops = array();
        foreach ($data as $row) {
            $key = "{$row['product_id']}-{$row['website_id']}-{$row['customer_group_id']}";
            if (isset($stops[$key]) && $stops[$key]) {
                continue;
            }

            if ($row['action_operator'] == 'by_percent') {
                if (isset($productData[$key])) {
                    $productData[$key]['value'] += $productData[$key]['value']/100*$row['action_amount'];
                } else {
                    $productData[$key] = array(
                        'entity_id'         => $row['product_id'],
                        'customer_group_id' => $row['customer_group_id'],
                        'website_id'        => $row['website_id'],
                        'value'             => 100-max(0, min(100, $row['action_amount'])),
                    );
                }                
            }

            if ($row['action_stop']) {
                $stops[$key] = true;
            }
        }

        foreach ($productData as $product) {
            $this->_getWriteAdapter()->insert($this->getTable('weee/discount'), $product);
        }
    }

---

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

• app/code/core/Mage/Weee/Model/Mysql4/Tax.php