00001 <?php 00002 /** 00003 * Magento 00004 * 00005 * NOTICE OF LICENSE 00006 * 00007 * This source file is subject to the Open Software License (OSL 3.0) 00008 * that is bundled with this package in the file LICENSE.txt. 00009 * It is also available through the world-wide-web at this URL: 00010 * http://opensource.org/licenses/osl-3.0.php 00011 * If you did not receive a copy of the license and are unable to 00012 * obtain it through the world-wide-web, please send an email 00013 * to license@magentocommerce.com so we can send you a copy immediately. 00014 * 00015 * DISCLAIMER 00016 * 00017 * Do not edit or add to this file if you wish to upgrade Magento to newer 00018 * versions in the future. If you wish to customize Magento for your 00019 * needs please refer to http://www.magentocommerce.com for more information. 00020 * 00021 * @category Mage 00022 * @package Mage_ProductAlert 00023 * @copyright Copyright (c) 2008 Irubin Consulting Inc. DBA Varien (http://www.varien.com) 00024 * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) 00025 */ 00026 00027 00028 /** 00029 * Product alert for back in stock resource model 00030 * 00031 * @category Mage 00032 * @package Mage_ProductAlert 00033 * @author Magento Core Team <core@magentocommerce.com> 00034 */ 00035 class Mage_ProductAlert_Model_Mysql4_Stock extends Mage_Core_Model_Mysql4_Abstract 00036 { 00037 protected function _construct() 00038 { 00039 $this->_init('productalert/stock', 'alert_stock_id'); 00040 } 00041 00042 protected function _beforeSave(Mage_Core_Model_Abstract $object) 00043 { 00044 if (is_null($object->getId()) && $object->getCustomerId() && $object->getProductId() && $object->getWebsiteId()) { 00045 if ($row = $this->_getAlertRow($object)) { 00046 $object->addData($row); 00047 $object->setStatus(0); 00048 } 00049 } 00050 if (is_null($object->getAddDate())) { 00051 $object->setAddDate(Mage::getModel('core/date')->gmtDate()); 00052 $object->setStatus(0); 00053 } 00054 return parent::_beforeSave($object); 00055 } 00056 00057 protected function _getAlertRow(Mage_Core_Model_Abstract $object) 00058 { 00059 if ($object->getCustomerId() && $object->getProductId() && $object->getWebsiteId()) { 00060 $sql = $this->_getWriteAdapter()->select() 00061 ->from($this->getMainTable()) 00062 ->where('customer_id=?', $object->getCustomerId()) 00063 ->where('product_id=?', $object->getProductId()) 00064 ->where('website_id=?', $object->getWebsiteId()); 00065 return $this->_getWriteAdapter()->fetchRow($sql); 00066 } 00067 return false; 00068 } 00069 00070 public function loadByParam(Mage_Core_Model_Abstract $object) 00071 { 00072 $row = $this->_getAlertRow($object); 00073 if ($row) { 00074 $object->setData($row); 00075 } 00076 return $this; 00077 } 00078 00079 public function deleteCustomer(Mage_Core_Model_Abstract $object, $customerId, $websiteId) 00080 { 00081 $where = array(); 00082 $where[] = $this->_getWriteAdapter()->quoteInto('customer_id=?', $customerId); 00083 if ($websiteId) { 00084 $where[] = $this->_getWriteAdapter()->quoteInto('website_id=?', $websiteId); 00085 } 00086 $this->_getWriteAdapter()->delete($this->getMainTable(), $where); 00087 return $this; 00088 } 00089 }