Esempio n. 1
0
 public static function checkQuantity($ID, $productFields)
 {
     $checkNeed = isset($productFields['QUANTITY']) || isset($productFields['QUANTITY_TRACE']) || isset($productFields['CAN_BUY_ZERO']);
     if (!$checkNeed) {
         return;
     }
     $productIterator = ProductTable::getList(array('filter' => array('=ID' => $ID), 'select' => array('QUANTITY', 'QUANTITY_TRACE', 'CAN_BUY_ZERO')));
     $product = $productIterator->fetch();
     if ($product) {
         if ($product["QUANTITY_TRACE"] == "Y" && $product['CAN_BUY_ZERO'] == 'N') {
             $linkIterator = LinkTable::getList(array("filter" => array("=LINK_TYPE" => LinkTable::TYPE_IBLOCK_ELEMENT, "=LINK_ID" => $ID, array(array("=BANNER.AUTO_QUANTITY_OFF" => YandexBannerTable::ACTIVE), array("=BANNER.AUTO_QUANTITY_ON" => YandexBannerTable::ACTIVE), 'LOGIC' => "OR")), "select" => array("BANNER_ID", "AUTO_QUANTITY_ON" => "BANNER.AUTO_QUANTITY_ON", "AUTO_QUANTITY_OFF" => "BANNER.AUTO_QUANTITY_OFF")));
             $zeroQuantity = $product['QUANTITY'] <= 0;
             $linkIdMark = array();
             $linkIdUnMark = array();
             while ($link = $linkIterator->fetch()) {
                 $linkIdMark[] = $link["BANNER_ID"];
                 if ($zeroQuantity && $link["AUTO_QUANTITY_ON"] == YandexBannerTable::MARKED || !$zeroQuantity && $link["AUTO_QUANTITY_OFF"] == YandexBannerTable::MARKED) {
                     $linkIdUnMark[] = $link["BANNER_ID"];
                 }
             }
             if (count($linkIdMark) > 0) {
                 if ($zeroQuantity) {
                     YandexBannerTable::markStopped($linkIdMark);
                 } else {
                     YandexBannerTable::markResumed($linkIdMark);
                 }
                 if (count($linkIdUnMark) > 0) {
                     if ($zeroQuantity) {
                         YandexBannerTable::unMarkResumed($linkIdUnMark);
                     } else {
                         YandexBannerTable::unMarkStopped($linkIdUnMark);
                     }
                 }
             }
         }
     }
 }
