PHP CDBResult::NavStart方法代码示例

 /** @return Int */
 public function getSelectedRowsCount()
 {
     if ($this->resource) {
         return $this->resource->getSelectedRowsCount();
     } elseif ($this->resourceCDBResult) {
         if (!$this->resourceCDBResult instanceof \CDBResultMysql) {
             $this->resourceCDBResult->NavStart(0);
         }
         return $this->resourceCDBResult->SelectedRowsCount();
     }
     return 0;
 }

	function NavStart($nPageSize=0, $bShowAll=true, $iNumPage=false)
	{
		parent::NavStart($nPageSize, $bShowAll, $iNumPage);
		if(COption::GetOptionString("search", "stat_phrase") == "Y")
		{
			$this->Statistic = new CSearchStatistic($this->strQueryText, $this->strTagsText);
			$this->Statistic->PhraseStat($this->NavRecordCount, $this->NavPageNomer);
			if($this->Statistic->phrase_id)
				$this->url_add_params[] = "sphrase_id=".$this->Statistic->phrase_id;
		}
	}

$catParams->iItemsCount = $allCatCount;
$catParams->bIsRed = 'N';
$catParams->createLinkFromTemplate();
$categories->addItem($catParams);
//Anyone can add custom virtual category to the list
$rsHandlers = GetModuleEvents("wiki", "OnCategoryListCreate");
while ($arHandler = $rsHandlers->Fetch()) {
    ExecuteModuleEventEx($arHandler, array(&$categories, $arParams['PATH_TO_CATEGORY']));
}
$arResult['CATEGORIES'] = $categories->GetItems();
sortByColumn($arResult['CATEGORIES'], "NAME");
//for pagination
$dbCatList = new CDBResult();
$dbCatList->InitFromArray($arResult['CATEGORIES']);
$arResult['CATEGORIES'] = array();
$dbCatList->NavStart($arParams['CATEGORY_COUNT'], false);
while ($arCat = $dbCatList->GetNext()) {
    $arResult['CATEGORIES'][strtolower($arCat["NAME"])] = $arCat;
}
$arResult['DB_LIST'] =& $dbCatList;
$arCatName = $categories->getItemsNames();
$arCatNameExists = array();
if (!empty($arCatName)) {
    // checking the category on the "red link"
    $arFilter = array('IBLOCK_ID' => $arParams['IBLOCK_ID'], 'CHECK_PERMISSIONS' => 'N', 'ACTIVE' => 'Y', 'NAME' => $arCatName);
    if (CWikiSocnet::IsSocNet()) {
        $arFilter['SUBSECTION'] = CWikiSocnet::$iCatId;
    }
    $rsElement = CIBlockElement::GetList(array(), $arFilter, false, false, array());
    while ($arElement = $rsElement->GetNext()) {
        $arCatNameExists[] = substr($arElement['NAME'], strpos($arElement['NAME'], ':') + 1);

             }
             /*$arUF = CReport::detectUserField($runtimeField, $arUFInfo);*/
             $viewColumns[$newNum] = array('field' => $runtimeField, 'fieldName' => $k, 'resultName' => $k, 'humanTitle' => empty($runtimeColumnInfo['humanTitle']) ? '' : $runtimeColumnInfo['humanTitle'], 'defaultSort' => '', 'aggr' => '', 'prcnt' => '', 'href' => empty($runtimeColumnInfo['href']) ? '' : $runtimeColumnInfo['href'], 'grouping' => false, 'grouping_subtotal' => $runtimeColumnInfo['grouping_subtotal'] === true ? true : false, 'runtime' => true);
             /*unset($arUF);*/
             $viewColumnsByResultName[$k] =& $viewColumns[$newNum];
         }
     }
 }
 if (isset($limit['nPageTop'])) {
     $main_query->setLimit($limit['nPageTop']);
 }
 $result = $main_query->exec();
 $result = new CDBResult($result);
 if (!$bGroupingMode) {
     if (isset($limit['nPageTop'])) {
         $result->NavStart($limit['nPageTop']);
     } else {
         $result->NavStart($limit['nPageSize']);
     }
 }
 $data = array();
 $grcDataPrimaryValues = array();
 $grcDataPrimaryPointers = array();
 while ($row = $result->Fetch()) {
     // rewrite UF values
     call_user_func_array(array($arParams['REPORT_HELPER_CLASS'], 'rewriteResultRowValues'), array(&$row, &$viewColumnsByResultName));
     // attach URLs
     foreach ($row as $k => $v) {
         if (!array_key_exists($k, $viewColumnsByResultName)) {
             continue;
         }

function okfilename_OnClick()
{
	fileencode = document.fform.actfile_name.value;
	OpenFile(fileencode, '<?php 
    echo AddSlashes(htmlspecialcharsex($path));
    ?>
');
}
//-->
</script>
<?php 
    $arDirContent = array_merge($arDirs, $arFiles);
    $db_DirContent = new CDBResult();
    $db_DirContent->InitFromArray($arDirContent);
    $db_DirContent->sSessInitAdd = $path;
    $db_DirContent->NavStart(50);
    if ($db_DirContent->IsNavPrint()) {
        $db_DirContent->NavPrint(GetMessage("FILEMAN_T_FILES"));
        echo "<br>&nbsp;";
    }
    ?>
<table width="100%" border="0" cellpadding="1" cellspacing="1">
	<tr>
		<td class="tablehead1" align="center"><font class="tableheadtext"><?php 
    echo GetMessage('FILEMAN_FILE_NAME');
    ?>
</font></td>
		<td class="tablehead2" align="center"><font class="tableheadtext"><?php 
    echo GetMessage('FILEMAN_FILE_SIZE');
    ?>
</font></td>

             $arResult['FATAL_MESSAGE'] = $e->getMessage();
         }
     }
 }
 $history = new CBPHistoryService();
 $arFilter = array('DOCUMENT_ID' => $documentId);
 $dbResultList = $history->GetHistoryList(array('ID' => 'DESC'), $arFilter, false, false, array('ID', 'DOCUMENT_ID', 'NAME', 'MODIFIED', 'USER_ID', 'USER_NAME', 'USER_LAST_NAME', 'USER_SECOND_NAME', 'USER_LOGIN'));
 $dbResultListFirst = $history->GetHistoryList(array('ID' => 'DESC'), $arFilter, false, false, array('ID'));
 $arResult['PAGE_VAR'] = $arParams['PAGE_VAR'];
 $arResult['OPER_VAR'] = $arParams['OPER_VAR'];
 $arResult['PATH_TO_HISTORY_DIFF'] = CHTTP::urlAddParams(CComponentEngine::MakePathFromTemplate($arParams['PATH_TO_HISTORY_DIFF'], array('wiki_name' => urlencode($arParams['ELEMENT_NAME']), 'group_id' => CWikiSocnet::$iSocNetId)), $arParams['IN_COMPLEX'] == 'Y' && $arParams['SEF_MODE'] == 'N' ? array($arParams['OPER_VAR'] => 'history_diff') : array());
 $sTableID = 'tbl_bizproc_document_history';
 $rsHistoryFirst = new CDBResult($dbResultListFirst, $sTableID);
 $arHistoryFirst = $rsHistoryFirst->GetNext();
 $rsHistory = new CDBResult($dbResultList, $sTableID);
 $rsHistory->NavStart($arParams['HISTORY_COUNT'], false);
 $arResult['DB_LIST'] =& $rsHistory;
 $arResult['HISTORY'] = array();
 if ($arResult['SOCNET']) {
     $arResult['AJAX_PAGE'] = $APPLICATION->GetCurPageParam('', array('bxajaxid', 'logout'));
     $arResult['PATH_TO_USER'] = $arParams['PATH_TO_USER'];
     $arResult['SHOW_LOGIN'] = $this->GetParent()->arParams['SHOW_LOGIN'];
     $arResult['NAME_TEMPLATE'] = $this->GetParent()->arParams['NAME_TEMPLATE'];
     $arResult['PATH_TO_CONPANY_DEPARTMENT'] = $this->GetParent()->arParams['PATH_TO_CONPANY_DEPARTMENT'];
     $arResult['PATH_TO_VIDEO_CALL'] = $this->GetParent()->arParams['PATH_TO_VIDEO_CALL'];
     $arResult['PATH_TO_SONET_MESSAGES_CHAT'] = $this->GetParent()->arParams['PATH_TO_MESSAGES_CHAT'];
 }
 $arErrorsTmp = array();
 while ($arHistory = $rsHistory->GetNext()) {
     $arHistory['USER_LINK'] = '';
     $arHistoryResult = CBPDocument::GetDocumentFromHistory($arHistory['ID'], $arErrorsTmp);

                        if ($eventHandlerID !== false && intval($eventHandlerID) > 0) {
                            RemoveEventHandler('main', 'system.field.view.file', $eventHandlerID);
                        }
                        $APPLICATION->AddViewContent(implode('_', array($tplID, 'ID', $commentId, "AFTER")), ob_get_clean(), 50);
                        $arRecords[$commentId]["CLASSNAME"] = "feed-com-block-uf";
                    }
                }
            }
            $tmp = $nav_result = null;
            if ($arEvent["COMMENTS_COUNT"] - count($arRecords) > 0) {
                $tmp = reset($arEvent["COMMENTS"]);
                $nav_result = new CDBResult();
                $nav_result->InitFromArray(array_fill(0, $arEvent["COMMENTS_COUNT"], null));
                $nav_result->NavRecordCount = $arEvent["COMMENTS_COUNT"];
                $nav_result->NavNum = 1;
                $nav_result->NavStart(20, false);
            }
            $arResult["OUTPUT_LIST"] = $APPLICATION->IncludeComponent("bitrix:main.post.list", "", array("TEMPLATE_ID" => $tplID, "ENTITY_XML_ID" => $arEvent["COMMENTS_PARAMS"]["ENTITY_XML_ID"], "RECORDS" => array_reverse($arRecords, true), "NAV_STRING" => $tmp ? "/bitrix/components/bitrix/socialnetwork.log.entry/ajax.php?" . http_build_query(array("action" => "get_comments", "logid" => $arEvent["EVENT"]["ID"], "commentID" => $tmp["EVENT"]["ID"], "commentTS" => $tmp["LOG_DATE_TS"], "lastLogTs" => $arResult["LAST_LOG_TS"], "et" => $arEvent["EVENT"]["ENTITY_TYPE"], "exmlid" => $arEvent["COMMENTS_PARAMS"]["ENTITY_XML_ID"], "p_user" => $arParams["PATH_TO_USER"], "p_le" => $arParams["PATH_TO_LOG_ENTRY"], "p_group" => $arParams["PATH_TO_GROUP"], "p_dep" => $arParams["PATH_TO_CONPANY_DEPARTMENT"], "nt" => $arParams["NAME_TEMPLATE"], "sl" => $arParams["SHOW_LOGIN"], "dtf" => $arParams["DATE_TIME_FORMAT"], "tf" => $arParams["TIME_FORMAT"], "as" => $arParams["AVATAR_SIZE"], "lang" => LANGUAGE_ID, "site" => SITE_ID)) : "", "NAV_RESULT" => $nav_result, "PREORDER" => "N", "RIGHTS" => array("MODERATE" => "N", "EDIT" => $arResult["COMMENT_RIGHTS_EDIT"], "DELETE" => $arResult["COMMENT_RIGHTS_DELETE"]), "VISIBLE_RECORDS_COUNT" => count($arRecords), "ERROR_MESSAGE" => $arResult["ERROR_MESSAGE"], "OK_MESSAGE" => $arResult["OK_MESSAGE"], "RESULT" => $arResult["RESULT"], "PUSH&PULL" => array("ACTION" => $_REQUEST['REVIEW_ACTION'], "ID" => $arResult["RESULT"]), "VIEW_URL" => isset($arComment["EVENT"]["URL"]) && strlen($arComment["EVENT"]["URL"]) > 0 ? $arComment["EVENT"]["URL"] : (isset($arParams["PATH_TO_LOG_ENTRY"]) && strlen($arParams["PATH_TO_LOG_ENTRY"]) > 0 ? CComponentEngine::MakePathFromTemplate($arParams["PATH_TO_LOG_ENTRY"], array("log_id" => $arEvent["EVENT"]["ID"])) . "?commentId=#ID#" : ""), "EDIT_URL" => "__logEditComment('" . $arEvent["COMMENTS_PARAMS"]["ENTITY_XML_ID"] . "', '#ID#', '" . $arEvent["EVENT"]["ID"] . "');", "MODERATE_URL" => "", "DELETE_URL" => '/bitrix/components/bitrix/socialnetwork.log.entry/ajax.php?lang=' . LANGUAGE_ID . '&action=delete_comment&delete_comment_id=#ID#&post_id=' . $arEvent["EVENT"]["ID"] . '&site=' . SITE_ID, "AUTHOR_URL" => $arParams["PATH_TO_USER"], "AVATAR_SIZE" => $arParams["AVATAR_SIZE_COMMENT"], "NAME_TEMPLATE" => $arParams["NAME_TEMPLATE"], "SHOW_LOGIN" => $arParams['SHOW_LOGIN'], "DATE_TIME_FORMAT" => $arParams["DATE_TIME_FORMAT"], "LAZYLOAD" => $arParams["LAZYLOAD"], "NOTIFY_TAG" => $arEvent["COMMENTS_PARAMS"]["NOTIFY_TAGS"], "NOTIFY_TEXT" => TruncateText(str_replace(array("\r\n", "\n"), " ", $arEvent["EVENT"]["MESSAGE"]), 100), "SHOW_MINIMIZED" => "Y", "SHOW_POST_FORM" => isset($arEvent["HAS_COMMENTS"]) && $arEvent["HAS_COMMENTS"] === "Y" && isset($arEvent["CAN_ADD_COMMENTS"]) && $arEvent["CAN_ADD_COMMENTS"] === "Y" ? "Y" : "N", "IMAGE_SIZE" => $arParams["IMAGE_SIZE"], "mfi" => $arParams["mfi"]), $this->__component);
            echo $arResult["OUTPUT_LIST"]["HTML"];
            ?>
