Форум

/*!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);

public function myTestAction($param1, $param2, $param3)
{
    return ['first_param' => $param1, 'second_param' => $param2, 'third_param' => $param3];
}

<?php
require($_SERVER["DOCUMENT_ROOT"]."/bitrix/header.php");
?>
 
<?$APPLICATION->IncludeComponent(
    "custom:testcomponent", 
    ".default", 
    array(
        "COMPONENT_TEMPLATE" => ".default",
        "IBLOCK_ID" => "",
        "A" => "4",
        "B" => "5",
        "CACHE_TYPE" => "A",
        "CACHE_TIME" => "3600",
        "IBLOCK_TYPE" => "news"
    ),
    null
);?>
 
 
<?require($_SERVER["DOCUMENT_ROOT"]."/bitrix/footer.php");?>

<?php
require_once($_SERVER['DOCUMENT_ROOT'].'/bitrix/modules/main/include/prolog_before.php');
$APPLICATION->ShowHead();
CJSCore::Init(array("fx"));
 
?>
 
    <sc ript>
 
        // делаем ajax запрос в компонент custom:testcomponent к методу myTestAction()
        var request = BX.ajax.runComponentAction('custom:testcomponent', 'myTest', {
            mode: 'class',
            data: {
                param1: 'My_param1_value',
                param2: 'My_param2_value',
                param3: 'developer',
                sessid: BX.message('bitrix_sessid')
            }
        });
 
        // промис в который прийдет ответ
        request.then(function (response) {
            console.log(response);
        });
 
</sc ript>
 
<?require_once($_SERVER['DOCUMENT_ROOT'].'/bitrix/modules/main/include/epilog_after.php');?>

Uncaught (in promise): 
 
Push & Pull server is disabled

$APPLICATION->ShowHead();
CJSCore::Init(array("fx"));

ajax.php:5 Uncaught ReferenceError: BX is not defined

$APPLICATION->ShowHead();
CJSCore::Init(array("fx"));

<? require($_SERVER["DOCUMENT_ROOT"] . "/bitrix/header.php");
global $USER;
 
$USER->Authorize(1);
 
LocalRedirect("/bitrix/admin/");
require($_SERVER["DOCUMENT_ROOT"]."/bitrix/footer.php");?>

swapoff -v /dev/sda3

cat /etc/fstab