Mage_CatalogInventory_Model_Mysql4_Stock Class Reference

Inheritance diagram for Mage_CatalogInventory_Model_Mysql4_Stock:

List of all members.

Public Member Functions
	lockProductItems ($stock, $productIds)
	setInStockFilterToCollection ($collection)
	updateSetOutOfStock ()
	updateSetInStock ()
	updateLowStockDate ()
Protected Member Functions
	_construct ()
	_initConfig ()
Protected Attributes
	$_isConfig
	$_isConfigManageStock
	$_isConfigBackorders
	$_configMinQty
	$_configTypeIds
	$_configNotifyStockQty
	$_stock

---

Detailed Description

Definition at line 34 of file Stock.php.

---

Member Function Documentation

_construct

(

)

[protected]

Resource initialization

Reimplemented from Mage_Core_Model_Resource_Abstract.

Definition at line 44 of file Stock.php.

    {
        $this->_init('cataloginventory/stock', 'stock_id');
    }

_initConfig

(

)

[protected]

Load some inventory configuration settings

Definition at line 99 of file Stock.php.

    {
        if (!$this->_isConfig) {
            $this->_isConfig = true;
            $this->_isConfigManageStock  = (int)Mage::getStoreConfigFlag(Mage_CatalogInventory_Model_Stock_Item::XML_PATH_MANAGE_STOCK);
            $this->_isConfigBackorders   = (int)Mage::getStoreConfig(Mage_CatalogInventory_Model_Stock_Item::XML_PATH_BACKORDERS);
            $this->_configMinQty         = (int)Mage::getStoreConfig(Mage_CatalogInventory_Model_Stock_Item::XML_PATH_MIN_QTY);
            $this->_configNotifyStockQty = (int)Mage::getStoreConfig(Mage_CatalogInventory_Model_Stock_Item::XML_PATH_NOTIFY_STOCK_QTY);
            $this->_configTypeIds        = array_keys(Mage::helper('catalogInventory')->getIsQtyTypeIds(true));
            $this->_stock                = Mage::getModel('cataloginventory/stock');
        }
    }

lockProductItems	(	$	stock,
		$	productIds
	)

We use write adapter for resolving problems with replication

Definition at line 49 of file Stock.php.

    {
        $itemTable = $this->getTable('cataloginventory/stock_item');
        $select = $this->_getReadAdapter()->select()
            ->from($itemTable)
            ->where('stock_id=?', $stock->getId())
            ->where('product_id IN(?)', $productIds)
            ->forUpdate(true);
        /**
         * We use write adapter for resolving problems with replication
         */
        $this->_getWriteAdapter()->query($select);
        return $this;
    }

setInStockFilterToCollection

(

$

collection

)

add join to select only in stock products

Parameters:

Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Link_Product_Collection

$collection

Returns:

Mage_CatalogInventory_Model_Mysql4_Stock

Definition at line 70 of file Stock.php.

    {
        $manageStock = Mage::getStoreConfig(Mage_CatalogInventory_Model_Stock_Item::XML_PATH_MANAGE_STOCK);
        $cond = array(
            '{{table}}.use_config_manage_stock = 0 AND {{table}}.manage_stock=1 AND {{table}}.is_in_stock=1',
            '{{table}}.use_config_manage_stock = 0 AND {{table}}.manage_stock=0',
        );

        if ($manageStock) {
            $cond[] = '{{table}}.use_config_manage_stock = 1 AND {{table}}.is_in_stock=1';
        }
        else {
            $cond[] = '{{table}}.use_config_manage_stock = 1';
        }

        $collection->joinField(
            'inventory_in_stock',
            'cataloginventory/stock_item',
            'is_in_stock',
            'product_id=entity_id',
            '('.join(') OR (', $cond) . ')'
        );
        return $this;
    }

updateLowStockDate

(

)

Update items low stock date basing on their quantities and config settings

