Битрикс: минимальная и максимальная цена торгового предложения

Часто бывает нужно произвести сортировку по цене в каталоге, в котором присутствуют и обычные товары и торговые предложения. Стандартными средствами это не получается так-как у ТП цена фиксированная, а больше похожа на сегмент в котором цена товара зависит от каких-либо свойств в варьируется от и до…

Ну что же, исправляем:

Добавляем в init.php нижеприведенный код для автоматизации заполнения минимальной и максимальной цены в свойства товара.
В товар и торговые предложения будут добавлены два свойства (PROPERTY_)MINIMUM_PRICE и (PROPERTY_)MAXIMUM_PRICE в которые скрипт занесет значения минимальной и максимальной цены.
В карточке торговых предложений можно будет выводить “цена от” равную свойству MINIMUM_PRICE и “цена до” равную свойству MAXIMUM_PRICE 🙂

AddEventHandler("iblock", "OnAfterIBlockElementUpdate", "DoIBlockAfterSave");
AddEventHandler("iblock", "OnAfterIBlockElementAdd", "DoIBlockAfterSave");
AddEventHandler("catalog", "OnPriceAdd", "DoIBlockAfterSave");
AddEventHandler("catalog", "OnPriceUpdate", "DoIBlockAfterSave");
function DoIBlockAfterSave($arg1, $arg2 = false)
{
 $ELEMENT_ID = false;
 $IBLOCK_ID = false;
 $OFFERS_IBLOCK_ID = false;
 $OFFERS_PROPERTY_ID = false;
 if (CModule::IncludeModule('currency'))
 $strDefaultCurrency = CCurrency::GetBaseCurrency();

 //Check for catalog event
 if(is_array($arg2) && $arg2["PRODUCT_ID"] > 0)
 {
 //Get iblock element
 $rsPriceElement = CIBlockElement::GetList(
 array(),
 array(
 "ID" => $arg2["PRODUCT_ID"],
 ),
 false,
 false,
 array("ID", "IBLOCK_ID")
 );
 if($arPriceElement = $rsPriceElement->Fetch())
 {
 $arCatalog = CCatalog::GetByID($arPriceElement["IBLOCK_ID"]);
 if(is_array($arCatalog))
 {
 //Check if it is offers iblock
 if($arCatalog["OFFERS"] == "Y")
 {
 //Find product element
 $rsElement = CIBlockElement::GetProperty(
 $arPriceElement["IBLOCK_ID"],
 $arPriceElement["ID"],
 "sort",
 "asc",
 array("ID" => $arCatalog["SKU_PROPERTY_ID"])
 );
 $arElement = $rsElement->Fetch();
 if($arElement && $arElement["VALUE"] > 0)
 {
 $ELEMENT_ID = $arElement["VALUE"];
 $IBLOCK_ID = $arCatalog["PRODUCT_IBLOCK_ID"];
 $OFFERS_IBLOCK_ID = $arCatalog["IBLOCK_ID"];
 $OFFERS_PROPERTY_ID = $arCatalog["SKU_PROPERTY_ID"];
 }
 }
 //or iblock which has offers
 elseif($arCatalog["OFFERS_IBLOCK_ID"] > 0)
 {
 $ELEMENT_ID = $arPriceElement["ID"];
 $IBLOCK_ID = $arPriceElement["IBLOCK_ID"];
 $OFFERS_IBLOCK_ID = $arCatalog["OFFERS_IBLOCK_ID"];
 $OFFERS_PROPERTY_ID = $arCatalog["OFFERS_PROPERTY_ID"];
 }
 //or it's regular catalog
 else
 {
 $ELEMENT_ID = $arPriceElement["ID"];
 $IBLOCK_ID = $arPriceElement["IBLOCK_ID"];
 $OFFERS_IBLOCK_ID = false;
 $OFFERS_PROPERTY_ID = false;
 }
 }
 }
 }
 //Check for iblock event
 elseif(is_array($arg1) && $arg1["ID"] > 0 && $arg1["IBLOCK_ID"] > 0)
 {
 //Check if iblock has offers
 $arOffers = CIBlockPriceTools::GetOffersIBlock($arg1["IBLOCK_ID"]);
 if(is_array($arOffers))
 {
 $ELEMENT_ID = $arg1["ID"];
 $IBLOCK_ID = $arg1["IBLOCK_ID"];
 $OFFERS_IBLOCK_ID = $arOffers["OFFERS_IBLOCK_ID"];
 $OFFERS_PROPERTY_ID = $arOffers["OFFERS_PROPERTY_ID"];
 }
 }

 if($ELEMENT_ID)
 {
 static $arPropCache = array();
 if(!array_key_exists($IBLOCK_ID, $arPropCache))
 {
 //Check for MINIMAL_PRICE property
 $rsProperty = CIBlockProperty::GetByID("MINIMUM_PRICE", $IBLOCK_ID);
 $arProperty = $rsProperty->Fetch();
 if($arProperty)
 $arPropCache[$IBLOCK_ID] = $arProperty["ID"];
 else
 $arPropCache[$IBLOCK_ID] = false;
 }

 if($arPropCache[$IBLOCK_ID])
 {
 //Compose elements filter
 if($OFFERS_IBLOCK_ID)
 {
 $rsOffers = CIBlockElement::GetList(
 array(),
 array(
 "IBLOCK_ID" => $OFFERS_IBLOCK_ID,
 "PROPERTY_".$OFFERS_PROPERTY_ID => $ELEMENT_ID,
 ),
 false,
 false,
 array("ID")
 );
 while($arOffer = $rsOffers->Fetch())
 $arProductID[] = $arOffer["ID"];

 if (!is_array($arProductID))
 $arProductID = array($ELEMENT_ID);
 }
 else
 $arProductID = array($ELEMENT_ID);

 $minPrice = false;
 $maxPrice = false;
 //Get prices
 $rsPrices = CPrice::GetList(
 array(),
 array(
 "PRODUCT_ID" => $arProductID,
 )
 );
 while($arPrice = $rsPrices->Fetch())
 {
 if (CModule::IncludeModule('currency') && $strDefaultCurrency != $arPrice['CURRENCY'])
 $arPrice["PRICE"] = CCurrencyRates::ConvertCurrency($arPrice["PRICE"], $arPrice["CURRENCY"], $strDefaultCurrency);

 $PRICE = $arPrice["PRICE"];

 if($minPrice === false || $minPrice > $PRICE)
 $minPrice = $PRICE;

 if($maxPrice === false || $maxPrice < $PRICE)
 $maxPrice = $PRICE;
 }

 //Save found minimal price into property
 if($minPrice !== false)
 {
 CIBlockElement::SetPropertyValuesEx(
 $ELEMENT_ID,
 $IBLOCK_ID,
 array(
 "MINIMUM_PRICE" => $minPrice,
 "MAXIMUM_PRICE" => $maxPrice,
 )
 );
 }
 }
 }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

AddEventHandler("iblock", "OnAfterIBlockElementUpdate", "DoIBlockAfterSave");

AddEventHandler("iblock", "OnAfterIBlockElementAdd", "DoIBlockAfterSave");

AddEventHandler("catalog", "OnPriceAdd", "DoIBlockAfterSave");

AddEventHandler("catalog", "OnPriceUpdate", "DoIBlockAfterSave");

function DoIBlockAfterSave($arg1, $arg2 = false)

{

$ELEMENT_ID = false;

$IBLOCK_ID = false;

$OFFERS_IBLOCK_ID = false;

$OFFERS_PROPERTY_ID = false;

if (CModule::IncludeModule('currency'))

$strDefaultCurrency = CCurrency::GetBaseCurrency();

//Check for catalog event

if(is_array($arg2) && $arg2["PRODUCT_ID"] > 0)

{

//Get iblock element

$rsPriceElement = CIBlockElement::GetList(

array(),

array(

"ID" => $arg2["PRODUCT_ID"],

false,

array("ID", "IBLOCK_ID")

);

if($arPriceElement = $rsPriceElement->Fetch())

{

$arCatalog = CCatalog::GetByID($arPriceElement["IBLOCK_ID"]);

if(is_array($arCatalog))

{

//Check if it is offers iblock

if($arCatalog["OFFERS"] == "Y")

{

//Find product element

$rsElement = CIBlockElement::GetProperty(

$arPriceElement["IBLOCK_ID"],

$arPriceElement["ID"],

"sort",

"asc",

array("ID" => $arCatalog["SKU_PROPERTY_ID"])

);

$arElement = $rsElement->Fetch();

if($arElement && $arElement["VALUE"] > 0)

{

$ELEMENT_ID = $arElement["VALUE"];

$IBLOCK_ID = $arCatalog["PRODUCT_IBLOCK_ID"];

$OFFERS_IBLOCK_ID = $arCatalog["IBLOCK_ID"];

$OFFERS_PROPERTY_ID = $arCatalog["SKU_PROPERTY_ID"];

}

//or iblock which has offers

elseif($arCatalog["OFFERS_IBLOCK_ID"] > 0)

{

$ELEMENT_ID = $arPriceElement["ID"];

$IBLOCK_ID = $arPriceElement["IBLOCK_ID"];

$OFFERS_IBLOCK_ID = $arCatalog["OFFERS_IBLOCK_ID"];

$OFFERS_PROPERTY_ID = $arCatalog["OFFERS_PROPERTY_ID"];

}

//or it's regular catalog

else

{

$ELEMENT_ID = $arPriceElement["ID"];

$IBLOCK_ID = $arPriceElement["IBLOCK_ID"];

$OFFERS_IBLOCK_ID = false;

$OFFERS_PROPERTY_ID = false;

}

//Check for iblock event

elseif(is_array($arg1) && $arg1["ID"] > 0 && $arg1["IBLOCK_ID"] > 0)

{

//Check if iblock has offers

$arOffers = CIBlockPriceTools::GetOffersIBlock($arg1["IBLOCK_ID"]);

if(is_array($arOffers))

{

$ELEMENT_ID = $arg1["ID"];

$IBLOCK_ID = $arg1["IBLOCK_ID"];

$OFFERS_IBLOCK_ID = $arOffers["OFFERS_IBLOCK_ID"];

$OFFERS_PROPERTY_ID = $arOffers["OFFERS_PROPERTY_ID"];

}

if($ELEMENT_ID)

{

static $arPropCache = array();

if(!array_key_exists($IBLOCK_ID, $arPropCache))

{

//Check for MINIMAL_PRICE property

$rsProperty = CIBlockProperty::GetByID("MINIMUM_PRICE", $IBLOCK_ID);

$arProperty = $rsProperty->Fetch();

if($arProperty)

$arPropCache[$IBLOCK_ID] = $arProperty["ID"];

else

$arPropCache[$IBLOCK_ID] = false;

}

if($arPropCache[$IBLOCK_ID])

{

//Compose elements filter

if($OFFERS_IBLOCK_ID)

{

$rsOffers = CIBlockElement::GetList(

array(),

array(

"IBLOCK_ID" => $OFFERS_IBLOCK_ID,

"PROPERTY_".$OFFERS_PROPERTY_ID => $ELEMENT_ID,

false,

array("ID")

);

while($arOffer = $rsOffers->Fetch())

$arProductID[] = $arOffer["ID"];

if (!is_array($arProductID))

$arProductID = array($ELEMENT_ID);

}

else

$arProductID = array($ELEMENT_ID);

$minPrice = false;

$maxPrice = false;

//Get prices

$rsPrices = CPrice::GetList(

array(),

array(

"PRODUCT_ID" => $arProductID,

)

);

while($arPrice = $rsPrices->Fetch())

{

if (CModule::IncludeModule('currency') && $strDefaultCurrency != $arPrice['CURRENCY'])

$arPrice["PRICE"] = CCurrencyRates::ConvertCurrency($arPrice["PRICE"], $arPrice["CURRENCY"], $strDefaultCurrency);

$PRICE = $arPrice["PRICE"];

if($minPrice === false || $minPrice > $PRICE)

$minPrice = $PRICE;

if($maxPrice === false || $maxPrice < $PRICE)

$maxPrice = $PRICE;

}

//Save found minimal price into property

if($minPrice !== false)

{

CIBlockElement::SetPropertyValuesEx(

$ELEMENT_ID,

$IBLOCK_ID,

array(

"MINIMUM_PRICE" => $minPrice,

"MAXIMUM_PRICE" => $maxPrice,

)

);

}

Далее можно будет производить общую сортировку по цене в разделе каталога (bitrix:catalog.section) простых товаров + торговых предложений.
Вставляем перед вызовом компонента (bitrix:catalog.section)

	$arParams["ELEMENT_SORT_FIELD"] = "PROPERTY_MINIMUM_PRICE";
	$arParams["ELEMENT_SORT_ORDER"] = "asc";
	if ($_GET["price"] == "min"){
        $arParams["ELEMENT_SORT_ORDER"] = "asc";
    }elseif($_GET["price"] == "max"){
        $arParams["ELEMENT_SORT_ORDER"] = "desc";
    }else{
		$arParams["ELEMENT_SORT_ORDER"] = "asc";
    }

$arParams["ELEMENT_SORT_FIELD"] = "PROPERTY_MINIMUM_PRICE";

$arParams["ELEMENT_SORT_ORDER"] = "asc";

if ($_GET["price"] == "min"){

$arParams["ELEMENT_SORT_ORDER"] = "asc";

}elseif($_GET["price"] == "max"){

$arParams["ELEMENT_SORT_ORDER"] = "desc";

}else{

$arParams["ELEMENT_SORT_ORDER"] = "asc";

}

1 комментарий к “Битрикс: минимальная и максимальная цена торгового предложения”

Cat
01.09.2020 в 02:40

Боже, ваш пост просто меня спас! спасибо!!

Ответить

Добавить комментарий для Cat Отменить ответ

Этот сайт использует Akismet для борьбы со спамом. Узнайте, как обрабатываются ваши данные комментариев.