Esempio n. 2
0
 /**
  * Returns product data.
  *
  * @param array &$productData			Product data.
  * @param array $entityData				Entity data.
  * @param array $iblockData				Iblock list data.
  * @return void
  */
 protected static function getProductData(&$productData, $entityData, $iblockData)
 {
     if (!empty($iblockData['iblockElement'])) {
         $productList = array_keys($productData);
         if (!empty($entityData['iblockFields'])) {
             $elementIterator = Iblock\ElementTable::getList(array('select' => array_merge(array('ID'), array_keys($entityData['iblockFields'])), 'filter' => array('@ID' => $productList)));
             while ($element = $elementIterator->fetch()) {
                 $element['ID'] = (int) $element['ID'];
                 $fields = array();
                 foreach ($entityData['iblockFields'] as $key => $alias) {
                     $fields[$alias] = $element[$key];
                 }
                 unset($key, $alias);
                 $productData[$element['ID']] = empty($productData[$element['ID']]) ? $fields : array_merge($productData[$element['ID']], $fields);
                 unset($fields);
             }
         }
         if ($entityData['sections']) {
             $productSection = array_fill_keys($productList, array());
             $elementSectionIterator = Iblock\SectionElementTable::getList(array('select' => array('*'), 'filter' => array('@IBLOCK_ELEMENT_ID' => $productList)));
             while ($elementSection = $elementSectionIterator->fetch()) {
                 $elementSection['IBLOCK_ELEMENT_ID'] = (int) $elementSection['IBLOCK_ELEMENT_ID'];
                 $elementSection['IBLOCK_SECTION_ID'] = (int) $elementSection['IBLOCK_SECTION_ID'];
                 $elementSection['ADDITIONAL_PROPERTY_ID'] = (int) $elementSection['ADDITIONAL_PROPERTY_ID'];
                 if ($elementSection['ADDITIONAL_PROPERTY_ID'] > 0) {
                     continue;
                 }
                 $productSection[$elementSection['IBLOCK_ELEMENT_ID']][$elementSection['IBLOCK_SECTION_ID']] = true;
                 $parentSectionIterator = \CIBlockSection::getNavChain(0, $elementSection['IBLOCK_SECTION_ID'], array('ID'));
                 while ($parentSection = $parentSectionIterator->fetch()) {
                     $parentSection['ID'] = (int) $parentSection['ID'];
                     $productSection[$elementSection['IBLOCK_ELEMENT_ID']][$parentSection['ID']] = true;
                 }
                 unset($parentSection, $parentSectionIterator);
             }
             unset($elementSection, $elementSectionIterator);
             foreach ($productSection as $element => $sections) {
                 $productData[$element]['SECTION_ID'] = array_keys($sections);
             }
             unset($element, $sections, $productSection);
         }
         if (!empty($entityData['needProperties'])) {
             $propertyValues = array_fill_keys($productList, array());
             foreach ($entityData['needProperties'] as $iblock => $propertyList) {
                 if (empty($iblockData['iblockElement'][$iblock])) {
                     continue;
                 }
                 $filter = array('ID' => $iblockData['iblockElement'][$iblock], 'IBLOCK_ID' => $iblock);
                 \CTimeZone::disable();
                 \CIBlockElement::getPropertyValuesArray($propertyValues, $iblock, $filter, array('ID' => $propertyList));
                 \CTimeZone::enable();
             }
             unset($filter, $iblock, $propertyList);
             self::convertProperties($productData, $propertyValues, $entityData, $iblockData);
         }
         if (!empty($entityData['catalogFields'])) {
             $productIterator = Catalog\ProductTable::getList(array('select' => array_merge(array('ID'), array_keys($entityData['catalogFields'])), 'filter' => array('@ID' => $productList)));
             while ($product = $productIterator->fetch()) {
                 $product['ID'] = (int) $product['ID'];
                 $fields = array();
                 foreach ($entityData['catalogFields'] as $key => $alias) {
                     $fields[$alias] = $product[$key];
                 }
                 unset($key, $alias);
                 $productData[$product['ID']] = empty($productData[$product['ID']]) ? $fields : array_merge($productData[$product['ID']], $fields);
                 unset($fields);
             }
             unset($product, $productIterator);
         }
         if (!empty($iblockData['skuIblockList'])) {
             self::getParentProducts($productData, $entityData, $iblockData);
         }
     }
 }
Esempio n. 3
0
 public function Delete($ID)
 {
     global $DB;
     $ID = (int) $ID;
     if ($ID <= 0) {
         return false;
     }
     $DB->Query('delete from b_catalog_price where PRODUCT_ID = ' . $ID, true);
     $DB->Query('delete from b_catalog_product2group where PRODUCT_ID = ' . $ID, true);
     $DB->Query('delete from b_catalog_product_sets where ITEM_ID = ' . $ID . ' or OWNER_ID = ' . $ID, true);
     $DB->Query('delete from b_catalog_measure_ratio where PRODUCT_ID = ' . $ID, true);
     Catalog\ProductTable::clearProductCache($ID);
     if (isset(self::$arProductCache[$ID])) {
         unset(self::$arProductCache[$ID]);
         if (defined('CATALOG_GLOBAL_VARS') && CATALOG_GLOBAL_VARS == 'Y') {
             /** @var array $CATALOG_PRODUCT_CACHE */
             global $CATALOG_PRODUCT_CACHE;
             $CATALOG_PRODUCT_CACHE = self::$arProductCache;
         }
     }
     return $DB->Query("delete from b_catalog_product where ID = " . $ID, true);
 }
