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