Class Mage_Sales_Model_Mysql4_Report_Order_Updatedat_Collection

Description
Description | Descendents | Vars (details) | Methods (details) Constants

Report order updated_at collection

  • author: Magento Core Team <[email protected]>
  • copyright: Copyright (c) 2010 Magento Inc. (http://www.magentocommerce.com)

Located in /Sales/Model/Mysql4/Report/Order/Updatedat/Collection.php (line 34) 

Varien_Data_Collection_Db
   |
   --Mage_Core_Model_Mysql4_Collection_Abstract
      |
      --Mage_Sales_Model_Mysql4_Report_Collection_Abstract
         |
         --Mage_Sales_Model_Mysql4_Report_Order_Updatedat_Collection
Direct descendents
Description | Descendents | Vars (details) | Methods (details) Constants
Class Description
Mage_SalesRule_Model_Mysql4_Report_Updatedat_Collection Sales report coupons collection
Variable Summary
Description | Descendents | Vars (details) | Methods (details) Constants
mixed $_inited
mixed $_periodFormat
mixed $_selectedColumns
Method Summary
Description | Descendents | Constants Vars (details) | Methods (details)
Mage_Sales_Model_Mysql4_Report_Order_Updatedat_Collection __construct (array $parameters)
Mage_Sales_Model_Mysql4_Report_Order_Updatedat_Collection load ([boolean $printQuery = false], [boolean $logQuery = false])
Mage_Sales_Model_Mysql4_Report_Order_Updatedat_Collection _applyOrderStatusFilter ()
Mage_Sales_Model_Mysql4_Report_Order_Updatedat_Collection _applyStoresFilter ()
array _getSelectedColumns ()
Mage_Sales_Model_Mysql4_Report_Order_Updatedat_Collection _initSelect ()
Variables
Description | Descendents | Vars (details) Constants | Methods (details)
mixed $_inited = false (line 38)
  • access: protected
mixed $_periodFormat (line 37)
  • access: protected
mixed $_selectedColumns = array(
'orders_count' => 'COUNT(e.entity_id)',
'total_qty_ordered' => 'IFNULL(SUM(oi.total_qty_ordered), 0)',
'total_qty_invoiced' => 'IFNULL(SUM(oi.total_qty_invoiced), 0)',
'total_income_amount' => 'IFNULL(SUM((e.base_grand_total - IFNULL(e.base_total_canceled, 0)) * e.base_to_global_rate), 0)',
'total_revenue_amount' => 'IFNULL(SUM((e.base_total_paid - IFNULL(e.base_total_refunded, 0)) * e.base_to_global_rate), 0)',
'total_profit_amount' => 'IFNULL(SUM((e.base_total_paid - IFNULL(e.base_total_refunded, 0) - IFNULL(e.base_tax_invoiced, 0) - IFNULL(e.base_shipping_invoiced, 0) - IFNULL(e.base_total_invoiced_cost, 0)) * e.base_to_global_rate), 0)',
'total_invoiced_amount' => 'IFNULL(SUM(e.base_total_invoiced * e.base_to_global_rate), 0)',
'total_canceled_amount' => 'IFNULL(SUM(e.base_total_canceled * e.base_to_global_rate), 0)',
'total_paid_amount' => 'IFNULL(SUM(e.base_total_paid * e.base_to_global_rate), 0)',
'total_refunded_amount' => 'IFNULL(SUM(e.base_total_refunded * e.base_to_global_rate), 0)',
'total_tax_amount' => 'IFNULL(SUM((e.base_tax_amount - IFNULL(e.base_tax_canceled, 0)) * e.base_to_global_rate), 0)',
'total_tax_amount_actual' => 'IFNULL(SUM((e.base_tax_invoiced - IFNULL(e.base_tax_refunded, 0)) * e.base_to_global_rate), 0)',
'total_shipping_amount' => 'IFNULL(SUM((e.base_shipping_amount - IFNULL(e.base_shipping_canceled, 0)) * e.base_to_global_rate), 0)',
'total_shipping_amount_actual' => 'IFNULL(SUM((e.base_shipping_invoiced - IFNULL(e.base_shipping_refunded, 0)) * e.base_to_global_rate), 0)',
'total_discount_amount' => 'IFNULL(SUM((ABS(e.base_discount_amount) - IFNULL(e.base_discount_canceled, 0)) * e.base_to_global_rate), 0)',
'total_discount_amount_actual' => 'IFNULL(SUM((e.base_discount_invoiced - IFNULL(e.base_discount_refunded, 0)) * e.base_to_global_rate), 0)',
) (line 39)
  • access: protected
Redefined in descendants as:

Inherited Variables

Inherited from Mage_Sales_Model_Mysql4_Report_Collection_Abstract

Mage_Sales_Model_Mysql4_Report_Collection_Abstract::$_aggregatedColumns
 Mage_Sales_Model_Mysql4_Report_Collection_Abstract::$_applyFilters
 Mage_Sales_Model_Mysql4_Report_Collection_Abstract::$_from
 Mage_Sales_Model_Mysql4_Report_Collection_Abstract::$_isSubTotals
 Mage_Sales_Model_Mysql4_Report_Collection_Abstract::$_isTotals
 Mage_Sales_Model_Mysql4_Report_Collection_Abstract::$_orderStatus
 Mage_Sales_Model_Mysql4_Report_Collection_Abstract::$_period
 Mage_Sales_Model_Mysql4_Report_Collection_Abstract::$_storesIds
 Mage_Sales_Model_Mysql4_Report_Collection_Abstract::$_to

Inherited from Mage_Core_Model_Mysql4_Collection_Abstract

Mage_Core_Model_Mysql4_Collection_Abstract::$_eventObject
 Mage_Core_Model_Mysql4_Collection_Abstract::$_eventPrefix
 Mage_Core_Model_Mysql4_Collection_Abstract::$_fieldsToSelect
 Mage_Core_Model_Mysql4_Collection_Abstract::$_fieldsToSelectChanged
 Mage_Core_Model_Mysql4_Collection_Abstract::$_initialFieldsToSelect
 Mage_Core_Model_Mysql4_Collection_Abstract::$_joinedTables
 Mage_Core_Model_Mysql4_Collection_Abstract::$_mainTable
 Mage_Core_Model_Mysql4_Collection_Abstract::$_model
 Mage_Core_Model_Mysql4_Collection_Abstract::$_resetItemsDataChanged
 Mage_Core_Model_Mysql4_Collection_Abstract::$_resource
 Mage_Core_Model_Mysql4_Collection_Abstract::$_resourceModel
Methods
Description | Descendents | Vars (details) Constants Methods (details)
Constructor __construct (line 63)

Initialize custom resource model

  • access: public
Mage_Sales_Model_Mysql4_Report_Order_Updatedat_Collection __construct (array $parameters)
  • array $parameters
Redefinition of:
Mage_Core_Model_Mysql4_Collection_Abstract::__construct()
Collection constructor
load (line 197)

Load

  • access: public
Mage_Sales_Model_Mysql4_Report_Order_Updatedat_Collection load ([boolean $printQuery = false], [boolean $logQuery = false])
  • boolean $printQuery
  • boolean $logQuery
Redefinition of:
Mage_Sales_Model_Mysql4_Report_Collection_Abstract::load()
Load data Redeclare parent load method just for adding method _beforeLoad
_applyOrderStatusFilter (line 106)

Apply order status filter

  • access: protected
Mage_Sales_Model_Mysql4_Report_Order_Updatedat_Collection _applyOrderStatusFilter ()
Redefinition of:
Mage_Sales_Model_Mysql4_Report_Collection_Abstract::_applyOrderStatusFilter()
Apply order status filter
_applyStoresFilter (line 76)

Apply stores filter

  • access: protected
Mage_Sales_Model_Mysql4_Report_Order_Updatedat_Collection _applyStoresFilter ()
Redefinition of:
Mage_Sales_Model_Mysql4_Report_Collection_Abstract::_applyStoresFilter()
Apply stores filter
_getSelectedColumns (line 124)

Retrieve array of columns to select

  • access: protected
array _getSelectedColumns ()
_initSelect (line 144)

Add selected data

  • access: protected
Mage_Sales_Model_Mysql4_Report_Order_Updatedat_Collection _initSelect ()
Redefinition of:
Mage_Core_Model_Mysql4_Collection_Abstract::_initSelect()
Init collection select
Redefined in descendants as:

Inherited Methods

Inherited From Mage_Sales_Model_Mysql4_Report_Collection_Abstract

Mage_Sales_Model_Mysql4_Report_Collection_Abstract::addOrderStatusFilter()
Mage_Sales_Model_Mysql4_Report_Collection_Abstract::addStoreFilter()
Mage_Sales_Model_Mysql4_Report_Collection_Abstract::getAggregatedColumns()
Mage_Sales_Model_Mysql4_Report_Collection_Abstract::isSubTotals()
Mage_Sales_Model_Mysql4_Report_Collection_Abstract::isTotals()
Mage_Sales_Model_Mysql4_Report_Collection_Abstract::load()
Mage_Sales_Model_Mysql4_Report_Collection_Abstract::setAggregatedColumns()
Mage_Sales_Model_Mysql4_Report_Collection_Abstract::setApplyFilters()
Mage_Sales_Model_Mysql4_Report_Collection_Abstract::setDateRange()
Mage_Sales_Model_Mysql4_Report_Collection_Abstract::setPeriod()
Mage_Sales_Model_Mysql4_Report_Collection_Abstract::_applyDateRangeFilter()
Mage_Sales_Model_Mysql4_Report_Collection_Abstract::_applyOrderStatusFilter()
Mage_Sales_Model_Mysql4_Report_Collection_Abstract::_applyStoresFilter()
Mage_Sales_Model_Mysql4_Report_Collection_Abstract::_applyStoresFilterToSelect()

Inherited From Mage_Core_Model_Mysql4_Collection_Abstract

Mage_Core_Model_Mysql4_Collection_Abstract::__construct()
Mage_Core_Model_Mysql4_Collection_Abstract::addExpressionFieldToSelect()
Mage_Core_Model_Mysql4_Collection_Abstract::addFieldToSelect()
Mage_Core_Model_Mysql4_Collection_Abstract::getAllIds()
Mage_Core_Model_Mysql4_Collection_Abstract::getMainTable()
Mage_Core_Model_Mysql4_Collection_Abstract::getModelName()
Mage_Core_Model_Mysql4_Collection_Abstract::getResource()
Mage_Core_Model_Mysql4_Collection_Abstract::getResourceModelName()
Mage_Core_Model_Mysql4_Collection_Abstract::getSelect()
Mage_Core_Model_Mysql4_Collection_Abstract::getTable()
Mage_Core_Model_Mysql4_Collection_Abstract::join()
Mage_Core_Model_Mysql4_Collection_Abstract::removeAllFieldsFromSelect()
Mage_Core_Model_Mysql4_Collection_Abstract::removeFieldFromSelect()
Mage_Core_Model_Mysql4_Collection_Abstract::resetItemsDataChanged()
Mage_Core_Model_Mysql4_Collection_Abstract::save()
Mage_Core_Model_Mysql4_Collection_Abstract::setMainTable()
Mage_Core_Model_Mysql4_Collection_Abstract::setModel()
Mage_Core_Model_Mysql4_Collection_Abstract::setResetItemsDataChanged()
Mage_Core_Model_Mysql4_Collection_Abstract::setResourceModel()
Mage_Core_Model_Mysql4_Collection_Abstract::_afterLoad()
Mage_Core_Model_Mysql4_Collection_Abstract::_beforeLoad()
Mage_Core_Model_Mysql4_Collection_Abstract::_canUseCache()
Mage_Core_Model_Mysql4_Collection_Abstract::_construct()
Mage_Core_Model_Mysql4_Collection_Abstract::_getCacheTags()
Mage_Core_Model_Mysql4_Collection_Abstract::_getInitialFieldsToSelect()
Mage_Core_Model_Mysql4_Collection_Abstract::_init()
Mage_Core_Model_Mysql4_Collection_Abstract::_initInitialFieldsToSelect()
Mage_Core_Model_Mysql4_Collection_Abstract::_initSelect()
Mage_Core_Model_Mysql4_Collection_Abstract::_initSelectFields()
Mage_Core_Model_Mysql4_Collection_Abstract::_loadCache()
Mage_Core_Model_Mysql4_Collection_Abstract::_saveCache()
Class Constants
Description | Descendants | Constants (details) Vars (details) | Methods (details)

Inherited Constants

Inherited from Mage_Core_Model_Mysql4_Collection_Abstract

Mage_Core_Model_Mysql4_Collection_Abstract::CACHE_TAG

Documentation generated on Fri, 11 Feb 2011 16:58:46 +0200 by phpDocumentor 1.4.3