Форум

getLink(); if ($firstPageLink) { LocalRedirect($firstPageLink); } } require_once($_SERVER["DOCUMENT_ROOT"].BX_ROOT."/modules/main/include/epilog_after.php");

bitrix create

module.exports = {
    input: 'src/script.js',
    output: {
        js: 'dist/mygrade.bundle.js',
        css: 'dist/mygrade.bundle.css'
    },
    namespace: 'BX.Mymodule',
    browserslist: false
};

import './style.css';
 
document.addEventListener("DOMContentLoaded", () => {
    console.log('Hello world from ext');
    document.querySelector("body").innerHTML = "<h1 class='hello-world'>Hello world from ext</h1>";
});

.hello-world {
    font-size: 40px;
    font-style: italic;
    color: blueviolet;
}

bitrix build

/* eslint-disable */
this.BX = this.BX || {};
(function (exports) {
    'use strict';
 
    document.addEventListener("DOMContentLoaded", function () {
      console.log('Hello world from ext');
      document.querySelector("body").innerHTML = "<h1 class='hello-world'>Hello world from ext</h1>";
    });
 
}((this.BX.Mymodule = this.BX.Mymodule || {})));
//# sourceMappingURL=mygrade.bundle.js.map

.hello-world {
    font-size: 40px;
    font-style: italic;
    color: blueviolet;
}

\Bitrix\Main\UI\Extension::load("mymodule.mygrade");

<?if (!defined("B_PROLOG_INCLUDED") || B_PROLOG_INCLUDED !== true) die();
 
return [
    'css' => './mygrade.bundle.css',
    'js' => './mygrade.bundle.js',
];

<MarkTaskButton v-if="!isTemplate && shouldShowMarkTaskButton"/>

<div class="ui-popup-menu-item${0}${0}">
                ${0}
            </div>

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
Ответ MySQL: Документация
 
#1231 - Переменная 'foreign_key_checks' не может быть установлена в значение 'NULL'

Unknown field definition `PROPERTY_UL_FULL_NAME` (PROPERTY_UL_FULL_NAME) for \Bitrix\Iblock\Element Entity. (100)

use Bitrix\Iblock\ElementTable;
use Bitrix\Main\Loader;
 
Loader::includeModule('iblock');
 
$iblockId = 44;
 
 
 
$params = [
    'order'=>['DATE_CREATE'=>'DESC'],
    'filter'=>[
        'PROPERTY_UL_FULL_NAME' => 'организация',
        'IBLOCK_ID' => $iblockId,
        'ACTIVE'=>'Y'
    ],
    'select' => ['ID','NAME','CREATED_BY','DATE_CREATE','TIMESTAMP_X','PROPERTY_UL_FULL_NAME'],
    'limit' => 20,
    'offset'=>0,
    'count_total'=>1,
    'runtime'=>[
        'PROPERTY'=>[
            'data_type' => 'Bitrix\Iblock\IblockElementProperty',
            'reference' => ['=this.ID' => 'ref.IBLOCK_ELEMENT_ID']
        ]
    ]
];
$dbItems = ElementTable::getList($params);
 
 
print_r(count($dbItems));
print_r($dbItems);

