Magento:如何将两个产品集合合二为一? [英] Magento: how to merge two product collections into one?

问题描述

如果我有两个产品系列，有没有办法将它们合并成一个?

if i have two product collections is there a way to merge them into one?

例如(我的最终意图不是实际上只是收集 2 只猫，这只是为了说明问题):

for example (my final intent isn't to actually just get a collection of 2 cats, this is just to illustrate the issue):

$collection1 = Mage::getModel('catalog/category')->load(148)->getProductCollection();
$collection2 = Mage::getModel('catalog/category')->load(149)->getProductCollection();

$merged_collection = merge_collections($collection1,$collection2);

任何帮助将不胜感激！

推荐答案

假设您希望组合在一起的项目属于相同类型并且存在于数据库中，那么您可以这样做:

Assuming the items you wish to group together are of the same type and exist in the database then you can do this:

$collection1 = Mage::getModel('catalog/category')->load(148)->getProductCollection();
$collection2 = Mage::getModel('catalog/category')->load(149)->getProductCollection();

$merged_ids = array_merge($collection1->getAllIds(), $collection2->getAllIds());
// can sometimes use "getLoadedIds()" as well

$merged_collection = Mage::getResourceModel('catalog/product_collection')
    ->addFieldToFilter('entity_id', array('in' => $merged_ids))
    ->addAttributeToSelect('*');

这里我知道按 entity_id 过滤，因为这是产品的键字段，就像大多数实体类型一样，一些平面表有不同的主键.通常，您可以使用集合的 getIdFieldName() 方法之一来概括它.在这种情况下，产品是一个不好的例子，因为它的 ID 字段名称没有正确填写.

Here I know to filter by entity_id because that is products' key field, like it is for most entity types, some flat tables have a different primary key. Often you can generalise that with one of the collection's getIdFieldName() method. Products are a bad example in this case because it's ID field name isn't filled out correctly.

这篇关于Magento:如何将两个产品集合合二为一?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！