1: <?php
 2: /**
 3:  * Magento
 4:  *
 5:  * NOTICE OF LICENSE
 6:  *
 7:  * This source file is subject to the Open Software License (OSL 3.0)
 8:  * that is bundled with this package in the file LICENSE.txt.
 9:  * It is also available through the world-wide-web at this URL:
10:  * http://opensource.org/licenses/osl-3.0.php
11:  * If you did not receive a copy of the license and are unable to
12:  * obtain it through the world-wide-web, please send an email
13:  * to license@magentocommerce.com so we can send you a copy immediately.
14:  *
15:  * DISCLAIMER
16:  *
17:  * Do not edit or add to this file if you wish to upgrade Magento to newer
18:  * versions in the future. If you wish to customize Magento for your
19:  * needs please refer to http://www.magentocommerce.com for more information.
20:  *
21:  * @category    Mage
22:  * @package     Mage_ProductAlert
23:  * @copyright   Copyright (c) 2012 Magento Inc. (http://www.magentocommerce.com)
24:  * @license     http://opensource.org/licenses/osl-3.0.php  Open Software License (OSL 3.0)
25:  */
26: 
27: 
28: /**
29:  * Product alert for back in abstract resource model
30:  *
31:  * @category    Mage
32:  * @package     Mage_ProductAlert
33:  * @author      Magento Core Team <core@magentocommerce.com>
34:  */
35: abstract class Mage_ProductAlert_Model_Resource_Abstract extends Mage_Core_Model_Resource_Db_Abstract
36: {
37:     /**
38:      * Retrieve alert row by object parameters
39:      *
40:      * @param Mage_Core_Model_Abstract $object
41:      * @return array|bool
42:      */
43:     protected function _getAlertRow(Mage_Core_Model_Abstract $object)
44:     {
45:         $adapter = $this->_getReadAdapter();
46:         if ($object->getCustomerId() && $object->getProductId() && $object->getWebsiteId()) {
47:             $select = $adapter->select()
48:                 ->from($this->getMainTable())
49:                 ->where('customer_id = :customer_id')
50:                 ->where('product_id  = :product_id')
51:                 ->where('website_id  = :website_id');
52:             $bind = array(
53:                 ':customer_id' => $object->getCustomerId(),
54:                 ':product_id'  => $object->getProductId(),
55:                 ':website_id'  => $object->getWebsiteId()
56:             );
57:             return $adapter->fetchRow($select, $bind);
58:         }
59:         return false;
60:     }
61: 
62:     /**
63:      * Load object data by parameters
64:      *
65:      * @param Mage_Core_Model_Abstract $object
66:      * @return Mage_ProductAlert_Model_Resource_Abstract
67:      */
68:     public function loadByParam(Mage_Core_Model_Abstract $object)
69:     {
70:         $row = $this->_getAlertRow($object);
71:         if ($row) {
72:             $object->setData($row);
73:         }
74:         return $this;
75:     }
76: 
77:     /**
78:      * Delete all customer alerts on website
79:      *
80:      * @param Mage_Core_Model_Abstract $object
81:      * @param int $customerId
82:      * @param int $websiteId
83:      * @return Mage_ProductAlert_Model_Resource_Abstract
84:      */
85:     public function deleteCustomer(Mage_Core_Model_Abstract $object, $customerId, $websiteId=null)
86:     {
87:         $adapter = $this->_getWriteAdapter();
88:         $where   = array();
89:         $where[] = $adapter->quoteInto('customer_id=?', $customerId);
90:         if ($websiteId) {
91:             $where[] = $adapter->quoteInto('website_id=?', $websiteId);
92:         }
93:         $adapter->delete($this->getMainTable(), $where);
94:         return $this;
95:     }
96: }
97: