Esempio n. 1
0
 /**
  * Init virtual grid records for entity
  *
  * @return $this
  */
 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;
 }