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_Catalog
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: * Catalog Product Relations Resource model
30: *
31: * @category Mage
32: * @package Mage_Catalog
33: * @author Magento Core Team <core@magentocommerce.com>
34: */
35: class Mage_Catalog_Model_Resource_Product_Relation extends Mage_Core_Model_Resource_Db_Abstract
36: {
37: /**
38: * Initialize resource model and define main table
39: *
40: */
41: protected function _construct()
42: {
43: $this->_init('catalog/product_relation', 'parent_id');
44: }
45:
46: /**
47: * Save (rebuild) product relations
48: *
49: * @param int $parentId
50: * @param array $childIds
51: * @return Mage_Catalog_Model_Resource_Product_Relation
52: */
53: public function processRelations($parentId, $childIds)
54: {
55: $select = $this->_getReadAdapter()->select()
56: ->from($this->getMainTable(), array('child_id'))
57: ->where('parent_id = ?', $parentId);
58: $old = $this->_getReadAdapter()->fetchCol($select);
59: $new = $childIds;
60:
61: $insert = array_diff($new, $old);
62: $delete = array_diff($old, $new);
63:
64: if (!empty($insert)) {
65: $insertData = array();
66: foreach ($insert as $childId) {
67: $insertData[] = array(
68: 'parent_id' => $parentId,
69: 'child_id' => $childId
70: );
71: }
72: $this->_getWriteAdapter()->insertMultiple($this->getMainTable(), $insertData);
73: }
74: if (!empty($delete)) {
75: $where = join(' AND ', array(
76: $this->_getWriteAdapter()->quoteInto('parent_id = ?', $parentId),
77: $this->_getWriteAdapter()->quoteInto('child_id IN(?)', $delete)
78: ));
79: $this->_getWriteAdapter()->delete($this->getMainTable(), $where);
80: }
81:
82: return $this;
83: }
84: }
85: