<?
/** @global CMain $APPLICATION */
/** @global CUser $USER */
/** @global string $DBType */
/** @global CDatabase $DB */
use Bitrix\Main;
use Bitrix\Main\Loader;
use Bitrix\Main\Localization\Loc;
use Bitrix\Main\Config\Option;
use Bitrix\Sale\Internals\StatusTable;
use Bitrix\Sale;
use \Bitrix\Sale\Exchange\Integration\Admin;

require_once($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/main/include/prolog_admin_before.php");
Loader::includeModule('sale');
require_once($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/sale/prolog.php");

\Bitrix\Main\UI\Extension::load('sale.admin_order_list');

// include functions
require_once($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/sale/general/admin_tool.php");

$saleModulePermissions = $APPLICATION->GetGroupRight("sale");
$isCanUsePersonalization = \Bitrix\Sale\Configuration::isCanUsePersonalization();

if($saleModulePermissions == "D")
	$APPLICATION->AuthForm(Loc::getMessage("ACCESS_DENIED"));

$LOCAL_SITE_LIST_CACHE = array();
$LOCAL_PERSON_TYPE_CACHE = array();
$LOCAL_PAYED_USER_CACHE = array();
$LOCAL_STATUS_CACHE = array();

Loc::loadMessages(__FILE__);

$request = \Bitrix\Main\Context::getCurrent()->getRequest();
$link = Admin\Link::getInstance();
$publicMode = $adminPage->publicMode;
$arUserGroups = $USER->GetUserGroupArray();
$intUserID = (int)$USER->GetID();

$registry = Sale\Registry::getInstance(Sale\Registry::REGISTRY_TYPE_ORDER);

/** @var Sale\Order $orderClass */
$orderClass = $registry->getOrderClassName();

$isUserResponsible = false;

$arAccessibleSites = array();
$dbAccessibleSites = CSaleGroupAccessToSite::GetList(
	array(),
	array("GROUP_ID" => $arUserGroups),
	false,
	false,
	array("SITE_ID")
);
while ($arAccessibleSite = $dbAccessibleSites->Fetch())
{
	if(!in_array($arAccessibleSite["SITE_ID"], $arAccessibleSites))
		$arAccessibleSites[] = $arAccessibleSite["SITE_ID"];
}

$bExport = (isset($_REQUEST['mode']) && $_REQUEST['mode'] == 'excel');

$sTableID = "tbl_sale_order";
$oSort = new CAdminSorting($sTableID, "ID", "desc");
$lAdmin = new CAdminSaleList($sTableID, $oSort);

$runtimeFields = array();

$arFilterFields = array(
	"filter_universal",
	"filter_is_sync_b24",
	"filter_id_from",
	"filter_id_to",
	"filter_account_number",
	"filter_date_from",
	"filter_date_to",
	"filter_date_update_from",
	"filter_date_update_to",
	"filter_date_paid_from",
	"filter_date_paid_to",
	"filter_lang",
	"filter_currency",
	"filter_price_from",
	"filter_price_to",
	"filter_status",
	"filter_date_status_from",
	"filter_by_recommendation",
	"filter_date_status_to",
	"filter_payed",
	"filter_canceled",
	"filter_deducted",
	"filter_allow_delivery",
	"filter_date_allow_delivery_to",
	"filter_date_allow_delivery_from",
	"filter_marked",
	"filter_buyer",
	"filter_product_id",
	"filter_product_xml_id",
	"filter_catalog_xml_id",
	"filter_affiliate_id",
	"filter_order_use_discounts",
	"filter_order_use_coupons",
	"filter_discount_coupon",
	"filter_person_type",
	"filter_user_id",
	"filter_user_login",
	"filter_user_email",
	"filter_group_id",
	"filter_sum_paid",
	"filter_pay_system",
	"filter_delivery_service",
	"filter_xml_id",
	"filter_tracking_number",
	"filter_delivery_doc_date_from",
	"filter_delivery_doc_date_to",
	"filter_source",
	"filter_company_id",
	"filter_responsible_id",
);

$arOrderProps = array();
$arOrderPropsCode = array();
$dbProps = \Bitrix\Sale\Internals\OrderPropsTable::getList(
	array(
		'filter' => array(
			'=ACTIVE' => 'Y'
		),
		'order' => array(
			"PERSON_TYPE_ID" => "ASC", "SORT" => "ASC"
		),
		'select' => array(
			"ID", "NAME", "PERSON_TYPE_NAME" => "PERSON_TYPE.NAME", "LID" => "PERSON_TYPE.LID", "PERSON_TYPE_ID", "SORT", "IS_FILTERED", "TYPE", "CODE", "SETTINGS"
		),
	));

while ($arProps = $dbProps->fetch())
{
	$key = "";
	$propAdded = false;

	if(trim((string)$arProps["CODE"]) !== '')
	{
		$key = $arProps["CODE"];

		if(empty($arOrderPropsCode[$key]))
		{
			$arOrderPropsCode[$key] = $arProps;
		}
		$propAdded = true;
	}

	if (!$propAdded)
	{
		$key = intval($arProps["ID"]);
		if (empty($arOrderProps[$key]))
		{
			$arOrderProps[$key] = $arProps;
		}
	}

	if($key)
	{
		if($arProps["IS_FILTERED"] == "Y" && $arProps["TYPE"] != "MULTISELECT" && $arProps["TYPE"] != "FILE")
		{
			$arFilterFields[] = "filter_prop_".$key;
		}
	}
}

$lAdmin->InitFilter($arFilterFields);

$filter_lang = trim((string)$filter_lang);
if($filter_lang <> '')
{
	if(!in_array($filter_lang, $arAccessibleSites) && $saleModulePermissions < "W")
		$filter_lang = "";
}

$arFilter = array();
$arSelectFields = array();
$userCompanyList = array();

if(intval($filter_id_from)>0) $arFilter[">=ID"] = intval($filter_id_from);
if(intval($filter_id_to)>0) $arFilter["<=ID"] = intval($filter_id_to);
if(trim((string)$filter_date_from) !== '')
{
	$arFilter[">=DATE_INSERT"] = trim($filter_date_from);
}
if(trim((string)$filter_date_to) !== '')
{
	if($arDate = ParseDateTime($filter_date_to, CSite::GetDateFormat("FULL", SITE_ID)))
	{
		if(mb_strlen($filter_date_to) < 11)
		{
			$arDate["HH"] = 23;
			$arDate["MI"] = 59;
			$arDate["SS"] = 59;
		}

		$filter_date_to = date($DB->DateFormatToPHP(CSite::GetDateFormat("FULL", SITE_ID)), mktime($arDate["HH"], $arDate["MI"], $arDate["SS"], $arDate["MM"], $arDate["DD"], $arDate["YYYY"]));
		$arFilter["<=DATE_INSERT"] = $filter_date_to;
	}
	else
	{
		$filter_date_to = "";
	}
}

if(trim((string)$filter_date_update_from) !== '')
{
	$arFilter[">=DATE_UPDATE"] = trim($filter_date_update_from);
}
elseif($set_filter!="Y" && $del_filter != "Y" && !$bExport)
{
	$filter_date_update_from_DAYS_TO_BACK = Option::get("sale", "order_list_date", 30);
	$filter_date_update_from = GetTime(time()-86400*Option::get("sale", "order_list_date", 30));
	$arFilter[">=DATE_UPDATE"] = $filter_date_update_from;
}

if(trim((string)$filter_date_update_to) !== '')
{
	if($arDate = ParseDateTime($filter_date_update_to, CSite::GetDateFormat("FULL", SITE_ID)))
	{
		if(mb_strlen($filter_date_update_to) < 11)
		{
			$arDate["HH"] = 23;
			$arDate["MI"] = 59;
			$arDate["SS"] = 59;
		}

		$filter_date_update_to = date($DB->DateFormatToPHP(CSite::GetDateFormat("FULL", SITE_ID)), mktime($arDate["HH"], $arDate["MI"], $arDate["SS"], $arDate["MM"], $arDate["DD"], $arDate["YYYY"]));
		$arFilter["<=DATE_UPDATE"] = $filter_date_update_to;
	}
	else
	{
		$filter_date_update_to = "";
	}
}

if(trim((string)$filter_date_paid_from) !== '')
{
	$arFilter[">=DATE_PAYED"] = trim($filter_date_paid_from);
}

if(trim((string)$filter_date_paid_to) !== '')
{
	if($arDate = ParseDateTime($filter_date_paid_to, CSite::GetDateFormat("FULL", SITE_ID)))
	{
		if(mb_strlen($filter_date_paid_to) < 11)
		{
			$arDate["HH"] = 23;
			$arDate["MI"] = 59;
			$arDate["SS"] = 59;
		}

		$filter_date_paid_to = date($DB->DateFormatToPHP(CSite::GetDateFormat("FULL", SITE_ID)), mktime($arDate["HH"], $arDate["MI"], $arDate["SS"], $arDate["MM"], $arDate["DD"], $arDate["YYYY"]));
		$arFilter["<=DATE_PAYED"] = $filter_date_paid_to;
	}
	else
	{
		$filter_date_paid_to = "";
	}
}

if(trim((string)$filter_date_allow_delivery_from) !== '')
{
	$arFilter[">=DATE_ALLOW_DELIVERY"] = trim($filter_date_allow_delivery_from);
}

if(trim((string)$filter_date_allow_delivery_to) !== '')
{
	if($arDate = ParseDateTime($filter_date_allow_delivery_to, CSite::GetDateFormat("FULL", SITE_ID)))
	{
		if(mb_strlen($filter_date_allow_delivery_to) < 11)
		{
			$arDate["HH"] = 23;
			$arDate["MI"] = 59;
			$arDate["SS"] = 59;
		}

		$filter_date_allow_delivery_to = date($DB->DateFormatToPHP(CSite::GetDateFormat("FULL", SITE_ID)), mktime($arDate["HH"], $arDate["MI"], $arDate["SS"], $arDate["MM"], $arDate["DD"], $arDate["YYYY"]));
		$arFilter["<=DATE_ALLOW_DELIVERY"] = $filter_date_allow_delivery_to;
	}
	else
	{
		$filter_date_allow_delivery_to = "";
	}
}

if($filter_lang <> '' && $filter_lang!="NOT_REF") $arFilter["=LID"] = trim($filter_lang);
if($filter_currency <> '') $arFilter["CURRENCY"] = trim($filter_currency);

if (isset($filter_status) && !is_array($filter_status) && $filter_status <> '')
{
	$filter_status = array($filter_status);
}
if (isset($filter_status) && is_array($filter_status) && count($filter_status) > 0)
{
	foreach ($filter_status as $filterStatusIndex => $filterStatusValue)
	{
		$filterStatusValue = trim($filterStatusValue);
		if (strval($filterStatusValue) != '')
		{
			$arFilter["=STATUS_ID"][] = $filterStatusValue;
		}
	}
}
if ($filter_by_recommendation <> '') $arFilter["=BY_RECOMMENDATION"] = trim($filter_by_recommendation);
if($filter_date_status_from <> '') $arFilter[">=DATE_STATUS"] = trim($filter_date_status_from);
if($filter_date_status_to <> '')
{
	if($arDate = ParseDateTime($filter_date_status_to, CSite::GetDateFormat("FULL", SITE_ID)))
	{
		if(mb_strlen($filter_date_status_to) < 11)
		{
			$arDate["HH"] = 23;
			$arDate["MI"] = 59;
			$arDate["SS"] = 59;
		}

		$filter_date_status_to = date($DB->DateFormatToPHP(CSite::GetDateFormat("FULL", SITE_ID)), mktime($arDate["HH"], $arDate["MI"], $arDate["SS"], $arDate["MM"], $arDate["DD"], $arDate["YYYY"]));
		$arFilter["<=DATE_STATUS"] = $filter_date_status_to;
	}
	else
	{
		$filter_date_status_to = "";
	}
}

if($filter_is_sync_b24 <> '') $arFilter["=IS_SYNC_B24"] = trim($filter_is_sync_b24);
if($filter_payed <> '') $arFilter["=PAYED"] = trim($filter_payed);
if($filter_canceled <> '') $arFilter["=CANCELED"] = trim($filter_canceled);
if($filter_deducted <> '') $arFilter["=DEDUCTED"] = trim($filter_deducted);
if($filter_allow_delivery <> '') $arFilter["=ALLOW_DELIVERY"] = trim($filter_allow_delivery);
if($filter_marked <> '') $arFilter["=MARKED"] = trim($filter_marked);
if($filter_buyer <> '') $arFilter["%BUYER"] = trim($filter_buyer);
if($filter_user_login <> '') $arFilter["USER.LOGIN"] = trim($filter_user_login);
if($filter_user_email <> '') $arFilter["USER.EMAIL"] = trim($filter_user_email);
if(intval($filter_user_id)>0) $arFilter["=USER_ID"] = intval($filter_user_id);
if (!empty($filter_group_id) && is_array($filter_group_id))
{
	Main\Type\Collection::normalizeArrayValuesByInt($filter_group_id);
	if (!empty($filter_group_id))
	{
		$whereExpression = '(' . implode(', ', $filter_group_id) . ')';
		$runtimeFields['REQUIRED_UG_PRESENTED'] = [
			'data_type' => 'boolean',
			'expression' => [
				'case when exists (select USER_ID from b_user_group where USER_ID = %s and GROUP_ID in '
					. $whereExpression . ') then 1 else 0 end'
				,
				'USER_ID',
			],
		];
		$arFilter['=REQUIRED_UG_PRESENTED'] = 1;
	}
}

if(intval($filter_affiliate_id)>0) $arFilter["AFFILIATE_ID"] = intval($filter_affiliate_id);
if(isset($filter_discount_coupon) && $filter_discount_coupon <> '') $arFilter["=ORDER_COUPONS.COUPON"] = trim($filter_discount_coupon);
if (isset($filter_order_use_discounts))
{
	switch ($filter_order_use_discounts)
	{
		case 'Y':
			$runtimeFields["REQUIRED_DISCOUNT_RULES"] = [
				'data_type' => 'boolean',
				'expression' => [
					'CASE WHEN EXISTS (SELECT ID FROM b_sale_order_rules WHERE ORDER_ID = %s) THEN 1 ELSE 0 END',
					'ID'
				]
			];
			$arFilter['=REQUIRED_DISCOUNT_RULES'] = 1;
			break;
		case 'N':
			$arFilter['=ORDER_DISCOUNT_RULES.ID'] = null;
			break;
	}
}
if (isset($filter_order_use_coupons))
{
	switch ($filter_order_use_coupons)
	{
		case 'Y':
			$runtimeFields["REQUIRED_COUPONS"] = [
				'data_type' => 'boolean',
				'expression' => [
					'CASE WHEN EXISTS (SELECT ID FROM b_sale_order_coupons WHERE ORDER_ID = %s) THEN 1 ELSE 0 END',
					'ID'
				]
			];
			$arFilter['=REQUIRED_COUPONS'] = 1;
			break;
		case 'N':
			$arFilter['=ORDER_COUPONS.ID'] = null;
			break;
	}
}
if(floatval($filter_price_from)>0) $arFilter[">=PRICE"] = floatval($filter_price_from);
if(floatval($filter_price_to)>0) $arFilter["<=PRICE"] = floatval($filter_price_to);
if($filter_xml_id <> '') $arFilter["%XML_ID"] = trim($filter_xml_id);
if($filter_tracking_number <> '') $arFilter["%SHIPMENT.TRACKING_NUMBER"] = trim($filter_tracking_number);

if(trim((string)$filter_delivery_doc_date_from) !== '')
{
	$arFilter[">=SHIPMENT.DELIVERY_DOC_DATE"] = trim($filter_delivery_doc_date_from);
}
if(trim((string)$filter_delivery_doc_date_to) !== '')
{
	if($arDate = ParseDateTime($filter_delivery_doc_date_to, CSite::GetDateFormat("FULL", SITE_ID)))
	{
		if(mb_strlen($filter_delivery_doc_date_to) < 11)
		{
			$arDate["HH"] = 23;
			$arDate["MI"] = 59;
			$arDate["SS"] = 59;
		}

		$filter_delivery_doc_date_to = date($DB->DateFormatToPHP(CSite::GetDateFormat("FULL", SITE_ID)), mktime($arDate["HH"], $arDate["MI"], $arDate["SS"], $arDate["MM"], $arDate["DD"], $arDate["YYYY"]));
		$arFilter["<=SHIPMENT.DELIVERY_DOC_DATE"] = $filter_delivery_doc_date_to;
	}
	else
	{
		$filter_delivery_doc_date_to = "";
	}
}


if(isset($filter_universal) && $filter_universal <> '')
	$arFilter["NAME_SEARCH"] = trim($filter_universal);
if($filter_account_number <> '') $arFilter["ACCOUNT_NUMBER"] = trim($filter_account_number);

if($filter_sum_paid <> '')
{
	if($filter_sum_paid == "Y")
		$arFilter[">SUM_PAID"] = 0;
	else
		$arFilter["<=SUM_PAID"] = 0;
}

if(isset($filter_person_type) && is_array($filter_person_type) && count($filter_person_type) > 0)
{
	foreach ($filter_person_type as $filterPersonTypeId)
	{
		if(intval($filterPersonTypeId) > 0)
			$arFilter["=PERSON_TYPE_ID"][] = intval($filterPersonTypeId);
	}
}

if (isset($filter_source))
{
	$filter_source = (int)$filter_source;
	if ($filter_source)
	{
		$arFilter["=SOURCE.TRADING_PLATFORM_ID"] = $filter_source !== -1 ? $filter_source : "";
	}
}

if(!empty($filter_pay_system) && is_array($filter_pay_system))
{
	$whereExpression = "";

	foreach ($filter_pay_system as $filterPaySystemId)
	{
		if(intval($filterPaySystemId) <= 0)
			continue;

		if($whereExpression == "")
			$whereExpression .= "(";
		else
			$whereExpression .= " OR ";

		$whereExpression .= "PAY_SYSTEM_ID = ".intval($filterPaySystemId);
	}

	if($whereExpression <> '')
	{
		$whereExpression .= ")";

		$runtimeFields["REQUIRED_PS_PRESENTED"] = array(
			'data_type' => 'boolean',
			'expression' => array(
				'CASE WHEN EXISTS (SELECT ID FROM b_sale_order_payment WHERE ORDER_ID = %s AND '.$whereExpression.') THEN 1 ELSE 0 END',
				'ID'
			)
		);

		$arFilter["=REQUIRED_PS_PRESENTED"] = 1;
	}
}

if(!empty($filter_tracking_number) && $filter_tracking_number <> '')
{
	$runtimeFields["REQUIRED_PS_PRESENTED"] = array(
		'data_type' => 'boolean',
		'expression' => array(
			'CASE WHEN EXISTS (SELECT ID FROM b_sale_order_payment WHERE ORDER_ID = %s AND '.$whereExpression.') THEN 1 ELSE 0 END',
			'ID'
		)
	);
}


if(!empty($filter_delivery_service) && is_array($filter_delivery_service))
{
	$countFilterDeliveryService = count($filter_delivery_service);
	$whereExpression = "";

	foreach ($filter_delivery_service as $filterDeliveryServiceId)
	{
		if(intval($filterDeliveryServiceId) <= 0)
			continue;

		if($whereExpression == "")
			$whereExpression .= "(";
		else
			$whereExpression .= " OR ";

		$whereExpression .= "DELIVERY_ID = ".intval($filterDeliveryServiceId);
	}

	if(strval($whereExpression) != "")
	{
		$whereExpression .= ")";

		$runtimeFields["REQUIRED_DLV_PRESENTED"] = array(
			'data_type' => 'boolean',
			'expression' => array(
				'CASE WHEN EXISTS (SELECT ID FROM b_sale_order_delivery WHERE ORDER_ID = %s AND `SYSTEM`="N" AND '.$whereExpression.') THEN 1 ELSE 0 END',
				'ID'
			)
		);

		$arFilter["=REQUIRED_DLV_PRESENTED"] = 1;
	}
}

if(!empty($filter_product_id) || !empty($filter_product_xml_id)|| !empty($filter_catalog_xml_id))
{
	$whereExpression = "";
	if (intval($filter_product_id) > 0)
	{
		$whereExpression .= "(PRODUCT_ID = ".intval($filter_product_id);
	}

	$filterProductFields = [
		'PRODUCT_XML_ID' => $filter_product_xml_id,
		'CATALOG_XML_ID' => $filter_catalog_xml_id
	];

	foreach ($filterProductFields as $code=>$filterValue)
	{
		if (trim((string)$filterValue) !== "")
		{
			if ($whereExpression == "")
			{
				$whereExpression .= "(";
			}
			else
			{
				$whereExpression .= " AND ";
			}

			/** @var \Bitrix\Main\DB\Connection $connection */
			$connection = \Bitrix\Main\Application::getConnection();
			/** @var \Bitrix\Main\DB\SqlHelper $sqlHelper */
			$sqlHelper = $connection->getSqlHelper();

			$whereExpression .= "{$code} = '".$sqlHelper->forSql($filterValue)."'";
		}
	}

	if(strval($whereExpression) != "")
	{
		$whereExpression .= ")";

		$runtimeFields["REQUIRED_PRODUCT_PRESENTED"] = array(
			'data_type' => 'boolean',
			'expression' => array(
				'CASE WHEN EXISTS (SELECT ID FROM b_sale_basket WHERE ORDER_ID = %s AND '.$whereExpression.') THEN 1 ELSE 0 END',
				'ID'
			)
		);

		$arFilter["=REQUIRED_PRODUCT_PRESENTED"] = 1;
	}
}


$filterOrderPropValue = array();
$filterOrderProps = array();
foreach ($arOrderProps as $key => $value)
{
	if($value["IS_FILTERED"] == "Y" && $value["TYPE"] != "MULTIPLE")
	{
		$tmp = trim(${"filter_prop_".$key});
		if($tmp <> '')
		{
			if($value["TYPE"]=="STRING" && !preg_match("/^\d+$/", $tmp))
				$filterName = "%PROPERTY_VALUE_".$key;
			else
				$filterName = "PROPERTY_VALUE_".$key;

			$filterOrderProps[$filterName] = $tmp;
			$filterOrderPropValue[$key] = $tmp;
		}
	}
}

foreach ($arOrderPropsCode as $key => $value)
{
	if($value["IS_FILTERED"] == "Y" && $value["TYPE"] != "MULTIPLE")
	{
		$tmp = trim((string)${"filter_prop_".$key});
		if($tmp <> '')
		{
			if($value["TYPE"]=="STRING" && !preg_match("/^\d+$/", $tmp))
				$filterName = "%PROPERTY_VAL_BY_CODE_".$key;
			else
				$filterName = "PROPERTY_VAL_BY_CODE_".$key;

			$filterOrderProps[$filterName] = $tmp;
			$filterOrderPropValue[$key] = $tmp;
		}
	}
}

if($saleModulePermissions < "W")
{
	if($filter_lang == '' && count($arAccessibleSites) > 0)
		$arFilter["=LID"] = $arAccessibleSites;
}

$allowedStatusesView = \Bitrix\Sale\OrderStatus::getStatusesUserCanDoOperations($intUserID, array('view'));

if($saleModulePermissions == "P")
{
	$userCompanyList = Sale\Services\Company\Manager::getUserCompanyList($USER->GetID());
	$arFilter[] = array(
		"LOGIC" => "OR",
		'=RESPONSIBLE_ID' => $USER->GetID(),
		'=COMPANY_ID' => $userCompanyList,
	);

	$arSelectFields[] = 'RESPONSIBLE_ID';
	$arSelectFields[] = 'COMPANY_ID';
}

$companyListNames = array();

$dbRes = \Bitrix\Sale\Services\Company\Manager::getList(array(
	'select' => array('ID', 'NAME'),
	'order' => array('NAME' => 'ASC')
));

while($row = $dbRes->fetch())
	$companyListNames[$row['ID']] = htmlspecialcharsbx($row['NAME']);

if(intval($filter_company_id)>0) $arFilter["COMPANY_ID"] = intval($filter_company_id);
if(intval($filter_responsible_id)>0) $arFilter["RESPONSIBLE_ID"] = intval($filter_responsible_id);

if($saleModulePermissions < "W")
{
	if(!$arFilter["=STATUS_ID"])
		$arFilter["=STATUS_ID"] = array();

	$intersected = array_intersect($arFilter["=STATUS_ID"], $allowedStatusesView);

	if(!empty($arFilter["=STATUS_ID"]))
	{
		if(empty($intersected))
		{
			$arFilter[]["=STATUS_ID"] = $arFilter["=STATUS_ID"];
			$arFilter[]["=STATUS_ID"] = $allowedStatusesView;
			unset($arFilter["=STATUS_ID"], $arFilter["=STATUS_ID"]);
		}
		else
		{
			$arFilter["=STATUS_ID"] = $intersected;
		}
	}
	else
	{
		$arFilter["=STATUS_ID"] = $allowedStatusesView;
	}

}

if (!empty($_REQUEST['OID']) && is_array($_REQUEST['OID']))
{
	foreach ($_REQUEST['OID'] as $orderId)
	{
		if (intval($orderId) > 0)
		{
			$arFilter['=ID'][] = intval($orderId);
		}
	}
}

$arFilterTmp = $arFilter;

if($lAdmin->EditAction() && $saleModulePermissions >= "U")
{
	foreach ($FIELDS as $ID => $arFields)
	{
		$ID = (int)$ID;
		$isOrderNeedSave = false;

		if(!$lAdmin->IsUpdated($ID))
			continue;

		/** @var \Bitrix\Sale\Order $editOrder */
		$editOrder = $orderClass::load($ID);

		if($editOrder)
		{
			if(array_key_exists("CANCELED", $arFields)
				&& ($arFields["CANCELED"] == "Y" || $arFields["CANCELED"] == "N")
				&& $arFields["CANCELED"] != $editOrder->getField("CANCELED"))
			{
				if(CSaleOrder::CanUserCancelOrder($ID, $arUserGroups, $intUserID))
				{
					/** @var \Bitrix\Sale\Result $res */
					$res = $editOrder->setField("CANCELED", $arFields["CANCELED"]);
					if($res->isSuccess())
					{
						$isOrderNeedSave = true;
					}
					else
					{
						$errMessages = $res->getErrorMessages();
						if(count($errMessages) > 0)
							$lAdmin->AddUpdateError(implode("<br>\n", $errMessages), $ID);
						else
							$lAdmin->AddUpdateError(Loc::getMessage("SOA_ERROR_CANCEL"), $ID);
					}
				}
				else
				{
					$lAdmin->AddUpdateError(Loc::getMessage("SOA_PERMS_CANCEL"), $ID);
				}
			}

			if(array_key_exists("IS_SYNC_B24", $arFields)
				&& ($arFields["IS_SYNC_B24"] == "Y" || $arFields["IS_SYNC_B24"] == "N")
				&& $arFields["IS_SYNC_B24"] != $editOrder->getField("IS_SYNC_B24"))
			{
				/** @var \Bitrix\Sale\Result $res */
				$res = $editOrder->setField("IS_SYNC_B24", $arFields["IS_SYNC_B24"]);
				if($res->isSuccess())
				{
					$isOrderNeedSave = true;
				}
			}

			$statusId = $editOrder->getField("STATUS_ID");

			if(array_key_exists("STATUS_ID", $arFields)
				&& $arFields["STATUS_ID"] <> ''
				&& $arFields["STATUS_ID"] != $statusId)
			{
				$statusesList = \Bitrix\Sale\OrderStatus::getAllowedUserStatuses(
					$USER->GetID(),
					\Bitrix\Sale\OrderStatus::getInitialStatus()
				);

				if(array_key_exists($statusId, $statusesList))
				{
					$res = $editOrder->setField("STATUS_ID", $arFields["STATUS_ID"]);

					if($res->isSuccess())
					{
						$isOrderNeedSave = true;
					}
					else
					{
						$errMessages = $res->getErrorMessages();
						if(count($errMessages) > 0)
							$lAdmin->AddUpdateError(implode("<br>\n", $errMessages), $ID);
						else
							$lAdmin->AddUpdateError(Loc::getMessage("SOA_ERROR_STATUS"), $ID);
					}
				}
				else
				{
					$lAdmin->AddUpdateError(Loc::getMessage("SOA_PERMS_STATUS"), $ID);
				}
			}

			if($isOrderNeedSave)
			{
				$res = $editOrder->save();
				Sale\Provider::resetTrustData($editOrder->getSiteId());
				if(!$res->isSuccess())
				{
					$errMessages = $res->getErrorMessages();
					if(count($errMessages) > 0)
						$lAdmin->AddUpdateError(implode("<br>\n", $errMessages), $ID);
					else
						$lAdmin->AddUpdateError(Loc::getMessage("SOA_ERROR_CANCEL"), $ID);
				}
			}
		}
		else
		{
			$lAdmin->AddUpdateError(Loc::getMessage("SOA_NO_ORDER"), $ID);
		}
	}
}

$bShowBasketProps = ((string)\Bitrix\Main\Config\Option::get('sale', 'show_basket_props_in_order_list') == 'Y');

//Filters by foreign entities
//User params
if(isset($arFilterTmp["NAME_SEARCH"]) && $arFilterTmp["NAME_SEARCH"] <> '')
{
	$nameSearch = $arFilterTmp["NAME_SEARCH"];

	$arFilterTmp[] = array(
		"LOGIC" => "OR",
		"%USER.LOGIN" => $nameSearch,
		"%USER.NAME" => $nameSearch,
		"%USER.LAST_NAME" => $nameSearch,
		"%USER.SECOND_NAME" => $nameSearch,
		"%USER.EMAIL" => $nameSearch,
	);
}
unset($arFilterTmp["NAME_SEARCH"]);


$propIterator = 0;
//Order props params
foreach ($arOrderPropsCode as $key => $value)
{
	if($value["IS_FILTERED"] != "Y" || $value["TYPE"] == "MULTIPLE")
		continue;

	if(
		(isset($filterOrderProps["PROPERTY_VAL_BY_CODE_".$key]) && $filterOrderProps["PROPERTY_VAL_BY_CODE_".$key] <> '')
		|| (isset($filterOrderProps["%PROPERTY_VAL_BY_CODE_".$key]) && $filterOrderProps["%PROPERTY_VAL_BY_CODE_".$key] <> '')
	)
	{
		$propIterator++;

		$runtimeFields['PROP_'.$propIterator] = array(
			'data_type' => 'Bitrix\Sale\Internals\OrderPropsValueTable',
			'reference' => array(
				'ref.ORDER_ID' => 'this.ID',
			),
			'join_type' => 'inner'
		);

		$arFilterTmp["=PROP_".$propIterator.".CODE"] = $key;

		if (isset($filterOrderProps["%PROPERTY_VAL_BY_CODE_".$key]))
			$arFilterTmp["?PROP_".$propIterator.".VALUE"] = $filterOrderPropValue[$key];
		else
			$arFilterTmp["PROP_".$propIterator.".VALUE"] = $filterOrderPropValue[$key];
	}
}

foreach ($arOrderProps as $key => $value)
{
	$propIterator++;

	if($value["IS_FILTERED"] != "Y" || $value["TYPE"] == "MULTIPLE")
		continue;

	if(
		(isset($filterOrderProps["PROPERTY_VALUE_".$key]) && $filterOrderProps["PROPERTY_VALUE_".$key] <> '')
		|| (isset($filterOrderProps["%PROPERTY_VALUE_".$key]) && $filterOrderProps["%PROPERTY_VALUE_".$key] <> '')
	)
	{
		$runtimeFields['PROP_'.$propIterator] = array(
			'data_type' => 'Bitrix\Sale\Internals\OrderPropsValueTable',
			'reference' => array(
				'ref.ORDER_ID' => 'this.ID',
			),
			'join_type' => 'inner'
		);

		$arFilterTmp["=PROP_".$propIterator.".ORDER_PROPS_ID"] = $key;

		if (isset($filterOrderProps["%PROPERTY_VALUE_".$key]))
			$arFilterTmp["?PROP_".$propIterator.".VALUE"] = $filterOrderPropValue[$key];
		else
			$arFilterTmp["PROP_".$propIterator.".VALUE"] = $filterOrderPropValue[$key];
	}
}

foreach(GetModuleEvents("sale", "OnOrderListFilter", true) as $arEvent)
	$arFilterTmp = ExecuteModuleEventEx($arEvent, array($arFilterTmp));

if(
	array_key_exists('=SOURCE.TRADING_PLATFORM_ID', $arFilterTmp)
	|| in_array('SOURCE_NAME', $arSelectFields)
	|| $by == 'SOURCE_NAME')
{
	addSourceNameToRuntimeAndSelect($runtimeFields, $arSelectFields);
}

$arID = array();

if(($arID = $lAdmin->GroupAction()) && $saleModulePermissions >= "P")
{
	$arAffectedOrders = array();
	$forAll =($_REQUEST['action_target'] == 'selected');

	if($forAll)
	{
		$filter = $arFilterTmp;
		$arID = array();
	}
	else
	{
		$filter = array(
			"ID" => $arID,
			"=STATUS_ID" => $allowedStatusesView
		);
	}

	if ($by === 'USER_EMAIL')
	{
		$by = 'USER.EMAIL';
	}

	$dbOrderList = \Bitrix\Sale\Internals\OrderTable::getList(array(
		'order' => [$by => $order],
		'filter' => $filter,
		'select' => array_merge(["ID", "PERSON_TYPE_ID", "PAYED", "CANCELED", "DEDUCTED", "STATUS_ID"], $arSelectFields),
		'runtime' => $runtimeFields
	));

	while ($arOrderList = $dbOrderList->fetch())
	{
		if($forAll)
			$arID[] = $arOrderList['ID'];

		$arAffectedOrders[$arOrderList["ID"]] = $arOrderList;
	}

	foreach ($arID as $ID)
	{
		if($ID == '')
			continue;

		if($_REQUEST['action'] != "unlock" && mb_substr($_REQUEST['action'], 0, mb_strlen("status_")) != "status_")
		{
			/** @var \Bitrix\Sale\Order $saleOrder */
			if(!($saleOrder = $orderClass::load($ID)))
			{
				$lAdmin->AddGroupError(Loc::getMessage("SO_NO_ORDER", array("#ID#" => $ID)));
				continue;
			}
		}

		if(CSaleOrder::IsLocked($ID, $lockedBY, $dateLock) && $_REQUEST['action'] != "unlock")
		{
			$lAdmin->AddGroupError(str_replace("#DATE#", "$dateLock", str_replace("#ID#", "$lockedBY", Loc::getMessage("SOE_ORDER_LOCKED"))), $ID);
		}
		else
		{
			$isOrderSaved = false;
			switch ($_REQUEST['action'])
			{
				case "delete":
					$allowedStatusesDelete = \Bitrix\Sale\OrderStatus::getStatusesUserCanDoOperations($intUserID, array('delete'));
					if(!in_array($saleOrder->getField("STATUS_ID"), $allowedStatusesDelete))
					{
						$lAdmin->AddGroupError(Loc::getMessage("SO_NO_PERMS2DEL", array("#ID#" => $ID)), $ID);
						break;
					}

					try
					{
						$res = $orderClass::delete($ID);
					}
					catch (Exception $e)
					{
						$res = $orderClass::deleteNoDemand($ID);
					}

					if (!$res->isSuccess())
					{
						$lAdmin->AddGroupError(implode("<br>\n", $res->getErrorMessages()));
					}
					break;

				case "unlock":
					CSaleOrder::UnLock($ID);
					break;

				case "cancel":
					$allowedStatusesCancel = \Bitrix\Sale\OrderStatus::getStatusesUserCanDoOperations($intUserID, array('cancel'));
					if(!in_array($saleOrder->getField("STATUS_ID"), $allowedStatusesCancel))
					{
						$lAdmin->AddGroupError(Loc::getMessage("SOA_PERMS_CANCEL_GROUP", array("#ID#" => $ID)), $ID);
						break;
					}

					if($saleOrder->getField("CANCELED") == "Y")
					{
						$lAdmin->AddGroupError(Loc::getMessage("SOA_PERMS_CANCEL_GROUP_CANCEL", array("#ID#" => $ID)), $ID);
						break;
					}
					/** @var \Bitrix\Sale\Result $res */
					$res = $saleOrder->setField("CANCELED", "Y");
					if(!$res->isSuccess())
					{
						$lAdmin->AddGroupError(implode("<br>\n", $res->getErrorMessages()), $ID);
						break;
					}
					$isOrderSaved = true;

					$res = $saleOrder->save();
					if(!$res->isSuccess())
						$lAdmin->AddGroupError(implode("<br>\n", $res->getErrorMessages()), $ID);
					break;

				case "cancel_n":
					$allowedStatusesCancel = \Bitrix\Sale\OrderStatus::getStatusesUserCanDoOperations($intUserID, array('cancel'));
					if(!in_array($saleOrder->getField("STATUS_ID"), $allowedStatusesCancel))
					{
						$lAdmin->AddGroupError(Loc::getMessage("SOA_PERMS_CANCEL_GROUP", array("#ID#" => $ID)), $ID);
						break;
					}

					if($saleOrder->getField("CANCELED") == "N")
					{
						$lAdmin->AddGroupError(Loc::getMessage("SOA_PERMS_CANCEL_GROUP_CANCEL_N", array("#ID#" => $ID)), $ID);
						break;
					}
					/** @var \Bitrix\Sale\Result $res */
					$res = $saleOrder->setField("CANCELED", "N");
					if(!$res->isSuccess())
					{
						$lAdmin->AddGroupError(implode("<br>\n", $res->getErrorMessages()), $ID);
						break;
					}
					$isOrderSaved = true;

					$res = $saleOrder->save();
					if(!$res ->isSuccess())
						$lAdmin->AddGroupError(implode("<br>\n", $res->getErrorMessages()), $ID);
					break;

				case "archive":
					$allowedStatusesDelete = \Bitrix\Sale\OrderStatus::getStatusesUserCanDoOperations($intUserID, array('delete'));
					if(!in_array($saleOrder->getField("STATUS_ID"), $allowedStatusesDelete))
					{
						$lAdmin->AddGroupError(Loc::getMessage("SO_NO_PERMS2ARCHIVE", array("#ID#" => $ID)), $ID);
						break;
					}

					$result = Sale\Archive\Manager::archiveOrders(["ID" => $ID], 1);
					if ($result->isSuccess())
					{
						$warnings = $result->getWarningMessages();
						if (empty($warnings))
						{
							$lAdmin->AddActionSuccessMessage(Loc::getMessage("SO_ORDER_ARCHIVED", array("#ID#" => $ID)));
						}
						else
						{
							foreach ($warnings as $message)
								$lAdmin->AddGroupError($message);
						}
					}
					else
					{
						foreach ($result->getErrorMessages() as $error)
							$lAdmin->AddGroupError($error);
					}
					break;

				case "allow_delivery":
				case "allow_delivery_n":

					/** @var \Bitrix\Sale\Shipment $shipment */
					foreach ($saleOrder->getShipmentCollection() as $shipment)
					{
						if(!$shipment->isSystem())
						{
							$shpMsg = Loc::getMessage(
								'SALE_ORDER_SHIPMENT_N',
								array(
									'##ORDER_N##' => $saleOrder->getField('ACCOUNT_NUMBER'),
									'##SHIPMENT_ID##' => $shipment->getId()
								));

							$allowedDeliveryStatusesUpdate = \Bitrix\Sale\DeliveryStatus::getStatusesUserCanDoOperations($USER->GetID(), array('update'));
							$allowUpdate = in_array($shipment->getField("STATUS_ID"), $allowedDeliveryStatusesUpdate);

							if(!$allowUpdate)
							{
								$lAdmin->AddGroupError(Loc::getMessage('SALE_SHIPMENT_ALLOW_DELIVERY_PERMS_ERR').'. '.$shpMsg);
								continue;
							}

							if($_REQUEST['action'] == 'allow_delivery')
								$setResult = $shipment->allowDelivery();
							else
								$setResult = $shipment->disallowDelivery();

							if ($setResult->isSuccess())
							{
								$warnings = $setResult->getWarningMessages();

								if (empty($warnings))
								{
									if($_REQUEST['action'] == 'allow_delivery')
										$mess = Loc::getMessage('SOA_SHIPMENTS_ALLOW_DELIVERY');
									else
										$mess = Loc::getMessage('SOA_SHIPMENTS_NOT_ALLOW_DELIVERY');

									$lAdmin->AddActionSuccessMessage($mess.'. '.$shpMsg);
								}
								else
								{
									foreach ($warnings as $message)
										$lAdmin->AddGroupError($message.' '.$shpMsg);
								}

								$isOrderSaved = true;

								$saveResult = $saleOrder->save();

								if (!$saveResult->isSuccess())
									$lAdmin->AddGroupError(join("\n", $saveResult->getErrorMessages()).' '.$shpMsg);
							}
							else
							{
								$serResultMessage = $setResult->getErrorMessages();

								if (!empty($serResultMessage))
									$lAdmin->AddGroupError(join("\n", $serResultMessage.' '.$shpMsg));
								else
									$lAdmin->AddGroupError(Loc::getMessage('SALE_SHIPMENT_ALLOW_DELIVERY_ERR').'. '.$shpMsg);
							}
						}
					}

					break;

				case "deducted":
				case "deducted_n":

					/** @var \Bitrix\Sale\Shipment $shipment */
					foreach ($saleOrder->getShipmentCollection() as $shipment)
					{
						if(!$shipment->isSystem())
						{
							$shpMsg = Loc::getMessage(
								'SALE_ORDER_SHIPMENT_N',
								array(
									'##ORDER_N##' => $saleOrder->getField('ACCOUNT_NUMBER'),
									'##SHIPMENT_ID##' => $shipment->getId()
								));

							$allowedDeliveryStatusesUpdate = \Bitrix\Sale\DeliveryStatus::getStatusesUserCanDoOperations($USER->GetID(), array('deduction'));
							$allowUpdate = in_array($shipment->getField("STATUS_ID"), $allowedDeliveryStatusesUpdate);

							if(!$allowUpdate)
							{
								$lAdmin->AddGroupError(Loc::getMessage('SALE_SHIPMENT_DEDUCTED_PERMS_ERR').'. '.$shpMsg);
								continue;
							}

							$setResult = $shipment->setField('DEDUCTED', ($_REQUEST['action'] == 'deducted' ? 'Y' : 'N'));

							if ($setResult->isSuccess())
							{
								$warningsList = array();
								$hasErrors = false;

								$warnings = $setResult->getWarningMessages();
								$hasWarnings = false;
								if (!empty($warnings))
								{
									foreach ($warnings as $message)
									{
										$warningsList[] = $message.' '.$shpMsg;
									}
								}

								$isOrderSaved = true;

								$saveResult = $saleOrder->save();
								if (!$saveResult->isSuccess())
								{
									$hasErrors = true;
									$lAdmin->AddGroupError(join("\n", $saveResult->getErrorMessages()).' '.$shpMsg);
								}

								if(empty($warnings) && !$hasErrors)
								{
									if($_REQUEST['action'] == 'deducted')
										$mess = Loc::getMessage('SALE_SHIPMENT_DEDUCTED');
									else
										$mess = Loc::getMessage('SALE_SHIPMENT_DEDUCTED_N');

									$lAdmin->AddActionSuccessMessage($mess.'. '.$shpMsg);
								}
								else
								{

									foreach ($warnings as $message)
									{
										$warningsList[] = $message.' '.$shpMsg;
									}

									$warningsList = array_unique($warningsList);

									foreach ($warningsList as $warning)
									{
										$lAdmin->AddGroupError($warning);
									}
								}
							}
							else
							{
								$serResultMessage = $setResult->getErrorMessages();

								if (!empty($serResultMessage))
									$lAdmin->AddGroupError(join("\n", $serResultMessage).' '.$shpMsg);
								else
									$lAdmin->AddGroupError(Loc::getMessage('SALE_SHIPMENT_ALLOW_DELIVERY_ERR').'. '.$shpMsg);

								if ($setResult->hasWarnings())
								{
									$isOrderSaved = true;
									$saveResult = $saleOrder->save();
								}
							}
						}
					}

					break;

				case "update_payment_status":

					/** @var \Bitrix\Sale\Payment $payment */
					foreach ($saleOrder->getPaymentCollection() as $payment)
					{
						$payMsg = Loc::getMessage(
							'SALE_ORDER_PAYMENT_N',
							array(
								'##ORDER_N##' => $saleOrder->getField('ACCOUNT_NUMBER'),
								'##PAYMENT_ID##' => $payment->getId()
							));

						$allowedStatusesView = \Bitrix\Sale\OrderStatus::getStatusesUserCanDoOperations($USER->GetID(), array('view'));
						$allowView = in_array($saleOrder->getField("STATUS_ID"), $allowedStatusesView);

						if(!$allowView)
						{
							$lAdmin->AddGroupError(Loc::getMessage('SALE_UPDATE_PAYMENT_STATUS_PERMS_ERR').'. '.$payMsg);
							continue;
						}

						/** @var Sale\PaySystem\Service $paySystem */
						$paySystem = $payment->getPaySystem();

						if(!$paySystem)
						{
							$lAdmin->AddGroupError(Loc::getMessage('SALE_UPDATE_PAYMENT_STATUS_PS_NOT_FOUND').'. '.$payMsg);
							continue;
						}

						if(!$paySystem->isCheckable())
						{
							$lAdmin->AddActionSuccessMessage(
								Loc::getMessage(
									'SALE_UPDATE_PAYMENT_STATUS_PS_NOT_ABLE',
									array('##PS_NAME##' => $paySystem->getField('NAME'))
								).'. '.$payMsg
							);

							continue;
						}

						$setResult = $paySystem->check($payment);

						if (!$setResult->isSuccess())
							$lAdmin->AddGroupError(join('\n', $setResult->getErrorMessages()));
						else
							$lAdmin->AddActionSuccessMessage(Loc::getMessage('SALE_UPDATE_PAYMENT_STATUS_DONE').'. '.$payMsg);
					}

					break;

				case "paid":
				case "paid_n":

					/** @var \Bitrix\Sale\Payment $payment */
					foreach ($saleOrder->getPaymentCollection() as $payment)
					{
						$payMsg = Loc::getMessage(
							'SALE_ORDER_PAYMENT_N',
							array(
								'##ORDER_N##' => $saleOrder->getField('ACCOUNT_NUMBER'),
								'##PAYMENT_ID##' => $payment->getId()
							));

						$allowedStatusesUpdate = \Bitrix\Sale\OrderStatus::getStatusesUserCanDoOperations($USER->GetID(), array('payment'));
						$allowUpdate = in_array($saleOrder->getField("STATUS_ID"), $allowedStatusesUpdate);

						if(!$allowUpdate)
						{
							$lAdmin->AddGroupError(Loc::getMessage('SALE_UPDATE_PAYMENT_STATUS_PERMS_ERR').'. '.$payMsg);
							continue;
						}

						$res = $payment->setPaid($_REQUEST['action'] == 'paid' ? 'Y' : 'N');

						if (!$res->isSuccess())
						{
							$lAdmin->AddGroupError(join("\n", $res->getErrorMessages()));
						}
						elseif ($res->hasWarnings())
						{
							$lAdmin->AddGroupError(join("\n", $res->getWarningMessages()));
						}
						else
						{
							$isOrderSaved = true;

							$res = $saleOrder->save();

							if (!$res->isSuccess())
							{
								$lAdmin->AddGroupError(join("\n", $res->getErrorMessages()));
							}
							else
							{
								if($_REQUEST['action'] == 'paid')
									$msg = Loc::getMessage('SALE_ORDER_PAID_SUCCESS');
								else
									$msg = Loc::getMessage('SALE_ORDER_PAID_SUCCESS_N');

								$lAdmin->AddActionSuccessMessage($msg.'. '.$payMsg);
							}
						}
					}

					break;

				case "delivery_requests":

					$shipmentIds = array();
					$dbRes = Sale\Internals\ShipmentTable::getList(array(
						'filter' => array('=ORDER_ID' => $arID, '!=SYSTEM' => 'Y'),
						'select' => array('ID')
					));

					while($row = $dbRes->fetch())
						$shipmentIds[] = $row['ID'];

					$_SESSION["SALE_DELIVERY_REQUEST_SHIPMENT_IDS"] = $shipmentIds;
					echo '<script>window.parent.location = "sale_delivery_request.php?lang='.LANGUAGE_ID.'";</script>';
					die();
					break;
				default:
					if(mb_substr($_REQUEST['action'], 0, mb_strlen("status_")) == "status_")
					{
						$statusID = mb_substr($_REQUEST['action'], mb_strlen("status_"));

						if($statusID <> '')
						{
							$resStatus = StatusTable::getList(array(
								'select' => array('ID', 'NAME' => 'Bitrix\Sale\Internals\StatusLangTable:STATUS.NAME'),
								'filter' => array(
									'=Bitrix\Sale\Internals\StatusLangTable:STATUS.LID' => LANGUAGE_ID,
									'=ID' => $statusID
								),
							));

							if($arStatus = $resStatus->fetch())
							{
								$allowedStatusesTo = \Bitrix\Sale\OrderStatus::getStatusesUserCanDoOperations($intUserID, array('to'));
								if(in_array($statusID, $allowedStatusesTo))
								{
									if($arAffectedOrders[$ID]["STATUS_ID"] != $statusID)
									{
										$saleOrder = $orderClass::load($ID);
										$res = $saleOrder->setField("STATUS_ID", $statusID);

										if(!$res->isSuccess())
										{
											$errMsgs = $res->getErrorMessages();

											if(count($errMsgs) > 0)
												$lAdmin->AddGroupError(Loc::getMessage("SOA_ERROR_STATUS", array("#ID#" => $ID, "#STATUS#" => $arStatus["NAME"])).": ".implode("<br>\n", $errMsgs), $ID);
											else
												$lAdmin->AddGroupError(Loc::getMessage("SOA_ERROR_STATUS", array("#ID#" => $ID, "#STATUS#" => $arStatus["NAME"])), $ID);
										}
										else
										{
											$isOrderSaved = true;
											$res = $saleOrder->save();

											if(!$res ->isSuccess())
												$lAdmin->AddGroupError(implode("<br>\n", $res->getErrorMessages()), $ID);
										}
									}
									else
									{
										$lAdmin->AddGroupError(Loc::getMessage("SOA_ERROR_STATUS_ALREADY", Array("#ID#" => $ID, "#STATUS#" => $arStatus["NAME"])), $ID);
									}
								}
								else
								{
									$lAdmin->AddGroupError(Loc::getMessage("SOA_PERMS_STATUS_GROUP", Array("#ID#" => $ID, "#STATUS#" => $arStatus["NAME"])), $ID);
								}
							}
						}
					}

					break;
			}

			if ($isOrderSaved)
			{
				Sale\Provider::resetTrustData($saleOrder->getSiteId());
			}
		}
	}
}

$arColumn2Field = array(
	"ID" => array("ID"),
	"ACCOUNT_NUMBER" => array("ACCOUNT_NUMBER"),
	"LID" => array("LID"),
	"PERSON_TYPE" => array("PERSON_TYPE_ID"),
	"IS_SYNC_B24" => array("IS_SYNC_B24"),
	"PAYED" => array("PAYED", "DATE_PAYED", "EMP_PAYED_ID"),
	"CANCELED" => array("CANCELED", "DATE_CANCELED", "EMP_CANCELED_ID"),
	"DEDUCTED" => array("DEDUCTED"),
	"MARKED" => array("MARKED", "DATE_MARKED", "EMP_MARKED_ID", "REASON_MARKED"),
	"STATUS_ID" => array("STATUS_ID", "DATE_STATUS", "EMP_STATUS_ID"),
	"STATUS" => array("STATUS_ID", "DATE_STATUS", "EMP_STATUS_ID"),
	"PRICE_DELIVERY" => array("PRICE_DELIVERY", "CURRENCY"),
	"PRICE" => array("PRICE", "CURRENCY"),
	"SUM_PAID" => array("SUM_PAID", "CURRENCY"),
	"USER" => array("USER_ID"),
	"DATE_INSERT" => array("DATE_INSERT"),
	"DATE_UPDATE" => array("DATE_UPDATE"),
	"TAX_VALUE" => array("TAX_VALUE", "CURRENCY"),
	"LOCK_STATUS" => array("LOCK_STATUS", "LOCK_USER_NAME"),
	"BASKET" => array(),
	"COMMENTS" => array("COMMENTS"),
	"REASON_CANCELED" => array("REASON_CANCELED"),
	"REASON_MARKED" => array("REASON_MARKED"),
	"USER_EMAIL" => array("USER_EMAIL"),
	"USER_DESCRIPTION" => array("USER_DESCRIPTION"),
	"EXTERNAL_ORDER" => array("EXTERNAL_ORDER"),
	"SOURCE_NAME" => array("SOURCE_NAME"),
	"XML_ID" => array("XML_ID"),
	"COMPANY_ID" => array("COMPANY_ID"),
	"RESPONSIBLE_ID" => array("RESPONSIBLE_ID"),
	"AFFILIATE_ID" => array("AFFILIATE_ID"),
);

$arHeaders = array(
	array("id"=>"DATE_INSERT","content"=>Loc::getMessage("SI_DATE_INSERT"), "sort"=>"DATE_INSERT", "default"=>true),
	array("id"=>"ID", "content"=>"ID", "sort"=>"ID", "default"=>true),
	array("id"=>"USER","content"=>Loc::getMessage("SI_BUYER"), "sort"=>"USER_ID", "default"=>true),
	array("id"=>"STATUS_ID","content"=>Loc::getMessage("SI_STATUS"), "sort"=>"STATUS_ID", "default"=>true, "title" => Loc::getMessage("SO_S_DATE_STATUS")),
	array("id"=>"PAYED","content"=>Loc::getMessage("SI_PAID"), "sort"=>"PAYED", "default"=>true, "title" => Loc::getMessage("SO_S_DATE_PAYED")),
	array("id"=>"ALLOW_DELIVERY","content"=>Loc::getMessage("SI_ALLOW_DELIVERY"), "sort"=>"ALLOW_DELIVERY", "default"=>false),
	array("id"=>"CANCELED","content"=>Loc::getMessage("SI_CANCELED"), "sort"=>"CANCELED", "default"=>true),
	array("id"=>"DEDUCTED","content"=>Loc::getMessage("SI_DEDUCTED"), "sort"=>"DEDUCTED", "default"=>true),
	array("id"=>"MARKED","content"=>Loc::getMessage("SI_MARKED"), "sort"=>"MARKED", "default"=>true),
	array("id"=>"PRICE","content"=>Loc::getMessage("SI_SUM"), "sort"=>"PRICE", "default"=>true),
	array("id"=>"BASKET","content"=>Loc::getMessage("SI_ITEMS"), "sort"=>"", "default"=>true),
	array("id"=>"DATE_UPDATE","content"=>Loc::getMessage("SI_DATE_UPDATE"), "sort"=>"DATE_UPDATE", "default"=>false),
	array("id"=>"LID","content"=>Loc::getMessage("SI_SITE"), "sort"=>"LID"),
	array("id"=>"PERSON_TYPE","content"=>Loc::getMessage("SI_PAYER_TYPE"), "sort"=>"PERSON_TYPE_ID"),
	array("id"=>"PAY_VOUCHER_NUM","content"=>Loc::getMessage("SI_NO_PP"), "sort"=>"", "default"=>false),
	array("id"=>"PAY_VOUCHER_DATE","content"=>Loc::getMessage("SI_DATE_PP"), "sort"=>"", "default"=>false),
	array("id"=>"STATUS","content"=>Loc::getMessage("SI_STATUS_OLD"), "sort"=>"STATUS_ID", "default"=>false),
	array("id"=>"PRICE_DELIVERY","content"=>Loc::getMessage("SI_DELIVERY"), "sort"=>"PRICE_DELIVERY", "default"=>false),
	array("id"=>"DELIVERY_DOC_NUM","content"=>Loc::getMessage("SI_DELIVERY_DOC_NUM"), "sort"=>"", "default"=>false),
	array("id"=>"DELIVERY_DOC_DATE","content"=>Loc::getMessage("SI_DELIVERY_DOC_DATE"), "sort"=>"", "default"=>false),
	array("id"=>"SUM_PAID","content"=>Loc::getMessage("SI_SUM_PAID"), "sort"=>"SUM_PAID"),
	array("id"=>"USER_EMAIL","content"=>Loc::getMessage("SALE_F_USER_EMAIL"), "sort"=>"USER_EMAIL", "default"=>false),
	array("id"=>"PAY_SYSTEM","content"=>Loc::getMessage("SI_PAY_SYS"), "sort"=>"", "default"=>false),
	array("id"=>"DELIVERY","content"=>Loc::getMessage("SI_DELIVERY_SYS"), "sort"=>"", "default"=>false),
	array("id"=>"PS_STATUS","content"=>Loc::getMessage("SI_PAYMENT_PS"), "sort"=>"", "default"=>false),
	array("id"=>"PS_SUM","content"=>Loc::getMessage("SI_PS_SUM"), "sort"=>"", "default"=>false),
	array("id"=>"TAX_VALUE","content"=>Loc::getMessage("SI_TAX"), "sort"=>"TAX_VALUE"),
	array("id"=>"BASKET_NAME","content"=>Loc::getMessage("SOA_BASKET_NAME"), "sort"=>""),
	array("id"=>"BASKET_PRODUCT_ID","content"=>Loc::getMessage("SOA_BASKET_PRODUCT_ID"), "sort"=>""),
	array("id"=>"BASKET_PRICE","content"=>Loc::getMessage("SOA_BASKET_PRICE"), "sort"=>""),
	array("id"=>"BASKET_QUANTITY","content"=>Loc::getMessage("SOA_BASKET_QUANTITY"), "sort"=>""),
	array("id"=>"BASKET_WEIGHT","content"=>Loc::getMessage("SOA_BASKET_WEIGHT"), "sort"=>""),
	array("id"=>"BASKET_NOTES","content"=>Loc::getMessage("SOA_BASKET_NOTES"), "sort"=>""),
	array("id"=>"BASKET_DISCOUNT_PRICE","content"=>Loc::getMessage("SOA_BASKET_DISCOUNT_PRICE"), "sort"=>""),
	array("id"=>"BASKET_CATALOG_XML_ID","content"=>Loc::getMessage("SOA_BASKET_CATALOG_XML_ID"), "sort"=>""),
	array("id"=>"BASKET_PRODUCT_XML_ID","content"=>Loc::getMessage("SOA_BASKET_PRODUCT_XML_ID"), "sort"=>""),
	array("id"=>"BASKET_DISCOUNT_NAME","content"=>Loc::getMessage("SALE_ORDER_LIST_HEADER_NAME_DISCOUNTS"), "sort"=>""),
	array("id"=>"BASKET_DISCOUNT_VALUE","content"=>Loc::getMessage("SOA_BASKET_DISCOUNT_VALUE"), "sort"=>""),
	array("id"=>"BASKET_DISCOUNT_COUPON","content"=>Loc::getMessage("SALE_ORDER_LIST_HEADER_NAME_COUPONS_MULTI"), "sort"=>""),
	array("id"=>"BASKET_VAT_RATE","content"=>Loc::getMessage("SOA_BASKET_VAT_RATE"), "sort"=>""),
	array("id"=>"DATE_ALLOW_DELIVERY", "content"=>Loc::getMessage("SALE_F_DATE_ALLOW_DELIVERY"), "sort"=>"", "default"=>false),
	array("id"=>"ACCOUNT_NUMBER","content"=>Loc::getMessage("SOA_ACCOUNT_NUMBER"), "sort"=>""),
	array("id"=>"TRACKING_NUMBER","content"=>Loc::getMessage("SOA_TRACKING_NUMBER"), "sort"=>"", "default"=>false),
	array("id"=>"DELIVERY_DOC_DATE","content"=>Loc::getMessage("SOA_DELIVERY_DOC_DATE"), "sort"=>"", "default"=>false),
	array("id"=>"EXTERNAL_ORDER","content"=>Loc::getMessage("SOA_EXTERNAL_ORDER"), "sort"=>"", "default"=> false),
	array("id"=>"SHIPMENTS","content"=>Loc::getMessage("SOA_SHIPMENTS"), "sort"=>"", "default"=> true),
	array("id"=>"PAYMENTS","content"=>Loc::getMessage("SOA_PAYMENTS"), "sort"=>"", "default"=> true),
	array("id"=>"SOURCE_NAME","content"=>Loc::getMessage("SALE_F_SOURCE"), "sort"=>"SOURCE_NAME", "default"=>false),
	array("id"=>"XML_ID","content"=>Loc::getMessage("SO_XML_ID"), "sort"=>"XML_ID", "default"=>false),
	array("id"=>"COMPANY_ID","content"=>Loc::getMessage("SALE_F_COMPANY_ID"), "sort"=>"COMPANY_ID", "default"=>false),
	array("id"=>"RESPONSIBLE_ID","content"=>Loc::getMessage("SALE_F_RESPONSIBLE_ID"), "sort"=>"RESPONSIBLE_ID", "default"=>false),
	array("id"=>"IS_SYNC_B24","content"=>Loc::getMessage("SALE_F_IS_SYNC_B24"), "sort"=>"IS_SYNC_B24", "default"=>($link->getType() == Admin\ModeType::APP_LAYOUT_TYPE)),

	array("id"=>"AFFILIATE_ID","content"=>Loc::getMessage("SI_AFFILIATE"), "sort"=>"AFFILIATE_ID", "default"=>false),
);

$arHeaders[] = array("id"=>"COMMENTS","content"=>Loc::getMessage("SI_COMMENTS"), "sort"=>"COMMENTS", "default"=>false);
$arHeaders[] = array("id"=>"PS_STATUS_DESCRIPTION","content"=>Loc::getMessage("SOA_PS_STATUS_DESCR"), "sort"=>"", "default"=>false);
$arHeaders[] = array("id"=>"USER_DESCRIPTION","content"=>Loc::getMessage("SI_USER_DESCRIPTION"), "sort"=>"", "default"=>false);
$arHeaders[] = array("id"=>"REASON_CANCELED","content"=>Loc::getMessage("SI_REASON_CANCELED"), "sort"=>"", "default"=>false);
$arHeaders[] = array("id"=>"REASON_MARKED","content"=>Loc::getMessage("SI_REASON_MARKED"), "sort"=>"", "default"=>false);

foreach ($arOrderProps as $key => $value)
{
	$arHeaders[] = array("id" => "PROP_".$key, "content" => htmlspecialcharsbx($value["NAME"])." (".htmlspecialcharsbx($value["PERSON_TYPE_NAME"]).")", "sort" => "", "default" => false);
	$arColumn2Field["PROP_".$key] = array();
}
foreach ($arOrderPropsCode as $key => $value)
{
	$arHeaders[] = array("id" => "PROP_".$key, "content" => htmlspecialcharsbx($value["NAME"]), "sort" => "", "default" => false);
	$arColumn2Field["PROP_".$key] = array();
}

$lAdmin->AddHeaders($arHeaders);

$arSelectFields[] = "ID";
$arSelectFields[] = "LID";
$arSelectFields[] = "LOCK_STATUS";
$arSelectFields[] = "LOCK_USER_NAME";

if($link->getType() == Admin\ModeType::APP_LAYOUT_TYPE)
{
	$lAdmin->AddVisibleHeaderColumn("IS_SYNC_B24");
}

$arVisibleColumns = $lAdmin->GetVisibleHeaderColumns();

if(in_array('SOURCE_NAME', $arVisibleColumns))
{
	addSourceNameToRuntimeAndSelect($runtimeFields, $arSelectFields);
}

$bNeedProps = false;
$bNeedBasket = false;
foreach ($arVisibleColumns as $visibleColumn)
{
	if(!$bNeedProps && mb_substr($visibleColumn, 0, mb_strlen("PROP_")) == "PROP_")
		$bNeedProps = true;
	if(
		!$bNeedBasket
		&& $visibleColumn != 'BASKET_DISCOUNT_COUPON'
		&& $visibleColumn != 'BASKET_DISCOUNT_NAME'
		&& mb_strpos($visibleColumn, "BASKET") !== false
	)
		$bNeedBasket = true;

	if(array_key_exists($visibleColumn, $arColumn2Field))
	{
		if(is_array($arColumn2Field[$visibleColumn]) && count($arColumn2Field[$visibleColumn]) > 0)
		{
			$countArColumn = count($arColumn2Field[$visibleColumn]);
			for ($i = 0; $i < $countArColumn; $i++)
			{
				if(!in_array($arColumn2Field[$visibleColumn][$i], $arSelectFields))
					$arSelectFields[] = $arColumn2Field[$visibleColumn][$i];
			}
		}
	}
}

$WEIGHT_UNIT = [];
$WEIGHT_KOEF = [];
$dbSite = CSite::GetList();
while ($arSite = $dbSite->Fetch())
{
	$serverName[$arSite["LID"]] = $arSite["SERVER_NAME"];
	if($serverName[$arSite["LID"]] == '')
	{
		if(defined("SITE_SERVER_NAME") && SITE_SERVER_NAME <> '')
			$serverName[$arSite["LID"]] = SITE_SERVER_NAME;
		else
			$serverName[$arSite["LID"]] = \Bitrix\Main\Config\Option::get("main", "server_name", "");
	}

	$WEIGHT_UNIT[$arSite["LID"]] = htmlspecialcharsbx(\Bitrix\Main\Config\Option::get('sale', 'weight_unit', "", $arSite["LID"]));
	$WEIGHT_KOEF[$arSite["LID"]] = htmlspecialcharsbx(\Bitrix\Main\Config\Option::get('sale', 'weight_koef', 1, $arSite["LID"]));
}

$arGroupByTmp = array();

if($saleModulePermissions < "W")
{
	foreach($arSelectFields as $k => $v)
	{
		if(in_array($v, Array("COMMENTS")) && $saleModulePermissions < "U")
			unset($arSelectFields[$k]);
	}
}

$arFilterOrder = array();

if(!empty($by) && in_array($by, $arSelectFields))
{
	if(!isset($order) || !is_string($order))
		$order = "DESC";

	if ($by == "STATUS_ID")
	{
		$arFilterOrder["STATUS_ID"] = $order;
		$arFilterOrder["DATE_STATUS"] = $order;
	}
	elseif($by == "CANCELED")
		$arFilterOrder["DATE_CANCELED"] = $order;
	else
		$arFilterOrder[$by] = $order;
}

$sScript = "
							var topWindow = (window.BX||window.parent.BX).PageObject.getRootWindow();";
$usePageNavigation = true;
$navyParams = array();

if (isset($_REQUEST['mode']) && $_REQUEST['mode'] == 'excel')
{
	$usePageNavigation = false;
}
else
{
	$navyParams = CDBResult::GetNavParams(CAdminResult::GetNavSize($sTableID));
	if ($navyParams['SHOW_ALL'])
	{
		$usePageNavigation = false;
	}
	else
	{
		$navyParams['PAGEN'] = (int)$navyParams['PAGEN'];
		$navyParams['SIZEN'] = (int)$navyParams['SIZEN'];
	}
}

if (in_array('USER_EMAIL', $arSelectFields))
{
	$arSelectFields["USER_EMAIL"] = 'USER.EMAIL';

	if ($searchIndex = array_search('USER_EMAIL', $arSelectFields))
		unset($arSelectFields[$searchIndex]);
}

$getListParams = array(
	'filter' => $arFilterTmp,
	'group' => $arGroupByTmp,
	'select' => $arSelectFields,
	'runtime' => $runtimeFields
);

if(!empty($arFilterOrder))
	$getListParams['order'] = $arFilterOrder;

if ($usePageNavigation)
{
	$getListParams['limit'] = $navyParams['SIZEN'];
	$getListParams['offset'] = $navyParams['SIZEN']*($navyParams['PAGEN']-1);
}

/** @var \Bitrix\Main\Entity\Event $event */
$event = new \Bitrix\Main\Event('sale', Sale\EventActions::EVENT_ON_ADMIN_ORDER_LIST, $getListParams);
$event->send();

if ($event->getResults())
{
	/** @var \Bitrix\Main\EventResult $eventResult */
	foreach($event->getResults() as $eventResult)
	{
		if($eventResult->getType() == \Bitrix\Main\EventResult::ERROR)
		{
			$errorMsg = new Sale\ResultError(\Bitrix\Main\Localization\Loc::getMessage('SALE_EVENT_ON_ADMIN_ORDER_LIST_ERROR'), 'SALE_EVENT_ON_ADMIN_ORDER_LIST_ERROR');
			if ($eventResultData = $eventResult->getParameters())
			{
				if (isset($eventResultData) && $eventResultData instanceof Sale\ResultError)
				{
					/** @var Sale\ResultError $errorMsg */
					$errorMsg = $eventResultData;
				}
			}
		}
		elseif($eventResult->getType() == \Bitrix\Main\EventResult::SUCCESS)
		{
			$eventParams = $eventResult->getParameters();
			if (is_array($eventParams))
			{
				$getListParams = $eventParams;
			}
		}
	}
}

$totalPages = 0;

if ($usePageNavigation)
{
	$countQuery = new \Bitrix\Main\Entity\Query(\Bitrix\Sale\Internals\OrderTable::getEntity());
	$countQuery->addSelect(new \Bitrix\Main\Entity\ExpressionField('CNT', 'COUNT(1)'));
	$countQuery->setFilter($getListParams['filter']);

	foreach ($getListParams['runtime'] as $key => $field)
		$countQuery->registerRuntimeField($key, $field);

	$totalCount = $countQuery->setLimit(null)->setOffset(null)->exec()->fetch();
	unset($countQuery);
	$totalCount = (int)$totalCount['CNT'];

	if ($totalCount > 0)
	{
		$totalPages = ceil($totalCount/$navyParams['SIZEN']);

		if ($navyParams['PAGEN'] > $totalPages)
			$navyParams['PAGEN'] = $totalPages;

		$getListParams['limit'] = $navyParams['SIZEN'];
		$getListParams['offset'] = $navyParams['SIZEN']*($navyParams['PAGEN']-1);
	}
	else
	{
		$navyParams['PAGEN'] = 1;
		$getListParams['limit'] = $navyParams['SIZEN'];
		$getListParams['offset'] = 0;
	}
}

$dbOrderList = new CAdminResult(\Bitrix\Sale\Internals\OrderTable::getList($getListParams), $sTableID);

if ($usePageNavigation)
{
	$dbOrderList->NavStart($getListParams['limit'], $navyParams['SHOW_ALL'], $navyParams['PAGEN']);
	$dbOrderList->NavRecordCount = $totalCount;
	$dbOrderList->NavPageCount = $totalPages;
	$dbOrderList->NavPageNomer = $navyParams['PAGEN'];
	$dbOrderList->nSelectedCount = $totalCount;
}
else
{
	$dbOrderList->NavStart();
}

$lAdmin->NavText($dbOrderList->GetNavPrint(Loc::getMessage("SALE_PRLIST")));

$ordersIds = array();
$shipmentStatuses = array();
$rowsList = array();
$basketSeparator = '<hr size="1" width="90%">';
$basketSetSeparator = '<br>&nbsp;-&nbsp;';

if ($bExport)
{
	$basketSeparator = "<br>";
	$basketSetSeparator = "<br>";
}

$orderList = array();
$basketList = array();
$recommendedList = array();
$basketPropertyList = array();
$users = array();
$userIdFields = array('EMP_ALLOW_DELIVERY', 'EMP_DEDUCTED_ID', 'EMP_MARKED_ID', 'EMP_STATUS_ID', 'EMP_CANCELED_ID', 'EMP_PAYED_ID', 'RESPONSIBLE_ID');
$formattedUserNames = array();
while ($arOrder = $dbOrderList->NavNext())
{
	$orderList[$arOrder['ID']] = $arOrder;
	$recommendedList[$arOrder['ID']] = false;
}

if (!empty($orderList) && is_array($orderList))
{
	/*
	 * $dbProp = \Bitrix\Sale\Internals\BasketPropertyTable::getList(array(
						'order' => array("SORT" => "ASC", "ID" => "ASC"),
						'filter' => array("BASKET_ID" => $arItem["ID"], "!CODE" => array("CATALOG.XML_ID", "PRODUCT.XML_ID"))
					));

					while($arProp = $dbProp -> fetch())
						if(strlen($arProp["VALUE"]) > 0)
							$fieldValue .= "<div><small>".htmlspecialcharsbx($arProp["NAME"]).": ".htmlspecialcharsbx($arProp["VALUE"])."</small></div>";
	 */
	if(\Bitrix\Main\Analytics\Catalog::isOn() || $bNeedBasket)
	{
		$basketItemIds = array();
		$dbItemsList = \Bitrix\Sale\Internals\BasketTable::getList(array(
			'order' => array('ID' => 'ASC'),
			'filter' => array('=ORDER_ID' => array_keys($orderList))
		));

		while ($item = $dbItemsList->fetch())
		{
			$basketList[$item['ORDER_ID']][$item['ID']] = $item;

			if (isset($recommendedList[$item['ORDER_ID']]) && $item['RECOMMENDATION'])
			{
				$recommendedList[$item['ORDER_ID']] = true;
			}

			if ($bShowBasketProps)
			{
				$basketItemIds[] = $item['ID'];
			}
		}
	}

	if ($bShowBasketProps && !empty($basketItemIds))
	{
		$basketItemIds = array_unique($basketItemIds);
		$basketItemIdsChunk = array_chunk($basketItemIds, 1000);
		foreach ($basketItemIdsChunk as $basketIds)
		{
			$resProp = \Bitrix\Sale\Internals\BasketPropertyTable::getList(array(
				'order' => array("SORT" => "ASC", "ID" => "ASC"),
				'filter' => array(
					"BASKET_ID" => $basketIds,
					"!CODE" => array("CATALOG.XML_ID", "PRODUCT.XML_ID"))
			));

			while($prop = $resProp->fetch())
			{
				if(strval($prop["VALUE"]) != "")
				{
					$basketPropertyList[$prop['BASKET_ID']][$prop['ID']] = $prop;
				}
			}
		}
		unset($basketItemIdsChunk, $basketItemIds);
	}
	$permUpdateOrderList = CSaleOrder::checkUserPermissionOrderList(array_keys($orderList), 'update', $arUserGroups);
	$permDeleteOrderList = CSaleOrder::checkUserPermissionOrderList(array_keys($orderList), 'delete', $arUserGroups, $USER->GetID());

	$affiliateCache = array();

	foreach ($orderList as $orderId => $arOrder)
	{
		foreach ($userIdFields as $userIdField)
		{
			if (!isset($arOrder[$userIdField]))
			{
				continue;
			}

			$uId = intval($arOrder[$userIdField]);
			if ($uId > 0 && !in_array($uId, $users))
				$users[] = $uId;
		}

		$formattedUserNames = GetFormatedUserName(array_values($users), false);


		/**
		 * define personalization settings
		 */
		$isRecommended = false;

		// personalization
		if(\Bitrix\Main\Analytics\Catalog::isOn() || $bNeedBasket)
		{
			$arBasketItems = array();

			if (isset($basketList[$orderId]))
			{
				$arBasketItems = $basketList[$orderId];
			}

			if (isset($recommendedList[$orderId]))
			{
				$isRecommended = $recommendedList[$orderId];
			}
		}

		$href = $link
			->create()
			->setFilterParams(GetFilterParams("filter_"))
			->fill()
			->setField('ID', $orderId)
			->setPageByType(Admin\Registry::SALE_ORDER_VIEW)
			->build();
		/**
		 * build row
		 */
		$rowsList[$arOrder['ID']] = $row =& $lAdmin->AddRow($orderId, $arOrder, $href);

		$lamp = "/bitrix/images/sale/".$arOrder['LOCK_STATUS'].".gif";

		if($arOrder['LOCK_STATUS']=="green")
			$lamp_alt = Loc::getMessage("SMOL_GREEN_ALT");
		elseif($arOrder['LOCK_STATUS']=="yellow")
			$lamp_alt = Loc::getMessage("SMOL_YELLOW_ALT");
		else
			$lamp_alt = str_replace("#LOCK_USER_NAME#", trim($arOrder['LOCK_USER_NAME']), Loc::getMessage("SMOL_RED_ALT"));

		//ID
		$idTmp = '<table><tr><td valign="top">';
		if(!$bExport)
			$idTmp .= "<img src=\"".$lamp."\" hspace='4' alt=\"".htmlspecialcharsbx($lamp_alt)."\" title=\"".htmlspecialcharsbx($lamp_alt)."\" />";

		$idTmp .= "</td><td><b><a ";

		if ($arOrder['MARKED'] == 'Y')
		{
			$idTmp .= 'style="color: red;"';
		}

		$href = $link
			->create()
			->setFilterParams(GetFilterParams("filter_"))
			->fill()
			->setField('ID', $orderId)
			->setPageByType(Admin\Registry::SALE_ORDER_VIEW)
			->build();

		$idTmp .=" href='".$href."' title='".Loc::getMessage("SALE_DETAIL_DESCR")."'>##ID##</a></b></td>";
		$idTmp .= "</tr>";

		if($isRecommended)
		{
			$idTmp .= "<tr>
				<td rowspan='2'>
					<div class='bx-adm-bigdata-icon-medium'></div>
				</td>
			</tr>";
		}

		$idTmp .= "</table>";
		$row->AddField("ID", str_replace('##ID##', Loc::getMessage("SO_ORDER_ID_PREF").$arOrder["ID"], $idTmp));

		//ACCOUNT_NUMBER
		$fieldValue = "";
		if(in_array("ACCOUNT_NUMBER", $arVisibleColumns))
		{
			$fieldValue = str_replace('##ID##', Loc::getMessage("SO_ORDER_ID_PREF").htmlspecialcharsbx($arOrder["ACCOUNT_NUMBER"]), $idTmp);
		}
		$row->AddField("ACCOUNT_NUMBER", $fieldValue);

		//XML_ID
		$fieldValue = "";
		if(in_array("XML_ID", $arVisibleColumns))
		{
			$fieldValue = $arOrder["XML_ID"];
		}
		$row->AddField("XML_ID", $fieldValue);

		//LID
		$fieldValue = "";
		if(in_array("LID", $arVisibleColumns))
		{
			if(!isset($LOCAL_SITE_LIST_CACHE[$arOrder["LID"]])
				|| empty($LOCAL_SITE_LIST_CACHE[$arOrder["LID"]]))
			{
				$dbSite = CSite::GetByID($arOrder["LID"]);
				if($arSite = $dbSite->Fetch())
					$LOCAL_SITE_LIST_CACHE[$arOrder["LID"]] = htmlspecialcharsbx($arSite["NAME"]);
			}
			$fieldValue = "[".$arOrder["LID"]."] ".$LOCAL_SITE_LIST_CACHE[$arOrder["LID"]];
		}
		$row->AddField("LID", $fieldValue);

		//PERSON_TYPE
		$fieldValue = "";
		if(in_array("PERSON_TYPE", $arVisibleColumns))
		{
			if(!isset($LOCAL_PERSON_TYPE_CACHE[$arOrder["PERSON_TYPE_ID"]])
				|| empty($LOCAL_PERSON_TYPE_CACHE[$arOrder["PERSON_TYPE_ID"]]))
			{
				if($arPersonType = CSalePersonType::GetByID($arOrder["PERSON_TYPE_ID"]))
					$LOCAL_PERSON_TYPE_CACHE[$arOrder["PERSON_TYPE_ID"]] = htmlspecialcharsbx($arPersonType["NAME"]);
			}
			$fieldValue = "[";
			if($saleModulePermissions >= "W")
				$fieldValue .= '<a href="/bitrix/admin/sale_person_type.php?lang='.LANGUAGE_ID.'">';
			$fieldValue .= $arOrder["PERSON_TYPE_ID"];
			if($saleModulePermissions >= "W")
				$fieldValue .= "</a>";
			$fieldValue .= "] ".$LOCAL_PERSON_TYPE_CACHE[$arOrder["PERSON_TYPE_ID"]];
		}
		$row->AddField("PERSON_TYPE", $fieldValue);

		//IS_SYNC_B24
		$fieldValue = "";
		if(in_array("IS_SYNC_B24", $arVisibleColumns))
		{
			$fieldValue .= '<span id="IS_SYNC_B24_'.$arOrder['ID'].'" style="'.(($arOrder["IS_SYNC_B24"] == "Y") ? "color: #ff2400;" : "").'" >'.(($arOrder["IS_SYNC_B24"] == "Y") ? Loc::getMessage("SO_YES") : Loc::getMessage("SO_NO"))."</span>";

			if($row->bEditMode != true)
			{
				$row->AddField("IS_SYNC_B24", $fieldValue);
			}
			else
			{
				$row->AddCheckField("IS_SYNC_B24");
			}
		}

		//PAYED
		$fieldValue = "";
		if(in_array("PAYED", $arVisibleColumns))
		{
			$fieldValue .= '<span id="payed_'.$arOrder['ID'].'">'.(($arOrder["PAYED"] == "Y") ? Loc::getMessage("SO_YES") : Loc::getMessage("SO_NO"))."</span>";
			$fieldValueTmp = $arOrder["DATE_PAYED"];
			if($arOrder["DATE_PAYED"] <> '')
			{
				if(intval($arOrder["EMP_PAYED_ID"]) > 0)
					$fieldValueTmp .= '<br />'.$formattedUserNames[$arOrder["EMP_PAYED_ID"]];

				if(!$bExport)
				{
					$sScript .= "
							new topWindow.BX.CHint({
								parent: topWindow.BX('payed_".$arOrder["ID"]."'),
								show_timeout: 10,
								hide_timeout: 100,
								dx: 2,
								preventHide: true,
								min_width: 250,
								hint: '".CUtil::JSEscape($fieldValueTmp)."'
							});
					";
				}
			}
		}
		$row->AddField("PAYED", $fieldValue);

		//CANCELED
		if($row->bEditMode != true
			|| $row->bEditMode == true && !CSaleOrder::CanUserCancelOrder($orderId, $arUserGroups, $intUserID))
		{
			$fieldValue = "";
			if(in_array("CANCELED", $arVisibleColumns))
			{
				$fieldValue .= '<span id="cancel_'.$arOrder['ID'].'">'.(($arOrder["CANCELED"] == "Y") ? Loc::getMessage("SO_YES") : Loc::getMessage("SO_NO"))."</span>";
				$fieldValueTmp = '';
				if ($arOrder['DATE_CANCELED'] instanceof Main\Type\DateTime)
				{
					$fieldValueTmp = $arOrder['DATE_CANCELED']->toString();
					if ($arOrder['DATE_CANCELED']->getTimestamp() > 0)
					{
						if ((int)$arOrder['EMP_CANCELED_ID'] > 0)
						{
							$fieldValueTmp .= '<br />' . $formattedUserNames[$arOrder["EMP_CANCELED_ID"]];
						}

						if (!$bExport)
						{
							$sScript .= "
							new topWindow.BX.CHint({
								parent: topWindow.BX('cancel_" . $arOrder["ID"] . "'),
								show_timeout: 10,
								hide_timeout: 100,
								dx: 2,
								preventHide: true,
								min_width: 250,
								hint: '" . CUtil::JSEscape($fieldValueTmp) . "'
							});
						";
						}
					}
				}
			}
			$row->AddField("CANCELED", $fieldValue, true);
		}
		else
		{
			$row->AddCheckField("CANCELED");
		}

		//STATUS
		if(in_array("STATUS", $arVisibleColumns))
		{
			if($row->bEditMode == true)
			{
				if($saleModulePermissions < "W")
				{
					$allowedStatusesFrom = \Bitrix\Sale\OrderStatus::getStatusesUserCanDoOperations($intUserID, array('from'));
					$isStatusAllowed = in_array($arOrder["STATUS_ID"], $allowedStatusesFrom);
				}
				else
				{
					$isStatusAllowed = true;
				}
			}

			if($row->bEditMode != true
				|| $row->bEditMode == true && !$isStatusAllowed)
			{
				$fieldValue = "";
				if (in_array("STATUS", $arVisibleColumns))
				{
					if (empty($LOCAL_STATUS_CACHE[$arOrder["STATUS_ID"]]))
					{
						$arStatus =  StatusTable::getList(array(
							'select' => array(
								'NAME' => 'Bitrix\Sale\Internals\StatusLangTable:STATUS.NAME',
								'COLOR'
							),
							'filter' => array(
								'=ID' => $arOrder["STATUS_ID"],
								'=Bitrix\Sale\Internals\StatusLangTable:STATUS.LID' => LANGUAGE_ID,
								'=TYPE' => 'O'
							),
							'limit'  => 1,
						))->fetch();

						if($arStatus)
						{
							$LOCAL_STATUS_CACHE[$arOrder["STATUS_ID"]]['NAME'] = htmlspecialcharsbx($arStatus["NAME"]);
							$LOCAL_STATUS_CACHE[$arOrder["STATUS_ID"]]['COLOR'] = htmlspecialcharsbx($arStatus["COLOR"]);
						}
					}
					$fieldValue .= "[";
					if($saleModulePermissions >= "W")
						$fieldValue .= '<a href="/bitrix/admin/sale_status_edit.php?ID='.$arOrder["STATUS_ID"].'&lang='.LANGUAGE_ID.'">';
					$fieldValue .= $arOrder["STATUS_ID"];
					if($saleModulePermissions >= "W")
						$fieldValue .= "</a>";

					$fieldValue .= "] ".$LOCAL_STATUS_CACHE[$arOrder["STATUS_ID"]]['NAME']."<br />";

					$fieldValue .= $arOrder["DATE_STATUS"];

					if(intval($arOrder["EMP_STATUS_ID"]) > 0)
						$fieldValue .= '<br />'.$formattedUserNames[$arOrder["EMP_STATUS_ID"]];
					$fieldValue .= "</div>";
				}
				$colorRGB = array();
				$colorRGB = sscanf($LOCAL_STATUS_CACHE[$arOrder["STATUS_ID"]]['COLOR'], "#%02x%02x%02x");
				if (is_array($colorRGB) && count($colorRGB))
				{
					$color = "background:rgba(".$colorRGB[0].",".$colorRGB[1].",".$colorRGB[2].",0.6);";
					$fieldValue = '<div style=	"'.$color.'
									margin: -11px 0 -10px -16px;
									padding: 11px 10px 10px 16px;
									min-height: 100%;
								">'.$fieldValue."</div>";
				}
				$row->AddField("STATUS", $fieldValue, true);
			}
			else
			{
				if($row->VarsFromForm() && $_REQUEST["FIELDS"])
					$val = $_REQUEST["FIELDS"][$orderId]["STATUS_ID"];
				else
					$val = $arOrder['STATUS_ID'];

				$fieldValue = '<select name="FIELDS['.$orderId.'][STATUS_ID]">';

				$statusesList = \Bitrix\Sale\OrderStatus::getAllowedUserStatuses(
					$USER->GetID(),
					\Bitrix\Sale\OrderStatus::getInitialStatus()
				);

				foreach($statusesList as $statusId => $statusName)
					$fieldValue .= '<option value="'.$statusId.'"'.(($statusId == $val) ? " selected" : "").">[".$statusId."] ".htmlspecialcharsbx($statusName)."</option>";

				$fieldValue .= "</select>";
				$row->AddEditField("STATUS", $fieldValue);
			}
		}

		//STATUS_ID
		if(in_array("STATUS_ID", $arVisibleColumns))
		{
			$arStatusList = false;
			if($row->bEditMode)
			{
				if($saleModulePermissions < "W")
				{
					$allowedStatusesFrom = \Bitrix\Sale\OrderStatus::getStatusesUserCanDoOperations($intUserID, array('from'));
					$isStatusAllowed = in_array($arOrder["STATUS_ID"], $allowedStatusesFrom);
				}
				else
				{
					$isStatusAllowed = true;
				}
			}

			if($row->bEditMode !== true
				|| $row->bEditMode && !$isStatusAllowed)
			{
				$fieldValue = "";
				$fieldValueTmp = "";
				if (in_array("STATUS_ID", $arVisibleColumns))
				{
					if (empty($LOCAL_STATUS_CACHE[$arOrder["STATUS_ID"]]))
					{
						$arStatus =  StatusTable::getList(array(
							'select' => array(
								'NAME' => 'Bitrix\Sale\Internals\StatusLangTable:STATUS.NAME',
								'COLOR'
							),
							'filter' => array(
								'=ID' => $arOrder["STATUS_ID"],
								'=Bitrix\Sale\Internals\StatusLangTable:STATUS.LID' => LANGUAGE_ID,
								'=TYPE' => 'O'
							),
							'limit'  => 1,
						))->fetch();

						if($arStatus)
						{
							$LOCAL_STATUS_CACHE[$arOrder["STATUS_ID"]]['NAME'] = htmlspecialcharsbx($arStatus["NAME"]);
							$LOCAL_STATUS_CACHE[$arOrder["STATUS_ID"]]['COLOR'] = htmlspecialcharsbx($arStatus["COLOR"]);
						}
					}

					$fieldValueTmp .= "[";

					if($saleModulePermissions >= "W")
						$fieldValueTmp .= '<a href="/bitrix/admin/sale_status_edit.php?ID='.$arOrder["STATUS_ID"].'&lang='.LANGUAGE_ID.'">';

					$fieldValueTmp .= $arOrder["STATUS_ID"];

					if($saleModulePermissions >= "W")
						$fieldValueTmp .= "</a>";
					$fieldValue = '<span id="status_order_'.$arOrder["ID"].'">'.$LOCAL_STATUS_CACHE[$arOrder["STATUS_ID"]]['NAME'].'</span>';
					$fieldValueTmp .= "] ".$LOCAL_STATUS_CACHE[$arOrder["STATUS_ID"]]['NAME'];
					$colorRGB = array();
					$colorRGB = sscanf($LOCAL_STATUS_CACHE[$arOrder["STATUS_ID"]]['COLOR'], "#%02x%02x%02x");
					if (is_array($colorRGB) && count($colorRGB))
					{
						$color = "background:rgba(".$colorRGB[0].",".$colorRGB[1].",".$colorRGB[2].",0.6);";
						$fieldValue = '<div style=	"'.$color.'
									margin: -11px 0 -10px -16px;
									padding: 11px 10px 10px 16px;
									min-height: 100%;
								">'.$fieldValue."</div>";
					}


					if(intval($arOrder["EMP_STATUS_ID"]) > 0)
						$fieldValueTmp .= '<br />'.$formattedUserNames[$arOrder["EMP_STATUS_ID"]];

					if(!$bExport)
					{
						$sScript .= "
							new topWindow.BX.CHint({
								parent: topWindow.BX('status_order_".$arOrder["ID"]."'),
								show_timeout: 10,
								hide_timeout: 100,
								dx: 2,
								preventHide: true,
								min_width: 250,
								hint: '".CUtil::JSEscape($fieldValueTmp)."'
							});
						";
					}
				}

				$row->AddField("STATUS_ID", $fieldValue, true);
			}
			else
			{
				if($row->VarsFromForm() && $_REQUEST["FIELDS"])
					$val = $_REQUEST["FIELDS"][$orderId]["STATUS_ID"];
				else
					$val = $arOrder['STATUS_ID'];

				static $proxyStatusList = array();
				$arStatusList = Array();

				if (array_key_exists($USER->GetID(), $proxyStatusList))
				{
					$arStatusList = $proxyStatusList[$USER->GetID()];
				}
				else
				{
					$statusesList = \Bitrix\Sale\OrderStatus::getAllowedUserStatuses(
						$USER->GetID(),
						\Bitrix\Sale\OrderStatus::getInitialStatus()
					);

					$proxyStatusList[$USER->GetID()] = $statusesList;
				}

				foreach($statusesList as $statusId => $statusName)
					$arStatusList[$statusId] = "[".$statusId."] ".$statusName;

				$row->AddSelectField("STATUS_ID", $arStatusList);
			}
		}

		if (in_array("PRICE_DELIVERY", $arVisibleColumns))
		{
			$row->AddField("PRICE_DELIVERY", '<span style="white-space:nowrap;">' . SaleFormatCurrency($arOrder["PRICE_DELIVERY"], $arOrder["CURRENCY"]) . '</span>');
		}

		//MARKED
		$fieldValue = "";
		if(in_array("MARKED", $arVisibleColumns))
		{
			$fieldValue .= '<span id="MARKED_'.$arOrder['ID'].'" style="'.(($arOrder["MARKED"] == "Y") ? "color: #ff2400;" : "").'" >'.(($arOrder["MARKED"] == "Y") ? Loc::getMessage("SO_YES") : Loc::getMessage("SO_NO"))."</span>";
			$fieldValueTmp = $arOrder["DATE_MARKED"];
			if($arOrder["DATE_MARKED"] <> '')
			{
				if(intval($arOrder["EMP_MARKED_ID"]) > 0)
					$fieldValueTmp .= '<br />'.$formattedUserNames[$arOrder["EMP_MARKED_ID"]];

				if($arOrder["MARKED"] == "Y" && isset($arOrder["REASON_MARKED"]) && $arOrder["REASON_MARKED"] <> '')
				{
					$fieldValueTmp .= "<br/>".$arOrder["REASON_MARKED"];
				}

				if(!$bExport)
				{
					$sScript .= "
							new topWindow.BX.CHint({
								parent: topWindow.BX('MARKED_".$arOrder["ID"]."'),
								show_timeout: 10,
								hide_timeout: 100,
								dx: 2,
								preventHide: true,
								min_width: 250,
								hint: '".CUtil::JSEscape($fieldValueTmp)."'
							});
					";
				}
			}
		}
		$row->AddField("MARKED", $fieldValue);

		$fieldValue = "";
		if(in_array("REASON_MARKED", $arVisibleColumns))
			$fieldValue = '<span id="REASON_MARKED_'.$arOrder["ID"].'" style="'.(($arOrder["MARKED"] == "Y") ? "color: #ff2400;" : "").'" >'.(($arOrder["MARKED"] == "Y") ? htmlspecialcharsbx($arOrder["REASON_MARKED"]) : "")."</span>";

		$row->AddField("REASON_MARKED", $fieldValue);

		$row->AddField("PRICE", '<span style="white-space:nowrap;">'.SaleFormatCurrency($arOrder["PRICE"], $arOrder["CURRENCY"]).'</span>');

		if (in_array("SUM_PAID", $arVisibleColumns))
		{
			$row->AddField("SUM_PAID", '<span style="white-space:nowrap;">'.SaleFormatCurrency($arOrder["SUM_PAID"], $arOrder["CURRENCY"]).'</span>');
		}

		$fieldValue = "";

		if(in_array("USER", $arVisibleColumns))
		{
			$fieldValue = GetFormatedUserName($arOrder["USER_ID"], false, false);
			if($link->getType() == Admin\ModeType::APP_LAYOUT_TYPE)
			{
				$fieldValue = strip_tags($fieldValue);
			}
		}

		$row->AddField("USER", $fieldValue);

		$paySystemsFields = array("PAY_SYSTEM_ID", "PAY_SYSTEM", "PAYMENTS", "PAY_VOUCHER_NUM", "PAY_VOUCHER_DATE", "PS_STATUS", "PS_SUM");
		$shipmentFields = array_intersect($arVisibleColumns, $paySystemsFields);
		if(!empty($shipmentFields))
		{
			$payments = array();
			/** @var \Bitrix\Main\DB\Result $res */
			$res = \Bitrix\Sale\Internals\PaymentTable::getList(array(
				'order' => array('ID' => 'ASC'),
				'filter' => array('ORDER_ID' => $arOrder['ID'])
			));
			while($payment = $res->fetch())
			{
				$href = $link
					->create()
					->setFilterParams(false)
					->fill()
					->setField('order_id', $arOrder['ID'])
					->setField('payment_id', $payment["ID"])
					->setPageByType(Admin\Registry::SALE_ORDER_PAYMENT_EDIT)
					->build();

				$payment["ID_LINKED"] = '[<a href="'.$href.'">'.$payment["ID"].'</a>]';
				$payments[] = $payment;
			}
			unset($payment, $res);

			//PAYMENTS
			$fieldValue = "";
			if(in_array("PAYMENTS", $arVisibleColumns))
			{
				$paymentCount = count($payments);
				foreach($payments as $payment)
				{
					if ($saleModulePermissions == 'P')
					{
						$isPaymentUserResponsible = false;
						if ($arOrder['RESPONSIBLE_ID'] == $USER->GetID()
							|| $payment['RESPONSIBLE_ID'] == $USER->GetID())
						{
							$isPaymentUserResponsible = true;
						}

						if (!$isPaymentUserResponsible && !in_array($payment['COMPANY_ID'], $userCompanyList))
						{
							$payment["PAY_SYSTEM_NAME"] = Loc::getMessage('SALE_ORDER_HIDDEN');
						}
					}

					$fieldValue .= $payment["ID_LINKED"].", ".
						htmlspecialcharsbx($payment["PAY_SYSTEM_NAME"]).", ".
						($payment["PAID"] == "Y" ? Loc::getMessage("SOA_PAYMENTS_PAID") :  Loc::getMessage("SOA_PAYMENTS_UNPAID")).", ".
						($payment["PS_STATUS"] <> '' ? Loc::getMessage("SOA_PAYMENTS_STATUS").": ".htmlspecialcharsbx($payment["PS_STATUS"]).", " : "").
						'<span style="white-space:nowrap;">'.SaleFormatCurrency($payment["SUM"], $payment["CURRENCY"]).'</span>';

					if($paymentCount > 1)
					{
						if ($bExport)
							$fieldValue .= "<br>";
						else
							$fieldValue .= "<hr>";
					}
				}
			}
			$row->AddField("PAYMENTS", $fieldValue);

			//PAY_SYSTEM
			$fieldValue = "";
			if(in_array("PAY_SYSTEM", $arVisibleColumns))
			{
				foreach($payments as $payment)
				{
					$tmp = "";

					if($saleModulePermissions >= "W")
						$tmp .= '<a href="/bitrix/admin/sale_pay_system_edit.php?ID='.$payment["PAY_SYSTEM_ID"].'&lang='.LANGUAGE_ID.'">';

					$tmp .= htmlspecialcharsbx($payment["PAY_SYSTEM_NAME"]);

					if($saleModulePermissions >= "W")
						$tmp .= "</a>";

					if(count($payments) > 1)
						$fieldValue .= $payment["ID_LINKED"].", ".$tmp."<hr>";
					else
						$fieldValue .= $tmp;
				}
			}
			$row->AddField("PAY_SYSTEM", $fieldValue);

			//PAY_VOUCHER_NUM
			$fieldValue = "";
			if(in_array("PAY_VOUCHER_NUM", $arVisibleColumns))
			{
				foreach($payments as $payment)
				{
					$tmp = htmlspecialcharsbx($payment["PAY_VOUCHER_NUM"]);

					if(count($payments) > 1)
						$fieldValue .= $payment["ID_LINKED"].", ".$tmp."<hr>";
					else
						$fieldValue .= $tmp;
				}
			}
			$row->AddField("PAY_VOUCHER_NUM", $fieldValue);

			//PAY_VOUCHER_DATE
			$fieldValue = "";
			if(in_array("PAY_VOUCHER_DATE", $arVisibleColumns))
			{
				foreach($payments as $payment)
				{
					$tmp = $payment["PAY_VOUCHER_DATE"];

					if(count($payments) > 1)
						$fieldValue .= $payment["ID_LINKED"].", ".$tmp."<hr>";
					else
						$fieldValue .= $tmp;
				}
			}
			$row->AddField("PAY_VOUCHER_DATE", $fieldValue);

			//PS_STATUS
			$fieldValue = "";
			if(in_array("PS_STATUS", $arVisibleColumns))
			{
				foreach($payments as $payment)
				{
					$tmp = "";

					if($payment["PS_STATUS"] == "Y")
						$tmp = Loc::getMessage("SO_SUCCESS")."<br />".$payment["PS_RESPONSE_DATE"];
					elseif($payment["PS_STATUS"] == "N")
						$tmp = Loc::getMessage("SO_UNSUCCESS")."<br />".$payment["PS_RESPONSE_DATE"];
					else
						$tmp = Loc::getMessage("SO_NONE");

					if(count($payments) > 1)
						$fieldValue .= $payment["ID_LINKED"].", ".$tmp."<hr>";
					else
						$fieldValue .= $tmp;
				}
			}
			$row->AddField("PS_STATUS", $fieldValue);

			//PS_SUM
			$fieldValue = "";
			if(in_array("PS_SUM", $arVisibleColumns))
			{
				foreach($payments as $payment)
				{
					$tmp = '<span style="white-space:nowrap;">'.htmlspecialcharsbx(SaleFormatCurrency(floatval($payment["PS_SUM"]), $payment["PS_CURRENCY"])).'</span>';

					if(count($payments) > 1)
						$fieldValue .= $payment["ID_LINKED"].", ".$tmp."<hr>";
					else
						$fieldValue .= $tmp;
				}
			}

			$row->AddField("PS_SUM", $fieldValue);
		}

		if (in_array("DATE_UPDATE", $arVisibleColumns))
		{
			$row->AddField("DATE_UPDATE", $arOrder["DATE_UPDATE"]);
		}

		if (in_array("TAX_VALUE", $arVisibleColumns))
		{
			$row->AddField("TAX_VALUE", '<span style="white-space:nowrap;">'.SaleFormatCurrency($arOrder["TAX_VALUE"], $arOrder["CURRENCY"]).'</span>');
		}

		//BASKET POSITIONS
		$fieldValue = "";
		$fieldName = "";
		$fieldQuantity = "";
		$fieldProductID = "";
		$fieldPrice = "";
		$fieldWeight = "";
		$fieldNotes = "";
		$fieldDiscountPrice = "";
		$fieldCatalogXML = "";
		$fieldProductXML = "";
		$fieldDiscountName  = "";
		$fieldDiscountValue  = "";
		$fieldVatRate  = "";

		if($bNeedBasket)
		{
			$bNeedLine = false;
			$arElementId = array();

			$parentItemFound = false;

			foreach ($arBasketItems as $arItem)
			{
				$arElementId[] = $arItem["PRODUCT_ID"];

				if(CSaleBasketHelper::isSetParent($arItem) || CSaleBasketHelper::isSetItem($arItem))
					$parentItemFound = true;
			}

			if($parentItemFound === true && !empty($arBasketItems) && is_array($arBasketItems))
				$arBasketItems = CSaleBasketHelper::reSortItems($arBasketItems);

			$arBasketItems = getMeasures($arBasketItems);
			$firstItem = true;
			$separator = "";

			foreach ($arBasketItems as $arItem)
			{
				$measure = (isset($arItem["MEASURE_TEXT"])) ? $arItem["MEASURE_TEXT"] : Loc::getMessage("SO_SHT");

				if($firstItem)
					$firstItem = false;
				else
					$bNeedLine = true;

				if($bNeedLine)
				{
					if(!CSaleBasketHelper::isSetItem($arItem))
						$separator = $basketSeparator;
					else
						$separator = $basketSetSeparator;
				}

				$fieldName .= $separator;
				$fieldQuantity .= $separator;
				$fieldProductID .= $separator;
				$fieldPrice .= $separator;
				$fieldWeight .= $separator;
				$fieldNotes .= $separator;
				$fieldDiscountPrice .= $separator;
				$fieldCatalogXML .= $separator;
				$fieldProductXML .= $separator;
				$fieldDiscountValue  .= $separator;
				$fieldVatRate  .= $separator;
				$hidden = "";
				$setItemClass = "";
				$linkClass = "";

				if($link->getType() == Admin\ModeType::APP_LAYOUT_TYPE)
				{
					$arItem["DETAIL_PAGE_URL"] = '';
				}

				if(CSaleBasketHelper::isSetItem($arItem))
				{
					$hidden = 'style="display:none"';
					$setItemClass = 'class="set_item_'.$arItem["SET_PARENT_ID"].'"';
					$linkClass = "set-item-link-name";
				}

				$fieldValue .= "<div ".$hidden. " ".$setItemClass.">";
				$fieldValue .= $bNeedLine ? $basketSeparator : '';

				if($arItem['RECOMMENDATION'])
					$fieldValue .= '<div class="bx-adm-bigdata-icon-medium-inner"></div>';

				$fieldValue .= "[".$arItem["PRODUCT_ID"]."] ";

				if(empty($arItem["DETAIL_PAGE_URL"]) || mb_strpos($arItem["DETAIL_PAGE_URL"], "http") === false)
				{
					$url = "//".$serverName[$arOrder["LID"]].htmlspecialcharsBack($arItem["DETAIL_PAGE_URL"]);
				}
				else
				{
					$url = htmlspecialcharsBack($arItem["DETAIL_PAGE_URL"]);
				}

				if($arItem["DETAIL_PAGE_URL"] <> '')
					$fieldValue .= '<a href="'.htmlspecialcharsbx($url).'" class="'.$linkClass.'">';
				$fieldValue .= htmlspecialcharsbx($arItem["NAME"]);
				if($arItem["DETAIL_PAGE_URL"] <> '')
					$fieldValue .= "</a>";

				$fieldValue .= " <nobr>(".Sale\BasketItem::formatQuantity($arItem["QUANTITY"])." ".htmlspecialcharsbx($measure).")</nobr>";

				if($bShowBasketProps)
				{
					if (!empty($basketPropertyList[$arItem["ID"]]) && is_array($basketPropertyList[$arItem["ID"]]))
					{
						foreach ($basketPropertyList[$arItem["ID"]] as $prop)
						{
							$fieldValue .= "<div><small>".htmlspecialcharsbx($prop["NAME"]).": ".htmlspecialcharsbx($prop["VALUE"])."</small></div>";
						}
					}
				}

				if(CSaleBasketHelper::isSetParent($arItem))
				{
					$fieldValue .= '<div class="set-link-block">';
					$fieldValue	.= '<a class="dashed-link show-set-link" href="javascript:void(0);" id="set_toggle_link_'.$arItem["ID"].'" onclick="fToggleSetItems('.$arItem["ID"].')">'.Loc::getMessage("SOA_SHOW_SET")."</a>";
					$fieldValue .= "</div>";
				}

				$fieldValue .= "</div>";

				if($arItem["NAME"] <> '')
				{
					$fieldName .= "<nobr>";
					if($arItem["DETAIL_PAGE_URL"] <> '')
						$fieldName .= '<a href="'.$url.'">';
					$fieldName .= htmlspecialcharsbx($arItem["NAME"]);
					if($arItem["DETAIL_PAGE_URL"] <> '')
						$fieldName .= "</a>";
					$fieldName .= "</nobr>";
				}
				else
					$fieldName .= "<br />";
				if($arItem["QUANTITY"] <> '')
					$fieldQuantity .= htmlspecialcharsbx(Sale\BasketItem::formatQuantity($arItem["QUANTITY"]))." ".htmlspecialcharsbx($measure);
				else
					$fieldQuantity .= "<br />";
				if($arItem["PRODUCT_ID"] <> '')
					$fieldProductID .= htmlspecialcharsbx($arItem["PRODUCT_ID"]);
				else
					$fieldProductID .= "<br />";
				if($arItem["PRICE"] <> '')
					$fieldPrice .= "<nobr>".SaleFormatCurrency($arItem["PRICE"], $arItem["CURRENCY"])."</nobr>";
				else
					$fieldPrice .= "<br />";
				if($arItem["WEIGHT"] <> '')
				{
					if((float)$WEIGHT_KOEF[$arOrder["LID"]] > 0)
						$fieldWeightCalc = (float)($arItem["WEIGHT"]/$WEIGHT_KOEF[$arOrder["LID"]]);
					else
						$fieldWeightCalc = (float)$arItem["WEIGHT"];
					if(!empty($arItem["QUANTITY"]))
					{
						$fieldWeightCalc *= $arItem["QUANTITY"];
					}
					$fieldWeight .= htmlspecialcharsbx(roundEx($fieldWeightCalc, SALE_WEIGHT_PRECISION).' '.$WEIGHT_UNIT[$arOrder["LID"]]);
				}
				else
					$fieldWeight .= "<br />";

				if (!CSaleBasketHelper::isSetItem($arItem))
				{
					$priceTypeName = \CSaleBasketHelper::getPriceTypeName($arItem);
					$fieldNotes .= $priceTypeName !== ''
						? $priceTypeName
						: '<br />';
				}

				if($arItem["DISCOUNT_PRICE"] <> '')
					$fieldDiscountPrice .= "<nobr>".SaleFormatCurrency($arItem["DISCOUNT_PRICE"], $arItem["CURRENCY"])."</nobr>";
				else
					$fieldDiscountPrice .= "<br />";
				if($arItem["CATALOG_XML_ID"] <> '')
					$fieldCatalogXML .= $arItem["CATALOG_XML_ID"];
				else
					$fieldCatalogXML .= "<br />";
				if($arItem["PRODUCT_XML_ID"] <> '')
					$fieldProductXML .= $arItem["PRODUCT_XML_ID"];
				else
					$fieldProductXML .= "<br />";
				if($arItem["DISCOUNT_VALUE"] <> '')
				{
					$fieldDiscountValue .= roundEx($arItem["DISCOUNT_VALUE"], 2);
					if(mb_strpos($arItem["DISCOUNT_VALUE"], "%") !== false)
						$fieldDiscountValue .= "%";
				}
				else
					$fieldDiscountValue .= "<br />";

				if($arItem["VAT_RATE"] <> '')
					$fieldVatRate .= $arItem["VAT_RATE"];
				else
					$fieldVatRate .= "<br />";
			}
			unset($arItem);
		}

		$row->AddField("BASKET", $fieldValue);
		$row->AddField("BASKET_NAME", $fieldName);
		$row->AddField("BASKET_QUANTITY", $fieldQuantity);
		$row->AddField("BASKET_PRODUCT_ID", $fieldProductID);
		$row->AddField("BASKET_PRICE", $fieldPrice);
		$row->AddField("BASKET_WEIGHT", $fieldWeight);
		$row->AddField("BASKET_NOTES", $fieldNotes);
		$row->AddField("BASKET_DISCOUNT_PRICE", $fieldDiscountPrice);
		$row->AddField("BASKET_CATALOG_XML_ID", $fieldCatalogXML);
		$row->AddField("BASKET_PRODUCT_XML_ID", $fieldProductXML);
		$row->AddField("BASKET_DISCOUNT_VALUE", $fieldDiscountValue);
		$row->AddField("BASKET_VAT_RATE", $fieldVatRate);

		if($bNeedProps)
		{
			/** @var \Bitrix\Sale\Order $propOrder */
			$propOrder = $orderClass::load($arOrder["ID"]);

			/** @var Bitrix\Sale\PropertyValue  $property */
			foreach($propOrder->getPropertyCollection() as $property)
			{
				$code = $property->getField("CODE");
				$colName = "PROP_".($code <> '' ? $code :  $property->getField("ORDER_PROPS_ID"));
				$row->AddField($colName, $property->getViewHtml());
			}
		}
		else
		{
			foreach (($arOrderProps + $arOrderPropsCode) as $key => $value)
				$row->AddField("PROP_".$key, "");
		}

		if (in_array("EXTERNAL_ORDER", $arVisibleColumns))
		{
			$row->AddField("EXTERNAL_ORDER", ($arOrder["EXTERNAL_ORDER"] != "Y" ? Loc::getMessage("SO_NO") : Loc::getMessage("SO_YES")));
		}

		//SHIPMENTS etc.
		$shipmentFields = array("SHIPMENTS", "ALLOW_DELIVERY", "DATE_ALLOW_DELIVERY", "DELIVERY", "DEDUCTED", "DELIVERY_DOC_NUM", "DELIVERY_DOC_DATE", "TRACKING_NUMBER");
		$shipmentFields = array_intersect($arVisibleColumns, $shipmentFields);
		if(!empty($shipmentFields))
		{
			$shipments = array();
			$res = \Bitrix\Sale\Internals\ShipmentTable::getList(array(
				'order' => array('ID' => 'ASC'),
				'filter' => array('ORDER_ID' => $arOrder['ID'], '!=SYSTEM' => 'Y')
			));

			while($shipment = $res->fetch())
			{
				$href = $link
					->create()
					->setFilterParams(false)
					->fill()
					->setField('order_id', $arOrder['ID'])
					->setField('shipment_id', $shipment["ID"])
					->setPageByType(Admin\Registry::SALE_ORDER_SHIPMENT_EDIT)
					->build();

				$shipment["ID_LINKED"] = '[<a href="'.$href.'"  title="'.Loc::getMessage('SALE_O_SHIPMENT_ID_TITLE', array('#SHIPMENT_ID#' => $shipment["ID"])).'">'.$shipment["ID"].'</a>]';
				$shipments[] = $shipment;
			}

			if(in_array("SHIPMENTS", $arVisibleColumns))
			{
				$fieldValue = "";

				if (empty($shipmentStatuses))
				{
					$dbRes = StatusTable::getList(array(
						'select' => array('ID', 'NAME' => 'Bitrix\Sale\Internals\StatusLangTable:STATUS.NAME'),
						'filter' => array(
							'=Bitrix\Sale\Internals\StatusLangTable:STATUS.LID' => LANGUAGE_ID,
							'=TYPE' => 'D'
						),
					));

					while ($shipmentStatus = $dbRes->fetch())
						$shipmentStatuses[$shipmentStatus["ID"]] = $shipmentStatus["NAME"]." [".$shipmentStatus["ID"]."]";
				}

				$shipmentCount = count($shipments);
				foreach($shipments as $shipment)
				{
					if ($saleModulePermissions == 'P')
					{
						$isShipmentUserResponsible = false;
						if ($arOrder['RESPONSIBLE_ID'] == $USER->GetID()
							|| $shipment['RESPONSIBLE_ID'] == $USER->GetID())
						{
							$isShipmentUserResponsible = true;
						}

						if (!$isShipmentUserResponsible && !in_array($shipment['COMPANY_ID'], $userCompanyList))
						{
							$shipment["DELIVERY_NAME"] = Loc::getMessage('SALE_ORDER_HIDDEN');
							$shipment["TRACKING_NUMBER"] = Loc::getMessage('SALE_ORDER_HIDDEN');
						}
					}

					$fieldValue .= $shipment["ID_LINKED"].", ".
						($shipment["DELIVERY_NAME"] <> '' ? htmlspecialcharsbx($shipment["DELIVERY_NAME"]).", " : "").
						'<span style="white-space:nowrap;">'.SaleFormatCurrency($shipment["PRICE_DELIVERY"], $shipment["CURRENCY"])."</span>, ".
						($shipment["ALLOW_DELIVERY"] == "Y" ? Loc::getMessage("SOA_SHIPMENTS_ALLOW_DELIVERY") : Loc::getMessage("SOA_SHIPMENTS_NOT_ALLOW_DELIVERY")).", ".
						($shipment["CANCELED"] == "Y" ? Loc::getMessage("SOA_SHIPMENTS_CANCELED").", " : "").
						($shipment["DEDUCTED"] == "Y" ? Loc::getMessage("SOA_SHIPMENTS_DEDUCTED").", " : "").
						($shipment["MARKED"] == "Y" ? Loc::getMessage("SOA_SHIPMENTS_MARKED").", " : "").
						($shipment["TRACKING_NUMBER"] <> '' ? htmlspecialcharsbx($shipment["TRACKING_NUMBER"]).", " : "");

					if($shipment["STATUS_ID"] <> '')
						$fieldValue .= $shipmentStatuses[$shipment["STATUS_ID"]] ? htmlspecialcharsbx($shipmentStatuses[$shipment["STATUS_ID"]]) : Loc::getMessage("SOA_SHIPMENTS_STATUS").": ".$shipment["STATUS_ID"];

					if($shipmentCount > 1)
					{
						if ($bExport)
							$fieldValue .= "<br>";
						else
							$fieldValue .= "<hr>";
					}
				}

				$row->AddField("SHIPMENTS", $fieldValue);
			}

			$fieldValue = '';

			foreach($shipments as $shipment)
				if(!empty($shipment["TRACKING_NUMBER"]))
					$fieldValue .= htmlspecialcharsbx($shipment["TRACKING_NUMBER"])."<br>";

			$row->AddField("TRACKING_NUMBER", $fieldValue);

			//ALLOW_DELIVERY
			$fieldValue = "";
			if(in_array("ALLOW_DELIVERY", $arVisibleColumns))
			{
				foreach($shipments as $shipment)
				{
					$tmp = '<span id="allow_deliv_'.$shipment["ID"].'">'.(($shipment["ALLOW_DELIVERY"] == "Y") ? Loc::getMessage("SO_YES") : Loc::getMessage("SO_NO"))."</span>";

					if(count($shipments) > 1)
						$fieldValue .=  $shipment["ID_LINKED"]." ".$tmp."<hr>";
					else
						$fieldValue .= $tmp;

					$fieldValueTmp = $shipment["DATE_ALLOW_DELIVERY"];
					if($shipment["DATE_ALLOW_DELIVERY"] <> '')
					{
						if(intval($shipment["EMP_ALLOW_DELIVERY_ID"]) > 0)
							$fieldValueTmp .= '<br />'.$formattedUserNames[$shipment["EMP_ALLOW_DELIVERY_ID"]];

						if(!$bExport)
						{
							$sScript .= "
								new topWindow.BX.CHint({
									parent: topWindow.BX('allow_deliv_".$shipment["ID"]."'),
									show_timeout: 10,
									hide_timeout: 100,
									dx: 2,
									preventHide: true,
									min_width: 250,
									hint: '".CUtil::JSEscape($fieldValueTmp)."'
								});
							";
						}
					}

					$row->AddField("ALLOW_DELIVERY", $fieldValue);
				}
			}

			//DATE_ALLOW_DELIVERY
			$fieldValue = "";
			foreach($shipments as $shipment)
			{
				$tmp = $shipment["DATE_ALLOW_DELIVERY"] <> '' ? $shipment["DATE_ALLOW_DELIVERY"] : Loc::getMessage("SO_NO");

				if(count($shipments) > 1)
					$fieldValue .= $shipment["ID_LINKED"]." ".$tmp."<hr>";
				else
					$fieldValue .= $tmp;
			}
			$row->AddField("DATE_ALLOW_DELIVERY", $fieldValue);

			//DELIVERY
			$fieldValue = "";
			if(in_array("DELIVERY", $arVisibleColumns))
			{
				foreach($shipments as $shipment)
				{
					$tmp = "";

					if($saleModulePermissions >= "W")
						$tmp .= '<a href="/bitrix/admin/sale_delivery_service_edit.php?ID='.$shipment["DELIVERY_ID"].'&lang='.LANGUAGE_ID.'">';

					$tmp .= htmlspecialcharsbx($shipment["DELIVERY_NAME"]);

					if($saleModulePermissions >= "W")
						$tmp .= "</a>";

					if(count($shipments) > 1)
						$fieldValue .= $shipment["ID_LINKED"]." ".$tmp."<hr>";
					else
						$fieldValue .= $tmp;
				}
			}

			$row->AddField("DELIVERY", $fieldValue);

			//DEDUCTED
			$fieldValue = "";
			if(in_array("DEDUCTED", $arVisibleColumns))
			{
				foreach($shipments as $shipment)
				{
					$tmp = '<span id="DEDUCTED_'.$shipment["ID"].'">'.(($shipment["DEDUCTED"] == "Y") ? Loc::getMessage("SO_YES") : Loc::getMessage("SO_NO"))."</span>";
					$fieldValue .= $shipment["ID_LINKED"]." ".$tmp;

					if(count($shipments) > 1)
						$fieldValue .= "<hr>";

					$fieldValueTmp = $shipment["DATE_DEDUCTED"];
					if($shipment["DATE_DEDUCTED"] <> '')
					{
						if(intval($shipment["EMP_DEDUCTED_ID"]) > 0)
							$fieldValueTmp .= '<br />'.$formattedUserNames[$shipment["EMP_DEDUCTED_ID"]];

						if(!$bExport)
						{
							$sScript .= "
								new topWindow.BX.CHint({
									parent: topWindow.BX('DEDUCTED_".$shipment["ID"]."'),
									show_timeout: 10,
									hide_timeout: 100,
									dx: 2,
									preventHide: true,
									min_width: 250,
									hint: '".CUtil::JSEscape($fieldValueTmp)."'
								});
						";
						}
					}
				}
			}
			$row->AddField("DEDUCTED", $fieldValue);

			//DELIVERY_DOC_NUM
			$fieldValue = "";
			foreach($shipments as $shipment)
			{
				$tmp = $shipment["DELIVERY_DOC_NUM"] <> '' ? htmlspecialcharsbx($shipment["DELIVERY_DOC_NUM"]) : Loc::getMessage("SO_NO");

				if(count($shipments) > 1)
					$fieldValue .= $shipment["ID_LINKED"]." ".$tmp."<hr>";
				else
					$fieldValue .= $tmp;
			}
			$row->AddField("DELIVERY_DOC_NUM", $fieldValue);

			//DELIVERY_DOC_DATE
			$fieldValue = "";
			foreach($shipments as $shipment)
			{
				$tmp = $shipment["DELIVERY_DOC_DATE"] <> '' ? $shipment["DELIVERY_DOC_DATE"] : Loc::getMessage("SO_NO");

				if(count($shipments) > 1)
					$fieldValue .= $shipment["ID_LINKED"]." ".$tmp."<hr>";
				else
					$fieldValue .= $tmp;
			}
			$row->AddField("DELIVERY_DOC_DATE", $fieldValue);
		}

		$row->AddViewField('BASKET_DISCOUNT_COUPON', ' ');
		$row->AddViewField('BASKET_DISCOUNT_NAME', ' ');

		if (in_array("SOURCE_NAME", $arVisibleColumns))
		{
			$row->AddViewField("SOURCE_NAME", '<span style="white-space:nowrap;">'.htmlspecialcharsbx($arOrder["SOURCE_NAME"]).'</span>');
		}

		//COMPANY_ID
		$fieldValue = "";
		if(in_array("COMPANY_ID", $arVisibleColumns) && intval($arOrder["COMPANY_ID"]) > 0)
		{
			$companyId = intval($arOrder["COMPANY_ID"]);
			$companyName = isset($companyListNames[$companyId]) ? '&nbsp;'.$companyListNames[$companyId] : '';

			$fieldValue = "[";
			if($saleModulePermissions >= "W")
				$fieldValue .= '<a href="/bitrix/admin/sale_company_edit.php?lang='.LANGUAGE_ID.'&ID='.$companyId.'">';

			$fieldValue .= $companyId;

			if($saleModulePermissions >= "W")
				$fieldValue .= "</a>";

			$fieldValue .= ']'.$companyName;
		}
		$row->AddField("COMPANY_ID", $fieldValue);

		//RESPONSIBLE_ID
		$fieldValue = "";
		if(in_array("RESPONSIBLE_ID", $arVisibleColumns))
		{
			if(intval($arOrder["RESPONSIBLE_ID"]) > 0)
				$fieldValue = $formattedUserNames[$arOrder["RESPONSIBLE_ID"]];
		}
		$row->AddField("RESPONSIBLE_ID", $fieldValue);


		//AFFILIATE
		$fieldValue = "";
		if(in_array("AFFILIATE_ID", $arVisibleColumns) && intval($arOrder["AFFILIATE_ID"]) > 0)
		{
			$affiliateId = intval($arOrder["AFFILIATE_ID"]);
			if (isset($affiliateCache[$affiliateId]))
			{
				$fieldValue = $affiliateCache[$affiliateId];
			}
			else
			{
				$affiliateRes = \CSaleAffiliate::GetList(
					array(),
					array("ID" => $affiliateId),
					false,
					false,
					array("ID", "USER_ID")
				);

				if($affiliateData = $affiliateRes->Fetch())
				{
					if (isset($formattedUserNames[$affiliateData["USER_ID"]]))
					{
						$fieldValue = $formattedUserNames[$affiliateData["USER_ID"]];
					}
					else
					{
						$fieldValue = GetFormatedUserName($affiliateData["USER_ID"], false, false);
						$formattedUserNames[$affiliateData["USER_ID"]] = $fieldValue;
					}

					$affiliateCache[$affiliateId] = $fieldValue;
				}
			}
		}
		$row->AddField("AFFILIATE_ID", $fieldValue);

		if($link->getType() == Admin\ModeType::APP_LAYOUT_TYPE)
		{
			//do nothing
		}
		else
		{
			$arActions = array();

			if(($arOrder['LOCK_STATUS'] == "red" && $saleModulePermissions >= "W") || $arOrder['LOCK_STATUS'] == "yellow")
			{
				$arActions[] = array(
					"ICON" => "unlock",
					"TEXT" => Loc::getMessage("IBEL_A_UNLOCK"),
					"TITLE" => Loc::getMessage("IBLOCK_UNLOCK_ALT"),
					"ACTION" => $lAdmin->ActionDoGroup($arOrder["ID"], "unlock", '')
				);
				$arActions[] = array("SEPARATOR" => true);
			}

			$arActions[] = array("ICON"=>"view", "TEXT"=>Loc::getMessage("SALE_DETAIL_DESCR"), "ACTION"=>$lAdmin->ActionRedirect("sale_order_view.php?ID=".$orderId."&lang=".LANGUAGE_ID.GetFilterParams("filter_")), "DEFAULT"=>true);
			$arActions[] = array("ICON"=>"copy", "TEXT"=>Loc::getMessage("SOA_ORDER_COPY"), "ACTION"=>$lAdmin->ActionRedirect("sale_order_create.php?ID=".$orderId."&lang=".LANGUAGE_ID."&".'SITE_ID='.$arOrder['LID'].'&'.bitrix_sessid_get().GetFilterParams("filter_")));
			$arActions[] = array("ICON"=>"print", "TEXT"=>Loc::getMessage("SALE_PRINT_DESCR"), "ACTION"=>$lAdmin->ActionRedirect("sale_order_print.php?ID=".$orderId."&lang=".LANGUAGE_ID.GetFilterParams("filter_")));

			if($arOrder['LOCK_STATUS'] != "red")
			{
				if($saleModulePermissions >= "W" || !empty($permDeleteOrderList[$orderId]))
					$arActions[] = array("ICON"=>"", "TEXT"=>Loc::getMessage("SOAN_LIST_ARCHIVE"), "ACTION"=>"if(confirm('".Loc::getMessage('SALE_CONFIRM_ARCHIVE_MESSAGE')."')) ".$lAdmin->ActionDoGroup($arOrder['ID'], 'archive'));

				if (!empty($permUpdateOrderList[$orderId]))
				{
					$arActions[] = array("ICON"=>"edit", "TEXT"=>Loc::getMessage("SALE_OEDIT_DESCR"), "ACTION"=>$lAdmin->ActionRedirect("sale_order_edit.php?ID=".$orderId."&lang=".LANGUAGE_ID.GetFilterParams("filter_")));
				}

				if($saleModulePermissions == "W"
					|| $arOrder["PAYED"] != "Y" && !empty($permDeleteOrderList[$orderId]))
				{
					$arActions[] = array("SEPARATOR" => true);
					$arActions[] = array("ICON"=>"delete", "TEXT"=>Loc::getMessage("SALE_DELETE_DESCR"), "ACTION"=>"if(confirm('".Loc::getMessage('SALE_CONFIRM_DEL_MESSAGE')."')) ".$lAdmin->ActionDoGroup($orderId, "delete", GetFilterParams("filter_", false)));
				}
			}

			$row->AddActions($arActions);
		}
	}
}

if (!empty($rowsList))
{
	if (in_array('BASKET_DISCOUNT_NAME', $arVisibleColumns))
	{
		$discountList = array();
		$discountsIterator = Sale\Internals\OrderRulesTable::getList(array(
			'select' => array('ORDER_ID', 'DISCOUNT_NAME' => 'ORDER_DISCOUNT.NAME', 'DISCOUNT_ID' => 'ORDER_DISCOUNT.ID'),
			'filter' => array('@ORDER_ID' => array_keys($rowsList)),
			'order' => array('ORDER_ID' => 'ASC', 'ID' => 'ASC')
		));
		while ($discount = $discountsIterator->fetch())
		{
			$discount['ORDER_ID'] = (int)$discount['ORDER_ID'];
			$discount['DISCOUNT_ID'] = (int)$discount['DISCOUNT_ID'];
			$discount['DISCOUNT_NAME'] = (string)$discount['DISCOUNT_NAME'];
			if (!isset($discountList[$discount['ORDER_ID']]))
				$discountList[$discount['ORDER_ID']] = array();
			$discountList[$discount['ORDER_ID']][$discount['DISCOUNT_ID']] = ($discount['DISCOUNT_NAME'] != '' ? $discount['DISCOUNT_NAME'] : $discount['DISCOUNT_ID']);
		}
		unset($discount, $discountsIterator);
		if (!empty($discountList))
		{
			foreach ($discountList as $order => $orderDiscounts)
				$rowsList[$order]->AddViewField('BASKET_DISCOUNT_NAME', implode('<br><br>', $orderDiscounts));
			unset($order, $orderDiscounts);
		}
		unset($discountList);
	}
	if (in_array('BASKET_DISCOUNT_COUPON', $arVisibleColumns))
	{
		$couponsList = array();
		$couponsIterator = Sale\Internals\OrderCouponsTable::getList(array(
			'select' => array('ORDER_ID', 'COUPON'),
			'filter' => array('@ORDER_ID' => array_keys($rowsList)),
			'order' => array('ORDER_ID' => 'ASC', 'ID' => 'ASC')
		));
		while ($coupon = $couponsIterator->fetch())
		{
			$coupon['ORDER_ID'] = (int)$coupon['ORDER_ID'];
			if (!isset($couponsList[$coupon['ORDER_ID']]))
				$couponsList[$coupon['ORDER_ID']] = array();
			$couponsList[$coupon['ORDER_ID']][] = $coupon['COUPON'];
		}
		unset($coupon, $couponsIterator);
		if (!empty($couponsList))
		{
			foreach ($couponsList as $order => $coupons)
				$rowsList[$order]->AddViewField('BASKET_DISCOUNT_COUPON', implode('<br><br>', $coupons));
			unset($order, $coupons);
		}
		unset($couponsList);
	}
}
unset($rowsList);

$arFooterArray = array(
	array(
		"title" => Loc::getMessage('SOAN_FILTERED1').":",
		"value" => $dbOrderList->SelectedRowsCount()
	),
);

// recommendation summary
$rcmCount = 0;
$rcmValue = array();
$rcmValueCur = array();

$runtime = array(
	new \Bitrix\Main\Entity\ExpressionField('SUM', 'SUM(sale_internals_order.PRICE)')
);

if(!empty($runtimeFields) && is_array($runtimeFields))
	$runtime = 	array_merge($runtime, $runtimeFields);

$getListParamsSum = array(
	'order' => array("CURRENCY" => "ASC"),
	'filter' => $arFilterTmp,
	'group' => array("CURRENCY"),
	'select' => array("CURRENCY", "SUM"),
	'runtime' => $runtime
);

if($saleModulePermissions == "W")
{
	$dbOrderList = \Bitrix\Sale\Internals\OrderTable::getList($getListParamsSum);

	while ($arOrderList = $dbOrderList->fetch())
	{
		$arFooterArray[] = array(
			"title" => Loc::getMessage("SOAN_ITOG")." ".$arOrderList["CURRENCY"].":",
			"value" => SaleFormatCurrency($arOrderList["SUM"], $arOrderList["CURRENCY"])
		);
	}

	// recommendation summary
	$rcmFilter = $arFilterTmp;
	$rcmFilter['>BASKET.RECOMMENDATION'] = 0;

	$runtime = array(
		new \Bitrix\Main\Entity\ExpressionField('SUM', 'SUM(%s * %s)', array('BASKET.PRICE', 'BASKET.QUANTITY')),
		new \Bitrix\Main\Entity\ExpressionField('COUNT', 'COUNT(sale_internals_order.ID)')
	);

	if(!empty($runtimeFields) && is_array($runtimeFields))
		$runtime = 	array_merge($runtime, $runtimeFields);

	$getListParamsSum = array(
		'order' => array("BASKET.CURRENCY" => "ASC"),
		'filter' => $rcmFilter,
		'group' => array("BASKET.CURRENCY"),
		'select' => array(
			"BASKET_CURRENCY" => "BASKET.CURRENCY",
			"SUM",
			"COUNT"
		),
		'runtime' => $runtime
	);

	$dbOrderList = \Bitrix\Sale\Internals\OrderTable::getList($getListParamsSum);

	if($arOrderList = $dbOrderList->fetch())
	{
		$rcmCount += $arOrderList['COUNT'];

		while(!isset($rcmValueCur[$arOrderList["BASKET_CURRENCY"]]))
			$rcmValueCur[$arOrderList["BASKET_CURRENCY"]] = 0;

		$rcmValueCur[$arOrderList["BASKET_CURRENCY"]] += $arOrderList["SUM"];
	}
}
elseif ($saleModulePermissions < "W")
{
	// also count recommendation stats
	$arOrdersSum = array();

	$arGroupByTmp[] = 'BASKET.RECOMMENDATION';
	$arGroupByTmp[] = 'BASKET_PRICE_TOTAL';
	$arGroupByTmp[] = 'BASKET.CURRENCY';

	$orderFilter = array(
		'order' => array('ID' => 'asc'),
		'filter' => $arFilterTmp,
		'group' => $arGroupByTmp,
		'select' => array(
			'ID',
			'CURRENCY',
			'PRICE',
			'BASKET_PRICE_TOTAL',
			'BASKET_CURRENCY' => 'BASKET.CURRENCY',
			'BASKET_RECOMMENDATION' => 'BASKET.RECOMMENDATION',
		)
	);

	if (!empty($runtimeFields) && is_array($runtimeFields))
		$orderFilter['runtime'] = $runtimeFields;

	$dbOrderList = \Bitrix\Sale\Internals\OrderTable::getList($orderFilter);

	$previousId = 0;

	while ($arOrder = $dbOrderList->Fetch())
	{
		if($arOrder['ID'] != $previousId)
		{
			if(!array_key_exists($arOrder["CURRENCY"], $arOrdersSum))
				$arOrdersSum[$arOrder["CURRENCY"]] = 0;
			$arOrdersSum[$arOrder["CURRENCY"]] += $arOrder["PRICE"];

			$previousId = $arOrder['ID'];
		}

		// recommendation stats
		if($arOrder['BASKET_RECOMMENDATION'])
		{
			if(!array_key_exists($arOrder["BASKET_CURRENCY"], $rcmValueCur))
			{
				$rcmValueCur[$arOrder["BASKET_CURRENCY"]] = 0;
			}

			$rcmValueCur[$arOrder["BASKET_CURRENCY"]] += $arOrder["BASKET_PRICE_TOTAL"];
			$rcmCount++;
		}
	}

	// show summary
	if (COption::GetOptionString("sale", "show_order_sum", "N")=="Y")
	{
		foreach ($arOrdersSum as $key => $value)
		{
			$arFooterArray[] = array(
				"title" => Loc::getMessage("SOAN_ITOG")." ".$key.":",
				"value" => $value
			);
		}
	}
}

// recommendation stats
foreach ($rcmValueCur as $currency => $sum)
{
	$rcmValue[] = SaleFormatCurrency($sum, $currency);
}

$order_sum = "";
foreach($arFooterArray as $val)
{
	$order_sum .= $val["title"]." ".$val["value"]."<br />";
}

$arResult = array(
	'RECOMMENDATION_ORDERS_COUNT' => $rcmCount,
	'RECOMMENDATION_ORDERS_VALUE' => htmlspecialcharsEx(join(' / ', $rcmValue))
);

// prepare recommendation widget
$bigdataWidgetHtml = '';
if ($isCanUsePersonalization)
{
	ob_start();
	?>

		<div class="adm-c-bigdatabar-container">
			<div class="adm-c-bigdatabar-summ"><br />
<b>Fatal error</b>:  Uncaught Error: Class &quot;Loc&quot; not found in D:\ktt\ttepla.com\public_html\bitrix\modules\sale\admin\order.php:3355
Stack trace:
#0 {main}
  thrown in <b>D:\ktt\ttepla.com\public_html\bitrix\modules\sale\admin\order.php</b> on line <b>3355</b><br />