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:  * Core Store Resource Model
 30:  *
 31:  * @category    Mage
 32:  * @package     Mage_Core
 33:  * @author      Magento Core Team <core@magentocommerce.com>
 34:  */
 35: class Mage_Core_Model_Resource_Store extends Mage_Core_Model_Resource_Db_Abstract
 36: {
 37:     /**
 38:      * Define main table and primary key
 39:      *
 40:      */
 41:     protected function _construct()
 42:     {
 43:         $this->_init('core/store', 'store_id');
 44:     }
 45: 
 46:     /**
 47:      * Initialize unique fields
 48:      *
 49:      * @return Mage_Core_Model_Resource_Store
 50:      */
 51:     protected function _initUniqueFields()
 52:     {
 53:         $this->_uniqueFields = array(array(
 54:             'field' => 'code',
 55:             'title' => Mage::helper('core')->__('Store with the same code')
 56:         ));
 57:         return $this;
 58:     }
 59: 
 60:     /**
 61:      * Check store code before save
 62:      *
 63:      * @param Mage_Core_Model_Abstract $model
 64:      * @return Mage_Core_Model_Resource_Store
 65:      */
 66:     protected function _beforeSave(Mage_Core_Model_Abstract $model)
 67:     {
 68:         if (!preg_match('/^[a-z]+[a-z0-9_]*$/', $model->getCode())) {
 69:             Mage::throwException(
 70:                 Mage::helper('core')->__('The store code may contain only letters (a-z), numbers (0-9) or underscore(_), the first character must be a letter'));
 71:         }
 72: 
 73:         return $this;
 74:     }
 75: 
 76:     /**
 77:      * Update Store Group data after save store
 78:      *
 79:      * @param Mage_Core_Model_Abstract $object
 80:      * @return Mage_Core_Model_Resource_Store
 81:      */
 82:     protected function _afterSave(Mage_Core_Model_Abstract $object)
 83:     {
 84:         parent::_afterSave($object);
 85:         $this->_updateGroupDefaultStore($object->getGroupId(), $object->getId());
 86:         $this->_changeGroup($object);
 87: 
 88:         return $this;
 89:     }
 90: 
 91:     /**
 92:      * Remove core configuration data after delete store
 93:      *
 94:      * @param Mage_Core_Model_Abstract $model
 95:      * @return Mage_Core_Model_Resource_Store
 96:      */
 97:     protected function _afterDelete(Mage_Core_Model_Abstract $model)
 98:     {
 99:         $where = array(
100:             'scope = ?'    => 'stores',
101:             'scope_id = ?' => $model->getStoreId()
102:         );
103: 
104:         $this->_getWriteAdapter()->delete(
105:             $this->getTable('core/config_data'),
106:             $where
107:         );
108:         return $this;
109:     }
110: 
111:     /**
112:      * Update Default store for Store Group
113:      *
114:      * @param int $groupId
115:      * @param int $storeId
116:      * @return Mage_Core_Model_Resource_Store
117:      */
118:     protected function _updateGroupDefaultStore($groupId, $storeId)
119:     {
120:         $adapter    = $this->_getWriteAdapter();
121: 
122:         $bindValues = array('group_id' => (int)$groupId);
123:         $select = $adapter->select()
124:             ->from($this->getMainTable(), array('count' => 'COUNT(*)'))
125:             ->where('group_id = :group_id');
126:         $count  = $adapter->fetchOne($select, $bindValues);
127: 
128:         if ($count == 1) {
129:             $bind  = array('default_store_id' => (int)$storeId);
130:             $where = array('group_id = ?' => (int)$groupId);
131:             $adapter->update($this->getTable('core/store_group'), $bind, $where);
132:         }
133: 
134:         return $this;
135:     }
136: 
137:     /**
138:      * Change store group for store
139:      *
140:      * @param Mage_Core_Model_Abstract $model
141:      * @return Mage_Core_Model_Resource_Store
142:      */
143:     protected function _changeGroup(Mage_Core_Model_Abstract $model)
144:     {
145:         if ($model->getOriginalGroupId() && $model->getGroupId() != $model->getOriginalGroupId()) {
146:             $adapter = $this->_getReadAdapter();
147:             $select = $adapter->select()
148:                 ->from($this->getTable('core/store_group'), 'default_store_id')
149:                 ->where($adapter->quoteInto('group_id=?', $model->getOriginalGroupId()));
150:             $storeId = $adapter->fetchOne($select, 'default_store_id');
151: 
152:             if ($storeId == $model->getId()) {
153:                 $bind = array('default_store_id' => Mage_Core_Model_App::ADMIN_STORE_ID);
154:                 $where = array('group_id = ?' => $model->getOriginalGroupId());
155:                 $this->_getWriteAdapter()->update($this->getTable('core/store_group'), $bind, $where);
156:             }
157:         }
158:         return $this;
159:     }
160: 
161:     /**
162:      * Retrieve select object for load object data
163:      *
164:      * @param string $field
165:      * @param mixed $value
166:      * @param Mage_Core_Model_Abstract $object
167:      * @return Varien_Db_Select
168:      */
169:     protected function _getLoadSelect($field, $value, $object)
170:     {
171:         $select = parent::_getLoadSelect($field, $value, $object);
172:         $select->order('sort_order');
173:         return $select;
174:     }
175: }
176: