Posted By

necode on 07/28/11


Tagged

collections magento Filters-Condition Manipulation-Methods


Versions (?)

Magento Using Collections, Filters and Manipulation Methods


 / Published in: PHP
 

URL: http://www.magentocommerce.com/wiki/5_-_modules_and_development/catalog/using_collections_in_magento

A collection is a Model type containing other Models, it is basically used in Magento to handle product lists (ie. from a category or a bundle option), but not only.

TO DO: Explain how Magento Implements a collection - Use this to explain how Magento implements a collection by looking at code in a model, so that people can learn to write their own collections

This is a simple example of loading some product collection from a category and ordering them on their product name using Magento’s API.

  1. $collection->addAttributeToFilter('field_name', array(
  2. 'in' => array(1, 2, 3),
  3. ));
  4.  
  5. $collection->addAttributeToFilter('date_field', array(
  6. 'from' => '2000-09-10',
  7. ));
  8.  
  9. $collection->addAttributeToFilter('date_field', array(
  10. 'from' => '10 September 2000',
  11. 'from' => '11 September 2000',
  12. 'date' => true, // specifies conversion of comparison values
  13. ));
  14.  
  15. $collection->addAttributeToFilter('field_name', 1); // tests for equality
  16.  
  17. // Add OR condition:
  18. $collection->addAttributeToFilter(array(
  19. 'attribute' => 'field_name',
  20. 'in' => array(1, 2, 3),
  21. ),
  22. 'attribute' => 'date_field',
  23. 'from' => '2000-09-10',
  24. ),
  25. ));

Report this snippet  

You need to login to post a comment.