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

$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']);