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