Magento – How to get collection result “column headers” or “column names” in Magento 1.9x

collection;databasemagento-1magento-1.9

How can I get collection result "column headers" or "column names" from query?

Suppose I have $data = Mage::getModel('catalog/product')->getCollection(); and I have some joins with other tables

I can get the data by running foreach on $data giving me the actual output data.

question: but how can I get the "header name" (or "column name") as I would see it when I run the same query in MySQL

Best Answer

For a simple query like SELECT * FROM 'sales_flat_order'

$res    = Mage::getSingleton('core/resource');
$read   = $res->getConnection('core_read');
$table  = $res->getTableName('sales/order');
$header = array_keys($read->describeTable($table));

To get all product attributes from Mage::getModel('catalog/product')->getCollection() just use keys from $item->getData().

Related Solutions

Magento – Magento aggregate collections

Doesn't seem that hard. Basically you would have to instantiate the customer collection, join it with the sales collections and apply some conditions. The sales table has most of the information you'll need except for the dob.

$collection = Mage::getResourceModel('customer/customer_collection')
        ->joinAttribute('dob','customer/dob', 'entity_id')
        ->join(array('orders'=>'sales_flat_order',
                     'orders.customer_id=main_table.entity_id', 
                     array('total_item_count','base_grand_total', 'customer_firstname', 'customer_lastname')))
        ->getSelect()
        ->reset(Zend_DB_Select::COLUMNS)
        ->columns(array(
                        'SUM(orders.total_item_count)'=>'qty',
                        'SUM(orders.base_grand_total)'=>'grand_total',
                        'orders.customer_firstname',
                        'orders.customer_lastname',
                        'dob'))
        ->group('main_table.entity_id')
        ->where('dob = SOMETHING');

I haven't tested it but this is how I would write it. Be sure to enable SQL logging in your Magento and adjust the collection according to the SQL result.

To format the dob as you wanted, I suggest using a renderer.

If you have any questions, feel free to ask.

How to Sort Data Collection in Ascending Order by ‘sort_order’ Column

Try with this:

$collection->setOrder('sort_order', 'ASC');

Best Answer

Related Solutions

Magento – Magento aggregate collections

How to Sort Data Collection in Ascending Order by ‘sort_order’ Column

Related Topic