Created
December 16, 2015 07:07
-
-
Save chebanenko/9674806954bbce3a70cc to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<? | |
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