public function _afterLoad() { foreach ($this as $object) { $order_id = $object->getEntityId(); $sales_flat_order_item = $this->getTable('sales/order_item'); $adapter = $this->getResource()->getReadConnection(); $select = $adapter->select()->from($sales_flat_order_item, array('sku'))->where("order_id = {$order_id} and parent_item_id IS NULL"); $rows = $adapter->fetchAll($select); $skus = ''; foreach ($rows as $row) { $skus .= $row['sku'] . ','; } $skus = substr($skus, 0, -1); $object->setSkus($skus); } return parent::_afterLoad(); }
protected function _afterLoad() { parent::_afterLoad(); if (count($this->_items) > 0) { $ids = array(); foreach ($this->_items as $item) { $ids[] = $item->getId(); } $ids = implode(',', $ids); $select = $this->getConnection()->select()->from($this->getTable('sales/order_status_history'))->where("parent_id IN ({$ids})")->order('created_at ASC'); $items = $this->getConnection()->fetchAll($select); foreach ($items as $item) { $parent = $this->_items[$item['parent_id']]; $parent->setOrdercomment($item['comment']); } } return $this; }