00001 <?php
00002
00003
00004
00005
00006
00007
00008
00009
00010
00011
00012
00013
00014
00015
00016
00017
00018
00019
00020
00021
00022
00023
00024
00025
00026
00027
00028
00029
00030
00031
00032
00033
00034 class Mage_CatalogInventory_Model_Mysql4_Stock_Item extends Mage_Core_Model_Mysql4_Abstract
00035 {
00036 protected function _construct()
00037 {
00038 $this->_init('cataloginventory/stock_item', 'item_id');
00039 }
00040
00041
00042
00043
00044
00045
00046
00047
00048 public function loadByProductId(Mage_CatalogInventory_Model_Stock_Item $item, $productId)
00049 {
00050 $select = $this->_getLoadSelect('product_id', $productId, $item)
00051 ->where('stock_id=?', $item->getStockId());
00052
00053 $item->setData($this->_getReadAdapter()->fetchRow($select));
00054 $this->_afterLoad($item);
00055 return $this;
00056 }
00057
00058
00059
00060
00061
00062
00063
00064
00065
00066 protected function _getLoadSelect($field, $value, $object)
00067 {
00068 return parent::_getLoadSelect($field, $value, $object)
00069 ->joinInner(array('p' => $this->getTable('catalog/product')), 'product_id=p.entity_id', 'type_id')
00070 ;
00071 }
00072
00073
00074
00075
00076
00077
00078
00079 public function addCatalogInventoryToProductCollection($productCollection)
00080 {
00081 $isStockManagedInConfig = (int) Mage::getStoreConfig(Mage_CatalogInventory_Model_Stock_Item::XML_PATH_MANAGE_STOCK);
00082 $productCollection->joinTable('cataloginventory/stock_item',
00083 'product_id=entity_id',
00084 array(
00085 'is_saleable' => new Zend_Db_Expr('(IF(IF(use_config_manage_stock, ' . $isStockManagedInConfig . ', manage_stock), is_in_stock, 1))'),
00086 'inventory_in_stock' => 'is_in_stock'
00087 ),
00088 null, 'left');
00089 return $this;
00090 }
00091 }