Docs For Class Mage_Reports_Model_Mysql4_Product_Lowstock

Description

Product Low Stock Report Collection

author: Magento Core Team <[email protected]>

Located in /Reports/Model/Mysql4/Product/Lowstock/Collection.php (line 35)

Varien_Data_Collection_Db
   |
   --Mage_Eav_Model_Entity_Collection_Abstract
      |
      --Mage_Catalog_Model_Resource_Eav_Mysql4_Collection_Abstract
         |
         --Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection
            |
            --Mage_Reports_Model_Mysql4_Product_Collection
               |
               --Mage_Reports_Model_Mysql4_Product_Lowstock_Collection

Variable Summary

bool $_inventoryItemJoined

Mage_CatalogInventory_Model_Mysql4_Stock_Item $_inventoryItemResource

string $_inventoryItemTableAlias

Method Summary

Mage_Reports_Model_Mysql4_Product_Collection filterByIsQtyProductTypes ()

Mage_Reports_Model_Mysql4_Product_Collection filterByProductType (array|string $typeFilter)

Mage_Reports_Model_Mysql4_Product_Collection joinInventoryItem ([ $fields = array()])

Mage_Reports_Model_Mysql4_Product_Collection useManageStockFilter ([int|null $storeId = null])

Mage_Reports_Model_Mysql4_Product_Collection useNotifyStockQtyFilter ([int $storeId = null])

Mage_Reports_Model_Mysql4_Product_Lowstock_Collection _addInventoryItemFieldToSelect (string $field, [string $alias = null])

string _getInventoryItemField (string $field)

string _getInventoryItemIdField ()

Mage_CatalogInventory_Model_Mysql4_Stock_Item _getInventoryItemResource ()

string _getInventoryItemTable ()

string _getInventoryItemTableAlias ()

Variables

bool $_inventoryItemJoined = false (line 49)

Flag about is joined CatalogInventory Stock Item

access: protected

Mage_CatalogInventory_Model_Mysql4_Stock_Item $_inventoryItemResource = null (line 42)

CatalogInventory Stock Item Resource instance

access: protected

string $_inventoryItemTableAlias = 'lowstock_inventory_item' (line 56)

Alias for CatalogInventory Stock Item Table

access: protected

Inherited Variables

Inherited from Mage_Reports_Model_Mysql4_Product_Collection

Mage_Reports_Model_Mysql4_Product_Collection::$_productEntityId
Mage_Reports_Model_Mysql4_Product_Collection::$_productEntityTableName
Mage_Reports_Model_Mysql4_Product_Collection::$_productEntityTypeId
Mage_Reports_Model_Mysql4_Product_Collection::$_selectCountSqlType

Inherited from Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection

Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::$_addFinalPrice
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::$_addMinimalPrice
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::$_addTaxPercents
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::$_addUrlRewrite
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::$_allIdsCache
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::$_flatEnabled
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::$_isWebsiteFilter
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::$_map
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::$_priceDataFieldFilters
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::$_productCategoryTable
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::$_productCountSelect
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::$_productLimitationFilters
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::$_productWebsiteTable
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::$_urlRewriteCategory

Inherited from Mage_Catalog_Model_Resource_Eav_Mysql4_Collection_Abstract

Mage_Catalog_Model_Resource_Eav_Mysql4_Collection_Abstract::$_storeId

Inherited from Mage_Eav_Model_Entity_Collection_Abstract

Mage_Eav_Model_Entity_Collection_Abstract::$_entity
Mage_Eav_Model_Entity_Collection_Abstract::$_filterAttributes
Mage_Eav_Model_Entity_Collection_Abstract::$_itemsById
Mage_Eav_Model_Entity_Collection_Abstract::$_joinAttributes
Mage_Eav_Model_Entity_Collection_Abstract::$_joinEntities
Mage_Eav_Model_Entity_Collection_Abstract::$_joinFields
Mage_Eav_Model_Entity_Collection_Abstract::$_selectAttributes
Mage_Eav_Model_Entity_Collection_Abstract::$_selectEntityTypes
Mage_Eav_Model_Entity_Collection_Abstract::$_staticFields

Methods

filterByIsQtyProductTypes (line 198)

Add filter by product types from config Only types witch has QTY parameter

access: public

Mage_Reports_Model_Mysql4_Product_Collection filterByIsQtyProductTypes ()

filterByProductType (line 181)

Add filter by product type(s)

access: public

Mage_Reports_Model_Mysql4_Product_Collection filterByProductType (array|string $typeFilter)

array|string $typeFilter

joinInventoryItem (line 143)

Join catalog inventory stock item table for further stock_item values filters

access: public

Mage_Reports_Model_Mysql4_Product_Collection joinInventoryItem ([ $fields = array()])

$fields

useManageStockFilter (line 212)

Add Use Manage Stock Condition to collection

access: public

Mage_Reports_Model_Mysql4_Product_Collection useManageStockFilter ([int|null $storeId = null])

