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:  * Template db resource
 30:  *
 31:  * @category    Mage
 32:  * @package     Mage_Core
 33:  * @author      Magento Core Team <core@magentocommerce.com>
 34:  */
 35: class Mage_Core_Model_Resource_Email_Template extends Mage_Core_Model_Resource_Db_Abstract
 36: {
 37:     /**
 38:      * Initialize email template resource model
 39:      *
 40:      */
 41:     protected function _construct()
 42:     {
 43:         $this->_init('core/email_template', 'template_id');
 44:     }
 45: 
 46:     /**
 47:      * Load by template code from DB.
 48:      *
 49:      * @param string $templateCode
 50:      * @return array
 51:      */
 52:     public function loadByCode($templateCode)
 53:     {
 54:         $select = $this->_getReadAdapter()->select()
 55:             ->from($this->getMainTable())
 56:             ->where('template_code = :template_code');
 57:         $result = $this->_getReadAdapter()->fetchRow($select, array('template_code' => $templateCode));
 58: 
 59:         if (!$result) {
 60:             return array();
 61:         }
 62:         return $result;
 63:     }
 64: 
 65:     /**
 66:      * Check usage of template code in other templates
 67:      *
 68:      * @param Mage_Core_Model_Email_Template $template
 69:      * @return boolean
 70:      */
 71:     public function checkCodeUsage(Mage_Core_Model_Email_Template $template)
 72:     {
 73:         if ($template->getTemplateActual() != 0 || is_null($template->getTemplateActual())) {
 74:             $select = $this->_getReadAdapter()->select()
 75:                 ->from($this->getMainTable(), 'COUNT(*)')
 76:                 ->where('template_code = :template_code');
 77:             $bind = array(
 78:                 'template_code' => $template->getTemplateCode()
 79:             );
 80: 
 81:             $templateId = $template->getId();
 82:             if ($templateId) {
 83:                 $select->where('template_id != :template_id');
 84:                 $bind['template_id'] = $templateId;
 85:             }
 86: 
 87:             $result = $this->_getReadAdapter()->fetchOne($select, $bind);
 88:             if ($result) {
 89:                 return true;
 90:             }
 91:         }
 92:         return false;
 93:     }
 94: 
 95:     /**
 96:      * Set template type, added at and modified at time
 97:      *
 98:      * @param Mage_Core_Model_Email_Template $object
 99:      * @return Mage_Core_Model_Resource_Email_Template
100:      */
101:     protected function _beforeSave(Mage_Core_Model_Abstract $object)
102:     {
103:         if ($object->isObjectNew()) {
104:             $object->setCreatedAt($this->formatDate(true));
105:         }
106:         $object->setModifiedAt($this->formatDate(true));
107:         $object->setTemplateType((int)$object->getTemplateType());
108: 
109:         return parent::_beforeSave($object);
110:     }
111: 
112:     /**
113:      * Retrieve config scope and scope id of specified email template by email pathes
114:      *
115:      * @param array $paths
116:      * @param int|string $templateId
117:      * @return array
118:      */
119:     public function getSystemConfigByPathsAndTemplateId($paths, $templateId)
120:     {
121:         $orWhere = array();
122:         $pathesCounter = 1;
123:         $bind = array();
124:         foreach ($paths as $path) {
125:             $pathAlias = 'path_' . $pathesCounter;
126:             $orWhere[] = 'path = :' . $pathAlias;
127:             $bind[$pathAlias] = $path;
128:             $pathesCounter++;
129:         }
130:         $bind['template_id'] = $templateId;
131:         $select = $this->_getReadAdapter()->select()
132:             ->from($this->getTable('core/config_data'), array('scope', 'scope_id', 'path'))
133:             ->where('value LIKE :template_id')
134:             ->where(join(' OR ', $orWhere));
135: 
136:         return $this->_getReadAdapter()->fetchAll($select, $bind);
137:     }
138: }
139: