PHP CAdminResult::NavStart方法代码示例

            \Softbalance\Callback\CallbackTable::delete($ID);
        }
    }
}
$arFilter = array();
//if (!empty($find_user_id))
//	$arFilter["USER_ID"] = $find_user_id;
if (!empty($find_created_from)) {
    $arFilter[">=CREATED"] = $find_created_from;
}
if (!empty($find_created_to)) {
    $arFilter["<=CREATED"] = $find_created_to;
}
$myData = \Softbalance\Callback\CallbackTable::getList(array('filter' => $arFilter, 'order' => $arOrder));
$myData = new CAdminResult($myData, $listTableId);
$myData->NavStart();
$lAdmin->NavText($myData->GetNavPrint(GetMessage("MY_STAT_ADMIN_NAV")));
$cols = \Softbalance\Callback\CallbackTable::getMap();
$colHeaders = array();
foreach ($cols as $colId => $col) {
    $colHeaders[] = array("id" => $colId, "content" => $col["title"], "sort" => $colId, "default" => true);
}
$lAdmin->AddHeaders($colHeaders);
$visibleHeaderColumns = $lAdmin->GetVisibleHeaderColumns();
$arUsersCache = array();
$status = array("new" => GetMessage("SB_CALLBACK_STATUS_NEW"), "dialing" => GetMessage("SB_CALLBACK_STATUS_DIALING"), "completed" => GetMessage("SB_CALLBACK_STATUS_COMPLETED"));
while ($arRes = $myData->GetNext()) {
    $arRes["STATUS"] = $status[$arRes["STATUS"]];
    $row =& $lAdmin->AddRow($arRes["ID"], $arRes);
    $StatusHTML = '<select name="FIELDS[' . $arRes["ID"] . '][STATUS]">';
    foreach ($status as $key => $value) {

$arFilterFields = array('filter_iblock_type_id');
$oSort = new CAdminSorting($sTableID, "NAME", "asc");
$lAdmin = new CAdminList($sTableID, $oSort);
$lAdmin->InitFilter($arFilterFields);
$arFilter = array("IBLOCK_TYPE_ID" => $IBLOCK_TYPE_ID, "CHECK_PERMISSIONS" => "Y", "MIN_PERMISSION" => "R");
$arHeader = array();
$arHeader[] = array("id" => "ID", "content" => GetMessage("BX_MOD_CATALOG_ADMIN_CIS_HEAD_ID"), "sort" => "ID", "align" => "right", "default" => true);
$arHeader[] = array("id" => "IBLOCK_TYPE_ID", "content" => GetMessage("BX_MOD_CATALOG_ADMIN_CIS_HEAD_IBLOCK_TYPE_ID"), "sort" => "IBLOCK_TYPE_ID", "default" => true);
$arHeader[] = array("id" => "NAME", "content" => GetMessage("BX_MOD_CATALOG_ADMIN_CIS_HEAD_NAME"), "sort" => "NAME", "default" => true);
$arHeader[] = array("id" => "ACTIVE", "content" => GetMessage("BX_MOD_CATALOG_ADMIN_CIS_HEAD_ACTIVE"), "sort" => "ACTIVE");
$arHeader[] = array("id" => "XML_ID", "content" => GetMessage("BX_MOD_CATALOG_ADMIN_CIS_HEAD_XML_ID"), "sort" => "XML_ID");
$arHeader[] = array("id" => "CODE", "content" => GetMessage("BX_MOD_CATALOG_ADMIN_CIS_HEAD_CODE"), "sort" => "CODE");
$lAdmin->AddHeaders($arHeader);
$rsIBlocks = CIBlock::GetList(array($by => $order), $arFilter);
$rsIBlocks = new CAdminResult($rsIBlocks, $sTableID);
$rsIBlocks->NavStart();
$lAdmin->NavText($rsIBlocks->GetNavPrint(GetMessage("BX_MOD_CATALOG_ADMIN_CIS_NAV")));
while ($arRes = $rsIBlocks->GetNext()) {
    $row =& $lAdmin->AddRow($arRes["ID"], $arRes);
    $row->AddViewField("NAME", $arRes["NAME"] . "<input type=hidden name='n" . $arRes["ID"] . "' id='name_" . $arRes["ID"] . "' value='" . CUtil::JSEscape(htmlspecialcharsbx($arRes["NAME"])) . "'>");
    $row->AddViewField("IBLOCK_TYPE_ID", $arRes["IBLOCK_TYPE_ID"]);
    $row->AddCheckField("ACTIVE", false);
    $row->AddViewField("XML_ID", $arRes["XML_ID"]);
    $row->AddViewField("CODE", $arRes["CODE"]);
    $row->AddActions(array(array("DEFAULT" => "Y", "TEXT" => GetMessage("BX_MOD_CATALOG_ADMIN_CIS_SELECT"), "ACTION" => "javascript:SelEl('" . CUtil::JSEscape($arRes["ID"]) . "', '" . CUtil::JSEscape($arRes["NAME"]) . "')")));
}
$lAdmin->AddFooter(array(array("title" => GetMessage("BX_MOD_CATALOG_ADMIN_CIS_MAIN_ADMIN_LIST_SELECTED"), "value" => $rsIBlocks->SelectedRowsCount()), array("counter" => true, "title" => GetMessage("BX_MOD_CATALOG_ADMIN_CIS_MAIN_ADMIN_LIST_CHECKED"), "value" => "0")));
if ($boolMultiSelect) {
    $lAdmin->AddGroupActionTable(array(array("action" => "SelAll()", "value" => "select", "type" => "button", "name" => GetMessage("BX_MOD_CATALOG_ADMIN_CIS_SELECT"))), array("disable_action_target" => true));
}
$lAdmin->AddAdminContextMenu(array(), false);

    CAdminMessage::ShowMessage($actionErrorMessage);
    $lAdmin->EndPrologContent();
}
$arAddHeaders = array(array("id" => "ID", "content" => "ID", "sort" => "ID", "default" => true), array("id" => "DOCUMENT_NAME", "content" => GetMessage("BPATL_DOCUMENT_NAME"), "default" => false, "sort" => "DOCUMENT_NAME"), array("id" => "NAME", "content" => GetMessage("BPATL_NAME"), "sort" => "NAME", "default" => true), array("id" => "DESCRIPTION", "content" => GetMessage("BPATL_DESCR"), "default" => true, "sort" => "DESCRIPTION"), array("id" => "DESCRIPTION_FULL", "content" => GetMessage("BPATL_DESCR_FULL"), "default" => false, "sort" => "DESCRIPTION"), array("id" => "MODIFIED", "content" => GetMessage("BPATL_MODIFIED"), "sort" => "MODIFIED", "default" => true), array("id" => "OVERDUE_DATE", "content" => GetMessage("BPATL_OVERDUE_DATE"), "default" => false, "sort" => "OVERDUE_DATE"), array("id" => "WORKFLOW_STARTED", "content" => GetMessage("BPATL_STARTED"), "default" => false, "sort" => "WORKFLOW_STARTED"), array("id" => "WORKFLOW_STARTED_BY", "content" => GetMessage("BPATL_STARTED_BY"), "default" => false, "sort" => "WORKFLOW_STARTED_BY"), array("id" => "WORKFLOW_NAME", "content" => GetMessage("BPATL_WORKFLOW_NAME"), "default" => true, "sort" => "WORKFLOW_TEMPLATE_NAME"), array("id" => "WORKFLOW_STATE", "content" => GetMessage("BPATL_WORKFLOW_STATE"), "default" => true, "sort" => "WORKFLOW_STATE"));
if ($allowAdminAccess) {
    $arAddHeaders[] = array("id" => "USER", "content" => GetMessage("BPATL_USER"), "default" => true, "sort" => "USER_ID");
}
$lAdmin->AddHeaders($arAddHeaders);
$arVisibleColumns = $lAdmin->GetVisibleHeaderColumns();
$arSelectFields = array("ID", "WORKFLOW_ID", "ACTIVITY", "ACTIVITY_NAME", "MODIFIED", "OVERDUE_DATE", "NAME", "DESCRIPTION", "PARAMETERS", 'DOCUMENT_NAME', 'WORKFLOW_STARTED', 'WORKFLOW_STARTED_BY', 'OVERDUE_DATE', 'WORKFLOW_TEMPLATE_NAME', 'WORKFLOW_STATE');
if (in_array("USER", $arVisibleColumns) && $allowAdminAccess) {
    $arSelectFields[] = "USER_ID";
}
$dbResultList = CBPTaskService::GetList(array($by => $order), $arFilter, false, false, $arSelectFields);
$dbResultList = new CAdminResult($dbResultList, $sTableID);
$dbResultList->NavStart();
$lAdmin->NavText($dbResultList->GetNavPrint(GetMessage("BPATL_NAV")));
while ($arResultItem = $dbResultList->NavNext(true, "f_")) {
    $row =& $lAdmin->AddRow($f_ID . '_' . $f_USER_ID, $arResultItem);
    $s = $allowAdminAccess ? "&uid=" . intval($arResultItem["USER_ID"]) : "";
    $row->AddField("ID", '<a href="bizproc_task.php?id=' . $f_ID . $s . '&back_url=' . urlencode($APPLICATION->GetCurPageParam("lang=" . LANGUAGE_ID, array("lang"))) . '" title="' . GetMessage("BPATL_VIEW") . '">' . $f_ID . '</a>');
    $row->AddField("NAME", $f_NAME);
    $description = $f_DESCRIPTION;
    if (strlen($description) > 100) {
        $description = substr($description, 0, 97) . "...";
    }
    $row->AddField("DESCRIPTION", $description);
    $row->AddField("DESCRIPTION_FULL", $f_DESCRIPTION);
    $row->AddField("MODIFIED", $f_MODIFIED);
    $row->AddField("WORKFLOW_NAME", $f_WORKFLOW_TEMPLATE_NAME);
    $row->AddField("WORKFLOW_STATE", $f_WORKFLOW_STATE);

	$arData = array();
	foreach ($arHistoryData as $index => $arHistoryRecord)
		$arData[$index]  = $arHistoryRecord[$by];

	$arIds = array();
	foreach ($arHistoryData as $index => $arHistoryRecord)
		$arIds[$index]  = $arHistoryRecord["ID"];

	array_multisort($arData, constant("SORT_".ToUpper($order)), $arIds, constant("SORT_".ToUpper($order)), $arHistoryData);
}

$dbRes = new CDBResult;
$dbRes->InitFromArray($arHistoryData);

$dbRecords = new CAdminResult($dbRes, $sTableID_tab5);
$dbRecords->NavStart();
$lAdmin_tab5->NavText($dbRecords->GetNavPrint(GetMessage('SOD_HIST_LIST')));

$histdHeader = array(
	array("id"=>"DATE_CREATE", "content"=>GetMessage("SOD_HIST_H_DATE"), "sort"=>"DATE_CREATE", "default"=>true),
	array("id"=>"USER_ID", "content"=>GetMessage("SOD_HIST_H_USER"), "sort"=>"USER_ID", "default"=>true),
	array("id"=>"TYPE", "content"=>GetMessage("SOD_HIST_TYPE"), "sort"=>"TYPE", "default"=>true),
	array("id"=>"DATA", "content"=>GetMessage("SOD_HIST_DATA"), "sort"=>"", "default"=>true),
);

$lAdmin_tab5->AddHeaders($histdHeader);

$arOperations = array();
while ($arChangeRecord = $dbRecords->Fetch())
{
	$row =& $lAdmin_tab5->AddRow($arChangeRecord["ID"], $arChangeRecord, '', '');

 protected function getMixedList($arOrder = array("SORT" => "ASC"), $arFilter = array(), $bIncCnt = false, $arSelectedFields = false)
 {
     $arResult = array();
     $notFound = false;
     if (is_array($arFilter["S_ID"]) && sizeof($arFilter["S_ID"]) == 1) {
         $notFound = $arFilter['S_ID'][0] == 0;
     }
     if (!$notFound && !$this->isFiltering()) {
         $arSectionFilter = array("IBLOCK_ID" => $arFilter["IBLOCK_ID"], "=ID" => $arFilter["S_ID"], "?NAME" => $arFilter["NAME"], ">=TIMESTAMP_X" => $arFilter["DATE_MODIFY_FROM"], "<=TIMESTAMP_X" => $arFilter["DATE_MODIFY_TO"], "CODE" => $arFilter["CODE"], "ACTIVE" => $arFilter["ACTIVE"]);
         if (isset($arFilter["CHECK_PERMISSIONS"])) {
             $arSectionFilter['CHECK_PERMISSIONS'] = $arFilter["CHECK_PERMISSIONS"];
             $arSectionFilter['MIN_PERMISSION'] = isset($arFilter['MIN_PERMISSION']) ? $arFilter['MIN_PERMISSION'] : 'R';
         }
         if (array_key_exists("SECTION_ID", $arFilter)) {
             if (!array_key_exists("INCLUDE_SUBSECTIONS", $arFilter)) {
                 $arSectionFilter['SECTION_ID'] = $arFilter['SECTION_ID'];
             } elseif (!$this->isAdvancedSearchAvailable() && ($margin = $this->getSectionMargin($arFilter['SECTION_ID']))) {
                 $arSectionFilter['>LEFT_MARGIN'] = $margin['LEFT_MARGIN'];
                 $arSectionFilter['<RIGHT_MARGIN'] = $margin['RIGHT_MARGIN'];
                 $arSectionFilter['>DEPTH_LEVEL'] = $margin['DEPTH_LEVEL'];
             }
         }
         $obSection = new \CIBlockSection();
         $rsSection = $obSection->GetList($arOrder, $arSectionFilter, $bIncCnt);
         while ($arSection = $rsSection->Fetch()) {
             $arSection["TYPE"] = "S";
             $arResult[] = $arSection;
         }
     }
     $notFound = false;
     if (is_array($arFilter["ID"]) && sizeof($arFilter["ID"]) == 1) {
         $notFound = $arFilter['ID'][0] == 0;
     }
     if (!$notFound) {
         $arElementFilter = array("IBLOCK_ID" => $arFilter["IBLOCK_ID"], "?NAME" => $arFilter["NAME"], "SECTION_ID" => $arFilter["SECTION_ID"], "=ID" => $arFilter["ID"], ">=TIMESTAMP_X" => $arFilter["DATE_MODIFY_FROM"], "<=TIMESTAMP_X" => $arFilter["DATE_MODIFY_TO"], "CODE" => $arFilter["CODE"], "ACTIVE" => $arFilter["ACTIVE"], "WF_STATUS" => $arFilter["WF_STATUS"], 'INCLUDE_SUBSECTIONS' => $arFilter["INCLUDE_SUBSECTIONS"]);
         if (isset($arFilter["CHECK_PERMISSIONS"])) {
             $arElementFilter['CHECK_PERMISSIONS'] = $arFilter["CHECK_PERMISSIONS"];
             $arElementFilter['MIN_PERMISSION'] = isset($arFilter['MIN_PERMISSION']) ? $arFilter['MIN_PERMISSION'] : 'R';
         }
         foreach ($arFilter as $key => $value) {
             $op = \CIBlock::MkOperationFilter($key);
             $newkey = strtoupper($op["FIELD"]);
             if (substr($newkey, 0, 9) == "PROPERTY_" || substr($newkey, 0, 8) == "CATALOG_") {
                 $arElementFilter[$key] = $value;
             }
         }
         if (strlen($arFilter["SECTION_ID"]) <= 0) {
             unset($arElementFilter["SECTION_ID"]);
         }
         if (!is_array($arSelectedFields)) {
             $arSelectedFields = array("ID", "IBLOCK_ID", "IBLOCK_SECTION_ID", "ACTIVE", "SORT", "NAME", "PREVIEW_PICTURE", "PREVIEW_TEXT", "PREVIEW_TEXT_TYPE", "DETAIL_PICTURE", "DETAIL_TEXT", "DETAIL_TEXT_TYPE", "SHOW_COUNTER", "SHOW_COUNTER_START", "CODE", "EXTERNAL_ID");
         }
         if (isset($arFilter["CHECK_BP_PERMISSIONS"])) {
             $arElementFilter["CHECK_BP_PERMISSIONS"] = $arFilter["CHECK_BP_PERMISSIONS"];
         }
         $obElement = new \CIBlockElement();
         $rsElement = $obElement->GetList($arOrder, $arElementFilter, false, false, $arSelectedFields);
         while ($arElement = $rsElement->Fetch()) {
             $arElement["TYPE"] = "E";
             $arResult[] = $arElement;
         }
     }
     $rsResult = new \CDBResult();
     $rsResult->InitFromArray($arResult);
     if ($this->isAdminSection()) {
         $rsResult = new \CAdminResult($rsResult, $this->getTableId());
         $rsResult->NavStart();
     } else {
         $rsResult->NavStart($this->getGridOptions()->GetNavParams());
     }
     return $rsResult;
 }

			$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;
	}
}

