/**
* Init virtual grid records for entity
*
* @return Mage_Sales_Model_Resource_Order_Invoice
*/
protected function _initVirtualGridColumns()
{
parent::_initVirtualGridColumns();
$adapter = $this->_getReadAdapter();
$checkedFirstname = $adapter->getIfNullSql('{{table}}.firstname', $adapter->quote(''));
$checkedLastname = $adapter->getIfNullSql('{{table}}.lastname', $adapter->quote(''));
$this->addVirtualGridColumn('billing_name', 'sales_flat_order_address', array('billing_address_id' => 'entity_id'), $adapter->getConcatSql(array($checkedFirstname, $adapter->quote(' '), $checkedLastname)))->addVirtualGridColumn('order_increment_id', 'sales_flat_order', array('order_id' => 'entity_id'), 'increment_id')->addVirtualGridColumn('order_created_at', 'sales_flat_order', array('order_id' => 'entity_id'), 'created_at');
return $this;
}
/**
* Init virtual grid records for entity
*
* @return Mage_Sales_Model_Resource_Order
*/
protected function _initVirtualGridColumns()
{
parent::_initVirtualGridColumns();
$adapter = $this->getReadConnection();
$ifnullFirst = $adapter->getIfNullSql('{{table}}.firstname', $adapter->quote(''));
$ifnullLast = $adapter->getIfNullSql('{{table}}.lastname', $adapter->quote(''));
$concatAddress = $adapter->getConcatSql(array($ifnullFirst, $adapter->quote(' '), $ifnullLast));
$this->addVirtualGridColumn('billing_name', 'sales_flat_order_address', array('billing_address_id' => 'entity_id'), $concatAddress)->addVirtualGridColumn('shipping_name', 'sales_flat_order_address', array('shipping_address_id' => 'entity_id'), $concatAddress);
return $this;
}
