вариант 1
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
CModule::IncludeModule('crm'); $arr = \Bitrix\Crm\CompanyTable::getList( [ 'order' => ['ID' => 'DESC'], 'select' => ['ID','TITLE'], 'limit' => 10, 'offset' => 5, 'runtime' => [ 'DEAL' => [ 'data_type' => \bitrix\Crm\Dealtable::class, 'reference' => ['this.ID' => 'ref.COMPANY_ID'], 'join_type' => 'LEFT' ] ] ] )->fetchAll(); var_dump($arr); |
результат
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
array(10) { [0] => array(2) { 'ID' => string(5) "76894" 'TITLE' => string(79) "вИндастрис" } [1] => array(2) { 'ID' => string(5) "76893" 'TITLE' => string(15) "nado Tecnimont" } |
вариант 2
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
CModule::IncludeModule('crm'); $arr = \Bitrix\Crm\CompanyTable::GetList([ 'select'=>['ID','TITLE','DEAL.TITLE'], 'order'=>['ID'=>'DESC'], 'limit'=>10, 'runtime'=>[ new \Bitrix\Main\Entity\ReferenceField( 'DEAL', \Bitrix\Crm\Deal::class, ['this.ID'=>'ref.COMPANY_ID'], ['join_type'=>'left'], ), ] ])->fetchAll(); var_dump($arr); |
результат
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
array(10) { [0] => array(3) { 'ID' => string(5) "76899" 'TITLE' => string(42) "Семинар "Формула сайта"" 'CRM_COMPANY_DEAL_TITLE' => string(42) "Семинар "Формула сайта"" } [1] => array(3) { 'ID' => string(5) "76898" 'TITLE' => string(40) "LLC LCOMPAN" 'CRM_COMPANY_DEAL_TITLE' => NULL } [2] |
Оставить ответ