Playing with customer collection in Magento

In this article I’ll give you some example how to get different collection of customers.
For example, how to get latest 5 customers, unconfirmed customers, latest 5 customers who purchased something etc.

I’ll create few objects that are instances of Mage_Customer_Model_Resource_Customer_Collection class and few objects that are instances of Inchoo_CustomerCollection_Model_Resource_Customer_Totals_Collection class.
Class Inchoo_CustomerCollection_Model_Resource_Customer_Totals_Collection extends Mage_Reports_Model_Resource_Customer_Totals_Collection class.

Let’s take a look.

How to get Not confirmed customers?

$collection = Mage::getResourceModel('customer/customer_collection')
    ->addNameToSelect()
    ->joinAttribute('billing_postcode', 'customer_address/postcode', 'default_billing', null, 'left')
    ->joinAttribute('billing_city', 'customer_address/city', 'default_billing', null, 'left')
    ->joinAttribute('billing_telephone', 'customer_address/telephone', 'default_billing', null, 'left')
    ->joinAttribute('billing_region', 'customer_address/region', 'default_billing', null, 'left')
    ->joinAttribute('billing_country_id', 'customer_address/country_id', 'default_billing', null, 'left')
    ->joinField('notconfirmed',
        'customer_entity_varchar',
        'attribute_id',
        'entity_id=entity_id',
        "{{table}}.attribute_id='831'");
 
$this->setCollection($collection);
return parent::_prepareCollection();

The last parameter of joinField is string which contain table, field and value “831”. Value “831” is ‘attribute_id’ from ‘eav_attribute’ table where ‘attribute_code’ is equal “confirmation”.

How to get customers with Gmail account?

$collection = Mage::getResourceModel('customer/customer_collection')
    ->addNameToSelect()
    ->joinAttribute('billing_postcode', 'customer_address/postcode', 'default_billing', null, 'left')
    ->joinAttribute('billing_city', 'customer_address/city', 'default_billing', null, 'left')
    ->joinAttribute('billing_telephone', 'customer_address/telephone', 'default_billing', null, 'left')
    ->joinAttribute('billing_region', 'customer_address/region', 'default_billing', null, 'left')
    ->joinAttribute('billing_country_id', 'customer_address/country_id', 'default_billing', null, 'left')
    ->addFieldToFilter('email',array('like'=>'%@gmail.com'));
 
$this->setCollection($collection);
return parent::_prepareCollection();

How to get customer with the largest purchased amount?

$collection is instance of Inchoo_CustomerCollection_Model_Resource_Customer_Totals_Collection. Methods: addTotalOrderAmount(), addBillingData() and addCustomerData() are declared in Inchoo_CustomerCollection_Model_Resource_Customer_Totals_Collection class.

public function __construct()
{
    parent::__construct();
    $this->setId('customerGrid');
    $this->setPagerVisibility(false);
    $this->setFilterVisibility(false);
    $this->setDefaultLimit(1);
}
 
protected function _prepareCollection()
{
    $collection = Mage::getResourceModel('customercollection/customer_totals_collection');
    $collection->joinCustomerName()
         ->groupByCustomer()
         ->addTotalOrderAmount()
         ->addBillingData()
         ->addCustomerData()
         ->orderByTotalAmount();
 
    $this->setCollection($collection);
    return parent::_prepareCollection();
}

These collections of customers, You can see under Customer->Customer Collection.

As you can see on the picture bellow, I decided to disable filtering options, sorting by column and Massaction Block.

CustomerCollection extension is tested on Magento CE 1.6.1.0. You can download extension here.

Cheers.