int|null $storeId

useNotifyStockQtyFilter (line 228)

Add Notify Stock Qty Condition to collection

access: public

Mage_Reports_Model_Mysql4_Product_Collection useNotifyStockQtyFilter ([int $storeId = null])

int $storeId

_addInventoryItemFieldToSelect (line 108)

Add catalog inventory stock item field to select

access: protected

Mage_Reports_Model_Mysql4_Product_Lowstock_Collection _addInventoryItemFieldToSelect (string $field, [string $alias = null])

string $field
string $alias

_getInventoryItemField (line 133)

Retrieve catalog inventory stock item field correlation name

access: protected

string _getInventoryItemField (string $field)

string $field

_getInventoryItemIdField (line 86)

Retrieve CatalogInventory Stock Item Table Id field name

access: protected

string _getInventoryItemIdField ()

_getInventoryItemResource (line 63)

Retrieve CatalogInventory Stock Item Resource instance

access: protected

Mage_CatalogInventory_Model_Mysql4_Stock_Item _getInventoryItemResource ()

_getInventoryItemTable (line 76)

Retrieve CatalogInventory Stock Item Table

access: protected

string _getInventoryItemTable ()

_getInventoryItemTableAlias (line 96)

Retrieve alias for CatalogInventory Stock Item Table

access: protected

string _getInventoryItemTableAlias ()

Inherited Methods

Inherited From Mage_Reports_Model_Mysql4_Product_Collection

Mage_Reports_Model_Mysql4_Product_Collection::__construct()
Mage_Reports_Model_Mysql4_Product_Collection::addCartsCount()
Mage_Reports_Model_Mysql4_Product_Collection::addOrderedQty()
Mage_Reports_Model_Mysql4_Product_Collection::addOrdersCount()
Mage_Reports_Model_Mysql4_Product_Collection::addViewsCount()
Mage_Reports_Model_Mysql4_Product_Collection::getProductEntityId()
Mage_Reports_Model_Mysql4_Product_Collection::getProductEntityTableName()
Mage_Reports_Model_Mysql4_Product_Collection::getProductEntityTypeId()
Mage_Reports_Model_Mysql4_Product_Collection::getSelectCountSql()
Mage_Reports_Model_Mysql4_Product_Collection::setOrder()
Mage_Reports_Model_Mysql4_Product_Collection::setProductEntityId()
Mage_Reports_Model_Mysql4_Product_Collection::setProductEntityTableName()
Mage_Reports_Model_Mysql4_Product_Collection::setProductEntityTypeId()
Mage_Reports_Model_Mysql4_Product_Collection::setSelectCountSqlType()
Mage_Reports_Model_Mysql4_Product_Collection::_joinFields()

Inherited From Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection

Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::addAttributeToFilter()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::addAttributeToSelect()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::addAttributeToSort()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::addCategoryFilter()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::addCategoryIds()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::addCountToCategories()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::addFilterByRequiredOptions()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::addFinalPrice()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::addIdFilter()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::addMinimalPrice()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::addOptionsToResult()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::addPriceData()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::addPriceDataFieldFilter()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::addStoreFilter()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::addTaxPercents()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::addTierPriceData()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::addUrlRewrite()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::addWebsiteFilter()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::addWebsiteNamesToResult()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::applyFrontendPriceLimitations()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::clear()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::getAllAttributeValues()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::getAllIds()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::getAllIdsCache()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::getAttributeValueCount()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::getAttributeValueCountByRange()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::getFlatHelper()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::getMaxAttributeValue()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::getNewEmptyItem()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::getProductCountSelect()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::getProductTypeIds()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::getSelectCountSql()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::getSetIds()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::isEnabledFlat()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::joinMinimalPrice()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::joinUrlRewrite()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::requireTaxPercent()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::setAllIdsCache()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::setEntity()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::setGeneralDefoultQuery()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::setStore()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::setVisibility()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::unsProductCountSelect()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::_addFinalPrice()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::_addMinimalPrice()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::_addTaxPercents()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::_addUrlRewrite()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::_afterLoad()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::_applyProductLimitations()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::_applyZeroStoreProductLimitations()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::_beforeLoad()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::_construct()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::_init()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::_initSelect()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::_initTables()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::_joinPriceRules()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::_loadAttributes()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::_prepareProductLimitationFilters()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::_prepareStaticFields()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::_prepareUrlDataObject()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::_productLimitationJoinPrice()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::_productLimitationJoinStore()
Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection::_productLimitationJoinWebsite()

Inherited From Mage_Catalog_Model_Resource_Eav_Mysql4_Collection_Abstract

