private function generateExportFile(Pap_Db_PayoutOption $payoutOption, $affiliateNote = '') {
$header = new Gpf_Templates_Template($payoutOption->getExportHeaderTemplate(), '', Gpf_Templates_Template::FETCH_TEXT);
$content = $header->getHTML();
$currency = Pap_Common_Utils_CurrencyUtils::getDefaultCurrency();
$affiliates = 0;
$commissions = 0;
$selectBuilder = $this->getAffiliatesToPaySelect($payoutOption->getID());
foreach ($selectBuilder->getAllRowsIterator() as $row) {
$user = new Pap_Common_User();
$user->fillFromRecord($row);
$payout = new Pap_Common_Payout($user, $currency, $row->get('amountRaw'),$this->generateInvoiceNumber());
$payout->setAffiliateNote($affiliateNote);
$affiliates++;
$commissions += $row->get('amountRaw');
$content .= $payout->getExportRow();
}
$footer = new Gpf_Templates_Template($payoutOption->getExportFooterTemplate(), '', Gpf_Templates_Template::FETCH_TEXT);
$footer->assign('affiliates', $affiliates);
$footer->assign('commissions', round($commissions, Pap_Common_Utils_CurrencyUtils::getDefaultCurrency()->getPrecision()));
$content .= $footer->getHTML();
$content = str_replace('\t', "\t", $content);
$content = str_replace('\n', "\n", $content);
return $content;
}