$couponIterator = new CAdminResult(Internals\DiscountCouponTable::getList($getListParams), $adminListTableID);
if ($usePageNavigation)
{
	$couponIterator->NavStart($getListParams['limit'], $navyParams['SHOW_ALL'], $navyParams['PAGEN']);
	$couponIterator->NavRecordCount = $totalCount;
	$couponIterator->NavPageCount = $totalPages;
	$couponIterator->NavPageNomer = $navyParams['PAGEN'];
}
else
{
	$couponIterator->NavStart();
}

$adminList->NavText($couponIterator->GetNavPrint(Loc::getMessage('BT_SALE_DISCOUNT_COUPON_LIST_MESS_NAV')));
while ($coupon = $couponIterator->Fetch())
{
	$coupon['ID'] = (int)$coupon['ID'];
	$coupon['MAX_USE'] = (int)$coupon['MAX_USE'];
	$coupon['USE_COUNT'] = (int)$coupon['USE_COUNT'];

    $arHeaders[] = array("id" => "yesterday_back", "content" => GetMessage("STAT_YESTERDAY") . "<br>" . GetMessage("STAT_BACK"), "sort" => $full_list ? "s_counter_back_yestoday" : false, "align" => "right", "default" => true);
    $arHeaders[] = array("id" => "bef_yesterday", "content" => GetMessage("STAT_BEFYESTERDAY") . "<br>" . GetMessage("STAT_STRAIGHT"), "sort" => $full_list ? "s_counter_bef_yestoday" : false, "align" => "right", "default" => true);
    $arHeaders[] = array("id" => "bef_yesterday_back", "content" => GetMessage("STAT_BEFYESTERDAY") . "<br>" . GetMessage("STAT_BACK"), "sort" => $full_list ? "s_counter_back_bef_yestoday" : false, "align" => "right", "default" => true);
}
if ((strlen($find_date1_period) > 0 || strlen($find_date2_period) > 0) && $is_filtered) {
    $arHeaders[] = array("id" => "period", "content" => GetMessage("STAT_PERIOD") . "<br>" . GetMessage("STAT_STRAIGHT"), "sort" => $full_list ? "s_counter_period" : false, "align" => "right", "default" => true);
    $arHeaders[] = array("id" => "period_back", "content" => GetMessage("STAT_PERIOD") . "<br>" . GetMessage("STAT_BACK"), "sort" => $full_list ? "s_counter_back_period" : false, "align" => "right", "default" => true);
}
$arHeaders[] = array("id" => "total", "content" => GetMessage("STAT_TOTAL") . "<br>" . GetMessage("STAT_STRAIGHT"), "sort" => $full_list ? "s_counter" : false, "align" => "right", "default" => true);
$arHeaders[] = array("id" => "total_back", "content" => GetMessage("STAT_TOTAL") . "<br>" . GetMessage("STAT_BACK"), "sort" => $full_list ? "s_counter_back" : false, "align" => "right", "default" => true);
$lAdmin->AddHeaders($arHeaders);
if ($full_list) {
    $events = new CDBResult();
    $events->InitFromArray($arEvents);
    $rsData = new CAdminResult($events, $sTableID);
    $rsData->NavStart(10);
    $lAdmin->NavText($rsData->GetNavPrint(GetMessage("STAT_EVENTS")));
    while ($arRes = $rsData->NavNext(true, "e_")) {
        $row =& $lAdmin->AddRow($e_ID, $arRes);
        if ($show_events == "list") {
            $title = "ID = " . $e_ID;
            if (strlen($e_EVENT1) > 0) {
                $title .= "\nevent1 = " . $e_EVENT1;
            }
            if (strlen($e_EVENT2) > 0) {
                $title .= "\nevent2 = " . $e_EVENT2;
            }
            if (strlen($e_NAME) > 0) {
                $title .= "\n" . GetMessage("STAT_NAME") . " " . $e_NAME;
            }
            if (strlen($e_DESCRIPTION) > 0) {

    }
    foreach ($arID as $ID) {
        $ID = intval($ID);
        if ($ID <= 0) {
            continue;
        }
        switch ($_REQUEST['action']) {
            case "delete":
                \Xpage\Seofilter\PropertyTable::delete($ID);
                break;
        }
    }
}
$obGroups = \Xpage\Seofilter\PropertyTable::getList(['order' => ['ID' => 'ASC'], 'select' => ['ID', 'TITLE', 'SORT', 'PROPERTY_ID', 'PROPERTY_NAME' => 'PROPERTY.NAME']]);
$obGroups = new CAdminResult($obGroups, $listTableId);
$obGroups->NavStart();
$adminList->NavText($obGroups->GetNavPrint("Разделы"));
$colHeaders = [["id" => 'ID', "content" => 'ID', "sort" => 1, "default" => true], ["id" => 'TITLE', "content" => 'TITLE', "sort" => 2, "default" => true], ["id" => 'SORT', "content" => 'SORT', "sort" => 3, "default" => true], ["id" => 'PROPERTY_NAME', "content" => 'PROPERTY_NAME', "sort" => 4, "default" => true]];
$adminList->AddHeaders($colHeaders);
$visibleHeaderColumns = $adminList->GetVisibleHeaderColumns();
$arUsersCache = [];
while ($arRes = $obGroups->GetNext()) {
    $row =& $adminList->AddRow($arRes["ID"], $arRes);
    $arActions = [["ICON" => "delete", "TEXT" => "Удалить", "ACTION" => $adminList->ActionDoGroup($arRes["ID"], "delete")], ["ICON" => "edit", "TEXT" => "Редактировать", "ACTION" => $adminList->ActionRedirect("seofilter_property_edit.php?ID=" . $arRes["ID"] . "&lang=" . LANGUAGE_ID), "DEFAULT" => true], ["ICON" => "", "TEXT" => "Замена", "ACTION" => $adminList->ActionRedirect("seofilter_property_values_edit.php?ID=" . $arRes["PROPERTY_ID"] . "&lang=" . LANGUAGE_ID)]];
    $row->AddActions($arActions);
}
$adminList->AddFooter([["title" => "Всего", "value" => $obGroups->SelectedRowsCount()], ["counter" => true, "title" => "Отмечено", "value" => "0"]]);
$adminList->AddGroupActionTable(["delete" => "Удалить"]);
$aContext = [["TEXT" => GetMessage("MAIN_ADD"), "LINK" => "seofilter_property_edit.php", "TITLE" => GetMessage("POST_ADD_TITLE"), "ICON" => "btn_new"]];
$adminList->AddAdminContextMenu($aContext);
$adminList->CheckListMode();

        $elPath = $searchRes[$i]['path'];
        $fullPath = $_SERVER["DOCUMENT_ROOT"] . $elPath;
        $bIsDir = $io->DirectoryExists($fullPath);
        $arPerm = $APPLICATION->GetFileAccessPermission(array($site, $elPath), $USER->GetUserGroupArray(), true);
        $arEl = array("PATH" => $fullPath, "ABS_PATH" => $elPath, "NAME" => CFileman::GetFileName($elPath), "PERMISSION" => $arPerm[0], "TIMESTAMP" => $searchRes[$i]['time'], "DATE" => date($date_format, $searchRes[$i]['time']), "SIZE" => $bIsDir ? 0 : $searchRes[$i]['size'], "TYPE" => $bIsDir ? "D" : "F");
        if (count($arPerm[1]) > 0) {
            $arEl["PERMISSION_EX"] = $arPerm[1];
        }
        $arDirContent[] = $arEl;
    }
}
$db_DirContent = new CDBResult();
$db_DirContent->InitFromArray($arDirContent);
$db_DirContent->sSessInitAdd = $path;
$db_DirContent = new CAdminResult($db_DirContent, $sTableID);
$db_DirContent->NavStart(20);
// Init list params
$lAdmin->NavText($db_DirContent->GetNavPrint(GetMessage("FILEMAN_PAGES")));
// List header
if ($logical == 'Y') {
    $arHeaders = array(array("id" => "LOGIC_NAME", "content" => GetMessage("FILEMAN_FILE_NAME"), "default" => true), array("id" => "NAME", "content" => GetMessage("FILEMAN_REAL_FILE_NAME"), "sort" => "name"), array("id" => "SIZE", "content" => GetMessage("FILEMAN_ADMIN_FILE_SIZE"), "sort" => "size", "default" => true), array("id" => "DATE", "content" => GetMessage('FILEMAN_ADMIN_FILE_TIMESTAMP'), "sort" => "timestamp", "default" => true), array("id" => "TYPE", "content" => GetMessage('FILEMAN_ADMIN_FILE_TYPE'), "sort" => "", "default" => true));
} else {
    $arHeaders = array(array("id" => "NAME", "content" => GetMessage("FILEMAN_FILE_NAME"), "sort" => "name", "default" => true), array("id" => "SIZE", "content" => GetMessage("FILEMAN_ADMIN_FILE_SIZE"), "sort" => "size", "default" => true), array("id" => "DATE", "content" => GetMessage('FILEMAN_ADMIN_FILE_TIMESTAMP'), "sort" => "timestamp", "default" => true), array("id" => "TYPE", "content" => GetMessage('FILEMAN_ADMIN_FILE_TYPE'), "sort" => "", "default" => true));
}
if (!CFileMan::IsWindows()) {
    $arHeaders[] = array("id" => "PERMS", "content" => GetMessage('FILEMAN_ADMIN_ACCESS_PERMS'), "sort" => "", "default" => true);
}
$arHeaders[] = array("id" => "PERMS_B", "content" => GetMessage('FILEMAN_ADMIN_ACCESS_PERMS_B'), "sort" => "", "default" => true);
$lAdmin->AddHeaders($arHeaders);
if (IntVal($show_perms_for) > 0) {
    $lAdmin->AddVisibleHeaderColumn("PERMS_B");

 function NavStart($nPageSize = 20, $bShowAll = true, $iNumPage = false)
 {
     $nSize = CAdminSubResult::GetNavSize($this->table_id, $nPageSize, $this->list_url . ('' != $this->list_url_params ? '?' . $this->list_url_params : ''));
     if (!is_array($nPageSize)) {
         $nPageSize = array();
     }
     $nPageSize["nPageSize"] = $nSize;
     if ($_REQUEST["mode"] == "excel") {
         $nPageSize["NavShowAll"] = true;
     }
     $this->nInitialSize = $nPageSize["nPageSize"];
     parent::NavStart($nPageSize, $bShowAll, $iNumPage);
 }

    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%">';
if ($bExport) {
    $basketSeparator = "<br>";
}

$errorMessage = "";
$arModules = CUpdateClientPartner::SearchModulesEx(array($by => $order), $arFilter, intval($_REQUEST["PAGEN_1"]) > 0 ? intval($_REQUEST["PAGEN_1"]) : 1, LANG, $errorMessage);
if (strlen($errorMessage) > 0) {
    $lAdmin->AddGroupError($errorMessage, 0);
}
$arResultListTmp = array();
if (is_array($arModules["MODULE"])) {
    foreach ($arModules["MODULE"] as $module) {
        $arResultListTmp[] = $module["@"];
    }
}
$dbResultList = new CDBResult();
$dbResultList->InitFromArray($arResultListTmp);
//echo "<pre>!1!<br>";print_r($arModules);echo "</pre>";
$dbResultList = new CAdminResult($dbResultList, $sTableID);
$dbResultList->NavStart(array("bShowAll" => false, "nPageSize" => 20));
$lAdmin->NavText($dbResultList->GetNavPrint(GetMessage("USMP_MODULES")));
$lAdmin->AddHeaders(array(array("id" => "IMAGE", "content" => GetMessage("USMP_H_IMAGE"), "sort" => "", "default" => true), array("id" => "ID", "content" => GetMessage("USMP_H_ID"), "sort" => "CODE", "default" => true), array("id" => "NAME", "content" => GetMessage("USMP_H_NAME"), "sort" => "NAME", "default" => true), array("id" => "DESCRIPTION", "content" => GetMessage("USMP_H_DESCR"), "default" => true), array("id" => "PARTNER", "content" => GetMessage("USMP_H_PARTNER"), "default" => true), array("id" => "DATE_UPDATE", "content" => GetMessage("USMP_H_DATE_UPDATE"), "sort" => "DATE_UPDATE", "default" => true), array("id" => "DATE_CREATE", "content" => GetMessage("USMP_H_DATE_CREATE"), "sort" => "DATE_CREATE", "default" => false), array("id" => "CATEGORY", "content" => GetMessage("USMP_H_CAT"), "default" => false), array("id" => "TYPE", "content" => GetMessage("USMP_H_TYPE"), "default" => false), array("id" => "LOADED", "content" => GetMessage("USMP_H_LOADED"), "default" => true)));
$arVisibleColumns = $lAdmin->GetVisibleHeaderColumns();
while ($arResultItem = $dbResultList->Fetch()) {
    $row =& $lAdmin->AddRow($arResultItem["ID"], $arResultItem);
    $row->AddField("ID", '<a href="update_system_market_detail.php?id=' . $arResultItem["ID"] . '&' . GetFilterParams("filter_") . '" title="' . GetMessage("USMP_VIEW") . '">' . $arResultItem["ID"] . '</a>');
    $row->AddField("NAME", $arResultItem["NAME"]);
    $row->AddField("DESCRIPTION", nl2br($arResultItem["DESCRIPTION"]));
    $row->AddField("DATE_UPDATE", $arResultItem["DATE_UPDATE"]);
    $row->AddField("DATE_CREATE", $arResultItem["DATE_CREATE"]);
    $row->AddField("PARTNER", $arResultItem["PARTNER"]);
    $strImage = "";
    if (strlen($arResultItem["IMAGE"]) > 0) {
        $strImage = '<img src="' . $arResultItem["IMAGE"] . '" width="' . $arResultItem["IMAGE_WIDTH"] . '" height="' . $arResultItem["IMAGE_HEIGHT"] . '">';
    }

 CAdminMessage::ShowNote($basketMessage);
 CAdminMessage::ShowMessage($basketError);
 //update price
 $arCacheFuser = array();
 $arUpdateFilter = $arBasketFilter;
 $arUpdateFilter["!CALLBACK_FUNC"] = '';
 $dbBasketList = \Bitrix\Sale\Internals\BasketTable::getList(array('order' => $arBasketSort, 'filter' => $arUpdateFilter, 'select' => array('FUSER_ID', 'LID')));
 while ($arBasket = $dbBasketList->fetch()) {
     if (!in_array($arBasket["FUSER_ID"], $arCacheFuser)) {
         $arCacheFuser[] = $arBasket["FUSER_ID"];
         CSaleBasket::UpdateBasketPrices($arBasket["FUSER_ID"], $arBasket["LID"]);
     }
 }
 $dbBasketList = \Bitrix\Sale\Internals\BasketTable::getList(array('order' => array_merge(array("SET_PARENT_ID" => "DESC", "TYPE" => "DESC"), $arBasketSort), 'filter' => $arBasketFilter));
 $dbBasketList = new CAdminResult($dbBasketList, $sTableID_tab4);
 $dbBasketList->NavStart();
 $lAdmin_tab4->NavText($dbBasketList->GetNavPrint(GetMessage('BUYER_BASKET_BASKET')));
 $BasketHeader = array(array("id" => "DATE_INSERT", "content" => GetMessage("BUYER_BH_DATE_INSERT"), "sort" => "DATE_INSERT", "default" => true), array("id" => "NAME", "content" => GetMessage("BUYER_BH_NAME"), "sort" => "NAME", "default" => true), array("id" => "DELAY", "content" => GetMessage("BUYER_BH_DELAY"), "sort" => "DELAY", "default" => true), array("id" => "PRICE", "content" => GetMessage("BUYER_BH_PRICE"), "sort" => "PRICE", "default" => true), array("id" => "QUANTITY", "content" => GetMessage("BUYER_BH_QUANTITY"), "sort" => "QUANTITY", "default" => true));
 if (count($arSites) > 1) {
     $BasketHeader[] = array("id" => "LID", "content" => GetMessage("BUYER_BH_LID"), "sort" => "LID", "default" => true);
 }
 $lAdmin_tab4->AddHeaders($BasketHeader);
 $arSetData = array();
 $arBasketData = array();
 while ($arBasket = $dbBasketList->GetNext()) {
     if (CSaleBasketHelper::isSetItem($arBasket)) {
         $arSetData[$arBasket["SET_PARENT_ID"]][] = $arBasket;
         continue;
     }
     $arBasketData[] = $arBasket;
 }

$arCurrency = array();
$dbCur = CCurrency::GetList($b1 = "name", $order1 = "asc", LANGUAGE_ID);
while ($arCur = $dbCur->Fetch()) {
    $arCurrency[$arCur["CURRENCY"]] = htmlspecialcharsEx($arCur["FULL_NAME"]);
    if (in_array($arCur["CURRENCY"], $arCurUsed)) {
        foreach ($arPrices as $v) {
            $arHeaders[] = array("id" => $v . "_" . $arCur["CURRENCY"], "content" => GetMessage("SALE_" . $v, array("#CURRENCY#" => htmlspecialcharsEx($arCur["FULL_NAME"]))), "sort" => $v . "_" . $arCur["CURRENCY"], "default" => true, "align" => "right");
        }
    }
}
$lAdmin->AddHeaders($arHeaders);
$arVisibleColumns = $lAdmin->GetVisibleHeaderColumns();
$dbResult = new CDBResult();
$dbResult->InitFromArray($arResult);
$dbResult = new CAdminResult($dbResult, $sTableID);
$dbResult->NavStart();
$lAdmin->NavText($dbResult->GetNavPrint(""));
while ($arResult = $dbResult->GetNext()) {
    $row =& $lAdmin->AddRow($arResult["PRODUCT_ID"], $arResult);
    $row->AddViewField("PRODUCT_ID", $arResult["PRODUCT_ID"]);
    $row->AddViewField("NAME", $arResult["NAME"]);
    $row->AddViewField("COUNT", $arResult["COUNT"]);
    $row->AddViewField("ORDER_COUNT", $arResult["ORDER_COUNT"]);
    $row->AddViewField("QUANTITY", $arResult["QUANTITY"]);
    $row->AddViewField("ORDER_QUANTITY", $arResult["ORDER_QUANTITY"]);
    $row->AddViewField("BASKET_QUANTITY", $arResult["BASKET_QUANTITY"]);
    $row->AddViewField("PAYED", $arResult["PAYED"]);
    if (IntVal($arResult["ORDER_COUNT"]) > 0) {
        $row->AddViewField("PAYED_PROC", roundEx($arResult["PAYED"] * 100 / $arResult["ORDER_COUNT"], 0));
        $row->AddViewField("ALLOW_DELIVERY_PROC", roundEx($arResult["ALLOW_DELIVERY"] * 100 / $arResult["ORDER_COUNT"], 0));
    } else {

}
if (empty($arSitesShop)) {
    $arSitesShop = $arSites;
}
$arCountry = GetCountryArray();
$arCountry["reference_id"] = array_flip($arCountry["reference_id"]);
/*
 * select all user (byuers)
 */
$arHeaders = array(array("id" => "USER_ID", "content" => "ID", "sort" => "USER_ID"), array("id" => "BUYER", "content" => GetMessage("BUYER_ROW_BUYER"), "sort" => "NAME", "default" => true), array("id" => "LOGIN", "content" => GetMessage("BUYER_ROW_LOGIN"), "sort" => "LOGIN"), array("id" => "LAST_NAME", "content" => GetMessage("BUYER_ROW_LAST"), "sort" => "LAST_NAME"), array("id" => "NAME", "content" => GetMessage("BUYER_ROW_NAME"), "sort" => "NAME"), array("id" => "SECOND_NAME", "content" => GetMessage("BUYER_ROW_SECOND"), "sort" => "SECOND_NAME"), array("id" => "EMAIL", "content" => GetMessage("BUYER_ROW_MAIL"), "sort" => "EMAIL", "default" => true), array("id" => "PERSONAL_PHONE", "content" => GetMessage("BUYER_ROW_PHONE"), "sort" => "PERSONAL_PHONE", "default" => true), array("id" => "LAST_LOGIN", "content" => GetMessage('BUYER_ROW_LAST_LOGIN'), "sort" => "LAST_LOGIN", "default" => false), array("id" => "DATE_REGISTER", "content" => GetMessage('BUYER_ROW_DATE_REGISTER'), "sort" => "DATE_REGISTER", "default" => true), array("id" => "LAST_ORDER_DATE", "content" => GetMessage('BUYER_ROW_LAST_ORDER_DATE'), "sort" => "LAST_ORDER_DATE", "default" => true), array("id" => "ORDER_COUNT", "content" => GetMessage('BUYER_ROW_COUNT_ORDER'), "sort" => "ORDER_COUNT", "default" => true, "align" => "right"), array("id" => "ORDER_SUM", "content" => GetMessage('BUYER_ROW_SUM_ORDER'), "sort" => "ORDER_SUM", "default" => true, "align" => "right"), array("id" => "GROUPS_ID", "content" => GetMessage('BUYER_ROW_GROUP')));
$lAdmin->AddHeaders($arHeaders);
$arVisibleColumns = $lAdmin->GetVisibleHeaderColumns();
$arOrderBuyer[$by] = $order;
$dbUsersList = CSaleUser::GetBuyersList($arOrderBuyer, $arFilter, false, array("nPageSize" => CAdminResult::GetNavSize($sTableID)), array("ID", "LID", "ACTIVE", "DATE_REGISTER", "LOGIN", "EMAIL", "NAME", "LAST_NAME", "SECOND_NAME", "PERSONAL_PHONE", "USER_ID", "LAST_LOGIN", "ORDER_COUNT", "ORDER_SUM", "CURRENCY", "LAST_ORDER_DATE"));
$dbUsersList = new CAdminResult($dbUsersList, $sTableID);
$dbUsersList->NavStart();
$lAdmin->NavText($dbUsersList->GetNavPrint(GetMessage("BUYER_PRLIST")));
while ($arBuyers = $dbUsersList->Fetch()) {
    $row =& $lAdmin->AddRow($arBuyers["USER_ID"], $arBuyers, "sale_buyers_profile.php?USER_ID=" . $arBuyers["USER_ID"] . "&lang=" . LANGUAGE_ID, GetMessage("BUYER_SUB_ACTION_PROFILE"));
    $profile = '<a href="sale_buyers_profile.php?USER_ID=' . $arBuyers["USER_ID"] . '&lang=' . LANGUAGE_ID . '">' . $arBuyers["USER_ID"] . '</a>';
    $row->AddField("USER_ID", $profile);
    if (floatVal($arBuyers["ORDER_SUM"]) > 0 && in_array("ORDER_SUM", $arVisibleColumns)) {
        $row->AddField("ORDER_SUM", SaleFormatCurrency($arBuyers["ORDER_SUM"], $arBuyers["CURRENCY"]));
    }
    if (floatVal($arBuyers["ORDER_COUNT"]) <= 0) {
        $row->AddField("ORDER_COUNT", '&nbsp;');
    }
    if (in_array("GROUPS_ID", $arVisibleColumns)) {
        $strUserGroup = '';
        $arUserGroups = CUser::GetUserGroup($arBuyers["USER_ID"]);
        foreach ($arUsersGroups as $arGroup) {