File code/core/Mage/Sales/Model/Resource/Billing/Agreement/Collection.php

 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:  * Billing agreements resource collection
30:  *
31:  * @category    Mage
32:  * @package     Mage_Sales
33:  * @author      Magento Core Team <core@magentocommerce.com>
34:  */
35: class Mage_Sales_Model_Resource_Billing_Agreement_Collection extends Mage_Core_Model_Resource_Db_Collection_Abstract
36: {
37:     /**
38:      * Mapping for fields
39:      *
40:      * @var array
41:      */
42:     protected $_map = array('fields' => array(
43:         'customer_email'       => 'ce.email',
44:         'customer_firstname'   => 'firstname.value',
45:         'customer_lastname'    => 'lastname.value',
46:         'agreement_created_at' => 'main_table.created_at',
47:         'agreement_updated_at' => 'main_table.updated_at',
48:     ));
49: 
50:     /**
51:      * Collection initialization
52:      *
53:      */
54:     protected function _construct()
55:     {
56:         $this->_init('sales/billing_agreement');
57:     }
58: 
59:     /**
60:      * Add cutomer details(email, firstname, lastname) to select
61:      *
62:      * @return Mage_Sales_Model_Resource_Billing_Agreement_Collection
63:      */
64:     public function addCustomerDetails()
65:     {
66:         $select = $this->getSelect()->joinInner(
67:             array('ce' => $this->getTable('customer/entity')),
68:             'ce.entity_id = main_table.customer_id',
69:             array('customer_email' => 'email')
70:         );
71: 
72:         $customer = Mage::getResourceSingleton('customer/customer');
73:         $adapter  = $this->getConnection();
74:         $attr     = $customer->getAttribute('firstname');
75:         $joinExpr = 'firstname.entity_id = main_table.customer_id AND '
76:             . $adapter->quoteInto('firstname.entity_type_id = ?', $customer->getTypeId()) . ' AND '
77:             . $adapter->quoteInto('firstname.attribute_id = ?', $attr->getAttributeId());
78: 
79:         $select->joinLeft(
80:             array('firstname' => $attr->getBackend()->getTable()),
81:             $joinExpr,
82:             array('customer_firstname' => 'value')
83:         );
84: 
85:         $attr = $customer->getAttribute('lastname');
86:         $joinExpr = 'lastname.entity_id = main_table.customer_id AND '
87:             . $adapter->quoteInto('lastname.entity_type_id = ?', $customer->getTypeId()) . ' AND '
88:             . $adapter->quoteInto('lastname.attribute_id = ?', $attr->getAttributeId());
89: 
90:         $select->joinLeft(
91:             array('lastname' => $attr->getBackend()->getTable()),
92:             $joinExpr,
93:             array('customer_lastname' => 'value')
94:         );
95:         return $this;
96:     }
97: }
98:
Packages

Classes

Interfaces
