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_Core
 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:  * Custom variabel collection
 30:  *
 31:  * @category    Mage
 32:  * @package     Mage_Core
 33:  * @author      Magento Core Team <core@magentocommerce.com>
 34:  */
 35: class Mage_Core_Model_Resource_Variable_Collection extends Mage_Core_Model_Resource_Db_Collection_Abstract
 36: {
 37:     /**
 38:      * Store Id
 39:      *
 40:      * @var int
 41:      */
 42:     protected $_storeId    = 0;
 43: 
 44:     /**
 45:      *  Define resource model
 46:      *
 47:      */
 48:     protected function _construct()
 49:     {
 50:         parent::_construct();
 51:         $this->_init('core/variable');
 52:     }
 53: 
 54:     /**
 55:      * Setter
 56:      *
 57:      * @param integer $storeId
 58:      * @return Mage_Core_Model_Resource_Variable_Collection
 59:      */
 60:     public function setStoreId($storeId)
 61:     {
 62:         $this->_storeId = $storeId;
 63:         return $this;
 64:     }
 65: 
 66:     /**
 67:      * Getter
 68:      *
 69:      * @return integer
 70:      */
 71:     public function getStoreId()
 72:     {
 73:         return $this->_storeId;
 74:     }
 75: 
 76:     /**
 77:      * Add store values to result
 78:      *
 79:      * @return Mage_Core_Model_Resource_Variable_Collection
 80:      */
 81:     public function addValuesToResult()
 82:     {
 83:         $this->getSelect()
 84:             ->join(
 85:                 array('value_table' => $this->getTable('core/variable_value')),
 86:                 'value_table.variable_id = main_table.variable_id',
 87:                 array('value_table.value'));
 88:         $this->addFieldToFilter('value_table.store_id', array('eq' => $this->getStoreId()));
 89:         return $this;
 90:     }
 91: 
 92:     /**
 93:      * Retrieve option array
 94:      *
 95:      * @return array
 96:      */
 97:     public function toOptionArray()
 98:     {
 99:         return $this->_toOptionArray('code', 'name');
100:     }
101: }
102: