protected function _prepareCollection() { $elementId = $this->getRequest()->getParam('order_id'); $collection = Mage::getModel('amaudit/log')->getCollection(); $collection->getSelect()->joinLeft(array('r' => Mage::getSingleton('core/resource')->getTableName('amaudit/log_details')), 'main_table.entity_id = r.log_id', array('is_logged' => 'MAX(r.log_id)'))->where("info = ?", 'Order ID ' . $elementId)->where("model = 'Mage_Sales_Model_Order'")->group('r.log_id'); $this->setCollection($collection); return parent::_prepareCollection(); }
protected function _prepareCollection() { $elementId = $this->getRequest()->getParam('id'); $collection = Mage::getModel('amaudit/log')->getCollection(); $classes = array('Mage_Customer_Model_Customer', 'Mage_Customer_Model_Address', 'Amasty_Customerattr_Model_Rewrite_Customer'); $collection->getSelect()->joinLeft(array('r' => Mage::getSingleton('core/resource')->getTableName('amaudit/log_details')), 'main_table.entity_id = r.log_id', array('is_logged' => 'MAX(r.log_id)'))->where("element_id = ?", $elementId)->where("model in (?)", $classes)->group('r.log_id'); $this->setCollection($collection); return parent::_prepareCollection(); }