Борис (Все сообщения пользователя)

    $rsStore = \Bitrix\Iblock\ElementTable::getList([
        'select' => ['IBLOCK_ID', 'IBLOCK_SECTION.NAME'],
    ])->fetchAll();

$q = SectionTable::query()
    ->registerRuntimeField('se', [
        'data_type' => SectionElementTable::class,
        'reference' => ['=ref.IBLOCK_SECTION_ID' => 'this.ID'],
        'join_type' => "INNER",
    ])
    ->registerRuntimeField('e', [
        'data_type' => ElementTable::class,
        'reference' => ['=ref.ID' => 'this.se.IBLOCK_ELEMENT_ID'],
        'join_type' => "INNER",
    ])
    ->setSelect(['e.NAME'])
    ->setFilter(['ID' => 954])
    ->setLimit(1)
    ->getQuery()

<?
$arDirProperties = [
    "HIDE_LEFT_BLOCK" => "Y"
];
?>

    $hl_id = 1;
    
    $hlblock = HL::getById($hl_id)->fetch(); 

    $entity = HL::compileEntity($hlblock); 
    $entity_data_class = $entity->getDataClass(); 

    // Массив полей для добавления
    $data = [
        'UF_PHONE' => $_GET['phone'],
        'UF_EMAIL' => $_GET['email'],
        'UF_DATE_CREATE' => new \Bitrix\Main\Type\DateTime($_GET['created_at']),
        'UF_USER_ID' => $_GET['user_id'],
        'UF_FIRST_NAME' => $_GET['first_name'],
        'UF_LAST_NAME' => $_GET['last_name'],
        'UF_CITY' => $_GET['city'],
    ];
     
    $result = $entity_data_class::add($data);

$arFilter = [
    'IBLOCK_ID' => 176,
    '!=CATALOG_PRICE_15' => false
];
$arSelect = ['*', 'CATALOG_PRICE_15'];
$res = CIBlockElement::GetList($array_sort, $arFilter, false, $navparams, $arSelect);

while($ar = $res->fetch()){
    print_r($ar);
}

$arFilter = [       
    'IBLOCK_ID' => 176,
    'ACTIVE' => 'Y',
    '!=price.PRICE' => false
];

$arSelect = [
    '*', 'price.PRICE'
];

$rsSections = \Bitrix\Iblock\ElementTable::getList([
    'filter' => $arFilter,
    'select' =>  $arSelect,
    'limit' => 5,
    'runtime' => [
        'price' => [
            'data_type' => '\Bitrix\Catalog\PriceTable',
            'reference' => [
                '=this.ID' => 'ref.PRODUCT_ID'
            ],
            'join_type' => 'inner'
        ],
    ],
]
)->fetchAll();

