Дмитрий Яковенко (Все сообщения пользователя)

IncludeModuleLangFile($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/intranet/public/.left.menu_ext.php");
$obMenus = $APPLICATION->GetMenu("left", true);
echo "<pre>"; print_r($obMenus->arMenu); echo "</pre>";

$r = Bitrix\Main\UserTable::getList( [
   'filter'  => ['=PERSONAL_PHONE'  =>  '+38 099 000 0000'],
   'sel ect' => ['ID']
]);

echo "<pre>"; print_r([Bitrix\Main\UserTable::query()->getLastQuery(), $r->fetchAll()]); echo "</pre>";

Array
(
    [0] => SELECT 
   `main_user`.`ID` AS `ID`
FR OM `b_user` `main_user` 
WHERE `main_user`.`PERSONAL_PHONE` = '+38 099 000 0000'
    [1] => Array
        (
            [0] => Array
                (
                    [ID] => 55
                )

        )

)

$r = Bitrix\Main\UserTable::getList( [
   'filter'  => ['=PERSONAL_PHONE'  =>  '1234567'],
   'sel ect' => ['ID']
]); 
echo "<pre>"; print_r(UserTable::query()->getLastQuery()); echo "</pre>";

SELECT 
   `main_user`.`ID` AS `ID`
FR OM `b_user` `main_user` 
WHERE `main_user`.`PERSONAL_PHONE` = '1234567'

if (\Bitrix\Main\Loader::includeModule('iblock'))
{
   $parameters = [
      'sel ect' => ['ID', 'NAME'],
      'filter' => [
         'IBLOCK_ID' => 5,
         [
            'LOGIC' => 'OR',
            [">=LEFT_MARGIN" => 1, "<=RIGHT_MARGIN" => "16"],
            [">=LEFT_MARGIN" => 31, "<=RIGHT_MARGIN" => "32"],
         ]
      ]
   ];
   $r = \Bitrix\Iblock\SectionTable::getList($parameters);
   while ($s = $r->fetch())
   {
      echo "<pre>"; print_r($s); echo "</pre>";
   }
}
echo "<pre>"; print_r(\Bitrix\Iblock\SectionTable::query()->getLastQuery()); echo "</pre>";

SELECT 
   `iblock_section`.`ID` AS `ID`,
   `iblock_section`.`NAME` AS `NAME`
FR OM `b_iblock_section` `iblock_section` 

WHERE `iblock_section`.`IBLOCK_ID` = 5
AND (
   (
      `iblock_section`.`LEFT_MARGIN` >= 1
      AND `iblock_section`.`RIGHT_MARGIN` <= 16
   )
   OR (
      `iblock_section`.`LEFT_MARGIN` >= 31
      AND `iblock_section`.`RIGHT_MARGIN` <= 32
   )
)