/** * Init collection select * * @return Mage_Core_Model_Resource_Db_Collection_Abstract */ protected function _initSelect() { parent::_initSelect(); // Join order comment $this->getSelect()->joinLeft(array('ordercomment_table' => $this->getTable('sales/order_status_history')), 'main_table.entity_id = ordercomment_table.parent_id AND ordercomment_table.comment IS NOT NULL', array('ordercomment' => 'ordercomment_table.comment'))->group('main_table.entity_id'); return $this; }
public function __construct($resource = null) { parent::__construct(); if (Mage::helper('tweaks')->isOrderViewProductsColumnBackendEnable()) { $this->setFieldProductNames(); $this->setShellRequest(); } }
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; }
public function getSelectCountSql() { if ($this->_isGroupSql) { $this->_renderFilters(); $countSelect = clone $this->getSelect(); $countSelect->reset(Zend_Db_Select::ORDER); $countSelect->reset(Zend_Db_Select::LIMIT_COUNT); $countSelect->reset(Zend_Db_Select::LIMIT_OFFSET); $countSelect->reset(Zend_Db_Select::COLUMNS); if (count($this->getSelect()->getPart(Zend_Db_Select::GROUP)) > 0) { $countSelect->reset(Zend_Db_Select::GROUP); $countSelect->distinct(true); $group = $this->getSelect()->getPart(Zend_Db_Select::GROUP); $countSelect->columns("COUNT(DISTINCT " . implode(", ", $group) . ")"); } else { $countSelect->columns('COUNT(*)'); } return $countSelect; } return parent::getSelectCountSql(); }
/** * Init collection count select * * @return Varien_Db_Select */ public function getSelectCountSql() { return parent::getSelectCountSql()->reset(Zend_Db_Select::GROUP); }
protected function _construct() { parent::_construct(); $this->setMainTable('enterprise_salesarchive/order_grid'); }