<?$APPLICATION->IncludeComponent(
    "bitrix:catalog",
    "",
Array(
        "TEMPLATE_THEME" => "blue",
        "IBLOCK_TYPE" => "catalog",
        "IBLOCK_ID" => "2",
        "HIDE_NOT_AVAILABLE" => "N",
        "BASKET_URL" => "/personal/cart/",
        "ACTION_VARIABLE" => "action",
        "PRODUCT_ID_VARIABLE" => "id",
        "SECTION_ID_VARIABLE" => "SECTION_ID",
        "PRODUCT_QUANTITY_VARIABLE" => "quantity",
        "ADD_PROPERTIES_TO_BASKET" => "Y",
        "PRODUCT_PROPS_VARIABLE" => "prop",
        "PARTIAL_PRODUCT_PROPERTIES" => "Y",
        "COMMON_SHOW_CLOSE_POPUP" => "N",
        "SEF_MODE" => "Y",



        "SEF_FOLDER" => "/shop/",



       "AJAX_MODE" => "N",
        "AJAX_OPTION_ADDITIONAL" => "",
        "AJAX_OPTION_JUMP" => "N",
        "AJAX_OPTION_STYLE" => "Y",
        "AJAX_OPTION_HISTORY" => "N",
        "CACHE_TYPE" => "A",
        "CACHE_TIME" => "36000000",
        "CACHE_FILTER" => "N",
        "CACHE_GROUPS" => "Y",
        "USE_MAIN_ELEMENT_SECTION" => "Y",
        "SET_LAST_MODIFIED" => "N",
        "SET_TITLE" => "Y",
        "ADD_SECTIONS_CHAIN" => "Y",
        "ADD_ELEMENT_CHAIN" => "N",
        "USE_ELEMENT_COUNTER" => "Y",
        "USE_SALE_BESTSELLERS" => "Y",
        "COMPARE_POSITION_FIXED" => "Y",
        "COMPARE_POSITION" => "top left",
        "USE_FILTER" => "Y",
        "FILTER_NAME" => "",
        "FILTER_FIELD_CODE" => array(
            0 => "",
            1 => "",
        ),...

$id = [       
        1,
        2,
        3,
        4,
        5
    ]

$id = [       
       ['ID' = 1],
       ['ID' = 2],
       ['ID' = 3],
       ['ID' = 4],
       ['ID' = 5]
    ]

$APPLICATION->IncludeComponent(
    "bitrix:catalog.section.list",
    "",
        [
                "VIEW_MODE" => "TEXT",
                "SHOW_PARENT_NAME" => "Y",
                "IBLOCK_TYPE" => "info",
                "IBLOCK_ID" => "212",
                "SECTION_ID" => "",
                "SECTION_CODE" => "",
                "SECTION_URL" => "",
                "COUNT_ELEMENTS" => "Y",
                "TOP_DEPTH" => "2",
                "SECTION_FIELDS" => "",
                "SECTION_USER_FIELDS" => "",
                "ADD_SECTIONS_CHAIN" => "Y",
                "CACHE_TYPE" => "A",
                "CACHE_TIME" => "36000",
                "CACHE_NOTES" => "",
                "CACHE_GROUPS" => "Y",
                "CUSTOM_SECTION_SORT" => ['sort' => 'asc']
        ]       
    );

$fileId = false;

if($_FILES['file'])

    $fileId = \CFile::SaveFile($_FILES['file'],"mailatt");

    

\Bitrix\Main\Mail\Event::sendImmediate(array( // or send

    "EVENT_NAME" => "VM_SERVICE_REQUEST", 

    "LID" => "s2", 

    "C_FIELDS" => array( 

        "EMAIL" => $arCompany["PROPERTIES"]["EMAIL"]["VALUE"], 

        "COMPANY_NAME" => $arCompany["NAME"],

        "MESSAGE" => $request->getPost("MESSAGE"),

        "USER_NAME" => $USER->GetFullName(), 

        "USER_EMAIL" => $USER->GetEmail(), 

    ),

    "FILE" => array($fileId), // нужно сохранять сначала, из документации к CEvent::send: 
                              //Массив id файлов, которые используются классом CFile. 
                              //Либо можно передать массив абсолютных путей до файлов.
));    



if($fileId)

    CFile::Delete($fileId);

array CFile::ResizeImageGet( 
    mixed file, 
    array arSize, 
    const resizeType = BX_RESIZE_IMAGE_PROPORTIONAL, 
    bool bInitSizes = false, 
    array arFilters = false, 
    bool bImmediate = false, 
    bool jpgQuality = false
); 

$dataSend = [
        'EVENT_NAME' => 'CONNECT_US_FORM',
        //'MESSAGE_ID' => 1111, Если надо можно прям указать ID Почтового шаблона
        'LID' => 's1', 
        'C_FIELDS' => [
             "MSG" => $_POST['msg'],       
             "NAME" => $_POST['name'],
             "EMAIL" => $_POST['email']
        ],
    ];
    
    Event::send($dataSend);

$select=[
        '*',
        'department.UF_DEP_TYPE',
        'store.AMOUNT',
        'store.STORE_ID',
        'stock'=> 'department.UF_DEP_STOCK'
    ];

    $filter = [
        'UF_ACTIVE' => true,
        'department.UF_DEP_TYPE' => 6,
        '>store.AMOUNT' => 0, 
        'store.STORE_ID' => 'department.UF_DEP_STOCK'
    ];

    $query = new \Bitrix\Main\Entity\Query($entity_data_class_notification);
    $query->registerRuntimeField('department', [
        'data_type' => $entity_data_class,
        'reference' => ['=this.UF_SITE_ID' => 'ref.UF_DEP_SITE'],
    ])->registerRuntimeField('store', [        
        'data_type' => '\Bitrix\Catalog\StoreProductTable',
        'reference' => ['this.UF_GOOD_ID' => 'ref.PRODUCT_ID'],
    ])->setSelect($select)->setFilter($filter)->setOrder(['ID']);

->whereColumn('store.STORE_ID','department.UF_DEP_STOCK')

$query = new \Bitrix\Main\Entity\Query($entity_data_class_notification);

$query->registerRuntimeField('test', [
        'data_type' => $entity_data_class,
        'reference' => ['=this.UF_SITE_ID' => 'ref.UF_SITE'],
    ])->registerRuntimeField('test2', [        
        'data_type' => '\Bitrix\Catalog\StoreProductTable',
        'reference' => ['=test2.STORE_ID' => 'test.UF_STORE_ID'],
    ])->setSelect($select)->where($filter)->setOrder(['ID']);