Magento：构建库存中所有可配置产品的自定义产品集合

Question

$collectionConfigurable = Mage::getResourceModel('catalog/product_collection')->addAttributeToFilter('type_id', array('eq' => 'configurable'));

foreach ($collectionConfigurable as $_configurableproduct) {
    $product = Mage::getModel('catalog/product')->load($_configurableproduct->getId());

    if ($product->isSaleable()) { 
// do something
}
}

Mage::getSingleton('cataloginventory/stock')->addInStockFilterToCollection($this->_productCollection);

$collectionConfigurable = Mage::getResourceModel('catalog/product_collection')->addAttributeToFilter('type_id', array('eq' => 'configurable'));
$instockConfigs = Mage::getSingleton('cataloginventory/stock')->addInStockFilterToCollection($collectionconfigurable);

将返回以下错误：

  Fatal error: Call to a member function joinField() on a non-object in /srv/magento/app/code/core/Mage/CatalogInventory/Model/Resource/Stock.php on line 197

Answer 1

我的“对股票系统更精细细节的天真”方法是

>

创建一个库存项目集合，只抓取库存项目。

使用该集合创建库存产品ID数组

//create a stock item collection with a `is_in_stock` filter
$collection = Mage::getModel('cataloginventory/stock')
->getItemCollection()
->addFieldToFilter('is_in_stock');

//capture the product ids of the in stock stock items
$product_ids = array();
foreach($collection as $item)
{
    $product_ids[] = $item->getProductId();
}

$products = Mage::getModel('catalog/product')
->getCollection()
->addAttributeToSelect('*')
->addFieldToFilter('entity_id',array('in'=>$product_ids))
->addFieldToFilter('type_id','configurable');

foreach($products as $product)
{
    var_dump($product->getData());
}

$product = Mage::getModel('catalog/product')->load($_configurableproduct->getId());

/**
 * Adds filtering for collection to return only in stock products
 *
 * @param Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Link_Product_Collection $collection
 * @return Mage_CatalogInventory_Model_Stock $this
 */
public function addInStockFilterToCollection($collection)
{
    $this->getResource()->setInStockFilterToCollection($collection);
    return $this;
}