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_Core 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 * Templates collection 00029 * 00030 * @category Mage 00031 * @package Mage_Core 00032 * @author Magento Core Team <core@magentocommerce.com> 00033 */ 00034 class Mage_Core_Model_Mysql4_Email_Template_Collection extends Varien_Data_Collection_Db 00035 { 00036 /** 00037 * Template table name 00038 * 00039 * @var string 00040 */ 00041 protected $_templateTable; 00042 00043 public function __construct() 00044 { 00045 parent::__construct(Mage::getSingleton('core/resource')->getConnection('core_read')); 00046 $this->_templateTable = Mage::getSingleton('core/resource')->getTableName('core/email_template'); 00047 $this->_select->from($this->_templateTable, array('template_id','template_code', 00048 'template_type', 00049 'template_subject','template_sender_name', 00050 'template_sender_email', 00051 'added_at', 00052 'modified_at')); 00053 $this->setItemObjectClass(Mage::getConfig()->getModelClassName('core/email_template')); 00054 } 00055 00056 public function toOptionArray() 00057 { 00058 return $this->_toOptionArray('template_id', 'template_code'); 00059 } 00060 00061 }