Exemplo n.º 1
0
 /**
  * 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;
 }
Exemplo n.º 2
0
 /**
  * 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;
 }