/** * Prepare filters * * @return Mage_Sales_Model_Resource_Order_Payment_Transaction_Collection */ protected function _beforeLoad() { parent::_beforeLoad(); if ($this->isLoaded()) { return $this; } // filters if ($this->_paymentId) { $this->getSelect()->where('main_table.payment_id = ?', $this->_paymentId); } if ($this->_parentId) { $this->getSelect()->where('main_table.parent_id = ?', $this->_parentId); } if ($this->_txnTypes) { $this->getSelect()->where('main_table.txn_type IN(?)', $this->_txnTypes); } if ($this->_orderId) { $this->getSelect()->where('main_table.order_id = ?', $this->_orderId); } if ($this->_addPaymentInformation) { $this->getSelect()->joinInner(array('sop' => $this->getTable('sales/order_payment')), 'main_table.payment_id = sop.entity_id', $this->_addPaymentInformation); } if ($this->_storeIds) { $this->getSelect()->where('so.store_id IN(?)', $this->_storeIds); $this->addOrderInformation(array('store_id')); } if ($this->_addOrderInformation) { $this->getSelect()->joinInner(array('so' => $this->getTable('sales/order')), 'main_table.order_id = so.entity_id', $this->_addOrderInformation); } return $this; }