Генератор документов - феррари на которой можно ездить только вокруг дома

<?
if (!defined("B_PROLOG_INCLUDED") || B_PROLOG_INCLUDED!==true)die();

if (!empty($arResult['ERROR']))
{
   echo $arResult['ERROR'];
   return false;
}

$APPLICATION->SetTitle("Тестовый список");

use \Bitrix\Iblock\PropertyEnumerationTable;
use Bitrix\Main\Grid\Options as GridOptions;
use Bitrix\Main\UI\PageNavigation;
use \Bitrix\Main\UI\ReversePageNavigation;

$list_id = 'example_list';

$grid_options = new GridOptions($list_id);
$sort = $grid_options->GetSorting(['sort' => ['ID' => 'DESC'], 'vars' => ['by' => 'by', 'order' => 'order']]);
$nav_params = $grid_options->GetNavParams();

$nav = new PageNavigation($list_id);
$nav->allowAllRecords(true)
   ->setPageSize($nav_params['nPageSize'])
   ->initFromUri();
if($USER->GetID() == 599){echo'<pre>';print_r($nav);echo'</pre>';}
$filterOption = new Bitrix\Main\UI\Filter\Options($list_id);
$filterData = $filterOption->getFilter([]);
$filter = [];

foreach ($filterData as $k => $v) {   
   $filter['NAME'] = "%".$filterData['FIND']."%";
}

$res = UchetmatcennostiTable::getList([
      "filter" => $filter,
      "count_total" => true,
      "offset" => $nav->getOffset(),
      "limit" => $nav->getLimit(),
      "order" => $sort['sort'],
   ]);

$ui_filter = [
   ['id' => 'NAME', 'name' => 'Название', 'type'=>'text', 'default' => true],
   ['id' => 'DATE_CREATE', 'name' => 'Дата создания', 'type'=>'date', 'default' => true],
];
?>
    <h2>Фильтр</h2>
    <div>
      <?$APPLICATION->IncludeComponent('bitrix:main.ui.filter', '', [
         'FILTER_ID' => $list_id,
         'GRID_ID' => $list_id,
         'FILTER' => $ui_filter,
         'ENABLE_LIVE_SEARCH' => true,
         'ENABLE_LABEL' => true
      ]);?>
    </div>
    <div style="clear: both;"></div>

    <hr>

    <h2>Таблица</h2>
<?php
$columns = [];
foreach ($arResult['fields'] as $key => $value) {
   $columns[] = ['id' => $key, 'name' => $value['LIST_COLUMN_LABEL'], 'sort' => $key, 'default' => true];
}

foreach ($res->fetchAll() as $row) {
   $data = [];
   foreach ($row as $key => $value) {
      $data[$key] = $value;
   }
      $list[] = ['data' => $data,];
}

$APPLICATION->IncludeComponent('bitrix:main.ui.grid', '', [
   'GRID_ID' => $list_id,
   'COLUMNS' => $columns,
   'ROWS' => $list,
   'SHOW_ROW_CHECKBOXES' => false,
   'NAV_OBJECT' => $nav,
   "NAV_PARAMS"=>["SEF_MODE" => "Y"],
   'AJAX_MODE' => 'Y',
   'AJAX_ID' => \CAjax::getComponentID('bitrix:main.ui.grid', '.default', ''),
   'PAGE_SIZES' =>  [
      ['NAME' => '1', 'VALUE' => '1'],      
      ['NAME' => '50', 'VALUE' => '50'],
      ['NAME' => '100', 'VALUE' => '100']
   ],
   'AJAX_OPTION_JUMP'          => 'N',
   'SHOW_CHECK_ALL_CHECKBOXES' => false,
   'SHOW_ROW_ACTIONS_MENU'     => true,
   'SHOW_GRID_SETTINGS_MENU'   => true,
   'SHOW_NAVIGATION_PANEL'     => true,
   'SHOW_PAGINATION'           => true,
   'SHOW_SELECTED_COUNTER'     => true,
   'SHOW_TOTAL_COUNTER'        => true,
   'SHOW_PAGESIZE'             => true,
   'SHOW_ACTION_PANEL'         => true,
   'ALLOW_COLUMNS_SORT'        => true,
   'ALLOW_COLUMNS_RESIZE'      => true,
   'ALLOW_HORIZONTAL_SCROLL'   => true,
   'ALLOW_SORT'                => true,
   'ALLOW_PIN_HEADER'          => true,
   'AJAX_OPTION_HISTORY'       => 'N'
]);
?> 

foreach ($arResult['PRODUCTS'] as $product) {    $list[] =
        [
            'data'    => [ //Данные ячеек
            'ID' => $product['ID'],
            'NAME' => $product['PRODUCT_NAME'],
            'PRICE_ACCOUNT' => $product['PRICE_ACCOUNT'],
            'QUANTITY' => $product['QUANTITY'],
            'MEASURE_NAME' => $product['MEASURE_NAME'],
            'SUM_ACCOUNT' => CurrencyFormat($product['SUM_ACCOUNT'], CCurrency::GetBaseCurrency()),
            'ISPAID' => ($arResult['PAYMENTS'][$product['ID']]['ISPAID']=='N')?
                Loc::getMessage('CRMSHARTTAR_PAYMENTS_NOPAID'):
                Loc::getMessage('CRMSHARTTAR_PAYMENTS_ISPAID'),
            'PAIDDATE' => $arResult['PAYMENTS'][$product['ID']]['PAIDDATE'],
            ],
            'actions' => [ //Действия над ними
                [
                    'text'    => 'Редактировать',
                    'onclick' => 'alert("Тут садим обработчик редактирования")'
                ],
            ],
        ];
}