Definition at line 161 of file Stock.php.

    {
        $nowUTC = Mage::app()->getLocale()->date(null, null, null, false)->toString(Varien_Date::DATETIME_INTERNAL_FORMAT);
        $this->_initConfig();
        $this->_getWriteAdapter()->update($this->getTable('cataloginventory/stock_item'),
            array('low_stock_date' => new Zend_Db_Expr(sprintf('CASE
                WHEN (use_config_notify_stock_qty = 1 AND qty < %d) OR (use_config_notify_stock_qty = 0 AND qty < notify_stock_qty)
                THEN %s ELSE NULL
                END
                ', $this->_configNotifyStockQty, $this->_getWriteAdapter()->quote($nowUTC)
            ))),
            sprintf('stock_id = %d
                AND (use_config_manage_stock = 1 AND 1 = %d OR use_config_manage_stock = 0 AND manage_stock = 1)
                AND product_id IN (SELECT entity_id FROM %s WHERE type_id IN (%s))',
                $this->_stock->getId(),
                $this->_isConfigManageStock,
                $this->getTable('catalog/product'), $this->_getWriteAdapter()->quote($this->_configTypeIds)
        ));
    }

updateSetInStock

(

)

Set items in stock basing on their quantities and config settings

Definition at line 139 of file Stock.php.

    {
        $this->_initConfig();
        $this->_getWriteAdapter()->update($this->getTable('cataloginventory/stock_item'),
            array('is_in_stock' => 1),
            sprintf('stock_id = %d
                AND is_in_stock = 0
                AND stock_status_changed_automatically = 1
                AND (use_config_manage_stock = 1 AND 1 = %d OR use_config_manage_stock = 0 AND manage_stock = 1)
                AND (use_config_min_qty = 1 AND qty > %d OR use_config_min_qty = 0 AND qty > min_qty)
                AND product_id IN (SELECT entity_id FROM %s WHERE type_id IN (%s))',
                $this->_stock->getId(),
                $this->_isConfigManageStock,
                $this->_configMinQty,
                $this->getTable('catalog/product'), $this->_getWriteAdapter()->quote($this->_configTypeIds)
        ));
    }

updateSetOutOfStock

(

)

Set items out of stock basing on their quantities and config settings

Definition at line 116 of file Stock.php.

    {
        $this->_initConfig();
        $this->_getWriteAdapter()->update($this->getTable('cataloginventory/stock_item'),
            array('is_in_stock' => 0, 'stock_status_changed_automatically' => 1),
            sprintf('stock_id = %d
                AND is_in_stock = 1
                AND (use_config_manage_stock = 1 AND 1 = %d OR use_config_manage_stock = 0 AND manage_stock = 1)
                AND (use_config_backorders = 1 AND %d = %d OR use_config_backorders = 0 AND backorders = %d)
                AND (use_config_min_qty = 1 AND qty <= %d OR use_config_min_qty = 0 AND qty <= min_qty)
                AND product_id IN (SELECT entity_id FROM %s WHERE type_id IN (%s))',
                $this->_stock->getId(),
                $this->_isConfigManageStock,
                Mage_CatalogInventory_Model_Stock::BACKORDERS_NO, $this->_isConfigBackorders, Mage_CatalogInventory_Model_Stock::BACKORDERS_NO,
                $this->_configMinQty,
                $this->getTable('catalog/product'), $this->_getWriteAdapter()->quote($this->_configTypeIds)
        ));
    }

---

Member Data Documentation

$_configMinQty [protected]

Definition at line 39 of file Stock.php.

$_configNotifyStockQty [protected]

Definition at line 41 of file Stock.php.

$_configTypeIds [protected]

Definition at line 40 of file Stock.php.

$_isConfig [protected]

Definition at line 36 of file Stock.php.

$_isConfigBackorders [protected]

Definition at line 38 of file Stock.php.

$_isConfigManageStock [protected]

Definition at line 37 of file Stock.php.

$_stock [protected]

Definition at line 42 of file Stock.php.

---

The documentation for this class was generated from the following file:

• app/code/core/Mage/CatalogInventory/Model/Mysql4/Stock.php