00001 <?php
00002
00003
00004
00005
00006
00007
00008
00009
00010
00011
00012
00013
00014
00015
00016
00017
00018
00019
00020
00021
00022
00023
00024
00025
00026
00027
00028
00029
00030
00031
00032
00033
00034
00035 class Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Attribute_Backend_Tierprice
00036 extends Mage_Core_Model_Mysql4_Abstract
00037 {
00038 protected function _construct()
00039 {
00040 $this->_init('catalog/product_attribute_tier_price', 'value_id');
00041 }
00042
00043
00044
00045
00046
00047
00048
00049
00050 public function loadProductPrices($product, $attribute)
00051 {
00052 $select = $this->_getReadAdapter()->select()
00053 ->from($this->getMainTable(), array(
00054 'website_id', 'all_groups', 'cust_group' => 'customer_group_id',
00055 'price_qty' => 'qty', 'price' => 'value'
00056 ))
00057 ->where('entity_id=?', $product->getId())
00058 ->order('qty');
00059 if ($attribute->isScopeGlobal()) {
00060 $select->where('website_id=?', 0);
00061 }
00062 else {
00063 if ($storeId = $product->getStoreId()) {
00064 $select->where('website_id IN (?)', array(0, Mage::app()->getStore($storeId)->getWebsiteId()));
00065 }
00066 }
00067 return $this->_getReadAdapter()->fetchAll($select);
00068 }
00069
00070 public function deleteProductPrices($product, $attribute)
00071 {
00072 $condition = array();
00073
00074 if (!$attribute->isScopeGlobal()) {
00075 if ($storeId = $product->getStoreId()) {
00076 $condition[] = $this->_getWriteAdapter()->quoteInto('website_id IN (?)', array(0, Mage::app()->getStore($storeId)->getWebsiteId()));
00077 }
00078 }
00079
00080 $condition[] = $this->_getWriteAdapter()->quoteInto('entity_id=?', $product->getId());
00081
00082 $this->_getWriteAdapter()->delete($this->getMainTable(), implode(' AND ', $condition));
00083 return $this;
00084 }
00085
00086 public function insertProductPrice($product, $data)
00087 {
00088 $data['entity_id'] = $product->getId();
00089 $this->_getWriteAdapter()->insert($this->getMainTable(), $data);
00090 return $this;
00091 }
00092 }