$APPLICATION->IncludeComponent(
    'bitrix:main.ui.grid',
    '',
    array(
        'GRID_ID' => 'CRMSHARTTAR_BOUND_PAYMENTPAYMENTS',
        'HEADERS' => array(
            array(
                'id' => 'ID',
                'name' => Loc::getMessage('CRMSHARTTAR_PRUDUCT_ID'),
                'type' => 'int',
                'default' => false,
            ),
            array(
                'id' => 'NAME',
                'name' => Loc::getMessage('CRMSHARTTAR_PRODUCT_NAME'),
                'default' => true
            ),
            array(
                'id' => 'PRICE_ACCOUNT',
                'name' => Loc::getMessage('CRMSHARTTAR_PRODUCT_PRICE_ACCOUNT') .
                            ' (' . CCurrency::GetBaseCurrency() . ')',
                'default' => true,
            ),
            array(
                'id' => 'QUANTITY',
                'name' => Loc::getMessage('CRMSHARTTAR_PRODUCT_QUANTITY'),
                'default' => true
            ),
            array(
                'id' => 'MEASURE_NAME',
                'name' => Loc::getMessage('CRMSHARTTAR_PRODUCT_MEASURE_NAME'),
                'default' => true
            ),

            array(
                'id' => 'SUM_ACCOUNT',
                'name' => Loc::getMessage('CRMSHARTTAR_PRODUCT_SUM_ACCOUNT'),
                'default' => true,
            ),
            array(
                'id' => 'ISPAID',
                'name' => Loc::getMessage('CRMSHARTTAR_PAYMENTS_HEADER_ISPAID'),
                'default' => true,
            ),
            array(
                'id' => 'PAIDDATE',
                'name' => Loc::getMessage('CRMSHARTTAR_PAYMENTS_HEADER_PAIDDATE'),
                'default' => true,
            ),
        ),
        'ROWS' => $list,

        'SHOW_ACTION_PANEL'         => false, // включить если нуэны будут групповые операции
        'ACTION_PANEL'              => [ 
            'GROUPS' => [ 
                'TYPE' => [ 
                    'ITEMS' => [ 
                        [ 
                            'ID'    => 'set-type', 
                            'TYPE'  => 'DROPDOWN', 
                            'ITEMS' => [ 
                                ['VALUE' => '', 'NAME' => '- Выбрать -'], 
                                ['VALUE' => 'plus', 'NAME' => 'Поступление'], 
                                ['VALUE' => 'minus', 'NAME' => 'Списание'] 
                            ] 
                        ], 
                        [ 
                            'ID'       => 'edit', 
                            'TYPE'     => 'BUTTON', 
                            'TEXT'        => 'Редактировать', 
                            'CLASS'        => 'icon edit', 
                            'ONCHANGE' => '' 
                        ], 
                        [
                            'ID'       => 'delete',
                            'TYPE'     => 'BUTTON',
                            'TEXT'     => 'Удалить',
                            'CLASS'    => 'icon remove', 
                            'ONCHANGE' => '' 
                        ],
                    ], 
                ] 
            ], 
        ],
        'SHOW_ROW_CHECKBOXES' => false,
        'NAV_OBJECT' => $nav,
        'AJAX_MODE' => 'N',
        'AJAX_ID' => \CAjax::getComponentID('bitrix:main.ui.grid', '.default', ''),
        'PAGE_SIZES' =>  [
            ['NAME' => '5', 'VALUE' => '5'],
            ['NAME' => '10', 'VALUE' => '10'],
            ['NAME' => '20', 'VALUE' => '20']
        ],
        'AJAX_OPTION_JUMP'          => 'N',
        'SHOW_CHECK_ALL_CHECKBOXES' => false,
        'SHOW_ROW_ACTIONS_MENU'     => true,
        'SHOW_GRID_SETTINGS_MENU'   => true,
        'SHOW_NAVIGATION_PANEL'     => true,
        'SHOW_PAGINATION'           => false,
        'SHOW_SELECTED_COUNTER'     => false,
        'SHOW_TOTAL_COUNTER'        => false,
        'SHOW_PAGESIZE'             => false,
        'ALLOW_COLUMNS_SORT'        => false,
        'ALLOW_COLUMNS_RESIZE'      => true,
        'ALLOW_HORIZONTAL_SCROLL'   => true,
        'ALLOW_SORT'                => true, 
        'ALLOW_PIN_HEADER'          => false, 
        // 'AJAX_OPTION_HISTORY'       => 'N' 
    ),
    $this->getComponent(),
    array('HIDE_ICONS' => 'Y')
);