Skip to content

Instantly share code, notes, and snippets.

@chebanenko
Created December 16, 2015 07:07
Show Gist options
  • Save chebanenko/9674806954bbce3a70cc to your computer and use it in GitHub Desktop.
Save chebanenko/9674806954bbce3a70cc to your computer and use it in GitHub Desktop.
<?
require($_SERVER["DOCUMENT_ROOT"]."/bitrix/header.php");
$APPLICATION->SetTitle("Новая страница");
?>
<?
Bitrix\Main\Loader::includeModule('citrus.priceagregators');
$result = \Citrus\PriceAgregators\LinkProductTable::getList([
'select' => [
'ID',
'IBLOCK_ELEMENT_ID',
'IBLOCK_ELEMENT_DATA.NAME',
'IBLOCK_ELEMENT_DATA.MODIFIED_BY',
'IBLOCK_ELEMENT_DATA.IBLOCK.NAME',
'CATALOG_PRICE_2',
],
'filter' => [
'=IBLOCK_ELEMENT_ID' => 7026,
],
'runtime' => [
'CATALOG_PRICE_2' => [
'data_type' => 'float',
'expression' => array(
'(SELECT b_catalog_price.PRICE FROM b_catalog_price
LEFT JOIN b_catalog_group ON b_catalog_group.ID = b_catalog_price.CATALOG_GROUP_ID
WHERE
b_catalog_price.PRODUCT_ID = %s
AND
b_catalog_group.NAME = \'EXCHANGE\'
AND
( b_catalog_price.quantity_from <= 1 OR b_catalog_price.quantity_from IS NULL )
AND
( b_catalog_price.quantity_to >= 1 OR b_catalog_price.quantity_to IS NULL))', 'IBLOCK_ELEMENT_ID'
)
]
]
])->fetchAll();
dump($result);
?>
<?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