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_Sales
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: * Recurring payment profiles resource model
30: *
31: * @category Mage
32: * @package Mage_Sales
33: * @author Magento Core Team <core@magentocommerce.com>
34: */
35: class Mage_Sales_Model_Resource_Recurring_Profile extends Mage_Sales_Model_Resource_Abstract
36: {
37: /**
38: * Initialize main table and column
39: *
40: */
41: protected function _construct()
42: {
43: $this->_init('sales/recurring_profile', 'profile_id');
44:
45: $this->_serializableFields = array(
46: 'profile_vendor_info' => array(null, array()),
47: 'additional_info' => array(null, array()),
48:
49: 'order_info' => array(null, array()),
50: 'order_item_info' => array(null, array()),
51: 'billing_address_info' => array(null, array()),
52: 'shipping_address_info' => array(null, array())
53: );
54: }
55:
56: /**
57: * Return recurring profile child Orders Ids
58: *
59: *
60: * @param Varien_Object $object
61: * @return array
62: */
63: public function getChildOrderIds($object)
64: {
65: $adapter = $this->_getReadAdapter();
66: $bind = array(':profile_id' => $object->getId());
67: $select = $adapter->select()
68: ->from(
69: array('main_table' => $this->getTable('sales/recurring_profile_order')),
70: array('order_id'))
71: ->where('profile_id=:profile_id');
72:
73: return $adapter->fetchCol($select, $bind);
74: }
75:
76: /**
77: * Add order relation to recurring profile
78: *
79: * @param int $recurringProfileId
80: * @param int $orderId
81: * @return Mage_Sales_Model_Resource_Recurring_Profile
82: */
83: public function addOrderRelation($recurringProfileId, $orderId)
84: {
85: $this->_getWriteAdapter()->insert(
86: $this->getTable('sales/recurring_profile_order'), array(
87: 'profile_id' => $recurringProfileId,
88: 'order_id' => $orderId
89: )
90: );
91: return $this;
92: }
93: }
94: