Class Mage_SalesRule_Model_Mysql4_Report_Updatedat_Collection

Description

Sales report coupons collection

Located in /SalesRule/Model/Mysql4/Report/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
            |
            --Mage_SalesRule_Model_Mysql4_Report_Updatedat_Collection
Variable Summary
Method Summary
Variables
mixed $_selectedColumns = array(
'store_id' => 'e.store_id',
'order_status' => 'e.status',
'coupon_code' => 'e.coupon_code',
'coupon_uses' => 'COUNT(e.`entity_id`)',
'subtotal_amount' => 'SUM((e.`base_subtotal` - IFNULL(e.`base_subtotal_canceled`, 0)) * e.`base_to_global_rate`)',
'discount_amount' => 'SUM((ABS(e.`base_discount_amount`) - IFNULL(e.`base_discount_canceled`, 0)) * e.`base_to_global_rate`)',
'total_amount' => 'SUM((e.`base_subtotal` - IFNULL(e.`base_subtotal_canceled`, 0) + IFNULL(ABS(e.`base_discount_amount`) - IFNULL(e.`base_discount_canceled`, 0), 0)) * e.`base_to_global_rate`)',
'subtotal_amount_actual' => 'SUM((e.`base_subtotal_invoiced` - IFNULL(e.`base_subtotal_refunded`, 0)) * e.`base_to_global_rate`)',
'discount_amount_actual' => 'SUM((e.`base_discount_invoiced` - IFNULL(e.`base_discount_refunded`, 0)) * e.`base_to_global_rate`)',
'total_amount_actual' => 'SUM((e.`base_subtotal_invoiced` - IFNULL(e.`base_subtotal_refunded`, 0) - IFNULL(e.`base_discount_invoiced` - IFNULL(e.`base_discount_refunded`, 0), 0)) * e.`base_to_global_rate`)',
)
(line 36)
  • access: protected

Redefinition of:
Mage_Sales_Model_Mysql4_Report_Order_Updatedat_Collection::$_selectedColumns

Inherited Variables

Inherited from Mage_Sales_Model_Mysql4_Report_Order_Updatedat_Collection

Mage_Sales_Model_Mysql4_Report_Order_Updatedat_Collection::$_inited
Mage_Sales_Model_Mysql4_Report_Order_Updatedat_Collection::$_periodFormat

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
_initSelect (line 54)

Add selected data

  • access: protected

Redefinition of:
Mage_Sales_Model_Mysql4_Report_Order_Updatedat_Collection::_initSelect()
Add selected data

Inherited Methods

Inherited From Mage_Sales_Model_Mysql4_Report_Order_Updatedat_Collection

Mage_Sales_Model_Mysql4_Report_Order_Updatedat_Collection::__construct()
Mage_Sales_Model_Mysql4_Report_Order_Updatedat_Collection::load()
Mage_Sales_Model_Mysql4_Report_Order_Updatedat_Collection::_applyOrderStatusFilter()
Mage_Sales_Model_Mysql4_Report_Order_Updatedat_Collection::_applyStoresFilter()
Mage_Sales_Model_Mysql4_Report_Order_Updatedat_Collection::_getSelectedColumns()
Mage_Sales_Model_Mysql4_Report_Order_Updatedat_Collection::_initSelect()

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

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