\Bitrix\Main\Loader::IncludeModule('iblock'); $result = \Bitrix\Main\UserTable::getList(array( 'select' => array( 'ID','NAME', 'SECOND_NAME', 'LAST_NAME', 'PERSONAL_COUNTRY', 'PERSONAL_STATE', 'PERSONAL_CITY', 'PERSONAL_STREET', 'PERSONAL_PHOTO', 'UF_COMPANY_ID', 'UF_SUBCOMPANY_ID', 'KO.NAME', 'KP.NAME' ), 'filter' => array('ID'=>$user_id), 'limit' => 1, 'runtime'=>array( 'KO' => array( 'data_type' => '\Bitrix\Iblock\ElementTable', 'reference' => array('=this.UF_COMPANY_ID' => 'ref.ID'), 'join_type' => 'LEFT' ), 'KP' => array( 'data_type' => '\Bitrix\Iblock\ElementTable', 'reference' => array('=this.UF_SUBCOMPANY_ID' => 'ref.ID'), 'join_type' => 'LEFT' ) ) |
Таблица пользователей в связке с инфоблоком
25.10.201707:3225.10.2017 07:32:11