addAttributeToFilter Conditionals In Magento
来源:互联网 发布:axure8.0 mac 中文版 编辑:程序博客网 时间:2024/05/16 00:28
今天偶然看见的一篇文章觉得还不错,有空翻译翻译:
*
addAttributeToFilter Conditionals In Magento
Posted on the 16th of April, 2010 at 10:10pm
addAttributeToFilter is a function that can be called on a product collection in Magento. In short, it adds a condition to the WHERE part of the MySQL query used to extract a product collection from the database.
1 $_products = Mage::getModel('catalog/product')->getCollection()
2 ->addAttributeToSelect(array('name', 'product_url', 'small_image'))
3 ->addAttributeToFilter('sku', array('like' => 'UX%'))
4 ->load();
The above code would get a product collection, with each product having it’s name, url, price and small image loaded in it’s data array. The product collection would be filtered and contain only products that have an SKU starting with UX.
addAttributeToFilter Conditionals
Notice above, I used the LIKE operator? There are many more operators in SQL and addAttributeToFilter will accept them all. I include them below as well as a reference for you. Hopefully this will save you some time.
Equals: eq
1 $_products->addAttributeToFilter('status', array('eq' => 1));
Not Equals – neq
1 $_products->addAttributeToFilter('sku', array('neq' => 'test-product'));
Like – like
1 $_products->addAttributeToFilter('sku', array('like' => 'UX%'));
One thing to note about like is that you can include SQL wildcard characters such as the percent sign.
Not Like – nlike
1 $_products->addAttributeToFilter('sku', array('nlike' => 'err-prod%'));
In – in
1 $_products->addAttributeToFilter('id', array('in' => array(1,4,74,98)));
When using in, the value parameter accepts an array of values.
Not In – nin
1 $_products->addAttributeToFilter('id', array('nin' => array(1,4,74,98)));
NULL – null
1 $_products->addAttributeToFilter('description', 'null');
Not NULL – notnull
1 $_products->addAttributeToFilter('description', 'notnull');
Greater Than – gt
1 $_products->addAttributeToFilter('id', array('gt' => 5));
Less Than – lt
1 $_products->addAttributeToFilter('id', array('lt' => 5));
Greater Than or Equals To- gteq
1 $_products->addAttributeToFilter('id', array('gteq' => 5));
Less Than or Equals To – lteq
1 $_products->addAttributeToFilter('id', array('lteq' => 5));
addFieldToFilter()
As far as I’m aware, addAttributeToFilter only works with products in Magento. When I first found out this fact I was not only shocked, I was worried! I thought that without it, I would have to custom craft all of my SQL queries. After scouring the Magento core code one night, I found addFieldToFilter(). This functions works in the exact same way and takes the same paramters, however it works on ALL collections and not just on products!
Debugging The SQL Query
There are two ways to debug the query being executed when loading a collection in Magento.
1 // Method 1
2 Mage::getModel('catalog/product')->getCollection()->load(true);
3
4 // Method 2 (Quicker, Recommended)
5 $collection = Mage::getModel('catalog/product')->getCollection();
6 echo $collection->getSelect();
Both method 1 and method 2 will print out the query but both will do it in slightly different ways. Method 1 prints the query out as well as loading the products while method 2 will just convert the query object to a string (ie. will print out the SQL). The second method is definitely better as it will be executed much quicker but I include them both here for reference.
On a side note, I will soon be writing an article on the getSelect() function as it opens up a door in Magento Collections that gives them (and you) true power!
- addAttributeToFilter Conditionals In Magento
- addAttributeToFilter condition in Magento
- Magento 条件筛选 addAttributeToFilter
- Magento addFieldToFilter和addAttributeToFilter用法整理
- 4 conditionals in JSX&parent child relationships
- Bestseller products in Magento
- Using Collections in Magento
- Tax module in Magento
- getChildHtml in Magento(麦进斗)
- Control-Conditionals
- playbook conditionals
- Search by categories in Magento
- Custom shipping method in Magento
- Retrieving product information in Magento
- Powerful block system in Magento
- Magento Get Items In Order
- [PHP] Easy popup in Magento
- Translation in Magento shell script
- Joomla 开发1
- 寻找......
- 用Jaxb解析XML的应用
- 改中文版ubuntu的用户目录名为英文目录的方法
- c fuxi
- addAttributeToFilter Conditionals In Magento
- entity listener config
- JAVA IO框架
- 计算机语言发展历程
- UpLoadFy上传图片
- POJ1837Balance题解动态规划DP
- getallheader
- PHP备份/还原MySQL数据库
- APACHE、TOMCAT在64位LINUX下集群配置