/** * 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; }