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屋!