function getList($iblockId, $properties, $filter, $nav, $navParams, $sort)
{
    unset($filter['PRESET_ID']);
    unset($filter['FILTER_ID']);
    unset($filter['FILTER_APPLIED']);
    unset($filter['FIND']);
 
    $filter['IBLOCK_ID'] = $iblockId;
    $filter['ACTIVE'] = 'Y';
    if ($filter['NAME']) {
        $filter['%NAME'] = $filter['NAME'];
        unset($filter['NAME']);
    }
 
    $fields = [
        'ID',
        'NAME',
        'CREATED_BY',
        'DATE_CREATE',
        'TIMESTAMP_X',
    ];
 
    $order = [];
    foreach ($sort as $key => $itemSort) {
        if (in_array($key, $properties)) {
            $order[$key] = $itemSort;
        } else {
            $order['PROPERTY_' . $key] = $itemSort;
        }
    }
 
    foreach ($properties as $propertyCode) {
        if (in_array($propertyCode, ["ID", "IBLOCK_ID", "NAME", "SORT", "IBLOCK_SECTION_ID", 'CREATED_BY', "TIMESTAMP_X"])) {
            continue;
        }
 
        $propertyCodeTmp = str_replace('PROPERTY_', '', $propertyCode);
        $props = CIBlockProperty::GetList(["sort" => "asc", "name" => "asc"], ["ACTIVE" => "Y", "IBLOCK_ID" => $iblockId, "CODE" => $propertyCodeTmp]);
        $arrNumberTypeProperties = [];
        if ($propFields = $props->GetNext()) {
            if ($propFields['PROPERTY_TYPE'] == 'E') {
                $fields[$propertyCode] = 'PROPERTY.PROPERTY_' . $propFields["ID"] . '_REF.NAME';
            } else {
                $fields[$propertyCode] = 'PROPERTY.PROPERTY_' . $propFields["ID"];
            }
            if ($propFields['PROPERTY_TYPE'] == 'S') {
                $arrNumberTypeProperties[] = $propertyCode;
            }
        }
 
        if ($filter[$propertyCode]) {
            if (in_array($propertyCode, $arrNumberTypeProperties)) {
                $filter['=' . $propertyCode] = $filter[$propertyCode];
            } else {
                if (!is_array($filter[$propertyCode])) {
                    //$filter[$propertyCode] = '%' . str_replace('%', '', $filter[$propertyCode]) . '%';
                    $filter[$propertyCode] = str_replace('%', '', $filter[$propertyCode]);
                }
            }
        }
    }
 
    Bitrix\Iblock\IblockElementPropertyTable::setProperties($iblockId);
 
    $params = [
        'order' => $order,
        'filter' => $filter,
        'select' => $fields,
        'limit' => $nav->getLimit(),
        'offset' => $nav->getOffset(),
        'count_total' => 1,
    ];
    $params['runtime'] = [
        'PROPERTY' => [
            'data_type' => 'Bitrix\Iblock\IblockElementProperty',
            'reference' => ['=this.ID' => 'ref.IBLOCK_ELEMENT_ID'],
        ],
    ];
    $dbItems = ElementTable::getList($params);
    $nav->allowAllRecords(false)
        ->setRecordCount($dbItems->getCount())
        ->setPageSize($navParams['nPageSize'])
        ->initFromUri();
 
    return $dbItems;
}

$gosServices = getList($iBlockData['ID'], $dirParams['FIELDS'], $filter, $nav, $navParams, $sort);

\Bitrix\Main\Loader::IncludeModule("iblock");
 
$propertyIdList = [608, 609];
 
 
$dbItems = \Bitrix\Iblock\ElementPropertyTable::getList([
            'select' => ['VALUE'],
            'filter' => [
                'IBLOCK_ELEMENT_ID' => 104445,
                'IBLOCK_PROPERTY_ID' => $propertyIdList
            ],
]);
 
        $propValues = [];
        while($item = $dbItems->fetch()){
            var_dump($item);
            $propValues[] = $item['VALUE'];
        }
 
 
 
var_dump($propValues);

public static function getItems(int $newsId, int $limit, int $offset = 0, int $parentId = 0, int $depthLevel = 0): array
    {
        $parent_Id = $parentId;
        if ($parentId == 0)
            $parent_Id = false;
 
 
        $dbItems = CommentsTable::getList([
            'order' => ['created_at' => 'DESC'],
            'select' => ['author', 'content', 'created_at'],
            'filter' => ['news_id' => $newsId, 'parent_id' => $parent_Id],
            'limit' => $limit,
            'offset' => $offset,
            'count_total' => 1
        ]);
 
        $items = [];
        while($item = $dbItems->fetch()){
            $items[] = $item;
        }
 
        return $items;
    }

public static function getChildComments(int $parentCommentId, int $limit = 9999, int $offset = 0): array
    {
        $dbItems = CommentsTable::getList([
            'order' => ['created_at' => 'DESC'],
            'select' => ['author', 'content', 'created_at'],
            'filter' => ['parent_id' => $parentCommentId],
            'limit' => $limit,
            'offset' => $offset,
            'count_total' => 1
        ]);
 
        $items = [];
        while ($item = $dbItems->fetch()) {
            $items[] = $item;
        }
 
        return ['items' => $items, 'count' => count($items)];
    }

$items = Actions::getItems(29, 3, 0, 0, 0);

$childItems = Actions::getChildComments(1);