1: <?php
2: /**
3: * Magento
4: *
5: * NOTICE OF LICENSE
6: *
7: * This source file is subject to the Open Software License (OSL 3.0)
8: * that is bundled with this package in the file LICENSE.txt.
9: * It is also available through the world-wide-web at this URL:
10: * http://opensource.org/licenses/osl-3.0.php
11: * If you did not receive a copy of the license and are unable to
12: * obtain it through the world-wide-web, please send an email
13: * to license@magentocommerce.com so we can send you a copy immediately.
14: *
15: * DISCLAIMER
16: *
17: * Do not edit or add to this file if you wish to upgrade Magento to newer
18: * versions in the future. If you wish to customize Magento for your
19: * needs please refer to http://www.magentocommerce.com for more information.
20: *
21: * @category Mage
22: * @package Mage_Core
23: * @copyright Copyright (c) 2012 Magento Inc. (http://www.magentocommerce.com)
24: * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
25: */
26:
27:
28: /**
29: * Url rewrite resource collection model class
30: *
31: * @category Mage
32: * @package Mage_Core
33: * @author Magento Core Team <core@magentocommerce.com>
34: */
35: class Mage_Core_Model_Resource_Url_Rewrite_Collection extends Mage_Core_Model_Resource_Db_Collection_Abstract
36: {
37: /**
38: * Define resource model
39: *
40: */
41: protected function _construct()
42: {
43: $this->_init('core/url_rewrite');
44: }
45:
46: /**
47: * Add filter for tags (combined by OR)
48: *
49: * @param string|array $tags
50: * @return Mage_Core_Model_Resource_Url_Rewrite_Collection
51: */
52: public function addTagsFilter($tags)
53: {
54: $tags = is_array($tags) ? $tags : explode(',', $tags);
55:
56: if (!$this->getFlag('tag_table_joined')) {
57: $this->join(
58: array('curt' => $this->getTable('core/url_rewrite_tag')),
59: 'main_table.url_rewrite_id = curt.url_rewrite_id',
60: array());
61: $this->setFlag('tag_table_joined', true);
62: }
63:
64: $this->addFieldToFilter('curt.tag', array('in' => $tags));
65: return $this;
66: }
67:
68: /**
69: * Filter collections by stores
70: *
71: * @param mixed $store
72: * @param bool $withAdmin
73: * @return Mage_Core_Model_Resource_Url_Rewrite_Collection
74: */
75: public function addStoreFilter($store, $withAdmin = true)
76: {
77: if (!is_array($store)) {
78: $store = array(Mage::app()->getStore($store)->getId());
79: }
80: if ($withAdmin) {
81: $store[] = 0;
82: }
83:
84: $this->addFieldToFilter('store_id', array('in' => $store));
85:
86: return $this;
87: }
88:
89: /**
90: * Add filter by catalog product Id
91: *
92: * @param int $productId
93: * @return Mage_Core_Model_Resource_Url_Rewrite_Collection
94: */
95: public function filterAllByProductId($productId)
96: {
97: $this->getSelect()
98: ->where('id_path = ?', "product/{$productId}")
99: ->orWhere('id_path LIKE ?', "product/{$productId}/%");
100:
101: return $this;
102: }
103:
104: /**
105: * Add filter by all catalog category
106: *
107: * @return Mage_Core_Model_Resource_Url_Rewrite_Collection
108: */
109: public function filterAllByCategory()
110: {
111: $this->getSelect()
112: ->where('id_path LIKE ?', "category/%");
113: return $this;
114: }
115: }
116: