/**
  * Load the tansaction object by specified txn_id
  * @param Mage_Sales_Model_Order_Payment_Transaction $transaction
  * @param int $orderId
  * @param int $paymentId
  * @param string $txnId
  */
 public function loadObjectByTxnId(Mage_Sales_Model_Order_Payment_Transaction $transaction, $orderId, $paymentId, $txnId)
 {
     $select = $this->_getLoadByUniqueKeySelect($orderId, $paymentId, $txnId);
     $data = $this->_getWriteAdapter()->fetchRow($select);
     $transaction->setData($data);
     $this->unserializeFields($transaction);
     $this->_afterLoad($transaction);
 }

 public function testLoadByTxnId()
 {
     $order = new Mage_Sales_Model_Order();
     $order->loadByIncrementId('100000001');
     $model = new Mage_Sales_Model_Order_Payment_Transaction();
     $model->setOrderPaymentObject($order->getPayment())->loadByTxnId('invalid_transaction_id');
     $this->assertNull($model->getId());
     $model->loadByTxnId('trx1');
     $this->assertNotNull($model->getId());
 }

 /**
  * Parent transaction getter
  * May attempt to load it.
  *
  * @param bool $shouldLoad
  * @return Mage_Sales_Model_Order_Payment_Transaction|false
  */
 public function getParentTransaction($shouldLoad = true)
 {
     if (null === $this->_parentTransaction) {
         $this->_verifyThisTransactionExists();
         $this->_parentTransaction = false;
         $parentId = $this->getParentId();
         if ($parentId) {
             $class = get_class($this);
             $this->_parentTransaction = new $class();
             if ($shouldLoad) {
                 $this->_parentTransaction->setOrderPaymentObject($this->_paymentObject)->load($parentId);
                 if (!$this->_parentTransaction->getId()) {
                     $this->_parentTransaction = false;
                 } else {
                     $this->_parentTransaction->hasChildTransaction(true);
                 }
             }
         }
     }
     return $this->_parentTransaction;
 }

 /**
  * Re-create order with new transaction returned by Eway
  * @param $data
  */
 private function __createNewTransaction(Mage_Sales_Model_Order $order, $transId)
 {
     // Load transaction
     $currentTrans = Mage::getModel('sales/order_payment_transaction')->getCollection()->addFieldToFilter('order_id', array('eq' => $order->getEntityId()));
     foreach ($currentTrans as $t) {
     }
     if ($t == null) {
         $t = new Mage_Sales_Model_Order_Payment_Transaction();
     }
     $trans = new Mage_Sales_Model_Order_Payment_Transaction();
     // Load payment object
     $payment = Mage::getModel('sales/order_payment')->load($t->getPaymentId());
     $trans->setOrderPaymentObject($payment);
     $trans->setOrder($order);
     $trans->setParentId($t->getTransactionId());
     $trans->setOrderId($order->getEntityId());
     $trans->setPaymentId($t->getPaymentId());
     // Get new TxnId
     $break = true;
     for ($i = 0; $i < 100; $i++) {
         $transId += 1;
         $newTrans = Mage::getModel('sales/order_payment_transaction')->getCollection()->addFieldToFilter('txn_id', array('eq' => $transId));
         if (count($newTrans) == 0) {
             $break = false;
             break;
         }
     }
     if ($break) {
         return false;
     }
     $trans->setTxnId($transId);
     $trans->setParentTxnId($t->getTxnId());
     $trans->setTxnType($t->getTxnType());
     $trans->setIsClosed($t->getIsClosed());
     $trans->setCreatedAt(date('Y-m-d H:i:s'));
     $trans->save();
 }

 /**
  * Check transaction for expiration in PST
  *
  * @param Mage_Sales_Model_Order_Payment_Transaction $transaction
  * @param int $period
  * @return boolean
  */
 protected function _isTransactionExpired(Mage_Sales_Model_Order_Payment_Transaction $transaction, $period)
 {
     $period = intval($period);
     if (0 == $period) {
         return true;
     }
     $transactionClosingDate = new DateTime($transaction->getCreatedAt(), new DateTimeZone('GMT'));
     $transactionClosingDate->setTimezone(new DateTimeZone('US/Pacific'));
     /**
      * 11:49:00 PayPal transactions closing time
      */
     $transactionClosingDate->setTime(11, 49, 00);
     $transactionClosingDate->modify('+' . $period . ' days');
     $currentTime = new DateTime(null, new DateTimeZone('US/Pacific'));
     if ($currentTime > $transactionClosingDate) {
         return true;
     }
     return false;
 }

 /**
  * Update transaction ids for further processing
  * If no transactions were set before invoking, may generate an "offline" transaction id
  *
  * @param string $type
  * @param Mage_Sales_Model_Order_Payment_Transaction $transactionBasedOn
  */
 protected function _generateTransactionId($type, $transactionBasedOn = false)
 {
     if (!$this->getParentTransactionId() && !$this->getTransactionId() && $transactionBasedOn) {
         $this->setParentTransactionId($transactionBasedOn->getTxnId());
     }
     // generate transaction id for an offline action or payment method that didn't set it
     if (($parentTxnId = $this->getParentTransactionId()) && !$this->getTransactionId()) {
         $this->setTransactionId("{$parentTxnId}-{$type}");
     }
 }

 /**
  * Check whether order transaction can be loaded
  *
  * @param Mage_Sales_Model_Order_Payment_Transaction $model
  */
 public function salesOrderTransactionLoadAfter($model)
 {
     if (!$this->_role->hasWebsiteAccess($model->getOrderWebsiteId())) {
         $this->_throwLoad();
     }
 }

 /**
  * Re-create order with new transaction returned by Eway
  * @param $data
  */
 private function __createNewTransaction(Mage_Sales_Model_Order $order, $transId)
 {
     // Load transaction
     $currentTrans = Mage::getModel('sales/order_payment_transaction')->getCollection()->addFieldToFilter('order_id', array('eq' => $order->getEntityId()));
     foreach ($currentTrans as $t) {
     }
     if ($t == null) {
         $t = new Mage_Sales_Model_Order_Payment_Transaction();
     }
     $trans = new Mage_Sales_Model_Order_Payment_Transaction();
     // Load payment object
     $payment = Mage::getModel('sales/order_payment')->load($t->getPaymentId());
     $trans->setOrderPaymentObject($payment);
     $trans->setOrder($order);
     $trans->setParentId($t->getTransactionId());
     $trans->setOrderId($order->getEntityId());
     $trans->setPaymentId($t->getPaymentId());
     $trans->setTxnId($transId);
     $trans->setParentTxnId($t->getTxnId());
     $trans->setTxnType($t->getTxnType());
     $trans->setIsClosed($t->getIsClosed());
     $trans->setCreatedAt(date('Y-m-d H:i:s'));
     $trans->save();
 }

 /**
  * Update transaction ids for further processing
  * If no transactions were set before invoking, may generate an "offline" transaction id
  *
  * @param string $type
  * @param Mage_Sales_Model_Order_Payment_Transaction $transactionBasedOn
  */
 protected function _generateTransactionId($payment, $type, $transactionBasedOn = false)
 {
     if (!$payment->getParentTransactionId() && $transactionBasedOn) {
         $payment->setParentTransactionId($transactionBasedOn->getTxnId());
     }
     // generate transaction id for an offline action or payment method that didn't set it
     if ($parentTxnId = $payment->getParentTransactionId()) {
         $transactionId = "{$parentTxnId}-{$type}";
         $collection = Mage::getModel('sales/order_payment_transaction')->getCollection()->setOrderFilter($payment->getOrder())->addPaymentIdFilter($payment->getId())->addTxnTypeFilter($type);
         if ($collection->count() > 0) {
             $transactionId .= '-' . ($collection->count() + 1);
         }
         $payment->setTransactionId($transactionId);
     }
 }

 /**
  * Unserialize additional information if required
  * @param Mage_Sales_Model_Order_Payment_Transaction $transaction
  */
 public function unserializeFields(Mage_Sales_Model_Order_Payment_Transaction $transaction)
 {
     $additionalInformation = $transaction->getData('additional_information');
     if (empty($additionalInformation)) {
         $transaction->setData('additional_information', array());
     } elseif (!is_array($additionalInformation)) {
         $transaction->setData('additional_information', unserialize($additionalInformation));
     }
 }

 /**
  * Determine if a transaction has been voided, using the "txn_type" field
  * instead of "type" like the native isVoided method does
  *
  * @param Mage_Sales_Model_Order_Payment_Transaction $trans
  * @return bool
  */
 public function transactionIsVoided($trans)
 {
     $children = $trans->getChildTransactions();
     $result = false;
     if (Mage_Sales_Model_Order_Payment_Transaction::TYPE_AUTH === $trans->getTxnType()) {
         foreach ($children as $child) {
             if (Mage_Sales_Model_Order_Payment_Transaction::TYPE_VOID === $child->getTxnType()) {
                 $result = true;
             }
         }
     }
     return $result;
 }

 protected function _toHtml()
 {
     $this->setTxnIdHtml($this->escapeHtml($this->_txn->getTxnId()));
     $this->setParentTxnIdUrlHtml($this->escapeHtml($this->getUrl('*/sales_transactions/view', array('txn_id' => $this->_txn->getParentId()))));
     $this->setParentTxnIdHtml($this->escapeHtml($this->_txn->getParentTxnId()));
     $this->setOrderIncrementIdHtml($this->escapeHtml($this->_txn->getOrder()->getIncrementId()));
     $this->setTxnTypeHtml($this->escapeHtml($this->_txn->getTxnType()));
     $this->setOrderIdUrlHtml($this->escapeHtml($this->getUrl('*/sales_order/view', array('order_id' => $this->_txn->getOrderId()))));
     $this->setIsClosedHtml($this->_txn->getIsClosed() ? Mage::helper('sales')->__('Yes') : Mage::helper('sales')->__('No'));
     $createdAt = strtotime($this->_txn->getCreatedAt()) ? $this->formatDate($this->_txn->getCreatedAt(), Mage_Core_Model_Locale::FORMAT_TYPE_MEDIUM, true) : $this->__('N/A');
     $this->setCreatedAtHtml($this->escapeHtml($createdAt));
     return parent::_toHtml();
 }

 protected function _construct()
 {
     parent::_construct();
     $this->_init('payperrentals/sales_payment_transaction');
     return $this;
 }