So fügen Sie ein-UND filter - / - Bedingung, um eine Bedingung ODER in Magento?

Nicht Nein, ich glaube, du bist etwas fehlt. Ich lief in ein ähnliches Problem eine Weile zurück und verwendet getSelect()->where() zu umgehen.

Beginnend mit der Abfrage:

SELECT * FROM products WHERE (name like '%blah%' and name like 
'%yes%') or (description like '%blah%' and description like '%yes%');

Zuerst habe ich eine Auflistung erstellt und verwendet die OR - array-Methode auf, um die Abfrage.

$collection = Mage::getModel('catalog/product')->getCollection();
$collection->addFieldToFilter(array(
                              array('attribute' => 'name', 'like' => '%blah%'),
                              array('attribute' => 'name', 'like' => '%yes%')
                              ));
$collection->addFieldToFilter(array(
                              array('attribute' => 'description', 'like' => '%blah%'),
                              array('attribute' => 'description', 'like' => '%yes%')
                              ));
$collection->load(true); //To dump the sql as text

Dies führte zu folgender Ausgabe:

SELECT `e`.*, IF(at_name.value_id > 0, at_name.value, at_name_default.value) AS `name`, IF(at_description.value_id > 0, at_description.value, at_description_default.value) AS `description` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_entity_varchar` AS `at_name_default` ON (`at_name_default`.`entity_id` = `e`.`entity_id`) AND (`at_name_default`.`attribute_id` = '96') AND `at_name_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_varchar` AS `at_name` ON (`at_name`.`entity_id` = `e`.`entity_id`) AND (`at_name`.`attribute_id` = '96') AND (`at_name`.`store_id` = 1) INNER JOIN `catalog_product_entity_text` AS `at_description_default` ON (`at_description_default`.`entity_id` = `e`.`entity_id`) AND (`at_description_default`.`attribute_id` = '97') AND `at_description_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_text` AS `at_description` ON (`at_description`.`entity_id` = `e`.`entity_id`) AND (`at_description`.`attribute_id` = '97') AND (`at_description`.`store_id` = 1) 
WHERE ((IF(at_name.value_id > 0, at_name.value, at_name_default.value) LIKE '%blah%') OR (IF(at_name.value_id > 0, at_name.value, at_name_default.value) LIKE '%yes%')) AND ((IF(at_description.value_id > 0, at_description.value, at_description_default.value) LIKE '%blah%') OR (IF(at_description.value_id > 0, at_description.value, at_description_default.value) LIKE '%yes%'))

Werden Sie feststellen, dass die WHERE Aussage ist fast, wo du es beschrieben hast, außer das OR und AND Umgekehrt.

Kopierte ich die WHERE Teil der Abfrage und eine zusätzliche getSelect()->where() Linie um die Sammlung so:

$collection = Mage::getModel('catalog/product')->getCollection();

//I added these lines to ensure that the collection would load 
//the fields and do the necessary joins to pull the data
$collection->addFieldToFilter('name');          
$collection->addFieldToFilter('description');

//I'm using the same WHERE statement but I have set the ANDs and ORs
//to match your requirements

$collection->getSelect()->where(" (IF(at_name.value_id > 0, at_name.value, at_name_default.value) LIKE '%blah%') AND (IF(at_name.value_id > 0, at_name.value, at_name_default.value) LIKE '%yes%')) OR ((IF(at_description.value_id > 0, at_description.value, at_description_default.value) LIKE '%blah%') AND (IF(at_description.value_id > 0, at_description.value, at_description_default.value) LIKE '%yes%')");

$collection->load(true); //To dump the sql as text again

Die resultierende Ausgabe ist:

SELECT `e`.*, IF(at_name.value_id > 0, at_name.value, at_name_default.value) AS `name`, IF(at_description.value_id > 0, at_description.value, at_description_default.value) AS `description` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_entity_varchar` AS `at_name_default` ON (`at_name_default`.`entity_id` = `e`.`entity_id`) AND (`at_name_default`.`attribute_id` = '96') AND `at_name_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_varchar` AS `at_name` ON (`at_name`.`entity_id` = `e`.`entity_id`) AND (`at_name`.`attribute_id` = '96') AND (`at_name`.`store_id` = 1) INNER JOIN `catalog_product_entity_text` AS `at_description_default` ON (`at_description_default`.`entity_id` = `e`.`entity_id`) AND (`at_description_default`.`attribute_id` = '97') AND `at_description_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_text` AS `at_description` ON (`at_description`.`entity_id` = `e`.`entity_id`) AND (`at_description`.`attribute_id` = '97') AND (`at_description`.`store_id` = 1) 
WHERE (IF(at_name.value_id > 0, at_name.value, at_name_default.value) = '') AND (IF(at_description.value_id > 0, at_description.value, at_description_default.value) = '') AND ( (IF(at_name.value_id > 0, at_name.value, at_name_default.value) LIKE '%blah%') AND (IF(at_name.value_id > 0, at_name.value, at_name_default.value) LIKE '%yes%')) OR ((IF(at_description.value_id > 0, at_description.value, at_description_default.value) LIKE '%blah%') AND (IF(at_description.value_id > 0, at_description.value, at_description_default.value) LIKE '%yes%'))

Den where() im getSelect() könnte gekürzt werden:

(`name` like '%blah%' and `name` like '%yes%') or (`description` like '%blah%' and `description` like '%yes%');

Jede andere Magento Menschen gibt, fühlen Sie bitte sich frei, mich zu korrigieren, wenn ich zu weit off-base mit, oder wenn Sie einen Weg kennen um zu erreichen das gleiche Ziel ohne den Einsatz dieser Methode.

hth!