Mage_Catalog_Model_Resource_Eav_Mysql4_Collection_Abstract::getDefaultStoreId()
Mage_Catalog_Model_Resource_Eav_Mysql4_Collection_Abstract::getStoreId()
Mage_Catalog_Model_Resource_Eav_Mysql4_Collection_Abstract::setStore()
Mage_Catalog_Model_Resource_Eav_Mysql4_Collection_Abstract::setStoreId()
Mage_Catalog_Model_Resource_Eav_Mysql4_Collection_Abstract::_getLoadAttributesSelect()
Mage_Catalog_Model_Resource_Eav_Mysql4_Collection_Abstract::_joinAttributeToSelect()

Inherited From Mage_Eav_Model_Entity_Collection_Abstract

Mage_Eav_Model_Entity_Collection_Abstract::__construct()
Mage_Eav_Model_Entity_Collection_Abstract::addAttributeToFilter()
Mage_Eav_Model_Entity_Collection_Abstract::addAttributeToSelect()
Mage_Eav_Model_Entity_Collection_Abstract::addAttributeToSort()
Mage_Eav_Model_Entity_Collection_Abstract::addEntityTypeToSelect()
Mage_Eav_Model_Entity_Collection_Abstract::addExpressionAttributeToSelect()
Mage_Eav_Model_Entity_Collection_Abstract::addFieldToFilter()
Mage_Eav_Model_Entity_Collection_Abstract::addItem()
Mage_Eav_Model_Entity_Collection_Abstract::addStaticField()
Mage_Eav_Model_Entity_Collection_Abstract::delete()
Mage_Eav_Model_Entity_Collection_Abstract::exportToArray()
Mage_Eav_Model_Entity_Collection_Abstract::getAllIds()
Mage_Eav_Model_Entity_Collection_Abstract::getAllIdsSql()
Mage_Eav_Model_Entity_Collection_Abstract::getAttribute()
Mage_Eav_Model_Entity_Collection_Abstract::getEntity()
Mage_Eav_Model_Entity_Collection_Abstract::getLoadedIds()
Mage_Eav_Model_Entity_Collection_Abstract::getResource()
Mage_Eav_Model_Entity_Collection_Abstract::getRowIdFieldName()
Mage_Eav_Model_Entity_Collection_Abstract::getTable()
Mage_Eav_Model_Entity_Collection_Abstract::groupByAttribute()
Mage_Eav_Model_Entity_Collection_Abstract::importFromArray()
Mage_Eav_Model_Entity_Collection_Abstract::joinAttribute()
Mage_Eav_Model_Entity_Collection_Abstract::joinField()
Mage_Eav_Model_Entity_Collection_Abstract::joinTable()
Mage_Eav_Model_Entity_Collection_Abstract::load()
Mage_Eav_Model_Entity_Collection_Abstract::removeAttributeToSelect()
Mage_Eav_Model_Entity_Collection_Abstract::save()
Mage_Eav_Model_Entity_Collection_Abstract::setEntity()
Mage_Eav_Model_Entity_Collection_Abstract::setObject()
Mage_Eav_Model_Entity_Collection_Abstract::setOrder()
Mage_Eav_Model_Entity_Collection_Abstract::setPage()
Mage_Eav_Model_Entity_Collection_Abstract::setRowIdFieldName()
Mage_Eav_Model_Entity_Collection_Abstract::toArray()
Mage_Eav_Model_Entity_Collection_Abstract::_addAttributeJoin()
Mage_Eav_Model_Entity_Collection_Abstract::_afterLoad()
Mage_Eav_Model_Entity_Collection_Abstract::_beforeLoad()
Mage_Eav_Model_Entity_Collection_Abstract::_construct()
Mage_Eav_Model_Entity_Collection_Abstract::_getAllIdsSelect()
Mage_Eav_Model_Entity_Collection_Abstract::_getAttributeConditionSql()
Mage_Eav_Model_Entity_Collection_Abstract::_getAttributeFieldName()
Mage_Eav_Model_Entity_Collection_Abstract::_getAttributeTableAlias()
Mage_Eav_Model_Entity_Collection_Abstract::_getLoadAttributesSelect()
Mage_Eav_Model_Entity_Collection_Abstract::_init()
Mage_Eav_Model_Entity_Collection_Abstract::_initSelect()
Mage_Eav_Model_Entity_Collection_Abstract::_joinAttributeToSelect()
Mage_Eav_Model_Entity_Collection_Abstract::_loadAttributes()
Mage_Eav_Model_Entity_Collection_Abstract::_loadEntities()
Mage_Eav_Model_Entity_Collection_Abstract::_prepareStaticFields()
Mage_Eav_Model_Entity_Collection_Abstract::_reset()
Mage_Eav_Model_Entity_Collection_Abstract::_setItemAttributeValue()

Class Constants

Inherited Constants

Inherited from Mage_Reports_Model_Mysql4_Product_Collection

Mage_Reports_Model_Mysql4_Product_Collection::SELECT_COUNT_SQL_TYPE_CART

Class Mage_Reports_Model_Mysql4_Product_Lowstock_Collection

Inherited Variables

Inherited Methods

Inherited Constants