Overview

Packages

  • currencysymbol
  • MAbout
  • Mage
    • Admin
    • Adminhtml
    • AdminNotification
    • Api
    • Api2
    • Authorizenet
    • Backup
    • Bundle
    • Captcha
    • Catalog
    • CatalogIndex
    • CatalogInventory
    • CatalogRule
    • CatalogSearch
    • Centinel
    • Checkout
    • Cms
    • Compiler
    • Connect
    • Contacts
    • Core
    • Cron
    • CurrencySymbol
    • Customer
    • Dataflow
    • Directory
    • DirtectPost
    • Downloadable
    • Eav
    • GiftMessage
    • GoogleAnalytics
    • GoogleBase
    • GoogleCheckout
    • ImportExport
    • Index
    • Install
    • Log
    • Media
    • Newsletter
    • Oauth
    • Page
    • PageCache
    • Paygate
    • Payment
    • Paypal
    • PaypalUk
    • Persistent
    • Poll
    • ProductAlert
    • Rating
    • Reports
    • Review
    • Rss
    • Rule
    • Sales
    • SalesRule
    • Sedfriend
    • Sendfriend
    • Shipping
    • Sitemap
    • Tag
    • Tax
    • Usa
    • Weee
    • Widget
    • Wishlist
    • XmlConnect
  • None
  • Phoenix
    • Moneybookers
  • PHP
  • Zend
    • Date
    • Mime
    • XmlRpc

