Skip to content

Instantly share code, notes, and snippets.

@chebanenko
Created December 2, 2015 16:03
Show Gist options
  • Save chebanenko/17480068359924598b2e to your computer and use it in GitHub Desktop.
Save chebanenko/17480068359924598b2e to your computer and use it in GitHub Desktop.
<?
require($_SERVER["DOCUMENT_ROOT"]."/bitrix/header.php");
$APPLICATION->SetTitle("Новая страница");
?>
<?
use \Bitrix\Main\Application;
use Bitrix\Highloadblock as HL;
use Bitrix\Main\Entity;
CModule::IncludeModule('highloadblock');
//bank
$bank_hlblock_id = 5;
$bank_program_hlblock_id = 6;
// включаем sql tracker
Application::getConnection()->startTracker();
/**
* забираем инфу о сущности из БД
*/
$bank_hlblock = HL\HighloadBlockTable::getById($bank_hlblock_id)->fetch();
$bank_program_hlblock = HL\HighloadBlockTable::getById($bank_program_hlblock_id)->fetch();
/**
* инициализация сущности
* @var \Bitrix\Main\Entity\Base $entity
*/
$bank_entity = HL\HighloadBlockTable::compileEntity($bank_hlblock);
$bank_program_entity = HL\HighloadBlockTable::compileEntity($bank_program_hlblock);
/**
*
* @var \Bitrix\Main\Entity\DataManager $dataClass
*/
$bankDataClass = $bank_entity->getDataClass();
$bankProgramDataClass = $bank_program_entity->getDataClass();
/**
* Делаем запрос
*/
$result = $bankDataClass::getList([
'select' => array(
'BANK_ID' => 'ID',
'BANK_XML_ID' => 'UF_XML_ID',
'BANK_NAME' => 'UF_NAME',
'BANK_SORT' => 'UF_SORT',
'PROGRAM_NAME' => 'ELEMENT.UF_NAME',
'PROGRAM_XML_ID' => 'ELEMENT.UF_XML_ID',
'PROGRAM_SORT' => 'ELEMENT.UF_SORT',
),
'runtime' => array(
'ELEMENT' => array(
'data_type' => $bankProgramDataClass,
'reference' => array(
'=this.ID' => 'ref.UF_LINK_BANK'
),
'join_type' => 'inner'
),
),
]);
dump($result->getTrackerQuery()->getTime());
dump($result->getTrackerQuery()->getSql());
while ($row = $result->fetch())
{
dump($row);
}
?>
<?require($_SERVER["DOCUMENT_ROOT"]."/bitrix/footer.php");?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment