}
$arResult["CURRENT_PAGE_PARAM"] = $APPLICATION->GetCurPageParam("", array("filter_date_from", "filter_date_to"));
$arResult["CURRENT_PAGE"] = $APPLICATION->GetCurPage();
$arResult["CURRENT_DATE"] = date($DB->DateFormatToPHP(CSite::GetDateFormat("SHORT")), time());
$arResult["PAID_SUM_INCOME"] = $arAffiliate["PAID_SUM"] >= 0 ? SaleFormatCurrency($arAffiliate["PAID_SUM"], $affiliateCurrency) : "";
$arResult["PAID_SUM_OUTCOME"] = $arAffiliate["PAID_SUM"] < 0 ? SaleFormatCurrency(-$arAffiliate["PAID_SUM"], $affiliateCurrency) : "";
$arResult["FILTER"] = array("filter_date_from" => $filter_date_from, "filter_date_to" => $filter_date_to);
$arFilter = array("AFFILIATE_ID" => $arAffiliate["ID"]);
if (StrLen($filter_date_from) > 0) {
$arFilter[">=TRANSACT_DATE"] = Trim($filter_date_from);
}
if (StrLen($filter_date_to) > 0) {
$arFilter["<=TRANSACT_DATE"] = Trim($filter_date_to);
}
$arResult["TRANSACT"] = array();
$dbTransactList = CSaleAffiliateTransact::GetList(array("TRANSACT_DATE" => "ASC"), $arFilter, false, false, array("ID", "TRANSACT_DATE", "AMOUNT", "CURRENCY", "DEBIT", "DESCRIPTION"));
while ($arTransactList = $dbTransactList->GetNext()) {
$arTransactList["AMOUNT_FORMAT"] = SaleFormatCurrency($arTransactList["AMOUNT"], $arTransactList["CURRENCY"]);
$arTransactList["AMOUNT_INCOME"] = $arTransactList["DEBIT"] == "Y" ? $arTransactList["AMOUNT_FORMAT"] : "";
$arTransactList["AMOUNT_OUTCOME"] = $arTransactList["DEBIT"] != "Y" ? $arTransactList["AMOUNT_FORMAT"] : "";
$arTransactList["DESCRIPTION_NOTES"] = array_key_exists($arTransactList["DESCRIPTION"], $arTransactTypes) ? $arTransactTypes[$arTransactList["DESCRIPTION"]] : "";
$arResult["TRANSACT"][] = $arTransactList;
}
$arResult["FILTER_ID"] = rand(0, 10000);
} else {
$arResult = False;
}
$this->IncludeComponentTemplate();
} else {
LocalRedirect($arParams["REGISTER_PAGE"] . "?REDIRECT_PAGE=" . UrlEncode($APPLICATION->GetCurPage()));
die;
if (IntVal($filter_affiliate_id) > 0) {
$arFilter["AFFILIATE_ID"] = IntVal($filter_affiliate_id);
}
if (strlen($filter_user) > 0) {
$arFilter["%USER_USER"] = $filter_user;
}
if (strlen($filter_currency) > 0) {
$arFilter["CURRENCY"] = $filter_currency;
}
if (strlen($filter_transact_date_from) > 0) {
$arFilter[">=TRANSACT_DATE"] = Trim($filter_transact_date_from);
}
if (strlen($filter_transact_date_to) > 0) {
$arFilter["<=TRANSACT_DATE"] = Trim($filter_transact_date_to);
}
$dbTransactList = CSaleAffiliateTransact::GetList(array($by => $order), $arFilter, false, array("nPageSize" => CAdminResult::GetNavSize($sTableID)), array("ID", "AFFILIATE_ID", "TIMESTAMP_X", "TRANSACT_DATE", "AMOUNT", "CURRENCY", "DEBIT", "DESCRIPTION", "EMPLOYEE_ID", "AFFILIATE_SITE_ID", "USER_LOGIN", "USER_NAME", "USER_LAST_NAME", "USER_EMAIL"));
$dbTransactList = new CAdminResult($dbTransactList, $sTableID);
$dbTransactList->NavStart();
$lAdmin->NavText($dbTransactList->GetNavPrint(GetMessage("STA_NAV")));
$lAdmin->AddHeaders(array(array("id" => "ID", "content" => "ID", "sort" => "ID", "default" => true), array("id" => "TRANSACT_DATE", "content" => GetMessage("SAT2_TRANSACT_DATE"), "sort" => "TRANSACT_DATE", "default" => true), array("id" => "AFFILIATE_ID", "content" => GetMessage("SAT2_AFFILIATE"), "sort" => "AFFILIATE_ID", "default" => true), array("id" => "AMOUNT", "content" => GetMessage("SAT2_SUM"), "sort" => "AMOUNT", "default" => true), array("id" => "TYPE", "content" => GetMessage("SAT2_TYPE"), "sort" => "DESCRIPTION", "default" => true), array("id" => "DESCR", "content" => GetMessage("SAT2_DESCR"), "sort" => "", "default" => true)));
$arVisibleColumns = $lAdmin->GetVisibleHeaderColumns();
while ($arTransact = $dbTransactList->NavNext(true, "f_")) {
$row =& $lAdmin->AddRow($f_ID, $arTransact);
$row->AddField("ID", $f_ID);
$row->AddField("TRANSACT_DATE", $f_TRANSACT_DATE);
$fieldValue = "[<a href=\"/bitrix/admin/sale_affiliate_edit.php?ID=" . $f_AFFILIATE_ID . "&lang=" . LANG . "\" title=\"" . GetMessage("SAT2_AFF_PROFILE") . "\">" . $f_AFFILIATE_ID . "</a>] ";
$fieldValue .= htmlspecialcharsEx($arTransact["USER_NAME"] . (strlen($arTransact["USER_NAME"]) <= 0 || strlen($arTransact["USER_LAST_NAME"]) <= 0 ? "" : " ") . $arTransact["USER_LAST_NAME"]) . "<br>";
$fieldValue .= htmlspecialcharsEx($arTransact["AFFILIATE_SITE_ID"]) . " ";
$fieldValue .= htmlspecialcharsEx($arTransact["USER_LOGIN"]) . " ";
$fieldValue .= "<a href=\"mailto:" . htmlspecialcharsEx($arTransact["USER_EMAIL"]) . "\" title=\"" . GetMessage("SAT2_MAIL") . "\">" . htmlspecialcharsEx($arTransact["USER_EMAIL"]) . "</a>";
$row->AddField("AFFILIATE_ID", $fieldValue);