Esempio n. 4
0
 $countSetDefaultItems = 0;
 $select = array('ID', 'NAME', 'CODE', 'IBLOCK_ID', 'IBLOCK_SECTION_ID', 'DETAIL_PAGE_URL', 'PREVIEW_PICTURE', 'DETAIL_PICTURE', 'PREVIEW_TEXT', 'CATALOG_AVAILABLE', 'CATALOG_MEASURE');
 $arResult["PRICES"] = CIBlockPriceTools::GetCatalogPrices($arResult['PRODUCT_IBLOCK_ID'], $arParams["PRICE_CODE"]);
 foreach ($arResult["PRICES"] as $key => $value) {
     if (!$value['CAN_VIEW'] && !$value['CAN_BUY']) {
         continue;
     }
     $select[] = $value["SELECT"];
 }
 $arResult["SET_ITEMS"]["DEFAULT"] = array();
 $arResult["SET_ITEMS"]["OTHER"] = array();
 $arResult["SET_ITEMS"]["PRICE"] = 0;
 $arResult["SET_ITEMS"]["OLD_PRICE"] = 0;
 $arResult["SET_ITEMS"]["PRICE_DISCOUNT_DIFFERENCE"] = 0;
 $arResult['ITEMS_RATIO'] = array_fill_keys($arSetItemsID, 1);
 $ratioResult = Catalog\ProductTable::getCurrentRatioWithMeasure($arSetItemsID);
 foreach ($ratioResult as $ratioProduct => $ratioData) {
     $arResult['ITEMS_RATIO'][$ratioProduct] = $ratioData['RATIO'];
 }
 unset($ratioProduct, $ratioData);
 $tagIblockList = array();
 $tagIblockList[$arResult['PRODUCT_IBLOCK_ID']] = $arResult['PRODUCT_IBLOCK_ID'];
 $tagIblockList[$arResult['ELEMENT_IBLOCK_ID']] = $arResult['ELEMENT_IBLOCK_ID'];
 $tagCurrencyList = array();
 $found = false;
 $itemsIterator = CIBlockElement::GetList(array(), array('ID' => $arSetItemsID), false, false, $select);
 while ($item = $itemsIterator->GetNext()) {
     $found = true;
     $item['ID'] = (int) $item['ID'];
     $item['IBLOCK_ID'] = (int) $item['IBLOCK_ID'];
     $tagIblockList[$item['IBLOCK_ID']] = $item['IBLOCK_ID'];
Esempio n. 5
0
 /**
  * @param  \CDBResult $dbResultList
  * @return array
  */
 protected function makeItemsFromDbResult(\CDBResult $dbResultList)
 {
     $arItemsResult = $arProductIds = array();
     while ($arItem = $dbResultList->Fetch()) {
         if ($arItem['TYPE'] != 'S') {
             $arProductIds[] = $arItem['ID'];
             $arItem['PROPERTIES'] = $this->getItemProperies($arItem['ID']);
             $arItemsResult[$arItem['ID']] = $arItem;
         } else {
             $arItemsResult['S' . $arItem['ID']] = $arItem;
         }
     }
     if (!empty($arProductIds)) {
         $dbCatalogProduct = \CCatalogProduct::GetList(array(), array('@ID' => $arProductIds));
         while ($arCatalogProduct = $dbCatalogProduct->fetch()) {
             $arItemsResult[$arCatalogProduct['ID']]['PRODUCT'] = $arCatalogProduct;
         }
         $offersExistsIds = \CCatalogSKU::getExistOffers($arProductIds, $this->getIblockId());
         $noOffersIds = array();
         if (empty($offersExistsIds)) {
             $noOffersIds = $arProductIds;
         } else {
             $this->loadAllSku(array_keys(array_filter($offersExistsIds)));
             foreach ($offersExistsIds as $id => $bExists) {
                 $arItem =& $arItemsResult[$id];
                 if ($bExists) {
                     $arItem['SKU_ITEMS'] = $this->getProductSku($arItem);
                 } else {
                     $noOffersIds[] = $id;
                 }
             }
             unset($id, $bExists);
         }
         if (!empty($noOffersIds)) {
             $productRatioList = Catalog\ProductTable::getCurrentRatioWithMeasure($noOffersIds);
             if (!empty($productRatioList)) {
                 foreach ($productRatioList as $productId => $productRatio) {
                     if (!isset($arItemsResult[$productId]['PRODUCT'])) {
                         continue;
                     }
                     $arItemsResult[$productId]['PRODUCT']['MEASURE_RATIO'] = $productRatio['RATIO'];
                     $arItemsResult[$productId]['PRODUCT']['MEASURE'] = $productRatio['MEASURE'];
                 }
                 unset($productRatio, $productId);
             }
             unset($productRatioList);
             $priceIds = $this->getVisiblePrices();
             foreach ($priceIds as $priceId) {
                 $dbPrice = \CPrice::GetListEx(array(), array('PRODUCT_ID' => $noOffersIds, 'CATALOG_GROUP_ID' => $priceId), false, false, array('PRODUCT_ID', 'PRICE', 'CURRENCY', 'QUANTITY_FROM', 'QUANTITY_TO'));
                 while ($arPrice = $dbPrice->fetch()) {
                     $arPrice['QUANTITY_FROM'] = (int) $arPrice['QUANTITY_FROM'];
                     $arPrice['QUANTITY_TO'] = (int) $arPrice['QUANTITY_TO'];
                     if (!isset($arItemsResult[$arPrice["PRODUCT_ID"]]['PRICES'][$priceId]) || $arItemsResult[$arPrice["PRODUCT_ID"]]['PRICES'][$priceId]['QUANTITY_FROM'] > $arPrice['QUANTITY_FROM']) {
                         $arItemsResult[$arPrice["PRODUCT_ID"]]['PRICES'][$priceId] = array('PRICE' => $arPrice['PRICE'], 'CURRENCY' => $arPrice['CURRENCY'], 'QUANTITY_FROM' => $arPrice['QUANTITY_FROM'], 'QUANTITY_TO' => $arPrice['QUANTITY_TO']);
                     }
                 }
                 unset($arPrice, $dbPrice);
             }
             if ($this->getStoreId()) {
                 $dbStoreProduct = \CCatalogStoreProduct::GetList(array(), array("PRODUCT_ID" => $noOffersIds, "STORE_ID" => $this->getStoreId()));
                 while ($arStoreProduct = $dbStoreProduct->Fetch()) {
                     $arItemsResult[$arStoreProduct["PRODUCT_ID"]]['PRODUCT']['STORE_AMOUNT'] = $arStoreProduct["AMOUNT"];
                 }
             }
             $groupsIterator = CCatalogProductSet::getList(array(), array('OWNER_ID' => $noOffersIds, 'SET_ID' => 0, 'TYPE' => \CCatalogProductSet::TYPE_GROUP), false, false, array('ID', 'OWNER_ID', 'ITEM_ID', 'SET_ID', 'TYPE'));
             while ($group = $groupsIterator->Fetch()) {
                 if ($group['OWNER_ID'] == $group['ITEM_ID']) {
                     $arItemsResult[$group['OWNER_ID']]['PRODUCT']['IS_GROUP'] = true;
                 }
             }
         }
     }
     return $arItemsResult;
 }
Esempio n. 6
0
 /**
  * <p>Метод проверяет наличие записи в таблице <i>b_catalog_product</i> с информацией (доступное количество, разрешена ли покупка при отсутствии товара и т.д.) для товара с кодом <i>intID</i>. Метод статический.</p>
  *
  *
  * @param int $intID  Код товара.
  *
  * @return bool <p> В случае наличия информации о товаре возвращает true, иначе -
  * false.</p> <br><br>
  *
  * @static
  * @link http://dev.1c-bitrix.ru/api_help/catalog/classes/ccatalogproduct/isexistproduct.php
  * @author Bitrix
  * @deprecated deprecated since catalog 15.5.2  ->  \Bitrix\Catalog\ProductTable::isExistProduct()
  */
 public static function IsExistProduct($intID)
 {
     return Catalog\ProductTable::isExistProduct($intID);
 }
Esempio n. 7
0
 public static function getItemsInfo(&$arSets)
 {
     $itemList = array();
     $itemIds = array();
     if (empty($arSets) || !is_array($arSets)) {
         return;
     }
     foreach ($arSets as $key => $arOneSet) {
         foreach ($arOneSet['ITEMS'] as $keyItem => $arItem) {
             if ('' == $arItem['ITEM_ID']) {
                 continue;
             }
             $intItemID = (int) $arItem['ITEM_ID'];
             if (0 >= $intItemID) {
                 continue;
             }
             if (!isset($itemList[$intItemID])) {
                 $itemList[$intItemID] = array();
                 $itemIds[] = $intItemID;
             }
             $itemList[$intItemID][] =& $arSets[$key]['ITEMS'][$keyItem];
         }
     }
     if (!empty($itemList)) {
         $productIterator = Iblock\ElementTable::getList(array('select' => array('ID', 'NAME'), 'filter' => array('@ID' => $itemIds)));
         while ($product = $productIterator->fetch()) {
             $product['ID'] = (int) $product['ID'];
             if (!isset($itemList[$product['ID']])) {
                 continue;
             }
             foreach ($itemList[$product['ID']] as &$setItem) {
                 $setItem['ITEM_NAME'] = $product['NAME'];
             }
             unset($setItem);
         }
         unset($product, $productIterator);
         $productRatio = Catalog\ProductTable::getCurrentRatioWithMeasure($itemIds);
         if (!empty($productRatio)) {
             foreach ($productRatio as $productId => $productData) {
                 if (!isset($itemList[$productId])) {
                     continue;
                 }
                 foreach ($itemList[$productId] as &$setItem) {
                     $setItem['RATIO'] = $productData['RATIO'];
                     $setItem['MEASURE'] = $productData['MEASURE'];
                 }
                 unset($setItem);
             }
             unset($productId, $productData);
         }
         unset($productRatio);
     }
     unset($itemIds, $itemList);
 }