Mage_CatalogInventory_Model_Mysql4_Stock_Status Class Reference

Inheritance diagram for Mage_CatalogInventory_Model_Mysql4_Stock_Status:

List of all members.

Public Member Functions
	saveProductStatus (Mage_CatalogInventory_Model_Stock_Status $object, $productId, $status, $qty=0, $stockId=1, $websiteId=null)
	getProductStatus ($productIds, $websiteId, $stockId=1)
	getProductData ($productIds, $websiteId, $stockId=1)
	getWebsiteStores ()
	getProductsType ($productIds)
	getProductCollection ($lastEntityId=0, $limit=1000)
	addStockStatusToSelect (Varien_Db_Select $select, Mage_Core_Model_Website $website)
Protected Member Functions
	_construct ()

---

Detailed Description

Definition at line 34 of file Status.php.

---

Member Function Documentation

_construct

(

)

[protected]

Resource model initialization

Reimplemented from Mage_Core_Model_Resource_Abstract.

Definition at line 40 of file Status.php.

    {
        $this->_init('cataloginventory/stock_status', 'product_id');
    }

addStockStatusToSelect	(	Varien_Db_Select $	select,
		Mage_Core_Model_Website $	website
	)

Add stock status to prepare index select

Parameters:

	Varien_Db_Select	$select
	Mage_Core_Model_Website	$website

Returns:

Mage_CatalogInventory_Model_Mysql4_Stock_Status

Definition at line 204 of file Status.php.

    {
        $websiteId = $website->getId();
        $select->joinLeft(
            array('stock_status' => $this->getMainTable()),
            'e.entity_id=stock_status.product_id AND stock_status.website_id='.$websiteId,
            array('salable' => 'stock_status.stock_status')
        );

        return $this;
    }

getProductCollection	(	$	lastEntityId = 0,
		$	limit = 1000
	)

Retrieve Product part Collection array Return array as key product id, value product type

Parameters:

	int	$lastEntityId
	int	$limit

Returns:

array

Definition at line 186 of file Status.php.

                                                                           {
        $select = $this->_getReadAdapter()->select()
            ->from(
                array('e' => $this->getTable('catalog/product')),
                array('entity_id', 'type_id'))
            ->order('entity_id ASC')
            ->where('entity_id>?', $lastEntityId)
            ->limit($limit);
        return $this->_getReadAdapter()->fetchPairs($select);
    }

getProductData	(	$	productIds,
		$	websiteId,
		$	stockId = 1
	)

Retrieve product(s) data array

Parameters:

	int|array	$productIds
	int	$websiteId
	int	$stockId

Returns:

array

Definition at line 127 of file Status.php.

    {
        if (!is_array($productIds)) {
            $productIds = array($productIds);
        }

        $data = array();

        $select = $this->_getReadAdapter()->select()
            ->from($this->getMainTable())
            ->where('product_id IN(?)', $productIds)
            ->where('stock_id=?', $stockId)
            ->where('website_id=?', $websiteId);
        $query = $this->_getReadAdapter()->query($select);
        while ($row = $query->fetch()) {
            $data[$row['product_id']] = $row;
        }
        return $data;
    }

getProductStatus	(	$	productIds,
		$	websiteId,
		$	stockId = 1
	)

Retrieve product status Return array as key product id, value - stock status

Parameters:

	int|array	$productIds
	int	$websiteId
	int	$stockId

Returns:

array

Definition at line 104 of file Status.php.

    {
        if (!is_array($productIds)) {
            $productIds = array($productIds);
        }

        $select = $this->_getReadAdapter()->select()
            ->from($this->getMainTable(), array('product_id', 'stock_status'))
            ->where('product_id IN(?)', $productIds)
            ->where('stock_id=?', $stockId)
            ->where('website_id=?', $websiteId);
        return $this->_getReadAdapter()->fetchPairs($select);
    }

getProductsType

(

$

productIds

)

Retrieve Product Type

Parameters:

array|int

$productIds

Returns:

array

Definition at line 164 of file Status.php.

    {
        if (!is_array($productIds)) {
            $productIds = array($productIds);
        }

        $select = $this->_getReadAdapter()->select()
            ->from(
                array('e' => $this->getTable('catalog/product')),
                array('entity_id', 'type_id'))
            ->where('entity_id IN(?)', $productIds);
        return $this->_getReadAdapter()->fetchPairs($select);
    }

getWebsiteStores

(

)

Retrieve websites and default stores Return array as key website_id, value store_id

Returns:

array

Definition at line 153 of file Status.php.

                                       {
        $select = Mage::getModel('core/website')->getDefaultStoresSelect(false);
        return $this->_getReadAdapter()->fetchPairs($select);
    }

saveProductStatus	(	Mage_CatalogInventory_Model_Stock_Status $	object,
		$	productId,
		$	status,
		$	qty = 0,
		$	stockId = 1,
		$	websiteId = null
	)

Save Product Status per website

Parameters:

	Mage_CatalogInventory_Model_Stock_Status	$object
	int	$productId
	int	$status
	float	$qty
	int	$stockId
	int|null	$websiteId

Returns:

Mage_CatalogInventory_Model_Mysql4_Stock_Status

Definition at line 56 of file Status.php.

    {
        $websites = array_keys($object->getWebsites($websiteId));

        foreach ($websites as $websiteId) {
            $select = $this->_getWriteAdapter()->select()
                ->from($this->getMainTable())
                ->where('product_id=?', $productId)
                ->where('website_id=?', $websiteId)
                ->where('stock_id=?', $stockId);
            if ($row = $this->_getWriteAdapter()->fetchRow($select)) {
                $bind = array(
                    'qty'           => $qty,
                    'stock_status'  => $status
                );
                $where = array(
                    $this->_getWriteAdapter()->quoteInto('product_id=?', $row['product_id']),
                    $this->_getWriteAdapter()->quoteInto('website_id=?', $row['website_id']),
                    $this->_getWriteAdapter()->quoteInto('stock_id=?', $row['stock_id']),
                );
                $this->_getWriteAdapter()->update($this->getMainTable(), $bind, $where);
            }
            else {
                $bind = array(
                    'product_id'    => $productId,
                    'website_id'    => $websiteId,
                    'stock_id'      => $stockId,
                    'qty'           => $qty,
                    'stock_status'  => $status
                );
                $this->_getWriteAdapter()->insert($this->getMainTable(), $bind);
            }
        }

        return $this;
    }

---

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

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