/** * * @return Pap_Db_Commission */ protected function getCommissionForTransaction() { $transactions = new Gpf_SqlBuilder_SelectBuilder(); $transactions->select->add('c.'.Pap_Db_Table_Commissions::TYPE); $transactions->select->add('c.'.Pap_Db_Table_Commissions::VALUE); $transactions->where->add('t.'.Pap_Db_Table_Transactions::TRANSACTION_ID, '=', $this->transaction->getId()); $transactions->where->add('c.'.Pap_Db_Table_Commissions::SUBTYPE,'=',self::getCommissionTypeFromTransaction($this->transaction->getType())); $this->initTransactionSql($transactions); $commission = new Pap_Db_Commission(); $commission->fillFromRecord($transactions->getOneRow()); return $commission; }