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_Reports_Block_Product_Abstract
  • Mage_Reports_Block_Product_Compared
  • Mage_Reports_Block_Product_Viewed
  • Mage_Reports_Block_Product_Widget_Compared
  • Mage_Reports_Block_Product_Widget_Viewed
  • Mage_Reports_Exception
  • Mage_Reports_Helper_Data
  • Mage_Reports_Model_Config
  • Mage_Reports_Model_Event
  • Mage_Reports_Model_Event_Observer
  • Mage_Reports_Model_Event_Type
  • Mage_Reports_Model_Flag
  • Mage_Reports_Model_Grouped_Collection
  • Mage_Reports_Model_Mysql4_Accounts_Collection
  • Mage_Reports_Model_Mysql4_Coupons_Collection
  • Mage_Reports_Model_Mysql4_Customer_Collection
  • Mage_Reports_Model_Mysql4_Customer_Orders_Collection
  • Mage_Reports_Model_Mysql4_Customer_Totals_Collection
  • Mage_Reports_Model_Mysql4_Entity_Summary_Collection_Abstract
  • Mage_Reports_Model_Mysql4_Event
  • Mage_Reports_Model_Mysql4_Event_Collection
  • Mage_Reports_Model_Mysql4_Event_Type
  • Mage_Reports_Model_Mysql4_Event_Type_Collection
  • Mage_Reports_Model_Mysql4_Invoiced_Collection
  • Mage_Reports_Model_Mysql4_Order_Collection
  • Mage_Reports_Model_Mysql4_Product_Collection
  • Mage_Reports_Model_Mysql4_Product_Downloads_Collection
  • Mage_Reports_Model_Mysql4_Product_Index_Abstract
  • Mage_Reports_Model_Mysql4_Product_Index_Collection_Abstract
  • Mage_Reports_Model_Mysql4_Product_Index_Compared
  • Mage_Reports_Model_Mysql4_Product_Index_Compared_Collection
  • Mage_Reports_Model_Mysql4_Product_Index_Viewed
  • Mage_Reports_Model_Mysql4_Product_Index_Viewed_Collection
  • Mage_Reports_Model_Mysql4_Product_Lowstock_Collection
  • Mage_Reports_Model_Mysql4_Product_Ordered_Collection
  • Mage_Reports_Model_Mysql4_Product_Sold_Collection
  • Mage_Reports_Model_Mysql4_Product_Viewed_Collection
  • Mage_Reports_Model_Mysql4_Quote_Collection
  • Mage_Reports_Model_Mysql4_Refunded_Collection
  • Mage_Reports_Model_Mysql4_Report_Abstract
  • Mage_Reports_Model_Mysql4_Report_Collection
  • Mage_Reports_Model_Mysql4_Review_Collection
  • Mage_Reports_Model_Mysql4_Review_Customer_Collection
  • Mage_Reports_Model_Mysql4_Review_Product_Collection
  • Mage_Reports_Model_Mysql4_Shipping_Collection
  • Mage_Reports_Model_Mysql4_Tag_Collection
  • Mage_Reports_Model_Mysql4_Tag_Customer_Collection
  • Mage_Reports_Model_Mysql4_Tag_Product_Collection
  • Mage_Reports_Model_Mysql4_Tax_Collection
  • Mage_Reports_Model_Mysql4_Wishlist_Collection
  • Mage_Reports_Model_Mysql4_Wishlist_Product_Collection
  • Mage_Reports_Model_Product_Index_Abstract
  • Mage_Reports_Model_Product_Index_Compared
  • Mage_Reports_Model_Product_Index_Viewed
  • Mage_Reports_Model_Report
  • Mage_Reports_Model_Resource_Accounts_Collection
  • Mage_Reports_Model_Resource_Coupons_Collection
  • Mage_Reports_Model_Resource_Customer_Collection
  • Mage_Reports_Model_Resource_Customer_Orders_Collection
  • Mage_Reports_Model_Resource_Customer_Totals_Collection
  • Mage_Reports_Model_Resource_Entity_Summary_Collection_Abstract
  • Mage_Reports_Model_Resource_Event
  • Mage_Reports_Model_Resource_Event_Collection
  • Mage_Reports_Model_Resource_Event_Type
  • Mage_Reports_Model_Resource_Event_Type_Collection
  • Mage_Reports_Model_Resource_Helper_Mysql4
  • Mage_Reports_Model_Resource_Invoiced_Collection
  • Mage_Reports_Model_Resource_Order_Collection
  • Mage_Reports_Model_Resource_Product_Collection
  • Mage_Reports_Model_Resource_Product_Downloads_Collection
  • Mage_Reports_Model_Resource_Product_Index_Abstract
  • Mage_Reports_Model_Resource_Product_Index_Collection_Abstract
  • Mage_Reports_Model_Resource_Product_Index_Compared
  • Mage_Reports_Model_Resource_Product_Index_Compared_Collection
  • Mage_Reports_Model_Resource_Product_Index_Viewed
  • Mage_Reports_Model_Resource_Product_Index_Viewed_Collection
  • Mage_Reports_Model_Resource_Product_Lowstock_Collection
  • Mage_Reports_Model_Resource_Product_Ordered_Collection
  • Mage_Reports_Model_Resource_Product_Sold_Collection
  • Mage_Reports_Model_Resource_Product_Viewed_Collection
  • Mage_Reports_Model_Resource_Quote_Collection
  • Mage_Reports_Model_Resource_Refunded_Collection
  • Mage_Reports_Model_Resource_Report_Abstract
  • Mage_Reports_Model_Resource_Report_Collection
  • Mage_Reports_Model_Resource_Report_Collection_Abstract
  • Mage_Reports_Model_Resource_Report_Product_Viewed
  • Mage_Reports_Model_Resource_Report_Product_Viewed_Collection
  • Mage_Reports_Model_Resource_Review_Collection
  • Mage_Reports_Model_Resource_Review_Customer_Collection
  • Mage_Reports_Model_Resource_Review_Product_Collection
  • Mage_Reports_Model_Resource_Shipping_Collection
  • Mage_Reports_Model_Resource_Shopcart_Product_Collection
  • Mage_Reports_Model_Resource_Tag_Collection
  • Mage_Reports_Model_Resource_Tag_Customer_Collection
  • Mage_Reports_Model_Resource_Tag_Product_Collection
  • Mage_Reports_Model_Resource_Tax_Collection
  • Mage_Reports_Model_Resource_Wishlist_Collection
  • Mage_Reports_Model_Resource_Wishlist_Product_Collection
  • Mage_Reports_Model_Session
  • Mage_Reports_Model_Test
  • Mage_Reports_Model_Totals

