Magento: app/code/core/Mage/Wishlist/Model/Mysql4/Item.php Source File

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_Wishlist
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  * Wishlist item model resource
00030  *
00031  * @category   Mage
00032  * @package    Mage_Wishlist
00033  * @author      Magento Core Team <core@magentocommerce.com>
00034  */
00035 class Mage_Wishlist_Model_Mysql4_Item extends Mage_Core_Model_Mysql4_Abstract
00036 {
00037 
00038     protected $_productIdFieldName = 'product_id';
00039 
00040     protected function _construct()
00041     {
00042         $this->_init('wishlist/item', 'wishlist_item_id');
00043     }
00044 
00045     public function loadByProductWishlist(Mage_Wishlist_Model_Item $item, $wishlistId, $productId, array $sharedStores)
00046     {
00047         $select = $this->_getReadAdapter()->select()
00048             ->from(array('main_table'=>$this->getTable('item')))
00049             ->where('main_table.wishlist_id = ?',  $wishlistId)
00050             ->where('main_table.product_id = ?',  $productId)
00051             ->where('main_table.store_id in (?)',  $sharedStores);
00052 
00053         if($_data = $this->_getReadAdapter()->fetchRow($select)) {
00054             $item->setData($_data);
00055         }
00056 
00057         return $item;
00058     }
00059 
00060 }