Classes

  • Mage_Adminhtml_Rss_CatalogController
  • Mage_Adminhtml_Rss_OrderController
  • Mage_Rss_Block_Abstract
  • Mage_Rss_Block_Catalog_Abstract
  • Mage_Rss_Block_Catalog_Category
  • Mage_Rss_Block_Catalog_New
  • Mage_Rss_Block_Catalog_NotifyStock
  • Mage_Rss_Block_Catalog_Review
  • Mage_Rss_Block_Catalog_Salesrule
  • Mage_Rss_Block_Catalog_Special
  • Mage_Rss_Block_Catalog_Tag
  • Mage_Rss_Block_List
  • Mage_Rss_Block_Order_Details
  • Mage_Rss_Block_Order_New
  • Mage_Rss_Block_Order_Status
  • Mage_Rss_Block_Wishlist
  • Mage_Rss_CatalogController
  • Mage_Rss_Helper_Catalog
  • Mage_Rss_Helper_Data
  • Mage_Rss_Helper_Order
  • Mage_Rss_IndexController
  • Mage_Rss_Model_Mysql4_Order
  • Mage_Rss_Model_Observer
  • Mage_Rss_Model_Resource_Order
  • Mage_Rss_Model_Rss
  • Mage_Rss_Model_Session
  • Mage_Rss_Model_System_Config_Backend_Links
  • Mage_Rss_OrderController
  • Overview
  • Package
  • Class
  • Tree
  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_Rss
 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:  * Order Rss Resource Model
 30:  *
 31:  * @category    Mage
 32:  * @package     Mage_Rss
 33:  * @author      Magento Core Team <core@magentocommerce.com>
 34:  */
 35: class Mage_Rss_Model_Resource_Order
 36: {
 37:     /**
 38:      * Enter description here ...
 39:      *
 40:      * @deprecated after 1.4.1.0
 41:      *
 42:      * @var array
 43:      */
 44:     protected $_entityTypeIdsToTypes       = array();
 45: 
 46:     /**
 47:      * Enter description here ...
 48:      *
 49:      * @deprecated after 1.4.1.0
 50:      *
 51:      * @var array
 52:      */
 53:     protected $_entityIdsToIncrementIds    = array();
 54: 
 55:     /**
 56:      * Enter description here ...
 57:      *
 58:      * @deprecated after 1.4.1.0
 59:      *
 60:      * @return array
 61:      */
 62:     public function getEntityTypeIdsToTypes()
 63:     {
 64:         return $this->_entityTypeIdsToTypes;
 65:     }
 66: 
 67:     /**
 68:      * Enter description here ...
 69:      *
 70:      * @deprecated after 1.4.1.0
 71:      *
 72:      * @return array
 73:      */
 74:     public function getEntityIdsToIncrementIds()
 75:     {
 76:         return $this->_entityIdsToIncrementIds;
 77:     }
 78: 
 79:     /**
 80:      * Enter description here ...
 81:      *
 82:      * @deprecated after 1.4.1.0
 83:      *
 84:      * @return array
 85:      */
 86:     public function getAllOrderEntityTypeIds()
 87:     {
 88:         return array();
 89:     }
 90: 
 91:     /**
 92:      * Enter description here ...
 93:      *
 94:      * @deprecated after 1.4.1.0
 95:      *
 96:      * @param unknown_type $orderId
 97:      * @param unknown_type $orderEntityTypes
 98:      * @return array
 99:      */
100:     public function getAllOrderEntityIds($orderId, $orderEntityTypes)
101:     {
102:         return array();
103:     }
104: 
105:     /**
106:      * Enter description here ...
107:      *
108:      * @deprecated after 1.4.1.0
109:      *
110:      * @param unknown_type $entityIds
111:      * @return array
112:      */
113:     public function getAllEntityIds($entityIds = array())
114:     {
115:         return array();
116:     }
117: 
118:     /**
119:      * Enter description here ...
120:      *
121:      * @deprecated after 1.4.1.0
122:      *
123:      * @return array
124:      */
125:     public function getAllEntityTypeCommentIds()
126:     {
127:         return array();
128:     }
129: 
130:     /**
131:      * Retrieve core resource model
132:      *
133:      * @return Mage_Core_Model_Resource
134:      */
135:     public function getCoreResource()
136:     {
137:         return Mage::getSingleton('core/resource');
138:     }
139: 
140:     /**
141:      * Retrieve order comments
142:      *
143:      * @param int $orderId
144:      * @return array
145:      */
146:     public function getAllCommentCollection($orderId)
147:     {
148:         $res = $this->getCoreResource();
149:         $read = $res->getConnection('core_read');
150: 
151:         $fields = array(
152:             'notified' => 'is_customer_notified',
153:             'comment',
154:             'created_at',
155:         );
156:         $commentSelects = array();
157:         foreach (array('invoice', 'shipment', 'creditmemo') as $entityTypeCode) {
158:             $mainTable  = $res->getTableName('sales/' . $entityTypeCode);
159:             $slaveTable = $res->getTableName('sales/' . $entityTypeCode . '_comment');
160:             $select = $read->select()
161:                 ->from(array('main' => $mainTable), array(
162:                     'entity_id' => 'order_id',
163:                     'entity_type_code' => new Zend_Db_Expr("'$entityTypeCode'")
164:                 ))
165:                 ->join(array('slave' => $slaveTable), 'main.entity_id = slave.parent_id', $fields)
166:                 ->where('main.order_id = ?', $orderId);
167:             $commentSelects[] = '(' . $select . ')';
168:         }
169:         $select = $read->select()
170:             ->from($res->getTableName('sales/order_status_history'), array(
171:                 'entity_id' => 'parent_id',
172:                 'entity_type_code' => new Zend_Db_Expr("'order'")
173:             ) + $fields)
174:             ->where('parent_id = ?', $orderId)
175:             ->where('is_visible_on_front > 0');
176:         $commentSelects[] = '(' . $select . ')';
177: 
178:         $commentSelect = $read->select()
179:             ->union($commentSelects, Zend_Db_Select::SQL_UNION_ALL);
180: 
181:         $select = $read->select()
182:             ->from(array('orders' => $res->getTableName('sales/order')), array('increment_id'))
183:             ->join(array('t' => $commentSelect),'t.entity_id = orders.entity_id')
184:             ->order('orders.created_at desc');
185: 
186:         return $read->fetchAll($select);
187:     }
188: }
189: 
Magento 1.7.0.2 API documentation generated by ApiGen 2.8.0