Interfaces

  • Mage_Reports_Model_Resource_Helper_Interface
  • Overview
  • Package
  • Class
  • Tree

Class Mage_Reports_Model_Resource_Order_Collection

Reports orders collection

Varien_Data_Collection_Db
Extended by Mage_Core_Model_Resource_Db_Collection_Abstract
Extended by Mage_Sales_Model_Resource_Collection_Abstract
Extended by Mage_Sales_Model_Resource_Order_Collection
Extended by Mage_Reports_Model_Resource_Order_Collection

Direct known subclasses

Mage_Reports_Model_Mysql4_Order_Collection, Mage_Reports_Model_Resource_Customer_Orders_Collection, Mage_Reports_Model_Resource_Customer_Totals_Collection

Indirect known subclasses

Mage_Reports_Model_Mysql4_Customer_Orders_Collection, Mage_Reports_Model_Mysql4_Customer_Totals_Collection
Package: Mage\Reports
Category: Mage
Copyright: Copyright (c) 2012 Magento Inc. (http://www.magentocommerce.com)
License: Open Software License (OSL 3.0)
Author: Magento Core Team <core@magentocommerce.com>
Located at code/core/Mage/Reports/Model/Resource/Order/Collection.php
Methods summary
public Mage_Reports_Model_Resource_Order_Collection
# checkIsLive( unknown_type $range )

Check range for live mode

Check range for live mode

Parameters

$range
unknown_type
$range

Returns

Mage_Reports_Model_Resource_Order_Collection
public boolean
# isLive( )

Retrieve is live flag for rep

Retrieve is live flag for rep

Returns

boolean
public Mage_Reports_Model_Resource_Order_Collection
# prepareSummary( string $range, mixed $customStart, mixed $customEnd, integer $isFilter = 0 )

Prepare report summary

Prepare report summary

Parameters

$range
string
$range
$customStart
mixed
$customStart
$customEnd
mixed
$customEnd
$isFilter
integer
$isFilter

Returns

Mage_Reports_Model_Resource_Order_Collection
protected Mage_Reports_Model_Resource_Order_Collection
# _prepareSummaryLive( string $range, mixed $customStart, mixed $customEnd, integer $isFilter = 0 )

Prepare report summary from live data

Prepare report summary from live data

Parameters

$range
string
$range
$customStart
mixed
$customStart
$customEnd
mixed
$customEnd
$isFilter
integer
$isFilter

Returns

Mage_Reports_Model_Resource_Order_Collection
protected Mage_Reports_Model_Resource_Order_Collection
# _prepareSummaryAggregated( string $range, mixed $customStart, mixed $customEnd )

Prepare report summary from aggregated data

Prepare report summary from aggregated data

Parameters

$range
string
$range
$customStart
mixed
$customStart
$customEnd
mixed
$customEnd

Returns

Mage_Reports_Model_Resource_Order_Collection
protected Zend_Db_Expr
# _getRangeExpression( string $range )

Get range expression

Get range expression

Parameters

$range
string
$range

Returns

Zend_Db_Expr
protected string
# _getRangeExpressionForAttribute( string $range, string $attribute )

Retrieve range expression adapted for attribute

Retrieve range expression adapted for attribute

Parameters

$range
string
$range
$attribute
string
$attribute

Returns

string
protected string
# _getTZRangeOffsetExpression( string $range, string $attribute, mixed $from = null, mixed $to = null )

Retrieve query for attribute with timezone conversion

Retrieve query for attribute with timezone conversion

Parameters

$range
string
$range
$attribute
string
$attribute
$from
mixed
$from
$to
mixed
$to

Returns

string
protected string
# _getTZRangeExpressionForAttribute( string $range, string $attribute, string $tzFrom = '+00:00', string $tzTo = null )

Retrieve range expression with timezone conversion adapted for attribute

Retrieve range expression with timezone conversion adapted for attribute

Parameters

$range
string
$range
$attribute
string
$attribute
$tzFrom
string
$tzFrom
$tzTo
string
$tzTo

Returns

string
public array
# getDateRange( string $range, string $customStart, string $customEnd, boolean $returnObjects = false )

Calculate From and To dates (or times) by given period

Calculate From and To dates (or times) by given period

Parameters

$range
string
$range
$customStart
string
$customStart
$customEnd
string
$customEnd
$returnObjects
boolean
$returnObjects

Returns

array
public Mage_Reports_Model_Resource_Order_Collection
# addItemCountExpr( )

Add item count expression

Add item count expression

Returns

Mage_Reports_Model_Resource_Order_Collection

Overrides

Mage_Sales_Model_Resource_Order_Collection::addItemCountExpr()
public Mage_Reports_Model_Resource_Order_Collection
# calculateTotals( integer $isFilter = 0 )

Calculate totals report

Calculate totals report

Parameters

$isFilter
integer
$isFilter

Returns

Mage_Reports_Model_Resource_Order_Collection
protected Mage_Reports_Model_Resource_Order_Collection
# _calculateTotalsLive( integer $isFilter = 0 )

Calculate totals live report

Calculate totals live report

Parameters

$isFilter
integer
$isFilter

Returns

Mage_Reports_Model_Resource_Order_Collection
protected Mage_Reports_Model_Resource_Order_Collection
# _calculateTotalsAggregated( integer $isFilter = 0 )

Calculate totals aggregated report

Calculate totals aggregated report

Parameters

$isFilter
integer
$isFilter

Returns

Mage_Reports_Model_Resource_Order_Collection
public Mage_Reports_Model_Resource_Order_Collection
# calculateSales( integer $isFilter = 0 )

Calculate lifitime sales

Calculate lifitime sales

Parameters

$isFilter
integer
$isFilter

Returns

Mage_Reports_Model_Resource_Order_Collection
public Mage_Reports_Model_Resource_Order_Collection
# setDateRange( string $from, string $to )

Set date range

Set date range

Parameters

$from
string
$from
$to
string
$to

Returns

Mage_Reports_Model_Resource_Order_Collection
public Mage_Reports_Model_Resource_Order_Collection
# setStoreIds( array $storeIds )

Set store filter collection

Set store filter collection

Parameters

$storeIds
array
$storeIds

Returns

Mage_Reports_Model_Resource_Order_Collection
public Mage_Reports_Model_Resource_Order_Collection
# groupByCustomer( )

Add group By customer attribute

Add group By customer attribute

Returns

Mage_Reports_Model_Resource_Order_Collection
public Mage_Reports_Model_Resource_Order_Collection
# joinCustomerName( string $alias = 'name' )

Join Customer Name (concat)

Join Customer Name (concat)

Parameters

$alias
string
$alias

Returns

Mage_Reports_Model_Resource_Order_Collection
public Mage_Reports_Model_Resource_Order_Collection
# addOrdersCount( )

Add Order count field to select

Add Order count field to select

Returns

Mage_Reports_Model_Resource_Order_Collection
public Mage_Reports_Model_Resource_Order_Collection
# addRevenueToSelect( boolean $convertCurrency = false )

Add revenue

Add revenue

Parameters

$convertCurrency
boolean
$convertCurrency

Returns

Mage_Reports_Model_Resource_Order_Collection
public Mage_Reports_Model_Resource_Order_Collection
# addSumAvgTotals( integer $storeId = 0 )

Add summary average totals

Add summary average totals

Parameters

$storeId
integer
$storeId

Returns

Mage_Reports_Model_Resource_Order_Collection
public Mage_Reports_Model_Resource_Order_Collection
# orderByTotalAmount( string $dir = self::SORT_ORDER_DESC )

Sort order by total amount

Sort order by total amount

Parameters

$dir
string
$dir

Returns

Mage_Reports_Model_Resource_Order_Collection
public Mage_Reports_Model_Resource_Order_Collection
# orderByOrdersCount( unknown_type $dir = self::SORT_ORDER_DESC )

Order by orders count

Order by orders count

Parameters

$dir
unknown_type
$dir

Returns

Mage_Reports_Model_Resource_Order_Collection
public Mage_Reports_Model_Resource_Order_Collection
# orderByCustomerRegistration( unknown_type $dir = self::SORT_ORDER_DESC )

Order by customer registration

Order by customer registration

Parameters

$dir
unknown_type
$dir

Returns

Mage_Reports_Model_Resource_Order_Collection
public Mage_Reports_Model_Resource_Order_Collection
# orderByCreatedAt( string $dir = self::SORT_ORDER_DESC )

Sort order by order created_at date

Sort order by order created_at date

Parameters

$dir
string
$dir

Returns

Mage_Reports_Model_Resource_Order_Collection
public unknown
# getSelectCountSql( )

Get select count sql

Get select count sql

Returns

unknown

Overrides

Mage_Sales_Model_Resource_Order_Collection::getSelectCountSql()
protected Mage_Reports_Model_Resource_Order_Collection
# _initInitialFieldsToSelect( )

Initialize initial fields to select

Initialize initial fields to select

Returns

Mage_Reports_Model_Resource_Order_Collection

Overrides

Mage_Core_Model_Resource_Db_Collection_Abstract::_initInitialFieldsToSelect()
public Mage_Reports_Model_Resource_Order_Collection
# addCreateAtPeriodFilter( string $period )

Add period filter by created_at attribute

Add period filter by created_at attribute

Parameters

$period
string
$period

Returns

Mage_Reports_Model_Resource_Order_Collection
Methods inherited from Mage_Sales_Model_Resource_Order_Collection
_addAddressFields(), _construct(), _getAllIdsSelect(), addAddressFields(), addAttributeToSearchFilter(), addBillingAgreementsFilter(), addFieldToSearchFilter(), addRecurringProfilesFilter()
Methods inherited from Mage_Sales_Model_Resource_Collection_Abstract
_attributeToField(), addAttributeToFilter(), addAttributeToSelect(), addAttributeToSort(), getAllIds(), joinAttribute(), setPage()
Methods inherited from Mage_Core_Model_Resource_Db_Collection_Abstract
__construct(), _afterLoad(), _beforeLoad(), _canUseCache(), _getCacheTags(), _getInitialFieldsToSelect(), _init(), _initSelect(), _initSelectFields(), _loadCache(), _prepareSelect(), _saveCache(), addExpressionFieldToSelect(), addFieldToSelect(), formatDate(), getData(), getMainTable(), getModelName(), getResource(), getResourceModelName(), getSelect(), getTable(), join(), removeAllFieldsFromSelect(), removeFieldFromSelect(), resetItemsDataChanged(), save(), setMainTable(), setModel(), setResetItemsDataChanged(), setResourceModel()
Constants inherited from Mage_Core_Model_Resource_Db_Collection_Abstract
CACHE_TAG
Properties summary
protected boolean $_isLive false
#

Is live

Is live

Properties inherited from Mage_Sales_Model_Resource_Order_Collection
$_eventObject, $_eventPrefix
Properties inherited from Mage_Core_Model_Resource_Db_Collection_Abstract
$_fieldsToSelect, $_fieldsToSelectChanged, $_initialFieldsToSelect, $_joinedTables, $_mainTable, $_model, $_resetItemsDataChanged, $_resource, $_resourceModel, $_useAnalyticFunction
Magento 1.7.0.2 API documentation generated by ApiGen 2.8.0