/** * * @param $transaction * @return Gpf_Data_Record */ protected function getChildAffiliateInfo(Pap_Common_Transaction $transaction){ $userSelect = new Gpf_SqlBuilder_SelectBuilder(); $userSelect->select->add('t.'.Pap_Db_Table_Transactions::USER_ID); $userSelect->select->add('u.'.Pap_Db_Table_Users::DATEINSERTED); $userSelect->from->add(Pap_Db_Table_Transactions::getName(),'t'); $userSelect->from->addInnerJoin(Pap_Db_Table_Users::getName(),'u','t.userid=u.userid'); $userSelect->where->add('t.'.Pap_Db_Table_Transactions::TRANSACTION_ID,'=',$transaction->getParentTransactionId()); return $userSelect->getOneRow(); }