##############################################
# Bitrix: SiteManager #
# Copyright (c) 2002-2006 Bitrix #
# http://www.bitrixsoft.com #
# mailto:admin@bitrixsoft.com #
##############################################
require_once($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/main/include/prolog_admin_before.php");
$CATALOG_RIGHT = $APPLICATION->GetGroupRight("sale");
if ($CATALOG_RIGHT == "D")
$APPLICATION->AuthForm(GetMessage("ACCESS_DENIED"));
\Bitrix\Main\Loader::includeModule('sale');
if(!CBXFeatures::IsFeatureEnabled('SaleAffiliate'))
{
require($_SERVER['DOCUMENT_ROOT']."/bitrix/modules/main/include/prolog_admin_after.php");
ShowError(GetMessage("SALE_FEATURE_NOT_ALLOW"));
require($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/main/include/epilog_admin.php");
die();
}
IncludeModuleLangFile(__FILE__);
require_once($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/sale/prolog.php");
$sTableID = "tbl_sale_affiliate_search";
$oSort = new CAdminSorting($sTableID, "ID", "asc");
$lAdmin = new CAdminList($sTableID, $oSort);
$arFilterFields = array(
"filter_site_id",
"filter_user",
"filter_plan_id",
"filter_active",
"filter_last_calculate_from",
"filter_last_calculate_to",
"filter_date_create_from",
"filter_date_create_to",
);
$lAdmin->InitFilter($arFilterFields);
$arFilter = array();
$func_name = preg_replace("/[^a-zA-Z0-9_-]/is", "", $func_name);
if ($filter_site_id != "NOT_REF" && $filter_site_id <> '')
$arFilter["SITE_ID"] = $filter_site_id;
else
Unset($arFilter["SITE_ID"]);
if ($filter_user <> '')
$arFilter["%USER_USER"] = $filter_user;
if (intval($filter_plan_id) > 0)
$arFilter["PLAN_ID"] = intval($filter_plan_id);
if ($filter_active <> '')
$arFilter["ACTIVE"] = (($filter_active == "Y") ? "Y" : "N");
if ($filter_last_calculate_from <> '')
$arFilter[">=LAST_CALCULATE"] = $filter_last_calculate_from;
if ($filter_last_calculate_to <> '')
$arFilter["<=LAST_CALCULATE"] = $filter_last_calculate_to;
if ($filter_date_create_from <> '')
$arFilter[">=DATE_CREATE"] = $filter_date_create_from;
if ($filter_date_create_to <> '')
$arFilter["<=DATE_CREATE"] = $filter_date_create_to;
$dbResultList = CSaleAffiliate::GetList(
array($by => $order),
$arFilter,
false,
false,
array("ID", "SITE_ID", "USER_ID", "AFFILIATE_ID", "PLAN_ID", "ACTIVE", "TIMESTAMP_X", "DATE_CREATE", "PAID_SUM", "APPROVED_SUM", "PENDING_SUM", "ITEMS_NUMBER", "ITEMS_SUM", "LAST_CALCULATE", "PLAN_NAME", "USER_LOGIN", "USER_NAME", "USER_LAST_NAME", "USER_EMAIL")
);
$dbResultList = new CAdminResult($dbResultList, $sTableID);
$dbResultList->NavStart();
$lAdmin->NavText($dbResultList->GetNavPrint(GetMessage("SAS1_AFF")));
$arHeaders = array(
array("id"=>"ID", "content"=>"ID", "sort"=>"ID", "default"=>true),
array("id"=>"SITE_ID", "content"=>GetMessage("SAS1_SITE"), "sort"=>"SITE_ID", "default"=>true),
array("id"=>"USER_ID", "content" => GetMessage("SAS1_USER"), "sort"=>"USER_ID", "default"=>true),
array("id"=>"PLAN_ID", "content"=>GetMessage("SAS1_PLAN"), "sort"=>"PLAN_ID", "default"=>true),
array("id"=>"ACTIVE", "content"=>GetMessage("SAS1_ACTIVE"), "sort"=>"ACTIVE", "default"=>false),
array("id"=>"DATE_CREATE", "content"=>GetMessage("SAS1_DATE_CREATE"), "sort"=>"DATE_CREATE", "default"=>true),
array("id"=>"PAID_SUM", "content"=>GetMessage("SAS1_PAID_SUM"), "sort"=>"PAID_SUM", "default"=>false),
array("id"=>"PENDING_SUM", "content"=>GetMessage("SAS1_PENDING_SUM"), "sort"=>"PENDING_SUM", "default"=>false),
array("id"=>"LAST_CALCULATE", "content"=>GetMessage("SAS1_LAST_CALC"), "sort"=>"LAST_CALCULATE", "default"=>false),
array("id"=>"ACT", "content"=>" ", "default"=>true),
);
$lAdmin->AddHeaders($arHeaders);
$arVisibleColumns = $lAdmin->GetVisibleHeaderColumns();
while ($arItems = $dbResultList->NavNext(true, "f_"))
{
$row =& $lAdmin->AddRow($f_ID, $arItems);
$row->AddField("ID", $f_ID);
$row->AddField("SITE_ID", $f_SITE_ID);
$fieldValue = "[".$f_USER_ID."] ";
$fieldValue .= $f_USER_NAME.(($f_USER_NAME == '' || $f_USER_LAST_NAME == '') ? "" : " ").$f_USER_LAST_NAME."
";
$fieldValue .= $f_USER_LOGIN." ";
$fieldValue .= "".$f_USER_EMAIL."";
$row->AddField("USER_ID", $fieldValue);
$row->AddField("PLAN_ID", "[".$f_PLAN_ID."] ".$f_PLAN_NAME);
$row->AddField("ACTIVE", $f_ACTIVE);
$row->AddField("DATE_CREATE", $f_DATE_CREATE);
$row->AddField("PAID_SUM", $f_PAID_SUM);
$row->AddField("PENDING_SUM", $f_PENDING_SUM);
$row->AddField("LAST_CALCULATE", $f_LAST_CALCULATE);
$row->AddField("ACT", "".GetMessage("SAS1_SELECT")."");
$arActions = array();
$arActions[] = array(
"ICON"=>"",
"TEXT"=>GetMessage("SAS1_SELECT"),
"DEFAULT"=>true,
"ACTION"=>"SelEl(".$f_ID.");",
);
$row->AddActions($arActions);
}
$lAdmin->AddFooter(
array(
array(
"title" => GetMessage("MAIN_ADMIN_LIST_SELECTED"),
"value" => $dbResultList->SelectedRowsCount()
),
)
);
$lAdmin->CheckListMode();
/****************************************************************************/
/*********** MAIN PAGE ****************************************************/
/****************************************************************************/
$APPLICATION->SetTitle(GetMessage("SAS1_SEARCH"));
require($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/main/include/prolog_popup_admin.php");
?>