<script type="text/javascript">BX.ready(function(){
						__logCommentsListRedefine("<?php 
            echo $arEvent["COMMENTS_PARAMS"]["ENTITY_XML_ID"];
            ?>
", "sonet_log_day_item_<?php 
            echo $ind;
            ?>
", "anchor_<?php 
            echo CUtil::JSEscape($anchor_id);
            ?>
", "<?php 

            break;
    }
}
$arResult = array("USER_ID" => $USER->GetID(), "IDEA" => array(), "SUBSCRIBE" => array(), "IDEA_STATUS" => array(), "GRID" => array());
//Get Idea subscribtion
if ($arResult["USER_ID"] > 0) {
    //InitGrid
    $GridOptions = new CGridOptions($arResult["GRID_ID"]);
    //Grid Sort
    $arSort = $GridOptions->GetSorting(array("sort" => array("DATE_PUBLISH" => "DESC"), "vars" => array("by" => "by", "order" => "order")));
    $arResult["GRID"]["SORT"] = $arSort["sort"];
    $arResult["GRID"]["SORT_VARS"] = $arSort["vars"];
    $arNav = $GridOptions->GetNavParams(array("nPageSize" => 25));
    $db_res = \Bitrix\Idea\NotifyEmailTable::getList(array('filter' => array("USER_ID" => $arResult["USER_ID"]), 'select' => array("ID" => "RUNTIME_ID", "SUBSCRIBE_TYPE", "ENTITY_TYPE", "ENTITY_CODE", "CATEGORY_NAME" => "ASCENDED_CATEGORIES.NAME"), 'order' => array("ENTITY_TYPE" => "ASC", "ENTITY_CODE" => "ASC"), 'runtime' => array(new \Bitrix\Main\Entity\ExpressionField('RUNTIME_ID', \Bitrix\Main\Application::getConnection()->getSqlHelper()->getConcatFunction("CASE " . "WHEN %s='" . \Bitrix\Idea\NotifyEmailTable::ENTITY_TYPE_IDEA . "' AND %s='' THEN '" . CIdeaManagmentEmailNotify::SUBSCRIBE_ALL . "' " . "WHEN %s='" . \Bitrix\Idea\NotifyEmailTable::ENTITY_TYPE_IDEA . "' THEN '" . CIdeaManagmentEmailNotify::SUBSCRIBE_IDEA_COMMENT . "' " . "WHEN %s='" . \Bitrix\Idea\NotifyEmailTable::ENTITY_TYPE_CATEGORY . "' AND %s='' THEN '" . CIdeaManagmentEmailNotify::SUBSCRIBE_ALL_IDEA . "' " . "WHEN %s='" . \Bitrix\Idea\NotifyEmailTable::ENTITY_TYPE_CATEGORY . "' THEN '" . \Bitrix\Idea\NotifyEmailTable::ENTITY_TYPE_CATEGORY . "' " . "ELSE 'UNK' END", "%s"), array("ENTITY_TYPE", "ENTITY_CODE", "ENTITY_TYPE", "ENTITY_TYPE", "ENTITY_CODE", "ENTITY_TYPE", "ENTITY_CODE")))));
    $oIdeaSubscribe = new CDBResult($db_res);
    $oIdeaSubscribe->NavStart($arNav["nPageSize"], false);
    //Select Subscribe
    $arBlogPostId = array();
    while ($r = $oIdeaSubscribe->Fetch()) {
        $arResult["SUBSCRIBE"][] = $r["ID"];
        if ($r["ID"] == CIdeaManagmentEmailNotify::SUBSCRIBE_ALL) {
            $arResult["IDEA"] = array(CIdeaManagmentEmailNotify::SUBSCRIBE_ALL => $r + array("TITLE" => GetMessage("IDEA_SUBSCRIBE_ALL_SUBSCRIBED"), "ID" => CIdeaManagmentEmailNotify::SUBSCRIBE_ALL)) + $arResult["IDEA"];
        } else {
            if ($r["ID"] == CIdeaManagmentEmailNotify::SUBSCRIBE_ALL_IDEA) {
                $arResult["IDEA"] = array(CIdeaManagmentEmailNotify::SUBSCRIBE_ALL_IDEA => $r + array("TITLE" => GetMessage("IDEA_SUBSCRIBE_ALL_IDEA_SUBSCRIBED"), "ID" => CIdeaManagmentEmailNotify::SUBSCRIBE_ALL_IDEA)) + $arResult["IDEA"];
            } else {
                if ($r["ENTITY_TYPE"] == \Bitrix\Idea\NotifyEmailTable::ENTITY_TYPE_CATEGORY) {
                    $arResult["IDEA"][$r["ID"]] = $r + array("TITLE" => !!$r["CATEGORY_NAME"] ? $r["CATEGORY_NAME"] : GetMessage("IDEA_SUBSCRIBE_NOT_FOUND_2", array("#CODE#" => $r["ENTITY_CODE"])));
                } else {
                    if ($r["ENTITY_TYPE"] == \Bitrix\Idea\NotifyEmailTable::ENTITY_TYPE_IDEA) {
                        $arResult["IDEA"][$r["ID"]] = $r + array("TITLE" => GetMessage("IDEA_SUBSCRIBE_NOT_FOUND"));

                while ($arRequest = $dbRequests->GetNext()) {
                    $gu = CComponentEngine::MakePathFromTemplate($arParams["PATH_TO_GROUP"], array("group_id" => $arRequest["GROUP_ID"]));
                    $arGroup = CSocNetGroup::GetByID($arRequest["GROUP_ID"]);
                    $arImage = array();
                    if (intval($arParams["THUMBNAIL_LIST_SIZE"]) > 0) {
                        if (intval($arGroup["IMAGE_ID"]) <= 0) {
                            $arGroup["IMAGE_ID"] = COption::GetOptionInt("socialnetwork", "default_group_picture", false, SITE_ID);
                        }
                        $arImage = CFile::ResizeImageGet($arGroup["IMAGE_ID"], array("width" => $arParams["THUMBNAIL_LIST_SIZE"], "height" => $arParams["THUMBNAIL_LIST_SIZE"]), BX_RESIZE_IMAGE_EXACT, false);
                    }
                    $arEventTmp = array("EVENT_TYPE" => "INVITE_GROUP", "ID" => $arRequest["ID"], "USER_ID" => $arRequest["USER_ID"], "GROUP_ID" => $arRequest["GROUP_ID"], "GROUP_URL" => $gu, "GROUP_NAME" => $arGroup["NAME"], "GROUP_IMG" => $arImage, "DATE_CREATE" => $arRequest["DATE_CREATE"], "MESSAGE" => $parser->convert($arRequest["~MESSAGE"], false, array(), array("HTML" => "N", "ANCHOR" => "Y", "BIU" => "Y", "IMG" => "Y", "LIST" => "Y", "QUOTE" => "Y", "CODE" => "Y", "FONT" => "Y", "SMILES" => "Y", "UPLOAD" => "N", "NL2BR" => "N")));
                    $arTmpResult["RequestsOut"][] = $arEventTmp;
                }
            }
            $rsRequestsOut = new CDBResult();
            $rsRequestsOut->InitFromArray($arTmpResult["RequestsOut"]);
            $rsRequestsOut->NavStart();
            while ($arRecord = $rsRequestsOut->GetNext()) {
                $arResult["RequestsOut"]["List"][] = $arRecord;
            }
            $arResult["RequestsOut"]["NAV_STRING"] = $rsRequestsOut->GetPageNavStringEx($navComponentObject, GetMessage("SONET_URE_NAV"), "", false);
        } else {
            $arResult["FatalError"] = GetMessage("SONET_URE_NO_PERMS");
        }
    } else {
        $arResult["FatalError"] = GetMessage("SONET_URE_NO_USER");
    }
    $arResult["InfoMessage"] = $infoMessage;
    $arResult["ErrorMessage"] = $errorMessage;
}
$this->IncludeComponentTemplate();

}
$parametrs = array('order' => array('CALL_START_DATE' => 'DESC'), 'filter' => $filter, 'select' => array('*'));
if (!$_GET['SHOWALL_1']) {
    $parametrs['limit'] = $limit;
    $parametrs['offset'] = ($page - 1) * $limit;
}
$data = VI\StatisticTable::getList($parametrs);
$result = new CDBResult($data);
$countQuery = new Bitrix\Main\Entity\Query(VI\StatisticTable::getEntity());
$countQuery->addSelect(new \Bitrix\Main\Entity\ExpressionField('CNT', 'COUNT(1)'));
$countQuery->setFilter($filter);
$totalCount = $countQuery->setLimit(null)->setOffset(null)->exec()->fetch();
$totalCount = intval($totalCount['CNT']);
if (!$_GET['SHOWALL_1']) {
    $totalPage = ceil($totalCount / $limit);
    $result->NavStart($limit);
} else {
    $totalPage = 1;
    $result->NavStart();
}
$result->NavRecordCount = $totalCount;
$result->NavPageCount = $totalPage;
$result->NavPageNomer = $page;
$arResult["NAV_OBJECT"] = $result;
$arResult["ROWS_COUNT"] = $result->SelectedRowsCount();
$arResult["ELEMENTS_ROWS"] = array();
$arAvailableStatuses = array("200", "304", "603", "404", "486", "503", "480", "402", "1", "2", "3");
$bModuleCatalog = false;
if (CModule::IncludeModule("catalog")) {
    $bModuleCatalog = true;
}

<?php 
echo EndFilter();
?>
<br>
<p><?php 
$total_COUNTER = 0;
$total_COUNTER_BACK = 0;
$arEvents = array();
while ($arEvent = $events->Fetch()) {
    $arEvents[] = $arEvent;
    $total_COUNTER += intval($arEvent["COUNTER"]);
    $total_COUNTER_BACK += intval($arEvent["COUNTER_BACK"]);
}
$events = new CDBResult();
$events->InitFromArray($arEvents);
$events->NavStart();
echo $events->NavPrint(GetMessage("STAT_ADV_EVENTS_PAGES"));
?>
</p>
<table border="0" width="100%" cellspacing="1" cellpadding="3">
	<tr>
		<?php 
if ($find_group == "NOT_REF") {
    ?>
		<td valign="top" align="center" width="0%" nowrap class="tablehead1">
			<font class="tableheadtext">ID<br><?php 
    echo SortingEx("s_id");
    ?>
</font></td>
		<?php 
}

$arNavParams = array(
	"nPageSize" => $arParams['ITEMS_LIMIT'],
	"bShowAll" => $arParams["PAGER_SHOW_ALL"],
);
$arNavigation = CDBResult::GetNavParams($arNavParams);
	
try {
	$obAuthor = new BeonoYandexFotki($arParams["AUTHOR"], $arParams['CACHE_TIME']);
	$arRawResult = $obAuthor->getAlbumPhotos($arParams["ALBUM_ID"], array('sort' => $arParams['PHOTOS_SORT']));
	$arResult = $arRawResult;
	$arResult['ITEMS'] = array();
	
	if (is_array($arRawResult['ITEMS'])) {
		$dbresult = new CDBResult;
		$dbresult->InitFromArray($arRawResult['ITEMS']);
		$dbresult->NavStart($arParams['ITEMS_LIMIT'], false);	
		
		while ($arItem = $dbresult->GetNext()) {
			$arItem['URL'] = str_replace(array('#album_id#', '#photo_id#'), array($arParams["ALBUM_ID"], $arItem["ID"]), $arParams['PHOTO_URL']);
			$arResult['ITEMS'][] = $arItem;
		}			
				
		$arResult['PAGE_NUMBER'] = $dbresult->NavPageNomer;
		$arResult["NAV_STRING"] = $dbresult->GetPageNavStringEx($navComponentObject, false, $arParams["PAGER_TEMPLATE"], $arParams["PAGER_SHOW_ALWAYS"]);
	}
	
	if (!$arRawResult['ID']) {
		throw new Exception(GetMessage('BEONO_YAFOTKI_COMP_ERROR_ALBUM404'));
	}	
	
} catch (Exception $e) {

}
unset($arSectionFilter);
// SECTIONS <--
// PRODUCTS -->
$arPricesSelect = $arVatsSelect = array();
$arSelect = CCrmProduct::DistributeProductSelect($arSelect, $arPricesSelect, $arVatsSelect);
$rsProduct = CCrmProduct::GetList($arResult['SORT'], $arFilter, $arSelect);
while ($arProductRow = $rsProduct->Fetch()) {
    $arProductRow['TYPE'] = 'P';
    $arResultData[] = $arProductRow;
}
unset($rsProduct, $arProductRow);
//$obRes = CCrmProduct::GetList($arResult['SORT'], $arFilter, $arSelect, $arNavParams);
$obRes = new CDBResult();
$obRes->InitFromArray($arResultData);
$obRes->NavStart($arNavParams);
$arResult['PRODUCTS'] = array();
//$arResult['PRODUCT_ID_ARY'] = array();
$arResult['PERMS']['ADD'] = true;
//!$CCrmProduct->cPerms->HavePerm('CONTACT', BX_CRM_PERM_NONE, 'ADD');
$arResult['PERMS']['WRITE'] = true;
//!$CCrmProduct->cPerms->HavePerm('CONTACT', BX_CRM_PERM_NONE, 'WRITE');
$arResult['PERMS']['DELETE'] = true;
//!$CCrmProduct->cPerms->HavePerm('CONTACT', BX_CRM_PERM_NONE, 'DELETE');
$arProductId = array();
$arPropertyValues = array();
while ($arElement = $obRes->GetNext()) {
    if ($arElement['TYPE'] === 'S') {
        $arElement['DELETE'] = $arElement['EDIT'] = true;
        $arResult['SECTIONS'][$arElement['ID']] = $arElement;
    } else {

 if (intval($_REQUEST["commentID"]) > 0 || intval($_REQUEST["commentTS"]) > 0) {
     foreach ($arResult["arComments"] as $key => $res) {
         if (intval($_REQUEST["commentTS"]) > 0 && $res["LOG_DATE_TS"] >= $_REQUEST["commentTS"] || intval($_REQUEST["commentTS"]) <= 0 && $key >= $_REQUEST["commentID"]) {
             unset($arResult["arComments"][$key]);
         }
     }
     if (isset($_REQUEST["PAGEN_1"]) && intval($_REQUEST["PAGEN_1"]) > 0) {
         $cntHidden = count($arResult["arComments"]) - intval($_REQUEST["PAGEN_1"]) * 20;
         if ($cntHidden > 0) {
             $arResult["navigationNextPageNum"] = intval($_REQUEST["PAGEN_1"]) + 1;
             $arResult["navigationCounter"] = $cntHidden;
         }
         $arResult["arComments"] = array_reverse($arResult["arComments"], true);
         $rsNavResult = new CDBResult();
         $rsNavResult->InitFromArray($arResult["arComments"]);
         $rsNavResult->NavStart(20, false);
         $arTmp = $arResult["arComments"];
         $arResult["arComments"] = array();
         while ($arNavResult = $rsNavResult->Fetch()) {
             $arResult["arComments"][$arNavResult["EVENT"]["ID"]] = $arNavResult;
         }
         $arResult["arComments"] = array_reverse($arResult["arComments"], true);
     }
 }
 $rating_entity_type = null;
 $arTmp = $arResult["arComments"];
 $arResult["arComments"] = array();
 foreach ($arTmp as $key => $arCommentTmp) {
     if ($rating_entity_type === null) {
         $rating_entity_type = !!$arCommentTmp["EVENT"]["RATING_TYPE_ID"] ? $arCommentTmp["EVENT"]["RATING_TYPE_ID"] : false;
     }

 function NavStart($nPageSize = 20, $bShowAll = true, $iNumPage = false)
 {
     if ($this->table_id) {
         if ($_REQUEST["mode"] == "excel") {
             return;
         }
         $nSize = CAdminResult::GetNavSize($this->table_id, $nPageSize);
         if (is_array($nPageSize)) {
             $this->nInitialSize = $nPageSize["nPageSize"];
             $nPageSize["nPageSize"] = $nSize;
         } else {
             $this->nInitialSize = $nPageSize;
             $nPageSize = $nSize;
         }
     }
     parent::NavStart($nPageSize, $bShowAll, $iNumPage);
 }