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:  * String translate 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_Translate_String extends Mage_Core_Model_Resource_Db_Abstract
 36: {
 37:     /**
 38:      * Define main table
 39:      *
 40:      */
 41:     protected function _construct()
 42:     {
 43:         $this->_init('core/translate', 'key_id');
 44:     }
 45: 
 46:     /**
 47:      * Load
 48:      *
 49:      * @param Mage_Core_Model_Abstract $object
 50:      * @param String $value
 51:      * @param String $field
 52:      * @return array
 53:      */
 54:     public function load(Mage_Core_Model_Abstract $object, $value, $field = null)
 55:     {
 56:         if (is_string($value)) {
 57:             $select = $this->_getReadAdapter()->select()
 58:                 ->from($this->getMainTable())
 59:                 ->where($this->getMainTable().'.string=:tr_string');
 60:             $result = $this->_getReadAdapter()->fetchRow($select, array('tr_string'=>$value));
 61:             $object->setData($result);
 62:             $this->_afterLoad($object);
 63:             return $result;
 64:         } else {
 65:             return parent::load($object, $value, $field);
 66:         }
 67:     }
 68: 
 69:     /**
 70:      * Retrieve select for load
 71:      *
 72:      * @param String $field
 73:      * @param String $value
 74:      * @param Mage_Core_Model_Abstract $object
 75:      * @return Varien_Db_Select
 76:      */
 77:     protected function _getLoadSelect($field, $value, $object)
 78:     {
 79:         $select = parent::_getLoadSelect($field, $value, $object);
 80:         $select->where('store_id = ?', Mage_Core_Model_App::ADMIN_STORE_ID);
 81:         return $select;
 82:     }
 83: 
 84:     /**
 85:      * After translation loading
 86:      *
 87:      * @param Mage_Core_Model_Abstract $object
 88:      * @return Mage_Core_Model_Resource_Db_Abstract
 89:      */
 90:     public function _afterLoad(Mage_Core_Model_Abstract $object)
 91:     {
 92:         $adapter = $this->_getReadAdapter();
 93:         $select = $adapter->select()
 94:             ->from($this->getMainTable(), array('store_id', 'translate'))
 95:             ->where('string = :translate_string');
 96:         $translations = $adapter->fetchPairs($select, array('translate_string' => $object->getString()));
 97:         $object->setStoreTranslations($translations);
 98:         return parent::_afterLoad($object);
 99:     }
100: 
101:     /**
102:      * Before save
103:      *
104:      * @param Mage_Core_Model_Abstract $object
105:      * @return Mage_Core_Model_Resource_Translate_String
106:      */
107:     protected function _beforeSave(Mage_Core_Model_Abstract $object)
108:     {
109:         $adapter = $this->_getWriteAdapter();
110:         $select = $adapter->select()
111:             ->from($this->getMainTable(), 'key_id')
112:             ->where('string = :string')
113:             ->where('store_id = :store_id');
114: 
115:         $bind = array(
116:             'string'   => $object->getString(),
117:             'store_id' => Mage_Core_Model_App::ADMIN_STORE_ID
118:         );
119: 
120:         $object->setId($adapter->fetchOne($select, $bind));
121:         return parent::_beforeSave($object);
122:     }
123: 
124:     /**
125:      * After save
126:      *
127:      * @param Mage_Core_Model_Abstract $object
128:      * @return Mage_Core_Model_Resource_Translate_String
129:      */
130:     protected function _afterSave(Mage_Core_Model_Abstract $object)
131:     {
132:         $adapter = $this->_getWriteAdapter();
133:         $select = $adapter->select()
134:             ->from($this->getMainTable(), array('store_id', 'key_id'))
135:             ->where('string = :string');
136:         $stores = $adapter->fetchPairs($select, array('string' => $object->getString()));
137: 
138:         $translations = $object->getStoreTranslations();
139: 
140:         if (is_array($translations)) {
141:             foreach ($translations as $storeId => $translate) {
142:                 if (is_null($translate) || $translate=='') {
143:                      $where = array(
144:                         'store_id = ?'    => $storeId,
145:                         'string = ?'      => $object->getString()
146:                     );
147:                     $adapter->delete($this->getMainTable(), $where);
148:                 } else {
149:                     $data = array(
150:                        'store_id'  => $storeId,
151:                        'string'    => $object->getString(),
152:                        'translate' => $translate,
153:                     );
154: 
155:                     if (isset($stores[$storeId])) {
156:                         $adapter->update(
157:                            $this->getMainTable(),
158:                            $data,
159:                            array('key_id = ?' => $stores[$storeId]));
160:                     } else {
161:                         $adapter->insert($this->getMainTable(), $data);
162:                     }
163:                 }
164:             }
165:         }
166:         return parent::_afterSave($object);
167:     }
168: 
169:     /**
170:      * Delete translates
171:      *
172:      * @param string $string
173:      * @param string $locale
174:      * @param int|null $storeId
175:      * @return Mage_Core_Model_Resource_Translate_String
176:      */
177:     public function deleteTranslate($string, $locale = null, $storeId = null)
178:     {
179:         if (is_null($locale)) {
180:             $locale = Mage::app()->getLocale()->getLocaleCode();
181:         }
182: 
183:         $where = array(
184:             'locale = ?' => $locale,
185:             'string = ?' => $string
186:         );
187: 
188:         if ($storeId === false) {
189:             $where['store_id > ?'] = Mage_Core_Model_App::ADMIN_STORE_ID;
190:         } elseif ($storeId !== null) {
191:             $where['store_id > ?'] = $storeId;
192:         }
193: 
194:         $this->_getWriteAdapter()->delete($this->getMainTable(), $where);
195: 
196:         return $this;
197:     }
198: 
199:     /**
200:      * Save translation
201:      *
202:      * @param String $string
203:      * @param String $translate
204:      * @param String $locale
205:      * @param int|null $storeId
206:      * @return Mage_Core_Model_Resource_Translate_String
207:      */
208:     public function saveTranslate($string, $translate, $locale = null, $storeId = null)
209:     {
210:         $write = $this->_getWriteAdapter();
211:         $table = $this->getMainTable();
212: 
213:         if (is_null($locale)) {
214:             $locale = Mage::app()->getLocale()->getLocaleCode();
215:         }
216: 
217:         if (is_null($storeId)) {
218:             $storeId = Mage::app()->getStore()->getId();
219:         }
220: 
221:         $select = $write->select()
222:             ->from($table, array('key_id', 'translate'))
223:             ->where('store_id = :store_id')
224:             ->where('locale = :locale')
225:             ->where('string = :string')
226:         ;
227:         $bind = array(
228:             'store_id' => $storeId,
229:             'locale'   => $locale,
230:             'string'   => $string
231:         );
232: 
233:         if ($row = $write->fetchRow($select, $bind)) {
234:             $original = $string;
235:             if (strpos($original, '::') !== false) {
236:                 list($scope, $original) = explode('::', $original);
237:             }
238:             if ($original == $translate) {
239:                 $write->delete($table, array('key_id=?' => $row['key_id']));
240:             } elseif ($row['translate'] != $translate) {
241:                 $write->update($table, array('translate' => $translate), array('key_id=?' => $row['key_id']));
242:             }
243:         } else {
244:             $write->insert($table, array(
245:                 'store_id'  => $storeId,
246:                 'locale'    => $locale,
247:                 'string'    => $string,
248:                 'translate' => $translate,
249:             ));
250:         }
251: 
252:         return $this;
253:     }
254: }
255: