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_Bundle 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 * Bundle Selections Resource Collection 00030 * 00031 * @category Mage 00032 * @package Mage_Bundle 00033 * @author Magento Core Team <core@magentocommerce.com> 00034 */ 00035 class Mage_Bundle_Model_Mysql4_Selection_Collection 00036 extends Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection 00037 { 00038 protected $_selectionTable; 00039 protected function _construct() 00040 { 00041 parent::_construct(); 00042 $this->setRowIdFieldName('selection_id'); 00043 $this->_selectionTable = $this->getTable('bundle/selection'); 00044 } 00045 00046 protected function _initSelect() 00047 { 00048 parent::_initSelect(); 00049 $this->getSelect()->join(array('selection' => $this->_selectionTable), 00050 '`selection`.`product_id`=`e`.`entity_id`', 00051 array('*') 00052 ); 00053 } 00054 00055 public function setOptionIdsFilter($optionIds) 00056 { 00057 if (!empty($optionIds)) { 00058 $this->getSelect()->where('`selection`.`option_id` in (' . join(',', (array)$optionIds) . ')'); 00059 } 00060 return $this; 00061 } 00062 00063 public function setSelectionIdsFilter($selectionIds) 00064 { 00065 if (!empty($selectionIds)) { 00066 $this->getSelect()->where('`selection`.`selection_id` in (' . join(',', (array)$selectionIds) . ')'); 00067 } 00068 return $this; 00069 } 00070 00071 public function setPositionOrder() 00072 { 00073 $this->getSelect()->order('selection.position asc') 00074 ->order('selection.selection_id asc'); 00075 return $this; 00076 } 00077 }